SUMMARY:

• Around 8 years of IT consulting experience in Analysis, Design, Development, Testing and maintenance of data warehouse systems and over 5 years of industry experience in developing strategies for ETL technology using Ab Initio tool in complex, high volume Data Warehousing projects in both Windows and UNIX environment.
• Experienced in all phases of Software Development Life Cycle (SDLC)
• Worked extensively with Ab Initio GDE, developing graphs and validating the data against the business requirements.
• Involved in creating Express - It templates and under line generic Graphs creation and support.
• Participated in ACE-BRE work sessions to give knowledge transfer to business team on template design and usage.
• Well versed with various Ab Initio parallelism techniques and implemented Ab Initio Graphs using Data parallelism and Multi File System (MFS) techniques.
• Worked with multifile systems that consist of various depths such as 4-way, 8-way, 16-way etc.
• Along with developing batch graphs, have worked on advanced concepts like Continuous flows and optimization. Also implemented concepts like Component Folding and Dynamic script generation which has brought extreme delight to client
• Worked with Conduct>IT and plans, EME and BRE.
• Coded and well-versed with UNIX shell scripting. Coded well-tuned Oracle and UNIX Shell (ksh, csh) scripts for OLTP warehouse instance.
• Experience in Ab Initio EME/Sandbox to implement version control and impact analysis to manage various project across the organization.
• Good understanding of Ab initio concepts such as Check Point, Phase, various component performances.
• Good understanding of AB Initio Graphs parameters to make the graph generic.
• Good knowledge in Ab Initio Co->Op m * commands.
• Experience in Using CFG (Continuous Flow Graphs) and also develop graphs for batch processing.
• Experience in working with Data Profiler and Business Rule Engine (BRE).
• Used Conduct>IT for job scheduling wherein created several plans using resources.
• Developed Complex Ab Initio XFRs to derive new fields and resolve various business requirements.
• Experience with Ab Initio Co>Operating System, application tuning and debugging strategies
• Expert in coding SQL, PL/SQL stored procedures, Triggers and Packages.
• Provided the 24x7 support for production and testing daily, monthly and weekly data refresh and worked with fixing complex/critical production problem.
• Knowledge of Version Control tool Clear Case and defect tracking tools like Clarify and Clear Quest.
• Experience in DBMS Utilities such as SQL, PL/SQL, TOAD, SQL Server, SQL*Loader, TeradataSQL Assistant.
• Extensively worked in Agile Methodology and well acquainted with nomenclature of agile environment.
• Having experience in coordination with Onsite and Offshore teams.
• Excellent Communication skills in interacting with various people of different levels on all projects and also playing an active role in Business Analysis.
• Effective Team Player with excellent quantitative, analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

Relational Databases: Teradata V2R 12.0/6.0/5.0, SQL Server 20 / 7.0, MS-Access 2000/2003/2007, Oracle 9i & 10g, Netezza.

Database Tools: SQL Server Enterprise Manager, Query Analyzer, AQT, ODBC.

Programming Languages: C, C++, C#, JAVA, XML, UNIX Shell Scripts, SQL/PLSQL

Operating Systems: UNIX (HP, Solaris, AIX), Linux, Windows Vista/windows7/XP/2003/2000/NT /2000 server.

ETL: Ab Initio (GDE 3.1.1/2.15/2.1 x/1.1X), Co>Operating System 3.15, 2.15, 2.14), Informatica 9.0, DATASTAGE, SSIS.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Ab Initio Developer

Responsibilities:

• Involved in creating Express-It templates.
• Worked with business users to debug template issues and helped them to create BRE rules.
• Created Generic Graphs to support customer driven templates.
• Modified the Ab Initio graphs to utilize data parallelism and thereby improve the overall performance to fine-tune the execution times.
• Created ETL jobs to load user defined eme datasets from different databases to address lineage issues.
• Created plans to run ab initio graphs. Used resource pools and loops to run multiple jobs in parallel.
• Used Conduct-It plans extensively to log audit information in to tables, running graphs and to log failures in to database using store procedures in inherited methods.
• Worked with the Production Services Group to implement the various projects promoted to Production environment.
• Created detail design documents and run book for production support team.
• Performed Unit Testing and responsible for the promotions to QA environment.

Environment: Ab Initio GDE 3.1.1/3.2.1.1/3.2.3.2, Co > Operating System 3.1.4/3.2.3.6, Control Center 3.2.1/TRMC Oracle10g, SQL Server, Java, HTML/XML, MQ Series, Linux, Autosys.

Confidential, Charlotte, NC

Sr. Ab Initio Developer

Responsibilities:

• Involved in analysis of end user requirements and business rules based on given preliminary design documentation and working closely with tech leads and data analysts in understanding the current system.
• Used Ab Initio GDE to generate complex graphs for transformation and loading of data into Staging and Target Database areas.
• Worked with Java developer’s teams to automate the migration process to lower environments and created a job which will trigger automation process.
• Modified the Ab Initio graphs to utilize data parallelism and thereby improve the overall performance to fine-tune the execution times.
• Created a generic Ab initio job for automation testing like compare source and target tables, duplicate check in target. Created a generic job to verify data quality for flat files, before processing.
• Created the detail design documents and run books for generic jobs.
• Performed Unit Testing and responsible for the promotions to QA environment.
• Created Autosys Jobs to schedule ETLs.
• Used PDL and Shell interpretations to resolve the graph level parameters.
• Created test cases and data validation for UAT.
• Responsible for trouble shooting, identifying and resolving data problems, worked with analysts to determine data requirements and identify data sources, provide estimates for task duration.
• Worked with Production Service and Automation teams to debug issues in production and for migrations from Pre-prod to Production.
• Worked with Oracle and Netezza DBA teams to create stored procedures and resolve database issues.
• Involved in Load testing in different environments and System Integration Testing (SIT) and User Acceptance Testing (UAT).
• Coordinating with different teams like User Interface (UI), Data Analyst (DA) and Load Testing team by arranging meeting and discussions.

ENVIRONMENT: Ab-Initio 2.1.4/3.0, Oracle10g, Netezza, Java, AIX, Linux, Micro Strategy, Autosys.

Confidential, Columbus, OH

Sr. Ab Initio Consultant

Responsibilities:

• Involved in developing Detail Design documents which describes the low level information of the implementation details.
• Created Ab Initio Graphs for Data flow processes to load data in data marts and worked with EME for code repository and used phases to divide the graphs and created checkpoints.
• Used Call Web service component to interact with the Services.
• Good hands on processing mainframe (MVS) files.
• Created DMLs based on the COBOL copybooks using the cobol-to-dml utility.
• Creating Graph level and Project level parameters according to the requirements or psets.
• Created Multiple XFR’s to support generic extract.
• Worked on generating the PSETS with the generic extracts.
• Used PDL and Shell interpretations to resolve the graph level parameters.
• Created the automated jobs using Operational console.
• Created test cases and data validation for UAT.
• Worked on improving the performance of Ab Initio graphs by using Various Ab Initio performance techniques like using lookups (instead of joins),In-Memory Joins to speed up various Ab Initio Graphs.
• Responsible for trouble shooting, identifying and resolving data problems, worked with analysts to determine data requirements and identify data sources, provide estimates for task duration.
• Worked with multi-file data for parallel processing and deployed jobs onto test staging area.
• Debugged various Ab-Initio Graphs using File Watchers for monitoring the intermediate results.
• Deployed graphs as executable Korn Shell scripts in the application system.
• Promotion of project from Development to SIT and UAT to Production.
• Involved in Load testing in different environments and System Integration Testing (SIT) and User Acceptance Testing (UAT).
• Coordinating with different teams like User Interface (UI), Data Analyst (DA) and Load Testing team by arranging meeting and discussions.

ENVIRONMENT: Ab Initio GDE 3.1.1, Co > Operating System 3.1.4, AIX, Ops-Console, Mainframe, Linux,, Distributed DB2, Teradata SQL Assistant/Administrator 12.0

Confidential, Dallas, TX

Sr. Ab initio Developer

Responsibilities:

• Worked closely with Business Analysts to make sure that all specs are understandable and good for development and
• Arranged meetings with Business Analysts and Subject Matter Experts to identify, discuss and resolve issues corresponding to the enhancements and gradually developed detailed design documents.
• Developed several Ab Initio graphs for extracting, transforming, cleansing and loading the various Data warehouse tables based on the business requirements.
• Worked on improving the performance of Ab Initio graphs by using Various Ab Initio performance technique’s like using lookups instead of Join’s, In-Memory Joins and rollup’s to speed up various Ab Initio Graphs etc.
• Extensively used the Ab Initio components like Reformat, Join, Fuse, Partition by Key, Partition by Expression, Merge, Gather, Sort, Dedup Sort, Rollup, Scan, Lookup. Used Ab Initio features like MFS, check point, phases etc.
• Used environment variables in all the Ab Initio graphs, which comprises of specific locations of the files to be used as source and target.
• Developed the scripts to automate the application builds and deployments within the environments.
• Responsible for System, Integration and UAT testing and documentation of complete Ab Initio Graphs.
• Involved in the production support.
• Worked on IBM Tivoli workload scheduler (TWS) to schedule the jobs in production.
• Used inquiry and error functions like is valid, is error, is defined and string functions like string substring, string concat and other string * functions in developing Ab Initio graphs to perform data validation and data cleansing.
• Creating Graph level and Project level parameters according to the requirements for psets
• Change management standards, Issue resolution process, Database change requests were strictly followed during various phases of environment i.e. development, testing and production environments.
• Worked in leading the off-shore team of four, assigning work and helping them with better understanding of the requirements.

ENVIRONMENT: AbInitio GDE 1.14/2.14/3.1. x, Co>Operating System 2.15, AIX UNIX, MVS, Datastage, Oracle 8.x, DB2, Teradata SQL Assistant/Administrator 12.0, IBM Tivoli Scheduler, HTTP Server, Unix shell scripts

Confidential, Austin, Texas

Sr. Ab Initio Developer

Responsibilities:

• Followed established software development guidelines and procedures as per Confidential standards.
• Involved in understanding the Requirements of the End Users/Business Analysts and Developed Strategies for ETL processes.
• Extensively used the Ab Initio tools feature of Component, Data and Pipeline Parallelism to improve Performance for existing ETL process.
• Developed Ab Initio graphs using components like Reformat, Sort, Filter by expression, Replicate, Join, Rollup, partitioning component and De-partitioning component based on the mapping documents provided by Data Analysts
• Worked with the Ab Initio corporate support team in development/enhancement of the existing models by adding extensions according to the business needs.
• I was involved in ETL code migration from Dev to Production using the HEATS (Home depot Customized tool) Utility
• I was involved in the ETL code Migration from WCS5.6 to WCS7
• Worked closely with Testing team to perform the System testing, Component testing, regression to make sure the data validation in compliance with requirement.
• Co-ordinated with an off-shore team of a group of 4 and communicated the requirements and made the project to complete in time.
• Coordination with other Teams or third parties during crisis or system recovery situations to solve the issues.
• Created automation Scripts that we work on daily basis.
• I was involved in the Implementation support (Request for Change (RFC)) as per Standard Operating Procedures.
• Created production Support document updates on a regular basis and Worked on Production data issues and break fixes
• Worked on IBM Tivoli workload scheduler (TWS) to schedule the jobs in production.

Environment: : Ab initio Co-op 2.15,GDE1.15, DB2 9.7,AIX 7, LINUX, 12.0, Teradata SQL Assistant/Administrator 13.0, Ab initio EME,, Oracle9.0.1, Microsoft Visio, TWS,HP Quality Center 10.00, Windows XP 2002, MS Outlook 2007

Confidential

Sr. Ab Initio Developer

Responsibilities:

• Followed established software development guidelines and procedures as per the BCBSNC standards.
• Worked with the Ab Initio team in development/enhancement of the existing models by adding extensions according to the business needs.
• Communicate clearly and effectively with the development/QA team, business users and DA/DBA groups.
• Developed Ab Initio graphs using Database components to extract data from CDW and send the data to downstream applications.
• Extensively worked on the Generic process of creation Load Ready Files (LRF) and using the Generic Loader to load to the Target tables.
• 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.
• Prepare code documentation in support of application development, including high level and detailed design documents, unit test specifications, interface specifications and also provided technical solutions for the Process requests raised by Data team to fix the issues in the existing system.
• Created test cases and performed unit testing for the Ab Initio graphs. Documented Unit testing. Logged and resolved defects in the roll out phase.
• Extensively used EME for Version Control System and for Code Promotion.
• Worked on various projects like Member, Provider, Pharmacy and Claim Bundle projects to bring multiple source data to the Enterprise Data warehouse (EDW) from Corporate Data warehouse (CDW).
• Excellent knowledge in Various Heterogeneous Source System like Oracle, Teradata, MS SQL Server, DB2,Flat files and Legacy Systems.
• Worked on developing Ab initio graphs, apply transformations based on the business requirements and loaded into TERADATA database.
• Created the Test Cases on various forms of the application.
• Performed extensive Backend Testing using SQL
• Automation of load processes Using Control-M.

Environment: Ab initio Co>Op 2.15, GDE 1.15,TERADATA 12.00.03.03, Teradata SQL Assistant/Administrator 12.0, DB2, Ab initio EME, Oracle9.0.1, Microsoft Visio, Control-M 6.4, HP Quality Center 10.00, Windows XP 2002, MS Outlook 2007