PROFESSIONAL SUMMARY:

• Closely Mentored by Ab Initio Consultants to deliver high quality, high performance ETL Applications.
• In - depth and comprehensive knowledge and experience in full life-cycle for enterprise data warehouse including business analysis, data model, source-target mapping, ETL implementation, BI report, and production support.
• Solid data knowledge and data application experience in diversified business areas, such as customer, operating, planning, and revenue management.
• Hand-on ETL architecture experience in design and implement ETL complex system with Ab Initio and AIX Unix platform, ETL system and data file archive, backup and restore strategies, and ETL system maintain, performance benchmark, tune-up, and upgrade.
• Proficient in Shell Script and Perl programming or scripting in UNIX environment.
• Independently completed and involved projects with Ab Initio ETL tool.
• Experienced in developing complex Ab Initio graphs in data warehouse environment using Multi File System (MFS) to take advantage of parallelism.
• An Excellent resource that can adjust into a fast paced, time critical project who can deliver bottom line results with superb quality and performance.
• Over 5 years of Information Technology experience in software development, designing and implementing with major focus on Data Warehousing, Business Intelligence and Database Applications.
• 5 years of experience in RDBMS like Oracle
• Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema
• Used Conduct>IT for job scheduling wherein created several plans using resources.
• Very Good Programming skills using UNIX/Shell Scripts and PL/SQL for Automation of ETL process.
• Team oriented and ability to understand and adapt to new technologies and environments faster. Good at analysis and troubleshooting.
• Excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

Data Warehousing: Ab Initio (GDE 3.0.5.3/1.15/1.14 /1.13/1.12, Co>Op 3.1.2.5/2.15/2.14/2.13/2.12 ), Informatica 8i/7i

Reporting Tools: Business Objects 6.5/XIR2, Cognos 8.0 Series

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and Dimension Tables, Pivot Tables

Testing Tools: Mercury QTP, Mercury Quality Center

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server 6.5/7.0/2000/2005/2008, Sybase, Teradata, MS Access 2003

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, Java, J2EE

PROFESSIONAL EXPERIENCE:

Confidential, Franklin Lakes, NJ

Ab Initio Developer

Responsibilities:

• Worked with project manager and ETL developers for Pharmacy claims management process: as technical lead, designed all ETL procedures including job flow, Ab Initio graph standard, data integration, ETL test plan and data archive, backup, and recover strategies, tracked the projects status, and audited the production promotions.
• Worked as one of the technical lead to handle claims management process
• Worked on claims processing, pharmacy contracts and benefit management.
• Involved with pre-live data and environment for testing the claims and work with the rejects.
• Created graphs to test claims for rejection and support system to handle it.
• Production deployment activities.
• Unit testing, System testing, Integration testing and Peer review of code.
• Participating in the code review calls with the SME and business.
• Creating Technical design documents which are used as the ETL specifications.
• Working with production support team to handle tickets on claims reject
• Guiding offshore team on development and domain knowledge.
• Participating in the offshore call for understanding and review of the technical specification document.
• Participating in the daily status call with the clients

Environment: Ab Initio (GDE 3.0.5.3/1.15/1.14, Co>OS 3.1.2.5/2.14/2.15 ), Teradata, Shell scripts, Perl, UNIX, FileZilla

Confidential, Bannockburn, IL

Ab Initio Developer

Responsibilities:

• Created ETL Production Support System, which provides common processes and template jobs and tracks all production support steps.
• Throughout involved in Ab Initio upgrade from V2.15 to V 3.x
• Converted the Unix shell script to Ab initio plan
• Involved in enhancement and testing the new ab initio environment.
• Designed and deployed the Extract, Transform and Load process, using Ab Initio by studying the business requirements from the business users and interacting with business analysts.
• Involved in setting up of sandboxes and maintaining sandbox parameters.
• Generated DB configuration files for source and target tables.
• Worked with source files and generated dml’s using Ab initio utilities.
• Developed generic graphs for taking care of repeating activities.
• Used Ab Initio functions for improving performance of Ab Initio graphs.
• Used Debuggers and Watchers to test and examine the behavior of the components.
• Involved in code review and performance tuning of ETL graphs.

Environment: Ab Initio (GDE 3.0.5.3/1.15/1.14, Co>OS 3.1.2.5/2.14/2.15 ), Oracle 10g, Shell scripts, Tidal, SQL, PL-SQL, Ms-Office, Perl, UNIX, Toad, FileZilla

Confidential, Deerfield, IL

Ab Initio Developer

Responsibilities:

• Used Ab-Initio to Extract data from source systems, cleanse, Transform, and Load data into databases.
• Responsible for creating Ab Initio graphs for landing the validated source data received from various customers in multifiles and creating Lookups for cross .
• Designed and developed Ab Initio graphs for transforming various data feed to fit into dimensional model of the target, using complex components.
• Also used Ab Initio Partition and Departition components to enable parallelism.
• Used UNIX Environment variables in various .ksh files, which comprises of specified locations to build Ab Initio Graphs.
• Responsible for code review and performance tuning of ab initio graphs designed by various developers.
• Performing transformations of source data with Transform components like Join, Dedup, Sort, Reformat, Filter-by-Expression, Rollup.
• Implemented Lookups, In-memory Joins and Rollups to speed various Ab Initio graphs.
• Wide usage of Lookup files while getting data from multiple sources and size of data is limited.
• Modified the AB INITIO components parameters, utilize data parallelism and thereby improve the overall performance to fine tune the execution times.
• Debugging Ab Initio graphs using Flow Watchers.
• Responsible for writing shell scripts (wrapper) to schedule the jobs in the development environment.
• Developed UNIX scripts and Ab Initio components.
• Used sub graphs and parallel execution features using multifile systems.
• Tuned graphs for better performance. Created functional and unit test cases and executed the same. Also, created a production support document, High level design and Detail design documents
• Wrote the UNIX Shell scripts to run the graphs after receiving the files from different regions and also to generate the data load reports and Error Handling reports to get the data load statistics like, how many records read from the input file, no of rejected records, no of error records and the reason to reject the record, no of records that are inserted and updated in the database.
• Wrote the Stored procedures using PL/SQL.
• Worked on the EME which used as the version control tool.
• Involved in unit testing, integration testing and troubleshooting.
• Involved in documentation and code review.
• Provided post production support.

Environment: Ab Initio (GDE 1.15/1.14, Co>OS 2.14/2.15), Oracle 10g, Shell scripts, ESP, SQL, PL-SQL, Ms-Office, Windows NT and UNIX

Confidential, Deerfield, IL

Ab Initio Developer

Responsibilities:

• After understanding the functional requirements wrote the Technical design documents which are used as the ETL specifications.
• By using the ETL tool Ab initio, extracted the data from source XML’s and the flat files received from the systems based on the pre-defined mappings.
• Designed and developed the Ab initio graphs for the ETL process to load the data into the Oracle database tables.
• Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DMLs.
• Extensively used Partitioning components like Partition by Expression, Partition by Round Robin and Partition by Key to increase data parallelism.
• Used EME for Version Control
• Developed SQL queries for cross verification of data again ETL Transformation rules.
• Worked in EME environment for source code control.
• Wrote the Test cases to perform the unit testing and Integration testing to verify the data and the complete ETL process.
• Worked on Performance tuning of the Ab Initio graphs.
• Performed the Level I support Level II production support.
• Used the Scheduling tool Autosys to run the jobs automatically. Wrote the Autosys scripts and installed them and scheduled the jobs.
• Worked with Infrastructure team to migrate the code into different environments and for the code review.
• Wrote the UNIX Shell scripts to run the graphs after receiving the files from different regions and also to generate the data load reports and Error Handling reports to get the data load statistics like, how many records read from the input file, no of rejected records, no of error records and the reason to reject the record, no of records that are inserted and updated in the database.
• Wrote the Stored procedures using PL/SQL.
• Worked on the EME which used as the version control tool.

Environment: Ab Initio (GDE 1.15/1.14, Co>OS 2.14/2.15), Oracle 9i/10g, EME, SQL, PL/SQL, SmartStream, UNIX, Windows 2000/XP, Autosys, Oracle 10g, Shell Scripting, QC 9.2

Confidential

Ab Initio Developer

Responsibilities:

• Involved in understanding the requirements of the end Users/Business Analysts and developed detail design, strategies for ETL processes.
• After understanding the functional requirements wrote the Technical design documents which are used as the ETL specifications.
• Create validation rules to maintain consistent data to maintain data quality in the system.
• Designed and developed the Ab initio graphs for the ETL process to load the data into the Oracle database tables.
• Used EME for Version Control
• Designed, developed and unit tested Ab Initio graphs using GDE for Extraction, Transformation and Loading of data from source to target.
• Extensively used Database and Dataset components like Input file, Input table, and Output table and transform components like Join, Rollup, Scan, Filter by expression, Reformat and other components like Merge, Lookup, Input/Output table, Dedup and Sort
• Reframed the deployment process and developed scripts to automate the deployment process.
• Involved in developing UNIX Shell wrappers to run various Ab Initio Scripts.
• Create the parameterized graph.
• Tuned graphs for better performance. Created functional and unit test cases and executed the same. Also, created a production support document, High level design and Detail design documents
• Wrote the UNIX Shell scripts to run the graphs after receiving the files from different regions and also to generate the data load reports and Error Handling reports to get the data load statistics like, how many records read from the input file, no of rejected records, no of error records and the reason to reject the record, no of records that are inserted and updated in the database.
• Wrote the Stored procedures using PL/SQL.
• Worked on the EME which used as the version control tool.
• Involved in unit testing, integration testing and troubleshooting.
• Involved in documentation and code review.
• Provided post production support.

Environment: Ab Initio (GDE 1.13, Co>Op 2.13), Oracle 8i/9i, XML Files, Flat Files,, Shell Scripting, Sun Solaris 8, EME, Business Objects 5.0