We provide IT Staff Augmentation Services!

Oracle Ebs And Hyperion Senior Consultant Resume

Beavercreek, OH

SUMMARY:

Oracle E - Business Suite (EBS) and Hyperion/Enterprise Performance Management (EPM) Consultant with technical and functional skills including PL/SQL development and testing, creation of requirements, design, testing and installation documents and development and migration of Hyperion artifacts. Oracle SQL Expert and Hyperion Planning 11 Implementation Specialist certified.

INDUSTRY EXPERIENCE:

Oracle EBS and Hyperion Senior Consultant

Confidential, Beavercreek, OH

Responsibilities:

  • Team member for Oracle Upgrade from 12.1.3 to 12.2.6; resolved issues involving delivery and encryption of Supplier notifications, a custom interface between EBS and a manufacturing system, Approvals Management Engine (AME) rules and query performance issues
  • Served as the Lead IT Analyst for system enhancements including creation of an interface to provide timecard data from Oracle Time and Labor (OTL) and Projects modules to a manufacturing system, enablement of iSupplier Portal invoicing functionality, updating of Oracle AME workflow for direct requisitions and creation of custom responsibilities
  • Developed Payables (AP) and General Ledger (GL) extracts to meet financial audit requirements and for loading data to Hyperion Essbase
  • Coded/updated BI Publisher (formerly XML Publisher) reports
  • Created installation documents and tested data fix scripts for Production issues
  • Provided technical support for Hyperion Planning, Hyperion Strategic Finance (HSF) and Hyperion Financial Management (HFM) applications, including resolving Production issues, providing support for Exalytics re-imaging and restarting systems and performing tests after monthly Windows security patches on Development, Test/QA and Production systems
  • Served as the Lead Hyperion Analyst for patching/upgrading of Hyperion Essbase and Smart View; worked closely with business users and Management, DBAs and Oracle Support
  • Utilized JIRA Agile IQ Suite to manage work, including creating JIRA issues, using Kanban boards, entering estimates and running reports

Oracle EBS and Hyperion/EPM Technical and Functional Consultant / Senior Engineer

Confidential, Beavercreek, OH

Responsibilities:

  • Developed, tested and deployed a Desktop Integrator for creating new employees in FMS using the Oracle EBS R12.1.3 Web Applications Desktop Integrator (Web ADI) application
  • Utilized korn shell scripts to stream edit a SQL*Loader control file and stage inbound data, to encrypt and archive files, to copy files for deployment, and to upload and download files using the Oracle Generic Loader (FNDLOAD)
  • Wrote IF.040 Interface Detail Mapping and Program Design, MD.120 Installation Instructions, TE.040 Systems Test Script, and User Procedures documents for several projects including the Employee Bank Accounts interface
  • Created and presented a PowerPoint presentation describing the design and development of the Employee Bank Accounts interface
  • Wrote Code Migration Process document describing methods for effective source control, generating DDL scripts using Toad for Oracle, use of FNDLOAD, and steps for migrating code to UAT and Production
  • Executed regression tests of Oracle Projects, Receivables, General Ledger, Purchasing and System Administration modules and database triggers
  • Wrote the TE.050 Systems Integration Test Script to test the consolidation of interfaces used to record payroll expenses in Oracle Projects and General Ledger
  • Wrote MD.050 Application Extensions Functional Design documents to implement Standard Financial Information Structure (SFIS) data requirements and business rules into Oracle EBS; included descriptive flexfield configuration changes and analysis of Oracle EBS patches
  • Collaborated with internal technical and functional teams and the customer to reproduce, research and resolve issues; including research using My Oracle Support (formerly Oracle MetaLink), Oracle Technology Network (OTN), and Oracle EBS Electronic Technical Manual (eTRM)
  • Developed business rules in Calculation Manager and calc scripts in Essbase
  • Extended Essbase calculations using Custom-Defined Functions
  • Created and updated simple and composite forms in Hyperion Planning including the development of complex edit checks
  • Created reports in Financial Reporting Studio 11.1.2.3 including advanced member selection criteria and conditional formatting
  • Migrated a Planning application and associated artifacts from an 11.1.2.3 source environment to an 11.1.2.4 target using EPM Lifecycle Management
  • Managed dimension hierarchies in Dimension Library and created, managed, validated and deployed applications in Application Library
  • Mapped and loaded data to Essbase using data load rules files
  • Provisioned Hyperion Planning users and roles using Shared Services
  • Analyzed SQL scripts and updated process documentation for metadata load/refresh from Oracle EBS tables into Hyperion Planning 11.1.2.3 application; investigated and resolved questions concerning metadata load logic
  • Developed and documented a process for restarting the Hyperion/EPM development instance; included instructions for Oracle WebLogic Server Administration Console, Essbase, EPM managed servers, Oracle Net Listener, and Oracle RDBMS components
  • Developed and presented use cases demonstrating how the customer will utilize Planning and Smart View to complete their budget cycle processes; included demonstrating forms, business rules, task lists and planning unit hierarchies to complete processes involving direct and indirect costs, escalation, edit checks, formal and ad hoc reporting

Senior Test Engineer Consultant

Confidential, Beavercreek, OH

Responsibilities:

  • Learned the automated test framework and Eclipse-based SpringSource; wrote, executed and debugged scripts using Java, JUnit, Firefox Firebug and Selenium WebDriver
  • Quickly learned system functionality and project-specific scrum agile processes
  • Wrote, improved and executed manual test scripts, identified and documented discrepancies in Rational Team Concert, provided updates to improve the VBMS User Guide
  • Utilized Rational Quality Manager to create test cases and test scripts, to create test execution records/results and release build records, to view and update test plans, and to view test environment records
  • Collaborated with Requirements Analysts to obtain detailed knowledge of system functionality
  • Created, updated and managed tasks, linked tasks to stories, collaborated with the ScrumMaster and Test Lead on scrum and sprint activities
  • Participated in daily scrum, sprint planning and sprint review meetings; asked questions to gain scrum team consensus and improve process and task execution; supported after hour deployments

Senior Test Analyst Consultant

Confidential, Fairborn, OH

Responsibilities:

  • Quickly learned complex system functionality, wrote and executed functional test cases, configured test data, identified and documented discrepancies in HP Quality Center
  • Tested the PRPS and CCaR (Comprehensive Cost and Requirements) system interface to verify funds within Confidential (Automated Business Services System) for purchase requests
  • Peer reviewed requirements documents and CBT modules; identified and documented deficiencies
  • Participated in test status, discrepancy review and design review meetings

Oracle E-Business Suite Analyst Consultant

Confidential, Beavercreek, OH

Responsibilities:

  • Engaged in daily collaboration with customers, management, solution architects, developers, and technical and functional testers
  • Led the functional testing of thirteen Oracle E-Business Suite R12 Procure-to-Pay and Order-to-Cash interfaces between ECSS and multiple trading partners
  • Managed test data (insert/update/delete/query) using Oracle SQL Developer and PL/SQL Developer, prepared XML files to simulate inbound transactions, validated XML files against XSDs using XMLSpy, and validated log files using PuTTY SSH client and UNIX commands
  • Configured test data and executed tests using Purchasing, Order Management, Warehouse Management, Quality Plans, Material and Maintenance Applications, Inventory, PLM, Program Execution and Scheduling, and View Interface Tables EBS modules and functions
  • Performed Oracle EBS troubleshooting and diagnostics; documented detailed system discrepancies; quickly validated discrepancies after code releases
  • Designed and executed functional, negative, end-to-end and financial tests with HP Quality Center
  • End-to-end tests included validation of Material Obligation Verification, Purchase Order Creation and Life Cycle Management, and Material Excess Management business processes
  • Peer reviewed, analyzed and made improvements to MD.050s (functional designs), MD.070s (technical designs including pseudo code), CV.050s (conversion procedures), and PL/SQL code

Technical Lead

Confidential, Beavercreek, OH

Responsibilities:

  • Led the functional testing effort for Confidential releases and mentored junior engineers
  • Ensured that Confidential sustainment processes were followed by the Confidential team and provided leadership to development, CM and QA team members to ensure quality, timely releases
  • Provided CM and QA support by performing formal and informal peer reviews, developing and improving templates, checklists, and processes for meetings, action items and status reporting
  • Led the writing of the technical portion of the Confidential proposal and made important contributions to GCSS-AF 2 (750M) and NETCENTS 2 APPS (1B) proposals, including analysis of software development processes, basis of estimates and sample task order proposal sections

Senior Test Lead / Integration Analyst Consultant

Confidential, Fairborn, OH

Responsibilities:

  • Led Confidential Help Desk; served as primary customer contact, resolved issues independently and thru team collaboration, collected/reported metrics, earned a high level of customer satisfaction
  • Detected 188% more defects than previous Confidential releases, ensured successful implementation of releases into GCSS-AF by creating high quality deployment packages
  • Led the testing and integration effort for deployments of Logistics and Civil Engineering systems into the GCSS-AF Data Services data warehouse, including analysis and deployment of BI solutions using Business Objects, Cognos, Informatica and Service-Oriented Architectures (SOA)
  • Responsible for systems integration support for the conversion of the Air Force Equipment Management System (AFEMS) to use GCSS-AF security services and for the implementation of a data feed from the Air Force data warehouse to the Equipment Requirements System (ERS)
  • Prepared deployment documentation for many Air Force systems hosted on the GCSS-AF Integration Framework, including requirements traceability matrices, design documents, test plans and reports, version description documents, and installation and security configuration instructions
  • Developed DoD Architecture Framework (DoDAF) diagrams using System Architect modeling tool, Visio and DoD Information Technology Standards Registry Online (DISRonline)
  • Utilized Business Objects Designer and InfoView and Teradata SQL Assistant and Administrator to design and execute tests, including tests to detect fan traps and chasm traps in database design

Senior Software Test Analyst / Team Lead / Account Manager

Confidential, St. Petersburg, FL

Responsibilities:

  • Wrote manual and automated software tests using Rational Robot, managed test assets within Rational TestManager, and logged, managed, and validated defects using Rational ClearQuest
  • Gained a deep understanding of s functional areas including Search, Eligibility Decisions, Adjustments, Dependencies, Print and the Generate, Authorize and Concur process
  • Learned s Oracle database table structures, table relationships and data definitions in order to stage baseline test data prior to test execution and validate data during execution
  • Automated Oracle data baselining and validation by developing PL/SQL and SQL command files to create, read, update and delete data in Oracle during execution of automated test scripts
  • Developed and executed test scripts to test the process flow between Search and Participant Profile (SPP), Rating Board Automation (RBA), s and the Finance and Accounting System (FAS) including validation of the lines or disallowance in s and payment processing in FAS
  • Became familiar with s architecture including Common Security System, Jet database, Housekeeping data retrieval process, Tuxedo client/server components and Oracle database
  • Provided valuable to junior Test Engineers in technical and team building areas
  • Selected by management to assume leadership responsibilities in the Test Manager's absence
  • Led meetings and conference calls between customers and project sponsors to develop action plans for addressing software defects discovered by the test team
  • Managed Rational TeamTest’s defect tracking workflow and e-mail notification system
  • Consistently wrote clear and concise software defect reports in order to quickly and effectively communicate system deficiencies to programmers and management
  • Developed and analyzed technical and functional requirements, project schedules and plans

Java Instructor

Confidential, Tampa, FL

Responsibilities:

  • Developed curriculums and instructed courses in Java and Advanced Java (J2EE) for Confidential Corporate
  • Provided high quality Java to experienced IT professionals using Oracle JDeveloper and MySQL open source database after learning these technologies through self-study
  • Developed and presented extensive class handouts and PowerPoint presentations
  • Earned the highest possible scores on many course evaluation forms and a high level of customer satisfaction from Confidential Corporate and their client

Hire Now