Madhuri Arugonda
Odessa,FL
Summary
Experienced professional with 6+ years in data analysis, business intelligence tools. Accomplished in roles involving business analysis, business data applications, data integration, and mentorship. Expertise in SQL, Power BI, Tableau, Python and MS Excel.
Overview
12
12
years of professional experience
Work History
Data Analyst
GoodRx
07.2023 - 02.2024
- Interacted and coordinated with business users to interpret business rules and translated the requirements to data teams
- Involved in defining the source to target data mappings, business rules and data definitions
- Worked with data governance teams and reduced data quality issues by 70% in compliance reports for EDI transactions
- Wrote complex SQL queries on staging tables and data warehouse tables to validate the data results
- Worked on Pharmacy Claims of different vendors and developed Drug Utilization dashboards
- Created vendor management and customer scorecard reports in Power BI
- Developed semantic models in Power Query for ad-hoc reporting and analysis.
Data Analyst
Meridian Health Plan
01.2016 - 03.2018
- Worked with Business analysts for requirement gathering, technical specifications, and testing and project coordination
- Interacted and efficiently coordinated with diverse group of professionals in the organization including managers and executives
- Administered users and BI user groups in the organization and promoted BI tool adoption
- Developed HEDIS and Medicare Star dashboard for Quality teams as part of enterprise reporting suite
- Created dashboards and reports using calculated fields, parameters, groups, sets and hierarchies in Tableau
- Extensively used data blending, embed functionalities in Tableau
- Developed, debugged, and optimized SQL queries for reporting
- Automated recurring reports using SQL and Python
- Implemented adoption of Power BI and migrated selected dashboards to PBI from Tableau
- Created SSIS jobs for processing data from various systems and transformed tables in Data Warehouse
- Developed technical specification documents, ETL design documents and data impact reports
- Prepared technical design documents to load data into various tables in Data Warehouse.
Business Analyst
Union Bank of Swiss - UBS
01.2012 - 09.2015
- Facilitated meetings with business subject matter experts (SME), decision makers, system owners, and end users to define goals and requirements for reports, dashboards, and analytics
- Transformed business goals and requirements into designs, leveraging proven design patterns for optimal solutions
- Performed data transformations and cleansing using SQL scripts
- Developed interactive dashboards and reports in SSRS, Excel and Tableau as per the reporting specifications
- Experience working on Microsoft Excel and hands on experience in creating pivot tables, VLOOKUP, GETPIVOT and other functions
- Created dimension hierarchies to achieve the drill-down and drill-through functionality
- Analyzed financial data to identify trends, patterns, and opportunities for process improvement
- Created dashboards to track financial metrics and provide real-time insights for senior leadership
- Created usage tracking reports for monitoring the usage of the reports
- Build test scripts to thoroughly test the accuracy and completeness of reports.
Education
Master of Science Information Systems -
University of Michigan - Dearborn
Dearborn, MI04.2020
Skills
- BI Tools: Excel, Tableau 11x, Power BI 211x
- Programming/Scripting Languages: SQL, PL/SQL, T-SQL, Python 2x, PowerShell 4x
- Relational Databases: MySQL, SQL Server 2012, Oracle 11c/12c
- Operating Systems: Windows, Linux
- ETL Tools: SSIS 2013, Alteryx 118
- Database Tools: SSMS, SQL Developer, DBeaver
- Microsoft Office Suite
Accomplishments
- Assoc. of the Month - May 2013: For resolving highest (~40%) number of tickets and receiving client appreciations.
- Assoc. of the Month - Nov' 2013: Developed a tool to automate the testing process which reduce time from 30 mins to 1 min.
Timeline
Data Analyst
GoodRx
07.2023 - 02.2024
Data Analyst
Meridian Health Plan
01.2016 - 03.2018
Business Analyst
Union Bank of Swiss - UBS
01.2012 - 09.2015
Master of Science Information Systems -
University of Michigan - Dearborn