Somil Manke

• Revenue:

- Played a pivotal role in delivering essential analytics crucial for the formulation of the Annual Price Increase strategy

- Spearheaded the Annual Price Increase automation project, streamlining the generation of 1000+ rate cards saving 6 days of manual effort. (Python, NLP, VBA Macros)

- Conducted customer Attrition analysis, quantifying the Revenue Impact of Attrition, segmenting data by Product and Customer Profiles, and performing root cause analysis. (Advanced Excel, SAP, Hyperion, Python, PowerBI, Dataiku)

- Built a Revenue Bridge model to assess the effects of New Revenue, Price Increase, and Volume volatility. (Python, SAP, Hyperion, Dataiku)

- Led the transformation of Partner Revenue reporting from manual to an automated BI dashboard, providing deeper insights. (PowerBI, SAP, Python)

- Developed a revenue forecasting model, incorporating Invoiced, Deferred, and Catchup revenue streams. (Hyperion, SAP, Python, MS Access)

- Examined the Market's influence on revenue through macro-level analysis incorporating factors of Fannie Mortgage Market rates, and interest rates. (Python, Dataiku, PowerBI)

• Cost:

- Designed a comprehensive HC (Headcount) dashboard utilized directly by CFO and VPs for active, open, and terminated HC tracking, enhancing resource planning. (Dataiku, Python, PowerBI, Workday, Hyperion)

- Conducted a thorough analysis of T&E (Travel and Entertainment) discretionary spending and tracked utilization against budget, assisting leadership in making informed spending decisions. (PowerBI, Hyperion)

- Created a Cost-per-unit analysis, categorizing it by locations and teams, enabling potential cost-saving opportunities and enhanced resource planning. (PowerBI, Excel)

- Executed a cost impact analysis for volume migrations between teams and vendors. (PowerBI, Excel)

- Automated Operations volume reporting, saving over 10 hours of manual work. (PowerBI, Excel)

- Automated vendor cost analysis, improving efficiency and enabling accurate vendor cost metrics during Month-end close and Budget cycles. (NLP, Python, PowerBI)

• Sales:

- Driving a business-critical sales forecasting project, developing a more scientific methodology using statistical models for accurate sales forecasting and comprehensive pipeline analytics. (Statistical modeling, Python, SQL, Dataiku, Time-series forecasting, PowerBI, Salesforce)

• Led and participated in 8+ CSR & DEIB initiatives, impacting 4000+. Awarded with the Global Sustainability award.

• Worked collaboratively with Thai students on a research project to develop a blockchain-based supply-chain management system for organic food commodities. (Python, Flutter, Blockchain)
• Streamlined the process of the organic food supply chain by improving the transparency and traceability of commodities using blockchain.

• Successfully simulated building models and generated reports by calculating the impact of cooling loads in Tokyo. (IES-VE, Python)
• Researched on green building certifications & standardizations
• Successfully tested and debugged the auto-simulator on build.btrlyf website.

• Analyzed quantitative and qualitative business data of over 25 local offices in India to develop a strategy capable of improving the conversion rate. (Excel, Tableau)
• Conducted insightful analysis to investigate ongoing or one-time operational issues and identify loopholes.
• Maintained the operational database for local committees across India for effective tracking and analysis. (Excel)

• Successfully delivered services to customers and partners by leading a team of 4 individuals all from diverse backgrounds.
• Established strategic partnerships with universities, hosted attraction events, and conducted Information Seminars in colleges and events.
• Mentored and trained members about the product in terms of front office sales, SWOT Analysis, creating and maintaining lead database, drafting partnership emails etc.

CGPA: 8.23

Specialization: Business Analytics

Activities:

• Head of Projects at Revolution Software Club
• Head of Projects at Atom Robotics Club
• Senior Member Virtual Energy Audit Project