Power Bi Business Analyst

Varsha Mawle

813-***-**** ***********@*****.*** https://www.linkedin.com/in/varshamawle/ Tampa, FL

EXPERIENCE SUMMARY :

Detail-oriented Business Analyst with over six years of experience in data analysis, reporting, and visualization. Adept at creating actionable insights by merging and reconciling large datasets across multiple systems. Skilled in Excel, Power BI, Tableau, SQL, and Python, with a proven track record of automating reporting mechanisms and providing data-driven solutions for senior stakeholders. Excels in delivering accurate, timely, and comprehensive metrics to support business and regulatory initiatives.

TECHNICAL SKILLS :

Data Analysis: Advanced Excel (Pivot Tables, VLOOKUP, INDEX-MATCH), Power BI, Tableau Programming and Scripting Languages: Python, Java, SQL, PL/SQL, R, SAS Programming Python Skills: NumPy, Pandas, TensorFlow, PyTorch, Scikit-Learn, Matplotlib Database & Big Data Framework: Oracle RDBMS, MongoDB, Cassandra, HBase, MySQL, Spark Core, Spark SQL Hadoop Skills: MapReduce, Pig, Hive, HBase, Zookeeper Visualization Tools : Tableau, PowerBI, Qlik, Google Looker, Viso

WORK EXPERIENCE :

Robert Half (Crete United), Tampa, FL, USA Sep 2024 – Present Data Reporting Analyst

Assist with data integration and migration for four partners transitioning to the Spectrum platform.

Map and upload data from the legacy ERP system to Spectrum, ensuring accuracy and completeness.

Collaborate with the MIS team to align data migration efforts with project goals.

Designed and optimized pivot tables while leveraging advanced Excel functions such as VLOOKUP, INDEX, and MATCH to enhance data analysis efficiency and accuracy.

Utilize Excel spreadsheets and other database files to support data mapping and migration tasks.

Ensure seamless data transfer to support the go-live process for one of the partners on Spectrum.

Troubleshoot and resolve any data migration issues with guidance from the MIS team.

Focus on accurately migrating GL (General Ledger) data to maintain financial integrity. Economic Impact Catalyst, Tampa, FL, USA May 2024 – Aug 2024 Data Analyst

Created KPI dashboard in Excel for data reporting and queried data using Pivot table, VLOOKUP, Match and Index which reduced the bottlenecks in the workflow.

Collected, cleaned, and processed large datasets from various sources to ensure data accuracy and reliability.

Maintained Excel workbooks, such as development of pivot tables, exporting data from external SQL databases, producing reports and updating spreadsheet information.

Developed Power BI and Tableau visualizations and dashboards.

Good in developing different Reports, Analytics, Data Mining solutions to various business generating data visualizations using Python, Tableau, Power BI and Google Sheets. Note: As an international student, I was unable to work due to visa constraints during Sep 2022 to Apr 2024, I was in Graduate school during this period.

Wipro Technologies, Pune India July 2016-Sep 2022

Senior Data Analyst

Gathered data from disparate systems for reporting and analysis.

Created pivot tables and utilized advanced functions (VLOOKUP, INDEX-MATCH, etc.) to streamline data analysis processes.

Designed and maintained Excel dashboards to visualize key performance indicators (KPIs) for senior management.

Expertise in Excel, Pivot Tables, VLOOKUP and other advanced functions.

Created interactive dashboards and visualizations in Tableau, Power BI, Qlik, Google Looker or similar tools to communicate insights effectively.

Designed and maintained Excel dashboards to visualize key performance indicators (KPIs) for senior management.

Use Tableau for SQL queried data, and data analysis, generating reports, graphics and statistical analysis.

Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.

Designed and implemented multiple dashboards using Power BI - PowerPivot; Power Query tools for in house metrics.

Conducted data cleaning and manipulation tasks using Excel macros, significantly improving data accuracy and efficiency.

EDUCATION :

University of South Florida, Tampa, Florida Sep 2022 - Dec2024 MS in Business Analytics and Information Systems GPA 3.8 Pune University June 2013 - June 2016

Bachelor of Computer Applications GPA 3.8

Contact this candidate