Oracle Ebs System Consultant Resume
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.