Data Management
Resume:
John Turner
*********@*****.***
Education, Experience, and Qualification Snapshot
Years of Relevant Experience
20+ years as a data warehouse architect/developer specializing in Data Services, Data Analysis, Data Modeling, Data Migration, Oracle Data Warehousing, and Database Design. Expert in extract, transform, load,
(ETL) expert with considerable SAP Data Services, Informatica and PL/SQL experience.
Education
• M.S. in Industrial Engineering Georgia Institute of Technology, 1989
• M.S. in Safety and Systems Management University of Southern California, 1982
• B.S. in Engineering United States Military Academy, 1979 Qualifications
Availability: Yes Clearance: TS/BI, Inactive
Meets Residency Requirements: Yes
Certifications:
• Certified Business Intelligence Professional (CBIP) Practitioner, 2012
• Oracle Certified Professional (OCP), 2000
• Oracle Applications Developer Masters Certificate, 1998 experience with Oracle ERP Financials. Mr. Turner has written Data Warehouse Strategy and BI Road Map documents and served as the technical lead of ten separate full SDLC BI/DW projects that utilized Oracle databases, Informatica Power Center, SAP Data Services and SAP Business Objects. He has designed dimensional data models and developed OLAP data structures using multiple sources. Relevant Training/Technical Skills:
• HR/Payroll, Momentum Financials, Patent Case Management and Workflow
• RHEL, HP-UX, Windows Server, AIX, Solaris, MVS
• Informatica Cloud Real Time, Informatica Power Center, SAP Data Services, Business Objects Enterprise, Webi, Crystal Reports, Information Designer, IBM Cognos
• Remedy, ClearCase, Subversion
• Oracle, DB2, Sybase, SQL Server, Informix
• SQL Developer, TOAD, SQL Data Modeler, ERwin, IBM Infosphere, Embarcadero, MS Visio
• Oracle Certified Professional (OCP), PL/SQL, SQL, Oracle E-Business Suite
• Certified Business Intelligence Professional (CBIP) – The Data Warehouse Institute (TDWI) Experience Summary:
More than 20 years of experience as a
Business Intelligence (BI) Data Warehouse
architect and developer supporting
federal and commercial clients to include
the U.S. Patent and Trademark Office
(USPTO), Department of Defense (DoD)
Military Health, General Services
Administration (GSA), Environmental
Protection Agency (EPA), Defense Finance
and Accounting Service (DFAS), U.S. Coast
Guard (USCG), First Union Bank, and
Marriott Hotels.
His qualifications include over five years of
experience with the full breadth of SAP
Data Services and Business Intelligence
Platform Server, Universe Designer and
Information Design Tool, WebI, Deski and
Crystal Reports as well as 5 years’
Chronology of Professional Experience:
Treatment Management Company 11/2016 – Present
Architect
• Led the acquisition of database, integration, and analytics tools and technologies to support the analysis of day-to-day operations of health care operations across three regions
• Integrates data from Salesforce CRM, InContact Call Tracking, ADS billing system, KIPU electronic medical records, and Netsuite ERP; profiling data domains and adhering to data standards
• Designs and develops data sets and presentation of Tableau reports and dashboards that enable senior management to visualize key performance indicators and identify value segments.
• Designs, develops and maintains data using Oracle 12c cloud computing services. This includes administering data operations, performance tuning, and backups using RMAN.
• Designs, develops, and maintains integration using Informatica Cloud integration mapping tasks and Informatica Cloud Real Time data integration REST Application Programming Interfaces (API) SalientCRGT 10/2006 – 11/2016
Architect
Client: United States Patent and Trademark Office (USPTO)
• Led a team of twelve report and application developers, business Intelligence administrators, database administrators, and ETL developers in delivering the day-to-day SAP ETL and reporting solution to over 700 active users spanning Patents, Payroll, Human Resources, General Ledger, Revenue, Accounts Payable, Accounts Receivable, Fixed Assets, Automated Distributions, Corporate Planning and Budget, Procurement, Project Management, Time and Attendance.
• Managed the day-to-day operations of the enterprise data warehouse (EDW) while refreshing GL transactions and other core financial data on a continuous, periodic schedule.
• Led development of full software development life cycle (SDLC) projects for the USPTO EDW to include: o Oracle 12c upgrade
o SAP Business Intelligence Platform 4.1 upgrade
o Revenue Fee Processing System replacement
o Momentum Financials 6.4 and 7.1 upgrade
o DARTS – Deployment Assessment Review Tool used to track life cycle and spending of IT projects o IT Dashboards to meet OMB reporting requirements o Major PTO Reorganization
o Contract Management while maintaining organizational security
• Led two complete upgrades and migrations of USPTO EDW servers to include operations and application systems for the complete spectrum of services from the database and ETL operations to the presentation layer using Apache Tomcat, SAP Business Objects Business Intelligence Platform 4.1 and Data Services 4.2 as well as the Oracle RDBMS 11g & 12c. o This included the migration of content, redesign of custom java portal scripts and the introduction of a secure interface using SSL. Each effort was successfully guided through ambitious project schedules from between 60-90 days each.
o Master Data Management (MDM) was strictly adhered to gaining approval from the USPTO Data Architecture Group for adherence to referential integrity, data standards and data domain profiles o Maintained Data Architecture and standards transparency using web enabled Rochade presentation and complete data object, entity and attribute definitions in Oracle database comments
• Delivered an Information Dissemination Strategy for USPTO that considers Zachman’s Framework from various perspectives of architectural design across multiple disciplines to complete an integrated information systems design
• Designed data architecture to capture and report revenue data from a new revenue accounting system implemented at USPTO. Successfully oversaw the delivery of revenue data conversions.
• Re-engineered a complex business process and successfully directed the design, development, testing and implementation of the PTO General Journal (PTOGJ) to link obligations to commitments
• Coordinated the planning, organization, and population of a Configuration Management (CM) structure for EDW and its associated applications in ClearCase for the Integration Stream
• Provided core concepts, ETL metrics, and methodology in support of ETL Tool Market Research Client: Military Health System (MHS) - TRICARE, Exec Information Decision Support (EIDS) Program Office, Traumatic Brain Injury/Behavioral Health (TBI/BH) Clinical Doc Tool (CDT)-a java based web healthcare application system
• Designed and developed data architecture to support behavioral health care using notes and diagnosis workload to capture baseline encounter data.
• Developed the ETL scripts in PL/SQL to process behavioral health notes, alerts, and patient assessments for transaction events, providers, patients, and locations. Incorporated exception handling to indicate results of each load and provide methods for completing partial loads
• Designed and developed data model for reporting Behavioral Health data in prototype
• Recommended streamlined, normalized data designs for Behavioral Health application
• Recommended key relationships vital to maintenance of data integration with CDR
• Created classifications and hierarchies for primary entities (Facility, Diagnosis, age, etc.)
• Designed a star schema to accommodate data considered for inclusion in the TBIBH-CDT
• Installed, configured and loaded data in Oracle database for reporting Humana Military Health Systems (HMHS)
• Helped shape a $500K project operating a two- person staffing effort including management
• Assisted HMHS in reaching its BI goals by providing initial DW designs to serve regional organizations
• Designed a logical dimensional data model for a Data Mart Pilot to include four key data areas: beneficiary, provider, claims and authorizations/referrals Client: Military 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 tests, radiology tests, diagnosis, procedures, and prescriptions rendered along with their respective interactions
• Derived Clinical practice guidelines from published professional journals
• Drove the design for an outcomes based data mart that can generated ad hoc results
• Provisioned eighteen months of production quality data more than 300GB to streamline universe design for ad hoc reporting
Client: U.S. Environmental Protection Agency (EPA), Office of Acquisition & Resource Management (OARM)
• Provided the design, development, and testing of modifications to accommodate strategic and tactical shifts in reporting requirements using an on-demand paradigm
• 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 with one Informatica code transition into production enabling the EPA’s purchasing application to uniformly update regions
• Analyzed use of existing universes using Business Objects Designer and Web Intelligence to streamline performance with the data mart in Oracle Client: Military Health System (MHS) - TRICARE, Executive Information Decision Support (EIDS) Program Office
• Assessed the current reporting data architecture used to support the EIDS activity
• Recommended immediate use of partitioned fields to improve report performance issues
• Developed content for Business Objects XI (BOXI) Release 2 computer based interactive training to fully leverage the capabilities of CDM ad hoc reporting at DoD Medical Treatment Facilities
• Enabled widespread use of adaptive and innovative methods to report and manage clinical events, outcomes, and forecast potential health risks
Client: U.S. General Services Administration (GSA)
• Delivered a Data Warehouse Strategy that incorporated a complete inventory of feeder systems, architecture diagrams of ‘As-Is’ and ‘To-Be’ environment, and port-to-port mappings of essential data elements and transformations needed to consolidate and manage the data distribution process that supports reporting so that the costs associated with these processes could be better contained
Arlington County Government 02/2002 – 10/2006
Data Architect
• Responsible for the Master Data Management (MDM) 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 management and administration
• Designed a database to inventory, jobs and administration of over 100 databases and 40 applications
• Lead data architect in implementing an Oracle E-Business Suite for payroll, HR, and Financials
• Designed an address master data store to synthesize and resolve data conflicts across departmental sources to provide a consistent enterprise view of horizontal and vertical county addresses
• Designed a Metadata Repository for reporting Active Directory groups, organizations, and key account information for users of the Arlington County network services
• Parsed extremely large data strings into meaningful hierarchies for reporting, grouping, and collaborating information to address data quality issues
• Lead BI architect for enterprise reporting across 12 core departments
• Automated the process for assessing and managing county addresses: the core component for delivering products and services across the county
• Established a process to sustain the creation and retirement of addresses
• Integrated involved party, location and services data to provide inter-departmental solutions Additional Experience
Company/Client Date Range
Datamat Research Inc. at U.S. Coast Guard (USCG) Operations Systems Center (OSC) 02/2001 – 10/2001 Baytree Associates Inc. at First Union National Bank 09/2000 – 01/2001 Virtualogic, Inc. at Marriott International 01/2000 – 09/2000 Trantach Inc. 07/1999 – 12/1999
SRA International, Inc. at U.S. Department of Defense (DoD), Defense Finance and Accounting 06/1995 – 07/1999 Assistant Secretary of the Army for Financial Management 06/1993 – 06/1995 Course Director and at United States Military Academy (USMA) 06/1989 – 09/1993 U.S. Army Field Artillery officer 06/1979 – 06/1989
Contact this candidate