SUMMARY:

• Overall 12+ years of experience in IT industry
• 5+ Years as a SAP BPC Lead Analyst
• Experience with SAP Confidential 10.1 (Classic and embedded) BPC 10.1 and 7.5 NW and SAP BPS/IP
• Worked on SAP BPC 10.1 on SAP HANA Architect and Full life cycle implementation of HANA for SAP BPC 10.0 and SAP BW providing solution on Architecture landscape.
• BPC Highlight Planning and consolidation with Agile Methodology.
• Requirement gathering for Consolidation. (Quarter based process) Intercompany eliminations, Dimensions and business rules, Currency translation logic Rate applications & dimensions
• Migrated SAP BPC 10.0 Environment to BPC 10.1
• 2 years SAP HANA implementation, SAP System Landscape transformation (SLT), SAP Data Modeling using Attribute view, Analytical View and Calculations Views.
• Migrating SAP BW Models in SAP HANA, converting the standard DSO into HANA optimized DSO, Standard InfoCube into SAP HANA optimized InfoCube
• 7+ years as a SAP BI/BW Consultant including BW 7.3 to BW 7.4 upgrade.
• 1,1 Year as an ABAPer
• A focused problem solver with strong organization and analytical skills
• Successfully lead technical teams in BPC, BW and R/3 implementations.
• Worked on both onsite and offshore resource model
• Understanding of SAP In - memory computing Architecture, Column store, Row store tables in SAP HANA studio.
• Gather the requirements for blue print, build, the consolidation, Planning, Budgeting and Forecasting functionalities.
• Prepare process Definition Document (PDD), Report definition Document (RDD) for the finalized consolidation, planning, budgeting and forecast processes.
• Prepare the documentation on the input template and data extraction of consolidation and planning requirements.
• Configure the currency translation logic, maintain rate application, rate dimension, business rules, Account Dimension, Rounding functions for the report
• Configure intercompany elimination logic, maintain entity, Intco dimension, business rules
• Configure the ownership the application for the consolidation of investment
• Maintain the business rules for Currency translation, intercompany elimination, ownership calculation
• Copy packages to copy the forecast, plan, and budget data.
• Configure data manager extraction from ECC and BI system for the actual, plan data
• Usage of conversion, transformation files for the data management process.
• Configure the application set, Configure application for legal, Management consolidation,
• Create, Maintain custom dimension/ info object, dimension property, dimension hierarchy for entity, account, product, time
• Maintaining the exchange rates in the rate application.
• BPC process chain development to the financial data to staging DSO and to the cube
• Process chain development to support master data loads from BW to BPC
• Executing the optimization tool for lite and full optimization
• Maintaining the FI configuration required for BPC consolidation such as Operations account, group account relationship, intercompany elimination, trading partner related settings, Currency and rate maintenance.
• Loading the historical data, opening balances, current year data to BPC application from Hyperion ESSBASE.
• Reconciling the data of BPC consolidation, planning extracts with BI, ECC application.
• Data extraction to SAP BPC system from Hyperion Essbase, Informatica, Oracle Financials, Insight
• Working knowledge of EPM Input Templates
• Create Consolidation reports such as trail balance, profit/loss, balance sheet, cash flow statement, Actual Versus plan analysis, etc
• Worked with Administrator Workbench and business content
• Created and developed ODS, Cube, Multi provider
• Creation of virtual cube from transaction cube, transaction ODS.
• Replication of data source from R/3. Reports using variables, structures,
• Creation of Key figure catalog, characteristic catalog. Activation of business content info objects. Transport of OSS note applied, Creating and Managing the Data targets, Monitoring the data loading
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using SAP BW/BI.
• Conceptual knowledge of BO (Xcelsius, Web Intelligence, Crystal Reports and Universal Builder.
• Excellent Interpersonal and Communication skills, coupled with strong technical and problem solving capabilities.

TECHNICAL SKILLS:

SAP NetWeaver: SAP BW 3.0b, 3.5, BI 7.0, BW7.3, BPC 10.0 and EPM 10.

ERP: SAPR/3 version 4.6X, 4.0B and 4.7

Operating System: Win 98, 2000, NT, XP, 2000 Server, Linux, Solaris

Languages: C, C++ and Java Adv. and Core

Back End: MS-ACCESS 2000, Oracle 8.i.

Testing Tools: Win Runner, Load Runner

PROFESSIONAL EXPERIENCE:

Confidential

Lead Analyst

Environment: SAP R/3, SAP BW and SAP BPC

Responsibilities:

• Evaluating the requirement for the Tax project to know why to migrate the planning process to BPC 10.1
• Migrating SAP BPC 10.0 Environment to BPC 10.1
• Configured Real-Time access of Transaction and Master data directly from SAP ERP.
• End to end Annual budgeting process
• Profit Center Planning and Cost Allocation

Confidential

Lead Analyst

Environment: SAP R/3, SAP BW and SAP BPC

Responsibilities:

• Evaluating the system for BW 7.3 to BW 7.4 upgrade.
• Conceptual design for the validation programs to validate objects data before and after upgrade.
• Preparing the document to list out the impact analysis of ABAP program/Objects after upgrade.
• Worked on HANA checklist program and resolving all the issues before update.
• Pre and Post DMO activities for HANA migration for SAP BPC.
• Involved in upgrade activities of BW 7.4 for SAP BPC.
• Worked on optimization of Cubes and Models with table consistency checks.
• Created attribute, analytic and calculation views for GL Line items.
• Data Provisioning and replicating data from source system toHANA Database using SLT and Business Objects Data Services.
• Replication of the selected tables of FI from ECC toSAPHANA. Performed transformations during the replication process.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Monitoring the replication process usingSAPHANAstudio andSAPLT replication serverfor transactional integrity.
• Experience in Importing Metadata, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads using SAP HANA IMCE (In memory calculation Engine) studio.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Gathering the requirement for Local consolidation and Cost Allocation

Confidential

Lead Analyst

Environment: SAP R/3, SAP BW and SAP BPC

Responsibilities:

• Requirement gathering for FDIC process for Consolidation. (Quarter based process)
• Provided the guidance to the team for the different Business day scenarios.
• Review of system design and suggest improvement process
• Preparation of Business Simulation Process for Legal Close and Management Close before Book of Records.
• Worked on SLA reports for Intra Day process (15 minutes SLA for Data loads for different day scenarios).
• Played a Major role in BPC 10.0 Go - Live project
• Gathering the requirement for Management calc project which is based on Loan Loss Reserved, Allocated Tax and Deposit Reserved.
• Converting the requirement into conceptual design and Worked on Proto type built phase to built proto type for Management Calc project
• Green light for built phase, Built out Evaluating the Product Performance or stress testing, UAT and Go-live of Management Calc Project.
• Providing the easy Solution of Complex design to load the huge volume of master data like Profit Center, Cost Center

Confidential

Lead Analyst

Environment: SAP R/3, SAP BW and SAP BPC

Responsibilities:

• Prepare Process Definition Document (PDD), Report Definition Document (RDD) for finalized Consolidation and Planning.
• Prepare the documentation on the input template and data extraction of consolidation and planning requirements.
• Configure the currency translation logic, maintain rate application, rate dimension, business rules, Account Dimension, Rounding functions for the report.
• Configure the intercompany elimination logic into dimension and Business Rules
• Configure data manager extraction from Non SAP system to SAP BPC for Primary and User Define hierarchies for Profit Center and GL Account.
• Analyze the GAAP for Management close and Auto Elimination process between SAP and In$ight systems for BOR (Book Of Records)
• FDIC Reporting - For the BOR, an end of day consolidated balance sheet will be generated at the end of the quarter for each calendar day of the quarter based on the quarter end consolidation structure. Daily consolidated balance sheets are required as supporting documentation needed to prove out to FDIC the calculations performed in SAP for qarter to date average balances (QTD ADB).
• Experience in creation of SAP HANA End to End scenario for POC which involved working in following tools/applications
• Setup application from SAP Source system (ERP) to SAP HANA using SLT.
• Setup of replication from non-SAP sources like DPP/MaxDB to SAP HANA using SLT.
• Creation of models using SAP HANA information Modeler
• Consumption of these models in few EPM and other reporting Tools.
• Post copy automation tool - automated solution for delta queue cloning and synchronization is called Post copy automation tool.

Confidential

Lead Analyst

Environment: SAP R/3, SAP BW and SAP BPC

Responsibilities:

• Responsible for collecting the information of target state solutions for the BOR by interacting with Business analysts and Business heads.
• Managing the integration between the BOR design and existing design to implement BOR changes
• Building the solution for BOR and creating the validation process between current and future design.
• Loading the historical data, Opening Balances, Current Year data to BPC application from MDM, IN$ight and ECC
• Working for FPP service solution built for validating the data from different systems through SAP BW - FIG - ETL systems.
• Reconciling the data of BPC consolidation, Planning extract with SAP BPC to Insight system.
• Provided the solution for the user define Hierarchy for the BPC - EPM reporting.
• Worked with an SAP for the MDX Queries.
• Corresponded with SAP on the product big, defects, apply the OSS note.
• Gathering the requirement for Drill Through to reconcile to balance on the P&L and Balance Sheet EPM Drill Through should reconcile for all prior periods. As the Drill Through is between SAP BW to BW system hence we created through MDX Code.
• Creating a POC for MDX Drill Through queries and working with SAP for the statements, which are not supported, current with the tool for the Local Connections and trying to fill the GAAP between SAP and Bank Requirement for Drill through.
• Building a document for the EPM Reporting for MDX for different for MTD, QTD and YTD queries.
• Creating the supporting and detail document for the MDX code for EPM

Confidential

Lead Analyst

Environment: SAP R/3, SAP BW and SAP BPC

Responsibilities:

• Specifically, responsible to lead SAP Business Objects Planning Consolidation (BPC) w/ Enterprise Performance Management (EPM) integration project experience; developing requirements future state design using leading practices, and the configuration of SAP BPC NW.
• Involve in understanding and gathering requirements by interacting with business analysts, Department heads, directors and Project Managers.
• Perform hands-on BPC Planning design and configuration (reports, input schedules, script logic, allocations, distributions, trending, etc). Develop Reports, Input Templates, Dimensions, Data Integration, Business Process Flows, Logic, and Security
• Building budget models and maintaining calculations with the budget models
• Develop SAP BPC reports using reporting tools (Business Objects, Business Explorer, etc.) to facilitate seamless drill-through analysis
• Communicated the effectively ideas and solutions to customers, team members, and partners after Code review and analysis.
• Throughout the Code review process, Liaised closely with the business and ensured that strict guidelines around project documentation were followed.
• Created status reports for gaps between FSpecs and T-Specs and updates as required and escalate issues as necessary to project management
• Closely working with Business Analysts to ensure that all core business requirements are satisfied, new business needs are proactively supported and new BPC functionality delivers business benefits
• Managed integration between the BW (existing), which is called as Analytical BW, and BPC Operational BW Models.
• Oversee completion of all activities related to the legacy systems in terms of data conversion and interface design, development and testing
• Timely delivery of the configuration and development.
• Analyze and fix any defects that come up during testing, within the agreed upon SLAs.
• Developed EUDD (End User Data Delivery) consolidated Work-stream Model, which is used for the pre-paring stage for BPC P&F model. There is a request that Plan and Forecast data for all entities of the overall BAC corp, be moved from Insight Mon Plan table to BW Plan info cube, until Insight will go for retire.

Confidential

Senior Analyst Appl. Programmer

Environment: SAP R/3 and SAP BW

Responsibilities:

• Kick started SAP BW Project at offshore at BA Continuum India in 2010.
• High-Level Architecture Designing, As-Is and To-Be Analysis.
• Interact with Business and Solutioning team to understand business requirements and come up with robust technical solutions
• Prepare design document, carry out coding, unit test and deliver for Functional testing, with Quality and within schedule
• We have developed the Customized Objects to support the Banking process for GL i.e. ADB (Average Daily Balance)
• Setting up Legal Application, Rate Application and Ownership Application and related Dimensions
• Data manager packages for loading Master and Transaction data from BI to BPC cubes
• Setting up the pre-requisites for SAP BPC Models
• Development of RECON tool to perform validation for data coming from different sources
• Provided the Solution for B2B (Book to Book Break).
• High-Level Architecture Designing, As-Is and To-Be Analysis.
• Interact with Business and Solutioning team to understand business requirements and come up with robust technical solutions
• Prepare design document, carry out coding, unit test and deliver for Functional testing, with Quality and within schedule
• Review Business Requirement Documents from a feasibility perspective and identify gaps with respect to any missing specification
• We have developed the Customized Objects to support the Banking process for AP and FA modules.
• We used FPP which uses Data Services as the ETL tool to move Source data to Target data using mapping tables. Also developing
• I was involved in all phases of the project from initiation to post go-live support and optimization for different releases. The solution incorporated data from SAP R/3, flat files, and external SQL databases using DB Connect.
• Analyze and fix any defects that come up during testing, within the agreed upon SLAs
• Provide Support for System Integration Testing, Dress Rehearsal, Cutover activities and Post Go Live Support
• Provide Proof of Concept support for incorporating latest technological changes for SAP BW 7.3 version.
• Used SPO (Semantic Partitioning) BW 7.3 Feature) to handle huge volume of data.
• User to support Functional Unit Testing while performing testing.

Confidential

Senior consultant

Environment: SAP R/3

Responsibilities:

• Involved in the Support Pack Upgrade from SPS11 to SPS18
• Worked on BW Upgrade project for Patch and plug in upgrades, which involved preparation of all clients for upgrade, post upgrade testing.
• Resolving WAD issues related to upgradation.
• Involved in before and after upgrade Process.
• GUI Upgrade.
• Developed Standard Test case template for Pre and Post Upgrade process in upgrade.
• Tested Sandbox and development environments as per test cases in upgrade process. from the business users.
• Perform test support patches and OSS Notes for Upgrade.
• Trained end users on BEx Reports for KF hidden can are shown which will be specific in 3.5 (from upgrade).
• Investigate and propose resolutions for failures.
• Testing RSRV, RSRT, RSD1, RSUPGRCHECK Program, ST22, RSA7, and SM13 after applying plug-ins.
• Compare Web reports in development and production, applying chart migration program, changes web reports manually as per standards in production. Empty data marts, RSISOSMAP extraction check, changing KF Property to hidden can be shown as per new OSS.
• Spot-check when system copy.
• Stabilization and QA Testing.
• Involved in Business improvement process
• Extensively involved in setting up of procedures for extracting data from SAP R3 by using Generic Extraction and Customizing LO Cockpit by using enhancements and writing User-Exit programs as per requirements.
• BW routine Development: Start Routine, End Routine, Virtual InfoProvider
• User exit Development: SAP R/3 extractor enhancement, Virtual Key Figures, Variable Exit Queries
• Development queries and web template
• Migrating HR and FI Reports and workbooks from BW 3.5 to BI 7.0
• Designed BEx Broadcaster application for distribution of sales report and tools usage summary report, configured pre - calculated web templates and work books.
• Create highly formatted BW reports using BEx and VBA Macros within Excel based BW workbooks, and drill down reports
• Report status, communicate project issues, and participate in project meetings and planning
• Created the HR leaved Availed Report
• Worked on Finance Monthly Profit and Loss by Country and Division.
• Created Finance Balance Carry forward Reports.
• Created Credit Risk Analysis Report.

Confidential

Senior Consultant

Environment: SAP R/3

Responsibilities:

• As a BW /BI Senior Consultant responsible for 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, New solution handovers in COPA, FIGL, SL, AP, AR, SD, MM and HRM modules.
• Work directly with functional teams to prioritize, understand, design, plan, manage, and deliver reporting and analytics solutions for the business. Work with business users and managers to understand requirements and articulate solutions
• Lead performance tuning and optimization initiative of a BW 3.5 system in preparation for a Net weaver BI 7.0 re-implementation enforcing naming conventions, standards, and process change controls.
• BI landscape and sizing consulting for a BI 7.0
• Created test packages for checking the consistency of the objects before and after upgrade.
• Involved in the Pre & Post Upgrade Activities (3.5 to NW2004s)
• Involved in the integration testing in quality of objects and Unit testing.
• Design, develop and test the objects with the new functionalities.
• Ensure successful production go-live & support hand over.
• Performed functional checks in order to test the new features of BI .
• Functional Upgrade to BI 7.0 system, Migration of WAD Templates to BI 7.0 templates.
• Migration of BEX Queries to BI 7.0 Queries, New BEX Analyzer Workbooks.
• Usage of Information Broadcasting to distribute reports to email and Knowledge Management (KM).
• Integration of BI reports in Portal using iviews.
• Migration of DWH objects to BI 7.0 objects (Transformations, DTP).
• Involved in BIA administration and Monitoring activities like index checks, maintenance function, index settings, delete and rebuild indexes, RSRV BIA checks for consistency and performance of data loads.
• Manage existing BW and newly transitioned employees in production support related tasks related to transports, change requests enhancements, and on-call duties. Mentored and trained junior team members in BW ETL processes and trouble-shooting, BW maintenance task, and query development.
• Installed Content browser info cube 0BCTCBC01 for managing content in BI .Involved in testing support packs, OSS notes, query development, and on-call responsibilities.
• Configure, validate, and promote requested enhancements to existing BW solutions
• Programming knowledge in Enhancements, User Exits and Routines.
• Configuration of Information Broadcasting
• Implementation of Information Broadcasting Queries, Queries view, Web Templates workbooks and Reports.
• Developed Inventory Stock Statement Report with Drill down for material, Plant Material Type, Material Group and Storage
• Developed Gross Margin Report with Drill down for Sales District, Customer Group, Country and Customer.

Confidential

Senior Software Member

Environment: SAP R/3 4.7

Responsibilities:

• Support at Data Correction of ODS objects and Infocubes.
• Involved in Reinitalization Process.
• Development of Transfer and update Rules in ODS objects and Infocubes.
• Creation of revision programs
• Setup of Aggregates, partitions and compressions.
• Support at Data Source correction of ODS and InfoCubes.
• Monitoring the Data loads and Fixing the problems
• Creation and debugging of the Reports as per the requirements of End Users.
• Involved enhancement of master data and transactional data sources to add new data fields

Confidential

Business Analyst

Environment: SAP R/3 4.7

Responsibilities:

• Interacting with clients and onsite team members.
• Involved in data extraction, monitoring, data maintenance and developing queries.
• Discussed Data Modeling, Granularity, and Performance Tuning with business analyst and end user
• Worked extensively on Remote Cubes in order to improve performance.
• Involved in the Performance Tuning of InfoCubes and Query reporting
• Cleaning up the Cubes.
• New Feeds setup in TST/TSP Systems.
• Promotion of Objects for Releases.

Confidential

Team Member

Environment: SAP R/3 4.7

Responsibilities:

• Setup periodic Data loads from R/3 and from a legacy system (flat files).
• Created queries for BEx reporting for Sales Lead report (sales prospect monitoring), and Daily billed reports (revenue monitor).
• Created multi-cube from Delivery and Billing Info Cubes.
• Fine-tuned the system for faster data uploads and BEx reporting.
• Used ODS to stage the data before transferring the ODS contents to the InfoCube. Done ODS reporting to give details of delivery items and schedule line items.
• Set up procedure for extracting R/3 data for SD using LO-cockpit.
• Worked extensively on standard and custom defined LIS, LO and CO-PA extractors. Used LO structures for extracting sales order, delivery billing information.
• Created multi-cube from Delivery and Billing Info Cubes.
• BEx Query Reporting, Install Business Content, Generic extraction.
• Worked on data extraction of SAP R/3 system using various extractors and non-SAP systems (via flat file). Also worked on extending some of the extract structures by adding fields.
• Worked on data targets i.e. Info cubes and ODS by creating interfaces at BW and SAP R/3 level. Used delta update mechanisms for uploading the data to BW from R/3. Worked with ODS and PSA.
• Worked on reporting using the Bex analyzer, Bex browser to summarize data.
• Worked with aggregates, Info set queries.
• Rescheduling the info packages.

Confidential

SAP BW Consultant

Responsibilities:

• Involved in Installing Business Content for Standard InfoObjects, InfoSources, InfoCubes related to Sales & Distribution and Finance.
• Worked with SAP R/3 LIS in loading S&D data into BW and used Flat File Interface in loading corresponding Master Data
• Actively involved in Monitoring the Data Transfers from Source Systems into BW with the help of PSA
• Used the Business Content Sales Overview InfoCube 0SD CO3, for over all Sales Analysis. The transaction Data is loaded from Different Source Systems using the InfoSorces 2LlS 01 S260 SalesOrder, 2LlS 01 S261 Delivery, and 2LlS 01 S262 for Billing Document and 2LIS 01 S263 for Sales Order/Delivery.
• Extracted data from MM modules and uploaded the data into the procurement cubes via 2LIS 02 HDR, 2LIS 02 ITM and 2LIS 02 SCL.
• Involved in the Performance Tuning of InfoCubes and Query reporting
• Worked with BEx Analyzer to generate Queries and embedding them into Workbooks
• Configured BEx Queries for Free Characteristics, Calculated and Restricted Keyfigures, Filters, Variables and Exceptions
• Worked with Reporting Agent in creating and Scheduling Packets for Background Exception Reporting and Printing Jobs

Confidential

Developer

Environment: SAP R/3 4.7

Responsibilities:

• Stock status Report: It displays in one single Report the unrestricted quantity available for each material at various plants with their respective batch numbers.
• Stock Movement Report: It is a detailed Report on material transactions listed in the order of plant storage location, Material, batch and their various movement types.
• Created a Report to display check for payments to vendors and record these checks as financial documents.
• Generated Report to compare the number of Quotations against the number of Orders received the contact address of the customer whose orders were not confirmed.
• Developed a BDC program to load Material master records.
• Introducing and enlarging new and existing interfaces for the various Perform and Form Routines in Report Programs
• Writing Report programs.
• Debugging of programs in connection with error messages and making suitable modifications in programs,
• Refining Programs by making suitable modifications (using the Extended Program Check functionality of various includes)