Sr. Sap Fico Consultant Resume
4.00/5 (Submit Your Rating)
GA
SUMMARY:
- 11+ years of versatile and ingenious experience as a SAP Functional Consultant in Designing, Business Process Re - engineering, Implementing, Customizing, Configuring, Integrating, Testing, Go-Live & Supporting.
- 4+ Full Life Cycle Implementations experience in all Configurations that includes Upgrades, Roll-Outs, Supports and Training phases for SAP FICO & 1 Full Life Cycle Implementation Experience for SAP MM ( P2P Process).
- Interacted with Business Partners to Understand the AS-IS Process & worked on developing TO-BE Process.
- Excellent Financial Accounting expertise in Configuring, Customizing & Testing in New and Classic General Ledger Accounting GL, Accounts Payable AP, Accounts Receivable AR, Asset Accounting AA & Fixed Assets FA
- Controlling Proficiency includes Cost Center Accounting, Profit Center Accounting & Internal Orders.
- Experience in integrating FI with CO, SD and MM modules (Procurement, sales, billing, and inventory).
- Good knowledge of Procure to Pay (MM) and Order to Cash (SD) sub modules functioning.
- Worked with Developers in Debugging the Custom Programs & developing Custom Reports.
- Designed, Tested & Supported for the Development of Functional Specifications for RICEFW Objects- Interfaces, Reports, User Exits, Data Conversion & Enhancements of Standard SAP Functionality.
- Extensively used Mercury Test Director/ HP Quality Center and Rational Clear Quest for Test Management and Bug Management.
- Experienced in preparing test plans & packages for all phases of Testing such as Unit testing, Integration testing, User Acceptance Testing etc.
- Ample knowledge of Generally Accepted Accounting Principal (GAAP), IFRS, and Sarbanes - Oxley Act (SOX).
- Usage of Tools such as LSMW & E-CATT for Data Migration from Legacy System to Target System. Excellent Oral & Written Communication, Presentation, Problem Solving and Analytical Skills.
- Excellent team player, detail oriented and ability to embrace new tools and technology with ease to innate new ideas to simplify the business and technical process.
TECHNICAL SKILLS:
ERP Package: SAP R/3 - FI/CO 4.0, 4.6c, 4.7d, 5.0 and ECC 6.0
Reporting Skills: Report Writer & Report Painter
Database: MS Excel, MS Access
Operating Systems: MS Dos, Windows 2000/NT/XP/Vista
Applications: MS Office Suite, MS Visio
Others: QA Testing Skills, SharePoint, HPQC, Sol Man, Peachtree & QuickBooks.
PROFESSIONAL EXPERIENCE:
Confidential, GA
Sr. SAP FICO Consultant
- Involved in Coke North America (CONA) Full Life Cycle Implementation Project for US & Canada.
- Lead Account payable & banking interface modules for Coca-Cola North America projects with various 3rd party Vendors & big banks.
- Worked on developing business requirement design document & functional specifcation document for various requirements for RICEF objects.
- Involved in configuring Account payables, Account receivables, New GL & foreign currency valuation set ups.
- Worked on FI/MM intergration & OBYC configuration based on business requirement provided.
- Lead multiple banking interface projects for Account Payables & Account Receiveiables. from Coca-Cola North America team. Worked with middleware & CBS team along with big banks for ACH & wire interface.
- Worked on Electronic Bank Statement as per Customer requirment from CONA.
- Design forms for Vendors within US & Canada. Forms include checks, Customer Statement Ad Hoc forms, Payment advices etc.
- Written Unit Test Cases for Lockbox Processing, Outbound ACH Payments, ACH Tax Payments, Garnishment Payments, Positive Pay File, Customer Statements (Ad hoc Statements & Extracts), Check Printing (Flat File & Regular Checks), 1099 Reporting) & W9 Mailing Form for Customers & Vendors.
- Performed Test for Check Printing, Positive Pay File, Customer Statements Extracts, Customer Statements (Ad Hoc Statements for Printing) & Outbound ACH Payments (PAYEXT & REMADV MESSAGE TYPE BOTH) & 1099 Reporting for Customers & Vendors.
- Involved in Payroll/FI Configuration Process. Configured Finance Accounts, Technical Accounts & Expense Accounts2 for Payroll/FI integration
- Configured various document types & maintained CONA GL Accounts for Document Splitting.
- Developed Info set Query for Chart of Account-Chart Level Report, T&E Credit Card Charges Not Expensed & Cost Center TAC Report for Travel Management in process.
- Involved in Upstream & Downstream Full Service Vending Process for Commission Payments. Knoweldgeable on Full Service Vending process.
- Involved in all testing such as Unit, Integration, Regression & User Acceptance testing for various implementations, upgrades & roll out projects.
- Used Tool such as Solution Manager (Sol Man) for Incidents & Defects Creation & HP ALM in late released to track defects & change requests.
- Prepared Inventory/ Prepaid Expenses Report via Report Painter for CONA R2 for Property Tax Reporting.
- Involved with CAM Team for Mock data Preparation for Assets & Equipment BI Reports as part of Property Tax Reporting.
- Involved on provincial taxes for Canada to calculate accounting entries and design form based on the requirement during Canada Go-live.
- Involved on FSCM configuration & testing during initial Coca-Cola North America bottlers Go-live.
Confidential, Morrisville, NC
Sr. SAP FICO Consultant
- Provided Daily Report for HK Offshore Service Orders Generation, Purchase Orders Blocked/ Unblocked details & GR/ IR Completion of Parts/ Labor Purchase Orders to Executive Level.
- Worked on SAP FI / MM / CRM Integration & Sabrix Tax Validation on Invoices & performed the E2E Life Cycle Testing for Service fulfillment.
- Involved on Full Life Cycle Testing on P2P (Procure to Pay) Process on JD Projects.
- Worked on Production Support, Data Validation, Testing and Tax Validations.
- Involved in Data migration of Fixed Assets from Legacy System to ECC via LSMW
- Good Hands on Customer Relationship Management 7.0 on both i.e. Web UI & GUI.
- Solely handled the Creation, Updates & Extension of Vendor Masters on JD Projects for all Finance Regions i.e. NA, RUCIS, J/ANZ, MEA, ASEAN, LAS, EET, WE, CAC, INDIA & HTK
- Involved on Vendor Data Collection from different Regional Towers for both ASP & AWSP such as General Data’s, Company Code Data’s & Purchasing Org. Data’s. Updated ASP & AWSP Vendors with their values before Go Live.
- Prepared Work flow Diagram for Brazil Non-ERS Process flow, Manual Payment Process for Labor & Non-ERS Report Process for Jade Dragon.
- Involved on Uploading of 10, 00,000 Materials (TPG & IPG) Cost & List prices, Freight & Unit Cost for Carriers & Labor Cost & List prices for Vendors on all environments i.e. Development, Testing, and Pre-Production & Production.
- Worked on Pricing Procedure for the defects raised while Generating Purchase Orders i.e. Defined Condition types, Access sequences, Calculation schema, Scheme groups and Schema Determination for Pricing in Purchase Orders
- Involved on releasing of Material Attributes & Loop factors from Home-Grown Software called LUCI to CRM/ECC.
- Involved on all Phases of P2P (Procure to Pay) Testing i.e. Stand Alone Testing, User Acceptance Testing, Regression Testing & Pre-Production Testing for all JD Projects before Go Live.
- Validated Service Request, Service Orders, Purchase Orders, DMR & DM on CRM and ECC (Testing & Pre-production Box) & were recorded on HPQC.
- Used SharePoint to Document & maintain all the Project Relevant Documents after Approval & Execution of Tasks .
- Performed GR/ERS for Labor & Parts Purchase Orders and validated Payment Vendors, Goods Supplier Vendors, Tax Rate, Currency etc. based on Regions & Countries for all JD Projects.
- Involved on Tax Code Determination for the aforementioned Regions.
- Knowledge of Determination of Pricing Procedure for both MM & SD.
- Involved on Finance Validation of Invoices on all Phases of P2P Process Testing.
- Thoroughly involved on Production issues for Service Order with errors especially for those not generating PO’s.
- Reversed GR/ERS via LSMW for PO’s with errors on Production & marked Delivery Completed via MASS.
- Mass creation of Vendors via LSMW.
- Involved on creation of SAP Queries to generate only the required fields on ERS Report for price Updates on Production, Vendor Data Extraction etc.
- Usage of Firefighter to update any Critical Changes on Production environment.
Confidential, Old Tappan, NJ
Sr. SAP FICO Consultant
- Worked extensively on Concur Interfaces replacing GELCO for Confidential Education (PE) & Penguin Group (PGI).
- Involved in Detail study of the Standard Accounting Extract & Imported to the clients General Ledger for the RFS 8819 and 8820
- Designed Functional Specifications for the Concur Project (Travel Expense Workflow) to create a bridge program in order to capture the travel expense and import it to the financial system for both Confidential Education (PE) & Penguin Group (PGI).
- Created Vendor and Customer Master using Mass with reference from production for Vertex Tax Jurisdiction Validation
- Involved with Configuration Team for US & CA Tax Calculation using Vertex.
- Coordinated with various departments i.e. Accounts Payable, Purchasing, Asset Management etc. to analyze various issues related to Taxes Calculated from Vertex and helped in documenting the process flow
- Configured Automatic Payment Program for Check Run, including Bank Determination, Check Lot creation, House Bank Set Up and Payment Methods.
- Configured Dunning Procedures in which dunning levels and forms for both customers and vendors are defined.
- Researched and Recalculated depreciation key z108 to ensure accurate asset depreciation posted and planned values via Straight Line Method.
- Worked extensively on integration between FI-SD (OTC procedures) & Inter-Company Process.
- Provided Support for various teams in OTC processes- Customer Service team and Billing Team.
- Configured Order To Cash (OTC), Material Determination, Account Determination, Route Determination, Contracts, Agreements and Rebates Processing.
- Created Primary and Secondary Cost Elements, Created Cost Element Groups, Maintained Cost Element Attributes, Costing Sheet etc. in Cost Element Accounting
- 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,
- Maintained Order Types, Screen Layouts, Maintained Order Groups, Status Management, Overhead Costing Sheets, Maintained Settlement Rules and Settlement Profile in Internal Orders
- Assigned New Number Ranges from existing Number Ranges for Canadian Company Code in Internal Orders & executed all hard-coded programs in background and scheduled jobs to verify the spools.
- Launched Firefighter (/n/VIRSA/VFAT) to capture various screenshots from production environment to provide the requirements of business for audit.
- Conducted unit testing & integration testing in different systems for Vertex Upgrade.
Confidential, Houston, TX
Sr. SAP FICO Consultant
- Involved on Data Migration from Classic GL to New GL
- Configured and Tested New Legal Entities for Ireland and Canada and set up foreign currency enablement in New General Ledger, Customized Account Groups, Field Status Groups, Posting Keys, Document Types, Posting Periods and G/L master records creation.
- Classified G/L Accounts, Document types for Document Splitting, Defined Document Splitting Characteristics for New G/L Accounts
- Configured Company Code, Posting Period Variant, Created Business Area and Functional Areas, Maintained Fiscal year variant, Assigned Company Code to FYV, Opened Posting Periods, Defined Document Type and Assigned Document Number Ranges, Defined Tolerance Groups for Employees , Created Chart of Account.
- Configured General Ledger Accounting and Maintained Charts of Accounts for different Company Code creation/change of G/L accounts, Screen Layout Rules, Automatic Account Assignments, Defined Retained Earnings, Field Status Group, Manual and Automatic Clearing, Recurring Postings, Defined FOREX rates, Foreign Currency Revaluation, Intercompany Account Posting, Intercompany Reconciliation, Maintained Posting Period Variant, Validation and Substitutions, Configured G/L Master Record, Defined & Maintained financial statement versions.
- Configured Accounts Payable/ Account Receivables - Incoming Invoices, Outgoing Payments, Credit memos & Debit Memos, Maintained Terms of Payments, EDI invoice posting, Screen Layout for Invoice Posting, Open Item Clearing, Bank Accounting, Closing Vendor Group & Maintain Vendor Master Data.
- Configured Outgoing Payments - Outgoing Payments Global Settings, Manual Outgoing Payments, Automating Outgoing Payments, Check, ACH and Wire Payments, Define Tolerances per Vendor, Check Payment Blocking Reason Code, Define House Bank, Define Payment Method per Company Code, Bank Determination for Payment Transactions, Bank Ranking Order, Bank Accounts, Available amounts per Bank Upload and Updated Bank Master Data with new ABA, Wire and IBAN.
- Monitored incoming and outgoing IDOCS on weekly basis and assisted account payable department in solving and finding out the root cause of rejected payments of vendors.
- Configured Logistic Invoice Verification (LIV) - Incoming Invoices, Document Type and Number Ranges, Set Check for Duplicate Invoices, Invoice Blocking - Determine Payment Block, Set Tolerances Limits for Invoice Posting, GR/IR Account Maintenance, and EDI invoice postings.
- In LIV, Involved in Two Way Match & Three Way Match Invoice Verification, Automatic Account Determination for MM and FI, Set Tolerance limit for invoices, set check for duplicate invoices, GR/IR account maintenance, and EDI invoice postings
- Extensively did the system testing in different system for unit testing, integration testing and user acceptance testing.
- Involved in Configuration for Lockbox, Electronic Bank Statements, and Bank Reconciliation.
- Ran F110 for Payment (Outbound) - ACH, Domestic Wire and Cross-Border Wires, verified the IDOCs in WE02.
Confidential, San Francisco, CA
Sr. SAP FICO Consultant
- Used ASAP methodology to gather requirements for business processes and enterprise structure related to General Ledger, Accounts payable, Accounts Receivable and Asset Accounting & Controlling.
- Supported the client in Post Launch Session and worked on Post Production Issues
- Configured company code global settings and settings for GL master data and transactional data.
- Configured settings for automatic account determination for intercompany transactions & defined rules for automatic clearing of documents.
- Created house banks, bank accounts and assigned the accounts to a check lot & configured Lockbox - Processing master data and House Banks for payment
- Configured automatic payment program for outgoing payments in Accounts Payable.
- Defined accounts for cash discounts, over payment and under payments, rounding differences and bank charges for vendor and customer payments.
- Configured the system for maintaining Credit Management Master Data.
- Defined special GL accounts for customers and vendors.
- Defined GR/IV, Inventory management, Goods movements, MIRO Stock transfer between Company codes and Plants.
- Configured necessary settings for sales tax, purchase tax and defined codes for non-taxable transactions.
- Configured automatic account assignment for MM by valuation class. Used various processing keys such as BSX, GBB, PRD and WRX for account determination.
- Configured necessary settings for closing activates in GL, AP and AR modules.
- Defined chart of depreciation, various depreciation areas and depreciation keys, asset classes, number ranges, revaluation settings.
- Defined transaction types for various business transactions like acquisition, retirement, transfers and account determination.
- Configured controlling area, operating concern, versions and number ranges for controlling area
- Created primary and secondary cost elements, cost element groups and costing sheet.
- Configured cost centers, activity types, statistical key figures, Cost center Standard Hierarchy, Cost center categories, distributions and assessments
- Defined planning area, planning layout and planner profile in Cost Center Planning.
- Maintained order types, screen- layouts, maintained order groups, status management, overhead costing sheets, maintained settlement rules, settlement profile, planning profile, budget profile, availability control.
- Created master data, standard hierarchy, substitutions and assignments in Profit Center Accounting.
- Prepared functional specifications for various custom reports & developed various reports using report painter.
Confidential, Baltimore, MD
SAP FICO Consultant
- Created and maintained Chart of Accounts, Customized Account Groups, Field Status Groups, Posting Keys, Document Types, Posting Periods and Created G/L Account master records
- Performed unit testing and integration testing of MM with Account Payable and SD with Account Receivable.
- Created Withholding Tax codes for 1099 reports and created Input Tax codes & Tax accounts for all purchases. Worked on setting up Tax Interface System for Vertex for Sales and Use tax.
- In Accounts Payable created vendor master records, account groups, defined client specific payment terms, vendor invoices, manual incoming/outgoing payments, automatic payment program configuration, partial payments and payment advices.
- Configured House Banks, Bank Accounts, GL Structure, and Posting Rules for automatic assignments FI
- Configured Payment Program such as Company Code Data, Paying Company Code, Country Payment methods, Wire Transfer Settings and ACH payments
- Configured the system for the creation of A/R invoices and posting of manual incoming payments and defined reason codes for payment differences and worked on to writing off these differences to G/L accounts.
- In Treasury, designed Lock Box procedure for Accounts Receivables and configured payment methods Check, ACH and electronic Bank statement processing.
- Configured tax codes and tax jurisdiction codes for US Sales and Use Tax
- Created Primary and Secondary Cost Elements and maintained Cost Elements Attributes
Confidential
Jr. SAP FICO Consultant
- Assisted project team to reconstruct enterprise organization and streamline business process.
- Worked on a full life cycle implementation of FI (GL/AP/AR/AA/SPL/CO/PCA).
- Configured the Chart of Depreciation and settings up the various depreciation areas like Book Depreciation and Taxation.
- Configured the Period Controls key’s, Depreciation key’s, Calculation key’s etc.
- Created Asset classes & configured screen layouts for Asset master records
- Configured the required settings for acquisition through Lease, Posting Investment subsidies, Revaluation of assets, Posting Depreciation etc
- Configured necessary settings for Assets under construction and settling the same to Fixed Assets
- Used BDC method to transfer the Asset master records from legacy system to SAP
- Configured Period control & posting rules to handle depreciation calculation and automatic posting of the same on a monthly basis.
- Set up the automatic payment program for handling vendor payments.
- Payment Program configuration includes the Country code payment methods.
- Set up of House Bank Accounts.
- Creation and Maintenance of Vendor Master Data.
- Logistics Invoice Verification - Integration with MM module.
- Performed integration testing and end-user training.
- Prepared detailed test plan for integration testing in FICO module with a focus on improving accuracy of inventory and to be able to match cost and revenue within a period.
- Post go-live support for FI/CO module.