Hi !

I'm Janhavi Zarapkar

Data



Skills

Skills

Languages and Frameworks

  • Python Python
  • MS SQL Server SQL
  • Java Java
  • Salesforce Salesforce
  • JavaScript JavaScript
  • Node.js Node.js
  • R R
  • React React
  • Angular Angular

Data Engineering

  • AWS Glue AWS Glue
  • PySpark PySpark
  • Talend Talend
  • Qlik Qlik
  • Informatica Informatica
  • Databricks Databricks

Database and Cloud

  • Postgres Postgres
  • MS SQL Server MS SQL Server
  • MongoDB MongoDB
  • Snowflake Snowflake
  • Azure Azure

ETL and Business Intelligence

  • Power BI Power BI
  • Tableau Tableau
  • Aws AWS
  • NumPy NumPy
  • Pandas Pandas
  • Keras Keras
  • Sci-kit Sci-kit
  • SciPy SciPy

Project Management Tools

  • Confluence Confluence
  • Lucid Charts Lucid Charts
  • JIRA JIRA
  • GIT GIT
  • Bitbucket Bitbucket
  • Jenkins Jenkins
  • Jupyter Jupyter
  • Azure DevOps Azure DevOps

Certifications

  • Salesforce Certified Administrator Salesforce Certified Administrator
  • Salesforce Certified Associate Salesforce Certified Associate

About

About Me

With a robust background in data science and analytics, I am currently pursuing a Master's in Information Management at the University of Illinois, Urbana-Champaign. My journey includes hands-on experience with leading organizations such as AGCO Corporation and Barclays, where I honed my skills in data engineering, machine learning, and cloud technologies. I have also worked extensively with Salesforce, automating data processes, optimizing metadata, and leading application migrations to Salesforce for improved business operations. From building scalable ETL pipelines to optimizing complex SQL queries, my work consistently drives efficiency and accuracy. Passionate about leveraging data to solve real-world problems, I thrive on transforming data into actionable insights for impactful decision-making.

Address: Champaign, Illinois, US
Education: Masters in Information Management (2025)
Bachelors in Information Technology (2021)
Languages: English, Hindi, Marathi
Interests: Traveling, Cooking, Gaming
Email Id: jzarap2@illinois.edu

Education

Education

University Of Illinois Urbana Champaign

Masters in Information Management
August 2023 - May 2025
Illinois,USA

Grade : 4.0 / 4.0

Coursework:

Data Stats and Information, Data Warehousing and Business Intelligence, Database Design and Prototyping, Database Admin and Scaling, Methods of Data Science, Data Visualization, Sociotechnical Information Systems, Information Consulting, Application Business Research

University Of Mumbai

Bachelor of Science in Information Technology
August 2017 - June 2021
Mumbai,India

Grade : 9.39 / 10.00

Coursework:

Data Mining and Business Intelligence, Big Data Analytics, Project Management, Data Structures and Algorithms, Database Management Systems, Advanced Data Structures and Algorithms, Advanced Database Management Systems, R Programming Lab, Python Programming

Experience

Experience

  • August 2024 - Present

    Business Intelligence Group

    Consultant

    Champaign, Illinois, USA

    (Part Time)

     ● Collaborated with a team of 6 consultants to build machine learning-based demand forecasting models for Asian groceries in the U.S. market, driving improved supply chain efficiency for a leading Korean food exporter.
     ● Conducted detailed research to identify market trends and socio-economic factors impacting demand, providing strategic insights that enhanced the client’s profitability.

  • May 2024 - Present

    AGCO Corporation

    Advanced Analytics and Data Engineer Intern

    Champaign, Illinois, USA

    (Internship)

     ● Developed ETL pipelines with AWS Glue, integrated PySpark for SQL-based distributed data analytics, and utilized S3 and Redshift for efficient data storage, expediting data analytics by 35%
     ● Optimized complex SQL-based views in Redshift for integration with Kinaxis Rapid Response via SFTP, resulting in a 20% improvement in forecast accuracy
     ● Created YAML-configured AWS Glue jobs and JSON scripts, deployed through CloudFormation, reducing manual efforts by 70%

  • January 2024 - April 2024

    AGCO Corporation

    Salesforce Data Intern

    Champaign, Illinois, USA

    (Part Time)

     ● Automated hourly data ingestion from SAP and Oracle into Amazon S3, enabling real-time decision-making using Qlik Replicate
     ● Leveraged Python scripts to optimize Salesforce metadata, improving security and performance based on user metrics

  • October 2023 - Present

    UIUC iSchool

    iSchool Ambassador

    Champaign, Illinois, USA

    (Part Time)

     ● Guided around 100+ prospective applicants of the UIUC MSIM program, thereby raising awareness and potentially increasing the program's visibility and facilitated incoming student queries through virtual information sessions and 1-on-1 meetings.
     ● Representing the college at recruitment & and networking events.
    UIUC Ambassador

  • August 2021 - July 2023

    BARCLAYS

    Business Analyst 3 - Developer

    Pune, India

    (Full Time)

     ● Orchestrated migration of Contact Centre Desktop application used by Barclays to Salesforce (LWC, Apex, JavaScript), handling design, development, UI enhancements, and API integration, achieving a 30% reduction in customer support issues
     ● Led the creation of a Knowledge Management app, revolutionizing knowledge article workflows and driving a 20% surge in knowledge sharing among Barclays Agents by leveraging Salesforce automation and Flows
     ● Transformed an Executive Dashboard, utilizing live data through SOQL and Salesforce's Reports and Dashboard functionality, providing real-time insights, including a 15% rise in active agents and cards
     ● Received Barclays Team Award for excellent delivery of the US Consumer Bank Strategic Priorities in Q1 of 2023 following Agile methodology principles through JIRA

  • August 2024 - Present

    Data Science & Analytics Lab,TSEC

    Academic Intern

    Mumbai, India

    (Internship)

     ● Analyzed customer purchase behavior during Black Friday Sales and built a predictive model, revealing a Gaussian distribution in the 'Purchase' variable and identifying key features (Occupation, Age, Gender) through uni-variate analysis
     ● Implemented one-hot encoding, ordered data mapping, and label encoding to handle categorical data, reducing RMSE by 15%
     ● Evaluated regression models (Multiple Linear, Random Forest, XGBoost) and achieved a RMSE of 2729, ranking in the top 30%  
    Link to Blog

Projects

Projects

norman

Data Augmentation and Analysis on Norman PD Incidents

Developed a Python-based ETL pipeline for Norman Police Department, reducing data processing time by 40% and enhancing data accuracy with geolocation integration. Conducted performance analysis of NoSQL (MongoDB and Amazon DynamoDB) databases to optimize scalability and efficiency.

norman

ImmunoChain
(EY Techathon Winner -2021)

Led the development of a gamified Flutter-based app to boost COVID vaccination, incorporating a chatbot for scheduling and FAQs. Integrated Blockchain and IoT for QR-based vaccine tracking, aiming to reduce counterfeiting and enhance public trust.

norman

Workforce Dynamics Analysis using Tableau

Developed a dynamic Tableau-based visualization system for workforce analysis, reducing exploration time by 20%. Cleaned and transformed employee data, enhancing human capital decision accuracy by 40%.

norman

Voice Your ID
(Smart India Hackathon Winner -2020)

Led a team of 6 to develop a voice recognition model (88% accuracy) for biometric authentication using Gaussian Mixture Models. Implemented a system in PostgreSQL to detect GPS spoofing and flag user impersonation attempts.

norman

Automobile Driver Anomaly Detection System

Developed a sensor data processing system integrated with vehicle OBD ports to analyze driving metrics and detect hazardous behaviors in real time. Created a Multivariate Gaussian Distribution Anomaly Detection Model with 79% accuracy, tested on a Carla Simulator using Python and PlayStation controller inputs.

norman

Black Friday Sales Predicition

Analyzed customer behavior during Black Friday Sales and built a predictive model to identify key features like occupation, age, and gender. Utilized various encoding techniques to manage categorical data, reducing RMSE by 15%. Evaluated multiple regression models and achieved an RMSE of 2729, ranking in the top 30%.

Certifications

Certifications

Leadership

Leadership and Volunteering Experience

iSchool Ambassador

As an iSchool Ambassador ( 2023 - Present) at the University of Illinois Urbana-Champaign, I guided over 100 prospective applicants for the MSIM program, enhancing program visibility and awareness. I facilitated incoming student queries through virtual information sessions and one-on-one meetings, providing valuable insights and support. Additionally, I represented the college at recruitment and networking events, fostering connections and promoting the program to potential students. My efforts contributed to creating a welcoming and informative environment for those considering the MSIM program.

Project Manager - Consulting

As Project Manager for an iSchool Information Consulting project (Aug 2023 - Dec 2023), I led a team of seven consultants to deliver strategic recommendations for a beauty sector client entering a new market. I ensured the successful execution of the project by setting clear agendas, delegating tasks effectively, and monitoring progress to meet critical deadlines. My ability to foster open communication and maintain cross-functional collaboration was key in adapting to the client’s evolving needs. I employed strategic thinking, leveraging market research and data analysis to tailor our recommendations.

Team Leader - Smart India Hackathon (2020)

As the team leader for the Smart India Hackathon 2020, I led a team of six to develop a voice and location-based attendance system for the Ministry of Youth Affairs and Sports. I applied agile methodology to ensure timely delivery across multiple prototype rounds, while managing team collaboration, communication with organizers. I took on a product owner role, coordinating research into the client’s needs and guiding brainstorming sessions that shaped the end-user experience. I ensured innovative solutions like IVR-based attendance marking for offline scenarios, while spearheading technical strategies like GPS spoofing detection. I showcased leadership by guiding the team towards a shared vision, promoting collaboration, & delivering a practical solution within a tight timeframe.

National Service Scheme

As a Student Volunteer with the National Service Scheme from May 2018 to December 2020, I dedicated over two years to various social initiatives. I participated in a 10-day residential camp in Ambevadi village, where I taught children about the importance of education and helped organize medical camps. I also raised awareness about the use of sanitary pads among women in the village and assisted a family in selling food during a Food Mela. Additionally, I contributed to blood donation camps at my college, including donating blood for the Tata Memorial Hospital. This role strengthened my commitment to community service and empowered me to drive positive change in the lives of others.

Contact

Contact Me