Staples envisioned the need to increase the complexity and sophistication of their marketing activities to build more intimate customer relationships and grow market share. To achieve this vision, Staples Enterprise data warehouse (EDW) would be enhanced to support marketing data and feed a marketing data repository (MRKDM - Marketing Data Mart) that supports views organized for modeling, advanced marketing analytics, campaign activities and reporting across the different customer and channel views. The MRKDM will support current Staples Marketing activities and will replace Staples current Customer Marketing Information system (CMIS) application

Delphi Electronics has been in business since 1980. Like every electronics base company, the company is searching for business enhancements and competitive edge. Client wants to have some system, which can give him/her intelligent information and reports regarding his existing business situation and how he/she can analyze specific business areas. According to the client requirement this data warehouse is developed to meet the requirement and help him/her to take appropriate decision to success.

Responsible in gathering Business requirements and create a mapping document to analyze how the metrics can be derived

Create Features and User Stories in Rally to define the work identified

Create Extract queries to pull data from Data Marts on Teradata.

Create Extract data sets in SAS from variety of sources like Data Marts, Data Lakes

Migrate data from legacy databases to Corporate Warehouse on Teradata

Develop business logics using SAS and create Metric Data sets

Using the Metric Datasets create XML and design the report using HP Exstream and python-pptx

• Identify reports with a high percentage of common fields
• Identify reports with common business definitions, review actual reports and consolidate similar reports
• Migrate from non-strategic sources to strategic sources (Data lake)
• Automate any manual effort involved in in Data Capture, Data Cleansing, Manipulation, Validation and Data Distribution.

• Involved in Project Designing and preparing mapping documents
• Analyzed source data for cleansing and applying business rules using Teradata SP
• Performed Unit testing the code for functionality and integrity
• Extensively used Informatica client tools Source Analyzer, Mapping Designer, Workflow Designer and Workflow Monitor
• Extensively created dashboards, stories in Tableau to look and feel as per the business requirements using different analytical views

• Responsible in gathering Business requirements and mapping them into Staples proprietary ETL techniques and Data modeling techniques and propose client an effective Enterprise data warehouse and Enterprise Operational data store solution using the framework.
• Develop ETL and database loading frameworks for the application using Staples ETL design techniques using Informatica and Teradata (TPT, BTEQ & Macros) utilities.
• Develop business logics using Teradata stored procedures
• Strong understanding on Staples Retail Domain, Applications and data warehouse which helps in resolving the issues involved in daily data load process within the SLA time.
• Responsible for building enhancements as per changing business requirements and implementing industry standard solution using Staples framework for ETL design and data modeling for Marketing Data Mart in Staples data warehouse.
• Responsible for facilitating user acceptance tests with the business users.
• Responsible for performing promotion of developed code into production environment.
• Understanding business process and requirements to effectively manage the project as per Staples specific standards and guidelines.
• Will provide software testing (unit and system) services for all development work prior to the production implementation.
• Conduct post implementation analysis to assess software effectiveness and usability.

• Requirements gathering at client location and Business Analysis in support of Data Warehousing efforts.
• Designed ETL specification documents.
• Created Tables, Keys (Primary, Secondary, PP..) and indexes in the Teradata DB.
• Imported, created and edited the table definitions using Informatica Designer.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries.
• Recommended tuning options to source/target database to gain optimum performance.
• Developed various Mapplets, Transformations and validated and fine-tuned the ETL logic coded into mappings.
• Extensively used Informatica Transformations, which includes Union, Look Up, Rank, Aggregator, Filter, Router, Joiner, Sequence Generator, Update Strategy, Stored procedure, and Expression
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target, Mapplets and Transformation objects by creating shortcuts.
• Created Schema objects like Indexes, Views, and Sequences.
• Writing Teradata procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Used the Slowly Changing Dimensions – Type II in various mappings.
• Testing and maintaining of Informatica mappings.

• Extensively used Informatica Transformations, which includes Union, Look Up, Rank, Aggregator, Filter, Router, Joiner, Sequence Generator, Update Strategy, Stored procedure, and Expression
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target, Mapplets and Transformation objects by creating shortcuts.
• Created Schema objects like Indexes, Views, and Sequences.
• Writing PL/SQL procedures for processing business logic in the database.
• Unit and integration testing on Informatica mappings.