Sap Fi/co Consultant Resume
Omaha, NE
SUMMARY
Over Eight years of IT experience with around six years of experience as a SAP FI/CO Consultant with thorough knowledge of applications such as General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Treasury and Controlling.
Overview:
- SAP FI/CO Technical Consultant with 6+ years of experience in SAP FI/CO covering multiple sectors such as Pharmaceuticals, CPG, Utilities, and Manufacturing Industries. Worked on end-to-end project implementations, configuration, upgrade, testing, training and production support with a proven record of continuous improvement and effectiveness
- Involved in Creating business blueprints for the processes and specified the requirements.
- Excellent Configuration knowledge in SAP FI.
- Expertise in Cross-module business processes knowledge. Lockbox, Positive pay and Bank reconciliation.
- Involved in Preparation of Annual Budget (Projected - Balance sheet, Profit & Loss statement, Cash flow, Capital Expenditure, Human resource, Inventory, Sales etc.,) Branch & Department-wise, line of Activity -wise (business area) and consolidation of company wide budget
- Developed high quality deliverables including: Business Process Procedures (BPP) and Process Design Document (PDD) with Visio Process Flows and narratives
- Involved in writing various test plans and coordinate Unit Testing, Integration Testing, Regression Testing and User Acceptance testing and Lead the testing team
- Expert in data migration system from legacy to SAP R/3 using Legacy System Migration
- Preparation of Management Information report (MIS) and variance report.
- Management of Accounts Receivables (Credit control, Invoice Management, Collection, Allowance for Doubtful debt), Accounts payables (Approval of Invoice to Disbursement) & Cash flow (Forecasting collection using cash Manager and collection Manager Analysis from Software)
- Good Skill set of MS word, MS excels, MS Access, MS Outlook, Power Point, ACT Contact management software.
- A good team player and a good individual starter with excellent communication skills.
Educational Qualifications
Bachelors in Engineering (Computers) (India)
Masters in Computers (India)
SAP Skills
FI: GL, A/R, A/P, Fixed Assets, SPL
Treasury: Lock-Box, Cash Journal
Reporting: Report Painter & Report Writer
Integration: FICO integration with MM, SD
Tools: ASAP Methodology
Other Skills ERP:SAP R/3 Versions 3.1H, 4.0B, 4.6B, 4.6C, 4.7
RDBMS: Oracle 8.1.5
TOOLS/UTILITIES: MS Office suites, Visio Professional
O/S: MS DOS, Windows NT, 95, 98, 2000
Professional Experience:
Client Name :Confidential, OMAHA, NE Jan '10 - Present
Role : SAP FICO Consultant
Responsibilities:
- Participated in gap analysis and coordinated business requirements from the client.
- Performed As- Is and To-Be study for the client's current business and worked in blue printing and implemantation phases of the project.
- System configuration and testing in the areas of FI-GL, FI-AR, FI AP, FI-AA and FI-GL: Master data preparations, G/L accounts creation and processing, creation of sample accounts and data transfer rules, setting for processing of open items.
- Created house banks, bank Accounts and assigned the accounts to a check lot.
- Creation of FI-AP vendor groups, creating number ranges and assigning, creation of tolerance groups, creation of vendor master and document types.
- Creation of FI-AR customer groups, overall Receivables and employee tolerances, terms of payment and interest calculation configuration. Configuration of lock box, lockbox file formats and lock box processing and bank statement processing.
- Configuration of FI-AA Asset classes, depreciation areas, assigning company codes to dep. Areas, creation of screen layouts and no. ranges, creation of dep. Keys like ordinary depreciation, special depreciation and imputed depreciation.
- Configuration of Dunning, Correspondence, Payment Terms and Automatic Payment Program.
Confidential, Indianapolis, IN
SAP FI/CO Configuration Consultant Jan07 - Dec09
Project involved the configuration of FI/CO.
- Configured Company Codes, Chart of Accounts and Business Areas
- Worked on Configuration and Validation rules for the Company Code
- Worked with the basis team to transport changes across environments
- Configured the posting key, Tolerance groups, Number ranges and Document types
- Extensive experience with creation of master data relating Accounts Payable including vendor masters.
- Assigned tax codes, Configured fiscal year variants and tolerance groups and assigned tax codes
- Configuration of Field status and also settings related to Document and Posting Control
- Development and enhancement of Automatic payments program
- Integration FI with Materials Management and Sales and Distribution modules
- Configuration of Dunning program
- Extensive experience with creation of master data relating Accounts Receivable including customer masters.
- Experience in configuring and maintaining Special General ledger accounts including Guarantees and bill of exchange.
- Master data creation for cost elements, cost centers, Internal orders and profit centers
- Developing training documentation relating various cost objects creation and CO-postings
Confidential, Naperville, IL
Mar\'06 - Nov\'06
Sap FICO Consultant
Involved in process design, mapping and business process re-engineering to match the client requirements with SAP. Involved in As-is and To-be process.
- System configuration and testing in the areas FI and CO includes internal trading partners creation.
- Creation of New G/L Accounts, Chart of Accounts, FSG, FSG Variant assignment, Posting periods, financial statement version and configuration for open item processing.
- Accounts Receivable/Accounts Payable: Configuring for open item processing, preparing the functional specifications and testing of the report, Invoice verifications, Open item clearing, Down payment, Configuring automatic payment program and dunning.
- Creation of Cost centers, cost elements, activity types, standard hierarchy and settlement.
- Report creation in Report Painter/writer for cost center accounting and profit center accounting.
- Write functional design specs for FI-CO RICEF includes Outgoing payment interface, Journal upload, email remittance to employee vendors, dunning notice forms, correspondence letters to customers, cost center to MPC outbound and currency rate upload.
- Involved authorizations process including identifying authorizations, profiles, objects, fields and activities.
Confidential, Eden Prairie, MN
FI/CO Consultant Sep'05 - Feb'06
- Project involves the implementation of G/L, Treasury and Accounts Receivable modules.
- Implemented the lock box processing including file formats, configuration, lockbox processing
- Implemented Bank statement processing and Exchange rates.
- Implemented overall AR and Employee tolerances
- Implemented Credit Management.
- Configured Dunning Program and implemented enhancements to customer master and vendor master
- Implemented Credit Management & Interest calculation Implemented the settings for interest calculations of delayed payments
- configured the parameters for payment program and implemented clearing of open items
- Implemented payment check processing and management.
- Worked on month-end and year-end closing processes
- Cash Management (liquidity forecast, cash position, electronic bank statement, lockbox, payments), Hedge Management, Market Risk Analyzer, Credit Risk Analyzer, Cash Budget Management.
- Formulated and implemented cross training schedules to ensure full function coverage, and all management requirements are met
This project involves the implementation of FI/CO Treasury configuration
- Participated in the activities of the Cash Management/Applications group of Treasury and Finance.
- Areas of participation and analysis included capital/money market investing, short-term funding, cash forecasting, cash management optimization, funds mobility, banking systems and corporate controls.
- Reviewed monthly bank account analysis statements and provided recommendations where appropriate.
- Monitored daily cash position and verified prior day bank account activity.
- Prepared monthly interest accruals for outstanding debt and investments and confirm activity on investment account statements.
- Reviewed monthly bank account analysis statements and provided recommendations where appropriate.
- Prepared monthly subsidiary cash and investment reported and verified that all investments are in compliance with our investment policy.
- Monitored debt covenants for credit agreement and prepared quarterly compliance certificate.
- Maintained cash management-banking relationships.
- Created and maintained a database of worldwide banking relationships, account numbers and signatories.
- Monitored daily cash position and verified prior day bank account activity.
- Formulated and implemented cross training schedules to ensure full function coverage, and all management requirements are met
- Enterprise Structure in Controlling: Setting up of controlling area, assigning company codes and creating standard hierarchy, creating CO version and defining control indicators.
- Cost Center Planning: Configured cost center planning, Configuration of Profit centers accounting.
Confidential
Sr.QA Engineer Jun'04 - Dec '04
Software Analyst
- Involved in Analysis, design, construction and deployment phases of SDLC.
- Interfaced with IT staff, client organization.
- Created detailed test plans and scripts to verify functionality and adherence to business requirements.
- Adhere to the project delivery process and documentation requirements and internal project.
- Done functional testing and regression testing with Win runner.
- Developed test scripts for Data driven tests to gauge the performance of the application.
- Manage all verification and validation activities for all production modifications including projects, releases and changes.
- Conditioned accounts as per the functional requirements such as change of status combine of accounts and etc.
- Scheduled test execution using Test Director and documented the defect findings.
- Co-ordinate with developers in reviews and solving the problems encountered in the application.
- Coordinated with business leads, project managers and QA core members.
- Developed time estimates, & provided with written status reports.
- Used Test director to track the defects.
- Performed Regression testing upon defect fixes and reported results to the business leads.
- Interfaced with IT staff, client organization.
- Involved in understanding functional requirement document and providing feedback. Provided documentation Design programs to meet specifications and conform to internal standards
Confidential, Atlanta, GA.
Programmer Analyst
Jan04 - Jun04.
The project was developed to enable the bank customers to access their various accounts over the web, account holders can handle their, accounts including saving,checking,money market accounts & credit card accounts. The application also allowed users to administer & monitor their account performance and activity electronically by having access to account balances, bill pay & transfer of funds & make changes in future allocations and personal information. Application also dealt with providing customer with services like ordering checks, requesting copies of checks & statements made in the past.
Tested softwares developed for various banks like Bank of America,Suntrust,WAMU.
Responsibilities:
- Involved in understanding functional requirement document and Buisness requirement document.
- Involved in black box type of testing where I was responsible for running registration, login, deposits, and withdrawals for online banking system.
- Performed regression testing to make sure that any modifications in the product did not side effect the system, or caused any errors
- Involved in black box testing where I was responsible, for running registration, login test cases.
- Responsible for running forgot password testcases, transfer money from and into accounts test case.
- Used Load Runner for Web Performance and Web Monitoring Testing to check for the maximum customers it can handle at a time.
- Involved in writing test plan for the testing cycle.
- Created and Performed Data Driven Testing.
- Tested backend database using SQL queries to carry out Regression test easily.
- Developed testcases & executed with all phases of testing.
- Interacting with developers for the savior priority bug issues.
- Extensively used Web functional test tools like Win Runner for Functional Testing, Load Runner for Web Performance and Web Monitoring Testing.
- Used Test director as defect tracking tool.