SUMMARY:

• Overall more than 10 and 1/2 years of experience on Oracle Applications (ERP) as a Technical consultant(Oracle Order Management, Oracle Purchasing, Inventory, BOM, Account Payables, Account Receivables, Fixed Assets and GL modules)
• Has extensive knowledge and experience in Oracle Apps 11i, R12 and underlying Oracle Applications database architecture as well as Oracle database and development tools including PL/SQL, SQL*Plus, Forms 6i/10g, Reports 6i/10g, TOAD, Oracle Workflow
• Worked on oracle XML Publisher for generation of various custom reports and registered them in the applications
• Have sound knowledge in P2P and O2C cycles
• In - depth knowledge of Oracle API and Open Interfaces for Finance and Supply Chain Modules
• Experienced in functional and technical systems analysis & design, systems architectural design, presentation, process interfaces design, process data flow design, and system impact analysis and design documentation and presentation.
• Extensively worked on Developing Interface programs, customizing Forms and Reports. Developed PL/SQL Packages to perform Data Conversion, Migrations and to Manipulate and to process business rules on Oracle Database.
• Expertise in developing, customizing, modifying forms, reports existing in Oracle Applications according to the business requirements and specifications using Oracle Developer Suite 10g/6i(Forms, Reports).
• Strong programming experience in creating Procedures, APIs, Packages, Functions, Triggers, Views, records, sequences, Materialized views, Constraints and other database objects using SQL and PL/SQL.
• Experience in Performance Tuning & Optimization of SQL statements.
• Extensively involved in trouble shooting, debugging and fixing the codes/scripts.
• Proven experience in project and team leading. Equally comfortable working independently as well as in a team environment. Excellent problem solving skills, troubleshooting capabilities, learn new tools and concepts.
• More than 6 and half years of experience of working in a client facing role in US in an Onsite Offshore model

TECHNICAL SKILLS:

Database: Oracle

Language: PL/SQL, SQL, Python

Operating System: Unix, Windows

GUI: Oracle Forms 6i/10g, Oracle Application Framework(OAF)

Tools: Oracle Reports 6i/10g, XML Publisher, SQL Loader, Data Loader, TOAD, SQL Developer, WINSCP, VSS, PVCS, Putty, Workflow Builder version 2.6.3.5

Other Tools, Software Products & Language: JDeveloper, Discoverer reports, Informatica

PROFESSIONAL EXPERIENCE:

Confidential

Programmer Analyst

Languages/Tools: Oracle Forms, Reports, Discoverer, SQL, PL/SQL, Workflow, XML publisher, TOAD, WINSCP, Putty

• Worked on Oracle upgrade project from 11.5.10 to R12.2.4
• Developed data conversion programs for item category, purchase orders creation and cancellation in legacy system, on hand quantity conversion and issuing it out from legacy system, cost type and other custom setup conversions
• Wrote programs to update item transact able flag, default shipping org and other item attribute columns
• Worked on design, development and testing of various business functions using Oracle and related technologies (e.g. Oracle Forms, Reports, SQL, PL/SQL, Workflow, XML publisher)
• Prepared technical design documents and test cases.
• Provided day-to-day production support, including root cause analysis of issues.
• Followed code management process, including use of source-code control utilities(PVCS) and facilitated of migration of code across multiple Oracle instances.

Confidential

Senior Specialist

Languages/Tools: PL/SQL, SQL, TOAD,PVCS, Oracle Forms/Reports(6i/10g), Informatica, OAF, Workflow Builder

Responsbilities:

• Code, test, debug, and document complex programs, and enhance existing programs to ensure that data processing production systems continue to meet user needs
• Worked on development for Oracle Forms, conversions, interfaces and extensions.
• Created Procedures, APIs, Packages, Functions, Triggers, Views, records, sequences, Materialized views, Constraints and other database objects using SQL and PL/SQL.
• Write detailed technical design documents before building application solutions for the business requirements.
• Analyze and resolve production normalization cases that are opened by business users.
• Responsible for release coordination activity for migration of the developed solutions to testing and the production environment.
• Working in Back-to-back Order fulfillment business process
• Worked on design and development for concurrent program to create Blanket Purchase Orders, Standard Purchase Orders, ASN Receiving and Return to Vendor(RTV) processes and Account Payables Invoice/Debit memo creation
• Worked on resolving issues related to Purchase Requisition creation, PO creation based on the PR, Receipt creation and PO price updates, LPN Creation and LPN Packing
• Worked on design and development for concurrent programs for build to stock(BTS) processes such as Work Order creation, ASN receiving and Transacting Work Orders, Consigned PO and Consumption Invoice creation
• Co-ordinate with business teams and technical teams to create and deliver the solutions that meet the requirements
• Interacting with Oracle via their formal Metalink SR process in order to secure assistance and solutions for problems which needs support from Oracle
• Modified existing custom OAF page to make field mandatory

Confidential, Wisconsin, US

Technology Lead

Languages/Tools: PL/SQL, SQL, TOAD,PVCS, Workflow Builder, SQL Loader, Data Loader, WINSCP

• Requirement gathering, co-ordination with offshore team, development of components and sign offs.
• Leading the team for integration between Oracle Applications and Siebel in terms of designing the interfaces, code development, review and testing
• Worked on customizations using Oracle XML Publisher reports, Oracle forms, PL\SQL, Forms Personalization, data conversions and interfaces
• Completing technical analysis of issues encountered during test cycles
• Creating and following up Service requests with Oracle for Product issues.

Confidential, Wisconsin, US

Technology Lead

Languages/Tools: PL/SQL, SQL, TOAD,PVCS, Workflow Builder, SQL Loader, Data Loader, WINSCP, Oracle Forms/Reports(6i)

• Requirement gathering, co-ordination with offshore team, development of components and sign offs.
• Worked extensively on Oracle Shipping reports and pick release and ship confirm processes
• Worked on customizations using Oracle XML Publisher reports, Oracle forms, PL\SQL, Forms Personalization, data conversions and interfaces
• Creating and following up Service requests with Oracle for Product issues.
• Coordinating different teams like DBAs and EDI team for integration testing.
• Completing technical analysis of problems faced by various team members
• Designed and completed development of Label Printing program for Zebra printers and has been appreciated by client

Confidential

Senior Software Engineer

Languages/Tools: PL/SQL, SQL, TOAD,PVCS, Workflow Builder, SQL Loader, Data Loader, WINSCP, Oracle Forms/Reports(6i)

• Preparing technical design of various component
• Co-ordination with onsite team and getting reviews done
• Worked on customizations using Oracle XML Publisher reports, Oracle forms, PL\SQL, Forms Personalization, FNDLOAD and interfaces
• Worked with DBA team for code migration
• Resolved defects and completing enhancements requested by client
• Worked on Oracle OM,WOP,BOM,INV, Engineering modules

Confidential

Software Engineer

Languages/Tools: PL/SQL, SQL, TOAD,PVCS, Workflow Builder, SQL Loader, Data Loader, WINSCP,OAF, Oracle Forms/Reports(10g)

• Completing technical design and development of various components
• Worked on customizations using Oracle Reports, Oracle XML Publisher reports, PL\SQL
• Developed custom OAF pages for Resource Maintenance Tracking system to search, create and update resource
• Resolved defects and completing enhancements requested by client
• Worked mainly on Oracle WMS and Purchasing modules

Confidential

Software Engineer

Languages/Tools: PL/SQL, SQL, TOAD,PVCS, Oracle Forms/Reports(6i), SQL Developer

• Resolved various defects and worked on enhancements requested by client
• Co-ordination with onsite team member
• Prepared test plans for all the defects and enhancements which were appreciated by client
• Most of the enhancements and defects were related to Oracle Foms and Reports