Mihir Sonar

Aspiring Analyst

Mumbai, India 1+ yrs exp 88 · Excellent

About

Aspiring Analyst with hands-on internship experience in data analysis and reporting. Seeking a full-time Analyst role to leverage foundational skills in Excel, SQL, and Power BI, along with strong analytical thinking, to contribute to data-driven decision-making and business insights.

Skills & Expertise (24)

Pivot Tables Intermediate

7.2/10

Years Exp

Excel Intermediate

7.2/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

Countifs Intermediate

6.4/10

Years Exp

Filtering Intermediate

6.4/10

Years Exp

Grouping Intermediate

6.0/10

Years Exp

Aggregations Intermediate

6.0/10

Years Exp

SQL Intermediate

5.6/10

Years Exp

Jupyter Notebook Intermediate

5.6/10

Years Exp

Visualizations Intermediate

5.6/10

Years Exp

Anaconda Beginner

5.0/10

Years Exp

Pandas Beginner

5.0/10

Years Exp

Python Beginner

5.0/10

Years Exp

Storytelling Beginner

5.0/10

Years Exp

Dashboards Beginner

5.0/10

Years Exp

Power BI Beginner

5.0/10

Years Exp

Joins Beginner

5.0/10

Years Exp

Tableau Beginner

4.8/10

Years Exp

Data Modeling Beginner

4.8/10

Years Exp

DAX Beginner

4.8/10

Years Exp

NumPy Beginner

4.8/10

Years Exp

Matplotlib Beginner

4.8/10

Years Exp

NLTK Beginner

4.0/10

Years Exp

Tally ERP9 Beginner

4.0/10

Years Exp

Work Experience

Account Assistant – O2C (Order to Cash)

Sodexo

Jun 2025 - Jun 2026

Partnered with the O2C Manager to prepare and structure data for a new invoicing and payment-tracking system, improving data readiness for rollout. Created and audited Master Data (MD) records to maintain accurate resource allocation and billing rate information across accounts. Processed and analyzed large-scale operational datasets in Excel using VLOOKUP, Pivot Tables, Slicers, and logical/financial formulas to streamline reporting. Cleaned, validated, and organized operational and financial data, strengthening billing accuracy and reducing reporting discrepancies.

Data Entry Executive

Research Connect

Jul 2024 - Nov 2024

Managed high-priority, time-sensitive research projects, sourcing and extracting high-profile contact data from LinkedIn and Apollo.io for targeted outreach campaigns. Validated and organized large-scale datasets with 95%+ accuracy to support market-research deliverables for stakeholders. Leveraged Excel and Google Sheets (Pivot Tables, Slicers, formulas, basic VBA) to clean, structure, and standardize profile data at scale. Prepared accurate, segmented contact lists that supported RFQ workflows and mass-mailing outreach campaigns.