SUMMARY

• About 11 years of sound experience of technical and managerial activities which involves several business domains: Banking, Telecom, Logistic and Health Insurance industry.
• Currently working with “ Confidential Inc.” as ETL Designer/Sr Developer at Durham, NC.
• Have experience handling a team of 20+ resources. Experience in managing an onsite offshore team.
• 11 years of experience in data warehouse space, skilled in multiple of the disciplines of data warehouse such as Data Modeling, ETL Analyst/Designer, data management and BI reporting analyst in various development projects.
• Expertise in Ab Initio Design, Configuration experience in Ab Initio ETL, Data Mapping, Transformation and Loading in complex and high - volume environment and data processing at Terabytes level.
• Expertise in designing solutions around AbInitio, with advanced skills in high performance and parallelism in AbInitio.
• Good experience in understanding business requirements and translating these to schema requirements.
• Strong UNIX, korn shell scripting experience.
• Strong Oracle, Teradata database knowledge
• Experience in full software development life cycle of development projects.
• Hands on in agile development.
• Good interpersonal, communication, team handling and documentation skills

TECHNICAL SKILLS

Hardware Platform and OS: Windows, UNIX

Tools: / Software: Ms Office, Abinitio, Toad, Mercury Quality Center, Teradata SQL Assistant

Languages: SQL, PL/SQL, Unix shell scripting

Database: Oracle, Teradata, DB2

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

ETL Designer/Sr developer

Responsibilities:

• Involved in analyzing the requirements and mapping the requirements into ETL design document
• Identification of Impacts based on the new requirement in the existing system and provide effort estimates for the change.
• Create High level design document, ETL mappings to load data warehouse table
• Provide effort estimation and capacity planning.
• Develop Abinitio graphs, unix scripts, SQL queries for extraction, transformation and loading of data in Data warehouse tables in Teradata
• Involved in code review for the quality of the deliverables.
• Involved in Unit testing and System Integration testing. Coordinated in preparing Test Environment and Test Data.
• Involved in creating Test Plan and Test scripts document.
• Coordinated User Acceptance Testing. Investigated and resolved defects raised by Business Users.
• Involved in tracking defects and maintaining defect logs.
• Involved in migration and deploying of code in QA and UAT env.
• Involved in creation Prod Implementation plan, and coordinating the implementation in Prod.
• Ensure all relevant documents are available and uploaded in SharePoint link
• Tracking and monitoring work status to ensure timelines
• Attend and Facilitate checkpoint / status meetings.
• Onsite-offshore coordination
• Coordination with Business Users.

Confidential

ETL designer

Responsibilities:

• Involved in analyzing the requirements and mapping the requirements into High level document and Detail design document.
• Create High level design document, ETL mappings to load data warehouse table
• Provide effort estimation and capacity planning.
• Develop Abinitio graphs, unix scripts, SQL queries for extraction, transformation and loading of data in Data warehouse tables in Teradata
• Involved in internal and external code review for the quality of the deliverables.
• Involved in Unit testing and System Integration testing. Coordinated in preparing Test Environment and Test Data.
• Involved in creating Test Plan and Test scripts document.
• Coordinated User Acceptance Testing. Investigated and resolved defects raised by Business Users.
• Involved in tracking defects and maintaining defect logs.
• Involved in migration and deploying of code in QA and UAT env.
• Involved in creation Prod Implementation plan, and coordinating the implementation in Prod.
• Ensure all relevant documents are available and uploaded in SharePoint link
• Tracking and monitoring work status to ensure timelines
• Attend and Facilitate checkpoint / status meetings.
• Onsite-offshore coordination
• Coordination with Business Users.

Confidential

Abinitio ETL developer

Responsibilities:

• Involved in analyzing the requirements and creating the Detail design document.
• Develop Abinitio graphs, unix scripts, SQL queries for extraction, transformation and loading of data in Data warehouse tables in Teradata
• Involved in internal and external code review for the quality of the deliverables.
• Involved in Unit testing and System Integration testing. Coordinated in preparing Test Environment and Test Data.
• Involved in creating Test Plan and Test scripts document.
• Coordinated User Acceptance Testing. Investigated and resolved defects raised by Business Users.
• Involved in tracking defects and maintaining defect logs.
• Checking in and tagging of Abinitio graphs/scripts.
• Creating Packages for the set of artifacts to migrate from one environment to other environment
• Involved in migration and deployment of code in production. Involve in creation of Implementation plan.
• Tracking and monitoring work status to ensure timelines
• Attend and Facilitate checkpoint / status meetings.
• Onsite-offshore coordination

Confidential

ETL developer

Responsibilities:

• Involved in analyzing the business requirements and creating the Detail design document.
• Involve in developing Abinitio graphs, PL/SQL programs based on design document, unix scripts to run the graph’s deployed Unix scripts, SQL queries for extraction and loading of data in Data warehouse tables
• Involved in Unit testing and System Integration testing. Create Test Plan and Test scripts document.
• Involve in checking in and tagging of Abinitio graphs/Scripts
• Creating Packages for the set of artifacts to migrate from one environment to other environment
• Create prod implementation plan, support and coordinate prod implementation.
• Involved in internal code review for the quality of the deliverables.
• Ensure all relevant documents are available and uploaded in SharePoint link.

Confidential

ETL developer

Responsibilities:

• Analyzing the Business Requirements and System Specifications.
• Developing SQL queries, PL/SQL codes according to design document.
• Preparing unit test plan/test cases, Conduct unit testing.
• Involve in verifying the code standard as per the code review checklist.
• Coordinating with the testing team in Test Environment preparation, System Integration testing, Regression testing
• Review Testing documents including Test Specification, Test Plan, Test results
• Investigating and resolving the problem logged by testing team.
• Migration and deployment of codes into Production Environment.
• Create prod implementation plan, support and coordinate prod implementation.