Роман

Roman Lesiv
Senior ETL Developer
Summary

• More than 9 years of experience in Oracle PL/SQL development
• More than 2 years of experience in T-SQL development
• Experienced in SQL, PL/SQL, Dynamic SQL, Triggers, Packages, Procedures, Functions
• Self-motivated and responsible

Technical Skills

Skill Category
Skill list
Programming Languages
PL/SQL, SQL, VBA scripts
ERP/Reporting Systems
Oracle Enterprise Business Suite, Business Objects
Data bases
Oracle RDBMS (9i,10g,11g, 12c), Microsoft SQL server
Operating System
Windows (2000, XP, Vista, 7), DOS, Unix
Development Tools
Informatica 9.5.1,TOAD, PL/SQL Developer, SQL Plus, SQL Navigator PowerDesigner, DataStage 8.5 (11.5)
VCS
SVN
Methodologies
SCRUM
Other
MS Office, Service Desk, Putty, Control-M, Nexus, WinScp

Contact

• Mobile phone: [відкрити контакти](див. вище в блоці «контактна інформація»)
• Email: [відкрити контакти](див. вище в блоці «контактна інформація»)

Foreign Languages Skills

Language
Written
Spoken
Ukrainian
Native
Native
Russian
Native
Native
English
Intermediate
Intermediate

Summary of Work Experience

Name of Employer: Unitask Group, Ukraine
Dates of Employment:from May 2019– today
Job Title: BI Developer
Project Name: DWH building for leader of pharmacy market
Project description:
Role: BI Developer
Responsibilities and Key Accomplishments:
• Creating new jobs Datastage and maintenance
• ETL creation
• Bash scripting
• Optimization of queries and issue resolving
• Application testing
• Support users and preparing technical documents
• Direct communication with user and clarify requirements
Technologies:
• SQL Developer, Datastage, UC4, Putty, WinSCP

Name of Employer: Unity-Bars, Ukraine
Dates of Employment:from August 2017– April 1019
Job Title: PL/SQL Developer
Project Name: Support ABS system, Preparation new data to load into data warehouse
Project description: The software was specially developed to provide services to the customer’s of the bank. System architecture allows combine data from various systems in a single complex. This effectively reduces the time of customer service.
Role: PL/SQL Developer
Responsibilities and Key Accomplishments:
• Preparation and optimized data for download in the corporate data warehouse
• Create new database objects
• Optimization of queries
• Application testing
• Support users and preparing technical documents
Technologies:
• SQL Developer, Toad, Tortoise SVN

Name of Employer: Lifecell, Ukraine
Dates of Employment:from June 2016 – to July 2017
Job Title: System Administrator
Project Name:Migration MAXIMO7 system
Project description:The project was implemented in four stages and for every stage a subset of applications was selected, forming an application group. Each application group was migrated, switching the production from Maximo 5 to Maximo 7 for that group within one night.
Role: System Administrator
Responsibilities and Key Accomplishments:
• Support and optimization of changes process in DBMS according to needs
• Support and administration of network planning systems
• Analysis of DBMS system problems and initiation of requests for correction of these problems
• Monitoring the performance of control systems, setting up and checking backups
• Administering and installing server hardware management systems
• Ensuring accessibility Maximo5 and Maximo7 systems

Technologies:
• Putty, PL/SQL Developer, Tortoise SVN, Eclipse Neon, SQL Navigator

Name of Employer: Luxoft, Ukraine
Dates of Employment:from July 2015 – to May 2016
Job Title: Oracle ETL developer

Project Name:Client on boarding
Project description:Enterprise wide system for top tier investment bank serving as golden source of information about Clients.
Functions are landing, processing, storing, and distribution of information. Channels are UI, Web services, Files, JMS.

Role: Oracle ETL developer
Responsibilities and Key Accomplishments:
• Create workflows, Unix scripts using Informatica 9.5.1
• Create objects and PL/SQL Units into Oracle Database
• Communication and support with clients, QA testing, users
• Support and development to available system
• Preparing documents and instructions
• Raise requests using dbPassoprt, DBSymphony, db-AP, DBUnity

Technologies:
• Putty, PL/SQL Developer, Nexus, Udeploy, Tortoise SVN, Informatica 9.5.1

Name of Employer: Universal Bank, Ukraine
Dates of Employment:from January 2013 – to July 2015
Job Title: Oracle developer/ ETL developer

Project Name:Universal Bank
Project description:Implementing and maintaining software,creation ETL proceses within agreed standards in order to meet business requirements. Project involves working closely with buisness users

Role: Oracle developer / ETL developer
Responsibilities and Key Accomplishments:
• Developed stored procedures, functions and packages on PL/SQLfor OracleDatabase
• SQL and PL/SQL tuning
• Designed database architecture
• Created analytical reports on Business Objects
• Data migration between and support ETL process
• Support users and preparing technical documents

Technologies:
• Oracle RDBMS 11g , Sybase PowerDesigner, Financial Reporting, Microsoft SQL server, BI (Business Objects), PL/SQL Developer, TOAD, Tortoise SVN

Name of Employer: Miratech, Ukraine
Dates of Employment:from December 2011 – to December 2012
Job Title: Oracle developer

Project Name:Oracle E Business Suite
Project description:Project activities cover building of solution based on OEBS tools.This includes maintenance and functional support , User Interface and mapping to other external/internal components ,customs applications and configurations

Role: Software Developer, Support Engineer
Responsibilities and Key Accomplishments:
• Developed PL/SQL programs for business needs
• Optimized database performance (PL/SQL and SQL statements tuning)
• Supported approx. 1000 users, Level 3 support
• Documented test cases, functional and technical requirements, user manuals
• Application testing
• Setup and customization of Oracle FixedAssets
• Configuration of OEBS Modules Fixed Assets General Ledger regarding to business requirements
• Data migration from internal system , data preparation
• Information and advice on technical issues, training of users
• Support and bug fixing

Technologies:
• Oracle RDBMS 9i, 11g, Oracle Applications 11i, PL/SQL Developer, TOAD, Tortoise SVN, Service Desk, Windows XP

Certifications/Courses

Date:2011
Course:Oracle Database 10g: SQL Fundamentals
Date:2011
Course:Oracle Database 10g: PL/SQL Fundamentals
Date:2015
Certificate:Informatica PowerCenter 8.6 Developer Level (1 and 2)
Date:2015
Certificate:Effective Interpersonal Communication for IT Project
Team
Date:2016
Certificate:Oracle 11g, Performance Tuning of SQL Statements

Academic Record

Dates of studying:2006– 2011
Name of institution:National Technical University of Food Technologies
Ukraine, Kiev
Department:Technical Mechanics and Packaging Machinery
Qualification:Master Degree