SUMMARY

• Over 7+ Years of experience in ETL process using Ab initio, Ab initio Co>operating system 1.15, Ab initio GDE 2.15, GDE 3.1 and Enterprise Metadata Environment.
• 1+ Years of experience in Development as a PHP WAMP Windows, Apache, MySQL and PHP and LAMP Linux, Apache, MySQL and PHP developer.
• Involved in creating detail data flows with source and target mappings and convert data requirements into low level design templates.
• Designed and deployed well - tuned AbInitiographs (Generic and Custom) for unix environment.
• Experienced in developing UNIX shell wrapper scripts to run Ab Initio graphs. Practical experience with working on multiple environments like production, development, testing.
• Sound knowledge of Finance Domain.
• Hands on Experience using various Databases such as Oracle, Netezzas, DB2
• Thorough understanding of the issues involved in mappings, development and integration of a software product.
• Experience with Ab Initio Co-Operating System, application tuning, and debugging strategies.
• Experienced in software analysis, Requirements Management, Quality Assurance, Modeling and Configuration Management.
• Ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem solving skills.
• Experience in requirement analysis, client interaction, development, testing and security.
• Having Good Understanding of Dimensional modelling like star Schema, Snow Flake Schemas.
• Familiar with UNIX Commands.
• Strong experience of Agile project methodology.
• Strongly self-driven, keen to learn,ability to work independently and adopt new technologies and process.

TECHNICAL SKILLS

Business Domain: Banking &Financial services

Operating System: Windows XP/ NT, UNIX, Linux, MS DOS.

ETL Tool: Ab Initio 3.X, Talend

Reporting Tool: Tableau

Programming Languages: C, C++, PHP4&5

Scripting Languages: Shell scripting

Database: Oracle 9i with 10g features, MySQL4&5, DB2, SQL

Web Technologies: HTML, CSS, JavaScript, PHP, Joomla, Smarty, PERL.

Environment: Toad, Control-M

Testing Tools: Win Runner, Load runner, Test Director and QTP

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Ab initioTechnical Lead/CSM

Responsibilities:

• Met with business/user groups to understand the business process and gather requirements.
• Lead ETL (Abinitio /Unix) Designer, developer, onsite coordinator.
• Participated in all stages of project grouped into various stories, project being agile.
• Developed, tested and reviewed complex Ab Initio graphs, sub-graphs, DML, Pset, XFR, deployed scripts, DBC files for connectivity, create Package and exports.
• Responsible for Requirements gathering, Technical System Design, Development, Testing, Code Review, Code migration, Supporting System testing, Job scheduling, Offshore Coordination, prepared source to target mapping.
• Improved performance of Ab Initio graphs by using various Ab Initio performance techniques like using lookups in memory joins and rollups to speed up various Ab Initio graphs.
• Extracted data from various sources like databases, delimited flat files and XMLs.
• Developed Ab Initio graphs to load the data into the DB2
• Prepare code documentation in support of program development.
• Used AIR commands to do dependency analysis for all ABI objects.
• Involved in Unit Testing the Ab Initio graphs and quality assurance and bug fixing.
• Used Toad to verify the counts and results of the graphs.
• Used Scheduler to setup jobs and monitor.

Environment: Abinitio 2.15, DB2, Shell scripting, UNIX

Confidential

Ab initio Technical Lead

Responsibilities:

• Participated in all stages of project grouped into various stories, project being agile.
• Developed Ab Initio graphs to load data into fact tables and update dimensional tables.
• Responsible for Requirements gathering, Technical System Design, Development, Testing, Code Review, Code migration, Supporting System testing, Job scheduling, Offshore Coordination, prepared source to target mapping.
• Developed Unix Wrapper scripts to run multiple Ab initio graphs together in a sequence based on requirements.
• Used Ab Initio EME for Check-In/Check-Outs and Version control.
• Documenting of complete Ab Initio Graphs.
• Involved in unit testing of the Ab Initio graphs.
• Responsible for setting up Production Jobs and created Production Support Document.
• Prepared the Detailed Design Document for the all the modules required for development.
• Used Toad to verify the counts and results of the graphs.
• Used Scheduler to setup jobs and monitor.

Environment: Abinitio 2.15, DB2, Shell scripting, UNIX

Confidential

Ab initioTechnical Lead

Responsibilities:

• Gather the new requirements for the new market/agency.
• UNIX shell scripts, Abinitio V2-15
• Developed Generic graphs for data cleansing, data validation and data transformation.
• Create new ETL Ab Initio graphs to handle the new requirements.
• Worked with Departition Components like Concatenate, Gather, Interleave and Merge in order to departition and repartition data from Multifiles accordingly.
• Worked with Partition Components like Partition-by-key, Partition-by-expression, Partition-by-Round Robin to partition the data from serial file.
• Extensively used Data base components such as Run-Sql, Multi Update table, update table and join with DB.
• Written wrapper scripts to automate batch jobs and also provided production support when needed.
• Analyze functional requirements, mapping documents and assist in problem solving.
• Prepare code documentation in support of program development.
• Used Toad to verify the counts and results of the graphs.
• Used Scheduler to setup jobs and monitor.

Environment: Abinitio 2.15, DB2, Shell scripting, UNIX

Confidential

Ab initio Technical Lead

Responsibilities:

• Coding, testing, modifying and documenting of Ab Initio Graphs.
• Taking knowledge transition from the client team on understanding the client requirements translating them into code.
• Analyze functional requirements, mapping documents and assist in problem solving.
• Prepare code documentation in support of program development.
• Assigned in Data Quality, Source Systems Analysis and Performance Tuning.
• Involved to the supporting and enhancement.
• Developed UNIX shell wrapper scripts for executing graphs & jobs using Ab Initio procedures.
• Implemented business rules using Ab Initio procedures.
• Developed the graphs using different components of Ab Initio for the reporting solution.
• Tuning the Ab Initio graphs for increasing the performance.

Environment: Abinitio 2.15, DB2, Shell scripting, UNIX

Confidential

Senior Programmer

Responsibilities:

• Maintained and upgraded current and future software features for specific projects.
• Involved to the supporting and enhancement.
• Done Impact Analysis on the existing graphs and identified the changesrequired.
• Involved in CMR and Code promotion.
• Process and Transform delta feeds of customer data, which comes in daily.
• Involved in preparation of the Testing Strategy Document, Test Scripts.
• Migrated scripts from DEV to SIT and UAT environment to test & validate data.
• Worked with project team in optimizing and tuning of SQL statements, used phases/checkpoints to avoid deadlocks to improve the efficiency.
• Involved in estimation of project timelines and completed all the tasks on time.

Environment: Abinitio 2.15, DB2, Shell scripting, UNIX

Confidential

Programmer

Responsibilities:

• Designed, developed Ab Initio graphs for Loading into Data store.
• Translating the logical data model in Erwin to a physical database design, database construction, design optimization and functional testing.
• Created sandbox and edited sandbox parameter according to repository.
• Implemented Data Parallelism through graphs, which deals with data, divided into segments and operates on each segment simultaneously through the Ab Initio partition components to segment data.
• Developed parameterized graphs using formal parameters.
• Developed Ab Initio graphs to unload required data from database.

Environment: Abinitio 2.15, DB2, Shell scripting, UNIX

Confidential

Software Programmer

Responsibilities:

• Coding, testing, modifying and documenting of Ab Initio Graphs.
• Work in a sandbox environment while extensively interacting with an EME to maintain version control on objects, check in and check out.
• Analyze functional requirements, mapping documents and assist in problem resolve.
• Prepare code documentation in support of program development, including detailed design documents, unit test specifications and interface specifications.
• Unit testing of new and existing Graphs.