NITHIYA SANTHIRARAJ

Designed Jenkins CICD pipelines to build Channel Economics in Google Big Query using Point of Sales and the Landed Cost of products

Participated in Architectural design meetings and document high and low level design for SAP Source Data landed in Google Big Query

Led the team of ten members for SAP sourced data landed in Big query and for Channel Margin

Calculated Receipts Layers with Discounts and Expenses for the Inventory of facilities onboarded to SAP from Legacy System

Automated creating Jenkins pipelines for newly onboarded tables from SAP to Big Query using Python Script

Developed Data validation Pipelines to validate Channel Margin data to be in threshold of the expected Gross Margin

Performed Completeness and Accuracy validation to compare SAP and Google Big query Data using Dataplex

Wrote complex SQLs to calculate Delivery Revenue and Expenses using the orders that are fulfilled on daily basis

Automated Unit Testing to compare source and target using Dataform

• Designed Jenkins CICD pipelines to build Receipts Engine in Big Query using Raw Receipts data from SAP
• Analyzed SAP source tables and decoded German columns to English
• Participated in Architectural design meetings and document high and low level design
• Calculated Moving Average Cost for products based on available inventory in Warehouse
• Developed Data validation Pipelines to validate SAP and legacy system's data and set threshold limit for any failure
• Performed Completeness and Accuracy validation to compare SAP and Google Big query
• Wrote complex SQLs to calculate Inventory at cost and Inventory at retail metrics
• Designed Pub Sub topic to subscribe to source SAP data to Google Big Query
• Design workflow orchestration using Apache Airflow
• Built Vendor Assignment in EDW to let suppliers understand how their products are sold in Home Depot's Store and online

• Designed Enterprise wide cross reference table to allocate online sales metrics to Stores using Customer Billing Zipcode and Store IP Addresses
• Designed Abinitio Graphs to pull data from DB2 and Raw Input files and load to Teradata for reporting Sales, Inventory , Receipts and Markdown Metrics on daily basis
• Designed SQLs to generate feeds and load to Sql server Database for planning, forecasting and product assortment activities
• Designed sqoop jobs to pull data from DB2 source to load to Hadoop System
• Analyzed various merchandising and finance source systems to bring needed data to build Gross margin at SKU , Store and Vendor grain Performed End to End Data Validations

• Developed Unix Scripts to extract data from Retail Warehouse System and Retailer Defined Hierarchy Databases for Stop & Shop/Giant Landover every 4 weeks to be fed into a data warehousing application
• Developed Unix Shell scripts to generate baseline data to allow Clients to make key decisions on effectiveness of their promotions by correlating lift in sales, beyond baseline, with their advertising data and that of their competitors
• Set up History data migration from Teradata to Big Query
• Deployment and Post Production Support
• Discussed issues with team members to provide resolution and apply best practices
• Tuned systems to boost performance