Darshan GV

• Collaborated with stakeholders in initial discovery sessions to understand business requirements, data sources, key KPIs (e.g., revenue, gross margin), and reporting expectations.
• Conducted Exploratory Data Analysis (EDA) and performed quality checks (QC) to identify missing attributes, anomalies, and inconsistencies across datasets along with stakeholders to drive data alignment.
• Aligned with clients on data mapping, logic validation, and filtering rules; validated metrics (e.g., revenue, margin) to ensure accuracy and consistency with business expectations.
• Developed automated data ingestion pipelines using Python for loading data into BigQuery; built raw, intermediate, master, and GSM tables using advanced SQL.
• Executed QC processes and ran ingestion pipelines to ensure seamless data flow from source systems to the analytical tool for real-time and historical analysis.
• Integrated ML-Ops pipelines and supported real-time analytics workflows with cross-functional teams to enable dynamic, data-driven decision-making.
• Validated final outputs including tool-level data and forecast reports; collaborated with business users to ensure data integrity, usability, and decision readiness.
• Developed interactive dashboards and reports Editable Flows, Out-of-the-Box (OTB) reports, Executive Reports.

Logistics Data Optimization:

1) Leading the development and implementation of ISC report automation solutions in PowerBI, demonstrating proficiency in process optimization and data management.
2) Guiding team members in optimizing MOH and Logistics Cost Analysis procedures, showcasing expertise in process enhancement and reporting refinement.
3) Integrating data from Hyperion and BOXi platforms into PowerBI for streamlined reporting, showcasing adeptness in data integration and automation strategies.

4)Spearheaded a team to quickly execute supply chain solutions

Data Preprocessing, Data Analysis and Data Management:

Transformed raw data from MySQL into valuable insights on Azure Synapse. Utilized pipelines, dataflows, and notebooks to orchestrate a seamless process. Delivered data-driven recommendations and reports to executives and stakeholders.

Machine Learning/Data Analysis: -

• SQL:
  Demonstrated expertise in utilizing SQL for data extraction and manipulation within the project. Executed joins, queries, window functions, and created views to extract valuable insights for informed decision-making processes.

Power BI Project:

• Data Analysis with DAX and M-Code: Leveraged Power BI's powerful DAX and M-code language to perform advanced calculations for insightful data analysis. Conducted daily systems analytics to maximize effectiveness and troubleshoot problems.

Alteryx :

Independent Learning Alteryx : Independently acquired knowledge in Alteryx, enhancing the data workflow. Successfully extracted and transformed data, orchestrated the process and presented actionable insights .

• Data Cleaning and Formatting: - Spearheaded comprehensive data cleaning initiatives, removing duplicates, filling missing values, and standardizing formats to ensure data accuracy and reliability.
• Data Aggregation and Analysis: - Applied advanced Excel functions for data aggregation, including SUM, AVERAGE, COUNT, and pivot tables, facilitating in-depth analysis and uncovering valuable insights.
• Data Visualization: - Developed visually compelling charts and utilized conditional formatting techniques to convey complex data trends in a clear and accessible manner.