We provide IT Staff Augmentation Services!

Senior Sap Bpc Lead Analyst Resume

2.00 Rating

Washington D, C

SUMMARY

  • Around 9 year’s experience in SAPBW / BI, BPC, SAPABAP, SAP Business Objects (BO), SAP HANAwhich includes 5full Life Cycle Implementationsand Production support following ASAP methodologies in various domains like Retail, Travel,HealthCare, Oil&Gas, Chemical, Telecomand Manufacturing. Extensively worked in the areas of Sales and Distribution (SD), FIORI,Finance (FI) and controlling (CO)and have in - depth business process knowledge.
  • Strong experience in Data Warehousing, Business Intelligence concepts & implementation.
  • Experience in leading Global SAP BPC (Planning and Consolidations) Projects as a Lead consultant and Solution Architect
  • Successfully lead Complex BPC Planning and Business Consolidations, OPEX and CAPEX Planning, HCM Planning, Profitability Planning, Cost Center Planning, Long Range Planning, Budgeting and Forecasting projects for various clients within timelines and under budget
  • Expertise in building Integrated Planning (IP) scenarios. Creating Planning Functions, Aggregation Levels and Real-time Cubes
  • Experience in designing the key financial statements - P&L, Balance Sheet and Cash Flow reports and Input Schedules in BPC 10.1
  • Extensively worked in resolving the system inconsistencies/issues with BPC 10 version and resolved key issues.
  • Extensively worked with key Finance business leads and Executives to define the Planning and Consolidation design and reporting requirements.
  • Extensive experience in developing data models inNative HANAand experience in writingStored Procedures in HANA using SQLScript
  • Excellent understanding of Real Time Consolidations (RTC) process from accounting standpoint including GAAP and IFRS legal requirements.
  • Strong Experience in Performance Tuning and Query Optimization.
  • Good Knowledge of HANA XS, JavaScript and developing User Interface with SAP UI5.
  • Extensive experience in using SAP BODS (Business Objects Data Services), SLT and SDA (Smart Data Access) to extract structured/unstructured data from different source systems into HANA
  • Strong experience in Business Objects 4.0/XI 3.1/XIR2/6.x/5. x.
  • Strong experience in Business Objects data services/Integrator XI/3.2/4.0.
  • Proficient in Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 2008/2005/2000/7.0 , (database triggers, materialized views, Packages, stored procedures, functions, and database constraints), SQL Loader, SQL*Plus, SQL Navigator, PL/SQL and oracle DBMS Packages, oracle supplied utilities
  • Expertise in building the Reporting Applications from scratch with OLAP/OLTP environments.
  • Expertise in Installation, migration, maintenance, troubleshooting and overall administration of the Business Objects Suite. Involved in conducting strategic evaluation (Proof of Concepts) of the use of Business Objects XI R3.1/R2.
  • Enhanced BI/BW objects such as InfoObjects, Transformations, DTPs, InfoProviders (DSOs, InfoCubes, and MultiProviders), and Process Chains.
  • Experienced in ETL Methodologies using Business Objects Data Integrator/ Services XI 3.1 with Data Quality & Rapid Mart and worked on Metadata Integration (BOMM-Business Objects Metadata Manager) and EPM (Enterprise Performance Management)
  • Extensively worked on creating complex workspace and analysis of data using OLAP reporting tool Voyager.
  • Extensively used Business Objects reporting functionalities such as MasterDetail, Slice and Dice, drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
  • Expert in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test (UAT) and data accuracy test.
  • Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.
  • Extensively worked in Crystal Reports for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, drilling reports, analysis reports, data reports along with Dynamic LOV using Business View Manager.
  • Have good hands on experience in ETL and Data Cleansing applications using Infomatica Power Center, Oracle Warehouse Builder, Data services/ BODI, and PL/SQL.
  • Ability to analyze existing systems, conceptualize and design new ones, and deploying innovative solutions with high standards of quality.

TECHNICAL SKILLS

ERP Packages: SAP ECC 6.0, R/3 4.6

Expertise: Programming, problem solving, Design patterns, Research and development, Mentoring/Training, Testing

SAP Modules: BW, HANA, BO, BI-ABAP, SD, FI/CO, SAP FIORI, S4 HANA 1610 version

Databases: HANA 1.x, Oracle 11g/10g/9i/8i/8.0, MS SQL Server 2000/7.0, MS Access, DB2, Teradata

Skill Versions: SAP BI-BW - 3.5, 7.0, 7.3,7.4, 7.5 (on HANA) SAP BO - 3.1,4.0 SAP BPC - 7.5, 10.0, 10.1 (on HANA) SAP ECC - 4.6,5.0,6.0 SAP HANA - 1.5 SAP NetWeaver - 2004S

PROFESSIONAL EXPERIENCE

Confidential, Washington D.C

Senior SAP BPC Lead Analyst

Environment: SAP ECC 6.0, SAP BW 7.5, and SAP BPC 10.1 NW

Responsibilities:

  • Extensively worked with key Finance business leads to define the financial planning design and reporting requirements.
  • Research and analyzed project data necessary for project planning and reporting.
  • Established and maintained strong relationships with functional team members to align objectives, resources and expectations.
  • Developed custom solutions including, appending DataSources, creating generic DataSources, creating InfoObjects, InfoSources, ODSs, MultiProviders, InfoSets and InfoCubes, Transfer rules / Update rules, Data Transfer Processes.
  • Worked with SAP BI Tools, building reports using Query Designer/BEX and building reporting applications using Business Objects Design Studio
  • BW Administration including troubleshooting data load issues, managing aggregates and indices, creating and maintaining process chains, in order to support established SLAs.
  • Worked on creating planning functions and planning sequences required for a given planning scenario.
  • Recommended process improvements within change management, training, and organizational management.
  • Creating Planning areas and defining Sales and operations, OPEX, and HCM.
  • Conducted various design sessions for understanding the Planning needs and converting the requirements to functional/technical requirements.
  • Defining planning area, planning levels, key figures, versions, and master data types and attributes for planning.
  • Extensively worked on Integrated Planning (IP) scenarios. Created Planning Functions, Aggregation Levels and Real-time Cubes
  • Knowledge in using Business Rules & Script Logic for COI and Inter Company transactions.
  • Created complexJobs, Work Flows, Data Flows, and Scriptsusing various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
  • Preparing Master data and transaction data uploads for different Dimensions from ECC - BW -BPC
  • Developed EPM Excel Reports to create Sales Plan and Report Expenses Data on periodical basis on the web.
  • Configured secured Dimensions and Security Concepts. Extensively worked on analysis authorization, restricting the users as per the data access granted to them
  • QA and release management of new and existing changes to applications through thorough testing, debugging and user acceptance before planning and executing deployment into Production.
  • Executed Test Management, execution and control. Provided post implementation support and troubleshooting.
  • Developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge
  • Involved in team formation, knowledge transition, technical guidance and client communication.

Confidential, Hilmar, CA

Senior SAP BW-BPC Consultant

Environment: SAP ECC 6.0, SAP BW 7.5, and SAP BPC 10.1

Responsibilities:

  • Responsible for Conducting workshop with respective stake holders to understand the As-Is process.
  • Design a feasible solution on the agreed requirement
  • Successfully implemented Business Consolidations project
  • Data collection includes flexible upload, load from data stream and periodic copy methods.
  • Worked with business to support resolving key issues with the automatic Consolidation Tasks which Includes...
  • Balance carry forward
  • Currency translation (which translates the financial data into the currency of the consolidation group) and rounding
  • Validation
  • Preparations for consolidation group changes
  • Inter-unit eliminations (for accounts payables and receivables, revenue and expense) and reconciliations
  • Designing and creating BPC data models to support consolidated reporting requirements.
  • Designing, developing, andimplementing business intelligence, business data warehouse, and financialreporting solutionsSAP S4 HANA, SAP HANA Live, SAP BW on HANA, andSAPBusiness Objects clients, including SAP Lumira, Web Intelligence(Webi), SAP Design Studio.
  • Designing and developing ETL SAP dataservices job flows to extract and load from flat file, SQL Server, and SAPsystems into SAP HANA.
  • Develop complex reports and Input templates.
  • Created Business process Flow, BPC security, BADI, Data Manager Package, Work status.
  • Created business rules and script logic to manipulate the data as required.
  • Designed EPM templates keeping in view of the clients existing reporting format
  • Design the system standards of delivery to comply with the Industry best practices
  • Managing the delivery, deliverables within the agreed time lines
  • Responsible for delivering OPEX and HCM solutions allowing business to perform financial planning.

Confidential, Houston, TX

SAP BI/BPC/HANA Consultant

Environment: SAP ECC 6.0, SAP Native HANA, SAP BI 7.4, SAP BO 4.0,SAP BPC 10.1, BPM, SAP FIORI

Responsibilities:

  • Working very closely with internal client team as well as with the implementation team.
  • Successfully delivered blueprinting, requirement gathering, design, strategy and eventually the build of SAP BW, BPC and HANA implementation.
  • Will be leveraging SAP BW with BPC alongside HANA and also installing SAP HANA studio and HANA Live
  • Experience in Understanding the Business requirements & convert them into Blueprint
  • Experience in Defining the Design Documents for the HANA Models
  • Experience inEssential Configurations for SAP ECC Accelerations using SAP HANA
  • Experience in Translating Functional Specifications into Technical Specifications
  • Experience in Translating the Business KPIs into HANA & Define the Reporting Layouts
  • Translate the Business KPIs for Dashboards & Define the dashboard Layouts
  • Analyzing the requirement gathering document and preparing the detailed design document for Planning and Forecasting functionalities.
  • Design OPEX and CAPEX Planning, Budgeting and Forecasting,Consolidations Model, Ownership, Rate and their respective dimensions.
  • Loading transactional, Master and configuration data from ECC using standard extractions as well as file interface using Data Manager Packages with transformation and conversions.
  • Worked extensively with Data Manager Packages, process chains, standard functions like copy, delete, and allocations and user defined logic for planning and allocations at dimensions level.
  • Load Master and Transaction Data from ECC - BW -BPC
  • Develop EVDRE & EPM Excel Reports to create Sales Plan and Report Sales Data on periodical basis on the web.
  • Defining the Metadata Import process.
  • Data integration mainly with SAP HANA area and data provisioning using SDI/SDQ
  • Understand & Configured client requirement for Applications and Dimensions and Customized
  • Understand & Configured client requirement for Applications and Dimensions and Customized validations, Custom Process types
  • Configured Business Process Flows -BPF
  • Prepared Simple & Complex EVDRE reports using Dynamic templates
  • Prepared Complex Input forms
  • Preparing Master data uploads for different Dimensions through flat files with the Transformation files.
  • Knowledge in using Business Rules & Script Logic for COI and Inter Company transactions,
  • Configured Secured Dimensions and Security Concepts
  • Knowledge on debugging the Validations in the backend and understanding of SQL Server Management Studio database table files.
  • Strong experience in usingBODSas an external system for ETL betweenECCandBI.
  • Created complexJobs, Work Flows, Data Flows, and Scriptsusing variousTransforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
  • Strong experience in cleansing the data usingData Qualitytransforms.
  • Authoring Presenting Business Cases, Investment Areas, and Consultantural Views to demonstrate value of technology/initiatives.
  • Articulated complex BPM process issues to all levels of the organization.
  • Lead and facilitated interview sessions with process owners and the ability to summarize information into both quantitative and qualitative models.
  • Designed and developed enterprise workflows in the SAP BPM tool (Process Orchestration Suite). This includes integrating between a SAP systems and Non-SAP systems
  • Building SAP HANA Strategy& Managing a team of Consultants and developing a go-to market strategy for SAP HANA including demand generation, marketing propositions.
  • Pre-sales Specialist with knowledge on strategic SAP Native HANA/BW implementations.
  • Propose unique strategy on adopting HANA, more specific to customer Business case
  • Ability to Re-Consultant the current BI solution with SAP Native HANA as Database, BW as EDW layer & BO BI as Analytics solution.
  • Having expertise in delivering HANA projects like BW on Native HANA Implementations,
  • Adopt and follow SAP’s roadmap on various products like Design Studio, Predictive Analytics & SAP Lumira.

Confidential, Houston, TX

SAP BI/BW /BPC /HANA Consultant

Environment: SAP ECC 6.0, SAP HANA, SAP BI 7.3,SAP BO 4.0, BPC 10.0, SAP FIORI

Responsibilities:

  • Developing planning and consolidation reporting
  • Settings up hierarchies for dimensions like Time, Entity, Customer and plants
  • Building logic scripts files for planning scenarios at customer, plant, entity levels and currency conversions, adjustments, rollover forecasts
  • Settings work spaces, teams, users, access profiles for user specific authorizations
  • Building Business process flows for data preparations, data analysis, scenario analysis, reporting, planning, variance analysis
  • Input forms for adjustments, planning using planning functions like spreads, weight, Trend
  • Journal postings for differences
  • EPM reports for scenario analyses like actual, planning, variance.
  • Documents, Member formulas, setting up Drill through capability to BEX
  • Identifying underlying BW, HANA repository objects for each BPC objects and documenting
  • Working with consolidation, inter-company eliminations, intercompany consolidations, ownership calculations
  • Developing planning and consolidation reporting.
  • Worked as Solution Consultant with progressive experience in Design/Development and Consulting in SAP specializing in SAP HANA 1.0 SP06, SAP Net Weaver Business Warehouse & Business Objects Reporting Tools.
  • Experience in SAP BW/BOBJ with subject matter expertise in Business Intelligence domain integrating to SAP HANA.
  • Experience includes end to end Implementations, support and upgrade; roll up projects as well as solution consultant and Pre Sales.
  • Data Provisioning using FLAT FILES and SDI.
  • Preparation of data, designing and implementing HANA analytical models, data provisioning into HANA tables, and designing and implementing BO reports on HANA data.
  • Data Provisioning using BODS 4.0
  • Building Data Flows in Designer (to Load the Data to SAP HANA)
  • Data Modeling
  • Creating Attribute Views, Analytical Views, Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios
  • SAP HANA SQL
  • HANA, Reporting Layer
  • WEBi 4.0 on HANA
  • Migration of BW to HANA.
  • Migrated HANA content from development, testing environment to Production environment using delivery units.
  • Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
  • Worked on creating Data Models - Creating InfoObjects, Datasource, Infopackage, DTP, Transformations, DSO, Infocubes, Multi providers etc. and optimized the relevant objects for HANA in accordance with LSA++ Consultanture.
  • Worked in ABAP routines - Start routine, End routine, field routine and Expert Routines in transformations - written codes for master data look-up, filtering data based on complex conditions, used function module for various conversions, etc.
  • Created Transient Providers, Composite providers to import native HANA models to BW and also exported cubes to HANA Studio to leverage HANA optimized BO reporting tools.
  • Created Open Hub Destination to load the BW data to 3rd party system.
  • Created, published and scheduled reports as per requirement on BO OLAP analysis, Explorer and Webi.
  • Implemented cells, workbooks and OLAP variables (Customer exits, formula variables etc.) in BEx.
  • Created and scheduled Master data and Transactional Data chains to automate data load process.
  • Extensively worked on Business Objects (BO) integration with BW for reporting requirements.
  • Extensive experience on developing Web Intelligence Reports and Crystal Reports.
  • Experience in Business Objects universe designing (OLAP Universes), Business Objects Web Intelligence (Webi), Business View Manager, InfoView, and Business Objects Enterprise (BOE).
  • Created Functional Designs and Technical Design documents based on real-time report
  • Requirements to be implemented on HANA enterprise along-with requirements of accelerated BW based reports.
  • Worked on data provisioning from Teradata systems using Data Services and from SAP ECC using SLT servers.
  • Worked on creating Attribute views, Analytical views & Calculation views based on requirements and data-warehousing standards.
  • Worked on SQL based authorizations and CE functions.
  • Worked on row level authorizations & hierarchies.
  • Created trend reports by combining imported SAP BW data models (InfoCubes) with historical data and real-time data from HANA models.
  • Consumed HANA models into Explorer, Advanced analysis, Crystal and Webi reports.

Confidential, NEW JERSEY, NJ

SAP BI/BW BPCConsultant

Environment: SAP ECC 6.0, SAP HANA, SAP BI 7.3, SAP BO 4.0, SAP BPC 7.5

Responsibilities:

  • Analyzing the requirement gathering document and preparing the detailed design document for Planning and Forecasting functionalities.
  • Managing Sales Model process and Reports for target business scenarios.
  • Building Integrated Financial Model, Ownership, Rate and their respective dimensions.
  • Loading transactional, Master and configuration data from ECC using standard extractions as well as file interface using Data Manager Packages with transformation and conversions.
  • Worked extensively with Data Manager Packages, process chains, standard functions like copy, delete, and allocations and user defined logic for planning and allocations at dimensions level.
  • Load Master and Transaction Data from DB2 on the mainframe and Oracle Databases.
  • Understanding and Implementing Confidential ’s Vistex solution in order to provide support to North American business users
  • Develop EVDRE & EPM Excel Reports to create Sales Plan and Report Sales Data on periodical basis on the web.
  • BPC Upgrade from 7.5 to BPC 10.0.
  • Utilized new BI 7.3, Dataflows, transformations and DTPs for all new developments.
  • Developed numerous custom datasources using database views and custom function modules.
  • Implemented new BI 7.3 security authorization objects.
  • Responsible for developing BI data models and designs, configuring custom and delivered BI content, analyzing BI reporting requirements, developing detailed reporting specifications.
  • Involved in activating Business Content for Standard Info Objects, DSO, InfoCubes related to FI, CO-PA, SD.
  • Experience in upgrading to BI 7.0/7.3 and in depth knowledge of migrating data sources from BW 3.5 to BI 7.0/7.3.
  • Involved in creating many complex OLAP variables, DTP routines.
  • Generated CO-PA redesign which involves addition of more fields with complete different flow and was involved in complete end to end testing for all the developments assigned.
  • Performed LO-Cockpit extraction for Sales Order, Sales Delivery, and Billingsby extractingStandard DataSources from the Business Content using LO-Cockpit extraction methods for Transactional data and enhanced them to meet the reporting requirements.

Confidential, Pittsburgh, PA

Sr. SAP Analyst

Environment: SAP BI 7.0, SAP ECC 6.0, FI, SD, MM, HR, BEx, Business Objects 4.0

Responsibilities:

  • Involved in full cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
  • Activated Business Content for Accounts payable (AP), Accounts Receivable (AR), General Ledger (GL), Cost Center Accounting (CO-CCA), Purchasing and customized them as per the client requirements.
  • Develop EVDRE & EPM Excel Reports to create Sales Plan and Report Sales Data on periodical basis on the web.
  • BPC Upgrade from 7.5 to BPC 10.0.
  • Help in Upgrade Strategy
  • Evdre Migration to EPM.
  • Create Budget Allocation Scripts for Sales Plans & Budgets.
  • Create Input Schedules to Input Sales Data
  • Create Journals to adjust data.
  • Create Transport from Dev regions to QA and Production.
  • Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Multiproviders, Info Sources, Info sets, Time dependent master data and also in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
  • Implemented FI cubes such as 0FIAR C02, 0FIAR C03, 0FIAP C03, and ODS such as 0FIAR O03, and 0FIAP O03 with proper transfer rules and update rules.
  • Extracted Master and Transaction Data from Flat files and loading into Info Objects, DSOs and Info Cubes.
  • Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC Generic Extractions and also in BI data modeling like Start Routines and End Routines.
  • Created Aggregates on Info Cubes to improve the query performance.
  • Created BEx queries for reporting on Info Cubes, Info Sets, ODS and Multi Provider.
  • Created calculated and Restricted Key Figures, Structures, Conditions, Filters and Cell Definitions within queries, maintained Query settings and tuning.
  • Migrated Data Sources from 3.x to 7.0. Modified the business content update and transfer rules to transformation rules.
  • Extracted Master and Transaction Data from Flat files and loading into InfoObjects, DSOs and InfoCubes.
  • Worked on FI - GL, FI-AR, FI- AP, FI- AA, COPA data sources for extraction and loading of data from FI to BW.
  • Creating queries for the cluster using Query Designer involving Calculated and Restricted KFs, different Variables, Conditions, Exceptions, Filters etc.
  • Created custom InfoCubes for company wide Sales, Delivery, Billing and Purchasing with various aggregate periods (business day of the year, business day of the month etc.)
  • Created and Maintained DTP and InfoPackage for Loading. Created, Maintained and Monitored Process Chains for periodic loads of Master data and Transaction data from ECC system to Data Targets using various process categories and process types.

Confidential, New Haven, CT

SAP Analyst

Environment: SAP Net weaver 04s (BI 7.0), ECC 6.0, CO, FI-GL, SD, BEx Analyzer.

Responsibilities:

  • Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
  • Interacted with the Business Users to analyze the business process and gathered the requirements.
  • Experience in SAP BPC 7.5,10.0 and 10.1 versions
  • Experience of upgrading BPC 7.5 system to BPC 10.0
  • Experience in building Environments, Dimensions, Models as per the requirements
  • Experience in building Non-Finance, Finance and Consolidation Models
  • Experience in building Integrated Financial models
  • Experience in writing script logic to perform on EPM templates as per the requirements
  • Experience in Dimension Formulas to maintain the master data as per the requirement
  • Experience in using predefined business rules and debug them
  • Experience in maintaining Work status for the models to control data into models
  • Experience in maintaining Business Process Flows to automate the process
  • Worked on SAP IP, BPS and converted reports from IP, BPS to SAP BPC Reports.
  • Experience in migrating the models to quality and production systems using Transport management system.
  • Experience in loading the transactional ECC data into BW cubes and then into BPC cubes
  • Experience in loading the master data from flat files and from third party system into BPC info objects
  • Designed functional and Technical specifications for Implementation and Development of BO XI R2 over SAP BI.
  • Involved in BW 3.5 to BI 7 upgrade processes and was responsible for design, development and extraction from R/3 Source system and flat files to BW for FI & CO.
  • Extensively worked on SD InfoCube 0SD C03 and data sources 2LIS 13 VDHDR, 2LIS 13 VDITM, 2LIS 13 VCITM and financial data providers, multi provider’s 0FIAP M40 data sources 0FI GL 40 according business needs in SAP BI.
  • Involved in development, integration testing, UAT to Go live production support of OTC, RTR reports.
  • Created new info providers in SAP BI depending upon the end user needs.
  • Developed extract structures and Data Sources in Financial Accounting to facilitate the data extraction to
  • Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC generic extractions and also in BI data modeling like Start Routines and End Routines.
  • Extensively worked on BEx reporting and workbooks using RRI, cell definitions, variable offsets, exceptions, conditions.
  • Master and Transaction Data extraction from Flat files and loading into Info Objects, DSOs and Info Cubes.
  • Performed analysis, design, development and implementation of standard/customized Info Cubes and DSO Objects for SD, FI and SCM modules.

We'd love your feedback!