SUMMARY

• 14 years of IT experience in SAP BPC (Business Planning & Consolidation) 10.0/7.5/7.0/5.1 (Outlooksoft) and SAP BW - BI 7.0/3.5, BPS,EPM with excellent Project Management, Business Analysis and strong Communication Skills
• Having cutting edge experience in SAP EPM-BPC on both NetWeaver (NW) and Microsoft (MS) platforms with Full Life Cycle Implementation, Support, Upgrade and Role out projects with focus on Planning, Budgeting & Consolidations
• Worked on Reports, Dynamic templates, Data manager, BPF, Applications, Dimensions, Members, Properties, Work status, Security, EV functions in SAP BPC
• Worked in S4HANA, IBP Finance Module.
• Involved in all the phases of project using ASAP Methodology which includes AS-IS, TO-BE, BBP, Configuration, Testing and Go-Live activities
• Experienced in installation and Upgrade to latest versions of SAP BPC on Microsoft platform
• Experienced in developing Reports & Input Schedules, SAP BPC Scripting and Excel VB.
• Expertise in Defining and Configuring Dimensions, Dimension Members and their properties, AppSet and Applications, Logic development, Data transformation and Conversions during the loads.
• Experience in MS SQL Server 2008/2005/2000 and MSBI (SSIS, SSAS, SSRS) and Crystal Report XI R2
• Experience in SAP BW Designing and maintenance of Info Cubes, MultiProviders, Remote Cubes, Infosets, DSO objects with consistent star schema and efficient multi-dimensional data modeling techniques. Customization of datasources in various SAP modules with focus in FI, CO, SD, MM, PP,PS, QM and HR Data
• Integrated functions from Funds management, Claims management,SAP APO with TPM
• Experience in Extraction methods such as LO Cockpit, Generic Extraction, automating the data extraction jobs by using Process Chains Creation and customization of Info Sources, Transfer Structures, Update Rules, Transformations, Start Routines and extract structures. Scheduling and monitoring of data upload into Info Providers such as Info Objects, ODS, Info Cube
• Worked on BADIs and Fucntion modules.
• Experieince in data load management, Background Scheduling ETL, experience in Scheduling Start Process and Process Chains of Events, Loading, Monitoring, Remote Cubes, DataMart and Open Hub Service, BW Transports, Aggregates, Rollup, Compression and Performance Tuning
• Experience in BEx Query Designer, BEx Analyzer, BEx WAD in building Queries, Views and Workbooks, Created Custom Queries using filters, Restricted Key figures, Calculated keyfigures,free characteristics, Conditions and Exceptions
• Experieince in Monitoring workloads, Query loads, Trace, process chains, resolving helpdesk tickets, Enhacing datasources with additional fields, Indexes, BI Statistics, load balancing, Attribute changerun, modifying queries, and work books
• Strong Knowledge of SAP BCS (Business Consolidation), IP (Integrated Planning) and BPS (Business Planning and Simulation)
• Strong knowledge of SAP Business Objects XI 3.2, 3.1, R2 suite and all the flavors which includes Universe Designer, Crystal Reports, XCelsius, Infoview, Webi and Deski
• Strong knowledge in other data warehousing ETL and Reporting tools such as Informatica Powercenter, DataStage, Cognos and MSBI
• Worked on different roles including being a business focused individual with a strong background in working with both SAP technical specialists and key business users, to successfully deliver high quality projects on time
• Experienced in preparing a demo system for client which could successfully convert the lead into the business for the organization
• Worked on multiple projects which got varying levels of complexity and a complete new set of requirements and ability to handle tasks with minimal supervision and independently
• Worked with Banking sector like Confidential .

TECHNICAL SKILLS

EPMSAP: BPC 10.0, 7.5, 7.0, 5.1 (Outlooksoft) both NetWeaver (NW) and Microsoft (MS) platforms, BCS

SAP BI/BW: SAP NetWeaver 2004s, BI 7.0, BW3.5, BW-BPS/IP SAP TPM,SEM BPS,APO,HANA.

Reporting: BEx Query Designer, Analyzer, Web Application Designer (WAD), Business Objects, Crystal Reports, Cognos

Languages: Java, J2EE, Servlets, C, C++, C#.Net, VBA Web HTML, JavaScript, XML, JSP

Database: MS SQL Server 2008/2005/2000 , Oracle 9i, PL/SQL, MS Access

MS Office: Microsoft PowerPoint, Microsoft Excel, MS Word

OS: Windows Server 2008/2003, Windows 7, Vista, XP, 98/95 and Unix

PROFESSIONAL EXPERIENCE

Confidential, Redmond WA

Senior SAP BPC Consultant

Responsibilities:

• Designing of S4HANA, IBP, BPC dimensions, properties and models based on requirements.
• Building of environment dimensions and models.
• Involved in configuring different business rules like - Currency Translation - To convert local data into reporting / group currency
• Account Based Calculation - Reclassification of data (Ex calculation of retained earnings)
• Carry Forward - To carry forward closing balances of last year as opening balance of the current year
• Eliminations and Adjustments - Configure different calculations for “Consolidation Of Investment” business rules.
• Controls - To validate the data integrity
• Configuring Ownership Manager - Define organization structure giving details of investments.
• Journals - Setting us journal functionality
• Work Status - To lock the data.
• Worked on BW HANA Modeling to implement data flow for BPC.
• Implemented BADIs and Integrated IBP.
• Loading Master data from BW to BPC dimensions
• Loading Transaction data from BW to BPC which includes Exchange Rate Data.
• Loading transaction data from Flat File to BPC using data manager package, transformation and conversions.
• Development of Reports and Input Forms with wide use of EPM Functions.
• BPF-To define sequence of steps to be configured.

Environment: SAP BPC 10.0 MS,EPM, MS SQL Server 2008 & UDW,ABAP, TPM, EPM

Confidential, Frisco TX

Senior SAP BPC Consultant

Responsibilities:

• Created a New Environment and applied associated dimensions, defined its properties and managed dimension members.
• Designed and developed multiple Hierarchies in Account Dimension for Chartf accounts and financial statement versions.
• Created Model for Cash and Liquidity forecasting.
• Designed and Developed Generic Extractors and BI Infocubes to pull the Data from ECC system to BI Info Cube
• Loaded Actuals transaction data from BI Infocube into BPC Models using data manager packages.
• Implemented BADIs.
• Developed Treasury forecast Input schedule and Reports using EPM .
• Incorporated Drill-through functionality to ECC and Bex

Environment: SAP BPC 10.0 MS,EPM, MS SQL Server 2008 & UDW,ABAP, TPM, EPM

Confidential, Sunnyvale CA

Sr SAP BPC/BPS CRM Consultant

Responsibilities:

• The project was mainly rolled out on Sales and Operational Planning in SAP BPC 10 MS platform
• Responsible for creation of Region specific work processes, reports, input schedules, reports, custom menus, script logics with much complex functionality
• Worked on development of Application Sets, Applications and Dimensions including maintenance of dimension members and dimension properties
• Created various Reporting (Finance, Sales) & Non-Reporting Applications (Rate) for planning purposes
• Worked on Conversion and Transformation files and Data manager for loading data into BPC
• Usage of wide range of BPC functions such as EVGET, and EVSND etc. for Reporting
• Prepared input schedules, EVDRE reports
• Use of Push Buttons with embedded functionality to enable the user to perform certain BPC functions
• Calculation of Deviations based on the Old Data (Actual and forecast etc.)
• Created simple MDX queries and used dimension logic, advanced script logic for creation of various input schedules and reports
• Worked on developing packages to execute the script logics, creation and testing of transformation files (used to upload data from external sources into the BPC system)
• Received multiple appreciations from the client for the quality of build and strict adherence to timelines and delivery standards
• Business application programming interfaces (BAPI'S)
• SQL Traces, Runtime Analysis, Debugging ALE & IDOC's,Workflow
• Involved in setting up the logical systems and in creation of distribution model.
• Created port definitions and RFC destinations.

Environment: SAP BPC 7.5 MS, MS SQL Server 2005, UDW,ABAP

Confidential, Sunnyvale, CA

Senior SAP BPC/TPM BPS Consultant

Responsibilities:

• Rolled out a complete life cycle Financial Planning and Consolidation Project
• Created Functional Specs and Blueprint for planning processes
• Designed the Integration of the Systems SAP BPC to Legacy Systems (Oracle Financials and JDE) to combine the data for Analysis, Planning and consolidation of data
• Created 5 applications in BPC for Consolidation, HCM, Gross Profit, CapEx and Management
• We are taking care of the EPM solutions for all the OPCOS from NBCU with about 800 users in total.
• I have been working onsite as a BPC-Technical and Functional consultant for the same and working across BPC-BW-ECC.
• Created script logic to transfer data from applications HCM, GrossProfit, CapEx to the Management and Consolidation Applications
• Used Input Schedules to Plan Gross Profit, Head Count and Capital Expenditure
• Also created input schedules for manual top level adjustment during month-end and consolidations.
• Created Script Logic for Various calculations like Revenue/COGS calculations, YTD Calculations, Net Income to Balance Sheet, Transfer Data within applications
• Created Allocation rules script logic and executed via custom SSIS data manager packages using RUNALLOCATION statement
• Created several report templates for Income Statement, Balance Sheet, Headcount and Departmental Expenses.
• Responsible for developing customized Reports and Input Schedule using EvDRE
• Given tool training and explained the features of product to client in order to make them understand tool
• Documentation of the developed Reports and Input Templates
• Conducting online and Onsite End User Trainings
• Create Custom Menus and Macros in Reports and Input Templates within SAP BPC
• Written complex Sheet Logics for Input Templates
• Enhanced BI Datasources to add the fields and developed the CMOD code to populate the data for enhanced fields and added info objects DSO, Info cubes.
• Developed Manual Planning Layouts Coupon level, Program level, Fixed cost item, Ad only, Marketing spend rate, Redemption rate %, Projection factors and Projections withholding.
• Developed ABAP Exit functions for Executed/Estimated redemption rate calculations, Projection factors delta.
• Enhanced the BADI UPX LAYOUT RENDER to lock and unlock the specific key figures based on the user status during the planning.
• Developed Fox formulas for Executed/Estimated Cost calculations and Executed/Estimated Volume calculations, Projection calculations.
• Developed COPY functions for NCH amount, NCH Quantity, Face value, MPR, Executed/Estimated circ, Forecast/Budget data.
• Developed Redemption rate, Marketing spend rate, Projection Planning folders and assigned the functions to Layouts to the folders.
• Designed planning profiles assigned the BPS Layouts and functions to planning profiles and integrated planning profiles to CRM Front end.
• Configured data retractions for Projections and settlement rules to ECC system.

Environment: SAP BPC 7.5 NW (NetWeaver), BW 7.0, ECC 6.0

Confidential, Washington DC

SAP BPC/BPS Application Consultant

Responsibilities:

• Worked closely with the functional user team in the design of Layouts, Reports, Interfaces And Conversions
• Involved in reviewing and redefining the existing budget process, validating and mapping new data requirements to support the budget process.
• Implemented BW BPS for CRM Trade Promotion management, TFM, TCM,
• Sales Volume Planning, Opportunity planning,budgeting, Forecasting, Estimated Promotions.
• Configured TPM Planning Cube, SVP Base Volume Cube for TPM, Latest estimate cube, SAS cube, Promotion data for sales volume DSO, BOM explode DSO.
• Created sales and procurement application according to the business requirements.
• Designed and developed multiple Hierarchies in Account Dimension for Chart of accounts and Financial statement versions.
• Created Process chain development to support master data loads from BW to BPC
• Worked on cash flow Budgeting, created an application according to the business requirements
• Worked on currency conversion rules for finance application.
• Worked with BPC for Excel Frontend and created a sales application and manually loaded the application with Data.
• Worked extensively on data manager packages
• Loaded Budget data and forecast data into Finance Application and helped the user's gain good understanding of Variance analysis capabilities in BPC.
• Worked extensively with BPC Office and utilized the powerful and flexible formulas and functions within BPC 7.0 NW version.
• Used Data Manager Functionality to move and copy data required for the planning applications.
• Worked extensively with Script logics especially around allocation.
• Worked on Balances carry farward using Business Rules.
• Worked on importing data into journals and loading them to cube.
• Woked on setting up Consolidation Frame Work
• Worked on IC eliminations
• Worked extensively on EVDRE functions.
• Worked extensively in developing macros in input schedules
• Granted access to specific applications using security setup and understood BPC audit
• Have good knowledge in work status optimization
• Worked on writing test cases for the application and helped users to gain knowledge on that.

Environment: SAP BPC 7.0, 5.1 NW (NetWeaver), BW 7.0, ECC 6.0, CRM 2007

Confidential, Secaucus NJ

Senior SAP BW/BPS Consultant

Responsibilities:

• Created Process Chains for automation data load for Consolidated Recall History, and Delivery Cubes.
• Interacted with end-users to gather business requirements and transformed them into technical work plan.
• Used ODS objects to stage the data from different data sources and transferred the ODS contents into various data targets and Info Cubes based on the requirement
• Loaded extractors for non-SAP source systems mapped the objects by creating transfer rules, update rules.
• Monitored data loads with full update and delta mechanisms for both master and transaction data and involved in optimizing load performance by adjusting packet sizes.
• Extracted Master Data from Legacy System using flexible InfoSource updating, & mapped objects into BW.
• Created the ODS for Purchase orders and created routines to define update rules.
• Created Drill through queries from summarized Various Info Cubes (Remote, Standard) to a detailed ODS data.
• Worked with WAD to develop customized web reports for Sales Analytics. Used web items, interactive charts, graphics, tables and pre-calculated web templates.
• Configured Reporting agent settings for sending Exception Reports and Alerts as an e-mail.
• Maintained Extract Structures and Data Sources for Procurement, SD & Inventory in LO-Cockpit, also worked on Generic Data Extraction (RSO2) tools.
• Documentation was done in each stage of the project and sent status report every week.
• Developed queries by defining navigational attributes, free characteristics for drill downs, filters and other features like RRI using BEX Analyzer and presented the result in workbooks.
• Modified or created some of the queries in BEx as per the specifications and layout needed in Crystal.
• Involved in training end-users on utilizing, developing and to administer BW queries.
• Conducted presentations, end users training. Supported in resolving end-user issues.

Environment: SAP BI 7.0, BW 3.5, SAP ECC 6.0/5.0, FI, CO, MM, SD, PP & QM

Confidential, Greensburg PA

Sr SAP BW Developer

Responsibilities:

• Supported ticket analysis report, resource utilization report, and time sheet maintenance of the support team
• Monitoring Process Chains, Data load failures, Validating data in Cubes/DSOs.
• Modifying BW reports as per the client requirement/need of the user
• Error Handling and execution of reports
• Submitting the ticket status (open/close) report
• Creation of Users and Specific Roles for Key Users and End Users
• Creation of User Authorizations, Profile generation and User assignments
• Managed and Monitored data loads with full update and Delta mechanism
• Monitoring Master Data Process Chains and Transaction data Process Chains
• Created InfoSources for uploading master data and hierarchies
• Created Aggregates and Indexes for InfoCubes to improve performance
• Production Support (Monitoring data loads for optimization, checking Query Performance)
• Generated standard and customized reports using BEx Query Designer
• Published reports on web using Web Application Designer
• Created exceptions for critical analysis of data
• Transported objects from Development for QA testing
• Activated business content according to business requirements. Analyzed and mapped business process to BW
• Developed Billing and Sales History cube using DataSource from R/3 and flat file source system
• Created ODS objects to store data and updated into various data targets
• Involved in data extraction from non-SAP sources and SAP
• Developed Process Chains for master data loads and transaction data loads
• Resolved Magicdesk tickets raised by Business Users for issues regarding Reports and BW object enhancements

Environment: SAP BW 3.5, SAP R/3 4.7, 4.6C, SD, MM, FI, CO

Confidential

SAP ABAP Consultant

Responsibilities:

• Involved in data conversion and data migration from legacy data into SAP R/3 in MM, SD and FI modules (Vendor Master data, Material Master data)
• Uploaded Customer Master using Session Method.
• Developed and Designed forms using SMARTFORMS for MM module like Purchase Order, MIGO, MIRO etc.
• Solved SMARTFORMS printing issues like printing both Arabic and English in forms like Sales Invoice, Purchase Order and MIGO.
• Modified HR time reports calculating short attendance, incorrectly punching, normal attendance etc.
• Developed quarterly sales & production report, report contains quarter wise Production and sales data.

Environment: SAP R/3 4.0B (MM, SD,HR, FI-CO,), ABAP/4