John Turner Email & Phone Number

Herndon, Va

United States Patent and Trademark Office (USPTO), Technical Lead, 04/2010 – presentLeading a team of twelve report and application developers, Business Intelligence administrators, DBAs and ETL developers in delivering the day-to-day SAP ETL and reporting solution to over 700 active users spanning Patents, Payroll, HR, GL, Revenue, AP,AR,FA, AD, Corporate Planning and Budget, Procurement, Project Management, Time and Attendance. Military Health System (MHS) - TRICARE, Exec Information Decision Support (EIDS) Program Office• Designed and developed data architecture to support behavioral health care using notes and diagnosis workload to capture baseline encounter data. Also, incorporated patient intake data ranging from mild concussions to Traumatic Brian Injuries (TBI)• Developed the Extraction, Transformation, and Loading (ETL) scripts in PL/SQL to process Humana Military Health Systems (HMHS)• Designed a logical dimensional data model for a Data Mart Pilot in four key business areas: beneficiary, provider, claims and authorizations/referralsMilitary Health System (MHS) - TRICARE, Exec Information Decision Support (EIDS) Program Office• Designed and developed a clinical studies data mart prototype to assess the delivery of a full spectrum of Nephrology services to military beneficiaries worldwide. • Services include: encounters, lab and radiology tests, diagnosis, procedures, and prescriptions• Drove the design for an outcomes based data mart that can generated ad hoc resultsU.S. Environmental Protection Agency (EPA), Office of Acquisition & Resource Management (OARM)• Designed and developed materialized views, bitmapped and b-tree indexes using TOAD to enhance the performance of loading and reporting contract financial data across EPA• Fully automated the process of phasing in regional updates across 15 regions using Informatica

Fairfax, Va

CRGT acquired Guident in Dec 2012 and maintains Guident as a subsidiary Operating Unit. SalientCRGT then merged with CRGT in 2014. SalientCRGT is a full life-cycle IT services provider and expert in emerging technology solutions across the Federal Government – www.crgt.com.

Arlington, Va

Team Lead for Data Management and Administration:• Responsible for the data management, standards, policies, guidelines and data architecture associated with a large and prominent county government• Supervised a team of five technicians to provide enterprise-wide data administration• Lead data architect in implementing an Oracle ERP for payroll, HR, and Financials• Designed a database to track the inventory, jobs and administration of over 100 databases and 40 applications• Coordinated the efforts of functional subject matter experts in providing data for converting legacy applications into Oracle’s E-Business Suite for HR/Payroll and Finance

Mclean, Va

U.S. Coast Guard (USCG) Operations Systems Center (OSC)• OSC develops, maintains and provides user support and innovative application of technology enterprise information systems• Responsible for implementing a data warehouse for a large defense operational systems command, leading a team of four developers in implementing a data warehouse to extend and enhance Decision Support Systems (DSS) for their Marine Safety Network• Completed rapid application development of a prototype ahead of schedule using Oracle 8.1.6 Enterprise Server, Informatica’s PowerMart as an Extraction, Transformation, and Loading (ETL) tool, and Cognos’ Impromptu and PowerPlay to provide a web enabled end user solution• Designed a Proof of Concept (PoC) as a basis for evaluating three ETL products from Oracle, Cognos, and Informatica

Charlotte, Nc

First Union National Bank, Oracle ERP• Responsible for delivering conference room pilot solutions for Oracle Financials• Contributed to solutions during the conference room pilot and systems test for AP deployment

Bethesda, Md

Marriott International, Project Mercury PeopleSoft Conversion• Led team of two analysts, a programmer and a tester in designing custom accounting interfaces for large commercial hospitality organization• Designed the interfaces required to transfer accounting data from the existing system to the PeopleSoft Financial Application

Alexandria, Va

U.S. Department of Defense (DoD), Defense Finance and Accounting Service (DFAS)• DoD Finance and Accounting Center designing an enterprise wide data warehouse to support the procurement, payment, and accounting defense contracts worldwide• Led a team of six data analysts in designing a custom star schema with fact and dimensional data for the Defense Finance and Accounting Service's (DFAS) Corporate Data Warehouse that tracks over one million General Ledger transactions daily• Full lifecycle development included diagramming the business process, functional hierarchical sets, entity relationship diagrams (ERDs), and physical tables• Built PL/SQL scripts in SQL*Navigator and SQL*Plus to report and analyze attributes and domains for over 15 application systems from the Oracle Designer/2000 repository

Arlington, Va

Department of Defense (DoD), Defense Finance and Accounting Service (DFAS)• Partnered with Oracle Corporation to implement Oracle ERP solutions to Federal Government clients throughout North America• Designed a custom financial application and interfaces for the client's Defense Procurement Payment System that tracks the disbursement of over $60 billion annually• Full lifecycle development is being conducted diagramming the business process model using the functional and hierarchical diagram sets• Built PL/SQL scripts in SQL*Navigator and SQL*Plus to migrate an MS Access database into the Oracle Designer/2000 repository in Herndon, VAUnited States Postal Service (USPS), Oracle Developer• Developed a Year 2000 compliant application for the client's Corporate Publishing System, written in Developer/2000 using PL/SQL and the data resides in an Oracle 7.2.2 databaseInternal Revenue Service (IRS), Oracle Assessment• Analyzed the requirements and capabilities of the Internal Revenue Services' Customer Service Budget Estimating Analysis System Tool (BEAST) data systemDepartment of Defense (DoD) Joint Staff, Project Manager• Constructed the BEF-M database in Oracle7 and MS Access to support a rapid prototype development for the J8, Force Structure, Resources, and Assessment• Assessed the risk and impact of multiple/continuous deployment patterns for service members across occupational specialties, assignment, pay grades, and services• Directed the effort to develop an object oriented manpower model at the individual object entity to address the stress associated with career assignment and deployment patterns involving over 400,000 people

Msie - Industrial Engineering, Industrial Engineering

Mssm - Systems Management

Engineering/Industrial Management

Based on the memoryless properties of the Poisson distribution and experience in Predictive and Prescriptive Analytics, I both predict.