Category: Oracle

Data and Integration Architect – HighPoint Solutions – US (Multiple Sites)

Agile Methodology, Business Glossary/Data Governance, Claims, Data Profiling/Data Quality, Delivery Lead, Enrollment/Member, ER/Studio, erwin, Facets, Health Care Payer, Hospital Quality Measures, Informatica Administration, Informatica/Axon, Informatica/EDC, Informatica/IDQ, Informatica/PowerCenter, InformationBuilders, iWay Data Quality Suite, Jira, Metadata Management, MS Project, Oracle, Pharmaceuticals, Practice Leadership, Provider, SQL, SQL Server, Tableau, Talend, Teradata, Toad Data Modeler

November, 2015 to June 2019

Informatics Architect for consulting company with healthcare, pharmaceutical and life sciences focus areas. Role included DW/BI architecture design, project technical oversight to multiple concurrent teams, data governance best practices in healthcare data management and business intelligence projects.

Designed and managed implementation of reporting prototype for data quality history and trending in IDQ 10.1 environment.

Established data architecture practice, modeled existing sources and created member/enrollment and provider logical data models in ER/Studio for a Massachusetts ACO. Screened candidates to assume lead role in the ACO organization. Trained analysts in ER/Studio and data architecture best practices. Participated in screening of implementation partners for data warehouse and master data management in a Talend/SQL Server environment.

Provided design and oversight to 3-person team to implement Informatica Business Glossary and Metadata Manager (v 10) proof of concept in the 4th largest BCBS organization. Project included 4 use cases using both PowerCenter and SQL-based ETL with rule-based lineage. Held daily sessions with internal team leaders to provide education, knowledge transfer and best practices. Team provided design and Informatica configuration documentation.

Designed data and metadata driven integration architecture, providing technical oversight/mentoring to 6-person team implementing a provider master data repository for a health plan and health services organization. Phase 1 moved Vistar data into the repository, providing daily extracts to a third party online provider scheduling application. Project team is extended to include data from Echo and Epic, and include data quality management and integration with Collibra.

Designed data and integration architecture and provided technical oversight to a 4-person team revising data strategy and business process for a healthcare analytics company. This project replaced their home-grown SQL Server application and manual data scrubbing and validation process with an automated solution. Informatica PowerCenter and IDQ were used to move, scrub and validate incoming hospital data applying over 400 scrubbing and validation rules reducing throughput from 2-3 weeks to 1-2 days. Over 40 IDQ profiles, scorecards and human tasks were built for data analysis performed by the operations team.

Architect for two data warehouse projects following a metadata-driven ingestion to staging, with subsequent custom ETL to requirements-driven relational data warehouse. This allowed the customer the flexibility to add or remove source data at schema, table or field level while maintaining changed data capture and history/archiving. One project was implemented in Informatica PowerCenter for a large hospital complex with clinical and patient data, and the other in Talend for a large medical provider/health plan management company. Trained and developed a new data modeler to follow industry standard best practices, who progressed to a data architect level of performance by the second project.

Training included Informatica Axon and Enterprise Information Catalog.

Principal Consultant — Data Intensity — Greater Cincinnati Area

Agile Methodology, Business Glossary/Data Governance, Data Profiling/Data Quality, Data Vault, erwin, Informatica Administration, Informatica/PowerCenter, Jira, Metadata Management, Multimedia, MySQL, Oracle, R, RapidMiner, SQL, Tableau, Technical Advisor, Unix Scripting

November, 2014 to November, 2015

Lead Data Architect/Integration Architect in an Oracle and MySQL environment; Data Vault data architecture; Expert ERwin Data Modeler (workgroup edition);  Informatica PowerCenter/IDQ/Metadata Manager/Business Glossary tools, RapidMiner, R, Tableau, Agile methodology, Jira.

Installed/configured/administered PowerCenter in an Oracle environment.  Designed and modeled data vault architecture for incremental load of Kantar Media data with transaction history.  Designed/built PowerCenter ETL to load/maintain 27 daily feeds. Provided extensive documentation and knowledge transfer.

IT Analyst — Collabera/Nationwide Financial Services — Columbus, OH

Agile Methodology, Business Objects, Financial Data, Informatica/PowerCenter, Netezza, Oracle, SQL

October 2011 – February 2012

Senior Business Requirements Data Analyst for the Investments Controllership and Accounting teams at Nationwide.  Assessed requirements and feasibility studies for projects using Informatica, Oracle 11g and Netezza in an Agile Methodology environment.  Skills include SQL (Oracle and Netezza), Business Objects, Informatica.

Senior Systems Engineer — Evanhoe & Associates — Dayton, OH

Business Objects, CMMI Methodology, erwin, HP Quality Center, Informatica/PowerCenter, MS Project, Oracle, SQL, Teradata, Unix Scripting

GCSS-AF/Global Force Management Data Initiative

April, 2010 – September, 2011  — DoD Secret Clearance

Senior Systems Engineer and Informatica developer on Global Force Management Data Initiative (GFM-DI) overseen by the Vice Chairman of the Joint Chiefs of Staff.  The project involves concurrent facilitation of force structure data sharing, ensuring unique information exchanges between enterprise systems on the Global Information Grid (GIG) and mitigating data collision issues across the DoD Enterprise.  Skills include Teradata, Oracle and ERwin.

Proactively suggested creating a separate integration test strategy and environment for the most recent release slated for August 2011. This resulted in the creation of a separate testing environment and expanded duties to run weekly installation tests and report results to the PMO.

Proactively researched and provided objective evidence to the Evanhoe & Associates leaders to demonstrate that the GFM-DI project conforms to most of the CMMI Level 3 requirements.  This resulted in assignment to organize a focus group across the business to do a preliminary gap analysis with a SCAMPI C planned for the fall of 2011.

Senior Systems Engineer – Qbase/Lockheed Martin — Beavercreek, OH

Business Objects, CMMI Methodology, Delivery Lead, erwin, Informatica/PowerCenter, Logistics and Resource Planning, Oracle, SAS, SQL, SQL Server, SSIS, SubVersion SVN, Teradata, Unix Scripting

GCSS-AF

April 2007 – April 2010 — DoD Secret Clearance

The following are projects accomplished for the USAF Global Combat Support System (GCSS-AF) for the Prime Contractor, Lockheed Martin, while working for Qbase.

Served as Tech Lead/Lead Programmer for the SNTUID (Serial Number Tracking/Unique Identification of tangible items) project for the Air Force Materiel Command. This project was the interface between the machine used to mark parts with a unique identifier and the DoD UID Authority. Led meetings with the customer to manage the project and was the lead Data Architect/Modeler, DBA and ETL programmer on a web-based application and a SQL Server database using SSIS.

Acted as Lead ETL Programmer for the BOBJ Metrics project for Lockheed Martin on behalf of the Air Force. Created ETL using Informatica 7.1 pulling in Oracle 10g Business Objects Repository data regarding usage of the various reports in the Data Services framework and outputting an xml document transmitted by SFTP to the customer on a daily basis. Authored all documentation according to GCSS-AF standards.

Lead Sys Admin and Programmer – Predictive Analysis Pilot (SAS) for the Logistics Directorate (USAF/A4). Worked with SAS sales and support to install and configure SAS. Worked with SAS consultants to construct mathematical models then led the presentation to the GCSS-AF Data Services PMO.

Lead ETL Programmer – Informatica Upgrade/Coding Standards effort for the GCSS-AF Data Services/Operations and Sustainment. Piloted a project converting Informatica 7.1 workflows to Informatica 8.1, and revise coding standards to translate Teradata BTEQ scripts to Informatica mappings.

Lead Architect and Tech Writer for the GCSS-AF Data Services/PMO. This effort published standards documentation on the web application for the GCSS-AF.  Standards documents were received from the Operations and Sustainment group, and uploaded to the existing (but empty) library area of the web application.  Also produced were hierarchical maps of hyperlinks that simplified finding the appropriate standards for any of the tools used by Data Services.

Lead Business Objects Developer – ACES (Automated Civil Engineering) Housing Management/Project Management BOBJ Rework for the USAF/A7. Inherited a project completed by another consulting group to Lockheed Martin that was released from the project.  Tasked with handling the PM side which required modifications to the universe to fit the existing Teradata structure and ERwin data model on the Data Services side and 30 revised reports. Identified serious flaws in the ETL delivered by the previous developers, resulting in continuing work for the customer to layer on the needed changes in a future project. Instrumental in defining the project plan/engineering requirements for the future work on ACES HM/PM.Lead Business Objects Developer – ACES Real Property Data Services application for the USAF/A7. Worked with a data modeler and an ETL developer to receive and load ACES Real Property data into Data Services EDW and create Web Intelligence reports for the customer.  Created Teradata views to support the ad hoc reporting capabilities, as well as developed Webi reports. Authored all project documentation.

Lead Teradata DBA and ETL Developer- ACES PM MILCON application for the USAF/A7. Worked on the Teradata side to create data structures and views to support a calculation-intensive report used by the Pentagon to structure the Presidential Budget.  Created 17 views to support the complex report and optimize performance for an application that held more than 50 calculation operations.

Lead ETL and Reports Architect/Programmer – ACES HM Re-engineering (Performance Optimization) for the USAF/A7. Served as the only developer for all segments of the work (Teradata DBA, Informatica, Business Objects). Redesigned data structures and views which were accessed by the Business Objects HM application to mitigate the poorly performing HM reports previously undertaken in the original ACES HM project. Created Informatica workflows and denormalized tables to support the Unaccompanied Housing and Military Familly Housing reports which were timing out before results could be displayed.  Revised ACES HM Universe to remove old, poorly performing Business Objects derived tables and replacing with a more efficient strategy, cutting display time down to 21 seconds. Created underlying data structures optimized to support a set of calculations based on the time period entered by the user (because of this, no calculations could occur until the user specified the dates, but the strategy compiled denormalized data in such a way to streamline the work done in the Business Objects layer).

Lead Teradata DBA/Business Objects Developer – ACES PM FIM (Facility Investment Metric) application for the USAF/A7. Created Teradata views and reworked the ACES PM Universe and reports to mimic the results formerly delivered from an Access database.  Deconstructed processes in the Access database and refined logic on the Data Services side to replicate all the features and reports. Constructed automated comparisons of output between the two systems.

Data Analyst/Business Intelligence Developer — M&S Consulting, Inc./SUMCO, Inc. — Cincinnati, OH

Oracle, Oracle Discoverer, SQL

2006 – 2007

Directly responsible for redesigning the underlying data structures to support their data warehouse applications using Oracle Discoverer. 

Created materialized views and cubes to support the suite of reports, as well as worked with the various users at the customer’s site to design and implement reports regarding the manufacturing of silicone wafers. 

Played a leadership role in redefining the process and structures by which the AS400 data was transformed into the Oracle data warehouse using stored procedures.

Information Engineer/Data Warehouse Design Consultant — Ramsey Consulting, Inc./CACI, Inc. — Fairborn, OH

Agile Methodology, Business Objects, CMMI Methodology, Financial Data, Informatica/PowerCenter, Logistics and Resource Planning, Oracle, SQL, Unix Scripting

GCSS-AF/Keystone Decision Support System

2004 – 2006 — DoD NAC

This began as a contract-to-hire position through Ramsey Consulting in Dayton, OH for 6 months, and was continued as a direct hire to CACI.  The Keystone Decision Support System (KDSS) is the business intelligence platform delivered through the Global Combat Support System (GCSS-AF), supporting analysis for the Air Force Working Capital Fund.

Responsible for designing enhancements to the Keystone Decision Support System based on customer (Air Force) requirements, including the creation of an ER diagrams and DDL to build the Oracle environment and populate static tables, as well as defining objects formulae and definitions.

Lead ETL developer for two enhancements to the KDSS.

Coordinated data analysis during design for the functional team while acting as a technical advisor to the technical team during data analysis for design and test phases.

Piloted the first detailed and comprehensive technical documentation used by the project.

Drove a team-wide definition and documentation of process change from a “waterfall” approach to a project team iterative development process orientation.

Sr. Research Associate — Procter & Gamble — Cincinnati, OH

Clinical Trials, Data Governance Council, Data Profiling/Data Quality, Delivery Lead, Good Clinical Practice, MS Project, Oracle, SAS, SQL, Unix Scripting, VAX, Visual Basic

September, 1994 – December, 1997

Project Manager (1995 – 1997)

Managed the enhancement and maintenance of an automated Tables Generation project, including periodic roll-out, training and user support.  Project was migrated from DECVAX to HP9000, and upgraded from Visual Basic 3.0 to version 6.0.

Collaborated with project managers from Medical Surveillance and Clinical Data Management on the Data Standards Review Board to determine and deliver useful tables and monitor data standards and database modeling.

Clinical Data Manager (1994 – 1995)

Responsible for clinical data management for 7 studies adhering to Good Clinical Practices for the OTC/Oral Care focus area, including on-and off-site support and training for direct data entry systems.

Projects included implementing code for new duties assumed by data management operations to provide summary datasets for biostatistical operations.  This required an active role in the development of standard processes to facilitate the acceptance of these systems, with emphasis on meeting cycle times.

 

Consultant — Computer Horizons/Procter & Gamble — Cincinnati, OH

Consumer Products, JCL, Logistics and Resource Planning, MVS/TSO, Oracle, SAS, SQL

March, 1994 – September, 1994

Consulted on the enhancement/maintenance of a resource planning/national product distribution system using MVS/TSO SAS.

Facilitated the preparation and translation of very large MVS/TSO SAS databases for 13 product categories of consumer data to meet the needs of importing to a new Unix Oracle system, assuring data integrity.