Functional Consultant Resume
New, YorK
Summary
- Over 15 yrs of Functional experience in Finance & IT and with 10+ years of experience in SAP R/3 expertise with a strong focus on Financial Accounting and Controlling (FI/CO) modules.
- Significantly contributed in Two Life Cycle implementation, Enhancement, Upgrade & Support in Finance and controlling modules in various roles handling responsibilities as required.
- Experience in leading a team
- Experience in gathering & analyzing business requirements and business process Re-engineering.
- Expertise in configuration testing of FI/CO modules - General Ledger (FI-GL), Accounts Receivable (FI-AR), Accounts Payable (FI-AP), Asset accounting (FI-AA), Cost center accounting (CO-OM-CCA), Profit center accounting (CO-PCA), Product Cost Controlling (CO-PC) and Internal orders (IO).
- Expertise in configuring the system based on client\'s requirements and best business practices.
- Experience in integration of FI/CO with SD and MM modules - Account determination.
- Experience in Multi Currency.
- Good understanding of ASAP methodology.
- Customized Special Purpose Ledger in arriving reports
- Strong knowledge in Financial Accounting and Managerial Accounting concepts.
- Working experience in pharmaceutical industry.
- Strong analytical, problem solving and conceptual skills combined with a variety of Functional skills.
- Self motivated with an ability to work independently and in a team with excellent communication and interpersonal skills.
- Excellent time management skills with an ability to prioritize and meet deadlines.
- Experience in Testing, Go-Live, Post-Live support.
FI Configuration Experience
- Confidential: Company code, business areas, functional areas, chart of accounts, fiscal year, posting period, sales and purchase tax.
- FI-GL: Account groups, GL master records, sample accounts, field status groups, posting keys, automatic account determination, inter-company automatic account posting, sales/purchase tax assignment, number ranges, document types, tolerance groups and Financial Statement Versions.
- FI-AR: Configured and Supported Order - to - Cash from Sales order to accounting receipt of cash. Customer groups, customer master data, payment terms and interest calculation, incoming payments, dunning, AR information system, Lock Box Process & closing operations. Configured required setting for Credit Management - Defined Credit Control area and assigning it to company code, Credit representative groups, defining risk management categories and defining and maintenance of Automatic credit control in OVA8. Configured settings related to DMC (Deduction Management Component) - Defined Notes Tickler Status codes, action codes and outcome codes and defined Notes tickler priority and defined layout to keep track of the customer payment correspondence.
- FI-AP: Configured and Supported Purchase to Pay from Purchase order to Payment made to the vendor and accounting the same. Vendor groups, vendor master data, automatic payments, recurring entries, invoices, credit memos, closing procedures, Creation of Special GL and Linking with Reconciliation Account.
- Asset Accounting: Asset class, asset master records, chart of depreciation, acquisition, Work in Progress, Retirement, Inter-company transfer.
- Defining Tax Procedure and assign it to the country. Defining sales & purchase tax and assigning non-taxable tax to the company code.
- Financial Statements: Financial closing of GL, Assignment of G/L accounts in FSV, GR/IR accounts, and financial statement creation.
- Bank Accounting: House Banks, bank accounts, check lots, Manual Bank Statement, Electronic Bank Statement, Lockbox Processing, and Automatic Payment Program.
- New G/L- Defining Document Split (Active & Passive), Defining Segment & attaching at PCA level and Defining Leading & Non-Leading ledger.
CO Configuration Experience
- CO - Configuring controlling areas, cost center hierarchy, nodes as required in the blue print
- Cost Center Accounting (CCA): Creating cost centers, cost center groups, activity types and statistical key, reposting.
- Defined settlement rules and settlement parameters for settlement of orders to cost objects
- Profit Center Accounting (PCA): Profit center, revenue elements.
- CO-PC - basic setting required for product cost estimates with quantity structure for different products.
- Defining origin groups, costing sheet with calculation bases, percentage overhead, quantity based overhead and credits, cost component structure
- Configured cost component & costing variants.
- Created production orders and tested the preliminary cost estimates and final settlement to cost objects
Integration of MM and SD with SAP-FI/CO module- Order to Cash, Account determination.
Hands-on experience in using Reporting tools like Report Painter and Drill down Reports which is used for analysis, performance, accounts history, and day to day business processes.
Confidential Jul 09 - Till Date
SAP R/3 FI/CO Functional Consultant (ECC 6.0)
Confidential is a biopharmaceutical company dedicated to the development, manufacturing, and commercialization of important medicines for patients with cancer and other life-threatening conditions. Enzon has a portfolio of four marketed products, Confidential
Responsibilities
Support FI/CO Module:
Month end activities in FI/CO:
Depreciation
Recurring Entries &
Foreign currency revaluation
AUC settlement of Asset - Defining & settling the same
Calculation of WIP,Variance & Settlement.
Periodic reposting, Distribution & Assessment
Defining Pre-payment process for the advance received from the customer through Down payment
Coordinating with the technical team for the technical & functional specification to develop report.
Updating the price in material master through mark & release (CK24)
Report painter reports modified as per the client request with single & multiple sets.
Configured Auto-payments for the payment process (F110).
Configured shipping and handling process for the Sales Order.
Supported - New G/L functionality in ECC 6.0 version.
Reversal of assets transferred from AUC
Confidential, Manhattan, New York Aug 07 - Jun 09
SAP R/3 FI/CO Functional Consultant (SAP R/3 4.6C & ECC 6)
Confidential is a global marketing research firm, with worldwide headquarters in New York City. Regional headquarters for North America are located in Schaumburg, IL. This company was founded in 1923 in Chicago, Illinois, by Arthur C. Nielsen, Sr., in order to give marketers reliable and objective information on the impact of marketing and sales programs. Confidential began expanding internationally in 1939, and now operates in more than 100 countries.
Responsibilities
Configuration as per the requirement:
- Company Code configuration for G/L, A/P & A/R
- Lock Box configuration - EDI IDOC
- House Bank set up
- Closing of Company code.
- New G/L - Defining Document Split (Active/Passive), Defining Segment and attaching at PCA level and Defining Leading & Non-leading ledger.
- Configured - Order to Cash - from sales order/Delivery/PGI/Billing/Release to Accounting to Receipt of Cash and accounting the same.
- Configured - Purchase to Pay - from purchase order/Release PO/Goods Receipt/Invoice verification to payment made to the vendor and accounting the same.
- Configured required setting in Credit Management & DMC (Deduction Management Component).
Supported & Upgraded to ECC6 from 4.6C.
Support:
Handle issues from Help Desk:
- T & E Issues under Travel Management
- Handled issues in FI & CO on daily basis
- Quarter/Month end closing activities
- Year end closing activities
- Supported issues related to Purchase to Pay & Order to Cash.
- Supported issues related to Credit Management & DMC.
- Handling scheduled jobs in Lock box transaction on daily basis
- Handling scheduled jobs in Credit card transaction on daily basis
- Manual & Auto payments processing in Accounts Payables
- Customized & Supported Special Purpose Ledger in arriving reports
- Reports - in Report Painter in single & multiple sets & customized reports for audit purpose
- Supported BW in co-ordination with BW consultant.
- Co-ordinate with Technical consultant with the Functional & Technical spec.
- Asset Accounting - defined chart of depreciation, various depreciation areas and depreciation keys, Asset Classes & number ranges. Supported asset accounting in creation of Asset, acquisition of asset, depreciation as month end closing activities, transfer of assets within company and inter-company, retirement of asset and asset under construction.
Upgrade:
- Unit Testing
- Integration Testing (with Testing Doc. before moving to production)
- User Acceptance Testing (UAT)
- End user manual preparation
- Training end user in Travel Management & FI/CO sub modules
Confidential, Princeton, NJ Mar 07 - Jul 07
SAP R/3 FI/CO Functional Consultant (SAP R/3 4.6C)
Confidential- Myers Squibb, a pharmaceutical company with Global Sales of $17.9 billion with the product & services into Pharmaceuticals, Mead Confidential having its headquarters in New York, USA.
Responsibilities:
- FI - Team Lead (A/R) - Implementation of Lockbox for 2(two) Co. codes.
- Based on System Requirement Specification (SRS), Lockbox was suggested & implemented:
- Automatic cash application for Trade Customers
- Cash application with foreign exchange impact
- Cash application with discount
- The ability to apply short payments. Open items due to short payment are left open until the entire payment is received
- The ability to apply cash without invoice reference to a Customer and then to be able to clear the payment against an invoice later on
- The ability to apply cash for multiple Customers in one process
- Miscellaneous differences (Bank charges, etc.,) to be written off from the Customer account
- Project plan was prepared & Design specification was validated & approved for Lockbox
- Configured SAP settings for Lockbox.
- In co-ordination with EDI team, segment mapping was done
- Unit Testing
- User Acceptance Testing (UAT)
- Trained users on Lockbox
- Documented the configuration for Lockbox
- Went on live & supported for 15 days
Confidential, Rome, Italy Mar 06 - Feb 07
SAP R/3 FI/CO Functional Consultant (SAP R/3 4.5B)Confidential is the United Nation's food aid agency and the world's frontline agency in the fight against hunger to provide food aid to the poor & needy nations and to support development as well as emergency activities based at Texas, USA.
Responsibilities:
- FI - Team Lead - Functional specification, Identify, Schedule and Assign tasks to team members and Monitor assigned tasks
- Configured settings for Company code, Fiscal year variant, Chart of accounts, posting period variant, field status variant and field status groups
- Configured Account groups and retained earning accounts to create GL Master
- Created Credit Control Area, Assigned to the company code
- Defined chart of accounts, account group and general ledger accounts for each company code
- Created Bank Master data, House banks, G/L accounts for each bank account and creating reconciliation accounts for vendors, customers and assets
- Configured Automatic Payment Program for out going payments in Accounts payable.
- Configures Tax procedures, Purchase tax and assigned it to the European country standard & assigned non-taxable tax to company code. Define tax exemption with 0%, as WFP is charitable organization.
- Created Customer groups, customer master data, payment terms and interest calculation, incoming payments, dunning, Lock Box Process & closing operations.
- Configured settings required for Electronic Bank Statement (EBS) and supported the issues related to EBS.
- CO - Team Lead Functional specification, Schedule and Assign tasks to team members and Monitoring assigned tasks
- Configured Controlling Area, versions and maintain number ranges for controlling area, also maintained Standard Hierarchy.
- Created Financial Statement Versions
- Defined and configured cost & revenue elements and cost centers
- CO-CCA - Configuration including account determination and account assignments for transaction processing
- Defined and configured cost centers
- Configured cost allocation programs like assessments and distributions
- Support activities to resolve the issues in FI/CO
- Upload Bank file for various Bank accounts for making payments
- Defining the Expiring currency - Currency old & new & effective date
- Defined the Translation Ratio & Exchange rates
- Define G/L account for automatic posting of gain/loss on exchange rates
- Creation of new House Banks
- Auto clearing of the GR/IR account & Vendor open item
- Assigning of G/L accounts to new materials created
- Creation of New Business area and allocating the same
- Monitor customers support to track tickets till the closure
- Raising issues with SAP - OSS for the resolution
- Prepare Functional & Technical specification for the new development of Reports
- Release & Move the Transport request from one client to other client
Confidential, Sandi ego, USA May 05 - Feb 06
Role: SAP FI/CO (Version: SAP 4.6B)
Confidential are primarily involved in trading of semi conductors, Home electronics like TVs and other digital equipment based at Sandi ego, California, USA.
Responsibilities
- Understand and interpret user requirements
- Documenting business specification
- Scope and impact analysis of requirements
- FI-GL: Configured organizational structure like creation of company, company codes, group and operational chart of accounts including configuring for group consolidation and reporting.
- Configured Account Groups, Field Status Groups, Fiscal Year Variants, Posting Period Variants, document number ranges & Financial Statement Versions.
- Set up document types and posting keys for business transactions.
- Worked on house bank configuration, and bank reconciliation statements.
- Worked on lockbox, dunning, bank settings and interest calculations.
- Configured and tested integration between MM and SD modules with FI and CO.
- FI-AR/AP: Vendor master records, customer master records, account groups, number ranges for account groups, tolerance limits.
- Created credit control areas and pre-defined credit limits for customers.
- Country/company code specific payment methods, manual incoming/outgoing payments and automatic payment programs for outgoing payments.
- Configured Payment methods/Check Writing, Identified one-time vendors and customers, and defined a separate screen layout for them.
- FI-AM: Configured Chart of Depreciation, asset classes, accounts determination, screen layout, number intervals, and depreciation keys.
- Defined asset classes, screen layout rules, and number range interval for asset classes and integration with GL Account
- Configures Tax procedures, Purchase tax and assigned it to the country & assigned non-taxable tax to company code. Define tax exemption with 0%. Also worked in Vertex, external software for tax in co-ordination with SAP.
- Uploading of balances of asset acquisition price, accumulated depreciation and depreciation account in master record and also asset class wise balances in GL account.
- Report Painter: Created new reports and modified the custom report groups to provide accurate walk across Income Statement
- Support users to resolve their issues
- Updating G/L accounts in FSV
- To retrieve the line item break-up for a particular account
- Configured for Expiring currency
- Define currency Translation ratio & exchange rates
- Defined FI Validation
- Prepare Initial Testing Document to provide to client
- Prepare Unit Test document
- Perform Unit Test
- Prepare various reports like Open call status, Pending Trend, Response and resolution report and SLA Reports
- Prepare Bank Reconciliation Reports and follow up with the bank for any discrepancy
Confidential, Minneapolis, USA Aug 04 - Apr 05
Position: SAP FI/CO (Version 4.6B)
A pharmaceutical company based at Minneapolis, USA. The scope of this project is to support the SAP modules of Confidential and also to upgrade from R4.6B to R4.7 and Enhancement of Labor & Material overheads in Product costing.
Responsibilities:
- Unmarking of G/L accounts from deletion
- Changing the status in the Field Status Group
- Updation of G/L accounts in FSV
- Assigning G/L accounts in the Valuation Class
- Updation of G/L account in T030H table
- Defined Validation to restrict user's to use particular account
- Updating Description in Vendor Account Groups
- Support users to resolve their issues
Upgraded from 4.6B to 4.7:
- Prepare Unit Test document
- Perform Unit Test
- User Acceptance Testing
- Synchronize between 4.6B to 4.7
Enhancement - Labour & Material overheads costing. Required configuration - Modifying the existing Costing Sheet, Cost Component Structure and Costing Variant in Product costing and moved to Production server after successful testing in QAS. Support in solving issues in product costing and taken care of month end closing activities.
Confidential. Oct' 02 - Jul'04
Position: SAP FI/CO (Version 4.7). In this project I was involved in Facilitating design discussions with business stakeholders and determined the appropriate solution to meet the business need. Directions were given in areas like implementation approach, deliverables, and required details.
Responsibilities
Implementation Plans; Documentation of 'AS-IS' and 'To-Be' design
Confidential Apr' 00 - Sep' 02
Position: SAP FI/CO (Version: 4.6B)
Confidential is networked worldwide and has an annual turnover of $ 2.0 Billion approximately. The primary business for Confidential is manufacturing and sale of batteries. Our team analyzed the SAP implementations for the company and implemented. A total of 26 members were involved in the project.
Responsibilities:
- Mapping Business Processes (which was being carried out on legacy system), customization/configuration.
- Configured the global settings for the company, co code, Business area and credit control area.
- Configured G/L Master records, document number ranges, posting period variants, opening and closing of posting periods, field status variants, document types, posting keys.
- Created house banks and payment programs.
- Created G/L master records and configured cross company code transactions, line item display, and open item processing for G/L.
- Configured Tolerance limit for Vendor, Customer.
- Assigned the tax procedure to company's country, specified the tax structure and assigned Tax codes for Non Taxable Transactions
- Defined Validation Rules in FI line item
- Configured the cross functional modules for the integration of Materials Management (automatic account determination) and Sales and Distribution (Revenue account determination) with FICO module
- Uploaded vendor and customer master records from the legacy system to SAP
- Configured Standard hierarchies for Profit centers, created profit center groups and profit centers (CO-PCA) and also configured changes in Standard hierarchies for Cost centers, created cost center groups and cost centers and assigned cost centers to respective profit centers (CO-CCA).
- Asset Accounting - defined chart of depreciation, various depreciation areas and depreciation keys, Asset Classes, number ranges, etc
- Carrying out Unit Testing and Integration Testing with all possible Business Scenario to ensure minimum problem.
- Ensured that the system is functioning according to the requirements of the organization.
Senior Finance Consultant
- Providing financial support in managing the banks ledger account, fixed assets inventories, trial balance, internal and external M.I.S. reporting.
- Monitor and maintain General Ledger, Fixed Assets, Trial Balance and Exhibit of Accounts.
- Preparing reports on bank advances, deposits, investments & securities, letters of credit, guarantees
- Developing departmental budget, financial analysis & reports to assist the Senior Management
Finance & Accounts Manager
- Responsible for maintaining the company accounts.
- Managed credit, debits, expenditure, outstanding payments, interest calculation, and assessment of vendors.
- Coordinated with the Systems department and helped them design the reports as required for the Finance department.
- Helped the Systems department to automate the entire process for sales and purchase orders.
Education
- MBA (Finance)
- BA (Economics)
- SAP R/3 Implementation Methodology
- SAP R/3 version 4.7 Enterprise orientation program
- SAP R/3 Upgrade training program
- Change control procedure training program
- GMP training program
- BPR Concepts
- Close to complete PMP Certification
