Anwit Gharat

ANWIT GHARAT Mumbai, India |-| +(91)- | http://linkedin.com/in/anwit gharat-9ba872109 | SUMMARY Highly accomplished Senior Data Analyst with 10 years of progressive experience transforming complex datasets into actionable business intelligence. Proven expertise in end-to-end data lifecycle management, from collection and analysis to advanced visualization and strategic reporting. Adept at leveraging a robust toolkit including Power BI, SQL, Python, KNIME, and Excel to drive data-driven decision-making, optimize operations, and significantly improve productivity and profitability. TECHNICAL SKILLS ●​ Business Intelligence & Visualization: Power BI (DAX, Power Query, Power Pivot), Tableau ●​ Programming & Databases: Python (Pandas, NumPy, Matplotlib, Seaborn, Plotly), SQL (SQL Server, Oracle SQL) ●​ Data Platforms & Tools: KNIME Analytics Platform, Microsoft Excel, SAP, CRM, Oracle, Microsoft SharePoint, JIRA, Confluence ●​ Core Concepts: Data Mining & Analysis, Reporting, Business Intelligence, Data Storytelling, Process Automation WORK EXPERIENCE Senior Analyst, Finance Operations | Priceline.com | Mumbai, India April 2024 – Present ●​ Developed and optimized complex SQL queries, reducing data download time by ●​ ●​ ●​ ●​ 60% and increasing monthly reconciliation efficiency by 40%. Implemented efficient join techniques to accurately reconcile disparate financial datasets. Automated critical report generation using Python (NumPy, Pandas), eliminating 80% of manual tasks and improving team productivity by 50%. Designed and built interactive dashboards using Tableau, translating raw data into actionable business intelligence for various stakeholders. Managed communications with USA-based vendors and stakeholders, ensuring seamless data exchange and timely issue resolution. Senior Data Analyst | Mettler Toledo India PVT LTD | Mumbai, India September 2018 – March 2024 ●​ Spearheaded the development of a Power BI customer dispute dashboard, ●​ ●​ ●​ ●​ decreasing Turnaround Time (TAT) from 60 to 30 days and reducing aging percentage from 30% to 15%. Created insightful Power BI visualizations for Cash Collections, Procure-to-Pay, and Record-to-Report, utilizing advanced DAX expressions to build robust data models and solve complex problems. Designed, managed, and optimized databases using SQL Server Management Studio (SSMS), improving data viewing efficiency by 30% through efficient queries, tables, views, and stored procedures. Implemented automated data workflows with KNIME, reducing manual tasks by 80% and enhancing overall data processing efficiency. Leveraged Python (Pandas, Matplotlib, Seaborn, NumPy, Plotly) for in-depth data analysis and visualization, including automating daily backup tasks to reduce manual effort by 30%. Customer Service Assistant | Jet Airways | Mumbai, India January 2017 – September 2018 ●​ Assisted diverse clientele with service requests, developing strong problem-solving and detail-oriented skills, and managing operational processes including bookings and flight coordination. Customer Service Assistant | Concentrix (IBM Business Services) | Mumbai, India November 2014 – May 2016 ●​ Provided comprehensive customer support across multiple channels, resolved a wide range of queries, and conducted regular system audits to ensure data accuracy and operational efficiency. EDUCATION Master of Commerce | Mumbai University | Mumbai, India​ ​ May 2016 – September 2018 Bachelor of Commerce | Mumbai University | Mumbai, India ​ July 2013 – May 2016 Higher Secondary Certificate | Maharashtra Board ​ ​ April 2012 – March 2013