Power Bi Data Analyst

SANKET PRABHUNE

Data Analyst

SUMMARY

Phone: +91-878*******

Email ID: ****************@*****.***

Address: Talawade, Nigdi,Pune 411062

Detail-oriented Export Executive with hands-on experience in preparing power bi dashboards, carrying out data analysis. Skilled in coordinating with stakeholders, shipping lines, freight forwarders, skilled in using tools like ERP, SQL, Power bi, Jira. Languages: SQL, DAX, M-Language, Python

Tools: Power BI Desktop, SQL, Data Warehouse, SharePoint, Jira, Postgres SQL, Agile Methodologies, UML, BPMN, Requirement gathering, BRD,

CORE COMPETENCIES

Data Visualization.

Analytical and Research Skills.

Report and Dashboard.

W O R K E X P E R I E N C E

Data Warehouse Architecture.

Data Modelling and Designing.

Business Intelligence.

MSC Service Center India Pvt Ltd, Pune. MAY 2022 - Present Designation: Executive

Expertise in ETL (Extract, Transform, Load) design, develop and test various Power BI reports using drill down, drill through bookmark, grouping, binning, parameterized by connecting from different data sources. Skilled in writing DAX queries and expressions within Power BI Desktop for advanced Data Analysis. Worked on string, time intelligence, date, filters, logical, math, stat functions majorly. Having experience in various filters (report, page, visual, drill through), slicers, manage parameter, toggle buttons. Expertise in creating Data Visualization like matrix, table, chart, gauge, cards, categorical visual and maps. Experience in creating workspaces, dashboard in Power BI Service. Implemented ERP system: Led deployment of Warehouse Management System / ERP / TMS that improved order processing time by 30% and reduced manual errors by 40%

Skilled in writing and implementing POSTGRES -SQL scripts, including stored procedures, views, and indexes. Experienced in creating Business Requirement Documents (BRD) and collaborating with project stakeholders to outline solutions. MSC Service Center India Pvt Ltd, Pune. AUG 2021 - May 2022 Designation: Executive

Worked as Logistic Coordinator for North China region. PROJECTS

1. Project Name: - Shipping Analysis Report

Collaborated closely with clients to grasp their models, data, and requirements, leading to the creation of a comprehensive Business Requirements Document (BRD).

Enabled the client to successfully lower their Crossover Error Rate (CER) to an impressive 15% through insightful reporting. Crafted engaging visuals and built intuitive dashboards, tailoring customizations to enhance the end-user experience and meet specific needs. Designed custom visuals and Key Performance Indicators (KPIs), resulting in a 10% reduction in delivery times and helping the client avoid penalties from customs authorities in the EU and USA. 2. Project Name: - Finops Report

Created around 45 Detailed Reports and 15 Interactive Dashboards for the Freight Sales Teams, leading to a remarkable 30% boost in operational efficiency.

DAX, Power Query, SQL, Data Analysis, Data Modeling, Data Visualization, KPI Dashboards, Business Intelligence, Reporting Automation, Python, Excel, Tableau, Predictive Analytics, Data Warehousing, ETL, SSIS, MS SQL Server, Azure Synapse, Snowflake

EDUCATION AND CERTIFICATIONS

BBA International Business Pune University (2021)

Business Analyst Seven Mentor (2024)

Learning path in Data science Board Infinity (2021) Data Analysis, Power BI, DAX, Power Query, SQL, Data Modeling, ETL, Excel, Data Warehousing, SSIS, Python, Tableau, Data Visualization, KPI Dashboards, Business Intelligence, Reporting Automation, Ad-hoc Reporting, Data Storytelling, Predictive Analytics, MS SQL Server, MySQL, Oracle, Snowflake, Azure Synapse, Google Big Query, AWS Redshift, Data Lakes, Data Pipelines, Problem-Solving, Business Acumen, Communication, Stakeholder Management, Agile, SDLC, Cross-Functional Collaboration

Contact this candidate