Shiven Krishan Ahuja

Operations Associate

Boston, Massachusetts, United States7 yrs 4 mos experience
Most Likely To SwitchHighly Stable

Key Highlights

  • Six years of experience in analytics and BI solutions.
  • Expert in Python, SQL, and data visualization tools.
  • Strong background in customer experience and process improvement.
Stackforce AI infers this person is a Data Analyst with expertise in eCommerce and Business Intelligence.

Contact

Skills

Core Skills

Data AnalysisBusiness IntelligenceCustomer Experience

Other Skills

AnalyticsData ModelingDescriptive AnalysisLeadershipMarketing StrategyMicrosoft ExcelMicrosoft Power BIMicrosoft PowerPointProcess ImprovementPython (Programming Language)R (Programming Language)SQLStatisticsStrategic PlanningTableau

About

πŸ‘‹πŸ½ Hi, my name is Shiven Ahuja πŸ• Currently working in Merchandising analytics at Chewy πŸŽ“ Masters in Quantitative Management from Fuqua School of Business, Duke University with specialization in the Marketing domain πŸ‘¨πŸ»β€πŸ’» Analytics Consultant with six years of experience partnering with consulting/eCommerce companies to design and deploy high-impact BI solutions, drive analytical support, and generate insights and recommendations for the business. Adept at project management, stakeholder interaction, and storyboarding πŸ’» My stint in Mu Sigma was very enriching in terms of the variety and complexity of problems, giving me a platform to journey along a steep learning curve, with tasks ranging from simple number crunching to implementing various machine learning algorithms πŸ›’ At Flipkart (Walmart Group), I worked with the customer experience team building a data-driven solution framework to deliver a frictionless 'Customer First' experience 🎾 I like badminton and cycling and watching Duke Basketball (Go Blue Devils!) and Boston Celtics πŸ’ͺ🏽 Tools: Python | R | SQL | Advanced MS Excel | Power BI | Tableau Please feel free to reach out to me. Email: shiven.k.ahuja@gmail.com

Experience

Chewy

2 roles

Manager

Promoted

Oct 2024 – Present Β· 1 yr 5 mos Β· Boston, Massachusetts, United States

Senior Analyst

Jun 2022 – Sep 2024 Β· 2 yrs 3 mos Β· Boston, Massachusetts, United States

Duke university - the fuqua school of business

Data Science Student Consultant

Mar 2022 – Apr 2022 Β· 1 mo Β· Durham, North Carolina, United States

  • Helped a multinational technology giant analyze data to drive the cloud gaming business
  • Analyzed 2M+ streaming quality metrics and user attributes data of Cloud gaming service
  • Predicted user engagement and churn via SQL and Python and visualized data via Power BI
  • Used multiple prediction models (Linear, Lasso, Random Forest, Logistic and Classification Tree) and evaluated their performance based on cross-validation and out-of-sample test.
  • Generated insights into user experience and recommended solutions to enable the client to improve user engagement and retention
Microsoft Power BIPython (Programming Language)SQLData AnalysisBusiness Intelligence

Flipkart

2 roles

Senior Business Analyst

Promoted

Apr 2021 – Jun 2021 Β· 2 mos Β· Bengaluru, Karnataka, India

Microsoft Power BIR (Programming Language)SQLProcess ImprovementCustomer ExperienceData Modeling+1

Business Analyst

Apr 2019 – Mar 2021 Β· 1 yr 11 mos Β· Bengaluru, Karnataka, India

Microsoft Power BIR (Programming Language)SQLDescriptive AnalysisData AnalysisBusiness Intelligence

Mu sigma inc.

Trainee Decision Scientist/Business Analyst

Jul 2017 – Apr 2019 Β· 1 yr 9 mos Β· Bangalore

  • Lead Targeting and Management
  • In reaction to clients marketing goal to reduce lead acquisition cost, enabled a feedback enterprise system for agents which prioritized prospect leads in the insurance market to aid effective lead targeting and expand customer base
  • Analyzed the purchase frequency and found that 25% of the leads had been repurchased from the same sources within 3 months. This enabled us to pin-point the root cause allowing the business team to centralize the lead purchase and distribution process helping save ~$10M
  • Designed a monitoring and performance tracker to evaluate key metrics of customer acquisition. Created dashboards using Tableau to analyze the agent and campaign performance based on KPIs like conversion rate etc. and carried out significance tests to validate the same
  • TV Network Exposure Segmentation
  • Worked with the Marketing team to create segments to understand underlying demographic, credit and other factors influencing unique reach using Rule based and Algorithmic segmentation (K-means Clustering). This helped in identifying low performing networks
  • Automating Model Validation
  • Helped the Marketing and Operations team in the end-to-end automation of weekly reporting from data manipulation in Hadoop to publishing the report, through in-house proprietary tool
  • Reduced the turnaround time for entire validation process by 80%
  • Driver Analysis
  • Developed look-alike models using Logistic Regression, Ensemble Decision Tree for an Insurance company to identify behavioral triggers leading a person to quote online before it even shows up in a lead list from an external vendor. This facilitated in optimizing lead acquisition costs by 15%.
R (Programming Language)SQLMicrosoft ExcelTableauData AnalysisBusiness Intelligence

Myadvo.in

Analyst - Corporate Alliance

Feb 2017 – Apr 2017 Β· 2 mos Β· Gurgaon, India

  • Analysed CRM data to define strategy and business plan for Corporate Sales Team, establishing a strategic alliance with consumer electronic companies that resulted in recurring business for the company.
  • Solely responsible for the Anti-Dumping cases for the company, which boosted the overall revenue of the company.

Namekart

Junior Domain Trader

Jan 2017 – Feb 2017 Β· 1 mo Β· Gurgaon, India

  • Analyzed key metrics to define the strategy for buying and sale of domains

Education

Duke University - The Fuqua School of Business

Masters of Quantitative Management β€” Business Analytics

Thapar Institute of Engineering & Technology

Engineer’s Degree β€” Electronics(Instrumentation And Control)

St. John's High School, Chandigarh

High School β€” Non- Medical

Stackforce found 100+ more professionals with Data Analysis & Business Intelligence

Explore similar profiles based on matching skills and experience