SUMMARY:

• Over 9+ years of experience in Design, Development, Testing, Implementation, Enhancement and Support of Data warehousing technologies. Extensive experience in ETL, Ab Initio, ACE, Unix, Sql and Aglie concepts.
• Having 8+ years of experience as a Tech Lead, ETL/Ab Initio developer in software development, design and implementation, Data warehousing.
• Experience in Software development/enhancements in Insurance, Banking, Health and Retail & Logistic domain.
• Focus in the extensive coding, design, implementation, testing, and deployment.
• Knowledge of various databases like TERADATA, DB2, SQL and ORACLE.
• Experience in developing complex mappings using Ab Initio to Extract the data from various sources and load into the Data Warehouse.
• Extensive hands on experience in Data Warehousing, Data Marts, OLAP, and OLTP concepts.
• Extensive hands on experience in Database components, De partition components, Partition components, Sort components, Transform Components and on multi file system (MFS).
• Experienced in working with AC - XMLs and Multifile systems (MFS).
• Experience working on Ab initio Batch flows, Continuous flows and Plans.
• Experience in UNIX (Solaris 5.10), Linux 2.6 and Oracle 11g.
• Experience in performance improvement techniques.
• Practical experience with working on multiple environments like development, testing and production.
• Involved in the Waterfall model and Agile Implementation Methodologies.
• Familiar with implementation of new technologies including documentation of the setups required and identifying the resolutions by working with support teams and creating troubleshooting documents to assist new team members.
• Expertise in Ab-initio, Conduct>It, Express>It (ACE), PDL, ACE, EME version control, Data Lineage, Data dependency, Metadata Hub, Ab-initio - HADOOP integration, Oracle, PL/SQL, UNIX-Shell Scripting, HIVE, XML, JSON & AVRO and CDC GoldenGate file format.
• Experience in designing and creating scripts/processes on UNIX and LINUX to automate Processes.
• Involved in working with users, identifying functional and technical gaps, estimating work to fulfill business requirements, designing custom solutions, programming, scheduling, documentation, and production support.
• Involved in all the phases of SDLC starting from project assessment, functional requirement.
• Experience in end-to-end ETL design and development, requirements gathering, Data Mapping, Transformation and Loading in a complex, high-volume environment.
• Hands on experience in ETL tools ACE and Hadoop Administration.

TECHNICAL SKILLS:

ETL Tools: Ab Initio (GDE 3.2.2, 3.0, 2.14, Co>Operating System 3.2, 3.0, 2.14), EME, Express>It (ACE), Meta Data Hub

Programming Lang: SQL, PL/SQL, Unix Shell Scripting. Scala and Spark.

Operating Systems: Windows XP/7 Server, HP-UX 11.1, SunOS 5.10, Linux 2.6.32

Scheduler: Tivoli, $U, Mainframe, Autosys

Databases: Oracle 11g, Teradata, DB2

Domain Knowledge: Insurance, RLT, Banking and Health

Methodology: SAFe Agile frame work, Waterfall Model

Tools: JIRA, GitHub, Rational ClearQuest, HP ALM/QC

PROFESSIONAL EXPERIENCE:

Confidential, Foster City, CA

Technology Lead

Responsibilities:

• Interact with Business users to understand new functional, ETL requirements to convert into TC33 format.
• Involved in development of projects, Unit testing, System testing to check whether the data loads into target are accurate which was extracted from different source systems according to the user requirements.
• Involved in writing the scripts to automate the execution of jobs and scheduled jobs using mvs.
• Designing and Developing new functionality end to end
• Works on development of Ab Initio Graphs and wrapper Scripts and creating ACE appconf templates.
• Involve in code migration activities by creating tag in lower environment and promoting it to higher environment
• Involved in code review of graphs/scripts before they are moved to another environment (Dev to QA or QA to Prod)
• Involve in defect fixing & testing on all required environments
• Assured high quality of code was delivered by carrying out effective code reviews
• Involved in Performance tuning by following Best Practices
• Unit Test plans and Documentation preparation is done during the Developments/Enhancements
• Involved in writing the scripts to automate the execution of plans.
• Creating subscripts to Banks through ACE screen in order to generate TC33 formatted output.

Environment: Ab Initio 3.1.5 & 3.2.3, Co>Operating System3.2, XML, TC33, UNIX, MVS, DB2 and ACE.

Confidential, Chicago, IL

Technical Lead

Responsibilities:

• Interact with Business users to understand new functional, ETL requirements.
• Involved in development of projects, Unit testing, System testing to check whether the data loads into target are accurate which was extracted from different source systems according to the user requirements.
• Involved in writing the scripts to automate the execution of jobs and scheduled jobs using Tivoli.
• Performance improvement of the Applications
• Interacting with BSA, business and the team to understand business requirements.
• Involved in development of project, Unit testing, System testing to check whether the data loads into PIM are accurate, which was extracted from different source systems according to the user requirements.
• Suggesting possible automations (using Ab Initio) to reduce human efforts maintaining consistency and quality of deliverables.
• Involve in the metadata warehouse, holding the metadata to import from the Technical Repository and data lineage, business definitions, impact analysis of data flow.
• Involve on Development, Unit Testing, End-to-End Testing and code Migration
• Create support document (Includes recent failures faced in development and source/destination file location) which will ease Production support team in case of failure.
• Worked with testing team to help them understand the user requirements on the quality testing.
• Involved in writing the scripts to automate the execution of plans and scheduled jobs using Tivoli Scheduler.

Environment: Ab Initio 3.2.2, Co>Operating System3.2, MDH, SQL developer, XML, UNIX and Tivoli.

Confidential, Memphis, TN

Technical Lead

Responsibilities:

• Interact with Business users to understand new functional, ETL requirements.
• Designed and development of Ab Initio Graphs.
• Delivered the quality deliverables within the deadlines according client standards.
• Reports generation for End Users/Clients.
• Handling Production Fixes and Enhancements to Identify Root Cause of the failures and provide solution for them.
• Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures.
• Support delivered modules during warranty period on $U/Production phase.
• Actively involved in UAT support. Implemented fixes/solutions to issues/tickets raised by user community.
• Involved in writing the scripts to automate the execution of sessions and scheduled jobs using $U Scheduler.
• Involved in development of projects, Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Worked with testing team to help understand them the user requirements on the quality testing.
• Actively involved in UAT support. Implemented fixes/solutions to issues/tickets raised by user community.
• Involved in writing the scripts to automate the execution of sessions and scheduled jobs using $U Scheduler.
• Creating stories for offshore.
• Involving in the PI planning sessions for the business requirement.

Environment: Ab Initio 3.1.2, Co>Operating System3.1.3.1, SQL server 2008, Teradata, UNIX and Dollar Universe.

Confidential

ETL Developer

Responsibilities:

• Worked on Enhancements by designing new graphs.
• Coordinating with the Onsite team and UNIXOPS regarding job aborts and instruction to take action on the jobs that abort according to the resolution.
• Worked on production defects.
• Provided Support for 10 Applications.
• Involved in writing test cases & testing graphs on performance tuning.
• Scheduling ETL jobs using JRS Tool and Tivoli.
• Fixing the Defects by analyzing the root causes of the defect and arriving at the resolution before modifying the graphs/Scripts.
• Involved in Unit Testing by executing the Test Cases.
• Work with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents

Environment: Ab Initio 2.14, Co>Operating System3.0, SQL server 2008, Mainframe, UNIX and Tivoli.

Confidential

ETL Developer

Responsibilities:

• Involved in analysis and documentation of the relevance and complexity of data received from onsite coordinator.
• Developed Ab Initio graphs to load data from sources involving XML files to ADW (Oracle database).
• Prepared the test case documents.
• Involved in Unit testing and peer to peer testing the graphs.
• Interaction with PL on daily basis for requirement gathering and status update.

Environment: Ab Initio 2.14, Co>Operating System3.0, SQL developer, Mainframe, UNIX and Tivoli.

Confidential

ETL Developer

Responsibilities:

• Involved on analysis and documentation of the relevance and complexity of data received from onsite coordinator.
• Prepared the test case documents.
• Involved in Unit testing and peer to peer testing the graphs.
• Interaction with PL on daily basis for requirement gathering and status update.
• Analysis and documentation of the relevance and complexity of data received from clients and third party providers.
• Development of Ab Initio graphs to load data from sources involving Oracle, Flat-files, etc. to Oracle database.
• Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like check-in and checkout were used for this purpose.
• Involved in Unit testing and peer to peer testing the graphs.

Environment: Ab Initio 2.14, Sql, Mainframe, UNIX and Tivoli.