Candidates About

 

Philip Leo Kaptur

Summary:

·        Technical Data Modeler/ Data Architect for multiple interfacing with project managers, developers, business analysts, database administrators, network administrators, and web developers – 15 years

o   Including Data Profiling, Data Strategy, Data Integration, Data Governance, Data Protection (12 year)

o   Hands on Data Modeling – Erwin versions R3.0 è R9.7 – recent experience with R9.7

o   Platform for applications and data stores was private cloud system

o   Big Data – Data Lakes, OLAP, ODS, EDW, Data Marts (Oralcle, DB2, Teradata, SQL Server) – sizes èTerabytes and Petabytes

o   Hands on Data Modeling with SAP PowerDesigner 12.1 & 12.5 (Microsoft SQL Server)

o   Hands on Data Modeling with SAP Enterprise PowerDesigner 15.0 for Oracle and Teradata

·         Senior Data Architect – multiple industries, integration and correlation of disparate sources into Enterprise-wide data warehouse using multiple platforms including cloud servers and utilizing multiple ETL technologies and databases – implementations of data integration from SAP (Customer, Supplier, Parts/ Products, BOMs, Routing, Labor, Chart of Accounts) for manufacturing and supply chain systems – McDonnell Douglas, GATX, Lockheed Martin, Freightliner/Damlier Chrysler, Microsoft, Electronic Arts – (12 years)

o   Data Management, Data Profiling, Data Strategy, Data Integration, Data Governance, Data Protection

§  CRM, ERP, Inventory, Production Control, Parts Logistics

o   Managing teams – data modelers, application developers, BI analysts and developers, Web developers, DBAs, Business analysts

·         IT Technical ETL, Data Modeling, BI Reporting development (17 years) – Commercial and Global systems for Healthcare – Blue Cross/Blue Shield and FEP encompassing MDM solutions and architecture

o    Including Commercial Banking and Insurance – American Express, Barclays Bank, CITI, JP Morgan, and Sea First Leasing

·         Managing IT healthcare interfaces with EDI transactions (270, 271, 834, 385, 837) into data warehousing processes

·        Managing delivery management for over 10 years for HR, Sales, IT, Finance/Banking, Marketing, Logistics and Customer Care for multiple industries

 

 

Senior Program manager with Master Data Management / Delivery Management /Development /Support Experience – 15 years 

·        Sponsorship, Project, and Change Management & Release Management – 7 years

·        Prosci Project Change Triangle (PCT) and ADKAR measurements aligned to Lean Six Sigma toll gates

·        SDLC and full life cycle development phases – 13 years

·        Enterprise wide system analysis and development – 10 years

·        ODS, EDW and Data Mart design of star schema and de-normalized data structures

·        Oracle, DB2 UDB, SQL Server, Teradata

 

ETL Trainer & Developer – Informatica 7.2 and 8.2 – 10 years

 

Areas of Expertise: 

 

Senior Data Architect, Data Modeler, and Enterprise Architect

·        Development management for technical delivery of commercial corporate systems for global application and functionality – OLTP, ODS, EDW, Data tMarts, and Web Application (14 years)

·        Build, Test, and Delivery of Strategic Software Portfolio Systems: Healthcare Membership/Claims, Inventory, Sales, Marketing, SAP BI, Human Resource, HRIS, Sales Demand and Product Synchronization, Scheduling, Motorola Telecom Device Demand and CRM, and Executive reporting services (14 years)

·        Collaboration and reporting project status, risks, and mitigation to business stake holders, senior management, CxO, and key external alliances (12 years)

·        Strategic and tactical implementation of medium and large-scale systems (12 years)

·        Data Profiling, Data Strategy, Data Integration, Data Governance, Data Protection, and Data Grievance (12 year)

·        Hands on experience with Data Modeling – Erwin versions R3.0 è R9.7 – recent experience with R9.7

 

Skill sets:

·        Thought leadership, project management, and collaboration on technical and business realms

·        Mentoring expanding teams across multiple disciplines including IT systems, RDBMS designs and support, Web architecture and support, and business analysts 

·        Identifying and delivery of a product roadmap along with building a high-scale infrastructure which is scalable in the future for end-to-end projects and architecture

·        Excellent communication skills, documentation, and presentation skills while interfacing with multiple levels of an organizations crossing technical areas and CxO’s

 

Education:

·        University Of Phoenix (2010) Master Degree (MIS) – 3.87 GPA​

·        University Of Portland (1978) B.A. Management and minor in Finance

·        Currently working on my PMI certification – ETA July 2018

 

Technical skills:

·        Microsoft Note, Microsoft Excel, PowerPoint, Visio, Project Manager, Word, Project Workbench, Unix, DB2, UDBEEE, Oracle 11i, IMS, VSAM, SQL Server 2008/2010, MS Access, CICS, Informatica 6.2, 7.2, 8.2 – workflow manager, designer, administrator, Oracle Warehouse Builder (OWB), Business Objects 5.0, 6.1, and XI, Erwin 9.2, Case tools, TCP/ISPF, FTP, Toad, SQL, PL/SQL, TSQL, Cobol II, Assembler, HTML, Unix Scripting, RMAN, Changeman, Infoman, PCT and ADKAR methodology, SharePoint, JIRA, ServiceNow, Remedy, Erwin Bulk Editor, Erwin Web Portal

 

Professional Experience:

 

Open Systems

Client: TIAA-CREF

Data Architect   Dec 2016 – Jan 2018

·        Data Architecture and Data Modeling for a replacement Regulatory Communications and Output Management (RCOM) Data Warehouse for the following purposes:

o   Taking in new source information for fund trading confirmations for TIAA TC Life and Prospectus

o   Leading Architectural development, implementations, and best practices to drive increased efficiency, quality, reduced time to take in new source system data, increase quality, and reduce costs.

o   Development of a roadmap for architectural enhancements for future business product lines and functionality.

o   Introduced blueprints for quick source mapping for new source system for quicker ETL development

o   Managed architectural build-out onto cloud based servers for Oracle data stores and creation of Materialized View for Tableau Reporting

o   Reduced hardcoding from previous RCOM structure by + 95%

o   Established repeatable processes to identify and correct stale processes

o   Results of architectural and process changes enabled efficiency across sourcing from 7 major systems, 50+ tables, and 85+ complex Tableau reports for daily reconciliation and Senior Management reporting and review

o   Executing Data Profiling, Identifying Data Strategy, and Determination of Data Grievances

o   Leading functional and technical design sessions to finalize documentation for application development

o   Reviewed system architecture and application development to increase effectiveness and quality

o   Database – Oracle 11i , ETL – Data Stage, Reporting – view, materialized views and Tableau

o   Managed data modeling efforts for the entire rebuild - Hands on with Data Modeling tool – Erwin version R9.7

 

Client: AIG​ - March 2014 – Feb 2016

Production Services – Data Architect and Data Modeler

·        Data Architect and Data Modeling for Global Risk and Property Casualty Risk – SSIS data warehouse with Java Web interface -

·        Program / Development Management - directing both onshore and offshore resources – infrastructure and software releases 

·        Managing Dev to UAT to Production deployments and coordinating resources – onshore and offshore

·        Managing server configurations, budgeting, and decommissioning 

·        Managing user provisioning for all environments 

·        Managing and coordinating DBA and technical staff functionality

Client: CITI.    ​Jul 2013 – March 2014

Release Manager 

·        Program Release Manager - directing both onshore and offshore resources (40+) – infrastructure and software releases 

·        Managing Dev to UAT to Production projects and coordinating resources – onshore and offshore

·        Project Management using Agile Methodology used during development, testing, and implementation of strategic and supportive code

·        Reporting to Executive on development and release from DEV/UAT to Production for financial feeds in the Global Warehouse for consumption by internal CITI personnel and external partners. Enhancement and maintenance of 4 major data warehouse systems covering over 500 million in asset transactions per week.

·        Setting up Sharepoint Application Registry for UAT projects 

 

 

 

Client: JPMC        ​Feb 2013 – Jul 2013 

Senior Data Architect

·        Data Management - directing both onshore and offshore resources (40+) – $3M project 

·        Reviewed and made recommendations for major logical and physical model changes for the ICDW system

·        Reporting to PMO and Executive on Customer data migration effort from a legacy EDW system (DB2) to an Integration Customer Data Warehouse (ICDW). 

·        Project Management using Agile Methodology and Waterfall Methodology used during development, testing, and implementation of strategic and supportive code

 

Cognizant Technology Solutions (FTE) – DWBI Associate IT Director – Data Architect and Data Modeler      ​     Jul 2011 – Feb 2013

Client: WellPoint, Medco, CareFirst, Aetna, United Healthcare

Domains: Membership, Consumer, Policy, and Vendor Membership, Consumer, and Policy

·        BI Assessments and Metadata Strategy Roadmaps – Data warehouse (ODS/EDW/DM) Informatica and SQL Server 2008 for MDM solutions

·        Assessment of entire DW models and capabilities for identifying increased performance and scalability (as-is to future)

·        Review of current data structures and processes to identify scalability, analytical, and web capabilities for enabling DaaS

·        Re-Architecting and refactoring of immature technology and architecture – reducing runtimes from 30 hours to under 3.4 hours

·        Data Architect and Data Modeling – hands on for Healthcare Payer Models – Erwin R9

·        Included Dara Architecting and data modeling, and coordination of off-shore developers (22), status reporting to Portfolio Management (PMO) 

·        Data management for major changes and correction fixes to billions of records – reduction of defects from over 70% affecting over 25 million records to 0.01% affecting under 500 records

·        Creating Reporting Data Store (star schema)

 

Technical Data Architect and Data Modeler (FTE)​ Apr 2010 – Jul 2011

Client: Microsoft – Multi-project management (global applications)

·        Domains: PFE, SR Wellness, MS Voice for executive reporting and cubes – Global Consumer Systems

·        Premier Field Engineering (PFE) – PFE Axis On boarding – Global Consumer Applications

·        Development of new staging and data mart for PFE reporting under a MDM solution base – Data Architecture and Data Modeling

·        Hands on Data Modeling using SAP PowerDesigner 12.1 & 12.5 (Microsoft SQL Server)

·        Data Warehouse Architecture for on SQL Server platform for:

·        SR Wellness – Global Consumer Applications

·        MS Voice – Global Consumer Applications

 

ETL and Data Architect  ​​​  Sept 2009 – Apr 2010

Client: Lockheed Martin

·        ETL Architecture and Governance – Payroll and Benefits system – Global Consumer systems

·        Data Governance, ETL migration procedures, UAT testing and Production deployment

·        Executive Strategy Analytic Management Systems and Subsystems – Project and Program Management (EDW and Cube Analytics) – entire US Navy 

o   Labor – Direct and Vendor (OLTP to EDW) – Naval Logistic and Ships

o   Labor Availability – Billet, Ship transfer, Position Transfer, and Grade Promotion 

·        Change management for EDW and analytic cube per bi-monthly roll-outs to production

·        Work with data architects, database administrators, networking administrators, and data transmission administrators on upgrades (VOIP, Oracle, SQL Server, LDAP, and web portal)

·        Project acceptance and closure validation with Lockheed Martin executives and US Navy commanders

 

Education – MBA University of Phoenix (MIS)​Aug 2008 – Aug 2009

 

HP/Knightsbridge - Technical Consultant Manager (FTE)        Aug 2005 – Jul 2008

Project/Program Manager – 5 projects – 400K- 1.2 million per project 

Client: Blue Cross/Blue Shield - Health Payer System – Claims, Member and Provider system – Consumer systems (reporting and web portal) and EDI transaction processing (270, 271, 834, 835, 837)

·        Managing on-shore and off-shore staff from HP, Deloitte

·        Technology Architect: Hardware Infrastructure, Web and ETL applications, Dashboards, and Data Warehouse RDBMS, Decision Management and Support systems

·        Environment: IBM P595 (4) 64-bit servers AIX 5L Version 5.3 with four logical partitions per server using grid technology, Red Hat Linux operating system. ETL applications were Informatica 8.2 with Powercenter, Power Connect. Data modeling tool was Erwin. Client machines utilized Windows XP with windows authentication. Data structures were Oracle 10g with partitioning. 

·        Technology Architect: Hardware Infrastructure, Web and ETL applications, Dashboards, and Data Warehouse RDBMS, Decision Management and Support systems for MDM systems

·        Methodology: PCT and ADKAR aligned to DMAIC Lean Six Sigma tollgates.  

·        Lifecycle management focusing on scalability, service level agreements, quality of service (QOS), platform strategy on combining data from multiple sources

·        Data lifecycle management architecture and design for backup/recovery, disaster recovery, storage planning, and data retention policy

·        Project Management using Agile Methodology and Waterfall Methodology used during development, testing, and implementation of strategic and supportive code

 

Informatica Trainer 

·        Training data management architecture, systems integration, and Informatica v8.2 ETL mappings, workflows, administration, scheduling, and performance

 

Technical ETL & Data Architect – 1 project – 1.8 million

Client: Farm Bureau - Insurance, Re-insurance and Sales Analysis – Consumer systems (reporting and web portal)

·        Technology Architect: Hardware Infrastructure, Web and ETL applications, Dashboards, and Data Warehouse RDBMS, Decision Management and Support systems

·        Environment: IBM P595 (2) 32-bit servers AIX 5L Version 5.3 with four logical partitions per server, Red hatLinux operating system. ETL applications were Informatica 7.2 with Powercenter, Power Connect, and Power Exchange. Data modeling tool was Erwin. 

·        Lifecycle management focusing on scalability, service level agreements, quality of service (QOS), platform strategy on combining data from multiple sources

·        Data integration via ETL – combining data from disparate sources and platforms, plus heavy systems integration (mainframe, UNIX, external vendor feeds)

·        Strong ETL experience with data extraction, transformation, and load into target data stores

·        Heavy systems integration testing across multiple corporate business unit

·        Executing Data Profiling, Identifying Data Strategy, and Determination of Data Grievances

 

Data Architect & Data Modeler – 2 global projects – 2.1 million

Client: Electronic Arts - Game Software, Sales Pipeline, CRM - – Consumer systems (reporting and web portal)

·        Global Application Web Program – CRM and Game Software – Business Analysis and IT activities

·        ODS, and EDW and user sandboxes using Erwin 4.0 as the data modeling tool. Oracle 10g was the DB environment.

·        Environment: IBM P595 (2) 64-bit servers AIX 5L Version 5.3 with four logical partitions per server, SUSE Linux SLES 9 operating system. ETL applications were Oracle Warehouse Builder (OWB). Technical prototyping with interfacing from SQL Server into an Oracle data warehouse for Demand Synchronization.

·        Lifecycle management focusing on scalability, service level agreements, quality of service (QOS), platform strategy on combining data from multiple sources

·        Data integration via ETL – combining data from disparate sources and platforms, plus heavy systems integration (UNIX, SQL server, external vendor feeds)

·        Data lifecycle management architecture and design for backup/recovery, disaster recovery, storage planning, and data retention policy

·        Project Management using Agile Methodology and Waterfall Methodology used during development, testing, and implementation of strategic and supportive code

 

ETL & Data Architect/Data Modeler

Client: Microsoft – Sales Force Role and Response -– Global Consumer systems (reporting and web portal)

·        Global Application Web Program – Sales and Response Software – Business Analysis and IT activities

·        Analyzed the current data modeling architecture for the Role Based Reporting of granular personnel and corporate reporting management level.

·        Technology Architect: ETL applications, and Data Warehouse RDBMS, Decision Management and Support systems Synchronization

·        Lifecycle management focusing on scalability, service level agreements, quality of service (QOS), platform strategy on combining data from multiple sources

·        Service oriented architecture (SOA) for reuse of software applications and business rules across multiple business segments

·        Heavy systems integration testing across multiple corporate business units

·        Design and implementation of data warehouse structures and workflows (conceptual, high-level, and detail)

·        Project Management using Agile Methodology and Waterfall Methodology used during development, testing, and implementation of strategic and supportive code

 

<span style="font-size:7.5pt;font-family:Aria