Snr Oracle ETL Developer / Team Leader
05.2012 − 01.2018 (5 років 8 місяців)
Snr Oracle ETL Developer / Team Leader, 01.05.2014 – present Luxoft, Deutsche Bank ODC, Ukraine
• Program: Regulatory & Control
• Projects: Production Service Level 3 (SL3) including x-Jurisdictions (CFTC/CANADA/HKMA/ESMA/MAS/ISIC) and x-Assets (IR/CMD/FX/CR/EQ) + EMIR Valuations; Environment Stability
• Description: The Depository Trust & Clearing Corporation (DTCC, www.dtcc.com) is the world’s largest post-trade financial services company, authorized by The U.S. Commodity Futures Trading Commission (CFTC, www.cftc.gov, an independent agency of the United States government that regulates futures and option markets) to gather ongoing financial, operational and regulatory reports.
The projects mission is to furnish and support regulatory reporting for DTCC. The solution allows loading data from different source systems, consolidating it in data warehouse, validate data, calculate financial indicators and populates specific data marts, generate reporting and send financial data to DTCC.
• Duties:
o Lead the team up to 16 FTE (BA, Oracle, Java, ETL);
o Following full software development cycle (requirements gathering, development, integration testing, quality assurance, user acceptance test, production deployment and post-production support);
o Technical Leadership, tasks decompositions, retrospectives, code review;
o Responsible for delivery and deployment into SIT/UAT/PROD Environments;
o Clarification requirements with Customer (PM), participate in regular call-meetings and presentation solutions for Business Customer;
o Transformation functional requirements into technical tasks after daily call-meetings;
o Cooperation with QA Team for fast bug-fixing for getting QA sign-off «In Time»;
o Control and coordinate deployment patches (DB and UI) creation/applying, Backlog prioritization;
o Loading data from different sources into landing tables using Informatica Power Center, Oracle, JMS, Web-services, Java;
Senior Oracle/ETL Developer, 01.06.2012 - 01.05.2014 Luxoft, Deutsche Bank ODC, Ukraine
• Projects: CFTC/CANADA (CMD/FX), EMIR Valuations
• Description:
The project mission is to furnish regulatory reporting for DTCC. The solution allows loading data from different source systems, consolidating it in data warehouse, validate data, calculate financial indicators and populates specific data marts, generate reporting and send financial data to DTCC
• Duties:
o Creating Realtime and EOD/Valuations reporting to DTCC;
o Loading data from different sources into landing tables using Informatica Power Center, Oracle, JMS, Web-services, Java;
o Bug-fixing, code review and QA support activities;
o Participating in regular call-meetings with BA/QA/PM;
o Migration from Informatica 8 to Informatica 9;
o Preparing technical documentation like a TDD;