Manasi Karur Subramanian Email & Phone Number

Berlin, De

Berlin, Berlin, De

Berlin, Berlin, De

GP Alignment - Lead a team of 3 people along with whom collaborating across multiple departments to understand how/when the rates of each category are populated so as to plan the margin and compare it with the actual numbers. This helps the organization to have transparency of Margin and drill down on where the Margin is lostTop of Funnel overview – Built a robust system which combines data from different Marketing platforms like Google Analytics, Adwords, LinkedIn with the customer data in Salesforce to get the journey of the customer along with cost information to get information on spend tracking. This helped to get the Top of the funnel view for better conversion. Activity Feed analysis - Helped the Operations team in finding the turnaround time for messages sent by customers. Build dashboard which highlighted the questions raised by customers, unanswered messages thus increasing the efficiency of the team by 8%People & Culture - Responsible for guiding the People & culture team to track key metrics for performance analysisStandard dashboard - Helped the Key account management team to define the key metrics for customers and build dashboards to report the same on TableauBusiness control automation - Automated the process of sending updates to the manager if there are mismatches in the shipment and what action needs to be taken reducing the manual effort of 10 minutes per shipment to 1 minuteConducted self service analytical training for colleagues (Org wide) where they are trained on SQL and Data StudioMentoring a couple of team members on various projects including Key account management and Sustainability

San Mateo, California, Us

Digital Marketing● Affiliate marketing - Enhanced the affiliate marketing program run by Freshworks’ to increase the traffic routing via affiliates. Worked on building end to end system, coordinating between third party Affiliate network, to capture the leads along with the affiliate. Handled the payout to the partners/third party vendors.● Display and Video Ad Optimization (DV360 Ads) - Performed Campaign overlap, Reach and Frequency analysis to optimize campaigns. This came in handy to remove overlapping campaigns (targeting similar audience) to reduce cost and target audiences based on frequency of Ads● Affinity analysis – Helped the display Ads team to retarget/fine tune audiences targeted by capturing the affinity group of users and reported top affinities based on key metrics such as Clicks, Page visits, Signups, CTR. This came in handy for the campaign managers to cut down cost spent on unrelated affinity groupsMarketplace● Automated monthly refresh of the data to get insights on the total apps being installed by users, revenue generated by these apps, payout for App host. This helped in customer retention thus reducing churn.● Categorized the best used apps across industry vertical to bundle up with product during new businessFreshmarketer/ Freshworks CRM - Product adoption metrics:Worked closely with the product team to understand the different product features and its adoption. This helped us in finding patterns for Customer retention. Analyzed and reported the new customers, their revenue, churn numbers, multi-product adoption, etc. With insights from this, helped the team to hit its first milestone - $1M revenue.

London, England, Gb

Recognitions: • ‘Lead’ a geographically distributed support team where system events were assessed, prioritized and managed. Worked with the team to design the system and plan the timelines accordingly

London, England, Gb

Channel Analytics – Unilever (SQL, Microsoft BI stack, MS Excel, Tableau, Python)• Developed a framework to measure Volume, Value and Profitability measures across various channels. This provided transparency of org level metrics and helped the clients to view P&L measures for various channels• Presented the weekly/monthly updates to the SME on the system performance, capacity, and incident details• Drove additional new business by identifying and highlighting key issues that needed to be addressed by the client• Developed a tool to compare objects across environments using Python• Created dynamic dashboards using Tableau with multi-level drill down option across various channels• Worked on complex SQL queries involving self joins, correlated sub queries and indexing. Implemented stored procedures, functions & triggers to execute the required functionalities• Worked across multiple data sources across different formats. Built an Integration services package to load data from all these sources onto the database• Analyzed large data across different dimensions using cubes and smaller data using MS excel using functions such as VLOOKUP, Match & Index and pivot tables• Reduced manual dependency on file by automation, saving 8 man-hours/week

London, England, Gb

Net Revenue Management – Unilever (SQL, Microsoft BI stack, MS Excel, Tableau)• Created dashboards using Tableau which provides information about the net revenue of the system, the performance about a product in each Country-Market across different levers• Developed key relationship with clients and served as the single point of contact between client and offshore teams• Improved performance of the system by parallelizing data loads which lead to automated, frequent refresh of the Tableau dashboards for easier client analysis• Automated the process of loading files, saving up to 40% overall time, and created solution to ignore archiving multiple version of the file, thus eliminated space constraints within the server• Gathered requirements and designed the system to automatically load & aggregate data from various sources • Single point of contact on the key technical areas for business owners• Optimized the overall end to end tasks involved in the project – saved 16 hours/weekShopper Insights – Unilever (SQL, Microsoft BI stack, MS Excel, Power BI, Numerator)• Analyzed shopper characteristics using Power BI dashboards which provides insights of different metrics such as penetration, frequency. Created Quality analysis dashboards to perform the data quality checks of the client files• Worked on highlighting the preferences of the shopper across Segments and Channels. Analyzed competitors share across different channels and demographics. • Handled multiple data source/file structure for different countries• Automated the manual work of highlighting errors which in turn saved 40 hours/week

London, England, Gb

Channel Reporting, a project which allows the users and clients to view P&L Measures through Channel that drives the business. A Channel is a collection of outlets that share a range of physical / tangible & shopper based characteristics. Channel Reporting also involves measuring Volume, Value and Profitability measures by Channel.

Master Of Science (M.Sc.), Theoretical Computer Science

Education record