SUMMARY

• 7 years of IT experience in SAP BPC (Business Planning & Consolidation) 10.0/7.5/7.0/5.1 (Outlooksoft), SAP BW - BI 7.4/7.0/3.5 and SAP SD wif 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 wif Full Life Cycle Implementation, Support, Upgrade and Role out projects wif 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.
• 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.
• Experienced in developing Reports & Input Schedules, SAP BPC Scripting and Excel VB.
• Experienced in the curreny translation during the data loads.
• 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 wif consistent star schema and efficient multi-dimensional data modeling techniques. Customization of datasources in various SAP modules wif focus in FICO, SD, MM and PP data.
• 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
• 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 halpdesk tickets, Enhacing datasources wif 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 noledge 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 noledge 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 wif a strong background in working wif 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 wif minimal supervision and independently.

TECHNICAL SKILLS

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

SAP: SAP NetWeaver 2004s, BI 7.4/7.0, BW3.5, BW-BPS/IP and SAP FICO, SD, MM and PP modules.

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, Sunnyvale, CA

Lead SAP BPC Consultant

Environment: SAP BPC 10.1 NW (NetWeaver), BW 7.4, ECC 6.0

Responsibilities:

• Design review of the initial phase of the implementation and proposed suggestions for performance improvement.
• Analyzing the feasibility of implementing the phase 2 business requirements in the application.
• Implemented an enhancement in the existing design as part of application tuning.
• Achieved performance improvement by 80% on implementing the parallelization concept in Confidential environment.
• Took the ownership and lead the technical upgrade from 10 to 10.1 version of BPC.
• Created 3 applications in BPC for Unit Revenue( Corporate & Global) & Gross Margin.
• Conducted User Acceptance test wif small end user group including the training sessions on the tool.
• Created training manual on the enhancement dat can be differentiated between the two versions.
• Used web reporting functionality for creating reports & input forms.
• Leveraged Webdynpro tool for getting a similar feature of package run over web.

Confidential, Detriot, MI

SAP BPC Consultant

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

Responsibilities:

• Implemented (Full End to End Life Cycle) the BPC software system from SAP to enhance and replace the company’s current Budgeting, Planning and Reporting process for P&L Cost Center level Budgeting, Forecasting and Reporting.
• 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
• Created Transformation Files, Conversion Files and Datamanager packages to import and export data to these applications to and from different source systems (PeopleSoft, JDE and Oracle Apps)
• 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 such as Revenue/COGS calculations, YTD Calculations, Net Income to Balance Sheet, Transfer Data wifin applications
• 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 wifin SAP BPC
• Written complex Sheet Logics for Input Templates

Confidential, Annarbor, MI

Sr. SAP BPC Consultant

Environment: SAP BPC 10 MS, MS SQL Server 2008

Responsibilities:

• Project was based on the Financial Planning and Consolidation in SAP BPC 10 MS platform
• Involved in client meetings for understanding the business requirements.
• Worked in requirements gathering, GAP analysis, solution design and implementation.
• Worked on the development of blue print document for Planning, Budgeting and Forecasting.
• Process designing for Planning, Budgeting and Forecasting.
• Defined business process flows (BPF’s) for Planning, Budgeting and Forecasting.
• Involved in the design suggestions based on the feasibility and compatibility checks of the client requirements wif achievables in the tool.
• Involved in the design of the specific driver requirement of the client for its business scenario and lead it from the implementation side.
• Designed the structure of the chart of account will be used during implementation.
• Designed the Dimensions as per the functionality requirement.
• Design and build of the reports and input schedules.
• Developed the technical design documents
• Analysing the required logics for implementation.
• Involved in resolving the technical issues of the application.
• Worked on Web reporting.
• Handled the data flow maintainance in the backend.
• Presented the prototype of the implementation at the yearly controller conference of the client and all the effort are very much appreciated by whole client team.

Confidential, Englewood Cliffs, NJ

SAP BPC Consultant

Environment: SAP BPC 7.5 MS, MS SQL Server 2008 & UDW

Responsibilities:

• Project was based on the Procurement Planning in SAP BPC 7.5 MS platform
• Involved in Design & Development
• Designed Input schedules & Reports
• Worked on Experience in EV functions, Script logic and allocations
• Worked extensively on the currency translations during the data loads.
• Created user security, Member access profiles
• Defined Custom Menus for running business processes.
• Working noledge on Transports to move data from Development environment to Production environment
• Troubleshooting end user issues during month end closing
• Involved in resolving the technical issues of the application
• Proposing solutions proactively to avoid potential problems in application
• Has been part of the Configuration Management and quality process
• In this project my role is mainly based wif requirement gathering from the client and developing the technical design documents
• Involved in the design suggestions based on the feasibility and compatibility checks of the client requirements wif achievables in the tool.
• Built the required technical design documents of reports for all the implementation scenarios
• I am involved in the build activities of report, input schedules and data manager packages
• I has written script logics required to achieve the specific business functionality in this project
• Playing a lead role in the product test phase of the SDLC for reports/input schedules segment
• Lead the maintenance team of this project until the PGLS exit. I was solely responsible for this team formation
• Received client appreciation for my efforts in stabilization of the application during PGLS period
• Was recognized by awarding the best people developer during employee survey for the 2011 cycle.

Confidential, Englewood Cliffs, NJ

SAP BPC Consultant

Environment: SAP BPC 7.0 MS, SAP SD, MS SQL Server 2005, UDW

Responsibilities:

• The project was mainly rolled out on Sales and Operational Planning in SAP BPC 7.0 MS platform
• Responsible for creation of Region specific work processes, reports, input schedules, reports, custom menus, script logics wif 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 wif 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

Confidential

SAP BPC Application Consultant

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

Responsibilities:

• Worked closely wif 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.
• Identifying the impact on requirements for the business processes.
• Created a New Application Set and applied associated dimensions, defined its properties and managed dimension members.
• 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 wif BPC for Excel Frontend and created a sales application and manually loaded the application wif Data.
• Worked extensively on data manager packages
• Loaded Budget data and forecast data into Finance Application and halped the user's gain good understanding of Variance analysis capabilities in BPC.
• Worked extensively wif BPC Office and utilized the powerful and flexible formulas and functions wifin BPC 7.0 NW version.
• Used Data Manager Functionality to move and copy data required for the planning applications.
• Worked extensively wif 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
• Has good noledge in work status optimization
• Worked on writing test cases for the application and halped users to gain noledge on dat.