Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

DOLLY KRISHNA PRIYA BHEEMANA

Charlotte

Summary

Highly motivated and detail-oriented with 3 years of experience as Data Analyst with a strong foundation in health and finance data analytics, data visualization, and SQL-based querying. Proficient in Python (Pandas, NumPy), Excel, and BI tools like Power BI and Tableau. Experienced with cloud platforms (AWS), APIs, and ETL pipelines. Passionate about deriving actionable insights to support data-driven decisions and eager to grow in a dynamic analytics environment.

Overview

3
3
years of professional experience

Work History

DATA ANALYST

DXC TECHNOLOGY
09.2022 - 06.2023
  • Extracted, transformed, and loaded over 1TB data from SQL Server, HTTP end points and REST APIs into Hive external tables via Sqoop and Spark ETL Processes
  • Integrated retail and corporate sales data with PySpark, utilizing UDFs for aggregation and Python scripts for Data Frame manipulation, resulting in a 30% reduction in processing time and handling over 2 million records daily.
  • Orchestrated end-to-end data workflows and pipelines by leveraging Azure Data Factory, enhancing data integration and management.
  • Designed and managed scalable data warehouse solutions in Azure Synapse Analytics, handling over 5 TB of data and improving query performance by 10% for high-performance analytics and reporting.
  • Created Power BI reports and dashboards utilizing DAX expressions and complex data models to provide sales insights.

Data Analyst

Stellantis Hyderabad, India
Hyderabad
06.2020 - 06.2022
  • Python programming to conduct data analysis on preventive maintenance records for 1000+ equipment units. Employed regression analysis techniques with Pandas and NumPy to forecast maintenance costs at the outset of each fiscal year.
  • Utilized Kafka for real-time processing of preventive maintenance logs on equipment data, managing over 300 messages per minute, and stored the processed data using AWS S3. Additionally, employed AWS Glue crawlers for automated metadata extraction.
  • Streamlined ETL tasks using PySpark, enhancing data processing efficiency by 20% and integrated with Redshift data warehouse for optimized business insights.
  • Performed data analysis using Power BI techniques to create BI dashboards and reports, identifying key trends, patterns and communicating insights from marketing campaigns.
  • Conducted predictive modeling using SPSS, and SAS to forecast sales trends, achieving a 25% accuracy rate and informing strategic business decisions.
  • Mitigated fraud transactions by 17% in offline retail environments through the implementation of real-time, data-driven rules using SQL, Association rule mining, K-means clustering and predictive modeling.
  • Drove a 20% increase in CRM growth using Salesforce by deploying advanced models incorporating RFM, Demand Forecasting, and Market Basket Analysis for customer retention, and cross-sell product analysis through real time campaigns.

Education

Master of Science - Information Sciences/Studies

Trine University
05.2025

Bachelor of Technology - Information Technology

Bhoj Reddy Engineering College for Women
06.2022

Skills

  • SQL and Python
  • Excel and Tableau
  • Power BI and Snowflake
  • ETL processes
  • Git version control
  • Google Data Studio
  • Basic statistics
  • HTML and CSS
  • AWS services (Athena, S3, QuickSight)
  • AI for data collection and cleansing
  • Data visualization techniques
  • Data preparation and wrangling
  • Exploratory data analysis (EDA)
  • Time series forecasting
  • Problem solving skills
  • Data storytelling strategies
  • Stakeholder communication skills
  • Attention to detail

Projects

COVID 19 Data Tracker, Designed and developed an interactive COVID-19 data dashboard using Power BI, Tableau, Python to track cases, deaths, and vaccination rates across multiple countries., Used SQL and Python to clean and transform datasets, including handling missing values and normalizing inconsistent formats., Performed time-series analysis to identify trends in infection rates and predict future case growth., YouTube channel Analysis, Analyzed video performance and audience engagement for a YouTube channel using data collected via the YouTube Data API and Python Pandas, NumPy., Developed KPIs to monitor channel health, such as engagement rate, retention rate, and click-through rate (CTR)., Electronic Medical Records (EMR) For Emergency Care, Designed a dashboard in Power BI / Tableau to monitor ER metrics such as average wait times, patient flow, triage severity distribution, and frequent diagnoses., Cleaned and standardized complex healthcare datasets using Pandas to handle missing values, duplicate records, and timestamp inconsistencies across patient records., Simulated real-world EMR data using Synthea for ethical testing and demonstration of da pipeline and dashboarding capabilities

Timeline

DATA ANALYST

DXC TECHNOLOGY
09.2022 - 06.2023

Data Analyst

Stellantis Hyderabad, India
06.2020 - 06.2022

Master of Science - Information Sciences/Studies

Trine University

Bachelor of Technology - Information Technology

Bhoj Reddy Engineering College for Women
DOLLY KRISHNA PRIYA BHEEMANA