Контактна інформація

Шукач вказав телефон та ел. пошту.

Отримати контакти цього кандидата можна на сторінці https://www.work.ua/resumes/3500681

Досвід роботи

Senior Oracle Developer

з 07.2017 по нині (6 років 10 місяців)
Luxoft, Киев (Luxoft – ведущий поставщик услуг в области разработки программного обеспечения и инновационных ИТ-решений)

Responsibilities:

Worked closely with Business Analysts and was involved in design and implementation of the ETL processes (Informatica mappings and SQL, PL/SQL) to load data into Data warehouse.
Maintaining an ETL services along with the customer.
Effectively Coordinate and discuss with the Users, Business Intelligence Leader, and the Process leads to clarify their requirements and gather additional information regarding the request to be developed.
Involved in the design of conversion mappings for ETL.
Developed mappings and involved in unit and integration testing of workflows.
Involved in the enhancement of ETL mappings.
Tuned the mappings to minimize the load time and reduced usage of system resources.
Creating weekly status and monthly status reports and metrics.
Actively involved in providing production support and debugging/ resolving ETL issues.
Interaction with offshore team to get the daily status and prioritize the ETL tasks.
Working with subject matter experts to understand the system, identify the risks and providing suggestions.
Involved in Data Conversion from the Source based on the Business rules.
Scheduling of workflows using Informatica workflow manager and other schedulers –Control M.
Involved in developing ETL best practices and followed the best practices.
Involved in developing the structured ETL code review process and checklist.
Implemented automated batch monitoring tool to study the trend of job runs, failures and proactive/predictive
alerts.

Deputy Head of Departmentdownloading and processing of data

з 10.2016 по 07.2017 (9 місяців)
OSCHADBANK, Киев (Finance, banking, and insurance)

• Analyze source data/file structures, technical metadata, profile source data and develop data mapping andtransformation rules and detail ETL specifications based on business requirements.
• Assist in the collection of technical metadata supporting the implementation.
• Design, code, test, and debug ETL application data flow plans to populated databases.
• Performance tune the ETL application and coordinate with DBA for DB performance enhancement on to meet operational production requirements.
• Develop and execute, in conjunction with the ETL Architect, Quality and Release, and Process Analyst system
and integration test plans.
• Written PL/SQL stored procedure for managing the partitions on temporal tables.
• Effectively implemented Partitioning and Parallelism techniques to fully utilize the resources and enhance job performance.
• Implement the change data capture procedures.
• Extensively worked with database objects including tables, views, indexes, schemas, PL/SQL packages,
stored procedures, functions, and triggers.
• Implement audit mechanism, balance and controls using strong SQL scripting per business
requirements.
• Configured the XML Input stage, XML Output stage and Transformer Stage for extracting, transforming and writing.
• Perform data analysis, profiling and reconciliation using complex SQL and PL/SQL queries.
• Design and code functions of the application in accordance with the ETL standards and architectural
guidelines.
• Writing the reporting in web intelligence in Business Objects.
• Execute test plans and document results and discrepancies.
• Designed Error handling process and generated Error reports to be sent as email whenever a job was
aborted.
• Prepare applicable ETL application supporting documentation.
• Assist in researching and resolving data issues uncovered during development and testing.
• Involved in Production document design, transition and supported Production for initial period.

Senior Orale Developer

з 10.2014 по 04.2016 (1 рік 6 місяців)
Luxoft, Киев (Luxoft – ведущий поставщик услуг в области разработки программного обеспечения и инновационных ИТ-решений)

Responsibilities:

• Work with external vendors and internal business and technology staff to accurately gather and interpret requirements, specifications, and database models to determine appropriate ETL development solutions
• Develop ETL technical specifications and recommends, designs, develops, tests, implements, and supports innovative and optimal data solutions
• Work with the Data Services and Business Intelligence team to design, implement, and support end-to-end data solutions across multiple platforms, environments, domains, and locations
• Integrated ETL development with existing codebase to maximize object reuse
• Create, execute, and documents unit test plans for ETL and data integration processes and programs
• Document ETL processes, programs and solutions as per established standards
• Performs tasks required to conform to the company's configuration management and software release processes
• Work with internal team, vendors, consultants, and external partners to quickly identify and resolve data integration and ETL job issues
• Assess and document the structure, quality, and compliance of source data and coordinate with business and technology teams to identify and resolve issues

Senior Orale Developer

з 01.2013 по 10.2014 (1 рік 9 місяців)
TASKOMBANK, Киев (TASKOMBANK is a universal commercial bank. TASKOMBANK provides a full range of financial services to corporate clients and individuals)

Description: TASKOMBANK is a universal commercial bank. TASKOMBANK provides a full range of financial services to corporate clients and individuals. The project was to support and develop data management system for the investment banking and asset management division of TASKOMBANK.

Responsibilities:
•Gathered the Requirement from the business user and prepared the program specification and design document for the development
•Developed PL/SQL modules such as packages, triggers, procedures and functions.
•Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
•Writing validation packages using PL/SQL package.
•Heavily involved in Performance Tuning at the application level.
•Developed reports using FastReport.
•Documented and performed unit testing for all components prior to migrating them to production.
•Maintained existing applications.

Electronic document management system
Provision of services in consulting and business process automation based on the product ECM DIRECTUM (Enterprise Content Management system and management of business process). Implementation, training and support solutions based on ECM DIRECTUM.

Senior DWH/ETL/Oracle developer

з 09.2004 по 12.2012 (8 років 3 місяці)
Ministry of Finance of Ukraine, Киев (The mission of the Ministry of Finance of Ukraine is to form an effective public policy in the field of revenue and to ensure efficient and effective expenditure)

Description: The mission of the Ministry of Finance of Ukraine is to form an effective public policy in the field of revenue and to ensure efficient and effective expenditure. The project was to develop DSS for the management of public finances.
The project mission is to create a corporate data warehouse and management reporting system.

Responsibilities:
• Work with external vendors and internal business and technology staff to accurately gather and interpret requirements, specifications, and database models to determine appropriate ETL development solutions
• Develop ETL technical specifications and recommends, designs, develops, tests, implements, and supports innovative and optimal data solutions
• Work with the internal business to design, implement, and support end-to-end data solutions across multiple platforms, environments, domains, and locations
• Integrated ETL development with existing codebase to maximize object reuse
• Create, execute, and documents unit test plans for ETL and data integration processes and programs
• Document ETL processes, programs and solutions as per established standards
• Performs tasks required to conform to the company's configuration management and software release processes
• Work with internal team, vendors, consultants, and external partners to quickly identify and resolve data integration and ETL job issues
• Assess and document the structure, quality, and compliance of source data and coordinate with business and technology teams to identify and resolve issues

Senior System Administrator

з 07.2001 по 09.2004 (3 роки 2 місяці)
State Treasury of Ukraine, Киев (Goverment)

•Performing analysis and diagnostics of problems and implement corrective solutions for end users
•Install, configure, test, maintain, and troubleshoot end user workstations, phones and related hardware and software
•Assisting with server, network and audio/video equipment installations, troubleshooting and movement of existing equipment of these types when necessary
•Install and build out of new desktops and assists with new acquisition conversions
•Reconfiguration and support of branch LAN (with specific focus on ensuring consistency across the enterprise)
•Managing equipment inventory and keep administration of all equipment, their location and status
•Supporting branch phone systems (i.e. maintain backups and phone changes)
•Participating in projects supporting business activities, technology upgrades, rollouts, etc.
•Performing other various duties as assigned

Освіта

National Aviation University

Faculty of Mechanical Energy,Gas turbine plants, Киев
Вища, з 1995 по 2001 (5 років 10 місяців)