s
saurabhvsics

Saurabh Pandey

@saurabhvsics
India
English, Hindi
About me
I am an MIS Executive with more than 8 years of experience working with Microsoft Excel to manage, analyse, and report business information. I specialize in dashboard design, formula/VBA/macros-based automated reports, and turning raw data into meaningful insights for business decision-making. Advanced Excel skills: Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, Power Query, Data Validation, Conditional Formatting, Charts, Sales, Inventory, HR, and Financial report preparation. Tools & Platforms: 1. Microsoft Excel (Advanced) 2. Google Sheets 3. Power BI (Basic to Intermediate) 4. Power Point... Read more

Skills

s
saurabhvsics
Saurabh Pandey
Offline • 
Average response time: 1 hour

See my services

Data Dashboards
I will create excel dashboards, sales mis reports and data analysis
From$10 / projectMore details
Data Dashboards
I will create interactive power bi dashboards and business reports
From$15 / projectMore details

Portfolio

Work experience

Vikrantgroup

Senior Data Analyst

Vikrantgroup • Full-time

Mar 2024 - Present • 2 yrs 8 mos

• Prepare Daily Sales Summary, Target vs Achievement, and Pending Order Reports. • Perform sales forecasting and analyze growth trends across products and regions. • Track top-performing products and territories to support strategic decisions. • Develop MIS dashboards to monitor sales team performance and KPIs. • Collaborate with sales leadership to deliver actionable insights and improve revenue outcomes.