We provide IT Staff Augmentation Services!

Sr. Sap Bpc/bi/hana Consultant Resume

4.00/5 (Submit Your Rating)

Chicago, IL


Working as a SAP Techno functional Consultant over 11 years of SAP implementation & support experience in SAP BPC and BI/ABAP. Worked for prestigious clients like GRAINGER, Confidential, Confidential, QSI, Confidential, Confidential etc. Travelled multiple countries for UK, Belgium and France for requirement gathering and Due diligence etc.


  • Participated in 2 Full Cycle of SAP BPC 10.0 (Net Weaver) implementation and support. Worked on BPC applications using BPC 7.5 & 7.0 NW and good knowledge on MS version & BPC 10.1.
  • SAP BPC Planning, Budgeting, and Forecasting Implementation - Data Load, Manual Planning via Input Form, Manual Forecast via Input Form, Automated Planning via Logic, Automated Forecast via Logic, Budget Allocation, Business Process Flow, Work Status, and Management Reporting
  • SAP BPC Planning & Consolidation (Data Collection, Data Preparation, Pre-Consolidation, Consolidation, and Post Consolidation) - Data Load, Currency Conversion, Group Currency Conversions, Journals, Carry Forward and Account Classifications, Ownership Calculations, Intercompany Matching, Intercompany Booking, Intercompany Eliminations, Minority Interest and Equity Adjustments, Statuary Reporting, and Consolidation Centrals.
  • Hands-on configuration of FI General Ledger, Accounts Payable, Accounts Receivable, Cash Book, Bank Accounts, Foreign currency, Assets etc.
  • Hands experience on HANA Modelling, HANA Administration, migration from BW on HANA architecture solutions etc.
  • As accounting graduate Good understanding of Accounting principles and consolidations, budgeting and forecasting processes. Excellent and cross-functional experience in SAP SD, MM, PP, HR, SEM-BPS, APO, CRM, FI and CO modules.
  • Worked with FICO, BW, SEM - BPS, SEM - Currency translations Extensively worked with Basic and Transactional InfoCubes, Basic Planning Areas, Multi-Planning Areas, Planning Levels, Planning Packages, Planning Layouts, Local and Global Planning sequences
  • Knowledge of Data Slices, Characteristics Relationships, Variables and Functions like Formula Extensions (FOX), Copy, Revaluation, Distribution, Repost, Forecast, and Currency Translation
  • Strong experience in Complete Ware House Development Life Cycle (WDLC) of SAP-BW/BI with hands on experience includes requirement gathering, Design, Coding specification, testing, Implementation, Maintenance.
  • Participated in Design, Development, Implementation, Go-Lives, Upgrades, Re-Engineering and Production Support implementations.
  • Well trained & Hands-on Business Objects (BOBJ) Web Intelligence, Desk Intelligence, Polestar, Live office, Qaaws (Query as web service), Voyager, Polestar, Live office, Qaaws (Query as web service), Voyager.
  • Have experience in SAP R/3 Implementation projects.
  • Extensive experience in analysis, design, development, testing, implementation, and documentation
  • Hands of experience in maintenance as a Support Lead
  • Full hands of experience in Reports, ALV, Smart forms, SAP Scripts, BDC, and LSMW
  • Possessing strong programming skills coupled with the expertise to interpret the functional requirements into program design. writing technical designs for forms, reports and translating business requirements into technicalspec
  • Communication with client for issue clarification, status updating etc.
  • Interaction with Functional leads / Key users to understand Functional Specification and to sort out issues and preparing technical & functional specifications.
  • Providing Support for Production Problems.
  • Analyzing & fixing the problem by finding the Root Cause of the problem.
  • Meeting customer needs effectively and building customer relationships with a focus on accuracy, quality, and clarity.
  • Communicating with the Quality Assurance teams regarding issues.


Business Intelligence: SAP BI Net Weaver 2004s /BI 7.4/7.3/ /3.5/3.0

ERP: ECC 6.0/5.0, SAP R/3 4.6C/4.6B

BI Tools: BO 4.0/3.1 Outlook soft 5.2 Business Objects Enterprise XI (BOE) R2/6.X/5.X Web Intelligence 6.0/2.X, Broadcast Agent, Crystal Reports XI R1/R2

Middleware: SAP XI/PI

ETL Tools: SAP BW-BI-NW, Informatica, MDM

Reporting: BEx Analyzer, BEx Browser, WAD, Business Objects WebI, Crystal reports etc.

Databases: Oracle, SQL Server, DB2 and HANA

Planning tools: SAP IP & BPC7.5, 10.0 & 10.1

Presentation Tools: MS-Office Suite, MS-Project.


Confidential, Chicago, IL

Sr. SAP BPC/BI/HANA consultant


  • Analyse business requirements and interacted with key user for gap analysis and developed fictional specs.
  • Build the components of BPC to suit the requirements for Planning, Consolidation and Rolling forecast.
  • Build BPF, Work status and Manage Security based on requirements.
  • Data loading across the environments to meet the requirements.
  • Developed Customer specific data model with Dimensions and Loaded data from Periodic models to YTD models (Planning model to Consolidation model).
  • Integration between BPC & BI & Automate both Master data load & Transaction Data load.
  • Involved in creating and managing Dimension members during the period (addition of Accounts, segments, cost centres, Entities and any master data related to the consolidation), Created process chains to load master and set up email notification to users if any package fails.
  • Create & Maintain Custom reports & Input Template and Used VBA & EPM API for reporting purpose.
  • Developed complex input template & reports using edit report & EPM functions & VBA macro.
  • Developed complex Script logic to meet the requirement of client.
  • Trained end user about BPC reporting& how to do on demand Data loading from ECC to BPC & how to schedule the Data loading from ECC to BPC.
  • Created & maintained custom process chain/Data manager package for email & Net income calculation in BS.
  • Have solved input schedule issues though debugging using BPC transactions UJKT.
  • Work closely with BW to attain the MD and Transaction data extracts for setting up automated procedures in Process chains.
  • Worked on BI 7.4 (HANA) migration issues and prepared documents.
  • Worked on HANA POC: Playbook, OSS messages, Housekeeping and post processing activities with Basis team.

Environment: SAP NW BPC 10.0 & BW 7.3 & 7.4, ECC 6.0, HANA, SD, MM, FI and BI 4.0

Confidential, Orange County, CA

Sr. SAP BPC Consultant


  • Analyse business requirements and functional areas that could be satisfied with SAP business content and installed the objects.
  • Activated finance related datasources 0FI GL 4 and related DSO and Cubes for actual data.
  • Environment Shells, Models, Dimensions, Attributes, Hierarchies, and Security Profiles.
  • Worked on financial Planning/Budgeting implementation from Blueprint to implementation and going live.
  • Developed BPC Live Reports using drag and drop option and included interactive chart. Developed BPF, Audit and Work Status Reports.
  • Worked with end user to cycle through the functional unit test and approval to move it to the SAP production environment.
  • Used EPM function while developing Input Template & Reports ie EPMContextMember, EPMSelectMember, EPMMemberProperty, EPMMemberOffset etc
  • Installed standard Business content, filling step table and setting up deltas, validated data in BW cubes and creating process chains.
  • Environment Shells, Models, Dimensions, Attributes, Hierarchies, and Security Profiles.

Environment: SAP NW BPC 10.0 & BW 7.3, ECC 6.0, HANA, SD, MM, FI, HCM, PS.

Confidential, CA

SAP BPC/BW Architect & Lead


  • Played a key role in the merging of Europe and US systems. Visited many times UK, Belgium, and France for due-diligence and requirement gathering.
  • Interacting with end users and business lead & Business partners for finalizing requirements and gaps.
  • Played a key role in multiple BPC planning areas financial planning, sales planning, forecasting, Budget Planning, Rolling forecast, currency translations and reporting etc.
  • Generating daily status of all the issue log and resolution and sharing with the client to give them the visibility inside the project
  • Design and develop transformation and conversion files for deriving master and transactional data from BI to BPC Experienced with developing integration between BPC and BW objects.
  • Loading data from Periodic models to YTD models and Unit of Measure and Unit of Currency conversions.
  • SAP HANA in few systems to bring planning data to BPC to develop Input Schedules for their SDL.
  • Design and configure BPC (BPC 10 Net Weaver version) structures.
  • Environment Shells, Models, Dimensions, Attributes, Hierarchies, and Security Profiles.
  • Design and configure MS Excel based templates that would be used to enter different types of data (future forecast, price projections, and assumptions).
  • Design and develop transformation and conversion files for deriving master and transactional data from BI to BPC.
  • Reconfiguring the design by removing unnecessary dimension like Segment, Region and Project from OPEX application and accordingly to comply the changes in Reporting, security, logics etc.
  • Debugging BADI and script logic to check the performance of the logic when running on 23 million of data of ACTUAL, BUDGET and FORECAST version and make changes which is best for performance.
  • Used custom VBA macros in Reports to get desired results as per client.
  • Experienced with developing integration between BPC and BW objects.
  • Building reports using EPMDimensionOverride, EPMAxisOverride and other functions.
  • Developing Logics using macros and provided solutions on master data automation and Master data on fly.
  • Played key role to code in ABAP for developing BADIs, User defined Variable User Exit etc.
  • Participated in transport strategy for the implementation projects. Transporting Requests of various Objects of the BI using Transport connection & Transporting of BPC objects using UJBR.
  • Created Process Chains for the info packages scheduled on daily and Weekly basis and dealt with PC Failures.

Environment: SAP NW BPC 10.0 & BW 7.3, ECC 6.0 and BO 4.0, FI, SD, MM, APO, CRM and BI 4.0.

Confidential, Dalls, TX

Sr. SAP BPC Consultant


  • Responsible for identifying the user requirements, analysis of new requirements, developing reports, process chains, etc., and Developing FS to Technical Specs.
  • Prepared Design Document for Business Planning (Sales and financial planning)
  • Design and configure MS Excel based templates that would be used to enter different types of data (future forecast, price projections and assumptions).
  • Worked on Transformation and conversion file and loaded data from BI to BPC.
  • Design and develop transformation and conversion files for deriving master and transactional data from BI to BPC Experienced with developing integration between BPC and BW objects.
  • Involved in financial planning and Non-financial Planning, Head count Planning, Sales volume planning Sales Revenue planning, Cash flow planning etc.
  • Have solved input schedule issues though debugging using BPC transactions in UJFS and UJKT.
  • Developed Data Model for BPC Account Based model from BI KPI's.
  • Created Application Set from APPSHELL. Developed Applications, Dimensions, Properties and Hierarchies
  • Configured Application Set and Application parameters for Journals and work status settings.
  • Involved in data extraction and conversion between BPC and BW systems.
  • Worked on Setting up Security features with Task profiles and Member Access Profiles.
  • Integrated SAP BPC Data Manager Packages with SAP BI process chains.
  • Experience with Unit of Measure and Unit of Currency conversions
  • Involved in the performance enhancement activities like enabling cache, maintaining aggregates etc.
  • Responsible for the documentation and successful transportation of the requests to upper landscapes.
  • Extracted data in various Datatargets depending on the user requirements like ODS, Infocube.
  • Bug fixing in the business related support activities.
  • Preparation of Technical Specifications of the objects followed by the implementation of desired functionality.
  • Involved in overall design, development, testing and maintenance of custom InfoCubes, ODS, datasources from ECC.

Environment: SAP NW BPC 7.5 & BW 7.0, ECC 6.0 and BO, SD, MM, FI and CO.

Confidential, TX

Sr. BI/ ABAP Consultant


  • Analysed system for Gaps based on client requirement and created GAP documents.
  • Created reports on FI (AP, PS, FA, GL) & HR (PM, PY, PA, TM).
  • BEx reporting with the use of RRI interfaces, filtering, conditions, variables, and currency conversions and navigational attributes.
  • Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyser to facilitate data analysis in a drill down or summarized way to give detailed level of information.
  • Designed formatted reports using vlookups in workbooks.
  • Extracted data from FI modules of SAP R/3 and from flat files into SAP BW system using Generic, Business Content Extractors.
  • Created Process Chain to Load Master and then included in Metachain.
  • Installed standard Business Content and Customized based on client requirements.
  • Involved in overall design, development, testing and maintenance of custom InfoCubes, ODS, InfoSources/DataSources (Distribution Plan, Inventories, Slow Movers) based on reporting requirements.
  • Developed reports in ABAP as they are time consuming in BI.
  • Trained power users on utilizing, developing, and administering Ad-hoc reporting, ABAP Query (SQ01, SQVI) BW Queries & BEx Browser.
  • Conducted training for End-users and developed business process documentation.

Environment: SAP R/3 ECC 6, BI 7.0, ABAP, SD, MM, FI, HR, PS and CO

Confidential, NY

Sr.BI Consultant


  • Responsible for assessing the business requirements, and designing and developing a data access Solution.
  • Involved in Help Plan in BW Upgrade.
  • Migrated few BW 3.x Objects (Data source, transfer/update rule, Queries etc.) to BI 7.X objects.
  • Prepared excel sheets with all the objects of your Prod to test and note an estimated days to cover each areas and Preparing lists of objects to keep as is 3x version.
  • Identified the gaps between Business Content and Requirements.
  • Testing all the objects, DSO, Cubes, loads, process chains, queries, reports etc.
  • Added steps from PSA level to data target in the process chain as Infopackage loads data till PSA level in BI
  • Maintained Aggregates on InfoCubes for Query Performance.
  • Monitor the data loads, which are running hourly, daily & weekly basis.
  • Training power users and participated in documentation and troubleshooting.
  • Converted Transfer/Update rules to Transformations.
  • Involved in testing 3.x objects in Net weaver 2004S, after upgrade.
  • Responsible for identifying and obtaining the data required to satisfy the requirements.
  • Installed the Business Content Info Objects, Info Cubes, and Info Sources as per the requirements.
  • Developed Views and Function Modules for Generic Extraction.
  • Gave a support to Basis team for installing patches, OSS notes and all.
  • Implemented SEM /BPS planning functions requiring complex allocation, Bottom-up/ Top-down value, distribution by reference, keys functionality, Depreciation, offsetting entry, delete function, user exits, complex FOX formulas etc
  • Developed Planning Hierarchy in SEM-BPS, Hierarchy Attributes in BW, Characteristic Relationships in SEM-BPS, and Worked on realignment of Characteristics across Hierarchies.

Environment: SAP R/3 ECC 6, BI 7.0, ABAP, SD, MM, FI, HR, PS and CO


SAP BW/ABAP Consultant


  • Created Remote Cubes, ODS in APO Server. Extracted data from R/3 and BI servers.
  • Created Process Chains in APO Server.
  • Supported APO Functional Consultants for their issues.
  • Extensively participated in Gap Analysis, enhanced the Business Content to fulfil the requirements.
  • Created Generic Extractor in BI server for Transferring data from BI to APO Server.
  • Designed and developed Info Objects, Info Cubes, ODS objects, Info Sources, Transfer Rules, Update Rules and Info Sets to meet the requirements.
  • Did the Re-Engineering for APO cubes in APO server.
  • Weekly status team meetings and daily update to managers.
  • Trained end-users on how to create Y queries in the production system.
  • Installed relevant SAP Business Content.
  • Scheduled Business Content data extraction from SAP R/3 Source System and data load procedures.
  • Worked on standard LO extractors for SD module.
  • Used LO structures for extracting sales order, delivery billing information.
  • Data extraction from SAP R/3 system and Flat file. Did Generic data extraction.
  • Data Mart: Used DSO to stage the extracted data before loading into the Infocube.
  • Developed an Interactive report to display the pricing conditions in a Sales Order.
  • Developed an Interactive report to display list of deliveries, reading shipping-point, customer number and delivery date ranges from user.
  • Developed a report to display purchase order history, vendor information and material description through extracting material numbers using (ALV) ABAP List Viewer

Environment: SAP R/3 4.6C, ABAP/4, SAP, ABAP, SD, MM, FI and CO


ABAP/BW Consultant


  • Bug fix in the business related support activities
  • Developed new screens as per requirements using Module Pool Programming.
  • Developed both classical and interactive reports using ABAP List Viewer (ALV).
  • Developed reports for the shipment details of a material from the plant and developed the same based on product hierarchy.
  • Developed sales interactive drill down report for a company in various countries and their respective locations.
  • Created New Layout for script set for the Invoice & Modifies Invoices, Credit Memos, Purchase Order and Mass Mailing Labels.
  • Created the BAR code in the scripts layout.
  • Involved in the documentation of ABAP/4 programs
  • Developed custom reports as per customer requirements in the area of MM, SD and FI/CO by using ABAP/4 programs and ABAP query.
  • Extensively worked on data migration using BDC, Sessions, and LSMW.
  • Developed Batch programs (BDC) to upload customer details from legacy system.

Environment: SAP R/3 4.6C, BW, ABAP/4, SAP, ABAP, SD, MM, FI, CO

We'd love your feedback!