Sap Fico Lead Consultant Resume
Atlanta, GA
PROFESSIONAL SUMMARY:
- Over 8+ years of extensive SAP experience in configuration, implementation and customization of Financial Accounting (FI) and Controlling (CO) modules along with their integration with logistics modules (SD & MM).
- Implementation of 4 Full Life Cycles using ASAP Methodology, with experience in all project phases - Business Blue Print, Realization, Final Preparation, Go-Live as well as Post Go-Live support.
- OpenText VIM experience includes end-to-end configuration of Document types, Document processes, ICC(OCR) system and Enterprise Scan.
- Extensive participation in studying and analyzing business processes, modeling the TO-BE process based on the knowledge of AS-IS process.
- Experience in debugging and understanding the program logic.
- Thorough understanding of the relationship between various SAP modules (FI/CO, SD, MM, PP) and of overall business processes such as order-to-cash and purchase-to-pay and Make to Order.
- Good knowledge of Generally Accepted Accounting Principles (GAAP) and IFRS required during the implementation of FI/CO module
- Experience in Financial Accounting (FI) includes General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Treasury, Funds Management (FM) and Bank Accounting - Lockbox and electronic Bank Statement processing.
- Experience in Controlling consists of Cost Element Accounting, Cost Center Accounting (CCA), Profit Center Accounting (PCA), Project Systems (PS) and Internal Order (IO).
- Experience with Logistics Invoice Verification (LIV) and Check Management.
- Sound knowledge of Financial Supply Chain Management (FSCM) and Contract accounting FICA.
- Analysis of Open Items, Foreign Currency Revaluation, clearing of Goods Receipt & Invoice Receipt.
- Proficient with SAP database and landscape design.
- Sound knowledge in migration of data from Legacy system to SAP for upgrade / new implementation / integration using LSMW.
- Extensive interactions with ABAP programmers during generation of AR, AP and G/L customized reports and functional specifications (RICEFW).
- Experienced in configuring Dunning program, Interest Calculation on Open Items, Correspondence and Account Statement processes.
- Proficient in Documentation, Business Presentations, writing and developing Business Reports and Technical Specifications.
- In SAP Testing. Experienced with knowledge in development, manual and automated testing. Extensively used automated tools like HP-QC, Mercury Interactive QTP, TAO and Solution Manager. Good Knowledge in ERP & CRM Concepts.
- Experienced in End User along with User Acceptance Testing.
- Excellent analytical and programming skills combined with outstanding interpersonal skills.
PROFESSIONAL EXPERIENCE:
Confidential, Atlanta, GA
SAP FICO Lead Consultant
Environment: SAP ECC6.0, OpenText-VIM 5.2/7.0, ICC, IDocs, AP,AR, GL, APP, EBS, Treasury,Travel managements BTM, Travel Smart Application
Responsibilities:
- Interacting with Business users, gathering the system and user requirements, documenting the change requests, operational requests and preparing test scripts.
- Creating New Legal entities for intercompany Transactions and assigned new clearing accounts For GL postings.
- Configured ACH Payment terms and Customized New Payment medium format in DMEE as per the Bank Needs.(NACHA and SEPA Format)
- Created New LockBox accounts for new House banks in Accounts Receivables.
- Worked on New GL, Data Migration, Activated new Ledger, Performed document splitting, Parallel Accounting and periodic processing and resolved related issues.
- Helped business users for master data uploading using LSMW and mass reversals of documents.
- Preparation of LSMW data upload templates, testing and performing data upload. GL balances both cumulative and line item balances including vendor, customer and asset master data were loaded via LSMW technique.
- Assigned New Dunning levels to dunning procedure and customized the Standard text for Dunning notices and automatic email triggering.
- Configured Fixed Asset Master Data - acquisitions, retirements, revaluation of fixed assets, customized depreciation keys for depreciation run - planned, special, unplanned depreciation.
- Customizing screen layouts for asset master data, asset sub ledgers and asset depreciation areas. Defining transaction types and account assignments for asset acquisitions and retirements.
- Involved in integration of Fixed Asset accounting with internal orders, maintaining settlement profiles for internal orders, Configuring capitalization of assets under construction, assigning cost elements.
- Support role involved break fixes for Production issues on FI modules and also new Enhancements to facilitate additional functionality requests for the business.
- Implemented SAP notes as suggested by SAP OSS messages to fix standard SAP issues.
- Worked on enhancements like customizing business rules, in user exits, adding custom fields in the index screen based on business requirements.
- Gathered business requirements and Coordinated with ABAPers for development of new Reports required by user and for modification of programs.
- Dealt Sap Workflow and Vim, JV and BTMworkflow related issues.
- Worked ontime related and service related revenue recognition procedures.
- Resolved failed tax documents that did not update the Vertex Tax ledger due to consistency failures.
- Worked on Travel Managements (BTM, Travel Smart application for US and Canada)
- Worked on Lock box issues, check printer issues.
- Successfully transitioned all EDI requirements from legacy system to SAP and scheduled batch jobs to transfer data from FTP server to SAP. Strong Knowledge and worked with middleware tools like Tibco, Axway, Webmethods etc.
- Worked on Idocs issues related to bank files like payment files, Remit files etc. Failed idocs processing.
- Business Signoff for the development changes.
- Involved in preparing and signing off the functional specification (FS) documents, FUT and UAT testing cycles (functional unit testing, and User Acceptance Testing) before Go Live.
- In-depth analysis of business critical issues encountered in the day-to-day functioning and was SME for FI module and Open Text vim Application.
- Setup offshore support model and knowledge transfer to offshore team to provide level 3 support. Worked with different time zones and global environment.
- Experienced in preparation of end user documentation.
- Received several appreciations from business users and client managers.
Confidential, Naperville, IL
Sr SAP FICO Lead Consultant
Environment: SAP ECC6.0, New GL, AP, AR, APP, EBS, Foreign Currency, IDocs, Treasury, Taxes, LSMW, CO-CCA,CO-PCA,CO-PA.
Responsibilities:
- Participated in Project Preparation, Business Blueprint, Realization, End-user- and Support for a full cycle implementation.
- Interacted with Super user and Solution Architect to ensure proper understanding of the Business Requirements and Functional specifications.
- Designed the To-Be Solution and gathered functional requirements for the same.
- Configured the functional process design built in Business Blueprint Phase.
- Participated in decision-making for the screen layout of Master Records including General Ledger, Vendor Master Record, and Customer Master Record etc.
- Verified and configured parallel currency type and exchange rate type according to requirements. Configured House Banks, Bank Accounts, Bank Account G/L Structure, Check Lots, Void Reason codes etc.
- Involved in customization of additional billing functionality like down payment, billing plans, configuration for the dunning, incoming payments, incoming payments like residuals, partial payments, payment differences like underpayment/overpayment, reason codes and cash application in Account payables.
- Created tax code, jurisdiction code, tax calculation procedure in sales and purchase, confirmed the output and tax report for sales and purchase.
- Worked on Bank interfaces in Bank Communication management; configuration of Idocs to XML/Flat files, SEPA Format for Europe Banks and working on integration layer between Banks and SAP.
- Maintained Check Lots; configured the Check Program Run for Online Check Printing as well as Manual Checks and created Check Extract files for records purposes.
- Worked on configuring and customizing validation and substitutions for vendor invoices and customer payments at transaction level and user exit level.
- Worked on integration of profit center consolidation and business consolidation (ECCS).
- Involved in the whole Accounts Receivable process including Customer Master Data design maintenance, Customer/Vendor Master Change Report as per SOX requirement, AR Debit/Credit Memo, Intercompany Payment Process, Lockbox, Get Paid interface, Incoming Payments with Reason Codes. Involved in the Test Director testing for the implemented changes.
- Configured multiple Transaction Types, Valuation Methods, and Valuation Areas and assigned Valuation Areas to Accounting Principles to meet the Foreign Currency Valuation requirements.
- Extensively worked in a Multi-Currency Environment. Configured the Automatic Postings for Foreign Currency Valuation and Account Determination for Currency Translation
- Extension of Treasury functionality (Money Market, Foreign Exchange, Derivatives, Hedge Accounting& Risk Analyzers) to new Company Codes.
- Managed GL and Treasury portion during integration testing phase and resolved the subsequent system errors.
- Configured and created cost elements, cost centers, Profit Center Product Costing, valuation profiles, field status groups, internal orders for enhancement in functionality and reporting
- In Internal Orders setup status profile for order type, maintained settlement rules, internal order planning, and Configured settlements distribution cycles for actual cost distribution
- Configured Period control and posting rules to handle depreciation calculation and automatic posting of the same on a monthly basis.
- Participated in functional and unit testing in order to make sure that it is functioning the way it was before.
- Involved in Cutover plan and weekend support for Go-Live support.
- Involved In regression and integration testing and using test tools like HP Mercury center and solution manager.
- Provided end user and created documents and presentations.
Confidential, Woodbury, NY
SAP FICO Lead Consultant
Environment: SAP ECC 6.0, New GL, AP, AR, APP, EBS, Lockbox, FI-MM, Fixed Assets, RICEFW, CO-PCA, Report Writer.
Responsibilities:
- Worked on Business blueprints including functional specifications and configuration documents.
- Responsible for gathering business requirements, conduct workshops with the business users, designing, configuring, and testing and providing post implementation support
- Defined Account Groups, Number Ranges, Posting Keys, Document Types, Posting Period, Fiscal Year Variants, and Field Status Groups.
- In FI- GL, responsible for creating GL master records and reconciliation accounts for sub-ledgers and configured cross-company code transactions and inter-company accounts for new legal entities.
- Accounts Payable - Vendor master data configuration, Tolerance group, Automatic Payment Program, Invoice, Credit memo, Check management, Down payment, recurring entries, Closing Procedures Integration with MM module.
- Configured AR Scenarios: Customer master maintenance, tolerances, over-under payments, cash discounts, Incoming payment (full payment/partial payment/residual payment), dunning procedures, and Age-Wise AR reports.
- Configured the payment program, payment methods, analyzed existing banking structure and worked on interfaces with the bank for the single source data transfer approach.
- Configured Web cash interface to enhance and ease account payable process.
- Configured Lockbox processing and created cross account clearing between Accounts Payable and Accounts Receivable. Analyzed the Bank Master data for APP.
- Provided production support for issues with House Banks and Automatic Payment program (APP) configurations as well as Electronic Bank Statements (EBS).
- Involved in optimizing bank details for wire payments, check lots, void reason codes and clearing inter-company vendor/customer open items.
- Maintained Lockbox configuration, worked on BAI2 format and resolved issues related to Unapplied and partially applied payments.
- Configured the US and Canada tax procedures and rates as per the jurisdiction, Worked on SAP Integration and Center like Vertex and provided high quality solution to end user in calculating tax within the SAP Solution Manager
- Fixed Asset Management: Defined Screen Layout Rule, Account determination and number range for each asset class and definedAsset Classas per business requirements.
- Configured interest calculation, overpayments/underpayments, cash discounts, tolerances and credit management.
- Configured basic settings and master data of PCA, created Profit Center groups, Dummy profit centers, Profit Center Standard Hierarchies, and assigned objects to the profit centers.
- Creation of basic sets, assigning reports to report group and executing the report groups using Report writer.
- Supported System Test and User Acceptance Test stages, solving problems, determining fixes, and reviewing code and test results.
- Assisted end users on month end activities such as overhead calculation, variance calculation and configured month end financial report.
Confidential, Jackson, MI
SAP FICO Functional Analyst
Environment: SAP ECC 6.0, New GL, AP, AR, APP, EBS,P2P, ACH, Lockbox, Check management, Data Migrations (LSMW), EDI Interface, CO-PCA.
Responsibilities:
- Worked with super users to conduct Feasibility study and gathered information for business requirements, conducted focus groups with pre-qualified stakeholders and studied Gap Analysis by performing AS-IS and TO-BE processes.
- Configured, maintained and resolved issues regarding business processes in support of the SAP utility ERP-FI module including Accounts Payable, Banks, General Ledger, etc.
- Involved in the basic implementation and development of Blue Prints for the entire project lifecycle related to MM module covering the full “Procure to Pay” business process.
- Accounts Payable-AP: Building AR Business module, Configuring and Customizing vendor master data, vendor account groups, Define sensitive fields for dual control, House banks, Invoice processing, Document parking, Outgoing payment, Reporting.
- Involved in the whole Accounts Receivable process including Customer Master Data design maintenance, AR Down payment, AR Debit/Credit Memo, Intercompany Payment Process, Lockbox, Get Paid interface, Incoming Payments with Reason Codes. Involved in the Test Director testing for the implemented changes.
- EBS - importing current day and prior day file from Citi direct and posting memo records from current day file for Cash position. Check encashment date and bank reconciliation using prior day file.
- Advance inbound and outbound electronic banking configuration like wire, ACH process, lockbox file, Electronic Bank statements and Integration with PI for generating payment outdoor.
- Worked on various Production Change Requests (PCRs) on Finance and AP related Issues. This involved documenting the detailed description of the configuration changes to the SAP production system. Analyzing the changes and business impact of these changes. And documenting the approval response including change implementation information.
- Migration experience of SD master data from legacy to SAP system using conversion programs- LSMW.
- Supported issues related to inbound and outbound processes for Electronic Data Interchange EDI.
- Configured basic settings, standard hierarchy, dummy profit center, Distribution and Assessments, CO-Objects to Profit Centers in Profit Center Accounting (PCA)
- Generated reports using Report Painter and Report Writer. Performed Documentation for end users and provided end user .
Confidential, Whippany, NJ
SAP FICO Functional Analyst
Environment: SAP R/3 4.7, AP, APP, Foreign Currency, Taxes, Data Migration (LSMW), Report Painter & Report Writer, Unit Testing, Integration Testing.
Responsibilities:
- Interfaced directly with business users to facilitate requirements gathering. Helped to design business process and system solutions.
- Created different kind of profiles such as WBS elements, Network and their Activities, cost planning and budgeting.
- Extensive experience in Lockbox configuration and processing Automatic, processes like payment program and dunning program
- Configured payment program for Wire transfers, local checks, centralized check printing, direct deposits.
- Configured electronic Banking, automatic bank reconciliation and assisted with foreign currency revaluations.
- Worked on GL master, Vendor master, Customer master, and open item (for GL, AR and AP) conversion using LSMW and BAPI’s.
- Prepared specifications for mapping data between legacy system and SAP; worked on master data and transactional data migration using LSMW.
- Worked on periodic and annual closing procedures for FICO and cross stream modules.
- Configured settings for booking Inter Company Transactions for Consolidation.
- Worked on Budgeting, commitment management and automatic upload of CCA and PCA budgets.
- Was Primary team member and responsible for solving the problems/issues with the user, configure and test SAP for change requests, Incident tickets and design and test development objects for the new enhancements needed.
- Worked on Validations and substitutions.
- Determined the sequence for scheduling the various background jobs and created Variants to be used while creating jobs on Maestro
- Developed integration test scripts and tested them in coordination with SD, PP and MM Modules
- Trained users to work on calculation and reporting taxes on a single platform to give them a better control on transaction tax compliance and make sure tax liability is determined accurately.
- Used Report Painter, Report Writer for reporting during the implementation of the project and developed reports.
- Prepared material using Microsoft Visio and gave to Key users and end users.
- Worked on Go-live and Post Go-live support.
Confidential, Greenville, NC
SAP Associate Consultant
Environment: SAP R/3 4.6, GL, AR, AP, OCR/ICR, ACH, APP, Foreign Currency, Check Management, System Testing, Automation Testing, UAT, Integration Testing.
Responsibilities:
- Worked on solving the production issues regarding OCR/ICR, Automatic Payment Program (APP) to pay the open payables. Also worked on setting up of ACH and Wire payments to vendors
- Configured automatic interest calculation procedure, payment terms, correspondence and dunning procedures.
- Worked on issues regarding check management, void reason codes and invoice verification.
- Monitored day-to-day activities and fixing incorrect postings as they occur.
- Checked assignments of relevant cost objects, in particular materials related to respective profit centers.
- Tested conversion of AR master data from legacy system to SAP
- Configured Screen layouts for vendor master and customer master data.
- Configured house banks, bank accounts, reason codes, check lots and lockboxes for payments.
- Completed Unit testing and integration testing. Created authorization profiles and tested the system before go live.
- Worked on Foreign currency revaluation to reevaluate the vendor open items and also setup the G/L accounts for Realized gains and losses in revaluation
- Involved in writing Integration Testing Scripts as well as User Acceptance Testing Scripts
- Supported the client in Post Go Live and worked on Post Production Issues