Back to Developers
SAGAR RAWAT

SAGAR RAWAT

Analyst

Faridabad, Haryana 4+ yrs exp 89 ยท Excellent

About

Analyst with 2.7 years of experience in data analysis, dashboard development, and performance monitoring across corporate and development sectors. Skilled in transforming raw data into actionable insights using Power BI and Excel. Proven ability to improve reporting efficiency, ensure data quality, and support decision-making through structured analysis and visualization.

Skills & Expertise (28)

Dashboard Development Advanced
8.5/10
5
Years Exp
KPI Dashboards Advanced
8.5/10
5
Years Exp
Power BI Advanced
8.5/10
5
Years Exp
Data Modeling Advanced
8.0/10
5
Years Exp
Data Visualization Advanced
8.0/10
5
Years Exp
Excel Advanced
8.0/10
5
Years Exp
Power Query Advanced
8.0/10
5
Years Exp
Data Transformation Advanced
8.0/10
5
Years Exp
Data Cleaning Advanced
8.0/10
5
Years Exp
Business Intelligence Reporting Advanced
8.0/10
5
Years Exp
DAX Advanced
7.8/10
5
Years Exp
Data Storytelling Intermediate
7.5/10
5
Years Exp
Data Extraction Intermediate
7.5/10
5
Years Exp
Problem Solving Intermediate
7.5/10
5
Years Exp
SQL Intermediate
7.5/10
5
Years Exp
ETL Processes Intermediate
7.5/10
5
Years Exp
Stakeholder Management Intermediate
7.0/10
5
Years Exp
collaboration Intermediate
7.0/10
5
Years Exp
Requirements Gathering Intermediate
7.0/10
5
Years Exp
Data Quality Checks Data Validation KPI Tracking Trend Analysis Filtering Aggregations Joins Advanced Functions Power Pivot

Work Experience

Consultant | Monitoring, Evaluation and Learning (MEL) Officer

American India Foundation (AIF)

Dec 2024 - May 2026

Delivered data analytics and reporting solutions for large-scale programs by analyzing operational and performance datasets using Power BI, Excel, Power Query, and DAX, enabling evidence-based decision-making. Designed and implemented executive-ready Power BI dashboards to monitor KPIs, operational efficiency, timelines, and program outcomes, improving visibility for senior stakeholders and clients. Translated client and business requirements into scalable data models and reporting frameworks by integrating data from multiple sources, ensuring accuracy, consistency, and data governance. Performed data preparation, validation, and quality assurance checks to strengthen data integrity across operational, financial, and program performance indicators. Supported operational performance management through target-versus-achievement analysis, resource utilization tracking, and field operations monitoring. Collaborated with cross-functional teams, including operations, program, field, and leadership teams, to deliver insight-driven recommendations aligned with client objectives and implementation priorities. Prepared client-facing reports, dashboards, and presentations, contributing to three strategic and operational reviews while strengthening monitoring and governance mechanisms. Supported baseline, midline, and endline assessments and impact evaluation. Assisted in budget forecasting, financial tracking, and variance analysis to ensure efficient allocation and utilization of project resources.

Associate Analyst

GlobalLogic Pvt. Ltd

Oct 2023 - Dec 2024

Extracted, transformed, and analyzed large datasets to support forecasting and business analysis. Processed and validated 50,000+ records using Excel and Power Query, ensuring high data accuracy. Automated recurring reports using Excel, reducing manual effort and improving reporting efficiency. Performed variance and performance analysis to identify process inefficiencies and optimization opportunities. Collaborated with stakeholders and data engineers to design structured data models for reporting.

ITI Apprentice

Escorts Ltd

Sep 2018 - Sep 2020

Worked closely with mentors to understand project objectives and technical processes. Operated hand tools, power tools, and diagnostic equipment to complete assigned tasks efficiently and safely. Assisted team members in executing planned procedures and operational activities, contributing to improved productivity. Supported daily workflows while adhering to productivity, safety, and quality.

Education

Bachelor of Computer Applications (BCA) - Maharshi Dayanand University

2019 - 2023 ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 14/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 89/100

Profile Overview

Member sinceJul 2026