Dharma Raj

Advisor, Data Science

• Job Details:Translated business requirements into scalable BI solutions using Power BI, Power Apps, and Power Automate for 400+ active users in global logistics & fulfillment. Conducted feasibility analysis and aligned development priorities with strategic business goals. Designed and implemented ETL pipelines with PostgreSQL to extract, transform, and load logistics and operations data into a centralized reporting layer. Led end-to-end dashboard lifecycle: data modeling, ETL (PostgreSQL/SQL), UAT, and production deployment to Power BI cloud and on-premise server. Led full-scale data warehouse migration project from Teradata to Greenplum, involving schema redesign, QA validation, and stakeholder training. Modelled data using star and snowflake schemas, incorporating fact and dimension tables relevant to fulfilment, delivery, and order cycles. Conducted UAT, ensured alignment with business KPIs, and deployed reports to Power BI cloud & on-premise server. Automated reporting workflows to reduce manual intervention and improve reporting turnaround. Performed in-depth analytics on global logistics lane data; monitored trends in costs, margins, and revenue. Collaborated with supply chain, finance, and operations teams to develop data-driven strategies. Partnered with data engineering teams to resolve data quality issues and optimize pipelines for analysis. Owned intake of analytical project requests, evaluated feasibility, and recommended design approaches.

Senior Supply Chain Analyst

• Job Details:Performed FY19/20/21 budgeting, cost variance analysis and quarter forecasting for warehousing and transportation cost, coordinated cost reduction initiatives to achieve approved projects. Sourced warehouse space to store the stockpile inventory, reviewed the 3PL contract with warehouse and distribution team, and ensured the term and collaborated with 3PL to manage the replenishment system to ensure accurate product replenishment at SKU level based on demand forecasting. Worked closely with internal business planning (IBP) to increase the local B2B sales resulting in high inventory turnover and handling cost of shipments. Managed reporting functionality for transportation by converting and streamlining existing reports and developing additional metrics and reports as needed.