Summary
Overview
Work History
Education
Skills
Websites
Certification
Related Experience
Personal Information
Timeline

Deepika Thelapola

Data Analyst
Denver,CO

Summary

Recent Computer Science Master's graduate with entry-level experience as a Data Analyst in the travel technology industry. Proficient in extracting and analyzing booking data using SQL, Python, and Tableau to deliver actionable insights for business teams. Demonstrated ability to maintain data quality, generate automated reports, and create clear visualizations for tracking travel trends and performance metrics. Combines strong academic foundation with hands-on experience in transforming complex data into meaningful business recommendations through detailed reporting and basic dashboard creation.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Data Analyst

TRAVELPORT
07.2024 - Current
  • Assisted in analyzing travel booking data using SQL queries and Excel, helping identify top-performing travel routes and contributing to monthly performance reports
  • Created and maintained Tableau dashboards to track basic booking metrics and travel agent performance, improving visibility of key performance indicators for stakeholders
  • Supported data cleaning and preparation efforts using Python (pandas), ensuring accuracy of booking data across different travel platforms
  • Collaborated with senior analysts to generate weekly reports on flight bookings and hotel reservations, reducing report generation time by 25%
  • Engineered comprehensive Python-based data validation scripts that automated anomaly detection and data cleansing processes, systematically improving dataset integrity and reducing manual error rates by 25%.
  • Helped maintain data quality by conducting regular audits of booking information, identifying and correcting data inconsistencies in Excel spreadsheets
  • Participated in cross-functional team meetings to gather reporting requirements from business stakeholders, translating their needs into clear data specifications and Excel templates
  • Developed and documented standardized data validation procedures using Excel macros and basic Python scripts, improving the team's efficiency in identifying data anomalies by 20%

Engineer Trainee

COGNIZANT TECHNOLOGY SOLUTIONS
09.2021 - 07.2022
  • Addressed and resolved technical issues to minimize downtime by 30%.
  • Maintained and monitored firewalls and databases to enhance security and data integrity.
  • Developed and tested software solutions through Java, Mainframe, .NET and Python to ease the task on various client projects.
  • Worked on data warehousing process utilizing data preprocessing and data cleaning methods to optimize data storage and retrieval by 40%.
  • Collaborated with cross-functional teams to understand software solutions integration, enhancing project efficiency and obtaining cross-knowledge.
  • Assisted with comprehensive system testing and debugging to attain a 20% reduction in post deployment issues, leading to improved software reliability.
  • Designed and implemented cloud-based data warehousing solutions using AWS S3 and Redshift

Software Intern

EXPERT SOLUTIONS
01.2021 - 08.2021
  • Assisted the data team in collecting and cleaning datasets using Excel and basic SQL queries, contributing to the company's customer behavior analysis project
  • Learned and applied fundamental Python programming skills to automate repetitive data entry tasks, saving approximately 10 hours of manual work per week
  • Shadowed senior data analysts in creating basic visualizations using Tableau, helping to present weekly metrics to the product team
  • Participated in database management activities, including data entry, basic table creation, and running predefined SQL queries to extract information
  • Supported the testing of new data collection methods, documenting results and identifying potential issues for the development team

Education

Master’s - Computer Science

University of Wisconsin- Milwaukee
05.2024
Relevant courses: Data Structures, Cybersecurity, Machine Learning, Algorithm Design Analysis

Bachelor’s - Electronics and Communication Engineering

Malla Reddy Engineering College
08.2021
Relevant courses: Objected Oriented Programming using Java, Linux Programming, Computer Programming

Skills

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server
  • NoSQL
  • MongoDB
  • Microsoft Access
  • Microsoft Excel
  • Pandas
  • NumPy
  • Jupyter Notebooks
  • Git
  • Microsoft Azure
  • AWS
  • S3
  • REDSHIFT
  • Google Cloud Platform
  • Python
  • C
  • SQL
  • Java
  • Shell Scripting
  • R
  • Excel
  • VBA
  • Power BI
  • Tableau
  • Matplotlib
  • Seaborn
  • Google Data Studio
  • JIRA
  • SharePoint
  • Microsoft Teams
  • Agile
  • Scrum
  • Microsoft Office Suite
  • Google Workspace

Certification

Microsoft Power BI Data Analyst, PL-300

Related Experience

  • Data Analyst, Travelport, USA, 2024-07-01, Present, Assisted in analyzing travel booking data using SQL queries and Excel, helping identify top-performing travel routes and contributing to monthly performance reports., Created and maintained Tableau dashboards to track basic booking metrics and travel agent performance, improving visibility of key performance indicators for stakeholders., Supported data cleaning and preparation efforts using Python (pandas), ensuring accuracy of booking data across different travel platforms., Collaborated with senior analysts to generate weekly reports on flight bookings and hotel reservations, reducing report generation time by 25%., Engineered comprehensive Python-based data validation scripts that automated anomaly detection and data cleansing processes, systematically improving dataset integrity and reducing manual error rates by 25%., Helped maintain data quality by conducting regular audits of booking information, identifying and correcting data inconsistencies in Excel spreadsheets., Participated in cross-functional team meetings to gather reporting requirements from business stakeholders, translating their needs into clear data specifications and Excel templates., Developed and documented standardized data validation procedures using Excel macros and basic Python scripts, improving the team's efficiency in identifying data anomalies by 20%.
  • Engineer Trainee, Cognizant Technology Solutions, India, 2021-09-01, 2022-07-01, Addressed and resolved technical issues to minimize downtime by 30%., Maintained and monitored firewalls and databases to enhance security and data integrity., Developed and tested software solutions through Java, Mainframe, .NET and Python to ease the task on various client projects., Worked on data warehousing process utilizing data preprocessing and data cleaning methods to optimize data storage and retrieval by 40%., Collaborated with cross-functional teams to understand software solutions integration, enhancing project efficiency and obtaining cross-knowledge., Assisted with comprehensive system testing and debugging to attain a 20% reduction in post deployment issues, leading to improved software reliability., Designed and implemented cloud-based data warehousing solutions using AWS S3 and Redshift.
  • Software Intern, Expert Solutions, India, 2021-01-01, 2021-08-01, Assisted the data team in collecting and cleaning datasets using Excel and basic SQL queries, contributing to the company's customer behavior analysis project., Learned and applied fundamental Python programming skills to automate repetitive data entry tasks, saving approximately 10 hours of manual work per week., Shadowed senior data analysts in creating basic visualizations using Tableau, helping to present weekly metrics to the product team., Participated in database management activities, including data entry, basic table creation, and running predefined SQL queries to extract information., Supported the testing of new data collection methods, documenting results and identifying potential issues for the development team.

Personal Information

Title: Data Analyst

Timeline

Data Analyst - TRAVELPORT
07.2024 - Current
Engineer Trainee - COGNIZANT TECHNOLOGY SOLUTIONS
09.2021 - 07.2022
Software Intern - EXPERT SOLUTIONS
01.2021 - 08.2021
University of Wisconsin- Milwaukee - Master’s, Computer Science
Malla Reddy Engineering College - Bachelor’s, Electronics and Communication Engineering

Similar Profiles

CREATE PROFILE
Deepika ThelapolaData Analyst