Avi Jani

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

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

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

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

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

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

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

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

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

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

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

Northeatsern University

GPA: 3.7