SUMMARY

• Over 10 years of Dynamic career reflecting pioneering experience and high performance in System Analysis, design, development and implementation of Relational Database and Business Intelligence Applications using AbInitio (GDE 3.2.7, Co - op 3.27), and other Major ETL Tools.
• ETL expertise with excellent exposure to AbInitio (GDE 3.2.7, Co-op 3.2.7) in high volume, parallel processing data environments.
• Excellent Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts.
• Proven Success as a Tech Lead and cross-organization collaborator, contributing effective and creative Data Integration Solutions.
• Vast experience in Production Support and Testing
• Having Hands on experience with agile development methodology.
• Expertise in AbInitio Coding, shell scripting, designing job flows, scheduling and data base queries.
• Having hands on knowledge in AbInitio admin activities, that includes new environment set up and sync up one environment with another environment.
• Experience in resolving the data lineage report errors occurred in analysis report.
• Designed and Developed the graphs using the GDE, with components like partition by round robin, partition by key, rollup, sort, scan, dedup sort, reformat, join, merge, gather Normalize, concatenate, fuse, continues components etc.
• Handled Batch processing projects and the various NDM/FTP involved getting and sending source and targeting data according to requirement.
• Worked on creating jobs/jils and scheduling the projects as per requirement in Autosys schedulers.
• Experience in Teradata (V12, V13) utilities- BTEQ, Fast Load, Multi Load, TPump, TPT, Fast Export
• Having very good experience in implementation of migration projects that include database, UNIX migration to different software and Ab initio version upgrades.
• Good exposure to Google BigData like Big Query and knowledge of loading Unix files to Google storage.
• Familiar with AbInitio Server (UNIX) Configurations and setup activities
• Worked with end users and developers to understand the data needs of an application
• Expertise in dealing global projects involving multi-vendor and multi locations.
• Proficient in Analyzing Business requirements, Active participation in Business discussions for Requirements Gathering and Data Quality Analysis
• Excellent Interpersonal Communication skills and Documentation.
• Worked as Onsite/Offshore Coordinator/Module lead for managing team and delivering the projects handled.

TECHNICAL SKILLS

ETL Tools: AbInitio - Co-op 3.2.7, GDE 3.2.7; IBM Infosphere DataStage 8.X

Operating System: DOS, UNIX, Linux, Windows 7/XP, 97, Windows Server 2003

RDBMS and Utilities: Teradata V12, v13, BTEQ, TPT, MLoad, FastExport, MSSQL, Oracle9i with emphasis on PL/SQL, Postgress

Data Modeling: Erwin

Quality Management: Reporting Tool

HPQualityCenter 10, Clear Quest, Rally: Cognos Reporting

Scheduling Tool: Tivoli (OPC), Autosys, Control-M V9

Repository: Ab Initio Metadata Hub 3.2.7, Query IT

Scripting Language: Shell Scripting and Python

Documentation & Collaboration: MS Office, Visio, Share-point, Outlook, Lotus Notes, Open Office

PROFESSIONAL EXPERIENCE

Confidential

Software Developer / ETL Developer

Responsibilities:

• Worked for Pharmacy analytics project for Confidential Inc. that involved enhancement and maintenance projects.
• Involved in analyzing business needs and document functional and technical specifications based upon user requirements with extensive interactions with business users.
• Identification of Impacts based on the new requirement in the existing system and identifying the development efforts required.
• Involved in planning, Grooming, Retrospective meetings and execute the projects using Agile methodology (scrum).
• Responsible for code migration to upper environments (SIT, UAT) using (git) tools.
• Driving agile development and approach the business requirements by continuous build and continuous testing.
• Had conceived data from sources, cleansed, transformed and loaded in to target databases using an ETL tool, Ab Initio
• Automate repetitive tasks to minimize the manual work and maximize the performance and productivity.
• Create plans using Conduct>IT framework for the generic requirement and do the modifications to the existing generic plans.
• Extensive experience working with branches in EME and coordinating with other teams to merge them.
• Responsible for creating and deploy the auto sys scheduling jils in all the environments.
• Coordinating with System Testing team and provide support in resolving QA & Testing issues/Problems.
• Create on demand Ad-hoc graphs in GDE to Troubleshoot Level II and Level III issues in production.
• Preparing the wrapper scripts as part of ETL Jobs execution
• Involve in Unit/System test plan creation based on the requirement and design document, providing the execution recommendation document in order to promote code to the higher environments.
• Working closely with the DBAs to create any new table schemas or objects for the database and MDH

Environment: AbInitio 3.2.7, Co-op. 3.2.7, UNIX, Oracle, Postgress, Auto Sys, JIRA, JIT, Ab Initio Meta Data Hub, Conduct>It, Git commands, Google Cloud, BIG QUERY, HADOOP

Confidential

Software Developer/ETL Developer

Responsibilities:

• Worked for Digital Experience project for BCBSA that involved enhancement and support projects
• Responsible for gathering, analyzing and preparing mapping documents and then Review and analyze existing data models: Physical, Logical, and Conceptual Models.
• Responsible for job execution and deployments (ETL batch and real time services) in the Limited Integration Testing (LIT) environment.
• Involved in analysis for Data issues for FEP DW
• Providing Design Specifications and ensure map specifications to the Requirements and Developing Ab-Initio graphs to match the Specifications.
• Create on demand Ad-hoc graphs in GDE to Troubleshoot Level II and Level III issues in production.
• Doing the root cause analysis and working for the permanent fix at code level and application configuration level by coordinating with development and SA team.
• Automate repetitive tasks to minimize the manual work and maximize the performance and productivity
• Coordinating with System Testing team and provide support in resolving QA & Testing issues/Problems.
• Responsible for addressing the incident tickets which has assigned to the support group and close the tickets with minimum MTR (Mean time of resolution) after providing appropriate resolution.
• Involve in Unit/System test plan creation based on the requirement and design document, providing the execution recommendation document in order to promote code to the higher environments.
• Responsible for loading of technical Meta data from EME, DB2 catalogs, S2T documents, Cognos metadata and Reference data Maintenance in Meta Data Hub.
• Involving in providing the data lineage report for different environment based on the request by the SA/Dev Team.
• Set up of ETL projects, EME instance, Control-M jobs and Shakeout of new environments, running all jobs and processes to assure everything is working as expected before releasing the environment
• Working closely with the DBAs to create any new table schemas or objects for the database and MDH
• Masking of production data (files including PHI and PII) via the File-Aid tool (FEP Standard Tool) for use in the lower environments.
• Creating shell scripts to automate loading DB2 catalogs, sand box details, S2T documents in Meta Data Hub.

Environment: AbInitio 3.2.7, Co-op. 3.2.7, UNIX, DB2, Control - M V9, Cognos, Ab Initio Meta Data Hub, Query IT.

Confidential - Irving, Texas

Senior TechnicalDeveloper

Responsibilities:

• Develop a thorough understanding of business specifications and produce design and code artifacts that meet the specifications
• Providing Resource, Effort Estimation and planning to the PMO groups
• Identification of Impacts based on the new requirement in the existing system and identifying the development efforts required
• Preparation of Detailed level design document based on the requirement and the impacts (if any).
• Participating in Business Analysis discussion to come up with the ETL Data Mappings
• Providing Design Specifications and ensure map specifications to the Requirements
• Developing Datastage Jobs, AbInitio graphs to match the Specifications.
• Guiding team for the daily development effort and conducting regular status meets
• Implementation of change requests to support the ongoing requirement changes
• Coordination with Data Modelers & DBAs for DDL changes, to keep in synch the other countries Data warehouse model
• Involved in Unit/System test plan creation based on the requirement and design document
• Supporting QA and UAT testing Cycles
• Coordination with System Testing team and resolving QA & Testing issues/Problems
• Migrating and deploying the ETL code in QA and UAT environments
• Preparing job flow and execution order through AutoSys scheduler
• Testing the schedule in test region
• Implementation in Production, Parallel support.
• NDM connectivity and initial project setup
• Preparing required Documentation, Training Materials and Support Plans to the Production Support Team
• Provided production support until the support team as up and ready.

Environment: AbInitio 3.1.4, IBM InfoSphere DataStage 8.X, UNIX, Teradata, Oracle, AutosysCognos.

Confidential

Senior Developer

Responsibilities:

• Initial requirement analysis and Impact analysis
• Understanding the data model, table structure to build in Teradata which is equaling
• Extensively involved in all the phases of development, right from HLD preparation to Prod support
• NDM connectivity and initial project setup
• Preparing ETL mappings required for EDW by coordinating with business analysts
• Creation of mappings using different types of transformations
• Development and unit testing of complex graphs
• Involved in preparation of unit test plans and unit testing
• Tracking the Test Plan/Test Specification vs. Requirements
• Coordination with System Testing and User Acceptance Testing teams, resolving QA Testing issues
• Preparation of training materials and operational manuals
• Migrating and deploying the ETL code in QA and UAT environments
• Preparing job flow and execution order to schedule the jobs in Auto Sys Scheduler
• Testing the schedule in test region
• Implementation in PROD, Prod parallel support
• Capturing best practices, new leanings and spreading KM and KC awareness within the team
• Doing production support with the tool Infoman, where the failed job details will be queuing.
• Participating in code promotion using Service Now tool.

Environment: AbInitio, UNIX, Teradata, Auto SYS, Service Now, Shell Scripting.

Confidential

ETL Developer

Responsibilities:

• Initial requirements and Impact analysis
• Create ETL mappings using different types of transformations
• AbInitio (DW) graphs as per the mappings rules
• Developed Unix wrapper scripts to run the graph’s deployed Unix scripts
• Develop Shell Scripts to run the jobs in UNIX environment
• Involved in preparation of unit test plans and unit testing
• Tracking the Test Plan/Test Specification vs. Requirements
• Coordination with System Testing team
• Preparing job flow and execution order through OPC scheduler
• Performance monitor the graphs and tune for the best performance
• Coordination with the Data Modelers and DBAs for any model changes and implement the DDLs accordingly
• Preparation of training materials and manuals
• Migrating and deploying the ETL code in QA and UAT environments
• Implementation and Post Implementation Support

Environment: Ab Initio, Teradata, Unix Shell scripting, SQL, Tivoli Scheduling