Name : XYZ E-mail ID: ABC@gmail.com
Phone No.: xxxxxxxxxxxxx Current Job: SAP BPC Consultant
• Qualified CPA from Colorado and FCA from India.
• Experienced in SAP BPC 4.2, 5.1, 7.0. Net Weaver and Microsoft versions in planning and consolidation.
• SAP certified in BPC, SEM and BI/BW module
• Experienced in SEM versions in BPS / BCS 3.2,3.5,4.0,6.0.
• Experience in BW versions 3.1,3.2,3.5, BW 2004S, 7.0. Experience in FICO areas such as General Ledger, AR/AP, New GL, Cost center accounting (CCA), Profit center accounting(PCA),Internal Orders(IO), cost elements, CO-PA. (R/3 version 4.0B, 4.6C,4.7,ECC5.0,ECC6.0)
• BOBJ BOXI reporting functionalities such as Web Intelligence, Desktop Intelligence, Xcelsius, Architecture of BOBJ BOXI
• Extracted the Hyperion ESSBASE data, Great plains, JDE, Oracle Financial Data, Siebel data to SAP BPC. Experienced with Sarbanes Oxley regulation in SAP
• Experience with BCS,BPS design, development, support, maintenance and interfaces.
• Experience in various levels in project management such as Team lead, module lead and technical architect
• Experience in scheduling tools TIDAL, Maestro and also consolidation tools such as Carat, Oracle Financials Experience with Solution Manager and uPerform tools.
• Received appreciation for work from customers, SAP America platinum consultants/ senior marketing director. Contributor in SAP Development Network (SDN) for BPC,FICO, BCS,BW module.
PROFESSIONAL SAP EXPERIENCE
Client : Campbell Soup, PA
Period: Feb. 2009 to Current one
ECC 4.7, BI 7.0, BPC 7.0 NW Rampup
Working as lead BPC Architect
• 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,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
• Correspond with SAP on the product bug , defects, apply the OSS note.
• Developing , unit testing the reports using the EVDRE functions.
• 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, Cognos.
• Develop the planning and consolidation reports using the BPC reporting services and EVDRE.
• Input templates for Revenue planning, HR planning, cost center planning, Override accounts, input of quantities, stock holding values
• Period open and close functions using the work status management
• BOXI reporting functionalities such as Web Intelligence, Desktop Intelligence
•
Client: AMB Properties( San Francisco, Deloitte Project)
Feb 2008 to Jan.2009
ECC 6.0, BI 7.0, BPC 4.2(Planning), BCS 6.0(Consolidation), BOBJ(Business Objects Reporting XI)
Worked as BPC Architect Consultant( Planning and Consolidation)
BPC Planning areas:
• Gather the business requirement and design the planning, forecast, budgeting requirements.
• Workshop on Planning consolidation requirements with stakeholder.
• Prepare Planning consolidation design documents, process flows
• Prepare functional , technical specification for Planning ,consolidation reports.
• Exchange rate Maintenance
• Load Creating Dynamic Range Exchange Reports and Schedules
• Defining Modeling Requirements
• Defining and Creating Input Templates
• Creating and Developing Budgeting Business Process Flows
• Setting application set status, Adding new application sets
• Using Appshell, the sample application set ,Adding, Scheduling dimension processing , Maintaining dimension members
• Assigning dimensions to applications ,Using dimension properties
• Currency and exchange rate types
• Opening balance and Historical balance loading from ESSBASE, Hyperion Systems. Data transformation and conversion files.
• BOBJ BOXI reporting functionalities such as Web Intelligence, Desktop Intelligence, Universe creation, Xcelsius, Architecture of BOBJ BOXI
BCS Consolidation Areas
• Configuring the consolidation related FI configuration in FI/NEW GL
• Legal consolidation, as well as using profit center as balancing segment.
• Finalizing the BI data source for BCS ,Configuring BCS data stream with required data conversion logic. Creating updating time, version dependant hierarchy in BCS.
• Workshop on consolidation requirements with stakeholder.
• Prototype the consolidation functionalities., Prepare BCS design documents, process flows. Prepare functional , technical specification for BCS reports.,Configure AFD tables for investment, Equity
• Configure consolidation of investment functionality ,Create , generate BCS data basis, consolidation area.Leverage special version for BCS configuration ,Configure/ load BCS Master data for company, consolidation group, FS item
• Validation with nested rule, Currency translation steps, methods, task.Reclassification method, task. BCS task hierarchy for data collection, standardization, consolidated financial data.
• Creation of BCS document type with no reversal, auto reversal with in same fiscal year and auto reversal in subsequent year
• Main tain document type hiérarchies in BCS.Currency translation method for balance sheet, income statement items
• Currency translation task to link company and currency translation methods
• Balance carry forward ,Copy data,BCS –BW reporting for consolidated financial statements such as balance sheet, Income /Expense Statement.
Client: Steelcase Inc.
Nov 2007 to Feb 2008
ECC 4.7, BPC 5.1/4.2
Working as lead Outlook-BPC /BI Consultant
• Blue printing, design, developing, testing and supporting the Business, planning, and consolidation requirements.
• Create ,maintain consolidation application such as Legal consolidation, rate, ownership
• Creation of planning application such as revenue planning, inventory planning, cost planning, HR planning, etc.
• Input schedule sales quantity, stocks, adjustments, rounding, entering planned amount for sales, inventory planning, HR planning. .
• Dimension management such as creation, maintenance and members additions and deletions. Application management such as creation, maintenance, addition of members.
• User Security such as team, task, member access profile creation, maintenance. Also restricting user access by activity, for reports only and specific to region.
• Currency translation functionality maintenance with required Dimensions, properties, applications, script logic, business rules and process chain maintenance.
• Input Schedule for Finance App: Cash Flow input template.
• Dimension Member Formulas, Script Logic to arrive at net profit and other calculations.
• Data management and loading of transaction data to BPC using the data transformation, conversion logic, Master Data loaded to a BPC Dimensions. Validation of data loaded.
• Routine maintenance of dimension members (Master data), hierarchies and member’s properties for account, entity, product, etc.
• Creation of BPC Audit reports and comments.
• Work status management to monitor the job completion.
• Worked on BPC application architecture, performance enhancement using Lite and full optimizations.
• Prepared Planning and consolidation design documents, and process flows.
• Configured Intercompany elimination with Interco members, business rules, and script logic.
• Exchange rate maintenance in rate application,Creation of input template for sales planning data, material planning, and stock holding inputs etc.
• Creation of journal template and journal entries.
• Maintained Hierarchy of Cost Center Accounting and Profit Center Accounting and loaded these files to BPC for the purpose of Planning, Budgeting, Forecasting and Consolidation.
• Configured Data Manager Packages to upload flat file using Conversion file and transformation files.
• Scripts in SQL (stored procedures, functions, and triggers) to supplement data transformation and improve the performance of the data extractions.
• Finance reports: FASTCAST Summary operations, FASTCAST Consolidated EBITDA by Profit Centre, Cash flow, Interest expense, Working capital etc.
• Legal Consolidation reports: Income Statement Report (Guarantor/non-guarantor), Balance Sheet report, Audit Report and Intercompany matching & elimination, Cash Flow report, Consolidated Summary of Operations and Consolidated Balance sheet by Company code etc.
• Documentation, training users and supported the BPC system.
GE Silicones
April 2007 to Oct 2007
SEM BCS version 6.0, ECC 5.0, BW 7.0
Worked as SEM BCS/BPS /BI/FICO Lead consultant covering following aspects:
BCS roles
• Preparation of BCS business requirement document, application design document, test script documents
• Finalize document on BCS transaction data flow/Master Data Flow.
• Worked with onsite/ Offshore teams, assign tasks, follow-up, monitor status of task.
• Configure Creating / generating data basis/ Consolidation area
• Implementation of consolidation of investment in Purchase, equity methods
• Legal and management consolidation to support the reporting requirements.
• Create Generate BCS transaction cube/ODS, Virtual cube
• Assignment of BCS role ,Configure consolidation frequency, permanent /temporary parameters, Configuration master data creation , Breakdown category
• Creation /transport of consolidation unit, consolidation group , hierarchy
• Create data stream function to load the R/3 data thru BW to BCS.
• Validation rules for document header, detail level for Journal entry
• Validation methods, task for Reported Financial Data, Standard Financial Data, Consolidated Financial Data ,Validation with nested rule, Creation of validation messages.Currency translation steps, methods, task. Reclassification method, task
• BCS task hierarchy for data collection, standardization, consolidated financial data.
• Creation of BCS document type with no reversal, auto reversal with in same fiscal year and auto reversal in subsequent year
• Configure reclassification of reported financial data, Configure reclassification of inventory/warranty /other accounts
• Configure Inter-unit elimination of receivable/payable, expense/ revenue , Sales/COGS, Inventory/Profit on sales ,Configure auto reversible journal entry
• Execution of consolidation task in the consolidation Monitor
• BCS Transports across the BW landscape ,Creation of BCS reports.
• Configure / transport Currency translation steps, methods, task.
• Configure / Transport Reclassification method, task
• BCS task hierarchy for data collection, standardization, consolidated financial data.
• Creation of BCS document type with no reversal, auto reversal with in same fiscal year and auto reversal in subsequent year,Submit message to SAP and follow up for the solution.Technical documentation for user training using the tool UPERFORM.
BPS Areas
• Discuss, understand the user requirement to plan the prices and variances
• Creation of planning area, planning levels, planning packages
• Creation of variable , planning layout, planning folder
• Create planning function such as copy, revaluation.Creation of multiple planning area
• Version Maintenance .Creation of BEX Planning reports .Creation of transaction cube, ODS Planning data preparation in ODS, datamart ODS to ODS , datamart ODS to infocube
BW reporting & data modeling
• 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.
• Fixing the cube issues with RSRV ,Fixing the report issues with RSRT.
• System replication of currency , fiscal period settings from R/3.
• 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
Whirlpool , St. Joseph ,Michigan
May 2006 to March . 2007
BCS 4.0, BW version 3.5
Role: FI/ BCS Lead Consultant.
BCS areas
• This covers the BCS configuration for Asia countries specifically for Actual, History and Plan versions in BCS.
• Worked with onsite /Offshore teams, assign tasks, follow-up, monitor status of task.
• Configure/ load BCS Master data for company, consolidation group, FS item
• Master data synchronization of BCS /BW data
• Joint venture consolidation
• BCS assign combination for settings to flow from Plan version to history master data, inter-unit elimination method/ task, reclassification method/task, manual journal entry, task hierarchy .Validation rules for document header, detail level for Journal entry
• Validation methods, task for Reported Financial Data, Standard Financial Data, Consolidated Financial Data
• Validation with nested rule, Currency translation steps, methods, task.
• Reclassification method, task
• BCS task hierarchy for data collection, standardization, consolidated financial data.
• Creation of BCS document type with no reversal, auto reversal with in same fiscal year and auto reversal in subsequent year
• Maintain document type hierarchy in BCS.Create cube, process chain to load the BCS plan, forecast data to BCS Plan, forecast cubes.
• Selective deletion of BCS plan, forecast data,BCS reporting / documentation.
• Currency translation method for balance sheet, income statement items
• Currency translation task to link company and currency translation methods
• Balance carry forward ,Copy data from Actual to History version
• Deletion of Plan data, Create method , task on flexible upload, data stream.
• BCS –BW reporting for consolidated financial statements such as balance sheet, Income /Expense Statement.
BW areas
• Developing new process chain.
• Worked with onsite / Offshore teams, assign tasks, follow-up, monitor status of task.
• Develop, transport ODS, Cube, Multi provider
• Creation of cube partitions, aggregates
• Reports using variables, structures,
• System cleanup activities such as PSA Deletion.
• Load Transaction and Master Data, monitor loads, fix failures and make data available for reporting.
• Built Query / Structure with Bex Analyzer with Calculated key figures using various filters and restrictions for use.
• Prepared test scripts and conducted unit and integration testing. Extensively.
• Designed Queries and workbooks; used variables, calculated key figures, restricted key figures, structures, conditions and exceptions.
• Monitoring the data loading
• Testing of data to SEM, upload of reported financial data, manual journal entry, reclassification of retained earning, currency translation, validation of reported financial data.
• Testing of task through consolidation monitor
• Perform SIT ,UAT test to ensure the validation before transport to production.
• Create Bex reports to comply with statutory requirements.
CONAGRA Foods, NE
Dec 2005 - April 2006
SAP Version R/34.7 and BW3.5
BPS Lead (Interface with CRM/APO/BW/FICO extractions)
• Creation of planning area, planning levels, planning packages
• Creation of variable , planning layout, planning folder,Create planning function such as copy, revaluation.
• Creation of multiple planning area,Version Maintenance
• Creation of BEX Planning reports , Creation of transaction cube, ODS
• Monitoring the data loads to the ODS, infocubes. Deleting/ correcting error in data flow
• Enabling statistical data collection o the data provider.
• Creation of statistical reports ,Enable performance enhancement for the BW data providers
• Correction Maintenance BW process chains.
• Creation of BW basic cube, multi provider, info objects and ODS.
Client Name: Whirlpool Corp
Project name: MPV ( Material price Variance , BPS )
Period: Oct / Dec2005
This is SEM –BPS project to analyze the MPV (material price variance ), arising out of planned prices , actual prices in raw material, parts, commodity codes.
• Discuss, understand the user requirement to plan the prices and variances
• Creation of planning area, planning levels, planning packages
• Creation of variable , planning layout, planning folder
• APO cubes data interface to BPS thru functions
• Create planning function such as copy, revaluation.
• Creation of multiple planning area, Version Maintenance
• Creation of BEX Planning reports ,Creation of transaction cube, ODS
• Planning data preparation in ODS, datamart ODS to ODS , datamart ODS to infocube
HP (Hewlett Packard), TX, Houston, Texas
Project: Light House Consolidation
May 2003 - September 2005
SEM Version 3.2, 3.5 and R/3 version 4.6b, 4.7
Worked as FI/BCS Lead consultant
FICO areas
• System configuration and testing in the areas of FI-GL, FI-AR, FI -AP, , FI-GL master data preparations, G/L accounts creation and processing, creation of sample accounts and data transfer rules, setting for processing of open items
• Configured General Ledger accounting – Creation of G/L Accounts,
• In Controlling defined the Master Records like Cost Elements (primary and secondary), Cost Element Groups, Cost Centers and Cost Center Group Defined Activity Types and Statistical Key Figures for Calculation of Overheads
• Converted Data from Excel using SAP LSMW functionality
• Creation FI-AP vendor groups, creating number ranges and assigning, creation of tolerance groups, creation of vendor master and document types
• Configured settings for AR such as employee tolerances, terms of payment and interest calculation configuration, reason code creation, credit management, dunning, creation of master records and number ranges
• Developed training material for all relevant FI and CO transactions. Involved in testing, training client, validating data and using training client
• Involved in development of test scenarios/test cases and resolved issues at unit testing and integration and system testing
BCS Lead functional work:
• Conducting sessions to gather business requirements from the business process owner community.Perform proof of concept work before real configuration.
• Worked with onsite / Offshore teams, assign tasks, follow-up, monitor status of task.
• Legal and management consolidation to support the reporting requirements
• Consolidation of investment in both the methods, accounting techniques, goodwill, system configuration for COI , inter company elimination of investments.
• Preparation of business requirement document, application design document
• Creating / generating data basis/ Consolidation area for legal and management consolidation.
• Configure consolidation areas,Assignment of BCS role to the consolidation area characteristic
• Configure consolidation frequency, permanent /temporary parameters
• Configuration master data load such as 0CS_ITEM , PC,CC
• Validation of reported financial data in local currency
• Validation of reported financial data in group currency.
• Configure reclassification of reported financial data
• Configure reclassification of inventory/warranty /other accounts
• Configure currency translation,Configure Inter-unit elimination of receivable/payable.
• Configure Journals for Unit level, group level adjustments,Configure auto reversible journal entry, Execution of data collection task in consolidation Monitor
• Execution of consolidation task in the consolidation Monitor
• Configure balance carry forward functions, Performing SIT,UAT ,regression test before transport to production.
• Joint ventures in consolidation ,Consolidation of Investment(COI) Method configuration with Purchase and equity method.
• Configure goodwill global for COI, Configure Appropriation of retained earning for COI.
• Configure selected items for COI ,Inter unit elimination of investments.
• Creation of BCS reports for statutory requirements (US GAAP)
BW areas
• Developed Business requirement document, Application design document based on all the requirements gathered from different stakeholder groups for BW extraction for FICO modules.
• Extraction of BW transaction data for FI module using the data source ZFI_GL_1, ZFI_GL_4, ZCO_OM_CCA_6, ZCO_OM_CCA_9
• Developing ODS, Basic Cube, Virtual Cube
• Statistical and Performance analysis of reports, extraction, activation
• Special ledger cubes/ODS/MP creation and creation of BEX reports for the same.
• Business contents and activation, Performance enhancement in data target, reports and OLAP cache.
• Creation of process chains, info package for data extraction
• Creation of logical partition of cube for performance enhancement.
• Execution of sequential loading thru scheduling tool TIDAL by using task , programs , variants. System integration checks and Unit Assurance test and validation
• Follow up for the solution with SAP for the solutions errors.
HAL( Aerospace and Defence)
July 2002 to March 2003.
Worked as SAP FICO consultant
FICO areas
• System configuration and testing in the areas of FI-GL, FI-AR, FI -AP, , FI-GL master data preparations, G/L accounts creation and processing, creation of sample accounts and data transfer rules, setting for processing of open items
• Configured settings for AR such as employee tolerances, terms of payment and interest calculation configuration, reason code creation, credit management, dunning, creation of master records and number ranges
• Developed training material for all relevant FI and CO transactions. Involved in testing, training client, validating data and using training client
• Involved in development of test scenarios/test cases and resolved issues at unit testing and integration and system testing
• Configured General Ledger accounting – Creation of G/L Accounts,
• In Controlling defined the Master Records like Cost Elements (primary and secondary), Cost Element Groups, Cost Centers and Cost Center Group Defined Activity Types and Statistical Key Figures for Calculation of Overheads
• Converted Data from Excel using SAP LSMW functionality
• Creation FI-AP vendor groups, creating number ranges and assigning, creation of tolerance groups, creation of vendor master and document types
Dorr Oliver, India, Mumbai, India
July 2001 – June 2002
Worked as FICO consultant
• Configuring of external and internal organizational units such as Company code, controlling area, Business area, credit control area etc.
• Creation of suitable chart of accounts, Account groups, Field status groups, Field status Variant entry screen variants etc.,
• Configured Number Ranges for documents with special number ranges for Recurring Entries and Sample documents.
• Configuration of tolerance groups and attaching the same to user groups and testing the correctness of user authorizations and profilesAccounts Receivable and Accounts Payable:
• Grouping vendors and customers by company code including identification of nature and volume of business transactions. Created Vendor and Customer master and specified number ranges and screen layouts and configured Reconciliation Account with General Ledger
GATI ( India), India
September 2000 - June 2001
SAP Version 4.0B
As FICO consultant
• General Ledger, Accounts Payable
• Accounts Receivable ,CO: Cost center, cost element accounting
• Activity Types,CO: Internal orders, Integration testing of system.
Elf Petroleum
Role: FICO Consultant
Duration : December 1997 - June 2000
Environment :SAP Version 4.0B
Responsibilities/Deliverables
• General Ledger (Creation Maintenance of chart of accounts), fiscal year , periods/variant
• Creation of customers, supplier and their maintenance,Creation and maintenance of cost elements
• Creation and maintenance of cost centers, profit centers
• Created Reports in SAP R/3 using report writer, report painter.
• Worked in the Blue print, development, UAT / SIT test, maintenance, go-live support activities in the project.
• Training user in the SAP FICO modules, Creation and maintenance of company codes
• Define Fund management system, Defining cost center, cost element planning
• Analysis of variance for comparing actual with planning.
• Contacting SAP for bugs/ issues in the SAP system,Applying OSS notes to fix the issues
• Analyzing the system short dumps and fixing
Role: Project Leader
Duration: July 2000 – September 2000
Responsibilities/Deliverables
Up-gradation of Merrill Lunch’s Oracle Financials Version 10.7 to Oracle Financials Version 11i (Modules GL, AR, AP, PC, PB). Operating system used Sun Solaris Unix. Subsequent to the up-gradation, quality assurance test were carried out.
Certified Public Accountant ( CPA,US)
Certified Chartered Accountant ( India)
SAP Certification BW 3.5
SAP Certification SEM Financials 2002
Languages: English: Fluent in written and spoken. Several Indian languages.
Phone No.: xxxxxxxxxxxxx Current Job: SAP BPC Consultant
Profile
• Specializing in SAP business module SAP BPC, SEM (BCS,BPS) ,FICO , BI. Eleven years of work experience in SAP, with 18 years of financials application experience,• Qualified CPA from Colorado and FCA from India.
• Experienced in SAP BPC 4.2, 5.1, 7.0. Net Weaver and Microsoft versions in planning and consolidation.
• SAP certified in BPC, SEM and BI/BW module
• Experienced in SEM versions in BPS / BCS 3.2,3.5,4.0,6.0.
• Experience in BW versions 3.1,3.2,3.5, BW 2004S, 7.0. Experience in FICO areas such as General Ledger, AR/AP, New GL, Cost center accounting (CCA), Profit center accounting(PCA),Internal Orders(IO), cost elements, CO-PA. (R/3 version 4.0B, 4.6C,4.7,ECC5.0,ECC6.0)
• BOBJ BOXI reporting functionalities such as Web Intelligence, Desktop Intelligence, Xcelsius, Architecture of BOBJ BOXI
• Extracted the Hyperion ESSBASE data, Great plains, JDE, Oracle Financial Data, Siebel data to SAP BPC. Experienced with Sarbanes Oxley regulation in SAP
• Experience with BCS,BPS design, development, support, maintenance and interfaces.
• Experience in various levels in project management such as Team lead, module lead and technical architect
• Experience in scheduling tools TIDAL, Maestro and also consolidation tools such as Carat, Oracle Financials Experience with Solution Manager and uPerform tools.
• Received appreciation for work from customers, SAP America platinum consultants/ senior marketing director. Contributor in SAP Development Network (SDN) for BPC,FICO, BCS,BW module.
Experience/Project Work
PROFESSIONAL SAP EXPERIENCE
Client : Campbell Soup, PA
Period: Feb. 2009 to Current one
ECC 4.7, BI 7.0, BPC 7.0 NW Rampup
Working as lead BPC Architect
• 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,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
• Correspond with SAP on the product bug , defects, apply the OSS note.
• Developing , unit testing the reports using the EVDRE functions.
• 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, Cognos.
• Develop the planning and consolidation reports using the BPC reporting services and EVDRE.
• Input templates for Revenue planning, HR planning, cost center planning, Override accounts, input of quantities, stock holding values
• Period open and close functions using the work status management
• BOXI reporting functionalities such as Web Intelligence, Desktop Intelligence
•
Client: AMB Properties( San Francisco, Deloitte Project)
Feb 2008 to Jan.2009
ECC 6.0, BI 7.0, BPC 4.2(Planning), BCS 6.0(Consolidation), BOBJ(Business Objects Reporting XI)
Worked as BPC Architect Consultant( Planning and Consolidation)
BPC Planning areas:
• Gather the business requirement and design the planning, forecast, budgeting requirements.
• Workshop on Planning consolidation requirements with stakeholder.
• Prepare Planning consolidation design documents, process flows
• Prepare functional , technical specification for Planning ,consolidation reports.
• Exchange rate Maintenance
• Load Creating Dynamic Range Exchange Reports and Schedules
• Defining Modeling Requirements
• Defining and Creating Input Templates
• Creating and Developing Budgeting Business Process Flows
• Setting application set status, Adding new application sets
• Using Appshell, the sample application set ,Adding, Scheduling dimension processing , Maintaining dimension members
• Assigning dimensions to applications ,Using dimension properties
• Currency and exchange rate types
• Opening balance and Historical balance loading from ESSBASE, Hyperion Systems. Data transformation and conversion files.
• BOBJ BOXI reporting functionalities such as Web Intelligence, Desktop Intelligence, Universe creation, Xcelsius, Architecture of BOBJ BOXI
BCS Consolidation Areas
• Configuring the consolidation related FI configuration in FI/NEW GL
• Legal consolidation, as well as using profit center as balancing segment.
• Finalizing the BI data source for BCS ,Configuring BCS data stream with required data conversion logic. Creating updating time, version dependant hierarchy in BCS.
• Workshop on consolidation requirements with stakeholder.
• Prototype the consolidation functionalities., Prepare BCS design documents, process flows. Prepare functional , technical specification for BCS reports.,Configure AFD tables for investment, Equity
• Configure consolidation of investment functionality ,Create , generate BCS data basis, consolidation area.Leverage special version for BCS configuration ,Configure/ load BCS Master data for company, consolidation group, FS item
• Validation with nested rule, Currency translation steps, methods, task.Reclassification method, task. BCS task hierarchy for data collection, standardization, consolidated financial data.
• Creation of BCS document type with no reversal, auto reversal with in same fiscal year and auto reversal in subsequent year
• Main tain document type hiérarchies in BCS.Currency translation method for balance sheet, income statement items
• Currency translation task to link company and currency translation methods
• Balance carry forward ,Copy data,BCS –BW reporting for consolidated financial statements such as balance sheet, Income /Expense Statement.
Client: Steelcase Inc.
Nov 2007 to Feb 2008
ECC 4.7, BPC 5.1/4.2
Working as lead Outlook-BPC /BI Consultant
• Blue printing, design, developing, testing and supporting the Business, planning, and consolidation requirements.
• Create ,maintain consolidation application such as Legal consolidation, rate, ownership
• Creation of planning application such as revenue planning, inventory planning, cost planning, HR planning, etc.
• Input schedule sales quantity, stocks, adjustments, rounding, entering planned amount for sales, inventory planning, HR planning. .
• Dimension management such as creation, maintenance and members additions and deletions. Application management such as creation, maintenance, addition of members.
• User Security such as team, task, member access profile creation, maintenance. Also restricting user access by activity, for reports only and specific to region.
• Currency translation functionality maintenance with required Dimensions, properties, applications, script logic, business rules and process chain maintenance.
• Input Schedule for Finance App: Cash Flow input template.
• Dimension Member Formulas, Script Logic to arrive at net profit and other calculations.
• Data management and loading of transaction data to BPC using the data transformation, conversion logic, Master Data loaded to a BPC Dimensions. Validation of data loaded.
• Routine maintenance of dimension members (Master data), hierarchies and member’s properties for account, entity, product, etc.
• Creation of BPC Audit reports and comments.
• Work status management to monitor the job completion.
• Worked on BPC application architecture, performance enhancement using Lite and full optimizations.
• Prepared Planning and consolidation design documents, and process flows.
• Configured Intercompany elimination with Interco members, business rules, and script logic.
• Exchange rate maintenance in rate application,Creation of input template for sales planning data, material planning, and stock holding inputs etc.
• Creation of journal template and journal entries.
• Maintained Hierarchy of Cost Center Accounting and Profit Center Accounting and loaded these files to BPC for the purpose of Planning, Budgeting, Forecasting and Consolidation.
• Configured Data Manager Packages to upload flat file using Conversion file and transformation files.
• Scripts in SQL (stored procedures, functions, and triggers) to supplement data transformation and improve the performance of the data extractions.
• Finance reports: FASTCAST Summary operations, FASTCAST Consolidated EBITDA by Profit Centre, Cash flow, Interest expense, Working capital etc.
• Legal Consolidation reports: Income Statement Report (Guarantor/non-guarantor), Balance Sheet report, Audit Report and Intercompany matching & elimination, Cash Flow report, Consolidated Summary of Operations and Consolidated Balance sheet by Company code etc.
• Documentation, training users and supported the BPC system.
GE Silicones
April 2007 to Oct 2007
SEM BCS version 6.0, ECC 5.0, BW 7.0
Worked as SEM BCS/BPS /BI/FICO Lead consultant covering following aspects:
BCS roles
• Preparation of BCS business requirement document, application design document, test script documents
• Finalize document on BCS transaction data flow/Master Data Flow.
• Worked with onsite/ Offshore teams, assign tasks, follow-up, monitor status of task.
• Configure Creating / generating data basis/ Consolidation area
• Implementation of consolidation of investment in Purchase, equity methods
• Legal and management consolidation to support the reporting requirements.
• Create Generate BCS transaction cube/ODS, Virtual cube
• Assignment of BCS role ,Configure consolidation frequency, permanent /temporary parameters, Configuration master data creation , Breakdown category
• Creation /transport of consolidation unit, consolidation group , hierarchy
• Create data stream function to load the R/3 data thru BW to BCS.
• Validation rules for document header, detail level for Journal entry
• Validation methods, task for Reported Financial Data, Standard Financial Data, Consolidated Financial Data ,Validation with nested rule, Creation of validation messages.Currency translation steps, methods, task. Reclassification method, task
• BCS task hierarchy for data collection, standardization, consolidated financial data.
• Creation of BCS document type with no reversal, auto reversal with in same fiscal year and auto reversal in subsequent year
• Configure reclassification of reported financial data, Configure reclassification of inventory/warranty /other accounts
• Configure Inter-unit elimination of receivable/payable, expense/ revenue , Sales/COGS, Inventory/Profit on sales ,Configure auto reversible journal entry
• Execution of consolidation task in the consolidation Monitor
• BCS Transports across the BW landscape ,Creation of BCS reports.
• Configure / transport Currency translation steps, methods, task.
• Configure / Transport Reclassification method, task
• BCS task hierarchy for data collection, standardization, consolidated financial data.
• Creation of BCS document type with no reversal, auto reversal with in same fiscal year and auto reversal in subsequent year,Submit message to SAP and follow up for the solution.Technical documentation for user training using the tool UPERFORM.
BPS Areas
• Discuss, understand the user requirement to plan the prices and variances
• Creation of planning area, planning levels, planning packages
• Creation of variable , planning layout, planning folder
• Create planning function such as copy, revaluation.Creation of multiple planning area
• Version Maintenance .Creation of BEX Planning reports .Creation of transaction cube, ODS Planning data preparation in ODS, datamart ODS to ODS , datamart ODS to infocube
BW reporting & data modeling
• 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.
• Fixing the cube issues with RSRV ,Fixing the report issues with RSRT.
• System replication of currency , fiscal period settings from R/3.
• 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
Whirlpool , St. Joseph ,Michigan
May 2006 to March . 2007
BCS 4.0, BW version 3.5
Role: FI/ BCS Lead Consultant.
BCS areas
• This covers the BCS configuration for Asia countries specifically for Actual, History and Plan versions in BCS.
• Worked with onsite /Offshore teams, assign tasks, follow-up, monitor status of task.
• Configure/ load BCS Master data for company, consolidation group, FS item
• Master data synchronization of BCS /BW data
• Joint venture consolidation
• BCS assign combination for settings to flow from Plan version to history master data, inter-unit elimination method/ task, reclassification method/task, manual journal entry, task hierarchy .Validation rules for document header, detail level for Journal entry
• Validation methods, task for Reported Financial Data, Standard Financial Data, Consolidated Financial Data
• Validation with nested rule, Currency translation steps, methods, task.
• Reclassification method, task
• BCS task hierarchy for data collection, standardization, consolidated financial data.
• Creation of BCS document type with no reversal, auto reversal with in same fiscal year and auto reversal in subsequent year
• Maintain document type hierarchy in BCS.Create cube, process chain to load the BCS plan, forecast data to BCS Plan, forecast cubes.
• Selective deletion of BCS plan, forecast data,BCS reporting / documentation.
• Currency translation method for balance sheet, income statement items
• Currency translation task to link company and currency translation methods
• Balance carry forward ,Copy data from Actual to History version
• Deletion of Plan data, Create method , task on flexible upload, data stream.
• BCS –BW reporting for consolidated financial statements such as balance sheet, Income /Expense Statement.
BW areas
• Developing new process chain.
• Worked with onsite / Offshore teams, assign tasks, follow-up, monitor status of task.
• Develop, transport ODS, Cube, Multi provider
• Creation of cube partitions, aggregates
• Reports using variables, structures,
• System cleanup activities such as PSA Deletion.
• Load Transaction and Master Data, monitor loads, fix failures and make data available for reporting.
• Built Query / Structure with Bex Analyzer with Calculated key figures using various filters and restrictions for use.
• Prepared test scripts and conducted unit and integration testing. Extensively.
• Designed Queries and workbooks; used variables, calculated key figures, restricted key figures, structures, conditions and exceptions.
• Monitoring the data loading
• Testing of data to SEM, upload of reported financial data, manual journal entry, reclassification of retained earning, currency translation, validation of reported financial data.
• Testing of task through consolidation monitor
• Perform SIT ,UAT test to ensure the validation before transport to production.
• Create Bex reports to comply with statutory requirements.
CONAGRA Foods, NE
Dec 2005 - April 2006
SAP Version R/34.7 and BW3.5
BPS Lead (Interface with CRM/APO/BW/FICO extractions)
• Creation of planning area, planning levels, planning packages
• Creation of variable , planning layout, planning folder,Create planning function such as copy, revaluation.
• Creation of multiple planning area,Version Maintenance
• Creation of BEX Planning reports , Creation of transaction cube, ODS
• Monitoring the data loads to the ODS, infocubes. Deleting/ correcting error in data flow
• Enabling statistical data collection o the data provider.
• Creation of statistical reports ,Enable performance enhancement for the BW data providers
• Correction Maintenance BW process chains.
• Creation of BW basic cube, multi provider, info objects and ODS.
Client Name: Whirlpool Corp
Project name: MPV ( Material price Variance , BPS )
Period: Oct / Dec2005
This is SEM –BPS project to analyze the MPV (material price variance ), arising out of planned prices , actual prices in raw material, parts, commodity codes.
• Discuss, understand the user requirement to plan the prices and variances
• Creation of planning area, planning levels, planning packages
• Creation of variable , planning layout, planning folder
• APO cubes data interface to BPS thru functions
• Create planning function such as copy, revaluation.
• Creation of multiple planning area, Version Maintenance
• Creation of BEX Planning reports ,Creation of transaction cube, ODS
• Planning data preparation in ODS, datamart ODS to ODS , datamart ODS to infocube
HP (Hewlett Packard), TX, Houston, Texas
Project: Light House Consolidation
May 2003 - September 2005
SEM Version 3.2, 3.5 and R/3 version 4.6b, 4.7
Worked as FI/BCS Lead consultant
FICO areas
• System configuration and testing in the areas of FI-GL, FI-AR, FI -AP, , FI-GL master data preparations, G/L accounts creation and processing, creation of sample accounts and data transfer rules, setting for processing of open items
• Configured General Ledger accounting – Creation of G/L Accounts,
• In Controlling defined the Master Records like Cost Elements (primary and secondary), Cost Element Groups, Cost Centers and Cost Center Group Defined Activity Types and Statistical Key Figures for Calculation of Overheads
• Converted Data from Excel using SAP LSMW functionality
• Creation FI-AP vendor groups, creating number ranges and assigning, creation of tolerance groups, creation of vendor master and document types
• Configured settings for AR such as employee tolerances, terms of payment and interest calculation configuration, reason code creation, credit management, dunning, creation of master records and number ranges
• Developed training material for all relevant FI and CO transactions. Involved in testing, training client, validating data and using training client
• Involved in development of test scenarios/test cases and resolved issues at unit testing and integration and system testing
BCS Lead functional work:
• Conducting sessions to gather business requirements from the business process owner community.Perform proof of concept work before real configuration.
• Worked with onsite / Offshore teams, assign tasks, follow-up, monitor status of task.
• Legal and management consolidation to support the reporting requirements
• Consolidation of investment in both the methods, accounting techniques, goodwill, system configuration for COI , inter company elimination of investments.
• Preparation of business requirement document, application design document
• Creating / generating data basis/ Consolidation area for legal and management consolidation.
• Configure consolidation areas,Assignment of BCS role to the consolidation area characteristic
• Configure consolidation frequency, permanent /temporary parameters
• Configuration master data load such as 0CS_ITEM , PC,CC
• Validation of reported financial data in local currency
• Validation of reported financial data in group currency.
• Configure reclassification of reported financial data
• Configure reclassification of inventory/warranty /other accounts
• Configure currency translation,Configure Inter-unit elimination of receivable/payable.
• Configure Journals for Unit level, group level adjustments,Configure auto reversible journal entry, Execution of data collection task in consolidation Monitor
• Execution of consolidation task in the consolidation Monitor
• Configure balance carry forward functions, Performing SIT,UAT ,regression test before transport to production.
• Joint ventures in consolidation ,Consolidation of Investment(COI) Method configuration with Purchase and equity method.
• Configure goodwill global for COI, Configure Appropriation of retained earning for COI.
• Configure selected items for COI ,Inter unit elimination of investments.
• Creation of BCS reports for statutory requirements (US GAAP)
BW areas
• Developed Business requirement document, Application design document based on all the requirements gathered from different stakeholder groups for BW extraction for FICO modules.
• Extraction of BW transaction data for FI module using the data source ZFI_GL_1, ZFI_GL_4, ZCO_OM_CCA_6, ZCO_OM_CCA_9
• Developing ODS, Basic Cube, Virtual Cube
• Statistical and Performance analysis of reports, extraction, activation
• Special ledger cubes/ODS/MP creation and creation of BEX reports for the same.
• Business contents and activation, Performance enhancement in data target, reports and OLAP cache.
• Creation of process chains, info package for data extraction
• Creation of logical partition of cube for performance enhancement.
• Execution of sequential loading thru scheduling tool TIDAL by using task , programs , variants. System integration checks and Unit Assurance test and validation
• Follow up for the solution with SAP for the solutions errors.
HAL( Aerospace and Defence)
July 2002 to March 2003.
Worked as SAP FICO consultant
FICO areas
• System configuration and testing in the areas of FI-GL, FI-AR, FI -AP, , FI-GL master data preparations, G/L accounts creation and processing, creation of sample accounts and data transfer rules, setting for processing of open items
• Configured settings for AR such as employee tolerances, terms of payment and interest calculation configuration, reason code creation, credit management, dunning, creation of master records and number ranges
• Developed training material for all relevant FI and CO transactions. Involved in testing, training client, validating data and using training client
• Involved in development of test scenarios/test cases and resolved issues at unit testing and integration and system testing
• Configured General Ledger accounting – Creation of G/L Accounts,
• In Controlling defined the Master Records like Cost Elements (primary and secondary), Cost Element Groups, Cost Centers and Cost Center Group Defined Activity Types and Statistical Key Figures for Calculation of Overheads
• Converted Data from Excel using SAP LSMW functionality
• Creation FI-AP vendor groups, creating number ranges and assigning, creation of tolerance groups, creation of vendor master and document types
Dorr Oliver, India, Mumbai, India
July 2001 – June 2002
Worked as FICO consultant
• Configuring of external and internal organizational units such as Company code, controlling area, Business area, credit control area etc.
• Creation of suitable chart of accounts, Account groups, Field status groups, Field status Variant entry screen variants etc.,
• Configured Number Ranges for documents with special number ranges for Recurring Entries and Sample documents.
• Configuration of tolerance groups and attaching the same to user groups and testing the correctness of user authorizations and profilesAccounts Receivable and Accounts Payable:
• Grouping vendors and customers by company code including identification of nature and volume of business transactions. Created Vendor and Customer master and specified number ranges and screen layouts and configured Reconciliation Account with General Ledger
GATI ( India), India
September 2000 - June 2001
SAP Version 4.0B
As FICO consultant
• General Ledger, Accounts Payable
• Accounts Receivable ,CO: Cost center, cost element accounting
• Activity Types,CO: Internal orders, Integration testing of system.
Elf Petroleum
Role: FICO Consultant
Duration : December 1997 - June 2000
Environment :SAP Version 4.0B
Responsibilities/Deliverables
• General Ledger (Creation Maintenance of chart of accounts), fiscal year , periods/variant
• Creation of customers, supplier and their maintenance,Creation and maintenance of cost elements
• Creation and maintenance of cost centers, profit centers
• Created Reports in SAP R/3 using report writer, report painter.
• Worked in the Blue print, development, UAT / SIT test, maintenance, go-live support activities in the project.
• Training user in the SAP FICO modules, Creation and maintenance of company codes
• Define Fund management system, Defining cost center, cost element planning
• Analysis of variance for comparing actual with planning.
• Contacting SAP for bugs/ issues in the SAP system,Applying OSS notes to fix the issues
• Analyzing the system short dumps and fixing
PROFESSIONAL NON SAP ERP EXPERIENCE
Merrill Lynch IBK, NY and IndiaRole: Project Leader
Duration: July 2000 – September 2000
Responsibilities/Deliverables
Up-gradation of Merrill Lunch’s Oracle Financials Version 10.7 to Oracle Financials Version 11i (Modules GL, AR, AP, PC, PB). Operating system used Sun Solaris Unix. Subsequent to the up-gradation, quality assurance test were carried out.
EDUCATION, Certification & Training
Bachelor of Commerce ( Bombay University, India)Certified Public Accountant ( CPA,US)
Certified Chartered Accountant ( India)
SAP Certification BW 3.5
SAP Certification SEM Financials 2002
Languages: English: Fluent in written and spoken. Several Indian languages.
0 comments:
Post a Comment