Olalekan Elijah Oyebobola

Data Analyst

OBJECTIVE

Data-driven Analyst with expert in leveraging analytics and business intelligence tools to transform and analyze data, develop visualization dashboards that provides valuable insights for data-driven decisions that fuel business growth. Recognized as a strategic problem-solver with an impressive record of automating iterative process that transforms business problems into innovative technical solutions.

ACHIEVEMENTS

Developed holistic interactive dashboard solutions that aggregated data from multiple data sources which helped centralized KPI performance reporting for customer engagement, website behavior and marketing campaigns.

Led the successful development of the first Data Techcon’s SQL relational database system for data storage of clients and student’s enrollment records and automated reporting by integrating the server into tableau and Power BI that helped streamlined reporting time.

Analyzed customer engagement data and created a data-driven marketing strategy used by Data Techcon to implement its marketing campaigns that resulted to a 55% increase in customer engagement rate and new student’s acquisition rate.

Streamlined the KPI Dashboard reporting time from 5 days down to only 2 hours by using dynamic data exchange skills across several platforms to automate various processes.

WORK EXPERIENCE

Informa Financial Intelligence: June 2006 - Present (Calabasas, CA)

Data & Business Intelligence Analyst

March 2017 – Present

Collect financial data from direct source. Use Microsoft Visual Studio and SSDT for ETL before analyzing the data.

Interpret the data in order to draw conclusions for managerial action and strategy.

Use advanced Microsoft Excel to create pivot tables and develop/design dashboards when needed. Also use VLOOKUP and other advanced functions for data solutions.

Use Power BI for visuals to audit/analyze data. Use SQL queries for a quick audit and to create custom reports.

Optimize data collection procedures and generate reports on a weekly, monthly and quarterly basis.

Analyze workload and delegate tasks to team members.

Use PowerPoint to present findings and conclusions to team managers in order to improve strategies and operations.

Proposed solutions such as report automation and migrating into Power BI to improve system efficient and reduce business expenses.

Assistant Client Relationship Supervisor

August 2011 – March 2017

Work directly with clients in different lending industries such as Wells Fargo, Bank of America, TD Bank, various Credit Unions, etc. to obtain Rate Sheets for reporting purpose.

Assisted team manager with implementing new initiatives, training new hires and leading special projects (e.g. development of the Rate Sheet Verification file, Rate Sheet Delivery Schedule and testing new department database).

Responsible for delivering highest level of customer satisfaction. Communicate defects to my direct supervisors and manager.

Responsible for onboarding new clients and entering the information in Salesforce.

Research & Data Specialist

June 2006 – August 2011

Client’s relationship management and nurturing of new leads from prospective customer stage to a closed won deal using salesforce CRM which has helped in increasing customer acquisition rate.

Collected vital financial information such as rates, loan amounts and fees for data analysis and reporting. To enable end user track KPI metrics towards projected leads goal of increasing client’s retention rate.

Mystery shopped for Ad Hoc reports.

Import complex data into the company’s internal department relational database and optimize SQL querying to reduce reporting time.

Evaluate financial impact and help drive data-driven culture in the organization for high level insights for smart decision making.

CAPSTONE PROJECT

Data Techcon (Data Analysis Course): April 2020 – June 2020 (California)

HR Analysis – Extracted, transformed and loaded large set into Power BI. Modeled the data, created relationships across multiple tables, visualized the data using appropriate visuals and wrote executive report providing great insights and recommendations on business initiative strategies to help improve gender inequality & non-diverse workplace.

Website Analysis – Integrated Google Analytics into Power BI to build an automated dashboard solution for the company for real-time reporting and insights. Identified KPI metrics based on the business goal. Collected, transformed, analyzed and built an interactive dashboard that provided insights on the effectiveness of marketing campaigns. Created marketing strategies based on the insight on the most efficient marketing media mix channel for launch new campaigns which helped save wasteful marketing spend, increased CTR & customer acquisition rate.

Healthcare Analysis – Analyzed healthcare data that identified pattern and trend on key factors that influences patient’s diseases and the likelihood of patients having hypertension and heart disease. Developed an interactive dashboard using descriptive statistics to show trends based on historic data. Generated key insights and wrote an executive report outlining the problems and recommendations on the impact of demographic & behavioral factors on heart disease and hypertension.

EDUCATION

Data Techcon, California (June 2020)

Advanced Excel, SQL, Google Analytics, Power BI & Tableau – Data Analysis Certificate.

UCLA Coding Bootcamp, Westwood, CA (August 2017)

Web Development and Programming – Full Stack Developer Certificate

DeVry University, Sherman Oaks, Sherman Oaks, CA (March 2017)

Coursework in Data Structures, Algorithm and Computer Security.

California State University, Northridge (CSUN) (June 2006)

Business Administration (option in Finance) - Bachelor of Science (BS)

CONTACT DETAILS

4075 Tamarind Rdg

Lake Elsinore, CA 92530

Phone#: 818-***-****

Email: adik9j@r.postjobfree.com

TECHNICAL SKILLS

Microsoft Office

Visual Studio

SSDT

Knime

Project Management

Advanced Excel

SQL

Python

Power BI

Tableau

Salesforce

Google Analytics

JavaScript

HTML

CSS

SOFT SKILLS

Communication

Customer Service

Presentation

Problem Solving

DEGREES & CERTIFICATIFICATIONS

B.S. in Business Administration

Google Analytics Certificate

Data Analysis Certificate

Full Stack Developer Certificate

HOBBIES

Basketball

Soccer

Ping Pong

Cooking

Exploring

Coding

REFERENCES

Available Upon Request

Contact this candidate