Avi Jani

United States · (857) 230-1353 · jani.av@northeastern.edu · avijani209@gmail.com

Data Analyst

As a dedicated and results-oriented Data Analyst, I am deeply passionate about harnessing the power of Python, R, Excel and SQL to derive impactful insights. Driven by an insatiable curiosity and a genuine appreciation for diverse perspectives, I take immense pleasure in leveraging data to craft strategic solutions that drive organizational triumph. With hands-on experience in project management using JIRA, I excel in fostering collaboration and optimizing efficiency through meticulously informed decision-making processes. Proficient in Agile and Scrum methodologies, I elevate team performance while creating visually captivating Tableau dashboards and conducting Python-fueled data analyses to uncover actionable intelligence. My unwavering commitment lies in leveraging my analytical acumen and technical proficiency to contribute to data-driven solutions that fuel business growth and inspire innovation.

 


Experience

Program and Project Management Associate

  • Collaborated with internal and external stakeholders to gather requirements and establish project timelines, achieving a 95% accuracy rate and employed Agile methodologies for seamless coordination in Marketing Operations
  • Created & maintained web pages & digital asset management using AEM, incorporating Business as Usual (BAU) activities leading to a 25% increase in user engagement
  • Leveraged Adobe Analytics for KPI insights and web analytics, contributing to a 15% improvement in conversion rates
  • Utilized Excel (pivot tables, VLOOKUP) to extract, analyze data and create dashboard from Adobe Analytics reports, improving KPI tracking accuracy by 30%
  • Maintained interactive dashboards with filters and parameters for dynamic data exploration
  • Initiated the development of Standard Operating Procedures (SOPs) for project management, resource allocation, and documentation control utilizing JIRA & reduced project delays by 20%
  • Conducted A/B testing with Adobe Campaign & CRM tool, resulting in a 20% increase in click-through rates
  • Managed an extensive product catalog on SAP Hybris (E-commerce Cloud), covering 75+ products across B2B and B2C
October 2021 - September 2022

Business Analyst

  • Enhanced customer experience through web page updates using CMS and data-driven marketing campaigns
  • Implemented Google Analytics by integrating it into content management system to measure visitor behavior, increasing website engagement by 15% and conducted quantitative analysis for conversion optimization
  • Analyzed marketing campaigns to track customer journey and evaluate activity through Google Analytics (conversion rate)
  • Improved customer experience through web page updates using CMS and marketing campaigns, utilizing Excel and Tableau for data visualization and performance tracking
  • Developed web landing pages for email communications, improving website engagement and ensuring SEO-friendly content with proper CTAs through regular QA practices
  • Prepared and delivered formal presentations to convey project updates effectively
July 2019 - October 2021

Projects

Sneaker Resale Predictive Modeling & Dashboard Analysis | Python, Snowflake, Tableau

  • Conducted comprehensive data analysis on a large-scale dataset of 24.5 million records for Arbit Inc., as part of the capstone project at Northeastern University; used SQL and Python for data extraction and analysis, resulting in a significant improvement in data processing efficiency
  • Executed SQL queries to extract relevant data from Snowflake, aiding targeted insight generation for project goals
  • Applied Python for in-depth analysis, employing statistical techniques and visualizations to discern data patterns
  • Developed a Tableau dashboard, resulting in a 20% improvement in pricing decisions by providing actionable insights
  • Iteratively refined predictive models, using time series model ARIMA, resulting in a 25% improvement in accuracy for predicting sneaker resale prices within the sneaker market

Arbit Inc | Northeastern University Jan 2024 - March 2024

Sales Team Capacity Planning: Forecasting Demand in E-commerce | Python | R-Studio

  • Implemented the Prophet forecasting model in Python to predict contact volume(call, chat) from historical service data within the sales department; utilized these predictions to optimize resource count, resulting in an estimated cost reduction
  • Orchestrated the implementation of the tradeoff matrix, resulting in a 20% improvement in service quality and a 15% increase in profitability for the sales team, driving strategic decision-making by conducting root cause analysis

Northeastern University March 2024

Bank Customer Churn Analysis

Tableau + Python
  • Developed an interactive Tableau solution for customer churn prediction
  • Utilized Tableau dashboards to visualize complex customer data, enabling data-driven decisions and effective data management
  • Leveraged Tableau's storytelling capabilities to communicate key insights and recommendations effectively
  • Unveiled a 20% customer churn rate using Python, empowering strategic business decisions
  • Utilized Python, Matplotlib, Seaborn, and SciPy to streamline analysis and implement robust data management practices
  • Implemented feature selection techniques, reducing training time by 25%
  • Achieved high precision (86%) and recall (96%) with Gradient Boosting in Python after model evaluation
  • Link to Tableau Project- Link to Tableau
  • Link to Github - Link to Github

Northeastern University September 2023

Oscar Best Picture Won Data Analysis & Prediction | Python

  • Detailed analysis of historical Oscar Best Picture winners to predict future winners
  • Conducted Exploratory Data Analysis (EDA) and handled data preprocessing, including removing duplicates, handling missing values, and label encoding
  • Achieved an 80% prediction accuracy for the "Oscar Best Picture" winner using an 85% accurate tree-based model on the test set
  • Link to Github - Link to Github

Northeastern University May 2023

Inventory Management Decision Model Development | MS Excel | R-Studio

  • Created a decision model in Excel and R to optimize inventory management for a company with an annual demand of 15000 units
  • Calculated Economic Order Quantity (EOQ) determining an order quantity of 661 units minimizing total inventory costs to $8,175
  • Conducted sensitivity analyses using what-if scenarios to assess the impact of parameter changes on inventory costs
  • Performed a simulation with 10,000 iterations in R to estimate expected costs and order quantities providing 95% confidence intervals, achieving more accurate order quantities and significant cost savings

Northeastern University May 2023

Project on Cambridge City Properties | Tableau, QlikView

  • Evaluated housing trends and factors affecting property prices in the Boston-Cambridge-Newton Metropolitan Area
  • Utilized Tableau and QlikView to create data visualizations for studying property prices, developing procurement metrics and KPIs, and providing insights to address research questions and support decision-making
  • Designed and implemented a customized dashboard that showcased key trends in land value, building value, tax amounts, and interior flooring in relation to sale price, achieving a 30% improvement in data accuracy and efficiency
  • Link to Tableau - Link to Tableau

Northeastern University May 2023

Walmart Sales Optimization Project | MySQL

  • Conducted comprehensive analysis of Walmart sales data, aiming to optimize sales strategies
  • Executed robust data wrangling, exploratory data analysis, and financial metric calculations
  • Achieved enhanced insights into product lines and customer segments, contributing to strategic sales improvements
  • Link to Github - Link to Github

Northeastern University December 2023

Data Professional Survey Analysis | Power BI

  • Conducted detailed Power BI analysis on Data Professional survey, exploring salary gaps, and career changes
  • Utilized advanced features, highlighting gender-based salary variations and the USA's prominence in the data industry
  • Presented key findings through a dashboard, showcasing a 2% higher salary for women and global industry trends
  • Link to Github - Link to Github

Northeastern University January 2024

Project Management | Process Migration & Improvement

  • Spearheaded seamless content management tool migration from SharePoint to AEM CMS, minimizing downtime by 25%
  • Collaboratively contributed to managing cross-functional teams, achieving a 20% increase in overall efficiency and a 15% improvement in process optimization
  • Acted as the primary point of contact, contributing to a 30% enhancement in project support effectiveness and maintained process documentation in JIRA with a 25% increase in accuracy
  • Enhanced content management tool quality by 20% through rigorous QA, ensuring adherence to web standards

Accenture October 2021 – August 2022

Education

Northeatsern University

Masters in Analytics

GPA: 3.7

September 2022 - March 2024

University of Mumbai

Bachelor's of Commerce

GPA: 3.8

July 2015 - April 2018

Skills

Programming Languages & Tools
Workflow

Interests

I'm a data enthusiast and process analyst with a knack for unraveling complex information. Beyond work, I'm an avid nature lover. I find joy in hiking, kayaking, and exploring new places.

I also have a creative side—I enjoy painting, letting my imagination flow onto the canvas. And I'm deeply connected to my cultural heritage, expressing it through Garba, a vibrant Indian folk dance. These passions reflect the diverse facets of my personality, adding depth to my life.


Trekking

Trekking

Travelling

Travelling

Garba

Garba

Animal Love

Animal Love

Scuba Diving

Scuba Diving

Water Fall

Getting to close Nature


Awards