SUMMARY:

• Confidential is a SAP BPC & HANA Consultant with over 13 years of SAP experience. Specializing in Business Planning & Consolidation combined with his FICO in ECC6 environment, gives him a unique advantage for global implementations/integrations in SAP R/3. Confidential has had over 19 years of professional experience in Network and Systems Administration, analysis, design, coding, testing, documentation, and implementation of various commercial applications in a client/server Business environment.
• He is very capable in managing different technologies and integration aspects of SAP products.
• Confidential is a creative, result driven leader, a problem - solver skilled in grasping the big picture, conceptualizing, developing and implementing solutions.
• With four recently completed FLC SAP-BPC implementations (BPC10-NW, BPC10-MS, BPC10-upgrade, BPC7.5NW) together with his SAP - HANA1.0, BOBJ4.0 and SOLMAN experience projects Confidential capability of a “Technical/Functional/Basis” to a SAP Platinum Level Consultant.
• This combined with 25 years of professional Business & Communication Skills projects him into a unique lead position to handle any SAP Business challenge worldwide.
• SAP-BPC10 & 7.5, SAP-FICO, BW, Solution Manager; ERP-Financial accounting, BPC-Data Manager, Reports & Input Schedules, Script Logic, Business Process Flow, Journals, Dynamic & Static templates, Planning & Consolidation.
• SAP HANA, BPC on HANA, SP03 & SP05
• BOBJ Crystal Dashboard - Xcelsius Dashboard Presentation and Design.
• DMS-Document Management System; Document Structure, Hierarchy, splitting, numbering, storing, scanning & distributing electronic documents.
• Information Technology Background; IBM-servers, Networking, Hardware, Software, Programming, Data recovery, Security.
• Excellent Communication skills; A spirited result-oriented communicator, bi-lingual, team player.
• Extensive Organizational Skills; Sales teams, Designing, Marketing, Administration, Corporate structures, Laws and Regulations, Negotiations, Trading.

SPECIALTIES:

SAP BPC10, BPC7.5, EPM-Tools, FICO-ECC6, HANA1.0, BO4, 3.1, SAP - Certified Support Associate, SAP BPC Technical Consultant, SAP BPC Functional Consultant, SAP BPC Basis Consultant, SAP FICO Consultant, SAP HANA Consultant (SP03, SP05), SAP BOBJ Consultant

PROJECT EXPERIENCE:

Confidential

SAP BPC - Principal Consultant, SAP HANA - Principal Consultant

Responsibilities:

• Designed and produced BINI (BI Integration) power point presentation for corporate presentation (Luxembourg & London) detailing benefits of BPC10 versus the present BPC7.5Ms installation after making an in depth study of the BPC installation at Client Mines in CANADA.
• Key resource in explaining the benefits of using BPC - Consolidation module to be implemented at Headquarters in Luxembourg & London while maintaining Planning Module (Budget, Forecast, Planning) in Canada, Mexico, Brazil, Africa.
• Presented Timeline & Budget to “Steering Committee” and “Business” kicking off the project for the Canadian Mining Group
• Identified key players and designed “milestones” for project roadmap
• Produced a Business Blueprint complete with project timeline and estimated cost
• Got Business Owner to sign-off on BPML - (Business Blueprint Master List)
• Produced a “Step by Step Installation” guide for BI/BW/BPC team to follow
• Monitored and hand held AMS-basis team (Brazil) during installation on new landscape including the critical post-installation steps of a NEW BPC10 installation
• Stabilized the existing BPC7.5 environment, resolved all issues, Optimized all applications before exporting Master & Transactional Data to flat files for loading into the new BPC10 environment and models
• Validated and checked new BPC10 environment delivered by Basis team from Brazil
• Validated (..\CPMB & ..\POABC) directories for consistency and namespaces
• Validated SSO configuration - CMC, CMS, Netweaver security profiles, roles of users
• Configured Data Manager for new system (DM-Packages, updated links & configuration)
• Created environment and 5 new Models in accordance with BPML
• Configured Base Security in BPC - complete with TASK & ROLE Mapping document
• Created 21 new Confidential to be used throughout the 5 new Models in DEV, QAS, PRD
• Adjusted Script Logic and converted SSIS packages to PC (Process Chains)
• Created transformation and conversion files for Master Data upload into new system
• Validated and exported Master data from old BPC7.5Ms system to Flat Files
• Uploaded & populated Master data (Imported from Flat Files)
• Validated and exported Transactional Data from old BPC75Ms system to flat files
• Wrote transformation and conversion files for all 5 models and imported 2 years of historical + one year of current data into BPC10 new Models (175m records)
• Configured ‘Work Status’ for BPC10 environment
• Validated Security, 160 Users, DataAccessProfiles, Tasks&Roles from BPC-Sys Admin.
• Exported 200+ reports and input schedules to new system and converted old EVDRE reports to new EPM report format
• Resolved issues and modified reports to work under the new EPM reporting tool
• Conducted UAT, implemented cutover, Delta loads leading to Go Live and Support
• Re-created 7 new BPF’s (Business Process Flows) in accordance with Business needs
• Trained Business Super Users & IT on new system
• Documented BPC10 installation and updated Functional & Technical Manuals and procedures
• Configured CMS
• User Groups, Users, Row & Object Level Access
• Configured IDT & UDT tools
• Created new connections including secured connections to existing Universes
• Team created new universes using equi-joins in accordance with BB
• Resolved Loops (manually using Aliases & Contexts)
• Checked & Resolved Chasm Traps
• Built new Data Models
• Configured WEBI Reports
• Configured Crystal Reports
• Configured Xcelcius Connections
• Worked on Interactive Reports (BO4.0 added functionality)
• Jumping Reports, Linking & Hyperlinking reports, Open Doc reports
• Created Reports using two or more UNV using the Merge DIM concept
• Fixed broken dashboard connections
• Built 2 new Dashboards (Revenue, Critical Drivers for Mining)
• Configured Live Office & QAAWS
• Created several new Vertical & Cross Tab reports
• Add/Edit/Checked Predefined Filters for all Universes
• Re-created Complex Filters, Query Level Filters optimizing performance
• Designed Custom Sorts, Rankings
• Applied Conditional formatting and configured Drill-Downs & Drill-By for Alternate Hierarchies
• Configured Transports using CMS between DEV, QAS & PROD servers
• HANA on BW, BPC on HANA, BOBJ & Cloud Services integration
• Built POC using SAP test environment
• Leveraged existing SAP licensing to plan for HANA Platform Edition implementation
• Advised using existing BODS environment for HANA Replication rather than SAP SLT
• Worked on HANA Admin, configured security (Users+Roles), Transports(Delivery Units, CTS), Monitored system upgrades for SP3 to SP5, Backups & Restore and System Status
• Worked extensively on HANA Modeling Studio, Data Modeling,
• Data Provisioning using DS4.0 for Real-time Replication of structured and unstructured data
• Used parameter based rules to load initial Data, Mass Copy
• Created/Configured Attribute views, Analytic views, Calculation views, Analytic privileges, Ownership privileges, GRANT & REVOKE privileges, Global Authorizations, Decision Tables, Mapping tables, User defined Schemas, Packages and sub-packages, Auto Docs.
• Server(s) upgraded to BPC- SP09 (DEV, QAS & PROD) in record time
• 164 Client’s machines upgraded to SP09
• Re-configured & Optimized APPSET & All APPLICATION parameters
• Enabled SMTP parameters for BPC - emailing enhancement for “Work Status” & BPF’s
• BPC- Security - Re-alignment & Support
• Re-Designed BPC Security
• Created Teams, assigned Users to teams, Assigned Tasks to Roles
• Re-designed MemberAccessProfiles for all users, teams, roles
• Deleted 175 excess & redundant users from BPC saving the company 175k/yr in SAP-Licensing fees
• Setup new DM (data manager) package schedules for all 5 Applications
• De-activated redundant old DM packages from PROD,QAS & DEV servers increasing performance while reducing traffic on the SQL-server
• Designed new DM packages including ADMIN-OPTIMIZE, DEFAULT PACKAGES to run late at night - reducing traffic, increasing performance resulting in faster AppServer response for BPC-users during normal Business hours
• Responsible to update DIM members and properties and syncing data from ECC6 G/L Accounts to BPC-Account DIM on a daily basis
• Designed and created “ Confidential ” – A white pages step by step guide to be used throughout all divisions to process, Confidential & APPLICATIONS in accordance with SAP-Best Practice
• Responsible for 2 nd and 3 rd level Support for all issues reported by Users via ISSUE MANAGEMENT SOFWARE
• Responsible for bugs & fixes, Analysis, Evaluation & implementation of all BPC technical and functional issues
• Maintain & Support Services
• Created, Maintained, Ran & Monitored Packages via DATA SERVICES MANAGEMENT CONSOLE
• Managed BO REPO PROD and BO DS data on a daily basis coming from ECC6
• Analysis of failed packages
• Adjust and re-start packages
• Flat File Management throughout various SAP systems including BPC, BusinessObjects 3.1/4.0

Environment: BPC 7.5 NW Version - Planning & Consolidation

Confidential, Houston, TX

SAP BPC – Principal Consultant

Responsibilities:

• Setup the environment. New VM’s
• Configure Base Level Security for BPC
• Downloaded and installed ALL Pre-Requisites
• Downloaded and installed BPC 10.0 Application, ABAP & DB Server(s)
• Configured Servers
• Validated Post Server steps (..\POABC, ..\CPMB & ..\1CPMB spaces)
• Configured new users in NW 7.3 for SSO
• Backed up current old-Appset in NW7.5
• Used SAP provided upgrade tool to migrate NW7.5 installation to NW10
• Current & Historical records imported into BPC10-NW
• Validated records & Cubes in BW-backend (..\CPMB space)
• Standard templates moved successfully in the new EPM tool
• Team converted 25 Reports and 8 Input Schedules using EPM –report migration in record time

Environment: BPC 7.5 MS Version - Planning & Consolidation

Confidential, Kingwood, TX

SAP BPC – Principal Consultant

Responsibilities:

• Performed a detail study of SAP-BPC implementation in record time.
• Identified “Problem Statements” in the Material Management (MM) and Customers (SD) Business Areas.
• Complex Reports and Input Schedules (Some with 8-14 dependent worksheets), each designed with 3-5 embedded EVDRE-functions were found in some of these problem workbooks. This deadly combination of (embedded multiple EVDRE’s combined with complex excel calculations) in each workbook - calls between 35-50 EVDRE functions in addition to making 100+ calculations to update or even refresh the data from the server.
• Lack of optimizing on a regular basis is causing an excessive amount of temporary records that are residing in the “tmpFAC2”, “tmpWB”, “tmpFACT” tables. These records are marked for deletion but are still residing in the back end databases resulting in large indexes impacting performance and sometimes data loss due to an index not found error.
• The scope of this study was to determine the root of the problem, recommendations and enhancement to the BPC environment.
• Recommendations were presented to the COO, CFO, CIO, Finance, MM, SD & IT Depts.
• Scope of work included checking ALL Confidential (Acccount.DIM alone had 2600+ line items with a 2-3 tier BPC Hierarchy), Configurations, time testing of reports and Input Schedules. BPC Hierarchies were checked for consistencies. Test reports were made to check the values in “Hard Coded” reports versus dynamic CV reports for accuracy. Documentation and Training manuals were made and delivered.
• ASAP methodology was followed to bring BPC implementation back into compliance with SAP rules.
• Re-Designed and configured complex reports from MM/SD departments.
• Configured and installed four Business Process Flows (BPF’s) to streamline work flow from MM / SD / Finance which enabled user confidence and acceptance to BPC.
• Security was configured in BPC-Admin. Added Teams and member access to BPF’s.
• Configured Member Access Profile’s in BPC Security.
• BPC enhancements were implemented such as “Park N Go” for Finance /MM/ SD depts.
• Users were trained on BPC features of Trending, Weighting and Spreading - increasing efficiency of the Forecast & Budgeting process throughout all departments.

Environment: BPC 7.5 NW Version - Planning & Consolidation

Confidential, Charlotte, NC

SAP BPC – Practice Manager & Principal Consultant

Responsibilities:

• Conducted PP- Project Preparation with Super Users, PM, CFO, IT & Finance team of 10+ members of the Steering Committee which identified a high level ‘Business Processes', 9-Pain points discussion with problems in HR templates, Data overflow & inaccuracy issues, Templates & Scripts Logic problems, Data flow, DM packages issues, Wishes and Wants for the Nuclear Energy Division.
• BB - Business Blueprinting : Reviewed and organized 35+charts, Reference & Admin Manuals.
• Realization : Checked DIM's, (ACCOUNT, COMP CODE, COST CENTER, EMPLOYEE) Hierarchy, Script Logic. Found several problems in Script Logic that was pointing to Separate Divisions. Validating Accounts Balances, found Script Logic was posting to TSG Accounts instead of NE. Templates were Hard Coded for HR-Div. but found in BUDGET App. Intermingling of data was found with severe repercussions to both divisions.
• Followed Data Flow from HR to BUDGET Applications (root cause of Data Absorption)
• Did Risk Analysis for ALL Divisions.
• Presented 'Scenario Based Solution' to 'Steering Committee' and got and Signoff to implement Solution.
• IT requested to check TSG and other Divisions for similar problems expanding the scope of Business.
• Wrote 10 new script logic files separating the two divisions.
• Uploaded to Q&A server the newly designed logic files in Appsets, K1 & K2 for User Testing.
• Ran 40+ Data Manager packages with various scenarios, validating the results from the newly tweaked scripts logic files.
• Final Preparation : Conducted webinar and training with 'NE Super Users' for testing scenario setup in Appsets 'GB GIP KF1' and 'GB GIP KF2' for UAT.
• Designed and implemented a BPF for "Unit Managers" to conduct an “ End to End ” Budget Process.
• Go Live & Support : Recruited a “Platinum Level” consultant to Handle CLIENT “Consolidations” which was moved from Houston to Charlotte in 02/12. – Ongoing.
• Conducted Phase 2 of the plan in which most of the 9 pt. issues relating to templates were fixed – Ongoing .
• Resulting in an extension of the “ Consolidations ” service contract while increasing the scope of Budget & Planning to the end of 2012.

Environment: BPC 10 MS Version - Planning & Consolidation

Confidential, Atlanta, GA

SAP BPC – Practice Manager & Principal Consultant

Responsibilities:

• Entailed a complete new installation of BPC- 10 Microsoft version on a SQL-Server.
• Technical & Basis work to install BPC-10 on a new VM.
• Downloaded and read Master Guide, Installation Guide, relevant SAP Notes(60),
• Setup the environment. New VM’s, Security, Users, Groups & Access.
• Downloaded and installed ALL Pre-Requisites (.NET, WEB IIS, Scripten,VBrun, etc)
• Configured .NET4.0, WEB IIS, AntiXssLibrary v4.2, SSO, CMS, MSDA.2010.SP01
• Downloaded and installed SAP BusinessObjects Planning and Consolidation 10.0 Application Server
• Downloaded and installed MS SQL-Server
• Configured AD (Microsoft Active Directory) on Windows Server 2008 R2 to enable SSO (Single Signon) feature of BPC10
• Configured Base names & pw required by BPC 10, security, profiles.
• Configured Base level Security in BPC-Admin. Member Access Profile’s – Added Teams users access
• Added new Environment SET using EnvironmentShell
• Added (4) new Models (Budget, Consolidation, Ownership, Finance)
• Configured DIM’s, for Planning, Forecast, Budgeting & Consolidation (Managerial & Legal).
• Built Hierarchies for data rollups & calculations for reporting purposes.
• Performed post installation procedures
• Installed EPM Add-on for Admin & Excel Client together with complete prereqs for Office 10 (vcredist x86, C++2010x86, MS WSE 3.0)
• Loaded 6.8 million records via DM into the Planning & Consolidation Applications.
• Configured templates and input schedules to demo the Planning & Consolidation process in BPC-10
• Installed Xcelcius / Dashboard connectivity to BPC10
• Download and install SAP BusinessObjects Extended Analytics
• Download and install SAP BusinessObjects EPM Connector 10
• Install SAP BusinessObjects Planning and Consolidation ODBO Client
• Install SAP BPCDataGrid component
• BPC Backend Configuration for see BPC10 data in Xcelcius

Environment: BPC 7.5 NW Version - Planning & Consolidation

Confidential, Atlanta, GA

SAP BPC – Practice Manager & Principal Consultant

Responsibilities:

• Entailed a complete new installation of BPC- Netweaver 7.5 on the BI/BW backbone.
• Technical & Basis work to install BPC-NW7.5 on a new VM(..169).
• Downloaded and read Master Guide, Installation Guide, relevant SAP Notes(100),
• Setup the environment. New VM’s, Security, Users, Groups & Access.
• Design & Build Backend Architecture. Configure ABAP, IIS, .NET2.0 on Windows 2008 R2 Server.
• Downloaded and installed ALL Pre-Requisites (.NET, WEB IIS, Scripten, MSMQ, VBrun, AntiXssLibrary, MSXML, etc)
• Configured server .NET2.0, WEB IIS, MSMQ, MSXML, VB6.0, AntiXssLibraryV1.5, Xceedzip6.5
• Configured the Application Server
• Configured the ABAP server. Created /CPMB namespace, Security, Profiles.
• Checked the Java Stack for communication.
• Installed SAP BusinessObjects Planning and Consolidation 7.5 Server
• Installed and configured BPC-CLIENT (Admin & Excel) x64 with prereqs on BPC-Server
• Installed and configured BPC-CLIENT (Admin & Excel) x86 with prereqs for all Client machines
• Downloaded and installed SAP GUI 7.20
• Install SAP BusinessObjects Planning and Consolidation 7.5 Client
• Configured Base level Security in BPC-Admin. Member Access Profile’s – Added Teams users access
• Added (5) new Applications and BPC-Architecture for use in Demo’s for various industry flavors like Education, Retail, Manufacturing & Finance.
• Configured DIM’s, for Planning, Forecast, Budgeting & Consolidation (Managerial & Legal).
• Built Hierarchies for data rollups & calculations for reporting purposes.
• Configure BPC-ADMIN
• Configure DM (Data Manager)
• Configure Business Rules
• Configure Default Script Logic
• Configure Mapping Rules
• Configure Transformation Files
• Populate DIM(s)
• Validate Master Data
• Research Guides for Xcelcius Connectivity
• Download and install SAP BusinessObjects Extended Analytics 7.5 SP05
• Download and install SAP BusinessObjects EPM Connector 7.5
• Install SAP BusinessObjects Planning and Consolidation 7.5 ODBO Client
• Install SAP BPCDataGrid component
• BPC Backend Configuration
• Dashboard Data Connection and Development for BPC data

Environment: BPC 10 MS- version and BPC 7.5 NW version - Planning & Consolidation

Confidential, Atlanta, GA

SAP BPC – Practice Manager & Principal Consultant

Responsibilities:

• Built a complete BPC practice from ground zero.
• Negotiated and closed several BPC contracts.
• Interviewed, Hired & Trained BPC consultants.
• Organized and Conducted Meetings, Webinars and Lectures.
• Trained internal BPC teams.

Environment: BPC 7.5 MS Version - Planning & Consolidation

Confidential, Boston, MA

SAP BPC – Principal Consultant

Responsibilities:

• Planned for a SAP-BPC implementation scope covering Sales planning for Business operations covering 14000 shoe stores of a retail store chain throughout USA, Canada.
• Worked on BPC Admin and BPC Web.
• Created a NEW AppSet using BPC-Apshell
• Created a Sales Application
• Created a Financial Application
• Created a Rate Application
• Created 3 Applications CB-Forecasting, CB-PLZ(Planning), CBD based on Clients data model.
• Created & maintained between 20-24 Confidential for each of the above Applications
• Created several versions of the Product DIM, Division DIM, Channels DIM specific for Collective Brands Business Model
• Collected historical sales & controlling data provided by Client in multiple excel sheets to import data into the BPC-cubes using at first Data Manager, in the end opting to use custom designed INPUT SCHEDULES.
• Designed and configured the data structure in the BPC Applications.
• Added, maintained, redesigned and tweaked Confidential so as to achieve “Currency Conversion” using Business Rules.
• Linked various processes using BPF’s - Business Process Flows.
• Configured “Work Status” features of BPC for all applications
• Added the “Reviewer” and “Owner” fields to required DIM’s for Work Status to operate.
• Developed Reports for PLAN and FORECAST for both their Inventory control Business Area (The S-11 Reports) and the Corporate Control Area – (The SRCG- reports).
• Created variance and comparison reports in the server.
• Created Dynamic Reports showing ACTUAL / PLAN blocks run by multiple EVDRE’s within the same report.
• Developed Reports with graphs and drill down capability.
• Designed and implemented 67 Input Schedules and 50 reports in 10 weeks.
• Published a dozen or so “Ad-Hoc” reports to the server and connected them to BPF’s showing extra functionality of BPC to the Client.
• Developed custom BPF’s – Business Process Flows one for the “S-11” Inventory Planning and Forecast and separate one for the “SRCG” controlling departments complete with work status involving a managers authorization to Accept, Reject the work performed.
• The CB PLZ Application had an added feature of “Currency Conversion” which was configured using Business Rules and converted the data from LC (Local Currency – also the Reporting currency, to EUR & USD).
• Used Data Manager to import files including Currency Conversion master rate data and maintained rates in the Rate DIM.
• Data Manager was also used to copy Master & Transactional Data from year to year for comparison purposes.
• DIM Locks were used to control and simplify user activity in ALL reports.
• Reports and Custom Input schedules were tested, optimized for each of the three custom Applications.
• Finally a new clean application CBD was designed keeping in mind the Entity & Account DIM members for consolidation purposes (down the road) resulting in a more effective business structure which was represented in the Product, Channel, Division DIM of CBD-App.

Environment: BPC 7.5 NW version - Consolidation Project

Confidential, Long Island - Islip, NY

SAP BPC Consultant

Responsibilities:

• Debug why US-Eliminations were not working in the present system for the past 10 months.
• Debugged system within 10 days and reported a 23 page report covering the primary reasons eliminations were not working.
• Checked the TIME, ENTITY, ACCOUNT Confidential for consistency
• Scoped and defined problems with Script Logic and various problems facing the NW7.0 installation.
• Suggested an upgrade to NW7.5 to the steering committee.
• Re-designed and rebuilt from scratch; A NEW-BPC Application for consolidation upon the guidance of the steering committee in 3 weeks flat.
• Re-Configured ENTITY, ACCOUNT, TIME, INTCO DIM for the new Application.
• Checked and reconfigured “Balance Carry Forward” for in-coming data.
• Configured new DIM members, Business Rules, Script Logic for Consolidation project for Confidential in record time.
• Resolved issues successfully and completed my project scope ahead of schedule.

Environment: BPC 5.1 / BPC 7.0 ramp-up - Planning & Consolidation