We provide IT Staff Augmentation Services!

Sr. Sap Fi/co Functional Analyst Resume

2.00/5 (Submit Your Rating)

Ashburn, VA

SUMMARY

  • Experienced SAP Financial Accounting & Controlling consultant with 9+ years of experience in SAP.
  • Industries worked include Telecommunication, Aerospace, Defense Industry, Energy, Manufacturer, Food and Electronics.
  • Four full cycles of SAP R/3 implementation with ASAP Methodology and up - grade project experiences in SAP FI/CO module.
  • Specialized in SAP FI-Account Payable, FI-Account Receivable, FI-GL, FI-AA
  • Experienced in SAP CO-PS (Project Systems)
  • In-depth understanding of OpenText VIM, ASAP methodology, system design and development and gathering user requirements
  • Automation of Invoice Verification with Good Receipts/Service Entries through Workflow process using MIGO, ML81N, MIRA, MIRO
  • Extensively worked on SAP Ariba, Vendor eForm and SAP MDG (Master Data Governance) during implementation support testing issues and golive support.
  • Designed, test and support Outbound, Inbound interfaces with Banks (wire transfer and encashment file), Lockbox, EBS (Electronic Bank Statement) Middleware and Third party systems.
  • Specialized in IDOCs.
  • Worked on SAP HANA in creating universe for reporting of actual cost reporting, cash flow forecast, spend and budgeting by Projects, WBS and Cost center, account assignments.
  • Conceptual knowledge of SAP Simple Finance.
  • Used ABAP debugger to identify cause of errors in custom reports and create functional specifications for ABAP enhancements and for custom reports.
  • Maintained and closed periods for FI and CO for Month End and Year End procedures.
  • Worked and responsible for all phases of the systems development life cycle that include system design, analysis, configuration, system testing, data conversion, post-implementation support.
  • Customized and configured IRS Tax Reporting for 1099M, 1099S and 1099K. New country tax code for 1042 for IRS Reporting.
  • Involved extensively in evaluating the business process and identifying key risks in conversion and provide solutions.
  • Skilled with GPD solutions and running the reports for pegging and distribution.
  • Project System Reporting using Report Painter and creating custom reports for Cost Centers, Projects, WBS for budgeting, allocating and actuals
  • Parallel ledger for New GL to support reporting requirements.
  • Project and WBS reports for Cost share, Cash Flow, Cash Forecast for Expense, R & D projects and Capital projects.
  • End user training, documentation and delivered training to consultants and business.
  • Experienced in Classic to New GL Migration using Migration Cockpit.
  • Experienced as liaison between business and the IT Team in the last 3 projects.
  • Expertise in Document Splitting and activating New GL (ECC 7.4) in Company Codes.
  • Experience in business process engineering, ASAP methodology, Agile, systems design and development. Outstanding communication and interpersonal skills with problem solving abilities and effectiveness in working independently and as a part of a team.
  • Experience with HP ALM, HP QC tool including creating test cases/plan for the FICO business process. And used SharePoint for updating and tracking projects documents.
  • Intuitive perception of requirements and Client’s interests. Advance skilled in MS WORD, EXCEL (Macros also), MS Access, MS PowerPoint, MS Project, MS Outlook.

PROFESSIONAL EXPERIENCE

Sr. SAP FI/CO Functional Analyst

Confidential, Ashburn, VA

Responsibilities:

  • For nSAP project create new House Bank and payment method, Customer and Vendor group for international customers and vendors. Worked on new RICEF objects for reporting, enhancement, interfaces and forms. Create new check lots and maintain variants for F110 all payment programs including printing out check and creating IDocs. Maintain partner profile, creating niF and partner function for EDI process including EDI 810, EDI 820. Worked with middleware Seeburger system for X12 transfer. Production support for international company code with international currencies. Month End and Year End closing support. Maintain GR/IR write off program with custom field added to SAP standard MR11 to write off to different account assignment then on GR/IR. Support and working on defects with international wire transfers by maintaining Vendors Banking information and IBAN values.
  • Worked on a new massive project vSAP in which migration of PeopleSoft and others ERP system including old SAP system dSAP into one SAP system. Part of the team in requirement gathering, identifying RICEF objects, creating Functional Specs, writing configuration documents, creating test scripts and test data for ABAP programmers. End to End testing of Functional User Testing. Creating and maintaining Data and scenarios in User Acceptance Testing environment and support the business in UAT phase. Use SAP Solution Manager and SharePoint for documentation and used HPQC for creating and running test scripts, update test scripts with FUT and UAT results. Use HPQC for tracking defects in UAT and in Production. Used AORS and CMIS tool to track production tickets.
  • Involved in JPMorgan Order to Pay implementation for Procure to Pay process. Setup new Vendor Group, House bank, payment method, EDI partners.
  • Interfaces with Banks for Positive Pay and EBS (Electronic Bank Statement). Created custom SAP reports to meet the statutory requirements. Created settings for automating Intercompany Check encashment, Bank Reconciliation and Bank Interface.
  • When JPMorgan was retiring involved in SAP ARIBA project for Procure to Process using cXML files and fixed width files in InvoicePro, Discount Pro and Information Tool Kit (ITK) and use IDOCs for early payment discounts.
  • Involved in Citibank Supplier Chain Financing project which include sending EDI 820 Payment Order to middleware Seeburger system and receiving EDI 824 for Acknowledgment. Using Standard SAP paying Citibank through Alternative Payee and legacy invoices directly to supplier through Alternative Payee on the document.
  • In nSAP worked on eForm Vendor maintenance and GR/IR process through workflow. Automation of Invoice Verification with Good Receipts/Service Entries in the Workflow process using MIGO, ML81N, MIRA, MIRO
  • In vSAP implemented SAP Master Data Governance (MDG) for Check request, Vendor Maintenance, Workflow for GR/IR and Travel expenses.
  • As per business needs customize the 1099 withholding process and created a complete automated process to secure tax information of vendors and send the 1099 records file to IRS through their FIRE system with the decrypted values. Customize 1099M, 1099S and 1099K using custom tables, configuring tax codes for 1099M, 1099S and 1099K.Creating custom reports, fix length files to IRS and print 1099 forms for vendors.
  • For 1042 Withholding tax for foreign vendor also custom a program for monthly and annually reporting to IRS including forms to Vendors.
  • Worked with HANA and BW team as primary functional resource for creating New Spend Analytics Reporting for AP, PS, GL and Supply Chain modules including cash flow, spend by GL, Cost Centers and WBS with their actual cost and account assignment.

Sr. SAP FI/CO/PS Functional Analyst

Confidential, Princeton, NJ

Responsibilities:

  • Configured asset classes and charts of depreciation in fixed assets, configured asset accounting structure/valuating fixed assets, designed and configured asset management to carry out business transactions like acquisitions, retirements, transfers, write-offs and post capitalization, integrated asset accounting (FI-AA), structured and valuated fixed assets, created asset values, acquisitions entry and alterations during use, asset retirement. Set up Asset Class for depreciation range with Asset life of 12 years. Run Asset depreciation Reports.
  • Defined Parallel ledger for new GL to support reporting requirements per US GAAP and IFRS for different entities. Used BW to extract reports and trained users on the BEx Analyzer. Created non leading Parallel ledgers for UK entity to meet UK IFRS reporting requirement.
  • Proposed, design and setup a Mass Project of 34 million dollars’ worth in SAP, Capitalizing multiple assets in different categories. Simplify the business need by managing plan and budget their expense cost and capitalized cost. The other aspect of that project was a huge part of the expense and capitalized cost was reimbursed over the period of time. At month end Capital WBS settles to AUC and Expense WBS settles to cost centers. Reports from PS with Actuals, Plan and variances.
  • Worked on Customer Master Records, Risk Categories, on Hold status, Credit Limits, Credit Management, Lockbox, Client Specific Payment Terms, Dunning and Payment Methods and in testing creating invoice from Sales order and check the system thorough credit blocks, new customer block, ITAR blocks and releasing invoice for shipments in Advance Order Process and Billing.
  • Configured LockBox settings, helped users with Customer Debit/Credit Memo Processing, Revenue recognition and Bank statement reconciliation.
  • In PS Module created the Project structure in Productions for all the government projects with Cost Type, Fixed Price, Fixed Fee and with Milestone billings. And also setup projects for R & D projects in SAP. Create settlement rules and costing sheet for them for the month end processes. Also calculate the overheads and Gross Margin on them. With the use of GPD (Grouping Pegging and Distribution) created networks and activities and assigned parts for the projects and ran pegging and distribution reports. Inventory valuation, mass price update.
  • Configured Accounts Payable modules including Creation of Vendor Master Records, account groups, tolerance groups, account determination, invoice validation and payment advices.
  • Automatic payment program for outgoing payments which included payment methods, payments to foreign vendors, house banks, bank accounts and ranking order of bank accounts, check management. Worked on integration with different interfaces using iDocs related to invoicing, payments (checks, wire transfer and foreign currency transfer) and discounts. Create Test Scripts and scenarios, part of the team during system integrating test (SIT) and User acceptance test (UAT). Running Queries and test daily and monthly report for super users from Financial Data. Reports includes CRR (Cash Requirement Report), CVR (Check Volume report), and COE (Center of Excellence) for the third party system related to payments and discounts.
  • Creating SOPs and training documents and maintained on SharePoint for business and end user. Provide SAP training to business and end users and provide support after the GO LIVE.
  • Maintained Costing rates and Billing rates for Engineering, manufacturing, G&A, Abated G&A, Fringe rates calculating the overhead rates and Gross Margins.
  • Profit Center settings, hierarchy, account assignment objects, product costing, value fields, planning and reporting, integrated cost object controlling. For planned budget using various costing methods, cost split, cost and valuation variants in product cost planning releasing production orders, Rework Orders, Warranties, confirming operations, final costing, price transfer- update, confirmation-settlement and period-end closing, calculated overheads, work in process, variances and settlement. cost component layout with multiple cost component views, additive cost and special procurements, design and configuration of profitability analysis.
  • In Product costing; configured the settings for new plants that used process manufacturing and enabled calculation of standard costs for valuation of manufactured products. Facilitated the Cost center planning and budgeting process to calculate activity prices of various operations. Execute costing run in Ck40n and resolve the issues before marking and release. Checking BOMs, routers and MM material master during the costing run.
  • Mapped the Cost component layout for calculation of direct and indirect costs for product costing purposes and created overhead cost sheet with relevant overhead groups to absorb overheads. Maintain the activity types, planning the activity types in cost centers and use a third party system “Auto Time” for labor hours.

Sr. SAP FI/CO Functional Analyst

Confidential, Charlotte, NC

Responsibilities:

  • Set up of document types and posting keys for business transactions.
  • Regrouped the GL accounts into various account groups.
  • Conducted training workshops for new users.
  • Created reconciliation accounts for account receivables and accounts payables.
  • Worked on Legacy data transfer to SAP using LSMW, CATTS, and Third party tools.
  • Developed a custom AR aging report, created Invoice Layout and processed invoices.
  • Defined and executed test scripts, test scenarios, unit test plans, functional test plans, integration test plans, and regression test plans.
  • Used ARIS tool for Business Process Mapping and Workflow design.
  • ARIS integration with Solution Manager to store Business Process Design Documents.
  • Configured settings for New GL including document splitting and segment reporting.
  • Created Balance Sheet and Profit & Loss Statements.
  • Supported SAP FI-AR, FI-AP, SD, MM end-users on various areas such as payment terms, customer contracts, process payment runs, manually processing incoming payments, running/editing dunning proposals, reconciliation accounts in the GL.
  • Defined exchange rates for multiple foreign currencies.
  • Designed and Implemented Revenue account determination for Sales order processing, Debit Memos, Credit Memos and other sales related transactions.

SAP FI/CO Functional Consultant

Confidential, Schenectady, NY

Responsibilities:

  • In Blueprinting phase gather information related to business process and provides resolution for SAP from their legacy system and maintained them on SharePoint. Interact with business and gather information related to their business process and their requirement for SAP.
  • Maintained the email notification for OpenText Vendor Invoice Management and excluded users from Notification Receiver list.
  • VIM OpenText training for users to automate invoice processing. Documented processes for VIM OpenText for scanning (OCR) and processing invoices automatically.
  • Defined workflow task and processing methods for OCR in OpenText VIM. Configured retry count time limit for OCR extraction in OpenText VIM. Assigned Validation group to Archive document type for OCR in OpenText VIM.
  • Mapped SAP HR org chart to OpenText Chart of Authority in OpenText VIM assigned them to default process types in OpenText VIM. Streamline entire accounts payable (AP) process, simplifies creating managing, monitoring, and routing Designed data mapping table to be used during data conversion from legacy interface.
  • Worked on integration with different interfaces related to invoicing, payments (checks, wire transfer and foreign currency transfer) and discounts. Create Test Scripts and scenarios, part of the team during system integrating test (SIT) and User acceptance test (UAT).
  • Interfaces with Banks for Positive Pay and EBS. Configured settings for Realized, Unrealized Gain/Loss and CTA accounts. Created custom SAP reports to meet the statutory requirements.
  • Created settings for automating Intercompany and Intra-company STO. Check encashment, Bank Reconciliation and Bank Interface.
  • Creating SOPs and training documents for business and end user. Provide SAP training to business and end users and provide support after the GO LIVE.
  • Assisted the business in requirement gathering and design for BPC (Business Planning and Consolidation).
  • Configuring settings for company code, defining the posting period variant, opening of posting periods, defining the fiscal year variant, defining the field status groups, assigning document number ranges, defining tolerance groups for employees, assigning the variants to company code. Used migration cockpit during classic to New GL migration.
  • Dispute Management: Defined case types, text IDs, default values for creation of dispute cases, activating process integration for creation of dispute cases using supplier portal.
  • Configured Accounts Payable modules including Creation of Vendor Master Records, account groups, tolerance groups, account determination, invoice validation and payment advices.
  • Automatic payment program for outgoing payments which included payment methods, payments to foreign vendors, house banks, bank accounts and ranking order of bank accounts, check management.
  • Worked on BOMs, Routings and Recipes for Product Costing.

SAP FI/CO Functional Consultant

Confidential, Omaha, NE

Responsibilities:

  • Configuring settings for company code, defining the posting period variant, opening of posting periods, defining the fiscal year variant, defining the field status groups, assigning document number ranges, defining tolerance groups for employees, assigning the variants to company code.
  • Created settings for SPL (Special Purpose Ledger).
  • Worked on gathering T&E requirements and assisted in testing those requirements.
  • Configuring and Customizing New GL with document splitting. Defining the chart of Accounts, Creation of G/L Accounts for each company code, Screen layout rules, automatic account assignments, recurring entries, validations and substitutions.
  • Trained users on New GL functionality after New GL migration.
  • Used ARIS tool for Business Process Mapping and Workflow design.
  • ARIS integration with Solution Manager to store Business Process Design Documents.
  • Configured and Customized Accounts Receivable and Accounts Payable modules including Creation of Vendor Master Records, Customer Master Records, account groups, tolerance groups, account determination, default account assignments and payment advices.
  • Automatic payment program for outgoing payments which included payment methods, house banks, bank accounts and ranking order of bank accounts, check management, and credit risk management.
  • Ensured reporting requirements are met according to US GAAP.
  • In SAP PS (Project Systems) worked on the following tasks,
  • Creating WBS Status Profiles
  • Payment Schedule Profile for Projects
  • Creating Simulation Profiles
  • Maintaining Cost Planning Profile
  • Project Budget Profile
  • Created Settlement structure for settling WBS Elements in SAP-PS Project Systems.
  • Created LSMW for mass update of WBS elements in SAP-PS Project Systems.
  • Define Tolerance Limits (for Budget)
  • Performed Result Analysis and WBS settlement to COPA for PS scenario.
  • Designed Invoice verification workflow to start when an invoice is scanned and placed in folder in transaction OAWD
  • Utilized SAP Migration cockpit during New GL migration.
  • Configured settings for manual and EBS (Electronic bank statement) in Treasury.
  • Assisted users in Bank Reconciliation and reporting.
  • Setup Single interface for connectivity to house banks via SWIFTNet
  • Maintained settings for Inventory valuation during goods receipt, goods issue and scrap.
  • Configured LockBox settings, helped users with Customer Debit/Credit Memo Processing, Auto Cash, Cash Accounting, Revenue recognition and Bank statement reconciliation.
  • Configuring cross-company purchasing organization and logistics invoice verification.
  • Successful integration of the FI with SD and MM modules.
  • Configuring settings for Controlling areas, activating the components/ indicators, assigning the company codes to controlling areas, assigning number ranges.
  • Defining the Operating Concern and maintaining the controlling versions.
  • Cost Elements analysis involving both primary and secondary cost elements, activating the reconciliation ledger, and maintaining accounts for automatic reconciliation posting.

SAP FI/CO Functional Consultant

Confidential, Chicago, IL

Responsibilities:

  • Configured and customized payment programs, House Banks and Payment advices.
  • Maintained Controlling area settings. Created Cost Elements, Cost Element Groups, and Configured Costing Sheet, Configured the reconciliation Ledgers, Parallel ledger, Created Cost Center Standard Hierarchy, configured Activities and statistical Key figures.
  • Maintained Controlling area settings and cost center assessment cycles. Set up planning profile for cost center, activities, statistical key figures and cost element planning.
  • Maintained Costing Based for Profitability Analysis in Operating Concern.
  • Characteristic Derivation and Valuation (in Costing Based CO-PA).Maintained Planning levels, Package, Methods and Parameters .Generated reports using tools like Report Writer, Report Painter and Drill Down reports.
  • Configured Company Codes, GL Accounts, Fiscal Year Variant, Chart of Accounts, Account Groups, Posting Periods, Parallel Currencies, GL account master records and assigned Field Status Groups to the GL accounts.
  • In SAP PS, worked on the following area,
  • Maintaining Planner Groups
  • Defining Procurement Indicators for Material Components
  • Defining Time Profiles
  • Defining Profiles for the Project Planning Board
  • Defining Profiles for Workforce Planning
  • Defining Overall Profiles for Information System
  • Maintaining Network Type
  • Set Up Number Range for Networks and Assign Network Type
  • Set Up Number Range for Standard Networks
  • In Treasury, created settings for Liquidity Analysis and Cash Concentrations.
  • Configured Controlling Area, assigned number ranges to Controlling Area, assigned Company Code to Controlling Area, maintained Cost Center standard hierarchy.
  • Configured New GL including settings to allow Document Splitting based on Profit Center.
  • Interacted with business users to configure Vendor/Customer Groups, set up Vendor/Customer Master Records and assigned Reconciliation Accounts in GL.
  • Defined payment methods, payment terms and tolerances for customer and vendors
  • Identified House Banks and bank accounts, created GL accounts and assigned them to the bank account, defined check number ranges and check lots.

SAP GL/Asset Functional Consultant

Confidential, Hollywood, CA

Responsibilities:

  • Designed asset classes and charts of depreciation in fixed assets, configured asset accounting structure/valuating fixed assets, designed asset management to carry out business transactions like acquisitions, retirements, transfers, write-offs and post capitalization, integrated asset accounting (FI-AA), structured and valuated fixed assets, created asset values, acquisitions entry and alterations during use, asset retirement, CCA-assessments/distribution.
  • Created a special asset class for AUC (Asset Under Construction)
  • Maintained a settlement profile and settled the AUC asset to a Fixed asset for capitalization.
  • Set up Asset Class for depreciation range (ADR) with Asset life of 12 years.
  • Assisted the users in removal of the adjusted current earnings (ACE) depreciation adjustment.
  • Set up the Integration of FI with MM and SD through Automatic Account Assignment
  • Extensively worked in controlling modules including, Cost Element Accounting (CO-CEA), Cost Center Accounting (CO-CCA), Internal Order Accounting (CO-IOA), Profitability Analysis (CO-PA) and Profit Center Accounting (CO-PCA).
  • Used ARIS tool for Business Process Mapping and Workflow design.
  • ARIS integration with Solution Manager to store Business Process Design Documents.
  • Created Training Scripts for the MM, FI and CO modules. Script development included MM Procurement processes; FI-GL Account Maintenance, Journal Processing, General Ledger processing and Financial Statements; and CO-CE creation, assignments and reporting; (CO-CCA) object creation, assignments and Reporting; (CO-IO) and (CO-PC) object creation, assignments and reporting.
  • Detected and resolve configuration errors in FI-AM for asset transfers and for (CO-CCA) and (CO-PC) transaction assignments. Provided project organization and work planning inputs to local level project managers for flow of Training Script development and progress reporting to Management.
  • 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.
  • Integration between different modules - GL, AP, AR, Bank, Treasury, CO (CCA, PCA), SD and MM, SRM, FI document postings, GL recurring entries, accrual deferral documents, worked on month-end and year-end processes (balance sheet and profit & loss statements).
  • Verified the balance of the retained earnings account, AP-customer transactions, house banks, payment program, clearing inter-company vendor/customer open items, AR-customer transactions, credit management, payment terms, process payment runs.
  • Manually processing incoming payments, running/editing dunning proposals, reconciliation accounts in the GL, customized credit control area for credit management in the application components AR and SD, payment processing in AR and automatic account determination, developed AR aging report.
  • Created invoice layout and processed invoices. Worked with the BW/BI Team to identify SAP tables and data while creating new reports.

We'd love your feedback!