NITHIYA SANTHIRARAJ
Summary
Committed, performance-driven Data Engineer with over 17 years of IT experience in bringing value to organization through a blend of technical leadership, business knowledge, and team focus. Currently working as Staff Software Engineer in Financial Data and Analytics Team, building several data marts in Google Big Query for User reporting. Proven ability to assess situations and implement solutions to improve efficiencies, reduce rework and meet strategic goals.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Staff Software Engineer
Home Depot
08.2023 - Current
- Developed EDW Actuals Feeds to support Onestream Planning and Forecasting
- Developed Jenkins pipelines to replicate SAP tables into Google BigQuery
- Developed Receipts Engine Stored procedure in BigQuery to build cost components in EDW
- Designed and implemented transaction-level Sales Fulfillment and Channel Economics
- Led cross-functional teams to design and implement scalable software solutions
- Developed and optimized sqls to enhance system performance and reliability.
- Mentored Software Engineers, fostering skill development and knowledge sharing.
- Done code reviews, ensuring adherence to best practices and quality standards.
- Supported high Severity Production issues to make sure user experience is not disturbed
Data Engineer
Tata Consultancy Services
04.2017 - 08.2023
- Designed Jenkins 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
Senior ETL Developer
Tata Consultancy Services
09.2014 - 03.2017
- 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
Software Developer
Tata Consultancy Services
05.2008 - 08.2014
- 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
Education
Master of Business Administration - Technology Management
Anna University
2010
Bachelor of Engineering - Computer Science And Engineering
Anna University
2007
Skills
- Databases: Google Big Query, Teradata, SQL Server, DB2
- Version Control: GitHub , PVCS , Ab Initio EME
- ETL Tools: Ab Initio, Datastage
- Apache Airflow For workflow Orchestration
- Messaging Service: Google Pub/Sub
- Computing Service: Cloud Functions
- Semantic Layer: Atscale
- Operating Systems: Windows, Unix
- Programming Languages: UNIX Shell Scripting, Python
- Distributed File System: Hadoop
- Project Methodologies: Agile, Waterfall
- Project Management Tools: Jira , Pivotal Tracker
- Business Intelligence: Tableau
- Functional Area: Retail Domain - Receipts , Inventory and Sales Management
Certification
Google Cloud Certified Associate Cloud Engineer
Timeline
Staff Software Engineer
Home Depot
08.2023 - Current
Data Engineer
Tata Consultancy Services
04.2017 - 08.2023
Senior ETL Developer
Tata Consultancy Services
09.2014 - 03.2017
Software Developer
Tata Consultancy Services
05.2008 - 08.2014
Bachelor of Engineering - Computer Science And Engineering
Anna University
Master of Business Administration - Technology Management
Anna University
Similar Profiles
SARAH MOREIRASARAH MOREIRA
District Hire Specialist Recruiter at HOME DEPOT POSITIONS, The Home DepotDistrict Hire Specialist Recruiter at HOME DEPOT POSITIONS, The Home Depot
Carmen MonterrosasCarmen Monterrosas
OVERNIGHT STOCKER AND RECEIVER at Home Depot/Lowes Home ImprovementOVERNIGHT STOCKER AND RECEIVER at Home Depot/Lowes Home Improvement
Jerimy SmithJerimy Smith
HDIS Senior Design Consultant at Home Depot Home ServicesHDIS Senior Design Consultant at Home Depot Home Services
DeMarius Holmes Jr.DeMarius Holmes Jr.
Order Fulfillment Associate. Family Business Work at Home Depot. Holmes Home Repair LLCOrder Fulfillment Associate. Family Business Work at Home Depot. Holmes Home Repair LLC
VIDHYA SITARAMANVIDHYA SITARAMAN
Staff Software Engineer at CollibraStaff Software Engineer at Collibra