Tosin Saka
Data Analyst
Phase 2,Kubwa. Abuja
Summary
A seasoned and highly skilled Data Analyst with a miner's heart and in-dept knowledge of latest technologies required to provide insight into organization data. An experienced large Data miner with experience that cuts across financial institution and Global Health Supply Chain (GHSC) organization with a proven ability to improve the operational functionality in line with business requirements.
Overview
1
1
Certification
9
9
years of professional experience
Work History
Data Analytics and Business Intelligence Advisor
Chemonics International
Chemonics International Global Health Supply Chain – Procurement and Supply Management Nigeria, Abuja
03.2019 - Current
- Responsible for designing ETLs packages required for cleaning, transforming and loading datasets from different data sources into the Data Warehouse.
- Responsible for writing complex T-SQL queries, Sub-queries, CTEs, Views, Store procedures required to be consumed by reporting applications e.g. Power BI, SSRS, tableau, paginated report builder etc.
- Responsible for writing Python Scripts required for cleaning up data, transforming data and moving the transformed data to another data source.
- Responsible for designing and deploying SSIS packages into SSIS Catalog and scheduling SSIS jobs.
- Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
- Responsible for gathering requirements from business users and ensuring that requirements are implemented to meet users need
- Responsible for providing technical training to business users on solution usage after deployment.
- Developed and maintained courteous and effective working relationships among team members
- Responsible for optimizing and managing Azure Data Warehouse and other on-premise databases.
- Responsible for designing various data models required by different business units of the organization.
- Responsible for designing organizational reports and dashboards with PowerBI desktop, Tableau, SSRS, PowerBI report builder.
- Responsible for providing technical oversight to consultant partners.
- Responsible for creating technical blueprints and solution architecture diagrams.
- Responsible for the documentation of the Azure Data Warehouse redesign
- Performed profiling on the tables on the Data Warehouse to know the pattern of the records and their relationship with one another.
- Created an audit log to know who is trying to access what on the database.
Zenith Bank Data Warehouse Project (BI Analyst)
Taytom Consultant Limited
66 Raymond Njoku off Awolowo Road, Ikoyi, Lagos
10.2017 - 03.2019
- Designed reports and dashboards with drill-through using SSRS, PowerBI Desktop, Power BI report builder.
- Responsible for designing data marts for business processes.
- Responsible for writing complex T-SQL queries, functions and store procedure used as engine for reports.
- Responsible for designing business model tailored to each department, unit on the client side.
- Responsible for meeting with users to understand the business process of each unit in the organization.
- Responsible for gathering requirements across units in the organization.
- Responsible for gathering all the data sources used by the units in the organization for their reporting purpose/other third-party application consumption.
- Responsible for profiling all the database tables for better understanding.
- Responsible for recommending indexes for tables in the identified data sources.
- Responsible for the design of the data model for each gathered requirement.
- Responsible for identifying needed columns from the source systems to the data warehouse.
- Responsible for designing ETLs for Extracting, Transforming and Loading from source to destination.
- Responsible for performing data profiling on client’s database.
- Responsible for identifying all data source needed for the project.
- Responsible for identifying archived tables and data sources and profiling them.
- Responsible for moving data from each identified source to the staging tables using SSIS.
Heritage Bank Limited, Dynamics CRM Developer/Reporting Analyst
Taytom Consultant Limited
66 Raymond Njoku off Awolowo Road, Ikoyi, Lagos
04.2016 - 03.2019
- Responsible for requirement gathering of some business unit in the organization.
- Responsible for connecting to the Dynamics CRM database and creating multiple reports as requested by business owners.
- Responsible for migrating entities from the client's On-premise databases to the Data Warehouse
- Queried client’s database to provide the needed report on dynamics CRM.
- Responsible for synchronizing the on premise entities with cloud entities in dynamics CRM.
- Responsible for generating customized cased number for the client using JavaScript, C#.
- Responsible for creating sitemap in Microsoft dynamics CRM.
- Responsible for fixing bugs identified by business users during UAT.
- Responsible for taking business users through the UAT.
- Responsible for using CRM plug-in, CRM SDK, to perform some tasks.
- Responsible for providing security roles to sitemap/menus in Dynamics CRM.
- Responsible for implementing service request matrix and enquiries for business users.
- Responsible for creating subject tree used for case metrics in CRM.
- Responsible for creating relationship between entities in CRM.
- Responsible for creating custom entities, fields in CRM.
- Responsible for configuring the security roles for business units in CRM.
- Responsible for creating permissions on dynamics CRM.
- Responsible for creating users on dynamics CRM.
- Responsible for creating queues to manage cases and route to the resolving unit in CRM.
- Responsible for creating business rules in CRM.
- Using JavaScript to add events to dynamic CRM with the aid of CRM SDK.
- Responsible for customizing forms, fields and entities based on the requirement of a business unit and specifying security to teams and/or user in an organization unit.
- Responsible for using workflows to send email to customers, resolving unit on case creation.
- Responsible for creating custom solutions, entities, fields, workflows, business rules in dynamics CRM.
- Responsible for using OData to retrieve values of related entities in dynamics CRM.
- Was part of the team that trained users on dynamics CRM.
- Using SSIS to move/integrate data from the source database into dynamics CRM.
- Using SSIS to automatically send out emails to business users to notify them of any occurrence as specified in the requirement.
- Responsible for integrating Dynamics CRM with other solutions within the client’s environment.
- Responsible for fixing exception identified by user after the release of the solution.
- Responsible for using plugins to populate some field values in Dynamics CRM.
Union Bank of Nigeria, BOTF (Software Support)
Taytom Consultant Limited
66 Raymond Njoku off Awolowo Road, Ikoyi, Lagos
04.2016 - 03.2017
- Responsible for writing queries and stored procedures.
- Responsible for designing the Bank of the Future landing pages using ASP.NET and C#.
- Was part of the team responsible for gathering requirements.
- Responsible for testing the web services provided by the client.
- Responsible for security tests and also debugging for errors.
- Responsible for providing application support for end users.
- Responsible for the installation and configuration of Video wall for adverts.
- Responsible for components testing on KIOSK using SDKs as provided by suppliers.
- Responsible for requirement gathering from business users.
- Responsible for the design of WPF forms.
- Designing of metro style application using XAML and C#.
- Performed designs based on user specifics.
- Conducted UAT for users.
- Responsible for security tests and also debugging for errors.
- Responsible for providing application support for end users.
- Responsible for the installation and configuration of Video wall for adverts.
- Responsible for components testing on KIOSK using SDKs as provided by suppliers.
- Designing back end application to log users’ request for any request from the front end.
- Consuming and testing webservices provided by the client for functionality testing
- Responsible for providing Users’ assessment test script during testing.
- Performed debugging in the case of exception.
- Responsible for writing the logic for the InfoPath form using C# to cater for business need.
Support Engineer
National Youth Service Corps
Akwa, Anambra
10.2009 - 09.2010
- Trained students in some Anambra state Secondary schools e.g Federal Science Technology School on how to use Microsoft Word, Excel, PowerPoint
- Trained staffs of the Anambra Broadcasting Service Corporation on the common usage of computers and Microsoft office packages (MS Word, MS Excel, and MS PowerPoint).
- Supervised in the networking and the joining to the domain of computer in (ABS).
- Performed monthly routine maintenance of Computers at the NYSC Local government secretariat.
- Loaded Operating System (Windows XP, windows Vista, Windows 7, Windows 8) for Clients at my place of service
- Installed basic user applications such as MS Office, Corel Draw, CS Suites Adobe packages etc.
- Installed third party performance enhancement applications for virus scanning.
- Performed basic Network troubleshooting in cases of network problem.
- Replaced faulty Desktop parts and servicing.
Intern
Integrated Telecommunication Technologies, CMS, Lagos
Broad Street, Lagos
06.2005 - 07.2006
- Maintained and serviced clients’ landline and intercoms.
- Responsible for the purchase of desktops, laptops, printers and other office accessories.
- Responsible for loading applications on computers.
- Responsible for setting up fax machine and office scanners.
- Responsible for the installation and the programming of a car tracking system.
- Performed routine maintenance to avoid downtime of computers and accessories.
- Organized company files and created support system to decrease workload and increase productivity
Education
Higher National Diploma - Electrical Electronics
The Federal Polytechnic
Ilaro, Ogun State 01.2009 - 01.2009
National Diploma - Electrical Electronics
The Federal Polytechnic
Ilaro, Ogun State 01.2005 - 01.2005
Senior Secondary School Leaving Certificate (SSCE) - Science
State High School
Oko-oba, Lagos State 05.2002 - 05.2002
Skills
Programming Tool(s): Python, PowerBI Report Builder, Power BI, DAX, SSIS, SSRS, Power Query, Power Pivot, MSSQL, MySQL, ASPNET, ADONET, HTML, JavaScript, CSS, PHP, XAML, WPF,ASPNET MVC5
Programming Language: MicrosofNET C#, PHP, Python
Tools/IDE: Visual Studio 2013, 2015, Dreamweaver, Notepad ; CRM Developer Toolkit, XRM Toolbox, SSDT, SSMS, Anaconda
Database: Microsoft SQL, MySQL
Other Skills: Microsoft Dynamics Customer Relationship Management Developer/Designer/Customizer, BI Developer
Business IntelligenceCustomer Relationship ManagementData WarehouseDatabasesDreamweaverHTMLJavaScriptC#MS ExcelMS WordMVC5MySQLPHPPythonMicrosoft SQLSQL ServerT-SQLCertification
Harvard Business School (Business Analytics)
Hobbies
- Researching and trying out new technologies
- Reading motivational books
- Traveling and meeting new people
Reference
- On Request
Timeline
Data Analytics and Business Intelligence Advisor
Chemonics International
03.2019 - Current
Zenith Bank Data Warehouse Project (BI Analyst)
Taytom Consultant Limited
10.2017 - 03.2019
Heritage Bank Limited, Dynamics CRM Developer/Reporting Analyst
Taytom Consultant Limited
04.2016 - 03.2019
Union Bank of Nigeria, BOTF (Software Support)
Taytom Consultant Limited
04.2016 - 03.2017
Support Engineer
National Youth Service Corps
10.2009 - 09.2010
Higher National Diploma - Electrical Electronics
The Federal Polytechnic
01.2009 - 01.2009
Intern
Integrated Telecommunication Technologies, CMS, Lagos
06.2005 - 07.2006
National Diploma - Electrical Electronics
The Federal Polytechnic
01.2005 - 01.2005
Senior Secondary School Leaving Certificate (SSCE) - Science
State High School
05.2002 - 05.2002