Principal Data Management Resume
Dallas, TX
SUMMARY:
- Confidential is a 30+ year veteran in the business community with experience in Solution Architecture, Program/Project Management, and Advisory Services with budgets exceeding $450M and implementation staffs as large as 125.
- Petrochemical/Energy industry, Financial/Banking, State and Federal Government, Manufacturing, Telecom, Pharmacy/Medical, and Client information systems.
- Projects utilized client specific development methodologies or RUP/RAD/Agile development methodologies, as well as PMO office methodologies or industry standard PMBOK methodology.
- Business Intelligence (BI) reporting
- Applied Analytics (AA), Predictive Analytics (PA), Dashboards & reporting
- Data Warehousing (EDW)
- Master Data Management (MDM)
- Business Process analysis, development, redesign, optimization, Updating & Integrating
- Structured Real - time Object-Oriented Application Development
- Data Center Design and Deployment including Consolidation
- SEI CMM Software Process Maturity Model Auditing
- Data & Process Governance
- In addition to extensive Program/Project experience, Confidential is adept as a business analyst at collecting requirements from line of business stakeholders, designing and/or altering Enterprise Solution Architectures and matching those to specific technologies all while bridging the communication gap between the Business Users and IT.
- He has extensive experience managing large migration projects and coordinating efforts and communication with various stakeholders.
- Confidential is also proficient at gaining consensus with disparate groups, even when they at first do not agree.
- Beyond Confidential ’s relational and communication skills, he has strong technical acumen, with the ability to simplify technical issues for non-technical constituencies.
- He is often engaged by operational teams to investigate back-end issues as well as front-end user issues.
TECHNICAL SKILLS
BI Applications: QlikView, QlikSense, MicroStrategy, Tibco Spotfire, SAS, Microsoft, Tableau Software, Oracle OBIEE, IBM, SAP (Business Objects), Pentaho, Information Builders
EDW/MDM Applications: IBM InfoSphere, Infomatica PowerCenter, Pentaho, Oracle Warehouse Builder (OWB), Oracle Data Integrator (ODI), Adeptia, Clover, Ab Initio, Tibco CIM, Profisee, MIOSoft, Orchestra, RedPoint
Data Storage: DB2, Oracle, Oracle Exadata, Teradata, Microsoft SQL, ERwin Data Modeler
Enterprise Solutions: Pegasystems, SharePoint Server, SQL Server, Internet Information Server (IIS), IBM Connections, Lync, Tandem NonStop Guardian & Integrity Systems
Architecture: Microsoft SQL Server, HTML, XML
Infrastructure: Windows Server 2008/2008 R2, SQL Server 2005/2008/2008 R2, Active Directory, IIS (Internet Information Server), SharePoint Server, Routers and Switches (Cisco, Foundry, Allied Telesyn)
PROFESSIONAL EXPERIENCE:
Confidential, Dallas, TX
Principal Data Management
Responsibilities:
- Responsible for Architecture, deployment, and overall Program management for Pekin Insurance to implement business intelligence, predictive, and applied analytics tools to improve enterprise systems, data quality & governance, data gathering capabilities, and reduce costs.
Technologies Used - QlikSense, Tableau, Hadoop, Cloud Based Storage, Oracle, SQL, Profisee, MIOSoft, Orchestra, RedPoint
Confidential, Houston, TX
Senior Business Intelligence Consultant
Responsibilities:
- Responsible for Architecture, deployment, and overall Program management for Apache Petroleum to implement business intelligence, predictive, and applied analytics tools to improve enterprise systems, data quality & governance, data gathering capabilities, and reduce costs.
Technologies Used - SAS, Tibco Spotfire, Tableau, Hadoop, Cloud Based Storage, Oracle
Confidential, Austin, TX
Director of Business Intelligence & Marketing
Responsibilities:
- Responsible for Architecture, development, and deployment of industry standard Enterprise business systems as well as upgrades/modernization of existing systems, along with the deployment of Applied/Predictive Analytics Business Intelligence tools for a State Not-for-Profit Association.
- Additionally, responsible for updating the MarComm campaigns, materials, and multiple Websites for the Association and multiple Business units.
Technologies Used - SAS, QlikView, QlikSense, Tableau, Tibco Spotfire, Hadoop, Cloud Based Storage, Oracle, IBM InfoSphere
Confidential, Austin, TX |
Director of Business Intelligence & Marketing
Responsibilities:
- Responsible for Architecture and Project oversight and implementation of an Applied/Predictive Analytics system for a Federal Government Agency.
- Internal systems were supported by the Corporate Teradata system and efforts included the consolidation of all data into a Global Unified Business view, providing analytic data marts, standardized reporting, analytics & KPI’s across all regions, and Globally scaled.
- Completed implementation provided global execution, faster cycle times and speed to developing reports synchronizing Enterprise data, account structures and processes.
Technologies Used - SAS, Tableau, QlikSense, Tibco Spotfire, Hadoop, Cloud Based Storage, Oracle, IBM InfoSphere, R (open source Programming Language)
Confidential, Dallas, TX
Vice President - Applied Analytics
Responsibilities:
- Efforts included the consolidation of all data into a Global Unified Business view, providing campaign analytic data marts, standardized reporting, analytics & KPI’s across all regions, and Globally scaled on targeted and trigger marketing. Completed implementation provided global execution, faster cycle times and speed to market, synchronizing Marketing and Sales data, account structures and processes.
- Responsible for performing the Data Discovery/Data Profiling/Data Architecture for MGM Resorts, which defined a Unified Business View of the internal operational systems & Datamarts, which included reviewing & analysis of 20+ Data sources and documenting the schemas.
- Created data flow diagrams documenting source system data flows from source systems to datamarts, datamarts to datamarts, and provided a business view of the data flows for the datamarts that can be communicated to the business users. Documented the inbound and outbound interface attribute of the source system, i.e. what is the point of origin of the information stored and what is the Data Lineage.
Technologies Used - SAS, QlikView, QlikSense, Tableau, Tibco Spotfire, Hadoop, Cloud Based Storage, Oracle, Teradata, IBM InfoSphere (MDM and BPM), Informatica PowerBuilder, R (open source Programming Language)
Confidential, Austin, TX
Senior Manager
Responsibilities:
- Program Manager & Solution Architect for a Data Center Transformation, Migration, and Modernization effort for Confidential, which included approximately 20 projects to accomplish the successful effort.
- Project required the consolidation of multiple operational data systems & analytic data stores into a consolidated system resulting in a Unified Data Business View for use by agency business analysts and external industry users.
- Project included development of numerous Business Intelligence reports and Analytics universes.
- Reports were used for past, present, and future production measurements, primary/secondary/tertiary flood activities and regulation, potable water tables, salt & wastewater disposal, and other agency regulatory requirements.
Technologies Used - QlikView, QlikSense, Tibco Spotfire, Hadoop, Cloud Based Storage, Oracle
Confidential, Dallas, TX
Principal Senior Consultant
Responsibilities:
- Solution Architect and Team Leader for EDW/BI Tool & Enterprise Solution for a Data Warehouse installation effort UBS Financial Services, for the migration of COBOL based data and functionality into an IBM InfoSphere environment. Data Business View and reports were for use by company business analysts and external customer users.
- Project included development of numerous Business Intelligence reports and Analytics universes for reports to be used for past, present, and future financial measurements.
- Solution Architect for EDW/BI/AA Tool & Enterprise Solution for a Data Warehouse installation effort Confidential for maintaining corporate data in Sales, Marketing, Manufacturing and Product Testing. Data Business View and reports were for use by company business analysts and internal/external customer users.
- Project was to include development of numerous Business Intelligence reports and Analytics universes for reports to be used for past, present, and future Operational measurements.
- Solution Architect for the design of a Business Intelligence Competency Center (BICC) for 3M.
- Evaluation team Solution Architect for EDW/BI/AA Tool & Enterprise Solution for a Data Warehouse installation effort Devon Energy.
- Data Business View was for use by company business analysts, oilfield production personnel, and external industry users.
- Project was to include development of numerous Business Intelligence reports and Analytics universes for reports to be used for past, present, and future production measurements, production & drilling activities, primary/secondary/tertiary flood activities and regulation, potable water tables, salt & wastewater disposal, and maintenance processes.
- Evaluation team Solution Architect for the implementation of a Center of Operational Excellence for Husky Energy around the Sunrise Project. Solution was to include production & maintenance activities as well as predictive analytics to reduce equipment failure downtime and loss or effective runtime.
- Evaluation team Solution Architect for the implementation of a Center of Operational Excellence for British Petroleum (BP). Solution was to include production & maintenance activities as well as predictive analytics to reduce equipment failure downtime and loss or effective runtime.
- Evaluation team Solution Architect for EDW/BI/AA Tool & Enterprise Solution for a Data Warehouse installation effort for Chevron. The purpose was to create a Global Data Business View suitable for Business Intelligence reports and Analytics universes for Structured and Unstructured (i.e. dated paper-based well logs, etc) data to be used by Reservoir Engineers and Geologists.
Technologies Used - QlikView, QlikSense, Tableau, Tibco Spotfire, Hadoop, Cloud Based Storage, Oracle, Teradata, IBM InfoSphere (BPM & MDM), Informatica PowerBuilder, R (open source Programming Language)
Confidential, Dallas, TX
Principal Senior Consultant
Responsibilities:
- Project Manager and Solution Architect for the implementation of an EDW & Master Data Management system dashboard project for Confidential that summarized individual project plans and business processes for worldwide projects to provide Executives a Global, Regional, by Project Lead and by Project View in a Web-based format.
- Solution included every type of project including preliminary exploration, Exploration, Drilling, Production (primary/secondary/tertiary recovery), decommissioning, and standardized the Business processes including approval processes, funding, and equipment acquisition for the projects.
- Project Manager and Solution Architect for the implementation of an EDW & Master Data Management system with dashboards for Confidential .
- The system was used for the entire Bank Operations including customer information, account information, loan/credit processing, and all transactions. Project was to include development of numerous Business Intelligence reports and Analytics universes for reports to be used for past, present, and future financial measurements.
Technologies Used - QlikView, QlikSense, Tableau, Tibco Spotfire, Cloud Based Storage, Oracle, Teradata
Confidential, Austin, TX
Principal Senior Consultant
Responsibilities:
- Led an 8-person team as Project Manager and Solution Architect in the migration of Manufacturing, Financial, and Engineering Data, with appropriate Business Process redesign, from Oracle Data Marts onto an existing Corporate Teradata EDW for Advanced Micro Devices.
- Implemented Business Objects Xi Universes and a Service-Oriented Architecture (SOA) to achieve the project’s objective of better access to the data via Business Objects Universes and establishing better Data Governance Policies & Procedures, including the Verification & Validation Test Plans/Procedures, Performance Testing and Final Customer reports acceptance.
Technologies Used - Business Objects, Oracle, Teradata
Confidential, Herndon, VA
Principal Senior Consultant
Responsibilities:
- Developed a Universal Master Data Governance & Data Quality plan, including policies and procedures, for use by clients deploying Master Data Management systems for Key Customer Data. Plan includes key activities such as initial Data Profiling and Cleansing, development of automated rules for initial and ongoing Data Cleansing, and ongoing support of the system data by Data Stewards.
- Performed Business Redesign/Reengineering of the Global ETL processes, overall business processes and procedures for multiple stakeholders for Lowe’s Home Improvement Centers, for Customer & Billing contacts and for Manufacturing, Production, & BOM information.
Technologies Used - Oracle, Teradata, IBM InfoSphere
