Maurice M Email and Phone Number

Data Warehousing and Business Intelligence - Clinical Data (EHR)Mining clinical data from multiple data sources for: Research projects, Accreditation and Quality Improvement, COVID 19, Medication Use and Tracking, Order and Order Set Usage. Data Provisioning: Accounting/Costing, Clinical Data, Workload Measurement, Government Reporting.Application Support - SOS Workload Measurement System. 2022 Update. Retired this application written in 1996 in April 2022. FoxPro and Oracle based. Good application, just no longer supportable.Microsoft BI - SSIS, SSRS, (2013-2018: SSAS, SharePoint)Microsoft - PolyBase Implementation (in use for Oracle and SQL Server).Visual Studio 2017Data Analysis, Extraction, Transformation, AnalyticsPowerBI for hosting reports usually developed in SSRSTableau - Really just support for inherited workbooksSQL Server - Oracle - and a little FoxPro ;-)Converted: IBM Cognos Data Manager to MS SSIS IBM Cognos Reports to MS SSRSSybase (SAP) PowerDesigner *** Not recently ***Data Sources:Allscripts - Sunrise Clinical Manager - Electronic Health Records - EHRInfomed - Promiso (Workload Measurement and Recording)Retired this application April 2022 ...SOS - In-house workload measurement systemOther Clinical Data SourcesCo-op Student MentorDesire to learn and grow. Learning is energizing, and we all have so much more to give.Epic Systems:--Cogito Proficiency--Caboodle Data Model Proficiency--Clarity Data Model Proficiency--Clinical Data Model Proficiency

Business IntelligenceETLData Quality ManagementConverted Cognos (DataStream, Lookup, SQL) to MS SSISConverted Cognos Impromtu Reports to SSRSDeveloped new Cognos DataStream DeliveriesUsed SSRS for Reports (DB Monitoring)MS Sql Server and Oracle Monitoring and MaintenanceSQL Coding in Oracle and SQL Server

Experience described below:Military, Banking, Transportation, Health CareBusiness Intelligence - 2013 - Data Architect/Modeler (Oracle Designer, Sybase PowerDesigner) - 2008-2012Database Administration (DBA) - 2002-2008Metadata Management - 1992 - 2002Systems/Business/Programmer Analyst - 1983 - 1992Accounting 1973-1983

Fast Track Program, complete BI process from Analysis, Dimensional Modeling, ETL to Dashboards on SharePoint.I enjoyed this Business Intelligence / Data Warehouse program immensely, and especially enjoyed helping other students who were learning much of the program content for the first time.

Warehouse distribution. Material selection, packaging, directing, and inventory checks.

2008 - 2012 Data Architect / Data ModelerData Modeler various subject areas (Equipment, Shipment, Track, ...).Oracle Designer - 3 yearsSybase PowerDesigner - 2 yearsPhysical and Logical Data ModelingData Analysis, Data Investigation, Data DiscoverySQL Development, Impact AnalysisMeta Data Repository Administration, Change Control, Security2001 - 2008 DBA - Oracle with some work in SQL ServerOracle Database Administrator (UNIX, Shareplex Replication)Emphasis in application development support.Data Migration for Oracle 8i to 10g.Data movement for testing and development support.Security Administration for Users and Roles.1998 - 2000 Data Analyst - Meta Data Repository AnalystAdministrator Platinum / Computer Associates PR/MVS Repository.IBM MainframeMeta Data ManagementSAS, REXX, DB2, JCL

1992 - 1998 Data Analyst, Meta Data Repository PR/MVS (Reltech/Platinum/Computer Associates).Standardization of data objects, copybook generation, repository maintenance and modification.SAS, JCL, REXX/Clist1992 - 1993 OKRA’s TotalMarketer. CRM Support1990 - 1992 MasterCard Accounting. CardPac System. Implementation. COBOL, CICS.MasterCard conversion project: FDR (First Data Resources) to CardPac.Responsible for accounting implications.Provided coding, analysis, and design for program interfaces.Wrote functional specifications and design guides.Supported the care and feeding of OKRA Marketing Software from mainframe to PC.

LCC #33 consists of 150 Townhouse Condominium Units Negotiated bank loan for major condominium renovation.Solicited RFQ'sInterviewed applicants for jobs around the complex.Collected overdue accounts.Enforced condominium bylaws.Authorized and paid condominium expenses.Presented Financial Statements at annual general meetings.

EDP Audit DepartmentBusiness Analyst / Systems Coordinator / Developer 1985-1988Created GUI interface to Audit Tools. CAATs - Computer Assisted Audit Tools.Created and automated generation of Audit Papers, random selection of audit items from mainframe files.Provided training to Audit Departments in London and Toronto for use of automated auditing tools.Credit Card SystemsBusiness Analyst / Systems Coordinator 1981-1984First Data Resources (FDR) Credit Card SystemCreated self serve reporting system for Credit Cards business users.Automated accounting functions within the Credit Card Department.Coordinated system changes for department.SAS, Easytrieve, CLIST, ISPF.Accounting Officer 1979-1981Credit Card accounting, interchange balancing, chargeback processing, assisted and reviewed work done by accounting clerks.Assisted external auditors during audit reviews.

Accounting and PayrollVictoria, BC; Borden, Ontario; Halifax, NS (HMCS Preserver)