We provide IT Staff Augmentation Services!

Senior Application Analyst Resume

3.00/5 (Submit Your Rating)

Atlanta, GA

Objective
A position that would allow me to utilize my expertise, in an environment that encourages on-going skills development and growth.

Professional Summary

  • 8 years of strong experience working as Oracle Applications Techno – Functional consultant in Purchasing , INV, OE/OM, iPay, ALERTS, AOL, iExpense, Fixed Asset, SYSADMIN,AME, AR, AP, GL modules of Oracle Applications.
  • Experience in Implementation, Production Support, System Maintenance and Version Upgrade.
  • Expertise in Procure To Pay, Order To Cash and Oracle Financial Modules.
  • Expertise in implementing multiple projects as a Functional and Technical.
  • Experience in Team Lead, Solution Architecture using Oracle Application Implementation Methodology (AIM) and SDLC methodology.
  • Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self motivated to work independently with excellent communication skills.

Technical Skills
Oracle Apps: Oracle 9i, 11i (11.5.10.0/11.5.10.2),Oracle Purchasing, AME, Oracle Financials (General Ledger, Account Payables, Account Receivables), Order Management ,Inventory, iPayment, Sys Admin, Fixed Asset and AOL.
Oracle Tools: XML Publisher, OAF, Reports 6i, SQL*Loader, Forms 6i, Toad.
Database: Oracle 10g/9i.
Languages: SQL, PL/SQL
Operating Systems: SUN SOLARIS, HP-UNIX.

Professional Experience

Confidential,Atlanta, GA March 2008 to Till Date
Senior Application Analyst
Confidential,pioneering in providing Push-To-Talk .It provides service to the utility and government sector.

Responsibilities: Involved extensively in functional and technical gap analysis, created functional and technical documents, responsible for providing functional and technical post production support, handled System Administration functions, involved extensively in System Integration Testing, UAT before production move and as part of technical deliverables created pl/sql packages, workflow, personalized/customized forms, created reports ,defined AOL objects.
Purchasing Implementation: This project involved implementing Procure to Pay cycle for expense and capital inventory items. It also involved interfacing capital item to FA.

  • Performed Functional Setup in Purchasing, Inventory and Payables modules.
  • Customized and defined the rules for PO Approval workflow around approval hierarchy.
  • Implemented AME for Payables Invoice Approval and headed AP Initiative with Purchasing.
  • Customized pl/sql package to customize PO number sequence, added GL location segment to inventory location.
  • Modified PO report and created various custom reports.
  • Set up Inventory Org, item.

OM- E Comm Integration : Implemented iPayment to accept credit card order from Order Management, Oracle HTML Quoting and external e-commerce system.

  • Interfaced external e-commerce order to OM using API.
  • Interfaced Shipping details for external orders.
  • Integrated iPayment to BEP.
  • Defined Order Type, Payment Method, Receipt Class, Receivables Activity and set up Automatic Receipt and Remittance creation process.
  • Created pl/sql packages and functions.

Inventory: Created Interface to upload ASN information for serialized item.
Write-Off : Involved clubbing of multiple open Invoices / customer and creating one Write-Off CM per customer, in this process all the revenue lines where accounted under bad debt account and all the tax lines where reversed to original account. CM was pro-rated if their where any partial payments made and adjusted accordingly if any adjustment was applied (line or tax).

  • Assigned collectors to costumers, customer percentage share and collector fee was derived from DFF setup in Collector screen.
  • Created multiple reports using XML publisher.

Lockbox Process : Set up Lockbox Processes to import Payment from bank , defined and setup file format, Receipt Source, Lockboxes and Transmission format,
Employee Expense Payout: Involved paying employees expense using Direct Deposit.

  • Migrated employee details from legacy system and created supplier using API.
  • Created Bank payment files using XML Publisher.
  • Overall Status Reporting, Issue Resolution and handling of escalations.

E911: Involved remitting charges to the state for availing 911 facility, payment was calculated on the number of subscribers per state.

  • Mapped Supplier to the geo-code on the commtax report.
  • Interfaced, validated and created invoices.
  • Defined Source, Payment Term, Paygroup, DFF on Invoice Distribution.

FA – CATS: Involved synchronizing assets location in CATS with FA location.

  • Mapped asset location and expense distribution based on the CATS location using API.
  • Created Exception report for retired, suspended and fully retired assets.

FA – Use Tax (Capital Item Tax): Creates Use Tax Journal Entries and uploads to FA.

  • Customized “Create Use Tax” to pass asset and invoice distribution info.
  • Processed Use Tax Journal entries in GL and created Use Tax Addition entry in FA, which created post addition line.
  • Defined Value Set , DFF.

Generated ad-hoc queries to analyze underlying data for inconsistencies and integrity issues to find data issues.
CU2 Upgrade: Team Lead for CU2 Upgrade team and functional and technical lead for AR, iPay, Purchasing and OM modules.

Technical Environment: Oracle Apps 11.5.10.0/11.5.10.2 (AR, Oracle Alert, iPayment, AP, GL, Inventory, FA, Purchasing), XML Publisher, OAF, Oracle 9i, Oracle Forms 6i, Oracle Reports 6i, PL/SQL, SQL Loader, TOAD.

Confidential, Atlanta, GA July 2007 to March 2008

Responsibilities: Involved extensively in functional and technical gap analysis, created functional and technical documents, responsible for providing functional and technical post production support, involved extensively in System Integration Testing, UAT before production move and as part of technical deliverables created pl/sql packages, workflow, personalized/customized forms, created reports ,defined AOL objects

  • Designed and Implemented Lockbox Process to receive bank payment file.
  • Development, configuration, and testing of interfaces from external system to Oracle for Order Management (OM/ONT) and Shipping Execution (WSH).
  • Set up AR Batch Source, Transaction Type, and Receivable Activities for the creation of invoices from legacy system.
  • Customer Creation: Designed and Implemented process to create customers using oracle seeded API.
  • Customized Oracle Seeded Workflow (i.e. iExpense & Po Approval) to implement Company Business Logic (i.e. Level of Approval, Third Party Expense Approval, Timeout Feature)
  • Created PL/SQL packages and respective Concurrent Programs for:
  • Creating JTF NOTE for Customer Merge Process in E Business Center.
  • Customer Specific Price Increase based on specific customer criteria.
  • Web_Util file of Customer Extract for SQL Server.
  • Created Ad-Hoc reports and Customized Oracle and PL/SQL reports in various oracle modules i.e. AR, AP, Pricing and Route Management.
  • WEBOP: Created JSP pages for Customer WEB Order Application (WEB OP) using Oracle iSupport Framework.
  • Developed Oracle Forms i.e. WEB Item Form and Standard Load Form.
  • Additional Responsibilities included fine Tuning, Creation of Design Document (MD070), Third Level Customer Support and coordinating with DBA for Production move.

Technical Environment: Oracle Apps 11.5.10.2 (AR, AP, GL, Inventory, OM, PO,FA), Oracle 10g, Oracle Forms 6i, Oracle Reports 6i, PL/SQL, SQL Loader, TOAD, iSupport Framework.

Soft Skills

  • Excellent communication, presentation, and negotiation skills.
  • Good problem solver and team player.
  • Ability to work concurrently in multiple projects.
  • Innovative, creative, and affinity to learn and leverage new technologies.

Educational:
Bachelor of Engineering (BE)

We'd love your feedback!