SUMMARY:

• 10+ Years of experience in SAP which includes BPC Optimized for S/4 HANA, Embedded Analytics such as SAP HANA, SAP BW, SAP BPC(Standard & Embedded), Business Objects (BO), SAP ABAP along with extensive experience on areas of Sales and Distribution (SD), Finance and controlling (FICO), COPA, SRM, CRM, HR, PP, Materials Management (MM), Inventory Management (IM) and Warehouse Management (WM) and have in - depth business process knowledge.
• Successfully led multiple BI teams and implemented several multi-million dollar S/4 HANA Simple Finance/IBPF,Enterprise Hana,(Integrated Business Planning),SAP BAIS,SAP BW,Business Objects (BO),( SAP FIORI,TABLEAU, Design Studio,),SAP BPC,SAP ABAP.
• Experience in S/4 HANA (1503/1511/1610/1702 ), Enterprise HANA, BW on HANA and Hana Live, SAP BW,Data Conversion, SAP BODS 4.0, 4.1, SAP Business Objects 3.1, 4.0, 4.1, TABLEAU, Design Studio, SAP FIORI, SAP BPC 7.5, 10.0, 10.1 with 4 Full life Cycle Implementations, Integrated Business planning(SAP BI-IBP-HANA PAK).
• Successfully SAP BPC/BI/HANA using SAP Activate, ASAP, and Agile methodology. Proactively supported many projects in different phases of life-cycle including business requirement gathering, business blueprint, architect design and solution, data modeling,Cut-over Strategy, UAT testing, post production support, and business user training.

AREAS OF EXPERTISE:

SAP BPC:

• Experience in SAP BPC NW (Classic, Embedded), BPC OPTIMIZED FOR S/4 HANA/IBPF(1610).
• Worked on leveraging HANA views for real time data consumption from ACDOCA tables of S4HANA (Transaction & Master data)
• Worked on Financial & Sales Planning, CAPEX, OPEX, Head Count Planning, Cost Center Planning, Profit Center Planning, Treasury Planning, HR Planning, Management and Legal Consolidation, Generating Financial Statements, Collection & Distribution and Management & Statutory Reporting
• Writing functional requirements and associated test cases. Designed and implemented applications for Planning, Reporting, Budgeting, Forecasting, Consolidations.
• Provide gap analysis and document the BPC solution options, recommendations and implications
• Defined and configured Appsets, Dimensions, Dimension Members and their properties, Non Finance, Finance, Consolidation and Integrated Finance Models as per requirement
• 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
• Experience in configuring Transformation files, Conversion Files and Data Manager Package
• Created Reports and Input Schedule using EPM Excel Add in.
• Experience with configuring Input Schedules on Rolling forecasts and budgets
• Advanced VBA expertise in reporting for custom formats and dynamic updates
• Experience with Inter-Company Eliminations, Currency Translation and Balance Carry Forward
• Experience in installing and customizing the IFRS/GAPP kit
• BPC Security Configuration, Creation of member access profile, Task profile creation, Team creation and Full integrations

SAP BW:

• Experience in Multi-dimensional Model in SAP BI.
• Hands on experience with creating Composite Provider, ODS View, ADSO, Info Cubes, Info Objects, ODS Objects, Data Sources, Info Packages, Process Chains, DTP, Transformations, Activating & Enhancing Business Content, Routines (Start, End & Expert ), Open Hub service etc.
• Extensive Experience on Data source Enhancement & Extraction using USER EXITS and BADI.
• Designed queries in BEx Query Designer and created workbooks in the BEx Analyzer using conditions, structures, calculated and restricted key figures, character variables, formula variables and text variables.
• Extensive Experience in data extracting in CRM,SRM,APO,LO Cockpit, OTC,CO-PA, FI (AR, AP, GL) and HR(HCM) data into BW.
• Experience on Performance Tuning and using BW Statistics, Improved query performance by creating Aggregates, Compression, Partitioning, Indexes, deleting indexes, Data packet size, Number Range Buffering, & DTP Settings.

SAP FICO:

• Worked in the areas of GL, AP, AR & AA in Finance Module and CEA, CCA & PCA in Controlling Module
• Successfully demonstrated and configured SAP FI-GL, FI-AR, FI-AP, FI-BA, FI-AA, Cost Center Accounting, and Profit Center Accounting during implementation.
• In Profitability Analysis (CO-PA): created the Operating concern, configured costing based profitability analysis. Defined and configured the reporting characteristics, value field, profitability segments used in profitability analysis configured the derivative structures and rule for characteristics. Defined both basic reports and form reports for the business units by profit centers to analyze the profit at customer and product levels.
• Product Costing (COPC): Configuring material cost estimate with and without quantity structure, maintained settlement structures, configuring variance calculations and WIP calculation, integrating COPC with SD, MM and COPA, cost variants, valuation variants
• Having good exposure to All major business processes like Dunning, Automatic Payment program, Depreciation, Interest Calculation, Taxes, Procure to Pay (P2P), Order to Cash Cycle (O2C).

SAP HANA:

• Data Provisioning:
• Experience in Loading the Data from different files (Text files, spread sheets, XML files and COBOL copybooks), SAP ERPS (like ECC, CRM) to SAP HANA using SAP BODS
• Experience in Loading the Data from different using SAP BODS to DSAP HANA for COPA Scenarios, FI Scenarios, Sales Scenarios, Purchasing Scenarios, Marketing Scenarios and Opportunity Scenarios and Service Scenarios.
• Experience in Loading the Data from SAP BW 7.3 to SAP HANA using SAP BODS (Open Hub Tables, DSO tables etc).
• Experience in Replicating SAP system tables with SLT and in Real-time replication from ECC to HANA with SLT
• Data Modeling
• Experience in Creating an attribute view, analytic view and calculation view
• Experience in Creating Attribute Views with Hierarchies, Using Variables with Analytic views
• Experience in Calculated columns in an Analytic view and an Attribute View
• Experience in Using Decision Tables with update values and return values
• Reporting
• Experience in HANA, Reporting Layer and Connectivity options, SAP Business Objects BI 4. 0
• Experience in Designing Complex Universes in IDT based on HANA Tables and HANA Views.
• Experience in WEBi 4.0 on HANA, Crystal Report for Enterprise with HANA
• Experience in Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0

SAP ABAP:

• Extensive experience on ABAP Skill set Like BAPI, BADI, SMARTFORMS, Routines, SAP Script, ALV Reports, User Exists, Enhancement Frameworks, Remote Function Calls (RFC),ALE, EDI and IDOC’s .
• Experience in Performance Tuning Tools like Runtime Analysis, SQL Trace.
• Good Experience with handling of background (batch) programming, Debugging Tool and Module Pool Programming.

PROFESSIONAL EXPERIENCE:

Confidential, Greensboro, NC

SAP BPC/BW/S4HANA/ABAP Consultant

Responsibilities:

• Supported and conducted initial triage for SAP BPC 10.1 (Embedded) cross-functional issues. Served as a technical liaison between the business and user side and maintained user accounts and permissions.
• Worked on SAP S/4 HANA Optimization Blueprint
• Worked Closely with BPA’s and FRA Teams, gathered details and Created User Requirement Specification, Functional Specifications and Detail Design Document.
• Responsible for all technical and various functional activities related to BPC 10.1 (Embedded) Design Hands on configuration of application objects Delta initialization, Custom measures and Complex reporting Creating aggregations, queries, data flow between cubes and building templates.
• Development of SAP IP/SEM Business Rules/LOGIC using BW/ABAP Worked extensively BEx and Analysis for office(AO) for Style Sheets and created a template with Company’s logo and executed planning functions like Copy, Move and custom planning functions using Fox formula using Analysis pane and also using VB Macro buttons
• Involved in the process of conducting Inventory, MRP, Purchasing, Quality, Production and Logistics process improvement workshops, document technical requirements, establish data governance organization, cleanse data and develop the implementation plan for BI.
• Architected and Developed FIORI Apps for the S/4 HANA Simple Finance Applications Such as Accounts Receivable, Accounts Payables, Cash Management, Asset Accounting.
• 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 HANA/BW implementations.
• Propose unique strategy on adopting HANA, more specific to customer Business case
• Ability to Re-architect the current BI solution with SAP HANA as Database, BW as EDW layer & BO BI as Analytics solution.
• Experience in Implementing AP/AR Accountant & Cash Manager in S/4 HANA 1511/1603/1610 Simple Finance Add-on 1.0/2.0
• Experience in Implementing Collection Specialist, Cost Manager, GL Accountant, Accounting Information for Managers & Sales Manager
• Experience in SAP Fiori for the SAP Simple Finance Add-On 1.0.
• Experience in Knowledge of country specific FI localization
• Experience in SAP Fiori productivity apps including corresponding SAP backend configuration
• Worked in locking of data using input schedules using Restricted Key figure in 10.1 embedded version.
• Successfully completed 2 Parallel runs with approximately 500 users testing simultaneously the solution Development of Reports and Templates, Configuring and setup of Business Rules and Fox formula.
• Security Sync for BPC and HANA by importing security tables to HANA by creating Analytical privileges.
• Worked on various HANA Modeling tasks like Creating an analytic view, Creating a calculation view, Creating Attribute Views with Hierarchies, Experience in Using Create View GUI, Created Calculated Columns in an Analytic view and Attribute View.
• Worked on Decision Tables with update values and return values as well as calculations in Columns and views.
• Reconciling the data of SAP BPC Consolidation and Planning Extracts with SAP BI and ECC applications.
• Worked on Consolidation Business Rules & logic, such as Copy Opening, Currency Conversion, Intercompany Matching/Elimination, and Account Transformation Used script logic for currency conversions and maintained security set up (task profile, member access profiles, users and teams), work status settings, Business Process Flows (BPFs).
• Create/Change BADI’s, Data Manager Packages, Package Links, etc.
• Built an Utility based on VB Script (Excel Macro), using which users were able to migrate hundreds of Adhoc reports from old connection to new connection.

Environment: SAP BPC 10.1 Optimized for S4 HANA, S4 HANA Simple Finance, BW7.5, ABAP, HANA, Remedy, SharePoint, BEx, Dashboard.

Confidential, Beaverton, OR

SAP BPC/BW/HANA/ABAP Consultant

Responsibilities:

• Worked on SAP BPC Data Modeling, Data Manager Packages, Script Logic, Process Chains, Dynamic Reports and Input Schedule Templates.
• Created Environments, Models, Dimensions, Reports, Input forms, Logic Script, Business Rules for Currency Translations and Creating and Modifying the Flat and Hierarchical dimensions.
• Worked on CAPEX Depreciation calculation and the data flow to the financial statements.
• Worked extensively on CAPEX planning for new and ongoing projects by asset class level. Straight line depreciation method was used for determining planned depreciation for new investments. Which also includes IT project capex and Non-Project CAPEX.
• Handled the Revenue, CAPEX, OPEX and procurement planning models independently.
• Setting up environment & model, Creation of Dimensions and Master Data Updating.
• Designing, implementing, managing BPC (Business Planning and Consolidation) solutions and running them optimally.
• Maintaining Dimension Members and its Properties such as Formula, Owner, Reviewer...etc.
• Involved in Preparation of Financial Statements
• Developed Actual and Consolidation Reports in BPC from Hyperion Retrieves.
• Developed BPC Legal & Management Console Model Reporting.
• Created Data manager packages for Currency Conversion, Consolidation, and flat file import.
• Worked on Intercompany accounting and legal consolidations
• Interco Elimination journal entries in consolidation system.
• Developed Dimension formula in C ACCT dimension in Legal Application for consolidation process.
• Involved in development of BADI’s for doing calculations and postings from a different models
• Transportation of Objects from Development Environment to Production Environment.
• Set up the security to all the Business users based on their role in the organization’s business process flow by maintaining appropriate Task profiles & Member Access Profile
• Audit configuration to track changes of BPC objectives.
• Creating input schedules and report as per the standard defined.
• Built input schedules based on the existing input schedules in Hyperion/ Essbase.
• Uploading of Transaction Data through Flat File.
• Creation of Transformation files and Data Manager Pkgs.
• Configuring Work status and User Security.
• Configuring Business Process Flow (BPFs).
• Worked with the business user, MOM preparation, Maintenance of the user files in central repository, Updation of Daily Activity Tracker of the team, Keeping track of object inventory, Following up with the sub-tracks progress and Conducting UATs

Environment: SAP BPC 10.0 NW, BW7.3, SAP ECC,FICO, MM, SRM, Hyperion, Remedy, HPQC.

Confidential, Minneapolis, MN

SAP BPC/BW/HANA Consultant

Responsibilities:

• Worked on SAP BPC 10.1 Standard NW.
• Build/Migrate Report and Input Schedule templates using EPM Add-In.
• Create & Deploy VB code in the Input Form/Report Excel Template.
• Initiated the OPEX Planning: - Loading the previous year data & copy the current year data, and implemented the OPEX Planning using BPC tool which facilitates the input of Operating
• Expenditure and Operating Revenue budget by cost center. Line items aggregated from cost center flow into account code before they can be viewed in financial reports.
• Created OPEX Planning Reports and input schedules. The key planning requirements under the following major heads
• Analyze performance indicators to locate problems with code and recommended corrections.
• Consult with managers/users to determine to achieve optimal efficiency of SAP BPC system within the company.
• Create/Change Script Logic files, BADI’s, Data Manager Packages, Package Links, etc.
• Expertise in Data Modeling, which include Info cube design, Operational Data Storage,
• Info Source, Transfer rules, Update rules, Info sets, Multi providers etc
• Enhanced the data sources by using the ABAP code and ensured it met the client requirements.
• Applied the Start routines, End routines, Field routines, and expert routines as and when necessary
• Expert on leveraging of Business Content Objects
• Worked on Logistics extraction in modules like sales and distribution, finance, inventory etc.
• Creation Generic Extractors using table, view and Function modules
• COPA: GR55 and KE30 comparison, Profit Center Creation, maintain hierarchy.
• Create GL, element and assignment to COPA and GR55, values flow from SD, MM, FI
• Maintain COPA derivation rules, create Characteristics, reconciliation with FI reports, KE21n, KE24,KE30
• Experience in filling of the set up tables for enables the delta initialization and for Full loads
• Extensively involved in extraction of Master and Transaction Data from both SAP Systems, Non SAP Systems
• Assisted with performance tuning of Report/Input Schedules.
• Raising OSS message with SAP AGS and coordinating within different teams to resolved the issues
• Carry out requirement gathering, GAP Analysis and solution design with clients
• Develop, document and revise system design procedures, test procedures, and quality standards.
• Used BPC Server Manager to move the appset from one environment to another
• Monitoring system & application performance using Management Console. Other activities included optimization of the application
• Created transformation files and conversion files for loading. Also used the start/End routines in the transformation. Used java script commands in the conversion files.
• Conducted UAT, implemented cutover, Delta loads leading to cut over and Go Live
• Created environment and 5 new Models in accordance with BPML
• Configured Base Security in BPC - complete with TASK & ROLE Mapping document
• Created 15 new Dimensions to be used throughout the 5 new Models in DEV, QAS, PROD
• Business Rules activities included Account Transformation, Inter Company Booking & Elimination, Carry-forward, US eliminations, Validation
• Client Interaction: Actively interacted with BPC application owner from the client side. The objective was to understand the new client need and provide them with solution and also evaluate the support status on weekly basis

Environment: SAP BPC 10.1NW, SAP ECC, FICO, MM, Maximo, IDT, Webi, Dashboard, Design Studio, Lumira.

Confidential, Cincinnati, OH

SAP BPC /BW Consultant

Responsibilities:

• Designed and produced BINI (BI Integration) power point presentation for corporate presentation detailing benefits of BPC10.1 versus the present BPC7.5 installation after making an in depth study of the BPC installation
• Key resource in explaining the benefits of using BPC - Consolidation module to be while maintaining Planning Module (Budget, Forecast, and Planning)
• Presented Timeline & Budget to "Steering Committee" and "Business" kicking off the project
• Identified key players and designed "milestones" for project roadmap
• Produced a Business Blueprint complete with project timeline and estimated cost
• Got Business Owner to sign-off on BPML - (Business Blueprint Master List)
• Produced a "Step by Step Installation" guide for BI/BW/BPC team to follow
• Monitored and hand held AMS-basis team during installation on new landscape including the critical post-installation steps of a NEW BPC10.1 installation
• Stabilized the existing BPC7.5 environment, resolved all issues, and optimized all applications before exporting Master & Transactional Data to flat files for loading into the new BPC10.1 environment and models
• Validated and checked new BPC10.1 environment delivered by Basis team. Validated (.\CPBM and.\POABC) directories for consistency and namespaces
• Validated SSO configuration - CMC, CMS, NetWeaver security profiles, task & roles for all users
• Configured Data Manager for new system (DM-Packages, updated links & configuration)
• Adjusted Script Logic and converted SSIS packages to PC (Process Chains)
• Created transformation and conversion files for Master Data upload into new system
• Worked on enabling the delta for generic extractors and load them into BW through info packages
• Performed the House keeping activities in BW
• Maintained the exchange rates in BW
• Created Exceptions, Conditions, Filters, Free Characteristics, Calculated Key Figures, Restricted Key Figures, Formulas, Report to Report interface
• Created the reports and publishing reports to the users using Bex broad casting
• Created the Naming convention document as per the project specifications
• Created the Process chain for daily, weekly and Monthly loads
• Experience on assigning Roles, creating authorization objects, roles
• Maintained the BW server on weekly basis by checking the table space, free space monitoring, batch jobs, missing indexes, system logs etc
• Configuration of Broadcast setting for report distribution/publication
• Created the costume variables using ABAP code in CMOD
• Validated and exported Master data from old BPC7.5Ms system to Flat Files
• Uploaded & populated Master data (Imported from Flat Files)
• Validated and exported Transactional Data from old BPC75Ms system to flat files
• Wrote transformation and conversion files for all 5 models and imported 2 years of historical + one year of current data into BPC10.1 new Models (175m records)
• Configured 'Work Status' for BPC10.1 environment
• Validated Security, 160 Users, Data Access Profiles, Tasks Roles from BPC-Sys Admin
• Exported 200+ reports and input schedules to new system and converted old EVDRE reports to new EPM report format
• Resolved issues and modified reports to work under the new EPM reporting tool
• Re-created 7 new BPF's (Business Process Flows) in accordance with Business needs
• Trained Business Super Users & IT on new system

Environment: SAP BPC 10.1NW, SAP ECC, Maximo, IDT, Webi, Dashboard, Design Studio, Lumira.

Confidential, Marysville, OH

SAP BPC /BW/HANA Consultant

Responsibilities:

• BPC support: Provided support to business user for three appset. These users were based in different locations. The user problem were related to application installation, security access, excel add-ins, appserver connectivity, data validation with source system, data loading problem
• BPC P&F lead of Onsite team to implement the EMP 10 tool in the existing BW system
• Input Template: Designed input template for Revenue, Expense, Budget, Short Range Planning (2 years), Long Range Planning (5 years), Head Count Planning, Position Planning
• Scheduling the Housekeeping activities like deletion of DM logs, audit logs, data files from UJFS
• Data Manager: Modified Data Manager Package to load data from staging table to BPC models
• Script Logic: Designed script logic for forecast adjustment and moving data from one application to another
• Allocation Logic: Designed allocation engine and script logic for corporate expenses
• Reports: Designed approx. 30 reports related to revenue by region, Profit Center, Company, region etc. These reports included both i.e. static report and dynamic reports
• Upgrading existing BW 7.3 to BW 7.4 and then migrating existing DB6 database to HANA database, fixing the ABAP code syntax errors caused by HANA migration
• Work Status: Used work status for tracking, locking and monitoring the job completion
• Worked on security set up. Creating task profiles, member access profiles to allow users to perform task and access assigned data
• Supported Consolidation team member with various Consolidation related activities i.e. creation of application, parameters setting and Business Rules
• Used SQL query statements to troubleshoot error related BPC and database. Similarly used MDX query statements for OLAP database
• Used BPC Server Manager to move the appset from one environment to another
• Monitoring system & application performance using Management Console. Other activities included optimization of the application
• Developing Input Schedules and reporting templates utilizing the new EPM 10 functionality
• Design and implementation of BADI's used for write back, calculate headcount fringe benefits, etc.
• Design and implementation of reports - web based and also in Data manager
• Implementation of OSS notes and works with SAP proactively on fixing the bugs in EPM 10
• Coordinating with Basis team on installing the EPM 10 in all the test systems and through with the implementation steps
• Troubleshooting BPC transports and mastered the issues frequently occurs in EPM 10
• Involved in the upgrade of BW on HANA and implementing the solutions for commercial and chain account planning in BPC on HANA environment
• Responsible for Data modeling in SAP HANA - Attribute views, Analytical views, Calculations views, Decision tables for new business requirements
• Responsible for Data provisioning in SAP HANA - SLT, BODS

Environment: BPC 10.0 NW, EPM ADD-IN, Jira, Remedy, HP Quality Center, Mule soft, JDA Supply Planning, Life Cycle Manager

Confidential, Providence, RI

SAP BPC /BW Consultant

Responsibilities:

• Dimension & Application: Processes 19 dimensions for Management Reporting. Created Dept App, HR, Consolidation and Rate application. The Consolidation application provided report on P&L Statement, Net Sales Value and included information on Sales Volume, Cost of Goods Sold (COGS), OPEX & other expenses
• Data Manager: Used transformation processes (Mapping, Conversion and Validation) to move data into BPC. Used BADI (UJD ROUTINE) to move Cost Center master data. Also modified data manager packages (Dynamic Script) to meet the client requirement
• Report: Organized data for approximately 20 reports on Revenue, Sales, COGS, OPEX, HR & other expenses for Corporate Power Users
• Other reports include Discounts, Prices, Rates, COGS, Expenses, Fixed and Variable Costs, Variances, etc.
• Wrote script logic for calculating and moving data from Consolidation to Dept App application. Used DESTINATION APP and LOOKUP for cross application logic
• Created Business Process Flows (BPFs) to monitor progress of users, send email notifications, and assure consistency and uniformity
• Work Status: Used work status for tracking, locking and monitoring the job completion
• Worked on security setup. Creating task profiles, member access profiles to allow users to perform task and access assigned data
• Supported Consolidation team member with various Consolidation related activities i.e. creation of application, parameters setting and Business Rules
• Business Rules activities included Account Transformation, Inter Company Booking & Elimination, Carry-forward, US eliminations, Validation
• Designed new Data Manager Package to run Allocation and FX Translation logic - activities include modifying and creating new prompt, radio button for selection
• Responsible for Optimization of Application on regular basis
• Extremely knowledgeable and an expert with BPC debugging tools like SLG1, script logic debugger, SE30-Run time analysis, ST03, ST22 trace, ST21 system trace, ST05 & ST01 RFC traces, UJFS traces, etc.
• Used extensively all the UJ* programs needed from verifying the master data, security, transport entries, UJFS files, etc.
• Production cutover task
• BADI's - Start Routine, End routine - BADI's for planning functions - BADI's for write back to DB
• Owner for the Design and implementation of BW Integration with BPC

Environment: BPC 7.5 NW

Confidential, Fort Worth, TX

SAP BPC /BW Consultant

Responsibilities:

• Worked on the SAP BW-SAP BPC Integration-Master Data Loads and Transaction Loads for Cash Flow Forecasting, Integrated Planning and Consolidation of Budget.
• Worked on developing BPC reports for Consolidation of actual & Cash Flow Forecasting and BPC Input schedules for consolidation of Budget
• Expertise in creation of Transformation and Conversion logic for data flow.
• Worked on BADI Implementation on Work Status to lock, approve and submit
• Created Process chains and implemented them in Data Manager Packages so that they can be triggered from the BPC environment and the complete flow of data happens as required.
• Worked on creating the Report specifications and Design documents
• Daily trouble shooting of Incidents, Implementing changes and requests.
• Involved in submitting the Ticket Status (open/close) report. Maintain Work History for all the Tickets until it is closed down.
• Develop custom data model using Info Objects, Info Cubes, Standard and Write- Optimized DSO, Info Sets and Multi providers.
• Used Delta Init, Full and Delta mechanisms for uploading data in BW
• Automated loading of data using Process chains which has Meta chains
• Played key role in Extraction of BW data to BPC as wells as retraction of BPC data to BW. Also automation of these activities
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains
• Worked on activating the Standard Business Content object like Info Cubes, ODS Objects, Info Objects etc.
• Writing ABAP codes for Function Module based extractors, Start/End routines and BAdIs.
• Performed Unit testing and Performance testing for all new developments.
• Constant interaction with the onsite team on all the requirements, Issues, changes and status updates.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Involved in creating UAT/BAT test scripts and Sessions with the analysts and given training

Environment: SAP ECC, BPC 7.0 NW, SAP BI7.0

Confidential

SAP BW Consultant

Responsibilities:

• Participated in the full life cycle efforts to design, analysis, Blue printing, technical specification, implementation, Go-Live and deployment of BW solutions and support processes
• Exposure to both BW 3.5 and BI 7.0 data flows
• Creation of process chains and scheduling according to the client requirement
• Monitoring the data loads and fixing in case of failure without affecting the business
• Successfully implemented solutions to frequently occurring problems like preventing LOCKING due to multiple loading to the same Confidential through process chains, avoiding data inconsistency
• Automated the month end activities that involves the master data load from different non-SAP source systems
• Extracted data from the finance modules like AR, AP and GL and enhanced the standard data sources 0FI AP 04, 0FI AR 04 to meet the client requirement
• Loading of transaction data to the business content Info Cube from Info Sources like 2LIS 11 VASCL, 2LIS 11VAHDR for sales, 2LIS 13 VDHDR, 2LIS 13 VDITM for billing, 2LIS 12 VCHDR for order
• Designed, built, tested, documented and maintained data extractors, transformations, DTPs, process chains, DSO Objects, Info cubes, and Multi-Cubes; coding in start routines and end routines
• Creation of different BEx queries and workbooks based on the user requirement
• Transporting the BEx queries and other BI objects from development to production
• Developed reports on the MM cubes to check the price variance for materials from different vendors
• Effectively Analyzed and Debugged the BI-ABAP programs used for the different transactions
• Arranged the L1 meeting with the business users for the periodic update of the issues
• Acted as the SME for the new joiners for both BW 3.5 and BI 7.0
• Raising OSS message with SAP AGS and coordinating within different teams to resolved the issues
• Carry out requirement gathering, GAP Analysis and solution design with clients
• Implemented the planning functions and package for transactional Info Cubes
• Edited the transactional Info Cubes data whenever there was inconsistency in the data
• Responsible for giving the access for Status and Tracking Systems (STS)
• Primary contact for the issues related to the locking or unlocking of the data for particular region and cycle
• Creation of each cycles with required planning types for both top down and bottom up approach based on the business requirement
• Creation and maintenance of the Crystal reports based on BEx queries
• Proposed the implementation of crystal reports for the complex reports to analyze the forecast and budget figures for the normal business users
• Backend Performance Improvement: By using SE30 to analyze the ABAP code - used ST05 to analyze the Select statements, created indexes on ECC tables based on the extraction criteria, set the optimum size parameter for the package size, etc.
• Worked in the Analysis Authorization and have the company code and cost center as the authorization enabled variables and maintain the Z table
• Conducted user training on the front end tools like BEx, Query Designer, and Integrated Planning. Conducted trainings to BI teams on Integrated Planning, BPS-SEM, Analysis Authorization, etc. Regular KT's sessions to the offshore team and work with them constantly
• Worked on Creating Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for data loading to improve performance and utilize data effectively
• Installed and Enhanced BW statistical technical business content to analyze overall system performance, Info Cubes, Aggregates Status, Queries Run Time, Query usage, Query OLAP time, Query Database Time and Load Time
• Managed and Kept consistency of master and transaction data in Info Cubes through BW RSRV performance tools
• Used the APD (Analysis Process Designer) feature in BI to perform several look ups to tie the transaction data to specific master data attributes
• Enhanced Data Source, Info Source, Update rules, Communication Structure and Transfer rules through Delta Management, RFC, Customer Exit, User Exit, Update rules and Start routines workbooks

Environment: SAP BW 7.0, SAP BW 3.X, SAP ECC .