SUMMARY

• Total 10 Years of Experience development, design, testing, and implementation with major focus on Data Warehousing, Database Applications and Business intelligence solutions using ETL tools like Ab Initio.
• Strong experience in Banking & Healthcare domain in implementing Data warehouse applications.
• Knowledge of full life cycle development for building a data warehouse.
• Worked on Traditional SDLC and Agile (SCRUM) Methodology.
• Strong experience in designing, developing and testing large scaled applications as per functional requirements using Ab Initio, Unix Shell scripting and SQL.
• Profound knowledge of Teradata database / utilities (Mload, Fload), UNIX Korn shell scripts and Wrapper scripts for high volume data warehouse instances.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing using Ab Initio.
• Experience in UNIX Shell Scripts including Korn Shell Scripts.
• Good knowledge in AbInitio Products like ACE and BRE.
• Knowledge with Ab Initio Business Rule Designer/Editor to define, design, document, and edit business rules and generate XFRs by using Rule sets in BRE (Business Rules Engine).
• Built an AI based generic application platform using ACE.
• Designed scalable architectures addressing parallelism, data integration, ETL, data repositories and analytics, making use of Ab Initio suite.
• Experience in various Ab Initio parallelism techniques and implemented Ab Initio Graphs using Data parallelism and MFS techniques.
• Experience in designing and implementing Ab Initio EME Metadata projects.
• Experience in creating teh Projects and Branches in EME.
• Experience with Ab Initio Cooperating System, application tuning and debugging strategies Proficient with various Ab Initio Parallelism and Multi File System technique
• Designed Ab - Initio graphs using GDE Conditional components.
• Automated ETL process using UNIX shell scripting for Production, Testing and development environment.
• Share / transfer knowledge on various projects / processes to new joiners on board as well as existing team members.
• Migrated jobs from development to QA to Production environments.
• Good Experience in Scheduler Tools like OP>CONSOLE, CTRL+M, Tivoli Schedulers.
• Ensure quality customer deliverables while leading and driving advanced / complex projects to successful completion.

TECHNICAL SKILLS

RDBMS: SQL, PL/SQL,My SQL, MS-Access, SQL Server 2008/2012, Oracle 9.2/10.2, Teradata

ETL Tools: Ab Initio Co>Operating system 2.15, 3.2.3.8, GDE 1.15,2.14,3.1.5,Informatica Power Center 6.2/8.1.1

Other Tools: Oracle SQL Developer, Microsoft SQL Server Management Studio, TOAD, MS Office Suite ACE (Application Configuration>Environment),Plan>IT (Conduct>IT)

Service Management: Service Now, HP Quality Center

Version Controls: EME(Enterprise Meta>Environment),Control M

Web/Scripting Languages: HTML, Unix Shell Scripts

Programming Languages: C, C++, Java

Operating Systems: Windows, UNIX and Linux

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, Georgia

ETL Developer & Ab Initio

Responsibilities:

• Interacted with business/user groups to understand teh business process and gather requirements.
• Involved in creating detail data flows with source and target mappings and convert data requirements into low level design templates.
• Analyzed business needs and documented functional and technical specifications based upon user requirements with extensive interactions with business users.
• Involved in all teh stages of SDLC during teh project. Analyzed, designed and tested teh new system for performance, efficiency and maintainability using ETL tool AB INITIO
• Improved performance of Ab Initio graphs by using various Ab Initio performance techniques like using lookups in memory joins and rollups to speed up various Ab Initio graphs.
• Helped ETL team to develop Ab-Initio graphs using Ab-Initio Parallelism techniques, Data Parallelism and MFS Techniques with teh Conditional Components and Conditional DML for teh data load from source to new Target.
• Design and development of Ab Initio graphs to as per teh business requirements by following teh best coding standards.
• Modified teh Ab-Initio components parameters, utilize data parallelism and theirby improve teh overall performance to fine-tune teh execution times.
• Performed unit testing and integrate testing by validating teh data for all teh business and technical functionality before deploying teh code.
• Prepared teh problem definition guide and shared to testing and production support team.
• Performed code review by following teh standard code review check lists and submitted teh Code QA documents.
• Worked on Release notes documents with all teh necessary information with clear run instructions for end to end testing.

Environment: Ab Initio GDE 3.1.7, Co>Operating System 3.0.4,Oracle, Teradata, DB2, Mainframe, UNIX, HP Quality Center

Confidential, Schaumburg, IL

ETL Developer & Ab Initio

Responsibilities:

• Developed and supported teh extraction, transformation and load process (ETL) for teh Data Warehouse from heterogeneous source systems using Ab Initio.
• Involved in development of ab initio graphs for loading and extracting data from various schemas relating to oracle database.
• Involved in creating sandbox in Ab Initio through GDE and as well running teh shell script.
• Worked with implementing MFS (multi file systems) and deployed MPP technique to perform VLDB data warehouse instance.
• Responsible for creating multi file system dat is composed of individual files on dat are partitioned and stored in distributed directories.
• Designed a graph for maintaining teh history of data with retaining teh surrogate key using Assign Key component.
• Used UNIX environment variables in All teh Ab Initio Graphs, which comprises of specified locations of teh files to be used as source and target.
• Tracking of projects - tracking progress of deliverables,maintaining alignment with external Testing Teams and maintaining interaction with users.
• Reviewed data mapping, design documents, Ab Initio code, Unit Test Cases.
• Reviewed automate test harness graphs before deploying teh code to testing environment.
• Worked on creating app configuration using Ab Initio ACE as per teh business requirements
• Designed and deployed well-tuned Ab Initio graphs (Generic and custom)

Environment: Ab Initio GDE 3.1.5, Co>Operating System 3.0.4,BRE, ACE, Teradata,UNIX,OpsConsole

Confidential

ETL Developer, Ab Initio

Responsibilities:

• Understanding teh Business requirements, co-ordination with designers and Business Analysts directly.
• Involved in all teh stages of SDLC during teh project. Analyzed, designed and tested teh new system for performance, efficiency and maintainability using ETL tool AB INITIO
• Designed and Developed teh generic graphs using teh GDE, with components sort, reformat, replicate, assign key, join, merge, gather, components.
• Used Various inbuilt functions like lookup,lookup match, lookup local, string filter out were effectively used in various transform functions
• Extensively used teh Ab Initio tool’s feature of Component, Data and Pipeline parallelism.
• Created teh ACE configurations for teh entire process like dimension processing, Fact processing.
• Created and checked in teh input and output data sets for teh BRE process and incorporated teh BRE xfr’s in teh graph transformations.
• Created teh Conduct>it plans for teh end to end process for teh end to end testing.
• Created teh project level and incremental tags to promote teh code to different environments SIT, UAT, Prep prod environments.
• Closely worked with testing team to complete teh testing smoothly.
• Worked on defects raised by testing team, thoroughly analyzed and fixed teh incidents and deployed for retest.
• Worked on Automate test harness graphs and tested teh end to end code before deploying to different environments.

Environment: AbInitio 2.15, CO>OS, Oracle, UNIX,BRE, SQL Plus, HP Quality Center, Windows NT.

Confidential

ETL Developer, Ab Initio

Responsibilities:

• Developed and Implemented extraction, transformation and loading teh data using Ab Initio Metadata mapping from source system to target database fields and involved in creating Ab Initio DMLs and written complex XFRs for implementing teh 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 Join, Normalize, Reformat, Rollup and Scan Components.
• Gathering teh knowledge of existing operational sources for future enhancements and performance optimization of graphs.
• Involved in writing wrapper scripts to run teh graphs, to load into Data Warehouse and to verify teh counts while loading.
• Used Parallelism techniques to partition and process large data simultaneously.
• Used UNIX environment variables in All teh Ab Initio Graphs, which comprises of specified locations of teh files to be used as source and target.
• Followed teh Deployment process to promote code from DEV to SIT and UAT environment to test & validate data.

Environment: Ab Initio 1.13, Co>Operating System 2.14, UNIX, HP Quality Center,WinSCP Oracle9i, TOAD, Windows NT

Confidential

ETL Developer, Ab Initio

Responsibilities:

• Understanding teh Business requirements, co-ordination with designers and Business Analysts directly.
• Worked in teh Data Management Team on Data Extraction, Data Cleansing and Data Validation.
• 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, Merge etc.
• Extensively used teh Ab Initio tool’s feature of Component, Data and Pipeline parallelism.
• Developed UNIX shell scripts for Archiving, Data Loading procedures and Validation.
• Tested and tuned teh Ab Initio graphs and Oracle SQL’s for better performance.
• Supported teh testing team (SIT, UAT environment) implementation as part of change/enhancements for teh application by developing, modifying teh existing code.
• Worked and resolved teh defects raised by testing team and deployed teh code by following teh deploying process.

Environment: Ab Initio 1.13, Co>Operating System 2.14, UNIX, HP Quality Center,WinSCPOracle9i,TOAD, Windows NT