Thought Leader And Data Management/governance Subject Matter Expert Resume
Overland Park, KS
SUMMARY:
IT professional with extensive project and program management experience, product ownership, and business process analysis, engineering and design. Subject matter expertise in Enterprise Information Management (Data Engineering, Data Governance). Focused in client - facing management of EIM engagements, is also hands-on with deep technical skills in data warehousing, business intelligence, and data analysis. Architects, engineers, performs business, business process and data analysis, requirements gathering, designs, develops and implements strategic innovative solutions to complex problems. Creatively leverages analytical skills and deep experience to proactively resolve problems, both managerial and technical and mitigates potential crises. Motivates and inspires colleagues and subordinates to successfully meet goals.
SKILLS:
People/Project skills: Account/Portfolio/Program/Project Management - including budget, resource, time and delivery management, Defining strategic solutions, Business Analysis, Process Analysis, Risk Analysis and Mitigation, Problem Analysis and Solution Architecture, PMO, AGILE, Product Management, team-building, motivating, mentoring, training, onsite/offshore/multi-site management. Data Governance - Frameworks and Implementation Roadmaps including Master Data Management, Data Quality, Integrity, Lineage, Taxonomy, Definitions, Naming Standard, Artificial Intelligence and Machine Learning, Error handling and Exception reporting. Business and technical documentation and communication.
Technical skills: Data Warehouse Management, Business process mapping, design and management, Data Governance and MDM tools by Informatica, IBM, Microsoft, SAP, and Collibra including the following functionality Data Quality, Integrity, Lineage, Metadata, Glossary, Catalog, AI and ML to support data mining in both structured and unstructured data repositories, Retention, Access and Security), Engineering including Full SDLC of components ETL/ELT (Data Ingestion, Integration; Informatica, Oracle, InfoSphere, Ab Initio, MS SSIS). Data Architecture including Data Analysis, Profiling, Mapping, Mining, Modeling (Relational, Dimensional - star, snowflake; Conceptual, Logical, Physical data models), Data Platforms (traditional in-house servers, Cloud (Amazon, Microsoft, Google, private), hybrid). Databases Traditional (Oracle, MS SQL Server, DB2/UDB, etc.), Proprietary MPP (Exadata, Netezza, Teradata, etc.), Commodity “Big Data” (Hadoop and Appliances - Cloudera, Hive, Sqoop, BASH, Python, NoSql, etc.). Data Reporting, Visualization and Analytics (dashboards, OLAP cubes; OBIEE, Cognos, Tableau, Qlikview, Alteryx, MSBI, SSAS, SSRS, etc.; real-time, “JIT”, batch) System Environments (Dev, Test, QA, Production, Support). System interfaces. XaaS services (SOA) PaaS, SaaS, IaaS, etc.
Industry Domain skills: Healthcare including Administration Group and Individual Policies, Members, Finance, Actuarial, Underwriting, Claims, HIPAA and other compliance); Service Providers (Providers, Facilities, Procedures, Clinical Trials, Pharmacy); Equipment (Products, R&D). Financial Services (G/L, Mortgage Lending, Asset Management, Cash Management and Payment System interfaces, Retirement Accounts, Corporate Investments, Lines/Letters of Credit, Credit Cards, Personal Banking, Risk Assessment, Regulatory Reporting). (Re)Insurance (Finance, Pricing, Actuarial, Underwriting, Claims, Ceded, Catastrophe Modeling, Regulatory Reporting, Risk Exposure, Basel Solvency II). Human Resources (Personnel, Compensation, Benefits, Staffing, Vendor Management).
PROFESSIONAL EXPERIENCE:
Confidential, Overland Park, KS
Thought Leader and Data Management/Governance Subject Matter Expert
Responsibilities:
- Engage with clients to advise and recommend data management and governance strategies to meet the client’s strategic and operational needs, and to maximize the value of data when considered as a key corporate asset.
- Provided these recommendations to Client Sponsors and Executive Stakeholders in the form of frameworks and roadmaps.
- Provided training through workshops and presentations and operational handbooks as required.
- When asked, served as Program Manager in delivery portion of the data management/governance framework.
- Stand-up and actualize the governance organizations and train them to a level of expertise necessary to properly decide and drive decisions for data management and governance; 2) Data quality maturity assessment and remediation, and 3) establishing enterprise master data through MDM methodologies and tools (by data domain), 4) work with data owners and scientists to develop governance policies and procedures for opportunities for mining/identifying additional data and metadata across structured data (eg known database) and unstructured data (data lakes) - both using manual mining and Artificial Intelligence and Machine Learning.
- One critical success factor for one client was developing an MDM and governance set of policies and procedures to ensure 100% data quality to meet the client’s goal of autonomous trains within the next 6 years.
- This involved developing standards and processes for structured data, IoT data, semi structured (e.g. EDI), and unstructured data (requiring AI and ML for data science and mining to identify).
- Systems were both server and cloud (AWS, Azure) based and included systems and databases SAP, Salesforce.com, Exadata, MS SQL Server, and in-house built applications to support them which were being integrated and migrated into a single enterprise-available ERP and analytics system.
Confidential, Austin, TX
Data Governance Subject Matter Expert / Thought Leader
Responsibilities:
- predicated on the delivery of a governance framework and 4 year roadmap. Business goals including streamlining and optimizing business and IT processes (e.g. unemployment claims and job search duplicate data entry and claims processing), reduce by 40% the amount of improper or fraudulent payments made to claimants and beneficiaries, build and maintain a “single version of the truth” via the creation of a Master Data repository shared across the enterprise and removed from siloed, legacy business unit systems.
- Conducted data management maturity DMM assessment, complete IT current state assessment, business process analysis including Confidential ’s ability to accept business process changes, and conducted interviews, working sessions, tutorials, and solicited recommendations from leadership as to their desired framework for meeting the above goals.
- Final delivery is a plan for 5 year implementation and maturing of a formal, non-invasive data governance framework to include business glossary and definition, data quality and lineage, assorted metadata, governance and MDM policies and procedures.
Confidential, New York, NY
Managing Principal - Enterprise Information Management/Big Data/Data Governance Practice Lead
Responsibilities:
- Business Proposal for a large, non-profit healthcare provider to Establish formal Data Governance Program to resolve 3 key issues impacting the organization: Address Claims Fraud (member and provider), Decrease time from claims receipt to claims payout, position the organization to be able to compete with for-profit healthcare organizations in current industry/political climate. Performed business process analysis and data analysis to propose business change requirements in support of new processes and data architecture.
- Prepared data governance framework including business-driven policies and procedures to ensure HIPAA compliance and other privacy issues; technical architecture framework including physical platforms, data acquisition and transport methods, conceptual, logical and physical data models to meet healthcare plan, medical and pharmaceutical provider, and medical equipment providers data requirements governance, quality and integrity of master, transactional, and metadata (business rules, definitions, etc.), R&D, clinical trial data; ETL and database architecture to support ingestion, manipulation, integration into staging, ODS, warehouse and BI/Analytic environments including on-demand and canned database schemas.
- Also provided 3-year roadmap for completing development and implementation of framework.
- All deliverables were based on a hybrid Exadata (Oracle)/Cloud physical environment and governance/data management using Informatica and Collibra.
- Established a program for a medical provider (globally recognized hospital) which was expanding to a full healthcare network including individual medical providers to provide 360-degree member view and management, in addition to a portal to be provide direct member access. Key activities for the program included data analysis and profiling, including exceptions and anomalies, data conformity and integration (name and address matching), ETL solution using Informatica, creation of an enterprise data warehouse to support existing information and newly acquired information from organizations/providers joining the health plan.
- For a global investment firm, provided Data Governance Framework and Roadmap to address new European GDPR regulations. Included in the deliverables were a DG program plan (policies, procedures, suggested governance leadership team), selection of data governance tools (Collibra ultimately selected) compatible with Hadoop and Oracle/Peoplesoft platforms, development of conceptual and logical data models to expand upon existing governance framework supporting other regulatory requirements (e.g. PIM, Confidential 239)
Confidential, Boca Raton, FL
Management Consultant
Responsibilities:
- Serving as Senior Technical Program Manager and Big Data/Cloud Architect for a global Financial Services and Insurance firm in New Jersey, directs, manages and executes highly complex data integration and reporting programs in support of an HR Integrated Data warehouse program, to provide efficient, best-of-breed, cost effective reporting, BI, and Analytics solutions.
- The organization as a whole will ultimately benefit by leveraging this newly defined enterprise standard integration and Big Data platform/framework to lower costs and reduce time-to-delivery of business critical, information dependent processes.
- Prepared detailed business process mapping and proposed process change design to better time-to-delivery of data driven functionalities.
- Influential in the architectural solution, including Hadoop. Cloudera, Sqoop. BASH, Informatica (Big Data Edition).
- Develops conceptual and logical data models for staging and dimensional environments
- Implemented a data governance program to ensure effective data management across the dataset(s) included in the program using Informatica and Collibra.
- Accountable for all program deliverables and closure of program on time and on budget.
Confidential, NY, NY
Senior Informationist / Data Governance Subject Matter Expert
Responsibilities:
- An Information Management and Analytics professional who, through Project Management and business analysis, helped my clients maximize information value and create business advantage.
- Work mainly focused on the development of generic and industry-specific data governance (Informatica, Collibra, IBM) frameworks as products for business development across existing and potential clients in the financial, insurance and entertainment industries. Focus on solutions architecture in Big Data (Hadoop, Teradata) and cloud based systems (AWS, Azure).
- Offsite Senior Solutions Architect for a project involving a healthcare insurance provider which had merged and/or acquired several other healthcare providers. Responsibilities included business and data analysis, architecting data warehouse (and associated environments) to support merged, consolidated, conformed data to provide single-definition, single-source of truth across all the newly unified healthcare organizations. Migration from in-house server based Netezza system to AWS cloud including re-architecting database tables to accommodate new capabilities with respect to partitioning, columnar load and querying, working with Amazon to performance tune the new hybrid cloud environment including replication, backup and archive strategies.
Confidential, Teaneck, NJ
Sr. Project Manager/Data Governance Director
Responsibilities:
- Serve in a variety of management roles including Project Manager, Program Manager, Senior Business Analyst, Technical Manager and Data Governance Director for a number of clients related to Enterprise Information Management (Data Warehousing / Business Intelligence, Business Performance Management) across multiple industries.
- Responsible for startup of EIM related IT programs and projects for assorted clients across Finance, Insurance, Healthcare, and Life Sciences industries including: Developing strategy, creating frameworks and roadmaps for each program (delivery and governance), staffing and onboarding, project planning, incorporating programs into client’s PMOs and being a member of the PMO, establishing and defining new / supporting change of existing data governance organizations to in corporate (support and manage) new information associated with the programs.
- Served as the Project/Program Manager and Senior Business Analyst for a major surgical/medical supplies manufacturer to modify their existing cloud-based, Big Data Enterprise Datawarehouse and BI platform to improve the organization's sales modelling capabilities and financial forecasting - ultimately to support improved decision making of sales territories and potential purchasers and increasing revenues. As part of this effort new internal and external ETL interfaces for their R&D business units needed to be created to provided quantifiable results from the use of their medical equipment at healthcare providers and within ther own R&D test facilities. The inclusion of this additional information, especially external, heterogeneous data feeds required the establishment of new data governance procedures (business and technical) and 2-year roadmap to provide data quality across heterogeneous databases, tools, and applications, including Microsoft SQL Server 2010 and Oracle Exadata environments, Informatica and Collibra Governance tools. Successfully went through 3 complete iterative SDLC cycles for development, deployment and production support of these changes.
- Project/Program Manager for multiple global healthcare companies (separate projects and initiatives), each of which were requesting consolidation and outsourcing of their data and production support (L2-L4) units to be provided by a single vendor (Cognizant). This was a 3-year, $45MM budget involving 200+ FTE. Responsibilities ranged from preparation of oral RFP response, building out initial project plan for delivery, resource planning and onboarding activities, and overseeing Knowledge Transfer/Acquisition from client and existing other support vendors to Cognizant. Subsequent project required re-engineering (new data models, interfaces, ETL processes) of these organizations data repositories (warehouses, BI, Analytics platforms) to help simplify ad streamline the support procedures enacted by Confidential to services the clients Worked with existing Data Governance organizations of both clients to improve overall data quality, accessibility, lineage, integrity and privacy so that clients and Confidential were ensured of stable, well defined data (Collibra, IBM).
- Analyzed data and existing risk reports for a global financial services firm and established Data Governance program to ensure data quality, integrity, lineage, consistent business definitions to meet Confidential 239 regulatory requirements.
- Lines of business included Commercial Investments, Credit Card, Auto Finance and Student Loans.
- Work done using SAS and Microsoft SQL Server 2008 environment.
Confidential, North Haven, CT
Sr. Project Manager / Sr. BI Consultant
Responsibilities:
- Provide project management and subject matter expertise to a national cable multi-system operator in developing business intelligence solutions to enhance the functionality and improve capabilities of sales teams in designing and selling campaigns and promotions.
- Primary responsibilities in this role included normal project management tasks (managing project to complete within budget, time, and scope constraints), working as a liaison between business users and the IT / data warehouse departments to understand business requirements, leverage new technologies and the information available from them and incorporate/transition to cloud-based, Big Data environment of the Enterprise Data Warehouse to provide additional data and integration of data from multiple disparate systems into a cohesive set of business information that would provide reporting, dashboards, and predictive analytics thereby enhancing the productivity of the Sales teams and creation of sales opportunities across channels, networks, zones and dayparts. Work performed in a Netezza environment using Cognos v10.
Confidential, Stamford, CT
Vice President, Reinsurance Data Warehouse / Product Owner / Data Governance Leader
Responsibilities:
- Project/Program(s) Manager for a company-wide, global initiative to meet European regulatory reporting (Basel Solvency II) needs (50+ FTE) using Agile management techniques to mitigate continually changing requirements from external regulatory groups. Provided data analysis and technical architecture to build DW/BI analytic system to support this reporting. Applied PMO methodologies to ensure smooth execution of projects and workstreams vis-à-vis all projects run in XL Re.
- Project Manager, Business Analyst and Systems Architect for the Reinsurance segment implementation of FR&C, an automated process of generating, transmitting, and controlling financial transactions from the Reinsurance Data Warehouse (RDW) to XL’s PeopleSoft Financials system ( )
- Created and lead the Data Governance Group for the Reinsurance Data Warehouse to create a controlling group within XL Re to ensure data quality, integrity, business purpose and meaning (especially with respect to the use of similar business terms having different meanings across geographical business units and regulatory reporting agencies). Governance framework included data quality, integrity, lineage, naming standards, business definition consistency and Master Data Management (MDM). Implemented using Informatica toolset. This governance implementation resulted in a 93% increase in user confidence of the organization’s data quality and consistent usage. ( )
- Project Manager and IT Lead for XL Re Finance Functional Team - coordinating efforts of, and working with, senior finance leadership at XL in determining short and long term tactical and/or strategic solutions to meet growing global financial reporting requirements. ( ).
- Served as the Data Warehouse Manager for a multi-year initiative to consolidate and integrate data from multiple disparate OLTP systems into the company’s proprietary OLTP system and associated data warehouse (, 40 FTE). Member of XL Re’s PMO, suggesting changes to PM methodology to shorten timeline of this initiative from 6 to 4 years, reducing cost of program.
- Release Manager for XL Re Destiny/RDW systems development and deployment of specific releases - oversee and manage all phases of SDLC across all functional areas (Finance, Underwriting, Claims, Cash, Accounting) in developing and successfully deploying new release of application(s) into Production on time and on/under budget
Confidential, North Haven, CT
Sr. Project Manager /Sr. Data Warehouse Consultant
Responsibilities:
- Provided Project management and leadership expertise pertaining to the design, development and maintenance of an Enterprise Data Warehouse for a global reinsurance leader. Was accountable at client for developing ETL/Informatica design, code methodology and standards. Proposed and prototyped architecture for quality assurance testing and reporting.
- Architected and implemented selective rollback and recovery solutions for maintaining integrity of the data warehouse while maximizing availability. Involved in team redesign of ETL architecture from business unit based data marts to consolidated enterprise warehouse.
- Technical Lead for several projects to in corporate data from business units into the data warehouse. Analyzed source system data and target warehouse and Datamart tables; architect and develop data mapping transformations; implemented these transformations using Informatica Sybase ASE 12.5, SQL Server, T-SQL, Autosys and NT2000. Served as Informatica/ETL Subject Matter Expert within the client’s IT framework.