We provide IT Staff Augmentation Services!

Senior Oracle Ebs Analyst Resume

0/5 (Submit Your Rating)

Orlando, FL

SUMMARY:

  • Extensive experience with ERP and RICE development
  • Several years experience with Governmental and DOD programs
  • Extensive experience with Oracle Financial Applications
  • Experienced with Oracle 11i implementation, Oracle 12i Implementation
  • Experienced with Oracle AIM Methodology

TECHNICAL SKILLS:

Operating Systems: Microsoft Windows 3.1, 95, 98, NT 4 Workstation, 2000 Professional, Microsoft Windows NT Server 4, Hp - Unix, Solaris, AIX, Digital Unix, VMS, XP Professional

Languages: PowerBuilder 6.0, Oracle Forms/Reports 6i, Java, Informix, PL/SQL, SQL*Plus, C++, Discoverer, Pro*C, Progress 4GL, Cobol, Ingress, Pascal, Ansi C

RDBMS: Oracle DBMS, Access, Sybase System10, DB2, Informix 7x, Progress

Development Tools: Oracle Developer (Forms 6i, Reports 6i, Designer, Discoverer), Erwin, Jdeveloper, Micro Strategy 7i, Borland C++

Application Servers: Micro Strategy, Oracle Financials, Oracle Ebusiness Delivery Return Modules, Source Modules, Finance Modules, IMail Server, Crystal Reports 8, Retek Merchandising, Retek Data Warehouse, Retek forecasting, Retek Distribution

Web Servers: Internet Information Server 6, Apache Web server

Internet Technologies: Active Server Pages / ASP.NET, JavaScript, JSP, MTS, COM+, COM, ADO, ADSI, OLDEB, ODBC

Scripting Languages: Java Script, Shell Scripting, Windows Scripting

Versioning Tools: Continuous, PVCS, Dimensions, ClearCase, ClearQuest

Server Mgmt Tools: IpMonitor, SecureCopy, SecurityExplorer, WebTrends, IIS Export Utility

Protocols: TCP/IP, SNMP, SMTP, FTP, X.25, PPP, WWW

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle EBS Analyst

Responsibilities:

  • Provide support for Oracle AP, AR, Payments, Purchasing, Projects,
  • Development of ETL Processes using Abinitio ETL Tool
  • Perform data conversion processes from a variety of data sourcesincluding data mapping, extraction, cleansing, migration and validation.
  • Create database objects tables, views, queries, indexes and stored procedures.
  • Create data feeds, file exports, incremental data feeds
  • Create technical requirements
  • Develop Technical Design document
  • Migrate Legacy data to Oracle Ebusiness/Data Warehouse
  • Develop functions, procedures using PL/SQL
  • Develop MD070 Technical Design Document
  • Assist in Mapping and defining data elements in MD050 and Business Rules
  • Provide Systems and business architecture design concepts.

Confidential

Senior Oracle EBS Application Analyst

Responsibilities:

  • Provide support for Oracle AP, AR, Payments, Purchasing, Projects, Taxes, Workflow
  • Use of Oracle Patch Wizard
  • Test and apply Oracle Patches
  • Ability to perform Application Diagnostics using Oracle Diagnostics
  • Ability to solve problems and log Oracle Service Request
  • Develop functions, procedures using PL/SQL
  • Develop Oracle forms/Reports, XML Reports
  • Perform systems analysis, design, programming and installation.
  • Provide Systems and business architecture design concepts.
  • Design and develop seamless connections between systems.
  • Test application installations, enhancements and upgrades.
  • Use Technology Services change management process.
  • Use and supported client based applications.
  • Oversee the work of others, and provide coaching, mentoring and .

Confidential, Orlando, FL

Senior Oracle PL/SQL Developer/Data Architect

Responsibilities:

  • Provide attention to detail, time management, work prioritization, multi-tasking, estimate tasks, n-time deliverables and task delegation & follow up.
  • Ability to develop complex interfaces in Oracle using PL/SQL
  • Develop ETL processes for converting Data
  • Ability to map data from ERP Systems to Oracle EDW and identify any data gaps
  • Ability to assimilate the holistic view as well the detailed dissection of the business processes.
  • Collaborate with business to determine requirements and recommend optimized solutions.
  • Interface with the end users to define and document requirements for data, reports, analysis and metadata, service levels, data quality, performance and troubleshooting.
  • Perform system impact analysis including upstream and downstream impacts, propose solutions and build functional specifications.
  • Designed/Architected Data Marts, Modified Data Warehouse Structures, Created Tables, Primary Keys, Indexes.
  • Collaborate with, BI developers to translate requirements into technical specifications.
  • Determine and validate potential data sources, build validation plan, assisting with or building scripts executing the scripts, and communicating results in non-production environment.
  • Plan, facilitate and participate in working sessions with cross-functional resources.
  • Conduct peer reviews to solicit feedback on materials created

Confidential, Dayton, OH

Senior Oracle 12i Oracle Technical Analyst/Project Lead

Responsibilities:

  • ERP Project Leader/Team member for RICE design/development.
  • Experience with the Oracle technology stack (Oracle RDBMS, Oracle Developer, Oracle JDeveloper, PL/SQL development, Oracle Forms, Oracle Reports)
  • Experience working with application design principles and product configurations
  • Experience with a multi - vendor, best-of-breed application solution
  • Excellent written and verbal communication skills.
  • Experience and Technical knowledge of Oracle Development tools including
  • Oracle Developer Oracle Forms Oracle Reports Oracle Discover Oracle Workflow Oracle BPEL-PM Oracle BPEL-PM
  • Experience with establishing and adhering to technical development standards
  • Good analytical, prioritizing, forecasting and problem solving skills.
  • Experience and knowledgeable of Oracle AIM documentation - specifically CV.40,CV.60, MD.050, MD.070
  • Design and development of RICE standards
  • Developing and documenting technical procedures for installing and executing RICE objects
  • Participates in business process solution development workshops to gain understanding of solution requirements
  • Analysis of ECSS requirements to establish RICE development requirements
  • Designing the technical RICE specification to meet the business process requirements of the ECSS solution
  • Developing RICE objects to meet the business process requirements of the ECSS solution
  • Unit testing RICE objects to meet the business process requirements of the ECSS solution
  • Support and participation in Solution Design/Development Labs as necessary
  • Coordination and support of program testing requirements
  • Developing and documenting technical specifications (MD.070)

Confidential, Melbourne, FL

Sr Oracle SOA Consultant/Lead

Responsibilities:

  • Assisted, trained and provided support to in-house developers on BPEL related issues and development. Results include: Setup for Database Alerts; defining Data Architecture for Data Loads and updates; developing BPEL interfaces using oracle BPEL Adapters such as Oracle advance queues, FTP file Adapter
  • Database Adapter and File Adapter; Setup and configured Client Link and Partner links; defined BPEL Activities, such as Assign, Reply, Invoke, Receive, Sequences, Switch, Otherwise and Fault handlers; used Oracle BPEL console and Process Manager for monitoring processes. Modified; and also troubleshot BPEL XML to meet business requirements for BPEL processes.

Confidential, Quantico, VA

Sr Oracle 12i Ebusiness Consultant

Responsibilities:

  • Defined/Mapped requirements for development of Interface extensions from Legacy System to Oracle Applications. Toad, PL/SQL, Oracle Aim Methodology, Oracle Work Flow. Modules include (PO, FA, AR, AP, GL, OM, WMS, WIP, INV)

Confidential, San Antonio, TX

Sr Oracle 11i Ebusiness Consultant

Responsibilities:

  • Developed financial reports in Oracle; Developed Stored Procedures, Functions, Operating Statements, Balance Sheet, GL Detail Report, and Prepaid Report: and developed Extensions; Used TOAD; and worked with end user defining requirements. Designed custom responsibilities and menus, and partnered with DBA to set up web server for self-service applications. Modules include (PO, HRMS, FA, AR, AP, GL)

Confidential, San Antonio, TX

Oracle 11i Ebusiness Consultant/Lead

Responsibilities:

  • Oracle application development consisted of (Forms/Reports 6i) for 11i applications and Inventory Management. Also conducted Oracle Workflow customization, workflow builder. Toad, SqlPlus, Enterprise Manager, SQL*Loader. Held weekly meetings with Confidential India to discuss project requirements, project status and completion and coordination of n - shore testing.
  • Software Development and application support modules consisted of Manufacturing (WIP, BOM, Inventory, MRP), Procurement (PO, ICX), Finance (AP, GL, AR), Quality (QA) and Project Control (PJM, PA). Discreet Manufacturing and Kintana source control. Support also consisted of multiple 3rd party applications.

Confidential, Las Vegas, Nevada

Sr. Oracle Ebusiness Consultant/Lead

Technology: Oracle 9i DBMs, Maximo, Oracle Financials 11i, MicroStrategy, PL/SQL, Discoverer and Oracle forms/Reports 9i & 6i. Modules include (PO, FA, AR, AP, GL,)

Responsibilities:

  • Involved in managing, architecting, testing, deployment, and monitoring of the software projects
  • Managed and Developed Oracle Reports, Stored Procedures, Oracle PL/SQL, Oracle forms/reports, Visual Basic, Access, and Micro Strategy Reports
  • Designed Oracle Financials 11i reports for Accounts Payables and Receivables
  • Developed Process Flow Diagrams and Data Flow Diagrams using Oracle Designer
  • Created Database tables, Logical/Physical model, ERD Diagrams
  • Developed Monthly and Yearly accounting reports using MicroStrategy and Discoverer
  • Responsible for the management and of developers
  • Managed Development of new Systems using Oracle forms/reports 9i, Discoverer
  • Lead Architect and Developer implementing Oracle Financials 11i
  • Capability Maturity Model Integration
  • Developed Equipment Maintenance reports using Maximo’s Actuate language

Confidential, Virginia Beach, VA

Sr. Enterprise Data Architect

Technology: Oracle Forms 6i, Oracle Reports 6i, Erwin, SQL*Loader, PL/SQL, Shell Scripting, Enterprise Manager, HP-UX, Micro Strategy.

Responsibilities:

  • Was responsible for managing the development in a Data Warehouse environment.
  • Managed Developers, DBAs, System Administrators and Network Administrators
  • Was responsible for the departmental yearly budget
  • Attended Upper Management meetings
  • Was responsible for Hiring of departmental personnel
  • Designed Logical and Physical model for Data Warehouse
  • Designed federated Data Marts for performance enhancement
  • Used Oracle Designer as Information Repository
  • Developed MicroStrategy and Oracle reports
  • Developed PL/SQL data load programs for cleansing and loading data from Legacy Systems
  • Developed Shell Scripts for execution of nightly batch processes
  • Used Oracle Explain Plan for tuning SQL Statements
  • Was responsible for developing coding standards and interface standards for all systems
  • Was responsible for overseeing all database changes and architectural changes for all Enterprise Systems

We'd love your feedback!