Ranmi Awoliyi
Business Intelligence Analyst
Calgary,AB
Summary
Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.
Overview
10
10
years of professional experience
6
6
years of post-secondary education
3
3
Certifications
Work History
Data Analyst
TELUS
Calgary, AB
07.2021 - Current
- Produced monthly reports using advanced Excel spreadsheet functions.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Utilized data visualization 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.
- Developed required policies and procedures that reflected actual goals, tasks and workflows, while meeting all regulatory compliance requirements.
- Collaborated with business-unit leaders to identify and prioritize problems.
- Worked with business intelligence software and various reports to glean insights into trends and prospects.
- Optimized data access and storage to improve performance of analytics systems.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Created dashboards to monitor and track key performance indicators.
- Provided technical support for troubleshooting analytics and reporting issues.
Business Intelligence Data Analyst
Coca-Cola
Nigeria, Lagos
02.2017 - 05.2021
- Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
- Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
- Designed customized data collection models for specific visualization tasks.
- Collected data from wide-ranging sources.
- Optimized BI reporting capabilities for secure server environment.
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
- Gathered and analyze procurement data using data collection techniques for a variety of uses such as key metrics reporting to Senior Management, developing the annual business plan, identifying supply chain inefficiencies, strategy development, supplier evaluation, and negotiation.
- Deployed predictive analytics models to forecast future trends.
- Identified patterns and trends in large data sets and provided actionable insights.
- Implemented business intelligence solutions to increase operational efficiency.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
Business Analyst
Coca-Cola
Nigeria, Lagos
02.2013 - 02.2017
- 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.
- Performed gap analysis to identify areas of improvement.
- Executed analysis of risks and identified risk mitigation strategies.
- Developed and maintained data warehouses and data marts to support business operations.
- Developed customized reports, summarizing and presenting data in visually appealing format.
- Collaborated with stakeholders to identify business needs and data sources.
- Created data models to support decision-making processes.
- Developed and implemented data governance policies and procedures.
- Identified patterns and trends in large data sets and provided actionable insights.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
Sales Operations Analyst
Coca-Cola
Nigeria, Lagos
10.2012 - 02.2013
- Utilized analytics and insights to drive business growth, improve return on investment, grow profitability, increase customer service, and identify category development opportunities.
- Maintained and continuously reviewed the company's dealer database and took advantage of all opportunities arising from our market's organic and inorganic growth.
- Conducted financial analysis on the return on Investment of the Go to Market (GTM) process, shared with key stakeholders, and put a 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.
- Monitored and reported on competitor activity (product, price, distribution, promotions) when in the field, to ensure fast and relevant responses by management and consistent competitive advantage.
- Built out the data and reporting infrastructure from the ground up using excel to provide real-time insights into Distributor's pulse survey, marketing funnels, and business KPIs.
- Ensured the Look of Success of all Execution KPIs. This included Scanning and Merchandising, drop sizes, outlet penetration, and brand penetration.
- Data Management and Design of Call concept and Frequency for the entire sales force to ensure that each sales team member meets individual goals, as well as the overall sales goals of the company.
- Applied Customer Relationship Management, SAP analytical tools, and methods to inform business decision-making processes.
- Trained dealers on Delivery Execution System (DES) and Strategic Route Planning
- Analyzed the Nielsen market data and presented findings to the Category Management team to capture the best growth opportunities.
- Collaborated with cross-functional teams to continuously drive sales strategies and efficiencies.
Education
MBA - General Management
University of Lagos
Nigeria 09.2010 - 09.2012
Bachelor of Science - Economics
Covenant University
Nigeria 10.2004 - 06.2008
Skills
Activity diagrams
Data profiling
Data validation
Data quality assurance processes
Data analysis
Business needs analysis
Project Management
Data Warehousing and Data Management
Reporting Tools
Analytical Problem Solving
Strong Story telling skills
Certification
Project Management Professional, Project Management Institute - March 2022
Timeline
IBM Data Analyst Professional - Feb 2023
02-2023
Black Tech Data Analytics Training - Feb 2023
02-2023
Project Management Professional, Project Management Institute - March 2022
03-2022
Data Analyst
TELUS
07.2021 - Current
Business Intelligence Data Analyst
Coca-Cola
02.2017 - 05.2021
Business Analyst
Coca-Cola
02.2013 - 02.2017
Sales Operations Analyst
Coca-Cola
10.2012 - 02.2013
MBA - General Management
University of Lagos
09.2010 - 09.2012
Bachelor of Science - Economics
Covenant University
10.2004 - 06.2008