RANMI AWOLIYI
Calgary,Canada
Summary
With extensive experience as a Business Strategist, I've honed my ability to leverage data to drive strategic business outcomes. My proficiency in data analysis, modeling, and reporting has enabled me to extract critical insights, enhance marketing campaigns, and refine strategies for a diverse range of organizations. Over more than a decade in the industry, I have developed the technical expertise and business acumen necessary to build and sustain robust data infrastructures, create compelling data visualizations, and deliver actionable recommendations to key stakeholders. Known for my meticulous attention to detail, ability to juggle multiple priorities, and commitment to excellence, I consistently strive to achieve high-quality results.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Research Analyst
CITY OF CALGARY
07.2023 - Current
- Develop and execute strategic initiatives in alignment with Council and administrative objectives, driving significant advancements within the business unit.
- Compile complex data into user-friendly dashboards, summaries, and comprehensive reports for diverse audiences, including Senior Administration, Council, and leadership teams.
- Conduct extensive research and analysis to identify service trends, gaps, and opportunities, providing data-driven insights to inform decision-making.
- Prepare comprehensive presentations to summarize findings from research projects.
- Build and maintain strong relationships with internal teams and external partners to facilitate collaboration and achieve strategic objectives.
- Present findings to management and executive leadership and fielded questions to help refine strategies.
- Actively participate in business-unit and cross-corporate committees and community-based initiatives, contributing valuable research insights and expertise.
Data Analyst
TELUS
07.2021 - 06.2023
- Produced monthly reports using advanced Excel spreadsheet functions
- Developed and maintained data models, dashboards, and visualizations using various tools to effectively communicate business insights
- Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users
- Used statistical methods to analyze data and generate useful business reports
- Collaborated with business-unit leaders and cross functional teams to identify and prioritize problems
- Conducted quality control checks on data to ensure accuracy and consistency
- Built operational reporting in Power BI to find areas of improvement for contractors resulting in $150k in annual incremental revenue
- Created, Conducted and Analyzed surveys to get information and insights to make business decisions
- Identified revenue and cost savings opportunities by uncovering actionable insights from internal & 3rd party data
- Led design and implementation of multi-layered customer segmentation models, both descriptive and predictive
- Actively promoted & participated in cross-sharing knowledge and solving business problems across functional teams.
Sales Operations Data Analyst
COCA-COLA
02.2017 - 05.2021
- Utilized analytics and insights to drive business growth, improve return on investment, grow profitability, increase customer service, and identify category development opportunities
- Conducted financial analysis on return on Investment of Go to Market (GTM) process, shared with key stakeholders, and put control system in place to get region compliance on route coverage
- Analyzed and resolved work problems by developing leading-edge RTM programs and ensuring appropriate controls and reporting tools. This boosted successful sales efforts by 12%
- Built out data and reporting infrastructure from ground up using excel to provide real-time insights into Distributor's pulse survey, marketing funnels, and business KPIs.
- Applied Customer Relationship Management, SAP analytical tools, and methods to inform business decision-making processes.
- Analyzed data related to business and revenue growth and product usage to identify opportunities for regional and national business teams.
- Contacted clients proactively to identify potential client needs and identified opportunities for business relationships.
- Engaged personal and business clients daily to understand their immediate and future needs and provided advise based on recommendations.
- Monitored and analyzed sales and revenue performances of retail and commercial banking business leaders to identify root cause analysis to declined activities.
- Resolved client problems promptly and/or refer to colleagues when necessary.
- Advanced expertise and skills in applying industry-leading analytics tools (SAS, Python, R, SQL, etc.) to manage, query, manipulate and analyze retail and enterprise customer data sets.
Business Intelligence Analyst
COCA-COLA
10.2012 - 02.2017
- Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence
- Designed customized data collection models for specific visualization tasks
- Collected data from wide-ranging sources
- Developed intelligence-sharing dashboards, providing company-wide access to collected data
- Gathered and analyze procurement data using data collection techniques for variety of uses such as key metrics reporting to Senior Management, developing annual business plan, identifying supply chain inefficiencies, strategy development, supplier evaluation, and negotiation
- Worked with the team to develop predictive models to improve forecasting accuracy
- Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement
- Analyzed key aspects of business to evaluate factors driving results and summarized into presentations
- Conducted interviews with key business users to collect information on business processes and user requirements
- Improved business direction by prioritizing customers and implementing changes based on collected feedback
- Delivered analysis of market, sales and consumer trend impact on long and short-term strategies
- Interacted with internal customers to understand business needs and translate into requirements and project scope.
Customer Insight Analyst
FINBANK
10.2010 - 09.2012
- Turned raw data into insights, recommendations, dashboards, and reports to provide reporting and analytics services and proactively support business decisions and processes
- Manipulated data across multiple data sources using SQL and advanced Excel tools (VLOOKUP, SUMIFS) to track trends, identify key drivers of various consumer behaviors, and develop recommendations to support key actions
- Analyzed feedbacks and surveys of customers who had negative experience for re-engagement purposes
- Minimized customer churn rates by analyzing data and building Predictive models using IBM SPSS Modeler to predict customer churn, understand influencers, and develop strategies such as tailored and personalized offers
- Increased customer engagement and loyalty for the retail banking division by executing Customer Value Segmentation using Recency, Frequency, Monetary (RFM) models, analyzing Segment contribution, and developing and implementing effective strategies.
Education
Economics (BSc) -
Covenant University
Skills
- Data Cleaning and Quality Assurance
- Data Warehousing
- Analytical problem solving
- Advanced Excel
- Power Query
- Strong Story telling skills
- Data Mining and Visualization
- Data Analysis
- SQL
- Python Programming
- Agile Methodologies
- Effective Communication
- Time Management
- Creative Thinking
- Problem Solving
- Critical Thinking
- Presentation
- Collaboration
- Leadership
- Attention to detail
- Azure Data Studio
- Power BI
- Tableau
- Microsoft Excel
- Jupyter Notebook
- Strategic Partnerships
- Customer Segmentation
- Stakeholder Management
Certification
- IBM Data Analyst Professional
- Project Management Professional (PMP)
- Certified Business Analyst (CBAP)
Timeline
Research Analyst
CITY OF CALGARY
07.2023 - Current
Data Analyst
TELUS
07.2021 - 06.2023
Sales Operations Data Analyst
COCA-COLA
02.2017 - 05.2021
Business Intelligence Analyst
COCA-COLA
10.2012 - 02.2017
Customer Insight Analyst
FINBANK
10.2010 - 09.2012
Economics (BSc) -
Covenant University
Similar Profiles
Meet SevakMeet Sevak
IT Developer at City of CalgaryIT Developer at City of Calgary
JOSH BOEHMJOSH BOEHM
Golf Pro Shop Employee at City Of CalgaryGolf Pro Shop Employee at City Of Calgary
Arpad JuhaszArpad Juhasz
Transit Bus Driver at City of CalgaryTransit Bus Driver at City of Calgary
Harley WoychyshynHarley Woychyshyn
Automotive Technician at City of CalgaryAutomotive Technician at City of Calgary
Craig DicksonCraig Dickson
Heavy Equipment Technician at Element Technical ServicesHeavy Equipment Technician at Element Technical Services