We provide IT Staff Augmentation Services!

Sap Bpc-bi Architect Resume

SUMMARY

  • SAP BPC and BI certified with 10 years of Techno - functional expertise in SAP HANA 2.0, EPM 10, SAP BPC 7.5/7.0, BI/BW, SEM-BPS and BI-IP
  • Experience in Project preparation, blueprinting, requirements analysis and validation, gap analysis, design, implementation, documentation, testing, go-live and post-production support.
  • Extensively worked on SAP BPC - developed transformation files, conversion files and script logic. Designed Applications, Appsets and dimensionality and worked on complex script logic as well as currency conversion, allocations and other standard BPC functionality such as distribution and collection of input templates.
  • Developed BADIs with custom ABAP code to handle complex scenarios of data transfer
  • Expertise in ETL (Extraction, Transformation and Loading), Multi-dimensional modeling and reporting with emphasis on performance optimization
  • Industry-specific experience includes large Petrochemical and process industries, Chemical Industries, Consumer Industries, Hi-tech, electronic, manufacturing companies and Telecommunications Industries
  • Excellent Communications skills (verbal and written). Involved in conducting workshops, user-training sessions, Knowledge transfer sessions etc. Excellent team player and team lead skills. Excellent analytical and problem-solving skills

TECHNICAL SKILLS

Environment: s: BW3.0B, 3.1C, Netweaver BI 7.0, BPC 7.0, BPC 7.5, BPC 10.0 (EPM 10), SAP HANA 2.0

Areas: FICO, PS, COPA, SD (Billing, Deliveries, Orders, Pricing), CCA, PURCH, AP, AR

Functional Expertise: Financial Planning, P&L, FICO, COPA, PS, IM, WBS, SD (Billing, Deliveries, Orders, Pricing), Balance Sheet

PROFESSIONAL EXPERIENCE

Confidential

SAP BPC-BI Architect

Responsibilities:

  • Involved in blueprinting, design and development of data models for Financial Planning, Forecasting and Budgeting - Income Statement and Balance Sheet Planning
  • Designed and Developed Dimensions, Applications, Script Logic and Business Rules required for Data flows, Currency Conversions and custom logic for Allocations
  • Developed Reports and Input Schedules
  • Developed Transformation Files, Conversion Files and Packages required for Extraction, Transformation and Loading of data.
  • Worked on Currency Conversion, Allocations and other calculations.
  • Optimized performance by using Parallel processes (Run Logic)within Script Logic calls for calculations with pre-defined selection criteria
  • Developed Script logic and Data Manager Packages for Allocations
  • Developed complex calculation view using SQL and CE-Function. Developed Interfaces from SQL to SAP HANA and BW/BPC using remote sources.
  • Involved in Project Management activities such as estimation of effort, planning, delivery, trouble shooting, and people management
  • Configuration and unit testing of Consolidation Business rules, Currency Translation and Journal Entries
  • Post-production support including monitoring process chains, consolidations monitor and Package link automation
  • Involved in preparation of test scripts, unit testing and string testing, user acceptance testing and post go-live support

Environment: SAP HANA 2.0, EPM 10.1, BI 7.3, SAP BEx Analyzer, ABAP/4 Development Workbench, FI/CO

Confidential, Fremont, CA

SAP BPC BW Lead

Responsibilities:

  • Designed and developed Aggregation Levels, Planning Functions, Planning Filters, Planning Functions,Planning Sequences and Bex Reports
  • Designed and developed VBA needed for customization and validation of AO Workbooks
  • Developed BADI’s, Start Routine, End Routine’s and ABAP needed for Planning and Reporting
  • Designed and developed Composite Provider, ADSO required as part of reporting
  • Developed Interfaces from SQL to SAP HANA and BW/BPC using remote sources
  • Created custom planning types using IP and Hana procedures
  • Worked extensively on input ready queries and AO workbooks
  • Created new planning type to lock / unlock data based on the type and source of data
  • Developed macros in VBA to call planning sequences at the click of buttons
  • Debugged issues in business logic done in Fox code
  • Developed various HANA Information Models Attribute View, Analytical View, Calculation View, SQL scripts required
  • Designed and developed Planning Cube, Aggregation Levels, Planning Filters, Planning Functions, FOX formula and Planning Sequence
  • Designed and developed complex Bex Queries required for planning using inverse formula and disaggregation features.
  • Designed and developed AO workbooks using Bex Queries, Complex VBA and AO Functions.

Environment: BW, EPM 10.1, BI 7.3, SAP BEx Analyzer, ABAP/4 Development Workbench, FI/CO

Confidential

Principal Consultant / Architect

Responsibilities:

  • Development and Enhancement of P&L Planning / Forecast Model
  • Developed logic for Company and Currency Allocations using a combination of script logic and Custom Logic BADIs
  • Developed Transformation Files, Conversion Files and Packages required for Extraction, Transformation and Loading of data.
  • Integration of BI Infoproviders with BPC Applications - designed and developed transformation files, conversion files to load data from BI to BPC
  • Developed Allocations and other logic for Department Spend and Capex models
  • Developed write-back BADIs with Custom ABAP for initialization of plan and forecast data based on user selected version of data (actuals or plan)
  • Maintained Ownership and Rate model required for Consolidations
  • Developed script logic and complex BADI code to copy and roll-up data from one application to another
  • Developed Input schedules for allocation percentages and plan/actual comparison reports for P&L, Balance sheet and Capex/Opex
  • Involved in Project Management activities such as estimation of effort, planning, delivery, trouble shooting, and people management
  • Involved in preparation of test scripts, unit testing and string testing, user acceptance testing and post go-live support
  • Post-production support

Environment: EPM 10, BI 7.3, SAP BEx Analyzer, ABAP/4 Development Workbench, FI/CO

Confidential

BI BPC Integration Architect

Responsibilities:

  • Design and development of data models for Financial Planning and Reporting
  • Automation of Inbound Transactional data and Master Data for Financial Planning Model
  • Retraction of Budget data from BPC to ECC using a completely customized process - Retraction for both Cost Center Accounting and Profit Center Accounting Modules.
  • Developed a Fully automated Custom Process for retraction using BADIs and Remote Function Modules
  • Developed Transformation Files, Conversion Files and Packages required for Extraction, Transformation and Loading of data.
  • Integration of BI Infoproviders with BPC Applications - designed and developed transformation files, conversion files to load data from BI to BPC
  • Developed several BADIs for CYNI, Master data automation, direct and indirect allocations
  • Involved in preparation of test scripts, unit testing and string testing, user acceptance testing and post go-live support

Environment: EPM 10, BI 7.3, SAP BEx Analyzer, ABAP/4 Development Workbench, FI/CO

Confidential

Sr. BPC Consultant

Responsibilities:

  • Lead Post-Production support of Financial Planning and Forecasting models
  • Enhancement of Financial Planning models to handle new Allocations models and conversions
  • Worked on conversion of script logic to BADIs for performance optimization
  • Co-ordinate with offshore and Basis teams to handle Production issues
  • Worked in support, Data loads, Validation and trouble shooting of transaction data and Master data, Change management, Transport Management, Roles & Security, System Checks, Performance tuning and process chains.

Environment: EPM 10, BI 7.3, SAP BEx Analyzer, ABAP/4 Development Workbench, FI/CO

Hire Now