SUMMARY

• Confidential is a SAP FICO / BPC / HANA Consultant with over 12 years of SAP experience. Specializing in Business Planning & Consolidation combined with his knowledge of an ECC environment, gives him a unique advantage for global implementations/integrations in SAP R/3.
• Confidential has had over 20 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 versatile 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 two recently completed full BPC implementations (1. SAP BusinessObjects Planning & Consolidation-BPC-10MS - 2. SAP BusinessObjects Planning & Consolidation NW7.5) together with his work in progress on SAP - HANA engine gives Confidential an all rounded capability of a “Technical/Functional/BPC-Basis” 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

TECHNICAL SKILLS

• SAP - BPC10 Microsoft Version Full Implementation (Basis/Technical & Functional)
• SAP - BPC 7.5 Net Weaver Ver. Full Implementation (Basis/Technical & Functional)
• BPC- Business Process Flows
• Data Modeling, Security, ADMIN, Reporting & Analysis
• SAP - BPC 7.0 / 7.5 NW-Version
• Business Planning & Consolidations
• (BPC- Architect, Technical & Functional Consultant)
• SAP - BPC 7.0 / 7.5 MS Ver.
• Business Planning & Consolidations (BPC- Architect, Technical & Functional Consultant)
• SAP - BW - Data Warehousing, ETL, DTP - Extractions –Transformations
• SAP–BPC 5.1 MS - OutlookSoft
• Business Planning & Consolidations Functional Consultant
• SAP - ERP Financial Accounting ECC- 6.0
• FI,AR,AP,GL,AA,TM,CO
• SAP – FICO (ECC 6.0) Financial Accounting with New G/L. Group COA, Segment Reporting
• SAP – Solution Manager 4.0
• DMS – Document Management System – ECC 6 – (Add-on)
• SAP – SBOP Certified Consultant
• Microsoft Windows Server 2008 – R2
• Microsoft AD (Active Directory Services, IIS, .NET 2.0 4.0
• Database Management, Design, Data Recovery, Security, Admin.
• Microsoft SQl – Server 2010, MySQL services
• MS - Visual Foxpro, Foxpro2, FoxBase+, dBase III/IV
• Microsoft Access, MS-OfficeOracle
• Corel Presentations
• Microsoft Publisher
• Microsoft Word
• Microsoft Excel
• Microsoft PowerPoint
• Adobe Acrobat
• Xcelsius - Dashboards
• Crystal Reports
• Adobe Photoshop
• Adobe Pagemaker
• Intuit Quickbooks / Quicken
• Unix / PC-Mos 5.01
• Multi User CPM/MPM
• OS/400
• Linux Red Hat 9
• Windows(3.1-2000, XP, NT, 7)
• Novel Netware
• Windows Server 2000,2003,2008 R2
• Microsoft SQL Server 2000, 2003
• Basic, C, C++, Pascal, VisualBasic
• MS Windows 2000
• MS Windows 2003
• MS Windows NT
• VPN
• Ethernet
• .NET 2.0 - 4.0
• Harvard Graphics
• FrontPage
• Adobe - Distiller
• Adobe - Photoshop
• PDFSam
• WordPerfect (5,6,7,9)
• Lotus
• Macromedia Fireworks
• WordStar (2)
• Accuzip 6
• Postal Soft
• SBT - Accounting

PROFESSIONAL EXPERIENCE

Confidential, Texas

SAP BPC – Solution Architect & Prime Consultant

Responsibilities:

• Worked on Timeline and project costing for Financial Consolidation
• Adjusted BPC Landscape to include QA/PRD systems
• Upgraded Sandbox + DEV system to BPC SP13
• Completed BPC BusinessBlueprint – Requirement gathering
• Configured New Environment + Model for BPC Consolidations
• Configured DIMs for Master Data Loads
• Built Parent Child Hierarchies in the ACCOUNT, ENTITY, INTERCO, SCOPES, AUDITTRAIL Dimensions
• Built out CATEGORY, FLOW & TIME dimensions
• Wrote Multicurrency conversion FX-script logic
• Configured DataManager, Appset/Model parameters
• Configured connections using the EPM –Add-in for Excel, Word, MS-powerpoint
• Laid down the architecture to pull GL data from SAP-ECC, Lawson, CMIS and other legacy systems
• Wrote Transformation and conversion files to import data into BPC using .CSV files
• Completed 1536 line items in the ACCOUNT dimension attaining Balance Sheet & monthly P&L for all 56 entities
• Configured INTERCO (inter company trading partners) – IC-eliminations
• Configured Balance Carry Forward Business Rules
• Configured O ACCOUNT – (PCTRL, POWN, CMETHOD) for BPC Consolidations
• Configured Ownership & Rate Applications/Models in BPC10MS
• Configured Ownership Manager to populate 15 Groups for full Legal Consolidation
• Designed Scope Dimension to handle Group Currency Conversion & Consolidation of Investments
• Configured Business Rules to run Group Currency Conversion
• Configured Business Rules for i) Consolidation of Investments, ii) Eliminations Consolidating all 56 Entities in 15 Groups
• Designed EPM reports for Balance Sheet & P&L
• Designed EPM Ad-Hoc reports showing details for eliminated Accounts
• Designed validation reports showing Assets = Liabilities before group consolidations are run on each group
• Designed Input Schedules in EPM for Data Entry of Legacy based systems
• ETL data loads and validated data loads from SAP, CMIS & Lawson systems
• Wrote BPP’s for User (SU) training and documentation
• Project was completed and is now on “Go Live & Support” mode - Remote

Confidential, Atlanta, GA

SAP BI - BPC –Functional, Technical & Support Consultant

Responsibilities:

• Supporting CCR Div. going live with integrated BPC7.5
• Automating Data Loads via BW process chains
• Writing Transformations, Conversions tables to import large data volumes (1 Billion records / month) into BPC for Financial reporting, Planning & Budgeting & Consolidation
• Responsible for data cleaning and Validation of Data from FIM tables to BPC Master Data tables
• Extensive Data Manager package link automation
• Checked 100+ scripts used to automate loads with calling multiple BADI’s
• DM package development & testing
• Managed Tivoli processes via BODS to maintain Data Flow
• Worked with KO-Team to test BPC functionality before “Go Live”
• Participated with Deloitte/Infosys teams to “Stress Test” critical reports
• Used “Fiddler” to test Network timings, Server Execution & BPC critical reports for refresh times
• Used VB-scripting to fine tune “Large Reports” which were taking 5-7 minutes to refresh/load down to 2 minutes resulting in a new template design which was installed throughout the CCR division
• Maintained .NET servers for BPC front end access on QA/DEV systems
• Trained Basis personnel on sequence/order for re-starting .NET servers
• Involved in setting up connection to HANA via the .NET tier
• Primary resource to test HANA functionality installed at CCR
• Assigned new .NET tier (2 .NET servers) to run HANA (POC) Box for BW/BPC PAK installed for the CCR division with HANA backend
• Created new connections to HANA Box to access BPC data on HANA database
• Ran & tested BPC critical functions (Admin, Excel), DM packages, DM links, Data Loads, Scripts/BADI’s on the HANA box
• Scenario testing of the HANA system
• BPC on HANA was tested using the same reports designed by the Deloitte/Infosys teams as above
• BPC on HANA performance was an impressive 30-45 secs for reports that were being run on the traditional BPC7.5NW system and took 3-8 minutes to load/refresh
• The HANA system was then loaded with the 85m records and re-tested
• Fiddler reports showed that HANA–db took only 3-4 secs to do all the calculations and the rest of the time was being taken up by Network bottlenecks which resulted from the .NET servers & Excel interactions.
• When the same reports were run directly from HANA-Modeler it confirmed the bottleneck created from the .NET tier
• Client was advised to use the new Flex based access via the WEB for accessing the HANA BPC data
• The HANA records were then replicated into a BPC10.1 (POC)
• SLT was used to replicate the BW tables into the new HANA (POC) Box
• Configured Security, Roles & Tasks prompts
• Configured Decision Tables for validation and Data Lookup
• Made connections to BW IP – integrated planning for direct use in HANA front end
• Configured front end tools for HANA
• Integrate BW/IP PAK and BPC NW on HANA
• Configured BPC 10.1 on HANA EPM Add-in
• Migrated existing reports to HANA POC
• Optimized databases in HANA (Flattened Hierarchies)
• Configured Transports
• Monitored EWA (Early Watch Reports) for Performance on a weekly basis
• Resolved 4 critical issues (Red) on a 53 page EWA report to avert system crashes
• Re-built 23 missing indexes on BW \CPMB space to improve performance stats
• BW Table-Spaces were running at critical. Incorporated changes to increase table-spaces
• Recommended installing LRID’s for system stability
• Installed BPC Audit to monitor BPC stats during critical EOM large data loads (1-Billion Recs /month)
• Resolved all critical warning from the EWA system to attain system stability for the CCR-division in record time (10 days)

Confidential, Kansas City, KS

SAP BPC –Technical & Support Consultant

Responsibilities:

• HCM / HR-Cube re-load
• Responsible for HCM Cube Data Loads, Transformations, Conversions
• Responsible for data cleaning of the HCM / HR – Cube Handoff
• Extensive Script Logic Updates
• Wrote new Multicurrency Script Logic FXTRANS.lgf
• NEW Scripts development to Push data to Finance Application from Project and HCM cubes
• DM package development
• BPF (Business Process Flow) development
• Conducted Optimization phase of BW before moving to HANA.
• Cleaned up legacy data flow to 7.3 utilizing functionalities such as DSO look up.
• Post migration activities: Cleaned logs, compressed data, fixed inconsistency in the environment.
• Manually backed up Hana environment.
• Migrated 15 critical reports, info-providers and data flow to the new BW on HANA system.
• Optimized data flow for reporting.
• Connected BOBJ environments to BW on HANA system Activate BW on HANA standard content
• Connect BPC using DB connect to BW on HANA
• Created Users in HANA Studio and POC creating views of backend tables

Confidential, Texas

SAP BPC – Solution Architect & Prime Consultant

Responsibilities:

• Management Consolidation of 153 Divisions and Business Entities
• Project Preparation
• BPC Business Blueprinting
• BPC – 10 MS version Installation
• FI - Integration with ECC6
• Meetings with Project Sponsors
• BPC – 10 MS version Installation
• SAP Sizing Guide and network traffic
• Sandbox, DEV, QA & PROD environment setup
• Setup BPC environment, Models, Dimensions, Business Rules, Controls, Logic, BPFs
• Configured BPC Initial Security
• Configured SSO for BPC10
• Added Users, Teams, Task profiles, Data Access Profiles
• Configured DM – wrote Transformation & Conversion files for .CSV data loads
• Uploaded 3m records to “Consolidation Model” using DM
• Uploaded 2m records to “Planning Model” using DM front end
• Created 13 new and 7 Ad-hoc reports using the new EPM tool
• Configured new connections in EPM to ECC GL records enabling Drill through
• Demoed Consolidation Demo to Zachry Corporate team members
• Demoed Planning Demo to Client Decision makers
• Define scope of Project in HR, SD, FI, and CO and laid out roadmap of future BOBJ landscape.
• Key decision maker on BOBJ tool selection; set the naming convention for global / regional reports and security strategy.
• Conducted blueprint workshops to define necessary reports in operations. Finance (AP,AR, GL, Asset Accounting, COPA), and HR
• Consolidated report requirements from multiple legacy systems.
• Created demo in SAP BI 4.0 Sandbox to clarify capabilities of BI 4.0
• Installation of Business Objects 4.0 server and end user tools. Configured single sign on.
• Implemented 4 layer BOBJ Security
• Team delivered & tested 5 Xcelsius dashboards and 15 BOBJ MS Analysis reports

Confidential

SAP BPC – Technical & Support Consultant

Responsibilities:

• Major script-logic development
• Cleaned up 14 scripts calculating EMPLOYEE wages, benefits & retirement
• Wrote Push2Finance logics to push records from HCM application to FINANCE
• Automation of Data Manager packages
• Developed new DTSK packages as per Business Blueprint
• HR cube integration with Finance
• Server Support (Service Pack Upgrades)
• New company acquisitions INTEGRATION into BPC Accounts & ENTITY.Dim
• ETL support, Data Cleansing, Transformations & Conversions from Legacy systems to BPC

Confidential, NA

SAP BPC – Prime 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.
• 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
• 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 (..\CPBM and ..\POABC) directories for consistency and namespaces
• Validated SSO configuration – CMC, CMS, Netweaver security profiles, task & roles for all 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 15 new Dimensions to be used throughout the 5 new Models in DEV, QAS, PROD
• 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 cut over and Go Live
• 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
• CMS configuration: 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 Business Blueprint
• Resolved Loops (manually using Aliases & Contexts) & 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 & tested universes & reports in coordination with DBA architects
• Used Designer to create Dimensional, Detail and Measure objects
• Resolved loops in universe using contexts and aliases and also Implemented aggregate awareness function
• Created Dashboards using Filters, List View, table, Line, Column and Pie charts (combination bar graphs, combination bar and line graphs, and line graphs will be used to display metrics)
• Involved in creating Tables and relationships
• Developed complex queries and reports using different data providers in the same report
• Created reports using Crystal Reports and also using Business Objects functionalities like Queries, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc
• Created and deployed Web Intelligence Reports through Info View
• Integration of BI, BO4 BPC10 with BO4.0 becoming the main reporting platform complete with Xcelcius integration for BO Dashboards & Analysis services
• 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 of BODS to plan for HANA Platform Edition implementation
• 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 replication
• Used parameter based rules to load initial Data, Mass Copy function
• 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.
• Gathered Business requirements to design the planning, forecast, budgeting needs
• Prepared Planning consolidation design documents, process flows
• Prepared functional, technical specification for Planning, Consolidation reporting needs
• Exchange rate Maintenance, Load creating Dynamic Range Exchange Reports and Schedules
• Defining Modeling Requirements and Creating Input Templates
• Creating and Developing Budgeting Business Process Flows
• Configuring Appset and Application parameters, set application status
• Adding, Scheduling dimension processing, Maintaining dimension members
• Assigning dimensions to applications, Using dimension properties
• Maintaining Currency and exchange rate types
• Opening balance and Historical balance loading from BODS - RapidMart
• Service & Support (Technical)
• 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
• Responsible to update DIM members and properties and syncing data from ECC6 G/L Accounts to BPC
• Responsible for bugs & fixes, Analysis, Evaluation & implementation of all BPC technical and functional issues
• Achieved performance enhancement using Lite and Full optimizations
• Designed and created “DIMENSION PROCESSING HANDBOOK” – A step by step guide to be used throughout all divisions to process, DIMENSIONS & APPLICATIONS in accordance with SAP-Best Practice
• Responsible for 2nd and 3rd level Support for all issues reported by Users via ISSUE MANAGEMENT software

Confidential, Houston, TX

SAP BPC Project Management BPC Practice Manager – Technical & Basis Consultant

Responsibilities:

• 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 installation steps (..\POABC & ..\CPMB and ..\1CPMB spaces)
• Configured new users in NW 7.3 for SSO
• Migrated old Appset to new Environment with minimal issues
• Used SAP provided upgrade tool to migrate old NW7.5 installation to new BPC10 NW new installation
• Current & Historical records imported into BPC10-NW
• Team converted 25 Reports and 8 Input Schedules using EPM –report migration with no major issues

Confidential, Atlanta, GA

SAP BPC – Practice Manager – Technical & Basis 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 & Consolidations (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.
• Tweaked supplied 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 viewing BPC10 data in Xcelcius