Summary
Work History
Education
Skills
Work Availability
Quote
Interests
Projects
Timeline
CustomerServiceRepresentative
Aaruni S. Jha

Aaruni S. Jha

CT

Summary

Seasoned data analyst experienced in meeting business requirements, improving processes and efficiency in team environments. Diligent worker with strong communication, task prioritization skills with real-time problem-solving ability.

Work History

Data Analyst

Compensia Inc
06.2022 - Current
  • Developed over 15 JS scripts to apply different business rules, accelerating process execution time by 17%.
  • Automated workflow process in MS Power Automate, accelerating task completion time by 20%..
  • Extracted data points from SEC APIs to develop data model using Python and MS Visio.
  • Conducted UAT resulting in a 98% success rate of functionality delivery.

Area Manager/Logistics Analyst

Amazon Logistics
02.2021 - 12.2021
  • Conducted RCA on supply shortages, boosting customer satisfaction ratings by 10%.
  • Utilized historical data to develop new process improvement plans, increasing quality by 20%.
  • Developed dashboards on Power BI to monitor internal business processes, resulting in an increasing throughput of 30%.
  • Analyzed data from tracking system for over 9,000 items daily leading to over 99.90% daily scan compliance.
  • Collaborated on safety programs to reduce employee-site exposure of COVID-19, resulting in a 90% decrease in risk.

Assistant Manager/Sales Analyst

CT Business Consulting
08.2018 - 08.2019
  • Guided management to develop insights from customer data using Power BI and SharePoint, raising profits by 30%
  • Developed dashboards depicting statistical trends of employee attrition, which led to a boost in the retention rate of 30%.
  • Mentored over 30 associates on approaches to upsell products increasing their customer conversion rate by 20%.
  • Designed innovative market strategy to boost market penetration, increasing operating profit margin by 23 %.

Assistant System Engineer

Tata Consultancy & Services
01.2016 - 05.2017
  • Analyzed customer online journey funnel data to detect fraud cases, resulting in a 30% decrease in fraudulent activity.
  • Created user groups, catalogs, and store specific attributes on SAP Hybris to boost customer conversion rate by 40%.
  • Created promotions with results driven strategic initiatives and product catalog management increasing client's revenue by 8%.
  • Optimized user interface design & functionality for accessibility, increasing customer engagement by 40%.

Education

Master of Science - Engineering Management

Northeastern University
Boston, MA
12.2020

Bachelor of Science - Electrical & Electronics Engineering

Sikkim Manipal Institute of Technology
India
06.2015

Skills

  • Microsoft Power Platform
  • Microsoft Excel
  • Microsoft Visio
  • Power BI
  • Python
  • Structured Query Language (SQL)
  • JavaScript
  • Scrum
  • Pivot Tables
  • VBA
  • User Acceptance Testing (UAT)
  • JIRA

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Quote

Even if you are on the right track, you’ll get run over if you just sit there.
Will Rodgers

Interests

Soccer

Digital Art

Digital Illustration

Traveling

Fitness

Gaming

Projects

Exploratory Data Analysis on Russia Ukraine War (Personal Project)

(https://github.com/AaruniJha/RUSSUKR/blob/main/RUSS_UKR_%20(2).ipynb)

Project Goal: Real time EDA on Russian Ukraine ongoing war.

Objectives

  • Use json and requests to import data.
  • Improve data accuracy.
  • Clean data provided on equipment and personnel loss.(check for null values, duplicated values and outliers).
  • Check data types. Convert them for any further operation.
  • Merge datasets
  • Analyze trends for each variable.
  • Group aerial, ground and naval equipments.
  • Create data visualizations to notice trends in losses.

Exploratory Data Analysis of US Census (Personal Project)(https://github.com/AaruniJha/US_Census/blob/570d410826ec2eabeb66af7429af38c5aae4b4b4/US_Census_EDA.ipynb)

Objectives:

  • Performed EDA on US Census.
  • Execute data cleaning operations such as removal of null values, duplicate values and outliers.
  • Compare the difference in result and visualizations pre and post removal of outliers.
  • Use python packages such as pandas, numpy, matplotlib, glob, seaborn in the project.
  • Perform Bivariate Analysis.
  • Perform Correlation Analysis.

Heat Fire Alarm System (Northeastern University - 09/2020 to 12/2020)

Objective: Use the fundamentals of product development to reduce false fire alarms.

  • Awarded as the best team member in the group.
  • Created a survey on SurveyMonkey to manipulate data to justify the requirement and value of products.
  • Led a team of three to propose and develop a heat fire alarm system to reduce false alarms.
  • Extracted data from APIs in Python to define user needs and refined them into design requirements.
  • Completed the three deliverables: lean canvas business model, stakeholder matrix and market specifications for the Fire Alarm System.
  • Researched on stakeholders, key activities, key resources, cost estimation and value proposition.

Sustainable Packaging Solution in E-Commerce Sector (Northeastern University - 09/2020 to 12/2020)

Objective: Develop Sustainable packaging for small products.

  • Led a cross functional team of 5 to develop sustainable packaging for small products.
  • Used data from market research to define user requirements and product strategy.
  • Conducted iterations of the product prototype and used a decision matrix with KPIs to pick final design.
  • Outlined a go-to market strategy with the help of a canvas business model.
  • Designed a prototype on Umake 3DArt which was later refined on solidworks by the team.

Automated Irrigation System (Sikkim Manipal Institute of Technology - Jan 2011 to May 2015)

  • Developed a prototype. to show minimization of manual labor for agriculture .
  • Developed code to satiate real-time values for conduction of irrigation using microprocessor 8085 and Ardunio Uno.
  • Developed soil moisture sensor, temperature sensor, water level sensor to build the hardware.

Timeline

Data Analyst

Compensia Inc
06.2022 - Current

Area Manager/Logistics Analyst

Amazon Logistics
02.2021 - 12.2021

Assistant Manager/Sales Analyst

CT Business Consulting
08.2018 - 08.2019

Assistant System Engineer

Tata Consultancy & Services
01.2016 - 05.2017

Master of Science - Engineering Management

Northeastern University

Bachelor of Science - Electrical & Electronics Engineering

Sikkim Manipal Institute of Technology
Aaruni S. Jha