SUMMARY

• Over 7 years of IT experience with over 5 years experience in Ab - initio.
• Excellent knowledge of industry standard methodologies like Software Development Life Cycle (SDLC), iterative SDLC Process as per Rational Unified Process (RUP) and Rational Tools used during various phases of RUP and Agile.
• Extensive experience in utilizing ETL Process for designing and building very large-scale data OLAP and OLTP instance using Ab-Initio and custom scripts
• Extensive experience of coding using ETL Tool - Ab Initio Proficient with various Ab-Initio Parallelism and Multi File System techniques.
• Worked in Enterprise metadata environment (EME) environment for check in and check out of the graphs, versioning of the graph, jobs migration, version control, and Dependency analysis operation.
• Developed various UNIX shell scripts to run Ab Initio and Database jobs. Worked mostly with Korn shell, sun Solaris and have a good knowledge of bash shell.
• Hands on experience in diverse fields like Financial, Retail, Pharmaceutical and Insurance relational Databases with an extensive use of Ab Initio, Dimensional Model Design, Databases.
• Expertise in all components in the GDE of Ab Initio for creating executing testing and maintaining graphs in Ab Initio and also experience with Ab Initio Co-operating System in application tuning and debugging strategies.
• Experience in Parameterization of graphs and worked with PSET.
• Developed wide variety of DML’s for data from different sources. Developed many Conditional DML’s.
• Used variousAb-Initiocomponents of partition, de-partition, database, datasets, transform, FTP and sort to build graphs in GDEand runs those graphs in UNIX environment. Used theAb-InitioWeb Interface to Navigate the EME to view graphs, files and datasets and examine the dependencies among objects.
• Experience in writing various UNIX shell scripts and knowledge on the usage of mp commands, air commands and Environment parameters like AI SERIAL LOG, AI RUN etc.
• Extensive experience in writing efficient and well tuned SQL Queries and UNIX Scripts to provide data reporting, processing and validation on Teradata, DB2 and Oracle. Good exposure in working with different databases - Oracle, Teradata and db2.

TECHNICAL SKILLS

Operating Systems: Windows 98/2000/2003/ XP,Sun Solaris 5.6,Unix-AIX,HP-UX, Linux

Languages: C,C++, SQL PL/SQL, SQL Plus, VB

Databases: Oracle 9i/10g, DB2, MS Access, MS SQL Server 2005/ 2000, Teradata V2R5/V2R4

Technologies: Data Warehousing, Rational Unified Process, SDLC,QALC

Tools: &Utilities: Ab-Initio GDE (1.15, 1.14.37/1.13.4 ), Co>Op 2.15/2.14/2.13 , Autosys 3.4,4.5, Toad 7.6, SQL Query Analyzer, MS Visio, MS Project, Quality Center, DB Artisan, Erwin 4.1, SQL Loader, MS Visio,Control-M,Autosys, IBM Lotus Notes 7.0.3

Domain Knowledge: Finance,Retail,Healthcare

PROFESSIONAL EXPERIENCE

Confidential, IL

Sr.Ab Initio Developer

Responsibilities:

• Designed and Developed Ab-Initio Graphs, Plans based on party subject area.
• Modified the Ab initio components parameters, utilize data parallelism and thereby improve the overall performance to fine-tune the execution times.
• Worked on Ab-Initio multi file system and used partition components for better performance and when dealing with large volumes of data.
• Worked on production support in monitoring the jobs and took corrective action based on the job status.
• Used EME for checkout of graphs, dmls and xfrs into my sandbox and modified as per the requirement.
• Performed DBA and application analysis tasks.
• Responsible for making the strategy for backup and recovery procedures.
• Developed, Tested and Migrated UNIX Shell Scripts.
• Monitoring of load on the server and memory usage by different processes. Responsible for performance tuning of the database.
• Responsible for deploying Ab Initio graphs and running them through the Co-operating systems mp shell command language and responsible for automating the ETL process through scheduling
• Involved in Comprehensive end-to-end testing.
• 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.
• Exposure to Abinitio Plans, Sub Plans, Plan Task, Program Tasks, and Graph tasks.
• Worked in EME sandbox environment to obtain data and variables by checking them out from the repository. The graphs and data were checked into the repository for common use by the other team members and to maintain version control..
• Timely Resolution of critical production issues and bug fixing.
• Worked with PSET for parameterization of graphs and validation of the audit files.
• Responsible for 24 X 7 production support of Ab Initio Process.

Environment: Abinitio GDE 3.0.2, Co-Op>3.0.2.3, Oracle, UNIX (SunOS 5.10), Oracle 10g, SQL server 2008

Confidential, Northbrook IL

Sr. AbInitio Developer

Responsibilities:

• Involved in understanding the Requirements of the End Users/Business Analysts and Developed Strategies for ETL processes.
• Used the following components of Ab Initio in creating graphs. Dataset components (Input file, output file, lookup file, and intermediate file), Database components (Input table, output table, RunSql, Truncated Table), Transform Components (Aggregate, Dedup Sorted, Filter by Expression, Join, Normalize, Reformat, Rollup and Scan Components), Partitioning Components (Broad Cast, partition by expression, partition by key, partition by round robin), Gather logs, Redefine format, Replicate, Run program components.
• Extensively used the Ab Initio tool’s feature of Component, Data and Pipeline parallelism.
• Created .dml files for specifying record format.
• Created checkpoints, phases to avoid dead locks and tested the graphs with some sample data then committed the graphs and related files into Repository from sandbox environment. Then schedule the graphs using Autosys and loaded the data into target tables from staging area by using SQL Loader.
• Worked heavily with various built-in transform components to solve the slowly changing dimensional problems and creating process flow graphs using Ab Initio GDE and Co>Operating System.
• 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.
• Ensured for the accuracy of data loaded intoTeradataand assured the linkage of keys on the tables for the variousapplications.
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables
• Extensively worked under the Unix Environment using Shell Scripts.

Environment: AbInitio GDE1.15, Co-Op2.15, Erwin 5.3.2, Teradata V2R6, Oracle, UNIX (SunOS 2.8), Oracle 10g

Confidential, Newyork NY

Sr. AbInitio Developer

Responsibilities:

• ImplementedAb-Initioconfiguration and set up well-tuned environments for Production Development & Testing.
• Designed and deployedAb-InitioETL graphs for daily transactional data monthly reference data by studying the business requirements from the functional design document and from the business users.
• Developed daily and monthly ETL Hub processes which were automated using custom UNIX Korn shell scripts.
• Extensive experience in Managing and implementing Data warehouses, ETL and Data integration.
• Implemented the Parallel application by replicating the components datasets and processing modules into number of partitions.
• Developed variousAb-Initiographs for customer credit, contact, account detail, account, data inserts & updates, data validate graphs.
• Used variousAb-Initiocomponents of partition, de-partition, database, datasets, transform, FTP and sort to build graphs in GDEand runs those graphs in UNIX environment.
• Wide usage of lookup files while getting data from multiple sources and size of the data is limited.
• Used the sub graphs to increase the clarity of graph and to impose reusable business restrictions and tested various graphs for their functionalities.
• Implemented component level pipeline and data parallelism using AB Initio for ETL process.
• Responsible for the design, development and administration of transactional and analytical data constructs/structures.
• Developed DML’s for data from different sources like flat files. Developed conditional DML’s for data that has Header, body and Trailers.
• Designed and developed parameterized generic graphs.
• Created Ab-Initiomulti file systems (MFS) to take advantage of partition parallelism.
• Worked with PSET for parameterization of graphs and validation of the audit files.
• Developed several stored procedures and functions to make the existing code to be executed and make it more dynamic which is now considered to be the centralized.
• Worked with different kinds of stored procedures and functions using PL/SQL.
• Wrote several SQL* loader programs to load small loads into temporary tables for the data, which may be required to move among different unix servers and databases while the program is running.
• Check in/Check Out existing applications Using EME in order to perform the necessary modifications.
• Used different EME air commands in project promotion like air tag create, air save, air load, air project export etc.

Environment: AbInitio GDE1.15, Co-Op2.15, EME, Korn shell scripting, Mercury Quality- center 9.0, UNIX, Oracle 10g, PLSQL, SQL Server Navigator 5.0, Teradata, Windows-NT/2000

Confidential, long Island NY

Ab Initio Developer

Responsibilities:

• Involved in designing and developing dimensional model for the Data Warehouse from the ETL side. Involved in re hosting of the data in legacy applications using Ab initio.
• Involved Preparation and implementation of data verification and testing methods.
• Involved in all the stages of SDLC during the projects. Analyzed, designed and tested the new system for performance, efficiency and maintainability using ETL tool AB INITIO.
• Developed Ab Initio graphs for receiving the data for various dimensions (Customers Circuits) all the way to populating the dimension tables.
• Provided architecture/development for initial load programs to migrate production databases from Oracle Datamart to teradata data warehouse as well as ETL framework to supply continuous engineering and manufacturing updates to the data warehouse (Teradata).
• Involved in writing user defined functions for common business logic.
• Involved in monitoring the resource usage of various Ab Initio graphs and suggesting the performance enhancements.
• Involved in setting up the MFS and SERIAL directories with a set of sub directories to properly organize transient and persistent data.
• Involved in writing the shell scripts to produce job output and load the necessary data into database.
• Created summarized tables control tables staging tables to improve the report performance and as a source for immediate recovery of teradata database.
• Worked with testers in setting up the test cases for testing Ab Initio graphs and also involved in validating the data load process using SQL scripts.
• Responsible for end user support peer reviews and code documentation.

Environment: AbInitio GDE 1.14.26/1.14.6 , Co>Operating System 2.14.7/ 2.14.8 , UNIX, Oracle SQL, PLSQL, Windows 2000, Korn shell.

Confidential, Atlanta GA

Ab Initio Developer

Responsibilities:

• Responsible for analyzing source and target data models and making necessary changes to the mapping document.
• Extensively involved in Ab Initio Graph Design, development and Performance tuning.
• Enhance performance using data parallelism.
• Extensively used Partition components and developed graphs using Write Multi-Files, Read Multi-Files, Filter by Expression, Run Program, Join, Sort, Reformat, and Dedup.
• Implemented Lookups, lookup local, In-Memory Joins to speed up various Ab Initio Graphs.
• Responsible for Designing and developing shell scripts (wrapper) to schedule the jobs in the development environment.
• Responsible for Designing and developing shell scripts (wrapper) to validate data.
• Responsible for writing SQL’s in SQL Developer to validate if the data load was correct.
• Designed and Created various Ab Initio Multi File System’s (MFS) to run graphs in parallel
• Design and development of Ab Initio load graphs to load tables in Oracle.
• Documenting of complete Ab Initio Graphs.
• Involved in unit testing of the Ab Initio graphs.
• Involved in meetings to gather information and requirements from the business.
• Written SQL scripts with .Sql extensions like Joins which will be used in Database Components of Ab Initio to extract the data from different source tables and to load the target table using Update DB and Load DB table components with the support of dbc file in graphs.
• Responsible for fully understanding the source systems, documenting issues, following up on issues and seeking resolutions.
• Reviewed Mapping documents provided by Business Team, implemented business logic embedded in mapping documents into Ab Initio Graphs and loading tables needed for Data Validation.
• Prepared Job scheduling docs and Job Stream List Using Tivoli Work Scheduler (TWS)for code migration to production.
• Prepared the Detailed Design Document for the all the modules required for development.
• Confirm the field mapping to the new data warehouse from the old data warehouse is identified for which the one-to-many and many to one fields are properly matched and resolved.

Environment: AbInitio GDE 1.13.26/1.13.6 , Co>Operating System 2.13.7/ 2.13.8 , UNIX, SQL, PLSQL, Windows 2000, Korn shell.

Confidential

Database Developer

Responsibilities:

• Study and analysis of the System
• Involved in creating tables, views, queries and stored procedures
• Interacted with functional users for developing application specifications
• Was responsible for the development of Tender module, Project Analysis and part of Financial Accounting
• Performed tuning of queries
• PL/SQL codes have been used extensively for the creation of forms and reports
• PL/SQL Scripts (Stored procedures and Functions) have been used for application Development.
• Involved in Integration and Acceptance testing
• Debugging of internal code for the forms and reports is done
• Developed forms and reports for an information system using Oracle 8.0
• Created tables based on the entities and attributes and there relations
• Enforced referential integrity’s and constraints

Environment: IBM AIX 4.1 with Oracle 9i, SQL, and PL/SQL