Guna Jaswanth Reddy Maduri
Summary
Positive, analytical problem-solver with strong foundation in data systems and processes. Possesses solid understanding of data modeling and database design, coupled with skills in SQL and Python. Capable of driving data-driven decision-making and improving data infrastructure.
Overview
2
2
years of professional experience
Work History
Data Engineer
HashTek Inc
06.2024 - Current
- Architected end-to-end RCM data lake on GCP using Medallion Architecture to process 50TB+ from 2 hospital systems, cutting data access time by 200%.
- Engineered ETL pipelines with PySpark/Dataproc ingesting MySQL Cloud SQL and APIs (CPT, NPI, ICD)—processing 1M+ daily records at 99.9% accuracy.
- Implemented SCD Type 2 and Common Data Model for historical tracking, improving data quality by 35% and ensuring HIPAA compliance.
- Developed claims processing workflows for monthly insurance files, reducing latency from 5 days to 6 hours (87.5% faster).
- Built BigQuery warehouse with 25+ star-schema tables, improving query performance by 45% for revenue analytics.
- Orchestrated pipelines via Cloud Composer, achieving 99.8% uptime with automated scheduling and monitoring.
- Established CI/CD with GitHub/Cloud Build, reducing deployment time by 70% and accelerating development by 60%.
Data Analyst
Transcend Technologies
01.2024 - 05.2024
- Analyzed and cleaned datasets of over 100K+ records, improving data accuracy and reliability by 15%.
- Designed and automated Power BI dashboards, reducing manual reporting time by 30% and enhancing visibility into KPIs.
- Developed and optimized SQL queries for data extraction and validation across multiple databases, improving query efficiency by 25%.
- Collaborated with cross-functional teams to translate business requirements into analytical solutions and actionable insights.
- Conducted trend and variance analysis to support strategic planning and performance monitoring initiatives.
- Presented weekly reports to supervisors, driving data-driven decision-making and process optimization.
Education
Master of Science - Data Science
University of New Haven
West Haven, CT05-2024
Bachelor of Science - Electronics And Communications Engineering
Bharath Institute of Higher Education And Research
Chennai, India05-2022
Skills
- Programming: SQL, Python (Pandas, NumPy), PySpark, SQL(BigQuery, SnowSQL), Unix Shell Scripting, JavaScript
- Cloud Platforms: AWS (S3, Glue, Lambda, Redshift), Azure (Data Factory, Synapse, Data Lake), Google Cloud Platform (GCS, Big Query, Dataproc, Composer, Dataflow, Cloud SQL, Cloud Build, IAM)
- Data Platforms: Snowflake (Snowpipe, Cluster Keys), Databricks
- ETL/Orchestration: Informatica PowerCenter, Talend, DBT, Apache Airflow
- Databases: SQL Server, Oracle, MySQL, PostgreSQL
- Data Modeling: Star/Snowflake Schemas, Dimensional Modeling, Data Lakes
- DevOps: Git, GitHub, Jenkins, Azure DevOps (CI/CD)
- Analytics: Power BI, Tableau
Languages
English
Full Professional
Hindi
Professional Working
Telugu
Native or Bilingual
Timeline
Data Engineer
HashTek Inc
06.2024 - Current
Data Analyst
Transcend Technologies
01.2024 - 05.2024
Master of Science - Data Science
University of New Haven
Bachelor of Science - Electronics And Communications Engineering
Bharath Institute of Higher Education And Research