Lead Fi/co Consultant Resume
NJ
SUMMARY
- SAP FICO consultant with ten plus years of experience in SAP applications with emphasis on FICO modules and extensive experience in Accounting and Finance domains in dynamic entrepreneurial environments.
- Three Full Life Cycle implementations experience using ASAP methodology.
- Proficient in business blue print documentation, configuring and understanding of business processes relating to SAP Finance, Controlling and integration with SD and MM modules.
- Proficient in AS - IS study, GAP Analysis, TO-BE process, trouble shooting, Production support and End user training.
- Expertise in Financial Accounting (FI)including New General Ledger(GL), Accounts Payable(AP), Accounts Receivable(AR), Asset Accounting (AA), Cash and Bank Accounting, controlling (CO), Cost Center Accounting(CCA), Profitability analysis (COPA) and Internal Orders(IO).
- Proficient in External Reporting and preparation of Financial Statements with good understanding of GAAP, IFRS and Sarbanes Oxley Act (SOX).
- Conducted training sessions, provided end user training and prepared training documents.
- Adept in various financial processes including Auditing, Assurance, Accounting processes, Financial statements, Fund Flow Management, Reporting, Consolidation and analysis, Budgeting and Forecasting.
- Demonstrated ability to work both in independent and team-oriented environments with well-developed organizational skills, excellent communication and interpersonal skills.
- Ability to take on challenges and strong determination and can run extra mile to meet deadlines.
TECHNICAL SKILLS
Finance: General Ledger(GL), Accounts Payable(A/P), Accounts Receivable(A/R), Asset Accounting(AA), Cash and Bank Accounting.
Controlling: Cost Element Accounting(CEA), Cost center Accounting(CCA), Profit Center Accounting(PCA), Internal Orders (IO) Profitability Analysis (COPA)
Integration: FI Integration with MM and SD
Skills: Oracle Financials, Quick Books, MS Office, MS Project.
PROFESSIONAL EXPERIENCE
Confidential, NJ
Environment: SAP 6.0
Lead FI/CO Consultant
Responsibilities:
- Provided production support for Business Management for the FI/CO modules in SAP.
- Provided functional specifications for the customized programs for AR and GL.
- Resolved various issues pertaining to A/P(Payment Program) and A/R(deductions) and Assessment cycle.
- Co-ordinated with the team in gathering data for the Banking interface with Deutsche Bank
- Involved in monthly vertex updates.
- Defined Internal Order settings and created different order types based on internal order category with the settlement profiles.
- Worked directly with end users SMEs, conducted various overhead presentations and work around solutions to meet direct specifications.
- Performed User Acceptance Test (UAT) from business side, ensuring that business processes are correctly mapped to the base-lined system specifications.
- Trained users in the areas of G/L, A/R and A/P modules.
Confidential, MD
Environment: SAP ECC 6.0
Lead SAP FI/CO Consultant
Responsibilities:
- Analyzed the existing system for AS-IS study and provided estimates and solutions for TO-BE system.
- Gathered functional requirements through user workshops and analyzed gaps.
- Configured company code, chart of accounts, defined posting keys, maintained field status variants and assign to company code, screen variants for document entry as per business specifications and tested the configuration in various scenarios.
- Configured Document Splitting and Zero Balancing on Documents in New GL
- Customized A/R and A/P account groups.
- Customized Dunning Program and Down Payments in Accounts Receivable.
- Configured Automatic Payment Program and Down payment in Accounts Payable.
- Configured new payment terms for downpayments.
- Defined House Banks, Bank Accounts, Check Lots and Reason Codes
- Configured asset classes, AA - GL integration, chart of depreciation, group assets, depreciation areas, depreciation key, calculation key, valuation, acquisitions and retirements.
- Configured settings for interest calculation- defined interest calculation type and time dependent terms, frequency of calculation,interest rates and interest posting.
- Configured settings for withholding taxes.
- Expertise in configuring settings for controlling area and worked on cost element accounting creating primary and secondary cost elements.
- Created Primary cost elements through automatic batch run, manually created secondary cost element
- Configured Cost Center hierarchy which includes creation and grouping of cost center, set planner profile and budgeting the expenses.
- Instrumental in CO-PA Profitability Analysis configuration, which included building the operating concern, developing value fields and characteristics, configuring summarization levels for reporting and assessments, cost center assessments to segments and CO-PA reporting
- Configured Internal Orders by maintaining Order Types, screen layouts, order groups, status management, settlement rules, settlement profiles and planning profiles
- Created reports for segmental Reporting according to business requirement.
- Conducted training to Key business users on SAP functionalities in general ledger, account payables, account receivables, overhead management and cost center accounting.
- Lead the team in year-end closing process.
- Tested the system rigorously, covering all the business cases to ensure the integrity of the system.
Confidential, MD
Environment: SAP ECC6.0
SAP FI/CO Consultant
Responsibilities:
- Closely worked in project implementation from ‘Blueprinting’ to ‘Go-Live’.
- Identified actual user requirements through Brainstorming Sessions.
- Identified Gaps in the system, based on user and policy requirements and prioritized the requirements of the users.
- Configured Enterprise Structure and Company codes.
- Configured chart of accounts, account group,New GL and current ledgers being set as leading ledgers and updated rules for other ledgers based on report requirements.
- Enabled Document splitting functionality to create the segmented display of Balance sheet according to Profit centers.
- Configured fiscal year variants with year - dependent periods for yearend closing and posting period variants.
- Configured account groups, field status groups, fiscal year and posting period variant, document types, posting keys, open item management and line item management, balance interest indicators, reference rate interest and assignment for interest values to G/L.
- Configured A/R and A/P account groups, interest calculation types, interest indicators, accounts for item interest calculations, check lots, payment terms, and bank determination for all payment transactions, tolerance groups and credit limits for customers.
- Configured Special G/L Accounts for down payment with down payment indicator.
- Defined settings for the Dunning procedure and configured the dunning procedure.
- Defined Automatic Payment Program for outgoing payments for company codes in A/P.
- Configured Asset Accounting module based on client requirements.
- Configured Chart of Depreciation, depreciation areas, Asset Classes, asset class account determination, calculation keys, depreciation keys, transaction types, acquisitions, and retirement.
- Customized screen layouts for asset master data, asset sub-ledgers and asset depreciation areas.
- Configured settings for VAT taxes -Defining calculation procedure, Tax codes, Tax accounts and activation of tax code in sales account.
- Identified one-time Vendors and Customers and defined a separate screen layout for them according to the requirement of the client. Mass Updated vendor master data via LSMW
- Configured Internal-Orders using order types, maintained settlement rules, internal order planning, budget profile and also tolerances for budget cost.
- Configured the Controlling area- Cost Element Accounting, CCA Accounting and CO-PCA
- Created cost element groups, cost element categories like primary cost element group and secondary cost element groups, activity type groups and statistical key figures.
- Configured COPA that includes setting up ofreporting Operating Concern, characteristics and value fields, creating characteristic derivation and derivation rules.
- Assisted in the integration process of FICO with MM and SD
- Created functional specifications for developing various custom reports as per the user requirements.
- Defined the financial statements for month and year end.Actively participated in year-end closing process.
Confidential, NJ
Environment: SAP ECC6.0
SAP FICO Consultant
Responsibilities:
- Gathered and analyzed business requirements.
- Prepared Business requirement Document and Functional design document.
- Analyzed the AS-IS system, did the gap analysis and designed the TO-BE system.
- Configured the complete organizational structure for FI module like creation of company codes, business area, and chart of accounts and GL account groups.
- Defined and assigned document number ranges, field status variants, fiscal year variant, posting periods and tolerance groups.
- Configured and implemented Accounts payable (A/P) defining Vendor account group, number ranges for vendor accountsand vendor down payments.
- Configured and implemented Accounts Receivable defining Customer Tolerance Groups, Customer Down Payments, Customer invoice posting and clearing (open item management),
- Defined and configured Dunning process which included creation of dunning proposals to creating dunning notices, Interest calculation - open items/balance outstanding, correspondence and account statement process and financial statement versions.
- Configured Interest calculation procedure which includes defining Interest calculation type interest rates, time dependent terms and Interest posting on loans raised.
- Configured Translation ratios for currency translation and entered exchange rates for foreign currency postings.
- Created Bank Master data, House banks, G/L accounts for each bank account and Reconciliation accounts for vendors, customers and assets.
- Defined and maintained versions for controlling area.
- Configured and Customized CO - General Controlling, Cost Element Accounting, and cost center Accounting.
- Configured Cost element accounting with primary and secondary cost elements, and maintained cost element groups
- In Cost Centre Accounting (CO-CCA), created the cost center groups, cost center hierarchy and attached the work centers to cost centers.
Confidential, OH
Environment: SAP ECC5.0
SAP FICO Consultant
Responsibilities:
- Designed Functional Specifications and developed process flow of the system to convert existing system into new system including defining the roadmap.
- Configured settings for Company Code, Currency, Posting Period Variant, Assigned Document Ranges, and Defined Tolerance Groups for Employees.
- Configured and customized General Ledger accounting - Creation of G/L accounts, automatic account assignments and financial statement version.
- Configured and Customized FI-AR and FI-AP modules including Account Groups, Number Ranges, Tolerance Groups, Account Determination, and Default Account Assignments.
- Configured Automatic Payment Program for Outgoing Payments in A/P.
- Created asset classes, asset groups and maintained sub-assets.
- Defined Chart of Depreciation, Depreciation areas, Depreciation keys for assigning calculation method and depreciation schedule.
- Customized screen layouts for asset master data, asset sub ledgers and asset depreciation areas.
- Tested different asset transactions like posting depreciations, reverse asset transaction, disposition and assisted in asset retirements.
- Trained key business users and coordinated with various teams and ensured that project deadlines are met.
Confidential, CT
Environment: SAP R/3 4.7 to ECC 5.0
SAP FICO Consultant
Responsibilities:
- Involved in the new functionality with Upgrade from 4.7 to 5.0 from testing phase to go-live and provided requirements for the planned enhancements in the system.
- Studied the changes in the standard SAP system for the new version and prepared change configuration scripts.
- Configured the ledgers, set up integration with Controlling, and made the general setting for the fiscal year, the posting periods and the currencies.
- Analyzed the AS-IS, performed gap analysis and designed the TO-BE system.
- Worked with technical resources to design Interfaces and data Conversion Programs and developed functional specifications for information exchange in-between existing SAP legacy systems and SAP.
- Performed table comparisons for major General Ledger (G/L), Accounts Payable (A/P), Accounts Receivable (A/R), customizing tables to list the differences between 4.7 R/3 and ECC 5.0 systems.
- Worked on the configuration changes for the business processes related to Finance and Controlling required as per the upgrade to ECC 5.0.
- Configured validation and substitution rules according to new ECC 5.0 system.
- Trained the end users and prepared training documents on using new ECC 5.0 system.
- 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.
- Configured and Customized the basic settings, maintained profit center hierarchy, assignments, CO-Objects to Profit Centers, distribution and assessment of costs, Planning and development of Reports
Confidential, Atlanta
Environment: SAP R/3 4.7
SAP FICO Consultant
Responsibilities:
- Gathered high level financial information requirements and translated these requirements into an appropriate SAP financial hierarchy (enterprise model).
- Configured and customized the Company Code, Fiscal year Variant, Chart of Accounts, Account Groups, Field status variant and assignments etc.
- Configured the settings in GL area, such as creating G/L accounts, cross-company code transactions, and open item clearing. Configured GL transactions for business processes such as fast- entry screens, posting, parking, reversals and month end closings.
- Defined tolerance groups, tolerances for employees, customers and vendors.
- Created vendor/customer groups, assigned Number ranges, Tolerance groups and Document types.
- Defined Document types and created Sample Documents and Account Assignment Model for recurring entries.
- Configured house banks, bank accounts and posting rules for automatic assignment and dunning notices.
- Defined Reconciliation accounts for A/P and A/R.
- Created Bank Master data, House Banks, G/L accounts for each bank.
- Provided user support and trained users in the areas of G/L, A/P and A/R.
Confidential
Sr. Controller
Responsibilities:
- Prepared complex financial statements, Management Reports and analyzed financial data for senior management decision-making.
- Centralized accounts payable, accounts receivable, general ledger and other accounting functions reducing functional headcount to over 25% and improving department performance.
- Managed company-wide Monthly and Annual closing processes and financial consolidation.
- Performed Budget Variance/Impact analysis and Balance sheet reconciliations for corporate headquarters.
- Provided Manifesto to implement US GAAP pronouncements and IFRS standards.
- Closely worked with SOX team, developed audit plans, documented and evaluated accounting operations.
- Point of contact for all inquiries, internal audit and external audit issues.
- Developed and implemented policies and procedures in conjunction with other functional departments such as IT, purchasing and operations.
- Closely worked with implementation team for company-wide deployment of SAP
- Trained users on ERP SAP.
