A bit about My life and Work!

  • Highly driven Data Engineer professional and goal oriented with a Bachelorโ€™s Degree in Computer Science & Engineering with 9+ years of work experience in Data Engineering, Including Domain knowledge in the K-12 education, Finance, and Retail Industry.
  • I have worked extensively with multiple Fortune 500 clients providing actionable insights and business solutions to clients and organizations.
  • Currently working as Senior Data Engineer @ SSNC Advent and pursuing Masters of Science in Information Systems at Northeastern University, Boston, my GPA (๐Ÿ‘.๐Ÿ—๐Ÿ“/๐Ÿ’.๐ŸŽ) Dec 2021 Graduate
  • I have been able to develop a diverse palette of skillset which I believe enables me to serve the ever-increasing data needs of an organization. Having said this, I certainly believe that there is yet more to experience, yet more to learn, and yet more to build.
  • I am an ๐™š๐™ฃ๐™ฉ๐™๐™ช๐™จ๐™ž๐™–๐™จ๐™ฉ๐™ž๐™˜ Software Data Engineer Professional possessing a humungous potential to learn advanced technologies and adapt to a new environment.
  • Former Graduate Teaching assistant at Northeastern University (NEU). Assisted the Director of the Information Systems program with the Application Engineering and Development Course, My responsibilities include conducting weekly labs and quizes, reviewing code, grading assignments and holding office hours
  • Passionate about solving complex data problems and providing simpler visualization for it, in result giving impactful insights and outcomes which are data driven, how they impact our lives.

Database
Design

Data
Analytics

I am looking for a Full Time Roles in Software Engineer, ETL Developer, Data Engineer

Download Resume

Skills

Languages/Cloud: Python, R, Azure, AWS

Data Visualization: Power BI ,Tableau, Looker, Google Data Studio, MS Excel

Data Integration: Talend , Alteryx

Databases: SQL Server, Hive, Snowflake, MongoDB, Postgres

Data Modelling: E-R Modelling, Data Modelling(Star Schema)

Tools: Jupyter Notebook, SSMS,VScode, GitHub, Kanban, JIRA, Confluence, Wiki Pages

Cloud: Azure, AWS

Certification

      Az-900 by Microsoft for Azure Fundamentals

Education

Currently pursuing master's degree in Information Systems at Northeastern University

  • Advisor - Gloria Choi
  • Expected graduation: December 2021.
  • Current GPA 3.95.

  • Course Work and grades -
    • Application Engineering Development(Java) [A]
    • Database Modelling and Database Design [A]
    • Program Structure Algorithms [A-]
    • Web Design/ User Experience Engineering [A]
    • Software Testing and Quality Control Management [A]
    • Designing Advanced Data Architectures for Business Intelligence

    • Completed undergraduate degree in Computer Science from Jayoti Vidyapeeth Women's University, Jaipur, India

  • Graduation: May 2014.
  • Graduated with 73 percent.


  • Course Work and grades -
    • Data Structure
    • Algorithm Design and Analysis
    • Database Management Systems
    • Advance Database Management Systems
    • Data Mining
    • Probability & Statistics
    • Java Programming

    • Work Experience

    Autodesk
    May 2021 - Aug 2021

    Business Intelligence Developer Intern

      ๐™Ž๐™ฉ๐™ช๐™™๐™š๐™ฃ๐™ฉ ๐™‘๐™š๐™ง๐™ž๐™›๐™ž๐™˜๐™–๐™ฉ๐™ž๐™ค๐™ฃ ๐™–๐™ฃ๐™™ ๐™Ž๐™ช๐™—๐™จ๐™˜๐™ง๐™ž๐™ฅ๐™ฉ๐™ž๐™ค๐™ฃ ๐˜ฟ๐™–๐™จ๐™๐™—๐™ค๐™–๐™ง๐™™ (๐˜พ๐™ช๐™จ๐™ฉ๐™ค๐™ข๐™š๐™ง ๐˜ผ๐™ฃ๐™–๐™ก๐™ฎ๐™ฉ๐™ž๐™˜๐™จ)
    • Automated data analysis process using Alteryx ETL jobs saving 1 week man-hour work
    • Provided insights to highlight data
      • Student Verification Dashboard
    • TBD

    Northeastern University
    Jun 2020 - Dec 2020

    Graduate Teaching Assistant

      ๐‚๐จ๐ฎ๐ซ๐ฌ๐ž: ๐ˆ๐๐…๐Ž ๐Ÿ“๐Ÿ๐ŸŽ๐ŸŽ ๐€๐ฉ๐ฉ๐ฅ๐ข๐œ๐š๐ญ๐ข๐จ๐ง ๐„๐ง๐ ๐ข๐ง๐ž๐ž๐ซ๐ข๐ง๐  ๐š๐ง๐ ๐ƒ๐ž๐ฏ๐ž๐ฅ๐จ๐ฉ๐ฆ๐ž๐ง๐ญ (๐‰๐€๐•๐€) I am currently working with Information ๐’๐ฒ๐ฌ๐ญ๐ž๐ฆ๐ฌ ๐’๐ž๐ง๐ข๐จ๐ซ ๐๐ซ๐จ๐ ๐ซ๐š๐ฆ ๐ƒ๐ข๐ซ๐ž๐œ๐ญ๐จ๐ซ, ๐ƒ๐ซ. ๐Š๐ก๐š๐ฅ๐ž๐ ๐๐ฎ๐ ๐ซ๐š๐ซ๐š, for the subject Application Engineering and Development
    • Taught ๐ˆ๐๐…๐Ž ๐Ÿ“๐Ÿ๐ŸŽ๐ŸŽ ๐€๐ฉ๐ฉ๐ฅ๐ข๐œ๐š๐ญ๐ข๐จ๐ง ๐„๐ง๐ ๐ข๐ง๐ž๐ž๐ซ๐ข๐ง๐  ๐š๐ง๐ ๐ƒ๐ž๐ฏ๐ž๐ฅ๐จ๐ฉ๐ฆ๐ž๐ง๐ญ students, course of ๐Ÿ๐ŸŽ๐ŸŽ+ ๐ฌ๐ญ๐ฎ๐๐ž๐ง๐ญ๐ฌ, on how to apply Java into real-life applications, such as building an ecosystem application from scratch with work area and responsibility
    • Conducted lab sessions and weekly quizzes for a batch of over ๐Ÿ๐ŸŽ๐ŸŽ ๐ฌ๐ญ๐ฎ๐๐ž๐ง๐ญ๐ฌ
    • Carried out code reviews and graded assignments with a strong focus on Object-Oriented Design Principles
      • ๐‚๐จ๐ฎ๐ซ๐ฌ๐ž: (๐‚๐’๐˜๐„: ๐Ÿ”๐Ÿ๐ŸŽ๐ŸŽ) ๐‚๐จ๐ง๐œ๐ž๐ฉ๐ญ๐ฌ ๐จ๐Ÿ ๐Ž๐›๐ฃ๐ž๐œ๐ญ-๐Ž๐ซ๐ข๐ž๐ง๐ญ๐ž๐ - ๐‰๐€๐•๐€
    • Supervised ๐‚๐’๐˜๐„: ๐Ÿ”๐Ÿ๐ŸŽ๐ŸŽ (๐‚๐จ๐ง๐œ๐ž๐ฉ๐ญ๐ฌ ๐จ๐Ÿ ๐Ž๐›๐ฃ๐ž๐œ๐ญ-๐Ž๐ซ๐ข๐ž๐ง๐ญ๐ž๐ - ๐‰๐€๐•๐€) students, a course of ๐Ÿ•๐ŸŽ+ students, on how to apply OOP Principles into real-life applications
    • Assisted the students with project work with a strong focus on architecture and building scalable applications using object-oriented design
    • Partnered with the professor for grading and designing assignments and exams for the students

    Power School LLC
    Aug 2017 - Dec 2019

    Data Analyst

      ๐”๐ง๐ข๐Ÿ๐ข๐ž๐ ๐ˆ๐ง๐ฌ๐ข๐ ๐ก๐ญ ๐€๐๐ฆ๐ข๐ง ๐ƒ๐š๐ฌ๐ก๐›๐จ๐š๐ซ๐: Empower K-12 decision makers & stakeholders in making effective, data-driven decisions (transcends data silos) and execute actions to dramatically improve student outcomes
    • Collaborated with engineers for designing star schema data models by doing descriptive analysis to identify KPI benchmarks, for reliable and strategic decision making
    • Performed diagnostic analysis using MSSQL & Power BI to identify students who scored less in state assessments, provided strategic recommendation which significantly changed the student outcome with a 54-point increase in assessments
    • Formed complex 15+ SQL queries to extract, clean and wrangle 60M+ of structured and unstructured K-12 education data
    • Implemented 28+ parallelized bulk copy program using extract/transform/load (ETL) data, achieved 10x faster loading of data into the target data mart by using an azure blob storage resource
    • Designed 18+ interactive Power BI dashboards and ad-hoc reports showcasing a comprehensive view of overall student performance to drive data informed decision making
      • ๐•๐ข๐ซ๐ ๐ข๐ง๐ข๐š ๐‹๐จ๐ง๐ ๐ข๐ญ๐ฎ๐๐ข๐ง๐š๐ฅ ๐ƒ๐š๐ญ๐š ๐’๐ฒ๐ฌ๐ญ๐ž๐ฆ (๐•๐€๐‹๐ƒ๐’): Identify weak students and act on such students by taking the state-specific assessment, processed various assessment files for weak students via ETL framework, and seed data into the data warehouse from which the data is populated to visualization dashboards.
    • restructured and optimization of ๐Ÿ๐ŸŽ+ ETL jobs and creating metadata-driven ETL jobs to capture ETL job activity and status
    • Development of application modules based on new requirements individually and/or in teams and giving technical sessions to new developers joining the project

    Capgemini India Pvt. Ltd.
    Oct 2014 - July 2017

    Senior Software Engineer

      ๐„๐ฅ๐ž๐ฆ๐ž๐ง๐ญ ๐…๐ฅ๐ž๐ž๐ญ ๐Œ๐š๐ง๐š๐ ๐ž๐ฆ๐ž๐ง๐ญ The most critical funding application which manages the companyโ€™s cash, developed SQL queries, and ETL jobs for various modules using ๐’๐‚๐ƒ ๐ญ๐ฒ๐ฉ๐ž ๐Ÿ ๐ข๐ฆ๐ฉ๐ฅ๐ž๐ฆ๐ž๐ง๐ญ๐š๐ญ๐ข๐จ๐ง
    • Structured ๐Ÿ๐ŸŽ+ ๐’๐๐‹ ๐’๐œ๐ซ๐ข๐ฉ๐ญ๐ฌ, interacted with clients to resolve financial app queries, succeeded in ๐Ÿ๐ŸŽ๐ŸŽ% ๐œ๐ฅ๐ข๐ž๐ง๐ญ ๐ฌ๐š๐ญ๐ข๐ฌ๐Ÿ๐š๐œ๐ญ๐ข๐จ๐ง
    • Delivered ๐Ÿ๐Ÿ+ ๐„๐“๐‹ (๐ž๐ฑ๐ญ๐ซ๐š๐œ๐ญ/๐ญ๐ซ๐š๐ง๐ฌ๐Ÿ๐จ๐ซ๐ฆ/๐ฅ๐จ๐š๐) ๐ฃ๐จ๐›๐ฌ, using SCD type 2(๐’๐ฅ๐จ๐ฐ ๐‚๐ก๐š๐ง๐ ๐ข๐ง๐  ๐ƒ๐ข๐ฆ๐ž๐ง๐ฌ๐ข๐จ๐ง) technique as per client requirement and deployed it in TAC (๐“๐š๐ฅ๐ž๐ง๐ ๐€๐๐ฆ๐ข๐ง๐ข๐ฌ๐ญ๐ซ๐š๐ญ๐จ๐ซ ๐‚๐ž๐ง๐ญ๐ž๐ซ) server
    • Utilized SQL query optimizations and indexing of the tables to make the system ๐Ÿ๐ŸŽ๐ฑ ๐Ÿ๐š๐ฌ๐ญ๐ž๐ซ in the production environment
    • Provided support by daily monitoring ๐„๐“๐‹ ๐ง๐ข๐ ๐ก๐ญ๐ฅ๐ฒ ๐ฃ๐จ๐›๐ฌ in the production environment and send status mail to client

    Contact

    Feel free to reach out and ask anything about my work. Email:

    bhatt.s@northeastern.edu

    in.shivi@gmail.com