Marcus Dyer Email & Phone Number

Santa Barbara, Ca, Us

• Currently leading a team of 4 developers on the re-design and rewrite of our current client server PL/SQL and web-based applications to ASP.NET in C# and Angular2 using MVC methodology in mixed database environment (MS SQL Server and Oracle). Utilizing RESTful calls for GET and POST of data to an offsite vendor data repository.• Researched different options for implementation of source control that would work with the ASP.NET rewrite project as well as the company’s current legacy systems. Implemented Microsoft’s cloud-based source control solution Team Services from scratch in an environment where no source control previously existed.• Trained a team of 10 developers on how to use the new source control/build/release management environment in Team Services using the GitFlow methodology.• Coordinated a plan and implemented the update of existing packages and scripts to meet updated ICD-10 (International Classification of Diseases) code specifications with a team of three other developers. • Lead developer and analyst in redesign of the current Provider payment system to offer EFT as a payment option to comply with HIPAA requirements under NACHA regulations. Completed the job one month ahead of schedule.• Analysis and documentation of current and new EFT payments systems including database redesign, flow charting the new process and recreating the database ERD.• Modified and streamlined UNIX shell script and Oracle SQL script jobs to work with the new HIPAA/NACHA compliant EFT payment system. This included consolidating the check printing and register report jobs into a single database package that works with all the different programs (i.e. Explanation Of Benefits).• Designed and created an enrollment web form for providers to sign up to receive payments via Electronic Funds Transfer (EFT) for EOB’s, capitation and incentives utilizing jQuery, CSS and Ajax/JSON.

• Developed and maintained of Naval Facility Acquisition Center for Training Systems (NFACTS) web application in HTML/ASP. Re-work ASP pages as well as Oracle 10g database structure to optimize efficiency.• Redesigned 40+ ASP application scripts (manually run by the users) into Oracle 10g PL/SQL automated batch jobs. Reduced user daily maintenance by 15%.• Utilized project management, systems analysis, development, maintenance and upgrade capabilities of Navy Shore Installations (NSI) reporting web application in ColdFusion utilizing extensive ColdFusion development, SQL (optimization) & PL/SQL, HTML & JavaScript.• Developed import and export type interfaces for the EXMIS (Expeditionary Management Information Systems) NAVFAC Business Line using the Maximo Integration Framework, Cron Tasks, PL/SQL and JAVA programming.• Acted as migration coordinator and developer for the Hazard Abatement DB (HA/DB) ColdFusion 8/MS Access application. This included recreation of their Access database model and data import into Oracle 10g.• Worked on migration of Oracle Portal web applications from 10g release 1 to release 2.• Utilized project management, systems analysis, development, maintenance and unit testing for upgrading and enhancing the NAVFAC Information Technology Enterprise Portfolio (NITEP) web application in ColdFusion. Extensive ColdFusion development, SQL optimization, PL/SQL, HTML & JavaScript was used.• Utilized project management, systems analysis, development, maintenance and upgrading of NAVFAC Information Assurance (IA) web application in Oracle AS Portal 10g utilizing the extensive SQL (optimization) & PL/SQL, HTML, JavaScript, Portal Forms & Reports. This included Web Toolkit functions utilizing HTML and JavaScript to create custom web forms and reports.

• Developed, maintained and upgraded of issue/requirements tracking web application in Oracle APEX utilizing extensive SQL (optimization) & PL/SQL, HTML & JavaScript.• Provided analysis and requirements documentation for the conversion of the Information Assurance application from Cold Fusion MX /Oracle 9i to Oracle Portal 10g/Oracle 10g. This included user acceptance testing and training.• Coordinated weekly user requirements and planning meetings.• Created technical documentation of application requirements. Including Systems Requirements Specifications (SRS), System Design Specifications (SDS), Entity Relationship Diagrams (ERD), test plans & workflow diagrams.• Provided quality assurance and unit testing of new requirements and maintenance promotions.• Re-Designed and configured Oracle 10g database model and schema structure. This included DDL and DML data migration scripts and triggers in PL/SQL.• NAVFAC Portal Applications design and backend integration of Form/Report/Dynamic Pages with PL/SQL packages and Oracle Internet Directory (OID) program development. Including development of synchronization routines between local tables and OID user accounts via DBMS_LDAP functions as well as synchronization with Single Sign-On (SSO) registration accounts.• Designed and developed NAVFAC applications in compliance with DoD STIGs. • Obtained extensive knowledge of NAVFAC organizational policies & procedures. Including NAVFAC Information Assurance (IA) business rules, workflows, application/asset accreditation processes, incident reporting, IAVA reporting rules & IA training processes.• Created documentation additions and modifications including requirements/enhancement gathering and DIACAP accreditation processes.

Us

• Upgraded and maintained NAVFAC OracleAS Portal 10g web applications including database table/trigger/package/function additions/modifications, Portal portlet/page/permission additions/modifications.• Acted as Lead System Analyst/Technical Lead on conversion of Cold Fusion MX based Information Assurance application to Oracle Portal 10g. Including extensive SQL & PL/SQL, Web Toolkit, Portal Forms & Reports, HTML, JavaScript development. • Provided documentation modifications including System Design Specification (SDS), Entity Relationship Diagram (ERD) and Requirements/Enhancement Requests• Re-Designed and configured Oracle 10g database model and schema structure. Including DDL and DML data migration scripts and triggers in PL/SQL.• Analyzed and reworked SQL queries for optimized performance.• Designed, developed and maintained project funding/material tracking application with SQL Server, ColdFusion MX & JavaScript.• Designed and developed invoicing, project, materials & funding applications with Oracle 8i EE, Developer 2000 Forms & Reports.• Converted from mainframe (COBOL) to ColdFusion MX/Oracle8i Naval/Marine Department of Defense financial reporting applications.• Designed, developed and maintained financial, budgeting & contracts/procurement with SQL, PL/SQL, ColdFusion 5.0, HTML.• Replaced the offices Novell domain controllers with Windows 2000 Server PDC and DBC’s.• Configured and worked as database and network administrator for a Windows 2000 Server based network running Oracle9i Enterprise Edition database & SQL Server 2000 EE.• Involved in all phases of systems analysis, programming and unit testing for two major Year 2000 projects utilizing legacy languages (COBOL, IDEAL, DYL-280) – Sansum Medical Clinic/Santa Barbara & NAVFAC Financial Information System U.S. Navy.

• Involved in modification of client tracking database• Responsible for update, maintenance and administration of PC based computer software and hardware

• Co-produced, designed & developed a major Macintosh/PC computer game• Promoted distribution of software to major retailers• Responsible for customer service requests, Quality Assurance and general problem solving