PROFESSIONAL SUMMARY

• Over 9 years of total IT experience in the Requirements Analysis, Data Analysis, Application Development, Implementations and Testing of Data warehousing business systems.
• Solid experience in developing Ab Initio applications for Extraction, Transformation, and Loading into Data Warehouse/Data mart. Used Ab - Initio with Very Large Database Systems (VLDB) that are Massively Parallel (MPP) by utilizing the concepts of Multifiles, Partitioning and Departitioning components etc and fine tune the applications for optimal performance.
• Expertise in all components in the GDE of Ab Initio for creating, executing, testing and maintaining graphs in Ab Initio.
• Well versed with Ab initio parallelism techniques and worked on Ab Initio Graphs using Data parallelism and Multifile System(MFS) techniques.
• Experience using various Ab Initio component like Transform, Datasets, Sort, Partition, De-partition, FTP and other miscellaneous component groups. Involved in Unit testing of Ab Initio code in pre-production environment.
• Worked on Ab Initio graphs for various Data warehouse and Data Mart ETL processes.
• Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Responsible for Debugging and Troubleshooting Ab initio graphs.
• Proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension surrogate key generation.
• Unique ability to understand and 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.
• Have good communication skills, comfortable in fast paced challenging environments.
• Unique ability to understand and 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.

TECHNICAL SKILLS

ETL: Ab Initio GDE 3.1/3.2, Co-Operating System 3.14, 3.15

Databases: Oracle 9i/10g, DB2, Teradata

Languages: PL/SQL

Operating Systems: Windows 98/2000/XP, UNIX

Languages: C, C ++, Shell Scripting, SQL

Since 20 Feb’17 till date: Globeop Financial Services Private Limited

PROFESSIONAL EXPERIENCE:

Confidential

Abinitio Developer

Responsibilities:

• Worked closely with the Business Analysts and Application Leads for Requirement study, Analysis and design of the application.
• Developed AB Initio real time application capable of processing real time XML messages from upstream Java applications and loading oracle databases.
• Created low level design documents for various application processes.
• Developed Ab Initio graphs that transfer data from flat files to oracle data warehouse
• Extensively worked on most commonly used components to complex components like Scan, Rollup, Assign Keys, Partition, Departition, Sort, Join, Reformat components etc.
• Used Ab Initio’s Multifile systems for improving heavy data loads.
• Migration of Ab Initio Objects from development to UAT environment and prepared appropriate documentation for code move to UAT and production environment.
• Replicate operational table into staging tables, transform and load data into warehouse tables using Ab Initio GDE.
• Prepared Unit test plan, Unit test release for developed Graphs by using mapping documents.
• Modified Ab Initio Graphs according to the new modifications.
• Involved in end to end data validation by interacting with the business (UAT)

Environment: Ab Initio, Oracle 11g, IBM DB2, Autosys.

Confidential, Atlanta, GA

Abinitio Developer

Responsibilities:

• Metadata mapping from legacy source system to target database fields and created Ab Initio DMLs.
• Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts.
• Developed different types of Ab Initio Graphs based on business requirements using various Ab Initio Components such as Partition, reformat, rollup, join, scan, normalize, gather, sort, dedup sorted etc.
• Developed Complex Ab Initio XFRs to derive new fields and solve various business requirements.
• Implemented Lookups, lookup local, In-Memory Joins and rollups to speed up various Ab Initio Graphs.
• Created various Ab Initio Multi File Systems (MFS) to run graphs in parallel.
• Developed Data transformation, loading and extraction programs using Ab Initio ETL tool.
• Validating graphs, Performed unit testing, regression testing and integration testing.

Environment: Ab Initio, Oracle, DB2, TOAD, Autosys.

Confidential

Abinitio Developer

Responsibilities:

• Responsible for requirement gathering, analysis and designing of the Ab initio graphs
• Designing and development of complex generic and conditionalized Ab initio graphs involving complex business logics.
• Optimizing performance by analyzing, ETL workflow and query patterns.
• Development of UNIX shell scripts
• Involve in Unit testing and documented test cases
• Involved in tracking and resolving the issues.
• Reviewing and optimizing the code to enforce standards
• Preparation of ETL detailed design document and reusable process related documents
• Dealing with processing logic, job scheduling or performance issues
• Participating in peer-review process of the code-fix for the quality of deliverables.
• Responsible for necessary documentation related to the Ab initio project.
• Developed Ab-initio graphs both generic and custom to accomplish the various tasks of the applications like time and space reduction
• Worked extensively in data-staging processes, Retail processes, customer outbound processes, database load processes and job scheduling
• Single POC for critical production issues and development projects struggling to meet committed timelines

Environment: Ab initio 3.0.2, Teradata, UNIX, IBM Tivoli

Confidential

Abinitio Developer

Responsibilities:

• Analyzing the requirement sent by the Leads and developing Ab Initio graphs
• Work products include Ab Initio graphs and associated code-level work products such as DML, worked using EME
• Involved in build from end to end.
• Developed the transformation graphs based on business requirements.
• Used Phasing and check pointing in the graphs to avoid deadlock and recover completed stages of the graph, in case of a failure.
• Designed and developed Ab Initio graphs, using different components viz. Reformat, rollups, scan, and Join.
• Worked with departition components Gather, Merge which will be used for adding the files which is done partition for fast process of data files.
• Designed appropriate unit-level testing plan and the managed the review process for the Ab Initio deliverables

Environment: Abinitio 3.0.2, Oracle, UNIX, Autosys Scheduler

Confidential, Hartford, CT

Abinitio Developer

Responsibilities:

• Developed a project for reporting client’s data to external governmental agencies from the client’s business warehouse by closely working with client and offshore team from requirement gathering till implementation.
• Developed a prototype of a premium data mart for client to enhance data visibility to end users.
• Provided production support of ETL applications in the commercial Lines Warehouse System.
• Developed tools and utilities to add value to client applications.
• Improve the performance of Ab Initio graphs by using Ab Initio performance techniques.
• Modifying existing graphs for error fixing or performance improvement and developing new ones for adding new functionality.
• Used EME to check-in /checkout the graphs.
• Testing - unit testing, integration testing and Regression Testing.

Environment: Abinitio 2.14, Teradata 12, UNIX, Autosys, Datastage

Confidential

Abinitio Developer

Responsibilities:

• Provided Enhancements, Production Support of various ETL applications in the Personal Lines Warehouse System. Suggesting and implementing enhancements for existing ETL applications. Developing tools and utilities to add value to client applications.
• Gathered business & functional requirements
• Involved in High Level Design and Low Level Design
• Extensively used Abinitio ETL tool in designing and implementing Extract, Transformation, and Load processes. Different Abinitio components are used effectively to develop and maintain the database. Worked with Multi files system and Partition Components to fine-tune the Graphs.
• Involved in development of UNIX Scripting
• Responsible for functional & standard code review of Abinitio and UNIX code.
• Involved in Performance Tuning of Abinitio graph.
• Responsible for defect fixes with rigorous testing.

Environment: Abinitio 1.14, Abinitio 1.15, Teradata 12, UNIX, Autosys