Sap Finance Analyst Resume
TX
SUMMARY:
- SAP Functional Consultant with around 6+ years of functional experience in Financial Accounting (FI) and Controlling (CO) modules and integration with logistics modules (SD, MM &PP). Involved in 2 full life cycle implementations using ASAP methodology Involved in different phases of life cycle implementation of SAP including Feasibility Analysis, Configuration, Testing and Support Performed As - Is study, Business requirement collection, Project Analysis, Process Design, Blue Print, GAP analysis, design, upgrade, Go-Live and Support
- SAP experience encompasses expertise in Implementing, customizing, configuring, System upgrade, integrating, testing, user and support of SAP with different versions including ECC 6.0 and SAP HANA.
- Checked CO-PA reports for PS/WBS Element for Revenue and COGS/COS (Cost of Goods Sold and Cost of Sales) update. Update CO-PA configuration with correct field value for value flow in CO-PA.
- Update Monthly MIS reports with report writer / report painters to update G/L accounts and Accounts Group in Reports to get proper result as per business requirements.
- Checked for Integration for SAP Product Costing (CO-PC) with Production Planning (PP), Project System (PS) and Sales Order.
- Perform pre-checks for performing the upgrade and migration.
- Coordinate and prepare HANA Database for migration.
- Documentation for POC on Suite on HANA.
- Worked in 2 Full cycle implementations using ASAP (Accelerated SAP) methodology with experience in all project phases - Business blue print, Realization, Final preparation,Go-live and Support and post live production support, with documentation.
- Extensive hands on experience in Financial Accounting (FI) including General Ledger(GL), New G/L, Asset Accounting (AA), Bank Accounting (BA), Accounts Payable(AP), Accounts Receivable (AR), Special Purpose Ledger and Treasury.
- Configured system settings in the areas of FI-GL transactions, house bank, AP-Automatic Payment Program (APP), Open Text vendor Invoice Management (VIM, ) Event Management, AR-Customer Credit, Credit Controls, and Credit Memos and performed Dunning.
- Developed SAP query for Withholding tax from BSIK and LIFNR table -open item information.
- Integration of FI with MM, SD and WM, LE (Logistic Execution), LIV (Logistic Invoice Verification), internal orders and Month End closing.
- Proficient in external reporting and preparation of financial statements with good understanding of Generally Accepted Accounting Principles (GAAP) and International Financial Reporting Standards (IFRS) financial analysis.
- Developed and configured the Electronic bank statement (EBS), Cash management and Lock box procedure in Treasury (FI-TR).
- Configured areas of AP - house banks, automatic payment program etc. and areas of AR - dunning, Interest Calculation and Credit Management (FI-AR).
- SAP Financials conversion and/or implementation experience - primarily within Asset Management.
- Sound Knowledge in migration of data from Legacy system to SAP for Upgrade / new implementation / integration using LSMW.
- Documented client business requirements (business scenarios, business issues, internal & external customer needs), analyzed and proposed business and system solutions and been a part of the drafting of the client Blueprints and performed testing in HP ALM and Solution Manager.
- Experienced in testing scenarios such as Integration, Functional, Regression, User Acceptance Testing, Performance and End-To-End Testing.
- Facilitated the UAT process and supported end users during UAT phases and Worked on defect life cycle for UAT defect.
- Experience in Mapping current state to future state, developed test scenarios, RICEFs, Conversion/Interfaces/validation plans, cutover, end user and post go-live production support.
- Demonstrated ability to work both in independent and team-oriented environments with well-developed organizational skills, excellent communication and interpersonal skills with problem solving ability.
TECHNICAL SKILLS:
SAP Financials: Simple Finance, GL/ New GL, Accounts Payable, Accounts ReceivableBank and Asset Accounting, S4 HANA
SAP Controlling: Cost Element, Cost Center and Profit Center Accounting, Product Costing and Profitability Analysis.
SAP Interfaces: IDOCs, ALE, BAPIs, EDI, .net connectors.
SAP Tools: SAP Solution Manager, SAP Query, LSMW, Report Painter, BDC.
Databases: Oracle, MSSQL, MySQL, SAP BW, SAP HANA.
Testing Tools: HP Quality Center / ALM, HP Quick Test Professional / UFT, SAP TAO, Worksoft Certify, JIRA.
Office Tools: MS Visio, MS Project, Word, Excel, PPT.
PROFESSIONAL SUMMARY:
Confidential, TX
SAP Finance Analyst
Version: ECC 6.0(Full Cycle Implementation)
Responsibilities:
- Participate in and develop/own process improvements for Operations, Finance and Accounting
- Establish and maintain effective working relationships with all stakeholders.
- Involved in the business process review, validation and testing of the current SAP system in accordance with the business structure providing the support for technical upgrade for GL,AR and AP.
- Configured the new GL functionality (standard company hierarchy, account groups, accounts for company codes, fiscal year variant, field status variant and posting period variant, implementation of parallel accounting methods and document splitting).
- Configured AR/AP for customers based upon interest calculation on items, account balance configuration / validation of substitution rules for documents, recurring entries, taxes, currencies and correspondence.
- Customized payment terms for Dunning and down payments, lockbox application in compliance with the BAI2 Format.
- Utilized LSMW to transfer Master Data.
- Active participation through Blueprint, Design, Realization, Testing, Go Live and Stabilization activities.
- Part of the implementation team for FI-GL, FI-AP, FI-AA.
- Analyzed the existing process for Asset Accounting and redesigned the process by gap identification and analysis after carrying out re-engineering, preparation of prototype, and pre-process testing.
- Involved in the business process review, validation and testing of the current SAP system in accordance with the business structure providing the support for technical upgrade for GL,AR and AP.
- Analyzed the existing process for Asset Accounting and redesigned the process by gap identification and analysis after carrying out re-engineering, preparation of prototype, and pre-process testing.
- Performed business process design and documentation
- Configured chart of depreciation, depreciation areas, depreciation keys, asset classes, number ranges, revaluation settings.
- Configured the system for Customer / Vendor down payments (Special G/L indicators)
- Performed Unit Testing, Integration Testing and User Acceptance Testing.
- Configured asset class and account determinations, Group Assets, Asset under Construction, Asset acquisitions, transfers and retirement
- Configured Tax Depreciation Related Depreciation Calculation Keys, Derived depreciation area, and special valuation of assets including Revaluation using revaluation measures
- Configured the system for Customer / Vendor down payments (Special G/L indicators).
- Responsible for FICO module - Accounts Receivable (AR), Accounts Payable (AP), GL Accounting (GL), Asset Accounting (AA/ FA/AM),Vendor payment, Electronic EBS.
- Responsible for customization of the organization structure, client interaction, user, process and transaction testing.
- Configured the Company code Global settings.
- Working on RICEF (Reports, Interfaces, Conversion, Enhancements and Forms).
- Analysis of customer requirements in preparing the master data for GL accounts, asset masters, Customer masters etc.
- Configured the Automatic Payment Program in Accounts Payable.
- Accounts Receivable: Configured customer incoming payments full, partial, & residual payments.
- Configured dunning, clearing, statistical postings, down payments.
- General Ledger accounting: Finalized Chart of Accounts, GL postings, and foreign currency valuation.
- Bank Accounting: Configured master data for house banks, Bank statement, reason codes, check printing, interest calculation.
- Asset Accounting: Configured and customized Chart of Depreciation and its Assignment to Company Code.
- Involved in the Legacy data asset transfer, which is taken into the system using batch data processing.
- Created Asset Master Data, asset classes, and depreciation areas/keys.
- Handled assets acquisition/retirement of assets & postings.
- Performed Unit Testing, Integration Testing and User Acceptance Testing
- Provide SAP support to accounting/finance and business process end users and management with limited supervision.
- Configuration of Assets Accounting(Chart of depreciation, Depreciation methods and Depreciation run).
- Create a collaborative environment that can support the standardization of business processes and documentation across Interiors
- Provide advice to the sites on best practice in SAP operations
- Improve SAP utilization & effectiveness within all Interiors value streams
- Participate in process improvements for Finance and Accounting and/or Business processes.
- Worked on Electronic bank statement for inbound and outbound transactions.
- Involved in house bank clearing configuration. creating on business scenarios as per business requirement- park and post general entries.
- Working on RTR interfaces by providing document number to end users.
- Working on data migration from legacy system people soft to SAP HANA by using front end SAP fiori application.
- Performed As Is study and prepared To Be Process documents for FI/CO Module.
- Studied and analyzed client's Business Processes and mapped them into SAP.
- Involved in final configuration of GL, AR, AP and writing functional specifications.
- Working closely with security team, basis team, product owner, business user and Scrum master.
- Run reports for Maintenance Department utilizing SAP data and extracting into Excel files for data trend tracking.
- Create documentation on new issues resolved, root cause analysis as well as troubleshooting steps attempted prior to closing or escalation incidents.
Confidential, OH
SAP Finance Analyst
Version: ECC 6.0(Full Cycle Implementation)
Responsibilities:
- Setup all incoming payments including Lockbox using EDI823, Electronic bank statement (EDI820).
- Responsible for FICO module - Accounts Receivable (AR), Accounts Payable (AP), GL Accounting (GL), Asset Accounting (AA/ FA/AM)
- Responsible for customization of the organization structure, client interaction, user, process and transaction testing
- Configured the Company code Global settings.
- Analysis of customer requirements in preparing the master data for GL accounts, asset masters, Cost centers, Customer masters etc.
- Cross company code transaction process set up
- Configured the Automatic Payment Program in Accounts Payable.
- Accounts Receivable: Configured customer incoming payments full, partial, & residual payments.
- Created origin-destination, house bank, partner profile, port definition, message types and logical message types
- Configured payment program to process transaction from banking database
- Upgraded auto clear program to process more open item after lockbox is processed
- Configured automatic payment program, which included creation of house banks, company code payment methods, employee tolerances, terms of payment, and reason codes
- Configured settings for Company code, posting period variant, assigned document number ranges, tolerance groups for customers, G/L accounts and users
- Configured partial payments, exchange rate differences, payment advices, payment proposal/payment schedule, payment run, and payment media
- Active participation through Blueprint, Design, Realization, Testing, Go Live and Stabilization activities.
- Part of the implementation team for FI-GL, FI-AP, FI-AA Product Costing, Profitability Analysis, Cost center Accounting and Profit Center accounting modules at HASS Automation.
- Defined result analysis keys, cost elements, result analysis versions and valuation methods to calculate Work in Process (WIP) and its settlements.
- Configured valuation areas, multiple currency types, movement type groups and material update structure in product costing.
- Responsible for carrying out valuation in COPA to access pricing and product cost information thereby allowing projected revenue and cost of sales figures to be calculated.
- Implemented transfer of overhead costs, transfer of activities from cost center accounting over to COPA segments.
- Configured account assignment objects for incurred costs and revenues to profit centers.
- Designed and mapped business processes and business solutions.
- Presented requirements and solutions to senior management
- Managed the delivery of business change and business readiness, working closely with the business to ensure the solution is delivered at a high quality.
- Coordinated testing, cutover activities, and managed post go-live support for SAP system.
- Managed offshore team, organizing testers, test scripts, and delegating workload.
- Provided on-site, assistance with testing for multiple countries, issue resolution and support which is maintained through HPQC (Mercury Quality Centre).
Confidential, Camp Hill, PA
SAP Finance Analyst
Version: ECC 6.0(Full Cycle Implementation)
Responsibilities:
- Analyzed As-Is business processes to design solutions and designed the To-Be Processesand played an active role.
- Involved in prototyping of the solutions in different phases of ASAP methodology.
- Conducted meetings with business users to discuss the deliverable sign-off.
- Revamped the bank statement and payment processes, by providing a structure that allows better hit rate for cash application.
- Provided upgrade fixes in all areas of configuration in the application areas FI-GL, FI-AP, FI-AR and Banking.
- Worked on configuration tasks in GL, AP, AR, AA and Treasury (lockboxes, electronic bank statements).
- Configured Automatic Payment Program (F110) for Outgoing Payments for new CompanyCodes in Accounts Payable. Created new forms and print programs for new payment methods.
- Devised LSMW for all the data migrations/conversions and master data uploads.
- Used Excel (Lookup and Pivot) for data conversion.
- Compared balances of AP, AR, AA Reconciliation accounts after activation of group currency for different key dates.
- Defined Reason codes, Customized Reason Code Conversion Versions & Mapped external reason codes to the defined reason codes to facilitate accountability for the underpayment and overpayment of incoming payments from customers (FI-AR).
- Solved problems on Invoice, Cash Application, Lockbox, Electronic Payments, and Automatic Customer Payment, clearing programs, Settlement, Adjustments, Credit Management and Banking integration.
- Created accounts required for revenue recognition.
- Remodeled various FI functions, Recurring entries, carry forward balances, residual/ partialpayment settings for vendors and customers, Automatic Payment program, down payments,reversal of documents and exchange documents.
- Checked CO-PA reports for PS/WBS Element for Revenue and COGS/COS (Cost of Goods Sold and Cost of Sales) update. Update CO-PA configuration with correct field value for value flow in CO-PA.
- Experience supporting external tax system (OneSource)
- Defined costing type, valuation variant, date control, quantity structure control and transfer control and variants for defining costing variant.
- Defined parameters for price update in standard cost estimate and inventory cost estimate and defined settings for and simulation costing and adhoc cost estimate.
- Defined Variance Keys, valuation variants for WIP and Scrap, target cost versions for variance calculation and result analysis keys, result analysis version, valuation methods, line ids, and assignment for work in process (WIP).
- Contribute to open source software.
- Configured Profitability Analysis- Defined Operating Concern, defined Characteristics and its Values, Value Fields, Account based and Costing based Profitability Analysis.
- Reconcile the difference between SAP Financial report with SAP- CO-PA report and re-configured/re-design the business process to match these two reporting.
- Extensive work on Asset Accounting (AA), asset creation, asset classes, depreciation areas,asset acquisition, determined depreciation areas in the asset classes, controlled the calculation of depreciation and carried out important periodic processing tasks.
- Created test plans and test scripts in HP-ALM for integration and UAT Testing.
- Involved in running scripts using automation tools like selenium and integrated ALM by installing various ADD-INS.
- FI AP - Bank set up, APP with various payment methods and different currencies, prior day file process, Bank accounts, EBS. AR - Lock box set up and process. New GL and document splitting functionalities. Default Account Assignments, Configured Input and output Tax and integrated with Vertex system. Worked on FATCA and other withholding Tax set-ups. Did Fixed Assets Accounting set up and month end and year end processing support. Controlling - worked in Cost Center Accounting, Profit center Accounting, Profitability Analysis.
- Provided end user and assistance in developing user documents in U perform.
Environment: SAP S/4 HANA, Solution Manager, HP ALM, Service Now, VERTEX, SAP FI, AP, AR, SD,FA, CO, PC, PCA iDoc, ABAP and LSMW
Confidential
SAP FICO Analyst
Version: ECC 6.0 (Full Cycle Implementation)
Responsibilities:
- Worked on full spectrum of ASAP methodology from gathering functional requirements, blue printing, configuration, customization, data migration, testing,, cutover and hyper care support.
- Written functional specs for different RICEF objects.
- Responsible for migrating customer & Vendor master data from legacy system in to SAP through LSMW.
- Configured Automatic Payment Program for payments to vendors; check lots, void & reissue of checks, online cash and blockage of payments for certain vendors.
- Orchestrated dunning program, dunning levels and dunning areas for each company at company code level.
- Profitability Analysis (COPA): KEPM Designs: Planning methods, Layouts, Reports, Planning levels, Planning versions, Derivations rules, Integrated Planning, data uploads from excel.
- Configured Rules for the Vertex Tax Decision Maker (TDM) to handle Customer Tax Exceptions, Product Tax Exceptions and Jurisdiction Exceptions.
- Mapping of Organization Product codes with Vertex product codes using Vertex Taxability and mapping Tool (TMT) for quicker handling of state-based product exceptions.
- Configured New G/L for document splitting and provided Document simulation facilityrather than waiting for period end process.
- Configured new costing variants, valuation variants, overhead costing sheet in product costing.
- Integrated SAP with the web-enabled Vertex&SAP Integration Component (SIC).
- Redirected SD (Order-to-Cash/Quote to Cash) and MM-PU (Purchase-to-Pay/Order toPay) master data links to Vertex.
Environment: SAP ECC 6.0, Solution Manager, SAP FI, AP, AR, SD, FA, CO, PC, COPA, PCA iDoc, ABAP and LSMW
Confidential
SAP FICA Analyst
Version: ECC 6.0
Responsibilities:
- Core member in SAP implementation team for FICO/FICA module.
- Involved in all the business meetings to understand the Entergy business process, requirements, writing and reviewing the functional specification documents with the team for FICA module.
- Worked on ISU-Billing/Invoicing implementation.
- Expertise on configuring the account determination, charges and discounts, extended payment terms functionality, billing, daily and monthly invoicing process, RFP generation, reconciliation report etc.
- Configured on Customer account maintenance and payments (Incoming and outgoing).
- Expertise on integration of FI-GL with FICA, reconciliation key transfer, billing, Invoicing in contract accounts receivable and payable.
- Worked on Billing & Invoicing based on the regulatory requirements.
- Implemented dunning by dunning procedure for ISU-FICA and Configured clearing control variant for FICA.
- Integrated banking with cash position update. Worked in integrating ISU-FICA with Banking using EBS. Mapped external banking transactions with EBS.
- Expert technical understanding of different payment file format (ACH, NACHA, BAI, BAI2 and SWIFT FORMATS).
- Configured Accounts Payable (A/P), customized vendor master data, specified number ranges, one-time vendors, credit memos, reconciliation accounts, special ledgers for advance payment postings, GR & IR accounts and configured Automatic Payment Program.
- Implemented parallel ledger (based on special purpose ledger) for FERC reporting which is a roll-up ledger with periodic transfers.
- Wrote Functional specifications using ISU-FICA Events for Convergent invoicing and FICA, prepared configuration documents.
- Wrote Functional specifications (RICEF/ WRICEF) using ISU- FICA Events, Wrote unit and integration test scripts.
- Hands on experience in handling Tickets during Production support, ticket monitoring and reporting with SAP Solution manager.
- Hands on experience in building test cases, executing the test scenarios and documenting the results in functional testing, integration testing and end to end testing.
- Facilitated the UAT process and supported end users during UAT phases and worked on defect life cycle for UAT defects.
- Developed the automation test scripts for the sap FI test cases using eCATTs.
- Extended production support for critical business issues and trained end users, prepareduser documentation and necessary material.
Environment: SAP ECC 6.0, Solution Manager,SAP FI, AP, AR, SD, FA, CO, PC, COPA, PCA iDoc, ABAP and LSMW
Confidential
SAP TRM Analyst
Version: ECC 6.0 (Roll-Out Project)
Responsibilities:
- Presented a clear blueprint session on major improvements for SAP CML and Treasury module upgrade along with implementation roadmap.
- Presented and Implemented SAP Tax and Revenue Management functionality in improvingexternal and internal services and for optimizing receivables management and accountingsystems.
- Defined and Created different BRF objects for forms validation, advance payment, exceptionmessages, taxpayer registration and tax returns processing.
- Worked on funds and foreign exchange transactions, TRM securities, and derivatives.
- Defined and reproduced the complete loan process and underlying transactions of contractacquisition from application to contract and managing collaterals (Collateral Value Calculation).
- Built a new process around Loan conditions regarding repayment settlement and Interest on Arrears calculations.
- Revamped the bank statement and payment processes, by providing a structure that allows better hit rate for cash application.
- Designed and configured Transaction Manager (FX, Money Mkt, TRM Securities andDerivatives), Cash Position/ Liquidity Forecast, AP and Treasury payments, Electronic BankStatement, Lockbox, and Exchange Rates, Credit Risk Analyzer, Market Risk Analyzer.
- Provided upgrade fixes in all areas of configuration in the application areas FI-GL, FI-AP, FIAR,Treasury and Banking.
- Redefined the flow types for Accruals and Deferrals postings and resetting.
- Assessed goals for trading management by gathering business requirements regarding money market and TRM securities trading and defining a competitive solution in processing different trade settlements covering major commodities.
- Maintained all documentation directly related to Loans and Treasury Management includingend-to-end process flows, process documentation, functional and technical specifications and configuration documentation that reflect upgrade changes.
- Defined Testing procedure and roadmap for a successful upgrade.
- Perform unit testing of changes (configuration, custom development, etc) in development and staging environments.
- Prepared test scenarios, integration test documents, and documentation of all relevant process UAT, trouble shooting.
- Involved in testing in development and Q&A environments. Issues resolving, compile documentation, user and sign off.
- Provided end user and assistance in developing user documents.
- Coordinated for providing effective support to users through calls as well as application support for all manual and system errors.
Environment: SAP ECC 6.0, Solution Manager, SAP FI, AP, AR, SD, FA, CO, PC, COPA, PCA iDoc, ABAP and LSMW
