Sap Sts Settlements Consultant Resume
SUMMARY
- Senior level functional experience in implementing, configuring, customizing, integrating, testing, support and user in SAP R/3 in FI/CO module.
- Over eight years of SAP consulting experience in the US with clients in pharmaceutical, FMCG, manufacturing, food industry, chemical and telecommunication sectors.
- Excellent analytical, technical and functional skills with strong customer orientation and attention to detail.
- Strong leadership skills with an ability to lead team of consultants. in SAP new GL functionality.
- Three full lifecycle SAP implementation project experience. Experience in multinational, multi currency and global template environments.
- Strong Experience in FI General Ledger, Accounts Payables, Accounts Receivables, Asset Accounting, Reporting and information system.
- Experience in Cost Center Accounting, Profit Center Accounting, Internal Order accounting, Product Cost Controlling and Profitability Analysis.
- Experience in project systems including set up of WBS element, network, account assignment for WBS element and WBS billing.
- Experience in PM - CO integration. Setting up PM order type, settlement profile, allocation structure.
- Experience in period end closing activities, closing cockpit design and testing.
- Experience in Reporting tools such as Report Painter.
- Experience in project evaluation, business blue print documentation, customization, configuration and in-depth understanding of business processes relating to SAP Financials and controlling modules along with integration to MM, SD, PP and PM modules.
- Excellent leadership, communication and interpersonal skills. Worked on multiple SAP finance implementations, streamlining business processes, design and configuration, testing and post-implementation support.
- Experience in writing functional specifications based on the business needs.
- Experience in developing end user testing and materials.
- In-depth experience in ALE, Idoc monitoring, processing of idoc errors, partner profiles, message types, and ALE distribution models.
- Experience in FSCM functionality including credit and collections management, Biller Direct.
- Graduate from Indian Institute of Technology (IIT Bombay) and University of Florida (UFL)
TECHNICAL SKILLS:
Financial Accounting: General Ledger, Accounts Payable and Receivable, Asset Accounting (AA), Credit Management and Treasury.
Accounts Payables and Receivables: Created Vendor and Customer account groups, regrouped customers to define Credit Control Area, experience in period end and year end process along with balance carry forward, customized screen layouts for vendors, customers and document entry, automatic interest calculations on account balances/line items. Configured payment terms, interest calculations, cash discounts, automatic payment program and dunning procedure.
Asset Accounting: Configured asset classes, account determination, screen layout rules for asset master, master data maintenance, legacy system data transfer, asset acquisition, revaluation, period end closing, depreciation areas, and depreciation key. Knowledge transfer and documentation.
Cost Element and Cost Center Accounting: Created cost elements, cost center standard hierarchy, cost center groups based on cost center categories. Defined activity types, statistical key figures. Direct and indirect activity allocation. Defined segments for cost allocation and run assessment cycles and distribution cycles.
Profit Center Accounting: Defined profit center standard hierarchy, profit center groups, maintained account assignments for additional balance sheet and Profit and Loss accounts, statistical key figures to run assessment cycles, allocation of various cost elements (e.g. Internal order, WBS element) to profit center.
Profitability Analysis: PA assessment, reports, forms, derivation rules, characteristics, value fields maintenance and PA transfer structure. Experience in COPA planning including sales and cost planning (SOP and AOP).
Report Painter/Writer: Used report painter and report writer for extensive reporting for period and year end closing.
PROFESSIONAL EXPERIENCE
Confidential
SAP STS Settlements Consultant
Responsibilities:
- Project scope includes working on A/P procure to pay area in settlements space.
- Responsible for issue resolution related to PO and non PO invoices, outgoing payments, monitoring interfaces, idoc monitoring and error analysis, reporting and resolving end user queries.
- Creation of change requests in case of any configuration changes or minor enhancements.
- Preparation and execution of test scripts in quality center using HPQC.
- Handling help desk cases and creation of change requests using remedy tool.
- Handling of PO and non-PO related workflow issues.
- Handling of issues related to LIV for 2-way match (indirect PO’s) and 3-way match (direct PO’s).
- Idoc error handling primarily for intercompany idocs that post AP postings.
- Maintaining EDI related settings for intercompany idocs for direct FI-billings (FB70/FB60).
- Provide end users with the relevant data from standard SAP tables on an as-needed basis.
- Setting up of payment configuration (FBZP) for new entities.
- Extend new entities to all relevant security roles in settlements space.
- Working on interface changes and testing these changes with the relevant third parties and middleware team.
- Testing the development and portal changes to payment portal. Payment portal is used to park invoices entered by end users for various markets.
- Running various test scenarios if any tax relevant changes made in external tax bolt on system (Sabrix).
- Testing scenarios in case of any security role modifications.
- Creating any new payment terms as per business request and testing these payment terms.
- Working with cross streams (Finance and OTC) in case of any cross stream related issues.
- Provide testing support if any changes are made in other areas that impact invoices or payment processes.
Confidential
SAP FICO Consultant
Responsibilities:
- Project scope includes working on PS migration from legacy (SAP system) to new SAP instance.
- Responsible for writing functional specification for interface to post head count (SKF) to cost center
- Wrote functional specifications for custom program to update PO tax jurisdiction code for open PO’s.
- LSMW to update tax jurisdiction code in Assets and WBS elements.
- Testing custom program for loading non-PO related invoices
- Testing vertex SAP integration for Procure to pay flows.
- Provide post go-live support related to AP interfaces.
- Provide screen prints from existing production system as part of evidence for Audit IT controls.
- Extract all JE’s from SAP system for the auditors as part of audit evidence
- Testing CO validation rules related to postings to cost center, WBS element and GL account combinations.
- Current providing support and minor enhancements in CO-PC area.
- Worked on testing PC interfaces to extract material master data, BOM costing data, order costing data for third party planning systems. These programs extract flat file to unix directory for subsequent processing in third party systems.
- Modification of a custom report for inventory coverage to read material data from global APO system. Material master data field MRP type is used to different materials that are forecasted in Global APO.
- Issue resolution and month end support related to AP interfaces, CO interface to post statistical key figures.
- FI-MM account assignment for new custom movement types that are used for clinical manufacturing goods issue from quality inspection lot.
- Configuration of new material types to account category .
- Configuration of new account category link to valuation class.
- Creating and testing new CO validation rules related to R&D costs posting to R&D WBS elements and Informatics costs posting to Informatics WBS elements.
Confidential, Swiftwater, PA
SAP CO Consultant
Responsibilities:
- Project scope include configuring, testing, documentation of PM functionality for new plant.
- Responsible for configuring PM Order type, settlement profile, allocation structure.
- Extend existing order types PM01, PM02, PMMM, PMSW for new plant
- Assign costing parameters to PM orde type
- Create CO master data for cost center and statistical internal order in order to be able to settle PM order costs.
- Include activity rates for maintenance cost center for labor consumption.
- Document and present the solution for business approval.
- Create test data and test scripts for PM flow including PM order creation, time confirmation and settlement along with relevant CO entries to cost center and statistical internal order.
Confidential, Somerset, NJ
SAP FI Consultant
Responsibilities:
- Project scope include design, configuring, testing of intercompany flows
- Responsible for configuring intercompany stock transfer process
- FI configuration included, setting up new company, company code and assigning new company code to existing chart of accounts, fiscal year variant, posting period variant and field status variant.
- Assign new company code to existing controlling area
- FI-MM configuration which includes setting up of valuation class, new valuation group code, account assignment configuration for transaction keys BSX, GBB, VAX, WRX to map to new accounts
- FI-SD configuration included mapping of intercompany revenue account, new account assignment for new account keys related to intercompany transfer price, mapping new SD condition types to existing value fields in COPA
- Configuring CO automatic account assignments OKB9 for new company code
- Creating master data for new GL accounts, cost center, profit center.
- Testing the intercompany stock transfer flow, intra company stock transfer flow and sales flow to external customer of new company and checking the accounting entries.
- Configuration of handling intercompany payables and receivables between trading partners in ECC6. This include generation of default customizing, activating IC clearing process, activate transaction data tables, defining reconciliation process detail attributes, configuring data selection and storage tasks.
- Executing ICR steps and demonstrating the functionality to the customer
- Configuration of closing cockpit which include creating organization hierarchies.
- Responsible for creating templates, creating tasks, creating transactions as tasks, creating flow definitions, defining dependencies.
- Creating closing cockpit template for existing closing schedule.
- Creating and releasing month end and year end close task lists.
- Testing the closing cockpit solution.
Confidential, Pittsburgh, PA
SAP CO-PC, CO-PA Consultant
Responsibilities:
- Confidential express full life cycle implementation project.
- Currently working as a CO consultant specializing in COPC and COPA.
- Project scope include, roll out Confidential SMB express solution for food and beverage industry.
- Primary responsibilities include, requirement gathering, design, configuration, testing and providing key user support.
- Design of costing model for Starkist, the design phase included interaction with key plant users from manufacturing plants, explain Confidential express solution to them and make changes to the solution based on their requirement.
- Demonstrating SAP costing functionality to business users.
- Assist the key users in developing cost center standard hierarchy for Starkist. This includes, cost centers for corporate and plants.
- Prepare, execute and document unit and integration test scenarios for Starkist.
- Configure CO-PP integration settings.
- Configure automatic account assignment for Company level and Plant level cost centers.
- Assist other streams MM, SD and QM on CO related issues.
- Costing, marking and releasing standard cost estimates for product cost planning.
- Repetitive manufacturing configuration with product cost collectors.
- Present SAP repetitive manufacturing functionality to business.
- Configure and test intercompany processes for drop ship and stock replenishment flows.
Confidential, Murray Hill, NJ
SAP FICO/ Payroll Consultant
Responsibilities:
- Currently working as a FICO team member supporting the lucent side of the merger project. Responsibilities include designing interfaces for specific payroll processes. Writing functional requirements for minor enhancements in the logistics box on the lucent side.
- Coordinate with ALE consultant to design ALE distribution model, partner profiles, addition of new message types (both outbound and inbound), linking message types to the partner profiles and outbound and inbound idoc and interface testing.
- Modules supported include GL, AP, AR, CCA and IO
- Internal Order configuration, testing of interface and idocs that sends Internal order master data from Alcatel system to Lucent system.
- Design of the payroll interface by interacting with responsible people from the third party payroll system
- Interface testing of the processes employee expenses, third party invoicing, third party payments, liens and garnishment processes
- Inbound idocs used in the process with message types ACC EMPLOYE EXPENSE for employee expense postings, ACC EMPLYEE PAY for third party invoices
- Outbound idocs used in the process FIDCC2 for accounting documents posted in lucent finance box
- Responsible for the design of the interface for activity allocation of all the employee expense postings posted in the alcatel system from analytical cost centers (one per company code) to operational cost centers (target cost centers) which are the employee cost centers
- Wrote functional specifications for activating a new field in the additional data B tab of the sales order for certain sales order types used for internal consumption process
- The new field from additional data B is used to hold the internal order
- Testing of the new functionality to check the account assignment of the internal expenses posted in lucent logistics system
- Testing of the validation rules set to post the CO documents in alcatel system. For e.g. validation rule set for invalid GL account and cost center category combination
- Provide support for the interface from alcatel to lucent box that would provide internal order master data from alcatel to lucent
- Configuration to include internal order types, status profile and number ranges.
- Provide support for the interface from alcatel to lucent box that would provide cost center master data from alcatel to lucent
- Support for the interface that would carry manual journal entries in lucent logistics box to carry over to alcatel system
- Involved in the conversion of existing sales orders to have new alcatel internal order in additional data B for the item text field
- Provide support to the in-house IT team and the business on an as-needed basis.
- Conversion of work centers to include new cost object
- Integrating payroll GL and AP postings from payroll system to Alcatel system
- This includes design, development, testing of interfaces to post accounting for payroll liabilities, net pay, third party invoice postings which include garnishments, check register update, third party garnishment information update in a custom table.
- Configuring automatic payment program in Alcatel box for payments of third party vendor invoice payments
- Writing functional specs for payroll liabilities, net pay, and third party invoice postings.
- Testing all the payroll related interfaces and providing user support on an as-needed basis
- Conversion of third party vendors from Lucent system to Alcatel system
- Conversion of third party vendor open items to transfer from Lucent system to Alcatel system
- Provide ALE support to transfer master data for cost centers, vendors to payroll system from Alcatel system on an as-needed basis
- Involved with conversion of vendor open items, conversion of vendor master record and various data migration activities.
- Configuration of Internal Orders including order type, status profile, settlement rules.
- Testing of interface to receive IO master data from Alcatel System. This includes ALE setup and including new partner and message type to receive IO master data.
- Functional specifications to add a field in Additional data B tab of sales order to store the Internal Order.
- Build an interface for activity allocation to move expenses from payroll analytical cost center to target operational cost centers. This interface replicates the standard SAP transaction KB21N for activity allocation.
- Prepare and present knowledge transfer documents for the production support team and for end users.
- Provide CO post go-live support to business end users. This includes, posting of idocs in error, error analysis, and navigation of cost center reports.
Confidential, Cranbury, NJ
SAP Expert, CO
Responsibilities:
- Plant visits to gather the business requirements and understand the business AS-IS flows for each plant
- Document the AS-IS flows and follow the existing global template to design the TO-BE flows
- Design the solution for the GAPS and testing the solution
- Configuration of the new plants to include in the global template
- EDI Configuration for the intercompany stock replenishment and direct shipment flows
- Designing standard SAP solution for the existing business processes
- Testing of SAP solution and preparing material for the existing business processes
- Participation in the unit testing and cross stream integration testing
- Resolution of integration testing issues and documenting the resolutions
- Preparation of user material for end user
- Providing the support to the key users on an As-Needed basis
- Representing the CO team in the cross-stream integration meetings
- Worked on solution for the GAP: Blocking deliveries if standard cost of the product is not released. The solution was to develop a custom program that identifies all the materials in the plant for which standard cost of the material was not released for the current period. Then provide the functionality to manually block the identified material for delivery.
- Worked on solution for the GAP: Inventory revaluation reverse. The gap was to identify the price change documents for the month. The documents are identified when standard costs are released during the first day of the close. The material revaluation variances for the month of the close will be posted during the standard cost release. The solution is to provide a custom program that populates all the price change documents. Then create a batch input that posts revaluation reverse for the current month and revaluation values at material level for month of the close.
- Creation of secondary cost elements master data and activity type master data for new activities
- Creation of cost centers for the new plants and include the new plant structure in the cost center standard hierarchy
- Maintaining standard prices for activities based on the input from the key users
- Assigning cost centers to the existing splitting structure (OKEW)
- Automatic account assignment of cost elements that have the account assignment detail at plant level for the new plants
- Creating of assessment and distribution cycles to transfer the costs from indirect cost centers to production cost centers
- Creation of special procurement type for material to be transferred from different plants (OMD9)
- Define cost accounting relevant default values for order types and plants for the new plants
- Define default variance keys for production (OKVW)
- Assign costing key to any characteristic (KEPC)
- EDI configuration for the intercompany stock replenishment and direct shipment flows.
- Designing the SAP solution for the existing process in the plants Baytown, Hammond and Portland
- The standard solution designed is to track all the costs relavant to these processes onto a service sales cost center. At the end of the month create a journal entry (AR) from service sales cost center to invoice a customer using transaction (F-02).
- At the end of the month an assessment cycle is created to allocate the costs from the service sales cost center to the correct value fields (indicating the service sales and direct and indirect costs) in COPA.
- For the Treatment services and Industrial Field Service (IFS) at Baton Rouge plant, the solution was to track the costs related to the burning of the waste onto WBS element. Creating and attaching a sales contract to WBS element.
- Master data for WBS, Allocation of the sales contract to WBS.
- At the end of the month, invoice the customer based on the conditions mentioned in the sales contract. The invoicing process will post sales on the WBS element.
- Check the total sales at the WBS level using PS reporting functionality.
- Settlement of WBS element to COPA based on the PA transfer structure.
- Master data creation of cost center hierarchy, cost centers, profit centers.
- Creation of assessment cycles to settle the cost center variances to COPA.
- Master data creation of cost elements.
- Involved with integration testing with different streams. Testing across multiple systems.
- Preparation of materials for the cost center billing processes for (Baytown, Hammond and Portland plants)
- Preparation of materials for TS and IFS processes (WBS billing and subsequent settlement to COPA)
- Successfully tested the solutions above before creating the materials and arranging workshops for the key users
- Created materials for the new business processes and assisted key users in the process
- Support tolling, subcontracting manufacturing process.
- Work with the plant maintenance (PM module) team for CO-PM integration issues.
- Work in COPA planning, including planning level, planning package, planning method and parameter sets for both sales operations planning and cost planning (SOP and AOP).
- Troubleshooting general integration test issues. Examples of typical issues:
- No accounting document generated from billing: Checked whether the standard costs have been released for the product. Checked if all the pricing conditions are maintained. Checked if the right revenue accounts are maintained for the combination of customer group/material group/ Account key
- Issue related to billing document release to accounting No derivation rule maintained: Checked whether the derivation strategy is maintained (KEDR). Checked if the combination of distribution channel and division is assigned to the right profitability segment. Checked if the profit centers are maintained correctly for the material.
- Goods issue not posted: Checked if the automatic account assignment is maintained (table T030) correctly. Checked if the offsetting posting for inventory is maintained for the combination of valuation class and movement type.
- Error in costing run: Analyzed the errors in the costing run. Checked if the materials have the quantity structure maintained, cost centers have activities defined for the period, activity prices have been maintained, BOM items have right costs defined, special procurement keys maintained, material periods are open.
Confidential, Rocky Hill, CT
FICO Competence Center Team member
Responsibilities:
- Worked as a team member in Henkel North America FICO competence center. Prime responsibilities include providing IT support to the business users during their day-to-day operations as well as providing support during the month end close process
- Finance modules supported include GL, AP, AR, AA, SPL and Controlling modules supported include CEA, CCA, PCA, CO-PC, and CO-PA
- Created master records for Customer and Vendor
- Involved in support of Order to Cash and Procure to Pay cycles
- Involved in 3-way match logistics verification (LIV) and Evaluated Receipt Settlement (ERS) process
- Set up of new accounting clerks and assigning them in the vendor master record
- Involved in configuration of terms of payment, payment difference, tolerance groups, reason codes and payment program configuration.
- Define new risk groups, risk categories and assign them to the relevant credit control areas (CCA)
- Maintain settings for automatic credit control for a combination of credit group, risk category and CCA. Blocking of shipment if credit limit exceeds on sales order
- Set up reason codes for customer over payments and under payments on AR line items
- Define GL accounts for payment differences and assign them to the corresponding reason codes
- Configuration of credit limits and credit checks at various levels of OTC cycle.
- Outgoing payments and Lockbox configuration and post processing. EDI configuration and mapping for
- Processing of paid checks file and clearing of bank transit account with EBS (Electronic bank statement)
- Define special procurement types for externally procuring material from different plants for product costing
- Assignment of special procurement type in costing view of the material master
- Creation of cost center master data, configure default cost center assignment (OKB9) settings for a combination of company code, cost element and valuation area
- Support of FI-MM (procure-to-pay) and FI-SD (order-to-cash) integration aspects.
- Support related to issues with lockbox. This includes issues related to importing lockbox file (FBL2), processing of checks that are not fully applied by lockbox import program.
- Using quick viewer program perform data extracts for company code Schwarzkopf and Henkel
- Data extracts include vendor master data, AP invoice documents and corresponding payment documents for check payments or wire payments for a particular year
- Cross Confidential data transfer by using customized transfer programs to move the GL, AP and AR documents generated in the logistics Confidential to the finance Confidential as part of period end process
- Provide support for documatch invoice printing process and automatic vendor invoicing ERS process for Henkel Surface Technologies business
- Resolve transaction MC.1 report authorization issue to find the total value of a stock in a plant using basis support
- Run a query to pull manufacturing costs per 100 sales units for all the finished goods, semi-finished goods for each plant after the successful cost roll update every month
- Involved in testing of minor modifications made to the custom reports in product costing before transporting to production system. As an example, a custom report was created to populate target costs and actual costs. Target costs were populated in Euro (controlling area currency) and actual costs were populated in USD (object currency). The report was modified to populate both target and actual costs in USD. Tested this modified report for actual currency by comparing the actual costs populated in the report to the actual costs posted in the CO document
- Tested changes made to the custom program that updates commercial price field in the material master with the standard price plus markup charges for inter company materials. Mark up charges are maintained in a markup table, for each sending and receiving company code combination, that will be updated every month by excel upload from the business users
- Involved in supporting product costing month end close that covers structure explosion, costing, analysis, marking and release of standard costs covering materials in various plants
- Functional specifications to modify a custom program that populates the correct amount and taxes from an accounting document. The old version of this program was populating the sum of various categories of taxes from an accounting document into the summary report. The new modification separated these tax amounts based on their categories (e.g. General Sales Tax, Quebec sales tax) and populated separately in the report. This report was prepared for audit purpose for a company code located in Canada
- Involved in writing functional specifications to include posting date in the selection parameters of a custom program that is used to populate the document amounts and various taxes for all the accounting documents posted in a fiscal year for a Canadian company code
- Involved in manually posting the missing idocs for inter company invoices for inter company standard business processes
- Analyze and modify custom program used to calculate accrual posting for cost of goods as a part of period end closing process. The accrual program checks all orders with goods issues without invoices, invoices without goods issues, goods receipts without credit note and credit notes without goods receipt and makes adjustment postings for the current period and creates a batch session for reversal in the next period
- Write functional specifications to modify custom program for posting controlling data input (e.g. direct activity allocation data) from legacy system (spreadsheet)
- Analyze results (line item level) of a custom program that runs at the month end to make the split between processing and material costs in PCA doing FI postings based on the costs from PA
- Analyze results of a custom program that reads year to date quantities in CO-PA and the year to date quantities in PCA
- Asset Accounting: Involved in supporting the month end process for Asset Accounting. This includes, depreciation run, checking the postings to the general ledger.
- Involved with supporting asset accounting end user transactions, which include purchase of an asset from external, asset retirement, scrapping, asset data transfer, sale of an asset.
- Check cancellation issue: Invoice document type life was given as 30 days in configuration settings. Check cancellation was made after 30 days of invoice processing, the system issued error message stating that the archiving has not finished. Issue was resolved by increasing the invoice document type life
- Worked with basis consultants to resolve authorization issues related to asset accounting reports
- Profit center line items report (KE5Z) performance issue: Executed the PCA line items report in the background with two different selection criteria and monitored the time taken to execute the report. Provided the best possible selection criteria to the business user for faster retrieval of data from PCA line items table GLPCA.
- Invoice reversal issue: Vendor invoice was posted and reversed from MM side. However, the user wanted the original invoice to be picked up in the payment run: Issue was resolved by posting invoice (journal entry) from FI side (FB60) and manually clearing the open items (journal entry and invoice reversal document) using F-44. This left the original invoice to be picked up for payment run
- Reset check information issue: Check Payment was cancelled and the invoice was reversed, the business wants to reset the check information. Issue was resolved by resetting reversal of payment document (FBRA), resetting reversal of invoice (FBRA), manually clearing the vendor open items (F-44) and finally resetting check information (FCHG)
- Inbound Idoc corrections to post intercompany AP postings.