
Rohan Bohra

Connect with Rohan Bohra to Send Message
Connect
Connect with Rohan Bohra to Send Message
ConnectTimeline
About me
Senior Analyst specializing in Statistical Analysis at Salesforce with expertise in Data Visualization A23 Games | Nomura | PwC - Management Consulting | ABG | BITS Pilani
Education

Birla Institute of Technology and Science, Pilani - Goa Campus
2017 - 2022B.E. Chemical EngineeringActivities and Societies: PMP, BITS Pilani DePP. Backstage, DoCW, DoSM
Experience

Department of Publicity & Public Relations , BITS Pilani Goa Campus
Aug 2017 - Apr 2020•Led a 3-tier team of 130 associates to generate total revenue of over 40 Lakhs for the annual sports fest through enhanced marketing and record participation.•Achieved 200% YOY increase in participation and 80% increase in the revenue generated by establishing a college relationship team of 50+ members.•Responsible for Brand Management and Marketing of all the major fests of BITS Goa (Waves, Quark and Spree) with a total budget of over 1 Crore.•Targeted audience through social media platforms; Generated 10,000+ impressions in 1 year.•Conceptualized executed and supervised overall management of two new national events. Show less
Public Relations Coordinator
Apr 2019 - Apr 2020Core Member
Apr 2018 - Apr 2019Crew Member
Aug 2017 - Apr 2018

Peer Mentorship Program, BITS Goa
Aug 2019 - Apr 2020Chief Coordinator•Led a team of 130+ mentors by comprehensive support services and oversight for 900+ students.•Implemented anonymity in the Anti-Ragging Committee and Anti-Harassment Committee to increase feedback/complaints raised by 20%.•Executed the implementation of intensive academic training for students in the academic counseling board decreasing ACB cases.•Increased efficiency by acting as the link between students body and administration.•Conceptualized mentorship programs in sister campuses due to proven high impact. Show less

Airmeet
Sept 2020 - Oct 2020International Growth Manager- Led MoM inc. of 10% in clientele by identifying key prospects, mapping requirements resulting in nurtured relationships- Revived 20% of the inactive user-base & enhanced their engagement through trend analysis & journey personalization

PwC India
Aug 2021 - Dec 2021Management Consultant-Formalized a plan for MoPNG to reduce import dependency of India by 10% on crude oil & natural gas by suggesting policy interventions-Only intern to lead program management of GCPMH India@75 Chemicals and Petrochemicals Industry Awards'21 held by FICCI-Developed a parametric framework to identify & recommend the winner for different Industry awards across multiple categories-Formulated a Strategic Business Plan to set up a petrochemical complex for one of the largest petrochemical company in India-Conducted a deep dive market study to recommend new products in synergy with the core competency of a client Show less

Nomura Asset Management
Jan 2022 - Jun 2022Program Management Trainee- Developed Excel models with VBA automation and utilized Power BI dashboards to present comprehensive monthly-level resource allocation reports to Senior stakeholders; Optimized implementation time by 40%- Collobarated with external Rating agencies to optimize Nomura’s ESG rating system for internal evaluation of projects- Implemented internal processes to ensure seamless project execution, shielding future initiatives from past pitfalls

Head Digital Works
Jul 2022 - Nov 2023Business Analyst-Working in the Product, Automation & Strategy team under Retention & Loyalty division (Marketing).-As a Business Analyst, I retrieve and analyze large data sets to generate actionable insights aimed at enhancing user retention on A23 apps. I make data-driven decisions, evaluate the effectiveness and ROI of campaigns and notifications, and summarize the findings into concise dashboards using the tools like MSTR & CT-Developed monthly budget and retention strategy for user engagement, incorporating user campaigns across monetary value, player activity & geography; Campaign budgeted 5 Cr. monthly, contributed 5% higher retention & 2% in revenue-Reduced manual intervention for periodic campaigns based on journey automation using analytical tools like CleverTap, designed dashboarding for efficient tracking using tools like Microstrategy; Reduced analysis time by 25%-Optimized spends by ~60k daily on reactivated users by replanning D0 to D15 journey, Achieved MoM growth of 5% in number of reactivated users with an enhanced revenue-to-spend ratio Show less

Salesforce
Nov 2023 - nowSenior AnalystAt Salesforce, our team employs statistical analysis and meticulous attention to detail to elevate customer retention strategies.-Automated and optimized a weekly forecasting process, delivering a consolidated view of high-risk attrition deals to CXO-level stakeholders, significantly enhancing executive decision-making and reporting accuracy-Created a Tableau dashboard to track weekly account changes, automating workflows to save 10+ hours per week & providing senior stakeholders with actionable insights for improved decision-making and attrition management-Assisted in a strategic discount reduction initiative, increasing profit margins and contributing to $200M in revenue growth by eliminating repetitive discounts through cross-team collaboration-Successfully minimized bounce rates by 11% and increased user engagement by 5% through tracking user journeys and analyzing data with Google Analytics and Looker Show less
Licenses & Certifications

MS-Excel Beginner to Advance
UdemyApr 2020- View certificate

Jira: Basic Administration
LinkedInNov 2021 - View certificate

Excel: Creating a Basic Dashboard
LinkedInNov 2021 - View certificate

SQL for Non-Programmers
LinkedInNov 2021 - View certificate

Becoming a Six Sigma Green Belt
LinkedInDec 2021 - View certificate

How to Manage Lean Six Sigma Projects: Part I
LinkedInNov 2021 - View certificate

SQL Essential Training
LinkedInOct 2021 - View certificate

Excel for Banking Professionals
LinkedInOct 2021 - View certificate

Corporate Financial Statement Analysis
LinkedInOct 2021 - View certificate

Learning Excel: Data Analysis
LinkedInOct 2021 - View certificate

Sales: Handling Objections
LinkedInOct 2021 - View certificate

Learning Jira Software
LinkedInNov 2021
Recommendations

Siddhessh gadkar
Omnik ltdMumbai, Maharashtra, India
Charlotte verhoeven
Student Rechtsgeleerdheid aan de Universiteit UtrechtUtrecht, Utrecht, Netherlands
German herrera
Director General Tierra BravaBarcelona, Catalonia, Spain
Suzanne gallagher
Office Manager at RM Plumbing & Gas ServicesBishopbriggs, Scotland, United Kingdom
John mathias
Administrative Services Coordinator, Office of Professional Education at University of Iowa College ...Iowa City, Iowa, United States
Gafar osman
Sales | Marketingالقاهرة مصر
Said zaky, pmp
Semiconductor & Electronic Components Supply Chain & Engineering Services, Sr. ManagerCairo, Egypt
Mohamed sherif
Devops EngineerCairo, Egypt
Amr khaled, pmp®
Telecom Project Manager at MobilyAl Khobar, Eastern, Saudi Arabia
Jefferson luis
Contábil / IFRS / ControladoriaSão Paulo, São Paulo, Brazil
Elaine manley
Design Historian | Museum Professional | Graphic DesignerDublin, County Dublin, Ireland
Stephanie rowe
Front End Developer | React.js, Next.js, HTML, CSS & JavaScript | PMP®Toronto, Ontario, Canada
Dominga ciavarella
Key Account Pharmacy Channel [ comfort zone ]Italia
Kunle olorunkoya
Electrical/Electronic Field Engineer, Technologist, Designer, Researcher, Installer, Supervisor, Mai...Nigeria
Manisha sharma
Associate engineerLos Angeles, California, United States
Emerson xavier
Bacharel em Publicidade e Propaganda | MarketingItapecerica da Serra, São Paulo, Brasilien
Svein willassen
CEO, Kvikna ASOslo, Oslo, Norway
Ali öztırpan
Software DeveloperIstanbul, Istanbul, Türkiye
Christine wlosinski
--Alpena, Michigan, United States
Mohammed abdalmaksood
Electrical Manager at Hyde Park DevelopmentEgypt
...