Back to Developers
Mandar Ambi

Mandar Ambi

Business Operations Analyst

Bangalore, India 2+ yrs exp 85 · Excellent

About

Results-driven Business Operations Analyst with 2+ years of experience in KPI management, MIS reporting, business process improvement, and operational performance monitoring. Skilled in maintaining and enhancing executive-level Power BI dashboards, automating Excel and VBA workflows reducing manual effort by 40%, and delivering data-driven insights to support strategic decision-making. Proficient in SQL, Advanced Excel, Power BI, SharePoint, and ServiceNow. Proven ability to collaborate across cross-functional teams to drive process efficiency, compliance reporting, and governance frameworks. Open to Remote work.

Skills & Expertise (37)

Power BI Advanced
8.2/10
1
Years Exp
Power BI Dashboard Development Intermediate
8.1/10
1
Years Exp
SQL Intermediate
7.4/10
1
Years Exp
Advanced Excel Intermediate
7.2/10
1
Years Exp
MIS & KPI Reporting Intermediate
7.1/10
1
Years Exp
Root Cause Analysis SQL data extraction Variance Analysis Data Validation Business Process Analysis Cross-functional coordination Stakeholder Management Process Improvement Data Reconciliation SOP Development KPI Frameworks Audit & compliance reporting workflow optimization Data Modelling Reporting Automation Power Query SharePoint ServiceNow VBA Tableau PowerApps Microsoft Teams MS Office Suite VLOOKUP Data Extraction Index-match SUMIFS Pivot Tables VBA Macros DAX KPI Dashboards Executive Reporting

Work Experience

Business Operations Analyst

Glentec Engineering Services (Client: Baker Hughes)

Jun 2024 - Present

Managed end-to-end business operations reporting across 2 concurrent enterprise projects, delivering weekly and monthly KPI dashboards and MIS reports consumed by 12 stakeholders across leadership and operations teams. Automated 6+ recurring Excel-based reports using VBA macros, reducing team reporting time from 5 days to 3 days per cycle — a 40% improvement in reporting efficiency and data consistency. Maintained and enhanced Power BI operational dashboards including data extraction, transformation, DAX measures, and visualization updates, ensuring 100% on-time delivery with validated data accuracy. Automated pivot table refresh macros triggered on file open events, ensuring reports always reflected up-to-date data without manual intervention. Performed root cause analysis and variance analysis on business performance datasets to identify process deviations, inefficiencies, and risk indicators, enabling timely corrective actions. Conducted operational risk management by tracking non-conformances, action item closures, and risk items in structured SharePoint-based risk registers, supporting key business go/no-go decisions. Built and maintained audit-ready governance datasets and compliance reporting frameworks, supporting regulatory reviews and internal audits. Coordinated with operations, compliance, and business teams to ensure data completeness and accuracy across risk, performance, and reporting workstreams.

Data Analyst Intern

AI Variant

Oct 2023 - May 2024

Automated 4 recurring Excel-based reports using VBA macros, saving 8–10 hours of manual effort monthly and improving reporting process efficiency. Performed SQL-based data extraction, transformation, and analysis to support business and operational performance reporting. Developed and maintained Power BI dashboards to track business KPIs and performance indicators, improving stakeholder visibility and management reporting. Conducted data validation and quality control checks to maintain accuracy, integrity, and consistency across all reporting deliverables. Delivered ad-hoc analysis and data-driven insights to support operational decision-making and business process improvement initiatives.

Education

Bachelor of Engineering - Mechanical Engineering - KLE Institute of Technology

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 10/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceMay 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation