We provide IT Staff Augmentation Services!

Oracle Business Application Analyst Resume Profile

5.00/5 (Submit Your Rating)

Arlington, VirginiA

CAREER SUMMARY

Highly innovative and versatile IT professional with 15 years of diverse experience supporting the Oracle Applications Business Suite.Recognized for keen analytical and problem solving skills, complimented by broad and varied experience in multiple product areas and industries. Results-oriented, self-motivated professional with a proven track record of meeting objectives in an efficient, capable manner. Known for building positive relationships with peers, employees and customers.

SELECTED ACCOMPLISHMENTS

  • Led SafeNet's global User Acceptance Testing for Oracle 12i Upgrade resulting in a smooth version transition of the corporate ERP system.
  • Project managed SafeNet's global implementation of Oracle's Advanced Supply Chain Planning module, thereby automating SafeNet's manual planning process.
  • Replaced SafeNet's manual Advanced Shipment Notice process with an automated solution significantly improving customer experience and enhancing Customer Service visibility and tracking of shipped orders.
  • Managed Bugzilla data migration into TekQuest as part of the acquisition of mBalance. The project ensured global software development remained standardized on a single problem tracking package.
  • Developed Tekelec's first Oracle Report incorporating barcode technology. This was a major improvement for the Shipping Department in realizing key productivity gains using Clear Orbit.
  • Modified TekQuest's company's invoice to model a more user friendly phone bill format, resulting in reduced collection times.
  • Developed Alcoa's Oracle Applications User Administration Bulkload program that reduced workload of 2 FTE's by 50
  • Developed email alert program to Alcoa alert business units of stuck manufacturing transactions that impact monthly closing. Reduced manual notification process from 17 hours to 2 minutes
  • Improved Net.com's quality of the development and test environments by designing and automating a database refresh Unix script that sped up the refresh cycle from 2 days to 8 hours
  • Enhanced Net.com's project accounting cycle by 20 by developing PL/SQL Labor Client Extension to meet cost rules not supported by Oracle Projects' standard Overtime Calculation Program
  • Developed data conversion project to migrate10 years of sales data from Jordan Kitt Music JKM COBOL legacy system to a relational database
  • Earned JKM's Employee of the Month for installing a wide area network in 15 retail outlets on time and under budget
  • Developed JKM's custom Online Time Entry program that eliminated a 4 day manual data entry process
  • Installed NoetixViews, Oracle Discoverer and EUL at Net.com, reducing development staff's workload by 30

PROFESSIONAL EXPERIENCE

Confidential

Oracle Business Application Analyst

  • Manage weekly meetings with offsite Development Team and the Procure-to-Payfunctional team to drive issue resolution
  • Review Procure-to-Payfunctional requirements documents for completeness and accuracy before they are passed on to the offsite Development Team
  • Manage review process of functional requirements documents with developers and business analysts
  • Provide weekly metrics for open issues with RICEW development objects
  • Coordinate migration of patches and service Oracle System Administration requests across controlled instances
  • Migrate custom code across development and test instances
  • Created HP ALM defect reports for tracking migrations, patching, and RICEW issues
  • Completed editing and proofing of Applications Programmers Guide

Confidential

Oracle Business Application Analyst

  • Led weekly Production Support meetings for the Supply Chain and Finance areas, to include providing metrics on defects, support tickets, status on enhancement work, projects and tracking team activities
  • Provided 24/7 support for Advanced Supply Chaining Planning and Inventory Optimization
  • Performed weekly Demantra maintenance for manual item chaining, location chaining, and location updates
  • Remediated interface error issues between Oracle Purchasing and CarQuest's legacy ERP system A-DIS
  • Designed/implemented weekly production support pivot table based Excel reports for the Supply Chain, Finance, and HRMS areas
  • Supported month end close of Cash Management activities for BWP business unit
  • Assisted with implementation and weekly support of the SEV1 24/7 hot line
  • Remediated Oracle software defects in accordance with SDLC principles, using HP Quality Center and HP Project and Portfolio Management
  • Served as Oracle training coordinator for IT, HRMS and Finance personnel
  • Performed Oracle System Administrator duties includingaccount, responsibility and menu maintenance

Confidential

IT Business Analyst

  • Planned, coordinated and lead all user acceptance testing activities for Oracle Applications upgrade from 12.0.6 to 12.1.3
  • Project managed implementation of Oracle Advanced Supply Chain Planning, to include having led CRP, UAT and Go-Live
  • Responsible for full SDLC solutions to all enhancement requests for the Operations group Customer Service, Fulfillment, Purchasing, Inventory, Planning , and iProcurement
  • Responsible for writing functional specs for Oracle Discoverer and OBIEE reporting requirements by Operations and coordinate testing with end users and development team
  • Provided daily production support for all functional issues opened by Order Management, Fulfillment, Purchasing, Advanced Supply Chain Planning, Inventory, and iProcurement teams

Confidential

Tech Support Rep

  • Provided 2nd level technical support for the Credit Suisse's full suite of corporate applications
  • Conducted initial troubleshooting and triage to 3rd level support as needed

Confidential

Business Systems Analyst

  • Provided functional support for iProcurement, Purchasing, Order Management, and Inventory
  • Developed functional specs for bug fixes, software enhancements and process changes
  • Primary tester for iProcurement with the implementation of AME
  • Coordinated with technical support, End Users and Oracle Support to remediate application issues
  • Managed Bugzilla data conversion to TekQuest as part of Tekelec acquisition of mBalance
  • Managed requirements, project planning, UAT, and cutover for the ClearQuest upgrade to 7.0.1
  • Responsible for functional and administrative support of TekQuest, Tekelec's primary software problem tracking tool. Managed full SDLC support of this application, 3 releases per year.
  • Served as liaison to Engineering department to support Data Center move, and hardware upgrade for the corporate tool Documentum
  • Re-engineered Partner account administration process, and provided ongoing support

Confidential

Oracle Developer

  • Developed iProcurement workflow customizations to address specialized approval rules
  • Modified Order Management workflow to fire custom code for service and training item holds
  • Reformatted company invoice to a more use user friendly format using XML Publisher
  • Implemented invoice format change using BI Publisher
  • Developed reports for Order Management, Finance, Payables, Receivables, Manufacturing, and Inventory using PL/SQL and Reports 4.5
  • Developed check laser printing using Evergreen Check Laser Format program

Confidential

Procurement Specialist FTE

  • Provided 3rd level Req to Pay production support for over 200 business units spanning North America, Canada and Mexico
  • Provided support for monthly closing process
  • Addressed day to day support for processing requisitions, purchase orders, BPA Maintenance Accounts Payable, MRO item support, EAM work orders, stuck transactions, workflow issues
  • Created Oracle SR's as needed to solve issues and acquire patches
  • Coordinated with technical support, End Users and Oracle Support to remediate application issues

Confidential

Technical Support Team Lead Contractor

  • Responsible to resolve Production/Development issues within Aloca'sSLA
  • Provided tech lead representation in EBS War Room to triage issues impacting monthly closing
  • Provided daily reporting to senior management of all EBS Production Services issues
  • Conducted interviews for candidates when additional team resources were needed
  • Provided key technical support for numerous 11i go-live implementations spanning Alcoa's North America EBS environment
  • Provided support in DEV, CRP, QA, UAT, and PRD instances for testing and migrating customizations
  • Troubleshoot application issues spanning RecToPay, OrderToCash and Manufacturing modules
  • Coordinated with Developers, End Users and Oracle Support to remediate application issues
  • Expedited Sales Order and Purchasing Transactions using Workflow administration tools
  • Worked with ITG to provide Change Management support
  • Coordinated with developers and users to address customization and bug remediation
  • Developed web based program for tracking stuck transactions that impacted monthly closing

Confidential

Oracle Applications Database Administrator / Applications Support

  • Oversaw all facets of Oracle Financials System Administrationand provided comprehensive support services to 1300 users
  • Provided key technical support for go-live implementation of Inventory, Purchasing, and Global Accounting modules for the company's division in Algety, France
  • Served as the liaison between the Senior Database Administrator, Corporate Oracle Financials Manager and IT staff in support of operational Oracle Financials issues for France Division
  • Applied patches both for proactive maintenance and daily bug remediation

Confidential

Oracle Applications Database Administrator

  • Project Management managed / coordinated technical aspects of a company-wide implementation of Servicesoft Helpdesk
  • Planned, installed and implemented technical upgrades, documentation, and system reorganizations for:
  • Oracle Applications 10.7 to Release 11.03 planning only
  • Oracle 7.3.4.4 to Oracle 8.05
  • Oracle Server 7.3.3.5 to 7.3.4.4
  • NoetixViews and Oracle Discoverer
  • Applied All Y2k Patches for Oracle Apps 10.7 and 10.7 SC

Oracle Developer/Systems Analyst

  • Developed customized reports using Oracle Reports and client extension packages using PL/SQL in Oracle Projects for calculating Overtime Labor Costing
  • Created and maintained Oracle Alerts and SQL Loader programs

TECHNICAL EXPERTISE

Operating Systems: Unix HP 11.11 Digital Unix 4.0F SunOS 5.5.1 Solaris SCO Unix NT 4.0 Netware Windows Server 2003 VAX/VMS OS/2 DOS 6.22 Hardware: Sun 3500 DEC Alpha 2400 Sequent 52000 SUN Ultra Enterprise Compaq Proliant 5000 IBM Mainframe Pentium Software Applications: HP Quality Center HP Project and Portfolio Management ClearQuest 7.0.1 Documentum SharePoint BI Publisher ITG 5.5 Kintana 4.5 Remedy 7 EDI Translator Hummingbird Connectivity Reflection 8.0.2 Microsoft Office Professional Lotus 1-2-3 Lotus Notes AppWorx TEMPRA Media Author ArcServe Manager Alexandria SPF/2 Database: Oracle 11i 12i Oracle Applications Releases 11.5.3., 11.5.8, 11.5.10, 12.0.1, 12.0.6, 12.1.3 Toad Oracle Workflow Builder Noetix Administrator Discoverer Administrator 3.1 iDiscoverer 3i/4i Oracle Enterprise Manager PL/SQL SQLPlus Developer 2000 Oracle Reports 2.5 Oracle Forms 4.5 Instance Monitor Quest Oracle Web Application Server 3.0 SQL Navigator Toad DataLoader Languages: Unix Shell Scripting PL/SQL ACUCOBOL Microfocus COBOL Lotus Macros ANSI C QBASIC PASCAL JCL DOS

We'd love your feedback!