Prahith Aleti

Prahith Aleti

Data Analyst
United States of America

نبذة عني

4+ years of proven expertise in Data Analysis, utilizing a diverse skill set encompassing statistical techniques, machine learning algorithms, and advanced data visualization tools. Led end-to-end SDLC projects, adeptly …

الخبرة

Data Analyst

Optum
Sep 2023 - حتى الآن · 2 سنوات 10 أشهر

• Conducted SQL queries on Electronic Health Records (EHR) databases to extract specific patient information, including details from demographics tables, medical history records, medication databases, and discharge summaries.
• Implemented Extract, Transform, Load (ETL) processes to refine and structure raw healthcare data, ensuring its usability for further analysis.
• Executed Exploratory Data Analysis (EDA) techniques to gain insights into the distribution of patient demographics, diagnoses, and readmission rates. Utilized Python's Matplotlib and Seaborn libraries for visualizations, presenting key findings through detailed charts and graphs.
• Adhered to healthcare data regulations, particularly ensuring compliance with the Health Insurance Portability and Accountability Act (HIPAA) to protect patient privacy and confidentiality throughout the data extraction and analysis process.
• Leveraged visualization tools such as Tableau to connect to the cleaned and transformed healthcare dataset. Established connectors to seamlessly link Tableau to relevant databases containing patient information, facilitating direct access to up-to-date and accurate data for visualization and reporting purposes.

Data Analyst

Optum, MI
Sep 2023 - حتى الآن · 2 سنوات 10 أشهر

Conducted SQL queries on Electronic Health Records (EHR) databases to extract specific patient information, including details from demographics tables, medical history records, medication databases, and discharge summaries.
Implemented Extract, Transform, Load (ETL) processes to refine and structure raw healthcare data, ensuring its usability for further analysis.
Executed Exploratory Data Analysis (EDA) techniques to gain insights into the distribution of patient demographics, diagnoses, and readmission rates.
Utilized Python's Matplotlib and Seaborn libraries for visualizations, presenting key findings through detailed charts and graphs.
Adhered to healthcare data regulations, particularly ensuring compliance with the Health Insurance Portability and Accountability Act (HIPAA) to protect patient privacy and confidentiality throughout the data extraction and analysis process.
Leveraged visualization tools such as Tableau to connect to the cleaned and transformed healthcare dataset.
Established connectors to seamlessly link Tableau to relevant databases containing patient information, facilitating direct access to up-to-date and accurate data for visualization and reporting purposes.

Data Analyst

HCLTech, India
Jan 2020 - Dec 2021 · 1 سنة 11 أشهر

Worked with Data Management team to analyze Reinsurance Data using tools like SQL, Access, Excel (Lookups, Pivot tables) and predicting any future impacts on business.
Pre-processed data for trading strategy evaluation using MySQL.
Consolidated data from separate tables into one table with a distinct symbol indicator for each stock, for easier evaluation of trading strategies.
Gathered customer data from various sources, including transaction logs, customer support interactions, and demographic information.
Utilized clustering algorithms such as k-means to segment customers based on purchasing behavior, frequency, and recency of interactions.
Presented A/B testing results in Tableau dashboards to compare the performance of different marketing strategies and utilized bar charts or box plots to showcase statistical significance and performance metrics.
Utilized ETL pipelines in Talend to implement customer segmentation algorithms and utilized components for clustering or classification to identify and assign customers to specific segments.
Developed a comprehensive UAT test plan outlining the testing scope, objectives, and acceptance criteria.
Leverage AWS EMR (Elastic MapReduce) for distributed computing when dealing with large-scale data processing tasks and implemented Spark or Hadoop on EMR for parallel processing.

Data Analyst

Zensar Technology, India
Nov 2017 - Dec 2019 · 2 سنوات 1 شهر

Analyzed and extract data from various Confidential using SQL.
Performed data cleansing and manipulation by using excel VLOOKUP’s, pivot and other advance excel functions.
Captured end-to-end lineage and ensure proper impact analysis has been performed in the event of changes to data assets as they move across the pipelines.
Maintained data flow documentation and perform object mapping using BI tools and validation.
Participated in daily Agile and Scrum master meeting to provide feedback and updates on the project.
Used DAX functions to create measure and calculated fields to analyze data for logical visualization and used Power Queries to transform the data.
Created PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.
Extracted data from data warehouse server by developing complex SQL statements using stored-procedures and common table expressions (CTEs) to support report building.
Implemented report integration among Power BI, SSRS and Python reports.

المهارات

التحليلات تحليل البيانات المحترف إدارة نظم المعلومات تنقيب البيانات مايكروسوفت أكسس نظام التحليل الإحصائي (SAS) لغة الاستعلامات الهيكلية (SQL) تمثيل البيانات مهارات تحليل البيانات باور بي آي لغة البرمجة آر (R) تابلو Data Analysis Statistical Techniques Machine Learning Python NumPy Pandas Matplotlib Seaborn SciPy ggplot2 Scikit-learn Advanced Excel AWS MySQL SQL Server PostgreSQL MongoDB Oracle Jira HP Quality Center UAT ETL Exploratory Data Analysis SSIS SSRS Predictive Modeling Classification Regression Clustering A/B Testing Data Cleaning Data Wrangling Storytelling Association Rule Analysis Git GitHub KPI Tracking Communication Windows Linux macOS Data Warehousing Big Data Access Talend Spark
الإبلاغ عن هذا الملف الشخصي؟