MS Power BI
AKASH SHAHAPURE
Data Analyst
Pune,Maharashtra
Summary
Experienced data analyst with a track record of delivering accurate and insightful reports through advanced Excel functions and Power BI visualization. Known for optimizing efficiency by automating tasks and maintaining a meticulous attention to detail. Proven ability to meet client and employer expectations, ensuring satisfaction. A results-oriented professional ready to leverage expertise in data analysis to drive informed decision-making and contribute to organizational success.
Overview
3
3
Languages
5
5
Certificates
5
5
years of post-secondary education
14
14
years of professional experience
Work History
Data Analyst
Haqdarshak Empowerment Solutions Pvt. Ltd.
Pune, Maharashtra
08.2023 - Current
- Responsible for finding insights from data for independent projects and keep track of KPI’s for each project separately.
- Automate task of data cleaning and mapping for monthly & weekly reports using Python scripts ETL.
- Update missing data from data source by collaborating with cross functional teams.
- Assist and train team members to solve their problems regarding data analysis with R and Python programming language and also with MS Excel.
- Keeping track of the progress of team member’s individual project using shared Google sheets.
- Conducting survey via Google forms to collect data from end users and link Google sheets to the form as per stake holders requirement then share the same with stake holders and clients.
- Visualize data via power BI or Looker by sharing interactive dashboard with stake holders and clients also leveraged PowerPoint ensuring clear and precise communication with stakeholders.
- Using GitHub for version control of the web app deployed using streamlit, Django and python to automate ETL task for non tech users of organization.
Associate Data Analyst
Tata Consultancy Services
Pune, Maharashtra
06.2021 - 07.2023
- Worked on BFL's financial data of the refund processed by my team to produce daily insights for the stake holders and clients.
- Reduced 60% of workload by automating tasks which don’t need human intervention like cleaning data, summarizing data via python ETL operation.
- Analyze data using Excel for defined KPIs with help of vlookups, pivot tables and advanced formulas like if-else, concatenate, arithmetic operations.
- Clean and remove anomalies from data using python, pandas, numpy .
- Create and publish insightful interactive dashboard using Power BI to show daily, weekly and monthly insights with help of filters and drill down reports.
- Manage workload by distributing tickets to team members via salesforce reports, act as SME to guide for the workflows of the process defined in SOP.
Process Associate
Tata Consultancy Services
Pune, Maharashtra
01.2017 - 05.2021
- Resolve customer queries via mails for BFL and record if any specific issue is being repeatedly reported by customers.
- Resolve tickets of customers registered using BFL app and analyze the ticket pattern of attempted customers for any specific area of issues that has to be taken care of.
- Check for historical financial data of customers and analyze if customer's penalties can be wived of under good payment gesture.
- Assist team members for any queries he/she stuck with by working as SME.
- Extract data from Salesforce and clean the data which is not relevant and assign the task to team members as a extra curricular activity.
- Process the refund using Finone Oracle Application as per customer request and clients approval then download the daily report for the refunds processed by all team and share the report with stakeholders.
Associate - Customer Support
Tech Mahindra
Pune, Maharashtra
03.2016 - 01.2017
- Customer Query Resolution via Email.
- Email, Chat Support.
- Proactively outcall to customers who have written via email to understand query.
- Maintaining Daily MIS data of employee attendance.
Customer Care Executive
Allied Softech Pvt. Ltd
Pune, Maharashtra
06.2014 - 08.2015
- Remote Support via TeamViewer & Ammyy Admin
- Network Configuration of Computer & Switches
- Software & Product Support 3.
- Coordinated timely responses to online customer communication and researched complex issues.
- Managed billing, service and account issues for Pharma customers.
- Assisted marketing team on short-term and long-term promotional projects and provided regular updates on status and progress.
Associate Voice
Aditya Birla Minacs
Aurangabad, Maharashtra
04.2011 - 10.2011
- On Call Customer Query Resolution.
- Actively listened to customers, handled concerns quickly and escalated major issues to supervisor.
- Increased customer satisfaction by resolving billing issues.
- Offered friendly and efficient service to all customers, handled challenging situations with ease.
Education
Master of Science - Data Science
Chandigarh University
Punjab 08.2021 - Current
Master of Computer Applications - Computer And Information Sciences
Pune University
Pune, Maharashtra 08.2013 - 05.2015
Bachelor of Science - Information Technology
Dr. B.A.M.U. University
Aurangabad, Maharashtra 08.2009 - 04.2013
Skills
Microsoft Excel
undefinedSoftware
IntelliJ Idea
R studio
Anaconda
Eclipse
Tableau
Certification
Microsoft Power BI Foundation
Timeline
Data Analyst
Haqdarshak Empowerment Solutions Pvt. Ltd.
08.2023 - Current
Python Intermediate
07-2022
BI Data Visualization - Tableau Advance
05-2022
Master of Science - Data Science
Chandigarh University
08.2021 - Current
Advanced Microsoft Power BI
07-2021
Data Science R Basics
06-2021
Associate Data Analyst
Tata Consultancy Services
06.2021 - 07.2023
Microsoft Power BI Foundation
04-2021
Process Associate
Tata Consultancy Services
01.2017 - 05.2021
Associate - Customer Support
Tech Mahindra
03.2016 - 01.2017
Customer Care Executive
Allied Softech Pvt. Ltd
06.2014 - 08.2015
Master of Computer Applications - Computer And Information Sciences
Pune University
08.2013 - 05.2015
Associate Voice
Aditya Birla Minacs
04.2011 - 10.2011
Bachelor of Science - Information Technology
Dr. B.A.M.U. University
08.2009 - 04.2013
Similar Profiles
Punamdhita BoraPunamdhita Bora
Assistant Manager-Client Account Management at HaqdarshakAssistant Manager-Client Account Management at Haqdarshak
Jissin AntonyJissin Antony
Assistant Manager - Financial Shared Services at Thinksynq Solutions Pvt Ltd (Outsourced to Servion Global Solutions Pvt Ltd)Assistant Manager - Financial Shared Services at Thinksynq Solutions Pvt Ltd (Outsourced to Servion Global Solutions Pvt Ltd)
Hari Prasad PoovalingamHari Prasad Poovalingam
Quality Analyst at Nthrive Global Solutions Pvt. Ltd (Formerly E4E Business Solutions Pvt. Ltd)Quality Analyst at Nthrive Global Solutions Pvt. Ltd (Formerly E4E Business Solutions Pvt. Ltd)