Data Analyst Healthcare

REVANTH SAI PIRATI

DATA ANALYST

Location: TX Phone: 940-***-**** Email: **************@*****.***

SUMMARY

Proficient in updating and maintaining patient records within specialized software like Clinirex, ensuring accuracy and completeness post-analysis.

Experienced in cleaning and validating existing datasets to ensure data integrity and reliability for informed decision-making.

Advanced proficiency in Microsoft Excel, Word, Access, and SQL, enabling efficient data manipulation and analysis for healthcare purposes.

Comfortable working with data provided by data engineers to derive actionable insights.

Developed and maintained SQL queries to extract and manipulate healthcare data from electronic medical records, enhancing data accessibility and usability.

High Availability and Disaster Recovery Systems Design and Implementation on SQL Server (Always On, Mirroring and Log Shipping).

Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouse and into Azure Data Lake using Talend, SSIS.

Designed and implemented statistical models to identify patient risk factors and predict adverse events, contributing to proactive healthcare management and intervention.

Designed and developed custom reports and dashboards using healthcare analytics software, facilitating data visualization and interpretation for strategic decision-making.

Proactive in staying updated with industry trends and best practices in data analysis. Eager to expand knowledge and skill set through ongoing learning and professional development opportunities.

TECHNICAL SKILLS

Programming Language: Python, SQL, JavaScript, Unix Shell Scripting

Databases: MySQL, Oracle, MS SQL Server.

Data Visualization Skills: Tableau, Power BI, MS Excel

Operating Systems: Windows, Unix/Linux

ETL Tools: Informatica

Methodologies: Agile, Waterfall.

Version Control Skills: Git, GitHub.

Analytical Skills: Data Mining, Data Cleansing, Statistical Analysis, Data Visualization, Text Mining,

Data Wrangling, Data Warehousing, Critical Thinking, Problem-solving, Communication.

EDUCATION

Campbellsville University, USA

Masters in Information Technology Aug 2022 - May 2024

Chalapathi Institute of Pharmaceutical Sciences

Bachelors in Pharm.D Aug 2016 – May 2022

PROFESSIONAL EXPERIENCE

Optum, MN, USA

Data Analyst Mar 2023 - Present

Gather, clean, and structure large-scale healthcare datasets, ensuring accuracy and integrity across multiple sources.

Develop and maintain dashboards and reports to track key performance indicators (KPIs) for patient outcomes, operational efficiency, and cost management.

Analyze healthcare data using SQL, Python, and BI tools (Tableau, Excel) to identify trends and generate actionable insights.

Assist in building predictive models and forecasting trends to support strategic planning and decision-making.

Collaborate with cross-functional teams (clinical, operational, financial) to translate business needs into data-driven solutions.

Ensure compliance with HIPAA and other healthcare regulations, maintaining secure handling of sensitive data.

Automate data processes to improve workflow efficiency and reduce human error.

Contribute to the development of business intelligence tools and platforms for enhanced data accessibility based data.

Design and manage ETL processes to extract, transform, and load data from diverse systems (e.g., healthcare claims, EHRs) into centralized data warehouses for analysis.

Healthcare Data Intern, Govt General Hospital, India

Data Analyst Apr 2021 - Jul 2021

Updating patient records in Clinirex software after completion of analysis

Entering observed Adverse Drug Reactions (ADRs) into the database system.

Cleaning and validating existing healthcare data to ensure accuracy and reliability.

Created Data Quality Scripts using SQL and Hive to validate successful das ta load and quality of the data. Created various types of data visualizations using Python and Tableau.

Utilizing Microsoft Excel, Word, Access, and SQL to manipulate and analyze healthcare data.

Analyzed the existing application programs and tune SQL queries using execution plan, query analyzer,SQL Profiler and database engine tuning advisor to enhance performance.

Developing and maintaining SQL queries to extract and manipulate electronic medical records.

Analyzed functional and non-functional business requirements and translate into technical data requirements and create or update existing logical and physical data models.

Created ad hoc queries and reports to support business decisions SQL Server Reporting Services (SSRS).

Developed solutions to leverage ETL tools and identify opportunities for process improvements using Informatica and Python

Creating custom reports and dashboards using healthcare analytics software for data visualization and interpretation.

Contact this candidate