SUMMARY

• 9+ yearsof experience in Software development.
• Able to work independently as well as in a team environment.
• Involved in all stages of the Software Development Life Cycle (SDLC) right from requirements gathering till the deployment.
• Strong experiences in UNIX shell scripting.Worked on large Data warehouses with databases - Teradataand DB2.
• Good Experience in developing and supporting ETL Applications usingAbinitio.
• Involved in Coding, Client Side Validations, designing required Database tables and testing. Created tables and views in the database. Worked on creation of various Test plans and Test data validation
• Extensively used AbInitio-EME data store/sandbox for version control, code promotion, and impact analysis.
• Well versed with various Ab Initio parallelism techniques and implemented Ab Initio Graphs using Data parallelism and Multi File System (MFS) techniques.
• Developed various UNIX shell wrappers to run various Ab Initio jobs.
• Strong knowledge in Dimensional modeling like Star Schema and Snowflake Schema.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing using Ab Initio.
• Experience in configuring and monitoring jobs in Control-M scheduler.
• Experience in interacting with Business users to analyze the Business Process requirements.
• Excellent interpersonal, communication and presentation skills along with time management skills.
• Ability to quickly adapt to different project environments and an excellent team member.

TECHNICAL SKILLS

ETL Tools: Ab Initio GDE 3.1

Database: Teradata 13 and DB2

Programming Language: UNIX Shell Scripting, SQL, PL/SQL, VB, C.

Job Schedulers: Control-M,CA7

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

AbInitio Consultant

Responsibilities:

• Understanding the business requirements, developing design specifications for enterprise applications using Ab Initio and db2 database.
• Design, develop and Unit test Ab Initio graphs using GDE for Extraction, Transformation and
• Loading of data from source to target.
• Design, develop and Unit test SQL views using db2 SQL to load data from source to target.
• Create test cases and perform unit testing for the Ab Initio graphs and SQL views. Document Unit testing.
• Work in the UNIX environment using Shell Scripts for FTP, SFTP processes.
• Support SIT and DAT testing which includes writing test cases.
• Problem solving skills for different Data Quality issues raised by customer.
• Solving day to day incidents, so that data for different applications will be processed without any delay.
• Log and resolve defects in the roll out phase.
• Document all production applications and resolve all application issues.
• Create CA7 schedules for automation.

Environment: Ab Initio, DB2, UNIX, CA7 and IBM IT-Portal.

Confidential, Plano, TX

Senior AbInitio Consultant

Responsibilities:

• Design and development of ETL process using Ab Initio as the tool.
• Define & build the data transmission mechanism for receiving and sending data into/from the repository (EME).
• Establish process to consolidate data received from different external systems into therepository.
• Created Ab Initio graphs to build business logic to extract data from different external systems, validate, transform and load data to Teradata.
• Used Enterprise Meta Environment (EME) for version control.
• Have created Plan>It jobs that consists of Ab Initio graphs, custom scripts, and third-party programs and made the systems to run as expected and recoverably.
• Involved in Ab Initio Graph Design and Performance tuning to Load graph process.
• Implemented a multi-file system that is composed of individual files on different nodes that arepartitioned and stored in distributed directories.
• Unit testing and updating currently implemented graphs, logic, and scripts.
• Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts.

Environment: Abinitio, Teradata, UNIX, Control-M, HP Service Manager.

Confidential, Plano, TX

Senior AbInitio Consultant

Responsibilities:

• I have worked on full life cycle of this project.
• I have designed and developed Ab Initio graphs, created psets, plans and user defined functions using GDE as per the client requirement.
• Involved in code review, performance tuning and optimization of graphs.
• Extensively used EME for Version Control and Code Promotion.
• Have created Unix shell scripts using SSH tool Putty to automate the various processes.
• Have used scheduling tool Control-M to create the jobs and schedules, also used the same for setting up the jobs for execution.
• Done Impact Analysis and time estimates for the enhancement changes as per business change requests.
• I was also responsible for creating various project related documents such as Impact Analysis, High and Detailed level design, unit test plan, unit test results, component integration test plan, system test plan and Service Handover Documents
• Mentoring to all new joiners with in the Team.

Environment: Abinitio, Teradata, UNIX, Control-M, HP Service Manager

Confidential, Plano, TX

Support Analyst

Responsibilities:

• Provide 24*7 supports to Star2 EDW application. Participate in on call rotation every other week and also provide support on the weekends.
• Provided support for the loads by monitoring the daily runs and resolved issues that came up during the loads
• Analyzed and Resolved Production reporting issues brought forth by the business users.
• Worked on Design/Code and testing for enhancement to the application.
• Worked on production break fixes to bring the system back up with in defined SLA's.
• Co-ordinate with business users and other source application teams during system outages and maintenance.

Environment: Teradata, UNIX, Abinitio, Informatica.

Confidential

Developer

Responsibilities:

• Involved in Coding and Testing of ETL Objects in AbInitio.
• Developed Bteq and Mload scripts which are used to load Production and Test Environments.
• Providing support and maintenance for Production and Test Environments.
• Jobs monitoring in both PROD and Test environments
• Created tables and views in the database. Worked on creation of various Test plans and Test data validation.

Environment: Ab Initio, Teradata, UNIX

Confidential

Developer

Responsibilities:

• I was involved in migration, Installing and configuring Business Objects XI 3.1, Testing and deploying of BOXI3.1.

Environment: BO.

Confidential

Developer

Responsibilities:

• I was involved in Coding, UI Designing, and Client Side Validations, designing required Database tables and stored procedures and testing
• Involved in the development of technical design document and reports using WebFOCUS Reporting tool.

Environment: WebFOCUS