Oracle Ebs & Soa Developer Resume
2.00/5 (Submit Your Rating)
NC
SUMMARY:
- Over 7 years of IT experience in ERP implementation and Enterprise Applications Practice with proven experience in Developing.
- Customizing, Workflow, forms, reports, Supporting/Maintenance and Migrating / Up gradation of Oracle Applications E - business Suite R12 & R11i.
WORK EXPERIENCE:
Confidential, NC
Oracle EBS & SOA Developer
Duties & Responsibilities:
- Working as a Process Specialist for Support and upgradation of Oracle EBS R-12.2.9 & SOA
- Involved in design, development and testing of new and existing Interfaces using PL/SQL to interface non-oracle and Oracle systems to Oracle applications Modules AR, GL, AP, FA, OM, SCM, INV, Service Contracts. All the interfaces were registered and run through the concurrent manager.
- Working on the upgradation R12.1.3 to R12.2.9. And in which I am managing all modules testing and rechecking all customized and standards forms, reports, procedures, functions and workflows.
- I am also working on SOA 12C. In which successfully completed numerous SOA projects leveraging Oracle fusion middleware.
- Extensively used Components such as Oracle File FTP Adapter, DB Adapter, BEPL, Oracle Mediator, Oracle Service Bus (OSB), Oracle Business Activity Monitoring (BAM), Human tasks and business rules
- Extensively used Oracle MDS to store common artifacts.
- Working on bug fixing, change requests, testing and deployments of SOA composites and OSB services
- Working on EJB, JMS, JDBC, XPath and XSLT (Java EE), Soap and Rest services
- Ensure standards and requirements are met through conducting quality assurance tests
Confidential
Oracle EBS Developer
Duties & Responsibilities:
- Worked as a Project Coordinator for Support of Oracle EBS R-12.
- I worked on Oracle PL/SQL, customized forms, reports as well as data warehousing, interfacing, data conversions, opening balance uploads, and server maintenance.
- I managed basic functional tasks like supplier open, customer open, inventory item opening, also work on oracle implementation methodologies like AIM and OUM.
- Conducted and improved database performance tuning by SQL statements, index tuning, creating materialized views.
Confidential
Assistant Consultant Oracle EBS R-12
Duties & Responsibilities:
- Five full cycle implementations of Oracle EBS R-12: Oracle (SCM) Supply Chain Management, Order to Cash(O2C), procure to pay(P2P), Inventory, Purchasing Order Management, (Accounts Receivable -AR, Accounts Payable -AP, General Ledger - GL, Fixed Assets - FA) and Discrete Manufacturing.
- Actively involved in gathering, analyzing and documenting business requirements to support development of quarterly releases.
- Executing the application configuration changes and ensuring that they are documented.
- Actively supporting the master data management team for recipe releases.
- Having excellent experience in development & maintenance of Oracle Applications R12& R11i
- Highly conversant with various modules of Oracle Applications Release R12 & R11i (SCM, MFG, Distribution, FIN & HRMS)
- Analyze, design develop, troubleshoot and debug software programs for commercial or end user applications. Writes code, completes programming, and performs testing and debugging of applications.
- Good at development of interface and conversion programs for EDI using ODI, PL/SQL and Oracle Standard APIs.
- Carried out comprehensive scenario testing and user acceptance testing well before Go-live making sure that all scenarios are catered enabling smooth transition to Oracle.
- Created Customized forms and Reports.
- Provided system support after implementation resolving issues quickly, identifying reporting requirements, assisting client with reconciliation after closing of the accounting periods.
- Created and maintained PL/SQL scripts and stored procedures. Designed, developed and maintained data extraction and transformation processes and ensured that data is properly loaded and extracted in and out of our systems.
- Involved in Oracle EBS Upgradation from R12.1.3 to R12.2.5
Confidential
INV, PO, AP, AR, FA, GL, BOM, WIP, BOM, OM, iProcurement, receivables and HCM
Duties & Responsibilities:
- Designed Technical Design for Oracle EBS inbound interfaces, extensions & reports.
- Involved in Oracle EBS Upgradation from R12.1.3 to R12.2.5
- Involved to support workflows and frame work.
- Created Customized forms and Reports.
- Procure to Pay (P2P) and Order to Cash (O2C) Validations and Form Personalization
- Working on Interface validations for third party system Hybris & AS400 systems for Customers (TCA), Orders (OM) & Receivables (AR).
- PO Requisition, Open PO and PO receipt conversions using Interface.
- Developed a conversion program to convert Fixed Assets from legacy system to oracle Fixed Assets (FA).
- Involved in developing open interface to transfer the data from Oracle Payables to base tables of Fixed Assets (FA).
- Working as OM & AR Modules Expert Resource at Client site to Review and Define Functional Setups, Development and Enhancements various customizations of Oracle Receivables Module.
- Created New DFF's and Lookups in Oracle Receivables Module. Ensuring full traceability of deliverables throughout the project lifecycle using various tracking tools and Oracle AIM documentation.
- Interfacing of Oracle Payables and Receivables with legacy system.
- Customized multiple reports and forms in GL, AP, PO, AR and OM modules according to the requirements.
- Customized Transaction register, Adjustment report, Receipts Register, Aging 7 buckets or 4 buckets Reports in Account Receivables (AR)
Confidential
INV, PO, WIP, BOM, AP, OM, AR, GL, SCM
Duties & Responsibilities:
- Oracle Financial and SCM Implementation of R-12
- Involved in Oracle EBS Upgradation from R12.2.0 to 12.2.4
- Development of Bill of Material and automatic creation of purchase requisition, Routing, BOM and WIP jobs.
- Custom API’s using PL/SQL (Business Logic)
- Order to Cash (O2C) Validations.
- Cloning of R12.2.4 and Customized XML and PDF reports and form personalization.
- Developed an inbound interface for open Payable Invoices, Suppliers, Supplier Sites, Supplier Contacts, Banks, Bank Branches, and Bank Accounts, etc. from legacy system to Payables.
- Creating and Registration of concurrent programs, forms and reports through AOL.
- Developed outbound interface to extract supplier details data including Payment details with Check for a wide range of dates using UTL FILE Package.
- Involved to Developing and deploying Oracle & Discoverer Reports 10g.
Confidential
INV, PO, WIP, BOM, AP, OM, AR, GL
Duties & Responsibilities:
- As a Team member interact with Team lead and Manager for requirements.
- Study the Functional Design Documents (MD 050) for requirement and gathered requirements from Client.
- Study the Requirements and interact with Onsite Business Analysts and business users.
- Testing the developed components with front and Applications.
- Involved in customize the Product.
- Developed custom reports, discoverer reports and registered with Oracle Applications.
- Customization of standard reports in different modules.
- Created different types of value sets.
- Worked on Purchasing Documents Open Interface to import Standard PO, Blanket PO into the PO Module using SQL*Loader and UTL file in PL/SQL
- Customized Reports in OM and inventory.
- Worked on different kind of concurrent programs like SQL*Plus, PL/SQL
- Extensive use of PL/SQL programming like Procedures, Functions, Triggers & Packages and Used Dynamic SQL in stored procedures.
- Involved in preparation of Technical Design Documents based on Functional Design Documents
- Fixing Bugs in Forms and Reports previously designed.
- Development of screens in forms using oracle at backend according to the requirements of Clients.
- Registration of reports using AOL script.
- Designing the Technical Documents for the Assigned Components.
- Testing with available data in the modules like Purchasing and Inventory.
- Involved in testing of components, which peers developed.
Confidential
Responsibilities:
- My role is to adapts existing methods and procedures to create possible alternative solutions to moderately complex problems.
- Application Programmer/Analyst responsible for evaluating, customizing, developing, monitoring and supporting Oracle Applications.
- Set standards and best practices for application development.
- Developed, supported and enhanced existing customizations to Oracle Applications.
- Preserves assets by implementing disaster recovery and back-up procedures and information security and control structures.
- Documented code in accordance with company policies, company standards and industry best practices.
- Developed technical system documentation.
- Developed and maintain the complete HRM Management System of Employees; planning, monitoring, and appraising employees record; coaching, counseling, and disciplining employees; initiating, coordinating, and enforcing systems, policies, and procedures.
- Developed and maintain the complete Salary Management System of Employees; planning, monitoring, and appraising employees record; coaching, counseling, and disciplining employees; initiating, coordinating, and enforcing systems, policies, and procedures.
- Recommends information technology strategies, policies, and procedures by evaluating organization outcomes; identifying problems; evaluating trends; anticipating requirements.
- Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.
- Created and maintained PL/SQL scripts and stored procedures. Designed, developed and maintained data extraction and transformation processes and ensured that data is properly loaded and extracted in and out of our systems.