Vaishnavi Gopal

*Developed interactive and visually appealing dashboards using power BI desktop, incorporating various data sources, such as sharepoint, Excel, and SQL server.

*Implemented complex data transformations and modeling using DAX and Power query for optimal report performance.

*Executed Complex SQL queries to extract, transform and analyze large datasets,ensuring optimal database performance.

*Utilized Excel for data manipulation including Pivot Tables, VLOOKUPS,and complex formulas, resulting in streamlined reporting processes.

*Proficient in writing Excel MACROS using VBA to automate tasks and improve workflow efficiency.

*Review and update documentations and formalization of Government pricing policies and SOP's.

*Updated Analysis for 40 quarters of backdated organizational Medicaid data for over 50 states and 350 programs.

*Create Ad-Hoc reports upon request from various departments and provided analytical support as per demand.