Ranjan Bharadwaj

• Supporting B2G ed-tech business GTM from learner acquization to
• Documented Use Cases and Use Case Models using MS Visio and Provided interpretive analyses, including associated/flowcharts diagrams
• Review all month end financial statements to ensure accurate financial reporting
• Performed TPC-C Oracle 10G RAC performance benchmark for NAS and SAN storage on Red Hat Enterprise Linux OS.

• Supporting all Departments ie Operations, Sales, and Marketing Partner Management with Analytics

• Complete end-to-end reporting and dashboarding.

• Creating models ie Incentive models, and Lead allocation model

• Day-to-day analysis of strategic decision

• Provide Automation solutions using VBA & R

• Taking training sessions for the Global team over Excel, Salesforce & Business.

• Supporting 14 Countries in terms of reporting and Ad hoc analysis

• Working on fraud prevention, promotional campaigns, customer profiling, revenue leakage, and revenue & Occupancy prediction projects

• Day-to-day Delta analysis and sharing key insights around them

• Created a model highlighting exceeding burns budgets and triggering it against each campaign.

• Created a model to predict month-end revenue which helps to push levers timely

FMCG Category April 2017 – Feb 2019

• Responsible for pricing, conversion, and net margin optimization (80 Cr monthly Revenue)

• Worked on campaigns to lead conversions, retention, lapser to repeat users , funnel improvement projects

• Worked on Demand planning, supply planning, supply deconcentration, regional supply & seasonal demands project which leaded to 12% reduction in logistics cost.

• Responsible for creating brand monetized wire frame at category property which leads to high revenue addition through paid slots

• Responsible category reporting, Return rate and delivery tats analysis , inventory liquidation plans

• Responsible for creating customer segments for different user traffic platforms.

• Worked on cross-categories, product affinity, discounting experiments, and customer profiling projects with central teams.

Customer support Analytics Aug 2015 – March 2017

• Responsible for audit sample methodology basis past trend customer cases issue buckets

• Analyzing case life cycle using salesforce CRM and share key defects with resolution SOP to share the resolution time.

• Analyzing case life cycle using salesforce CRM and share key defects with resolution SOP to sharing the resolution time

• Worked with the Salesforce integration team to reduce the case life cycle considering the existing process.

• Worked over cases hopping projects to optimize the partner’s manpower cost

Customer support Operation Aug 2014 – July 2015

• Audit the resolution given to customers through the mail.

• Update SOP after analyzing the defect with audit

• Organized weekly workshops for low-scoring agents with key insights to improve performance.