We provide IT Staff Augmentation Services!

Sr Sap Fico And Hana Consultant Resume

4.00/5 (Submit Your Rating)

Reston, VA

PROFESSIONAL SUMMARY:

  • SAP Certified Financial Professional
  • 9 years of experience in SAP FI/CO Functional configuration in New General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, FSCM - Treasury-In HouseColloections& Dispute, Credit management, Cash Management, Controlling and COPA
  • Extensive knowledge on all the releases of S4HANA (1503, 1511, 1605 and 1610)
  • Worked on three End -to- End Implementation, Support, Upgradation Projects and Data Migration projects from JD EDWARDS, VISTA to ECC/S4 and ECC to S4 HANA.
  • High expertise in Financial/Controlling modules (G/L, New GL, A/P, A/R, AA,AUC, Functional Area, IO, CO-PA, and working knowledge on BPC reporting, ECCS and BCS consolidation systems.
  • Extensive experience in SAP FI integrations with other modules in particular MM, SD, AM
  • Proficient in using the service management tools HPSM, SNOW, FastHelp, REMEDY and CHARMS.
  • Created functional specifications and worked together with the ABAP developers to develop and modify RICEFW objects.
  • Considerable experience on utlizing Report writer, Report Painter and also worked extensively on LSMW/BDC for the data conversion during the Implementation Projects.
  • Expertise in implementing various interfaces with SAP through IDOCS, RFC and Web services.
  • Experience with HP ALM, eCATT, HP QTP and SAP TAO and IBM rational Functional Tester tools
  • Developed user-training material on all Application Components of IHC, cash management module and inall areas of SAP FICO totrain Business users.
  • Excellent client interaction and communication skills, relationship management skills, proven trouble shooter and Team Leader.
  • Team player with strong ability to explain technical issues to business users

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Sr SAP FICO and HANA consultant

Responsibilities:

  • Involved in Full Life Cycle Implementation of the project; including blue-print preparation, configuration, testing, end-user training and go-live phases.
  • Followed ASAP methodology in implementing the project
  • Involved in all the test phases unit testing, integration testing, User Acceptance Testing (UAT). Provided informative documentation to help the end users.
  • Involved in go-live phase and provided post live support in clearing the tickets.
  • Developed a list of business scenarios and Special functions that need to be tested as a part of the upgrade. Met with business teams in several manufacturing plants to understand their daily activities and develop a comprehensive testing spreadsheet
  • Tested all the standard SAP functionality and Custom SAP functionality of Rexroth. This included business scenarios and a list of special functions.
  • Worked with SAP consultants on staff to implement NEW GL, switch to NEW GL using the New GL cockpit and also coordinate data cleansing and reconciliation with SME’s
  • Worked with several technical teams like Basis and Security while developing special SAP instances - exclusively built for the ECC 6.0 upgrade; and copying the necessary roles for users.
  • Coordinated and completed the IT testing for FICO
  • Tested all the FICO document flow and user exits for all the major logistics processes like Sale from stock, Make to Stock, Make to order, Assemble to order and Engineer to order.
  • Was the IT team member responsible for the completion of business testing for a couple of Manufacturing plants and the corporate headquarters. Held weekly meetings with business and coordinated the testing to make sure all the functionality including the interfaces and SAP Jobs are all tested.
  • Coordinated resolving several authorization issues and ABAP issues related to the Upgrade. Modified the roles by adding several new auth objects in ECC 6.0
  • Migrated from Classic GL to SAP New GL by partnering with SAP America.
  • Involved in Migration of Classic GL to New GL,with Basis and Project Management by establishing a client structure by Filling a SAP Questionnaire, SAP Performing Production system review and Final Test Migration review
  • Identified the New GL scenario - 05 (New GL migration with Doc Splitting and Parallel Ledgers) and activated FAGLFLEXT and FAGLFLEXA
  • Added a custom field Country to the coding block
  • Identified document splitting characteristics - Set up the configuration for document splitting by Profit center, Segment and Country
  • Performed Data cleansing by reviewing Open items and accounts with balances in foreign currencies and performed data cleansing
  • Installed the SAP Migration cockpit in Sandbox and Migration Quality clients and performed test migrations
  • Performed the final migration in Production with support from SAP along with the BASIS team supervision
  • Coordinated with all the involved parties such as SAP ECC, SRM, RSL, SUS Portals, BI, BOBJ etc during migration of SAP ECC to HANA.
  • Worked very closely with the ABAP team, SAP BASIS team during the initial analysis on the migration to HANA to understand all the changes that were performed on the custom programs to resolve the inconsistencies in queries as recommended by SAP
  • Demonstrated advantages of migrating to SAP HANA to key stakeholders - Report time and SAP Future compatibility being the two major areas of SAP
  • Worked closely with Portal teams to establish clean connections with ECC, SRM and BW databases.
  • Coordinated the testing efforts with key business users
  • Made configurations for entire Procure to Pay business process including - creating Purchase Order, Goods Receipt, Invoice Verification and Outgoing Payment.
  • Integrated with Open Text (Vendor Invoice Management - VIM) to automatically scan incoming invoices and process them using a workflow for PO and Non PO invoices
  • Set up VIM to read invoices from emails and automatically process required fields for processing an invoice
  • Added an extra workflow layer for Non PO direct pay requests
  • Created Automatic Payment Program for vendor payments and invoice processing using checks. Configured House banks, Payment Methods, Assigned Payment Method in Vendor Master.
  • Scheduled the payment run as an auto job for users to verify the proposal and then rerun the proposal if needed
  • Set up interfaces with different banks and generated IDOC’s from SAP - which were passed to the SAP Application Layer folder and then transmitted to the bank using SFTP protocols
  • Created Customer Master Data and corresponding reconciliation accounts for automatic posting in GL accounts. Maintained document number ranges for customer invoices and incoming payments.
  • Integrated MM and FI modules for according to movement types and valuation classes.
  • Made configuration for automatic account postings in the transaction code OBYC
  • Worked closely with MM consultants to define the conditions for discounts, Freight and other sur charges and their accounting treatment
  • Created primary and secondary cost elements and cost element groups in Controlling.
  • Created cost center standard hierarchy, cost centers and assigned cost centers to cost elements.
  • Created Activity types and defined Statistical Key figures to transfers costs from one cost center to the other.
  • Configured Assessment and Distribution cycles to settle both the actual and plan costs among different cost objects.

Confidential, Minneapolis MN

Sr SAP FICO and Treasury consultant

Responsibilities:

  • Implemented SAP FICO O2C and P2P solution for SAP implementations of Mexico, Colombia and Argentina
  • Developed an interface with a different Sales system and SAP using Web Methods
  • Developed an E-Invoicing solution for Mexico to get all the AR and AP invoices digitally signed by the government.
  • Developed a custom report for Mexico VAT reporting
  • Worked with SAP LSMW’s and Win Shuttle to perform master data and transactional data migrations for Mexico.
  • Co-Led the project to upgrade the SAP ECC system from EHP4 to EHP7. Worked very closely with the other involved systems such as SRM, RSL, SUS Portals, BI, BOBJ etc.
  • Evaluated the new functionality in the areas of AR - Interest, Integration of AR with Grants Management, New GL closing cockpit
  • Implemented new business functions that proved a lot of benefit for the business
  • Coordinated the upgrade with SAP BASIS and Development teams
  • Coordinated the testing with the IT teams and Key business users.
  • Held regular meetings with all the teams involved to track the issues and coordinate with SAP of all the technical issues, Issues were prevalent in newer systems including SRM, SAP HCM, ESS/MSS portal etc.
  • Developed a new custom solution for dunning and AR interest and penalty charges according to the ordinance issued by the county. Standard SAP solution of AR Interest could not satisfy the requirement, so implemented several BADI’s to achieve the desired results
  • Implemented the AR penalty and Interest, Also created a Custom cash application process. Customized standard SAP interest functionality to compute interest and one time penalty
  • Extended the custom AR Late charges and Cash application process to new agencies
  • Extensively used the AR-Lockbox functionality for cash application needs. Custom logic was implemented to create a payment distribution logic to apply the payments to Interest, Penalty and then to the Principal amount.
  • Created a BI aging report by Profit Center, Geography
  • Created a new product type for Money market funds, copied standard SAP 52A to achieve this
  • Created a new product type for Corporate Note, copied standard SAP bonds (Securities) to achieve this
  • Designed all the accounting relevant transactions like TBB1, TPM44, TPM18, TPM1, FWZE and TPM40 etc.
  • Created a program to distribute the interest earned to several funds based on some predefined interest distribution rules
  • Created several RICEF reports for Treasury accruals, Investment holdings, Weighted average Rate of return at a portfolio level
  • Designed custom reports by building custom tables by product types and Update types to ensure functionality needed for the business (Example: Accrued Interest report by Fiscal year, Revenue projection report, Investment holdings report etc)
  • Implemented several new payment methods for different countries and company codes
  • Set up interfaces between different banks such as Bank of America, JPM and Suntrust with SAP
  • Streamlined the Procurement card process by establishing an interface with JP Morgan
  • Set up integration points between SRM and ECC for links between shopping carts to PO, GR and IR in ECC
  • Supported an initiative “Payment Transparency” Web based payment feed fo to have a look at the payments made. Worked with creating extracts to SAP BI for all the
  • Set up prior day and current day loads of bank statements into SAP - Used formats BAI and Swift MT940
  • Set up posting rules and also enhanced the standard algorithms for customer cash application
  • Set up search strings for specific bank charges as well as Credit card transactions
  • Processed current day banks statements and created memo records for cash manager analysis to get Cash position at 8 AM and 10 AM.
  • Created a new asset class for Leased capital assets
  • Developed several custom reports to view the balance of assets by WBS elements / Projects
  • Created custom transaction types to Non Budget relevant acquisitions and donated assets
  • Worked on reconcilliation issues for yearend closing
  • Worked with SAP using OSS incidents to resolve inconsistencies between tables ANLA and ANLBZA for depreciation terms
  • Supported month end settlements of WBS elements and Internal orders for capital and expense projects / orders.
  • Reconciled the balances of CO (WBS elements and IO) with the CIP GL accounts and resolved any differences from time to time.
  • Imported all FI tables to a SQL based data warehouse by using Data Services as the ETL. Worked very closely with the Data Services and SQL consultants to construct the cubes and develop excel based reports in SSRS
  • Used SQL based data warehouse system only for FI reports. These were developed to utilize existing SQL resources and also considering the expertise of users in SQL to be able to produce FI statements
  • Worked with SQL Architects to design the data schema in Erwin and develop cubes in Data Services - SSIS
  • SAP BW was used for all other reporting. Worked with SAP BI team to design the data schema and cubes for P2P and O2C reports
  • Consolidations were performed in Hyperion. Developed interfaces with Hyperion to load all the financial data for consolidations between all the Fairfax county agencies and Fairfax Schools to generate Month end statements.
  • Yearend reporting and Tax / Audit adjustments were performed based on the data from Hyperion by performing on top adjustment entries in Periods 13-16 in SA

Confidential, Marysville, OH

SAP FICO Consultant

Responsibilities:

  • Configured customer groups, assigned number ranges for master data and documents, created payments terms, created reason codes and accounts for exchange rate differences, rounding differences,
  • Complete bank configuration for incoming payment with bank transactions for multi house bank scenario.
  • Configured Vendor groups, assigned number ranges for vendor master data and documents
  • Configured automatic payment programs and maintained additional payment methods.
  • Use of special GL indicator transactions including down payment for AR and AP,
  • Setup fixed asset structure - Asset class, Depreciation areas, Chart of Depreciation & Asset master data.
  • Maintained depreciation key, defined declining balance method, multi-level methods of depreciation calculation.
  • Transfer of legacy data to R/3 using Batch input program.
  • Integrated AA with GL by defining G/L accounts for acquisition and retirement account assignment. Maintained Financial Statement Version for Asset Reports.
  • Maintained posting document number ranges. Defined Posting Cycles for Depreciation Run
  • Responsible for Configuration of Asset acquisitions, Asset retirements, Asset transfers, revaluation of assets, depreciation run and year-end closing in Asset accounting.
  • Performed Month endclosing operations for GL, AR, AP and AA that includes clearing GR/IR accounts, regrouping and sorting of AR /AP, running the depreciation run, running the APP program etc.
  • Performed Year end operation - creating Financial Statement Versions, Grouping GL accounts into Balance Sheet and Income Statement accounts. Closing the old posting periods and opening the new fiscal year and posting periods, carrying forward the balances.
  • Defined operating concern, characteristics, value fields, Characteristic Derivation, Valuation strategy.
  • Created settlement profile and PA transfer structure for direct postings from FI/MM and variance settlement.
  • Defined forms and variables, created profitability report using those forms.
  • Configured Costing variant, Costing sheet (Calculation Bases, Overheads, Credits), valuation variant, order type, overhead cost elements.
  • Followed Activity Based Costing (ABC) to estimate the standard cost and to calculate the actual cost using actual values.
  • Made configurations for standard cost estimate with quantity structure. Defined Cost Component Structure, Cost Components.
  • Configured cost object controlling following ‘Product Cost by Order’.
  • Enhancements on G/L: Master records, G/L interfaces, customized developments, month end and year end closing. Bank: House Banks, Check Management, Electronic bank statement and Bank reconciliation. Fixed Asset: Master records, depreciation run, month end and year end closing.
  • Support and training related to Cost center accounting: Master records, assessment cycles, reporting and planning. COPA reporting.
  • Support Internal orders: Master records, settlement and reporting. Projects System: Master records and reportingBasic Settings & Dunning Procedure
  • Migration of legacy cost centers, WBS elements and extraction of COPA.
  • Interaction with business user and SME's to understand requirement for data migration from Legacy system to identify To-Be Process
  • Successful on User Training and Testing GL scenarios: GL master data maintenance, all GL transactions, Month end closing and year-end closing activities and GL reports
  • Contribution to super user Training AP Scenarios: Vendor master data maintenance, vendor invoice, credit memo posting, parking and posting parked invoices, cancel vendor invoice posted through invoice verification, price variance, and Accounts Payable (FI-AP) reports
  • Delivered end user training AR Scenarios: Customer master maintenance, tolerances, over-under payments, cash discounts, Incoming payment (full payment/partial payment/residual payment), dunning procedures, and Age-Wise Accounts Receivable (FI-AR) reports.
  • Proficient at user training on Asset Master Creation, chart of depreciation, inter-company asset transfers without revenue, retirement with sale and disposal of asset, Capitalization of Assets (using WBS), Assessment and Distribution cycles.

Confidential, San Jose, CA

SAP FICO Analyst

Responsibilities:

  • This project involves the end-End Production Support of SAP Financial Information Systems
  • Configuration of Account Payables Starting with Purchase Requisition, Purchase Order, Goods Receipt, Invoice Verification, Vendors credit memo and Check clearing sub-processes, Advance paid or down payment made to vendors
  • Configuration for the creation of Account Receivables invoices and posting of manual incoming payments with differences, clearing and reversals, interest calculation.
  • Involved in developing detailed functional specifications documents.
  • Responsible for SAP FICO upgrade from SAP R/3 4.6c to ECC 6.0 by performing unit, integration and volume testing to ensure the software in the functional area performs as expected.

    Maintained Field Status group for vendor for General Data, Company Code Data & Purchasing Data which reflected on the Vendor Master Records.

  • Maintained Field Status group for customers for General Data, Company Code Data & Sales area which reflected on the Customer Master Records.
  • Configured fiscal year variants with year dependent periods for yearend closing and posting period variants.
  • Created customer/vendor account groups to assign external number ranges to the master records as per the client requirements
  • Responsible for solving Level 2 and Level 3 production support tickets routed though HPSM.
  • Creation of test scenatios in HPQC and validating the test results.
  • Responsible for Month-End Monitioring and escalating issues to leads in case of any devieations.
  • Set and Run Jobs using SM35 in test systems and configure the job in Production system for Users to run.

Confidential, WI

SAP FICO CONSULTANT

Responsibilities:

  • Work with Business users in collecting the requirements and perform GAP analysis.
  • Responsibilities include configuration of GL, Accounts Payable, Accounts receivables, Asset Management, Treasury, Cost Centre Accounting, Profit Centre accounting and Internal Orders.
  • Configuring Enterprise Structure elements Chart of Accounts, leading ledgers, Variant configuration and define Financial Statement Versions for different reporting purposes.
  • In the Accounts Payable module, defined and configuring vendor account groups, maintained terms of payments, reason codes, open item management in vendor accounts, tax account for incoming invoices and intercompany clearing.
  • Manual and Automatic Payment Program with payment advice and payment analysis printing and clearing of vendor open items.
  • Configured exchange rate types, default account assignments for foreign currency valuation and Configured Tax Interfaces like Vertex to meet indirect taxations in USA.
  • Configured chart of depreciation, depreciation areas, asset classes, account determinations, number ranges, screen layouts, depreciation keys, calculation keys and period controls.
  • Define transaction types for acquisition retirement and transfer of assets.
  • Involved in design and customisation of Cost Centre accounting and Internal Order in order to configure Asset under Constructions and its settlements.
  • Set up Cost centre and Profit Centre hierarchies and set up default profit centre assignments for PCA balance sheet reporting
  • Prepared test scripts for different scenarios in Asset Accounting and Accounts Payable integrated with MM and Performed Unit testing, integration testing and UAT Testing.
  • Involved in Cut off procedures along with uploading and tallying of legacy data of Vendors and assets masters and the future depreciations of the assets.
  • Involved in migration of GL master data, Vendor master data and Asset master data from legacy system.
  • Set up statistical and real internal orders for cost allocation via secondary cost elements.
  • Worked on the defect resolution created by the cross functional module as Sales and Distribution, Material Master Team and Product Costing team.
  • Participated in Go - Live and initial support after go live.

We'd love your feedback!