Prathamesh Bawaskar

About Prathamesh Bawaskar

Results-driven Data & Business Analyst with 5+ years of experience leveraging SQL, Python, and BI tools to drive data-driven decision-making. Expertise in interactive dashboard development (Tableau, Power BI), ETL optimization (SSIS, Snowflake), and process automation to enhance operational efficiency and data accuracy. Skilled in collaborating with cross-functional teams, translating complex business needs into actionable insights, and implementing AI-driven automation to reduce manual effort. Strong background in data governance, regulatory compliance (HIPAA, GDPR), and cloud-based analytics (AWS, SaaS, SAP). Passionate about building scalable data solutions that drive strategic growth, predictive analytics, and business impact through innovative data modeling and process improvements.

Experience

1. Data Analyst

   MetLife

   May 2023 — Present · NJ, US

   Conducted business process analysis using process mining tools, identifying inefficiencies and implementing automation solutions that improved operational efficiency by 20%. • Utilized Python (pandas, NumPy) to clean, transform, and preprocess large datasets, ensuring high-quality data for analysis and reporting. • Developed comprehensive Business Requirement Documents (BRDs) and Functional Specifications Documents (FSDs) using Confluence, improving collaboration between stakeholders and reducing project scope creep by 30%. • Designed and deployed automated data pipeline architecture to extract and consolidate data from external sources, feeding into Tableau for real-time business intelligence reporting. • Created scalable SSIS packages for efficient handling of increasing data volumes, improving ETL performance by 10%. • Optimized Snowflake performance by 30% through query tuning, indexing, and partitioning, reducing query response times and improving database efficiency. • Developed complex SQL queries incorporating subqueries, Common Table Expressions (CTEs), and window functions to enhance data extraction and transformation processes. • Created advanced SQL-based data models, improving data accuracy and accessibility for actuarial teams and financial analysts. • Developed interactive Tableau dashboards visualizing Key Performance Indicators (KPIs) for executive decision-making, reducing manual report generation time by 40%. • Automated Power BI reports integrating SQL and Snowflake datasets, cutting down data processing time by 35% and refining risk assessment models for insurance underwriting teams. • Implemented predictive analytics models in SAS to analyze financial trends, improving forecasting accuracy and reducing financial losses by 25%. • Integrated Salesforce CRM data with SQL databases, reducing lead processing time by 40% and improving customer insights for business development teams.

Education

• DY Patil University

  Bachelor's degree