We provide IT Staff Augmentation Services!

Oracle Ebs System Consultant Resume

2.00/5 (Submit Your Rating)

Schaumburg, IL

SUMMARY

  • Extensive experience in System Analysis, Design, Testing, Integration, and Implementation in Client Server environment using various software tools. Extensive experience in Oracle 11i/R12 EBS, Oracle 10g/11g, PL/SQ, and Report Developing Tools. Excellent knowledge and experience in functional and technical skills.
  • Oracle 11i/R12 EBS Applications - 10 Years

TECHNICAL SKILLS

Applications: Oracle Applications 11i, R12 (OM, INV, WMS, PO, WIP, ASCP, MRP, GL, AR, AP, FA, CRM, Oracle Projects & Billing, HR

Languages: PL/SQL, SQL, C, PERL, KSH Shell, XML, HTML, JAVA, JSP, JavaScript

Operating Systems: UNIX (HP-UX & SUN SOLARIS, AIX), Windows NT/2007, Windows XP, MS-DOS, IBM Mainframe, AS 400, P800

Development Tools: Developer 6i/10g Forms & Reports, XML Publisher, JDeveloper, Workflow Builder, Agile, Discoverer 10g, AIM, SQL*PLUS, TOAD, SQL Navigator, OBIEEWeb ADI, Informatica, Crystal Reports, PVCS, Data Loader, SVN, TFS, STAT

Databases: Oracle 10g/11g, Data Warehouse Builder, DB2, SQL Server, Access

PROFESSIONAL EXPERIENCE

Confidential, Schaumburg, IL

Oracle EBS System Consultant

Responsibilities:

  • As a UHG Team member, worked on designing and implementing the Oracle EBS R12 Applications.
  • Involved and Performed functional setup/development for a new Specialty System Project.
  • Work with business users to prepare and implement business requirements documents and Functional/Technical Design for Accounting Group.
  • Review and analyze business requirements and process configuration, mapping and management.
  • Assist with the support and ongoing enhancement of the Oracle E-Business Suite
  • Prepared Functional Design Documents for Retrobill, Sales order invoice, Credit Card Process, Tipsy hold process and Finance Reports.
  • Performed functional setup in Oracle EBS modules.
  • Tested Oracle RICE objects with Business Users using PL/SQL and Toad.
  • Worked and Tested with Order To Cash and Procure To Pay using oracle applications.
  • Assisting and Performing DEV, SIT and UAT Testing in Oracle e-business suite of Applications.
  • Created and modified SQL scripts, functions, triggers, procedures, tables and views.
  • Assists the application users in testing using Oracle EBS Applications.
  • Creating/maintaining users, responsibilities, menus, concurrent programs, workflow administration, and Printer configuration.
  • Created Service Request and follow up of using Oracle Metalink support for functional issues.

Confidential, Chicago, IL

IT Business Systems Analyst

Responsibilities:

  • As a Confidential Team member, worked on designing and implementing the Oracle EBS R12 Oracle Supply Chain Applications.
  • Involved and Performed functional setup/development for a new Global Greenfield Project. Work with business users to implement business requirements and created Functional Design Documents (MD-50) & Unit Test Plan.
  • Provide functional and technical support for interface integrations between MIS and Sanmina.
  • Define technical requirements, perform gap analysis, design solutions, and present delivery plans to business and technology partners.
  • Works closely with other IT business analysts, Developers, DBAs and domain experts.
  • Create and execute test plans for both custom and standard Oracle functionality. Worked with Business Partner in Testing and implementation objects in Production System.
  • Provide a solution to process multiples ASNs using Hard Reservation in OM.
  • Designed a solution for performance of Commercial Invoices and Packing Lists.
  • Performed configuration/setup in Oracle Modules.
  • Performed and Resolved Oracle Workflow related issues/errors.
  • Created SR’s with Oracle Technical Support and follow up of for using Oracle Metalink support for functional or technical issues.
  • Provide assistance to process of month-end. Assist with functional testing of monthly, quarterly and emergency patches.
  • Resolving production tickets using Oracle production applications.
  • Created and modified SQL scripts, functions, procedures, tables and reports.

Confidential

Oracle Technical/Functional Analyst

Responsibilities:

  • As Confidential Team member, worked on designing and implementing the Oracle R12 EBS Applications.
  • Worked with Order To Cash, Procure to Pay, and Manufacture Process.
  • Involved and Performed functional setup/configuration/development for a new company in existing oracle applications.
  • Work with business users to implement business requirements and created Technical Design Document (MD-70) & Unit Test Plan.
  • Designed, Coded, and Tested Confidential Order Process, Tax Reconciliation, and FedEx Outbound Interface programs.
  • Modified SP GL Ace Interface. Created a new interface to upload gl transaction using Web ADI.
  • Modified and Tested Uninvoiced Receipt, Pack Slip and Confidential Orders Reports using Publisher.
  • Modified and Tested Oracle RICE objects using PL/SQL, Stat, and Toad.
  • Resolving production tickets using Oracle production applications.
  • Creating/maintaining users, responsibilities, menus, concurrent programs, workflow administration, and Printer configuration.
  • Created Service Request and follow up of using Oracle Metalink support for functional or technical issues.

Confidential, Chicago, IL

Sr. Oracle Developer/Analyst

Responsibilities:

  • As a United Team member, worked on designing and implementing the Oracle EBS R12 Oracle Supply Chain/Financials and Projects Applications.
  • Coordinated and partipiciated the entire phase of the project which included initial operations analysis, business process re-evaluation, integration, testing, training, conversions, customizations and documentation and implementation of modules.
  • Designed and developed Conversion Programs for importing the data using PL/SQL and SQL*Loader for AOP Inventory/Purchasing Project. Created and Tested Interfaces using Inventory and transactions and Pos APIs.
  • Performed Journal Import Open Interface and Item import interface to import data.
  • Supporting and Maintaining Accrual Log application using Oracle Applications Framework (OAF), Web ADI, and Hyperion.
  • Prepared Functional Documents and worked with Off Shore Team for development and testing.
  • Performed standard setups/configuration in Financial and Oracle Supply Chain Modules. Working and Testing on Oracle Projects/Billing implementation.
  • Working and Testing Oracle Order Extract and Suppliers invoice package. Created and modified SQL scripts, triggers, packages, tables and views.
  • Supporting, Maintaining and resolving issues in Oracle applications. Resolving production issues durning Month End Period Close and coordinates with business users.
  • Designing and Developing Oracle Finance/Inventory Reports using OBIEE and Oracle Reports.
  • Coded and Tested SLA Non-3rd Party Journal Interface to create Journals using GL APIs.
  • Developed UNIX shell script to call control file and load the data into Staging Table.
  • Designed, planned and conducted functional testing. Developed and maintained test scenarios and test scripts for project team and end users.
  • Designed and modified Security Forms. Designed and tested finance/OM/PO related reports.
  • Resolving complex production issues for existing Organizations and fixes bugs in the programs.
  • Worked with TCS Consultants for developing and testing oracle objects.
  • Creating/maintaining users, responsibilities, menus, concurrent programs, values sets, functions, workflow administration, and Printer configuration.
  • Created SR’s with Oracle Technical Support and follow up of for using Oracle Meta link support for functional or technical issues.

Confidential

Oracle Technical/Functional Analyst

Responsibilities:

  • As an Confidential Team member, worked on designing and implementing the Oracle EBS11i/R12 Oracle Applications. - Order to Cash, Procure to Pay, and MFG Modules.
  • Coordinated and partipiciated the entire phase of the project which included initial operations analysis, business process re-evaluation, integration, testing, training, conversions, customizations and documentation and implementation of modules.
  • Involved and Performed functional setup/configuration for a new Sweden Organization to Oracle Financial and Supply Chain Modules.
  • Designing, coding, and testing interfaces, conversions, reports, forms, and extensions.
  • Developed and tested customers, Items, BOMs, Vendors, and Price Lists Conversions for Telair Sweden Implantation. Performed Import Process to load the data from interface to oracle tables.
  • Modified and Tested Lawson Financial and EDI Order Interfaces using APIs.
  • Performed Auto Invoice and Auto Create Process using Open Interfaces.
  • Designed, Modified and tested Employee Time Entry/ITAR forms and packages.
  • Designed and tested invoices/shipping related reports using XML Publisher, and Oracle Reports.
  • Performed and Resolved Oracle Workflow related issues/errors in OM.
  • Involved in designing and developing the Discoverer Workbooks, folders, Calculation items, Business areas, administering security and privileges.
  • Provide assistance to process of month-end, quarter-end and year-end close processes.
  • Performed technical specification design, development, unit testing, system integration testing, UAT and maintenance of Oracle e-business suite of Applications.
  • Assisting and Performing patche’s testing in dev, test, and production system.
  • Created and modified SQL scripts, functions, triggers, procedures, tables and views.
  • Assists the other developers in coding and testing using Oracle Applications.
  • Coordinate Oracle service requests and drive them to a final resolution for functional or technical issues.
  • Performed fundamental administrative tasks including registering applications, programs and reports.
  • Resolving complex production issues for existing Organizations and fixes bugs in the programs.

Confidential

Oracle ERP Business Analyst

Responsibilities:

  • As a consultant, worked on designing, coding, testing, and implementing the Oracle R12 ERP Applications.
  • Analyze, design and develop enterprise-wide application solutions based on the business requirements under ERP applications.
  • Involved in designing, coding, and testing interfaces, conversions, reports, forms, and extensions using Oracle ERP Modules.
  • Developed and Tested Items extract program using SQL, PL/SQL, and DB2 COF system.
  • Performed and Involved Item/Customer conversion, setup/uploaded new items/PTO models in the R12 ERP system.
  • Worked with consultants to prepared DRs and Technical Design documents on new business requirements. - Payment Term, Custom Credit fail, Export Compliance extensions.
  • Performed Order Import, Shipping and Auto Invoice process.
  • Worked with functional consultant to perform the setup in OM/AR/GL modules.
  • Modifying and tested customers and orders related reports using Oracle Reports.
  • Assisting and Performing SIT and CAT Testing for Oracle e-business suite of Applications.
  • Involved in design of AIM (Application Implementation Methodology) documents (MD-50,
  • MD-70) for conversion, interfaces, reports and extensions.
  • Created and modified SQL scripts, functions, triggers, procedures, tables and views.
  • Helping users/developers in R12 ERP modules.

We'd love your feedback!