SUMMARY

• Over eight years of IT experience in all phases of the Software Development Life Cycle analysis, design, development, test, implementation and production support with extensive exposure to data warehousing and business intelligence.
• Experience with Ab Initio Co, operating system 3.1.2/2.15, application tuning and debugging strategies. Proficient with various Ab Initio parallelism and multi file system techniques.
• Used Ab Initio EME/Sandbox to implement version control and impact analysis to manage various projects across the organization.
• Worked with designing Ab Initio graphs generic or parameterized for various data warehouse and data mart ETL processes.
• Sound knowledge of dimensional modeling concepts and design of data warehouse with the elements of STAR and SNOWFLAKE schemas.
• Experience designing, developing and testing large scaled applications as per functional requirements using Ab Initio, UNIX , Unix Shell scripting and SQL.
• Strong experience in relational databases like Teradata, DB2, Oracle, and SQL server.
• Hands on experience in end-to-end of data warehousing ETL routines, which includes writing custom scripts, stress testing, data mining and data quality process.
• Exposure to various areas of data migration and database design for the data warehouse applications.
• Experienced as an ETL lead developer and designer.
• Involved in customer interactions offshore and onsite as well as requirements gathering, development, construction, testing, production deployment and production support.
• Also involved in leading teams onsite a three member team and offshore six members at the same time.
• Proficient in preparation of technical specifications and effort estimations.
• Seamlessly interacted with onsite and offshore teams 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.
• Excellent communication, people, team building and interpersonal skills.

SKILLS

• Business Domain Retail
• ETL Tools Ab Initio v2.15, 3.1.2, Talend
• RDBMS Teradata, Oracle 10g, DB2, SQL Server
• Other DBs Hadoop/HIVE
• Languages SQL, Shell Scripting, Teradata BTEQ
• Scripting Languages Shell Scripts
• Operating System Unix-AIX, Linux, Windows
• Office Tools Microsoft Office
• Scheduling Tools IBM Maestro Console

EXPERIENCE

Confidential

Freight Audit and Payment

• Involved in requirement analysis, design construction, unit testing, QA support and production deployment and support.
• Created high level, low level specification documents, unit test plans and UTR.
• Created Ab Initio graphs to read the data from DB2 tables and land in flat files on the ETL server.
• Created Ab Initio graphs to transform the data and land the data in Teradata DB.
• Created automation scripts to specify the dependency between the graphs.
• Created the JOB to schedule the automated scripts.
• Involved in finding out the clarifications which were raised by the UAT teams and solved them quickly.

Environment: Linux, Ab-Initio GDE - 3.1.2, DB2 database, Teradata database. Maestro Scheduling tool, Quality Center, Teradata SQL Assistant

Confidential

Re platform of Joliet OI process from Abinitio/Teradata OI to Talend/Hadoop OI

• Involved in requirement analyze, design construction, unit testing, QA support and production deployment and support. Lead the offshore teams of two members of this project.
• Created high level, low level specification documents, unit test plans and UTR.
• Created generic Talend jobs to read all 194 tables from Oracle and landed them in HDFS and HIVE tables.
• Created automation scripts to specify the dependency between the Talend jobs.
• Created the JOB to schedule the automated scripts.
• I was involved in production support when the project was in the warranty period.
• Involved in finding out the clarifications which was raised by the UAT team and solved them quickly.

Environment: Linux, Talend 5.5, Oracle database, Hadoop File System, HIVE DB, Teradata database. Maestro Scheduling tool, Quality Center, Teradata SQL Assistant, Hue query tools

Confidential

Distribution Visibility RDC

• This project provides a complete supply chain distribution view. In order of this project, Manhattan operational database is unloaded and transformed in ETL tools and loaded into Teradata EDW. This is where the inbound and outbound details were handled.
• Involved in requirement analysis, data modelling, design, construction, unit testing, QA support and production deployment.
• Created high level, low level specification documents, unit test plans and UTR.
• Created Ab Initio graphs to transfer Manhattan data to flat files.
• Created Ab Initio graphs to transform the data to Teradata EDW
• Created BTEQs scripts to transfer the data to Teradata EDW to perform aggregation operations which were used by the business intelligence teams for their reports.
• Created automation scripts to specify the dependency between the graph and BTEQs.
• Created the job to schedule the automated scripts.
• Was involved in production support when the project was in the warranty period.
• Involved in finding out the clarifications which were raised by UAT teams and solved them quickly.

Environment: Linux, Ab-Initio GDE - 3.1.2, Teradata BTEQ, DB2 database, Teradata database. Maestro Scheduling tool, Quality Center, Teradata SQL Assistant

Confidential

Transportation Visibility

• As part of this project, we maintained the transactions and shipments of our retail stores in three separate inter-related processes, a master data section, a Talon shipment section and a LTL Less than truck load shipment section.
• Conducted requirement analysis, data modelling, design construction, unit testing, QA support and production deployment.
• Created high level, low level specification documents, unit test plans and UTR.
• Created Ab Initio graphs to transfer the DB2 data to flat files.
• Created Ab Initio graphs to transform the data to Teradata EDW
• Created the JOB to schedule the automated scripts.
• Involved in production support when the project was in the warranty period.
• Involved in finding out the clarifications which were raised by UAT teams and solved them quickly.

Environnent: Linux, Ab-Initio GDE - 3.1.2, Teradata BTEQ, DB2 database, Teradata database. Maestro Scheduling tool, Quality Center, Teradata SQL Assistant and SQL server

Confidential

Exposure Visibility

• This project shall be an asset protection and financial dashboard of RDC operations for the past four fiscal weeks and year-to-date. This tool is used by the supply chain distribution to track and monitor inventory levels and adjustments in the supply chain. The overall goal is to minimize exposure shrink . In order to be able to analyze the impact of shrink, it is necessary to be able to drill down to the SKU level.
• Conducted requirement analysis, data modelling, design construction, unit testing, QA support and production deployment.
• Production deployment and support.
• Created high level, low level specification documents and unit test plans and UTR.
• Created Ab Initio graphs to transfer the DB2 data to flat files.
• Created Ab Initio graphs to transform the data to the Teradata EDW.
• Created BTEQs scripts to transfer the data to Teradata EDW.
• Created automation scripts to specify the dependency between the graph and BTEQs.
• Created the job to schedule the automated scripts.
• Involved in finding out the clarifications which were raised by the UAT teams and solved them quickly.

Environnent: Linux, Ab-Initio GDE - 3.1.2, Teradata BTEQ, DB2 database, Teradata database. Maestro Scheduling tool, Quality Center, Teradata SQL Assistant

Confidential

SDC Joliet Teradata OI

• As part of this project, the data from source Oracle is unloaded and loaded into Teradata OI operational image . The current source system doesn't have the ability to keep the data for more than 60 days, so in order to maintain the source data for analytical purposes and it is loaded into Teradata OI.
• Involved in requirement analyze, design construction, unit testing, QA support and production deployment and support.
• Created high level, low level specification documents, unit test plans and UTR.
• Created Ab Initio graphs to read Oracle data and land in flat files on the ETL server.
• Created Ab Initio graphs to transform the data to EDW Teradata OI .
• Created automation scripts to specify the dependency between the graphs.
• Created the JOB to schedule the automated scripts.
• Involved in finding out the clarifications which were raised by the UAT teams and solved them quickly.

Environment: Linux, Ab-Initio GDE, 3.1.2, Hadoop File System, Oracle database, Teradata database. Maestro Scheduling tool, Quality Center, Teradata SQL Assistant

Confidential

Bazar Voice

• The Return To Vendor RTV or bazaar voice is a self-service report used to inform suppliers about the current performance of their products RTV or mark down metrics and to crowd source overview of the product quality. The report is used to identify product quality issues, highlighted area for improvement and quality potential savings opportunities for the vendor due to quality improvements.
• Conducted requirement analysis, data modelling, design construction, unit testing, QA support and production deployment.
• Created high level, low level specification documents, unit test plans and UTR.
• Created Ab Initio graphs to transfer the XML data from HDFS to flat files.
• Created the JOB to schedule the automated scripts.
• Involved in finding out the clarifications which were raised by UAT teams and solved them quickly.

Environment: Linux, Ab-Initio GDE - 3.1.2, Hadoop file system, Teradata database. Maestro Scheduling tool, Quality Center, Teradata SQL Assistant

Confidential

Vendor Compliance Transformation

• As part the Vendor Compliance Transformation project, we handled the direct fulfillment details and the data is sourced from Mincron. This project handled the vendor details, yard management details and timeliness On time on cycle . The YOW Your Other Warehouse data includes master data, purchase orders data, ASN data, receipts data, TMS and YMS data is handled here.
• Conducted requirement analysis, data modelling, design construction, unit testing, QA support and production deployment.
• Created high level, low level specification documents, unit test plans and UTR.
• Created Ab Initio graphs to transfer Mincron data to flat files.
• Created Ab Initio graphs to transform the data to Teradata EDW.
• Created BTEQs scripts to transfer the data to Teradata EDW.
• Created automation script to specify the dependency between the graph and BTEQs
• Created the job to schedule the automated scripts.
• Involved in finding out the clarifications which were raised by the UAT teams and solved them quickly.

Environnent: Linux, Ab-Initio GDE - 3.1.2, Teradata BTEQ, DB2 database, Teradata database. Maestro Scheduling tool, Quality Center and Teradata SQL Assistant

Confidential

LMS Labor Management System

• As part of this project, we brought the activities that were being performed at each DC, labor information, shift details and the number of working hours which were captured by the Manhattan system and landed them into EDW for analytical purposes and resource planning.
• Conducted requirement analysis, data modelling, design construction, unit testing, QA support and production deployment.
• Created high level, low level specification documents, unit test plans and UTR.
• Created Ab Initio graphs to read the data from the Manhattan system and landed them into flat files.
• Created Ab Initio graphs to read the flat files data and transformed and landed in Teradata EDW.
• Was involved in the production support when the project was in the warranty period.
• Involved in finding out the clarifications which were raised by UAT teams and solved them quickly.

Environment: AIX UNIX, Ab-Initio GDE - 3.1.2, DB2 database, Teradata database, Maestro Scheduling tools, Quality Center and Teradata SQL Assistant.

Confidential

SSR SKU Store Repository

• The purpose of this project is to build new functionality and create new data stores at the SKU store data level in order to enable data maintenance for pricing, assortment and replenishment. As part of this process, I landed more than 50 new tables with the volume of 4 TB each in EDW.
• Conducted requirement analysis, data modelling, design construction, unit testing, QA support and production deployment.
• Created high level, low level specification documents, unit test plans and UTR.
• Created Ab Initio graphs to read the data from DB2 database and land in stage tables in the Teradata database and then BTEQS.
• Created automation scripts to specify the dependency between the graphs and BTEQs.
• Involved in finding out the clarifications which were raised by UAT teams and solved them quickly.

Environment: Linux, Ab-Initio GDE - 2.15, Teradata Bteq, DB2 database, Teradata database, the Maestro Scheduling tool, Quality Center and Teradata SQL Assistant.

Confidential

IPR Inventory Planning and Replenishment

To ensure that our customers always found the products on the shelves, it required us to move from analysis of 'simple' OOS where on-hand quantity is