Fscm Consultant Resume
New Jersey, NJ
SUMMARY:
- Over 11 years of experience with 9+ years of SAP R/3 experience including Four Full Life Cycle Implementation experience. Three years of experience in Financial Accounting and Cost Accounting systems
- Certified consultant in My SAP ERP In Financial & Management Accounting
- Extensive experience in configuration and implementation of Financial Accounting (FI), Controlling (CO) and Asset Accounting (AA),Project system(PS),Treasury& Risk Management , In-House cash Management of SAP and integration with MM, SD, PP
- Involvement in Business Process Re-engineering.
SAP Modules Experience from all clients:
Treasury & Risk Management, Electronic Bank Statement and In-House Cash.
- Worked extensively on end to end implementation projects which include blue print preparation, prototype, design, configuration, testing conducting workshops for business in In-house cash collection and Payment process. Support on EBS importing both current day and prior day file for US and Canada. Daily cash position and wire payments, ZBA and cash concentration. Worked on Prototype, design, configuration, testing of Interest rate instruments like Bank Note, Borrowing, Credit Facility for Revolving loan Drawdown, Inter-company borrowing/investment Money Market Fund Investment and foreign exchange deals for Client Perkin Elmer , American Water & Procter & Gamble.
Banking, cash management in treasury module
- Very Strong skills in designing and configuring treasury module of SAP. Implemented cash management (liquidity and cash forecast) and treasury modules for client Perkin Elmer and Gujarat Glass private limited (GGPL) & American Water. Experienced in creation of house banks, electronic bank statements, bank reconciliation, check register etc for various clients. Worked extensively on DME, ACH formats with bank for clients like Procter & Gamble & American Water etc.,
New General Ledger Migration
- Very strong skills in New General ledger Migration using migration cockpit tool for the Equate petrochemicals Co for a multi currency, multi company environment. Designed ,configured prototype the document splitting , parallel valuation segment reporting . Configured and designed integration with profit center accounting.
Profitability analysis and Material Ledger
- Very strong skills in profitability analysisand Material Ledger Implemented for the Gujarat Glass private limited, (GGPL), in a multi currency, multi company environment. Designed and configured to meet budgeting needs. Configured and designed integration with sales and profit center accounting. Developed various drill-down reports to meet customer needs.
Cost center accounting and internal orders
- Very strong skills in cost center accounting and internal orders. Implemented for the Gujarat Glass private limited, Equate petrochemicals &.Parenteral Drugs India limited Worked with end-user in designing standard hierarchy and master data such as cost centers, activity types, cost elements, allocation cycles and order types. Designed and configured to meet budgeting needs. Configured Excel interface for budget data upload using standard SAP. Developed various report painter reports to meet customer needs. Provided end-user training on using information system reports. Designed and configured integration of internal orders with asset accounting and investment management.
General ledger including chart of accounts taxation
- Very Strong skills in designing and configuring general ledger module of SAP. For most of the clients implemented company codes, finalized chart of accounts and other related configuration such as SD, MM account determination procedure, document types, number ranges, etc. Conducted various end-user training in this area. Configured taxation procedures including tax codes, tax reports. Designed new interfaces and reports. Provided support to most of the clients for their various needs such as GR/IR clearing, information system, month-end close and reconciliation with profit center accounting, profitability analysis, consolidation etc.
Accounts receivables and Accounts payables
- Very Strong skills in configuration and application of AR and AP. Experienced in creation of Account groups, Payment methods, Automatic check payment, Lock Box, Credit Card payment, Check printing, and integration with materials and sales for invoice verifications. Implemented for most of the clients. Also designed logistics invoice verification (MM) and Billing and Pricing (SD). Provided after go-live support to various clients. Trained end users in various A/R, A/P areas
Asset management, investment management
- Very Strong skills in designing and configuring assets management module of SAP. Implemented for clients Gujarat Glass private limited, Equate petrochemicals,Parenteral Drugs India limited &Proctor & Gamble. Experienced in creation of depreciation areas, chart of depreciation, asset classes, other related configuration and use information system. Strong Skill in configuration of bonus depreciation, mid quarter convention, mass intercompany transfers using workflow and integration with internal order settlement process.
My SAP ERP 2005 (SAP ECC 6.0)
- Configuration and Implementation of the New GL Migration and online document splitting functionality using SAP delivered method, defining segment field, defining variants for real time integration with CO, Allocations within the G/L and consolidation process Resonsible for the configuration of the company code and general specification
SKILLS:
- SAP : SAP R/3 4.6C/ 4.7 & 6.0 (, Treasury, FI, CO, AA, CO-CCA, AM, PS,MM-FI/CO, SD-FI/CO, FI-AM, FI-CA-Contract, FM, CCS, MM-AM, AR, AP, GL, Asset Mgmt, Cost Center Accounting, Internal Order, Treasury,Corporate Finance Management, Report Painter, Report Writer, LSMW
EDUCATION:
- Master of Business Administration from Confidential University
- SAP Training in: Special Purpose Ledger (AC220-Level 3), Profitability Analysis (AC605-Level 3 Release 4.0B),Funds Mgmt (Level 3) and Treasury (Level 3)
- Certified consultant in My SAP ERP In Financial & Management Accounting
EXPERIENCE:
Confidential, New Jersey March 2012 –Till date
Project: SAP Cash Management/Electronic Bank Statement, In-house Cash Management
SAP Release: ECC 6.0 (utility industry)
Role: FSCM Consultant
Modules: FI-Bank Accounting, Cash Management and integration with AP, Payroll & Transaction Management
Responsibilities:
- Involved and responsible for sequential phases of ASAP methodology like business Blue printing, gap analysis, prototype, design, configuration for In-house Cash Management and Cash Management Modules for American water which is utility based industry for around 29 company codes.
- Responsible for configuration and implementation of SAP In-House Cash module for central cash payments process, Central incoming receipts which include customer collection from different lockboxes ,Mapping the service Companies Bills using the Posting rules in order to reflect the In-House Cash Current accounts, and intercompany payment process.
- Responsible for ALE IDOC setup for the in-House Cash module throughout the landscape where both Financial module and In- house Cash exit in the same system.
- Advance inbound and outbound electronic banking configuration like wire , ACH process , lockbox file, Electronic Bank statements and Integration with PI for generating payment outdoor.
- Responsible for configuration setup to Integration In-House cash Management with Procure to Pay, Payroll ,general ledger &Transaction Management.
- Customization for the Global cash position reporting , liquidity forecasting and Planning calculation of the cash flow ,planning and acutal verus plan comparions.
- Responsible for configuration setup to Integration of In-house Cash Management with Payroll module for process like Garnishment Payments and to creating the ACH file using the program RFFOUS_T.
- Cash Management- Grouping and Structure definition for daily Cash Position, wire transfers, ZBA and cash concentration
- Integration with new general ledger
- Involved in the preparation of design document to develop Z program to automatically create Internal Payment Order in order to adjust the Loan Balance of different company codes.
- Responsible for the setup of end of the day actives for the In-house Cash Management like transfer to General ledger & Generation of internal Bank Statements for each current account.
- Responsible for configuration setup to Integration In-House Cash Management with Transaction management for Payment process of internal borrowing between the company codes and external borrowing of the loans and Interest posting.
- Configuration of Automatic payment method and payment request program for difference scenario like customer refund, Payroll, Garnishment payment & record voucher, P-Cards, using the Payment medium Workbench process.
- Configuration setup for Integration of Financial Supply Chain Module with CRM and account receivable module for Processing the dispute cases and collection Management activities.
- Involved In integration testing using test tools like HP Mercury center.
- Testing using test tools like HP Mercury center, data migration, go-live, conducting user training, preparation user manual and warranty.
Confidential, Atlanta July 09 to March 2012
Project: SAP Finance/Procure to pay/SRM
SAP Release: ECC
Role: Finance Lead
Modules: SAP FICO
Responsibilities:
- Design, Prototype configuration of extended withholding tax for 54 company codes of USA region.
- Enhancement to generic withholding tax report according to the file format of conveys system.
- Activities on 1099 and 1042 state reporting like execution of RFWT0020 and RFWT0010 report for the existing documents before the go-live
- Responsible for the SRM procure to pay for indirect material redesign process which include Enhancement for calculation and determination VAT Code using the Tax usage Indicator and company code address, development new workflow process in the Account payable area.
- Enhancements related to Integration with Cost center and internal order with SRM
- Trouble suiting the error inbound and outbound IDOC from SRM system to ECC system and visa versa.
- Worked in the Upgrade project for SAP open text
- Configuration setting for setting for tax calculation for USA & Canada regions.
- Make configuration setup and functional design document for technical development in SAP.
- Perform unit test and help test team in creation and finalization of test script for integration testing and resolve their issues and queries while actual test, Help training team in finalization of training material for presentation to business users.
- Account Receivable: involved in customization of additional billing functionality like down payment , billing plans, configuration for the dunning ,incoming payments, incoming payments like residuals, partial payments, payment differences like underpayment/overpayment, reason codes and cash application.
- Conducting workshops with business representatives for changes in critical business processes.
- Contributing towards user acceptance testing with business users for test of business scenario before go live and handle queries from business for business process to be carried out in SAP.
- Supporting data migration and cutover tasks for go live.
- Providing support after go live for in the stabilization phase of project and -Knowledge transition to production support team
Confidential, Waltham Nov2008 -June’09
Project: SAP Cash Management/Electronic Bank Statement, In-house Cash Management
SAP Release: ECC 6.0
Role: FSCM Consultant
Modules: FI-Bank Accounting, Cash Management, integration with AP, AR Transaction Management and BCM
Responsibilities:
- Involved and responsible for sequential phases of ASAP methodology like business Blue printing, gap analysis, prototype, design, configuration for In-house Cash Management and Cash Management Modules.
- Responsible for configuration and implementation of SAP In-House Cash module in cash payments and collections
- Responsible for Setup of the ALE IDOC for in-house Cash Module for IDOC type PAYTEXT, FINSATA and DIRDEB.
- Trouble suiting and solving the IDOC issue related to In-house Cash during integration testing.
- Configuration setting for sale tax, withholding and tax calculation for USA.
- Designed ,configuration and prototype transaction Management , Position Management.
- Advance inbound and outbound electronic banking configuration like wire , ACH process , lockbox file , Electronic Bank statements
- Integration of the Account receivable with Financial supply chain management: Responsible for configuration of Credit Management organization structure, credit exposure check, credit scoring and comparison of functionality,
- Dispute Management: Responsible for setup for dispute cases and role assignment, processing the dispute case and integration with account receivable.
- Collection Management setup for collection strategies, collection work lists, collection Management activities and integration of the collection management with dispute Management & account receivable.
- Intergartion with Bank Communication Management for features like Merge Payments, Approve payments, bank Statement Monitor and Reservation for cross -Payment Run Payment Media
- Responsible for the Basic setting , Payment grouping, Payment status Management and release Strategy for Bank Communication Management.
- Responsible for solving the issue during the Unit and and Integartion testing
- Integration with procure to pay,order-to-cash and other financial process.
- Customization for the Global cash position reporting
- Customization of the Global liquidity forecasting and Planning: calculation of the cash flow ,planning and acutal verus plan comparions , plannning in Liquidity planner.
- Account Receivable: involved in customization of additional billing functionality like down payment , billing plans, configuration for the dunning ,incoming payments, incoming payments like residuals, partial payments, payment differences like underpayment/overpayment, reason codes and cash application.
- Involved In regression and integration testing and using test tools like HP Mercury center.
- Testing using test tools like HP Mercury center, data migration, go-live, conducting user training, preparation user manual and warranty
- Cash Management- Grouping and Structure definition for daily Cash Position, wire transfers, ZBA and cash concentration
Confidential March 2008 – Nov ‘2008
Project: Technical Upgrade and New general ledger Migration
SAP Release: 6.0
Role: Senior FICO/FSCM Consultant
Modules: New general ledger Migration and Add On 4.6 c for treasury module.
Responsibilities:
- Involved in new general ledger migration using the cockpit process.
- Designed ,configuration and prototype the document splitting , parallel valuation & segment reporting Configured and designed integration with profit center accounting.
- Worked on blue printing and implementation of ECC 6.0 Upgrade and New GL migration project and implemented online document splitting functionality using SAP delivered method, defining segment field, defining variants for real time integration with CO, Allocations within the G/L
- Configured and implemented - assigning the methods to the ledger and define the splitting fields, Assign GL accounts to item categories, Assign document types to splitting rules and business transaction, defaulting account assignment.
- Involved In the in integration and regression testing for all the module of FICO after the technical upgrade and new general ledger migration.
- Responsible for the business partner Migration and Treasury Add to 4.6 C version after the technical upgrade.
- Position Management: Customizing the external and internal position, update type, business transaction, accounting codes and valuation area, external position Management and process of internal position management.
Confidential Aug 2007 – Feb 2008
Project: SAP Implementation
SAP Release: ECC 6.0
Role: FI/CO Lead
Modules: FI-AR, AP, AR, PA ,CCA , PCA, Order and Treasury & Risk Management,
Responsibilities:
- Responsible for configuration and implementation of SAP implementation to their group companies.
- Responsible for Design, Configuration and implementation of FI modules, Asset Accounting, Cost center accounting and Internal order and cash Management
- Responsible for Design, Configuration and Implementation of Profit center accounting and profitability analysis for one of their sister company. Responsible for Data load, Material ledger, Transfer pricing configuration in profit center accounting.
- COPA: Configuration setup for COPA Planning and Transferring of the Data into COPA, Order and Project settlement, transfer of Overheads, COPA reporting scenarios
- Responsible for the Setup of costing based COPA and Configuration of COPA assessment & allocation cycles, Master data for COPA
- Material Ledger: Responsible for Design and Configuration basic setting of material ledger, Of Manufacturing and overhead Variances, Material Ledger Actual Costs and Value flow reports, Purchase processes and Variances,
- Configured and Activated Material Ledger to implement Profit center transfer pricing functionality
- Account Receivable: involved in customization of additional billing functionality like down payment , billing plans, configuration for the dunning ,incoming payments, incoming payments like residuals, partial payments, payment differences like underpayment/overpayment, reason codes
- Enhancement to the custom report in the area of sale taxes, integration of order to cash process with the treasury module.
- Configured and implemented - assigning the methods to the ledger and define the splitting fields, Assign GL accounts to item categories, Assign document types to splitting rules and configure account determination.
- Responsible for Design, Configuration and Implementation of Profitability Analysis and worked on identifying character, value fields and derivation rule, developing report using report painter in profitability analysis.
- Involved in Master Data conversion for cost center, profit center, internal order and loading G/L account, AR, AP and asset accounting data using LSMW. Cost center planning.
- Electronic bank statement, Payment Management, Cash Management and Transaction
- Management like Bank note-borrowing, Credit Facility, Credit Facility Drawdown, Intercompany
- EBS–importing current day and prior day file from Citi direct and posting memo records from current day file for Cash position. Check encashment date and bank reconciliation using prior day file.
- Configured, tested and implemented global definition like creating posting rule for Citi direct.
- Cash Management- Grouping and Structure definition for daily Cash Position, wire transfers, ZBA and cash concentration.
- Customization of the Global liquidity forecasting and Planning: calculation of the cash flow ,planning and acutal verus plan comparions , plannning in Liquidity planner
- Payment Management- Payment request and Payment handling for Outgoing/Incoming wire payments, Money Market- borrowing/investment Incoming/Outgoing transactions.
- Transaction Management- Bank note borrowing for Lien 1&2, Facility for Revolving loan, Inter-
- Company borrowing/Investment for Inter-company loan and Foreign Exchange for Spot/Forward Trading. Definition of Product types, transaction types, flow types, condition types for setting up Interest rate instrument. Account determination for Treasury and accrual/deferral Posting.
- Configuration and testing of workflow for Interest rate instrument (Deals) release and Business Partner release.
- Loan, Foreign Exchange transaction (Spot and Forward) and Money Market Fund (Investment).
- Responsible for configuration and integration of Credit Management functionality, AP payment program, financial statement versions, capitalization of assets by settlement from orders and depreciation postings
- Responsible for configuration and testing of MM and SD automatic account determinations includes scenarios like rebates , sample etc.,
Confidential, New castle ,UK Oct 2005– Aug 2007
Project: SAP Rollout project for Europe Company
SAP Release: ECC 6.0
Role: FI/CO Analyst
Modules: FI, Cost Center, Internal order, Treasury
Responsibilities:
- Responsible for In-house banking configuration setups in cash payments, collections and warranty support after the Go-live for one the new Company acquired using the phase roll out.
- Responsible for analysis, design, configuration and testing of FI/CO modules for their canadian company
- Responsible for Canadian & USA tax configuration, setting up profit center hierarchy, income statement for profit center, configuring master record for Cost center accounting and internal order modules
- Worked extensively on configuring costing based profitablity analysis
- Created reports in Profitability Anaysis using report painter and CO reports using report writer.
- Trained profitability users in report painter and writer for a week.
- Electronic bank statement, Payment Management, Cash Management and Transaction
- Management like Bank note-borrowing, Credit Facility, Credit Facility Drawdown, Intercompany
- EBS–importing current day and prior day file from Citi direct and posting memo records from current day file for Cash position. Check encashment date and bank reconciliation using prior day file.
- Configured, tested and implemented global definition like creating posting rule for Citi direct.
- Cash Management- Grouping and Structure definition for daily Cash Position, wire transfers, ZBA and cash concentration.
- Integration of the Account receivable with Financial supply chain management: Responsible for configuration of Credit Management organization structure, credit exposure check, credit scoring and comparison of functionality,
- Dispute Management: Responsible for setup for dispute cases and role assignment, processing the dispute case and integration with account receivable.
- Collection Management setup for collection strategies, collection work lists, collection Management activities and integration of the collection management with dispute Management & account receivable.
- Customization of the Global liquidity forecasting and Planning: calculation of the cash flow ,planning and acutal verus plan comparions , plannning in Liquidity planner
- Payment Management- Payment request and Payment handling for Outgoing/Incoming wire payments, Money Market- borrowing/investment Incoming/Outgoing transactions.
- Transaction Management- Bank note borrowing for Lien 1&2, Facility for Revolving loan, Inter-
- Company borrowing/Investment for Inter-company loan and Foreign Exchange for Spot/Forward Trading. Definition of Product types, transaction types, flow types, condition types for setting up Interest rate instrument. Account determination for Treasury and accrual/deferral Posting.
- Configuration and testing of workflow for Interest rate instrument (Deals) release and Business Partner release
Confidential Aug2003 – Aug 2005
Project: Production Support & enhancement of SD, Pricing, Billing, GL, AR, AP
SAP Release: 4.6C & 4.7E
Role: FI/CO Analyst
Modules: FI, GL, AR, AP, SD Billing
Responsibilities:
- Providing Production support and enhancement for SD Pricing and Billing, GL, AR, AP
- Worked on condition records, condition tables and pricing procedure to fix pricing issues
- Worked with developers on program modifications on the above areas
- Worked on enhancement Issues such as configuring SAP Auto Clearing Program by modifying SD maintain copying control for billing documents and Created new line layouts
- Responsible for configuration changes and tested on Billing types and Copying control on billing documents