We provide IT Staff Augmentation Services!

Lead Sap Bpc/bw Consultant Resume

SUMMARY

  • 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

ENVIRONMENT: S: 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, New York

Lead SAP BPC/BW Consultant

Responsibilities:

  • 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

Responsibilities:

  • 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 Confidential 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

Responsibilities:

  • 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

Responsibilities:

  • 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.

Hire Now