Post Job Free

Resume

Sign in

Management Accounting

Location:
Hoboken, NJ
Posted:
May 22, 2014

Contact this candidate

Resume:

VIKAS JOSHI

SAP FICO CONSULTANT

acd86q@r.postjobfree.com

732-***-****

PROFESSIONAL SUMMARY

• SAP FI/CO Functional -Technical Consultant with of experience in SAP FI/CO implementation, configuration, upgrade,

testing, training and production support with a proven record of continuous improvement and effectiveness.

• Overall multiple years of SAP FICO functional consultant experience with two full life cycle Implementations at Leica

Microsystems, McKesson Corporation & Culligan International.

• Experienced in all phases of the systems development life cycle which include system design, analysis, configuration, system

testing, data conversion, and production support in FI- General Ledger, Accounts Receivables, Accounts Payables, Asset

Management, CO- Cost Center Accounting, Internal Orders, Profit Center Accounting, Project Systems (PS), Material

Management and Order Management.

• Worked on ASAP methodology in all project phases - Business blue print, Realization, Testing, Final preparation and post

live production support, with documentation.

• Financial Accounting expertise in Configuring General Material Ledger Accounting (FI-G/L), New G/L, Accounts Payable

(FI-AP), Accounts Receivable (FI-AR) and Asset Accounting (FI-AA).

• Worked in SAP FSCM – Credit management & Credit control.

• Worked in VIM (Vendor Invoice Management) & OCR

• Worked on different aspects of FI Transactions such as P2P, Inter Company Transactions, Reconciliation Accounts, partial and

Residual Payments, Credit Memos/ Dunning and Clearing Inter-company Vendor/Customer Open Items.

• Controlling experience includes Cost Center Accounting (CO-CCA), Internal Orders (CO-IO), Product Costing (PC), Cost

Element Accounting (CO-CEA), Profitability Analysis (CO-PA), and Profit Center Accounting (CO-PCA).

• Experience in configuration of Automatic Payment Run, Banks Accounting, Foreign Currency Valuation and Electronic Bank

Statement (EBS), Lockbox configuration, Lockbox Processing.

• Experience in FM and Data Mapping

• Experience in mergers and acquisitions

• Worked on handling conversion from GL to New GL right from preparing of blue print for new GL to the customization of

document splitting, allocation and planning.

• Expert in data migration system from legacy to SAP R/3 using Legacy System Migration Workbench (LSMW), ECATT, EDI,

IDOC and SeeBurger tools. Expert in preparation of reports using Report writer/Report Painter.

• Configured Automatic payment program for outgoing/incoming invoices, dunning, validation & substitution, lockbox file

format, lockbox processing, EBS processing including bank accounting, Cash concentration and Liquidity forecast.

• Strong communication (both written and verbal) skills, inter-personal, mentoring, as well as strong attention to detail, ability to

conduct one-on-one training to teammates and business users.

• Experience in different testing phases like Application Testing, Integration testing and User Acceptance testing.

• Excellent communication skills, leadership qualities, systematic approach and ability to work effectively in a fast paced

environment. Strong organizational and time management skills.

• Motivate team members and others in process development and utilization. Ability to work in a high-stress environment.

TECHINCAL SKILLS

ERP SYSYTEM: SAP ECC 5.0 and 6.0, SAP R/3 4.x

OPERATING SYSYTEM: Windows 95/98/2000, XP, Vista & Windows 7

APPLICATION SKILLS: Oracle 12i, GetPaid,, JD Edward, D-Base, COBAL, AS400

AREAS OF EXPERTISE

Organization Structure Setup, Taxes and Schedule Manager.

FI-GL -- GL Master, posting, account balances, reporting, closing activities.

FI-AP -- Vendor Master, Automatic Payment Program, Check Management, Intercompany clearing.

FI-AA -- Asset Master, Chart of Depreciation, Integration with GL, Valuation of assets, postings and reporting.

FI-AR -- Customer Master, Credit Management, Risk Management, Dunning, FI-SD Integration.

FI-BL -- Bank Master, House Banks.

FSCM – Dispute management, Credit management

Cash Management -- Electronic Bank Statement and Lock Box.

CO-OM –

• Cost Element Accounting -- Master Data, Cost Element Group, Cost element category, Reconciliation Ledger.

1 P a g e

• Cost Center Accounting -- Cost Center Master, Standard Hierarchy, SKF, Activity Types, Planning, Postings, Allocations,

Reporting, closing activities.

• Internal Orders- Master Data, Order Types, Funds Commitments, Postings, Settlements, closing activities.

CO-PA -- Structure, Characteristics, Value Fields, Allocations, Value Flows, Planning, Postings, Summarizations.

Reports -- Report Painter, Report Writer and Drill-down reporting.

EC-PCA -- Master Data, Planning, Postings, closing activities.

EDUCATION

• Bachelors in Commerce (with accounting major)

• Diploma Information Software Management from Apple Education

• Professional Business D & B Credit Report Specialist

PROFESSIONAL EXPERIENCE

Culligan International - Chicago IL August 2011 – Present

FICO CONSULTANT LEAD

Client Description: Network is a distribution partner to over 75 independent distributors with operations in over 38 countries. They

have over 650 distribution locations worldwide. Network and its member companies serve over 1 million customer locations annually

with over $ 3 billion in annual sales worldwide.

Responsibilities:

• Lead position to preparing required documents user training providing the design alternatives, created prototypes of the business

individuals of the business process in SAP.

• Configured GL, AP, AR, TR and Bank modules in the SAP system.

• Managing configured and Customized FI sub-modules Accounts Receivable and Accounts Payable.

• Worked on integration between MM and FI. Configured automatic account assignments for GR/IR clearing accounts. Worked on

P2P process including Logistics Invoice Verification.

• Designed and Configured the Vendor Master Data, Vendor Group, Vendor Field Status, Vendor and Customer Master Data

• Defined and customized business rules for sales taxes including jurisdiction codes, tax procedures for US and Canada, tax

condition types, and account assignment.

• Worked on Data Mapping

• Worked with the SD consultant to correct configuration related to customer material royalty accrual, expense, verification and

payment

• Implement the correct process for invoice entry. Included usage of subsequent invoice pricing for price adjustment

and teaching the payables group how to investigate and understand postings made against a purchase order

• Created forms to be used by purchasing to request vendor account adjustments along with GR/IR account

adjustments

• Taught the client how to process down payments correctly and implemented new configuration that allows the

down payment to be tied directly to the Purchase Order and the PO line item

• Advance knowledge in VIM & OCR

• Set up & creating queries in ALV format for vendor number, name, invoice number

• extracting data via Optical Character Recognition (OCR) and transforming invoice metadata at both header and

line-item detail

• Entered all the Revenue information that was being kept on a spreadsheet for 2 years.

• Made sure all the owners were set up.

• Journal Entries

• Account Reconciliations

2 P a g e

• Royalty Reports

• Leveraging Excel spreadsheet functions such as VLOOKUP, HLOOKUP, IF CONDITION, IF AND CONDITION and

CONCATENATE to streamline data analysis required to perform various activities in SAP and to create excel based dash boards.

• Worked with Production Support on tasks like Validation and Substitution.

• Clearing Inter-Company Vendor/Customer open items, Manually Processing Incoming Payments, Reconciliation Accounts in the

GL and Create functional specifications for Custom Interfaces.

• Configured One-time Vendors/Customers with Separate Screen Layouts. Customer credit control areas and pre-defined credit

limits for customers, maintained Risk categories and credit monitoring groups, discount overviews.

• Created Number ranges, posting periods for G/L accounts, defined G/L account groups, created chart of accounts, participated in

modifying and uploading G/L accounts.

• Product Costing – Estimation of product costs in integration with PP and MM modules, WIP calculation and variance settlement.

• Documented End User Manuals and Training Material.

• Client requirement of external request for purchasing documents

• Scanning Paper invoices into ERP & set up invoices via emails & fax

• Notification of Supplier Master Data as well as Customer Master Data changes

Leica Microsystems Inc. - Chicago, IL June 2010 – August 2011

LEAD SAP FICO CONSULTANT

ENVIRONMENT ECC 6.0

Client Description: Leica Microsystems is a leading manufacturing company for Microscope, Microtone & Lab testing Device

Company. Company is base in Germany. This is US corporate office. Serving the needs of the They supply and extend medical facility,

Government offices such as treasury department. Educational center also need for lab testing. Universities & all research &

development facility.

Responsibilities:

• Made the configuration changes and implemented various SAP Notes and corrections required as per the upgrade to ECC 6.0.

• Master data set up like vendor master data, Customer master

• Worked on integration between MM and FI. Configured automatic account assignments for GR/IR clearing accounts. Worked on

P2P process including Logistics Invoice Verification

• Dunning and Account Receivable such ash Cash Application, Lockbox, EBS and EFT

• Configuration of Automatic Account determination for Logistics and troubleshoot problems in the P2P process.

• Made changes to New General Ledger, Accounts Receivable, Accounts Payable, Internal Order and Project Systems tables and

fields affected through upgrade

• Implement the correct process for invoice entry. Included usage of subsequent invoice pricing for price adjustment

and teaching the payables group how to investigate and understand postings made against a purchase order

• Implement a new process for invoice block removal. This required bringing the purchasing, payables and receiving

groups together and promoting an environment of cooperation between the groups

• Worked with the Capital team to assist in creating an integrated approach to the purchase of assets – which included

special payment terms and invoicing process

• Taught the client how to process down payments correctly and implemented new configuration that allows the

down payment to be tied directly to the Purchase Order and the PO line item

• Resolved various integration issues between Finance and HR/Payroll module.

• Configuration of system integration from global perspective. FI global settings, configured company code, 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.

• Vendor and Customer Account Groups, Field selection, Vendor and Customer Master data, Automatic Payment run for Vendors/

Customers, Payment Methods, Payment terms, Bank determination, Payment medium workbench for ACH and Wire transfer.

• Executed test scripts for various business processes related to New General Ledger, Accounts Receivable, Accounts Payable,

Controlling, Internal Orders, Project Systems, Funds Management and Grants Management

• Processed Revenue for all the Onshore Properties.

3 P a g e

• Setting for invoice monitor and define the conditions in which an exception

• Advance knowledge automatic invoices data entry with OCR

• Entered all Cash Receipts.

• Monthly Account Reconciliation's Gas-Balancing, Journal Entries.

• Made sure all the end of the month reports were accurate.

• Answered the Royalty Hotline.

• Prepared Variance Analyses

• Configuration of Billing master data, various other billing & invoicing configurations

• Lead merger & acquisitions international

• Configured Taxes, foreign exchange and intercompany processes

• Configured Profit Center Accounting (PCA), Profitability Analysis (COPA) and Internal Orders (IO).

• Experience in solving the production issues in Automatic Payment Program (APP), Account Assignment, and interest calculation

on open items, foreign currency valuation, regrouping of line items, check management and void reason codes.

• Took part of QA Testing mythology Unit Testing, Regression, configuration & UAT.

• Harmonization cap with different stages.

• Updating Pay process bank procure to Pay Process

• House Bank notification & Lockbox updating for Business to Business

• Multiple Entity processing for Pay system & costing center

• Actively participate throughout all phases of the SDLC ( Software Development Life Cycle)

Baxter International - Chicago, IL AUG 2009 –MAY 2010

FICO CONSULTANT

Client Description: Baxter International provides medical devices, state of the art medical equipment, accessories and hospital

supplies. Also major healthcare products manufacture and lifesaving drugs.

Responsibilities:

• Configured chart of accounts, account groups, field status groups, and posting keys, assigned these variants to company codes,

created GL Master records, reconciliation accounts for sub-ledgers, document types, number ranges, invoices and payments,

tolerance groups, automatic account assignments, GL display (line item layouts, special fields, sort variants, totals variants) and

financial statement version

• Configured areas of AP, House Banks and Automatic Payment program (APP). Involved in optimizing bank details for wire

payments, check lots, void reason codes and clearing inter-company vendor/customer open items.

• Configured customer account groups, tolerance groups, performed credit management, account assignments, defined various

payment terms as per the client specific requirements for Accounts Receivables.

• Identified one-time Vendors and Customers and defined a separate screen layout for them according to the requirement of the

client.

• Made necessary settings for the account assignment model for Recurring and Periodic entries, Bank master data, and House

Banks for the payment program.

• Assigned new scenarios to the leading ledger like Cost center update, Preparations for Consolidation, Profit Center Update and

Segmentation.

• Created integrated asset acquisition and defined account assignment type for Asset Account, Account Assignment Objects for the

Depreciation Areas.

• Set up facilities, well completions and equipment in SAP PRA.

• Prepare monthly production reports to MMS (OGORs).

• Check volumes and well tests for accuracy and correct if necessary.

4 P a g e

• Prepare monthly Severance Tax

• Made settings for the Dunning procedure and configured the dunning procedure

Configured the system to deduct a cash discount for payment of fixed asset invoice automatically and in real time, to the

corresponding asset.

• Configured setting for revaluation of fixed assets, normal depreciation run and posting of asset acquisition.

• Configured Cost center accounting (CCA), Profit center Accounting (PCA), Internal Orders (IO), and Profitability Analysis (PA).

• Tested report generation using reporting tools Report Painter and report writer and performed end user training and documented

training materials for the users.

College Of American Pathology - Chicago, IL MARCH 2008- JULY 2009

FICO CONSULTANT

Client Description: College Of American Pathology is a global specialty chemical company with 2,900+ employees in over 50

locations in more than 30 countries delivering innovative and engineered programs for upstream, midstream, and downstream oil and

gas markets. Their integrated offering mixes sustainable chemistry, technology, and service to enhance your world.

Responsibilities:

• Interacted with Client business users for requirements gathering and analysis.

• Interacted with the business Analysts and end users to get the user requirements and Business process using ASAP methodology.

• Preparing required documents user training providing the design alternatives, created prototypes of the business individuals of the

business process in SAP.

• Configured and Customized FI sub-modules Accounts Receivable and Accounts Payable.

• Interacted with Client to Update and Group Customer and Vendor Master Data to define Credit Control Areas and Dunning Areas.

• Designed and Configured the Vendor Master Data, Vendor Group, Vendor Field Status,

• Vendor and Customer Master Data and Risk Categories.

• Redefined and Configured Payment Methods, Payments Terms, House Bank, Bank Accounts for AP, AR - Dunning process,

Lockbox, Interest calculation, and Credit Management.

• Clearing Inter-Company Vendor/Customer open items, Manually Processing Incoming Payments, Running/Editing Dunning

proposals, Reconciliation Accounts in the GL and Create functional specifications for Custom Interfaces.

• Configured Outgoing Payments, Open Item Clearing in Accounts Payable, and Cost Center Accounting Master data, Planning and

Cost allocations in Cost Center Accounting.

• Configured the Automatic Payment Program for AP including Partial Payment Configuration, Check Management and Check

Printing.

• Configured One-time Vendors/Customers with Separate Screen Layouts.

Customer credit control areas and pre-defined credit limits for customers, maintained Risk categories and credit monitoring

groups, discount overviews.

• Documented End User Manuals and Training Material.

McKesson Corporation – Dallas, TX APRIL 2007- FEB 2008

FICO CONSULTANT

FSCM DISPUTE & CREDIT MANAGEMENT

5 P a g e

ENVIRONMENT ECC 5.0

Client Description: McKesson Corporation is leading healthcare supply Chain Company in USA. McKesson provide healthcare

related software, medical supplies and technical support for healthcare software.

Responsibilities:

• Studied the business process and user requirements.

• Configured G/L Master records, document number ranges, posting period variants, reversal of documents, opening and closing of

posting periods, field status variants, document types, posting keys.

• Configured Vendor and Customer Master Records, tolerance limits for over payments and under payments, Payment terms, and

Payment methods.

• Performed Month end closing

• Maintenance of GR/IR accounts.

• Worked on SAP credit management functions & configured application components.

• Activated the FSCM Functions business functions

• Increased flexibility for creating dispute cases

• Strong knowledge on credit management & credit control area

• Maintenance of A/R & A/P functions

• Updated functional specifications to develop business requirements involving various FICO SAP enhancements

• Defined chart of accounts in accordance with the requirements.

• Configured Posting Periods, new tolerance groups, account groups and field status variants for new company codes within the

company.

• Configured Recurring Entries, hold & park and sample documents, training end users. (AP) Creation of one time vendors, new

payment terms on clients request, discounts, interests calculation and materials creation.

• Updating functional specifications with respect to client requirements CreationofChecklots.

• Automatic Payment Program, Dunning notices.

• Configured withholding taxes, defined WHT codes, WHT groups, Tax structures and percentages (differentperiods)

• Testing and executing change management tasks in systems projects

• Migration of AS400 to SAP support for throughout the System Development Tasks

• Modification data testing & user data testing

• Serve as a focal point for implementation and roll-out support to users

Walgreen JAN 2006- APRIL 2007

Lead Account Receivable

Worked as team lead at Walgreen for Account receivable department. Worked under PARS system (Pharmacy Account

Receivable System). Supporting team with accounting issues with customers accounts.

6 P a g e

PACTIV CORPORATION FEB 2002- JAN 2006

Sr. Accountant

Worked d as Sr. Accountant at Pactiv Corporation managing their national accounts in account receivable & risk

management. General Ledger entries & supporting Sales Tax.

Allegiance Healthcare DEC 1999- FEB 2002

Accounting supervisor

7 P a g e



Contact this candidate