Shivam Teotia

Data Analyst / Business Analyst with 1+ year of experience converting sales, dealer, and operations data into dashboards, reports, and business recommendations. Skilled in requirement gathering, stakeholder management, and translating business needs into reporting specifications, SQL queries, and Power BI/Excel dashboards.

At Hero

MotoCorp, partnered with management to replace manual reporting with automated workflows, improving delivery-data efficiency by 40% and cutting manual data-processing errors by 30%. Strong track record of data quality validation, root-cause analysis, and clear communication of insights to non-technical stakeholders.

Data Analyst - Hero MotoCorp

(2024-10 - 2025-12)

• Partnered with sales, dealer, and operations stakeholders to gather reporting requirements and translate them into dashboard specifications and recurring report formats.
• Cleaned, validated, and analyzed large datasets covering sales, customer trends, and dealer performance, giving management a clearer, data-backed read on business drivers.
• Built and maintained interactive Power BI and Excel dashboards — including data modeling and DAX measures — to track monthly and regional sales performance, replacing static spreadsheet updates with a live self-service view for management review.
• Wrote SQL queries to extract, transform, and load (ETL) data from relational databases into reporting-ready formats, cutting time spent on recurring reporting tasks.
• Documented business rules and validated report/dashboard outputs against stakeholder requirements before rollout, ensuring accuracy and consistency of delivered insights.
• Delivered weekly and monthly performance reports feeding directly into sales strategy and operational planning.
• Analyzed delivery and logistics data to identify bottlenecks, contributing to a 40% improvement in delivery efficiency; automated manual reporting steps, cutting data-entry errors by 30%.

Business Development Associate - Byju's

(2022-12 - 2023-12)

• Engaged prospective customers to explain product offerings and drive conversions in a target-driven environment; tracked performance against weekly targets and reported results to team leads.
• Built strong client communication and needs-assessment skills through daily customer interactions — a foundation that now shapes how business requirements are gathered and presented to stakeholders.

Bachelor of Science - Computer Science (2019-04 - 2022-06)