Data Analyst | Turning
Data into Business Impact

I build dashboards, optimize workflows, and uncover insights that drive strategic decisions

View My Work  →

About Me

Analytical professional turning complex data into clear, actionable business insights

Monalika Ghosh

Hi, I'm Monalika Ghosh

I'm a Data Analyst based in Kolkata with a 9.74 CGPA in M.C.A from SRM University and hands-on experience in MIS reporting, ETL development, and BI dashboarding. I specialize in translating messy, complex datasets into clear narratives that business stakeholders can act on.

At JPK Metallics, I have built interactive KPI dashboards in Power BI and Looker Studio, improving decision-making efficiency by 25%, and performed root cause analysis to enhance reporting accuracy by ~30%. Skilled in SQL, Excel, Power Query, and Google Sheets, I specialize in creating analysis-ready datasets and ensuring strong data quality and governance. I've also automated reporting workflows, saving 10+ hours per week, and collaborated with cross-functional teams to deliver data-driven solutions that support business growth.

My strength is bridging the gap between raw data and real decisions — whether that's building a weighted city scoring model for digital expansion, or flagging vendor concentration risks before they become supply chain problems.

SQL & PythonPower BIETL Pipelines KPI DashboardsHypothesis TestingMIS Reporting Data StorytellingAutomation

Skills

Comprehensive skill set spanning data analysis, business intelligence, and automation

Programming Languages

PythonSQL

BI & Reporting Tools

Power BI (DAX, ETL) Excel (Pivot Tables, Dashboards, Lookup Functions, Formulas, Data Validation, Conditional Formatting) Power Query Google Sheets Automation (Apps Script)

Databases

MySQLSQL Querying

Data Analysis & Concepts

Data CleaningKPI Tracking Sales & Operations ReportingData Mining Predictive AnalyticsStatistical Analysis Data ProfilingModeling TransformationETLBI Reporting

Libraries & Frameworks

PandasMatplotlibSeabornStreamlit

Tools & Platforms

Power BIMySQLExcel PowerPointGoogle ColabGoogle Sheets GitGitHubStreamlit Cloud

Automation & Integration

Google Sheets APIAPI Integration Google Cloud Service Account Authentication

Soft Skills

Strong CommunicationCritical Thinking Problem-SolvingCollaborationAdaptability

Featured projects

Real-world data analysis projects delivering measurable business impact

Vendor Performance Analysis

Analyzed vendor dependencies and inventory optimization opportunities to reduce supply chain risks and improve cost efficiency.

Tools & Technologies
SQLPythonExcelPower BI
Key Achievements
  • Optimized SQL ETL pipeline for efficient data processing using CTEs
  • Performed EDA and hypothesis testing to validate insights
  • Identified 65.7% over-dependence on top 10 vendors
  • Uncovered $2.71M in unsold inventory
  • Recommended diversification strategy to mitigate supply chain risks
Business Impact
  • $2.71M inventory optimization potential
  • 72% cost-saving opportunity identified
  • Strategic vendor diversification roadmap delivered
View on GitHub →

AirPure Innovations

Developed data-driven market entry strategy for air purifier company by analyzing AQI patterns and identifying high-risk markets.

Tools & Technologies
SQLPythonStatistical AnalysisFeature EngineeringPower BI
Key Achievements
  • Built ETL pipeline for 23K+ AQI records across 291 cities
  • Analyzed pollution patterns and identified winter AQI spikes (Nov–Jan)
  • Engineered City Risk Score and Health Burden Index metrics
  • Prioritized high-risk states: Delhi NCR, UP, Maharashtra, West Bengal
  • Performed correlation and hypothesis testing for validation
  • Developed comprehensive 5-page Power BI dashboard
Business Impact
  • Data-driven HEPA-focused market entry strategy
  • Identified mid-premium affordable-smart product gap
  • PM2.5/PM10 priority targets defined for 89% of cities
View on GitHub →

Media Survival Analysis (Bharat Herald)

Analyzed print media performance and digital readiness to optimize resource allocation and guide digital transformation strategy.

Tools & Technologies
SQLPythonData Visualization
Key Achievements
  • Developed SQL ETL workflows for 6 years of data (2019–2024) across 10 cities
  • Performed comprehensive EDA in Python
  • Identified 25–30% print waste reduction potential
  • Analyzed city-level ROI and performance metrics
  • Designed weighted readiness priority scoring system
  • Ranked cities for strategic digital rollout
Business Impact
  • Improved forecast accuracy by 18%
  • Identified Tier-2 markets (Lucknow, Bhopal, Patna) for digital expansion
  • Delivered actionable roadmap for digital transformation
View on GitHub →

Supply Chain Service Level Analysis (AtliQ Mart)

Delivered a data-driven supply chain performance dashboard to diagnose service-level failures and support customer retention strategy in an FMCG business.

Tools & Technologies
Power QueryPower BIDAX
Key Achievements
  • Built end-to-end Power BI dashboard with 4 analytical layers (Overview, KPI Performance, Trend, Root Cause)
  • Created core supply chain metrics: OT%, IF%, OTIF%, LIFR%, VOFR% using DAX
  • Identified ~35–40% demand-supply gap between ordered and delivered quantities
  • Discovered 65% of failures driven by In-Full (IF) issues vs 35% from delays
  • Performed customer-level analysis highlighting high-risk accounts with OTIF < 30%
  • Conducted city and product-level analysis to detect systemic fulfillment issues
  • Designed failure breakdown visuals to isolate Late vs Partial delivery impact
Business Impact
  • Highlighted inventory/fulfillment gaps as primary root cause of service failure
  • Enabled targeted action on high-risk customers to reduce churn risk
  • Recommended prioritizing In-Full delivery improvement to maximize OTIF recovery
  • Provided actionable insights for supply chain optimization before business expansion
View on GitHub →

Professional experience

Proven track record of delivering data-driven solutions in fast-paced environments

MIS Executive

Current
JPK Metallics Pvt. Ltd.
📅 Nov 2025 – Present 📍 Howrah, West Bengal
Key Achievements
  • Developed interactive dashboards and reports in Power BI and Looker Studio with business-defined KPIs, enabling performance tracking and delivering actionable insights for decision-making
  • Collected, extracted, and transformed data using SQL, Advanced Excel Formulas, Power Query, and Google Sheets (QUERY, IMPORTRANGE) to build structured, analysis-ready datasets
  • Analyzed sales and operational data and performed Root Cause Analysis (RCA) to identify trends, issues, and improvement opportunities, enhancing reporting accuracy by ~30%
  • Collaborated with cross-functional stakeholders to gather requirements and translate business needs into data-driven insights, KPI dashboards, and reporting solutions
  • Automated repetitive reporting tasks using Google Apps Script and VBA Macros, and prepared data summaries and presentations to support client discussions, proposals, and internal decision-making while ensuring data validation, consistency and quality

Data Analyst Intern

InLighnX Global Pvt Ltd (InLighn Tech)
📅 June 2025 – Aug 2025 📍 Remote
Key Achievements
  • Developed a scalable ETL pipeline that was 60% faster for vendor performance analysis
  • Identified $2.71M unsold inventory and 72% cost-saving potential through deep analysis
  • Applied SQL, Python, Excel, and Power BI to deliver actionable insights supporting strategic decisions
  • Delivered actionable recommendations for supply chain optimization

Let's connect

I'm open to opportunities where I can drive data-backed decisions and deliver measurable business impact

✉
Email
ghoshmonalika290@gmail.com
📞
Phone
+91 8017193605
LinkedIn GitHub