SUMMARY

• Total 10 years of IT experience as BI/BW/HANA and BPC Consultant
• Ten years’ experience in BI/BW as Techno - Functional and 4+ years in BPC 10.0
• Successfully completed four full life cycle implementations with SAP BW/BI/BOBJ/BPS/HANA and BPC 10.
• Experience in BW - Design and implementation of enterprise data warehousing, data extraction, data transformation, data loading, BAPI’s and Production support activities like: monitoring and maintenance, performance tuning and optimization, partitioning, compression, aggregates, statistics, process chain, info package groups.
• As BW Architect core responsibility is Preparation of Data flows, functional feasibility analysis, Post go live support, activity execution, Preparation of cutover activities, System configuration checks, Quality Assurance to improve performance of the system, documentation and user training .
• Techno Functional lead for gathering requirements and translation requirements in functional specification and technical specifications.
• Expert in start routine, end routine, expert routine, transformation routine, DTP Filter user exits, Info Package Filter user exits, BEX customer exit variable, Virtual char /KF user exit, BPS-SEM user variable exits, Planning functions user exits, IP variable user exits, generic data source full /delta load, user exits: transaction DS, attributes, texts-ECC
• As BPS Architect Role: Experience in BPS-SEM- developed basis and transaction cube, developed extract programs, created planning areas, planning level, planning package, planning functions, variables, data slices, manual planning layout - excel and ALV and reports. Used Bottom Up Planning. Knowledge of retraction, status and tracking system
• Upgrade experience in BW 3.5 to BI 7.0/BW 7.3 and BPS 3.0 to BPS 4.0
• Upgrade experience in BW 7.3 to BW 7.4 on HANA database
• Successfully implemented the SAP BPS on top of BW 3.5 for planning, forecasting and budgeting
• Hands on experience in BPC Planning & Reporting and creating application in Profitability Planning (COPA), Capital Expenditure Planning (CAPEX & OPEX), Sales and Headcount Planning.
• Transformation, Mapping, Conversion and Validation of data from different sources.
• Used Script Logic for various calculation, allocation, currency conversion and moving data from one application to another application.
• Extensively used EPM 10 Functions and related functions for designing reports & input schedule.
• Designed & developed Business Process Flows (BPFs) to monitor progress of users, send email notifications, and assure consistency and uniformity.
• Excellent exposure in interacting with clients, understanding business requirement and providing desired solution. Also, designed Project Blue Print document.
• Experience in generating Income Statement / P&L, Cash Flow Statement and Balance Sheet.
• Production support: Experience - support to BW, BI 7.0, BPS-SEM, BPC 10
• Experience in modifying the dynamic templates including monthly comparison report, yearly comparison report, trend report, and variance report.
• Experience in configuring drill through report from BPC report to BEx and ECC report
• Conducted user training: Reporting, BPS configuration, BI reporting tools, BI 7.0 Overview, etc
• Developed business process and technical documentation. Experience: Developed technical documentation, developed functional documentation and specs, unit test, integration test, UAT - test scripts
• Strong team player. Good communication skills. Proven ability to work in multi-cultured, cross functional and geographically dispersed teams.

TECHNICAL SKILLS

SAP Technology: BPC 10, BW 7.3, BW 7.4 on HANA database, BI 7, BW 3.5 and BusinessObjets XI 3.1

Platform: NetWeaver and Microsoft

BPC 10 Technology: Environment, Dimensions, Models, Business Rules, Control Settings, Logic Script, Work Status, Journal, Audit Report Settings, Web Interface, Consolidation monitoring, EPM Add-in., EPM 10 Functions

BI/BW Technology: InfoArea, InfoObject Catalogs, InfoCube, InfoArea, Extended Star Schema, OLAP, ETL, BEx Analyzer, BEx Browser, Administrator Workbench, PSA, MDM, InfoSource, InfoPackage, User Authorization, Business Content

BPS/SEM: Planning applications, Planning layouts, Primary and Multi planning area, Filters. Planning level and packages, Aggregation levels, Custom planning functions using ABAP, Planning sequence, Input planning query, Excel/ALV planning layouts, BPS security and restriction by variables, Custom extractors.: Custom retractors, Standard retractors.Process chains

BusinessObject Technology: Universe, CMC, Information Space, DataSrc connection, Integrity Test, Measures, Facets, Validation, Indexing, BusinessObject Explorer,.

Environment: SQL2005, 2008, VS 2008, SAP BI, ECC 6.0, R/3,, Oracle Financials R12

Methodology: ASAP

PROFESSIONAL EXPERIENCE

Confidential

BW/BPC/HANA Architect

Responsibilities:

• BPC Architect to analyze the Fit/Gap for the In-scope requirements. Was responsible for understanding the data requirement for the proposed solution and identifying the different sources.
• Worked as Functional lead for developing data architecture design, functional specifications based on the Fit/Gap analysis.
• Designing the technical specification based on the Functional specification based on the SAP BW and BPC feasibility.
• Part of decision-making body to decide the requirements and to plan for the timelines of the requirements.
• Involved in the upgrade of BPC on HANA and implementing the solutions for commercial and chain account planning in BPC on HANA environment.
• Responsible for evaluating how security impacts the design & development process
• Designed and built data integration and data acquisition models

Confidential

Senior BW and BPC Developer

Responsibilities:

• 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.
• BPC support: Provided support to approx. 2300 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 etc.
• 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 tem 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.
• 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.
• 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 Datamanager.
• 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.
• 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.

Confidential

EPM/BPC Developer

Responsibilities:

• Dimension & Application: Processes 19 dimensions for Mgmt Rptg (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 set up. Creating task profiles, member access profiles to allow users to perform task and access assigned data.
• Supported Consolidation tem 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.

Confidential

BI/BW Consultant

Responsibilities:

• Collected requirements from users. Conducted workshops. Created design document.
• Worked with different user groups to gather business requirements and transformed them into a data model using Extended Star Schema model.
• Created data sources, transfer structure-extract structure, wrote extractors - R/3 - custom function modules.
• Created ODS, Cubes, infosets and necessary ‘Z’ info objects.
• Created info source-transfer structure, communication structure, ABAP routines, update rules, update routine, etc. Assigned data sources to info source.
• Loaded master data and transactional data from flat files and SAP R/3.
• Analyzing the SAP BW Business Content required, activating the Business Content components.
• Created queries and web templates. Created Custom Queries using Conditions, Exceptions, Variables, and restricted key figures, calculated key figures, reusable Structures and aggregates for frequently used queries. Published the reports.
• Performance tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, partitioning.
• Involved in the design - authorization objects - reporting authorization. Worked closely with Basis team to create the roles, user groups, profiles and authorization objects.
• Created info package and info package groups. Monitoring of info packages and analyzing the reasons for frequent failures of info packages .Created Process chains to schedule complex data loading into data targets. Used reporting agent.
• Created or changed user exit for BEX reporting variables.
• Ongoing Production support to Finance - Revenue Accounting, Bookings, Expense Planning and Investment Management.
• Involved in the upgrade from BW3.0 to BW 3.5.
• Monitoring of Process chains and analyzing the reasons for frequent failures of Info packages in the Process chains
• Maintaining Reconciliation’s to verify the data in SAP R3 with SAP BW
• Maintaining the queue- related to system generated tickets and customer generated tickets.
• Maintaining the Work History for all the tickets until it is closed down.
• Performing ETL activities from multiple source (R3, RDBMS, etc) systems to BI system
• Monitoring the loads and analyzing the reasons for frequent failures
• Acted as a primary contact for all ETL issues
• Contacting the responsible persons for different source systems whenever there is inconsistent data from source system.
• Creation of data sources in source system and BI system
• Responsible for the month end activities carried over for last 10 days in every month
• Scheduled the source jobs based on the data requirement in the BW system
• Generation of monthly and weekly reports based on the criticality of the business.
• Proposed the changes in current workbooks so that all business requirements are met
• Contacting the BASIS support Mexico Team for system performance issue and Kernel level up-gradation for BI system.
• Worked with Report to Report Interface (RRI) to drill down from Info Cube to ODS item and schedule line level information.
• Involved in optimizing the queries and created reports using BEx Analyzer and Web Application Designer to develop Web Reports.
• Scheduled and automated data loads from R/3 to BW and optimized the load performance by adjusting the packet size, data selection and number of Info Packages

Confidential

BI/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
• Setting up the connection between BW and R3 source system
• Persistently worked towards the process improvements.
• Successfully implemented solutions to frequently occurring problems like preventing LOCKING due to multiple loading to same target through process chains, avoiding data inconsistency
• Automated the month end activities that involves the master data load from different non-SAP source systems
• Creation of different BEx queries and workbooks based on the user requirement
• Transporting the BEx queries and other BI objects from development to production
• 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 InfoCubes
• Edited the transactional InfoCubes 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
• Responsible for creation of data slices for different cubes for CARS and Motorcycles to restrict data for given characteristics
• 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, InfoCubes, 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 InfoCubes through BW RSRV performance tools
• Enhanced DataSource, InfoSource, Update rules, Communication Structure and Transfer rules through Delta Management, RFC, Customer Exit, User Exit, Update rules and Start routines