Sap Fi-co-ps Lead Consultant Resume
Harleyville, SC
SUMMARY:
- Overall 10+ years of extensive functional experience in SAP including 4 full life cycle implementations, 3 Global Roll outs, 3 Enhancements and 2 Production Support projects.
- Holding a Master’s degree in Finance with Strong domain knowledge and Industry experience in FMCG, Manufacturing, Pharmaceutical, and Cements .
- Involved in Requirement Gathering, GAP Analysis, Business Blue Print, Customization, Testing and End user with in - depth understanding of Business Processes.
- Good understanding on OTC (Order to Cash), P2P (Procure to Pay), PTP (Plan to Production) and R2R (Record to report) business processes with transactions in multiple currencies and cross-company code transactions.
- Extensive experience in configuring and testing FI-classic GL & New GL, FI-AP, FI-AR (Accounts Payable & Receivable), FI-AA (Asset Accounting) Tax, In-House Cash, CO-CCA (Cost center Accounting), CO-PCA (Profit Center Accounting) and CO-IO (Internal Orders), CO-PC (Product Costing), CO-ML (Material Ledger) and CO-PA (Profitability Analysis) with HANA.
- Strong knowledge in FI & CO integration with MM, PP, PI, SD, PS (Project Systems), CS (Customer Service) PM (Plant Maintenance) and WM (Warehouse Management).
- Experience in defining control parameters for BAI2 file for LOCKBOX processing and configuring EBS (Electronic Bank Statement), and APP (Automatic Payment Run) in Cross company environment.
- Implemented Tax module to calculate Sales and Use Tax through the VERTEX interface.
- Experienced in implementing Asset Accounting in integration with Project systems and Internal Orders.
- Implemented Project Systems (PS) for CAPEX projects and Maintenance Projects. Also worked in resource related and milestone billing.
- Implemented Product Costing (CO-PC), Cost object controlling (CO-PC-OBJ) and Material Ledger (CO-ML) modules for Make to Stock (MTS) and Make to Order (MTO) scenarios in Discrete, Repetitive and Process Manufacturing.
- Through knowledge in using Product cost by Production / process order & Product cost by period, for Discrete & Repetitive Manufacturing in MTS scenario and Product cost by sales order for variant configuration and repetitive manufacturing with sales order stock in MTO scenario.
- Worked on CO-production order, Special Procurement keys, Scrap Costing, Failure costing, costing for Joint production and sub-contracting materials.
- Implemented (CO-ML) Material Ledger for valuating Inventory in multiple currencies, calculating Actual cost through Single/Multi Level price determination and calculating WIP at Actual Cost.
- Understood External and Intercompany billing process along with other sales scenarios to implement Costing based CO-PA with HANA to handle high business volume and improve performance.
- Migrated data GL Balances, A/P and A/R open items, Asset Data, Costing data and inventory from JDEdwards and Legacy systems.
- Strong working knowledge on inbound and outbound interfaces, Report writer/painter, ABAP query, SQVI, Debugging, EDI, IDOC, ALE, BADI, BAPI, LSMW, and Batch Data Communication (BDC).
- Expertise in writing Functional specs, Test cases, customized materials, User manuals, concepts slides, Business Process Procedures (BPP), quick guides, and simulations for s.
SOFTWARE EXPERTISE
ERP Packages: SAP R/3 4.0-4.7, ECC 6.0 EPH 7
Software tools: MS Access, MS Excel, MS Word, Outlook, PowerPoint, Microsoft Visio & Front Page
PROFESSIONAL EXPERIENCE:
Confidential, Harleyville, SC
SAP FI-CO-PS Lead Consultant
Full Life Cycle implementation / SAP ECC 6.0.
- As an FI-CO-PS consultant responsible for rolling out template design to US sites and implementing Product Costing, Material Ledger, CO-PA, Project systems, EBS, LOCKBOX and Tax (Vertex)
- Developed an integrated solution to post the planning data in CO-PA from Excel.
- Implementation of Costing based CO-PA includes creation and derivation of Characteristics, Value fields, Integration of CO-PC, CO-ML, MM, FI, PS & SD and Report painter reports for Management P&L and many sales related reports.
- Provided solution to include the Depreciation cost in the standard cost estimation. Provided solution using Template allocation to calculate the Material overhead based on the Gross weight for certain materials.
- Used CO Production orders to allocate the single freight invoice to inventory of multiple materials in the plant where production planning module was not implemented.
- Worked with the SD and MM consultant to determine the stock in transit (SIT) of the materials in Material Ledger
- Developed the custom program to replicate the standard transaction for order revaluation and settlement, since the selection criteria related to organizational structure is not available in the standard transactions
- Involved in implementing Project systems (PS) to collect the costs related to overhaul Maintenance in the WBS elements and designed the settlement profiles to settle the WBS to the appropriate cost centers (Integration of FI-CO-PS-PM)
- Involved in implementing Project systems for handling the CAPEX projects (Integration: FI-AA-IM-PS).
- Setup the system to automate the Material Ledger close to improve the performance.
- Utilized the Logistics Information System (LIS) to read the sales order quantity and post in statistical key figures (CO-SKF). Later the SKF is used in the cost center allocations.
- Used the Indirect activity allocation to allocate the Energy costs to the production cost centers based on the activity confirmation from Production planning module.
- Implemented the Distribution of Usage variance in Material Ledger to distribute the Physical inventory difference and Activity difference.
- Based on the requirement from corporate controllers streamlined the cost allocation process across the organization using Cost center distribution, assessments and Top-Distribution in CO-PA.
- Built a custom solution to automate the cross-company clearing while processing the LOCKBOX file.
- Co-ordinated with Wells Fargo bank and implemented the Electronic Bank Statement (EBS) Functionality.
- Involved in discussion with VERTEX team to setup the Tax Interface and coordinated the configuration for calculating the Sales tax and Use Tax.
- Built various SQVI reports and assigned the custom Transaction code for easy access and better security control.
- Developed solution to automatically post the Journal entries from ADP payroll interface.
- Worked with the ABAPers to develop the LSMWs for migrating GL Balances, AR open items, AP open items and Asset Masters and its transactions from JDEdwards to SAP.
- Created End user manuals and conducted End user s on various topics from Basic navigation to Month / year end closing and Reporting.
Confidential
Indianapolis, IN
SAP CO-PA/CO-PC Consultant
US Roll out / SAP ECC 6.0.
- Integrated Material Ledger and COPA to post the standard cost and variance by cost components in different value fields.
- Built a Custom report to analyze the actual cost component split for multiple materials by the reading the values in Material ledger. In other words, it is similar to massive CKM3N in material ledger.
- Analyzed the business scenarios and Integrated SD and COPA by mapping the Condition Types to Value Fields.
- Created a custom solution to avoid the rounding issue in the cost component split in COPA. This solution avoided the reconciliation issues between FI and COPA.
- Used the Allocation structure and PA transfer structures in COPA cycles to reduce the number of segments which reduces the maintenance efforts.
- Implemented a BADI to change the settlement receiver in the production or process order from Material to GL account based on the Inventory risk or Production risk.
- Designed a custom report to display all the Production order and Product cost collector settlement error logs in detail, which helped the users to act on the error quickly during the Month end close.
- Used the standard Report Painter functionality to include the Company code in cost center accounting reports, which helped the business user to view site specific information in the global controlling area.
- Designed the custom program to upload the master data such as GL accounts, Cost elements, cost centers, profit centers and WBS elements.
- Designed the custom program to upload the SD and MM pricing condition records.
- Involved in Month end closing and assisted the business user in ML Close, COGS revaluation and Allocations.
- Co-ordinated the Data Migration for all FICO objects. Worked with the business to determine the mapping rules between the legacy and new system and coordinated the migration through a direct table update tool called - T Bone.
Confidential
Englewood Cliffs, NJ
Senior SAP CO-PA/CO-PC Consultant
Full Life Cycle implementation & Rollout / SAP ECC 6.0.
- Implemented Costing based COPA with HANA, Product Costing and Material Ledger for Unilever North America, Canada, Mexico and Brazil
- Designed a common Cost component structure for Primary cost component split in cost center accounting & product costing integrated them with CO-PA using the valuation strategies. This helped the business in understanding the expenses behind the activity types.
- To analyze the costs of different Raw Materials in Production, designed the Auxiliary cost components in CO-PC and integrated them with CO-PA using the valuation strategy.
- Used the Switching structure in Cost center accounting to flip the estimations between the cost component structures.
- Activated Material ledger for all the manufacturing plants with the single/Multi level price determination.
- Implemented costing process using special procurement keys and Transfer control in the scenario where manufacturing of finished goods and semi-finished goods were happening across plants in different company codes.
- Worked with the MDM team and business to design the Global product hierarchy and Customer hierarchy and derive them in COPA.
- To reduce the number of profitability segments and improve the performance, only the certain levels in the hierarchy which required for posting has been included in the operating concern and the remaining levels will be directly derived in BW repots.
- Unlike standard product hierarchy, the business has 14 levels with 34 characters length, maintained in classification view of the material master. Created the derivation rules in COPA to derive the product hierarchy and designed a solution to address the hierarchy changes every year.
- Created validation rules for customer hierarchy through standard derivation rules to avoid users from entering wrong levels in the hierarchy. This validation avoided further implications in allocation.
- Created user defined characteristics where needed and their corresponding derivation rules as well. Used the COPA user exit COPA0001 also when there are limitations with functionalities in standard derivation rules.
- Created user defined characteristics and derivation rules for the mixed pack products.
- Analyzed the P&L and worked with the business to design the value fields required for profitability analysis.
- Worked intensively in handling the sign while designing the Value field. Handled the sign issue using the COPA user exit COPA0005.
- Designed the Quantity value fields for different UoM and configured to populate by reading the material master.
- Studied all the OTC various scenarios and designed the integration between SD and COPA. Based on the Condition type mapping to GL accounts, identified and mapped the Condition type to Value field with sign issue also into consideration.
- Used the COPA user exit COPA0005 to move the values from one value field to another to make sure that the FI posting from OTC and posting in VF belong to same FS item from the P&L perspective.
- Integrated CO-PC and CO-PA by linking Main and Auxiliary cost component structure to Value fields through valuation strategy to get the standard cost component split COPA at the time of billing.
- Integrated ML and COPA to get the actual cost component in COPA. Also designed the KE27 variant to run during the month end.
- Defined additional costing keys to read the future cost if the released cost is not available. This design made sure that billing will not be stopped when there is no released standard cost and also the COGS in COPA will be corrected by ML to COPA process
- Integrated COPA with Warehousing & Transportation (WT) to post the freight cost to COPA while settling the shipment cost to FI.
- Created a validation rule in FI to make sure that all the FI postings in Cost elements type 11 and 12 has the COPA characteristics. This validation rule made sure that P&L report from FI and COPA matches at profit center level.
- Created Characteristic groups to make sure that only certain characteristics are allowed for FI/MM.
- Used COPA user exit COPA0003 to handle the exceptions to allow FI postings to characteristics not included in the characteristic group. This avoided the impacts on FI postings from the legacy systems and the interfaces.
- Designed external CO-PA transfer (KEFC) to upload COPA only entries from Excel file.
- Prototyped the I-Doc process to address the external billing to bring the discounts offered by the legacy system.
- Designed the solution using BAPI to create two set of COPA docs for different segments from one billing doc. Since the New GL is not integrated completely with COPA.
- Involved in realignment of COPA docs using the transaction KEND to address the changes in customer and product hierarchy.
- By standard, the Freight posting to COPA will derive the 3rd party customer from the delivery doc. But the requirement is to analyze the profit by Intercompany customer. Thus created the enhancement step in derivation rules to change the customer from 3rd party to intercompany.
- Integrated New GL and COPA to post the Gain or loss created through foreign currency revaluation program.
- Worked intensively in Top down distribution to distribute the amounts posted at higher levels down to SKU and customer and also Designed the Top down distribution cockpit to update the periods and characteristic values.
- Designed basic reports, form based reports and line item reports to run on both HANA and COPA summarization levels.
- Worked closely with SAP AG, to implement HANA and assisted in improving the performance of reporting, cost center assessments and Top down distributions by more than 50%.
- Built custom reports to reconcile FI and CO-PA at different levels such as company code, Management unit, segment and transaction levels.
- Worked closely with the BW team to provide inputs related to COPA design to get the MSBI report aligned with COPA data.
- Built a custom solution to split the secondary freight cost from CASS interface and post it to the appropriate cost component in the material ledger. This solution allowed the business to include the secondary freight in inventory valuation and determine the correct actual cost.
- Built an Excel based upload tool to adjust the inventory value of a material (MR22) for the plants with Material ledger active. It avoided the issues with currency conversion and manual effort.
- Built a Custom tool to upload the additive costs are planned in the Business Planning and Consolidation (BPC) Module.
- Used the Indirect activity allocation in cost center accounting along with the switching structure.
- Suggested the business to use the allocation structure in the cost center assessments, which reduced the number of segments in each cycle and helped improving the performance.
Confidential
Delavan, WI
SAP Controlling Consultant
US Rollout / SAP ECC 6.0.
- As a CO Consultant responsible for implementing Product Costing and Costing based Profitability Analysis (CO-PA).
- Implemented Mixed Costing to combine the procurement of material from different vendors.
- Involved in configuring Cost Component Structure, Costing Variants and Overhead Costing sheets.
- Devised the solution using eCATT to automate the process of creating the Standard Cost estimation
- Implemented the costing process for the sub-contract materials through reading the Purchase info records.
- Through the standard functionality, Setup the Excel based interface to load the plan Statistical Key Figures (SKFs) to act as the allocation driver in cost center assessments.
- Provided solution using the special procurement keys to determine the standard cost estimate of the finished goods, whose intermediate component materials were manufactured in different plants under the same company code.
- Prototyped the single/Multi level price determination in Material ledger and designed the Account determinations for posting the Price difference and COGS revaluation in FI.
- Designed the Failure costing process which helped the business to track and report the rework costs for the Finished Goods rejected and not scraped in quality check process.
Confidential
Rosemead, CA
SAP FI-CO Consultant
SAP ECC 6.0.
- Implemented New GL and activated document splitting by Segment, profit center and business unit.
- Maintained the Leading ledger and Parallel ledger to activate the parallel accounting for US GAAP.
- Created a customer field “Business unit” in FI-New GL, to get the financial statement by business unit.
- Maintained the Confidential to ease the postings in multiple ledgers simultaneously.
- Designed the system for real time integration with CO using New GL functionalities.
- Designed the Foreign currency revaluation process to post the realized and unrealized gain or loss on the AR open items and bank accounts with foreign currency.
- Implemented the Automatic accounts payable for check, electronic and wire payments.
- Worked with JP Morgan Chase Bank to design the LOCKBOX process using BAI2 Format.
- Implemented the Electronic Bank statement (EBS) in BAI format.
- Created Internal Orders, assigned the costs related to that internal order from different cost centers.
- Defined Order types, settlement profile, Settlement structure & settlement cost element for IO settlements.
- Customized the SD - FI interface by preparing the Revenue account determination process. Allocate the G/L accounts for various combinations of terms in access sequences Application, Account determination type, Chart of Accounts, Sales Org, and Customer Account assignment group
- Optimized the automatic provision process for bad debts according to the document splitting in New GL.
- Implemented the In-house banks functionality to centralize the cash flow across the company
- Configured the FI - MM automatic account assignment based on Valuation class, gen. modifier, valuation area and linked to movement and transaction type.
. Confidential
Waltham, MA
SAP Controlling Consultant
SAP ECC 6.0.
- Involved in implementing CO-PC by production order (MTS scenario) and sales order (MTO Scenario) and Costing based - COPA .
- Designed the Costing type, valuation variant, date control, quantity structure control, transfer control and variant for defining costing variant in product costing CO-PC
- Defined origin groups, overhead keys, overhead groups and cost component structure.
- Defined costing sheets for calculating Overhead (percentage based overhead calculation).
- Configured Material Cost Estimate with Quantity Structure, costing variant, cost component structure—with structures like BOM and Routing for costing the product provided by PP.
- Defined variance keys, valuation variants for WIP and scrap, target cost versions for variance calculation and result analysis keys, result analysis version, valuation methods, line ids and assignment for work in process ( WIP ).
- Created a standard Report painter report to analyze different categories of variance for the plant and production order.
- Built an Excel based solution to change the price in the material master. It saved the time, avoided the manual error and provided the simulation of inventory adjustments after the price change of the material
- Used the Primary cost component split in cost center accounting and transferred it to auxiliary cost component in CO-PC to explain the costs behind each activity type in the Main cost component structure.
- Integrated Primary cost component split in cost center accounting to COPA value fields through the valuation strategy.
- Created cost component groups to display the cost components in columns in the standard cost estimate reports and BOM reports. This functionality helped the business to compare the cost components of various materials.
- Designed the product costing module to separate the scrap variance from other production variances, which helped the business to handle the scrap costs efficiently.
- Created a custom ALV report to combine the planned scrap maintained in different places of SAP - (MRP1 view, MRP 4 view, Component scrap in BOM, Operations scrap in BOM and operations scrap in routing) and actual scrap quantities to analyze the scrap variance in detail.
- Configured production order as a cost object to collect actual costs, plan costs and determine WIP at the end of every period, variance calculation after the order technically completed.
- Configured costing based CO-PA, created characteristics and value fields, used various derivation techniques and rules, configured valuation using product costing and costing sheet.
- Configured CO-PA planning, including creating planning levels plan package and planning methods and mapped SD condition types to value fields in CO-PA.
- Defined summarization levels to call up data stored in Profitability analysis and generated Reports on different profitability segments using the data from CO-PA tables.
- Prepared month end close and setting up the master data for Allocations (Assessments and Distribution).
Confidential
Eden Prairie, MN
SAP FI/CO Consultant
SAP R/3 4.7 to ECC 6.0
- Responsible for implementing New GL and CO-Production order to get postings of goods movements from the newly procured plant which is running of legacy system - “Quintiq”
- Redesigned COPA to accommodate new changes made in FI and CO, which includes defining new characteristics and value fields
- Integrated SAP with Non-SAP Production planning system - “Quintiq” through the standard CO Production orders.
- Created a custom solution to post the actual activity to CO-Production Orders from the Legacy systems.
- Worked in the environment where the Goods issue and Goods receipt are posted into CO Production orders from the legacy system (“Quintiq”) using the IDOC.
- Addressed the limitation of 999 line items in accounting entries generated from Interfaces, billing and Goods issue through user exits.
- Designed the system to calculate the WIP and Variance for the product costing by CO-production order.
- Implemented New GL and Co-ordinated the testing activities for the areas of FI-GL, accounts payable, accounts receivable transactions.
- Designed the solution using standard SAP to make automatic provisions and reversals for the Bad debts.
- Implementation of new house banks and integration of cash flow.
- Activated the document splitting process for the characteristics segment and profit center. It helped the business to get the Financial statements and management reporting below the company code level.
Confidential
Philadelphia, PA
SAP Business Analyst
SAP R/3 4.7
- Designed leading ledger for consolidated financial reporting and non leading ledgers for local accounting requirement with alternate currencies and different fiscal year variants.
- Defined segments based on reporting requirements and derived them from Profit Center master data.
- Defined the scenarios in the ledger to update the fields like consolidation transaction type, segment and Profit Center from postings
- Activated document splitting functionality by defining the document split method with business transaction and variant.
- Coordinated migration of production data (planning and reconciliation) into New GL using SAP Migration cockpit.
- Designed the system to calculate the Sales tax and Use Tax though TAXWARE.
- Designed the custom drilldown report to generate the financial statements by Company code, Business area and by Profit center.
- Created Validation and substitutions for FI and Cost Accounting on both line item and header level
- Complete Fixed Assets configuration: Designed the Chart of depreciation, defined allowed depreciation areas, defined depreciation types and keys, Asset classes, master data layout, account determination by class for acquisition, retirement, accumulated depreciation and expense accounts.
- Responsible for the Fixed Asset module design and integration in the new system, right from data collection, migration to reconciliation in the new system.
Confidential
Huston, TX
SAP Business Analyst
SAP R/3 4.6c
- The scope of the project is to optimize the controlling module and to implement the product costing module and CO-PA modules.
- Created cost centers, activity types, statistical key figures, Cost Center Standard Hierarchy, cost center categories, document numbers, maintained default account assignments and automatic account assignments, validations and substitutions, overhead structure for accrual costs, allocations using cycle-segment method for periodic reposting, distribution and assessment, indirect activity allocations. Developed planning area, planning layout and planner profile.
- Configuring and Customizing Product Cost Planning (CO-PC-PCP) with Quantity Structure and Cost Object Controlling (CO-PC-COC) including product cost by order.
- Based on the Management reporting requirements designed the Characteristic and Value-fields in Costing based COPA.
- Configured settlements of price and quantity variances of materials and activities to respective value fields through PA transfer structure.
- Created the management P&L and other sales report through information systems in CO-PA module.
Confidential
Emeryville, CA
SAP Business Analyst
SAP R/3 4.6c
- Participated in full life cycle implementation of SAP R/3 using ASAP Methodology.
- Based on organizational structure configured company codes, currency settings, assigned document ranges, posting period variants organizational structure and tolerance groups for employees.
- Configured the system for Automatic payment run which includes configuring house banks.
- Work extensively Configuring Lockbox for automatic clearing of AR open items.
- Setup the dunning process to create aging reports.
- Configured the system to handle various receivables scenarios (over, shorts, down payments, reversals and resets, credit memos and adjustments etc.).
- Configured Controlling Area and Operating Concern, maintained versions.
- Designed structure for Cost center Accounting, Profit center Accounting and Internal orders.
- Configured and Customized Internal Orders to collect the temporary expense and created settlement rules to allocate to appropriate cost centers.
- Worked on chart of depreciation, inter-company asset transfers and asset retirements.
- Configured the system to post the automatic GR/IR adjustments.
- Assisted in Data Migration and cutover activities.
- Involved in cutover, end user and post go-live production support.
Confidential
SAP Jr. Business Analyst
SAP R/3 4.6b
- As a Team Member responsible for supporting day to day business activities in FI module and assist in project enhancements.
- Resolved issues related to GL, Accounts Payable, Accounts Receivable, Asset Accounting and Cost center accounting.
- Assisted business in Month end and year end closing activities.
- Created Cost center Assessments and Distributions to address the business requirements related to cost allocations.
- Involved in enhancements related to Foreign currency revaluation and interest calculation.
- Created reports using report painters and report writers.
.
