Power Bi Senior Data

SUMMARY

•

VATAN SHAH

Big data/Cloud Technologies: Microsoft Azure, Amazon

Web Services (AWS), Google Colab, Salesforce, Smartsheets Project Management: Agile Methodologies,Micrsoft

Project, JIRA, Gantt Project, MS Visio, MS Planner Senior Data/Reporting Analyst – Beecan Health – Glendale, CA [PowerBI, MS SQL, Excel, Azure Cloud, ADF] Aug 2022 – Present Built and published 30+ interactive Power BI reports to represent financial, labor, demographics, turnover, census and clinical data for over 60 nursing facilities across three states. Feb 2022 – Jul 2022

• Designed 20+ executive-level Key Factor reports integrating Excel and Power BI used by the President of organization.

• Developed ETL pipelines using Azure Data Factory and stored data in Azure Blob, queried and modeled data with MS SQL.

• Implemented advanced DAX and M query transformations in Power BI for complex calculations and manipulations of data.

• Learned and followed the complete data journey - extracting data from 3rd party sources like PCC, Isolved, Sage, to implementing storage in Azure by creating data pipelines and querying the data using MS SQL to finally reporting the data in PowerBI and Excel.

• Utilized AI tools like ChatGPT to obtain streamlined solutions for complex problems in Azure, SQL and PowerBI.

• Delivered internal training sessions on Power BI an Excel. Data Analyst – iMedia Brand Inc - Fullerton, CA

ETL Development Tools: Microsoft Azure Data Factory(ADF), Snowflake, Streamsets, SSIS

PROFESSIONAL EXPERIENCE

AIRBNB Recommendation System :

• Created different predictive models (XGBoost, Decision Tree) on Airbnb dataset describing listings and metrics in New York city to predict rental pricing. XGBoost was determined to be the best model with RMSE value of 76.27.

• Visualizations designed using Python and Tableau included Geo-scatter plot, Stacked Bar Chart, Treemap,Barplot and wordcloud for text analysis.

Forest Cover Type Prediction Model :

• Implemented KNN, CART and Random Forest classification using R programming on the given cartographic variables.

• Achieved an accuracy of 76.62% using KNN model, 60.82% using CART model and 82.14% using Random Forest model. Super Data Analysis :

• Performed data analysis on Sales and Profit data on Superstore public dataset by developing various dashboards in Tableau. Point of Sale System :

• Developed a POS System Implementing Shiny Dashboard in Excel using Visual Basic for Applications (VBA).

• Built data pipelines using Streamsets and conducted ETL processes in Snowflake.

• Building, publishing customized interactive reports and dashboards analyzing advertising and media trends using PowerBI. Business Analyst/Project Manager - Nuetrino LLC (Client- Blackrock -Los Angeles, CA) Jan 2022 – Mar 2022

• Gathered and documented business/system requirements and translated them into BRDs.

• Documented project plans, process flow, timelines and other requirement using Smartsheets.

• Utilized Smartsheets and Tableau to design multiple scorecards and dashboards for HR and Finance teams. B2B Business Analyst - Circle K - CA Aug 2021 - Jan 2022

• Generate financial and customer reports using Tableau and Excel to improve finance tracking and customer trends.

• Forecasted fuel sales using historical finance and customer data and provided data-driven recommendations.

• Built ETL processes using SQL Server and Data Lake; managed data imports/exports across platforms.

• Understanding end user needs and analyzing their requirements, performing Cost-benefit Analysis and Risk Analysis. EDUCATION

Experienced Data Analyst with 5 years of expertise in Business Intelligence and developing specialized insightful reports and interactive dashboards using leading data visualization tools. Skilled in the art of data storytelling and presenting complex information in easily digestible and user-friendly formats. Proficient in ETL processes and advanced analytics tools to derive actionable insights from diverse datasets. Detail-oriented and committed to delivering accurate and actionable analytics by transforming raw data into compelling narratives that support strategic, data-informed decision-making. SKILLS AND EXPERTISE

Analytics & Reporting Tools: Microsoft PowerBI, Tableau,SSRS, Google Analytics,Advanced MS Excel (VBA, VLookup,

Pivot tables),Qlik Sense, Forecast Pro

Database Systems: Microsoft SQL Server, MySQL, MS Access, Oracle

Languages&libraries: Python(NumPy,Pandas,Matplotlib, Seaborn), R (ggplot2, shiny), VBA

***********@*****.*** 657-***-**** linkedin.com/in/vatanshah Fullerton, CA Master of Science in Information Systems at California State University, Fullerton May 2021 Bachelor of Engineering in Information technology at Mumbai University, India May 2018 ACADEMIC PROJECTS

Contact this candidate