Apoorv Pandkar

About Apoorv Pandkar

I am working in Financial Reporting Team at Parallon HCA Healthcare. I completed my masters in Computer Science from University of Texas at Arlington in May 2021. I am a professional data analyst over the last 4+ years. I started my professional career with a multinational company like Accenture and Deloitte.Passionate and results-driven Data Analyst with over four years of hands-on experience in extracting actionable insights from complex datasets. I specialize in transforming raw data into meaningful narratives that drive strategic decision-making. My expertise lies in SQL, Python, and data visualization tools like Power BI, enabling me to analyze and present data in a compelling and accessible manner.Skills/Technologies/Framework:SQLPythonData Visualization (Tableau, Power BI)ExcelCloud Platforms (AWS, Azure, GCP)Apache SparkApache KafkaStatistical AnalysisData CleaningData ModelingData WarehousingETLPandasExploratory Data Analysis (EDA)Dashboard CreationBusiness IntelligenceMachine Learning (Basic)Google AnalyticsData InterpretationA/B TestingTime Series AnalysisData MiningPredictive AnalyticsData PresentationGit

Experience

1. Business Intelligence Analyst

   Parallon

   Aug 2023 — Present · US

   Utiliized Azure Synapse analytics to integrate and transform disparate healthcare datasets facilitating comprehensive analysis.• Developed complex SQL queries, analyzed patient data to gain insights using SQL Server improving healthcare outcomes by 15%.• Implemented cost-effective strategies within Azure Synapse Analytics, such as optimizing data storage and processing resources, to ensure efficient utilization of cloud resources while saving $20 M by managing costs effectively.• Led discussions on process improvements, translating complex data into actionable insights, resulting in a 15% improvement in healthcare outcomes. Prepared detailed operational reports for executive management, enabling data-driven decision-making.• Partnered with clinical and operational teams to develop key performance indicators (KPIs) by generating reports in Power BI that drove significant improvements in patient outcomes and cost-efficiency.

Education

• New England College

  Master's degree, Data science and analytics

• Savitribai Phule Pune University

  Bachelor's degree, Computer Science

• The University of Texas at Arlington

  Master's degree, Computer Science