Business Intelligence Analyst

OLUFEMI KUPOLUYI MSc.

Dopemu Agege, Lagos Nigeria ********@*****.*** +234 806*******

LinkedIn: www.linkedin.com/in/olufemi-kupoluyi

PROFESSIONAL SUMMARY

Self-driven and highly commercial professional with experience in managing business operations, delivering quantitative and statistical analysis, and leveraging data from multiple sources to generate actionable insights for informed business decisions making. Adept at using data analytics tools and techniques to transform, extract, analyze and model data to create self-service data analytics platforms and visualize large complex datasets ensuring high quality and timely delivery of analysis. With a keen eye for details and proficiency at identifying new opportunities for analysis and insight generation and developing key performance indicators. Experienced collaborating closely with business stakeholders to understand their issues and address them via relevant data-based solutions. An excellent communicator who possesses exceptional problem solving and critical thinking skills, and ability to multi tasks, lead teams and work effectively within teams or independently to deliver excellent results.

TOOLS AND COMPETENCIES

Business Intelligence: Ms Power BI, Advanced Ms Excel Including Pivot Tables, v-lookups, Dashboard, Excel Functions, Power Map, Power Pivot, Power Point, Excel Dashboard, Ms Word

Databases: T-SQL-Microsoft SQL Server, MySQL, TeraData, PostGRE SQL, Oracle SQL Developer

Projects: Market Basket Analysis, Forecasting, Customer Profiling, Competitor Intelligence, Channel Performance Analysis, Sales Performance Analysis, Interactive Dashboards.

Others: • Leadership • Managerial • Excellent Communication• Decision Making • Team collaboration

WORK EXPERIENCE

July 2020 – till date BI ANALYST (PROJECTS) Pairview Limited

Meeting with key business stakeholders to understand, define and deliver analytics requirements, and communicating insights generated from findings.

Carried out financial performance analysis across sales channels, compared products sales, revenue generated and costs to determine profitability across regions using PowerBI.

Conducted trend analysis and applied visual tools to understand sales performance trend, discover drivers of sales online and in various stores, established drivers of shifts and determine the reasons for changes in products sales.

Developed self-updating dashboards in PowerBI using key performance indicators and demographic data in SQL data warehouse to analyze consumers’ behaviors, segment customers into categories in order to generate insights relating to financial contributions by different segments.

Investigated business areas to improve by extracting, transforming, loading, and analyzing data relating to business process, operations and functions.

Performed SWOT analysis to determine products/business competitiveness by researching other products and unique features offered by competitors, comparing prices with competitors’ and investigating how business performance compares to industry data.

Recommended cross-selling opportunities using market basket analysis to uncover top association products with great revenue and profit generating potentials.

Developed Times Series models to perform five years quarterly sales forecast across channels and regions, providing the data and insights required for future business planning and decision making.

Writing complex SQL queries to extract, consolidate, manipulate, analyze, aggregate and isolate necessary information from databases and transforming raw data into easily accessible models for supporting data visualization.

Used advance Microsoft Excel functions to analyze data from various sources, pivot tables to summarize data and pivot charts for efficient and effective visual communication.

September 2019 – July 2020 BI ANALYST/OPERATIONS MANAGER Williando Nigeria Ltd.

Tracked key business metrics for analysis, forecast, preparation and presentation of periodic performance reports.

Ensured the timely and successful delivery of solutions according to clients’ needs, objectives and specifications.

Developed new sales opportunities by meeting with potential customers to pitch company’s products and establishing good rapport with existing clients.

July 2017 – August 2019 BDM/OPERATIONS MANAGER Next IT Services.

Researched organizations and individuals to find new prospects and attract new clients.

Organized and attended meetings between prospective clients and relevant personnel.

Managed sales accounts, developing quotes and invoices for clients and overseeing onsite engineers.

Short/medium term planning and organization of resources.

Managed teams for company projects.

Compiled business activities and operations reports.

Managed staff payroll.

Provided operational cover for absent senior managers when required.

June 2016 – June 2017 FUNERAL MANAGER Bel Luyi Funerals.

January 2015 – May 2016 Attended Post Graduate School.

January 2014 – May 2015 MANAGER The Caring Global Resources Ltd.

July 2012 – December 2013 TECHNICAL SUPERVISOR TOS Funerals Ltd.

May 2012 – July 2012 TRAINEE EMBALMER TOS Funerals Ltd.

QUALIFICATIONS

Post Graduate Diploma in Management

Assam Don Bosco University, September 2019

Masters of Science in Cell Biology and Genetics

University of Lagos, May 2016

Bachelor of Science in Anatomy

Olabisi Onabanjo University, August 2010

CERTIFICATIONS AND TRAININGS

Microsoft SQL Server 2019 Essential Training (Linkedin, March 2021)

Data Analyticts for Business Professonals (Linkedin, February 2021)

Power BI Essential Training (Linkedin, February 2021)

BI Analyticts Specialist Certificaton (Pairview, January 2021)

Microsoft Excel 2010 (Alison, June 2020)

Diploma in Operations Management (Alison, June 2020)

Diploma in Business Communication Skills (Alison, May 2020)

Fundamentals of Project Management (Alison, April 2018)

Fundamentals of Operations Management (Alison, March 2018)

Business Communication – Managing Successful Team Meetings (Alison, Sept 2017)

REFERENCES: Available on request

Contact this candidate