Summary
Overview
Work History
Education
Skills
Software
Timeline
OperationsManager
Mohammed Mahtab Alam

Mohammed Mahtab Alam

Data Analyst
Bengaluru

Summary

Experienced data analyst with 5 years of expertise in data analysis, business and decision modeling. Proficient in MS SQL, SSIS, and cloud platforms including BigQuery. Proven track record in team management and delivering data-driven insights for stakeholders. Skilled in data visualization and management tools, adept at creating dynamic reports to inform strategic decisions and drive process improvements.

Overview

9
9
years of professional experience

Work History

Medi Assist Insurance TPA Pvt. Ltd.

Data Analyst
03.2019 - Current
  • Enhanced Provider Network Efficiency: Developed a Power BI dashboard to provide real-time insights for optimizing network performance.
  • Predicted Out-of- Pocket Costs: Created cohort models to identify key factors influencing member spending.
  • Improved Enrollment Data Quality: Reduced manual data correction efforts by 5% and increased enrollment processing efficiency by 3%.
  • Improved Claim Fraud Detection: Designed an entity risk score for the ML team's fraud prediction model.
  • Automated Data ETL Pipeline: Designed and implemented an ETL pipeline for timely and accurate data availability.

Enser Communication Pvt. Ltd.

Team Leader
01.2016 - 01.2019
  • Streamlined Daily MIS Reporting: Developed a system for clear, concise daily reports to senior leadership.
  • Created Custom Reports: Responded promptly to management requests for tailored data.
  • Enhanced Reporting Efficiency: Improved data visualization and workforce management.
  • Increased Agent Productivity: Implemented a daily analysis system to exceed targets.
  • Optimized Manpower Allocation: Prepared attendance and staffing reports for efficient operations.
  • Ensured SLA Adherence: Strategically allocated resources to consistently meet service agreements.

Education

BCA (Distance) -

Annamalai University
Bengaluru, India
2022

Intermediate (Commerce) -

Dr. Jagannath Mishra College
Muzaffarpur, India
2014

Skills

  • MS Excel Modeling
  • MS SQL
  • ETL(SSIS)
  • BigQuery
  • Power BI
  • Looker Studio
  • Python
  • Data Analysis & Modeling: Utilized Excel, MS SQL, SSIS, and BigQuery for comprehensive data analysis in the health insurance industry
  • Visualization: Created actionable visuals using Power BI and Looker Studio to translate insights into clear, impactful business decisions and review
  • Machine Learning Collaboration: Collaborated with ML teams on feature engineering for fraud detection and cost prediction models, enhancing overall analytical capabilities

Software

MS SQL

BigQuery

Python

Power BI

Looker Studio

Timeline

Medi Assist Insurance TPA Pvt. Ltd.

Data Analyst
03.2019 - Current

Enser Communication Pvt. Ltd.

Team Leader
01.2016 - 01.2019

BCA (Distance) -

Annamalai University

Intermediate (Commerce) -

Dr. Jagannath Mishra College

Similar Profiles

CREATE PROFILE
Mohammed Mahtab AlamData Analyst