Ujjvala Hanumanthu

1.Optimized a standardized retention rate formula: Leveraged Salesforce CRM data across 10 datasets to identify key sponsor journey patterns and enhance retention insights using Power BI. 2.Analyzed sponsor behavior trends with running totals: Processed 10,000 rows of data using SQL and using running totals to capture patterns and produce KPIs through DAX. 3.Collaborated with business stakeholders: Delivered data-centric insights in alignment with budgeting, forecasting, and financial decision-making, using MS Excel and Power BI to fulfill strategic objectives. 4.Developed data models to analyze sponsorship patterns: Built clustering models and correlation analyses to determine key reasons for sponsorship drop-offs, identifying regions with similar retention patterns. 5.Conducted global pattern analysis: Analyzed dropout trends across different time periods globally and across six regions, applying Power BI DAX and machine learning models to detect and address retention challenges.

1.Engineered a comprehensive Power BI directory, reducing search time for campaign contact information by 99%. Consolidated 2 million rows from Salesforce and Definitive Healthcare datasets using Power Query, constructing data model with dynamic follow-up messaging using DAX and conditional formatting, streamlining the search process for non-tech users and leadership. 2.Integrated over 1 million End-of-life product records following HIPAA from Azure storage and Salesforce using advanced SQL, identifying new leads. 3. Resulted in a 20% reduction in excess inventory and a 15% improvement in product replacement timing, saving 500k annually in operational costs, contributing to a 30% improvement in systems lifecycle management.

Built 12+ Tableau and Power BI dashboards integrating POS and warehouse data, reducing excess inventory by 15% and saving $250K annually in holding costs. Conducted back-testing on historical sales and promotions data to uncover demand inconsistencies, improving forecast accuracy by 22% and raising service levels by 18%. Automated SQL-based inventory reconciliation across 5+ systems, cutting reporting time by 40% and eliminating $100K in discrepancies annually. Developed pricing and replenishment models using statistical analysis, reducing markdown losses by 12% and improving gross margins by $300K annually. Partnered with supply chain, finance, and marketing teams to streamline product launch inventory planning, cutting stockouts by 20% and supporting 25+ successful launches.

Optimized inventory replenishment strategies by analyzing SKU-level sales data, reducing stockouts by 22% and increasing product availability across 150+ retail locations. Built automated dashboards in Tableau and Excel to track sell-through rates, aging inventory, and demand variability, saving 10+ hours of manual reporting per week. Conducted EDA analysis on 5K+ product lines to identify slow-moving items, reducing excess stock by 15% and freeing up $200K in working capital. Collaborated with supply chain and marketing teams to align promotions with inventory forecasts, preventing overstock of seasonal products and cutting markdown losses by 12%. Designed SQL-based reporting to track vendor lead times and delivery performance, improving order accuracy and supplier reliability by 20%. Implemented safety stock and reorder point models, increasing forecast accuracy by 25% and minimizing disruptions in new product launches.

Produced and curated compelling content, including 140 captivating social media captions, to engage and inform audiences about upcoming events, occasions, announcements, and more. Authored 5 pages of content for the annual regional Rotaract magazine, showcasing a commitment to delivering high-quality, print-ready materials. Drafted and disseminated 50 meticulously crafted email communications across the university community, ensuring efficient and timely transmission of critical announcements and emergency updates. Collaborated closely with cross-functional teams to align content strategies with clubs goals, resulting in increased engagement and readership.

Event Management Leadership: Collaborated with a 30-member marketing team to plan, organize, and execute the successful grand inauguration of the innovation ecosystem. Oversaw all aspects, from content creatives to venue branding. Energized by the challenge, accomplished a 50% increase in event attendance and generated $100k in new businesses through leadership abilities in inaugurating a successful innovation ecosystem. Played a pivotal role in managing event planning, content creation, and venue branding, while implementing a data-driven social media strategy in Excel. Achieved a 20% reduction in costs and a 15% increase in overall event profitability by spearheading the creation of an interactive financial dashboard. Integrated data from various departments to provide real-time insights on event progress, optimizing resource allocation for enhanced financial efficiency. Strategic Event Mapping: Mapped out the event details meticulously, including content creatives, venue branding, and a comprehensive social media plan, all organized efficiently on spreadsheets. Venue Branding Expertise: Conducted extensive research for venue branding, partnering with a renowned event management agency. Gained insights into web design for booklets and digital standees, contributing to a visually appealing event. Content Creation: Crafted compelling content for key event materials, including a section of the booklet highlighting Hyderabad as the 'Entrepreneurial Capital of India.' Also, authored content for brochures showcasing successful startups nurtured by T-Hub as part of the 'Start-up Showcase' activity.

Effective Collaboration: Collaborated seamlessly with diverse departments and professors to curate research articles for the annual college magazine, fostering a culture of interdisciplinary engagement. Content Acquisition Campaigns: Strategically planned and executed campaigns to solicit articles, illustrations, and poems from students and faculty members, resulting in a diverse range of high-quality submissions. Proactive Outreach: Initiated and maintained email correspondence with various departments, nurturing valuable relationships to facilitate content acquisition and ensure timely submissions. Networking Proficiency: Demonstrated strong networking skills by actively engaging with college community members, raising awareness about the magazine's mission, and encouraging contributions to enhance both knowledge and recognition. Effective Communication: Visited classrooms to provide informative sessions about the magazine's purpose and benefits, effectively motivating students to participate, contribute, and broaden their intellectual horizons.