We provide IT Staff Augmentation Services!

Director Enterprise Business Intelligence Resume

0/5 (Submit Your Rating)

SUMMARY:

  • To be part of world class Analytic organization, which is team oriented and driven by business/technology execution/delivery of analytic solutions success (e.g. business expectations met, solutions on - time and on-budget, etc.)
  • 30+ Years Information Technology Experience
  • 15 Years Software Architecture and Systems Engineering Experience
  • 20 Years Management Information Systems, OLAP Analytic, Data Warehousing/Business Intelligence experience and has participated in more 45+ data warehousing/business intelligence analytic project implementations.
  • Prior Vice President of Data Warehousing Programs, Data Integration and is currently the President, of the DFW DAMA organization.
  • 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 SKILLS:

HARDWARE: Intel PC's /Win 95/NT XP/2007, SUN/Solaris Servers, HP/UX Servers NCRTeradata, DELL ProLiant Servers, IBM/AIX Servers, IBM AS/400 Servers IBM - MVS Mainframe, Amdox Mainframe

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 Software, IBM Ascential ETL Software, Informitaca ETL Software, Abinitio ETL Software SAS STAT Analytical Tools, Enterprise BRIO Holos, MVS File Aid CA7/CA-Unicenter AutoSys, WebMethods, WebLogic EAI SOA Software FTP - TCP/IP/WSFTP Syncsort Software Microsoft Project Microsoft Office Pro, Platinum Repository, Microsoft Exchange Server, VISIO Professional / Microsoft Publisher, Microsoft Access DB, LOTUS Notes, COGNOS Impromptu/PowerPlay, Business Objects (BO), Microstrategy Software, ORACLE Express ORACLE Discover ORACLE Designer 2000, ORACLE Developer, ORACLE ERP Smart Client, IQ Objects, Microsoft SQL Server 2005, 2008 R2, Microsoft 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/DC, Microsoft 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

PROFESSIONAL EXPERIENCE:

Confidential

Director Enterprise Business Intelligence

Responsibilities:

  • Responsible for technical architecture frameworks of the ( Confidential Enterprise Data Warehouse/Business Intelligence) Product Solution. Ownership for defining Enterprise Level Technical Architecture blueprints (i.e., Data Architecture, ETL & BI OLAP APP Architectures, and Technical Infrastructure Architecture). Worked with Product Management, Client Delivery, and IT Operations Teams to gather and document business requirements, technical requirements and critical success criteria DW/BI Product system releases. Utilized (CA Erwin r8 - Data Modeling Tool) to develop the (DW BI) Data Model.
  • Assisted ETL Team to perform (data profiling) analysis against OLTP (GE FlowCast & GroupCast - PMS Systems) data feeds to the (DW BI) database. Assisted ETL Team with Source-to-Target (SST - Source to DW ETL Data Mapping) MS SQL Server 2008 R2 (SSIS ETL) design deliverables. Assisted BI Team with (SST - DW to BI Report Data Mapping) Cognos 10. BI Reporting design deliverables. Assisted QA Team in defining the (ETL & BI Application) QA Test Plans. Leveraged company specific “ Corporate Assets”, to support key analytic information needs from corporate IT Systems (PMS-GroupCast, PMS-FlowCast, Msight, PMS-Athena, GL-Great Plains, etc.). Supported Proof of Concept (POC) for Big Data solutions, leveraging Hadoop, Distributed File System (HDFS) and MapReduce - JUMBUNE, for unstructured Data integration with MSI traditional Data Warehouse StarSchema database.

Confidential

Lead Database Marketing Architect

Responsibilities:

  • Responsible for defining an implementation of Enterprise (Database Marketing) solutions, which provided SAP Business Objects (BO) Reporting Analytic, 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. Also responsible for establishing business driven Data Governance programs to ensure data is audited for accuracy and timeliness, which ensures that client business units have and maintain a “single-version-of-the-truth” to support mission critical information needs.
  • Responsibilities include providing high-level architecture solution blue-prints, which enable utilization of Client specific “ Corporate Assets”, by extracting key analytic information from corporate assets - such as Client ERP, CRM and SOA systems for building out new “ Event Driven - SOA”. Leveraged BIG Data and Stat Modeling Tool - SAS and Tibco Spotfire. Researched Hadoop Big Data Tools - for possible integration of Web Click Stream analytics and Social media “Un-structured” data streams. Company elected to leverage the Tibco Spotfire solution.

Confidential

Principal Architect

Responsibilities:

  • Responsible for defining an implementation of Enterprise Analytic (Data Management/Data Integration) solutions, to provide an enterprise service bus and analytic reporting information, which drive client (customer/product loyalty & revenue enhancement) decision management programs. Also responsible for establishing business driven
  • Data Governance programs to ensure data is audited for accuracy and timeliness, which ensures that client business units have and maintain a “single-version-of-the-truth” to support mission critical event driven SOA transaction processing and analytic reporting needs. Provided high-level architecture solution blue-prints, which enable utilization of Client specific “ Corporate Assets”, by extracting key analytic information from corporate assets - such as DMBS ORACLE, Informix, Sybase, MS SQL Server, ORACLE Hyperion Essbase, SAP ERP, ORACLE ERP, JD Edwards ERP, Siebel CRM, PeopleSoft Enterprise Project Management (EPM), HR, POS, and SOA 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 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. |

Confidential

Director Information Resource Management (IRM)

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), Enterprise Data Integration and Business Intelligence/Data Warehousing programs within Confidential (VIS). Assist Verizon 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. Ownership for all Business Intelligence/Data Warehousing programs within JPMorganChase. Assisted JPMorganChase Product Sales Team in 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.

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. Consulting engagement with South West Airlines - supporting Y2K, Enterprise Data Integration Management leveraging Oracle and BI OLAP Cognos Impromptu & PowerPlay Reporting Soutions.

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.
  • Responsible for end-to-end development processes for manufacturing SAP's ASAP BW methodology CD. 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 DBMS 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 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, Data Base Management, Business/Rule Modeling, Data Base Modeling, Resource Management, and 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:

  • Project Manager for the GTE Re-Engineering & Data Warehousing conversion projects.
  • 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 advise 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 GTE Data Services 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.

Confidential

Project Leader Systems Engineer/System Analyst

Responsibilities:

  • Responsibilities included determining impact of proposed enhancements to CBSS Billing System architecture during the High Level Design and Detail Level Design requirements phases. Acted as a project resource to guide, instruct and monitor team members in Coding, Testing and Implementation tasks. Instructed team in coding techniques, technical/user procedures and estimating tasks, per GTED’s Project standards. Assumed supervisor responsibilities whenever necessary. Focal point for all MIS decision support issues relating to GTE Billing data. Member of core team responsible for OLTP, ODS, Data Warehouse implementation and Decision Support Data issue resolution.

Confidential

Programmer/Programmer Analyst

Responsibilities:

  • Determined impact of proposed enhancements to the CABS and/or CBSS Billing System. Provided production support for "Problem/Incident" Coordinator for the Bill Calc, Pricing, Format and BOCB groups. Designed/developed system software specifications, Coding, Testing, Debugging of system software and the formal inspection of assigned Data Processing Service Request (DPSR’s) modules, as well as to assist in the creation of the RVL release PMW Work Plan. Assumed project leader responsibilities when ever necessary.

Confidential

Technical Writer/Technical Publication Project Leader

Responsibilities:

  • Provided assistance and to coworkers in the origination of documentation, desk top publishing procedures and the interpretation of COBOL II and ADR/IDEAL programs, Dump Analysis, JCL syntax and TSO/ISPF mainframe command options. Planned, organized, edited, and published the Confidential and User documentation Project. Provided assistance and to coworkers in the origination of documentation and desk top publishing procedures. Generated on-demand ADR/IDEAL Data Queries, which produced cross- listing of data elements within the

Confidential

Accounts Payable Accountant/Purchasing Agent

Responsibilities:

  • Researched and resolved accounting, purchasing purchase-order procurement-match rejection errors.
  • Contacted vendors to expedite shipment of open purchase orders. Generated on-demand ADR/IDEAL Data Queries to report inventory levels, identify potential shortages, report pricing and warehouse-receiving errors, as well as to insure the accuracy of payment for invoices processed through accounts payable. Acted as a mediator between purchasing, accounting and information management departments.

Confidential

Branch Operations Officer/Head Teller/Systems Security Administrator

Responsibilities:

  • General accounting functions, administrating in-house system security access to users, Air Force base security officers, tellers and new account reps. Secured all vaults and alarms with Air Force Base Security administration. Bonded for 2,000,000.00 with a personal cash limit of over 750,000.00 per day. Directly Supervised 6 employees. Excellent balancing record.

We'd love your feedback!