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.
• 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.
• 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.
• 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

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.
• 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.
• 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.
• 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.

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 and.