Team Member Resume

SUMMARY:

About 3.0 years of professional experience in Oracle Applications R12 as Technical Consultant Responsible for understanding, analyzing, Designing, Developing and troubleshooting RICE components
Extensive experience in Oracle and other utilities such as TOAD, and SQL*Loader, and discover reports
Involved in creation of Value sets, Concurrent Programs and Request sets using proper naming conventions in Oracle Application Projects
Experienced in writing Program using PL/SQL, and good knowledge on Forms and Report builder6i
Involved in Design and Development of Report Layouts in Oracle applications as per client requirements using Report builder6i
Experience in designing and development of Conversion Programs to load data from Legacy system to Oracle Applications with effective validation logic and Error handling mechanism
Worked on Inbound and Outbound Interfaces to load the data from legacy system to Release 11i using PL/SQL and SQL* Loader and UTL FILE package

TECHNICAL SKILLS:

Oracle Product: Oracle Apps R12

Data Base / Operating System: Oracle Database 11g

Technical Skills: AOL, PL/SQL, Form Personalization, XML Publisher, Oracle Forms, Report 6i/10g, Oracle Discoverer 4 and TOAD, Workflow

Operating Systems: Window - 98/XP/2000, Linux

Languages: SQL, PL/SQL

Tools: & Utilities: Microsoft Office, Toad, Winscp

PROFESSIONAL EXPERIENCE:

Confidential

Team Member

Environment: Oracle apps R12, Forms 10g, Reports 10g, Oracle 11g, Sql * Loader, XML Publisher, Workflow

Responsibilities:

Developed Bank and branch conversion
Developed Supplier conversion
Creation of Value sets in various Modules of the application.
Developed new forms using TEMPLATE.fmb
Worked on form personalization
Preparation of SQL Loader scripts to load data from .csv file to otacle tables
Development of XML publisher Reports.
Registrations of Tables using the API Ad Dd
Executing concurrent programs from PL/SQL.
PL/SQL method of submitting Concurrent programs using API FND REQUEST.SUBMIT REQUEST
Development and Customization of Reports, PL/SQL Procedures, and Packages.
Registering reports in Oracle Applications
Developed Shell scripts

Confidential

Team Member

Environment: Oracle apps R12, Forms 10g, Reports 10g, Oracle 11g, Sql * Loader, XML Publisher, Workflow

Responsibilities:

Technical consultant for interfaces designs.
Suggesting the optimized solutions to the customer for their requirements as per As-Is processes
Preparation of MD120 doc for Code migration
Monitoring the deliverables during each phase of project
Attending the weekly status calls and weekly reporting
Writing SQL queries according to customer requirement
Understanding customer issues.
Define value sets
Design, Development and Customization of RICE components
Doing feasibility analysis and preparing technical design documents MD-070
Coding and Development of RICE as per Naming and Coding Conventions
Define Concurrent program, Request Sets and Executable
Performing Unit testing and Code review for developed RICE Components

Confidential

Team Member

Environment: Oracle apps 11i, Forms 6i, Reports 6i, Oracle 9i, Sql * Loader

Responsibilities:

Technical consultant for interfaces designs.
PL/SQL Coding for interfaces.
Preparing the Documents as per AIM Methodology
Developing forms and customization of forms.
Developing Reports and are registered as Concurrent programs
Writing custom packages and control files to develop conversion programs.
Preparation of technical specifications from the functional specifications Received from functional team like CV60, MD70 using AIM 3.0.
Developing PL/SQL code to obtain the required functionality.
Customization of reports as per client requirement.
Define value sets
Preparation of MD120 doc for Code migration
Monitoring the deliverables during each phase of project
Attending the weekly status calls and weekly reporting