OLAITAN FAGBAMILA
****-*** ****** ******, ********, ON, L8N 3X2 +1-905-***-**** **********@*****.*** (preferred contact)
Work Experience
Data Processing Officer,
Finance Department, RCCG Chapel of Praise, Hamilton, On. Jan. 2015 – Present (Part-time)
Develop MS Excel spreadsheet database by transposing cheque information ensuring timely and accurate data processing
Process invoices and payments in accordance with the terms and conditions into Quickbooks Application
Import data from QuickBooks to Microsoft Excel and Access accurately
Participate in budget and financial planning
Create and Setup new vendors within the database
Create, edit, and maintain existing and new computer data files
Generate reports analyses and reconcile totals on a monthly basis
Use excel reporting, spreadsheets, pivot tables, and Vlookup to generate timely and reliable report
Maintain data with high accuracy rate and escalate issues appropriately when necessary
Verify, update, and backup database regularly to ensure data management accuracy
Use Teamviewer application to work remotely
Data Processor co-op
Product, Pricing and Analytics Department, Economical Insurance, Waterloo, On. Sept. 2018-Dec. 2018
Performed data validation, ensured timely and accurate data management.
Corrected Policy Information in GISA (P and C)by using information from Guidewire, Energy Auto and Validate VIN from IBC.
Conducted data reconciliation to ensure accuracy and data integrity
Compared the given CLIENT/customer POLICY NUMBRT to that of Canada POSTAL CODE and provided
services like address standardization and correction.
Assisted underwriter to Process policy transactions for personal home and auto insurance policies in the Sonnet system
Entered data from multiple platforms and sources into spreadsheets and other interfaces.
Worked with Microsoft Excel, including styling, formulas, functions, Vlookup, and Hlookup.
Worked independently and as a team to ensure accurate data processing
Assisted Data Analytics in preparing, cleaning large dataset for the data analysis.
Machine Learning Specialist /SAS Programmer, Metro Coll. of Tech. Toronto, On. July 2016-Oct. 2016 (Intern)
Used various statistical software including SAS programming, R console and MS Excel to analyses data
Data extraction, manipulation and management skills using SQL and SAS programming
Summarized and validated data by segments using classification and clustering analysis
Implemented Python scripts to manipulate and apply machine learning algorithms
Built machine learning forest fire models in Python and R (SVM, Logistic Regression, Neural Net)
Transformed raw data into MySQL with custom-made ETL application to prepare unruly data for machine learning
Statistician/Lecturer, Crawford University, Lagos, Nigeria 2006 – 2014
Lectured undergraduate University students various statistical theories, methods and applications
Conducted research and published papers in scholarly journals
Prepared lecture notes and delivered lectures; supervised students on their projects
Computed and analyzed students’ results using MS Excel (Macro, Vlookup, Hlookup and Advanced Excel functions) and reported the results to the head of the departments
Served on departmental committees to discuss matters such as grading students’ results, degree requirement and a variety of other administrative issues
Transferred students’ records from MS Access database to Excel for processing
Data Processing Officer, Research and Marketing Services, Lagos, Nigeria 2004 – 2005
Edited data using statistical packages such as SPSS, EXCEL and QUANTUM
Entered data into computerized databases, spreadsheets; verified data for accuracy of completeness
Determined the methodologies and procedures for carrying out effective data analysis
Evaluated the given problems, situations and crisis; investigated for solutions using data analysis practices and prepared analysis reports
Gathered data required to conduct analysis from several sources, compiled it together in a prescribed format and entered the data in several data analysis software
Manipulated large data sets using advanced MS Excel techniques
Education
Data Analytics, Big Data, and Predictive Analytics Certificate 2018
Ryerson University, The Chang School, Toronto, On.
Certificate in SAS Programming
Metro College of Technology, Toronto, ON 2016
Oracle Certified Professional (OCA, OCP)
Oracle University, Online 2008 Master Degree in Statistics 2005
University of Ibadan, Nigeria
(Equivalent to a Master’s in Statistics, as determined by World Education Services, Toronto, On.)
Bachelor Degree in Statistics 2001
University of Ibadan, Nigeria
(Equivalent to a Master’s in Statistics, as determined by World Education Services, Toronto, On.)
References
Available upon Request