Richard Kingma BSc.

Database Administrator/Business Analyst/Application Developer

ac96ac@r.postjobfree.com 613-***-****)

Summary of Experience

I am a Microsoft Great Plains Administrator / Database Administrator. I have analyzed, designed, documented, developed, tested, implemented and supported numerous types of applications in a large number of technical and business environments with a variety of development tools. I have extensive manufacturing, pharmaceutical, health, marketing and government experience.

Application Experience (partial list)

- Enterprise Resource Planning (ERP) - Customer Relationship Management (CRM)

- Data Warehousing and Reporting - Business Planning Systems

- Clinical Study Management - Material Management Systems

Technical Skills Summary

Databases:

- SQL Server (16 years) - Oracle (12 years)

- DB2 (8 years) - IMS (6 years)

Tools:

- SLQ Server 2000, 2005, 2008 R2, 2012, 2016 (including SSRS, SSAS) (Management Studio, Visual Studio, Various Database Tuning and Analysis Tools) (14 years)

- Microsoft Dynamics Great Plains and related applications

- Microsoft Sharepoint (MOSS and Foundation Server) (5 years)

- Microsoft Internet Information Services (10 years)

- Active Directory (10 years) - VMWare (10 years)

- MS Office (2016, 2010, 2007, 2003) (16 years) - Informatica (1 year)

- Holos, Hybrid OLAP Tool (9 years) - Crystal Enterprise/Reports (5 years)

- SSRS (12 years) - Business Objects (1 year)

Languages:

- PL-SQL, SQL Plus / SQL (25 years) - Visual Basic (5 years)

- C# (4 years) - COBOL/JCL (8 years)

Operating Systems:

- Windows (XP, Vista, 7, 8, 10, Server 2008 R2, 2012, 2016) (25 years)

- HP-UNIX V10.01, V10.20, V11.0 (3 years) - SunOs (1 year)

- AIX (1 year) - MVS/ESA (9 years)

Methodologies:

- SDLC (System Development Life Cycle) (25 years)

- ITIL (2 years)

Education:

- Bachelor of Science, Honors Applied Physics, University of Waterloo, 1987

- Engineering Systems Development Program, EDS, 1989

Business Skills Summary

May 2008 United Counties of Leeds and Grenville, Brockville, Ontario

to Oct 2018 Database Administrator/Business Analyst – All Counties Enterprise Applications

Installed and administrated SQL Server including SSRS, SSIS and SSAS

Performed numerous SQL Server upgrades to versions 2005, 2008 R2, 2016 and 2016 R2.

Installed, upgraded, configured and customized SQL Server applications including: Microsoft Dynamics Great Plains / Diamond Software and Extensions (ERP, Accounts Payable, Account Receivable, Canadian Payroll, Human Resources, Purchasing, Inventory, Asset Manager modules), Microsoft Dynamics Business Portal (Sharepoint based Great Plains interface with HR Self-Serve), electronics Timecards, Accounting, Purchasing, Inventory modules), Rockton Auditor (Great Plains Auditing), Mekorma MICR (Check printing enhancement), FRx (Financial Reporting ) Anyview IDS (Web Report Designing), Worktech (Work Manager and Asset Manager), Helpstar/ServicePRO (Help Desk), Yardi (Property, Asset and Investment Management), Electronic Content Management System (Customized Sharepoint Team Sites/Document Repository), CAMS (Court Administration Management System), OCCMS (Ontario Child Care and Management System) and Orion (Geographical Information Systems)

Provided report development / Business Intelligence services to clients for all SQL and Web based business application using SQL Server Reporting Services

Built interface between Microsoft Dynamics Great Plains Business Portal and Diamond Municipal Solution Software Time Banks. Vendor has not yet developed this solution.

Analyzed customizations of projects prior to arrival such as the Microsoft Dynamics Great Plains / Yardi interface, (resulting in 90% reduction in development effort, 100% reduction of data replication, 90% reduction in system complexity and significant improvements in business process and ease of use.)

Provided consulting services to team and users on a project or enquiry basis according to the IT standards and procedures.

Developed, implemented and maintained programming and systems development infrastructure

Instituted Change Management Systems for all systems

Managed and prioritized issues with vendors in conjunction with user requirements

Assisted first level support staff in problem resolution.

Developed, reviewed, approved and/or executed Project Plans, Project Estimates, System Test Plans, Business and Functional Requirements, Installation Instructions, User Acceptance Tests and Supporting System Documentation,

Documented, coordinated and tracked all issues to resolution using Helpstar.

Migrated all SQL applications from SQL Server 2000 to SQL Server 2005 to SQL Server 2008 R2 to SQL Server 2016.

Mediated Business Processes and responsibilities for departments within the County

Tested, documented and performed upgrade of Microsoft Dynamics Great Plains from Version 9 to Version 10 to Version 2010 to Version 2013 to Version 2016.

Received Nomination for Overall Excellence Award from Diamond Municipal Solutions

Tools used: Windows (10, 8, 7, 2008 R2, Vista, 2003, XP and 2000), SQL Server 2016, 2012, 2008 R2, 2005 and 2000, Microsoft Great Plains (10, 2010, 2013, 2013 R2, 2016), Microsoft Sharepoint (2007 and 2010, MOSS and Foundation), Microsoft Active Directory, Microsoft Internet Information Services, Solar Winds, Crystal Reports XI, VMWare Server Virtualization, ServicePro/Helpstar 2008, MS Office (2016, 2010 and 2007)

Business Skills Summary

Aug 2006 Abbott Laboratories, Chicago, Illinois (1 month contract extended to 14 month contract.

to Apr 2008 Working from home 75% of the time)

Senior Oracle Clinical Analyst / Clinical Studies Management System

Performed analysis for implementation and customization of Perceptive Informatics “IMPACT” (a Clinical Trials Management System) software and Cognos custom reports.

Developed, reviewed, approved and/or executed Project Plans, Project Estimates, Validation/Test Plans, Business and Functional Requirements, Installation Instructions, Validation Test Scripts, Traceability Matrixes, System Design Documents, System Configuration Documents, Supporting System Documentation, Project Release Notes and System Certifications.

Documented, coordinated and tracked all issues to resolution.

Tools used: Perceptive IMPACT, Cognos Reportnet 1.1, Cognos 8.2, MS Office Professional (Word, Excel, PowerPoint, Visio, Project), Lotus Notes, Oracle 10i

March 2007 Seltech Electronics, Milton, Ontario (contract to deliver Material Management and

to July 2007 Purchase Generation reports)

Senior Analyst / Crystal Reports Developer

Created cost estimates based upon user requirements for reports.

Developed System Design based upon requirements and existing Syspro (ERP) database.

Developed complex Crystal Reports requiring the generation of purchase orders for suppliers based upon current stock, previous purchase orders, sales orders and various lead times.

Created Detail and Summary Reports for users.

Interfaced with business end user while developing, finalizing and delivering reports.

Tools used: Crystal Reports XI, SQL, Windows XP

Jan 2006 Abbott Laboratories, Chicago, Illinois (6 month contract extended to 8 month contract)

to Aug 2006 Senior Oracle Clinical Analyst / Oracle Clinical

Performed analysis for implementation of Oracle Clinical Consolidation and Oracle Clinical Upgrade projects.

Developed, reviewed, approved and/or executed Project Plans, Project Estimates, Validation/Test Plans, Business and Functional requirements, Installation Instructions, Validation Test Scripts, Traceability Matrixes, System Design Documents, System Configuration Documents, Supporting System Documentation, Project Release Notes and System Certifications.

Documented, coordinated and tracked all issues to resolution.

Tools used: Oracle Clinical, SQL Server 7.0, Analysis Services, Query Analyzer, Windows XP, MS Office Professional (Word, Excel, PowerPoint, Visio, Project), TOAD

Business Skills Summary (continued)

Sept 2005 Promoworks Chicago, Illinois (8 week contract to replace employee on maternity leave)

to Nov 2005 Senior Data Warehouse Analyst

Interfaced with business end user to document, analyze and prioritize user requirements.

Developed specifications, user manuals and system documentation.

Documented, coordinated and tracked all issues to resolution.

Performed weekly upgrade release testing for web application for external clients.

Provided end user training to other Promoworks personnel.

Tools used: Crystal Enterprise/Reports, SQL Server 7.0, Analysis Services, Query Analyzer, Windows XP, MS Office Professional (Word, Excel, PowerPoint, Visio, Project), TOAD

Nov 2004 Acxiom Corporation Chicago, Illinois (6 month contract extended to 9 months)

to July 2005 Senior Analyst – CRM and SLA Reporting

Developed and executed test plans for customized CRM and Service Level Agreements reports for a large automotive client.

Developed and presented test plan templates for QA team.

Provided technical support and leadership to QA team.

Documented, coordinated and tracked all issues to resolution.

Tools used: Oracle 9.0.2, PL/SQL, Cognos, TOAD, HP Unix, SQLPlus, MS Excel, Windows XP, WSFTP

Sept. 2000 Abbott Laboratories, Chicago, Illinois (6 month contract extended to 4+ years)

to Nov 2004 Oracle 9i Migration Analyst – All CRM Applications

Tested migration of all potential customer applications from Oracle 8i to Oracle9i for a large financial client.

Developed and executed test plans for all major potential customer mailings applications in Oracle 8i and 9i environments.

Analyzed Oracle 8i and 9i environments and application inputs and outputs to ensure compatibility.

Analyzed execution data to compare performance between Oracle 8i and 9i environments.

Documented, coordinated and tracked all issues to resolution.

Tools used: Oracle 8.1.7 & 9.0.2, PL/SQL, Ab Initio, TOAD, HP Unix, SQLPlus, MS Excel, Windows XP

Business Skills Summary (continued)

Sept. 2000 Abbott Laboratories, Chicago, Illinois (6 month contract extended to 4+ years)

to Nov 2004 Senior Data Warehouse Developer – Siebel Reporting – Pharmaceutical Product Div.

Participated in development of Informatica ETL and Business Objects Reporting application built from Siebel Data Warehouse.

Translated business requirements and functional specifications into Oracle SQL scripts.

Developed standards and techniques.

Created test script to test functionality, integration, performance, volume and usability.

Executed Oracle SQL scripts and test plans.

Documented, coordinated and tracked all issues to resolution.

Tools used: Oracle 8.1.7, PL/SQL, TOAD, SQLPlus, Active File Compare, MS Excel, Infomatica, Business Objects, Windows 98/NT 4.0/2000 Workstation and Advanced Server

Senior Data Warehouse Developer – Manugistics Reporting – Abbott International

Participated in development of Informatica ETL and Cognos OLAP/Reporting application built from Manugistics Data Warehouse.

Translated business requirements and functional specifications into Oracle SQL scripts.

Developed standards and techniques.

Created test scripts to test functionality, integration, performance, volume and usability.

Executed test plans and Oracle SQL test scripts.

Documented, coordinated and tracked all issues to resolution.

Trained and coordinated other personnel.

Tools used: Oracle 8.1.7, TOAD, SQLPlus, Active File Compare, MS Excel, Informatica, Cognos, Windows 98/NT 4.0/2000 Workstation and Advanced Server, HP Unix

Senior Systems Architect – Sales Forecasting and Reporting – Hospital Products Div

Enhanced and supported an existing OLAP (Holos) application (SMART – Sales Marketing and Reporting System, an executive forecasting and Sales reporting system).

GPO project (Group Purchase Organization) enhancement increased the functionality of the existing application ($1,200,000 project).

Gathered user’s business requirements and analyzed current application and environment.

Created specifications for relational database, multidimensional database and application.

Developed and tested multidimensional database and application changes.

Specified data migration requirements for OLAP application.

Successfully coordinated implementation of hardware, database and application changes.

Participated in 21 CFR Part 11 validation classes.

Tools used: Holos 7.0B/C & 8.0A (client/server Reporting/OLAP tool), Oracle 7.3.4.4, & Oracle 8.1.7, PL/SQL, Windows 98/NT 4.0/2000 Workstation and Advanced Server, MS Project, Access 2000/Visual Basic

Business Skills Summary (continued)

May. 1997 Crystal Decisions, Toronto, Ontario (6 month contract extended to 3+ years)

to July 2000 Senior Pre-Sales/Post Sales Consultant

On contract to Crystal Decisions as Senior consultant to provide pre-sales and post-sales consulting support services to Crystal Decisions’ clients.

Primary duties included client demonstration of Crystal Decisions’ products including Crystal Enterprise and Holos, designing database/application architectures for clients, responding to questions and Request For Proposals, and client problem resolution.

Designed/constructed/implemented numerous Holos pilot applications given the application requirements and a 5 day development period.

Tools used: Holos 6 & 7 (client/server Reporting/OLAP tool), Crystal Enterprise, MS ACCESS 2000 / VBA, MS Frontpage, Oracle 7.X, PL/SQL, Windows 98/NT 4.0/2000 Workstation and Advanced Server, Red Brick, SQL Server, Sybase, Various Unix

Nov. 1996 Price Waterhouse / Global Software Solutions, Ottawa, Ontario

to May 1997 Senior Architect/Programmer/Analyst - Business Planning System

On contract to Price Waterhouse (Ottawa) to develop a Business Planning System pilot application for the Canadian Heritage and Health Canada departments of the Canadian Federal Government

Responsible for programming all dimensions, structures, rules, models, reports and database (Oracle) interfaces

Responsible for the setup of Oracle tables in multiple environments

Performed installations of Holos, Oracle and Business Planning System (both client and server programs) at remote sites

Tools used: Oracle, PL/SQL, SQLplus, Holos 5.0(client/server OLAP tool), Sun Unix, Windows 3.11, Windows 95, Windows NT

Feb. 1993 Canadian Pacific Railway Systems

to Nov. 1996 Senior Architect/Programmer/Analyst - Data Warehouse/Cost Analysis System

Senior Programmer/Analyst - Locomotive Information For Effective Maintenance

Senior Programmer/Analyst - Electronic Grain Releasing System

Senior Programmer/Analyst - Integration: SOO Line Railway and CPR systems

Tools used: Oracle, SQLPlus, PL/SQL, Holos(client/server OLAP tool), HP-UX V10.01, AIX, DB2, SPUFI, QMF, COBOL, Windows 3.11, Windows NT, OS/2 2.11, TSO/ISPF, JCL, MVS/ESA, SAS, HP9000/K400, IBM RS/6000, Visual Basic, Project Scheduler 6.0

Sept. 1987 Electronic Data Systems (EDS) - Customer: General Motors

to Feb. 1993 Team Leader, Systems Engineer - New Employee Experience Rating project (NEER)

Systems Engineer - International Export Sales (IES)

Systems Engineer - Product Engineering

Contact this candidate