Shivani Sharma

Shivani Sharma

Industrial Internship

Followers of Shivani Sharma2000 followers
location of Shivani SharmaNepean, Ontario, Canada

Connect with Shivani Sharma to Send Message

Connect

Connect with Shivani Sharma to Send Message

Connect
  • Timeline

  • About me

    Data Engineer Intern at Transport Canada| Masters in Applied Business Analytics at Carleton University | Ex - Senior Data Engineer at Brillio

  • Education

    • K J Somaiya College College of Science and Commerce

      2015 - 2017
      Higher Secondary Course Science 72
    • St Anthony High School

      2005 - 2015
      90.80
    • Carleton University

      2023 - 2025
      Master's degree Applied Business Analytics
    • Mumbai University Mumbai

      2017 - 2021
      Bachelor of Engineering - BE Electronics and Telecommunication Engineering 8.21/10

      Technical Paper Presentation: Participated in college-level Paper Presentation “Tantragyaan 2021”. Publicity Head: Worked as the Publicity Head for the IETE ETSA committee at Lokmanya Tilak College Anchor: Represented the college as an ‘Ancho r’ for various cultural and annual events (Zephyr) in the year 2019-2020 Social: Muskurahat Foundation: Worked as a fundraising intern to raise funds for the underprivileged kids

  • Experience

    • Doordarshan Sahyadri

      Apr 2019 - May 2019
      Industrial Internship
    • Suven Consultants and Technology Pvt.Ltd.

      Jul 2020 - Aug 2020
      Web Development Coding Internship
    • Brillio

      Oct 2021 - Jul 2023

      ‣ Involved in planning, gathering, and analyzing requirements‣ Implemented and optimized a scalable ETL process for migrating Ascend streaming data to Snowflake production using Pyspark in Databricks across Bronze, Silver, and Gold notebooks resulting in a 40% increase in processing efficiency.‣ Streamlined the migration process by eliminating manual intervention through automating triggers and scheduling workflows to run at specific times, ensuring timely delivery of updated data.‣ Developed and documented complex PySpark logic, streamlining data processing by 30% for a drive wealth client.‣ Converted Ascend CAT report workflow into SQL code using DBT‣ Conducted thorough QA analysis on newly implemented SQL logic to ensure efficient performance‣ Setting up regular meeting cadence with stakeholders with specific agenda shared well in advance and sprint calls as per agile methodology Show less • Developed and executed a comprehensive data migration plan for an eBay client, resulting in the successful transfer of data from Oracle to SSMS within the allotted timeframe and budget.• Implemented ETL pipeline using Azure Data Factory, increasing the efficiency of the data migration process by 50% • Designed data models in lucid as per client requirements• Designed database schema (DDL), views, stored procedures, functions, packages, and triggers from Oracle to SSMS• Documented the logic of various procedures on the wiki so that the API team can capture the necessary use cases.• Worked and resolved various ad-hoc queries coming from API and UI team• Attended daily calls with on-site POC for requirement reviews and clarifications• Received recognition from eBay client for exceptional execution and timely delivery of project Show less

      • Senior Data Engineer

        Apr 2023 - Jul 2023
      • Data Engineer

        Jan 2022 - Mar 2023
      • Analytics Practitioner

        Oct 2021 - Dec 2021
    • Carleton University

      Oct 2023 - Mar 2024
      RFID Library Student Assistant
    • Transport Canada - Transports Canada

      Apr 2024 - now
      Data Engineer Intern
  • Licenses & Certifications

    • Python for Data Science

      Cognitive Class
    • Scrum Foundation Professional Certificate

      CertiProf
      May 2021
      View certificate certificate
    • Foundations: Data, Data, Everywhere

      Google
      May 2021
    • Blockchain

      Blocklogy
    • Java

      Udemy
      Apr 2020
    • HTML

      Coursera
    • SQL for Data Science

      Coursera
      Mar 2020
  • Volunteer Experience

    • Student Volunteer

      Issued by Somaiya Alumni Reunion on Jan 2017
      Somaiya Alumni ReunionAssociated with Shivani Sharma
    • Publicity Head

      Issued by ETSA(Electronics and Telecommunication Students Association) on Sept 2019
      ETSA(Electronics and Telecommunication Students Association)Associated with Shivani Sharma
    • Fundraising Intern

      Issued by Muskurahat Foundation on Apr 2021
      Muskurahat FoundationAssociated with Shivani Sharma