SUMMARY:

• Having total 12 years of IT experience with expertise in Data Warehousing with Data Analysis, Data Integration, and Data Management.
• 8 years relevant experience in ETL tool Abinitio which includes 2 Years onshore experience.
• Designed Source to Target Mapping documents with the business rule transformations to load the data into Date Warehouse from multiple source systems.
• Understanding of the ETL concepts especially various components of Abintio.
• Experience in interacting with business users on multiple projects and translating the Business User requirements to technical specifications.
• Thoroughly conversant with Software Development Life Cycle (Requirements Gathering, Analysis, Design, Design Review, Coding, Code Review, Test plans, Testing and Deployment.
• Experience integrating Financial products viz. Bonds, Loans, Derivatives, FX data in warehouse.
• Experience writing SQL codes and creating PL/SQL objects, database views in Oracle.
• Proficient with Database relational models, stored procedures, and views.
• Proven experience in data modeling, data management, data warehousing, data transformation, metadata and reference data management and Erwin tools.
• Skilled in designing, developing, implementing and maintaining applications in risk management
• Experience in using of Unix, SQL and Production support for Applications
• Created comprehensive application support documentation (Run book) for use by L3 and L2.
• Tracked production issues using Service Now Incidents and Tasks.
• Basic knowledge of using ETL tool Informatica.
• Worked with continuous components and XML components in AbInitio
• Experience working with various Heterogeneous Source Systems like Oracle, SQL Server, Teradata, DB2 and Flat files.
• Good knowledge in working with Relational database utilities like TOAD.
• Knowledge with Batch Jobs automation tools including Autosys.
• Knowledge in data warehouse concepts, STAR Schema, SNOW FLAKE Schema designs and dimensional modeling

TECHNICAL SKILLS:

Database: Oracle Database 10g/11g, PL/SQL programming.

Languages: and Tools Abintio 3.1, UNIX Shell Scripts, and PLSQL Developer.

Operating Systems: Windows, UNIX.

PROFESSIONAL EXPERIENCE:

Technical Consultant

Confidential

Responsibilities:

• Working to Integrate wholesale data warehouse to downstream Recon system.
• Working closely with the downstream IT team to gather requirements and implement a
• Mechanism for balance comparison.
• Data Analysis to ensure 100 % consumption of the data hub by the downstream systems.
• Write complex SQL Query’s for data extraction and analysis.
• Analyze PL/SQL code for understanding of legacy data.
• Data comparison in Excel using Pivot table etc.

Confidential

Responsibilities:

• Created new wrapper script which sends the source file load status in csv fomat to the concerned team.
• Handling of any UAT/Production issues and maintaining all defects in common share drive.
• Conducting team meetings to understand their issues, concern and giving suggestions to them.
• Involved in the development of new projects in Abinitio and enhancements of existing application in Abinitio.
• Handling quality process and attending quarterly audits with Quality team.

Confidential

Responsibilities:

• Handling L&T GIW Securities and CDS2 defects.
• Attending weekly Defect meeting with the team.
• Follow up with GIW and CDS2 team for implementation of defects based on priority in Production.
• Analysis/debugging of any production issues and maintaining all defects in common share drive.
• Involved in the development of new projects in Abinitio and enhancements of existing application in Abinitio.

Confidential

Responsibilities:

• Involved in the development of new projects in ABINITIO and enhancements of existing application in ABINITIO.
• Reading data from multiple source system in different formats like MQ Series, Flat Files, and XML Files or reading data from ABINITIO queues populated by other application in SPE.
• Preparing Test Cases, Unit testing, Integrated testing
• Involved in IUT, SIT and UAT testing and Support to UAT Team.
• Analysis/debugging of any production issues and UAT issues.

Confidential

Responsibilities:

• Involved in the development of new projects in ABINITIO and enhancements of existing application in PL/SQL with INFORMATICA or ABINITIO.
• Reading data from multiple source system in different formats like MQ Series, Flat Files, XML Files or reading data from ABINITIO queues populated by other application in GIW.
• Involved in IUT, SIT and QC (Quality Control).
• Analysis/debugging of any production issues and UAT issues

Confidential

Responsibilities:

• Involved in the development of new projects in ABINITIO and enhancements of existing application in PL/SQL with INFORMATICA.
• Reading data from multiple source system in different formats like MQ Series, SHAREPLEX to replicate data from source to target, XML data through MQ.
• Involved in IUT, SIT and QC (Quality Control).
• Analysis/debugging of any production issues and UAT issues

Confidential

Responsibilities:

• I was responsible for supporting the Development team by understanding project specifications and requirements, which were essential for developing the backend data quality check utilities.
• Used SQL and PL - SQL for mass updates in the database. Involved in Database loading and maintaining the integrity.
• Involved in setting up the Production workflow and Process for the entire project and the sequence of steps to be taken from data loading to delivery.
• Involved in analyzing the Bugs reported by customer
• Closely interacted with the Team Leads, providing timely support to the onsite team
• Preparation of test plans and test cases.
• Regular training sessions to meet the general as well as specific requirements of the entire Team.
• Induction of new trainees and preparation of training documents for the new associates.