Summary
Overview
Work History
Education
Skills
PROJECTS
Timeline
Generic
Shilpa Sahu

Shilpa Sahu

Bhopal

Summary

A data enthusiast with overall 2.7 years of experience in Data Analysis, Data Analytics, Data Blending, Data Collection, Data Visualization, Business analysis, Power BI.

Overview

3
3
years of professional experience

Work History

Business Analyst

Ticketbookkaro
Mumbai
06.2021 - 12.2023
  • Developed and maintained interactive dashboards and reports in Power BI to support the growth marketing team’s initiatives
  • Conducted comprehensive data analysis to identify growth opportunities, contributing to a 20% increase in customer acquisition.
  • Collaborated with marketing and sales teams to translate business requirements into data-driven solutions.
  • Automated data collection and reporting processes, reducing manual effort by 30%.
  • Monitored and analyzed marketing campaign performance, providing actionable insights to optimize ROI.
  • Technologies Involved: Power BI , MySQL , SQL and Microsoft Excel.

Education

Bachelor of Science - Pharmacy

Technocrates Institute of Technology
Bhopal
06-2019

Skills

  • SQL
  • Power BI
  • MS Excel
  • MySQL
  • Data Visualization
  • Data Extraction
  • DAX (Data Analysis Expressions)
  • Marketing Analytics
  • Dashboard Design
  • Automation

PROJECTS

1. Data Analytics Projects on Banking KPIs

  • Conducted a comprehensive data analytics project focused on evaluating key performance indicators (KPIs) within the banking sector, utilizing SQL, and Power BI for data extraction, transformation, and visualization.
  • Analyzed various KPIs including total loan amount, month-to date (MTD) loan amount, bad loan ratio, and good loan ratio.
  • Improved understanding of loan portfolio performance by providing clear and actionable insights through visualizations.

2. Provide Insight to the revenue team in the Hospitality Domain

  • Developed and implemented a real-time dashboard using Power BI to provide comprehensive revenue insights for a hospitality chain. The dashboard aimed to enhance data visibility, streamline decision-making processes, and drive revenue growth.

Timeline

Business Analyst

Ticketbookkaro
06.2021 - 12.2023

Bachelor of Science - Pharmacy

Technocrates Institute of Technology
Shilpa Sahu