Sanket Gemawat

Business Intelligence Developer @Slipstream Life Sciences

PA, US

Designed and developed over 50 Power BI reports to track forecasting accuracy, budgeting trends, and spend trajectory, enabling FP & A teams to enhance budget allocation and profitability analysis.Implemented complex Row-Level Security (RLS) at 4 levels (report, project, department, and employee), ensuring controlled access to sensitive financial data and maintaining data confidentiality.Executed A/B testing, regression testing, unit testing for multiple SQL databases, Tableau and Power BI reports, ensuring 99% data accuracy and accelerating deployment by 30%.Constructed and optimized intricate DAX queries and measure tables for 20+ Power BI reports, leveraging calculation groups to streamline calculations and improve reporting efficiency.Developed 42 interactive Power BI reports and 20+ Tableau reports for biotech and pharmaceutical companies, providing insights into HCP engagement, patient trends, and prescription (Rx) data.Employed the ServiceNow system to extract ticketing data and develop over 21 reports, visualizing KPIs such as ticket resolution time, SLA compliance, first call resolution, and customer satisfaction.