Mike Blake Email & Phone Number

Hamilton, ON, CA

Software Consulting Company focusing on providing Custom Software Solutions, Data Extraction and Validation and specializing in Excel and Word VBA applications, Access Databases and Business Reporting. Key clients as a self-employed, incorporated consultant include:TRANSITIONS GROUP NORTH AMERICA. Burlington, Ontario. Jan 2009 – PresentThe Cooperator's.

Monitor Collector & Monitor Updater Applications.Developed Monitor Collector Excel Based VBA Application that:- Creates a distributable custom application with a simple interface for collecting data for each service provider located at a client's site. - Validates, formats & returns the data monthly to Transitions Group's office for analysis. Developed.

Guelph

Member of support team for SIGMA Policy Management System, an RPG/400 Property and Casualty Insurance application supporting clients in Quebec. Primary support of CUMIS I90 Policy Management System and key player in data extraction for conversion to new RSG 2.0 system at I90 retirement in Jun 2015.

• Primary support for I90 Policy Management System, an RPG/400 Property and Casualty Insurance application, troubleshooting issues and providing enhancements. Provided expertise and developed applications including:
• VB.NET applications that:- transfer, format and send Insurance reporting data to Insurance Bureau of Canada; - import, format and export PaySpecialist extract to mainframe Payroll application eliminating manual process.
• COGNOS Impromptu reporting process for Seibel CRM data standardization. Redesigned as Access project linked to SQL Server database to improve efficiency.
• iSeries extract of client Premium & Claims data and calculation of Loss ratios fed to Excel VBA app that formats into publication quality reports.
• Access applications that:- manage clients’ privacy preferences to meet PIPEDIA requirements; -track project performance and status, improving management reporting.
• Excel VBA applications that:- reformat batches of text files to produce formatted Excel Workbooks for Client reporting.- import COGNOS Impromptu reports and produce editable departmental budget plans.

Extracted and validated detailed financial data from ORACLE, PRMS, LAWSON and SUN systems to support audit requirements for CRA, Provincial and International Tax agencies.Created ‘Banking Management’ application in MS-Access to manage and report on all details of all international Bank Accounts and all Individuals related to those accounts. Developed Excel.

• Developed reporting applications and provided Crystal Reports support for the corporate office and 43 branches including:
• Worked with vendor to develop metadata and data requirements for Cartesis budgeting and planning application. Developed ETL process for Cartesis from GL, HR and banking systems using SQL and DTS package.
• Developed Portfolio Reporter application for product/account performance and profitability analysis. Excel VBA interface provides ad hoc reporting and drill down capabilities. Developed queries, views and stored.
• Created FTE Reporter Excel VBA application to measure employee counts compared to budget and post merger plans. Application imports raw data extracts from payroll and HRIS systems and seamlessly produces detailed roll.
• Investigated and rewrote Crystal reports to resolve Cheque printing and G/L Reporting issues caused by ACCPAC upgrade

• Sep. 2001 – Nov. 2001
• Created VBA application in Excel to produce Employee Performance Assessment and Development reporting system, used by employees in all divisions of Maple Leaf Foods. Wrote complementary application to summarize and.
• Enhanced Employee Performance Assessment and Development reporting application to include new evaluation processes and improved user-friendliness of interface. Combined five previous versions into a French and an.
• Wrote two Survey applications using VBA in Excel that collect response information from internal and external clients. Survey design includes customizable questions to allow re-use. Wrote complementary Report and.

• Wrote RPG programs to: automate Monthly and Daily tasks and reports into single step operations
• Wrote programs to recap Premium, Loss and Reinsurance; report Broker Experience status; detail Quota Share Premium and Claims data.
• Developed Excel VBA report processes using I90 source data to provide analysis tools for Pending Renewal Policies and Policy Profiles.

• Hired to support PRMS MRP system and assist with conversion to BPCS ERP system.
• Became in-house authority for: Report development using FormsXpress/OPTIO software; Kronos Computerized Time Systems applications implemented at locations across Canada.
• Produced Applications to track and report Customer complaints; Monitor Customer order fulfillment; and generate other reports from BPCS and PRMS Manufacturing Systems and Kronos Timekeeping data.
• Wrote RPG programs to: update BPCS inventory and plant production from PRMS shop floor data; collect format and validate BPCS General Ledger data and export to PC based Hyperion accounting system.
• Created Shipping Management Application in Microsoft Access that evaluates delivery costs, shipping cost and fixed costs and provides detailed reports on cost effectiveness of Delivery Processes.

 Developed application based on Constraint Theory to calculate product profitability relative to manufacturing resources. Defined specifications, trained users, developed enhancements with Clients’ management and production workers and led development team. Marketed application and related consulting services to prospective clients throughout North America.

 Consulted to clients on AS/400, System/38 and System/36 systems. Analyzed client requirements; developed specifications with users; performed feasibility studies; devised and implemented solutions. Tested, debugged and rewrote EDI (Electronic Data Interchange) application to update PRISM COM Module using data transferred via GE*Express EDI*PC software.

 Developed strong understanding of Business Operational, Merchandising and Financial systems during 12 year career through ‘Best in Retail Industry’ management training program, culminating as Manager of Kmart stores in Sarnia and Burlington, Ontario with respective annual sales of $7 million and $9 million. Coached staff and management to achieve.

Vb .Net, Asp.Net

Economics, Statistics

Part-Time Degree Studies

German

• Computer Programming And Systems Analysis Diploma