SUMMARY

• Over 7 plus years of experience in full Software Development Life Cycle (SDLC) analysis, design, development, testing, implementation and maintenance in data warehousing environment.
• Over 5 plus years of experience in implementing Datawarehouse and data base applications with Ab Initio, Informatica ETL in addition with data modeling and reporting tools on Teradata, Oracle, DB2, Sybase RDBMS.
• Highly experienced in ETL tool Ab - Initio using GDE Designer.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables with data modeling tools ERWIN and Sybase power designer.
• Very good understanding of Teradata’s MPP architecture such as Shared Nothing, Nodes, AMPs, BYNET, Partitioning, Primary Indexes etc. Extensively used different features of Teradata such as BTEQ, Fastload, Multiload, SQL Assistant, DDL and DML commands.
• Well versed with Ab Initio parallelism techniques and implemented Ab Initio Graphs using Data parallelism, MFS techniques, Continuous Flows, Component folding and PDL features.
• Involved in using EME version control.
• Expertise in various Ab Initio component groups like Partition, De-partition, Database, Datasets, Transform, FTP, Sort and Miscellaneous.
• Very good experience in Oracle database application development using Oracle 10g/9i/8i/x, SQL, PL/SQL, SQL*Loader. Strong experience in writing SQL, PL/SQL-Stored Procedures, Functions and Triggers.
• Worked extensively on Data profiling for understanding mapping document and data.
• Expertise in Data Profiler for Data Quality Analysis, EME for Dependency Analysis and version control.
• Hands on Experience with Ab Initio Trillium Components for standardization, enrichment of Name and Address and also used for Matching Results.
• Created various adhoc reports using SAS. Extensively used DB access to Teradata and Oracle 9i using SAS SQL pass-thru facility. Extensively used the following SAS features: data, data null, sort, merge, append, transpose, tabulate, freq, means, summary, contents, copy, print, datasets, compare, report, format, proc sql, macros, symput, symget, includes and ods to create various SAS reports.
• Provided Production support and flexible in managing multiple projects.
• Extensive experiences in UNIX shell scripting to automate and schedule the jobs.

TECHNICAL SKILLS

ETL Tools: Ab Initio (GDE 1.15/3.0 Co>Operating system 2.15/3.0), EME, Data Profiler, Informatica PowerCenter 8.5/8.1/7.1.

BI Tools: SAS 9, Business Objects 6.0, Cognos

Data Modeling: Erwin, Sybase power Designer 12

RDBMS: Teradata V2R12/6/5, Oracle 8.0/8i/9i/10g, DB2 (Main Frames), MS Access, MS SQL Server.

Languages: C, SQL, PL/SQL, SAS 9, PERL Scripting and Korn Shell Scripting.

Operating Systems: MS-DOS, HP UNIX, Windows 95/98/2000/NT and Sun OS.

Scheduling and others: UC4, Control M, Clear Quest, Clear Case, SVN

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr. Abinitio Developer

Environment: Ab Initio (GDE 3.0, Co>operating system 3.0), Oracle 10g, Teradata V12, Teradata SQL Assistant, SQL, PL/SQL, Shell Scripts, TOAD, Clear Quest, DB2, Erwin.

Responsibilities:

• Understanding the specifications for Data Warehouse ETL Processes and interacting with the business analysts and end users to understand system requirements
• Working closely with Business Analysts to interpret the Business rules and make necessary modifications to process the data for accuracy.
• Performed Data Analysis and created High Level and Technical Design documents based on system requirements.
• Worked on projects which were migrated from old CSA legacy system to new DDE ETL environment. As part of this migration project, had to do reverse engineering in understanding complex data transformations.
• Worked on Credit Card Statements project in tuning the existing code which was running for about 6 hours. Involved in tuning the application by making changes like removing unnecessary sort components, modified the process so that it will run in parallel(component and data parallel) from end-end.
• Modified the Ab Initio graphs to utilize data parallelism and thereby improve the overall performance to fine-tune the execution times.
• Worked in analyzing production defects and suggesting solution to the defects.
• Involved in code reviews, system test case reviews, test case execution result reviews for the projects I designed.
• Developed graphs for the ETL processes using Join, Rollup, Scan, Normalize, Denormalize and Reformat transform components as well as Partition and Departition components extensively.
• Used Data Profiler not only for collecting the statistics, but performing analysis across and within data sets for dependencies and correlation; as well as being able to generate transformation code to use for validation
• Implemented Lookup’s, lookup local, In-Memory Joins and rollup’s to speed up various Ab Initio Graphs.
• Quickly adapted to Capital One Agile methodology (3 week sprints) and actively participated in Sprint Planning sessions.
• Extensively used Ab Initio web interface for data lineage breakdowns (Dependency and Impact analysis).
• Actively involved in production support of Internet Analytics ETL (Ab Initio) and Reporting applications (Business Objects).
• Worked with several disparate data sources (Teradata, SQL Server, Oracle, flat files and vendor specific files) and their complex format conversions.

Confidential, Atlanta GA

Sr. Abinitio Developer

Environment: Ab Initio (GDE 1.15, Co>Operating System 2.15), Oracle 10g, DB2, Teradata v2R6, Toad, Erwin 7.3, Control-M, Pl/Sql, Sql*Loader, HTML, ASP, Pro*C, Solaris 2.6, WXP

Responsibilities:

• Performed Analysis, designing and preparing the functional, technical design document and code specifications.
• Developed and supported the extraction, transformation and load process (ETL) for a Data Warehouse from their OLTP systems using Ab Initio and provide technical support and hands-on mentoring in the use of Ab Initio.
• Responsible for all pre-ETL tasks upon which the Data Warehouse depends, including managing and collection of various existing data sources.
• Involved in developing UNIX Korn Shell wrappers to run various Ab Initio Scripts.
• Developed Ab Initio XFR’s to derive new fields and solve various business requirements.
• Developed number of Ab Initio Graphs based on business requirements using various Ab Initio Components such as Partition by Key, Partition by round robin, reformat, rollup, join, scan, normalize, gather, Broadcast, merge etc.
• Worked on improving the performance of Ab Initio graphs by using various Ab Initio performance technique’s like using looks instead of Join’s etc.
• Design Documentation for the developed graphs.
• Created mapping document and ETL design document.
• Updated and inserted the transaction data according to the business changes using continuous Flows.
• Good understanding of new Ab Initio features like Component Folding, Parameter Definition Language (PDL), Continuous flows, Queues, publisher and subscriber components.
• Used Parameter Definition language (PDL) in writing DML to execute the graphs without writing scripts or deploying using air commands.
• Extensively used the Teradata utilities like BTEQ, Fastload, Multiload, TPump, DDL Commands and DML Commands (SQL).
• Involved in writing complex SQL queries based on the given requirements and created series of Teradata Macros for various applications in Teradata SQL Assistant and performed tuning for Teradata SQL statements using Teradata Explain command.
• Created UNIX shell scripts to automate and schedule the jobs.
• Created the migration scripts, test scripts for testing the applications, creating and supporting the Business Objects reports.
• Involved in the integration testing with ETL developers and User Acceptance Testing (UAT) with Business Analysts.
• Performed physical data modeling, performing regular refreshes of development and test database environments using the Export/Import utility.

Confidential, New Berlin, WI

Sr. Ab Initio Developer

Responsibilities:

• Understanding the business requirement and transforming into technical development.
• Developed Ab Initio graphs and Detail Design document for data movement.
• Responsible for creating test cases to make sure the data originating from source makes it to the target in the proper format. Performed Component testing of Ab-Initio graphs and fixed the defects found.
• Worked on improving the performance of Ab Initio graphs by using Various Ab Initio performance techniques like using lookup Tables, In-Memory, Joins and rollups to speed up various Ab Initio Graphs.
• Used FastLoad, BTEQ, UNIX Shell and Teradata SQL to transfer cleanup and summarize data.
• We build the risk data strategy on Basel implementation. Involved in designing the mapping documents.
• We were a team size of 40 while working on Basel implementation.
• Involved in preparing Job dependency Diagrams to schedule jobs using Autosys.
• Worked with XM team in transforming the Mainframe COBOL code into DML's and moving the data to DEV.
• Automated the complete daily, weekly and monthly refresh using the custom build UNIX shell scripts.
• Responsible for deducing and consolidating records from various sources to create master list.
• We used the generic graphs while developing the history data mapping and loading.
• Worked in analyzing and gathering the information from Business Analyst for designing and developing the CPMI History data.
• Trained in using Informatica Power Center.

Confidential, Denver, CO

Ab Initio Developer

Environment: Ab Initio (GDE 1.13 Co-op 2.13), UNIX, PL/SQL, Oracle 8i/9i, Teradata, SQL, Query man, UNIX, Windows NT/2000.

Responsibilities:

• Performed Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DMLs.
• Involved in creating detail data flows with source and target mappings and convert data requirements into low level design templates.
• Responsible for setting up Repository projects using Ab Initio EME for creating a common development environment that can be used by the team for source code control.
• Implemented various levels of parameter definition like project parameters and graph parameters instead of start and end scripts.
• Used various teradata utilities such as Mload, API and Fast load while using I-Table, O-Table components depending on the volume of data and status of the target database table.
• Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures.
• Implemented Lookups instead of joins, in-memory sorts to minimize the execution times while dealing with huge volumes of data.
• Replicate operational table into staging tables, transform and load data into warehouse tables using Ab Initio GDE.
• Deployed and ran the graphs as executable Korn shell scripts in the applications system.
• Developed UNIX Korn Shell script wrappers to run Ab Initio deployed scripts, perform audit checks/data reconciliation and error handling to ensure data accuracy

Confidential, Minneapolis, MN

Ab Initio Developer

Environment: Ab Initio (GDE 1.12, Co>Op Sys 2.12), ERWIN, Shell Scripts, Windows Advanced Server 2000, SQL, PL/SQL, MVS JCL, Teradata V2R5, Oracle 9i.

Responsibilities:

• Based on the requirements created Functional design documents and Technical design specification documents for transformation and loading.
• Translating client’s strategic vision into technical solutions and application identification.
• Designing and reviewing the ETL solutions in Ab Initio.
• Mentoring the team in the technology, design and development areas.
• Extracted data from legacy applications into the EDW environments, programming in SQL to perform the data Query functions for Teradata.
• Extensively used Ab Initio to load data from sources involving Oracle, Flat files, SQL Server to Teradata database.
• Used Ab Initio components like Reformat, Scan, Rollup, Join, Sort, Partition by key, Normalize, Input Table, Output Table, Update Table, Gather Logs and Run SQL for developing graphs.
• Involved in complex Ab Initio XFRs and DMLs to derive new fields and solve various business requirements
• Created Database objects including Tables, Indexes, Clusters, sequences, roles, and privileges.
• Calculated and monitored size and space for tables, clusters and indexes.
• Created separate table spaces for Users, Indexes, Rollback Segments and Temporary Segments. Renamed and resized redo log files, user data files, rollback files, index files and temporary files.
• Created and maintained Triggers, Packages, Functions and Procedures.
• Created and maintained roles and profiles for security and limited access of data.
• Designed and implemented Backup & Recovery strategies.
• Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
• Debugged, performed system/application tuning by identifying long running reports.
• Created users and established application security by creating roles.
• Wrote procedures to meet adhoc requirements to replicate data from one table to another.