Shivam Abrol

3336 Jefferson Ave · Cincinnati, OH 45220 · (513) 404-9977 · abrolsm@mail.uc.edu

I am experienced in leveraging agile frameworks to provide a robust synopsis for high level overviews. Iterative approaches to corporate strategy foster collaborative thinking to further the overall value proposition.

Experience

Data Engineer

UC Sim Center (P&G)

  • Worked closely with a cross-functional team to develop the MongoDB-powered user interface using Streamlit for the grooming data hub pilot project
  • Led the effort to utilize the Labelbox API and Python to link over 10,000 images with their corresponding labels, which greatly improved the usability of the data for business users
  • Took the initiative to analyze structured and non-structured data from multiple sources and implemented data pipelines using Azure Logic apps and Databricks to automate the merging and updating of sensor data
  • Suggested and implemented the development of a PySpark-based Spark application in Azure Databricks, which resulted in a 50% improvement in data processing efficiency by extracting, transforming, and aggregating data from 1000+ CSV files totaling 500GB of data for automatic integration

    • March 2022 - Present

    Software Developer

    AscentX

  • Worked with a team of developers to enhance the data rendering API performance by optimizing latency, resulting in a 95% reduction in response time from 2 seconds to 10 milliseconds
  • Took the initiative to automate the build and deployment process for 5 projects using Jenkins and shell scripting, reducing release times by an average of 25% and streamlining the release process
  • Collaborated with a team of database administrators to design over 50 complex PL/SQL queries, procedures, triggers, stored procedures, packages, and views for various databases such as Oracle and MySQL
  • Developed 15+ Typescript reusable components and services to consume REST APIs using an Angular 4 component-based architecture, utilizing Webpack to build and optimize the performance of the Typescript modules

    • January 2020 - July 2021

    Education

    University of Cincinnati

    Masters of Science
    Computer Science

    GPA: 3.72

    August 2021 - August 2023

    Thapar Institute of Engineering and Tech

    Bachelor of Engineering
    Computer Engineering

    GPA: 3.6

    August 2016 - June 2020

    Skills

    Programming Languages and Tech

    • Proficient in Java SE and Java EE, with 2 years of experience in developing enterprise-level applications
    • Strong experience in web development using frameworks such as Spring and Hibernate
    • Experienced in deploying applications to web application servers such as Tomcat
    • Proficient in designing and querying databases using SQL
    • Skilled in agile software development methodologies and version control using Git
    • Experience with continuous integration and deployment using Jenkins
    • Familiar with front-end development using HTML, CSS, and JavaScript

    Workflow
    • Mobile-First, Responsive Design
    • Cross Browser Testing & Debugging
    • Cross Functional Teams
    • Agile Development & Scrum

    Projects

    Herbarium Data Analysis

    Live Website Code Documentation

    • University of Cincinnati has a collection of preserved plant, fungi, and lichen specimens The project aimed to build a website to visualize the fungi data in bar charts, pie charts, and a map
    • 8,000 entries of fungi data were extracted from online database, including GPS location, collection date, collector, classification, and habitat notes Data in CSV format, some fields sparsely populated and may need formatting
    • D3.js and Leaflet JavaScript libraries were used for data visualization and web mapping Website has filters (year, start day, and class) and a draggable timeline chart to update data in real-time

    TV Time

    Live Website Code Documentation

    • Website built using D3.js and data from Kaggle to analyze dialogue from Star Trek Deep Space 9 Interactive bar charts show number of lines per character per episode
    • Interactive elements include hover effects, tooltips, and dynamic updates based on user selection Data can be filtered by character or season
    • Provides unique and engaging way for fans to analyze dialogue from the show.

    Other projects

    Old Portfolio

    I've got a bunch of other projects which I did for User Interface and Data Visualization classes You can find them on my old porfolio website.
    PS: They're a little unorganised

    Interests

    I have a diverse range of hobbies that I enjoy both indoors and outdoors. When I'm inside, I like to read books, watch movies, and listen to music. I also enjoy doing puzzles and playing board games with friends and family. On the other hand, when I'm outside, I love to go for hikes, play sports like basketball and soccer, and go camping. I find it important to have a balance of indoor and outdoor activities to keep me active, mentally stimulated, and in touch with nature. Whether it's a quiet day inside or a day filled with adventure, I always find time for the things that I love and bring me joy.