SUMMARY

• Total 11 Years of Experience development, design, testing, and implementation with major focus on Data Warehousing, Database Applications and - intelligence solutions using ETL tools like Ab Initio, Informatica.
• 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 Ab Initio Products like ACE and BRE, Conduct >IT.
• 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).
• 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 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 scripts for Production, Testing and development environment.
• Share / transfer knowledge on various projects / processes to new joiners on board as well as existing team members.
• Good Experience in Informatica tools Designer, Workflow manager, Workflow Monitor.
• 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.
• Attended training on BI Visualization Tool Tableau. Able to create interactive dashboards with various tableau visualizations.
• Have zeal to work by stretch towards meeting project deliverables and timelines.

TECHNICAL SKILLS

RDBMS: SQL, PL/SQL, My SQL, SQL Server 2008/2012, Oracle 9.2/10.2, Teradata, Netezza

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, Tableau, ACE (Application Configuration>Environment), Plan>IT (Conduct>IT), Express>IT

Service Management: Service Now, HP Quality Center, Clear Quest

Version Controls: EME (Enterprise Meta>Environment), Clear Case

Web/Scripting Languages: HTML, Unix Shell Scripts

Programming Languages: C, C++, Java

Operating Systems: Windows, UNIX and Linux

Job Schedulers: Control M, AutoSys

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, Georgia

SR ETL Specialist

Responsibilities:

• Interacted with business/user groups to understand the 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 the stages of SDLC during the project. Analyzed, designed and tested the 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 the Conditional Components and Conditional DML for the data load from source to new Target.
• Design and development of Ab Initio graphs to as per the business requirements by following the best coding standards.
• Developed generic reusable graphs to run for different source data.
• Modified the Ab-Initio components parameters, utilize data parallelism and thereby improve the overall performance to fine-tune the execution times.
• Performed unit testing and integrate testing by validating the data for all the business and technical functionality before deploying the code.
• Prepared the problem definition guide and shared to testing and production support team.
• Performed code review by following the standard code review check lists and submitted the Code QA documents.
• Developed the Ab Initio Plans using Conduct >IT to perform the Automation of end to end testing.
• Worked on Release notes documents with all the necessary information with clear run instructions for end to end testing.
• Support System Integration Testing (SIT) and User Acceptance Testing (UAT) as needed

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

Confidential, Schaumburg, IL

SR ETL Specialist

Responsibilities:

• Developed and supported the extraction, transformation and load process (ETL) for the 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 the 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 that is composed of individual files on that are partitioned and stored in distributed directories.
• Designed a graph for maintaining the history of data with retaining the surrogate key using Assign Key component.
• 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.
• 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 the code to testing environment.
• Worked on creating app configuration using Ab Initio ACE as per the 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, Ops Console, Informatica Power Center.

Confidential

ETL Specialist

Responsibilities:

• Understanding the Business requirements, co-ordination with designers and Business Analysts directly.
• Involved in all the stages of SDLC during the project. Analyzed, designed and tested the new system for performance, efficiency and maintainability using ETL tool AB INITIO
• Designed and Developed the generic graphs using the 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 the Ab Initio tool’s feature of Component, Data and Pipeline parallelism.
• Created the ACE configurations for the entire process like dimension processing, Fact processing.
• Created and checked in the input and output data sets for the BRE process and incorporated the BRE xfr’s in the graph transformations.
• Created the Conduct>it plans for the end to end process for the end to end testing.
• Created the project level and incremental tags to promote the code to different environments SIT, UAT, Prep prod environments.
• Closely worked with testing team to complete the testing smoothly.
• Worked on defects raised by testing team, thoroughly analyzed and fixed the incidents and deployed for retest.
• Worked on Automate test harness graphs and tested the end to end code before deploying to different environments.
• Created the ACE Configurations and developed BRE rulesets using Express>IT.
• Worked on the L3 Production activities to fix the incidents.
• Worked on problem records to provide a permanent fix for the frequently occurring incidents.
• Through testing the code in all the environments before promoting the code to the production environment.
• Hands on experience on Fixing Auto and User incidents and timely updating the problem definition guide for new issues.
• Worked with Mainframe Tivoli Scheduler to monitor the status of the jobs, view the error logs, check the dependences predecessors & successors, copy the mainframe datasets from different environments, perform the Ezi Copy to copy the data.

Environment: Ab Initio 2.15, CO>OS, Oracle, UNIX, Express>IT, SQL Plus, HP Quality Center, Service Now, Mainframes, Ops Console, Windows NT.

Confidential

ETL Specialist

Responsibilities:

• Developing Ab Initio graphs as daily and monthly cycle for loading, partitioning, cleaning and Populating the data based on legal and business requirements.
• Worked with Partition components like partition by range, Partition by Round Robin, partition by Expression efficient use of Multifile system which comes under Data Parallelism.
• Performing transformations of source data with Transform components like Replicate, Denormalize, Redefine, Reformat, Filter-by-Expression, Rollup etc.
• Used Lookups with Reformat component to fetch matching records based on for the downstream process.
• Used Sort component to sort the tables, and used Dedup Sort to remove duplicate values.
• Used Rollup component to populate monthly, quarterly and annual summary tables.
• Used Data Parallelism, Pipeline Parallelism and Component Parallelism in Graphs, where huge data files are partitioned into multifiles and each segment is processed simultaneously.
• Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like check-in and checkout were used for this purpose.
• Worked with departition components Gather, Merge which will be used for add the files which is done partition for fast process of data files.
• Used Ab Initio Components like Sort, Partition, Rollups, Reformat and Merge to build complex graphs.
• Supporting to the SIT team.

Environment: Ab Initio, Teradata, UNIX, BRE, HP Quality Center, Windows NT, Informatica Power Center.

Confidential

ETL Specialist

Responsibilities:

• Developed and Implemented extraction, transformation and loading the 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 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 Join, Normalize, Reformat, Rollup and Scan Components.
• Gathering the knowledge of existing operational sources for future enhancements and performance optimization of graphs.
• 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.
• 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.
• Followed the 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 Specialist

Responsibilities:

• Understanding the Business requirements, co-ordination with designers and Business Analysts directly.
• Worked in the 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 the 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 the Ab Initio graphs and Oracle SQL’s for better performance.
• Supported the testing team (SIT, UAT environment) implementation as part of change/enhancements for the application by developing, modifying the existing code.
• Worked and resolved the defects raised by testing team and deployed the code by following the deploying process.

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