SUMMARY

• Over 10 years of IT experience in System Analysis, Design and Development of business applications using Oracle 10G/9i/8i/8/7.3 C, SQL, PL/SQL, Oracle Forms 10g/9i/6i/4.5, Reports10g/ 9i/6i/4.5.
• Very good experience in analysis, design, development, and testing of applications in ORACLE.
• Experience in writing many PL/SQL Procedures, Functions, and Packages, triggers etc.
• Experience in developing Reports, Customizing Oracle seeded Reports.
• Experience in Oracle SQL Performance Tuning.
• Excellent understanding of the software development lifecycle (SDLC) which includes Build & Release Management.
• Knowledge in System Administration including Oracle Applications activities like managing concurrent managers, application user setup, defining responsibilities, values sets and flex fields.
• Experience over SQL, PL/SQL, Oracle Reports and Forms.
• Self - starter, logically strong and technically good and always excels to meet Industry standards.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Well versed with RDBMS, Oracle 7.X / 8.X/9.X and OS concepts. Worked on Windows NT, 95 & 2000, UNIX platforms.
• Conversant with ISO 9001 quality procedures, while executing the projects and aware of SIX SIGMA Process.
• Expert in Oracle applications (AP, AR, GL, PO, CM, FA, PA, OM, BOM, INV, AOL and SYSADMIN).
• Commitment to work well to achieve client’s objectives.
• Excellent communication and interpersonal skills, with ability to work as a Technical person.
• Excellent Business and Data analysis skills
• Knowledge of UNIX, XML.
• Experienced in using utilities like Toad, SQL loader and PL/SQL developer.
• Great team worker and motivates the team with friendly nature.
• Responsible, self-starter always striving for technical and professional excellence.
• Proven ability to quickly learn and apply new technologies with strong technical background. Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion

TECHNICAL SKILLS

Operating Systems: Windows NT/2000/98/95, DOS 6.0/3.0, UNIX

Languages: PL/SQL, SQL, C, Pro*c,Perl, VisualBasic6.0, HTML, JavaServlet and JavaScript.

Database tools: SQL, PL/SQL, T-SQL, PL/SQL Developer, Forms10g/9i/6i, TOAD, Oracle Enterprise Manager

GUI: Developer/2000, Forms 6i/5.0/4.5, Reports6i/3.0/2.5), Visual Basic, ASP

RDBMS: Oracle 11g/10g/9i, TOAD, SQL Developer, SQL * Plus

Administration: SQL*Loader, Export, Import

Tools: TOAD, SQL*NAVIGATOR

Testing Tools: Win runner, Quick Test Professional, Test Director/Quality center.

Source Control Tools: Microsoft Visual Source Safe, PVCS Version Manager.

Reporting Tools: Crystal Reports, MS Access Reports, Oracle Reports & Excel Reports.

Office Tools: MS Word, Excel, Power Point, Visio, UML, Erwin, MS Project.

PROFESSIONAL EXPERIENCE

Confidential, Plymouth, MI

Oracle PL/SQL Developer

Responsibilities:

• Excess Equipment is a Web Application for all plants to Request Equipment’s.
• Developed both inbound and outbound interfaces using PL/SQL to load data into targeted database and extract the data from the database to flat files.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages according to the new business measures.
• Worked on PL/SQL tool TOAD to run SQL queries to validate the data.
• Modifying existing web application GUI as per the need from the look and feel point of view using HTML, Java script.
• Extensively used HTP and HTF package used to dynamically build webpage from PL/SQL.
• Developed stored packages with Oracle\'s Web Toolkit.
• Worked with front end application developers with their queries/stored procedures while building User-Interface for the project.
• Wrote complex SQL queries using Joins, Sub queries and Group functions.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Worked on package more than 15000 lines.
• Good experience in communicating with offshore team.
• Worked closely with end-users and team members to understand business requirements that drive the analysis.

Environment: Oracle 11g/10g, SQL, PLSQL, UNIX, TOAD, QL* Plus, UNIX, TOAD, VISIO, HARVEST APPWORX, Forms 10g and Reports 10g.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed Packages, SQL Scripts and Database Triggers to populate the historic data in the tables.
• Structural changes to database objects according to business logic.
• Used SQL*Loader scripts to load the flat files into the Oracle Database.
• Performed application SQL Tuning using SQL Trace and Explain plan.
• Created various simple and complex views.
• Used various SQL Expression in standalone procedures and functions.
• Used File Transfer Protocol (FTP) tool to transfer files from one server to other.
• Used Export/Import Oracle utilities of Data Pump to move data to different testing environments.
• Worked on Unix Shell Scripting for Scheduling Batch Jobs using Crontab.
• Wrote complex SQL scripts and was responsible for Performance tuning of SQL Queries.
• Created Unit Test plans and involved in primary unit testing.
• Responsible for the development and maintenance of end-user documentation.

Environment: Oracle 11g/10g, UNIX, Solaris 5.8, SQL, PL/SQL, SQL*PLUS9.2.0.3, TOAD 10.6, SQL Developer 3.1, Adobe 9, Fillezilla 0.9.40, BugZilla 4.0.2, RUP 7.5.1. ORACLE 11g,10g, SQL* Plus, UNIX, PL/SQL Developer, VISIO,STONE Branch, Oracle Discoverer 10g Forms 10g and Reports 10g.Oracle applications 11.5.4(AP,PO,AOL,OM,SYADMIN)

Confidential, Cleveland, OH

Oracle Developer

Responsibilities:

• Gathered requirements and developed the Project Definition document which specifies the problems that need to be solved for developing the system.
• Responsible for developing PL/SQL Functions, Procedures, Cursors, Packages and Triggers for incorporating the business logic and to populate user data into database tables.
• Tuning the queries wrote PL/SQL packages, procedures and functions
• Used various Performance Tuning techniques for quick extraction of data.
• Wrote UNIX shell scripts
• Involved in analyzing the statistics of queries
• Worked on PL/SQL developer
• Worked on Explain plan
• Writing Unix shell scripts
• Understanding the business, most required to tune the query.
• Understanding the database structure.
• Involved in migration of forms from 6i to 10g and unit testing the same
• Participation in weekly design reviews and walkthroughs with project manager and development teams.
• Extensively involved in interaction with end users for testing and acceptance of the system.

Environment: Oracle 9i/10g, Oracle SQL, PL/SQL, Oracle forms 6i/10g, TOAD, SQL Navigator Windows 2000, FTP, Unix, Shell scripting.

Confidential, MN

Oracle Developer

Responsibilities:

• Prepared program Specification for the development of PL/SQL procedures and functions.
• Created Custom Staging Tables to handle import data.
• Created custom triggers, stored procedures, packages and functions to populate different database.
• Developed SQL* loader scripts to load data in the custom tables.
• Run Batch files for loading database tables from flat files using SQL*loader.
• Created UNIX Shell Scripts for automating the execution process.
• Developed PL /SQL code for updating payment terms.
• Created indexes on tables and Optimizing Stored Procedure queries.
• Design, Development and testing of Reports using SQL*plus.
• Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions / enhancement on oracle application.
• Created Indexes and partitioned the tables to improve the performance of the query.
• Involved in preparing documentation and user support documents.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Environment: Oracle 9i/10g,PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus, UNIX, Windows NT 4.0/2000/XP Windows2000.

Confidential, MN

Programmer Analyst

Responsibilities:

• Understanding the customer issues.
• Involved review of design document and code review accordingly.
• Fixing the bugs that arise.
• Deliver the bug fix as per quality standards.
• Writing test plans, functional specifications, program specifications for the bugs fixed.
• Design all the necessary reports.
• Document the development activities.
• Testing - unit testing & integration testing.

Environment: UNIX Shell scripts, Maintenance, C/C++, Retail, and Red hat Linux, embedded c, PL/SQL and Reports6i.

Confidential, Minneapolis

Programmer Analyst

Responsibilities:

• Design necessary reports
• Reported the bugs in the Bug Tracker Tool. ·
• Coordinating with Team members in allocating jobs and keeps track of reported bugs for each testing cycle. ·
• Consolidate Bug Status Report will be send to the PM/QM. ·
• Timely escalated where there is less clarity between Requirement and Design document and get it clarified with PM/QM ·
• Reviewed Unit test Plan and Integration Test Plan and made sure the comments are fixed. ·
• Reviewed Unit test cases and code reviews n and made sure the comments are fixed. ·
• Make sure the Daily Activity Status Report are updated and made available at a common area to which every one in team can access. ·
• Writing Integration test cases for the all the jobs. ·
• Guidance given to new team members on UTC review and Testing Procedure. ·
• Mentored all the team members for the Build operation and ensured all team members are confident in doing this process.

Environment: Java, ATG, HP-Unix, Oracle 9i, PL/SQL, reports 6i, SQL* Plus, shell scripting

Confidential

Oracle Programmer Analyst

Responsibilities:

• Fixing the bugs that arise.
• Deliver the bug fix as per quality standards.
• Writing test plans, functional specifications, program specifications for the bugs fixed.
• Design all the necessary reports.
• Document the development activities.
• Testing - unit testing & integration testing.

Environment: Informix, UNIX Shell scripts, Maintenance, C/C++, Retail, Red hat Linux, embedded c and SQL