Sheetal Pujari

Boston, MA 857-***-**** ad3ink@r.postjobfree.com ad3ink@r.postjobfree.com linkedin.com/in/sheetalpujarii/ EDUCATION

Northeastern University Boston, MA

Master of Science in Computer Software Engineering Expected Dec 2024 Coursework - Data Engineering and Tools, Designing Advanced Data Architectures, Network Structures & Cloud Computing Nitte Meenakshi Institute of Technology Bangalore, India Bachelor of Engineering in Computer Science & Engineering Aug 2017 - Aug 2021 Coursework - Database Management Systems, Algorithms, Programming in Python and Data Science WORK EXPERIENCE

Lead Graduate Teaching Assistant, Northeastern University Boston, MA Course: Statistics for Data Analytics and Visualization Aug 2023 – Present

• Assisted a cohort of over 50 students in mastering the intricacies of data warehousing and dimensional modelling concepts

• Provided mentorship by conducting lab sessions NumPy and Pandas through weekly office hours Legato Health Technologies (Anthem) Bangalore, IN

Software Engineer (Data and Cloud Team) Aug 2021 - Nov 2022

• Engineered Anthem’s Medicare Insurance Enrollment and Billing projects involving SQL stored procedures, batch data ETL pipelines, high volume healthcare relational databases

• Implemented CI/CD pipeline using GitHub Actions for automated AWS resource provisioning using Terraform resulting in a 50% reduction in deployment time

• Refactored and optimized existing SQL stored procedures by simplifying complex joins, replacing them with modular operations improving readability, and reliability of the code, also bringing down query time by 10%

• Spearheaded the enhancement of a healthcare cost-sharing application's security, successfully mitigating Log4j vulnerabilities and substantially strengthening its overall robustness against cyber threats

• Revamped data processing by implementing ETL pipelines with Microsoft SSIS achieving a 40% boost in efficiency for generating daily and monthly reports simultaneously enhancing the system with real-time notifications, resulting in accelerated information flow to insurance providers, ensuring timely updates on health patient data

• Integrated 3 new sections into the Medicaid Insurance Enrollment form, effectively streamlining the XML data transfer and SQL triggers to the billing team, this optimization led to a 45% reduction in overall processing time

• Mentored a 4-person team in migrating 8 client accounts to AWS, boosting efficiency by 25% and integrated AWS CloudWatch according to CPU utilization for enhanced log monitoring and data governance.

• Awarded as the 2022 Employee of the Month for key development roles in enhancing health insurance applications

• Developed a python program for performing complex transformations involving automation of Tidal jobs Exposys Data Labs Bangalore, IN

Data Engineer Intern Sep 2020 - Dec 2020

• Designed REST APIs in NodeJS and scrapers to automate data ingestion, reducing manual work by 25%

• Segregated the customer database containing 10,000 records into 7 clusters of users with similar traits

• Formulated a Load Balancer to optimize distribution of inbound/outbound traffic reducing network congestion by 20% ACADEMIC PROJECTS

Cloud-Native Course Management (NodeJS, AWS, Terraform, Packer, CI/CD, DNS) Sept 2023 - Dec 2023

• Engineered a submission system utilizing DynamoDB on Amazon Web Services (AWS), Lambda functions and Packer

• Developed the REST API endpoints using NodeJS with Python Sequelize as Object-relational mapping framework

• Implemented Infrastructure as Code with Terraform to provision EC2, VPC, RDS, S2, IAM, Load Balancer TECHNICAL SKILLS

Programming Languages Python, SQL, Java, C, C++, JavaScript, React.js, Node.js, HTML, CSS Databases and Frameworks MySQL, MSSQL, DynamoDB, MongoDB, Flask, Pulumi, Tableau Cloud/IaaC/DevOps AWS (EC2, RDS, S3, CloudWatch, Lambda), Airflow, Google Cloud, Snowflake Software and CI/CD Tools GitHub Actions, Packer, Toad, Microsoft SSIS, DevOps, DevSecOps, SaaS, Maven, IaaS, IaC

Contact this candidate