Oracle Apps Technical Developer Resume
Lincolnshire, IL
PROFESSIONAL SUMMARY:
- 9.2 years of experience as Oracle EBS Senior Developer in Oracle E - Business Suite Application (Release 12/11i) providing Solutions of Implementation, Upgrade, Maintenance, Testing and Production Support.
- Extensive experience in Oracle Apps such as Order Management (OM), Inventory (INV), General Ledger (GL), Account Receivables (AR), Purchasing (PO), Work in Process (WIP), AOL, Trading Community Architecture (TCA) and Account Paybles (AP), Cash Management (CM).
- Extensive knowledge in all phases of Software Development Life Cycle (SDLC)
- Expertise in Client Interaction, Requirement Gathering, Process walk through, Mapping, GAP Analysis and Technical Design documentation and Full lifecycle implementations, Upgrades.
- Experience in Requirements analysis, Design and Testing Enterprise level Applications
- Experience in the preparation of Functional Design, System Design (MD 50) and Technical Design documents.
- Extensive knowledge and work experience in design and development of database applications in Client/Server environment using Oracle Developer tools Forms (6i & 9i), Reports (6i & 9i), PL/SQL Developer, Workflow Builder and TOAD.
- Experience working on end-to-end Order to Cash (OTC) and knowledge of Procure to Pay (P2P)
- Proficient in SQL and PL/SQL and Advanced PL/SQL
- Experience in Creating Stored Procedures, Functions, Packages, Triggers, Views and Indexes and also in tuning the sql queries for improving the performance
- Experience of developing conversion programs and Interfaces (Inbound & Outbound)
- Good knowledge in using performance-tuning utilities like EXPLAIN PLAN, SQL Trace and TKPROF
- Extensive experience in registering Concurrent Programs, Form, Functions, Menus, Tables, developing Key and Descriptive Flex-fields in Custom Applications and defining Profile values by using Application Object Library (AOL) and System Administration in Oracle Applications
- Experience in developing in Reports and XML Publisher/ BI Publisher and custom workflows using oracle Workflow Builder
- Efficient in UNIX shell scripting
- Experience in using tools like TOAD, PLSQL Developer, SQL Developer, SQL *Loader, Data Loader, FND LOAD
- Good Knowledge on JAVA OOPS Concepts, SOA and OA Framework
- Working Experience at Different Locations Offshore& Onsite (India, USA)
- Exceptionally well organized with Strong Communication, Inter-personnel, Analyzing Skills and a desire to learn new technologies and tools
- Good problem solving and trouble shooting skills, highly motivated and ability to work as an individual or as a dynamic member in a team
TECHNICAL SKILLS:
ERP: Oracle Applications Release 11i & R12
Databases: Oracle 9i, 11g.
Programming Languages: SQL, PL/SQL,XML & UNIX
Development Tools: Forms & Reports 6i/10g, Xml Publisher, Workflow builder
ERP Modules: OM, INV, AR, GL, TCA, CM, PO, WIP and BOM
Version Control: Clear case, RCS
Migration Control: Kintana
DB Tools: Toad, SQL Developer and PLSQL Developer
PROJECT EXPERIENCE:
Confidential, Lincolnshire, IL
Oracle Apps Technical Developer
Responsibilities:
- Analyzing system requirement mappings for business requirements, evaluate the gaps.
- Perform proof of concepts for technical feasibility and impact analysis
- Implementing project using Oracle Application Implementation Methodology (AIM)
- Involved in requirement review meetings with Business Analyst on MD.050 documents
- Working on Order Managment Outbound interfaces and xml publisher reports to develop custom pack slip and trip related reports
Confidential, WEBSTER, NY
Oracle Apps Technical Developer
Responsibilities:
- Interactions with business users to understand the business requirements and help them for preparing use cases.
- Analyzing system requirement mappings for business requirements, evaluate the gaps.
- Perform proof of concepts for technical feasibility and impact analyses.
- Implementing project using OUM (Oracle Unified Method) standards
- Requirement review meetings with functional analyst on AN-100 documents.
- Mapping system requirement into DS-140 document.
- Review meetings with Stake holders (Functional analyst, Business Owners, Delivery manager).
- Attended conference Room Pilot Meeting (CRP) during multiple phase of the project.
- DS-140 document Review and approval with stake holders (Delivery manager).
- Worked on mainly OM and INV modules
- Developed Order Import interface to load the orders into Oracle EBS System from Legacy Systems
- Worked on different order types like Sales order, Back to Back Order and Drop Ship Orders.
- Developed Item Import, BOM and Routing, Sales Order Conversion and On-hand conversions.
- Responsible for conducting the complete cycle of testing in O2C (Order to Cash)
- Code/Build as per technical design and coding standards.
- Developed PL/SQL packages as per new requirements
- Modified the existing packages
- Modified the custom forms and reports
- Performed Unit testing for components developed.
- Co-ordinate with offshore team members
- Making sure Code goes through internal quality audit (IQA) and External quality audit (EQA).
- Attended Weekly status review meetings for deliverables with stake holders.
Environment: Oracle Applications 11i (BOM, WIP, INV, OM, AOL, SYSADMIN) and Oracle Applications R12, Oracle 11g, PL/SQL, SQL, Forms 10g, Reports 10g, SQL*Loader, Windows XP
Confidential, WEBSTER, NY
Oracle Apps Technical Developer
Responsibilities:
- Interactions with business users to understand the business requirements and help them for preparing use cases.
- Analyzing system requirement mappings for business requirements, evaluate the gaps.
- Perform proof of concepts for technical feasibility and impact analyses.
- Requirement review meetings with functional analyst on system requirement document (SRD).
- Mapping system requirement into system design document (SDD) and completing the SDD.
- Review meetings with Stake holders (Functional analyst, Business Owners, Delivery manager).
- Mapping system design document to technical design document (TDD).
- Technical Design document Review and approval with stake holders (Delivery manager).
- Code/Build as per technical design and coding standards.
- Developed PL/SQL package
- To automate assigning items to new org and copying item attributes for given from organization to the To organization.
- To automate the stock locator creation in new organization from given FROM organization
- To automate the ship method assignment in new organization
- Responsible for conducting the complete cycle of testing in O2C (Order to Cash)
- Modified the existing PL/SQL packages to meet the business requirement.
- Worked on the existing packages those needs to be tuned to improve the performance
- Worked on Order management, shipping and Discrete manufacturing modules
- Developed custom Reports as per business requirements
- Prepared Test plans and use cases for interface testing.
- Performed Unit testing for components developed.
- Co-ordinate with offshore team members
- Making sure Code goes through internal quality audit (IQA) and External quality audit (EQA).
- Provided support for:
- Integration Testing.
- Functional Testing support.
- User Acceptance Testing Support.
- Attended Weekly status review meetings for deliverables with stake holders.
- Provided Burn-In support after go-live
Environment: Oracle Applications R 12.2.0 (BOM, WIP, INV, OM, AOL, SYSADMIN), Oracle 11g, PL/SQL, SQL, Forms 10g, Reports 10g, SQL*Loader, Windows XP
Confidential, WEBSTER, NY
Oracle Apps Technical Developer
Responsibilities:
- Interactions with business users to understand the business requirements and help them for preparing use cases.
- Analyzing system requirement mappings for business requirements, evaluate the gaps.
- Perform proof of concepts for technical feasibility and impact analyses.
- Requirement review meetings with functional analyst on system requirement document (SRD).
- Mapping system requirement into system design document (SDD) and completing the SDD.
- Review meetings with Stake holders (Functional analyst, Business Owners, Delivery Manager).
- Mapping system design document to technical design document (TDD).
- Technical Design document Review and approval with stake holders (Delivery manager).
- Code/Build as per technical design and coding standards.
- Developed PL/SQL package to automate the BACK Order process which can run by user if any damaged goods found in the order.
- Modified the existing PL/SQL packages to meet the business requirement.
- Developed custom Reports as per business requirements
- Worked on existing Reports and Forms remediation as per requirements.
- Prepared Solution Design and Technical Design documents.
- Responsible for conducting the complete cycle of testing in O2C (Order to Cash)
- Prepared Test plans and use cases for interface testing.
- Performed Unit testing for components developed.
- Co-ordinate with offshore team members
- Making sure Code goes through internal quality audit (IQA) and External quality audit (EQA).
- Provided support for:
- Integration Testing.
- Functional Testing support.
- User Acceptance Testing Support.
- Volume Testing Support.
- Regression Testing Support.
- Attended Weekly status review meetings for deliverables with stake holders.
- Provided Burn-In support after go-live
Environment: Oracle Applications 11i (INV, OM, WSH, WIP, BOM), SQL, PL/SQL, Unix, Oracle Forms and Oracle Reports.
Confidential, WEBSTER, NY
Oracle Apps Technical Developer
Responsibilities:
- Interactions with business users to understand the business requirements and help them for preparing use cases.
- Analyzing system requirement mappings for business requirements, evaluate the gaps.
- Perform proof of concepts for technical feasibility and impact analyses.
- Requirement review meetings with functional analyst on system requirement document (SRD).
- Provide approvals for System requirement documents.
- Mapping system requirement into system design document (SDD) and completing the SDD.
- Review meetings with Stake holders (Functional analyst, Business Owners, Delivery manager and VCPs).
- Mapping system design document to technical design document (TDD).
- Technical Design document Review and approval with stake holders (System architect and Delivery manager).
- Code/Build as per technical design and coding standards.
- Developed and modified the existing PL/SQL packages and interfaces for the identified requirements.
- Developed package to automate the WSH shipping process using standard APIs.
- Developed Reports as per business requirements
- Worked on existing Reports and Forms remediation as per requirements.
- Worked on the fix script to update the data in custom orders table which has million records.
- Worked on the packages that has performance issues
- Prepared Test plans and use cases for interface testing.
- Performed Unit testing for components developed.
- Co-ordinate with offshore team members
- Making sure Code goes through internal quality audit (IQA) and External quality audit (EQA).
- Provided support for:
- Integration Testing.
- Functional Testing support.
- User Acceptance Testing Support.
- Volume Testing Support.
- Regression Testing Support.
- Scheduled Weekly status review meetings for deliverables with stake holders.
- Provided Burn-In support after go-live
Environment: Oracle Applications 11i & R12.2.0 (INV, OM, WSH, WIP), SQL, PL/SQL, Unix, Oracle Forms and Oracle Reports.
Confidential, Webster, NY
Oracle Apps Technical Developer
Responsibilities:
- Involved in identifying Custom Component Impact Analysis & Remediation
- Responsible for setting up the chart of Accounts and related setup changes.
- Prepared the fix scripts for identified custom components
- Performed Unit test for respective custom components
- Modified the existing Oracle Reports and Forms to accommodate the changes.
- Identified the workflows that need to remediated and prepared fix script to accommodate the changes
- Involved in preparation of test plans and use cases for all such scripts
- Developed solution (System and Technical) design documents for customized components
Environment: Oracle Applications R12 (INV, OM, GL), SQL, PL/SQL, Oracle Forms and Oracle Reports and UNIX.
Confidential, Webster, NY
Oracle Apps Technical Developer
Responsibilities:
- Obtain a sneak-peek into the prevailing algorithm and activity of arriving at optimal inventory stocking positions.
- Identified gaps and designed custom components to fill the gaps
- Developed PL/SQL custom packages to fetch the demand of given inventory
- Developed PL/SQL custom packages to load the minimum and maximum quantities of given inventory which comes from feed file.
- Preparation of test plans and use cases for interface testing
- Supported System Integration testing
- Supported User Acceptance testing
- Production movement
- Post production warranty support
- Involved in preparation of test plans and use cases for all such scripts
- Developed solution (System and Technical) design documents for customized components
- Developed interfaces to accommodate complex business requirements.
Environment: Oracle Applications 11i (INV, OM, Field Service), SQL, PL/SQL, Oracle Forms and Oracle Reports.
Confidential, Webster, NY
Oracle Apps Technical Developer
Responsibilities:
- Involved in analyzing and understanding the business requirement.
- Prepared project Plan/Estimates
- Developed the custom interfaces and custom reports using report builder 6i
- Prepared the Solution Design Document and Technical Design Document
- Involved in preparation of test plan and test scenarios.
- Performed Unit Testing for the components developed by me.
- Provided Technical assistance to team members.
- Prepared Status Reports and Represented offshore team in Weekly and Monthly.
Environment: Oracle Applications 11i (INV, OM), SQL, PL/SQL and UNIX
Confidential, Schaumburg
Oracle Apps Technical Consultant
Responsibilities:
- Involved in analyzing and understanding the business requirement.
- Good experience in interacting with customers to understand their technical queries and provide assistance in resolution.
- Defined Shipping rules for the Mixed and Return orders
- Developed custom reports using XML publisher
- Developed XML reports to be fired at Pick releasing the order and Shipping the order.
- Modified the existing interfaces and supporting Stored Procedures to resolve the issues raised
- Invoice Generation for the eligible orders in Receivables and importing the data to GL.
- Created Technical documents and Unit Test Plans.
- Performed Unit Testing.
Environment: Oracle Applications R12 (OM, AR and GL), SQL, PL/SQL, XML Reports, Oracle Forms and UNIX.