Mansi Borole

Experience

Michigan Health Information Networks (MiHIN)

Software Development Engineer Intern

May 2023 - Present

• Worked on backend development of a state-sponsored project “Social Determinants of Health”. Developed and deployed AWS Lambda functions using Python Boto library for processing, validating, and storing Electronic Health Records in AWS RDS.
• Created mock interfaces and implemented unit tests to validate the functionality of the database drivers. Took a test-driven design approach to ensure code quality and improved code coverage from 20% to 80%.
• Optimized PostgreSQL database performance using indexes and views, resulting in 80% faster processing.
• Created a PoC Project to evaluate Serverless architecture using AWS Lambda, SNS, CloudFormation and showcased it to the leadership.

May 2023 - Present

HSBC Bank

Software Engineer (Big Data)

July 2019 - August 2022

• Provisioned Cloudera Hadoop clusters (HDFS, MapReduce, YARN, Hive, Oozie, Zookeeper, Solr) on-premise for production and disaster recovery in the UK and HK datacenters.
• Built "BigData360", a real-time alerting, monitoring system and designed dashboards for 80+ Hadoop dev and prod clusters using Grafana and Prometheus by collecting metrics from Cloudera APIs and Node Exporters.
• Generated monthly cost reports to support Big Data Capacity Planning and forecasting demand. Built a self-serving data cataloging tool to analyze tenant usage metrics and trends in real time using NiFi, MySQL and groovy saving ~150 workhours. 
• Virtualized control nodes by migrating critical Hadoop Master services (NameNodes, YARN, Solr, Zookeeper, Hive) from on-premise servers to ESXi virtual machines to enhance cluster efficiency. Achieved cost avoidance of $700k on buying new expensive servers while saving 400 work hours in maintenance upgrades. 
• Developed ETL pipelines and scripts in python to archive cold data. Set up HDFS Erasure coding policies to achieve savings of 50% in total storage space.
• Created automation using Ansible playbooks to streamline the provisioning of RedHat servers with Cloudera(CDP) Hadoop capabilities.
• Mentored and onboarded new SWEs. Conducted knowledge sharing sessions with my team.

July 2019 - August 2022

Part time Web Designer

• Managing wordpress/drupal webpages for Mechanical and Aerospace Engineering, School of Engineering @ Rutgers
• Designed and developed websites for client’s businesses using HTML, CSS, Javascript, Wordpress.
• Work sample https://deogiriinfratech.com , https://mansigit.github.io/

July 2018 - Present

Education

Rutgers University - New Brunswick

Masters of Science, Computer Science

Massive Data Analytics , Machine Learning

GPA: 3.91 / 4.0

August 2022 - May 2024

University of Pune, India

Bachlors of Engineering, Computer Science

Coursework: Data Structures, Database Management, Distributed Computing

CGPA: 8.61 / 10

Publication: A "Survey on Blockchain for Enabling Transparency in transactions of Government Direct Benefit Transfers (DBT)" >> DOI:10.5120/IJCA2019918637

June 2015 - June 2019

Technical Skills

• Programming Proficiency: Python, SQL, HTML, CSS, JavaScript, Shell Scripting, YAML
• Cloud & Databases platforms PostgreSQL, MySQL, MongoDB, AWS (S3, EC2, Lambda, RDS, API Gateway, CloudFormation)
• Big Data Hadoop: HDFS, Apache Spark, Pyspark, Apache Airflow, Scoop, ETL, Enterprise Data Ingestion and Warehousing
• Tools & Frameworks: Git, Serverless, Boto, Node.js, React, Pytest, Tableau, Grafana, Microsoft Suite, JIRA, Agile, CI/CD
• Data Visualization: Tableau, Grafana, QlikSense

• Test-driven developement(TDD), Backend development, REST APIs, Microservices, Serverless application developement
• Hadoop Administration, DevOps SRE, Big Data Engineering and Capcity Management

Interests 😻

I like reading, anime, marathons, digital art, and cats.🤓 😎

I'm always on the lookout for the next marathon around the town 🏃‍♀️

Here are some of my favorite movies and quotes : 🎞️

"One often meets his destiny on the road he takes to avoid it" - Master Oogway 🐼

Even the most unlikely hero can overcome past struggles and become a kung fu master with the help of loved ones. It inspires us to strive to be the ultimate version of ourselves and to find inner peace in order to achieve success.🌱

“There is nowhere you could go that I won’t be with you.” – Gramma Tala (Moana) 🌊

When it comes to leadership and family, I found Moana to be a terrific inspiration. The movie shows how one can overcome fears through family and cultural heritage, and how leadership is not about power but about responsibility and service to others. 🌞