SUMMARY

• Overall 7 years of experience in full Software Development Life Cycle (SDLC) analysis, design, development, testing, implementation and maintenance in data warehousing environment.
• Over 4 years of experience in using Ab Initio as the ETL tool. Extensive knowledge in architecture design of Extract, Transform, Load environment also worked as Analyst gathering user’s requirements.
• Highly experienced in ETL tool Ab - Initio using GDE Designer.
• Involved in full life cycle implementation of Data warehouse project.
• Good experience with Data Migration, Data Transformation and Data Loading using Ab Initio into Oracle, Teradata, DB2 Databases and Files.
• 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, Fast load, Multiload, SQL Assistant, DDL and DML commands.
• Experienced in developing UNIX shell wrapper scripts to run Ab Initio graphs.
• Well versed with AB Initio parallelism techniques and implemented Ab Initio Graphs using Data parallelism and MFS techniques.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Involved in using EME version control.
• Expertise in Developing Transformations between Source and Target using Ab Initio.
• Expertise in various Ab Initio component groups like Partition, De-partition, Database, Datasets, Transform, FTP, Sort and Miscellaneous.
• Developed various UNIX shell scripts to run Ab Initio and Database jobs. Practical experience with working on multiple environments like production, development, testing.
• Provided Production support on call carrying pager 24/7.
• Automated and scheduled the Abinitio jobs using UNIX Shell Scripting.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Extensively worked on MS Access, MS Excel, Power Design, MS Visio, MS PowerPoint, MS Project, and SQL.
• Excellent written and verbal communication skills including experience in proposal and presentation creation.

TECHNICAL SKILLS

ETL Tools: Ab Initio (GDE 3.1.3.2, Co>Op 2.15, WEB EME 3.0), Ab Initio, (GDE 1.15, Co>Op 2.15), EME, Data Profiler

Data Modeling: Erwin 7.3, Star Schema Modelling, Snow Flake Modelling

Databases: Oracle 10g/9i/8i, MS SQL Server 2008/2005, DB2 8.x, Teradata 12.0, Sybase 12.5, MySQL

BI/OLAP Tools: Cognos 8.0/7.0/6.0, Business Objects XI R3/R2/6.x/5.x

Languages: SQL, PL/SQL, Unix Shell Script, Visual Basic, XML, PERL

Tools: Toad, SQL* Loader, WinSQL, Teradata SQL Assistant

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

Version Control: Rational Clear Case, CVS, VSS, PVCS

PROFESSIONAL EXPERIENCE

Confidential, CA

Ab Initio Developer

Responsibilities:

• Analyzed business requirements, system requirements, Source to Target data mapping requirement specifications.
• Involved in Analyzing Data Dependencies, Data Profiling, High Level Design.
• Involved in developing Technical detailed Design, Mapping document and Ctrl+M Visio.
• Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DMLs.
• Developed number of Ab Initio Graphs based on business requirements using various Ab Initio Components such as rollup, join, scan, normalize, gather, merge etc.
• Well versed in Partition by Key, Partition by round robin, reformat.
• Developed various Ab Initio Graphs for data cleansing using Ab Initio function such as is valid, is error, is defined, string * functions etc.
• Developed Ab Initio graphs for Data validation using validate components.
• Deduping and consolidating customer records from various sources to create master customer list.
• Developed Complex Ab Initio XFRs to derive new fields and solve various business requirements.
• Worked on improving the performance of Ab Initio graphs by using Various Ab Initio performance techniques such as using lookups instead of Joins etc.
• Implemented Lookup’s, lookup local, In-Memory Joins and rollups to speed up various Ab Initio Graphs.
• Debugging Ab Initio graphs using Flow Watchers
• Creating load ready files using Ab Initio ETL tool to load into database.
• Developed UNIX Korn shell wrapper scripts to accept parameters and scheduled the processes using Maestro.
• Validating the code and Review the code as per the requirements.
• Worked in Agile Methodology, where status of work and hours burned for each task is updated in Daily Stand up’s.
• Worked with Scrum Master to identify Testing Stories, Tasks during Sprint Planning & Grooming Sessions.
• Supported in closing of stories and tasks in Sprint Retrospective.

Environment: Ab Initio (GDE 3.1.3.2, Co>Op 2.15, WEB EME 3.0), Teradata SQL Assistant 13.0.015, SQL Developer, MS SQL Server 2008, UNIX Shell Scripting, HP ALM/Quality Center, SQL Server, SQL, UAT, PL/SQL, Teradata, IBM DB2, Oracle, XML Files.

Confidential, Virginia

Ab Initio Developer

Responsibilities:

• Involved in developing Technical detailed Design, Mapping document and Ctrl+M Visio.
• Designed programs to utilize the parallel processing capabilities of An Initio using Data parallelism (MFS).
• Designed AB Initio Graphs for various ETL functions and using GDE and deployed in CO>Operating Systems.
• Used AB Initio Components like sort, partition, rollups, merge, and configured ports and created XFRs.
• Implemented partition techniques using MFS with round robin, Key, expression and interleave Gather and merge.
• Participated in testing with various Ab Initio validate components like Validate Records, Compute Checksum etc components.
• Also Used FTP, Normalized, Denormalize components.
• Has written UNIX shell wrappers and Oracle PL/SQL programming.
• Created various Ab Initio Multi File System (MFS) to run graphs in Parallel.
• Created load ready files using Ab Initio to load database.
• Loaded data files into databases using Dbload and DbUpdate Ab Initio components.
• Involved in the analysis of the data flow requirements for developing a scaleable architecture for both staging and loading data.
• Involved in the preparation of documentation for ETL using Ab Initio standards, procedures and naming conventions.
• Generated Configuration files, DML files from Copybooks, XFR files specifies the Record format, which are used in components for building graphs in Ab Initio.
• Was involved in using the built-in AB Initio functions to build the Custom components, which will help in implementation of the complex business logic.
• Performed complex queries involving large data volumes of data. Some of these queries run parallel against the same table to improve the performance.
• Developed UNIX Korn shell wrapper scripts to accept parameters and scheduled the processes using Maestro.
• Developed wrapper scripts to execute Ab Initio graphs followed by error handling routines and post audit checks/data reconciliation after executing the graphs
• Supported Production Validations for Partnership Projects like KOHLS, HBC and HSBC with Business.

Environment: Ab Initio (GDE 1.15, Co>Op 2.15, WEB EME 3.0), Teradata SQL Assistant 13.0.015, Db Visualizer 9.0.8, Business Objects, SQL Developer, UNIX Shell Scripting, Teradata, Agile, AutoSys, Java, Windows, UNIX(Sun Solaris)

Confidential, Virginia

Ab Initio Consultant

Responsibilities:

• Analyze data warehouse/decision support business requirements.
• Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DML s USING Ab Initio DB CONFIG, input Table components.
• Involved in designing fact, dimension and aggregate tables for Data warehouse Star Schema.
• 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, is defined, sting substring, srting concat and other string * functions.
• Developed Ab Initio graphs for Data validation using validate components like compare records, compute checksum etc.
• Developed Complex Ab Initio XFR s to derive new fields and solve rious business requirements.
• Extensively used Ab Initio Co>OS commands like m ls, m wc, m dump, m copy, m mkfs etc.
• Worked on improving the performance of Ab Initio graphs by using Various Ab Initio performance technique s like using lookup s (instead of joins), In-Memory Joins and rollup s to speed up various Ab Initio Graphs.
• Involved in monitoring Ab Initio jobs using AB REPORT options.
• Created various Ab Initio Multi File Systems (MFS) to run graphs in parallel using layout feature.
• Involved in pager rotation program to support 24 x 7 production support.
• Developed various stored procedures using ORACLE PL/SQL and cursors.
• Converted various SQL Loader scripts into Ab Initio load programs.

Environment: Ab Initio (GDE 1.15, Co>Op 2.15, WEB EME 3.0), Sun Solaris 5.8, Business Objects 5.1, Oracle 8i, PL/SQL, SQL, PL/SQL, TOAD 7.x, java, Windows NT, Agile, Shell Scripting, Sun Solaris

Confidential, Columbus, OH

AB Initio Developer

Responsibilities:

• Involved in all phases of ETL cycle and prepared detailed level design that depicts the transformation logic used in Ab Initio.
• Responsible for collecting and documenting the business requirements.
• Responsible for designing the source to target mapping diagrams
• Developed generic graph to extract data from various heterogeneous source such as Oracle databases and from flat files.
• Responsible for creating Ab Initio graphs for landing, the validated source data received from various divisions, in multifiles and creating lookups for cross reference.
• Used Ab Initio EME for repository of Graph object and performed check in/ check out.
• Extensively used database, dataset, partition / departition, transform, sort and partition components for extracting, transforming and loading.
• Developed number of Unix Korn Shell wrapper scripts to control various Ab Initio processes and complex functionalities such automated ftp, remote shell execution, and remote copy etc
• Wrote UNIX shell scripts to automate the some of the data extraction, and data loading process.
• Involved in Creation of Sandboxes and managing Enterprise Metadata using EME.
• Involved in creation of the database and developed the backend procedures for the system
• Developed a number of scripts and procedures to address the changes to system based on change requests of the user needs
• Involved in creating interfaces from and to the manufacturing, shipping and fulfillment systems
• Involved in doing migration of legacy system data to new systems. Initially the migration was done to the beta test systems to establish data validation and stability of migrations and subsequently ported to the production

Environment: Ab Initio (Co >Operating system 2.12 GDE 1.12), Oracle 8i, SQL plus, UNIX and Window NT

Confidential

Programmer

Responsibilities:

• Involved in design of database and creation schemes and tables in normalized form.
• Loaded huge volume of data from ASCII files into Oracle Database using SQL Loader.
• Developed and implemented complex oracle backend programs by using SQL, PL/SQL
• Wrote stored procedures and packages on server side and also developed libraries PL/SQL triggers, and functions were used to implement business logic.
• Developed forms and reports using Forms 4.5 and Reports 2.5
• Analyzed data for correctness and created database triggers for data integrity
• Importing and exporting the data using Import and Export Utilities

Environment: Oracle 7.3, Developer2000 (forms4.5, reports2.5), SQL*PLUS, SQL*Loader, PL/SQL, Import, Export, MS-Access, UNIX, Windows NT 4.0