Sumit Singh

Sumit singh

bookmark on deepenrich
location of Sumit SinghSan Francisco Bay Area
Followers of Sumit Singh914 followers
  • Timeline

  • About me

    Data Engineer at Meta

  • Education

    • North carolina state university

      2022 - 2024
      Master's degree computer science 3.833

      Coursework:• CSC 505 Design and Analysis of Algorithms• CSC 510 Software Engineering• CSC 522 Automated Learning and Data Analysis• CSC 540 Database Management Concepts and Systems• CSC 591 Neural Networks and Deep Learning• CSC 591 Meta-heuristics for Search and Optimization• CSC 547 Cloud Computing Technology• CSC 519 DevOps: Modern Software Engineering Practices• CSC 533 Privacy in the Digital Life• CSC 591 Accelerated Deep Learning

    • Vellore institute of technology

      2016 - 2020
      Bachelor of technology - btech electronics and communications engineering 9.17

      Relevant Coursework:• Data Structures and Algorithms• Problem-Solving and Object-Oriented Programming• Computer Networks• Information Theory and Coding• Probability Theory and Random Process

  • Experience

    • Oil and natural gas corporation ltd

      May 2018 - Jun 2018
      Summer intern
    • Zs

      Jan 2020 - Jul 2022

      Custom Data Management Platform -► Led a team of 3 Associates to develop a cloud based AWS solution, enabling clients to customize and manage their data on a unified platform. Conducted 50 code reviews, overseeing the backend and integration development.► Implemented efficient automated data refresh processes using Glue PySpark ETL jobs, reducing daily processing time by 30%. Utilized DataBrew for comprehensive data quality checks and built scripts for data pipelines with a CI/CD approach, orchestrated with Amazon MWAA.► Developed REST APIs on the AWS serverless stack, leveraging Amazon API Gateway, Lambda, S3, and DynamoDB for secure integrations with authentication. Implemented S3 upload/download features with presigned URLs, and achieved 90% automation in infrastructure provisioning using YAML scripts and CloudFormation for IAM roles. Show less AWS Migration and Orchestration -► Migrated on-premise to a cloud based AWS solution, revamping data models for enhanced scalability to handle large and complex datasets. Optimized Aurora PL SQL code, significantly reducing daily system refresh time by 45%.►Transitioned workflow management from Airflow to AWS Managed Workflows for Apache Airflow (MWAA), upgrading from version 2 to 3. Developed and managed multiple scripts to streamline data processing from various sources.►Led the production go-live, ensuring seamless system deployment by working closely with operations and client stakeholders. Coordinated efforts to ensure smooth integration and functionality of the migrated systems.Sales force Alignment Management Solution -► Designed a cloud-based sales force alignment management solution implementing ETL processes using Spark SQL, orchestrated with Azkaban. Built 10+ data pipelines for daily synchronization and integration across multiple sources (S3, SFTP, SFDC Bulk APIs).► Developed customized data analytics and Business Intelligence solutions to recommend target HCPs and HCOs for sales reps. Supported backend systems for data refresh and transformation, ensuring alignment with the data model of the Alignment Management platform.► Coordinated with key executive stakeholders to align business requirements and system functionalities. Implemented a roster system for seamless integration with SFDC.Target Management Solution - ► Led a team of two associates to build bulk upload features and improve the UI on sales force Target Manager solution. Migrated and optimized the integration system from Boomi to Amazon MWAA.Custom Call Planning Solution - ► Designed a custom Call Planning tool using JAC and Aurora PL/SQL for life sciences sales planning. Show less

      • Business Technology Associate Consultant

        Jun 2022 - Jul 2022
      • Business Technology Analyst

        Jul 2020 - Jun 2022
      • Business Technology Analyst Intern

        Jan 2020 - Jun 2020
    • North carolina state university

      Aug 2023 - May 2024

      ► Worked as lead TA for the CSC 110 Computer Science and Principles course with Dr. Stallmann► Held lab sessions, conducted office hours and graded assignments and projects► Took 2 theory lectures on Algorithms in lieu of Dr. Stallmann ► Worked as TA for the CSC 110 Computer Science and Principles course with Dr. Price. ► Held lab sessions, graded assignments and projects and conducted office hours.

      • Lead Teaching Assistant

        Jan 2024 - May 2024
      • Teaching Assistant

        Aug 2023 - Dec 2023
    • North carolina state university

      Sept 2024 - Jan 2025
      Researcher
    • Meta

      Feb 2025 - now
      Data engineer

      - Reality Labs

  • Licenses & Certifications