Sr.sap Fico Consultant Resume
Houston, TX
SUMMARY
- SAP FI/CO Functional Consultant with 8 plus years of functional experience in Financial Accounting (FI) and Controlling (CO) modules and integration with logistics modules (SD and MM).
- Worked in 3 Full cycle implementations using ASAP (Accelerated SAP) methodology with experience in all project phases - Business blue print, Realization, Final preparation, Go-live and Support and post live production support, with documentation.
- SAP experience encompasses expertise in Implementing, Customizing, Configuring System upgrade, Integrating, Testing, End to End testing, End User, Data migration and support of R/3 with different versions including ECC 6.0 and in phases like Cut-Over, Deliver, Go-live and Post Go-live.
- Extensive hands on experience in Financial Accounting (FI) including General Ledger (GL), New G/L, Accounts Payable (AP), Accounts Receivable (AR), Asset Accounting (AA), Bank Accounting (BA) and Special Purpose Ledger.
- Controlling experience includes Cost element Accounting, Cost Center Accounting (CCA), Internal Orders, Product Costing (PC), Material Ledger, Profitability Analysis (COPA), Profit Center Accounting (PCA) and Consolidation.
- SAP functional experience with implementation, configuration and support for PS (Project Systems) module. Expertise in Providing application functional support and implementation in SAP Applications R/3, in the module areas of Project Systems (WBS, Project Accounting, Project Planning, Resource Planning, Budgeting, and Cost Planning).
- Configuration Experience in Open Text- Vendor Invoice Management (VIM) including End to End workflow, assigning new roles, exceptions, enhancements and interface objects.
- Experience in configuration of Automatic Payment Program (APP), Lockbox, Electronic Bank Statement (EBS), check management, Document Splitting and Zero balancing of Documents in New G/L.
- Extensive exposure to IFRS, US GAAP/GASB 34/IPSAS, Logistics Invoice Verification (LIV), Order to Cash (OTC) and Procurement to Pay (PTP) process.
- In depth experience in data transfers from CCA, PCA, and Internal Orders for Profitability Analysis.
- Ability to work as a SAP techno-functional consultant with sound knowledge in ABAP Queries, Reporting Tools: Report Painter and Report Writer, User-exit programming, CATTs Programming and Debugging, Proficiency in writing the Functional and Technical Specifications for development objects (RICEFW).
- Worked with BAPI, BADI, ALE, SQVI, EDI/IDOC, User exits, Foreign Currency Translation. Very good exposure to Compliances like GXP, SOX, GMP, FDA, IFRS.
- Ability to drive toward a standard FSCM (Financial Supply Chain Management) solutions including Funds Management, In-House cash management, Biller Direct, Credit Management, internal Treasury Reporting, Authorization objects, Budget Entries, FM area, Funds Center, Commitment items, Availability control.
- Sound Knowledge in migration of data from Legacy system to SAP for Upgrade / New implementation / integration using LSMW, CATTs.
- Good team player, strong interpersonal, great communication skills combined with self-motivation, initiative and project management attributes.
TECHNICAL SKILLS
ERP: SAP R/3,4.6C/4.7, ECC5.0, ECC6.0
Languages: ABAP, C, C++, SQL, PL/SQL, JSP
R/3 interface: EDI, IDOC, Vertex and BAPI
Operating system: MS Windows 98/2000/XP & VISTA, MS-DOS, UNIXMS-Excel Vlookup, Formatting, Validations, Formulae, Macros
PROFESSIONAL EXPERIENCE
Confidential, Houston, TX
Sr.SAP FICO Consultant
Responsibilities:
- Analyzed the organizational structure, business process and provided business analysis in the form of Blue print document for Demand planning and Distribution requirement planning.
- Worked in various FI aspects relating to AR and AP issues, Recurring entries carry forward balances, residual/ partial payment settings for vendors and customers, down payments, reversal of documents and exchange documents, House Banks, Automatic Payment program (APP). Involved in optimizing bank details for wire payments, check lots, void reason codes and clearing inter-company vendor open items.
- Configured end-to-end business process for FI (Accounts Payable)-MM integration work flow of Procure to Pay Cycle and worked closely with SD Consultants for integration of FI (Accounts Receivable)-SD for the Order to Cash cycle. Configured Automatic Account determinations for different material movements and valuation classes.
- Designed, configured and implemented accounts payable check printing, periodic Sales and US tax reporting, and related month end financial reports.
- Experience in SAPR3 including functional requirements gathering, functional testing, R/3 customizing/configuration, ABAP & BW programming and also worked on UTL SAP IS-U, Device Management.
- End-to- End implementation experience of Open Text VIM. Configured solution for PC and non PO based invoices including 3-way and 2-way match scenarios in Open Text VIM.
- Configured document type settings i.e. document process, process determination sequence, set sequence, index screen in Open Text VIM. Also worked on ICC/OCR setup for application creation per Archive document type and hotspot set up, batch jobs for invoice capture center dispatcher in Open Text VIM.
- Identified invoice standards and multiple formats that includes single sided invoices, multi folded invoices, multi- page invoice with variant dpi in Vendor Invoice Management (VIM).
- Configured VIM reports/Analytics in order to analyze and to provide updated progress status of invoice in a unified dashboard.
- Worked on new G/L implementation for managerial and financial accounting, including segment reporting also configured settings for activating cost of goods accounting.
- Configured lockbox processing with control parameters and posting data to handle incoming customer payments using BAI2 format, Worked on EBS, Positive pay, ACH payments and Wire Transfer.
- Enhanced functionality of transfer of overhead costs from Cost center accounting on a periodic basis and transfer of activities indirectly into profitability analysis segment also designed the PA transfer structure to control the secondary cost elements.
- Maintained assessment cycles and the relationship of cost elements to profitability segments for transferring overhead costs to COPA.
- Wrote Functional Specifications using RICEFW (Reports, Interface, conversion Enhancement, Forms and Workflow) objects for better reporting for the management.
- Configured tax, used calculation procedure TAXUSX to handle the US sales and use tax calculations.
Environment: ECC 6.0, SAP SRM, Open Text VIM, HPQC, OneSource, SharePoint, IFRS. Modules: GL, New GL AP, AR, AA, Inflation Accounting CCA, PCA, COPC, COPA, TR, CM, LIV, P2P, Taxes, Intercompany, Lockbox, EBS, Report writer/Report Painter and Project System.
Confidential, Houston, TX
Sr.SAP FICO Consultant
Responsibilities:
- Involved with all phases of implementation from development of business blueprint, conducting workshops, GAP Analysis.
- The project involved detailed study of the entire accounting operations, studying the current business process, organization structure finalizing and mapping & configuring of to-be Business process and providing necessary support.
- Configured and customized Chart of accounts, Company code Global Parameters, Fiscal year Variants, Posting Period Variants, Account Groups, Field Status Groups, and Tolerance Groups.
- Worked with multiple currencies, US taxes and sales taxes, Maintained tax codes and tax jurisdiction codes for company codes worked with Tax ware.
- Created Lock box, Bank Master Data, House banks, G/L accounts for each bank account and Reconciliation accounts for vendors, customers and assets.
- Worked on EBS, Positive pay, ACH payments using NACHA file formats, and Wire Transfer.
- Configured automatic payment program (FBZP) for outgoing payments, which included payment methods, bank accounts and ranking order of bank accounts, and automatic account determination using FBKP.
- Created check lots, voided checks for payment blockage, and reissue of destroyed checks. Expertise in LSMW for data migration from Legacy system to SAP system. Enhancements to existing Validations and Substitutions for FI module.
- Implemented Open Text VIM for document type, process type, Invoice Capture Center (ICC), and OCR configuration in Open Text VIM.
- Configured Archive Link document types in VIM and liked SAP Business objects to respective document types. Configured EDI interfaces for field mapping in VIM.
- Created new procedure for parallel accounting, merged various FI ledgers, worked on new G/L migrating special ledger or profit center.
- Configured Inflation accounting for Material and Asset revaluation for Chile local and IFRS reporting.
- Maintained Inflation Index, Time base and exposure to inflation variant, Inflation methods, Assign inflation method to company code, maintain material inflation class, maintain account determination, define inflation adjustment accounts as a the part of implementing inflation accounting to revaluate the material and assets.
- Configured reconciliation accounts and alternative reconciliation accounts, tolerance groups for employees, G/L accounts, Vendors and Customers.
- Assigned Number Ranges for Documents, Vendors and Customers, reconciliation Accounts for Vendors and Customers.
- Worked on different Consolidation (ECCS) levels like Statutory Consolidation, Business Area Consolidation and Profit Center Consolidation.
- Maintained the budget profiles and tolerance limit for the availability control, defined the Project coding mask, by creating the project file and status profile in Project Systems (PS).
- Configured credit control area, cost elements, cost centers, profit centers, costing based COPA, account based COPA, created characteristic and value fields, and configured valuation-using product costing sheet.
- Extensively worked on cost estimate updates, costing run in Product Costing, implemented Material Cost Estimate with Quantity Structure like BOM&PIR and Configured Costing Variants for Base Planning Object, standard cost estimate and current cost estimate.
- Defined Costing Type, Valuation Variant, Date Control, Quantity Structure Control, and Transfer Strategy for the costing variants in Product Costing.
- Configured Costing Variants for Preliminary Costing in Cost Object Controlling,
- Maintained overhead cost elements, defined costing sheets, allocations and settlements in CO.
- Sound knowledge in foreign currency revaluation, individual value adjustment and flat rate individual value adjustment.
- Experience with FSCM Credit Management, Dispute Management, and Collections Management.
- Responsible for carrying out Valuation in COPA planning to access pricing and product cost information for products having planned quantities, thereby allowing projected revenue and cost-of-sales figures to be calculated automatically.
- Defined internal order types, planning and settlement profile and created standard hierarchy, dummy profit center, distribution and assessments in CO-PCA.
- Maintained number ranges for settlement and controlling documents, and for variance documents, used report painter and report writer.
- Proficiency in writing Functional Specs for all RICEFW (Reports, Interfaces, Conversions, Enhancements, Forms, Workflow) objects.
- Designed and configured Asset Management to carry out business transactions like acquisitions, retirement, transfers, depreciation calculation, write-offs and post capitalization.
- Prepared the Cutover plan and carried out cutover tasks as per schedule and frequent meetings for discussion of issues, new requirement and fixing bugs.
Environment: ECC 6.0, SAP SRM, Open Text Vertex, Visio, BizTalk. Modules: GL, New GL, AP, AR, Asset Accounting, Bank Accounting, Cash Management, Internal Orders, Cost Center Accounting, Cost Element Accounting, Inter Company, Procure to Pay, Order to Cash, Taxes, LIV, COPA, User Exits, LSMW, EDI, IDOC, RICEFW.
Confidential
Sr.SAP FICO Consultant
Responsibilities:
- Understood the business process and studies the current implementation of various modules AP, AR, GL Controlling, FSCM, PS, CRM, SD and MM.
- Enhanced Automatic Payment Program functionality for outgoing Payments in Accounts Payable to include additional Payment methods like Check, Wire transfer and ACH Payments.
- Configured for leading ledger to add various scenarios like cost center update, profit center update, segment and defined additional currencies such as Hard currency and group currency for leading ledger in New GL.
- Configured settings for Document Splitting to create segment financial statements and defined Zero balance Clearing Account. Classified GL Accounts for Document splitting and defined splitting characteristics for General Ledger Accounting and Controlling.
- In Project Systems (PS) defined the Project coding mask, created the project file and status profile. Maintained the budget profiles and tolerance limit for the availability control.
- Configured settings for EDI for incoming invoices and IDOCS for Payment Program.
- Configured Account groups for customer master and Partner determination procedures for customers. Configured Settings for Lockbox Processing and Bank lockbox format to SAP Lockbox format (BAI2) and Post processing of Lockbox data.
- Configured Reason Codes, correspondence types and automatic clearing of open items.
- Created primary and secondary cost elements, cost element groups and maintained cost element attributes in Cost Element Accounting.
- Configured PM order Types, Service Order types, Settlement Profiles, Allocation structures, Source structure for settlement of PM orders.
- Enhanced basic settings standard hierarchy, dummy profit center, Distribution and Assessments, CO-Objects to Profit Centers in Profit Center Accounting (PCA).
- Responsible for carrying out Valuation in COPA planning to access pricing and product cost information for products having planned quantities, thereby allowing projected revenue and cost-of-sales figures to be calculated automatically.
- Configured the Material Cost estimate with Quantity Structure and Configured the cost component structure, Costing variants for standard cost estimate for planned and actual Production orders in Product Costing Planning (COPC).
- Maintained Overhead cost elements, calculation bases, credits, costing sheets, activity plan, and costing types in Product Costing. Integrated Cost Object Controlling (CO-PC-OBJ) component in the R/3 System, for planned budget using various costing methods, Cost Split, Cost and Valuation Variants in Product Cost Planning.
- Extensively worked on Cost Object controlling period ending activities such as WIP calculations, Variance calculations, settlements of process orders, cost estimate updates, costing run, marking and releasing for updating the price in material master records, display reports etc. Analyzed Material Ledger, results analysis and product costing in Make-to-Order (MTO) procedures.
- Implemented FASB52 (Foreign Currency Revaluation), Used LSMW to load Cost center, Profit Center, Customer, Vendor Master Data. Tested with ABAPer in the process of writing functional specs using RICEFW objects.
Environment: ECC 6.0, Vertex, Visio. Modules: GL, New GL AP, AR, AA, CCA, PCA, COPC, COPA, CM, LIV, P2P, Taxes, Intercompany.
Confidential, Houston, TX
Sr. SAP FICO Consultant
Responsibilities:
- Worked on areas of AP, House Banks and Automatic Payment program (APP).
- Involved in optimizing bank details for wire payments, check lots, void reason codes and clearing inter-company vendor/customer open items.
- Configured customer account groups, tolerance groups, performed credit management, account assignments, defined various payment terms as per the client specific requirements for Accounts Receivables.
- Identified one-time Vendors and Customers and defined a separate screen layout for them according to the requirement of the client. Worked on different tax modules like withholding tax, tax jurisdiction code.
- Made necessary settings for the account assignment model for Recurring and Periodic entries, Bank master data, and House Banks for the payment program.
- Maintained Lockbox configuration with BAI2 format, cash management and planning levels in treasury and worked on Electronic bank statements (EBS). Managed multiple ledgers within the general ledger according to the client requirements, worked on parallel accounting model following the rules of New GL.
- Assigned new scenarios to the leading ledger like Cost center update, Preparations for Consolidation, Profit Center Update and Segmentation. Created integrated asset acquisition and defined account assignment type for Asset Account, Account Assignment Objects for the Depreciation Areas.
- Made settings for the Dunning procedure and configured the dunning procedure. Configured the system to deduct a cash discount for payment of fixed asset invoice automatically and in real time, to the corresponding asset.
- Configured setting for revaluation of fixed assets, normal depreciation run and posting of asset acquisition.
- Configured Cost center accounting (CCA), Profit center Accounting (PCA), Internal Orders (IO), and Profitability Analysis (PA).
- Tested report generation using reporting tools Report Painter and report writer and performed end user and documented materials for the users.
- Have worked on solution manager and diagnostics, Configuration of solution manager and created role for solution manager.
Environment: ECC 6.0, SAP ARIBA, Tax ware, Visio. Modules: GL, New GL, AP, AR, Asset Accounting, Bank Accounting, Cash Management, Internal Orders, Cost Center Accounting, Cost Element Accounting, Inter Company, Procure to Pay, Order to Cash, Taxes, LIV, COPA, User Exits, LSMW, EDI, IDOC, BAPI, RICEFW
Confidential
SAP FICO Consultant
Responsibilities:
- Participated in blueprinting phase using ASAP (Accelerated SAP) Methodology.
- Configured House banks, Bank accounts, GL structure, posting rules for automatic assignment and Automatic Payment Program (APP) configuration.
- Maintained relations with Banks by resolving the issues in receiving Flat file for processing customer remittances.
- Worked on creation of Asset classes, depreciation types, depreciation areas Specified Automatic Account Assignments to link asset master data to G/L accounts; Created depreciation keys with assignment to depreciation areas.
- Configured and worked on Project Structures, PS Financials - Financial transactions, calculations and evaluations of project performance, PS Cross Application Time Sheets, PS reporting.
- Extensively worked to design/configure business processes in SAPPS to support the planning, control and monitoring of programs/projects including limiting actions that can be performed.
- Worked on Credit Management and Credit control areas, interest calculation and developed Assessment, Distribution, Periodic reposting cycles and segment.
- Configured and used LSMW for uploading master data of General Ledger, Customers and Vendors. Worked on CATT’s for creation and modification of master data of G/L accounts, Customers, Vendors.
- Executed test scripts for various business processes related to Accounts Receivable, Accounts Payable, Controlling, Internal Orders, Funds and Grants Management.
- Helped the team to develop material.
Environment: ECC 5.0, SAP BI, Visio, SAP CRM Modules: G/L, AP, AR, BA, AA, Automatic Payment Program (APP), Project Systems (PS), Cost Center Accounting (CCA), Assessments, Distributions, Profitability Analysis (CO-PA), Internal Orders (IO), LIV, P2P, OTC, Report Painter/Report Writer, Lockbox, EBS, LSMW, Interest Calculation.
Confidential
SAP FICO Consultant
Responsibilities:
- Studied And Understood the Changes in the Standard SAP System for the new version and prepare change configuration scripts.
- Team member of the customization and implementation group of the FI/CO Module.
- Interacted with Business Users for Requirements Gathering and Analysis.
- Prepared a document of all the changes made, bug fixes, revised the Business Process Procedures to facilitate the changes during the Upgrade.
- Activated Created Leading and Non Leading Ledgers for the different Company Codes and activated Parallel Accounting for the Different Accounting Principles.
- Releasing the Cost Estimate in Price Updating and defined Profit Center Hierarchy and Cost Center Hierarchy.
- Configured Material Cost Estimate with Quantity Structure and calculated costs on Production Order, Standard and Modified Cost Estimate and worked on Price Update.
- Configured Costing Variant, Valuation Variant, Cost Component Split, Cost Component Structure, BOM and Route Settings. Created Cost Center groups and Cost Centers, Primary and Secondary Cost Elements.
- Used Report Painter, Report Writer for reporting during the implementation of the project and developed reports.
Environment: SAP R/3 4.7, Vertex, Visio Modules: GL, AP, AR, Asset Accounting, Bank Accounting, Cash Management, Cost Center Accounting, Cost Element Accounting, Internal Order, Procure to Pay, Order to Cash, Taxes, LIV, COPA, User Exits, LSMW, EDI, IDOC, BAPI, RICEFW