ETL developer, System Architect Resume

SUMMARY

Total 7 years of experience in IT industry.
Over 5 years of experience in extensive ETL design, development, data analysis, data warehousing and Reconciliations.
Over 4 years of comprehensive experience on data Reconciliations across various heterogeneous systems.
Proficient in Abinitio 2.1.14, Abinitio 3.0.3, Perl scripting, Unix Shell Scripting, Oracle 10g/11g. Sybase 15.0, Autosys scheduling.
Exposure to Abinitio 3.1.15, BRE (Business Rule Environment) 3.1.15, ACE (Application Configuration Environment) 3.1.15, Metadata Hub 3.1.15, Data Profiling.
Dodd Frank (US Market Exposure) reporting for SEC (Security Exchange Commission) and CFTC (Commodities Futures and Trades Commission) Implementation for the financial client.
Excellent Communication and Interpretation skills.
Acquaintance to Accounting principles for Balance sheet, Profit and Loss reporting.

PROFESSIONAL EXPERIENCE

Confidential

ETL developer, System Architect

Responsibilities:

Analysis of the data stored in multiple tables and understanding the relationship between the base positions and the corrections on it. Using ETL efficiently to make sure that there is minimum load on the system and ETA’s are achieved.
Understanding the correction data warehouse in General Ledger and preparing process flow for Genesis data preparation.
Understanding the flow of the data in different systems and imply the business logic accurate to make sure that the corrections flow is taking care of systems errors.
Data modeling, implementation of ETL functionalities and Functional testing.
Generic implementations for future changes and compatibilities with new systems.
Solving technical issues of team members during integration testing.
Onsite coordination and team management.

ETL developer, System Architect

Confidential

Responsibilities:

Understanding and implementation of Prong I and Prong II tests and calculations for Dodd Frank reporting. This involved detailed understanding of SEC (security exchange commission) and CFTC (Commodities Futures and Trade commission).
Setup ETL and database servers, architecture and design for the reporting that involved high amount of data from different systems, multiple mappings from Finance controls with high stability.
Implementation of functionalities in ETL, Sybase DB and AIX server. Performance tuning to match SLA.
Coordination with Business analyst in understanding the data from all the systems and its use in implementing the tests for market exposure reporting.
Reconciliations of reports with Traders to at the testing stage to validate the accuracy of the data.
Processing tuning and software optimization for performance optimization to handle Big data to match ETA for user reporting.
Offshore coordination for overnight operation of the application.

Sr Software developer

Confidential

Responsibilities:

Understanding the system interactions and mapping between the applications for corrections. This includes understanding the business of the two systems and how the business can interact.
Understanding and implementation of entitlements, user profiling, maker, checked for adjustments application.
Interaction with Business users, clients during the application developments.
Flow design and implementation of functionalities in ETL, PL SQLs shell scripts.
Generic implementations for future changes and compatibilities with new systems.
Functional testing includes reconciliations of data between two systems.
Analysis of the systems breaks in test data and gathering statistics. Using ETL to
Offshore management and solving technical issues of team members during integration testing.
Packaging of modules, post production activities which includes the knowledge transfer to support team.

Software developer

Confidential

Key Responsibilities:

Understanding the data processing requirement of upstream Systems. Creating templates and implementation.
Data analysis, drill down to during the testing phase.
Development of Sybase TSQL Stored Procedures and Queries
Utility scripts for packaging.
Preparation of Unit Test Plans, peer testing and Unit Testing