Vp Enterprise Data Management/architecture Resume
Irving, TX
SUMMARY:
- Extensive information technology experience with a combination of technical consulting expertise and functional leadership, including presales and business development. (Direct - hire and Consulting roles held.)
- Strong Software Architecture and Systems Engineering Experience, with emphasis on ETL/ELT Solutions using Informatica Tool Suite, Expert IBM InfoSphere ETL Tool Suite, including InfoSphere Governance Catalog. Oracle and SAP Certified.
- Expert Level hands-on Chief Data Officer (CDO) Leadership skills in Management Information Systems, BI OLAP Analytic, Data Warehousing/Business Intelligence experience and has lead data warehousing/business intelligence (Data Modeling, ETL & BI) analytic project implementations.
- Published numerous Data Integration/EMP Web Services Systems SOA and Data Warehousing/Business Intelligence, Master Data Management and Data Governance white papers, and has been a frequent lecturer at Data Warehousing business seminars and conferences.
TECHNICAL EXPERTISE:
HARDWARE: Intel PC's /Win 95/NT XP/ 2007/2008/2010 , SUN/Solaris Servers, HP/UX Servers NCR Teradata, DELL ProLiant Servers, IBM/AIX Servers, IBM AS/400 Servers IBM-MVS Mainframe, Amdox Mainframe, Red Hat/JBoss, Red Hat/Linus
SOFTWARE: SAP R/3 ERP & BW ERP Apps. SAP SFA, FICO Applications Process Modeling BPWIN PeopleSoft Enterprise Project Management (EPM), Oracle ERP/Hyperion/PeopleSoft - CRM 8.8 & 8.9 ERP ERD/LDM/PDM - MDM Data Modeling CA Erwin, IBM DB2 & UDB SQL QMF Reporting, Informatica ETL SoftwareIBM Ascential ETL Software, Informatica ETL Software, AbInitio ETL Software SAS STAT Analytical Tools, Enterprise BRIO Holos, MVS File Aid CA7/CA-Unicenter AutoSysWebMethods, WebLogic EAI SOA Software FTP - TCP/IP/WSFTP Syncsort Software Microsoft Project Microsoft Office Pro, Platinum Repository, Microsoft Exchange ServerVISIO Professional / Microsoft Publisher, Microsoft Access DB, LOTUS NotesCOGNOS Impromptu/PowerPlay, Business Objects (BO), Microstrategy SoftwareORACLE Express ORACLE Discover ORACLE Designer 2000, ORACLE Developer ORACLE ERP Smart Client, IQ Objects, Microsoft SQL Server 2005, 2008 R2Microsoft Reporting & Analysis Services, OLAP Reporting (SSIS, SSRS, SSAS)Microsoft Visual Studio (Visual Basic, Visual C#, Visual C++, C++, C#, J#) and Visual Web Developer) and MQ Series Messaging, ETI Extraction/Transform Software
LANGUAGES: Oracle PL/SQL Oracle SQL*Net Oracle SQL*DBA Oracle SQL*Loader Oracle SQL*Forms Oracle SQL*Report Writer MVS DB2 QMF SQL SAS INFORMIX, Hyperion Essbase, SYBASE NCR/Teradata IMS DB/DCMicrosoft Visual Studio Visual C++, .Net Framework, MS SQL Server 2008, 2010 MVS JCL MVS CLISTS/REXX Microsoft SQL Server Syncsort,RAMIS/RXX IDMS HTML/XML/JAVA MVS COBOL II Microfocus JCL, COBOL II and CICS Mainframe Messaging System Applications
EXPERIENCE SYNOPSIS:
Confidential, Irving, TX
VP Enterprise Data Management/Architecture
Responsibilities:
- Technical Lead responsible for creating the architecture, technical roadmap and drive the execution of a Data Modeling plan to build and support a best-in-class Operational Data Store (ODS) ESB/SOA to support the day-to-day operational data integration and reporting needs of the Real Estate Lending business.
- Leveraged IBM InfoSphere ETL Tool Suite, including InfoSphere Governance Catalog.
Confidential, Washington, DC
Sr. BI Strategy Solutions Architect
Responsibilities:
- Strategic Technical Architecture and 5 Year Road Map for Confidential (Enterprise Data Management - BIG Data) Product Solution.
- Ownership for defining Enterprise Level Architecture blueprints (i.e., EDI, Data Architecture, ETL/ELT & BI OLAP APP Architectures, and Technical Infrastructure Architecture).
- Worked with Confidential Executive Leadership, Business Operations LOB, and IT Operations Teams to gather and document business requirements, technical requirements and critical success criteria Confidential Enterprise BIG Data Solution deployment Road Map schedule.
Confidential
Director Enterprise Business Intelligence
Responsibilities:
- Technical Architecture Frameworks of the Product Solution. Ownership for defining Enterprise Level Technical Architecture blueprints (i.e., Data Architecture, ETL & BI OLAP APP Architectures, and Technical Infrastructure Architecture).
- Big Data solutions, leveraging JAVA EE, EJB, JBC, JCA, JDBC, JMS, JMX, JFS, POJOs, JBOSS jBPM, Eclipse scripting tools with Hadoop, Distributed File System (HDFS) and MapReduce - JUMBUNE, for unstructured Data integration.
- Leveraged IBM InfoSphere ETL Tool Suite, including InfoSphere Governance Catalog.
Confidential
Lead Database Marketing Architect
Responsibilities:
- Responsible for defining an implementation of Enterprise (Database Marketing) solutions, which leveraged Informatica ETL Tool Suite, Oracle 11g Database, also leveraged SAP Business Objects (BO) Analytic BI Reporting, and CRM data integration services to Confidential clients.
- Examples of the types of solutions would include customer/consumer product loyalty & marketing campaign ROI decision management programs.
- Utilized Stat Modeling tools SAS, Tibco-Spotfire.
- Hadoop Big Data Tools - for possible integration of Web Click Stream analytics and Social media “Un-structured” data streams.
Confidential
Principal Architect Consulting
Responsibilities:
- Leveraged Oracle 11g database, Informatica PowerCenter ETL, IBM Ascential ETL Tools, to support Data Governance ensuring data accuracy/ timeliness to maintain a “single-version-of-the-truth” data assets.
- Developed custom event driven SOA transaction processing systems using JAVA EE, EJB, JBC, JCA, JDBC, JMS, JMX, JFS, POJOs, JBOSS jBPM, Eclipse scripting tools
- Provided high-level architecture solution blue-prints that included COTS products (i.e.,ORACLE ERP, Siebel CRM, PeopleSoft HR & Enterprise Project Management (EPM), POS, etc.) systems for building out new “ Event Driven - SOA”.
Confidential
SVP Managing Director
Responsibilities:
- Responsible for defining an implementation of a Universal Information Management Strategy to provide a single environment to collect, manage and store key business information across the enterprise, along with implementation of a centralized Information/Data Governance business and technology solution.
- Responsibilities include providing high-level architecture solution blue-prints that enable utilization of Corporate Assets such as Oracle 10G DBMS for building out new Enterprise Data Integration services “Data Hub”, which leverages the both Informatica ETL & IBM Ascential ETL Tool Suite including DataStage, MetaStage, ProfileStage, QualityStage, with direct-connect interfaces to Oracle Hyperion Essbase.
- All Logical and Physical Data Models are developed and managed through Computer Associates (CA) ERWIN and Model Manager for Logical and Physical Database Models.
- All Front-Office End-User Business Intelligence solutions are delivered via the COGNOS ReportNet 8, Web Portal and Reporting Framework components.
- Leveraged IBM InfoSphere ETL Tool Suite, including InfoSphere Governance Catalog.
Confidential
Director Information Resource Management
Responsibilities:
- Responsibilities include providing high-level architecture design support for Oracle EMP &, PeopleSoft Enterprise Project Management (EPM), and PeopleSoft HR, POS, CRM 8.8 & 8.9, WebLogic Web Services
- Service Oriented Architecture (SOA) custom development using JAVA EE, EJB, JBC, JCA, JDBC, JMS, JMX, JFS, POJOs, JBOSS jBPM, Eclipse scripting tools Architected Enterprise Data Integration, Business Intelligence/Data Warehousing programs within Confidential Information Services (VIS), leveraged Oracle 10g database, Informatica PowerCenter ETL Tool, and Cognos 8 BI Reporting Tool.
- Assist Confidential Sales & Marketing Teams in vendor management partnership activities and project scoping/delivery RFI & RFP estimation functions.
- Core team member of Project Management Office, which provides governance and executive release management ROI tracking for all VIS programs and projects.
Confidential
VP Global Application Development
Responsibilities:
- High-level architecture design support for all Enterprise EMP Web Services SOA, Data Integration system architecture solutions using JAVA EE, EJB, JBC, JCA, JDBC, JMS, JMX, JFS, POJOs, JBOSS jBPM, Eclipse scripting tools.
- Ownership for all Business Intelligence/Data Warehousing programs leveraging Oracle 10g database, Informatica PowerCenter, and Cognos 7 & 8 BI Reporting Tools. Assisted Confidential (Private Bank LOB) high-value Clients custom application, through the pre-sales activities and project scoping/delivery estimation functions.
- Hands-on mentoring and leadership for systems architecture SDLC solution delivery organization.
- Have ownership of all end-to-end Enterprise Data Integration with both internal data feeds (i.e., ORACLE ERP/Hyperion Essbase/PeopleSoft HR), and external data feed Vendors, and Business Intelligence/Data Warehousing program and project solution deliverables.
- Leveraged IBM InfoSphere ETL Tool Suite, including InfoSphere Governance Catalog.
Confidential
Digital Intelligence Solution Architect/Practice Director
Responsibilities:
- Provided pre-sales support for potential Alliance engagement opportunities.
- Assisted Alliance practice management in the development/publication of "Managed Services" practice specific SDLC methodologies and deliverable templates.
- Guidance and recommendations for proposed technology solutions, and leadership / mentoring support for junior technical staff members.
Confidential
Senior Data Warehouse Implementation Consultant
Responsibilities:
- Defined and developed effective strategic business plans for the rollout of a standardized SAP Data Warehousing methodology and "best practices" software implementation approach.
- Assisted in the development of a standardized DW methodology and "best practices" approach for the implementation of Data Warehousing Programs for Client Partnerships, leveraging SAP ABAP Extractors and Informatica PowerCenter ETL Tools, Oracle 7 Database, and OLAP tools such as Cognos, Business Objects, BRIO, and Microfocus IBI. Responsible for end-to-end development processes for manufacturing SAP's ASAP BW methodology CD and custom development of Web Site Knowledge System using JAVA EE, EJB, JBC, JCA, JDBC, JMS, JMX, JFS, POJOs, JBOSS jBPM, Eclipse scripting tools .
- This CD contained SAP's recommended approach to implementing the BW data warehousing software product on top of SAP R/3 application modules.
- Application of expertise Project Management, Vendor Contract Management, Data Base Management, Business/Rule Modeling, Data Base Modeling, Resource Management, and Software Engineering.
Confidential
Oracle Applications Implementation Consultant and Data Warehousing Engagement Director
Responsibilities:
- Provided hands-on support for ORACLE Applications SmartClient 10.15 and ORACLE database 7.1, 7.2 and 7.3.2 implementations.
- Application modules installed (General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Inventory, Fixed Assets, Project Accounting and Human Resources).
- Responsibilities included installing both Client and Server Oracle application software, as well as developing any custom Java EE scripting and ORACLE Forms/Reports using the ORACLE Designer 2000/Developer 2000 & Discover 2000 case tools.
- Data Warehousing Engagement Director responsibilities included providing pre-sales support for potential DMR engagement opportunities.
- Application of expertise Project Management, Vendor Contract Management, Oracle 7 Database Management, CA Erwin Business/Rule & Data Modeling, BI OLAP Reporting using BRIO, Hyperion, and Business Objects Reporting Tools, Resource Management, Software Engineering.
Confidential
Credit Card Data Warehousing Project Manager
Responsibilities:
- Defined, developed and implemented appropriate and effective Decision Support and Data Strategies related to the deployment of Data Warehouse projects throughout The Associates Corporation.
- Responsible for determining and implementing the processes and team required to effectively facilitate change, build effective relationships with multiple business units, and market the Data Warehouse projects.
- Provided hands-on support to the point of teaching, reviewing and helping implement Data Warehouse processes (i.e., Corporate Enterprise Data, Data Access Paths, Data Extraction/Transformation, Data Modeling Logical and Physical, Data Mapping, Data Base Loads, Source to Target Data Reconciliation’s, Data Mining, etc.).
- Worked with developers to develop custom data sourcing software using the PRISM Warehouse Management Metadata Tool and Oracle Case Tools. Hands on experience using ERWIN, S-Designor and Oracle D/2000, to support development of Oracle DDL for target database structures. ORACLE Tools used (i.e., Forms/Reports using the ORACLE Designer 2000/Developer 2000 & Discover 2000 case tools. Custom development on UNIX Server using PL/SQL, SQL*NET, SQL*PLUS, SQL*DBA, SQL*LOADER, SQL*FORMS, SQL*REPORTWRITER).
- Application of expertise; Project Management, Vendor Contract Management, Data Base Management, Business/Rule Modeling, Data Base Modeling, Resource Management, and Software Engineering.
Confidential
Project Manager/Advisor Systems Engineer
Responsibilities:
- Managed, planned, staffed, coordinated and organized data conversion activities for transformation of data from legacy systems to client server OLTP, ODS and Data Warehouse systems environment.
- Supported Proof of Concept for GTE SAP (GL, AP, AR & HR) project, which required intense analysis Of GTE’s legacy systems/functions that would be replaced by utilizing the object-oriented ABAP/4 and distributed components using SAP’s Business Framework and Intranet Technology.
- Application of technical expertise; Mapping Source to Target Object Functions, Data Base Management, SAP R3-ABAP/4, Operating Systems Data Extraction, Business/Rule Modeling, Data Resource Management, QDB/Analyze, and Software Engineering. Additional responsibilities; provide advice and counsel to executive management concerning complex technical issues and to make recommendations as to the appropriate application of systems technologies.
- Additional responsibilities included initiating functional systems requirements for Confidential Legacy systems.
- Resolved system and functional issues for the CCC, CBC and Customer Contact Centers for both Production and Testing environments.
- Traveled about 50% of the time meeting in person with each State Regulatory Commission Staff members, where GTE provides Local Service, seeking approval to implement new Advanced Credit Management (ACM) programs.