Rujuta Awate

Experience

• 

  Self-employed

  Jan 2013 - Jun 2023

  Indian Classical Dancer (Kathak)
• 

  Deloitte

  Aug 2013 - Mar 2017

  Worked on enhancements, integration and reports across Higher Education and Retail industries on Oracle ERPs & VBA Intrapreneurship and Innovation: Only analyst contributing towards ideation and development of an IP - Integrated Course Evaluation Framework - to arrest student dropout using survey feedback.• Conducted market research to aid problem statement formulation and solution design. Derived logic and KPIs to draw insights from raw datasets• Developed the solution on PeopleSoft Campus Solution Platform Show less • Independently developed 15+ ad-hoc reports using SQL and Oracle BI publisher for a Canadian Higher Education Client• Customization of hiring workflow process to reduce time to hire for a US based Fortune 500 client in retail industry• Developed voucher upload functionality for clients’ vendors using integration between web services and Oracle ERP • Conceptualized & developed VBA solution to streamline document review & approval process; Saved 30% project time • Led automation of sales pursuit estimation, staffing & service offerings in VBA • Automated performance evaluation process using VBA for S&O practice Show less

  • Consultant

    Sept 2016 - Mar 2017

  • Business Technology Analyst

    Aug 2013 - Aug 2016
• 

  Capillary Technologies

  Jun 2018 - Jan 2020

  Focused on driving growth and improving business performance for clients by drawing problem statements and insights by analyzing consumer data. Led annual portfolio worth $2.5M comprising of 16 brands including a $1.6B retail groupSkillset gained across:Data Analytics | Leadership | Client Management | Strategy Design | Business Development | BudgetingLeadership & Client Relationship Management:• Led an aspiring team of 7 Account Managers & 4 Business analysts to drive business while reporting directly to leadership • Built partnership with client’s marketing & CRM team along with C-suite leaders to ensure healthy Net Promoter ScoreStrategy & Analytics: Perform descriptive, predictive and prescriptive type of data analysis to achieve organic growth for clients.• Investigated data to drew insights and devise strategies to design and implement segmented A/B tested marketing campaigns • Analyzed customer data and developed KPI to increase retention, basket size and/or ticket size across channels. Improved retention rate to achieve 3% incremental ($200K) revenue over 3 months by using churn modeling• Redesigned loyalty program for a leading footwear brand which has over 500 stores spread across top cities in India• Addressed key challenges by interpreting results of clustering, classification and fraud detection models• Successful storyboarding using historical data which resulted in additional annual business worth $50K• Helped client identify and target the low hanging stores to achieve targeted sales growth using classification and fraud detection modelsBusiness Development:• Generated 12% yearly incremental revenue by upselling and cross-selling products and service offerings• Initiated streamlining of collections processes by liaising with global leaders. Improved collections from 65% to 87% Profit and Loss Statement (P&L): • Led strategic contract negotiations and effective resource allocation; Achieved 10% profitability for my portfolio Show less Responsible for end to end planning & agile implementation of Digital Transformation engagements for CPG & retail clients Skillset gained across:Agile Mindset | Project Management & Execution | Cross-function collaboration | Process Improvement: • Led foundation of agile methodology for India - PM team. Iteratively set processes and planned cross functional training• Conducted discovery sessions with clients to gather requirements and derived & prioritized user stories to plan iterations. Directed weekly cycles for status reporting and tracking issues while communicating responsibility matrix• Effective resource and task allocation along with retrospective sessions helped achieve 10% profitability in $1M portfolio• Re-engineered & automated business processes. Reduced supply chain lead time by 86% for a CPG client by developing a mobile order application which provided a live view of its retailers & distributor’s inventory• Designed lead funneling system & workflow for a Fortune 500 Healthcare company; reduced sales cycle by 80%• Led deployment of an e-commerce system for a B2B client with $3B revenue; Increased breadth of purchased products by 30%• Aided product team to define product feature enhancement roadmap; Participated in sprint planning, showcase, retrospectives and backlog refinement; provided user stories and acceptance criteria along with customer feedback Show less

  • Engagement Manager ( Analytics and Operations)

    Nov 2018 - Jan 2020

  • Project Manager

    Jun 2018 - Nov 2018
• 

  Scotiabank

  Oct 2020 - Feb 2021

  Business Analyst
• 

  TELUS

  Feb 2021 - Jun 2021

  Senior Business Analyst

  • Developed Data Pipeline for periodic report generation for B2B business in the SAS platform. • Impacted bottom line by performing ad-hoc data analysis to solve operational and billing data-related challenges• Developed Data models to integrate data sources to better profile customers and customize offerings

• 

  Deloitte

  Jun 2021 - Jul 2023

  Senior Consultant

  • Data Analytics: Developed machine learning models and conducted in-depth data analysis to generate insights using tools such as Python, Tableau, Alteryx, and advanced Excel. Delivered client reports with actionable recommendations• Innovation and Business Development: Conceptualized and Designed new analytics-driven solutions while supporting the business development activities• Digital Transformation and Project Management: Conducted strategic and operational workshops with client’s executives to understand the current state and designed future state by leveraging frameworks and best practices Show less

• 

  Women in AI

  Nov 2023 - now

  Volunteer
• 

  SAWITRI Theatre Group

  Feb 2024 - Jun 2024

  Lead Actress - Theatre | Recreational Endeavor

  Lead Actress for 'The Day of Confession' play as part of MarathiShorts; Featuring on April 13 and 14-

• 

  Tiger Analytics

  Jun 2024 - now

  Manager - Analytics Consulting