Hithesh Medavarapu

Highly skilled Data Analyst with 3 years of experience in analyzing large datasets, implementing machine learning models, and delivering actionable insights. Expertise in data mining, validation, and visualization, combined with a strong proficiency in using tools and methodologies such as SDLC, Agile, and Waterfall. Adept at employing NumPy, Pandas, Matplotlib, and other advanced packages to drive data-driven decision-making.

Experienced in creating dynamic dashboards and reports using Tableau, Power BI, and MS Excel, simplifying complex data for diverse stakeholders. Proficient in leveraging AWS services for scalable data storage and processing, and managing various database systems including MySQL, SQL Server, and NoSQL databases. Dedicated to optimizing data processes and enhancing data accessibility to support strategic business objectives.

• Led data extraction, transformation, and loading (ETL) processes to migrate healthcare data from legacy systems into

Snowflake, optimizing data storage and retrieval for reporting and analysis.

• Conducted in-depth data cleaning and preprocessing using Python (Pandas, NumPy) on patient records, ensuring accurate and actionable insights for healthcare providers by eliminating anomalies and missing values.
• Collaborated with cross-functional teams to design dynamic Tableau dashboards, enabling real-time monitoring of hospital operational metrics such as bed occupancy rates, patient throughput, and staff allocation.
• Utilized SQL and Power BI to automate monthly financial reporting on insurance claims, integrating data from multiple sources and reducing report generation time by 50%.
• Spearheaded the implementation of predictive analytics models using Python and SciPy to forecast patient admissions,

helping the hospital optimize staffing and resource allocation during peak periods.

• Worked closely with the IT department to implement a cloud-based data warehousing solution on AWS, improving data accessibility and supporting HIPAA compliance across all hospital departments.
• Provided training to healthcare administrators on data visualization and reporting tools, enhancing data literacy within the organization and promoting data-driven decision-making.

Master of Science in Computer and Information Sciences

University: State University of New York at New Paltz

CGPA: 3.72

Aug 2022 - May 2024