SUMMARY OF QUALIFICATIONS

• SAP experienced BPC and Business Warehouse Architect/Developer with 14 years of IT experience, with over 10 years in SAP BW and 4 years in SAP BPC NW
• Involved in 4 full-lifecycle of SAP BW
• Involved in 3 full life cycles of BPC 7.x for Netweaver.
• Implemented a proof of concept for BPC planning on BPC 10.0 for Netweaver.
• Reduced 70 of the time spent in generating and loading flat files into BPC by creating Custom process types and process chains to load BW data directly into BPC applications.
• Developed custom data packages for BPC data manager which saved business analysts 30 of the time spent on planning.
• Developed a custom backup process to refresh BPC production data into BW development and quality systems for BPC7.0.
• Leading requirement gathering sessions to design applications based clients' business process.
• Translating business requirements into SAP BPC NW landscape/design.
• Defining SAP BPC NW security.
• Designed/modeled a data flow from ECC into BW then into summarized BW info cubes designed specifically for BPC implementations this facilitated the cube to cube load for BPC planning.
• Defining and developing dimensions, applications, calculations, script logic, business rules, Input schedules and reports extraction of data from SAP BW as a source system into BPC applications via data manger packages.
• Analyzed, recommended and executed solutions on a BW system that fixed BI Accelerator memory issues which resulted to a faster report execution time.
• Led the initiative to gather requirements and developed BW queries for waste reporting which enabled the company to identify and rectify plant and material waste processes.
• Developed custom web templates with the use of WAD for inventory, fill rate reporting dashboards and material movements type monitoring which improved the stock availability in the plants.
• Designed and implemented a custom BW Admin. Cockpit using Visual composer, which enabled the SAP group to have a better view and transparency of daily process chain loads, process chain statistics, BW usage version 3.5 vs. 7.0 to assist the SAP group to identify, evaluate and determine when and how to transform all Users to the use of BW 7.0 queries.
• SAP BW security: Advised the security Team on the required/ appropriate BW authorization objects for the desired User access, which helped the company to avoid assigning over authorized access to Users which prevented the problem of unauthorized data access.
• Designed the sales dashboard which helped stakeholders in having a one page view of company sales by RBM, VP and total gross sales and one version of the truth per company performance.
• SAP BW lead on the Upgrade from BW 3.5 to BI 7.0, Trained end Users on the delta between BW 3.5 usage vs BI 7.0
• Modifying preexisting BPC designs in accordance to SAP best practice and to meet the clients' needs.
• Extensive experience with BPC 10.0 for Netweaver
• Extensive experience with BPC 7.0, 7.5 for Netweaver
• Extensive experience and knowledge of the New BPC 10.0 NW functionalities
• Advance experience in script Logic coding for BPC NW
• Extensive experience in the development of custom/complex reporting templates and Input schedules using BPC NW 10.0, 7.5 and 7.0
• Advance knowledge and experience with SAP BW data modeling
• Extensive knowledge of SAP BW security and Authorizations
• Extensive experience in BI upgrades BW3.5 to BI 7.0 .
• Extensive experience in the Creation of BPC reporting packages
• Extensive experience in SAP BW and SAP BPC performance tuning
• Experience in Enterprise portal implementation
• Experience with SAP Visual Composer.
• Experience with BIA BI Accelerator
• Developed global reports for company, intercompany sales, revenue, production and planning analysis which was used to analyze by regions, country or location.
• Involved in Designing, Implementing, Data Models, Extraction and Reporting.
• Configured Info Cubes, ODS Objects, Info Objects.
• Involved in Data extraction from R/3 function modules using LO, COPA and Business Content extractors
• Developed Queries and Reports using BEx Analyzer and Web Application Designer.
• Excellent knowledge of Business Intelligence and Data Warehousing.
• Experience in extracting data from R/3 and ECC - function modules, FI, CO, MM, SD, LO, SD and PP to SAP BW/BI.
• SAP BPC 7.0 for Netweaver implementation, data extraction and support
• Experience with SAP BW security.
• Experience in developing security requirements for reporting roles and authorization objects.
• Extensively worked on BW Reporting.
• Designed and developed SAP BW components such as Data Sources, Transfer rules, Info Sources, Update rules, Info Objects, ODS, Info Cubes, quarries via BEx Analyzer, BEx Web reporting, BEx Web Publisher
• Excellent Communication Skills

ENVIRONMENTS:

R/3 4.6c, 4.7, ECC 5.0, 6.0, BW 3.0, 3.1, 3.5 NW04S BI BI 7.0 , BI 7.3, SAP BPC NW 7.0, 7.5, 10

PROFESSIONAL EXPERIENCE:

Confidential

Lead SAP BPC/BW Consultant

• Evaluation assessment and recommendation of client's current SAP BPC NW planning implementation project.
• Advisory role on SAP BPC best practices and design improvement.
• Short deferred acquisition cost solution design and implementation
• Script logic coding for the calculation of a custom Short deferred acquisition cost solution
• Creation of catastrophic upload template design via ABAP.
• Custom SAP BW data modeling
• Creation of underwriting Adjustment input template
• Validation reports design and developments
• Creation of custom DM packages
• Test script writing
• Customer SAP BPC education/training

Environment: SAP BI 7.0, SAP BPC NW7.5 and Windows XP.

Confidential

SAP BPC/BW Consultant

• Advisory role on SAP BPC best practices and design improvement.
• Advised, recommended and implemented SAP BPC NW Script logic coding for Planning, Foreign exchange translation and business rules.
• Educated HCL Axon UK consultants on best practices and on how to code script logic for SAP BPC NW
• Remote issue resolution.

Environment: SAP BI 7.0, SAP BPC NW7.5 and Windows 7

Confidential

SAP BPC/BW Consultant

• Involved in the implementation of BPC 10.0 Netweaver Planning applications proof of concept
• Developed reporting templates and Input schedules for the Utility industry sales Demo
• Developed reporting templates and Input schedules for the Insurance industry sales Demo
• Extensive script logic coding for currency translations to enable the planning with multiple currencies
• Extensive script logic coding for transaction data transfer and calculations between applications and via input schedules.
• Developed data manager packages for data transfers and script logic executions, this was necessary for data automation to save man hours.
• Data validation via SAP BW for all BPC applications, which confirmed that the script logic calculations where calculating based on the functional specifications.
• BPC 10.0 modeling which included the creation of dimensions, Applications, Dimension members, Dimension Properties, security setup and update, etc.
• BW 7.3 data modeling, design and reporting.

Environment: SAP BI 7.3, SAP BPC NW10.0 and Windows XP.

Confidential

SAP BPC/BW Consultant

• Led requirement gathering sessions for budgeting and planning script logic coding.
• Implemented BPC 7.5 for Netweaver which replaced a Hyperion system
• Developed custom reporting templates and Input schedules for testing script logics to ensure desired results were obtained via logic calculations
• Creation of complex script logic codes to meet the clients requirement from their previous Hyperion system. The codes alleviated the time spent by end users during planning scenarios.
• Loaded transaction data from SAP BW info cubes into SAP BPC applications saving the client an hour which enabling the client to spend more time in their planning process
• Performance tuning using Business intelligence Accelerator BIA/BWA to improve query run times
• Developed a process to automate Master data loads from the SAP BW environment and Flat file loads, thereby reducing the man hours spent by planners on time consuming process.
• Developed custom Data manager packages to load data from the SAP BW app server, thereby making it possible for non IT skilled end-users to proceed with their work tasks with minimal involvement of the IT team
• Developed Transformation files to populate master data loads and dimension member properties, thereby improving the data quality form source to target systems.
• Developed conversion files for custom conversions per clients request to filter out unwanted data, which made reporting results more readable.
• Trained team members and client on SAP BPC transport procedures and options
• Executed stress test scenarios to ensure the system was capable of handling post go live usage.

Environment: SAP BI 7.0, SAP BPC NW7.5 and Windows XP.

Confidential

SAP BPC/BW Consultant

• Implemented BPC 7.5 for Netweaver which facilitated the client in their planning processes.
• Requirement gathering for reports and input schedules
• Developed custom Premium comparison reporting
• Developed custom Premium earnings pattern reports and Input schedules
• Developed custom Gross commissions reports and Input schedules
• Creation of reporting packages for deferred income and allowance on sales to distributors roll forward
• Educated and trained team members and client on SAP BPC NW transport procedures and options
• Developed Data Push logics for pushing data from one application to another per design document
• Developed FxTrans logic for currency translation purposes
• Performance tuning on both SAP BW and SAP BPC systems

Environment: SAP BI 7.0, SAP BPC NW7.5 and Windows XP.

Confidential

SAP BPC/BW Consultant

• Involved in BPC 7.5 for Netweaver implementation
• Developed custom reporting templates and Input schedules for Capital expense reporting
• Developed custom reporting templates and Input schedules for Operating expense reporting
• Developed custom reporting templates and Input schedules for HCM reporting
• Creation of reporting packages for deferred income and allowance on sales to distributors roll forward

Environment: SAP BI 7.0, SAP BPC NW7.5 and Windows XP.

Confidential

SAP BW and SAP BPC Developer/ Analyst

• Involved in BPC 7.0 for Netweaver implementation
• Developed Custom process chains to load BW data into BPC applications for Finance and consensus applications.
• Developed custom data packages for BPC loads
• Developed Custom process to refresh BPC data from production system into BW development and quality systems for the corresponding BPC environments.
• Worked on upgrading the BW system from version BW3.5 to BI 7.0
• Involved with the BW and BPC architectural designs.
• Worked on the migration of some queries from BW 3.5 to BI 7.0 version
• Extensively involved in assisting the SAP security team in determining the required BI authorization.
• Worked with Open Hub Development to FTP data to third party applications.
• Activated and implemented the BI 7.0 technical content.
• Developed a custom Admin cockpit for the company because the standard admin cockpit did not meet their needs.
• Worked extensively on enterprise portal
• Developed custom Bex queries for Finance, sales and distribution, customer service, production planning, COPA. demand planning reports using data loaded into BW from APO
• Activated standard BI business content queries where applicable.
• Developed custom web templates with the use of WAD for inventory, fill rate reporting dashboards and material movements type monitoring.
• Developed custom sales and statistic monitoring dashboards with Visual composer VC to analyze company daily sales and BI performance respectively.
• Developed restricted key figures and calculated key figures to meet company KPI reporting.
• Driven the initiative to gather requirements and Developed BI queries for waste reporting which enabled the company to identify and rectify plant and material waste.
• Developed a cash flow report for a client
• Developed profit and loss statement report
• Worked extensively with purchasing data sources and Developed Purchasing, Contract, obsolescence and material inventory reports
• Worked extensively with SAP BI 7.0 and Developed transformations. DTP,s, info packages, process chains, info cubes, DSO's, multiproviders,
• Worked extensively with SAP BW 3.5 and Developed info packages, process chains, info cubes, ODS's, multiproviders, update rules, transfer rules
• Worked as a BW resource in a SAP BI upgrade BW3.5 to BI 7.0 implementation
• SAP BW production support, monitoring daily process chain loads and troubleshooting extraction failures where applicable and assisting end users with performance issues such as slow executing queries and how to run queries.
• Developed ADP's analysis data processes for custom data manipulation and extraction into a secured company directory for BPC 7.0 for Netweaver data loads per the company's BPC design.
• Worked extensively with SAP enterprise portal and implementation, designed a custom web template for a client, through which end users can access reports from enterprise portal.
• Experience with BIA/BWA BI Accelerator Developed and maintained BIA aggregates on info cubes
• Experience in 2 full-lifecycle SAP BW implementation following ASAP methodology. Gathered requirements for reporting and BW ETL design
• Involved in Designing, Implementing, Data Models, Extraction and Reporting
• Involved in Data extraction from and the enhancements of data sources from SAP R/3 and ECC source systems.
• Experience in extracting data from R/3 and ECC- function modules FI, CO, MM, SD, LO, SD and PP Analyzed SAP BW security/access problems and recommended solutions to the SAP security team
• Performance tuning for slow runtime queries

Environment: SAP BW 3.5, SAP BI 7.0, ECC 5.0, SAP VC, FI, CO, MM, SD, LO, SD and PP, SAP EP, SAP BPC NW7.0 and Windows XP.