Ray Moore Email & Phone Number

Denver, Co, Us

Chesterfield, Missouri, Us

o Data Engineering, Data Analytics, Automation, Workflow Automation, CRM/PRM, Marketing & Saleso Databases : HANA, Clarity, Oracle, SQL Server 2016-2019, Azure SQL, DataBrickso Designed/Implemented automated tool to Align all USA Hospital data (HIDI) to Clinical Service Lines with Components (Revenue, HCPCS CPT, ICD10/11, Diagnosis, Procedure) allowing Decision Support o Studios : HANA - Graphical/Script, SQL Server SSMS, Visual Studio, Oracle SQL Developer, Power BI, PowerApps, Power Automate o Analytics : Demand Forecast, Facilities, Demographics, Deprivation Score, Disease Prevalence, Insurance Coverage, Labo Marketing & Sales - Digital Acceleration & Integration – SalesForce Cloud, Lead & Patiento ETL : SQL Server SSIS, IBM DataStage, SAP Data Services BODS, ADF, SF . Data Transfer between SalesForce/Marketing/Health Cloud (soql) to/from on-premise SQL Server 2019, Azure SQLo MS Power FX, PowerApps, Power Automate (Flow) - for Marketing, SalesForce, TouchPoint performance, Covid PPE & Vaccine Trackingo Automated alignment of other Hospital data to Clinical Service Lines (Rev, Cpt, Hcpcs, Icd10, Msdrg)o Hana DB Cursors, Dynamic SQL, Functions, Procedures, CV SQL Script, Spark SQL, EPSI, STRATA o Adobe Analytics Data Feeds for marketing web pageso Cisco Call Center SkillGRoup integration with Epic/Clarity datao analyzed health care inpatient/outpatient discharge data from thousands of hospitals and health systems (cpt, proc, icd10, diag, rev) - Hospital Industry Data Institute ( HIDI )

Multiple Clients :• Developmental Pathways: Case Mgmt, Work Flow, Analytics, Healthcare, HCPF Medicaid • Government: Case Mgmt, Quality Assurance, Work Flow, Doc Imaging, Analytics, Architect• Catholic Health Initiatives : Healthcare - Business Intelligence - Operational Analytic• Pfizer /Medivation: Oncology/Urology - Pharma: Data Warehouse, Sales Operations Analytics – SF• Ernst & Young: Financial Services: Data Warehouse & Solutions Architect, Analytics – GA• Kaiser Permanente: Healthcare, Clinical Informatics & Decision Support – Pharma, Disease Mgmt • Orion HealthCorp – Healthcare Billing - Review DB Tables, Queries for Corporate Dashboards • China Manufacturing – Solutions Architect, Market Analysis – replace USA Wholesaler • Forensic Crime Scene Data Analysis Tool for mobile - Discovery Channel, Investigators, Detectives • Rays TeleRadiology - Medical Imaging, Data Analytics, ETL, Sales Force Analytics, Pattern Recognition -CO• ICON - Construction Online Network - Accounting Software for Builders & Banking, Sales Force Automation• Connects: Builders, Subcontractor’s, Field Inspectors, Bankers, Title Companies, Realtors• Electronic Loan App, Draw Request, Invoice Submission, Field Inspection, Loan Status ReportsSQL Server 2016, SSIS-ETL, SSRS, MS PowerApps, MS Flow, Azure SQL, AI, ML

Automate & Streamline Human Services Healthcare processes , work-flow , data-flow & document imaging.Business process Improvements - Application to Benefit Determination.DW Architect (SQL Server EDW , State Level data) , Data Modeling, Erwin, Toad, Sql, Oracle 11/12Consolidation of Server Farm w/ 70 Servers with 650 SQL Server DB's (2005/2008/2012) SSRS, Tableau, MS Access and SAP BOE Crystal Reports Data Migration & Integration (Accela , Cherwell , CarteGraph, CBMS, TRAILS, CYF, ACSES )Master Data Services MDS, Data Quality Service DQS, GIS MappingConceived and implementing XPRESSO, a new low cost, low risk, high impact system for Human Services to automate operations, streamline processes, workflow, data-flow and reduce costs/cycle times to enable timely CSS/CSE/CYF benefit determination and pave the way for same day processing. Completed business analysis with SME's and gained buy-in from key stakeholders. Cost reduction by as much as $1 Million/Year in larger counties. Improved customer satisfaction and I.T. rapport with business units using the first agile/iterative methodology in the county. Xpresso eliminates the need for expensive Scanners, Doc Mgmt Systems, Kofax Image Conversion. RIM Dept FTE's can be reduced or reassigned to do Fraud & Risk Analytics. Concept won National Award in Dec 2018.ITIL (Vers 3), CMDB - automated method to audit all SQL Servers & DB's and populate CMDBDesigned automated Verification & Authentication systemHealthcare Payment, Fraud / Risk, Case Load Trending - by Client, Case, Prgrm, Worker, CountyColorado State Database CBMS / Dss01 / Dss02 / CYF / ACSES, Deloitte, Incident & Help Desk Ticketing (Remedy , Cherwell )Departmental DB Support , Design ( MS Access 2007 / 2010 / 2013 )ETL, E-T-L ( Oracle 11g , DB2 , SQL Server , MS Access ), VS 2010/12Security Clearance (CBI , CGIS)ITIL, Version 3 Cert, CRM/SFDCContinual Service Improvement , Business Relationship Management

Denver, Co, Us

 Automated National Sales Force Operations for 3 Brands (WU, Vigo , Orlandi, TexMex) Managed expert team of 4 Business Intelligence resources Supported 250+ Sales Reps in North America a& Western Europe Coached Sales Reps to use new SFA Tools to increase Revenue, Sales Performance 65,000 Agents in North America generating 75mill Txn’s, $1 Billion Revenue to 200+ Countries Enterprise Data Warehouse Architect for Sales, Marketing, Finance, Legal, ANM,Compliance Data Integration, Migration (ETL), Normalization and scrubbing ( DB2 , Oracle , SQL Server ) Customer Relationship Management CRM for sales reps, stores, prospects, competitors.  Developed system to track/resolve Agent NSF’s by acct reps in Dnvr, Mexico City,Costa Rica  Offshore experience in Western Europe to assist with electronic maps, sales reporting tool  50% Travel in North America and Western Europe to assist/train sales/op teams on SFA Designed Risk Analysis & Assessment application to monitor stores, agents, owners Sales Performance Analysis Score-Card advised Reps of actual Sales versus Quota/Goal Researched Bank Security Act ( BSA ), Financial Crisis Enforcement Network ( FINCEN ) Office of Financial Asset Control ( OFAC ), Financial Action Task Force ( FATF ) Visit Retail Stores in North America, Assist Marketing in Setting up Merchandising, POS, Signs Patents approved for Sales Force Automation, Market and Business Intelligence Evaluated multiple Sales Force Automation tools including Market Intel and Salesforce.com

Dallas, Tx, Us

New York, Ny, Us

Brookfield, Wisc., Us

Business IntelligenceCompetitive Surveillance (Points of Light)Automated Profit Analyis & Reporting (Paris, MS Access, MS SQL Server, SSRS, DB2, Oracle )Risk Analysis, Detection And Reporting (Radar, MS SQL Server, SSRS, SSAS, SSIS)Consumer Profile, Insights , Demographic Demand & Existing Market SaturationSalesForce Automation Money Order , Money Transfer, CheckData & Systems Integration & Data Migration (Oracle, DB2, MS Access, SQL Server)Project Management & Business AnalysisCommon Storefront - Same Store Sales TrendsSix Sigma Training

Denver, Colorado, Us

Atlanta, Georgia, Us

designed complete portable hardware systems for projects and RFP's for Dept of Defense - DOE, DOD, Naval Surface Warfare, US Army CONCOM ($1 Billion LCU Contract)

London, England, Gb

using programming in cobol and fortran our team developed charts of horizons below ground using shock point data electronically transmitted to Denver office - to help determine areas to drill for gas/oil

Chicago, Illinois, Us

Business Analysis, Application Programmer, Dec Vax SystemPayroll, Sales Compensation, Accounts Payable, General Ledger, Accounts Receivable, Bill-Of-Materials, Purchasing, Manufacturing

Smithfield, Virginia, Us

Business Analysis, Application Programmer, Dec Vax SystemPayroll, Sales Compensation, Accounts Payable, General Ledger, Accounts Receivable, Bill-Of-Materials, Purchasing, Manufacturing

I.T.I.L. - Version 3 - Certification, Information Technology Project Management

Business Intelligence Development Studio, Ms Sql Server - Ssis, Ssrs, Ssas, Data Mining

Information Technology & Business Admin, Business Administration

Information Technology & Aerospace Engineeering

Effective Corporate Negotiations, Corporate Negotiations

Enterprise Data Warehousing

Ms Sql Server Olap (Cubes)

Mcse - Network & Opr Sys

I.T., Information Technology

I.T., Aerospace Engineering