SUMMARY

• Over 12 years of experience in full Software Development Life Cycle (SDLC) and Agile/Scrum analysis, design, development, testing, implementation and maintenance in data warehousing environment.
• Experience in implementing Data warehouse and data base applications with Ab Initio, Informatica ETL in addition with data modeling and reporting tools on Teradata and Oracle.
• 2 years of work in Hadoop Big Data(Hive, Pig) and Could Solution(AWS)
• Worked and Implemented AWS solutions, has worked several AWS components: EC2, S3, CFT, Lambda, SNS, SQS, Redshift, VPC, Subnet, Security Group, NACL
• Implemented AWS solution in banking Domain with PA - DSS complaint
• Code deployment in Cloud using GIT, Jenkins and Chef
• Highly experienced in ETL tool Ab-Initio using GDE Designer.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables
• Good experience with Data Migration, Data Transformation and Data Loading using ETL with RDBMS and file systems such as Mainframe, XML files.
• Very good understanding of Teradata’s MPP architecture such as Shared Nothing, Nodes, AMPs, BYNET, Partitioning, Primary Indexes etc.
• Extensively used different features of Teradata such as BTEQ, Fastload, Multiload, TPT, SQL Assistant, DDL and DML commands.
• Well versed with Ab Initio parallelism techniques and implemented Ab Initio Graphs using Data parallelism, MFS techniques, Continuous Flows, Component folding and PDL features.
• Involved in using EME version control.
• Expertise in various Ab Initio component groups like Partition, De-partition, Database, Datasets, Transform, FTP, Sort and Miscellaneous.
• Developed various UNIX shell scripts to run Ab Initio and Database jobs. Practical experience with working on multiple environments like production, development and testing.
• Very good experience in Oracle database application development using Oracle 10g/9i/8i/x, SQL, PL/SQL, SQL*Loader. Strong experience in writing SQL, PL/SQL-Stored Procedures, Functions and Triggers.
• Provided Production support and flexible in managing multiple projects.
• Extensive experiences in UNIX shell scripting to automate and schedule the jobs.
• Self-initiative, excellent analytical and communication skills, ability to work independently
• Has good exposer to Open-source Environment like BigData, Hadoop, pig and hive

TECHNICAL SKILLS

Could Solution: AWS Solution Architect Associate Certified

ETL Tools: Ab Initio (GDE 3.1.1 Co>Operating system 3.1.1.2), EME

BI Tools: Cognos

RDBMS: Teradata V2R12/6/5, Oracle 8.0/8i/9i/10g, MS Access, MS SQL Server.

Languages: Python, SQL, PL/SQL, PERL Scripting and Korn Shell Scripting.

Open source: BigData Hadoop, Hive, Pig

Scheduling and others: Control M

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Ab Initio Tech Lead

Environment: Ab Initio (GDE 3.1.4, Co>operating system 3.1.1), Oracle 10g, Teradata V2R6, Teradata, Hadoop, Hive, Pig, SQL Assistant, SQL, PL/SQL, Shell Scripts, TOAD .

Responsibilities:

• Involved in understanding the requirements of the End Users/Business Analysts to model the Pricing Data Mart for better customer satisfaction and revenue gains
• Developed/Modified subject area graphs based on business requirements using various Ab Initio components like Filter by Expression, Partition by Expression, reformat, join, gather, merge, rollup, normalize, denormalize, scan, replicate etc.
• Developed Complex Ab Initio XFR’s to derive new fields and solve various business requirements.
• Extensively worked under Unix Environment using Shell Scripts and Wrapper Scripts. Responsible for writing the wrapper scripts to invoke the deployed Ab Initio Graphs.
• Performed potential transformations at the staging area, such as cleansing the data (dealing with missing elements, parsing into standard formats) combining data from multiple sources, de-duping the data and assigning surrogate keys.
• Created tables, views in Teradata according to the requirements.
• Analyze business requirements and develop metadata mappings. Involved in preparing high level and detailed design documents, ETL-Spec Document, Test Cases.
• Used Ab Initio to extract, transform and load data from multiple input sources like flat files, Oracle files to the database.
• Created parameterized common components and sub Graphs to impose application/business restrictions.
• Performed bulk data load from multiple data source (ORACLE 8i, legacy systems) to TERADATA RDBMS using BTEQ, Fastload, Multiload and TPump.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Developed scripts to load high volume data into empty tables using FastLoad utility.
• Used FastExport utility to extract large volumes of data at high speed from Teradata RDBMS.
• Extensively used Ab Initio tool’s feature of Component, Data and Pipeline parallelism.
• Used phases and checkpoints in the graphs to avoid the deadlocks, improve the performance and recover the graphs from the last successful checkpoint.
• Used Ab Initio Web Interface to Navigate the EME to view graphs, files and datasets and examine the dependencies among objects.
• Extensively used Ab Initio built in string, math, and date functions.
• Provided 24*7 extended supports during the production rollout.
• Worked on database connections SQL joins, Loops, Materialized Views, Indexes, aggregate conditions, parsing of objects and Written PL/SQL procedures and functions for processing business logic in the database.
• Used Enterprise Meta Environment (EME) for version control, Control-M for scheduling purposes.
• Involved in Unit testing, System testing and debugging during testing phase.
• Good experience with Data Migration, Data Transformation and Data Loading using ETL with RDBMS and XML file system.

Confidential, Irving, TX

Sr. Ab Initio Developer

Environment: Ab Initio (GDE 1.14/1.15, Co>operating system 2.14/2.15), Oracle 10g, Teradata V2R6, Teradata SQL Assistant, SQL, PL/SQL, Shell Scripts, TOAD .

Responsibilities:

• Performed Analysis, designing and preparing the functional, technical design document and code specifications.
• Developed and supported the extraction, transformation and load process (ETL) for a Data Warehouse from their OLTP systems using Ab Initio and provide technical support and hands-on mentoring in the use of Ab Initio.
• Responsible for all pre-ETL tasks upon which the Data Warehouse depends, including managing and collection of various existing data sources.
• Involved in developing UNIX Korn Shell wrappers to run various Ab Initio Scripts.
• Developed Ab Initio XFR’s to derive new fields and solve various business requirements.
• 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, Broadcast, merge etc.
• Worked on improving the performance of Ab Initio graphs by using various Ab Initio performance technique’s like using looks instead of Join’s etc.
• Implemented Lookup’s, lookup local, in-Memory Joins and rollup’s to speed up various Ab Initio Graphs.
• Design Documentation for the developed graphs.
• Created mapping document and ETL design document.
• Good understanding of new Ab Initio features like Component Folding, Parameter Definition Language (PDL), Continuous flows, Queues, publisher and subscriber components.
• Used Parameter Definition language (PDL) in writing DML to execute the graphs without writing scripts or deploying using air commands.
• Created UNIX shell scripts to automate and schedule the jobs.
• Created the migration scripts, test scripts for testing the applications, creating and supporting the Business Objects reports.

Confidential

AbInitio Developer

Environment: Ab Initio (GDE 1.14/1.15, Co>operating system 2.14/2.15), Oracle 10g, Teradata V2R6, Teradata SQL Assistant, SQL, PL/SQL, Shell Scripts, TOAD .

Responsibilities:

• Performed Analysis, designing and preparing the functional, technical design document and code specifications.
• Developed and supported the extraction, transformation and load process (ETL) for a Data Warehouse from their OLTP systems using Ab Initio and provide technical support and hands-on mentoring in the use of Ab Initio.
• Responsible for all pre-ETL tasks upon which the Data Warehouse depends, including managing and collection of various existing data sources.
• Involved in developing UNIX Korn Shell wrappers to run various Ab Initio Scripts.
• Developed Ab Initio XFR’s to derive new fields and solve various business requirements.
• 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, Broadcast, merge etc.
• Worked on improving the performance of Ab Initio graphs by using various Ab Initio performance technique’s like using looks instead of Join’s etc.
• Implemented Lookup’s, lookup local, in-Memory Joins and rollup’s to speed up various Ab Initio Graphs.
• Design Documentation for the developed graphs.
• Created mapping document and ETL design document.
• Good understanding of new Ab Initio features like Component Folding, Parameter Definition Language (PDL), Continuous flows, Queues, publisher and subscriber components.
• Used Parameter Definition language (PDL) in writing DML to execute the graphs without writing scripts or deploying using air commands.
• Extensively used the Teradata utilities like BTEQ, Fastload, Multiload, TPump, DDL Commands and DML Commands (SQL).
• Involved in writing complex SQL queries based on the given requirements and created series of Teradata Macros for various applications in Teradata SQL Assistant and performed tuning for Teradata SQL statements using Teradata Explain command.
• Created UNIX shell scripts to automate and schedule the jobs.
• Created the migration scripts, test scripts for testing the applications, creating and supporting the Business Objects reports.
• Involved in the integration testing with ETL developers and User Acceptance Testing (UAT) with Business Analysts.
• Performed physical data modeling, performing regular refreshes of development and test database environments using the Export/Import utility.