PROFESSIONAL SUMMARY:

• 10 years of IT Experience - Performing functional and technical work Implementation, Migration, Customization, Extension, Production support of various business applications using Oracle Applications E-Business Suite.
• Experienced on complete Software Development Life Cycle (SDLC) using various methodologies like Waterfall Model and Scrum.
• Involved in the Design and Development of applications using SQL, PL/SQL, Oracle Database 8i/ 9i/10g/11g, 11i and R12 Oracle Forms, Oracle Reports, and Oracle Workflows.
• Good Technical & Functional knowledge of Oracle 11i and R12.
• Oracle Applications Framework, XML Publisher, Oracle Workflow Builder, Java,, ADF, OAF, Oracle Forms, Oracle Reports and/or Oracle Web technologies like SOA 11g .
• Excellent knowledge of order processing cycles Procure to Pay (P2P) and Quote to Order (O2C) cycles.
• Worked in 11i and R12 Oracle Applications in Modules like OM, INV, PO, OIC, WMS, WIP, BOM, GL, and AP.
• Completed training on Oracle Fusion Middleware 11g: Build Applications with ADF I Ed 2
• Having good Knowledge in the concepts of Multi org/MOAC and flex fields.
• Good Knowledge in developing Xml Publisher Reports/BI Publisher, OAF and ADF Application and SOA Web Services. BPEL and Mediator(ESB)
• Personalized various forms in different modules using Form Personalization.
• Excellent skills in Application Development using Forms, Reports and developing Interface/Conversion Programs to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader, UTL file, etc.
• Experience in Full Life-cycle implementations of Oracle E-Business Suite.
• Analyze user requirements and create design documents from user requirements.
• Study and analyze existing technology architecture and create estimates from requirements and design documents.
• Good knowledge in AIM Methodology, Designing and Developing RICE components.
• Solving business problems with application (Oracle 11i/12i) functionality.
• Good knowledge in UNIX and shell Scripting.
• Have worked on development of OAF and ADF Applications.
• A highly motivated, energetic individual and a team player with excellent analytical & problem solving skills, communication skills and interpersonal skills.
• Ability to adapt to a changing environment & can work in diverse team environment.
• Experience in Performance Tuning & Optimization of SQL statements.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Ability to work individually as well as in a team with excellent problem solving skills, troubleshooting capabilities, learn new tools and concepts.
• Involved in preparing the functional specification, technical documentation, schema documents, test cases, flowcharts, production support and user support documents using AIM methodologies.

TECHNICAL SKILLS:

ERP: Oracle Applications 11i, R12, AOL, INV, PO, AP,GL, WMS, OM

Languages: SQL, PL/SQL, ADF, BI Publisher

RDBMS: Oracle 9i, Oracle 8i, Oracle 10g, Oracle 11i/R12

Tools: and Utilities: SQL *Loader, UTL FILE, FNDLOAD, Workflow, Oracle Reports Builder, Oracle Forms Builder, ADF and SOA web service.

Third Party Applications: TOAD, PUTTY, WINSCP, ECMS, Jet forms

O.S: UNIX, Windows 2000, XP, TFS, MKS, CVS

PROFESSIONAL EXPERIENCE:

Confidential

SENIOR ORACLE EBS DEVELOPER

RESPONSIBILITIES:

• Design, analyze, code, test, debug, modify and document moderately complex applications requiring thorough knowledge of business applications and Confidential processes .
• Designs applications and services according to Confidential technical design standards in an Oracle EBS environment including the creation and communication of the technical design documentation.
• Troubleshoots application problems and works with inside and outside resources including Oracle Customer Support as necessary to resolve them.
• Quickly convert concepts and ideas into solutions through the preparation of detailed specifications consistent with the IS development methodology for business application projects and customizations that will be integrated with existing applications.
• Analyze and modify existing business applications and processes, and provide recommendations for system and process improvements.
• Diagnose and resolve problems in the maintenance and support of business applications.
• Interact with client and technical teams to define requirements, resolve issues and develop solutions.
• Provide input when reviewing new business application designs to ensure consistency with business objectives and technical standards.
• Operate within a complex product and business environment requiring the ability to manage multiple requests. Able to work independently and maintain focus on priority tasks.
• Collaborate with the business and management teams to develop efficient plans, processes, timelines and work required for addressing all identified support and upgrade activities.
• Partner with end-users and technical staff to diagnose and resolve problems relating to a variety of business processes.

Confidential

ORACLE APPLICATION DEVELOPER II

RESPONSIBILITIES:

• Develops applications and services according to technical design documentation, including form extensions, custom PL/SQL for application integrations, data fixes in coordination with Oracle customer support, and in general any in-flow or out-flow of data from the core business systems.
• Troubleshoots application problems and works with inside and outside resources including Oracle Customer Support as necessary to resolve them.
• Reads, understands, and follows technical design documentation.
• Designs applications and services according to BH technical design standards in an Oracle EBS environment including the creation and communication of the technical design documentation.
• Uses appropriate tools to streamline development and support of applications and services.
• Enables the security of applications and services with adherence to security best practices and security standards, as specified in the technical design documentation, has ability to establish and contribute to security strategy.
• Performs and coordinates production release activities such as code migrations as necessary to support business requirements and operations schedules.
• Writes and follows written test plans to ensure highest quality work.
• Review and diagnose other developer's code to solve production problems.
• Analyze high level business requirements and design strategic solutions for business problems.
• Work with functional leaders to define processes and then translate same into automated solutions in the Oracle EBS system, using existing functionality where possible.

Confidential

SR.ERP CONSULTANT Onsite

RESPONSIBILITIES:

• Worked on OM, HRMS, AP and GL.
• Develop effectively handled project management activities - project Requirement Gathering, defining technical specifications, Coding, Testing, Worked in Conversion and extension Components.
• Interacting with business for understanding the requirement and prepared technical specification, test plans and test cases.
• Involved in Design and Development of RICE components - Procedures, Packages, Functions, Triggers, Reports and Extensions using PL/SQL, Stored Procedures, Triggers, API’s.
• Developed PL/SQL package to validate the customer sites data for importing or updating in oracles apps base tables.

Confidential

SR.ERP CONSULTANT

• Interacting with client for understanding the requirement documents and prepared technical specification, test plans and test cases.
• Development & Review of code changes, test procedure, test plans and other deliverables.
• The modules involved: PO, HRMS WMS and OM for Extension, Reports and Conversion.
• Well Familiar with System Administrator, Application Object Library (AOL), and Oracle (Application Program Interface) APIs.
• Involved in Design and Development of RICE components - Procedures, Packages, Functions, Triggers, Reports and Extensions using PL/SQL, Stored Procedures, Triggers, API’s.
• Involved in Major and Minor Enhancements.
• Developed Interface in Oracle Inventory based on data sent from warehouse in flat file.

Environment: PL/SQL, Shell Scripts, Oracle 10g/11g/R12, UNIX, TOAD, PUTTY.

Confidential

SR.ERP CONSULTANT

RESPONSIBILITIES:

• Getting the functional inputs from the users and worked on the technical enhancements.
• Analyzed business requirements, designed, implemented business solution design and development.
• Created and customized reports using XML Publisher in OM, BOM, WMS, AP and INV.
• Prepared the Technical Design documents, Installation documents and Unit Test Case documents.
• Developed workflow to send notifications to users by using oracle work flow builder.
• Customized Workflows as per the client requirements.
• Worked with Discoverer so users would have the ability to generate ad-hoc reports.
• Experience includes application system administration activities such as user setup, defining responsibilities, value sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs, providing support to apps users for any technical and functional issues.
• Prepared the SQL scripts for creating the concurrent programs, executable and parameters in Oracle applications.
• Uploaded all the concurrent program, Value sets and Responsibilities details into another instance by using FNDLOAD commands.
• Creation of Value sets in various Modules of the application.
• Involved in implementation of Interface between Oracle Apps and Seibel using API and concurrent program.

Environment: Oracle apps, PL/SQL, Shell Scripts, Oracle 10g/11g/R12, UNIX, Reports 10g, Forms 10g, SQL*Loader.

Confidential, CA

Senior System Analyst --Offshore

• Effectively handled project management activities - project Requirement Gathering, defining technical specifications, Coding, Testing, Worked in Conversion and extension Components.
• Involved in coding and implementation of the project (Extension).
• Involved in implementation of Workflow, forms and XML Publisher.
• Involved in preparation of technical design documents and unit test cases for the change requests/enhancements.
• Involved in coordinating with Client and Offshore Team for clarification on technical Issues.
• Developed Find Form, XML Publisher Reports and API for Application.
• Developed interface to import Journals from external system into oracle apps general ledger tables.
• Customized shell script to call sql*loader for importing the data from flat file to staging table.
• Developed shell script to send the notification to the specified email list contains an attachment having failed records in validation.
• Developed PL/SQL package to validate the customer sites data for importing or updating in oracles apps base tables.
• Developed preprocess program to modify the Asset Tag numbers.
• Team Lead for 4 Developers at Offshore.
• MoneyGram International, Inc.

Environment: Oracle apps, PL/SQL, Shell Scripts, Business Objects 6x, Discoverer4i, Oracle 9i, Oracle Applications 11.5.8 (OM, INV, WIP, BOM, AP) UNIX

Confidential

Senior System Analyst - OIC Module-Offshore

• As a developer involved in coding and implementation of the project Modules (Oracle Incentive Compensation- OIC).
• Involved in preparation of technical design documents, Coding and unit test cases for the change requests/enhancements.
• Created Packages and Procedure for client requirement.
• Functional and system test execution including regression testing
• Interact with client for requirement gathering and clarification for any change request.
• Worked for both development as well as support assignments.
• Participated in taking KT’s at both offshore and on shore end.
• Maintaining VSS.
• Job responsibilities include creating database objects like tables, indexes, views etc. import and export of data using oracle utilities.
• Involved in developing packages for implementing business logic through Procedures and functions.
• Responsible for following the development standards as per the project.

Environment: Oracle Apps and PL/SQL

Confidential

System Analyst - OM, PO, BOM, INV and GL

• Involved in coding and implementation of the project Modules. (OM, BOM, WIP, AP, GL and INV.)
• Involved in preparation of technical design documents and unit test cases for the change requests/enhancements.
• Worked on Sales Workbench, a tool developed for Arrow Electronics, Unity program. Was involved in analysis, technical documentation, development, review activities.
• Worked in rapid application development methodology for Arrow and was a part of Sprint team.
• As a Techno Functional consultant responsible for creating multiple conversions to support client's migration from a legacy system to Oracle ERP suite of applications including WIP, BOM, Purchasing, Inventory, and Order Management.
• Imported Bills and Routings through BOM Interfaces.
• Developed Work Order Interface to import discrete job information into oracle apps base tables.
• Created Shell script program to call the SQL loader program that transfers data in data file to staging table and runs the custom concurrent program to transfer data from staging table to interface tables.
• Created and customized reports using XML Publisher/BI Publisher in OM, BOM, PO, AP, GL, WIP and INV.
• Customizing & enhancements on Forms.
• Converted Oracle 6i Reports and SCM reports to BI publisher reports.
• Extensively used CRM API's for upload the service request information from AFA (Legacy System) to oracle apps ERP.