We provide IT Staff Augmentation Services!

Sr.it Applications Analyst/dev Resume

4.00 Rating

Houston, TX

SUMMARY

  • SAP FI/CO Functional Consultant wif 8 +years of functional experience in Financial Accounting (FI) and Controlling (CO) modules and integration wif logistics modules (SD and MM).
  • Three full life cycle implementation experiences wif ASAP methodology, proficient in interacting wif business users to identify information need and initiate process change and expertise in business process engineering.
  • Solid experience in gathering business requirements, blueprinting, mapping business requirements to SAP environment, realization, final preparation, data migration, cut over planning, go live and supporting.
  • Worked wif AP & AR team to configure automatic payment program, Electronic Fund transfer (EFT).
  • Configure 3 way match for logistic Invoice verification invoice, direct invoices, set up tolerance for line items invoice amount limit, EDI vendor setup, maintenance GR/IR clearance, setup block invoices and release invoices, Lock Box, EDI payment, processed IDoc files for inbound & outbound interfaces
  • Developed interface to create Outbound IDoc for EFT Payment notification. The details of the payments made to SDAs using EFT have to be sent to the SDA via Email. The transfer to the repository would be through IDOCS - FI
  • Treasury: Lockbox configuration, treasury groupings, bank statement processing, risk management, cash management posting rules, exchange rates, planning, integration wif MM and SD.
  • Cash Management and Bank Accounting: House Banks, Bills of Exchange, Manual & Electronic Bank Statement, Lockbox Processing, Exchange Rates, and Translation Ratios.
  • SAP - Finance, Banking and all bank related Interfaces such Electronic Bank Statement (EBS), Payment files (PMW), DMEE, Cash & Liquidity Management(CLM) and Bank Communication Management(BCM),
  • Experience in configuration of Automatic Payment Run, Banks accounting, Foreign Currency valuation and Electronic Bank Statement (EBS), Lockbox configuration, Lockbox Processing and testing the lockbox functionality.
  • Resourceful problem solver wif an excellent ability to understand the shortcomings of SAP business processes, capture justified user requirements, and manage these through to completion wifin a structured development cycle.
  • Hand on configuration experience on EDI Program setting, IDoc structures and mapping for varied external portals
  • Configured Customer Hierarchies, Agreements, Customer Rebates, Purchase Rebates and Customer Master Maintenance as this related to the chargeback process common wifin this industry
  • Integration of FI wif MM and SD wif Procure to Pay and Order to cash Cycles
  • Financial Accounting expertise in Configuring General Ledger Accounting (FI-G/L), New G/L, Accounts Payable (FI-AP), Accounts Receivable (FI-AR), Asset accounting (FI-AA), and Treasury-Cash Management (TR-CM).
  • Excellent in working wif posting validations, substitution rules, forms, interfaces (ALE & EDI), user-exits, and reporting tools
  • Experience wif Third Party Credit Card Authorization/Settlement - Pay metrics
  • Worked on different aspects of FI Transactions such as Inter Company Transactions, Reconciliation Accounts, Partial and Residual Payments, Credit Memos/ Dunning and Clearing Inter-company Vendor/Customer Open Items.
  • Maintained Automatic Account Determination for MM & SD Modules
  • Controlling experience includes Cost element Accounting (CO-CEA), Cost Center Accounting (CO-CCA), Internal Orders (CO-IO), Product Costing (PC), Profitability Analysis (CO-PA)
  • Hands on experience in configuring Cost Elements (CO-CEA), Cost Centers (CO-CCA) and Cost Element Categories and configuring Assessment and Distribution cycles.
  • Sound knowledge in migration from GL to New GL right from creation of blue print for new GL to the customization of document splitting, allocation, planning, Zero Balancing of documents.
  • Configuration of output tax, input tax & wifholding (WHT) tax requirements in accordance wif local and US tax laws.
  • Experience in Product Costing, Cost Controlling, COPA and PS
  • Sound knowledge in validations of SOX, GMP, GXP and FDA regulated environments.
  • Experience in Unit, Integrating and User Acceptance Testing and knowledge of Report Painter, Report Writer.
  • Undergone corporate training on people skills such as Decision-Making, General Management, Team Building and Negotiations. Excellent communication and interpersonal skills wif problem solving abilities, TEMPeffective in working independently and an exceptional team player.

TECHNICAL SKILLS

FI: GL, A/R, A/P, Fixed Assets, Special Purpose ledger, Bank accounting Lock-Box, Cash Journal, XML, PMW, SEPA, APP, FSCM, In house cash, BRF+

CO: CEA, CCA, IO, CO-PA, CO- PC, PCA, OM

Treasury: Cash Budget Management, Market Risk Management, Cash Management

Reporting: Report Painter & Report Writer, Hyperion Report, Planning & Analyzer

Integration: FICO integration wif MM, SD

Tools: ASAP Methodology / Remedy, Load runner, Quick Test Professional, Redwood Cronacle, OCR, Tapfin, VIM, Kintana request, HPQC, HP service manager, share point, Solution Manger, Visio

Other Skills ERP: SAP R/3 Versions, 4.5B, 4.6B, 4.6C, 4.7, ECC 5.0, ECC 6.0

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr.IT Applications Analyst/Dev

Responsibilities:

  • Involved in the analysis of AS-IS business - To-Be process, gap analysis and finalizing the Business Blueprint.
  • Implemented Payment Medium Workbench (PMW) - Maintained payment medium formats, maintain variants for payment medium, reserve identification for cross payment run payment medium
  • Implement SEPA payment type for entire Europe zone.
  • ActivatedBank Communication Management (BCM) in switch framework and performed configurations relevant to BCM - Payment grouping, payment status management and Bank statement monitor
  • Implemented Bank chain functionality for intermediary banks.
  • Prepared end user process flows wif Bank communication management (BCM)
  • Documented BCM user manual for end user training purposes
  • Worked on bank interface.
  • Worked on Interfaces and solving IDOC errors
  • Worked wif Paymetrics - processing manual credit card process (Initiate manual credit card charge, Open Accounts receivable items - Clear customer open item using credit card, Worked wif Xipay system wif Paymetric, Test authorized transactions using Xipay system, initiate settlement process.
  • Expertise in lockbox file format and lockbox processing, manual bankstatement and EBS processing
  • Create positive pay file for Bank and bank reconciliation file for check clearing, monitoring & process inbound and outbound IDoc files for various interface programs
  • Setting up of down payment methods, payment files and advices throughchange in SAP scripts
  • Configuration and creation of house banks, bank accounts andassignment of these accounts to a check lot. Configured automatic payment program for out-going payments in Accounts Payable (AP)
  • Worked on writing the functional specifications for RICEF objects
  • Worked in new enhancements and fixing bugs reported in existing enhancement wif the help of technical team
  • Payment automation for different Country; Company Codes and Banks
  • Implement BRF+ for Tax code solution on the base of business requirement
  • Configured decision table in BRF+
  • Configured business rule in BRF+
  • Implemented web base Vendor portal service to view invoice status for external vendors,
  • Implement automation payment feed file process wif Tango.
  • Created custom report related Tax accrual process, which TEMPhas all the necessary information as per business requirement.
  • Closely working wif Production Scheduling Team for fixing reported issues wif schedules in Cronacle system in relation wif SAP FI/CO Jobs
  • Involved in Month End Close activities as well as year-end activities
  • Direct communication wif user as a part of monitoring Finance Functional Mail Box for any requests/queries related to the function
  • Major Configuration points include configuration of Fixed Asset Classes, Master data, Addition, retirement., transfer and other business transactions
  • Worked on day to day support issues for clearing tickets.
  • Coordinate wif basis team and ABAP team regarding OSS, Transports and user authorizations.
  • Ensuring dat offshore team resources are properly loaded, help them in solving tickets where required and ascertain dat the tickets are resolved well wifin the stipulated SLA timelines set.
  • Configured payment terms, over-due interest calculations, cashdiscounts and automatic clearing of line items
  • Worked on logistics invoice verification (LIV). Starting wif Purchase Requisition, Purchase Order, Goods Receipt, InvoiceVerification, Vendor Payment and Check clearing sub-processes.

Confidential, IL

SAP FICO Consultant

Responsibilities:

  • Configured lockbox, generated bank advices and account posting. Imported and lockboxes at house bank and configured control parameters and posting data. Configured G/L account structure for each bank account. Configured electronic bank statement and worked wif different file formats (Multi-cash and BAI).
  • Worked on EBS, Positive pay, ACH payments and Wire Transfer, liquidity forecast and configuring and customizing multiple payment methods and automatic clearing.
  • Solved problems on Invoice, Cash Application, Lockbox, Electronic Payments and Automatic Customer Payment, clearing programs, Settlement, Adjustments, Credit Management and Banking integration
  • Configuring the XML file using the SAP tool Payment Media Workbench
  • Creating the Company Mandate text to be signed by the customer (Smart Forms)
  • Generating IBAN codes automatically
  • Customizing of house banks and payment methods
  • Creation of payment media formats (DMEE)
  • Configuration and creation of house banks, bank accounts and assignment of these accounts to a check lot. Configured automatic payment program for out-going payments in AP, payment terms, over-due interest calculations, cash discounts and automatic clearing of line items.
  • Implemented customization in the areas of AP-payment program, AR-credit control, dunning, customer master data, retained earning account assignment, employee tolerance, customer tolerance limits.
  • Setting up the Mandate management for the Direct Debit payment Method (by country)
  • Maintenance and adaption of forms of financial accounting
  • Customizing of special dunning procedures
  • Split print of dunning letters by SAP script and Smart forms
  • Design of a uniform solution for sending payment advices, dunning letters, balance confirmations and correspondence via email and fax
  • Adjustment of field status groups.
  • Uploaded master data records of customers from the legacy ERP system into SAP through LSMW and ensured dat bank and correspondence data is created for all customers.
  • Written Functional Spec’s for all RICEFW (Reports, Interfaces, Conversions, Enhancements, Forms, Workflow) objects.
  • Implemented a Custom process wif the help of IDOC Functionality, which enables the successful processing of data files even though there are errors at line item level.
  • Extensively involved in developing RICEFs (Reports, Interfaces, Conversions, Enhancements and Forms).
  • Worked on Project Systems PS like WBS, Assets etc.
  • Involved wif PS team for integration to FI
  • Configured and Customized FICO modules including General Ledger, Asset Management and Special Purpose Ledger For the Global Roll out Project.
  • Developed Blueprint documents for Demand planning, Distribution requirement planning, Deployment and Master production scheduling.
  • Worked as SAP consultant Full Lifecycle Implementation using the ASAP methodology in the organization.
  • Understanding the clients business as a whole, anticipate its needs and clarify its expectations. Prioritize tasks.
  • Identify implications of proposed solutions on people, processes, strategy, finance etc.
  • Responsible for FICO module. Team lead for Accounts Receivable (AR), Accounts Payable (AP), GL accounting Asset Accounting (AA/ FA/AM).
  • Responsible for customization of the organization structure, client interaction, user training, process and transaction testing.

Confidential, MN

Sr.SAP FICO Lead Consultant

Responsibilities:

  • Expertise in lockbox file format and lockbox processing, manual bankstatement and EBS processing
  • Create positive pay file for Bank and bank reconciliation file for check clearing, monitoring & process inbound and outbound IDoc files for various interface programs
  • Worked on EBS, Positive pay, ACH payments using NACHA file formats, and Wire Transfer.
  • Configured automatic payment program (FBZP) for outgoing payments, which included payment methods, bank accounts and ranking order of bank accounts, and automatic account determination using FBKP.
  • Created check lots, voided checks for payment blockage, and reissue of destroyed checks.
  • Extensively exposed to integration issues of FI wif MM and SD
  • To have the deepest level of application or product understanding.
  • Configured house banks, bank accounts, reason codes, check lots and lockboxes for payments.
  • Worked wif Center of excellence team to help them in replacement of third party vendor i.eTravelex as a part of budget control
  • Developed custom report for business to tie intercompany accounts payable and accounts receivable transactions
  • Resolved intercompany markup issues
  • Able to understand both the standard application features (i.e. out of the box functionality) as well as the detailed components of the customized features.
  • Responsible for making changes, migrating them, completing the ticket and communicating the change to the level 2 support person, who can then resolve and close the call.
  • Co-ordination of problem tickets wif offshore resources (functional as well as technical) to ensure dat the tickets are resolved wifin the stipulated SLAs.
  • Created Trading Partner validation rules for intercompany postings
  • Worked on Accounts Payable workflow to have automated approval process
  • Configured the system to show Purchase price variance and markup separately for (CAS Compliance) government reporting.
  • Configured structures for Tax Jurisdiction codes, calculation procedures, message control and field control for Tax amounts.
  • Worked wif Technical team on data archiving of AP Invoices
  • Developed custom program to users to upload journal entries to SAP system as parked or Post documents based on roles
  • Developed custom program to transfer labor hours (LATS and CATS) Production orders, WBS and Shop orders.
  • Configured the posting blocks for the parked documents
  • Worked on maintenance of Factory/ Holiday Calendars.
  • Created user-exits and routines wif help of developer for intercompany markup values in Purchase orders
  • Worked on the user and supervisor roles and authorization wif BASIS team.

Confidential, Kansas City, MO

SAP FICO Lead Consultant

Responsibilities:

  • Involved wif all phases of implementation from development of business blueprint, conducting workshops, GAP Analysis, and configured the system for implementation of Cost center Accounting, Profit center Accounting, Profitability Analysis, Product Costing.
  • The project involved detailed study of the entire accounting operations, studying the current business process, organization structure finalizing and mapping & configuring of to-be Business process and providing necessary support.
  • Configured and customized Chart of accounts, Company code Global Parameters, Fiscal year Variants, Posting Period Variants, Account Groups, Field Status Groups, and Tolerance Groups.
  • Configuration and creation of house banks, bank accounts and assignment of these accounts to a check lot. Configured automatic payment program for out-going payments in AP, payment terms, over-due interest calculations, cash discounts and automatic clearing of line items.
  • Configured Product cost using Production Planning cost collector.
  • Assigned Number Ranges for Documents, Vendors and Customers, reconciliation Accounts for Vendors and Customers.
  • Made settings for GL accounts for AUC,Loss/gain on asset disposal/retirement, and posting depreciation under different Depreciation Areas.
  • Worked on different Consolidation (ECCS) levels like Statutory Consolidation, Business Area Consolidation and Profit Centre Consolidation.
  • Maintained the budget profiles and tolerance limit for the availability control, defined the Project coding mask, by creating the project file and status profile in Project Systems (PS).
  • Configured credit control area, cost elements, cost centers, profit centers, costing based COPA, account based COPA, created characteristic and value fields, and configured valuation-using product costing sheet.
  • Configured Customer Hierarchies, Rebates, and Customer Master Maintenance as this related to the chargeback process common wifin this industry
  • Configured system settings for integration of PS module wif IM, FI, CO and MM modules.
  • Tested the status profile to examine the user status assigned to the project and the WBS element and recommended users accordingly to activate the time dependency for system status in IMG to ensure dat all status confirms wif the WBS elements are logged.
  • Extensively worked on cost estimate updates, costing run in Product Costing, implemented Cost Estimate wif Quantity Structure and Configured Costing Variants for Base Planning Object, standard cost estimate and current cost estimate.
  • Defined Costing Type, Valuation Variant, Date Control, Quantity Structure Control, and Transfer Strategy for the costing variants in Product Costing.
  • Configured Costing Variants for Preliminary Costing in Cost Object Controlling,
  • Maintained overhead cost elements, defined costing sheets, allocations and settlements in CO.
  • Sound knowledge in foreign currency revaluation, individual value adjustment and flat rate individual value adjustment.
  • Responsible for carrying out Valuation in COPA planning to access pricing and product cost information for products having planned quantities, thereby allowing projected revenue and cost-of-sales figures to be calculated automatically.
  • Defined internal order types, planning and settlement profile and created standard hierarchy, dummy profit center, distribution and assessments in CO-PCA.
  • Maintained number ranges for settlement and controlling documents, and for variance documents, used report painter and report writer.
  • Worked wif multiple currencies, US taxes and sales taxes, Maintained tax codes and tax jurisdiction codes for company codes.
  • Created Lock box, Bank Master Data, House banks, G/L accounts for each bank account and Reconciliation accounts for vendors, customers and assets.
  • Worked on EBS, Positive pay, ACH payments using NACHA file formats, and Wire Transfer.
  • Configured automatic payment program (FBZP) for outgoing payments, which included payment methods, bank accounts and ranking order of bank accounts, and automatic account determination using FBKP.
  • Created check lots, voided checks for payment blockage, and reissue of destroyed checks.
  • Expertise in LSMW for data migration from Legacy system to SAP system.
  • Enhancements to existing Validations and Substitutions for FI module.
  • Proficiency in writing Functional Specs for all RICEFW (Reports, Interfaces, Conversions, Enhancements, Forms, Workflow) objects.
  • Designed and configured Asset Management to carry out business transactions like acquisitions, retirement, transfers, depreciation calculation, write-offs and post capitalization.
  • Integration of MM and SD wif FI accounts assignment and appropriation request, investment measure in Investment Management.
  • Prepared the Cutover plan and carried out cutover tasks as per schedule and frequent meetings for discussion of issues, new requirement and fixing bugs.

Confidential

SAP FICO Consultant

Responsibilities:

  • Involved in Full Life Cycle Implementation of the project including blue-print preparation, Data migration, configuration, end-user training, and go-live phases.
  • Experience implementing and configuring (hand-on) SAP FICO including organizational structure, master data, intercompany processing, foreign currency valuation and integration wif tax.
  • Followed ASAP methodology in implementing the project, involved in test phases i.e. unit testing, integration testing.
  • Developed functional and technical specification for development objects (RICEFW) and experience in transferring G/L accounts using LSMW and modified data wif addition of payment terms and interest calculation.
  • Configuration of FI global settings, configured company code, created GL accounts, defined posting keys, maintained field status variants and assigned to company code, screen variants for document entry as per business specifications and tested the configuration in various scenarios.
  • Configured the settings in GL area, such as creating G/L master data, open item clearing and configured customer account groups, terms of payment, tolerance limits for customer payments, special GL indicators, dunning, and down payments.
  • Configured and customized Special Purpose Ledgers by designing the structure, defining the tables, created the Master data of ledgers, activities and Field Movements.
  • Configured Customer credit limits, accounting clerks, defining of initial credit limits for customers and provided business process design in the areas of FSCM.
  • Created account assignment models for recurring entries and defined specifications for preparing balance sheets at periodic intervals, account balances, creation of reserve for bad debts and other provisions, for business area balance.
  • Configured payment terms, Over-due interest calculations, Cash discount, Automatic clearing of line items, Multi currency configuration and Tax ware.
  • Expertise in financial consolidation and planning technical solution experience wif SAP ECCS and setting up of own payment methods, payment files and advices through change in SAP scripts.
  • Configured chart of depreciation, depreciation areas, asset classes, asset class account determination, calculation keys, depreciation keys and transaction types.
  • Experience in Process Asset Acquisition- Down payment on Asset under construction, Direct Acquisition of Internal Activity, Subsequent Acquisition and Post capitalization, Asset retirement, Mass asset retirement, Transfer wifin company code, Inter company code transfer settlement of asset under construction (AUC).
  • Configured complete Bank Accounting sub module including House Banks, Lockbox, Bank chains, Electronic bank statements (EBS), Bank keys, Automatic payment run for check and wire transfer.
  • Created and assigned business transactions for Manual Bank statement, defined posting keys and created business transactions for Check deposit.
  • Configured and Customized Treasury module including Cash Management including Bank statements, Payment Programming, Payment Advises, Liquidity Forecasts, cash budgeting.
  • Experience in solving the production issues in Automatic Payment Program (APP), Account Assignment, and interest calculation on open items, foreign currency valuation, regrouping of line items, check management and void reason codes.
  • Experience in FSCM like Collection management and Dispute management.
  • Assisted in maintaining Cost center category (CO-CCA) and defined cost center hierarchy.
  • Configured Profit Center Accounting, Cost Center Accounting by creation Standard Cost Center Hierarchy using CATTs, Alternative Hierarchy, primary and secondary cost elements.
  • Worked on inter-company clearing, recurring entries and configured settings for assessments and distributions.
  • Worked on Project Settlement profile and customized Result Analysis as input to Project Settlement.
  • Unit Testing: Complete Unit testing of FI-GL, FI-AP, FI-AA and Integration Testing - Complete business cycles across sub-modules were tested, in conjunction wif the users and Core Team representatives from the client side.
  • Maintained tax codes and tax jurisdiction codes for US and Canada company codes.
  • Experience in filing financial statements in 10k & 10Q format wif related SEC standard.
  • Worked on month-end, year-end closing procedures and generated reports using report painter and report writer.
  • Participated in the Analysis and Design meetings for the Requirements.
  • Attended training sessions, and practice sessions to cope the organization.
  • Maintained Company Codes & Company Code Global Parameters.
  • Configured additional House Banks, Bank Accounts, and Check Lots.
  • Defined Reason codes for the payment differences and worked on writing off thesedifferences to GL accounts.
  • Configured Posting Keys, Number Ranges & Document Types.
  • Maintained the Operating Chart of Accounts by adding GL accounts as per the client’s requirements.
  • Customized the Financial Statement Versions and assigned it to the Chart of Accounts
  • Created Master Records including General Ledger, Vendor Master Record, and Customer Master Record etc.
  • Created Cost centers, Profit centers and completed the account assignment for the cost objects.

We'd love your feedback!