TECHNICAL SKILLS:

• Oracle Systems Analysis

• Advance SQL
• TOAD
• Order Management
• Accounts Receivable
• Purchasing
• Accounts Payable
• Project Costing
• Fixed Assets
• Cash Management
• Project Billing
• Incentive Compensation
• Inventory Module iProcurement iSupplier
• Workflow
• XSL Style Sheets
• XML Publisher
• Oracle A/P Module
• BPEL
• User Productivity Kit
• Development of User Training
• Oracle E - business Tax
• Sub-ledger Accounting
• Linux Server

• Microsoft Office Suite

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Oracle Analyst- Lead Consultant

Responsibilities:

• Work directly with Operations to understand supply chain planning requirements and model those requirements in ASCP
• Responsible for planning small/medium sized projects or tasks
• Provides reliable solutions to a variety of problems using sound problem solving techniques including ability to find root cause and corrective action for given problems
• Implementation of technology solutions for Sub-Ledger Accounting
• Works with the following module suites: Financials (GL, AP, AR, PA, CE, FA,), Discrete Manufacturing (INV, BOM, WIP, Cost, PO), Supply Chain (Order to Cash, Procure to Pay, WMS), Advanced Planning (ASCP, DP, MRP), CRM, Human Resources
• Supports Accounting Manager to ensure Period end Procedures are completed
• Responsible for assistance to the Application DBA in their day to day functions with Oracle EBS.
• Work with contractors for the data warehouse and ERP systems, assigning work as needed.
• Analyze and evaluate business and procedural problems for resolution.
• Gather facts and analyze data to provide comparative analysis capabilities to user departments at department and management levels.
• Ensure software systems are configured to process data as required. Coordinate software upgrades and integrations.
• Provide system documentation for standard operation with revision level control. Write necessary user documentation and provide requested user training, as required.
• Review and obtain required approval for user access to confidential data and determine user responsibility to access specific data files.
• Confer with user departments concerning their operations and data needs. Instruct user department personnel on system procedures and operations.
• Evaluate and recommend changes for continuous improvement of the data warehouse.
• Create data warehouse grids and connections to ERP systems to pull data into the warehouse. Develop web pages needed to display the information with security applied per user per grid.
• Work closely with Controllers and other users to verify correct mapping of information into the data warehouse and verification of data obtained
• Monitor health of Our Client's planning cycle and provided advanced troubleshooting for issues which impact critical planning and reporting processes
• Analyze and query application data schema for ASCP and related Oracle applications

Confidential, DALLAS, TX

Manufacturing Systems Analyst

Responsibilities:

• Serve as the functional team lead for the deployment of existing financial & manufacturing applications supporting corporate finance and treasury functions to newly acquired / migrated locations as well as the deployment of new financial & manufacturing applications that are required to support enhancements for existing systems. These Oracle Modules include: OTC, P2P, AP, QA
• Manage relationships with key business owners and subject matter experts in order to regularly review customer satisfaction, project priorities, service needs, process improvements, etc.
• Work with supported corporate functions to streamline, document, and improve existing and new processes using Oracle EBS and third-party software solutions.
• Document and communicate functional requirement specifications for system enhancements, and report / data needs to the IT development team.
• Provide quality assurance and testing on newly developed customizations and reports before delivering to the user group.
• Provide second / third level functional / technical support on issues that are escalated above the first-level help desk.
• Provide documentation and training to end user groups on existing functionality and newly developed enhancements.
• Assist in ensuring the timely reporting of financial information, as well as supporting and improving the monthly closing process.
• Provide project management and QA services for all applicable Oracle EBS patches and upgrades.
• Develop ad-hoc reports, data extracts, etc. to meet one-time or continuing business needs using available tools (BI Publisher, Discoverer, Oracle Reports, Toad, etc.).
• Maintain awareness about the need for new / upgraded financial application software; research and
• Evaluate new / improved financial application software; and assist in the software selection process.
• Worked with the implementation on Procure-to-Pay and design of AME and Iprocurement for R12
• Designed policies and hierarchy for metal and non-metal requisition approval.
• The functional Team lead in verification of data mapping, migration validation of data from 11i to R12.
• The functional Team lead in verification of data mapping, migration and validation of data implementation of sites in Mexico, Canada and North Carolina