David Macmaster Email & Phone Number

Oak Creek, CO, US

Oak Creek, Colorado, United States

A remote position supporting Elixir pharmaceutical solutions.The job entails analyzing requirements, interacting with business to clarifyrequirements, modifying/creating shell scripts and modifying/creating Oracle procedures and packages to meet business requirements.

Oak Creek, Colorado, United States

A remote position supporting IBM with NextEra Energy projects in the Solar,Wind and Stored Energy domains in a Data Engineer / PL/SQL Developerrole.

Oak Creek, Colorado, United States

Searched unsuccessfully for a remote position. Most, ifnot all, recruiters had remote projects available until after COVID. I preferred notto relocate during this time. I did not know what “after COVID” looked likeso I couldn’t in good faith commit to pursue these projects.

Indianapolis, Indiana, United States

-Assigned to a Fiserv contract to support Fiserv’s Department of Education and commercial student loan portfolio by modifying and creating packages, procedures, functions and triggers per business requirements.-Moved Oracle 12c databases to a new datacenter using DBCA, EXPDP, and IMPDP utilities.

Dallas-Fort Worth Metroplex

- Assigned to a Rexel contract to extract and load data from Oracle and SQL Server databases using Informatica PowerCenter 10 into an Oracle data warehouse per customer requirements for analytics and reporting.- Created and modified packages and procedures to process data used by views created for the analytics and reporting team.- Created views and.

Englewood, Colorado, United States

- Created new packages and procedures for ESPS and DICE applications to meet DISH Networks external payments business requirements. - Enhanced application performance by tuning SQL statements.

Rockville, Maryland, United States

- Created new packages, procedures, triggers, functions, modified existing packages, procedures, triggers, and functions to meet new business requirements, and fix existing bugs in claims processing and in the healthcare cost management application using PL/SQL running on Oracle 11g/12C databases.- Loaded data into Oracle instances on an ad hoc basis for.

Overland Park, Kansas, United States

- Developed, modified, and tested PL/SQL packages in Sprint’s Centralized Reporting Online system for customer service metrics and customer satisfaction reporting. - Participated in code reviews with other team members.- Loaded data into SQL Server for Sprint Service Trender testing.- Wrote/modified SQLLDR scripts to load data into Oracle 11g database.

Pittsburgh, Pennsylvania, United States

- Loaded and processed claim data into an Oracle 11g data warehouse from SQL Server databases using SAS DI Studio 4.2, SAS 9.2, and PL/SQL.- Set up SQL Servers 2008 for Development and Test environments.- Upgraded Team Foundation Server 2008 to 2010 for evaluation and testing.

Washington DC-Baltimore Area

- Created Network Control Review Board requests for network system connectivity to remote applications and databases.- Generated and deployed PL/SQL, Java and Visual Basic software builds for DEV, SIT, CAT, and Production environments using SVN and Ant scripts.- Ran predictive performance tests for the upgrades of the Surface Air Support System, Surface.

Cerfificate, Medical Billing And Coding, A - 97%

Medical Billing and Coding program which covered ICD-10, CPT, and HCPCS Codes, and the overall Revenue Cycle Management process.

High School Diploma