Michael Betts Email & Phone Number

Stoufville

Conducted meetings with owners to establish needs and issues with current IT systemsCompleted analysis and process review on existing systems including our software and business process Source and replace outdated hardware upgrade systems to win seven from XP, replaced old fax machine to 1 multi-function fax, Copier, email to cut costs and simplify office operationsSource new Internet and cell phone provider to upgrade network and cell phone and reduce costs, gather requirements for new website source and manage the bill, tasks, implementation of websiteSet up new email system using officer 365 and clients domain namePerform analysis on heavy equipment using diesel and manage third party company to submit claims for diesel usage rebateManage and move all IT, Phone System, Office Equipment to temporary office while new office is being built.

Keswick

Completed the analysis and functional specifications to enhance and replace existing website present to owner for approvalDesign and develop new website using WordPressConducted user acceptance testing with owner to ensure product delivered what was needed and implemented new website

Review and document 6 applications used by the corporate office and stores in the west, including process mapping, support requirements, department interviews. To determine SDLC stage and requirements to bring them under the corporate office in Toronto.Conducted whiteboard sessions with IBM project executives to review findings and develop a course of action to present to LCL stakeholders. This included the creation of business cases to support different optionsCompleted the analysis and functional status for any enhancements, upgrades, or any issues that required change in code or processConducted whiteboard sessions with Department managers and mainframe developers to determine any leverage point that could be usedCreate business cases to support the removal of 4 of the 6 applications by leveraging applications and processes that already exists in the EastCreate test cases to be used in system testing for any upgrades and enhancements to systemreview and document user acceptance testing submit results to implementation to teamMajor point of contact for 400+ source, district managers, all departments feeding data into the independent back office sources used by the independent stores in the WestCreate and submit change request as requiredProvide third level support for Weston grocers independent retail stores back office systemsComplete code changes and distribution to 400+ stores in the WestCompleted analysis and functional specifications to handle tax change laws across all Western provinces this included design and development, system testing, user acceptance testing, change request submission, productionIBM team lead and system expert used to support LCL in the search for a replacement for back office system used by independent grocery stores in the WestImplement escalation paths for support problems.Q&A for mainframe Programmers when making changes to mainframe and how that data would flow through to back end software

 Completed the analysis and functional specifications for upgrades to reporting system to allow for the dynamic selection of one or more products, group by district, territory, national, present findings to stakeholders for approval. Design and Develop enhancements to an Excel 2003 reporting system that reports on sales units moved by district or National or Territory. Allow for the dynamic selection of products to report on. This included the writing of functions and Procedures in VBA and Store Procedure and user defined function in MS SQL. Completed the analysis and functional specifications for upgrades to a graphical sales report system, upgrades included the ability to track sales calls against call compliance, number of units sold against target, ability to perform dynamic grouping, and present data in graphical form Design and Develop enhancements to an Excel 2003 reporting tool that reports on sales via graphs. Allow for the dynamic selection of products to report on and generate selected number of graphs in Excel 2003 using VBA. This tool was also used to track Call Compliance by the sales force and track it against the targets for each salesman. Stored Procedures and user functions were written in MS SQL 2000Tools: Excel VBA 2003, MS SQL 2000

Toronto, Canada Area

 Completed analysis and functional specification for the creation of a new data repository that would hold information on students for 500+ schools, and hold five years of trend data, data was used to produce analytical profiles of each school, and 24 family's of schools Hold whiteboard sessions with senior analysts at the Toronto district school board to determine needs from data, current process used to cleanness data, and current state of data hold whiteboard sessions with third party suppliers of data to create a standard format for the supply of data. Suppliers were (EQAO, safe schools, elementary report cards, demographics, student success indicators, early development indicators, OSLT)  Design and Develop a centralized reporting database to gather different data sources internal and external sources. Generate reports from newly created Data Repository for 500 + schools and 24 Family’s of schools with 5 years of trend data and various graphs and charts. Data Sources are (Demographics, EQAO, Student Success Indicator, Early Development Indicators, Safe School, Elementary Report Card)Tools: Access 2003, VBA, Excel 2003. Design and Develop ETL Process to clean and verify various Data sets from internal and external sources such (EQAO, Report Card, Demographic, Safe Schools Data)Tools: Access 2003, VBA, Excel 2003. Automate Data Matching Process to match student results from external data sources to actual students in the TDSB (EQAO, OSSLT)Tools: Access 2003, VBA Create ad-hoc reports as requested by senior managementTools: Access 2003, VBA, Excel 2003

Computer Programmer And System Analysis Diploma, Computer Programming

Business/Commerce, General, 12

Business Administration Diploma, Accounting