SUMMARY

• Over 10 years of experience in Data Warehouse System Analysis, Design, Development, Testing, Implementation and Maintenance of business applications using Ab Initio (2.1.5/3.1.6/3.1.7 ), Informatica(9.x), Unix Shell Script, Oracle PL/SQL, Teradata SQL and Utilities, DB2, SQL Server Reporting Services, Cognos Report Net/8 BI, Hyperion Interactive Reporting.
• Strong experience in writing UNIX Shell scripts and using utilities like sed, awk and grep.
• Strong experience in Relational Databases like Oracle, DB2, SQL Server and Teradata.
• Strong experience in using Teradata utilities like T Pump, Fast load and Multi Load.
• Strong experience in using Control M Desktop and work load Automation for job scheduling and monitoring.
• Strong experience in ETL production support, job monitoring and job scheduling
• Strong Experience in ETL Quality Assurance and Support.
• Very good knowledge in Data Modelling using Erwin Data Modeler.
• Certified Amazon Web Services (AWS) solutions architect - Associate.
• Very good understanding of Hadoop architecture, HDFS & Map Reduce 2.0 programming technique, and the five daemons of Hadoop - Name Node, Data Node, Job Tracker & Task Tracker.
• Very good knowledge in installation and configurations of Hadoop ecosystem components like Hive, HBase, Pig, Kafka, Spark and Sqoop.
• Very good knowledge on Horton Works Data Platform.
• Having experience in leading the offshore and onsite teams.
• Having good understanding and exposure in Agile Methodology.
• Well versed with all stages of Data warehouse development life cycle.
• Exposure to various areas of data migration and database design for Data Warehouse applications.
• Involved in customer interaction at onsite, requirements gathering, leading offshore teams.
• Strong analytical skills with ability to quickly understand client’s business needs and create specifications.
• Proficient in preparation of technical specifications and effort estimation.
• Seamlessly interacting between onsite and offshore for reviews and implementation.
• Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
• Work distribution among the team and responsible for the deliverable items on time.
• Worked with clients such as Confidential, CITI Bank, Capital One Financial Services and Confidential .
• Excellent communication, people, team building and interpersonal skills.
• Participated in system, integration, performance, and user acceptance testing for applications

TECHNICAL SKILLS

Business Domain: Ecommerce, Retail, Banking and Financial Services(Credit Cards, Mortgage and Auto loans)

ETL Tools: Ab Initio 2.1.5, 3.1.2,3.1.6,3.1.7, Web EME(Metadata Hub GUI), Informatica 9.x

Tools: Teradata SQL Assistant, PL SQL Developer, SQL Server Management Studio, HPSM, Maestro Console, Control M GUI, Desktop and Web Automation, Toad.

Business Intelligence Tools: SQL Server Reporting services 2008, Hyperion, Cognos 8 BI

Databases: Oracle 11g,ExaData, DB2,Teradata,SQL Server

Operating Systems: Windows XP/7, UNIX, Linux

Languages: SQL, Shell Scripting, Teradata BTEQ,XML

PROFESSIONAL EXPERIENCE

Confidential, PA

Ab Initio Developer

Responsibilities:

• Gathering requirements from Account/Client services Team.
• Discovery and Effort estimation for change requests.
• Preparing design document based on CRF document and Discovery results.
• Developing Ab initio graphs and UNIX scripts.
• Creating control M schedules in order to execute the Ab Initio graphs/deployed scripts
• Unit Test Case preparation for unit testing the ETL codes and Unix Shell scripts.
• Unit Test Result document preparation.
• Code promotion to System Testing and UAT regions.
• Coordination with testing team during QA testing phase
• Production deployment and post deployment validations
• Warranty Support and Level2, Level3 Production support
• Coordinating with offshore team.

Confidential, Plano TX

Ab Initio Developer

Responsibilities:

• Gathering requirements from BSA and analyzing the requirements.
• Source to target mapping walkthrough with BSA and incorporating technical details like source file/tables and target files/tables information.
• Preparing design document based on Source to Target Mapping provided by BSA.
• Developing ab initio graphs and parameter sets.
• Developing ab initio plans for executing graphs and psets in required sequence.
• Creating UNIX wrapper scripts for scheduling the ETL codes through Control M Scheduler jobs.
• Unit Test Case preparation for unit testing the ETL codes and wrapper scripts.
• Unit Test Result document preparation.
• Control M job related documentation for assisting Control M team to create jobs in production.
• Code promotion to System Testing and UAT regions.
• Coordination with testing team during QA testing phase
• Preparing production support hand over documentation for support team.
• Production deployment and warranty support production bug fixes

Environment: Ab Initio GDE 2.1.5, 3.1.2, UNIX Shell Scripting, Web EME, Control M, SQL Server.

Confidential, Schaumburg, IL

Ab Initio Developer

Responsibilities:

• Gathering requirements from BSA and analyzing the requirements.
• Source to target mapping walkthrough with BSA and incorporating technical details like source file/tables and target files/tables information.
• Preparing design document based on Source to Target Mapping provided by BSA.
• Developing ab initio graphs and parameter sets.
• Developing ab initio plans for executing graphs and PSets in required sequence.
• Creating UNIX wrapper scripts for scheduling the ETL codes through Control M Scheduler jobs.
• Unit Test Case preparation for unit testing the ETL codes and wrapper scripts.
• Unit Test Result document preparation.
• Control M job related documentation for assisting Control M team to create jobs in production.
• Code promotion to System Testing and UAT regions.
• Coordination with testing team during QA testing phase
• Preparing production support hand over documentation for support team.
• Production deployment and warranty support production bug fixes

Environment: Ab Initio GDE 2.1.5, 3.1.2, UNIX Shell Scripting, Web EME, Control M, Teradata.

Confidential, Atlanta, GA

Onsite Lead and Developer

Responsibilities:

• Closely interacted with IDM business team for understanding the business requirements.
• Closely interacted with the Data modeling team for understanding the application architecture and database tables design.
• Assigning the tasks to offshore team and monitoring the work progress.
• Leading the offshore team and getting daily status updates.
• Identifying the gaps in requirements and design and getting the clarifications from business users and providing the updates to the offshore team.
• Attending all the meetings with different stake holders and providing updates to offshore team.
• Creating high level, low level specification documents and unit test plan for offshore team.
• Reviewing the ETL codes and providing feedback to offshore team to make necessary improvements in the code.
• Reviewing the unit test results to ensure the code authenticity before promoting to test region.
• Coordinating with Offshore team to ensure the on time deliveries.
• Created UNIX scripts to transfer the source xml file from application servers to ETL server using FDQ process.
• Created graphs to transform xml data to flat files and applied various transformations in order to create full feed to hd.com and Channel Intelligence.
• Developed ab initio graphs to determine daily delta changes and create delta feed to hd.com and channel intelligence.
• Created UNIX scripts to send automatic email for any rejects occurred while creating delta or full feed to hd.com and Channel Intelligence.
• Created UNIX scripts to send job completion notification with feed summary to hd.com team
• Created graphs to transform xml data in order to create load ready files for BTE table’s full refresh.
• Developed AbInitio graphs to determine daily delta changes and create incremental load ready files for BTE table’s delta.
• Created UNIX scripts to send automatic email for any rejects occurred while loading the BTE tables.
• Designed and Developed the graphs using the GDE, with components like partition by round robin, partition by key, rollup, sort, sort with in groups, scan, dedup sorted, reformat, join, normalize, filter by expression, partition by expression, replicate, partition by key and sort Components
• Working with De-partition Components like Gather, concatenate and Interleave in order to de-partition and Repartition the data from Multi File accordingly.
• Performing transformations of source data with Transform components like Join, Rollup, Reformat and scan.
• Involved in Unit Testing the Ab Initio graphs and quality assurance and bug fixing.
• Involved in creating the operation manual and documentation for the hand-off.

Environment: Ab Initio GDE 3.1.2, Co>Operating System 3.1.2.6, UNIX, Oracle Exadata, EME, Toad and windows

Confidential

Offshore Lead and Ab Initio Developer

Responsibilities:

• Closely interacted with Ecatalog business team for understanding the business requirements.
• Closely interacted with the Data modeler for understanding the application architecture and database tables design.
• Assigning the tasks to offshore team and monitoring the work progress.
• Leading the offshore team and getting daily status updates.
• Identifying the gaps in requirements and design and getting the clarifications from business users and providing the updates to the offshore team.
• Attending all the meetings with different stake holders and providing updates to offshore team.
• Creating high level, low level specification documents and unit test plan for offshore team.
• Reviewing the ETL codes and providing feedback to offshore team to make necessary improvements in the code.
• Reviewing the unit test results to ensure the code authenticity before promoting to test region.
• Coordinating with Offshore team to ensure the on time deliveries.
• Developed unload, transform and load graphs to load the data into the staging area on Db2 database.
• Created UNIX scripts to send automatic email for any rejects occurred while loading the DB2 staging tables.
• Designed and Developed the graphs using the GDE, with components like partition by round robin, partition by key, rollup, sort, sort with in groups, scan, dedup sorted, reformat, join, normalize, filter by expression, partition by expression, replicate, partition by key and sort Components
• Working with De-partition Components like Gather, merge in order to de-partition and Repartition the data from Multi File accordingly.
• Performing transformations of source data with Transform components like Join, Rollup, Reformat and scan.
• Involved in Unit Testing the Ab Initio graphs and quality assurance and bug fixing.
• Involved in creating the production support manual and documentation for the hand over to support team.

Environment: Ab Initio GDE 3.1.2, Co>Operating System 3.1.2.6, UNIX, Db2, EME, Toad and windows 2000

Confidential

Offshore Lead and Ab Initio Developer

Responsibilities:

• Estimating the effort required for implementing the business requirements using ab initio.
• Produced design documents on a high level for the process involved to get the desired result
• Coordinate and Communicate with the On-site, discuss the same with the offshore team and coordinate work at offshore.
• Responsible for providing daily status updates to the onsite lead on behalf of offshore team.
• Ensure the overall quality of the project.
• Developing new AbInitio un-load graphs as per the requirements.
• Developed graphs to generate xml messages and published the messages into ab initio queue
• Develop HDDTM plans and Maestro codes to schedule the scripts.
• Creating SDS document and designing scripts to load the data model.
• Developed continuous flow graphs to publish the message to queue

Environment: AbInitio GDE 1.1.5, Co>Operating System 2.1.5, UNIX, Db2, EME, Toad and Windows2000

Confidential

Ab Initio Developer

Responsibilities:

• Estimating the effort required for implementing the business requirements using abinitio.
• Produced design documents on a high level for the process involved to get the desired result
• Coordinate and Communicate with the On-site, discuss the same with the offshore team and coordinate work at offshore.
• Created detailed design documents and the unit test plan.
• Developed Ab Initio graphs to implement the required business rules for processing of data before being loaded into DB2.
• Developed Ab Initio graphs to load the data into the DB2 and the Teradata databases.
• Developed automation plans and Maestro codes to schedule the scripts.
• Involved in Unit Testing the Ab Initio graphs and quality assurance and bug fixing.
• Used EME to maintain version control of the project, graphs and scripts.
• Project Monitoring and metrics reporting.

Environment: Abinitio GDE 1.1.5, Co>Operating System 2.1.5, UNIX, Oracle Exadata, EME, Toad and Windows2000

Confidential

BI Report Developer

Responsibilities:

• Gathered report requirements from business users.
• Prepared low level design documents for the changes required in the reports developed by SSRS2000.
• Modified the existing reports for the compatibility with SSRS2008.
• Unit test plan and test cases document preparation and unit testing of the reports.
• Coordinating with QA team during QA testing of the reports.
• Knowledge transition and turn over to the production support team.

Environment: SQL Server Reporting Services2000, 2008, DB2, Toad and Windows2000

Confidential

BI Report Developer

Responsibilities:

• Produced design documents on a high level for the process involved to get the desired result
• Prepared detailed design documents for the reports as per the business requirements document
• Developed End cap summary report with drill down capability to show the store level data
• Developed End cap detail report to display the data at SKU level with drill down capability to show the store level data.
• Developed the end cap trend report to provide the graphical view of the end cap sales at SKU level
• Involved in Unit Testing the SSRS reports and quality assurance and bug fixing.

Environment: SQL Server Reporting Services 2008, DB2, Toad and Windows2000, XP