SUMMARY:

• Total of thirty - four (34) years of Information Systems experience. I have worked in a number of capacities over the last twenty-four (24) years in data warehousing. I have primarily focused on the SAP Business Warehouse (BW) / BusinessObjects environment for the last twenty-two (22) years in both a functional and technical capacity as a BW / BO / BWA / HANA / Sybase IQ installer, trusted advisor and architect.
• In addition, I have worked with the Confidential Cognos BI Analytics solution as a developer, architect and migration consultant for a total of approximately 5 years, most recently with the 10.2 version.
• The years prior to SAP BI were spent in custom data warehouse design. In those years I conducted JAD/ user reporting sessions developing appropriate dashboard / reporting KPI's as well as developing and implementing the supporting technical designs.
• Over the years, customers have complimented me on my presentation and written skills in executive settings and end user workshops and on my technical skills in implementations.
• For the last several years, I have been primarily focused on testing, designing, installing, and deploying integrated leading edge BI analytics environments utilizing Native HANA, BW on HANA (BWoH), the Business Warehouse Accelerator (BWA) / Business Warehouse (BW) and BW BusinessObjects (BO) tools and Confidential Cognos.
• Recently I have added SAP Sybase IQ 16 Nearline Storage (NLS), BusinessObjects DataServices, MS SharePoint / SAP, MS SQL Server / SAP Integration methods and SAP PowerDesigner 1.6 to this list.
• Now moving into the SAP Data Intelligence product space ( Formerly SAP Data Hub)
• Knowledge and experience with in-memory, columnar-based applications such as HANA, BWA Sybase IQ 16, and the BusinessObjects toolset as well as in house large memory Dell rack-server test systems provide me with a hands-on background with ever-changing BI software architectural directions.
• These in-house systems enable me to advise clients more accurately on the actual feasibility / workability of proposed BI solutions.
• Currently the company maintains a number of Dell rack servers dedicated to support offsite customer research and development.
• The company also maintains a Cisco WebEx account for stable/ secure remote customer voice / video conferencing.
• The ability to provide my clients the unique capability of testing their potential BI landscape solutions in my offsite systems allows much faster and lower cost landscape modeling, development / POC design and testing of leading edge SAP BI solutions.

EXPERIENCE:

Confidential

Senior SAP Data Intelligence POC Architect

Responsibilities:

• Starting development work in partnership with IDI on a Composite Advanced Data Platform proof of concept integrating data governance / data routing /lineage/ HANA /tensor flow (ML) and predictive analytics focused on the utility industry.

Confidential

Senior SAP IQ 16.1 Nearline Storage Architect

Responsibilities:

• Confidential is implementing an SAP IQ 16 Nearline Storage (NLS) integration with BW on HANA 7.4 and native HANA 1.0 SPS12 as major component in a large global financial systems consolidation effort.
• Contracted for installation, design, testing and production cutover tasks necessary to implement this solution
• Current role is Confidential SAP IQ DBA.
• Working with the GBI global financial team on this project to integrate a total of 43 source systems in the final solution.
• Working closely with SAP Max Attention resources on these tasks.
• Project work has been extended to include updates to the SAP IQ 16 NLS Environment, NLS performance benchmarking and NLS performance tuning.

Confidential

Senior SAP HANA Architect

Responsibilities:

• The data model developed is primarily a virtual data model (VDM) utilizing HANA Smart Data Access (SDA) and HANA Graphical Calculation Views (GCV) to merge data from the two HANA systems, in real-time.
• Multiple tracks were explored using HANA GCV generation from both native, regional BWoH InfoProviders (Composite Providers and InfoObjects) and from Bex Queries against corporate, central InfoProviders (Composite Providers and InfoObjects).
• The data transmission occurred via HANA SDA.
• Currently this work is undergoing performance evaluations with a goal of utilizing the best performing options for production objectives for on premise and cloud based SAP HANA and BWoH.

Confidential

Senior SAP Consultant

Responsibilities:

• This DW pulls data from 6 ERP systems around the world including China, to replace a manually intensive MS Excel driven revenue reporting process with an automated reporting process.
• SAP DataServices 4.2 was the central software used to extract and merge SAP and Non-SAP data into a custom designed Data Warehouse Pilot project.
• The customer was provided a fully automated, daily scheduled system including SQL Script libraries for management and operations documentation.
• The source environments were a mix of SAP ERP running on various versions of Oracle and MS SQL Server with the target environment being Oracle 11G.

Confidential

Senior SAP Consultant

Responsibilities:

• Additional efforts focused on supporting and documenting for the BW staff and BASIS staff, a wide variety of critical production issues/ corrections.
• Subsequent to the BW efforts, was the implementation of a Cognos 10.2 BI production and test platform? This platform was a reestablishment of a complex financial system resulting from the acquisition of Equitable Gas Company (EGC) in a new 10.2 installation.
• The last two years have been a full-cycle effort to propose, model, procure, design and implement a forward-looking SAP BI leading edge architecture.
• This implementation, entitled the “PNG BI 2.0 New Technology Landscape”, is an integrated, in-memory centric, virtualized decision support system.
• With the exception of HANA, all servers are virtual in VMWare.
• Windows Remote Terminal services provide single points of maintenance for a centralized SAP BI Advanced Analytics Platform and a SAP BI Developers Platform.
• This allowed for a zero footprint / zero maintenance desktop client environment.
• HANA Dynamic Tiering was purchased/ researched and at last discussion, is planned for 2018-2019 implementation.
• The details of the last several years are listed below:
• Project Charter Development
• Coordinator/ Advisor for Hardware Vendor Negotiations
• Advisor for PNG’s SAP BI / BOE/ HANA licensing determination/ negotiations.
• Project Planning including
• New Environment Installation
• HANA DEV/QA MTC Environment
• BWoH Migration
• Sybase IQ 16 Nearline Storage (NLS)
• HANA HA/DR Planning / Implementation / Procedures and Testing
• PNG Software Installation / Configuration for:
• SAP HANA 1.0 SPS12 PL06
• BW on HANA (BWoH) 7.4 SP16
• Business Objects Enterprise (BOE) 4.2
• SAP Information Steward 4.2
• SAP Advanced Analytics - MS Office
• MS SharePoint IOMS integration 4.2
• MS SQL 2014 (for in-memory BOE CMS / IPS/ IS / DS Repositories)
• SAP Data Services 4.2
• SAP Lumira Desktop/Server 1.3.1 including (incl BIP Add-in)
• SAP Eclipse-based tools
• SAP Design Studio 1.6 (incl BIP Add-in)
• SAP Information Platform Services 4.2
• SAP NW 7.4 Gateway Sever / (Foundation for Fiori)
• SAP LT Replication Server /
• SAP Predictive Analytics 2.0
• SAP Mobile 3.0
• Sybase IQ 16 PL06 Nearline Storage (NLS)
• Development of complete offsite, running, PNG New Technology
• Landscape (NTL) mirror models containing the SAP BI components listed above.
• Performed HANA conversion to Multi-Tenant in multiple environments.
• Implemented / Architected HANA HA/DR
• Performed HANA DR Testing Activities
• Arranged / Oversaw conversion of HANA DR Server to complex dual purpose
• QA/DEV environment to better utilize expensive HANA Dell Hardware.
• Coauthor of SSO Automated Security Design for this complex landscape.
• SAP / HANA / BW / BOE / LUMIRA / MS SharePoint IOMS Environment.
• Implementation of Sybase IQ 16 Nearline Storage for test and production.
• Development of complete, highly detailed BWoH Migration Task List
• Performed Cleanup Pre and Post Migration Tasks for BW on HANA migrations
• Configuration of BW <-> Sybase IQ 16 NLS connectivity
• Worked with Senior PNG Management over many years as a trusted advisor for
• SAP BI direction / strategy
• BW 7.01
• Methodology Development
• Query Analysis
• InfoProvider Assessment (Design, indexing, etc.)
• Data Source Extraction Analysis
• System (BASIS / BW) Performance Assessment
• Cognos 10.2
• Migration, implementation and redeployment of PNG acquisition
• (Equitable Gas Company) complex financial system.
• Implemented Test and Production environment.
• Developed and Implemented batch scripting/ data loading /
• Automated Report Processing and Distribution

Production Cognos Administrator

Confidential, Charlotte, NC

Responsibilities:

• BI Architect and Technical Lead for StarKist BW Customer Service implementation.
• Responsibilities included IT Management advisement, BW implementation correction, redesign and completion.
• Complex query design and development. BW standards development.
• Designed and Implemented SAP BOE / SharePoint IOMS / BW Proof of Concept.

Confidential, Charlotte, NC

Senior SAP BW/ BusinessObjects Architect

Responsibilities:

• Senior resource tasked with evaluation of emerging Business Objects Architecture with a special emphasis on both SAP and Non-SAP data sources and Xcelsius as well as InfoView alternative delivery tools such as MS Office SharePoint.
• Full circle development of complex multilevel dashboards with multiple subject areas, graphical (State and City) Mapping, dynamic chart legends and alerts, multiple levels of menuing and drilldown, site designed windows management and Trend Analysis Forecasting.
• These dashboards were developed for the Financial Controlling area and the
• Developed data source schemes from Oracle and SAP BW. Implemented many extensions to the basic XC components
• Responsible for SQL development (Oracle) and BOE Universe design, QaaWS design etc.
• The overriding goal of this project was to go one-step beyond POC and create production level applications and a standardized documented production XC template.
• The project was also to help identify and forge the best BOE development processes for Confidential BCS in conjunction with Confidential European IT operations.
• Other tasks including discussion and feedback on BOE XI 4.0 feasibility and reasonable SAP/BO/ Confidential timelines for 4.0 implementation given the XI 3.1 tool capabilities and the projected needs of the business. Communicated and assisted in evaluation of third party Xcelsius add-on vendors such as Antivia (XWIS).

Confidential, Charlotte, NC

Senior SAP BW/ BusinessObjects Architect

Responsibilities:

• Senior resource tasked with the evaluation of initial Confidential ’s “Express” implementation of ECC/BW/SEM/TPM after the Go-Live.
• Principally assisted in correcting and completing an improper and incomplete BW7.x environment. This was performed despite a post go-live environment, which added additional constraints on the degree and speed of change.
• Reworked / reconfigured or reinstalled from tech BW side: COPA, FA / FR / G/L SD, Billing, Delivery, Inventory, with a number of customizations on goods receipt/ goods movement.
• After identification of numerous large gaps between the business reporting needs and the lack of best practices development, a significant effort was made to re-implement the BW system with enhanced BCT extractors, Custom Extractors.
• Standardized business rules in common objects such as Function Modules for special Fiscal Date processing and Specialized unit conversions.
• A framework was developed to automate auditing / balancing and alerting functionality with advanced central logging capabilities.
• Designed and implemented the production BW Process Chain architecture.
• Decommissioned or redesigned at least 75% of the MulitProviders as being unusable BCT or objects architected in ways which would not support either the near term BEx reporting or the planned BusinessObjects reporting.

Confidential

Senior SAP BW/ BWA / BusinessObjects Consultant

Responsibilities:

• Senior resource tasked with evaluation BusinessObjects gap analysis, participating in BAC proof of concept and BusinessObjects XI 3.1 SP2 installations (local and CITRIX) .
• Gap analysis performed against current production environment and scheduled release. Worked with SAP BusinessObjects personnel covering BusinessObjects 4.0 release functionality.
• Developed production examples of BusinessObjects solutions for difficult BAC query issues and volumes.
• Evaluated the impact of BWA on their current design with or without BusinessObjects, 7.x query development and technical documents

Confidential

Senior SAP BW / BWA Architect

Responsibilities:

• Senior BW resource tasked by Confidential to review implementation architecture, development standards and designs for planned very large scale (45TB) BW / BW Accelerator (BWA)/ Business Objects (BO) project.
• Performed advisement on BI Business Objects integration, SAP BW - BO release impacts, BO Universe design, production roll-out, BW / BWA production sizing. Assisted with offshore development reviews.
• Planned BWA post install configuration / evaluation tasks and further BW BWA BO performance testing.

Confidential, Raleigh, NC

Senior SAP Business Warehouse Consultant

Responsibilities:

• BW 3.2 to BW 7.0 Upgrade using Agile project methodology. Involved in the assessment of 7.0 feature inclusion in the upgraded landscape.
• Assisting with migration and redesign of 3.5 BW objects to 7.0 formats.
• Various prototyping efforts demonstrating BW 7.0 functionality. Provided input on BWA design and functionality.
• Minimal exposure to Business Objects Data Integrator.

Confidential

Senior SAP BW Architect

Responsibilities:

• Responsible for planning, project materials, technical pre and post upgrade tasks, ad-hoc delta training, and general coordination of the BI side of the upgrade.
• This upgrade included syncing with a parallel SCM 5.1 upgrade as well as a requirement for ongoing BI development during the upgrade cycle.
• Assisted in the Initial evaluation of Business Object Universe for performance with the BI Data Model. Prototype work with Visual Composer, BO Xcelsius and BO Crystal Reports

Confidential

Senior SAP BW Architect

Responsibilities:

• Senior SAP BI Resource for large retail implementation of BI 7.0 for Home Depot Canada.
• Full life cycle involvement including large volume proof of concept and implementation of Business Information Accelerator (BIA).
• Performed in a number or roles including BI architecture and standards development, BIA implementer including vendor coordination, data architect and data model review, developer of both backend and front-end deliverables, post go-live support, BI technical resource interviews and ad-hoc BI/BIA trainer / mentor.
• Developed custom Forecast and Replenishment (F&R) BI extraction solutions including design, development (backend and front-end) performance testing and production roll-out.
• Designed and implemented project process chain solution
• Designed custom Inventory and Retail Pricing / Cost solutions to address performance issues.

Confidential

Senior SAP Business Information Consultant

Responsibilities:

• Senior SAP BI resource for SAP Project Scope definition, Blueprinting for EC and PP manufacturing areas for NW2004S / BI 7.0 Implementation.
• Delivered front-to back solutions including customer objects, specialized BI survey programs, Adapted BCT and custom I InfoProvider (InfoCubes, MulitProviders, and DataStores) and extractors using new transform/DTP paradigms. Query and BEx Report development using new BI 7.0 Front-end components.
• Developed BI status survey process to provide extended BEx support for current status, complex date comparison rolling queries that provided a simplified query development process while eliminating data reloads. Primarily developed in Production Planning (PP) subject area.
• Assisted with installation and configuration and questions of brand new nw2004s BI landscape.
• Assisted with strategic decisions on landscape,
• Creation and testing of security/roles, STMS. Necessary new-system debugging.
• Performed necessary BI related configuration in R/3 OLTP systems.
• Assisted others with NW2004s knowledge transfer.

Confidential

SAP Business Information Warehouse Consultant

Responsibilities:

• Senior BW resource for data modeling and design of Customer / Product Profitability ( COPA and SD ) subject areas ( BW 3.5 )
• Senior BW resource for data modeling and design of Cost and Profitability Analysis ( COPA and Cost ) subject areas ( BW 3.2 and BW 3.5 )
• Senior BW resource for data modeling and design of Customer Performance KPI reporting ( Sales Order and Delivery subject areas ) ( BW 3.2 and BW 3.5 )
• Responsible for design and development of COPA data sources and data targets. Working with IP business users in transforming business requirements into production implementation.
• Responsible for development of SEM Balanced Scorecard and Management Cockpit feasibility prototype for customer performance measurement. ( SEM 3.5 and SEM 4.0 )
• Responsible for initial evaluation of SEM Business and Planning and Simulation for Internal IT Service Cost Allocation system. ( SEM 3.5 and SEM 4.0 )
• Additional task included education of staff and evaluation and presentation of BI delivery alternatives such as BW 3.5, Executive Cockpits, NW04 ( EP 6.0 etc.,)

Confidential

Senior SAP Business Information Warehouse Consultant

Responsibilities:

• Senior BW resource for reporting assessment/recommendation for multi-site SAP BW financial 3.1 /SEM 3.2 implementation.
• Responsible for evaluation of existing financial data models and financial reporting strategies.
• Responsible for providing on-site support for end-user query developers.
• Responsible for development, review and/or verification of SEM Balanced Scorecard (BSC) and Management Cockpit (MC) data extraction.

Confidential

SAP Business Information Warehouse Consultant

Responsibilities:

• BW architect for assessment, re-design and performance enhancements for existing SAP BW production environment.
• Primary focus was the assessment and re-design for migration to BW 3.0B.
• Developed project plans, BW 3.0B knowledge transfer, performed initial systems upgrades and performed testing for BW 3.0B.
• Performed extensive corporate SAP BW assessment and presented study results to management.
• Incorporated many of these enhancements in the existing production environment.
• Productive environment contained InfoCube with sizes ranging from 17 to 40 million rows primarily populated with financial and logistics data (COPA, SD).
• Also, developed customized performance enhancement and migration utilities and reports because of the assessment and upgrade activities.

Confidential

SAP Business Information Warehouse Consultant

Responsibilities:

• Lead BW Architect and sub-project manager (BW Area) for implementation of the SAP CRM/ SEM/ BW for SAP AG and SAP America. Operated internationally between Waldorf Germany, Hertogenbosch Netherlands and Newtown Square, PA in the US designing, and implementing integrated BW environment with CRM/ SEM and customized internal SAP sales and marketing R/3 OLTP systems.
• Project leader and architect for creation and standardized integration of rate scales involving large book manufacturer and multiple industry vendors.
• Responsible for overall integration design, development and implementation of BW/CRM/OLTP data architecture and enhancements, data modeling, extraction design and development of data cleansing applications in CRM and BW, reporting architecture design and development. Included development on entirely new methods for CRM BW survey extraction and management and BW CRM Target Group Creation. Developed customized non-financial measures auto-population for SEM. New development was turned over to SAP standard development.
• Involvement included all phases of the project lifecycle from initial prototype and proof of concept development and demonstration to requirements development to component design and development to production roll-out.
• Lead architect and project manager for BW / CRM Internet project at large media publication firm. Responsible for analysis and design of SAP BW/CRM environment integrating 3rd party CRM tools for e-mail campaign management. Developed entirely new approach for 3rd party tool integration to provide enhanced usability and performance.
• Managed team of three developers and provide appropriate project communications with the overall corporate structure
• Developed fast track BW implementation program for Syskoplan and performed fast track implementation at large life insurance company. Program provided for functioning financial implementation of BW in 6 weeks.
• Developed pre-sales prototype and orchestrated joint SAP/Syskoplan pre-sales call for large film manufacturer.
• Performed fast track configuration and functioning BW Business content prototype for large tool manufacturer in 10 days.
• Assisted in installation and configuration of Internal BW system and Confidential.
• Designed and developed BW meta-data extraction process in to provide foundation for CRM 3rd party tool integration. Operated in Birmingham, England, Gutersloh, Germany and Garden City, NY, USA. Worked with 3rd party tool management and developers to provide knowledge transfer on underlying BW schemas and RFC communication.
• Developed and installed prototype demonstration of this BW CRM 3rd party tool integration for presentation at 1999 Sapphire conference
• Additional duties included: development of collateral materials, knowledge transfer to other Syskoplan employees, presentations for pre-sales, internal Syskoplan functions and conferences such as the 2000 SAP BW Conference in San Francisco.
• Independently served as editor for SAP BW 2.0 book during this time period

Confidential

Data Warehouse Architect

Responsibilities:

• Responsible for the design of Shipment Datamart for Confidential.
• Developed and deployed Cognos Web Server models and reports Impromptu Web Query reports.
• Datamart developed in Sybase System 11.
• Modeling completed with PowerSoft 6.1 Power Designer data modeling tools.
• Developed and deployed Active Server Page meta data as well as ASP maintenance pages. Performed data warehouse tools analysis and recommendation functions.
• Participated in designed and development Time Entry MS Visual Basic application for large manufacturing client utilizing RDO and MS SQL Server 6.5. Wrote multiple stored procedures in Transact SQL.
• Designed and developed MS Visual Basic application for Duquesne Light to allow information extraction of batches Visio diagrams an as well as batch printing and HTML conversion functions. Developed utilizing OLE Automation.
• Responsible for the design of Financial and Inventory Datamart for Confidential.
• Developed and deployed Cognos PowerPlay models and reports. Developed and deployed Intranet financial reporting web site. Datamart developed in Sybase System 10. Modeling completed with PowerSoft 6.0 Data Warehouse Architect tools. Developed and deployed hypertext meta-data.
• Responsible for the design, architecture and implementation of a manufacturing Financial Data Warehouse and Operation Data Store (ODS). Utilized IDI’s data warehouse methodology to create the Data Warehouse environment. The data warehouse and ODS were created in Microsoft SQL/Server, and modeled using PowerSoft’s S-Designer.
• Performed VLDB analysis and design overview for bank Financial Data Warehouse.( Working as independent in collaboration with IDI. )

Confidential, Pittsburgh, PA

Principal CASE Consultant/Data Architect

Responsibilities:

• Responsible for the design and development of Financial Data Warehouse for Duquesne Light.
• Full life-cycle development including modeling, SQL/DDL development. Information gate program design and development and design of Data Warehouse monitoring facility.
• Responsible for development of data models in I-CASE for pilot PowerBuilder/ ORACLE 7 client/server application. Developed and implemented MVS-AIX, MVS-Windows conversion and interface architecture including PL/SQL development in ORACLE.
• Developed and implemented client/server security applications and data models for the pilot project. Modified commercial class libraries to support security functionality.
• Responsible for design and implementation in I-CASE of a object-based common services system architecture.
• Responsible for re-engineering and implementation of CICS time keeping system in I-CASE. Over 130 CICS programs developed for the common services and timekeeping projects.
• Developed and implemented complete workstation based development and testing environment utilizing Micro Focus CICS/COBOL/FileShare, DB2/2 and XDB.
• Developed OS/2 - MVS communication applications using REXX. Developed I-CASE encyclopedia management tools using REXX.
• Performed I-CASE training, I-CASE presentations, JAD's, developed I-CASE organization standards and enhanced re-engineering methodologies.