Summary
Overview
Work History
Education
Skills
Certification
Projects
Timeline
Hi, I’m

Charan Sai Dara

Data Analyst
Hyderabad
Charan Sai Dara

Summary

Data Analyst with 2+ years of experience in leveraging SQL, Python, and R to uncover actionable insights and drive strategic decision-making. Proficient in building data pipelines, creating visualizations, and conducting statistical analysis. Strong experience in developing executive dashboards and producing detailed analytics reports. Adept at collaborating with business leaders to understand marketplace dynamics and user behaviors.

Overview

3
years of professional experience
1
Certification
5
years of post-secondary education

Work History

University Of Arkansas

Graduate Assistant
05.2023 - 05.2024

Job overview

  • Automated data retrieval and insertion across websites using RPA, saving 80% in efficiency and work hours
  • Applied statistical techniques such as mean, mode, median, variance, standard deviation, correlation, and grouping to analyze datasets and extract meaningful insights
  • Developed and debugged JavaScript features for website functionality
  • Created Power BI visualizations and dashboards to provide actionable insights
  • Upgraded Bootstrap framework from 3 to 4, enhancing user experience and efficiency.

Virtusa Consulting Services

Associate Engineer
05.2022 - 05.2023

Job overview

  • Developed Power BI visualizations using DAX queries for executive-facing dashboards
  • Predicted customer churn with 85% accuracy using decision trees, reducing churn by 15%
  • Built data pipelines with PySpark, GCP, and Airflow, archiving MySQL data to a distributed file system
  • Improved data retrieval efficiency by 20% with advanced SQL techniques
  • Conducted data profiling to identify trends and anomalies, providing valuable insights for business leaders.

Virtusa Consulting Services

Data Engineer Intern
01.2022 - 04.2022

Job overview

  • Improved data quality and usability by 70% using advanced Excel functions
  • Developed and adapted SQL queries for various projects
  • Built and maintained data dashboards to track business metrics.

EduGene Technologies

Data Engineer Intern
11.2020 - 02.2021

Job overview

  • Created Power BI visualizations for student data, increasing productivity by 50%
  • Performed data migrations and database upgrades
  • Designed ER diagrams and optimized student data tables.

Education

University of Arkansas
Fayetteville

Master of Science from Information Systems
05.2023 - 05.2024

Anurag Group of Institutions
Hyderabad

B.Tech from Electronics And Communications
03.2018 - 04.2022

Skills

  • Data Analysis: SQL, Python, R, PowerBI, Tableau
  • Data Mining: KNIME, SAS EM, SAS EG
  • Programming Languages: Java, JavaScript, HTML5, CSS3
  • Statistical Tools: Hypothesis testing, regression analysis, decision trees
  • Project Management: Agile, Scrum

Certification

  • Career Essentials in Data Analysis by Microsoft
  • SQL for Data Analysis by LinkedIn
  • Oracle Certified Java Associate (OCJA)
  • ISTQB Foundation Level Certification

Projects

MurphyUSA Sales Data Analysis :

• Data Analysis and Visualization: Utilized PowerBI and SQL Server to extract, transform,  and visualize sales and transactional data,       providing stakeholders with actionable  insights. 

• DashboardDevelopment: Created executive dashboards using PowerBI, allowing  business leaders to track progress towards business goals. 

•Stakeholder Communication: Effectively Communicated data insights to non -technical stakeholders, aiding in strategic decision-making.


Data Warehouse Development for Murphy USA :

• Data Integration: Integrated data from multiple sources using SSIS, ensuring  consistency and accuracy. 

• OLAP Cube Development: Created an OLAP cube to facilitate faster data analysis,  improving decision-making capabilities. 

• Visualization Development: Utilized PowerBI and Tableau to create visualizations that  provided actionable insights to stakeholders.


Students Data Analysis : 

• Analyzed University of Arkansas student enrollment data to  assist the Director of Student Services in data-driven decision-making. Using Python and  SQL 

• Collected and cleaned datasets, then developed interactive PowerBI dashboards. 

• Applied DAX queries to enhance data analysis and provided in-depth insights. Finally, I  presented comprehensive analysis reports, highlighting key findings and  recommendations.



Timeline

University of Arkansas

Master of Science from Information Systems
05.2023 - 05.2024

Graduate Assistant

University Of Arkansas
05.2023 - 05.2024

Associate Engineer

Virtusa Consulting Services
05.2022 - 05.2023

Data Engineer Intern

Virtusa Consulting Services
01.2022 - 04.2022

Data Engineer Intern

EduGene Technologies
11.2020 - 02.2021

Anurag Group of Institutions

B.Tech from Electronics And Communications
03.2018 - 04.2022
Charan Sai DaraData Analyst