PROFESSIONAL SUMMARY

• Over Six years of IT experience in software analysis, design and development for various software applications in client-server environment with over 5 years experience in providing Business Intelligence solutions in Data Warehousing for Decision Support Systems and OLAP application development in Windows and Unix platforms.
• Over Four years of solid experience in the Analysis, Design and Development of Data warehousing solutions and in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Ab Initio.
• Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Ab Initio/Informatica Power center 6.2/6.1/5.1.
• Highly experienced in ETL tool Ab Initio in using GDE Designer. Very good working experience with all the Ab Initio components.
• Expertise and well versed with various Ab Initio Transform, Partition, Departition, Dataset and Database components.
• Experience with Ab Initio Co-Operating System, application tuning, and debugging strategies.
• Expert in writing UNIX Shell Scripts including Korn Shell Scripts, Bourne Shell Scripts.
• Very good experience with SQL Server & Oracle Databases.
• Involved in implementation of Business Intelligence Applications using Cognos and Business Objects, building Data Marts and enterprise wide Data Warehousing.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access and Worked on integrating data from flat files.
• Experience in developing Entity-Relationship diagrams, Logical and Physical Data Models, and the use of Data modeling tools.
• Excellent analytical & problem solving and business interaction skills.
• Excellent Written and verbal communication skills.

EDUCATION

• Bachelors of Technology in Computer Science and Engineering.

TECHNICAL SKILLS

ETL Tools: Ab Initio, Informatica Power center, Power mart.
OS : Windows 95/98/NT/ME/00/XP, UNIX, MS-DOS, Sun Solaris 5.8, Linux 8x.
Databases: Oracle 10g/9i/8.x, MS SQL Server.
Languages: C, C++, Java, XML, Visual Basic 6.0/5.0, SQL, PL/SQL, Transact-SQL and Perl.
OLAP/Tools: Cognos (Impromptu, Power Play), Business objects, Micro Strategy, Oracle Reports.
Packages: SQL* PLUS, Toad 7.x, SQL Loader, Erwin 4.0, MS Visio 2002.
Scripting: UNIX Shell (Ksh/Csh).

PROFESSIONAL EXPERIENCE

Confidential,CA Oct 09 – Sep 10
Ab Initio Developer
Customer Profile Project

The purpose of the Customer Profile project is to capture and provide basic customer information and customer attributes for use in email and online marketing campaigns. Customer profiles will be comprised of customer contact information plus customer attributes such as purchase history, product and brand affinity, response to promotions, and online activity. This information will facilitate marketing outreach efforts such as event triggered email campaigns and targeted online marketing. It will include data enhancements to the CDW for customer returns, promo codes, and Ecommerce product catalog which are needed for customer profiles.

Responsibilities:
• Extensive usage of Multifile system where data is partitioned into four partitions for
Parallel processing.
• Wide usage of Lookup Files while getting data from multiple sources and size of
the data is limited.
• Developed Generic graphs for data cleansing, data validation and data transformation.
• Responsible for cleansing the data from source systems using Ab Initio components such as Join, Dedup Sorted, Denormalize , Normalize, Reformat, Filter-by-Expression, Rollup
• Worked with Departition Components like Concatenate, Gather, Interleave and
Merge in order to departition and repartition data from Multifiles accordingly.
• Worked with Partition Components like Partition-by-key, Partition-by-expression,
Partition-by-Round Robin to partition the data from serial file.
• Used Toad to verify the counts and results of the graphs.
• Involved in System and Integration testing of the project.
• Wrote several Shell scripts, to remove old files and move raw logs to the archives.
• Tuning of Ab Initio graphs for better performance.
• Process and Transform delta feeds of customer data, which comes in daily.
• Developed dynamic graphs to load data from data sources into tables and to parse records.

Environment: Ab Initio (Co.Op 2.15, GDE 1.15.9.2), UNIX, EME, Teradata
TOAD, CONTROL-M and Windows

Confidential,Long Island, NY May 09 – Sep 09
Ab Initio Developer
NPD New Generation Project

Confidential,is the conversion of entire NPD ETL Process which is present in Oracle PL/SQL to Abinitio. NPD collects point of sale information from retailers and survey information from consumers to produce reports on retail sales tracking and trend analysis etc.

Responsibilities:

• Involved in developing totally metadata driven architecture.
• Involved in creating detail data flows with source and target mappings and convert data requirements into low level design templates.
• Developed highly generic graphs to serve the instant requests from the business.
• Worked in highly parallelized (MPP Solution) Ab initio environment to process 1+Tera bytes of data daily.
• Developed complicated graphs using various Ab Initio components such as Join, Rollup, Lookup, Partition by Key, Round Robin, Gather, Merge, Dedup sorted, Scan and Validate
• Worked with Infrastructure team to write some custom shell scripts to serve the daily needs like collecting logs and cleaning up data.
• Migrated scripts from DEV to SIT and UAT environment to test & validate data.
• Deployed and test run graphs as executable k-shell scripts in the application system.
• Worked with project team in optimizing and tuning of SQL statements, used phases/checkpoints to avoid deadlocks to improve the efficiency.
• Gathering the knowledge of existing operational sources for future enhancements and performance optimization of graphs.
• Extensively involved in Ab Initio Graph Design, development and Performance tuning.
• Worked with cron tabs to schedule the reports.
• Involved in writing processes to continuously capture the data from different servers across the country continuously.
• Used UNIX environment variables in All the Ab Initio Graphs, which comprises of specified locations of the files to be used as source and target.
• Used sandbox parameters to check in and checkout of graphs from repository Systems.

Environment: Ab Initio GDE 1.15, Co op 2.15, UNIX shell scripting, Crontabs, Oracle 10g, Teradata, Sun Solaris, Windows Vista

Confidential,CT April 08 – April 09
Ab Initio Developer Aug 2004 to July 2005

This project deals with the banking transactions at regional and Country level. They follow two systems Advantage and E-Advantage. Advantage Application captures data from Flat files and Excel Sheets, where as E-Advantage Application pumps huge data into the production database, which makes it impossible to maintain beyond 90 days. Each location at the end of the day has to transfer the data into central zones and each location daily generates reports for different purposes like Loan portfolio, Non sufficient fund port folio. They needed extensive Data Warehousing to maintain historical data at a central location for integration and analyze the business information in different locations according to the profit areas, which could serve the purpose of a DSS management.

Responsibilities:

• Developed and Implemented extraction, transformation and loading the data from the legacy systems using Ab Initio
• Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DMLs and written complex XFRs for implementing the business logic transformation.
• Implemented various levels of parameter definition like project parameters and graph parameters instead of start and end scripts.
• Extensively Used Transform Components Aggregator, Match sorted ,Join, Denormalize sorted, Reformat, Rollup and Scan Components
• Involved in Unix Korn shell wrapper scripts to accept parameters and scheduled the processes using Crontab, Job Scheduler, Database Load Interface, and Denormalization using Ab Initio.
• Worked with EME / sandbox for version control and did impact analysis for various Ab Initio projects across the organization.
• Developed Ab Initio scripts for data conditioning, transformation, validation and loading.
• Gathering the knowledge of existing operational sources for future enhancements and performance optimization of graphs.
• Assisted in developing various reports using PL/SQL Stored Procedures.
• Involved in writing wrapper scripts to run the graphs, to load into Data Warehouse and to verify the counts while loading.
• Used Parallelism techniques to partition and process large data simultaneously
• Created Auto Sys job stream to schedule jobs by creating box jobs and jil templates.
• Developed shell scripts to automate file manipulation and data loading.
• Replicate operational table into staging tables, transform and load data into warehouse tables using Ab Initio GDE.

Environment: Ab Initio GDE 1.14,Co op 2.14, Oracle 9i, Tera data, Autosys ,Toad 7.6.0.11, HP UX 11.x, IBM PCOM 4.2, TSO/ISPF, Korn Shell Scripting.

Confidential,San Jose, CA Aug 07 – Feb 08
Ab Initio Developer
Ebay/Shopping.Com

The BIS Project in EBay involves creating processes for the generation of reports about the customer behavior on the eBay web site.

Responsibilities:

• Designed and developed different graphs in Ab Initio for analyzing the behavior of the traffic hitting e-bay site.
• Worked with business to translate the business requirements into High level design, Detailed Level Design and Functional code.
• 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.
• Developed adhoc graphs to serve the instant requests from the business.
• Developed graphs using Graphical Development Environment (GDE) with various Ab Initio components
• Developed Complex Ab Initio XFR’s to derive new fields and solve various business requirements
• Worked on Converting Shopping.com data warehouse code from pl/sql to Ab initio as part of conversion project.
• Extensively worked under the Unix Environment using Shell Scripts and Wrapper Scripts. Responsible for writing the wrapper scripts to invoke the deployed Ab Initio Graphs
• Developed graphs to extract internal / external data needed from different source databases by using multi input file components and by configuring the dbc file in Input Table component
• Used phases and checkpoints in the graphs to avoid the deadlocks, improve the performance and recover the graphs from the last successful checkpoint.

Environment: Ab Initio GDE 1.13 Co op 2.13/2.14, UNIX shell scripting, Oracle 9i, Sun Solaris, Windows XP

Confidential,Durham, NC Aug 06 – Aug 07
Ab Intio Developer

Involved in developing the Data store meant for Web Services. Data store is meant for 24*7 availability which was not there with the legacy systems which were in AS/400 and IMS. Data store is designed to provide the response to web services which were invoked when providers enquire about the member’s information who have BCBS health Insurance.

Responsibilities:

• Designed, developed Ab Initio graphs for Loading into Data store.
• Translating the logical data model in Erwin to a physical database design, database construction, design optimization and functional testing.
• Created sandbox and edited sandbox parameter according to repository.
• Implemented Data Parallelism through graphs, which deals with data, divided into segments and operates on each segment simultaneously through the Ab Initio partition components to segment data.
• Developed parameterized graphs using formal parameters.
• Developed Ab Initio graphs to unload required data from database.
• Developed Ab Initio graphs to load data into fact tables and update dimensional tables.
• Used various component of Ab Initio graphs like ‘Partition By Key’, ’Sort’, ’Reformat’, ‘Join’, ‘De-Dup’ etc. to impose business logic on the incoming data for loading and maintaining Dimensional tables (insert/update), such that the history of the records could be retained, for recurring loads.

Environment: Ab Initio GDE 1.13, Co op 2.13, DB2, Tera data, Erwin, UNIX, SunOS 5.8.

Confidential,Chicago, IL May 05 – June 06
Ab Initio Developer

Involved in developing the enhancements, which are to be applied in Walgreen’s Health Initiatives (WHI) Formulary Management System, which manages its PBM (pharmacy benefit management) and rebate process. The primary function of the system is to manage rebate contracts with pharma and PBM clients, process prescription rebate calculations, allocate rebate payment to clients.

Responsibilities:

• Involved in design, development and testing of Ab Initio graphs for formulary management system.
• Translating the logical data model in Erwin to a physical database design, database construction, design optimization and functional testing.
• Performed Reverse engineering on existing graphs and stored procedures to know their present functionality and in turn to know where specific enhancements are to be applied.
• Implemented Data Parallelism through graphs, which deals with data, divided into segments and operates on each segment simultaneously through the Ab Initio partition components to segment data.
• Developed parameterized graphs using formal parameters.
• Developed Ab Initio graphs to unload required data from database.
• Developed graphs to do complex calculation by using normalize and de-normalize components.
• Developed Ab Initio graph to load data into fact tables and update dimensional tables.
• Used various component of Ab Initio graphs like ‘Partition By Key’, ’Sort’, ’Reformat’, ‘Join’, ‘De-Dup’ etc. to impose business logic on the incoming data for loading and maintaining Dimensional tables (insert/update), such that the history of the records could be retained, for recurring loads.
• Was involved in designing, writing packages, stored procedures, cursors, functions, etc.
• Designed documents for the enhancements, which are applied as part of phase 5 of the Formulary Management Project.

Environment: Ab Initio GDE 1.3, Co op 2.13,Oracle8i, PL/SQL, SQL*Plus 8.1.7, Erwin, UNIX TOAD 7.5, SunOS 5.8, Windows XP, Business objects.

Confidential,India Dec 03 to July 05
ETL Consultant/ Informatica

Responsibilities:

• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Sales and Marketing Systems to facilitate Daily, Monthly and Yearly Loading of Data.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Developed PL/SQL Business Functions for Web Users For Flexible Querying.
• Developed Mappings for the Category, Specification, Code, and Type areas.
• Involved in design, developing and testing the software (Informatica , PL SQL, UNIX shell scripts) to maintain the data marts (Extract /Transform/Load data).
• Involved in quality assurance of data, automation of processes, programming for data manipulation and graphics, validation of programming, and presentation of results.
• Provided data modeling services for a large data warehouse design.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
• Developed schedules to automate the update processes and Informatica Sessions/Batches.
• Involved in fixing repository related, Reader process and External procedure problems.
• Involved in loading data to staging area and into Warehouse tables using SQL Loader.