SUMMARY

• 6 years of experience in IT industry in Analysis, Design, Development, and Testing & Implementation of various Data Warehousing Projects. 5+ Years of experience in Ab - Initio GDE (1.15/1.14/1.13 ), Co>Op (2.15/2.14/2.13 ).
• Worked in data warehousing using ETL (Extraction, Transformation and Load) tool Ab Initio. Well versed in developing data management solutions using Ab Initio and UNIX shell scripts.
• Good Exposure in Dimensional Modeling, ETL Design, Requirement Analysis, Estimation and User interface. Working knowledge of Data modeling using Star Schema/Snowflake schema, Fact & Dimensions tables.
• Well versed with database like DB2/400 and well aware of Data warehousing Concepts.
• Strong experience in designing & preparing functional specifications, high level design documents and low level design documents
• Excellent Exposure to Insurance and Banking domain.
• Hands-on experience in AS400 with RPG programming.
• Excellent ability to maintain and develop AS400 application systems using RPG Integrated Language Environment, Screen design Aid, Reports using Report Layout utility and Subfiles.
• Provided 24x7 Production Support for ETL jobs for daily, Monthly and Weekly schedule.
• Experience with various scheduling tools like Autosys.
• Good analytical and presentation skills.
• Highly motivated with the ability to work effectively in teams as well as independently.
• Excellent Communication, Interpersonal, problem solving and time management skills.

TECHNICAL SKILLS

Operating Systems: Windows 98/2000/XP,OS/400, UNIX

Languages: RPG, RPGLE, CL, CLLE, Cobol, Java

Databases: DB2/400,SQL, DB2

Tools: Ab Initio GDE 1.13, 1.14, 1.15, Co>Ops 2.13,2.14,2.15,SEU, RLU, DFU, PDM, SDA, ISDB, Subfiles, Smart400, Implementer, Mercury quality Centre, Autosys

Domain Knowledge: Insurance, Banking and Energy

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

ETL Developer

Responsibilities:

• Designing the ETL process using Ab Initio tool to load data from source to target schema
• Preparing Design Document, ETL specifications, Unit Test Cases
• Extensively used the Ab initio components like Reformat, Join, Partition by Key, Merge, Gather, Sort, Dedup Sort, Rollup, Lookup to transform and load the data in fact and dimension tables
• Used Data Parallelism, Pipeline Parallelism and Component Parallelism in Graphs, where huge data files are partitioned into multi-files and each segment is processed simultaneously.
• Developed wrapper scripts to execute Ab Initio graphs (Unix Shell Scripts)
• Used Ab Initio EME (Enterprise Meta>Environment) to promote graphs from Development to Uat and then to the production environment.
• Testing the graphs by Unit testing, and Integration testing as per the test cases and test plan.
• Created JIL’s for Autosys scheduling

Environment: Ab Initio GDE 1.15, Co>operating System 2.15, Shell Scripting, SQL, DB2, Autosys

Confidential, Illinois

Ab Initio Developer

Responsibilities:

• As an ETL Designer and Developer, was responsible for interaction with client and analysis of the specifications provided by the client
• Participated in data model (Logical/Physical) discussions with Data Modellers.
• Preparing Design Document, ETL specifications, Unit Test Cases
• Implemented Star Schema models for the above data warehouse by creating facts and dimensions.
• Design the ETL process using Ab Initio to load data from source files to different Facts and Dimension tables.
• Extensively used the Ab initio components like Reformat, Join, Partition by Key, Partition by Expression, Merge, Gather, Sort, Dedup Sort, Rollup during graph development.
• Testing the graphs by Unit testing, and Integration testing as per the test cases and test plan.
• Wrote shell scripts to automate the calling of graphs and scheduled those using Autosys.

Environment: Ab Initio GDE 1.15, Co>operating System 2.15, Shell Scripting, DB2, Autosys

Confidential, NewYork

Team Lead

Responsibilities:

• Responsible for interaction with client, gathering requirements and analysis of the specifications provided by the client.
• Sizing of the project in terms of analysis, design, build hours (Code, Code Review, Unit Testing), System Integration Testing, UAT, and production support.
• Understanding the business requirements and creating Technical design documents based on the business requirements.
• Developed the Ab Initio graphs to load data from source files to staging database and from staging database to target tables.
• Extensively used Reformat, Rollup, Lookup, Join, Partition by key, Gather, Merge, Run program, Scan, Input File, Output File, Input Table, Output Table components for creating the graphs.
• Accountable for maintaining stringent deadlines and ensuring defect free delivery to the client.
• Mentored team members for any functional or technical query related to application.
• Mentoring and arranging technical trainings for the team of new resources inducted in the projects
• Reviewing the deliverables of team and conducting knowledge sharing sessions to enhance the team skills.
• Managing the Release and post release activities as per the project plan.

Environment: Ab Initio GDE 1.14, Co>operating System 2.14, Shell Scripting, SQL Server, My SQL Workbench, Autosys, Microsoft Project

Confidential

ETL Developer

Responsibilities:

• As an ETL Designer and Developer, was responsible for interaction with client and analysis of the specifications provided by the client.
• Participated in data model (Logical/Physical) discussions with Data Modelers and created both logical and physical data models.
• Developed number of graphs and Transformations to facilitate both regular and one time Loading of Data.
• Extensively used the Ab initio components like Reformat, Join, Sort, Rollup, Lookup to transform and load the data into target tables
• Tested the graphs by Unit testing, and Integration testing.
• Ensure adherence to quality procedures and coding standards
• Created wrapper scripts for scheduling jobs using Implementer
• Handled Implementation and Release activities.
• Provided 24x7 Production Support for ETL jobs for daily, Monthly schedule.

Environment: Ab Initio GDE 1.13, Co>operating System 2.13, Shell Scripting, My SQL, DB2, Oracle, Implementer

Confidential

Software Engineer

Responsibilities:

• Reported to the team lead and involved in Application Design, Coding and testing.
• Analysis of the specifications provided by the client
• Responsible for preparation of unit test plans as per the design of the application.
• Testing - unit testing & integration testing
• Coordinating with offshore team and onsite coordinator

Environment: SEU, RLU, DFU, PDM, SDA, ISDB, Smart400, Implementer, Mercury quality Centre, OS400, RPG, RPGLE, COBOL, CL, DB2400