Brian Padgett Email & Phone Number

Greater Pittsburgh Area

• Leading team of analysts and developers in building a Reference Code application supporting EHS platform and replacing existing technical debt. Providing guidance and direction in requirements, architecture, database design, user interface, stored procedures, system integration, and testing.• Developed strategy and roadmap to address Enterprise Metadata Management for EHS platform comprising mainframe, open systems, and analytical environments. Developed process, estimation tool and reference model for metadata collection, enrichment, and delivery to health plan partners.• Provide technical solutions for health plan partner requests working closely with product development areas such as Data Warehouse, Claims, Member and Provider.• Consulting in implementation and rollout of Informatica data management toolsets including BDM, BDQ, EDC to support Hadoop analytical environment.• Conducted vendor product evaluations for data governance, metadata, data quality and mainframe metadata.Accomplishments Completed training in SOLR / Fusion provided by Lucidworks Enterprise Data Catalog (EDC) training and operational implementation recommendation

Greater Pittsburgh Area

Business Intelligence/Data Warehouse• Prepared strategy and roadmap for establishing EDW Data Governance with business stakeholders. Present Data Governance – Data Definition direction to EDMC BI Assessment Committee.• Initiated the build of Enterprise Conceptual Data Model, Enterprise Business Subject Area Model, Enterprise Logical Data Models, and Enterprise Data Warehouse Model.• Facilitated data dictionary/data modeling work sessions with Admission Vice Presidents to identify and define business entities and rules related to student admission and origination. • Redefined the data warehouse architecture to support ETL best practices for dimension and fact table build.• Lead technical analysis and design of Management Operation System (MOS) to report Admissions, Financial Aid, and Institutional Effectiveness metrics. Integrated Lawson employee data, designed hierarchy structures for operational reporting. Prepare physical models and DDL for Qlikview and OBIEE reporting.• Lead systems analysts and developers in data architecture and implementation of analytic projects within Business Intelligence team. Defined data requirements for source, operational and analytical data layers.• Developed Agile Scrum process for Data Warehouse projects• Coordinated the installation and upgrade of Erwin Data Modeler to Erwin 9.5 Workgroup Edition• Completed training Implementing TOGAF for Enterprise Architecture.

Greater Pittsburgh Area

• Developing Information Architecture strategy and standards to enable best practices in Enterprise Information Management. Information Architecture representative of Enterprise Architecture Review Board (ARB).• Communicates directly with CIO, Vice President and Director level staff in establishing Enterprise Architecture Portfolio Management, Data Governance and Metadata Management.• Engaged in Enterprise toolset solutions for Enterprise Architecture (Troux), Metadata Management (Informatica Metadata Manager), and Data Architecture (Erwin Workgroup).• Developing Metadata management strategy to establish the organization, sharing, communication and re-use of information assets. Leading technical staff in defining data lineage among enterprise applications.• Establishing foundational components to implement enterprise portfolio management through execution of project-level initiatives. Leading technical and business analysts in creation of common vocabulary of standards, frameworks, informational models, terms, and measures.• Utilize BDNA Technopedia to normalize standards for technology and application portfolios. • Represent EA for project reviews, technical solution proposal, vendor proposal, and use case development.• Research Cloudera, Datameer, and IBM solutions for Big Data / Hadoop platform.

Greater Pittsburgh Area

• Worked directly with client Director level personnel in areas such as Patient Accounting, Health Information Management, and Access Management on Horizon Enterprise Revenue Management (HERM) implementation teams.• Analyzed legacy data systems, business processes and reporting solutions. Identify gap information requirements for custom report development. Created SQL code to interrogate the database and validate report results.• Implemented Business Objects reporting solution for HealthCare clients in support of HERM product.

Greater Pittsburgh Area

• Responsible for the Enterprise Customer Repository design in support of transitioning to SOA architecture.• Analyzed data integration services of international and domestic plant systems as part of gap analysis.

Greater Pittsburgh Area

• Prepared enterprise information engineering artifacts (data requirements, gap analysis, subject area data architecture, logical data models, physical database schema design, database impact analysis, and configuration change control). Defined terminology and descriptions of enterprise data library establishing business, logical, physical, database, and XML notations in compliance with data governance policy.• Participated in Enterprise development of SOA and ITIL practices. Established boundary interfaces between abstracted levels of data in support of SOA business component design.• Implemented logical design solutions promulgating sound data quality implementations and ensuring business rule compliance within organization processes, functional architecture, applications, and user interfaces.• Conducted information engineering activities on modernization project to transition legacy systems to a single source of truth of federated enterprise corporate data.• Facilitated knowledge workers in workgroup setting to elicit business requirements. Performed process management validation as part of identifying enterprise data requirements of business components. Identified conflicts of process operations correlating to baseline business rules.• Performed gap analysis of legacy source system file layouts, X12 EDI schema, copybooks and tables to create data maps to new system design. Identified impact analyses with regard to physical database, application, business services, and organization processes. Conducted formal walkthroughs of physical database designs ensuring models satisfy requirements and business processes.• Created star schema of IMS Lifetime Accumulator data illustrating dimensions of business data.