Tannu Hooda
Quick Summary
I am drawn to utilising data to solve complex business challenges and drive strategic outcomes, aiming to increase efficiency and support growth.
I analyse large datasets, turning insights into actionable plans, refining strategies related to performance and customer behaviour.
My goal is to deliver clarity through data narratives, enhancing operational models and informing critical business decisions.
I analyse large datasets, turning insights into actionable plans, refining strategies related to performance and customer behaviour.
My goal is to deliver clarity through data narratives, enhancing operational models and informing critical business decisions.
USP
- Applied Python (Pandas, NumPy) and SQL to analyse data from over one million Instacart orders, segmenting customers to inform exact marketing strategies.
- Reduced procurement-to-sale lead times by over 50% for luxury watches at Ethos Limited by streamlining sourcing and quality checks.
- Developed decision tree models in a global banking context to identify customer churn predictors and strengthen AML compliance programs.
- Created Tableau dashboards for a medical staffing agency, integrating data from the US Census Bureau and CDC to optimise personnel dispatch during flu season.
Data Analysis & Interpretation
My ability to analyse complex data sets has led to more informed strategic planning and measurable business improvements.
Statistical Analysis & Modelling
Applying statistical techniques has led to stronger financial decisions and proactive risk mitigation strategies in diverse projects.
Data Visualisation & Reporting
Effective data visualisation and detailed reporting improve insight communication and allow for quicker strategic alignment.
Actionable Business Insights
Transforming data into clear, actionable recommendations has directly supported improved acquisition strategies and growth initiatives.
Chrono Seconds — Operations Head
Primary Responsibilities:
Specific Projects and Contributions:
Contribution to Mission:
The work supported the enterprise by optimising operational workflows through the supply chain and ensuring financial viability through informed procurement, which directly influenced top-line growth and market performance.
Skills Developed: Data Gathering, Market Research, Operational Streamlining, Supply Chain Management, Inventory Management, Client Relationship Management.
- Managing end-to-end operations including supply chain, inventory, logistics, and shipping.
- Conducting detailed procurement pricing research to determine accurate acquisition costs for inventory.
- Gathering market insights and segmenting customers to engage them effectively.
Specific Projects and Contributions:
- Improved cash flow by balancing margin targets against market value expectations, informing purchasing practices.
- Grew transaction volume by 200 trades per month and quarterly revenue by $50,000 by executing targeted client engagement initiatives informed by market insights.
- Automated reporting and planning workflows, reducing lead times by 10 hours per week and enhancing operational efficiency across main functions.
Contribution to Mission:
The work supported the enterprise by optimising operational workflows through the supply chain and ensuring financial viability through informed procurement, which directly influenced top-line growth and market performance.
Skills Developed: Data Gathering, Market Research, Operational Streamlining, Supply Chain Management, Inventory Management, Client Relationship Management.
Ethos Limited — Operations/Data Analyst
Primary Responsibilities:
Specific Projects and Contributions:
Contribution to Mission:
This role was central to building operational consistency, managing financial returns through pricing strategies, and ensuring sales team motivation and alignment with organisational goals, all contributing to the company's expansion in the certified pre-owned watch market.
Skills Developed: Data Analysis, Process Optimisation, Strategic Pricing, Incentive Program Design, Inventory Management, Quality Control, CRM Management, Sales Reporting, Data Extraction, Client Relations, Negotiations, Sales Operations.
- Built and scaled certified pre-owned watch operations, defining Standard Operating Procedures (SOPs), quality workflows, and inventory systems.
- Designed and implemented procurement pricing strategies for weekly inventory, impacting margin outcomes.
- Managed full sales cycles, administered Salesforce CRM to track pipeline activity, and cultivated client relationships.
- Collaborated with the accounts team to create data-focused incentive structures linked to monthly revenue.
Specific Projects and Contributions:
- Reduced procurement-to-sale lead times by over 50% (from 15 to 7 days) by simplifying sourcing, quality checks, and website upload processes.
- Increased website traffic by 60% and total sales revenue by $100,000 through data-led website redesign and optimization.
- Produced regular sales performance reports from Salesforce data to inform incentive calculations and management decisions.
- Negotiated profitable deals and provided tailored service to high-value customers, resulting in strong client satisfaction.
Contribution to Mission:
This role was central to building operational consistency, managing financial returns through pricing strategies, and ensuring sales team motivation and alignment with organisational goals, all contributing to the company's expansion in the certified pre-owned watch market.
Skills Developed: Data Analysis, Process Optimisation, Strategic Pricing, Incentive Program Design, Inventory Management, Quality Control, CRM Management, Sales Reporting, Data Extraction, Client Relations, Negotiations, Sales Operations.
Instacart | Targeted Marketing & Business Strategy
Project Description: Instacart aimed to move beyond general sales strategies to implement targeted marketing campaigns by understanding diverse customer segments and purchasing behaviours. This project focused on identifying customer value, shopping patterns, and product popularity.
Solution: My approach involved analysing millions of Instacart orders and customer demographic data using Python (Pandas, NumPy, Matplotlib, Seaborn) in Jupyter Notebook. I conducted extensive data wrangling, cleaning, and variable derivation across multiple merged datasets to ensure data integrity. I then utilised descriptive statistics, frequency analysis, and various visualizations to uncover critical insights into customer loyalty, regional ordering habits, and demographic correlations, identifying high-value customer segments, peak shopping times, and popular product departments.
Conclusion: Data-backed recommendations were provided to Instacart stakeholders. These recommendations focused on optimising ad scheduling, tailoring product promotions based on spending patterns, and segmenting customers for highly targeted marketing campaigns, aiming to increase sales effectiveness and customer engagement.
Solution: My approach involved analysing millions of Instacart orders and customer demographic data using Python (Pandas, NumPy, Matplotlib, Seaborn) in Jupyter Notebook. I conducted extensive data wrangling, cleaning, and variable derivation across multiple merged datasets to ensure data integrity. I then utilised descriptive statistics, frequency analysis, and various visualizations to uncover critical insights into customer loyalty, regional ordering habits, and demographic correlations, identifying high-value customer segments, peak shopping times, and popular product departments.
Conclusion: Data-backed recommendations were provided to Instacart stakeholders. These recommendations focused on optimising ad scheduling, tailoring product promotions based on spending patterns, and segmenting customers for highly targeted marketing campaigns, aiming to increase sales effectiveness and customer engagement.
Rockbuster | Online Video Launch Strategy
Project Description: Rockbuster Stealth, a traditional movie rental company, aimed to strategically transition to an online video rental service amidst competition. This required data-driven insights into customer behaviour and what drives revenue.
Solution: I Dd multiple SQL queries using PostgreSQL to build a relational database. This included joins, subqueries, and Common Table Expressions (CTEs), on film inventory, customer, and payment data to address critical business questions. Insights were drawn on revenue contributions by movie, average rental durations, along with the geographic distribution of customers. High lifetime value customers and regional sales patterns were identified.
Conclusion: Data-driven recommendations supported Rockbuster's market entry strategy for its online streaming service. This enabled informed content acquisition, targeted marketing campaigns for high-value customers, and regional sales optimisation aimed at boosting initial subscriptions and maximising revenue.
Solution: I Dd multiple SQL queries using PostgreSQL to build a relational database. This included joins, subqueries, and Common Table Expressions (CTEs), on film inventory, customer, and payment data to address critical business questions. Insights were drawn on revenue contributions by movie, average rental durations, along with the geographic distribution of customers. High lifetime value customers and regional sales patterns were identified.
Conclusion: Data-driven recommendations supported Rockbuster's market entry strategy for its online streaming service. This enabled informed content acquisition, targeted marketing campaigns for high-value customers, and regional sales optimisation aimed at boosting initial subscriptions and maximising revenue.
Influenza Season Planning | Staffing Optimisation
Project Description: A medical staffing agency needed a data-driven strategy to effectively distribute temporary medical personnel to clinics and hospitals across the United States during influenza season, aiming to prevent understaffing and overstaffing.
Solution: An end-to-end data analysis was conducted. This involved integrating US population data from the US Census Bureau with flu mortality records and laboratory test results from CDC FluView. The aim was to identify high-risk states, vulnerable populations, and seasonal peaks. Data cleaning, transformation, and integration were accurately performed and statistical analysis and hypothesis testing were used to determine influenza seasonality and regional variations. I then categorised states into low-, medium-, and high-need based on vulnerable populations.
Conclusion: My analysis resulted in a comprehensive, data-backed staffing plan and an interactive Tableau dashboard, enabling optimal resource allocation. This was projected to reduce instances of understaffing and overstaffing and enhance the agency's ability to meet patient demand during flu season effectively.
Solution: An end-to-end data analysis was conducted. This involved integrating US population data from the US Census Bureau with flu mortality records and laboratory test results from CDC FluView. The aim was to identify high-risk states, vulnerable populations, and seasonal peaks. Data cleaning, transformation, and integration were accurately performed and statistical analysis and hypothesis testing were used to determine influenza seasonality and regional variations. I then categorised states into low-, medium-, and high-need based on vulnerable populations.
Conclusion: My analysis resulted in a comprehensive, data-backed staffing plan and an interactive Tableau dashboard, enabling optimal resource allocation. This was projected to reduce instances of understaffing and overstaffing and enhance the agency's ability to meet patient demand during flu season effectively.
Global Bank | Customer Retention & Investment Strategy
Project Description: A global bank needed advanced analytical support for its anti-money laundering (AML) compliance department, focusing on client/transaction risk assessment, model optimisation, and mitigating ethical data dilemmas while also understanding customer retention.
Solution: I provided analytical support to improve client and transaction risk assessment strategies and to optimise various compliance models. Decision tree models were developed to pinpoint key customer churn predictors, which helped enable proactive retention strategies. Rigorous distribution analysis was also conducted, intended to detect and address bias in fraud detection models, thereby improving model fairness and accuracy. Time-series analysis and forecasting techniques were applied to analyse complex financial data, including oil prices, to inform strategic investment decisions. I also navigated data ethics by identifying potential biases, as well as ethical dilemmas, within financial datasets to enable responsible consumption of data and related reporting.
Conclusion: This project delivered data-driven insights and model optimisations that enhanced the bank's ability to assess fraud and churn risk. It also informed strategic investment decisions, strengthening the overall efficiency and ethical integrity of the AML compliance programme.
Solution: I provided analytical support to improve client and transaction risk assessment strategies and to optimise various compliance models. Decision tree models were developed to pinpoint key customer churn predictors, which helped enable proactive retention strategies. Rigorous distribution analysis was also conducted, intended to detect and address bias in fraud detection models, thereby improving model fairness and accuracy. Time-series analysis and forecasting techniques were applied to analyse complex financial data, including oil prices, to inform strategic investment decisions. I also navigated data ethics by identifying potential biases, as well as ethical dilemmas, within financial datasets to enable responsible consumption of data and related reporting.
Conclusion: This project delivered data-driven insights and model optimisations that enhanced the bank's ability to assess fraud and churn risk. It also informed strategic investment decisions, strengthening the overall efficiency and ethical integrity of the AML compliance programme.
GameCo | Marketing Budget Planning
Project Description: GameCo, a new video game company, needed data-driven insights to inform game development strategy and optimise marketing budget allocation across various genres and global markets.
Solution: My approach involved performing a descriptive analysis of 16,000 video games (from 1980–2016), covering 12 genres and multiple platforms. I used Excel for data cleaning, pivot tables, and grouping/summarizing data. This work helped identify genre popularity, regional market shifts, and competitor performance over time, challenging initial assumptions about equal budget distribution.
Conclusion: Strategic recommendations were provided to GameCo executives focused on optimising marketing budget allocation. This involved advocating for region-specific and genre-specific investment strategies, projected to increase marketing ROI and inform future game development decisions.
Solution: My approach involved performing a descriptive analysis of 16,000 video games (from 1980–2016), covering 12 genres and multiple platforms. I used Excel for data cleaning, pivot tables, and grouping/summarizing data. This work helped identify genre popularity, regional market shifts, and competitor performance over time, challenging initial assumptions about equal budget distribution.
Conclusion: Strategic recommendations were provided to GameCo executives focused on optimising marketing budget allocation. This involved advocating for region-specific and genre-specific investment strategies, projected to increase marketing ROI and inform future game development decisions.
Education & Certifications
Degrees:
Certifications:
- International Master in Global Luxury Goods & Services Management | MIP Politecnico di Milano
- Master’s Degree in Chemistry | Maharshi Dayanand University
- Bachelor’s Degree in Chemistry | University of Delhi
Certifications:
- Professional Certificate in Data Analytics | CareerFoundry
- Claude 101 | Anthropic
- AI Bootcamp Certification | GrowthSchool
- Six Sigma Green Belt Certification | AIGPE
My Content
Get in touch
Book a call with me to know more about my story.
Built with Unimad