Consultant

• Jan 2023 - Present

President

• Oct 1996 - Present

Successfully operate an independent consulting firm providing business-intelligence services. Successfully operate an independent consulting firm providing business-intelligence services.

Certified, Epic-Clarity Consultant

• May 2021 - Dec 2022

Duties: * asssisting in the implementation of the PECARN registry (pecarn.org). * creating data extracts from Epic's Clarity database. Duties: * asssisting in the implementation of the PECARN registry (pecarn.org). * creating data extracts from Epic's Clarity database.

Consultant

• Nov 2019 - May 2021

* Implementing Windows Virtual Desktop environment * System's integration work, using PowerShell, with FuelCloud's REST API * System's integration work, using PowerShell, with Geotab's JSON-RPC API * System's integration work with Intacct * System's integration work with Salesforce (planned) * Implementing Windows Virtual Desktop environment * System's integration work, using PowerShell, with FuelCloud's REST API * System's integration work, using PowerShell, with Geotab's JSON-RPC API * System's integration work with Intacct * System's integration work with Salesforce (planned)

Certified, Epic-Clarity Consultant

• Jul 2019 - Oct 2019

Certified, Epic-Clarity Consultant

• Nov 2018 - Jul 2019

Developing Crystal Reports and Web-Intelligence solutions, for ADT, Cadence, EpicCare, Optime, and Phoenix modules. Developing Crystal Reports and Web-Intelligence solutions, for ADT, Cadence, EpicCare, Optime, and Phoenix modules.

Certified Epic-Clarity Consultant

• Jul 2016 - Apr 2018

Developing Universe (UNX,UNV) and Web-Intelligence solutions for their ValleyCare-integration project, for ADT, EpicCare, Optime, Stork, and Willow modules. Developing Universe (UNX,UNV) and Web-Intelligence solutions for their ValleyCare-integration project, for ADT, EpicCare, Optime, Stork, and Willow modules.

Certified Epic-Clarity Consultant

• Apr 2016 - May 2016

RESPONSIBILITIES * Designed and developed reports to support their Clarity and Star implementation. RESPONSIBILITIES * Designed and developed reports to support their Clarity and Star implementation.

Certified Epic-Clarity Consultant

• Oct 2015 - Mar 2016

* Design and develop (Webi, Crystal Reports) reports to support their Phoenix implementation. * Design and develop (Webi, Crystal Reports) reports to support their Phoenix implementation.

Certified Epic-Clarity Consultant

• Sep 2014 - Oct 2015

RESPONSIBILITIES o Creating Clarity data extracts (~100 to date) to support CHoA’s research initiatives. o Assessing data from SQL Server 2012 implementation of Clarity; ADT, ASAP, Beaker, Epicare Ambulatory, Epicare Inpatient, OpTime, and Willow modules. o Acting as analyst and developer. DEVELOPMENT / DOCUMENTATION o Developed T/SQL functions and procedures to support extraction work. o Used SQL Server’s Geography data type to perform geo-spatial queries (e.g find the closest clinic for each patient based on their respective postal codes); made architectural recommendations to DBAs to support more-granular queries (I.e. street address). o Created common-language runtime (CLR) function that adds regular-expression support to SQL Server. Used to extract text snippets from HNO notes. o Developed SQL Server Management Studio snippets to increase productivity. o Managed Git (http://www.git-scm.com) repositories. o Experimented with test-driven, database development (http://dbfit.github.io/dbfit). o Generated HTML documentation using Asciidoc. o Promoted the use of a wiki (https://github.com/gollum/gollum) as a shared knowledge base. WORKFLOW / PRODUCTIVITY o Created work-flow enhancement tools (semi-automated build and distribution scripts) using PowerShell. o Wrote a PowerShell module to interact with SharePoint (https://github.com/craibuc/PsSharePoint) and Outlook (https://github.com/craibuc/PsOutlook). o Developed Clarity code snippets (SQL code blocks that can be easily assembled with one another). o Wrote a Ruby/Sinatra-based website that makes the Clarity data-dictionary tables more useful. o Used Chocolatey (https://chocolatey.org) to manage Windows-based “packages”. Show less

Certified Epic-Clarity Consultant

• Feb 2011 - Aug 2013

• Design and developed reports to support a variety of inpatient-reporting needs. • Design and developed Oracle components to simplified and standardized to the Clarity data model. This layer of indirection, implemented with views, decreases development and maintenance time while increasing quality. • Implemented a report-documentation system using MediaWiki. • Designed and developed a “derived table” (Epic speak for custom table and procedure to populate it) to simplify IEV events. • Developed BusinessObjects BusinessView (a semantic layer) that supports the Clarity reports’ dynamic/cascading parameter needs. Developed a tool to assess the impact of changes to the ‘BusinessView’. • Developed a single-sign-on authentication prototype that connected Epic’s Hyperspace to BusinessObjects’ InfoView (the reporting ‘desktop’). The goal of the project was to temporarily supplant the use of the Epic-Crystal integration component. • Developed a report-distribution strategy that leverages the use of BusinessObjects’ Publication architecture. • Assisted in BusinessObjects Enterprise administration. Show less

Certified Epic-Clarity Consultant

• Feb 2010 - Jan 2011

• Supported client’s Accountable-Care-Organization (ACO) and Care-Model-Innovation (CMI) initiatives. • Designed and implemented executive-level dashboards for numerous financial and productivity measurements. • Developed BusinessObjects Universe, Web-Intelligence, and Oracle-based ETL components to support dashboards. • Supported client’s Accountable-Care-Organization (ACO) and Care-Model-Innovation (CMI) initiatives. • Designed and implemented executive-level dashboards for numerous financial and productivity measurements. • Developed BusinessObjects Universe, Web-Intelligence, and Oracle-based ETL components to support dashboards.

BusinessObjects Consultant

• Oct 2009 - Jan 2010

I developed a Java utility to simplify the deployment of Universes and WebIntelligence (WebI) templates. I developed a Java utility to simplify the deployment of Universes and WebIntelligence (WebI) templates.

Certified Epic-Clarity Consultant

• Aug 2009 - Dec 2009

• Developed complex, OB reports based on concept and flowsheet data, including medical-record audits. • Developed database components to simplify the Clarity data model for deliveries, ADT, and flowsheets. • Developed complex, OB reports based on concept and flowsheet data, including medical-record audits. • Developed database components to simplify the Clarity data model for deliveries, ADT, and flowsheets.

Consultant

• Jan 2009 - Oct 2009

I developed a number of reports for their permit-management system. I also helped design an enhancement to the system that allowed them to have more accurate reporting. I developed a number of reports for their permit-management system. I also helped design an enhancement to the system that allowed them to have more accurate reporting.

Consultant

• 2009 - 2009

BusinessObjects Consultant

• Oct 2007 - Nov 2008

I was commissioned to integrate enterprise-class reporting with their project-portfolio management (PPM) system; the solution was based on BusinessObjects’ service-oriented architecture (SOA). The result was a visually-compelling, cross-functional set of analytics that helped increase the PPM system’s visibility and sped its adoption by other Wells Fargo divisions. I was commissioned to integrate enterprise-class reporting with their project-portfolio management (PPM) system; the solution was based on BusinessObjects’ service-oriented architecture (SOA). The result was a visually-compelling, cross-functional set of analytics that helped increase the PPM system’s visibility and sped its adoption by other Wells Fargo divisions.

Business-Intellignece Consultant

• Feb 2006 - Sep 2007

• Developing a high-level, long-term migration plan to move from an internally-developed Business Intelligence portal to Business Objects Enterprise XI. In the short run, he created a transparent, simplified interface between the portal and BOE XI. • Designed and developed an application to collect and analyze product usage for their textile division. This architecture reduced the complexity of data collection, increased quality and simplified the business process. • Developed a row-level-security prototype using Crystal Reports XI and the BusinessObjects Universe. This prototype includes both data security and parameter security. This was especially challenging as the Universe’s integration with Crystal Reports XI is limited. • Prototyped a report-localization architecture for their international reports. This strategy used a less-known feature of Crystal Reports to dynamically alter labels depending on a workstation’s localization settings. This architecture works for both scheduled and ‘on-demand’ reports. • Created numerous Crystal Reports based on SAP’s BW. Created prototype reports using Business Objects’ OLAP Intelligence (OLAPi) based on SAP’s BW Analytical Services. • Improved Ecolab’s SAP BW integration with Business Objects Enterprise XI using OLAP Intelligence. • Developed a reusable, JavaScript application to simply the coding necessary to generate a Business Objects logon token that is created by an internally-developed, and wholly undocumented, BOE XI authentication webservice. • Developed solutions to address the limitation of Crystal Reports’ integration with Business Objects’ Universe, specifically with dynamic-cascading-parameters. Show less

Certified Epic-Clarity Consultant

• Dec 2004 - Nov 2005

• Rapidly becoming a technical expert on Clarity’s CliniDoc, ADT, Rx and Optime modules without any formalized training. • Using his new-found expertise to assist Epic Systems’ effort to improve the usability of Clarity’s data model. • Developing Oracle components to simplify reporting on Clarity’s data. • Authoring Oracle components to simplify reporting on Admissions, Discharges and Transfers (ADT). Simplification included removing bed transfers and adding hospital-outpatient visits. • Authoring Oracle components to simplify reporting on flowsheet data, which included converting selected flowsheet rows into columns. • Developing a customization for Crystal Enterprise 10 and XI’s ePortfolio to allow a report to be scheduled once with a large data set, but filtered by its parameters when viewed. This customization is called View-Time Parameters. • Authoring a Microsoft Access-based application, called ReportSmart, to track reporting projects. Creating a component to extract a report’s metadata. • Authoring knowledge-base files for Crystal Reports, Epic Care and Oracle. • Mentoring staff in the use of Crystal Reports, Crystal Enterprise and Oracle. Show less

Senior Consultant

• Jun 1995 - Oct 1996

Senior Consultant

• Mar 1993 - Jun 1995

Developed enterprise-class, client-server applications to Fortune 500-class companies. Developed enterprise-class, client-server applications to Fortune 500-class companies.

Consultant

• 1992 - 1992

Consultant

• Dec 1988 - Jul 1991