Sr. Sap Fi Consultant Resume
Houston, TX
SUMMARY
- Accounting Graduate with over 11 years of Industry experience including 9 plus years as SAP FI/CO consultant.
- Expertise in configuration and customization of Financial (FI) (GL, AR, AP, BA, AA, SPL, NGL).
- Strong working knowledge in Controlling (CO) (CCA, OM, PCA, COPA, CO - PC)
- Extensive experience of (4) Full Life Cycle Implementations, (1) Rollouts, (1)Support and (1)Upgrade projects
- Worked on 3 Global Implementations and 4 Small Scale projects.
- Worked as Project lead and experience in Off-Shore model of development
- Excellent communication and inter personnel skills. Proven ability to work independently and team environments
- Extensive experience in configuration, implementation and testing of SAP FICO modules GL, AR, AP, Asset Accounting (AA), Banking, Treasury, Credit Management, Project Systems (PS), Cost Center, Internal Order, Profit Centre (PCA), Profitability Analysis (CO-PA), Product Costing (CO-PC) and New GL
- Design and configuration experience in New GL and Multiple ledgers and Document splitting.
- Integration of FI with MM and SD with Procure to Pay (P2P) and Order to cash Cycles (O2C)
- In-depth knowledge in configuration, implementation, ASAP methodology, system design and development and gathering user requirements
- Experience in Blueprint, Configuration, Unit, Stress, Volume, Regression, User Acceptance and Integration Testing, Training, Documentation and Production support.
- Experience in working with clients spread across multiple regions, countries, companies, currencies and environments
- Experience with Month-End/Period-End closing activities and Closing cockpit
- Experience in upgrade from SAP R/3 Version 4.7 to ECC 6.0 Versions
- Involved in multiple implementations of Asset Accounting
- Working experience of Vendor Invoice Management (VIM) tools like OpenText.
- Working knowledge of Project Systems and integration with FI/CO modules.
- Familiar with FSCM concepts (Financial Supply Chain Management) like In-House Cash and Credit Management.
- Worked on Lockbox Processing, electronic funds transfer and Bank statement processing, Exchange Rates, and Translation Ratios, Bank reconciliation and Cash journal.
- Worked on Taxation configuration for Sales, Purchase (Use) and Withholding tax. Integration experience with third-party taxation tools like Sabrix and Vertex.
- Good knowledge in ABAP debugging techniques to work with user-exits and cross applications
- Experience in reporting tools such as ABAP queries, Report Painter and Report Writer
- Written Functional specs for RICEF (Reports, Interfaces, Conversions, Enhancements and Forms).
- Experience in all phases of System Development Life Cycle (SDLC)
- Knowledge of SAP FI and BW integration points and familiar with BEX and Web reporting.
- Used Testing automation and management tools like Confidential Quality center/ALM (Application Lifecycle management)
- Knowledge in identifying, testing and documenting of SAP application controls in compliance with Sarbanes Oxley Act (SOX)
TECHNICAL SKILLS
ERP: SAP R/3 Versions 4.7 and SAP ECC 6.0 Version and up
SAP: SAP FI: General Ledger, Accounts Payable, Accounts Receivable, Asset Accounting, Bank Accounting SAP CO: Cost Element Cost Center Accounting, Profit Center Accounting, Internal Orders, Profitability Analysis, and Product Costing
O/S and Tools: MS DOS, Windows NT, 95, 98, 2000, UNIX, MS Word, Excel, PowerPoint, MS Visio, Confidential ALM
Databases and Language: Oracle, MS SQL, ABAP, Progress, MS SQL, VB.net
PROFESSIONAL EXPERIENCE
Confidential, Houston, TX
Sr. SAP FI Consultant
Responsibilities:
- Involved in NGL implementation, primarily responsible for Asset Accounting.
- Involved in Configuration ofChart of Depreciation, Depreciation Areas, and Asset classes, Asset Master Data, Depreciation Posting, Acquisition and Retirement of Assetsat Assets Accounting.
- Defining Deprecation Areas for USGAAP, Local GAAP and Delta Areas, Depreciation keys, Asset classes and Number Ranges, Integration between GL and Asset Accounting, Account Determination and Posting rules
- Created Functional Specs for custom reporting requirement in Asset Accounting
- Master Data, Go-live preparations, production startup, RTP and warranty support.
- Engaged on Different FYV requirement in Asset Accounting and coordinated with SAP North America on Technical analysis and Demonstration of SAP AMT Tool.
- Involved in SAP BW Account Hierarchy solution for local statutory reporting for multiple countries.
- Provided assistance on Spot Rate implementation project for pilot countries Costa Rica, Slovakia, Turkey from Accounting Rate to Spot rate for transactional and MEC/YEC revaluations.
- Worked on customer transactions, Master data, Payment terms, Cash application, Lockbox processing, Mapping Bank Lockbox format with Sap lockbox format, customizing payment advice notes on Accounts Receivable (A/R).
- Configured Automatic Payment Program for Check, Wire and ACH payments.
- Created Bank Master data, House banks, EDI,ERS, G/L accounts for each bank account and Reconciliation accounts for vendors, customers and assets.
- Involved in end to end implementation of WHT for 6 countries including extended WHT for some countries.
- Development of test scenarios/ test cases and resolved issues at Unit Testing and Integration Testing and System Testing on Confidential QC/ALM.
- Created Test cases, Test scenarios and Test Strategy for Integration and Regression Testing and also uploading them to Confidential ALM. Executing the test cases in Confidential ALM and capturing the test results and generating defects reporting.
- Conducted User Acceptance Testing workshop and tracking progress and issues and resolving them in given ETA.
- Training end user community and provide KT to OC support team for smooth transition
- Deployment, MOC and Warranty/support of the solution.
Confidential, Lexington, KY
Sr. SAP FI/CO consultant
Responsibilities:
- Involved in implementation of General Ledger Accounting, Accounts Receivables, and Accounts Payables.
- Configured, and extended, Chart of accounts to .multiple company codes, defined field status groups, for GL Masters, Vendor Masters, and Customer masters.
- Defined Multiple Ledgers to address US GAAP, and Local GAAP for Canada.
- Document splitting configurations done for segment reporting.
- Defined Payment terms as per the country requirements.
- Defined automatic account determinations for AP, and AR. - Bill of exchanges, Down payments, and Tax account determinations.
- Defining House Banks, Defining Lock Boxes for House Banks, Defining Control Parameters and Posting Data for Auto Cash with Lock Box, and Customizing configuration for Importing Electronic Bank Statement.
- Preparing Functional Specs, worked intensively on Enhancements for Lock Box and Electronic Bank Statement.
- Configuring Integration aspects of SD and MM with FI/CO. Configured Automatic account determinations for MM, SD, and Taxes.
- Designed and Created Cost Center Hierarchy. Created Cost Centers, Designed and Created Assessment Cycles to Allocate Overhead Costs.
- Maintained planner profiles, planning layouts and planning version for planning in controlling.
- Development of test scenarios/ test cases and resolved issues at Unit Testing and Integration Testing and System Testing
- Involved in cutover activities, and data migration. GL Balances conversion, Accounts receivables, and Accounts Payable balances conversion.
- Integrating SAP with Third party software system (SABRIX) for taxes and functional specs written foruser exit development, and VAT & VAT related reports development.
- Configured tax settings in SAP, for all geo's to meeting the input and output taxes.
- Customized VAT Netting programs to meet the requirementswith SABRX integration.
- Involved in FSCM - In-House Cash and Credit Management activities
- User training, and assisted to users immediate after go-live.
- Involved in Supporting FI/CO Reconciliation during Month-end, Quarter-end and Year-end close.
- Continuing in COE team for user support, and process improvement.
Confidential, Franklin, TN
SAP FI/CO Consultant
Responsibilities:
- Involved in Implementation of General Ledger Accounting and Asset Accounting.
- Involved in design, realization, and deployment phases.
- Conducted workshops with business teams, prepared AS-IS, and TO-BE documents for General ledger Accounting, and Fixed Assets Accounting.
- Configuration of FI global settings, Configured company codes, Created GL accounts, Defined posting keys, maintained field status variants and assigned to company code, screen variants for document entry as per business specifications and tested the configuration in various scenarios..
- Implemented Down payments, Bill of exchanges, and Noted items.
- Parallel ledgers defined, and designed reports for US GAAP, and Local GAAP.
- Automatic account determinations for Taxes, SD, and MM are configured.
- Worked with data migration teams, and written Functional specs for GL transactional data migration. Accounting BAPI’s are used in data migration programs.
- ConfiguredCash Journals, Cross company postings, and Intercompany transactions integration with SD, and MM.
- Was involved in Planning, development and executionof test cases in SAP FI Module.
- Involved in the preparation of training material and end user training to process owners in General Ledger accounting, and Fixed Assets areas.
- Preparing of functional specification for Forms, reports, and Enhancements.
- Involved in Opening&closingofpostingperiods.
- Configured SD Condition records in COPA by creating access sequence; tables, condition types and mapping of these value fields to SD condition types and assigned pricing procedure in COPA.
- Made changes to reconcile PCA (Profit Center Accounting) to COPA (Profitability Analysis) for P&L accounts; also includes modification of COPA user exits and creation of new field status groups.
- Configured CO-PA (Profitability Analysis) to facilitate complex price reporting requirements and profitability reporting.
- Created cost component structure, future cost estimates by assigning costing keys in COPA (Profitability Analysis) and created custom user exit enhancement for reporting of planned price in COPA (Profitability Analysis).
- Worked on customizing CO-PA both costing based (with value fields) and accounting based.
- Created custom KE31 reports for the management and users in CO-PA (Profitability Analysis).
- By setting the status to TECO that were not billable, resolved issues in Product cost by Sales order / Production order.
- Configured Cost component structure and roll ups, BOM. Set up material cost estimate with quantity structure.
- Worked in PTP (Procure-To-Pay) business process.
- Go-live and continuous support.
Confidential, San Jose, CA
SAP FI/CO Consultant
Responsibilities:
- Analysis, validation and testing of key FI/CO processes in SAP including impact analysis ofcustom programs, batch jobs, interfaces and custom reports.
- Coordinated overall efforts to develop testing scenarios, test scripts and unit & regression testing plans.
- Also coordinated system cutover and resumption tasks pertaining to SAP Financial application areas of SAP 4.7 Upgrade.
Confidential, Hartford, CT
SAP FI/CO Consultant
Responsibilities:
- Defined customer / vendor account groups, configured vendor / customer master data settings, defined payment methods for vendor / customer and configured automatic payment program for outgoing payments in A/P.
- Configured House bank, Bank determination and set tolerances limits, scheduled Automatic Payment Program for payments to vendors and others, created check lots and online cashed checks in A/P and A/R.
- Analyzed and verified the whole procurement cycle from determination of requirements to payment procedures and order to cash cycle.
- Maintained interest calculation procedures for overdue customers, cash discounts, customized forms for dunning and confirmation of balances for period end closing, configured credit management, debit and credit memos, down payment, tolerances and reason codes.
- Configured reason codes with A/R (Accounts Receivable) analyze payment differences and avoid G/L coding errors.
- Efficiently dealt with the unresolved A/R (Accounts Receivable) accounts by using Deduction management component.
- Configured Vendor account groups, terms of payment, payment methods, and automatic payment programs (APP) for Item clearing.
- Resolved the issues pertaining to vendor payments using payment requests.
- Implemented Asset accounting acquisition, transfer, retirement, and asset class and depreciation areas.
- Configured Lockbox settings for incoming payments as per the BAI2 format and cash management including cash concentration, wire transfer settings and ACH payments.
- Written functional requirement specifications for conversions and scheduled period closing using schedule manager to automate repeated activities and monitored successful execution of transactions.
- Configured the master data, standard hierarchy, Dummy profit Center, Distribution and Assessments in Profit Centre accounting (PCA).
- Used Top-Down Distribution in CO-PA (Profitability Analysis) to Report Overhead Costs at Lower-Level Characteristics.
- Configured and Managed All Period-End Closing Activities with Schedule Manager. Worked and maintained Cost center standard hierarchy with cost center groups representing organizational structure of the company, representative cost centers for summarization.
- In Profitability Analysis (CO-PA), created the characteristics and value fields, defined derivation structures and rules, maintained derivation table and profitability segments.
- Defined Costing type, valuation variant, date control, quantity structure control, transfer control and reference variant for defining costing variant in product costing CO-PC.
- Configuring and Customizing the basic settings, maintained profit center hierarchy, assignments, CO-Objects to Profit Centers, distribution and assessment of costs, Planning and development of Reports.
- Used LSMW for data loads.
- Integration and validation of test scripts to validate all business requirements.
- Proactively participated in the preparation of training material
- Trained the Super-users and End-Users at different strategic business units of the client.
- Performed Cut-Over activities, Go Live and post-Go-Live support.
Confidential, San Jose CA
SAP FI/CO Consultant
Responsibilities:
- Full production support for General Ledger Accounting, Accounts Payables and Accounts Receivables, Assets Management Cost Element and Cost Center Accounting, Internal Orders.
- Analyzed the existing system for, AS-IS study, gathered functional requirements through user workshops, gap analysis, and participation in process improvement teams
- Involved in all the test phases unit testing, integration testing, User Acceptance Testing (UAT). Provided informative documentation to help the end users
- Involved in go-live phase and provided post live support in clearing the tickets.
- Worked with BW team in developing reports as per the user requirements.
- Worked withABAPteam in developing customized reports for Controlling. This involved providing functional specifications, testing and end user training.
- As part of support team, involved in month end process. GL closing includes, opening of new material periods, and GL periods.
- Executing GR/IR programs, AR and AP re-class programs, and Depreciation runs. Preparing Monthly Financial statements and reconciling them with BI reports.
- Provided production support for the month end close activities in the controlling which involved resolving issues in Allocations, Settlements, and Re-postings of Cost centers.
- Provided End user documentation for error handling for the month end close procedure.
- Worked with ABAP consultants, in identifying the root cause for few customized process, like Third Party Logistics provider interfaces, Tax ware system failures, and Portal integrations.
- End-user support, troubleshooting and enhancements
- Attending to work orders for enhancements in the FICO area
- Uploaded legacy data using workbench tools
- Involved in uploading and migrating the Master records to SAP from Legacy using LSMW
- Finance and Controlling Closing procedures executed:
- Establishing Support procedures.
- Executing periodic reports and analysis of reports with data.
- Developing and Enhancing the existing and new reports
- Resolving Business user’s problems and guiding the procedures in execution of SAP Transactions.
- Training in SAP transactions
- Documenting business process using BPP template
- Modified and Enhancements to Check management systems and Lock Boxes
Confidential
SAP FI/CO Consultant
Responsibilities:
- Conducted AS-IS study interacting with the core team members and developed a TO-BE process to suit the company’s objectives using ASAP methodology. Involved in Business Blueprint Phase and worked on field mapping to study the GAP Analysis.
- Set up company codes, chart of account, fiscal year variants, tolerance limits, posting periods and financial statement variant.
- Created Segments and assigned Scenarios and Customer Fields in the Ledgers.
- Created separate country-specific financial statement versions.
- Defined reconciliation accounts for A/P (Accounts Payable) and A/R (Accounts Receivable).
- Configured Accounts payable (A/P) including vendor account groups, number ranges, tolerance groups.
- Created vendor/customer groups, assigned Number ranges, Tolerance groups and Document types.
- Involved in creation of work centers and project profile using project builder/project planning board and IMG module.
- Worked with the management in budget allocation, assisted the client in budget management and releasing the budget.
- Evaluated cost planning on project forecast, and performed Project Summarization.
- Extensively worked on LSMW, CATTS and ABAP Queries with the ability to act as a techno functional consultant.
- Configured and customized Account groups, posting keys, Document number ranges and document types, Open and closed posting periods and maintained Field status groups.
- Configured Controlling area, Cost elements, Cost centers, Profit centers for CCA and PCA with Integration of FI with SD and MM modules.
- Configured Cost objects, Account assignments, Allocations and Settlements in CO.
- Maintained Overhead Cost Elements defined Costing sheets, Credits, Overhead Keys. Configured Standard Cost estimates in Product Cost Planning for the production orders with Quantity structure and configured WIP Calculations and variance calculations.
- Created Settlement Profile, Allocation structure for period end closing and maintained number ranges for settlement documents.
- Trained end users about the new system functionality and explained the integration between the various modules SD, MM, FI and CO.
- Resolved critical business issues related to finance and controlling.
Confidential
Finance Executive & Key Team Member
Responsibilities:
- Reporting to Managers of Accounts and Distributions Departments.
- Preparing and maintaining books of accounts and statutory requirements.
- Preparations of age wise reports of Debtors and creditors preparations of MIS Reports.
- Reconciliation’s of stock and inventory
- Preparation of costing reports and meeting the requirements of external an internal auditors
- Super user and supporting ERP implementations
