We provide IT Staff Augmentation Services!

Sap Bi/bpc Solution Consultant Resume

Raleigh, NC

PROFESSIONAL SUMMARY:

  • Over 15 years of professional experience in Information Technology. Includes 11 years of SAP BI experience. Implemented 3 full life cycle Projects in SAP BI involving both front end and back end development.
  • Extensive hands on experience in BI backend development - Info Objects, Info Cubes, DSO, Multi-providers, Info Set, DTP, Transformation, Transfer Rule, Update Rule, Info Package.
  • Experience in BI front end development - BEx Analyzer, BEx web Analyzer, Views, Workbook.
  • Involved in all aspects of the ASAP methodology phases - Business Blue Print, Realization, User Training, Preparation and Go live/Support.
  • Experienced in SAP HANA implementation, SAP System Landscape transformation
  • SAP HANA data modeling using Attribute View, Analytic View and Calculation Views,
  • Expertise in data modeling, design, configuration, implementation of Data Warehousing solutions
  • Hands-on configuration knowledge of SAP CRM Marketing, Sales and Service Including SAP’s call centre solution Customer Interaction Center (CIC).
  • Working knowledge in both BI7.0,BI 3.5 & BO 4.0
  • Expertise in Process Chain, Scheduling, Monitoring data loads and Background jobs.
  • Worked extensively with LO Cockpit, Logistics and FI extractors, process chain.
  • Proven ability in defining goals, coordinating teams and achieving results.
  • Experience in SD Business Processes.
  • Created Webi Reports on top of Bex Queries and SAP HANA Database
  • Analyzed and evaluated user’s requirements, created technical documentation, assisted users, coordinated procedures, reviewed functional specifications with the Subject Matter Expert.
  • Served as coach mentor to the department staff regarding how to deploy and execute a test plan. designed test plans to ensure software functions as designed.

TECHNICAL SKILLS:

ERP: SAP ECC5.0, ECC 6.0

BW: BI 7.0, BW 3.5 BO 4.0

Function Modules: SD, MM, HANA, FI/CO

Reporting Tool: BEx Analyzer, Web application Designer, BEx Web Analyzer

Operating Systems: UNIX, Linux, MVS, OS/390, z/OS, Windows.

Packages: MS-Office, VISIO

Databases: DB2, Oracle10 PL/SQL, SYBASE

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh, NC

SAP BI/BPC Solution Consultant

Environment: SAP BI,BPC, SAP ERP ECC.6, BEx, Analyzer

Responsibilities:

  • As a Techno functional consultant preparing the functional design documents from the requirements.
  • BI/BPC Consultant responsible for Preparation of Data flows, functional feasibility analysis, Post go live support, activity execution, Quality Assurance to improve performance of the system.
  • Create Appsets, Dimensions, Applications, Conversions, Transformations
  • Created universes, classes, objects, based on SAP HANA data models like Calculation Views and Analytical Views and defining the necessary connections.
  • Configuration of web reporting with customized web templates using Web Application
  • Building Dashboards using visual composer in producer portal PS3 (Enterprise Portal).
  • Customized and maintained Data sources such as Billing Item (2LIS 13 VDITM) and
  • Performed Data loads for Transaction and Master Data from SAP R/3 using Process Chains
  • Worked extensively with the Sales Order and Billing items Data Sources, Custom InfoCubes and Custom DSO(Data store Objects) for staging the billing and Sales order item data
  • The Solution in BPC integrated with SAP ECC, BW and BusinessObjects
  • Developed Xcelsius dashboards for Weekly and Monthly Business Objects usage trends.
  • Activated the Business Content performed the Data Source Migrations. Created different test scenarios to reconcile new reports to old reports
  • Designed Xcelsius Dashboards using Excel and QaaWS.
  • Performed data modeling in SAP HANA studio and developed Analytical views for the transactional data, Attribute views for the master data, and Calculation views for reporting.
  • Created transport proposals.
  • Provided assistance and created training curriculum, guides, checklists and courses.
  • Created test plans, scripts and scenarios for Unit Testing and User Acceptance Testing.
  • Coordinated and managed User Acceptance Testing.
  • Supported end users for the existing applications as well.
  • User Training of navigation and utility of BPC reporting
  • Direct interaction with the business users.

Confidential, Jasper, IN

Sr. SAP BI/BPC Consultant

Responsibilities:

  • Part of the implementation team in implementing a BI Solution data and legacy application, responsible for doing front end and back end development work
  • Hands on development work, creating or changing Info Objects, ODS, Info Cubes, Multi Provider, Transfer Rule, Update Rule, Info Packages.
  • Responsible for Designing and Architecting the Planning solution for Liquidity Planning (in BPC NW 10), while Legal Consolidation to stay in Hyperion. Responsible for Architecting the BPC Planning solution in a heterogeneous landscape, with multiple SAP instances and heterogeneous legacy systems.
  • Design of Planning models and development of Planning Areas, Multi-planning areas, Planning Levels and Packages for Sales Planning and Cost center Planning
  • Defining Planning Functions and creating and maintaining Planning Layouts for Manual Planning
  • Implemented full/delta loads, standard, generic extractors, process chain and set up in conjunction with the 3rd party scheduler software for nightly data load.
  • Performed Data Extraction for master data and transactional data from ECC system to SAP BW.
  • Creation of Web interface using BSP pages for planning, and making the planning layouts available to the users using Enterprise Portals
  • Involved in the Upgrading of BW 35 to BI 70
  • Implemented many BI reports using BEx.
  • Developed many BI queries, Views and workbooks on Sales and financials data.
  • Develop BI objects in both BI 7.0 and 3.5 versions.
  • Extensive experience SAP HANA/BW with ability to synthesize the technical needs to the business requirements for a new engagement
  • Developed and scheduled Business Content data extraction from SAP R/3 Source System and data load procedures.
  • Worked extensively on LO Cockpit and SD extractors
  • Responsible for Logistics Cockpit configuration and customization for sales order overview.
  • Responsible for extending standard extract structures and user exit on SAP R/3 side.
  • Created process chains for nightly data loads for master data, transaction data.
  • Created training materials for end users and conducted many End user trainings.

Confidential, Reedsburg, WI

BW Consultant (BI Architect)

Responsibilities:

  • Worked closely with SME’s, functional specialists and process owners to gather detailed business requirements and translated the requirements into robust reporting solutions.
  • Developed data models, data flow diagrams, functional design and technical design documents for BI Solutions
  • Conducted meeting and interacted with third party vendor to get needed clarifications.
  • Designed Star Schema
  • Developed model to Load data from third party through Oracle 9i as the intermediate tool.
  • Built info objects, master data objects, DSO and info cube
  • Mapped the third party data to SAP data though ABAP routines to look up the mapped data.
  • Built required transformations on production data and used ABAP routines to fetch matching plant and material.
  • Built cubes and multi provider on sales data and production data.
  • Tested, Validated loaded data from ECC to HANA, troubleshoot and analyze varies issues related to data load.
  • Developed 7 reports with BEx tools as per the client’s requirements
  • Used ABAP user exit to get the previous year same month data in 4 reports.
  • Tested for data integrity, Data load, and performance
  • Identified data discrepancies and data quality issues, and worked to ensure data consistency and integrity
  • Tuned the objects and processes for Performance
  • Participated and supported 2 UAT sessions with super users
  • Involved in Moving the objects and related processes through 5 landscapes
  • Documented the complete processes and presented to the approval committee.

Confidential, Winchester, VA

Sr. SAP BI /BO Consultant

Responsibilities:

  • Contribution-Interacted with the management, conducted workshops and personal interviews to collect the requirements during initial stages of projects/task for understanding business process and end-users reporting requirements.
  • Fielding questions concerning the data content, definition and structure.
  • Worked closely with the process team to design Functional Specifications document and created Technical Specifications for the same.
  • Support the Procurement Business with the provision of functional specifications and technical specifications for systems, ensuring compliance with guidelines.
  • Involved in design of Planning for business planning applications.
  • Activated Sales Cubes 0SD C01, 0SD C02, 0SD C03, 0SD C05 from Business Content and customized to meet the requirements.
  • Involved SAP HANA-BW on HANA use cases study, solution proposal and implementation
  • Worked extensively on Standard Datasources with LO Customizing Cockpit for extracting Sales, Delivery, Billing, Purchase and Customer.
  • Activated Operational Data Store Objects and Cubes by the extraction of data from R/3 using 2LIS 11 VAITM, 2LIS 12 VCITM and 2LIS 13 VDITM extractors.
  • Worked on reports of Costs of raw materials, operating supplies, Wage costs and External services.
  • Worked on creating Aggregates and providing fixed values for Info objects as per requirement, Data Marts, Info cube Compression.
  • Created Multi provider on sales and delivery cubes to assist reporting on sales and delivery together.
  • Created reports on incoming order data for specific customers, Quotation Success Rate per Sales Area, Delivery Service Analysis, Service Level analysis by quantity and item level.
  • Request creation and maintenance for object transportation.

Confidential, Denver, CO

Sr. SAP BI/BO Lead/ Consultant

Responsibilities:

  • Part of the implementation team in implementing a BI Solution for CRM,SD data and legacy application, responsible for doing front end and back end development work
  • Hands on development work, creating or changing Info Objects, ODS, Info Cubes, Multi Provider, Transfer Rule, Update Rule, Info Packages.
  • Implemented full/delta loads, standard, generic extractors, process chain and set up in conjunction with the 3rd party scheduler software for nightly data load.
  • Implemented Information Broadcasting to send large reports to broad user base through email for the Field Sales Team.
  • Configured CIC to enable Call Center Representative to create service Orders for repairs.
  • Developed Integrated Billing cube (to include Billing item, Billing conditions, legacy Billing information)
  • Co-ordinate security and transport activities with the security and Basis team respectively.
  • Implemented many BI reports using BEx.
  • Involved in SAP HANA Attribute, Analytical, Calculation view data modeling optimization, tuning, applied SAP best practices and troubleshooting
  • Developed many BI queries, Views and workbooks on Sales and financials data.
  • Develop BI objects in both BI 7.0 and 3.5 versions.
  • Responsible for Logistics Cockpit configuration and customization for sales order overview.
  • Responsible for extending standard extract structures and user exit on SAP R/3 side.
  • Developed and scheduled Business Content data extraction from SAP R/3 Source System and data load procedures.
  • Extracted Data from R/3, Creating Info Packages, Event Scheduling, and Monitor settings.
  • Worked extensively on LO Cockpit and SD extractors
  • Created process chains for nightly data loads for master data, transaction data.
  • Created training materials for end users and conducted many End user trainings.

Confidential, Meridian, MS

SAP BI/CRM Consultant

Responsibilities:

  • Created approx 50 reports and 300 views and 60 workbooks in this project, Used SAP BW 3.5, ECC 5, CRM,SD, BEx Analyzer, AWB
  • Deriving technical specifications from high-level functional specifications for the BI front end development work.
  • Involved in design, development, unit testing, and integration testing of new BI front end development as well as enhancing the existing objects.
  • Created technical design document, unit test scenarios and integration scenarios for the project.
  • Enhanced pre-configured InfoCube and related objects to meet the business requirements.
  • One working screen (IC profile) for each interaction centre scenario
  • Simulation of incoming phone calls and phone call processing (inbound and outbound)
  • Created aggregates for the InfoCube for the better performance of the queries.
  • Defined new info objects and modified the User Exit for transactional data / master data to accommodate the business need as per the client requirements.
  • Extensively used Variables, Restricted, Calculated Key Figures & Query Jump targets (RRI), text variable, exceptions, Conditions, Filters, Global Filters.
  • Configured and scheduled Information Broadcasting for the sales force and upper management on their daily BI reports.
  • Configured CIC to enable Call Center Representative to create service Orders for repairs.
  • Created Webi Reports on top of Bex Queries and SAP HANA Database
  • Handled all user inquires related to production support and giving them resolution.
  • Extending production support and resolving the production issues on daily basis.
  • Created user training manuals for all the new BI queries, workbook and views
  • Conducted training for the end users on their reports.

Confidential, Chicago, IL

SAP BI/ BW Consultant

Responsibilities:

  • SAP BI 7.0 RTP (Request to Pay) SRM - EBP and PS implementation at Confidential
  • Installed and activated SAP business content according to initial design of RTP (Request to pay)
  • Developed InfoCubes and ODS’s (Data store objects) for Purchase Order, Confirmation, Invoice, Shopping Cart, Bidding Engine and Global Spend
  • Created ODS (Data Store objects) for data staging before loading the ODS contents to the InfoCube
  • Automatic Number Identification (ANI) for incoming telephone calls
  • Performed data extraction from SRM DataSources for Purchase Order, Confirmation, Invoice, Shopping Cart and Bidding Engine and extended the structures using user exits to support the business needs
  • Interacted with Business leaders, Owners, Users, Call center Agents to Understand the Business processes, functional requirements and did the Gap analysis.
  • Created Master data and Transaction data process chains to automate loading process
  • Developed flexible queries using navigational attributes, variables, calculated key figures, restricted key figures in Query Designer to facilitate data analysis in a detailed drill down or summarized levels
  • Created Variable Exits for global variables Fiscal year variant, controlling Area and Chart of Accounts as per the requirement
  • Given role based access to queries in Enterprise Portal
  • Written a Global Include program which reads values from TVARVC table for fiscal Year variant as it is client dependent
  • Implemented SAP Notes

Confidential, Rosemont, IL

SAP BW /CRM Consultant

Responsibilities:

  • Responsible for integration testing all the BI front end back end development. Used SAP BW 3.5, ABAP/4, ECC 5 (CRM and SD modules), BEx Analyzer, BEx Web Analyzer
  • Created integrated test scenarios for testing queries, views and work books.
  • Reviewed functional and technical design documents for completeness.
  • Extensively tested BI queries, restricted key figures, and calculated key figures.
  • Analyzed, indentified issues and recommended resolutions.
  • Responsible for working with SAP HANA security including user management, Roles and Privileges.
  • Tested all the BI key figures with ECC (sources of truth) by running SE16, standard TCodes, SQVI, Custom ABAP programs.
  • Investigated the BI back end objects (cube, ODS) to make sure that the data is populated as expected.
  • Reviewed and tested all the BI nightly data loads for master data and transaction data.
  • Scheduled the data loads in Test environment and making sure that there are no failures.
  • Updated issue log with discrepancies and possible resolution in the issue log.

Confidential, Irvine, CA

SAP BW Functional Consultant

Responsibilities:

  • Involved in designing MDM for various business scenarios and creating custom InfoCubes supporting Quality Management and Materials Management of consumer products.
  • Installed Business Content and activated the SAP delivered Standard InfoCubes and InfoSources.
  • Worked on Generic Data Extraction tool (RSO2) to create DataSources for transaction and master data.
  • Created Views in the non-SAP database systems and generated Data Source for the tables/views.
  • Extensively worked on CO-PA, FI-SL, and Logistics Cockpit extractions.
  • Maintained customized InfoCubes, Operational Data Sources, and MultiCubes for the business requirements.
  • Updated data from several ODS objects into InfoCubes.
  • Defined update and transfer routines in transformation rules.
  • Performed Delta request using Time Stamps.
  • Dealt with the creation of InfoPackages for transaction data as well as master data.
  • Worked on Process Chains to load InfoCube, ODS, aggregate roll up etc.
  • Created InfoSpoke for carrying out extractions from BW InfoProviders.
  • Extensively used BEX Analyzer to build queries, queries with maps and charts and worksheets to access data from BW data targets.
  • Used ODS Reporting to give details of delivery items.

Confidential, Atlanta, GA

Test Analyst

Responsibilities:

  • Prepared Test Plans, Test cases Test Scenarios and Test Data for all requirements.
  • Automate the GUI of Web application by Selenium Webdriver.
  • Reviewed the Test Cases prepared by other team members.
  • Published Test Summary Reports on the basis of testing result.
  • Involved in build and Release processes.
  • Conducted Review Meetings with Business analyst and within the Team.
  • Responsible for coordination between development team and testing team.
  • Reported bug using the bug tracking tool.
  • Involved in testing the Production Releases.
  • Prepared the release notes for the known limitation of the project delivered.
  • Worked on Source control, data collection, reporting and project tracking using TFS.

Hire Now