Sap Sr. Analyst, Resume
Hillsboro, OR
PROFESSIONAL SUMMARY:
- SAP consultant with 8 years of experience distributed across new implementation, rollout and support projects in Finance & Controlling (FICO) and FSCM.
- Two full life cycle implementations of SAP Finance (FI) and Controlling (CO) modules with hands on experience in up gradation and in following SAP versions, SAP R/3 4.5B, 4.7, ECC 5.0, 6.0
- Expertise in implementing ASAP methodology on all stages of projects including Business Process Analysis, As - Is and To-Be designing, Business Blueprint Mapping, Gap analysis to customization, Realization, Go-live, post live production support, User training and documentation.
- Expertise in Financial accounting include FI-AA, FI-AP/AR including Credit Management, FI-G/L including New GL, Special Purpose Ledgers, Treasury Management.
- Data Migration strategies for master and operational data load with LSMW, BDC/batch input, direct input, BAPI, and IDOC infrastructure.
- Strong knowledge in Integration of various SAP FICO applications with SD & MM. Performed integration of FI/CO module with SD, MM and PP modules.
- Created & Maintained Customer and Vendor Master Data along with, Customer and Vendor Groups, Payment Terms, Reporting, Dunning, Down Payment, Discount, Over and Under Payment.
- Configured payment terms for Dunning , Over-Due Interest calculations for Down Payments and Automatic Clearing of line items and for posting net payment amounts for Cash Discounts after calculation of Cash Discounts, Under / Over Payments, write-offs and Reason Codes .
- Implemented audit controls, defined user profiles, authorizations and addressing segregation of duties issues related to Sarbanes Oxley (SOX).
- Expertise in using CATT, SAP Scripts, Smart Forms, ABAP Queries, ABAP debugging and possesses ability to propose and justify technical solutions functionality. Good working knowledge in development of custom reports, Report Painter, Report Writer.
- Technical proficiency in implementation of major functionalities like Electronic/Manual Bank Statements, Payments, Electronic and Manual Check deposit, Payment Advices, complete Check Management functionality.
- Extensive Experience with SAP FSCM Modules Including SAP Biller Direct: for handling Web-based payments and account and bill display, SAP Dispute Management: for processing customer invoice complaints.
- Performed Lockbox configuration, Lockbox Processing, setting up house banks, defining lockbox accounts at House banks, defining lockbox parameters, posting data and testing the lockbox functionality.
- Defined number ranges, valuation of assets in different depreciation areas, external asset acquisition, in-house asset acquisition, cross company code transfers in Asset Accounting (A/A).
- Proficient in Manual Testing, Integration, Functional, Regression, User Acceptance Testing, Performance and End-To-End Testing.
- Excellent communication skills, exceptional ability to perform individually as well as part of team.
TECHNICAL EXPERTISE:
ERP: SAP R/3 4.7, ECC 5.0, ECC 6.0
Financial: General Ledger, Accounts Payable, Accounts Receivable, Asset Accounting, Bank Accounting.
Controlling: Cost Element/Cost Center Accounting, Profit Center Accounting, Internal Orders, Profitability Analysis, and Product Costing.
Technical: ABAP Query, Report Painter, Report Writer, CATTS, eCATTS, Infopak, uPerform, LSMW, HPQC, ASAP Methodology.
Databases: MS Access
Office Tools: MS Word, PowerPoint, Excel.
PROFESSIONAL EXPERIENCE:
Confidential, Hillsboro, OR
SAP Sr Analyst
Environment: SAP ECC 6.0
Responsibilities:
- Worked on functional specs, configuration and user testing, technical testing and solution delivery on various projects as part of Nike Treasury team.
- Responsible for configuration and solution implementation of SAP In-House Cash. Setup of ALE IDOC for in-house Cash Module for IDOC type PAYTEXT, FINSATA and DIRDEB.
- Resolve IDOC issues related to In-house Cash during integration testing.
- Configured House Banks with multiple Bank Accounts, alternate bank selections for Payments, assigned check lots and defined void reason codes, check lots and configured Automatic Payment Program for outgoing payments and IDOCs.
- Configured Automatic Payment Program and Dunning Program.
- Made settings for automatic procedures in Payment Programs and for interest calculation on account balances/line items and foreign exchange calculation.
- Troubles shoot issues relating to the overall payment process including the F110 Payment.
- Maintained Lockbox configuration with BAI2 format, cash management, planning levels in treasury and on Electronic bank statements (EBS).
- Configured relevant settings for Treasury Cash Management position, liquidity forecast and cash concentration.
- Ensured that all computerized aspects of Accounts Receivable (A/R) were operating efficiently and effectively to ensure proper fee calculation and billing.
- Configured customer account groups, number ranges, tolerance groups; credit control area, customer credit limits, credit limit groups
- Configured credit control area and credit management for Account receivable (A/R).
- Integration of FI with MM and SD modules, Fine-tuning interfaces with FI, GL, AP, and AR including validation / substitution rules.
- Configured G/L Master records, document number ranges, posting period variants, tolerance groups, reversal of documents, opening and closing of posting periods, field status groups, document types, posting keys.
- Extensively worked on LSMWs to enable conversion of master data and transactional data into SAP in the areas of FI and Controlling as part of Data Migration.
- Responsible for Account payable (A/P) and Account receivable (A/R) master data and open items interfaces between SAP systems and between SAP and third party systems
Confidential, Redmond, WA
SAP FICO Functional Consultant
Environment: SAP ECC 6.0
Responsibilities:- Worked on Business Requirements gathering and classification into configuration and RICEF objects, Functional Design and gap analysis for intercompany process automation, vendor master data and vendor invoice migration.
- Coordinated with development team for preparing technical specifications and custom report developments for Unrealized Intercompany Margin, intercompany invoice print.
- Improved Treasury short term cash flow forecasting process through process automation and implementation of SAP Cash flow forecasting module. Configured EBS, product types for debt, FX, created cash concentration groups and bank configuration.
- Coordinated integration of all existing bank interfaces such as current day, prior day, wire, ACH payments using SWIFT Alliance and BAI2 files.
- Optimized AP and Treasury payment process, created custom payment types for SEPA, payment methods with cash discount, configured all aspects of FBZP transaction. Configured all aspects of lockboxes for inbound payments from banks,
- Configuration, test case preparation and End user documentation for Intercompany reconciliation (ICR) process.
- Reviewed and suggested changes to current regional payment and invoicing solution to help resolve critical issues with SAP and its bank interface and designing a solution for cash application using both Lockbox and Electronic bank statement (EBS).
- Designed a treasury blueprint solution that complies with best practices; setting up a centralized treasury operation and global cash pooling using In-house Cash (IHC).
- Recommended system changes as preparation for future growth with the goal of providing short-term and longer-term solutions for cash management.
- Configured and customized Account Receivable (AR) and Accounts Payable (AP) modules including creation of Vendor Master Records, account groups, tolerance groups, account determination, and default account assignments.
Confidential, Houston, TX
Senior SAP FICO Functional Consultant
Environment: SAP ECC 6.0
Responsibilities:- Worked on Business Requirements, Functional Design and gap analysis for Vendor Open Invoices Migrations, GL Account balances migration and Purchase Order Migration from (SAP 4.5B) to (SAP 6.0)
- Formulated functional specs and guided ABAP programs development and custom function module modifications for vendor invoice extraction, convert to Idoc format file, Invoice upload, vendor invoice clearing.
- Extensively worked on direct procurement in ECC. Purchase requisitions, purchase orders, GR/IR clearing, Invoices and outline agreements and custom reports along with standard info cube.
- Resolve issues with exchange rates (standard and spot rate) calculations, withholding tax (WHT), language types and performance issues associated with vendor open item migrations high volumes.
- Configured business transactions for Accounts payable (A/P) payment runs program, clearing of vendor open items. Company code data, Paying company code, Country payment methods, wire transfer settings, ACH payments, Dunning Notices.
- Created Vendor transactions, Master data, Check management, House banks, Payment Terms, Deduction management, Clearing Inter - company Vendor/Customer open items, Logistic invoice verification, Evaluated settlement.
- Configured settings for integration of SAP with Tax ware. Maintained Input and Output tax codes for different jurisdiction codes, and maintained jurisdiction code settings, automatic account assignments for tax postings. Configured tax determination procedures for US and Canada. Worked on functional specification for user exit for tax determination using Tax ware.
- Designing included process flow, ABAP program developments, logic buildup for balance calculation, Co Code split scenarios and correct mapping for cost center and Business area, custom mapping tables for GL account mapping.
- Configured and customized General Ledger, creation of G/L accounts, screen layout rules, automatic account assignments, financial statement version, and validation and substitutions rules.
- Configured posting period variants, open and close of posting periods, fiscal year variants, field status groups, document ranges, tolerance groups, and assigning the variants to company code etc.
- In Vendor Master Data Migration from (SAP 4.5B) to (SAP 6.0); Analyzed and configured vendor accounting groups, accounting groups number ranges, minority indicators, tolerance groups, country specific field checks, mappings vendor reconciliation accounts.
- Configured Idocs settings for CREMAS, ADRMAS, INVOIC, ACC DOC Idoc types; Reprocess the failed Idocs after the error has been fixed through reprocess programs, blocking of the Idocs, Archived Idocs.
- Coordinated with different teams (TAX, GL, and AP) for test case scenarios, execution and validations for migrated accounting and purchasing vendors.
- Worked on all stages from analysis to GO LIVE, production support and knowledge transfer for new interfaces, for processing employee expense invoices. Maintained Organizational plan for interface Idocs error.
- Experience with AIF for monitoring and error processing of invoices. Monitored test case execution and progress via ALM (formerly HPQC). Scheduled program jobs variants via TIDAL for outbound reconciliation reports.
- Experience with procurement cycle from determination of requirements to payment procedures and order to cash cycle. Worked on Logistics Invoice Verification (LIV or GR-IR verification) in FI-MM (Procure to Pay) integration and configured account determination for FI-SD (Order to Cash) cycles.
- In Fixed Asset Management, Copied Reference Chart of Depreciation, Assigned Chart of Depreciation, Specify Number Assignment across Company Codes & Account Determination.
- Four Depreciation Areas created for Book Depreciation, Tax Depreciation, and Cost Depreciation, Management Depreciation. Created Chart of Depreciation and settings for asset company code. Made settings for GL accounts for AUC, gain/loss on asset disposal/retirement, for posting depreciation under different Depreciation Areas.
- As part of Confidential split (SMO) project, worked on co code make up for each company. Developed and tested custom tools and ABAP program used for cloning and cleansing of Purchase orders, open GR's and IR's (PO/non-PO) in SAP instances.
- Defined cutover strategy, automated test solutions, new cost center configuration and tested EDI and ERS outbound for correct suppliers.
Confidential, San Rafael, CA
SAP FICO Consultant
Environment: SAP ECC 6.0
Responsibilities:- Configured GL Master records, document number ranges, posting period variants, tolerance groups, reversal of documents, opening and closing of posting periods, field status groups, document types, posting keys, etc.
- Configured relevant settings for Treasury Cash Management position, liquidity forecast, risk management, integration of FI with SD and MM and cash concentration.
- Integration of FI with MM and SD modules included fine-tuning interfaces with FI, GL, A/P, and A/R and also validation and substitution rules, order management, pricing, delivery and transportation and billing.
- Part of team responsible for defining business process requirements and configuring the MM and IM modules in the areas of Purchasing/Procurement (direct and indirect purchase requisitions/purchase orders/contracts, release strategy with Workflow), Invoice Verification (vendor, invoice receipts), Material master, Inventory management.
- Pricing, output determination, Direct and indirect procurement, release strategy, Confirmations.
- Configured Inventory/Logistics: Material movements, GR, GI, Account determination, Advance shipping notifications, inbound deliveries, Outputs.
- Expert in GTS Configuration, Export /Import Compliance, SPL/Embargo, License Determination, classification, Customs Export, import process, trade Documentation.
- Worked on Export control and foreign trade data in Sales documents; Item specific Export Control, European Trade Statistics (INTRASTAT) and Extra European Trade Statistics (EXTRASTAT) reporting.
- Configured Invoice verification: invoices, credit memo, subsequent debit, and subsequent credit.
- Configured Maintaining Controlling Area, Assignment Of Company Codes and Control Indicators, Number Ranges, Standard Hierarchy Creation of Cost Centers and Cost Center groups, primary cost element, primary cost element groups revenue cost elements, secondary cost element Order Types and Number ranges for orders.
- Imputed costs calculation methods, cost element attributes, statistical key figures and activity types in Cost Center Accounting.
- Defined Assessment, Distribution, and Periodic Reposting of costs using cycle segment method in Cost Center Accounting.
- Created Profit Center standard hierarchy, dummy profit center, profit centers and profit center groups. Analysis using account assignment monitor.
- Costing variants for standard cost estimate for planned and actual Production orders
- Defined Settlement Structures and Allocation Structure in Internal orders.
- ALE and IDOC’s, Developed inbound and outbound interfaces using standard, custom IDOC’s and RFC technology. Enhanced standard IDOC’s, Building partner profiles, distribution model and configuring SAP workflows for IDOC’s.
- Worked on New GL Document Splitting configuration- Activate Document Splitting, Classify G/L accounts, Classify Document Types, Zero Balancing document splitting GL account, Document splitting characteristic for GL account, Define Document Splitting method, rules, Assign Document Splitting method and Define Business Transaction variants.
- Activated New GL and Leading Ledger with creation of segments and assigning scenarios and customer fields in the parallel ledgers.
- Involved in working with House Banks, Check Lots, Check Register, Correspondence and void of Checks in Accounts Payable (A/P) and configuration of new void and reversal reason codes for check reversal. Involved in modeling of invoice processing, Disbursement run, check printing and bank reconciliation processes for Account Payable (A/P).
- Designed the process of payment proposal approvals for different payment methods like ACH, Wire, Check and P-cards in Account Payable (A/P).
- Maintained Lockbox configuration with BAI2 format, cash management, planning levels in treasury and on Electronic bank statements (EBS).
Confidential, North Wales, PA
SAP FICO Consultant
Environment: SAP ECC 6.0
Responsibilities:- System configured and tested in the areas of FI-GL-transactions, Account payable (A/P) -paying vendor invoices, Account receivable (A/R)-customer credit, credit controls, applying cash, credit memo, dunning, Master data, CO-CCA-assessments/distribution, PCA-settings, hierarchy, account assignment objects, Product Costing with Cost Splitting Valuation - PA-structure, value fields, planning and reporting.
- Performed and resolved issues in Cost center assessments to segments, (CO-PA) reporting, forms, Planning, Derivation rules and structures, Product and customer hierarchy, PA settlement, realignments and integration issues with SD.
- In Cost Center Accounting Settings for Periodical Processing, Activity Based Costing (ABC), Order processing, maintain/ control Billing documents, Inventory management, Purchasing, Variant Configuration and complete design /configuration of general CO functionality (CCA).
- Setup Internal-Orders and Cost Collector configuration. Customized order classification establishing a sophisticated system of order settlements and cost center assessment cycles. Set-up planning profile for cost centers, activities and statistical key figures.
- The scope of CO included Product Costing and Profitability Analysis (CO-PA).
- Assisted client in design and configuration of PA transfer structures including decisions on characteristics, and settlement to (CO-PA).
- Technical work involved resolution of various issues in Product costing and Material Ledger.
- Created the characteristics and value fields, defined derivation structures and rules, maintained derivation table, and profitability segments used in profitability analysis. Defined various reports.
- Through knowledge in Defining Costing Sheet and calculating Overhead.
- Integrated Cost Object Controlling component in the SAP System, for planned budget using various costing methods, Cost Split, Cost and Valuation Variants in Product Cost Planning.
- Releasing Production Orders, Confirming Operations, Simultaneous Costing, final Costing, Price Transfer / Update, Confirmation/ Settlement, and Period-End closing.
- Developed IDOC’s for Sales Order, Purchase order , Invoice, and Advance Shipment Notification. Mapping of EDI and SAP documents. Produced customized segment types, IDOC’s types, extending IDOC’s , message types, function module, partner profile, port definition, user exit, and output determination.
- Developed program to create the IDOC ’s with related transfer Order that automatically updates a custom table with release date and time.
- Worked closely with Supply Chain Management (SCM) and Warehouse Management, involved with LIV, goods receipt, goods issue, inventory management (FI-A/R).
- Performed data extraction, transformation, migration and reconciliation of GL Master, Banks, Business Partner, Market Data, Treasury Deals and A/c Balances during Cut Over Phase
- In Tax accounting performed creation of Input and output tax General Ledger accounts, setting up different tax codes in various countries and assigning them to GL accounts. Resolving user queries in Tax posting journal entries.
- Configured for vendors subject to withholding tax, interest calculations on item balance interest calculation, number ranges for forms, interest on arrears, account balance calculation on account balances line items.
- Transactions - Incoming Invoices/Credit Memos (terms of payment), Outgoing Payment, Incoming Payment, Dunning, Open item Clearing, Down-payment received, Down-payment made, Bill of Exchange, Special G/L accounts (other reconciliation accounts).
- Analyzed end user needs and propose viable solutions for report improvement, QA and user training in CO. Generated reports using tools like Report Writer, Report Painter.
- Provided System configuration, testing to the global Finance user base in the areas of GL, Account payable (A/P), Account receivable (A/R), Fixed Assets, Special ledger, programs on the ECC 6.0 environment.
- Troubleshooting issues involved in analyzing problems, configuring, testing, training and documentation of fixes. Provided production support for FI and related Account receivable (A/R) and SD integration touch points with FI.
- Integrated Fixed Asset accounting with internal orders, maintained settlement profiles for internal orders, Configured capitalization of assets under construction, assigned cost elements.
- Involved in Integration of New general ledger with Controlling for reconciliation activity through real time integration variant.
Confidential, Houston, TX
SAP FICO Consultant
Environment; SAP ECC 6.0 Full Life Cycle Implementation
Responsibilities:- Worked in project preparation, business blueprint, and realization, final preparation to Go live & support using ASAP methodology.
- Defined Chart of Accounts, GL Master Records, Field status groups, Automatic account determination and Sales tax automatic account assignments.
- Configured FI-A/P and FI-A/R, Customer/ Vendor Master Records, Account groups, Tolerance groups, Document number ranges and account determination
- Defined Adjustment Account for GR/IR clearing by configured regrouping postings.
- Created Special ledgers for different types of special transactions.
- Involved in data migration from legacy systems to SAP through LSMW. Extracting Master data & transactions data to Non - R3 format, clean up data, mapping interfaces, loading data into SAP format (IDOC) and testing loaded data.
- Identified one time vendors and creation of one time vendors without duplicates.
- Created vendor master records, groups, vendor documents, number ranges, payment terms, discounts, Configured Automatic Payment Program.
- Configured and customized Account receivable (A/R) and Account payable (A/P) modules for vendors subject to withholding tax, interest calculations on item balance interest calculation, number ranges for forms, interest on arrears, account balance calculation on account balances / line items, foreign exchange calculations, automatic payment program, dunning program, credit management etc.
- Defined customer master records, customer groups, House bank.
- Designed, documented SAP (A/R) reports in coordination with ABAP developers for respective functional specs by creating libraries, report groups.
- Defined and assigned Reconciliation ledgers and maintaining accounts for automatic reconciliation posting.
- Worked with SAP (SD) functional team to ensure that account determination met all requirements.
- Involved in the configuration of Valuation areas, Multiple Currency types and number ranges, Movement type groups, Material update structure in the Material Ledger.
- Creation of Customer Account Groups, Billing, Payment terms and interest calculation, Incoming payments, Dunning, Account receivable (A/R) Information System, Credit Management, closing operations, sales order and Integration with SD and thereby improving the business process flow
- Asset Management (AM) implementation, configuring Asset classes, Master Depreciation and other business transactions. Fixed asset accounting, reconcile asset management to GL.
- Configured the chart of Depreciation and settings up the various depreciation areas like Book Depreciation.
- New General Ledger, Created of Chart of Accounts, Account groups, creation of new G/L accounts and Automatic account determination, Materials & SD postings.
- Configured the Chart of Depreciation Created procedural documentation for End users in Asset management (AM) module.
- Worked on Lockbox process configuration, bank statement processing, Cash management (CM) to monitor payment flows and liquidity and also worked on client’s lockbox banks to validate the inbound files.
Confidential, Chalfont, PA
SAP FICO Analyst
Environment: SAP ECC 6.0
Responsibilities:- Involved in all the phases of Global implementation from development of business blueprint to end user training and Go Live, designed As-IS & To Be diagrams.
- Configured the New GL, AP, In the SAP system as a FICO Analyst.
- Setup Fiscal Year Variant, GL Accounts Group, Field Status variant and Document number ranges.
- Configured New-GL-Segments, Scenarios and assigned Segments to Profit Centers Configured zero-Balance clearing Accounts for document splitting.
- Designed and configured Automatic Payment Program(APP) and Account payable (A/P) Master Data, Vendor group, Vendor Field Status, Creating Vendor and Customer Master Data and Risk Categories.
- Configured EBS, check deposits, check forms and wire transfer and ACH Payment
- Configuration of Tax codes and tax Jurisdiction codes for the USA.
- Extensively involved in Implantation & support Project of CCA, PCA, COPA.
- Configured Controlling Area, assigned number ranges to controlling area, and maintained Versions.
- Created Standard hierarchy of Cost Center Accounting (CCA) and Cost center groups.
- Configured Activities types and Statistical Key Figures & assigned cost centers to cost elements & developed Allocation cycle for Assessment & Distribution.
- Configured EC-PCA by creating profit centers, standard hierarchies, assigned revenue elements, to profit center, planning profile and planning layouts.
- Developed contribution margin and user defined COPA profitability reports using report painter
- Configured the value flow from SD to COPA and also from FI, MM to COPA.
- Configuration of Product Cost Planning and Cost Object Controlling, Material Cost estimate with Quantity Structure which included costing variant, valuation variant, cost component split, costing sheets, cost component structure, BOM and routing settings, origin groups, overhead keys, and overhead groups. Configured Actual Costing/Material ledger.
- Performed Functional Testing for their new unit and designed the Custom Entities in Quality Centre as per the user requirement.
- Expertise in Integration, Functional, Regression, User Acceptance Testing, Performance and End-To-End Testing, Good Knowledge of SDLC, Testing Methodologies.
- Participated in testing using Solution Manager.
