Kehinde Ajayi
Data Analyst
Chicago,IL
Summary
- Experienced sales and data analytics professional offering proven leadership, planning, and problem-solving abilities honed over eight years of outstanding performance in the fast-moving consumer goods company.
- Knowledge in using Power BI and Excel to Create data analytics solutions.
- Proficiency in writing SQL queries against relational databases to extract, transform and display data for reporting purposes
- Experienced Sales manager with a history of successfully direct and motivate sales team members to exceed targets and boost revenue.
Overview
5
5
years of post-secondary education
15
15
years of professional experience
Work History
Junior Data Analyst
Fashion Pinnacle
Chicago, IL
02.2020 - Current
- Manipulating, cleansing, and processing data, running pivot tables, V-lookups, and formulas in Excel, creating reports that managers consume.
- Using Digital information collected to help retail stores become more profitable by predicting trends and consumer behavior increasing sales by 15%.
- Analyzing sales data to develop Key Performance Indicators and building dashboards to visualize important trends and goals for decision making.
- Provide strategic recommendations to managers.
- Identified unnecessary shipping cost that saves company over $2,000 monthly.
- Monitor Shop-Style KPIs every day and dig into details to discover what is driving those trends.
- Answer important ad-hoc business questions with data analysis.
- Creating sales dashboards and metrics for business to understand lucrative merchandise, sizes selling fast, weekly, and monthly sales.
- Implementation and use of data-driven decision processes have contributed to 15% in sales revenue over 7months.
- Sales data, product information, and consumer data are collected continuously and analyzed to improve sales and margins.
- Performing daily system checks.
Garage Attendant
Standard Parking Plus
Chicago, IL
07.2015 - 03.2020
- Determined customer needs by asking relevant questions and listening actively to responses.
- Answered questions and provided information about customers' vehicles.
- Handled customers' concerns with professionalism.
- Kept facilities clean, neat, and organized at all times to give areas professional and fresh appeal.
- Educated customers about the brand to incite excitement about the company's mission and values.
- Worked to maintain outstanding attendance record, consistently arriving to work ready to start immediately.
Sales Manager
Reckitt Benckiser Nigeria.
Yaba, Lagos
02.2006 - 01.2015
- Identified, hired, and trained highly qualified staff by teaching best practices, procedures, and sales strategies.
- Held weekly meetings with sales representatives to identify techniques to overcome sales obstacles.
- Handled all customer relations issues pleasantly, enabling quick resolution and client satisfaction.
- Increased revenue by 25% by working closely with key top 10 Retail stores.
- Accomplished sales goals and boosted revenue by 30million Naira through product knowledge and customer relationship management.
- Organized promotional events and interacted with community to increase sales volume.
- Increased monthly gross sales from 4million Naira to 10milion Naira and exceeded goals for sales, revenue, and profit margins.
- Increased regional market share by 20% within 13 months.
- Achieved growth and hit sales targets by successfully managed sales team.
- Created and Reviewed sales dashboard and KPI metrics with sales team to let them track their sales target.
- Used excel and power-bi to create sales dashboard for visualization.
- Designed and implemented strategic sales plan that expanded company's customer base and ensured its strong presence.
- Liaised with Logistics department to ensure timely deliveries to customers as necessary.
- Taught sales team how to connect with customers and build long-term, productive relationships.
Education
Certificate: Data analytics and Reporting -
Eklipse Consult Training
Chandler, Arizona 07.2019 - 02.2020
Bachelor of Arts - Marketing Management
Ladoke Akintola University Of Technology
Ogbomosho 01.2011 - 02.2013
Associate of Science - Computer And Information Sciences
City Colleges Of Chicago - Wilbur Wright College
Chicago, IL 01.2019 - Current
Skills
Team Building and Leadershipundefined
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Projects
- Built a data analytic solution using PowerBI for a moving company. This project involved retrieving data from a relational database (SQL Server), creating relationships in Excel (data modeling), transforming/cleansing data using Excel formulas, and building Pivot tables / Pivot charts for visualization purposes.
- Built an end to end database and data analysis solution for a Transportation logistics company. This project involved requirements gathering, database design/ implementation, creation of medium to complex database queries/views, and design of PowerBI reports for visualization purposes
Quote
The way to get started is to quit talking and begin doing.
Walt Disney
Accomplishments
- Supervised team of 12 sales representatives to achieve our annual target 5years consecutively.
- Used Microsoft Excel and power-bi for data visualization.
- Resolved product issues through consumer testing.
Timeline
Junior Data Analyst
Fashion Pinnacle
02.2020 - Current
Certificate: Data analytics and Reporting -
Eklipse Consult Training
07.2019 - 02.2020
Associate of Science - Computer And Information Sciences
City Colleges Of Chicago - Wilbur Wright College
01.2019 - Current
Garage Attendant
Standard Parking Plus
07.2015 - 03.2020
Bachelor of Arts - Marketing Management
Ladoke Akintola University Of Technology
01.2011 - 02.2013
Sales Manager
Reckitt Benckiser Nigeria.
02.2006 - 01.2015
Similar Profiles
Judy KempfJudy Kempf
Closer at Pinnacle Funding Corp./dba Pinnacle Home LoansCloser at Pinnacle Funding Corp./dba Pinnacle Home Loans
Navjot KaurNavjot Kaur
Customer Service Representative at Fashion Fashion Unique Inc.Customer Service Representative at Fashion Fashion Unique Inc.
Kaamya KrishnanKaamya Krishnan
Volunteer at Global Fashion Collective, New York Fashion WeekVolunteer at Global Fashion Collective, New York Fashion Week
Tsvetelin PenevTsvetelin Penev
Back Server at The Peninsula HotelBack Server at The Peninsula Hotel
Jose Sanchez-GarciaJose Sanchez-Garcia
Certified Medical Assistant at Northwestern MedicineCertified Medical Assistant at Northwestern Medicine