Sai Purushoth G

EHE Health - Preventive Healthcare Company

• Received the "Above and Beyond" award for leading the team, guiding them in the right direction, and providing the right solutions to the customer.
• Automated the process of updating patient eligibility information, reducing manual processing time by over approx 12 hours and minimizing errors. Utilized AWS Services (S3, Lambda (Python), Glue (PySpark), and RDS (MySQL) for event-based architecture, ensuring efficient operations.
• Transformed Java-based processes for transmitting patient, exam, and lab-related information into AWS Glue with PySpark, customizing logic for each client to enhance data quality and processing efficiency.
• Designed and implemented ETL pipelines to daily migrate data from relational databases of microservice applications to data warehouses and Salesforce, incorporating custom schema mapping. Developed and deployed ETL pipelines for loading data from S3 and relational database into the data warehouse.
• Created a PySpark-based solution in AWS Glue for generating daily email summaries from a reporting dashboard for EHE leadership.
• Upgraded AWS Glue from version 2.0 to 4.0, significantly reducing costs and improving data processing performance. Additionally, worked on the analysis of upgrading MySQL RDS from version 5.7 to 8.0.
• Collaborated on data modeling for Data Warehouse tables from MySQL RDS to Redshift, with a focus on designing facts and dimension tables for appointment and exam-related datasets.
• Developed stakeholder dashboards, including "Super" dashboards for all clients and custom solutions for specific clients. Played a key role in troubleshooting ETL pipeline errors and optimizing overall efficiency.

EHE Health - Preventive Healthcare Company

• Developed Quicksight Migration tool using Python framework for seamless resource migration between environments,reducing deployment time significantly compared to manual processes.
• Created Quicksight Backup tool to generate JSON templates for resource backup and restoration, aiding in deletion prevention and facilitating versioning.
• Designed and implemented stakeholder dashboards in AWS Quicksight by translating complex business logic into SQL queries, providing actionable insights for a large number of stakeholders.
• Analyzed and resolved bugs in ETL pipelines of the data warehouse, ensuring data integrity and reliability using PySpark.
• Investigated and rectified discrepancies in dashboards with complex SQL queries, enhancing data accuracy and usability

Event Buzz - Event Management System

• Developed Restful APIs with Serverless Framework (Typescript) and implemented backend solutions using AWS services (Lambda, API Gateway, AWS Aurora).
• Designed schema for optimized backend.
• Integrated AWS services including Cognito for authentication, AWS Amplify for backend/frontend coordination, and AWS AppSync for real-time notifications.
• Contributed to the development and debugging of React UI components.

• Engineered a web application for movie ticket booking utilizing Node.js for the backend and Angular for the frontend, ensuring seamless user experience and efficient ticket management.
• Designed and implemented microservices architecture for library management system using .NET Core, facilitating modular and scalable application development while enhancing system performance and maintainability.
• Completed comprehensive training in Spark, HDFS, and Kafka, gaining proficiency in big data processing and real-time data streaming technologies to contribute effectively to data-driven projects and initiatives.