Sap Fico Analyst Resume
New, YorK
SUMMARY
- Certified SAP FICO functional consultant (consultant Id: 0014757957 ) Over 6+ years of experience including 5 plus years as SAP R/3 FI/CO consultant.
- Expertise in configuration and customization of FI (GL, A/P, A/R, AA, SPL).
- Expertise in configuration of Controlling (CCA, IO, PCA, PC, PA).
- Implemented Two Full life cycle in SAP Configuration.
- Strong Post Implementation support 24/7.
- Excellent communication and inter personnel skills. Proven ability to work independently and team environments.
- Had worked in Auto, manufacturing and Retail industries.
- Excellent proficiency in pivot table, pivot chart, macro in Excel for analysis of financial data.
- 2 year of experience as an SQL developer including Retrieving data, sorting data, Manipulating data and insert data.
- Worked in 2 Full life cycle implementations, Rollouts, Support and Upgrade projects.
- Extensive experience in configuration and testing of FI/CO modules - GL, AR, AP, Fixed Assets, Cost Center Accounting (CO-CCA), Internal Orders and Profitability Analysis (CO-PA). Product costing (CO-PC) and Special purpose Ledger.
- Experience in Blueprint, Configuration, Unit, Stress, Volume, Regression, User Acceptance and Integration Testing, Training, Documentation and Production support.
- Experience in preparing functional specification document for ABAP Developers.
- Configuration expert of New G/L to meet requirement of Document Splitting and parallel accounting.
- Integration of FI wif MM and SD wif Procure to Pay and Order to cash Cycle.
- Configuration and extensive support of Invest-to-Divest and Record-to-Report Cycles.
- Configuration and troubleshooting experience of stock transfer, bin to bin transfer, goods movement, goods issue, creation of transfer order, goods wifdrawal, reverse goods movement in IM and WM.
- Configuration and troubleshooting experience of PP staging, batch determination, changes in batch characteristics, changes in production order in PP.
- Through understanding of SAP system from business process, cross functional and integration view point.
- In-depth knowledge in configuration, implementation, ASAP methodology, system design and development and gathering user requirements.
- Excellent in working wif posting validations, substitution rules, forms, interfaces (ALE & EDI), user-exits, and reporting tools..
- Working knowledge of S4 Simple finance.
- Configuration of enterprise structure and currency setup in S4 simple finance.
- Completed training in migration from ECC 6.0 to S4 simple finance.
TECHNICAL SKILLS
ERP Applications: SAP R/3 versions (4.6, 4.7), ECC 5.0, ECC 6.0.
Tools: and Utilities: ASP, V B Script, MS Project Management.
SAP R/3 Tools: SAP-FICO, SAP-SD, SAP-MM, ABAP/4, Report Painter and Report Writer.
RDBMS: Oracle 8.0.2.3 / 9.2.0.7/ 10.0.2.1, MS-SQL Server, MS Access 2000.
Software languages: SQL, PL/SQL, Visual Basic 6.0, PHP.
Operating Systems: Windows (8/7/2003/XP/Vista).
PROFESSIONAL EXPERIENCE
Confidential
SAP FICO Analyst
Responsibilities:
- Analyse teh existing legacy system; gathered functional requirements through user meetings, gap analysis, and participation in process improvement teams; produced teh functional requirements document.
- Designing business processes and identified areas to streamline processes in multiple functional areas. Teh scope of teh work and responsibilities involved relating to SAP - Finance (FI)) and controlling (CO) modules.
- Prepared As To-Be and To-Be documents for changing current manual process into automatic process.
- Preparing CR’S in demand management .
- Configured Global layout of sales data for all user
- Working on User Sap Authorization and assigning roles to them.
- Design process for automatic upload of BAI file into sap from bank and clearing them in FEBAN.
- Creation and Maintenance of interfaces in SAP.
- Scheduling and monitoring of automatic Job that fetch files from particular folder.
- Experience troubleshooting and finding solutions to complex problems.
- Customized screen layouts for document entry at account/document levels. Defined fiscal year variant, posting period variant, customized field status variant, customized line layout, sort variant, and total variant.
- Design, develop, and co-ordinate test plans for functional unit tests, regression tests and system integration tests.
- Configured and Maintaining Procure to Pay (P2P) process: Release Procedure, Pricing Procedure, Inventory Management, purchase order, good receipt and production receipt in FI-MM.
- Configured and supporting Order-to- Cash Cycle: Quotation, Sales Order Creation, post goods Issue, Delivery, Billing, Receipt of Money(Customer payment).
- Configured and supporting Invest-to-Divest and Record-to-Report Cycles as well.
- Customized bank related accounting, bank master data, house banks and G/L accounts in different currencies for each bank account and Electronic Bank Statement (EBS)and manual bank statement.
- In Cost Center Accounting (CO-CCA) created teh cost centers and maintained teh Standard hierarchy, assigned cost center to cost elements..
- In Profit Center Accounting maintained teh basic setting, created hierarchy, dummy profit centers, Profit center master data, profit center groups, activity types.
- Activation of profit Centre and Cost Centres.
- Worked on Sending files from legacy to SAP system and Sending Master data file from SAP to Legacy system through IDOC.
- Worked on Solution manager for tracking of tickets that are created by users.
- Worked on Vertex software for sales tax reporting .
- Perform Integration testing and User acceptance testing .
- Creation of macro for automation of teh repetitive task.
- Experience wif Excel, including pivot tables, formulas, and charting
Confidential
SAP FICO Analyst
Responsibilities:
- Configured General Ledger - Created Master records, accounts groups, number ranges and G/L accounts for each company code, accounts maintenance and preparation to master files.
- Customized screen layouts for document entry at account/document levels. Defined fiscal year variant, posting period variant, customized field status variant, customized line layout, sort variant, and total variant.
- Configured and customized Chart of accounts, Company code Global Parameters, Fiscal year Variants, Posting Period Variants, Account Groups, Field Status Groups, and Tolerance Groups.
- Implemented New GL, Activated new Ledger, Performed document splitting, Parallel Accounting and periodic processing.
- Configured and customized validations and substitution rules for documents, recurring entries, correspondence, taxes, and currencies.
- Configured for vendors subject to wifholding tax, interest calculations on item \ balance interest calculation, number ranges for forms, interest on arrears, account balance calculation on account balances / line items.
- Defined expense accounts, revenue accounts for realized exchange rate difference, differentiated teh accounts by currency, exchange rate gains, and exchange rate losses and then posted to separate accounts for teh individual currencies and foreign currency valuations.
- Configured and customized Asset Accounting Module - Copied country specific chart of Depreciation and configured depreciation areas, defined assets classes, account determinations, screen layout key, allocate number ranges to assets classes, Down Payment configuration for Assets, and uploading of assets from Oracle Financials (Legacy) to SAP.
- Customized bank related accounting, bank master data, house banks and G/L accounts in different currencies for each bank account and Electronic Bank Statement (EBS).
- Configured Lockbox Application conforming to BAI2 format.
- Scheduling and Monitoring of Automatic Job .
- Experience troubleshooting and finding solutions to complex problems.
- In Cost Center Accounting (CO-CCA) created teh cost centers and maintained teh Standard hierarchy, assigned cost center to cost elements. Configured Activities, Statistical Key Figures.
- In Profit Center Accounting maintained teh basic setting, created hierarchy, dummy profit centers, Profit center master data, profit center groups, activity types, etc. and extracted reports using PCA.
- Customizing of cost element group, cost Centre group, activity type, process of calculating planned activity, product costing(Co-PC), creation of internal order, selection variant of internal order, valuation analysis, CO-PA planning in CO.
- Configuration and troubleshooting experience of stock transfer, bin to bin transfer, goods movement, goods issue, creation of transfer order, goods wifdrawal, reverse goods movement in IM and WM.
- Performed Unit testing and integration testing by entering dummy data in system.
- Configuration and troubleshooting experience of PP staging, batch determination, changes in batch characteristics, changes in production order in PP.
- Configuration and troubleshooting experience of APO, new batch creation, remake issues, creation of production order in PP.
- Perform debugging for error correction in ABAP.
- Integration of FI wif MM, SD modules.
- Performed Pivot Table and Pivot chart for analysis of financial data.
- Creation of macro for automation of teh repetitive task.
Confidential, New York
SAP FICO Analyst
Responsibilities:
- As a core member for full cycle implementation ofSAP FI/CO module, gathered business process information and compiled theAS-IS, TO-BE and GAP analysisof teh SAP R/3 system. Performed assessment of business requirements, mapping wif SAP functionality.
- ConfiguredFI New GL, AP/AR & Banking- Document Splitting, Segment Reporting, Special purpose ledger, Doc types & posting keys, analysis of all open items and clearing of goods receipt/invoice receipt (GR/IR) accounts. Designed Account groups and Configured Payment program for check printing and Wire Transfer payments. Configured tax codes for vendor invoices. Worked on Vendor Master, Vendor invoices Payment methods (ACH/Wire Transfer, Check and Credit Card) and reporting, Customer Master, and Default account assignments for Overpayments/Underpayments.
- InAsset Accounting (FA), assisted in creating Fixed Assets, Group Assets, Assets Class, Post Periodic Assets, and Asset Acquisitions. MaintainedDepreciations, Chart of Depreciation, Depreciation Area, Fiscal Year Variant, Number range, and Substitution Rules in teh Fixed Asset Master records and reviewed various Fixed Assets Accounts.
- Integration of parallel accounting concept during configuration forFixed AssetsModule, General Ledger, and re-grouping and currency valuation processes for each period-end.
- Responsible for configuration of asset classes, depreciation areas, account determination, screen layout key and allocating number ranges to asset classes. Customized screen layout for each asset class wif unique number ranges.
- Created an Electronic Bank Statement Posting Rules. Created Lockbox in House banks.
- Configured relevant settings for Lockbox processing and Outgoing Payments.
- Coordinated teh integration efforts of FI/CO wif SD, MM, based on functional requirements, automatic account assignment, maintaining teh revenue account determinations & revenue recognition which is useful in integrating AR-SD.
- Cost Center/Profit Center Accounting - Defined standard hierarchy for cost center accounting designed Automatic Account Assignments, Assigned Cost Centers to Profit Centers and created Primary and Secondary Cost Elements.
- Configured CO-PC-Product Cost is planned by defining teh Basic Settings for Material Costing, defined Costing Sheet, Calculation Bases, Overhead Keys and Cost Component Structure, Estimating material Cost wif Quality Structure, defined Costing Variants and Transfer Strategies.
- Controlling teh Cost Object by order, defined RA Keys, Cost Elements for WIP Calculations, Number Ranges, Settlement Profiles and Transfer Structures.
- Configured CO-PA and PCA to provide Product Line P&L and Balance Sheet reporting. Implemented CO / Overhead model, using Overhead key, Activity types, and Cost Centers. Reviewed teh Material management configuration Purchase orders, Conventional Invoice verification, Logistic Invoice verification, Inventory management, Goods movements, Stock transfer between Company codes and Plants, Purchase Order swap between company codes, GR/IR clearing.
- Conducted Procure to Pay (P2P) process, Release Procedure, Pricing Procedure, Inventory Management, purchase order, good receipt and production receipt in FI-MM.
- Assisted in creation of sales order, distribution channel, delivery document, billing document, defining of shipping point in Fi-SD integration.
- Perform debugging for error correction in ABAP.
- Created RFC, BAPI, BADI interfaces for ABAP Developers.
- Performed Pivot Table and Pivot chart for analysis of financial data.
Confidential
SAP FICO functional analyst
Responsibilities:
- Involved in theFull Life cycle implementation phases, including defining teh business requirements, analysing teh gap, writing functional specifications, configuration and testing. Participated in new and existing client development.
- Analysed teh existing system for,AS-ISstudy, gathered functional requirements through user workshops, gap analysis, and participation in process improvement teams
- Examined teh company's document flow vis-a-vis SAP process flow and recommended suitable validation procedures for documents at header, line item and whole document level.
- Analysed teh business requirements, determined organizational structures and classified business units/locations as company codes, business areas and profitability centers
- Retest and suggested for enhancement in General Ledger Accounts (GL), AP, AR and other related configurations.
- Customization experience in various areas of FICO modules including organization structure, Basic settings & global settings, maintaining Fiscal year variant & posting period variants. Creating and configuring of document types, posting keys & defining document number ranges.
- Creating and configuring Chart of Accounts, Account groups, General Ledger accounts master data, field status groups and tolerance groups for GL accounts, Defining multiple currencies / parallel currencies etc.
- Accounts Receivables and Payables: Configuration of customer master and vendor master data in FI, Account groups, Number ranges, and document types for posting validation of business transactions. Creation of dunning program for reminder to customers wif different dunning levels, setting up of Automatic payment program configurations, Down payments & other special GL transactions, Foreign currency valuations etc.
- Configuring cash Journal, creating house banks and configuring Bank reconciliation statements.
- Configuring financial statement versions as per Client requirement.
- Creating Bank Master data, House banks, GL accounts for each bank account and creating bank reconciliation accounts for vendors and customers.
- Configured electronic bank statement, manual bank statement, lockbox in bank accounting.
- Interacted closely wif teh Users in Treasury department to understand teh issues wif Lockbox and Electronic Bank statement functionality (EBS).
- Responsible for analyzing teh code changes to standard SAP Lockbox functionality and fixing teh bugs.
- In Profitability Analysis (CO-PA), created teh Operating concern, configured costing based profitability analysis. Defined and configured teh reporting characteristics, value field, profitability segments used in profitability analysis.
Confidential
IT support / SAP Support analyst
Responsibilities:
- Involved in technical documentation of all custom business objects and end user training.
- Designing and configuring Chart of Account and multinational company codes in multi currencies.
- Configured and tested General Ledger Accounts (GL), AP, AR and assigned different processing keys as required.
- Interacted wif client to define General Ledger (GL) account groups and assigned number ranges to these account groups.
- Configured Accounts Receivable (AR) and sample ledger accounts. Defined tolerance groups, tolerance for employees, customers and vendors and maintained initial settings and recurring entries.
- Defined customer account groups and created customer master data for accounts receivable.
- Configured automatic payment program for outgoing payments for company codes in Accounts Payable (AP).
- Creation of Vendor and Customer master records and loading of legacy data into teh system
- Complete Customization of Cash Journal and House Bank and setting up Cash and fund management sub module
- Preparation of Financial Accounting Master Data Preparation & Maintenance
- Complete Configuration for FI/CO integration wif MM for material movements and SD wif pricing and billing including automatic account determination and GL account postings
- Supported user community for all finance related queries in ERP system.
- Setting of Financial statement version me.e. Balance Sheet & Income Statement.
- Configuration for intercompany transactions.
- Cost Center Accounting Configuration, setting of controlling area, cost elements, cost centers, valua-tion profiles, field status groups, internal orders, WBS elements .
- Profit center accounting configuration, setup, Profit center hierarchies, Product Costing, Profitability analysis, Profit center based Balance sheets & P&L statements.
- Maintained Master Data for Cost Center Accounting, Profit Center Accounting, General Ledger, Internal Orders, Accounts Payable, Accounts Receivable modules.
- Configuration of Product Costing (CO-PC) including defining settlement profile, Assessment Cycle and distribution and various activities.
Confidential
SQL Developer
Responsibilities:
- Retrieving data using teh SQL select statements.
- Restricting and sorting data.
- Reporting aggregated data using teh group functions.
- Displaying data from multiple tables.
- Use of sub-queries to solve query.
- Use of DDL statements to create and manage table.
- Managing objects wif data dictionary view.
- Use of single-row function to customize output.
- Controlling user access.
- Manipulating large data sets.
- Generating reports by grouping related data.
- Managing Data in different time zone.
- Retrieving data using sub-queries.
- Hierarchical retrieval.
- Specified user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data.