PROFESSIONAL SUMMARY

• Over 15 years of experience in IT industry.
• 10 years experience in development/maintenance/Testing /conversion and migration projects in ORACLE database PL/SQL under UNIX/LINUX/Windows environment.
• 2 Years of experience in Project Management.
• 4 yrs of experience in Oracle Apps Technical.
• Good experience in all phases of SDLC, exposure to CMM process, Testing, Quality and change management procedures.
• Strong Customer interfacing skills with exposure to Fortune 500 multinational customers.
• Hands on experience in technical analysis, development, implementation integration and maintenance support for 24x7 production environment.
• Good knowledge in Unix and Shell Scripting.
• ORACLE certified Associate OCA with experience in database design, Database administration, data conversion , data integration , data warehousing , performance tuning , creation of database objects, developing PL/SQL stored Procedures, Packages, Functions, Triggers, Materialized view , SQL Loader , export/import/data pump utilities and Dynamic SQL.
• Experience in SCM modules like PO, INV, OM, AP,AR and GL and good understanding of the entire P2P, O2C business cycle process and good experience in Development of Interfaces and Conversions to validate and load data from legacy and feeder systems to Oracle applications.
• Good knowledge and experience in Oracle Forms, Oracle Reports, JAVA, Pro C, Developer/2000, TOAD, SQL Plus.
• Good Management skills, in leading and mentoring individuals and forming cohesive team environments.
• Good knowledge in Retail, Manufacturing, Utilities, Mobile and Telecom domains.
• Extensive experience in daily batch and report monitoring, space management, index rebuilds, statis tics collection and other Oracle housekeeping tasks.

TECHNICAL PROFICIENCY

PROFESSIONAL EXPERIENCE

Confidential

Role: Oracle Apps technical Consultant

Responsibilities:

• Manage the team and develop concurrent program to do the following
• Upload transfer orders from DC to staging tables and archive the data file.
• Validate data and insert into custom tables.
• Purge more than one month data.
• Document MD70, Migration docs, install file, UTP as per AIM methodology.
• Unit testing of the application.
• Mentor team members.
• Send weekly status report to the management.
• Performance tuning of the queries.
• Check the status on issues and prepare report on the same.

Environment Tools:, Oracle 10g ,PL/SQL, Toad, UNIX, Sharepoint, PPM Project Portfolio Management , Quality Center, SVN, Oracle eBusiness Suite, Oracle Apps R12 ,OM,INV.

Confidential

Role: Oracle DB Architect/Consultant

Responsibilities:

• Design/Develop/Test/Implement PL/SQL procedures, triggers, functions and packages for the Time Track application using Agile Scrum methodology.
• Migration of SQL server DB to Oracle DB.
• Define Data Retention Policy and implement the policy.
• Requirement analyses, design, develop, test and implement the back end database enhancements required for the ETRACE product maintenance request.
• Mentor database developers to deliver work on time for each sprint.
• Performance tuning of the queries based on AWR report and DBMS profiler.
• Do Export/ Import of the tables to extract and Load Data.
• Writing control files to load data into table using SQL Loader.
• Prepare test cases, test data and execute the testing of the change request.
• Testing the backend changes through the JAVA front application.
• Develop PL/SQL procedures using dynamic SQL.

Environment: UNIX, Oracle 11g Express Edition, PL/SQL, Windows 7, TOAD, JIRA, SQL Developer, SVN, JAVA,AWR report, DBMS Profiler

Confidential

Role: Technical Project Manager for Oracle Apps project.

Responsibilities:

• Prepare various artifacts for the project.
• Prepare various metrics for the project.
• Check the status on issues and prepare report on the same.
• Coordinate with onsite team and offshore team.
• Allocate work to team members and update the status to clients.
• Coordinate the deliverables and track the schedule.
• Performance Analysis of the deliverables.
• Identify the resource requirements in the project.
• Identify Risk and prepare the risk response plan.
• Resolve issues.
• Conduct Business Meeting and conference calls with the client.
• Responsible for validating the weekly effort reporting of the team and billing that to the customer.
• Prepare periodic reports and evaluate the performance of the deliverables.
• Set Goals and Objectives for team members and conduct performance appraisals.
• Prepare proposals and SOW and manage the change control process.
• Prepare test cases and conduct Testing of the application

Environment Tools: Oracle eBusiness Suite, GL, AP, Oracle 10g PL/SQL, Forms 9i, Toad, SQL Developer, UNIX, and XML Publisher, Oracle Apps 11i , RICE

Confidential

Role: Project Lead for Oracle Apps Project.

Responsibilities:

• Prepare CV60 Documents after completion of the component.
• Develop new forms by using TEMPLETE.
• Customize Oracle Standard forms by using CUSTOM.pll
• Develop Supplier open interface to load supplier details from old system into Oracle Apps Supplier base tables.
• Using Sql Loader to load data from flat files to staging tables and write PL/SQL procedure for all the validations. Data is then loaded into supplier base tables using standard import program.
• Status monitoring and Weekly calls.
• Workflow customization for PO approvals.
• Execute concurrent programs from PL/SQL.
• Creation of Value sets in various Modules of the application.
• Develop outbound interface in PO module to extract the po details from Oracle Apps base tables to the Flat file using UTL File utility.
• Prepare test cases and conduct Testing of the application

Environment Tools: Oracle eBusiness Suite , XML Publisher , PL/SQL, Forms, Reports, RICE Components, Oracle Apps Oracle Apps 11i .

Confidential

Role: QA Manager

Responsibilities:

• Manage the QACoE Wipro onsite team and offshore team
• Prepare various Quality metrics for the project.
• Involve in the preparation of Quality artifacts for the project.
• Check status of testing issues and prepare report on the same.
• Do the Testing of Application
• Allocate work to team Wipro members and update the status to clients.
• Build the Wipro team at onsite and offshore.
• Coordinate the deliverables and track the schedule.
• Identify the resource requirements in the project.
• Identify Risk and prepare the risk response plan.
• Resolve issues.
• Conduct Business Meeting and conference calls with the client.
• Validate weekly effort reporting of the team and billing that to the customer.
• Prepare periodic reports and evaluate the performance of the deliverables.
• Set Goals and Objectives for team members and conduct performance appraisals.
• Prepare proposals, statement of work SOW and manage change control process.
• Prepare test cases and conduct Testing of the application

Environment: HP UNIX, Windows XP, LoadRunner, QTP, Mercury Quality Center, KINTANA, HP Open view, Documentum, RFC Request For Change tool

Confidential

Role: Tech Lead for Oracle application migration and production support.

Responsibilities:

• Provide 24 x 7 production supports to the application as per the SLA.
• Lead team of 12 through the analysis, design, development, testing and implementation life cycle of a conversion/migration project.
• Conversion of DCL scripts to UNIX shell scripts.
• Assist the DBA in Database administration of Oracle 9i and 10g databases.
• Involved in the installation and customization of Oracle 9i application server

• Conversion of character based forms/reports/menus to Web based forms/reports/menus.
• Assist in installing and setting up the Forms and Reports Services on 9iAS.
• Trouble shoots the database performance issues and bugs within packages, forms, and reports using dbms output , explain plan etc.
• Conversion of COBOL and FORTRAN programs to PL/SQL and Pro C programs.
• Design and develop Web-enabled Oracle Forms Reports .
• Develop and document standards for Coding and development.
• Part of Implementation, System, Stress testing and User acceptance testing.
• Created new interfaces to the Application like Label printing, core tag printing barcodes and Accusort scanners.
• Documented business rules, functional and technical designs, test cases, and user guides.

Environment: Oracle 9i Administration, Forms9i/6i/5.0/3, Oracle Reports 9i/3.0/1.1, Oracle Developer PL/SQL PL/SQL web Tool kit SQL Plus Oracle 9i Sun Solaris UNIX Shell scripts, Open VMS, Windows NT/XP, TOAD, Visio.