Snehal Shrimanwar
Experienced BI Developer skilled in data cleaning, exploratory data analysis, data collaboration, data modelling, real-time analysis and data visualization. Proficient in SAP BI, Power BI Desktop, Power Query Editor, Power Pivot, Power View, DAX, data transformation and Power BI Service. Also worked with Tableau, Ms Excel and SQL Database. Proficient in statistical analysis. Designed and developed dashboards and reports using BI Tools.
Pune
Summary
Adept in transforming complex data into actionable insights, I leveraged SAP Business Objects and Power BI to enhance reporting efficiency and data accuracy. My analytical prowess and meticulous attention to detail led to optimized resource allocation and process improvements, showcasing my technical proficiency and problem-solving skills.
Overview
2
2
years of professional experience
3
3
Certifications
Work History
Software Trainee
Saksoft Ltd.
02.2024 - Current
- Setting up the monitoring of BO servers.
- Setting up the auditing policies, and manage event and alerts related to CMS, Audit and Reporting Database services
- Keep availability of BO Web applications CMC, BI Launchpad, and other applications.
- Manage day to day scheduled report jobs from Instance Manager.
- Handling the support issues from business users.
- Monitoring the resources of BusinessObjects servers.
- Manage user and permissions.
- Manage Universe and Connections and other BI Repository objects.
- Backup and Restore of BusinessObjects environment.
Data Analyst Intern
KPMG
09.2023 - 10.2023
- Worked on customer demographic data to help optimize resource allocation for targeted
marketing. - Extensive experience in conducting Data Quality check.
- Proficient in designing research methodologies, collecting and analyzing data, and
presenting findings. - Meticulous attention to detail in ensuring data accuracy and conducting quality
assurance checks
Power BI Developer
Purple Chillies Solution
10.2022 - 03.2023
- Worked on Power BI Dashboard Enhancement.
- Experienced in creating different visualizations using KPI, Cards, DAX Functions, Bar charts, line graphs, pie chart, histogram, bubble chart, maps.
- Worked with Power Query to perform Data Transformation, Data manipulation, Data cleaning, Creating Calculated fields, calculated tables, Merge and append queries.
- Worked with Power pivot to Performed Data Modeling using Star Schema, Snowflake Schema and Galaxy schema.
- Additionally, I collaborated with support teams to resolve technical issues, optimized data-gathering processes, and identified opportunities for process improvement. Finally, I analyzed data and corrected errors to ensure optimal output.
Education
Data Analytics Certification Course - Data Analytics
Imarticus Institute
Pune 04.2001 -
Master of Science - Computational Science,
Swami Ramanand Teerth Marathwada University
Nanded, India 04.2001 -
Skills
SAP Business Objects Business Intelligence
DAX, EDA
Power BI desktop & Power BI Service
Microsoft Excel, advanced excel, pivot table, pivot chart, Vlookup, Hlookup
SQL
Certification
Power BI Essential training (Linkedin) • Master in Microsoft Power BI Desktop and Services: https.//www.udemy.com/certificate/UC- dfab6d29-d126- 4e45- a78c- 0e2025ccb94a/
PERSONAL PROJECTS
- SPOTIFY DATA ANALYSIS PROJECT: Participated in dataDNA challenge. Analyzed Total songs = 943, Top 3 Most streamed tracks of all time = Blinding lights, Shape of you, Someone you loved. Top 3 tracks with high energy = Numb, Take My Breath, About Damn Time. Top 3 tracks with High danceability = About Damn time, Take My Breath, Spit In My Face. Major mode is used in maximum songs. Maximum and total 75 songs has released in May 2022.
- ZOMATO BANGALORE RESTAURANTS DATA ANALYSIS PROJECTS: The objective is to Identify how the Location, Restaurant type, cuisine, Online order facility and Table booking service will contribute to the success of the hotel industry. following are some insights of Analysis: • BTM has the largest count of restaurants followed by HSR and Koramangala 5th block. • Drink Night life, Pubs & bars, Buffets are the most voted peoples' choice restaurant types. • Although Bangalore is a city in southern India but it has given the highest no. of votes for North Indian Cuisine, Chinese South Indian cuisine and Mughlai. • Table booking facility and online food delivery facility will absolutely add value to the business.
- PIZZA DATA ANALYSIS IN POWER BI PROJECT: Participated in the Pizza Data Analysis Challenge from Maven Analytics. I used Power BI Desktop for Dashboard development and implemented Conditional formatting of colours based on profit and loss. The insights gained from this project were: • Identifying the peak day and time for pizza orders. • Determining the most popular pizza ordered. • Identifying the top three and bottom three selling pizzas based on the data.
HOBBIES:
- Badminton
- Poetry
Timeline
Software Trainee
Saksoft Ltd.
02.2024 - Current
Data Analyst Intern
KPMG
09.2023 - 10.2023
Power BI Developer
Purple Chillies Solution
10.2022 - 03.2023
Data Analytics Certification Course - Data Analytics
Imarticus Institute
04.2001 -
Master of Science - Computational Science,
Swami Ramanand Teerth Marathwada University
04.2001 -