Welcome to Harichandana's work-in-progress profile. More details coming soon!

University of Utah

*   Compiled and cleaned data from disparate sources using moderate to complex **SQL** queries which involved Stored Procedures, Window functions and CTEs.
*   Designed and developed **SSIS** packages to automate loading of data from various sources like CSV files, REST APIs and Oracle databases into **MS SQL server** data warehouse.
*   Cleaned and validated health data and built a model using Mode imputation to impute the Health Small Areas using **R** language and reduced missing data by 79%.
*   Developed and automated a **Python** script to generate cumulative patient visit data information on a monthly basis, saving 10 hours per month and achieved a 98% accuracy rate in generating cumulative patient visit data.

Data Engineer Intern

*   Developed a pipeline to capture real time data from Salesforce and loaded the data into S3 using **Kafka,** processing 100,000 records/minute and seamlessly integrated with **Airflow** for orchestration, data integration and automation.
*   Architected and developed a robust, scalable data pipeline leveraging **Kafka** and **PySpark** to efficiently ingest semi- structured streaming data from over 20+ data sources, handling a staggering volume of 150 million records.
*   Successfully developed and deployed a **Snowflake** data warehouse solution, optimizing data processing speeds by 30% and reducing query response times by 20%, resulting in significant cost savings for the organization.
*   Developed ETL pipelines using **AWS Glue** and **Redshift** Spectrum to extract data from S3 buckets, transform via Spark, and load into Redshift for analytics.
*   Experienced in Linux based system operation, shell scripting, using **Spark SQL** queries on different formats like Text, CSV, Parquet, Avro, JSON and developing **Sqoop** jobs to import the data from MySQL to HDFS.

Consultant

*   Developed visualization dashboards with **PowerBI** by connecting to Azure and **Bigquery** cloud data sources.
*   Analyzed and optimized critical SQL queries by examining explain plans and implementing performance tuning techniques like creating indexes, stored procedures to enhance query performance.
*   Built a database for a healthcare client gathering business requirements, transforming conceptual models to relational models, employing DBeaver, PostgreSQL, DDL, DML SQL queries along with advanced SQL queries.

Harichandana Gonuguntla

#1 Video-Talent Marketplace

Ready to discover your perfect career?