Data Analyst Power Bi

Yash Khamitkar

Data Analyst

***************@*****.*** 902******* Yash Khamitkar

Aspiring to be a part of a fast-paced and innovative organization as a data analyst, where I can use my experience in data collection, predictive modeling, and data visualization to drive impactful insights. SKILLS

Microsoft Excel SQL Tableau Power Bi Client communication Power Query Data Management Data Validation Tableau Desktop Advance Excel Python PowerPoint Pandas Snowflake Data Analytics JIRA Snowflake Power Automate Tableau Prep

PROFESSIONAL EXPERIENCE

Capacity LLC, Jr. Data Analysis 2024/07 – Present Pune India

•Created and published 30+ interactive dashboards in Tableau Desktop, utilizing calculated fields, LOD expressions, parameters, dual-axis charts to deliver meaningful business insights.

•By using the Power Query and advance excel, manipulated the raw and complex prosprave client data into meaning full insight to help the sales and the pricing team.

•Worked on the migration of SSRS reports to Tableau dashboards.

•Handle ad-hoc data requests from Jira tickets, using SQL (SSMS) for extraction, querying, and manipulation; apply conditional formatting and pivot tables in Excel before delivering reports to clients.

•Worked on migrating reports from Tableau Server to Tableau Cloud, performing quality checks and implementing improvements.

•Worked on the implementation of Tableau Virtual Connections to enable Row-Level Security (RLS), where external clients could view only their own data in report. and Created SQL views in the database.

•Monitored daily SQL job runs to keep database data up to date. Investigated job failures by analysing stored procedures, identified root causes, and worked with IT to resolve issues, ensuring Tableau dashboards show the accurate and updated data.

•Built ETL processes using Tableau Prep to change raw data into the required format, published flows to Tableau Cloud, and monitored flow extracts to ensure clients receive updated data.

•Did UAT and data checks to make sure the data is correct and KPI matches business needs.

•I have knowledge of Tableau Cloud, including report publishing, flow scheduling, and permission management.

•Created Entity Relationship (ER) diagrams for analytical database.

•Knowledge of the Third-Party Logistics (3PL) industry. Eaton Technologies Private Limited, Data Analyst 2023/10 – 2024/08 Pune, India

•Responsible for the comprehensive analysis of datasets and the end-to-end delivery of Power BI dashboards, starting from requirement gathering to presenting the final demo of the dashboard to stakeholders. Prepared reports and important documentation for stakeholders stating trends, patterns, using relevant results from analysis.

•Engaged in developing a user-friendly and easy-to-use CSV comparison application for non-technical individuals, resulting in a 70% reduction in manual intervention.

•Used Python (Pandas library) to clean and transform messy Excel files into the required format.

•Set up a workflow automation for users to refresh Power BI reports whenever changes have been made in the source file.

•Developed a comprehensive Standard Operating Procedure (SOP) for Power BI reporting, which streamlined the data analysis process and enhanced the efficiency of business decision-making.

•Migrated VBA code to Power Query in Excel.

***************@*****.***

•Completed tasks with top quality and dedication. Work well in teams, focusing on what's best for the business. InfoStack Software Development Pvt. Ltd, Intern 2023 – 2023

•Gathered requirements from the manager and understood the system.

•Imported data from MySQL and Microsoft Excel .

•Developed custom measures,KPI and calculated columns using DAX.

•Design and develop Power-BI dashboard as per the client's requirement.

•Made use of Bookmarks, Filters, Dynamic Dashboard to improve usability of dashboard. Wipro, Design Engineer 2019/08 – 2020/07 Pune

•Gathered requirements from the sales team for understanding of customer specifications and requirement.

•Custom logic development as per customer requirement using DIAlux lighting software. Submitted the report along with BOQ In Microsoft Excel.

•Completed 100+ project.

CERTIFICATES

I have successfully completed Full Stack Data Analytics and received Certificate from iNeuron.ai. I have successfully completed Snowflake Hands-On Essentials: Data Warehousing Workshop First prize in Project Competitions held at V.V.P. Institute of Engineering & Technology, Solapur. EDUCATION

B.E (Electrical), N.B. Navale Sinhgad college of Engineering. 2015 – 2018 Solapur GPA - 8.84/10.0

***************@*****.***

Contact this candidate