Shreya Sonawane

Analyst
Email: shreyasonawane1997@gmail.com
Contact:8668298789
LinkedIn Profile: https://www.linkedin.com/in/shreya-sonawane-b758991b6/

Email:
SUMMARY
shreyasonawane1997@gmail.com

Experienced Data Analyst with a proven track record of transforming raw data into actionable insights over two
yearsshreyasonawane1997@gmail.com
Email: of dedicated work. Proficient in a wide array of analytical tools and techniques, including Microsoft Power
BI, SQL, Python, Tableau, and Power Automate. Adept at extracting, cleaning, and visualizing data to empower
Phone: 8668298789
data-driven decision-making and enhance organizational efficiency.
Linkedin:https://www.linkedin.com/in/shreya-sonawane-
b758991b6/

EXPERIENCE
October 2021 to Current - Analyst at Course5 Intelligence

 Extracted Data from data sources like Databases, Data Warehouse, Text documents, and more.
 Performing Data Cleaning on Raw data like handling Missing values, normalizing data and transforming into
suitable formats for Data Analysis
 Performing Exploratory Data Analysis (EDA) on the data
 Implemented ELT & ETL on Data.
 Created Reports/Dashboards/Visualizations in Power BI using Power query, DAX Functions & Visuals •
 Generated end-to-end Tableau Solutions, including data modeling, dashboard design and interactive
visualizations. Developed prototype dashboards as mockups using wireframing tools like Adobe XD & Figma
to demonstrate design concepts and gather client feedback before final dashboard creation.
 Successfully implemented a write-back functionality in Power BI reports by integrating Power Automate and
Power apps. This allowed end-users to input and update data directly within Power BI report, streamlining
data entry and improving real-time reporting.
 Proficient in crafting intricate SQL queries to extract and transform data from diverse data sources,
including relational databases, data warehouses, and external APIs.
 Maintained existing reports and Dashboards and made changes onto the same as per new and challenging
business requirements.
 Worked on Embedding Power BI Reports into Power Apps for creating Mobile friendly Dashboards.

SharePoint:

 Developed SharePoint website for a well-known Company "LinkedIn" From Scratch with enhancing visual
looks and using various web parts to make the site look attractive.
 Managed SharePoint site configuration and content management, ensuring data accuracy and accessibility.
 Implemented best practices in managing lists and libraries, increasing retrieval efficiency.
 Worked on 3+ projects managing web pages, forms, workflows and libraries.
 Collaborated with cross-functional teams to gather migration specifications ensuring feature completeness.

SKILLS
 Data Analysis  Data Modeling
 Data Visualization  Data Integration
 Data Cleaning and Preprocessing  Stakeholder Management
 Business Process Analysis  Dashboard Design and Development
 ETL  DAX
TECHNICAL SKILLS
Tools/Languages: Python, SQL, Power BI, Tableau, Power Automate, Power Apps, Adobe XD, RPA
PowerAutomate, SharePoint Development.

Database: MS SQL Server, MySQL, PostgreSQL, MS Excel

Education

2021 Master of Computer Application

IICMR -Pune

2018 Bachelor of Computer Science

Indira College of Commerce and Science -Pune

2015 HSC-Science
Amrita Junior College- Pune

CERTIFICATIONS
 PL-900 Microsoft Power Platform Fundamentals Certified
Verify at: https://learn.microsoft.com/en-us/users/shreyasonawane- 7078/certifications/certification-
print/certification.power-platform-fundamentals

 Intelligent Automation with Microsoft Power Automate Flow and RPA with AI Builder
 Introduction To Data Analytics- Coursera
Verify at: Coursera | Online Courses & Credentials from Top Educators. Join for Free | Coursera

 Microsoft Azure SQL –Coursera

Verify at: Coursera | Online Courses & Credentials from Top Educators. Join for Free | Coursera

 Power BI Report Development Crash Course-Coursera

Verify at- Coursera | Online Courses & Credentials from Top Educators. Join for Free | Coursera

 Adobe XD Masterclass-Udemy
Verify at: Udemy Course Completion Certificate | Udemy

PROJECTS
Project 1 (Alcoholic Beverage Company)
Environment: Power BI, Advance Excel, Adobe XD

 Gathered and integrated data from diverse sources, including SQL databases, Excel spreadsheets, and
cloud-based APIs, ensuring data accuracy and consistency.
 Conducted exploratory data analysis (EDA)and calculated new columns which are needed as per the
requirements using Power Query Editor
 Implemented complex data transformation and modeling using Power Query, DAX to create a robust data
model that supported interactive and dynamic visualizations.
 Created Mock-up Based on the understanding of requirements and Data using Designing tool Adobe XD
 Took approvals from Client using mockup design.
 Created Calculated Measures which are required using DAX Functions.
 Extensively Worked on DAX Part.
 Worked on all types of Transformations that are available on Power BI Query Editor. Designed and
customized visually engaging and user-friendly dashboards, featuring slicers, drill-through actions, and
dynamic KPIs, improving user engagement and data exploration.
  Continuously monitored and optimized the performance of Reports and dashboards, reducing report load
times by 40 % through query optimization.
 Presented regular performance reports and dashboard usage analytics to management, facilitating data-
driven decision-making, and promoting the expansion of Power BI adoption within the organization.


Project 2 (Pharmaceutical Company)

Environment: Tableau, SQL, Adobe XD

 Defined Project Scope and Identified the stake holders and gathered requirements Made a Live connection
to the snowflake and retrieved the data and explored the data using table’s drag and drop interface and
identified the potential insights.
 created the Mockup of the dashboard and took feedback from clients.
 Created data model based on the requirements.
 Created calculated fields and expressions to derive new metrics.
 Developed end to end dashboard on Tableau based on the requirements.
 Worked on Implementing Multiple customized charts to overcome limitations of Tableau.
 I tested the dashboards and Visualizations for Accuracy and functionality and validated the data displayed
on the dashboard.
 Published the dashboard to Tableau server for wider access and managed access permissions Conducted
user training sessions and created documentation to facilitate the adoption of the Tableau dashboard
among the dashboard users.
 Regularly optimized SQL queries and Tableau workbook performance to ensure smooth and responsive
dashboard Interactions, even with large dataset.