TECHNICAL SKILLS

• ORACLE 11i / R12 E - Business Suite Financials (Accounts Payable (AP), Accounts Receivable (AR), General Ledger (GL)
• Fixed Assets (FA), Cash Management (CE), iExpense (IE), Purchasing (PO) & Projects (PA)); Oracle Document Capture (ODC)
• Oracle Imaging and Process Management (me/PM), Oracle Business Process Management (BPM)
• Oracle Approvals Management Engine (AME), Oracle Enterprise Manager, Oracle System Administrator
• TOAD; SQL Developer; ADI; DISCOVERER; HP Quality Center, Micro Focus QA Director; Compuware TrackRecord

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Oracle Functional Consultant (Media)

Responsibilities:

• Oracle EBS application support (AP, IE, GL, PO, PA)
• Use of SQL Developer for teh analysis of interface processing, data issues, and reporting
• Use of Remedy ticketing system to manage most user requests
• Create business requirements
• Create test scenarios and scripts
• Perform configuration changes
• Ensure changes are constructed, tested, and implemented
• Design remediation plan for massive GRC incidents
• Use of PCG to restrict access Confidential responsibility / function level
• Third party software integration testing
• Participate in off-shore development

Confidential, Atlanta, GA

Oracle Functional Consultant (Media)

Responsibilities:

• Oracle EBS application support (AP, IE staff augmentation)
• Use of TOAD / SQL Developer for teh analysis of interface processing, data issues, and reporting
• Use of Remedy ticketing system to manage most user requests
• Updates and sharing of Discoverer reports
• Manage / resolve import errors
• Investigate possible upgrade changes / needs
• Participate in UAT activities
• Creation of test scenarios and scripts
• Third party software integration testing
• Handle various staff requests to support data integration / processing
• Update system setups to accommodate project changes
• Manage Oracle Alerts and scheduling

Confidential, Atlanta, GA

Oracle Functional Consultant (Restaurant)

Responsibilities:

• Oracle EBS application support (AP staff augmentation)
• Handle various staff requests to support data integration / processing
• Update system setups to accommodate project changes
• Manage Oracle Alerts and scheduling
• Troubleshoot expense and invoice processing
• Use of me/PM to support teh verification of processed images
• Manage tasks list assignments and coder forms within BPM
• Troubleshoot processing ‘faults’ via Enterprise Manager
• Manage failed document upload processing via Content Manager
• Troubleshoot document processing within ODC
• Manually update ODC indexes for batch processing
• Maintain connections and processes of various financial institutions
• Troubleshoot data interface issues from various financial institutions
• Maintain AME groups and rules for workflow processing
• Use of teh AME test bench to determine teh flow of teh approval process
• Use Oracle Workflow to maintain and/or update vacation rules / approval notification processes
• Use of TOAD / SQL Developer for teh analysis of interface processing and data issues
• Use of HP Quality Center to track and maintain defect / testing issues
• Test and document updated procedures
• Document current processes

Confidential, Atlanta, GA

Oracle Functional Consultant (Utilities)

Responsibilities:

• Oracle EBS application support
• Enterprise Solution Support team member providing production support for user community to include case creation and/or management and resolution
• Use of TOAD to retrieve data for reconciliation of interface processing and analysis of data issues
• Troubleshooting process failures to include production data integration
• Research and resolve functionality failures
• Coordination with team members of various modules and 3rd party applications to conduct all phases of testing and provide production support
• Validation of 3rd party processing of PO’s and Receipts to Oracle interface tables
• Ensure PO invoice matching and payment processes are correct
• Ensure iExpense setups and processes are correct
• Utilize Oracle Workflow to maintain and/or update approval notification processes
• Data preparation for testing
• Application testing of Oracle 11i modules (AP, AR, GL)
• Creation and/or execution of test scenarios and test scripts
• Communication and/or resolution of test defects
• System Regression testing (AP, AR, GL)
• Key Financial Controls testing (AP, AR, GL)
• Verify sub-ledger accounting (SLA)

Confidential, Atlanta, GA

Oracle Functional Consultant / SBA (Telecomm)

Responsibilities:

• Work closely with Business Analysts, Quality Assurance and Development teams to gather, test, and troubleshoot items surrounding new custom processes for multiple 3rd Party data integrations into Oracle AP
• Functional, Technical, and Testing Design Documentation creation / updates / reviews
• MD.050s, MD.070s, TE.040s
• BR100 Documentation creation / updates; setups performed and others reviewed
• Participated in design reviews with QA manager to ensure testing efforts covered various processing scenarios
• Creation and execution of test scenarios and test scripts
• Use of TOAD to create test data and troubleshoot custom SQL code issues
• Functional, regression and integration testing lead to include pre go-live sign off
• Documentation and resolution of processing defects

Confidential, Atlanta, GA

Oracle Functional Consultant (Utilities)

Responsibilities:

• Implementation team member
• Application testing of Oracle 11i modules ( AP, AR, GL)
• Enterprise Solution Support team member providing production support for user community to include case creation and/or management and resolution
• Implementation Quality Assurance (QA) team member for multiple test phases
• Designated AP Subject Matter Expert (SME) for various test phases and documentation reviews
• Creation and execution of test scenarios and test scripts
• Communication and/or resolution of test defects
• Research and resolve data / system functionality failures
• Data preparation for testing and end user training
• User Acceptance Testing (UAT) liaison
• System Regression testing (AP)
• Key Financial Controls testing (AP, AR, GL)
• Confirm sub-ledger accounting (SLA) processing
• Review of end user training documentation and provide feedback / updates
• Provide Corporate IT Help Desk training
• Use of RICE principles to create needed documentation
• Creation of documentation for Internal Control Compliance auditing
• Configuration reviews / recommendations for AFS document (BR100 Equivalent)
• Coordination with team members of various modules and 3rd party applications to conduct all phases of testing and provide production support
• Validation of vendor configuration within Oracle to ensure proper PO processing
• Data mapping of 3rd party data elements to Oracle
• Validation of 3rd party processing of PO’s and Receipts to Oracle interface tables
• Use of TOAD to retrieve data for reconciliation of interface processing
• Troubleshooting process failures to include production data integration
• Review of PO invoice matching process to ensure teh matching types were created correctly
• Ensure PO invoice payment processing completed with teh payment statuses and amounts correctly reflected for teh related PO
• Utilized Oracle Workflow to maintain and/or update approval notification processes

Confidential, Donough, GA

Manager, Business Applications Systems / Senior BA

Responsibilities:

• Maintenance, modification, and implementation of Oracle 11i Financial modules (Accounts Payable (AP), Accounts Receivable (AR), General Ledger (GL), Fixed Assets (FA) & Cash Management (CE))
• Managed project delivery to include staff resources and updates to project deliverables
• Use of Oracle Business Intelligence (BI) tools to create Executive Dashboard reporting to provide KPI’s and graph data
• Liaison between business units and technical staff to gather required information necessary to create functional and technical documentation
• Provide hands-on analysis, conceptual design, specification documentation, and testing
• Identify and translate business requirements into system definitions and solutions
• Preparation of time estimates for modifications of existing applications and new product services
• Drive process improvements relative to business functionality
• Post implementation support to include user support and training on reported issues
• Research and recommend Oracle modules and/or additional software solutions

Oracle Applications Administrator

Confidential

Responsibilities:

• Application support of Oracle 11i E-Business Suite
• Implementation team member for Accounts Payable (AP), Accounts Receivable (AR), General Ledger (GL), Fixed Assets (FA) & Cash Management (CE)
• Oracle System administration including configurations of individual modules, user setups, application setups
• Provide functional and technical application support for associated business applications
• Use / understanding of application tools: TOAD, SQL, SSH Secure Shell, ADI, FSG, Discoverer
• Use of Metalink/TAR (Technical Assistance Requests) system to open and coordinate service requests with Oracle Support
• Data mapping between legacy systems and Oracle
• Research / troubleshoot and resolve application failures
• Oracle Product Support collaboration to submit development requests for production bugs
• Assist developer(s) with modification requests
• Support application developers in troubleshooting and de-bugging customizations
• Collaborate with DBA and infrastructure team to assist in patch applications, upgrades, and resolve any issues
• Create / maintain job schedules, concurrent processing sets, and incompatibility restrictions
• Monitor scheduled concurrent processes
• Monitor system processes for performance degradation
• End-user access / maintenance
• Assist end-users with functional error resolutions
• Create customized responsibilities and menu structures
• Provide test scripts for end-user testing
• Obtain end-user sign-off for acceptance testing
• Advise end-users of system updates

Confidential, Atlanta, GA

Data Warehouse Analyst/Developer

Responsibilities:

• Hyperion Essbase Administrator
• Developed Enterprise Data Warehouse OLAP processing and analytical reports using Hyperion Essbase, ShowCase and AlphaBlox tools
• Provided ongoing maintenance of application tools with installation of updates to include patches when notified by software vendor
• Multidimensional cube design, development, test, implementation and follow-up support
• Participated in project planning sessions
• Prepared time estimates and create modifications of existing applications
• Participated in ETL / Star-Schema design process design to determine use of warehouse, financial, Web, EDI, and transportation data for development of data warehouse database
• Developed Warehouse Builder definitions for dimension build and load rule files
• Used Warehouse Builder sets to create or change existing cube dimensions and/or data
• Reviewed error logs produced by Warehouse Builder definitions and correct errors which may include change in ETL processing
• Supported of new applications once implemented
• Used Analyzer and AlphaBlox to build analytical reports
• Installed client-side ShowCase tools and patches for multiple end-users - created ‘Silent Install’ on network drive
• Developed and maintained technical and end-user documentation
• Analyzed end-user reports and information to identify and resolve data discrepancies and other program related problems
• Cost analysis of Data Warehousing tools