Data Analyst Machine Learning

Prashanth Kumar Gunda

954-***-**** • *********.*******@*****.*** • Open to Relocation • LinkedIn

EDUCATION

Master of Science, Business Analytics Carl H. Lindner College of Business, University of Cincinnati Graduated: Aug 2024 Cincinnati, Ohio, USA

SKILLS

Technical Skills: SQL, Python, R, Excel, Hadoop, Hive, Google Analytics, No SQL, Excel VBA Data Visualization & Reporting: Power BI, Tableau, Amazon Quicksight, Cognos, Matplotlib, Seaborn Data bases & Datawarehouse: Power Pivot, Power Query, Informatica Powercenter, ORACLE, BigQuery, Redshift Business & Soft Skills: Data Storytelling, Cross-Functional Collaboration, Communication, Project Management Machine Learning & Statistics: Hypothesis testing, Regression, Classification, Clustering, Decision Trees, Random Forest WORK EXPERIENCE

Graduate Assistant- Data Science Aug 2023 - Dec 2023 University of Cincinnati Cincinnati,OH

• Examined database of ~15M EHRs using Excel, SQL, and designed a data pipeline with Clinical BERT, optimizing the extraction of social determinants for diabetes through NLP, integrating SNOMED for clinical data.

• Devised an SSIS ETL pipeline to efficiently manage data from multiple sources, streamlining the analysis process and reducing data processing time by 40% relative to manual data integration methods.

• Created comprehensive Tableau dashboards using jittered bar charts and butterfly charts to track and analyze SDOH factors affecting patient outcomes, enhancing better project plans and data-driven decision making. Data Analyst Apr 2022 - Jul 2023

Infosys Hyderabad, India

• Uncovered a 14% increase in conversion rate by analyzing customer behavior through a data pipeline integrating Google Analytics, CRM, third party data to GCP Big Query, and Tableau, resulting in $480K in additional revenue.

• Applied K-means clustering in BigQuery ML to categorize customers, driving personalized marketing campaigns, incorporating A/B testing resulting in a 19% rise in customer engagement levels.

• Using RFM analysis, developed customer segments and predicted customer lifetime value (CLV) and revenue for different segments and designed customer acquisitions.

• Developed Tableau dashboards incorporating ROI, attribution models, and sales funnel analysis, tracking key KPIs such as conversion rate, CPC, and CTR for 250+ campaign comparisons and optimization.

• Collaborated with cross-functional teams to identify areas of improvement in data collection and analysis processes, leading to a 12% reduction in errors and inconsistencies. Data Analyst Jul 2021 - Dec 2021

BYJU’S Bengaluru, India

• Analyzed a dataset of over 10M students at BYJU'S, using SQL to identify factors contributing to student churn, including demographics, academic targets (SAT, GRE), and chosen streams.

• Enhanced SQL query performance through normalizing, indexing and partitioning, improving retrieval times.

• Developed a churn prediction model using Python and LightGBM, enabling targeted marketing campaigns that enhanced student retention by 11%.

Data Associate Jul 2019 - Jun 2021

IIT Hyderabad Hyderabad, India

• Analyzed ~323K unique patient clinical records and used readily available clinical parameters to build an SVM model classifying ARDS endotypes, projecting a 30% reduction in mortality rate for a major hospital chain.

• Utilized Google Colab and BigQuery for data modeling, cleaning, manipulation, and process raw patient data, ensuring data privacy.

• Created Power BI dashboard for clinical audience to automate gene-drug-disease mapping, enabling quick visualization of genes, reducing data retrieval time from minutes to seconds. PROJECTS

• Developed a near real-time data pipeline using AWS Kinesis Firehose to process and store credit card transactions data in S3, enabling dynamic data analysis with AWS QuickSight to identify fraudulent activities.

• Developed a chatbot with LangChain, GPT-3.5, and advanced RAG techniques for handling queries related to BI visualizations, DAX and calculations.

Contact this candidate