ankit

Junior Data Analyst

Delhi NCR, India 5+ yrs exp 90 · Outstanding

About

Detail-oriented Business Data Analyst with 5+ years of hands-on experience collecting, cleaning, and analyzing data from multiple sources, and presenting findings through clear dashboards and reports. Proficient in MS Excel (Advanced), Power BI, Google Sheets, and SQL, with a strong understanding of data validation, trend identification, and visualization best practices. Experienced in independent remote collaboration and cross-functional team environments. Passionate about turning raw data into actionable business insights. Pursuing MBA in Business Analytics.

Skills & Expertise (22)

MS Excel Advanced

8.2/10

Years Exp

Advanced Formulas Advanced

8.0/10

Years Exp

Google Sheets Advanced

8.0/10

Years Exp

Business Reporting Advanced

8.0/10

Years Exp

Data Cleaning Advanced

8.0/10

Years Exp

Pivot Tables Advanced

7.8/10

Years Exp

VLOOKUP Advanced

7.5/10

Years Exp

Cross-Functional Collaboration Intermediate

7.5/10

Years Exp

Power BI Intermediate

7.5/10

Years Exp

Trend Analysis Intermediate

7.5/10

Years Exp

Dashboard Design Intermediate

7.5/10

Years Exp

Automated Reporting Intermediate

7.5/10

Years Exp

Remote work Intermediate

7.0/10

Years Exp

Pattern Analysis Intermediate

7.0/10

Years Exp

Data retrieval Intermediate

7.0/10

Years Exp

Charts Intermediate

7.0/10

Years Exp

Data Storytelling Intermediate

6.5/10

Years Exp

SQL Queries Intermediate

6.5/10

Years Exp

MySql Intermediate

6.5/10

Years Exp

XLOOKUP Intermediate

6.5/10

Years Exp

manipulation validation

Work Experience

MIS Analyst

Ambrane India

Feb 2025 - Present

Data collection & analysis: Gather data from multiple stakeholder sources, translate business requirements into analytical frameworks, and build Excel and Google Sheets–based analytics that helped the Modern Trade team exceed monthly sales targets by ~30%. Dashboard & visualization creation: Design and maintain automated dashboards using advanced Excel formulas and Google Sheets visualization, providing real-time visibility across the sales funnel. Reporting: Produce accurate daily, weekly, and monthly business reports for management, synthesising large datasets into clear trends and findings. Data cleaning & validation: Manage reporting databases and run structured data validation and audits to maintain data integrity and accuracy of all business-critical figures. Trend & pattern identification: Track KPIs across business units, identifying performance trends and patterns and translating them into actionable recommendations for senior stakeholders. Cross-functional collaboration: Partner with clients, stakeholders, and cross-functional teams to understand business requirements and ensure they are accurately reflected in reporting outputs. Process automation: Built an automated Pending Orders and RTV dashboard in Google Sheets using advanced formulas, reducing manual reporting effort and improving delivery accuracy.

Data Analyst Intern

Excelerate

Jun 2024 - Jul 2024

Remote data analysis: Worked independently in a fully remote environment, analyzing data from 15 marketing campaigns in Excel and delivering recommendations that boosted ROI by 15%. Visualization & presentation: Created and refined 6 Power BI dashboards and visualizations to support strategic recommendations, presenting findings to senior management. Remote collaboration: Collaborated with a global team of 7 across India, Canada, and Nigeria, contributing to team meetings and cross-time-zone project coordination.

MIS Executive

DUCAT

Mar 2023 - Jan 2025

Business reporting: Generated monthly financial and operational reports to track performance trends and surface areas for improvement to leadership. Data management: Maintained and updated large operational databases, ensuring data accuracy and timely updates for decision-making. Analysis & insight support: Analyzed workflows and datasets using advanced Excel functions, improving reporting efficiency and supporting strategic planning. Data discrepancy resolution: Identified and resolved payment operation discrepancies through structured data analysis, updating databases to maintain integrity.

MIS Assistant

PAMS & Associates

Dec 2020 - Mar 2023

Financial data analysis: Compiled, cleaned, consolidated, and reconciled financial data across multiple categories, ensuring accuracy and regulatory compliance. SQL-adjacent data work: Applied advanced Excel functions (VLOOKUP, IF, Pivot Tables) to automate data reconciliation and manipulate records, directly supporting business reporting needs. Documentation & reporting: Maintained vendor records and produced structured reports for cross-functional teams, consistently meeting strict deadlines.