Data Analyst - BI, VBA Automation Specialist, E-commerce Excutive

SUMMARY

EDUCATION

ADDITIONAL INFORMATION

HARDIK HARYANI

DATA ANALYST REPORTING ANALYST MIS ANALYST OPERATION ANALYST

+917********* ******.*********@*****.***

I am a detail-oriented Data Analyst with expertise in e-commerce operations, sales reporting, and business intelligence. Skilled in Power BI, Excel, and VBA automation, I streamline workflows and deliver actionable insights to drive efficiency and growth. Advanced Excel

Google Sheet

VBA

Power BI

Tableau

SAP

SQL queries

Python

Data Analysis

Data Analyst, Coloressence 07/2025 - Present

Manage end-to-end e-commerce operations, including processing purchase orders (POs) and coordinating dispatches for both B2B and B2C channels.

Oversee inventory management of 800+ SKUs, ensuring accuracy, timely replenishment, and alignment with sales projections. Develop and maintain sales performance dashboards in Power BI to track projections, trends, and operational efficiency. Handle returns to vendor (RTVs) and optimize reverse logistics processes to minimize losses and improve supply chain flow. Streamline reporting and operational workflows, enabling data-driven decision-making across e-commerce and supply chain functions. Reporting Officer, Patanjali Foods Limited 01/2025 - 07/2025 Developed and generated weekly and monthly ad-hoc reports for management to facilitate informed decision- making.

Utilized macros and VBA to automate repetitive tasks, enhancing productivity and efficiency. Maintained comprehensive sales dashboards to track primary and secondary sales, growth analysis, and trend analysis.

Provided detailed sales trend analysis reports to management, contributing to strategic planning and performance evaluation. Data Analyst, Niketan Farms Pvt Ltd 01/2023 - 11/2024 Streamlined data organization in Excel and Google Sheets, improving data clarity and accessibility by 30% Mentor staff on MIS tools and reporting standards to maintain consistency and accuracy across the organization. Performed comprehensive analysis on distribution channels, root causes, sales performance leading to a 15% increase in sales efficiency.

Developed and presented dashboards and reports, effectively communicating key findings to stakeholder. Designed MIS reports and Power BI dashboards, pin-pointing growth and improvement areas. Utilized business intelligence and ETL processes in Power BI for data integration and analysis. Used pivot tables for in-depth sales data analysis to identify trends and patterns. Technology Sales Specialist, Trimurti Travels 02/2020 - 12/2022 Oversaw and optimized the company's social media presence, increasing engagement by 25%. Monitored ongoing email marketing campaigns.

Crafted and delivered compelling presentations for clients and enhancing client engagement. B.COM (Computer Applications) Hemvati Nandan Bahuguna Garhwal University 08/2020 Languages: English, Hindi.

Certifications: Data Analytics Professional by Google, Data Visualization with Power BI by Great Learning, Generative AI Fundamentals Accreditation by Databricks TECHNICAL SKILLS

EXPERIENCE

Contact this candidate