Hi! I'm Rohan Ranshinge
Join me as I share my journey on all things analytics
Who am I? (officially)
I'm an analytics professional with over 8 years of experience in Business Intelligence and analytics.
I love working in a fast-paced and deadline driven environment. I have experience in SQL, R, Python and Tableau and enjoy making visualizations and telling stories using data.
Who am I? (unofficially)
A huge Rocky fan (Rocky 3 was the best movie). I love learning new things and am constantly trying to improve.
In my free time, I like to sketch, play guitar (I'm still a beginner) and read books. I love playing football (aka soccer) and tennis.
The only objective is to get a little bit better everyday.
I'm always down for a nice beer or coffee!
Blog
Experience
Marketing Analyst, Google
Aug 2022 - Present
Built a comprehensive reporting infrastructure and an exec dashboard from the ground up, for senior leadership to easily track and measure event effectiveness across and within regions and programs.
Enabled Sr Leadership to make improved budgeting decisions during quarterly reviews.
Created data pipelines using SQL and used custom macros to calculate event impact metrics, making it easier to highlight the most and least efficient events and reducing time spent in cleaning and analyzing the data by 80%
Identified and recommended solutions to fix segmentation issues in existing workflow improving accuracy by 25%
Sr Analyst, Home Depot
Sep 2019 - Aug 2022
Implemented Causal Impact algorithm (Python, R) to identify top-performing subscription items, informing a data driven dashboard that recommended 7.5K new product additions and contributed to a 40% YoY growth in subscriptions.
Created a tableau dashboard for the Online Pricing team that provided historical, intra and post-event performance. This was the first view providing visibility to YoY performance and helped save the team 55 hours of effort per event
Mentored an intern in the development of a diagnostic report of negative margin items, reasonings as to why an item is producing a negative margin, and how to action.
Conducted SQL training sessions for the Assortment Growth team enabling them to write production level code and improve overall productivity of the team
Data Analyst Intern, Institute of Transportation Studies
Sep 2018 - July 2019
The project focused on providing business expansion strategies for an electric vehicle (EV) charging provider in CA
Segmented customers on membership type, to identify trends and patterns in usage behavior using SQL and Tableau
Performed congestion analysis to identify stations with the highest market potential based on demand and utilization
Accolades
Invited to present at an EV conference attended by representatives from BMW, Toyota, Honda and Nissan
Data Analyst, Accenture
Aug 2016 - Mar 2018
Saved the project 5 hrs of manual intervention per restoration and the costs associated with it by automating a backup-restore activity using PowerShell scripts
Automated a sales report using SQL queries on retail databases saving the project 30 hours of manual intervention per month
Used SQL to query transactional DBs and troubleshoot issues occurring in dev/test and production environments