Lokesh Ramamurthy
Information Officer · Unilever Industries Pvt. Ltd
Bangalore, KAWork Experience
Information Officer
Unilever Industries Pvt. Ltd2016 – Present
Job Profile: Project and management for various functions
Projects Handled Process: NRM (Net Revenue Management) Key Role: Data Blending & Analytics Tools Used: Alteryx, Excel & Nielsen Process Details: • NRM deals with Unilever's revenue management, pricing, distribution strategies and managing promotions with retailers. • Was required to use tools such as Nielsen's full range of customer management suite and Alteryx for blending the data. • The information was used for reporting to key high-level stakeholders and as a result managed key client relationships as well.
Process: Media Analytics and Distribution Optimization Key Role: Data Blending, Automation and Analytics Tools Used: Alteryx, Excel & Nielsen Process Details: • Handled 2 projects - Distribution Optimization and Media Analytics - where I automated an entire manual process with large number of formulas and calculations. • Used Alteryx to blend the data and applied automation for a seamless output in PowerBI. • This project helped me improve my skills in project management, process optimization, data management and governance.
Process: Livewire Key Role: Analytics and Brand Reporting Tools Used: Alteryx, Excel & Nielsen Process Details: • Project Livewire was a high-level brand reporting platform for senior management. The project assessed brand performance and marketing milestones for UL's India business. • Dealt with brand performance and marketing KPIs • Was required to handle different levels of data structures from channels and distribution information for both rural and urban markets.
Process: IMS (Media & Retail) Key Role: Data management, Market mix modelling Tools Used: Mindshare Reporting, Media Spends Information Process Details: • IMS (Information Management System) Media was a data management process that caters to the needs of an analytical process called Market Mix Modeling (MMM). • The procedure involved generating data from various sources and consolidating all types of media data to arrive at standard formats.
Process: Competitor Intelligence Key Role: Data management, External insights, communications Tools Used: MailChimp, Sharepoint Process Details: • Track all UL competitor activity, including marketing, financial reporting and campaign activity. • Managed apps and data for internal social media and information sharing tools such as salesforce for business • Develop reports for competitor benchmarking and industry trends
PROFESSIONAL EXPERIENCE (PREVIOUS COMPANY)