OBJECTIVES/ASPIRATIONS:

To work in a competitive environment that effectively utilize my analytical, interpersonal, technical and organizational skills to conceive and achieve solutions, the solutions which help the organization in not only meeting its targets, but also allowing it to grow, therefore enhancing my own skills as an individual and as a key player in the organization' s development.

SUMMARY:

• Around 4 and half years of experience as an Oracle applications (E - Business Suite) Techno-Functional developer with expertise in Accounts Payables(AP), Account Receivables (AR).
• Hands on experience in 11i & R12 implementation and roll-out of financial modules like AP, and AR and AME
• Designing, developing, customizing and supporting the Outbound Interfaces in Oracle Applications which includes AP and AR modules.
• Complete Life cycle experience of ERP implementations, and custom application development projects.
• Worked on Oracle Forms and Workflow Builder, Approval Management Engine, BI Publisher Reporting, Oracle Reports and XML Publisher.
• Worked on various phases of Software Development Life Cycle (SDLC) such as Project Requirement Study, high level design, low-level design, Coding, Testing, Quality assurance Documentation, Implementation and Project Planning.
• Have worked on RICEFW Components like Reports, Interfaces, Conversions, Extensions, Forms and Workflow as per client requirements.
• Extensive experience in PL/SQL Oracle database and RDBMS Concepts Procedures, Functions, Packages and Database Triggers.
• Proficient in using PL/SQL Developer, Reports 6i/10g and Forms 6i/10g for both development and customizations as per client specifications.
• Experience in Application Object Library (AOL) for registration of Forms, Reports, Concurrent Programs and oracle API’s and Menus.
• Very good understanding of Trading Community Architecture (TCA), P2P and O2C cycle.
• A self-motivated Team Leader/Member with excellent inter-personal, presentation and technical documentation skills with concern for maintaining quality at all levels.
• Involved in preparing the Functional Requirement Specification Document depending on the Business Requirements and Components across several releases.
• Strong understanding of the business requirements and the technical issues.
• Develop the code in PL/SQL packages, procedures, functions.
• Keeping flexibility in the code so that it can in corporate any change that the Business might ask for.
• Documenting the technical changes that would help any person in understanding the technical design end to end.
• Extracting test cases from the understanding of the Business Requirement and the components. During implementation of test plan, test scenarios are identified & accordingly test cases are generated with the help of Testify tool. Prepare Test Documents and upload the same to Quality Center.
• Actively involved in testing several components in Unit Testing, System Integration Testing phase and providing support during UAT and post-production.
• Building up the new setups and functional changes or to align the gaps in the existing setups as per the business requirements.
• Onsite/Offshore co-ordination and ensuring on-time Deliveries.
• Imparted training to Project Support Team for the understanding of the components across each release.
• Analyzing Software Defects and performing root cause analysis. Also worked on the fixing of the defects.
• Worked on the Project Management Tools etc and attended various PL related trainings.
• Defined policies and procedures for test environments analyzed the environment requirements and worked on getting the same available to the concerned teams.
• Defined the requirements for the build of Test Environments, keeping in consideration the system functionality and the access security concerns.
• Managed the QA Configuration and setups and also the Configuration change Process.
• Reviewed the setups mentioned in Functional Setup documents and audit the configuration and setups done in the test environment and thus performing quality reviews on configuration/ test documentation.
• Coordinated with the Development and Testing Teams for the cloning/patching/code change requirement in the Test Environments.
• Was involved in Developing, implementing and maintaining environment schedules for code/patch/cloning and data updates.
• Tested the environments if all are in synchronization as per the requirement and are secured as per the specification of the Environment. Data are in synch with the Production data and the access is restricted to just the designated associates.
• Developed queries to extract the data from several tables pertaining to the Setups / configurations across all ERP Modules.
• Performing the Data Synchronization .Synchronizing The Setup Document with the latest Production data by automating the pull of data extract through queries and linking the document to a hyperlink in the Shared folders where these extracts have been kept.
• Working on the defects logged by Testing team to setup the configurations in the Test Environments.
• Creating the PPM( Project and Portfolio Management) Requests to facilitate the code migration across instances.
• Validating the post clone checklist to ensure the cloning has been done with the update scripts run post cloning activity.
• Undergone Training on Oracle Order to Cash and Procure to Pay Lifecycle.

SKILLS:

Software: PL/SQL Developer,Oracle Forms 6i,Oracle Development Suite,XML Publisher, Microsoft Excel,Oracle Workflow Builder, Oracle Reports 10g, Oracle BI Publisher

Operating System: Windows XP Professional Version 2002, Unix

Tools:: PL/SQL Developer,HPSD,TSG Service Now,Starteam,HP Quality Center,Winscp,PS Pad,Application Lifecycle Management, HP Project and Portfolio Management,, BMC Remedy Mid-Tier,Oracle Applications 11i,Starteam

Methods: Software Development Life Cycle(SDLC)

ERP: Oracle Applications 11.5.10, Oracle R12.1.0

RDBMS: Oracle 10g

CAREER PROFILE:

Confidential

System Engineer(Onsite)

Responsibilities:

• Gathering the user Requirements and analyzing the same by holding regular meetings with the Business Users and the Onsite Team.
• Documenting the Functional Requirement Specification Document based on the Business Requirements and Solution Design.
• Extracting test cases from the understanding of the Business Requirement and the components. During implementation of test plan, test scenarios are identified & accordingly test cases are generated with the help of Testify tool. Prepare Test Documents and upload the same to Quality Center.
• Building up the new setups and functional changes or to align the gaps in the existing setups as per the business requirements.
• Defining policies and procedures for test environments, analyzing the environment requirements and working on getting the same available to the concerned teams.
• Defining the requirements for the build of Test Environments, keeping in consideration the system functionality and the access security concerns.
• Worked on BI Publisher to generate report for all the Invoices due to be paid to the Suppliers at the end of every month.
• Worked on RICE (reports, Interface, Conversions and Extensions) Components. Have worked on GL Journal Conversion from Legacy System to R12.
• Managing the QA Configuration and setups and also the Configuration change Process.
• Performed the setups mentioned in BR100 documents for physically separating two Businesses which have been using the same ERP implementation. Also, audit the configuration and setups done in the development, test environments and Production environment across the Project phases and thus performing quality reviews on configuration/ test documentation.
• Developed queries in PL/SQL developer to extract the data from several tables pertaining to the Setups / configurations across all ERP Modules (AP, AR, PA, Inventory, PO, GL, CM) implemented in the system.
• Incorporating these queries in a Macro for generating the data records setup in the system.
• Coordinating with the Development and Testing Teams for the cloning/patching/code change requirement in the Test Environments.
• Developing, implementing and maintaining environment schedules for code/patch/cloning and data updates.
• Testing the environments if all are in synchronization as per the requirement and are secured as per the specification of the Environment. Data are in synch with the Production data and the access is restricted to just the designated associates.
• Validating if the code and Configurations are accurate across all environments as per environment management processes and checklist .
• Performing Internal Quality Assurance (IQA) of the Technical Design Documents (TD) and Conversion Development Codes prepared by Peers and correspondingly documenting the points not satisfying the Quality norms.
• Working on the defects logged by Testing team to setup the configurations in the Test Environments .
• Defining policies and procedures for test environments
• Managing configuration change process.
• Performing quality reviews on configuration/ test documentation
• Testing environment synchronization
• Validating code and Configurations are accurate across all environments as per environment management processes and checklist.
• Developed queries to extract the data from several tables pertaining to the Setups / configurations across all ERP Modules.
• Performing the Data Synchronization .Synchronizing The Setup Document with the latest Production data by automating the pull of data extract through queries and linking the document to a hyperlink in the Shared folders where these extracts have been kept.

Hardware: Client provided hardware. No specific hardware for this project implementation

Operating System: Windows XP

Languages: PL/SQL

Special Software: Oracle Applications R12.1.0, HP Project and Portfolio Management, HP Quality Center, Oracle Applications 11i, BMC Remedy Mid-Tier, Oracle BI Publisher, PL/SQL Developer

Confidential

Project Leader

Responsibilities:

• Gathering the user Requirements and analyzing the same by holding regular meetings with the Business Users and the Onsite Team.
• Documenting the Functional Requirement Specification Document based on the Business Requirements and Solution Design.
• Extracting test cases from the understanding of the Business Requirement and the components. During implementation of test plan, test scenarios are identified & accordingly test cases are generated with the help of Testify tool. Prepare Test Documents and upload the same to Quality Center.
• Building up the new setups and functional changes or to align the gaps in the existing setups as per the business requirements.
• Did the Conversion of existing Customers in AR as Refund Vendors in the Payables Workbench, allowing the Refunds to be made to them. Conversion activity included development of code in PL/SQL Packages, procedures, functions and creation of Concurrent Programs whose run will ensure the conversion and interface of Customers as Suppliers(Refund Vendors).
• Automating The Standard Refund Payment Process to call the PAyment Workbench for the Refund Vendors, which had been Setup in AP. Receipts generation and Credit Memo Adjustment in AR was also in scope,thereby integrating both Payables and Receivables Workbench
• Worked on changes in Oracle Forms. Implemented some logics and triggers in the Form, so as the Form behaves as per the Business Requirements.
• Worked on Oracle Reports.
• Have worked on Workflow Builder and triggers.
• Worked on implementing the workflow for sending the Remittance Letter in form of electronic mails as and when refund process gets completed.Also have worked on AME for the approval heirarchy.
• Have implemented Forms Personalization to pop-up an error message to the user on proper validation.
• Keeping flexibility in the code so that it can in corporate any change that the Business might ask for.
• Documenting the technical changes that would help any person in understanding the technical design end to end.
• Performed Unit testing on all the developed components before start of SIT and traced out the defects at the earliest phase.
• Performed SIT Testing for the test of the various components developed in the Release.
• Provided support to the users during UAT and fixed the defects which they raised in Application Lifecycle Management tool as soon as those were traced.
• Have worked on the Functional setups required for the functionalities using the implementation of Oracle Applications AP and AR modules.
• Interacting with client and all stakeholders and providing strategic and tactical directions.
• Keeping track on Custom Object deliverables, change request, defects and the documentation.
• Identifying the problem areas in advance and delivers a solution in time to prevent the user getting impacted by the problems.
• Co-ordination with various teams for resolving Issues and understanding the Root Cause.
• Ensure deliver of Solution against the defined requirements
• Assigning the work from technical and functional perspective.

Hardware: Client provided hardware. No specific hardware for this project implementation

Operating System: Windows XP

Languages: PL/SQL

Special Software: Oracle Forms, Pl/SQL Developer, Oracle Reports, Oracle BI Publisher,XML Publisher,Oracle Applications 11i, Application Lifecycle ManagementStarteam

Confidential

Developer

Responsibilities:

• Gathering the user Requirements and analyzing the same by holding regular meetings with the Business Users and the Onsite Team.
• Documenting the Functional Requirement Specification Document based on the Business Requirements and Solution Design.
• Extracting test cases from the understanding of the Business Requirement and the components. During implementation of test plan, test scenarios are identified & accordingly test cases are generated with the help of Testify tool. Prepare Test Documents and upload the same to Quality Center.
• Building up the new setups and functional changes or to align the gaps in the existing setups as per the business requirements.
• Develop the codes in Pl/Sql packages, procedures, functions, Forms, Reports.
• Keeping flexibility in the code so that it can in corporate any change that the Business might ask for.
• Documenting the technical changes that would help any person in understanding the technical design end to end.
• Performed Unit testing on all the developed components before start of SIT and traced out the defects at the earliest phase.
• Performed System Integration Testing of the components and analyze the functionality of the components.
• Provide Support to the Users during UAT.
• Provide Support to the users after Go-Live of the Releases till the Post-Production Support period.
• Providing cutover support before every SIT and Production Go-Live(Raising tickets, supporting DBA for code movement, doing functional setups and performing sanity checks) to ensure a smooth and hassle free cutover.
• Integrating with other Teams for some components within the Enhancement involving the integration with third party systems like Documentum, IBS, GECARS etc.
• Imparting Training to the Support Team regarding the understanding of the Functionality and Technical Design of the enhancement as per the releases.
• Conducting training for users
• Involved in gathering the business requirements specification, documenting the Functional Specification.
• Actively involved in testing several components in Unit Testing, System Integration Testing phase and providing support during UAT and post-production.
• Involved in onsite/offshore co-ordination, deliveries
• Significant Contribution in tough times to maintain quality and to ensure On Time Delivery

Hardware: Client provided hardware. No specific hardware for this project implementation

Operating System: Windows XP

Languages:PL/SQL

Special Software: Oracle Forms, Pl/SQL Developer,Oracle Applications 11i, HP Quality Center, HP Service Desk, TSG Service Now