SUMMARY

• 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.
• Techno - Functional consultant for the implementation of Oracle Apps AP and AR modules.
• 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.
• Worked on Oracle Forms and Workflow Builder.
• Involved in Conversion activities.
• Keeping flexibility in the code so that it can incorporate 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.

TECHNICAL SKILLS

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

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

PROFESSIONAL EXPERIENCE

Confidential

System Engineer

Responsibilities:

• 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.
• Managing the QA Configuration and setups and also the Configuration change Process.
• Reviewing the setups mentioned in BR100 documents and audit the configuration and setups done in the test environment and thus performing quality reviews on configuration/ test documentation.
• 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 .

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.
• 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 incorporate 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.

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 incorporate 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