Business Intelligence Analyst

Amit Bakde

Business Intelligence Analyst PGDM – Big Data Analytics (GIM Goa)

+91-834******* Email: ***********@*****.*** Linkedin: linkedin.com/in/amitbakde/ Portfolio: amitbakde99.github.io/ SUMMARY

Business Intelligence Analyst with a PGDM in Big Data Analytics from Goa Institute of Management, currently delivering enterprise-wide healthcare analytics in the UAE. Experienced in building and owning CXO-facing BI solutions, standardizing KPIs and transtioning manual MIS reporting into scalable analytics platforms. Strong in Power BI-led decision support, cross-functional stakeholder engagement and analytics adoption at leadership level. Seeking analytics or consulting roles in structured, data-driven organizations. EDUCATION

• Goa Institute of Management June 2023 – April 2025 PGDM – Big Data Analytics

• Rajiv Gandhi Proudyogiki Vishwavidyala June 2015 – May 2019 B.E. - Mechanical Engineering

SKILLS

• Core Competencies: Business Intelligence, Dashboard Design, Revenue Cycle Analytics, Stakeholder Management, KPI Frameworks.

• Primary Tools: Power BI, DAX, Power Query, SAP (Data Extraction), Advanced Excel.

• Technical Proficiency: Python (Pandas, NumPy, Matplotlib), SQL (Joins, Aggregations, Window Functions). WORK EXPERIENCE

Business Intelligence Analyst (Management Trainee) - Burjeel Medical City, Abu Dhabi UAE Aug 2025 - Present

• Owned development of a multi-module Executive BI suite covering OP/IP operations, standardizing 30+ enterprise KPIs; enabled daily leadership monitoring and faster escalation of operational issues.

• Delivered a group-wide laboratory utilization & benchmarking analytical solution across 20+ units, consolidating multi-year test volumes into a single analytical view; implemented role-based access & standardized benchmarks for leadership performance views.

• Partnered with billing and finance stakeholders to improve visibility into accrual aging and reconciliation gaps across payer segments; supported prioritization of high-value follow-ups through analytics-driven reporting.

• Automated source-to-dashboard refresh pipelines and standardized reporting logic, replacing multiple manual MIS reports and freeing analyst capacity for variance analysis and decision support.

• Built peak-hour demand & patient mix analytics (demographics, visit patterns) used by leadership for clinic staffing and scheduling decisions. Tech Stack – Power BI (Advanced DAX, RLS, Enterprise Dashboards), SAP data extracts, Advanced Excel, KPI standardization, CXO-facing BI delivery. Business Analyst (Summer Internship) – Outlook Group, Remote Apr 2024 – June 2024

• Translated 93 business research questions into an analytics-ready data dictionary (variables, definitions, response coding), enabling structured analysis on a survey dataset of ~11k responses.

• Cleaned and analyzed survey + subscription time-series data (2020-2022); built dashboards (Power BI) and baseline forecasts to summarize segment-level preferences and subscription trend insights for marketing planning. Data Scientist Intern - Zummit Infolabs, Remote Nov 2022 – Feb 2023

• Led 4-member agile team to deliver assistive-tech proof-of-concept, managing sprints and daily stakeholder updates.

• Curated and prepared an image dataset (~10k samples after augmentation), ran iterative experiments to benchmark prototype performance and packaged outputs into a simple Flask demo (upload to label) for stakeholder review. Assistant System Engineer – Tata Consultancy Services, Pune Apr 2021 - Oct 2021

• Managed 24x7 IT operations for European manufacturing client, ensuring timely incident resolution and minimizing service disruptions.

• Resolved 1000+ ServiceNow tickets including high-priority issues across APAC & EMEA region, delivering rapid and high quality IT solutions ANALYTICS TRAINING & PORTFOLIO

• SQL (joins/windows), Python (Pandas) Statistics fundamentals, Power BI (DAX/modelling); portfolio projects on GitHub. PROJECTS

Analyzing Industry 4.0 Trends in NIFTY200 Companies – Research Project

• Developed a python-based web scraper and extracted 30GB+ unstructured data (text/media/articles) from Top 100 NIFTY companies.

• Automated workflows in Python, reducing data collection efforts by 80% and boosting data organization efficiency.

• Cleansed large-scale text data using stop words removal & lemmatization, eliminating 30% of irrelevant terms to enhance relevance & consistency.

• Executed keyword frequency analysis, revealing key Industry 4.0 trends across five sectors.

• Developed co-occurrence matrix for each firm, identified keyword relationships, and highlighted adoption patterns. Hospital Operations & Finance Dashboard (Power BI 2025)

• Built a complete OPD/IPD operations dashboard using python-generated dummy dataset to showcase hospital analytics capabilities.

• Shared interactive dashboard and code on Github, demonstrating clean modelling, drill-through navigation and business KPI mapping. Cohort Analysis : Customer Retention Insights

• Applied K-Means clustering to segment customers into loyalty tiers (loyal, average, churn-risk) & identified high-risk groups for targeted retention.

• Performed Cohort Analysis to track retention trends over time, uncovering critical drop-offs in customer engagement after initial onboarding.

• Conducted RFM (Recency, Frequency, Monetary) segmentation to quantify revenue contribution, confirming that a small customer segment drove the majority of revenue.

ACADEMIC ACHIEVEMENTS & CERTIFICATIONS

• Forward Program by Mckinsey.org, 2025 Global Leadership Problem Solving Digital Transformation Strategic Decision Making

• Grant Thornton Bharat Lean Six Sigma Green Belt, 2023 Agile Methodology Root Cause Analysis Process Improvement

• Certified in Google Data Analytics Professional by Google on Coursera, 2023

Contact this candidate