We provide IT Staff Augmentation Services!

It Finance Support Analyst Resume

Palo Alto, CA

Executive Summary
18+ years experience with Oracle.
6years experience with Oracle Applications - Performing functional and technical work with main modules such as GL, AR, AP, FA, CM, PO, OM, iExpense and iProcurement.
Functional responsibilities: business process analysis, requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, interfacing with users, training end users and production support.
Technical responsibilities: identifying technical gaps, estimating work, architecting system interactions, designing custom solutions, programming, scheduling, producing documentation and providing production support.

Technical Skills

  • ERP : Oracle Applications 11i.5.10.2 and R12.
  • ERP Functional Modules : GL, AR, AP, FA, CM, PO, OM, SLA, iExpense & AOL.
  • Oracle tools : Oracle Developer Reports/Forms 6i, BI/XML Publisher 5.6.3, Web ADI, FSG and Discoverer.
  • Databases : Oracle database 8i/9i, MS Access
  • Tools/Utilities : TOAD
  • Support Applications: BMC, Helpzilla.
  • Languages : SQL, PL/SQL, SQL*LOADER.
  • Operating Systems : Windows NT/2k, UNIX
  • Other tools : MS Excel, MS Word, Visio

Experience Details:
Apr 2011- IT Finance Support Analyst Confidential, Palo Alto, CA
Environment: Oracle Applications 11i.5.10.2 iExpense, iProcurement, Workflow, AR, APand PO

  • Analyzing issues related to the financial modules mainly in P2P, GL and AR resolving and testing.
  • Work with offshore team on interface support.
  • Monitoring support systems and coordinate with the business users.
  • Directing developers on coding and resolving any PL/SQL updates.
  • Handle Discoverer's reports issue mainly in GL reports like Trail-Balance.

May 09- Sep 10 Oracle Functional Conslt. Confidential, Dubai, UAE
Environment: Oracle Applications R12.1.2 GL, AR, AP, CM, FA, AME and SLA

  • Configured AP setups such as financial/payables options, payment terms, suppliers, suppliers site, bank accounts for the supplier, invoice holds and releases etc.
  • Validated Setup steps for Purchasing like Financial, Purchasing and Receiving Option, Definition of approval group/ assignments, setting up the approval hierarchy etc.
  • Delivers AME based Approval mechanism for Buyer Approval workflows for Procurement, and configure HR hierarchies and DFFs to fit custom approval design
  • Created payment template through payment manager.
  • Configured AR System options, Transaction types, Payment terms, Auto Accounting setups as per Business need. Conducted Business Owners meeting to finalize functional setups involved in AR Module.
  • Involved with GL workshop to analyze, define and implement the Multi-Org and COA structure.
  • Defined Auto Accounting rules and involved in import of invoices into AR using Auto Invoice.
  • Defined transaction types and sources for Receivables module
  • Implemented Cash Management Module - Defined setups such as System Parameters, Bank Account, Bank Statement Interface Configuration and Auto-Reconciliation.
  • Involved with FA setup like KFF, Categories, and Asset Books.
  • Extensive involved in Post-Production support and assisted day to day business activities.

Dec '07 - Feb 09Sr. Oracle Developer Confidential, Torrance CA
Environment: Oracle Applications OM, GL, AR, PO, AP,AOL, PL/SQL, TOAD9, Forms6i, Report 6i, SQL*LOADER, BI/XML Publisher Reports.

  • Developed custom package "HL Global GL Listing Wrapper" to generate custom GL report in Excel/PDF format using Oracle Reports builder6i and XML Publisher.
  • Generating Distributor's Letters in Multilanguage using Oracle XML Publisher, prepared a PL/SQL package to generate the canonical XML data format, assign the right layout, submit the letters and handle error processing letters via printer, FTP and Email the letters as their destination after decommissioning the legacy system..
  • Developed PL/SQL Script to validate order records in OM Interface tables and run Order import program.
  • Imported the customer, Invoices and Receipts into the AR from legacy systems
  • Defined concurrent programs, concurrent program executable, concurrent programs to associated request groups and Request sets.
  • Personalized Receive Transactions form to print "HL Print Manual Invoice".
  • Day to day troubleshooting using support applications to process helpdesk tickets from users to production instance such as SupportMagic, CMR and BMC.
  • Raise several Tars for unresolved issues.

Nov '06 - Sep '07Data Analyst Confidential, Hayward CA.
Environment: Oracle Applications Order Management, Inventory, Accounts receivable, AOL, PL/SQL, TOAD9, Forms6i, Report 6i, SQL*LOADER.

  • Performed AutoLock Box processes, designed the Transmission Format and debugged related issues.
  • Performed Accounts Receivable functional setups such as Customers, Banks, Receipts Classes, Payment Methods, and Lockbox.
  • Developed PL/SQL procedure to validate and adjust data format.
  • Prepared script for Sqlloader control file.
  • Customized through Custom.pll.in Order Organizer (OEXOEORD), Sales Order Screen and E-Business center Zoom button to pop up a form and get additional data for End User and pass the End_Order_no as a parameter.
  • Customized Invoice print batch of invoices, Receivables Aging report.
  • Worked on custom Pack Slip report to resolve issues of duplicate records.
  • Customized the Sales Acknowledgment report, which was not displaying the correct order amount.
  • Developed control file script for SQL*Loader script to import Order records from legacy system.
  • Modified Defaulting Rules as per business requirement.
  • Created a new custom Discoverer report to display the Sales order information.
  • Imported AR Invoices from the Legacy System using SQL*Loader and developed PL/SQL script to validate AR Interface table records.
  • Conducted business owner meetings to finalize the required information from the old data and the setups needed for Accounts Receivable.

Sep'92 - Oct '06Sr. Oracle Developer Confidential
Environment: (Oracle 8i/9i) PL/SQL Procedures, Functions, Triggers and Data Base Triggers, Forms 2000 and Reports 2000.

  • Created new Finance Management System FMS package using Developer6i Form & Report in client/server on Oracle 8i/9i databases. Gathered requirements, Designed, implemented and tested security control in various database levels, application and fine grain access control.
  • Participated FMS data modeling, prototype design, document preparation; created form templates, object libraries and generic package/stored procedures for standardization of the FMS application.
  • Developed stored procedure based forms to integrate with legacy system.
  • Designed, created or modified payroll, benefit and human resource applications using SQL-PL/SQL languages Oracle database and Developer.
  • Modified and trouble-shooting inventory and process control system with Oracle Developer 6i.
  • Installed Oracle 9i and configured Developer on client stations.
  • Participated architecture design and migration of enterprise wide multi-tier system with different version of Oracle server back-end.
  • Tuned and optimized current and new applications utilizing SQL Trace utility and DBMS package, and enhancing performance through regeneration and rebuilding of indexes and creation of views.
  • Assisted Senior DBA with configuring Oracle Name server, load balance and fine-tuning production database parameters and providing assistance for database related errors from individual Clients. Also cooperating with DBAs and production personnel for annual database purge and rollover.
  • Created and implemented ad hoc reports using SQL for various users in different environments.

Educational Qualifications:
Master's Degree. M.Sc Computer Science

Hire Now