Sap Fico Consultant Resume
Atlanta, GA
SUMMARY
- Over all 13+ Yrs of IT Experience and 8+ years of SAP FICO Consultant Experience and as a Sr Accountant experience for over 5+ years.
- Involved in 3 Full Life Cycle implementations, 1 Rollout and provided extensive hyper care support.
- Extensive hands on experience in Configuration of GL/New GL, AP - Accounts Payable, AR-Accounts Receivable, Fixed Assets, Banking. Worked on bank formats MT940, BAI2 etc.
- Hands on experience in Controlling areas - Cost Element Accounting, Cost Center Accounting (CCA), Profit Center Accounting (PCA), Internal Orders (IO).
- Good exposure to Order to Cash (OTC) and Procurement to Pay (PTP) process, Logistics Invoice Verification (LIV) and experience in integration of FI-MM and FI-SD
- Experienced in configuring Lockbox, Electronic Bank Statements (EBS), EDI Interface and IDOC Process.
- Provided extensive support in End to End testing activities, such as Integration testing, Manual Regression testing, unit testing, performance testing.
- Involved in Cutover Activities and Data Conversion using Migration tools like LSMW and BDC.
- Good Exposure in Validations, Substitutions, and BADI’S.
- Good knowledge in configuring integration between SAP and Third-Party System using BAPI’S and ALE/IDOC.
- Proficient in developing SAP Query Reports
- Involved in handling Tickets, Incidents, Problem records, Change Management and Change Control Requests. Prepared Test scripts and involved in Unit/System/Integration/Regression Testing and provided UAT support to the business team.
- Well experienced in drafting the End User Manuals and delivered End User trainings.
- Good working Knowledge in Testing tools HP Quality Center (HPQC) and Ticketing tools Remedy and Service-now.
- Involved in Fit/Gap Analysis and Prepared good number of Functional Specification Documents (RICEFW’s).
- Ability to interact effectively with clients, understanding to client expectation and provide end-to-end solutions to the business requirements.
- Good Management skills, Documentation skills and quick to comprehend new technologies.
- Exceptional presentation, written & verbal communication and problem-solving skills. Self-motivated and has proven ability to work in both independent and team environments.
TECHNICAL SKILLS
General Ledger: Chart of Accounts, Account Groups, GL Master Records, Field Status Groups, Posting Keys, Automatic Account Determination, Sales/Use Tax, Number Ranges, Document Types, Tolerance Groups.
New GL: Document Splitting, Parallel Accounting, Parallel ledgers, Segment reporting.
Accounts Payable: Vendor Groups, Vendor Master Data, House Banks, Bank Accounts, Check Lots, Reason Codes, Automatic Payments, Recurring Entries, Invoices, Credit Memos, AP Information System, Integration with MM.
Accounts Receivable: Customer Groups, Customer Master Data, Billing, Payment Terms, Interest Calculation, Incoming Payments, Dunning, AR Information System, Account Systems, Credit Management, Dunning, Closing Operations, Sales Order and Integration with SD.
Cash Management and Bank Accounting: Inbound/outbound process House Banks, Manual & Electronic Bank Statement, Lockbox Processing, electronic funds transfer and Bank statement processing, Bank reconciliation and Cash journal.
Asset Accounting: Configuring Asset Master Data, Asset Classes, Chart of Depreciation, Unplanned Depreciation, Depreciation Areas, Depreciation Posting, Acquisition and Retirement of Assets, Assets under Construction and Capitalization of Assets.
Cost Element/Cost Center Accounting: Configuring and customizing the Cost Elements, Costing Sheets, Reconciliation Ledgers, Standard Hierarchy, Cost Centers, Activity Types, Statistical Key Figures, Master Data Groups, Assessments, Distributions and Reposting, Allocation Cycle and Segment.
Profit Center Accounting: Configuring and customizing the Basic Settings, Maintaining Profit Center Hierarchy, Assignments, CO-Objects to Profit Centers, Distribution and Assessment of Costs, Planning and Development of Reports.
Internal Order: Create Internal Order, Order Type, Settlement and Disbursement of Cost through Assessment Cycle, maintain Settlement RuleIntegration of FI/CO, SD (VKOA) and MM (OBYC).TECHNICAL SKILLS
ERP: SAP R/3 FI/CO, SAP S/4 HANA FINANCE
Operating systems: Window 95/98/XP, Server 2000/2003, Unix, RDBMS, MS-SQL Server, MS Access 2000
Project Utilities: MS Project, ASAP, Access, Visio, Infopak
Testing Tools: Mercury Test Director, Quality Center and Solman (Solution Manager)
SAP R/3 Tools: LSMW, Report Painter, Report writer
PROFESSIONAL EXPERIENCE
SAP FICO Consultant
Confidential, Saint Petersburg, FL
RESPONSIBILITIES:
- Handling day to day queries/incidents related to FICO - FI-GL, AR, AP, FIXED ASSETS, PCA and Internal orders. Designing and preparation of Functional specifications for various Reports, Interfaces, Conversions, Enhancements and Forms (RICEF’s).
- Responsible for complete integration of MM-FI and SD-FI
- Configured all settings for AR and AP including the Automatic Payment program, Dunning.
- Customized and configured Cash management including Bank statements, payment program, Payment advises.
- Designed the Generic Non-PO Invoice Postings Interface for Purchase to pay division so that Vendors can submit the Invoices electronically.
- Worked exclusively on payment methods like ACH processing and check runs.
- Supported in solving the issues related to the automatic payment program, EBS, check management, open item clearing and down payments.
- FI-SD integration: Assigned revenue accounts, deferred revenue accounts, freight accounts, and tax and discount accounts in SD account determination.
- As a functional consultant, provided IDOC types and extension details and coordinated with ABAP team. Implemented the exchange of customer required data that was not available in SAP delivered IDOCs.
- Preparing the unit test scripts for all the custom developments and interfaces, perform unit test and assign the same to QA testing.
- Trained business users on various business processes of treasury like EBS and Lockbox processing, running payment run and recurring entries for periodic transactions.
- Extracting and providing standard and custom table data outside of the standard reports on ad hoc basis.
- Responsible for monitoring (critical) interfaces and background jobs.
SAP FICO Consultant
Confidential, Atlanta, GA
RESPONSIBILITIES:
- Created new company codes for the countries Mexico & Canada and Rolled out SAP FICO solutions.
- Configured all the basic settings as per the Global template, Created Tax codes, Number ranges, Payment output files, EBS, LOCKBOX, EDI settings, Cost center Hierarchy, Cost centers and Cutover activity.
- Customized and Configured General Ledger Account Groups, G/L Accounts, Chart of Accounts, Tolerance Groups & retained earnings account in New GL.
- Configured Electronic bank statement and familiar with new EBS and Lockbox.
- Worked on extensive customization for Asset Accounting and coordinated with SharePoint team to setup a connection between one-gate and ECC to process asset transactions from SharePoint.
- Developed and tested a customized vendor master design which includes web dynpro forms, workflows, enhancements, interfaces. Worked with MDM (Microsoft Master Mata Management) team in designing an interface through PI/PO. Designed a mapping for data transfer between ECC and MDM.
- Experienced in KOFAX invoice processing and involved in custom program design in ECC for monitoring invoices coming through KOFAX.
- Developed SAP query for Withholding tax from BSIK and LIFNR table -open item information.
- Worked on customized AUC settlement process.
- Managing on-site & off-shore teams.
- Involved in Unit Testing, provided the User training and UAT support, Cutover activities and post go-live support.
- Executing Data Manager packages for weekly reports from flat files and BW.
- Good experience in configuration of leading and non-leading ledgers.
- Extensively involved in preparation of test data, writing test scripts and execution of test scripts.
- Played a key role in System integration testing for finance and reporting of test results to management by creating defects in application life cycle management (HP QC/ ALM)
- Good understanding of payment process and expert in tracing the payment issues.
- Involved in post go live support for finance and led a team of 6 members.
- Familiar with "Service now" ticketing tool.
- Involved in reporting activities with respect to team productivity and ticket resolution.
SAP FICO Consultant
Confidential
RESPONSIBILITIES:
- Customized (client specific) New General Ledger Accounting to perform parallel accounting, Document splitting, allocation, Accounts Receivables.
- Configured house banks, bank accounts, GL structure, posting rules for automatic assignment and automatic payment program (APP) configuration by Bank Chain Functionality.
- Involved in configuring Business Partners and Inter-Company transactions.
- Configured Lock Box accounts that are referenced in customer master records using BAI2 format and used invoices as a part of remittance information.
- Prepared test plans, test cases, test scenarios and executed all phases of Testing.
- Worked on Bank related accounting SAP configuration, experience in setting up incoming payments, Lockbox configuration, Automatic Outgoing payments bank reconciliation process including Electronic Bank Configuration (EBS) like MT940, BAI2 formats etc. also Manual Bank Statement (MBS) processing.
- Configured and Tested DME set up for company to upload XML file onto respective banks.
- Worked on Interpretation Algorithm and Search String functionality.
- Performed Treasury operational functions such as cash management, cash forecasting, interest rate monitoring and capital funding and financial derivative analysis.
- Involved in the review of internal controls, risk management, regulatory compliance and reporting functions.
- Conducted Integration testing for P2P and OTC processes.
- Streamlined posting of Inter-Company Code Transactions and Dunning Processing that includes from Creation of Dunning Proposals to Print.
- Maintained configuration in CCA, PCA, IO and COPA areas of the CO module.
- Designed and developed custom reports in CCA, PCA and COPA for Management Reporting.
- Used HPQC to develop test scripts and to Raise, Assign, Modify, Clear Defects.
- Apart from normal production support activities, also worked on Streamline testing, system integration testing and regression testing.
SAP FICO Consultant
Confidential
RESPONSIBILITIES:
- Involved in New GL project implementation along with testing and support.
- Worked on End to End plan, scheduling and configuration of General Ledger, Accounts Payable and Account Receivable.
- Defined leading and non-leading ledgers, defined different segments for segment reporting
- Configured document splitting characteristics for finance and controlling both,
- Classified G/L accounts for document splitting.
- Defined and assigned different accounting principles to ledger groups
- Worked on Info Pack to create Training materials and successfully trained Users.
- Worked on importing data from legacy systems toSAP via Legacy System Migration Workbench (LSMW.
- Handled issues related to GL, AR, AP, AA, CO-PC, IO, CCA, PCA, and Project Systems, etc. As part of the Production Support Team worked closely with Technical and Functional consultants of other modules to resolve the issues as per priorities. Analyzed FICO related trouble tickets, discussed with the Business Users, determined the root causes and resolved them in timely manner.
- Interacted with client's business process team; collected business requirements, created functional specifications.
- Involved in decision-making for the screen layout of Master Records including General Ledger, Vendor Master Record and Customer Master Record.
- Customized Operating Chart of Accounts, Group Chart of Accounts & Country Chart of Accounts.
- Created different G/L accounts centrally and at company code level, like expenses, revenue, cash, asset and liability.
- Configured vendor account groups & assigned number ranges to vendor groups.
- Maintained Vendor Group Field Status for General Data, Company Code Data & Purchasing Data which reflected on the Vendor Master Records.
- Customized the Payment Program to in corporate Company Code Data, Paying Company Code Data, Country Payment Methods, Company Code Payment Methods, and House Banks etc.
- Configured House Banks, Bank Accounts, Bank Account G/L Structure, Check Lots, Void Reason codes etc.
- Worked with ABAP people to create different z-reports.
- Configured Depreciation areas, Defined Asset Classes, created Screen layout rules, created financial statement version for Asset Reports.
- Configured Integration of Assets with General Ledger, created different type of Depreciation terms, created Screen layout for depreciation areas, created depreciation area for different currencies, Special depreciation.
- Defined and configured different depreciation keys. Configured Screen layout for Asset Master Data, created asset classes for Group Assets, created Allocation structures and settlement profiles.
- Configured Electronic bank statement and Lockbox.
- Worked on customized AUC settlement process.
- Involved in post go live support for finance and led a team of 6 members.
- Familiar with "Service now" ticketing tool.
- Involved in reporting activities with respect to team productivity and ticket resolution.
Sr. Accountant
Confidential
Responsibilities:
- Manage Accounts Payable and Accounts Receivables processes
- Preparation of Aging Analysis every quarter which is presented to top management.
- Reconciliation of bank accounts and high-risk general ledger accounts
- Analyzed and process monthly A/P accruals
- Prepare regular monthly/quarterly journal entries as part of the closing process and Inter-company reconciliation
- Supported Fixed Assets team in capitalization, retirement and transfer of assets.
- Assisted in month end closing of fixed asset module