Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

HARSHAVARDHAN CHAPPIDI

Milwaukee,WI

Summary

Work collaboratively with team members from different disciplines to coordinate, manage, identify potential changes for the products and meeting client objectives. A results-driven MBA graduate student bringing 3+ years of success in Information Technology Industry. Astute, organized, and methodical with articulate communication style and personable nature. Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Data Analyst

InterGlobe Aviation Limited.
09.2018 - 05.2022
  • Developed efficient ETL functions for airline Flight Domain datasets, perform complex feature analysis, data modeling and visualization in SQL and Tableau to identify potential areas for improvement to drive organization profitability.
  • Experienced in working with multiple data sources like Snowflake, SQL, Oracle, PostgreSQL based on business needs.
  • Utilized Spotfire, Tableau, Power BI, in developing visually appealing reports to highlight insights gained from data analysis to be communicated to business users.
  • Strong in Creating SQL Queries, Python, Java for customizations of reporting.
  • Redesigned executive dashboards and automated many operational reports that reduced manual workload by 50%
  • Performed data analysis and maintenance on information stored in Snowflake database
  • Worked on creating filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
  • Developed and Tested reports migrated from Spotfire to Tableau as part of modernization efforts.
  • User story definition and agile board management in JIRA during project execution, as well as participation in sprint demo and retrospective.
  • Agile approach was used to carry out the development process, which included iterative application development, sprints, meetings, and reporting.

Data Engineer Trainee

Convextree, Bangalore
05.2018 - 09.2018
  • Developed python code snippets for extracting Business performance data that includes diagnostic metrics, leading indicator metrics and KPI metrics at campaign and Ad level
  • Worked on source data analysis and data modelling steps to determine overall dimensions and fact tables for furnishing best possible visualizations
  • Built ETL mappings to load ODS, stage and data mart tables which included Incremental logic and SCD concepts.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability

Education

Master's // MBA - Management Sciences and Quantitative Methods

University of Wisconsin - Milwaukee
Milwaukee, WI
12.2023

Bachelor of Science - Computer Science and Engineering

Vellore Institute of Technology
Vellore, Tamilnadu, India.
09.2018

Skills

  • Languages:
  • C, Java, Python, SQL, R
  • Reporting / Visualization Tools: Tableau, Power BI, Spotfire, QlikView, MS Excel, AWS Quick sight ETL / Development
  • Tools: Informatica, Qlik, Visual Code, Jupiter Notebook, Eclipse
  • Databases: Snowflake, MS SQL Server, Redshift, Oracle, PostgreSQL
  • Cloud: AWS, Azure cosmos DB

Certification

IBM - Cloud Computing and Virtualization Specialist. Google Product management professional certificate.

Timeline

Data Analyst

InterGlobe Aviation Limited.
09.2018 - 05.2022

Data Engineer Trainee

Convextree, Bangalore
05.2018 - 09.2018

Master's // MBA - Management Sciences and Quantitative Methods

University of Wisconsin - Milwaukee

Bachelor of Science - Computer Science and Engineering

Vellore Institute of Technology
HARSHAVARDHAN CHAPPIDI