SUMMARY

• 12 years of IT experience in the Data Analysis, Design, Development, Implementation and testing of Database/Data warehousing and Legacy applications for Financial, Manufacturing and Helath Care Insurance industries using Data Modeling, Data Extraction, Data Transformation, Data Loading and Data Analysis.
• Having strong Data Warehousing experience using Ab Initio Co>Op system 3.0.5/2.15/2.14/2.13/2.12 , GDE 3.0.5/1.15/1.14/1.13/1.12
• Over Nine years of experience in Ab Initio ETL tool, Data Mapping, Transformation and Loading in a complex, high - volume environment.
• Experience in using Teradata utilities like Tpump, BTEQ, MultiLoad, Fast-Load & Fast-Export
• Experience in Oracle (SQL/PLSQL) and Unix shell scripting
• Well versed with various Ab Initio parallelism techniques and implemented number of Ab Initio Graphs using Data parallelism and Multi File System (MFS) techniques
• Practical Experience with UNIX shell wrappers and Oracle PL/SQL programming.
• Involved in providing production support to various Ab Initio ETL jobs and Oracle Database programs.
• Actively Involved in Data Cleaning, and database design, Data Modeling
• Involved in design and implementation of Data Warehouses fact and dimensional tables (Star Schema)
• Highly adaptive to a team environment and proven ability to work in a fast paced teaming environment with excellent communication skills.

TECHNICAL SKILLS

Operating Systems: MS-DOS, Linux, UNIX, Windows 2000/NT/XP, IBM AIX

Relational Databases: Oracle 7x/8i/9i, SQL Server 6.0/7.0/2000 , SybaseSQL*Loader, Toad, DB2 UDB EEE, Teradata V2R5 (FastLoadMultiLoad, FastExport, TPump, BTEQ), MS Access.

ETL Tools: Ab Initio GDE 3.0/1.15/1.14/1.13/1.12 , Co>Op system 3.0.4/2.15/2.14/2.13/2.12 Conduct>It, Informatica Power Center 6.1 Informatica Power Mart 6.1. Informatica 8.6

Data/Object Modeling Tools: ERwin 4.0/4.5

OLAP Tools: Crystal Reports 8.0/8.5,Crystal Enterprise 8.0/8.5, Business Objects 5.1, Cognos Power Play 5.0, Cognos Impromptu 5.0

Programming Languages: VB 6.0, JAVA, JDBC, JSP, SERVLETS, SQL, PL/SQL, SQL Loader, Oracle Forms 4.5/6/6i, UNIX Shell Scripting, C and C++

Job Scheduler: Control - M, Autosys 4.5

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Sr. ETL Developer

Responsibilities:

• Working as an individual contributor for BASEL III enhancements in Ab Initio.
• Performance enhancements to the existing Ab Initio Graphs.
• Developing complex Ab Initio graphs for implementing Basel III rules.
• Data analysis on complex data sets for sourcing and reporting purposes.
• Interacting with Business Users for understanding complex business requirements.
• Preparing Technical Specification documents and supporting Testing teams on data validations.
• Developing UNIX, Autosys and Oracle scripts.
• Working on time bound deliverables with tough deadlines and complex requirements.
• Ensuring defect free Ab Initio code development.

Environment: Ab Initio 3.1.5, LINUX, Oracle 11g, Sybase, Autosys. SVN

Confidential, Herndon VA

Sr. ETL Developer/DW consultant

Responsibilities:

• Designed and deployedETL graphs by studying the business requirements from the functional design document and from the business users.
• Created mapping documents for the development of ETL and got it reviewed and approved by business.
• Extensively used Called Stored Procedures in Abinitio to call DB2 Mainframe Stored Procedures and load databases.
• Worked heavily on PLAN, PSET, PDL make the ETL Flow more dynamic, versatile and set dependencies.
• Worked with team of Abinitio Admins to setup Abinitio Console in the environment. Also scheduled jobs for the project in Op-console.
• Worked as Release Captain from ETL team to help create Abinitio Tags (Project Level tags or Object level tags) from EME air commands and moving the code from one environment to other.
• Comparing different versions of Code in EME with EME Graphical or textual Difference functionality.
• Phasing and check pointing were used in the graphs to avoid deadlock and recover completed stages of the graph, in case of a failure.
• Developed DML’s for data from different sources like flat files. Developed conditional DML’s for data that has Header, body and Trailers.
• Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Repository server and Informatica server to load data from flat files, SQL Server.
• Designed the mappings between sources (files and databases) to operational staging targets.
• Tuned graphs for better performance.

Environment: Ab initio Co>Op 2.14, GDE 1.15.3,Conduct>IT, UNIX SunOS, Oracle, Autosys R11, Informatica 8.6

Confidential, Warren, NJ

Sr.Ab Initio Developer/Lead

Responsibilities:

• Gather the requirements from business analysts.
• Design the and Developed ETL application
• Created technical specification document and mapping document.
• Responsible for High level Design and Detail design document for specific ETL processes
• Created Sand box, Sandbox Parameters and Graph Parameters
• Created dml’s form COBOL copybooks.
• Worked on tuning the Ab Initio graphs for better performance
• Worked on testing for data accuracy
• Designed and developed common component graphs for all the loading unloading
• Designed and developed generic graph for loading data feeds
• Creating packages and deploying to UAT and PROD Environments.
• Involved in end to end data validation by interacting with the business (UAT)
• Created Autosys JILS
• Responsible for Allocating tasks to the team members

Environment: Ab initio Co>Op 3.0.4, GDE 3.0.4, UNIX SunOS, Oracle, Autosys 4.0,SVN,Talend

Confidential, Columbus, OH

Sr.Ab Initio Developer

Responsibilities:

• Reconcile files to meet user requirements.
• Designed generic graph to load monthly data
• Migrated code test and production environments.
• Prepared job schedules.
• Creating load ready files using Ab Initio to load into database
• Responsible for support during UAT.
• Implementation plans preparation.

Environment: Ab initio Co>Op 2.13, GDE 1.13, UNIX Sun Solaris8,DB2EE, Autosys 4.0

Confidential, Berkeley Heights, NJ

Sr.Ab Initio Developer

Responsibilities:

• Design the ETL application following all ETL standards and architecture
• Involved in the design phase worked on the mapping document (technical specifications).
• Responsible for Detailed Low Level Design and Construction for specific ETL processes
• Develop detailed ETL specifications based on business requirements
• Set up the Sand box, Sandbox Parameters and Graph Parameters
• Check in/Checkout the project in/from to the EME - Maintaining the Version Control of source code
• Worked on testing and tuning the Ab Initio graphs for optimizing performance
• Designed and developed common component graphs for all the loading unloading
• Developed generic graphs to load and unload data, and process data.
• Creating packages and deploying to Test and prod Environments.
• Involved in end to end data validation by interacting with the business (UAT)
• Support during SIT, UAT phases
• Coordinating 5 Members team at both onsite and offshore. Effort estimation which required for each BAU (Business as Usual) and new project activities
• Allocate activities and tasks to the team members at onsite/Offshore.
• Guide the team and provide the solutions towards any problem faced by them

Environment: Ab initio Co>Op 2.15, GDE 1.15,Ab Initio EME,Condut>IT, UNIX Sun Solaris8,DB2EE, Oracle 10g, Teradata,ERWIN, Autosys 4.0, Cognos 8

Confidential, Warren, NJ

Sr.Ab Initio Developer/ETL Lead

Responsibilities:

• Developed number of Ab Initio Graphs based on business requirements using various Ab Initio Components
• Supported the Extraction from heterogeneous source systems, like Oracle, Sybase,excel spread sheets and internal and external flat files and building of the Transformations and Loading formatted data into the Multi-file and Serial files during the intermediate and the final stages of the Data Warehouse using Ab Initio
• Involved in creating Ab Initio DML's USING Ab Initio DB CONFIG, input Table components.
• Involved in developing UNIX Korn Shell wrappers to run various Ab Initio Scripts.
• Developed various Ab Initio Graphs for data cleansing using Ab Initio function like is valid, is defined, is error, string substring, string concat and other string * functions.
• Extensively used Enterprise Meta Environment (EME) for Versioning control and Dependency Analysis for Ab Initio graphs.
• Developed Ab Initio XFR s to derive new fields and solve various business requirements.
• Extensively used Ab Initio Co>Op commands like m ls, m wc, m rollback, m cp, m mkfs etc.
• Translate business-reporting requirements into data warehouse architectural designs and analyzing source and target data models and make necessary changes.
• Initial setup for Ab Initio like writing Unix Scripts. ex: .profile, .ssh etc.
• Used Ab Initio as ETL tool to pull data from source systems, cleanse, transform, and load data into databases.
• Check Out existing applications in Unix in order to perform the necessary modifications.
• FTP the New & Existing Ab Initio applications to the Local Host.
• Involved in Unit testing, Integration testing of New and existing Graphs.
• Created Ab Initio graphs with complex transformation rules using Ab Initio GDE . Extensively used components like partition by round robin, partition by key, rollup, sort, scan, dedupsort, reformat, join, merge, gather, and concatenate components.
• Used components like run program and runsql components to run UNIX and SQL commands in Ab initio. Used components like filter by expression, partition by expression, replicate, partition by key and sort components in different transformations.
• Extensively used Departition Components like Gather, Interleave in order to departition and Repartition the data from Multi File accordingly.
• Performing transformations of source data with Transform components like Join, Match Sorted, Dedup Sorted, Denormalize, Reformat, Filter-by-Expression.
• Performed complex queries involving large volumes of data. Wrote parallel queries to improve the performance.
• Used file management utilities like m touch, m ls, m env.
• Knowledge on continuous flows components.
• Developed Unix Korn shell wrapper scripts to accept parameters and scheduled the processes using Autosys.
• Developed UNIX shell scripts to automate file manipulation and data loading procedures.

Environment: Ab initio Co>Op 2.14, GDE 1.14,Ab Initio EME, UNIX AIX, Oracle 10g, ERWIN, UNIX Shell Script., Autosys 4.0 Eclipse 3.x, XML, SVN,Java1.4.X, Spring Framework

Confidential, Durham, NC

Ab Initio Consultant

Responsibilities:

• Worked with project managers and business analysts to recommend/develop solutions to business problems
• Created HLD and DLD documents for the ETL process.
• Responsible for analysis and design of ETL Ab Initio Graphs.
• Involved in understanding of the Specifications for Data Warehouse ETL Process and interacted with the designers and the end users for informational requirements
• Developed ETL Logic and Ab Initio graphs using Ab Initio GDE 1.14 and CO>OP 2.14
• Developed graphs for the ETL processes using Join, Rollup and Reformat transform components as well as Partition and Departition components extensively.
• Extensively used Ab Initio functions like is valid, is error, is defined, sting substring, srting concat and other string functions etc
• Extensively used the Ab Initio tool’s feature of Component, Data and Pipeline parallelism.
• Developed Unix Shell wrapper scripts
• Used file management utilities like m touch, m ls, m env.
• Extensively used Teradata data loading utilities like Fast Load, Multi Load, and Tpump
• Developed Strategies for Data Analysis and Data Validation
• Developed Unit and Detailed level Test Cases for testing Ab Initio Graphs.
• Unit and Integration testing of Applications.
• Write and Modify several application specific Config scripts in Unix in order to pass the Environment variables.
• Tuning of Ab Initio Graphs for better performance.
• Responsible for deduping and consolidating customer records from various sources to create master customer list.

Environment: Ab Initio>Operating System 2.14, GDE 1.14, Teradata 7.1.0,DB2, External files(COBOL), UNIX Shell scripts, UNIX, Control M, Visio, Test Director 8.1

Confidential, Richmond, VA

Ab Initio Consultant

Responsibilities:

• Actively involved in different phases of the project life cycle.
• Involved in understanding of the Specifications for Data Warehouse ETL Process and interacted with the designers and the end users for informational requirements.
• Analyze business requirements and developed metadata mappings and Ab Initio DML’s
• Developed Strategies for Data Analysis and Data Validation
• Used UNIX environment variables in various .ksh files, which comprises of specified locations to build Ab Initio Graphs.
• Responsible for writing shell scripts (wrapper) to schedule the jobs in development environment.
• Written complex SQLs joins, sub queries and correlated sub queries.
• Developed graphs for the ETL processes using Join, Rollup and Reformat transform components as well as Partition and Departition components extensively.
• Extensively used the Ab Initio tool’s feature of Component, Data and Pipeline parallelism.
• Creating load ready files using Ab Initio to load into database.
• Involved in Unit testing, System testing and debugging.
• Involved in dependency analysys for the applications
• Created tags and deployed to test and production environment as per the request
• Supporting the application and fixing the incidents or defects.
• Performing enhancement for the present and new application

Environment: Ab Initio Co>Operating System 2.13, GDE 1.13, Ab Initio EME,Unix Shell Scripting, Oracle 8i, Teradata V2R5 (FastLoad,MultiLoad, TPump, BTEQ), Oracle, Control-M,Visio, DB2 UDB 7.8, Oracle 9i/ 8i, SQL, PL/SQL, Erwin 3.5.2.

Confidential, Boca Raton, FL

ETL Developer

Responsibilities:

• Extracted Data from different source systems like Oracle, Sybase and Flat files.
• Created Data Flow Process diagrams in Ab Initio GDE for data extraction, transformation, and loading.
• Generated Configuration files, DML files, XFR files.
• Developed various AbInitio Graphs for data cleansing using AbInitio function like is valid, is error, is defined, string * functions .
• Developed graphs with complicated functionality using multistage components.
• Extensively used Transform Components like Aggregate, Match sorted, Join, Denormalize sorted, Reformat, Rollup and Scan Components.
• Implemented various parallelism techniques like component, pipeline and data parallelism in Ab Initio for ETL process for Data warehouse.
• Extensively used Partitioning Components like Broad Cast, partition by key, partition by Range, partition by round robin, partition by expression and Departition components like Concatenate, Gather and Merge.
• Created many large Ab Initio graphs with complex transformation rules using Ab Initio GDE
• Worked on improving the performance of Ab Initio graphs by using component lookup instead of Join
• Create Summary tables using Rollup, Scan & Aggregate.
• Involved in monitoring Ab Initio jobs using AB report options
• Extensively used validate components for unit testing and integration testing.
• Created Ab Initio Data flow processes for loading data into Data marts.
• Involved in the preparation of documentation for ETL Ab Initio standards, procedures and naming conventions.
• Created Ab Initio scripts for data extraction transformation, validation and loading.
• Used Unix environment variables in various .ksh files.

Environment: Ab Initio Co>Operating System 2.12, GDE 1.12, Unix Shell Scripting, SunOS 5.8,WS-FTP95,Autosys,Oracle 9i/ 8i, SQL,MY SQL,SYBASE, Teradata V2R5 (FastLoad,MultiLoad, TPump, BTEQ),Microsoft Office., Informatica 6.2