David Mcbride Email & Phone Number

Retired

Sterling, Virginia, Us

Enhance database schema, and create api to connect to UI pages.

Radnor, Pa, Us

Lead team that crafts sql and python functions to facilitate data transfer and maintain data integrity. Creating migration scripts for ETL process from internal operation systems to Operational Data Stores.Contract ending 10/1/2022.

Maintain and enhance schema for data warehouses stored in SQL databases; create and enhance Informatica extract and load flows for data movement. Craft sql to facilitate report generation, maintain data integrity, and insure proper performance objectives. Creating migration scripts for ETL legacy data ito join it with operational data in Star Schema configuration stored on SQL Server.Created Redshift cluster on AWS, will join cluster with Spectrum to understand this new technology.

Designed & enhanced analytical data warehouse using Postgresql database for medical claims processing. Initiated automated claim rate verses rework rate measure to help management effectively modify operational activity to maximize profits.Used SQL database and Python to create multiple homogeneous Medical Charges data warehouse based upon inherited table design within overall schema. Created an analytical data warehouse for workflow data which is integrated with charges & claims data warehouses to report on the claim resolution process. Working to identify throughput, bottlenecks, and maximize capacity utilization to reduce costs and reduce average AR days. Used decision tree and decision rules to produce classification values for charge records.Designing data models and reports using Dimensional Insight's BI tool set to view the information extracted from the data warehouses. Began migration to Pentaho by creating first ETL process for AR model. Enhanced data warehouse to set up Star Schema for data mart.

Work directly with clients to manage projects, design, implement, integrate, and maintain custom cloud-based business applications using Linux or Windows servers, databases (Postgresql, Oracle, MySQL, SQL Server) technologies (Open ACS, PHP, C#, node.js, django), and client side technology of javascript, jQuery, Ajax, and ExtJs, using the Agile methodology for various industries. Using SAS to combine data streams into a data model for continuous data evaluation process. Predictive Analytics certificate.

Sunnyvale, Ca, Us

Development Manager of software engineering group. Duties included project management and management of engineers contributing to database driven web pages for website in financial planning tool industry. Code changes were released weekly.

Waterloo, On, Ca

Development Manager of software engineering group. Duties included project management, problem escalation management, maintenance resource allocation, staff hiring, 2 releases of e.Reporting Software application. Grew team to 15 engineers. Delivered Suite 4 and Suite 5 versions of e.Reporting application.

Project management and team management of 5 architect engineers that created universal data model document for ERP system for customer; ERP system consisted of 5 best of breed large database applications. Initiated messaging system Application Object Broker (AOB) project, architected & wrote first prototype. Interfaced with and gathered requirements from user divisions to meet customer needs. Staffed development team to 8 engineers. As software engineer, created, & implementing API for applications to remotely interface with network control processes for the Oracle 8 project. Initiated product creation, designed Client Status Monitor for release with Oracle 7.3, wrote specification. Wrote automated test programs which raised product quality. Process Improvement: Improved server lab set up time from 2 weeks to 2 hours by implementing standard procedures and automating tasks.

Certificate, Predictive Analytics

Mba

Bscs, Computer Science