PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Enterprise Data Architect (Consultant)

Responsibilities:

• Designed the dimensional model for an ACO Budgetary Performance Data Mart and enhancements to a Care Management Data Mart using ERwin 9.5. Data sources included cOS (a real - time “clinical Operating System” that integrates data from a variety of healthcare data sources) and the Confidential System. Mentored development teams, provided design reviews and reworked data mart designs for offshore development teams. Reverse engineered cOS and legacy data marts from native databases and XSD files, created metadata. Authored a Data Management review of current systems defects, design shortcomings and operational practices. Confidential is a pioneering leader in application of genomic and proteomic sequencing coupled with advanced treatment practices to improve outcomes in the treatment of cancer Confidential ts.

Confidential, Ft. Worth, TX

Sr. Master Data Analyst II / Project Manager (Consultant)

Responsibilities:

• Led the design and implementation of MDM, Data Quality and Data Governance programs across 65 independent international sites of a $10B global manufacturer of pharmaceutical and surgical supplies, in preparation for consolidated financial reporting and the rollout of SAP across all divisions. Created the underlying strategy for a robust set of Master Data Governance solutions to support specific enterprise initiatives ensuring that accurate and timely data is provided to global commercial systems. Acted as a data trustee by working closely with external Confidential sites to enhance enterprise master data quality in support of the global Net Product Margin Reporting initiative, a strategic financial system used to perform global product profitability analyses and product planning. Developed and implemented data quality and data governance strategies: formalized business rules to employ in data quality reports against
• Confidential data repositories and for use in pre-emptively auditing data quality at external Confidential sites, profiled site data stores and created an MDM hub. Created data governance standards, led the development of business rules matrices, data standards, data profiling and data analytics quality programs. Developed, produced and delivered monthly data quality management Webinars for a large global audience (425 professionals and executives). Introduced corporate Data Governance practices promoting, collaboration and the practical application of data quality principles. Developed custom SQL queries for use by various sites to pro-actively address data quality issues. Reduced global master data errors from over 300K to the theoretical floor given timing differences in global batch processes and new product ramp-ups at Confidential ’s manufacturing facilities. Primary project deliverables were completed ahead of schedule and under budget.

Confidential, Southfield, MI

BI Team Lead and Sr. Project Manager (Consultant)

Responsibilities:

• Restructured a strategic, fixed price BI project to redesign and upgrade the Confidential ODS and Enterprise Data Warehouse to add enhanced analytical capabilities and new subject areas, transition to additional data sources (to Facets from Xcelys, in corporate IKA and proprietary internal data stores) and introduce role-based data models for flexibility and support for Master Data Management. Led the ETL and Data Architecture teams. Provided technical leadership for the development of data conversions and supported the implementation of Cognos as the reporting layer. Re-allocated team resources, created a new project plan to implement improved development. Introduced Agile development methodologies to improve delivery schedules and promote collaboration with the client; acted as ScrumMaster for two development teams. Led data modeling tasks. Engaged by RCG after the project was found in October
• 2013 to only be 13% complete versus the 85% reported to the client. Technical environment is Oracle, Cognos and DataStage. Converted and loaded 50+ million rows of data into four subject areas in a new Dimensional Data Warehouse in February and delivered the remaining subject areas in March together with related Cognos frameworks and packages.

Confidential, Ft. Worth, TX

Manager, Data Management and Systems Development

Responsibilities:

• Led three teams: Business Intelligence, Data Integration and Applications Development. Deliverables included development of policies to promote enterprise data quality and the implementation of a real-time data warehouse and the associated analytics utilized to improve business performance, quality and financial outcomes by integrating operational information from multiple lines of business. BI Use Case development included delivery of an application to deliver current, unified Meditech and Athena Confidential t data in real-time, operational dashboards and development of data feeds to the Marketing Department used to plan expansion of the clinical network. Technical environment includes the Microsoft BI stack (SQL Server, SSIS, SSAS, SSRS), QlikView and Tableau. Personally designed data models for Episode of Care and Pharmacoeconomics using ERwin. Led application development initiatives including an EDI Claims Adjudication System to improve reimbursement rates, development of end-user self-service applications, CCHAPS analytics and a System-wide financial dashboard using Tableau.
• Achieved major improvements in the state of software development by introducing new development techniques - Agile development, daily Scrums, continuous integration, peer-reviewed designs, deployment checklists, managed code (version control, build scripts and processes), static code analysis, and test-driven development. Projects included development of the CCHAPS community health survey and web portal, web check-in services, and the Internal Case Management Referral System which provides collaborative dashboards between the Hospital and Home Health organizations to transition Confidential t care and coordinate the delivery of healthcare services.
• In the area of Data Integration, eliminated 90% of point-to-point application interfaces using the Corepoint Enterprise Service Bus (ESB) and created Confidential t identity interfaces between the hospital and external clinics to improve the data consistency of disparate applications. Developed budget and resource planning, provided monthly steering committee briefings to C-level executives, utilized a Gartner to perform research and provide strategic guidance to peers. Cook Children’s Healthcare System is an ITIL compliant environment.

Confidential, Irving, TX

Sr. Enterprise Data Architect

Responsibilities:

• Partnered with business and technical resources to define delivery priorities and strategies, develop a three year B.I. roadmap and set expectations with business users
• Implemented SAP BI 7.0
• Conducted requirements gathering sessions with end users
• Led the design and construction of data extractors, load processes and OLAP cubes
• Created custom reports to capture project benefits, produced executive dashboards and KPI analyses, calculated and monitored business benefits realization achieved in globally implementing SAP - used to gauge the success of the project
• Hired team members and phased out IBM participation in B.I. In the areas of Data Management, Data Quality and Data Architecture:
• Recipient of IBM’s Trusted Information in Action as a result of employing data management processes as a technique for mitigating project risk
• Created detailed international Data Standards including standard vocabularies and naming conventions by collaborating with business and technical personnel in the US, Europe and the Far East
• Employed QualityStage and custom SQL queries to perform data profiling and data quality assessments for legacy source systems
• Worked with process teams and functional developers to design effective data strategies and structures in support of business objectives for the project
• Supported the configuration and implementation of all SAP modules, promoting approaches that enhanced data quality
• Established a Data Architecture team with members from the U.S., Europe and Australia
• Developed comprehensive Data Dictionaries for Materials, Customers and Vendors to assist developers and end users
• Responsible for the integrity and accuracy of all data loaded into SAP
• Provided guidance to ETL Teams for conversion of legacy system data and the ETL Solution Architecture in a DataStage environment including the design of data mappings, transformations and load strategies
• Collaborated with business users at each implementation Site to support loading of their data into SAP. Performed data profiling, data quality audits, process enhancements and data remediations within legacy source systems prior to their conversion to SAP
• Promoted the adoption of TIQM (Total Information Quality Management) disciplines.

Confidential, Des Moines, IA

Program Architect (contractor to EDS)

Responsibilities:

• Designing context and systems architecture diagrams in support of the Integration Strategy
• The design, creation and implementation of all technical solutions
• Implementation of external data exchanges with third parties and clients
• Profiling and analyzing third party data sources
• Coordination of Matria and Confidential service offerings
• Support for internal and external reporting
• Interfaced third-party Matria data sources with Confidential data warehouse and ODS systems. Designed
• Data extractions, transformations and feeds from Matria to Confidential operational, data warehouse and ODS systems
• Re-startable Unix shell scripts to automate data loads to Confidential data warehouses
• Complex data interchange strategies and data mappings between Confidential, Matria, client organizations and service providers

Confidential, Dallas, TX

Manager, Enterprise Data Warehouse and Data Management

Responsibilities:

• Development of the upgrade strategy for the EDW to enable consolidating information from eight hospital systems. The EDW acts as both a widely-used analytical data store and also as a data integration hub for multiple healthcare applications. Enhanced the data collection layer to utilize HL7 event-level messages in place of the previous batch processes - enabling the capture of more detailed healthcare events.
• The EDW was utilized to generate $1+MM in annual savings by improving supply chain practices and reducing surgical blood transfusions by 33%, delivering Confidential t safety improvements in orthopedic surgery while simultaneously reducing costs
• Management of the EDW Users’ Group, which included the participation of executives throughout BHCS and promoted the expansion of BI capabilities
• Introduction of Business Objects as the corporate reporting tool
• Development of corporate dashboards using .Net and Business Objects applications, for the Board of Directors and the CEO, respectively
• Creation of a Pre-Transplant application to improve reimbursement rates
• Promotion of medical vocabularies
• Design of ETL solutions using Informatica
• Promoted data management, stewardship and governance initiatives:
• Implemented Master Data Management (MDM) / Confidential t identify management programs using solutions from Initiate
• Designed and led the implementation of a custom Metadata Repository and application in support of data standardization and Baylor’s strategic Clinical Transformation initiatives. Reverse engineered legacy applications, mined data dictionaries, developed the data model for the metadata repository using ERwin and mapped current state to future state attributes and code sets to support application design, data transformation and risk mitigation. Provided guidance to implementation teams on data standards and data governance principles.

Mentored the EDW team on data warehouse design and modeling techniques using ERwin, delivered a technical presentation on the use of navigation bridge tables to the Healthcare Data Warehousing Association.

Confidential, Lewisville, TX

Data Architect

Responsibilities:

• Working with JAVA architects and business users designed the Synergy data model for the components of Confidential ’s commercially offered retail campaign processing system, using ERwin. This JAVA J2EE, Oracle-based system supports high volume transaction rates for leading corporations. Created component data models, database metadata, and architectural alternatives. Maintained six Oracle instances for developers. Performed data analyses using TOAD. Wrote PL/SQL routines to support call center monitoring.
• Managed a team of six BI developers and one DBA. Designed and implemented a Data Warehouse using federated data marts to recast the corporate transaction processing schemas into a more performant and reportable data model. Business capabilities included analytical support for retail campaign management, planning, budgeting, financial analyses and fulfillment analytics. Led a commercial engagement to develop a Channel Sales-Thru analytical data mart for Staples that enabled statistical analyses and fraud detection. Led the selection of Business Objects by developing use cases, POC prototypes and evaluation matrices. Contributed to the design and development of the Business Objects Universe. Managed the conversion of two hundred reports from BRIO to Business Objects. Created custom reports for a new accounting system.

Confidential, Dallas, TX

Practice Leader

Responsibilities:

• Developed a Supply Chain Management practice which delivered B2B and i2 Advanced Planning engagements
• As project manager, led a team of Edison and client developers at USPA&IRA (First Command) to custom develop the corporation’s core business system, a Financial Services offering. Reported directly to the Board of USPA&IRA
• Delivered database performance engineering projects for PeopleSoft implementations at HEB (Informix) and Winn-Dixie (DB2)
• Developed business vision and strategy for Edison clients including solution design engagements at eBrix and FashionMall (data modeling and applications design), technical strategy development at H& Confidential Block, B2B services at GIA (the Gemological Institute of America ) and researcher collaboration strategies for the J. Confidential
• Solutions Design Architect for a Siebel CRM implementation at Lucent to provide Marketing Analytics, a client profile Data Mart and Campaign Management functionality. Together these applications manage the sales funnel and segment clients in support of sales and marketing strategies designed to enhance customer profitability and retention

Confidential, Richardson, TX

Program Chief Technologist

Responsibilities:

• As a customer-facing Solutions Architect led the development of a new commercial software and service offering by partnering with a group of leading home healthcare companies and senior client executives to define the applications landscape, design custom applications and associated data models, manage the selection of an ERP vendor and direct the development of custom application software components. Created the integration strategy by building an integration hub using CORBA and components from Iona Technologies. The first project engagement was for a healthcare provider operating in four states.
• The client based their IPO on the advanced operational capabilities that this project afforded them. Rockwell successfully marketed this as a new service offering to multiple clients. The project included design of a comprehensive Data Warehouse to coalesce clinical, financial and operational factors in order to provide industry comparisons of operational metrics for a consortium of healthcare providers. Responsible for developing all aspects of the solution architecture through collaboration with client executives and staff. Managed the requirements team and utilized facilitated, executive-level JRP and JAD sessions.

Confidential, Somerset, NJ

Software Development Manager

Responsibilities:

• Headed the development of Confidential Pharmaceutical’s global clinical trial management system - the first of its kind within the Pharmaceutical industry. This system accelerates FDA approval of new ethical drugs by (1) analyzing clinical trial data using a custom-developed exploration Data Warehouse, (2) providing unattended remote data collection, (3) automating the construction of trial protocols and (4) supporting in-field monitoring and auditing of clinical trials. The project employed the Catalyst development methodology and a wide range of leading technologies including data warehousing and analytics,
• Rapid Application Development (RAD) workshops, BPR, Object Oriented Analysis, Design and Programming, automated testing, unattended remote data collection, integration middleware and mobile computing. This groundbreaking system was the first of its type to be successfully implemented in the Pharmaceutical industry. Managed an extensive staff of approximately eighty CSC professionals, client staff and third party consultants to Confidential after being rapidly promoted from Software Development Manager to head the project. Brought in to develop and present the solutions architecture to Confidential ’s Confidential & Confidential organization, resulting in backing for the project. Reported to Confidential ’s Director of Confidential &D. Defined and coordinated the deliverables of multiple project teams. Negotiated scope and budget with the senior management of Confidential Pharmaceutical. Delivered executive presentations including a demonstration to the number two executive in Confidential that led to securing the final round of funding for the project.

Confidential, Dallas, TX

Project and Program Manager

Responsibilities:

• Program and engagement manager within a systems integration practice that developed electronic document management (EDMS) and workflow systems marketed to Fortune 100 manufacturing and engineering clientele. Initiated and managed multiple, concurrent projects for leading clients across the United States including Confidential, Texaco, Monsanto and Alabama River Pulp. The EDMS Practice partnered with Shell Petroleum to develop the industry’s response to new Confidential government regulations, in the form of our application and service offerings. Selected and integrated multiple applications and third party solutions into commercial offerings that were marketed throughout North America. Adapted product offerings to meet individual client requirements. Conducted envisioning workshops with leading petrochemical and engineering corporations. Developed RFP responses and led investigatory projects. Delivered briefings and presentations to client executives spanning marketing, project justification and project execution.
• Developed a process improvement data warehouse for continuous process manufacturing for the largest Union Pacific Resources (UPR) refinery. Operating margins and profits at this facility grew to surpass those of larger Citgo facilities that became peers after the divestiture of UPR’s downstream operations.