Post Job Free

Resume

Sign in

Sales Data

Location:
Regina, SK, Canada
Posted:
February 14, 2020

Contact this candidate

Resume:

FALOLA OLUWATOSIN OLAJIDE

Email: adbr1b@r.postjobfree.com 104 Meadow Way, Regina, SK, S4N 5h1, Canada. 306-***-****

LinkedIn: www.linkedin.com/in/tosinrefined

SUMMARY

I am a manager who is driven and motivated by success, I provide solution to problems using intellectual and technology tools, I have experience in Information Technology and most especially data engineering, data architecture and business intelligence, I have core competence in Database, Business Intelligence, Microsoft SharePoint and Dynamics CRM solutions, Marketing Technology and Relationship Marketing.

BUSINESS AND TECHNICAL SKILLS

TECHNICAL

Database Design and Implementation

SQL Server Reporting Services

SQL Server Analysis Services

SQL Server Integration Services

Microsoft Power BI

IT Service Management

ITIL V3 Service Strategy, Design, Transition, Operation and Continuous Service Improvement (CSI)

Application Design and Development

Dynamic CRM Installation and Configuration

Dynamic CRM Applications

SharePoint Installation and Configuration

SharePoint Administration

Plugins Developments

Workflow design, creation and development

SharePoint, CRM, third party app Integration

Software/Web design, development & management

System Analysis and Design

BUSINESS

Business Requirements Gathering

Requirements to Solutions

Customer Relationship/Management

Sales and Marketing

Business Development

Market Research

Idea Generation and Implementation

Pitch Presentation

Strategic Initiatives

Project Management

Good Client Facing and Interaction

Root cause Analysis and problem solving

CERTIFICATIONS

ITIL V3 Foundation Certification

IT Services Management (2011)

SharePoint Online

(October 2016)

Microsoft Dynamics CRM Application

(July 2015)

Implementer: Designing BI with Microsoft SQL Server 2012 (Oct 2016)

Core Solutions of Microsoft SharePoint Server

(Sept 2016)

EDUCATION

MSc. Computer Science (2019)

University of Regina, Canada

HND, Computer Science (2007)

Lagos City Polytechnic, Lagos, Nigeria

SUITE OF TOOLS

Microsoft - SQL Server, Power BI, Power Maps, SharePoint, Dynamics CRM, O365, Office Suites

Others – Tableau, IBM Cognos

PROFESSIONAL EXPERIENCE

Database Developer/Analyst September 2018 – April 2019

Refined Solution Services

Regina, Canada

ChurchCareTM is a CRM web portal for church management, it’s an application that manages congregational information from the point of data gathering. The core functionalities are based on an idea of customer relationship management with the sense of keeping customers for life by building a relationship with them. It is currently being used by three (3) organizations.

DATA ANALYSIS: I designed the database, implement it, and created various views. I wrote SQL Queries, for data analysis, and present Graphical insights to users.

Technology used: MySQL, HTML, CSS, PHP and JavaScript, Google Graphs (developer).

Snr Applications Consultant (BI, SharePoint, CRM) Feb 2015 – Dec 2016

ASL Business Solutions, Lagos, Nigeria.

UBA Self Service Business Intelligence Reporting

United Bank for Africa. A leading bank in Africa wanted to reduce cost on Cognos Licenses. They needed a solution. That will do what Cognos does and more. They want to give access to users to the reporting platform across Africa.

Responsibilities:

I looked at the existing reports on the Cognos BI tool and came up with a replica in SQL Server Reporting.

I lead a team of professionals to design a robust reporting platform

Use Microsoft SQL Server Reporting Services to design and develop all reports

Use SharePoint as a repository for all the reports

Control access to the reports using Active Directory of Windows Server embedded in SharePoint

Train the technical team leads on how to develop reports using SQL Server Reporting Services

PALTON MORGAN BI Pitch

Palton Morgan is a group of companies in Real Estate business. They want to automate their business and get reporting from the field and seen across all levels of management. We pitched and won.

Responsibilities:

I lead a team of professionals who designed a prove of concept of data gathering and reporting.

We leverage on Microsoft tools (Dynamic CRM and SQL Server) for data storage and analysis

SQL Server Analysis services was used for analysis, and SQL Server Reporting Services was used for reporting purposes

We designed the databases, based on the client requirements and present the data in dashboards.

Information Technology Manager Jun 2012 – Jan 2015

Proximity Communications Nigeria

Lagos, Nigeria

I designed, development and maintain business intelligence platform for five (5) different clients. I used SQL Server SSIS, SSAS, SSRS for all these client field related projects. Our business goal is to ensure success of our clients at retail.

RECKITT BENCKISER (New Mum Activation Program)

The goal of this project was to get the number of new mums from five geographical region of the Nigeria. The client wants to sell Dettol antiseptic liquid wash to them, and hence boast the sales of the product.

Responsibilities

I designed a data warehouse for the project. I created Tables, views, and procedures.

I used SQLServer Analysis Services to analyze the data from the data warehouse.

Created dashboards that speaks to the information from the tables

I created competition insights. What brand in that category sells more.

Created Dettol sales insight. What region has the highest sales, which of the brand ambassador and what SKU.

I also generate insights for average age of mums, and from what locations

This reports are also tied to specific hospitals.

Kimberly Clark (Huggies Sampling Project)

In this project, the goal was to get mums to use huggies diaper for their kids. This was in one city of the nation. The client wants to create awareness and increase sale of the product. The product is just being introduced to Nigeria at that time.

Responsibilities

I got the clients requirements of this project

I designed the database for application portal. I created Tables, views, and procedures.

I used SQLServer Analysis Services to analyze the data.

Created dashboards that speaks to the information from the tables

I created competition insights. What brand in that category directly competes with the product in terms of sales?

I created sales insight by brand ambassador

I also generate insights for average age of mums that are being sampled daily.

Etisalat (Project Ropp House)

This was a road show event, coupled with sales of sim cards, data mifi and wifi hot-spot router. For each event, peoples’ data were capture, we get information about what mobile network they use. We also sell the company’s sim card to non-users of the product. We introduce new products to existing clients. The data gathered are being analyzed.

Responsibilities

I got the clients requirements of this project

I designed the database for the web platform for data capture

I created dimension and cubes for the analysis using SQL Server Analysis services

Each data mart was plugged into SharePoint BI Site for reporting purposes

This gives the client insights into the patterns of use, purchase, and sales of the product

I was responsible for sharing and discussing the information with all stakeholders of this project.

I Write and present reports (projects and insights) to the required managers

This project also involves visual insights and analysis.

Information Technology Executive Apr 2009 – May 2012

Proximity Communications Nigeria

Lagos, Nigeria.

The goal of this role was to manage different data driven initiatives from our clients (Unilever Nigeria, Promasidor Nigeria), where they wanted to incentivize their various customers based on their purchasing power, the project has different mechanics which has to be well programmed, I was in charge of these projects and more.

Responsibilities:

Database Design and Management for each of the business Ideas

Build Loyalty Management System using SQL Server BIDS

Report Generation and Management using SQL Server Reporting Services

Project Management for each of the projects executed. (Customer Development Incentive, Sell More Smile More, U and I loyalty programmes

Data reporting with MS PowerPoint. Reporting information to the stakeholders

Reference Projects

UnI, Sell More Smile More and CD Incentive Programme

Unilever Nigeria, is a Fast Moving Consumer Goods Company. In order to increase sales, they came up with an individual program for their wholesalers, retailers and Customer Development Team. These programs have different mechanics (requirements)

As the head of IT at Proximity Communications Nigeria at the time, my role was to come up with a system that will take in all mechanics, convert them into an automated solution, where at the end rewards will be given to individuals that have a particular point. It's worth noting that gifts given are based on points earned. All these must also be automated. I am to declare winners, authoritatively based on the successful implementation of the system.

I created different tables and views for each components of the mechanics. E.g. Table of Wholesalers, Retailers, the Managers, Locations, Products, Sales, Purchases, Date (Day, Month, Year, Quarter) both in numbers and names from 19's to 30's. Time (Nano Second, Seconds, Minutes, Hours) in 12 and 24 hours respectively. I then created views with calculations to compute the result which translate into points. Based on the analysis from the data, we are able to come up with a list of winners and their rewards.

These projects were successful and we handled them for 3 consecutive years.

There are three projects in all, two were done using Microsoft SQL Server Management Studio, BIDS (Microsoft Business Intelligence Development Studio) Microsoft SQL Server Analysis services, Microsoft Integration Services and Microsoft Reporting Services. The third was done using Microsoft Access. I should also mention that Microsoft Excel was also used.

Promasidor Merchandising Programme

Between 2012 and 2016. I worked directly with different clients to solve business issues. I used data driven approaches to solve their problems.

Promasidor is a leading FCMG organization in Nigeria. They wanted to know how well their business was doing and also compare their growth with competing brands.

They came up with Merchandising Programme. My responsibility was to gather data all across the nation. Data on sales, competition (based on specific metrics) and stock out information. To analyze the data. Present the information in an understandable manner. Suggest solutions to help the organisation to win in the market war.

I designed a database using Microsoft SQL Server, with different table that will help capture the information from the field. I created different views by writing SQL queries to merge the data. I then use Microsoft SQL server analysis services to analyze the data, I created different cubes so as to be able to drill down on information. Finally, I presented the information to the client, using Microsoft SharePoint Business Intelligent Site.

I reported on sales per sku, per brands. We were able to see the trends of sales over the period of 2 years. I showed the competition information, how Promasidor was doing in terms of sale. In comparison with their competitions brands. The clients were able to know what product is doing well. Those meeting expectation and those below target.

The client was able to take decisive decision on how to re-strategize and win the market war. The project was successful.

OTHER EXPERIENCE

Lab Instructor January 2019 – April 2019

University of Regina

Regina, SK

I teach undergraduate students the basic of programing, techniques and implementation in the lab. Supporting their lecturers in a holistic approach to learning.

Graduate Teaching Assistant August 2018 – August 2019

University of Regina

Regina, SK

Assist the Professor in class management, by supervising examinations, marking assignments, midterms and final exam scripts. Uploading the marks and remarks on the online student platform (Self Service), and giving advice when needed.

Assistant Programmer Apr 2006 – Mar 2008

TEQUILA\Nigeria

Lagos, Nigeria

In this role I was working directly with the director of IT to make sure that all employees of the organisation have work itch free, my role also was to develop client and web software applications as needed.

Responsibilities:

2006 - 2008 (2 years)

Software Development

Managed www.door2doornigeria.com (the website)

Work directly with the Technology Director on IT issues

Attends to all technology issues in the company

Programmer (Trainee) April 2004 – Feb 2006

TEQUILA\Nigeria

Lagos Nigeria

As a trainee, I was saddled with the responsibility of co-developing an e-commerce web site, which I eventually took ownership, I was also responsible for managing a Microsoft Access back end database of a call center, I was the go to person for data obtained from all tele-marketing activities.

Responsibilities:

Telemarketing Management (BAT and MTN projects respectively)

Fully manages www.door2doornigeria.com

Co-design Door II Door website (www.door2doornigeria.com)

Manages the company’s Intranet

Ensures normal working conditions of every systems

Data De-Duping (Data cleaning)

RESEARCH WORK

IoT Device Fingerprint – University of Regina, Canada - 2019

In this research, I am looking at the best way to uniquely identify IoT devices connected to the IoT network. The aim is to be able to minimize, or completely eradicate anomaly in IoT based network.

Data Analysis: I am able to come to conclusion of the best way to uniquely identify IoT devices by analyzing the network traffic data. I use a combination of network features from the data to identify each of the devices.

Technology Tools Used: MS Excel, Weka (Data analysis Tool) and Wireshark.



Contact this candidate