SUMMARY:

• Has 11+ years of experience in Data Warehousing ETL development using Ab Initio (GDE 3.0.2, Co>Ops 3.0.4) and Informatica 8.6.Involved in Design, Development, testing deployment and in production support for various applications in Banking and Insurance Domains. Had experience in all aspects of software development life cycle and also worked on Agile methodologies.

TECHNICAL SKILLS:

ETL Tools: Ab Initio Co>Op 2.14.134/3.0.4, Informatica8.6.1/9.1

Languages: Unix KSH Shell scripts, Python

Configuration & Version Control: Ab Initio EME

Database: Oracle, Teradata

I SQL Tools: Toad, SQL Developer

Job Scheduling: Control - M, Autosys, Arow

BIGDATA: Hadoop, Spark

Cloud Technologies: AWS, SnowFlake

PROFESSIONAL EXPERIENCE:

Confidential, Texas, Plano

COAF Site Reliability Engineer

Responsibilities:

• Worked on enhancements in some of the graphs for the Existing Abinitio jobs.
• As a senior developer, supporting my team members in understanding the system & developing graphs.
• Maintain/modify programs as per the requirements for the new cloud environment.
• Used WEB EME extensively to analyze the dependency analysis for the new environment.
• Involved in defect fixing.
• Involved in the discussion with the Data stewards and SME team to resolve production issues.
• Involved in discussions with Dev Teams on Design Reviews and KT’s before moving the code to production.
• Implemented Lambda and s3 workload policies in Production.
• Involved in Analysis for On PREM to AWS Migration.
• Implemented solutions like DROPBOX and FILEBROKER in Cloud.
• Implemented Monitoring tools on the Logs that are created by Arow for reports on daily executions using python.
• Migrated Applications from Control-m to Arow.
• Implemented catch ups using spark and unix.
• Involved in discussions with Dev Teams on Design Reviews and KT’s before moving the code to production.
• Involved in defect fixing.
• Involved in the discussion with the Data stewards and SME team to resolve production issues.
• Supported AWS and Hadoop Applications
• Involved in Rehydration of AWS Components like EMR, EC2

Confidential, Wilmington, DE

L3 Support Specialist

Responsibilities:

• Involved in discussions with Dev Teams on Design Reviews and KT’s before moving the code to production.
• As a senior developer, supporting my team members in understanding the system & Supporting Applications.
• Providing override codes in case of code failures to continue on the existing production runs
• Involved in defect fixing.
• Involved in the discussion with the Data stewards and SME team to resolve production issues.
• Used WEB EME extensively to analyze on Prod runs.
• Supported AWS and Hadoop Applications
• Involved in Rehydration of AWS Components like EMR, EC2
• Involved in Analysis for On PREM to AWS Migration
• Implemented solutions like DROPBOX and FILEBROKER in Cloud.

Confidential, Hartford, CT

ETL Developer

Responsibilities:

• Involved in discussions with Business Analysts for clarifications
• Getting complete hold on the source and target systems
• Worked on enhancements in some of the graphs.
• As a senior developer, supporting my team members in understanding the system & developing graphs.
• Maintain/modify programs during the Assembly Testing and System Integration Testing phase
• Involved in defect fixing as a part of assembly test / SIT execution
• Given support for the Cycle Execution in the SIT Phase.
• Defect Fixing for the issues raise while in the SIT Cycle execution.
• Involved in the discussion with the BA’s
• Implemented SCD Type2 Model Using Abinitio.
• Used EME extensively for version control.
• Created Plans to implement dependencies during execution.
• Developed and Maintained jobs to execute the Graphs.

Confidential

ETL Developer

Responsibilities:

• Performed Server set ups and Migrated Abinitio applications from one server to other.
• Performed Application Analysis, design for conversion of Abinitio module to Informatica.
• As a active member from Dev team Provided level 2 support for Production issues where Production support team not able to resolve the issue.
• Created mapping documents based on the AbInitio Graphs.
• Performed Migration from Informatica 8.1 to 8.6.
• Created transformations and mappings using Informatica to move data from multiple sources into targets.
• Created ETL transformations like Lookup, Rank and Source Qualifier Transformations in the Informatica v9 designer
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter.
• Expertise in Performance Tuning by identifying the bottlenecks at sources, targets, Power Center transformations and sessions using techniques like Explain plans
• Used Informatica designer to create mappings using transformations to move data to a data Warehouse.
• Developed mappings, worklets and sessions, Event raise, and Command tasks.

Confidential

ETL Developer

Responsibilities:

• Involved in discussions with Business Analysts for clarifications
• Getting complete hold on the source and target systems
• Worked on enhancements in some of the graphs.
• As a senior developer, supporting my team members in understanding the system & developing graphs.
• Maintain/modify programs during the Assembly Testing and System Integration Testing phase
• Involved in defect fixing as a part of assembly test / SIT execution
• Given support for the Cycle Execution in the SIT Phase for the RDM.
• Defect Fixing for the issues raise while in the SIT Cycle execution.
• Involved in the discussion with the BA’s