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

PROFESSIONAL EXPERIENCE

Oracle PL/SQL Developer

• International Automotive Components is a leading global supplier of automotive components and systems. Our approach is solution-based, innovative and built on stringent best practices and commitment to the success of our customers in the global marketplace.
• Excess Equipment provides all the Equipments which help internal business users to locate the Equipment which are requested from one location to another. This Application gives the information about Equipment positions, trading activity, margin requirements, pricing comparisons of the prices of products of equipment with other supplier companies. Developing team is responsible for extracting the data from different sources and developing reports as per the business requirements.

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

• Confidential Telecommunications is a Confidential leading Provider in next Generation Data and Telecom Services. Offers a wide, unique, portfolio of services to fulfill telecom and data needs backed by the network of a large communications provider coupled with the attentive, flexible, personalized services of a small provider.
• 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

Oracle Developer

Confidential

Confidential is a wholly owned subsidiary of subsidiary of Signet Group plc. The current IMS database and associated client processes are anticipated to grow beyond the capabilities of the current hardware .A hardware update will require a large capital investment, which can be delayed for a time by making a much smaller investment in optimizing the current system. This project will analyze and implement tuning measures to provide a performance margin for retaining the current system as long as possible.

Roles/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.

Oracle Developer

Confidential

Time sheet is a web-based application used by the employees of the bank. The employees update their weekly timesheets and submit them to historical database HDB for approval. Managers access the same to approve/revert through the web application. Thus, HDB contains the time sheet data filled in by employees, which acts as a source for timesheet application. This data is extracted using PL/SQL program that runs weekly. The extraction program extracts the timesheet and shift related data from HDB applies transformation rules and inserts the data into the Integration database IDB .

Roles/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.

Programmer Analyst

Confidential

The CPS Consumer Products and Services division at Symantec is focused on developing software products in the Internet Security Solutions area to help individuals protect and manage their digital assets. There are separate groups within CPS working on each of the products. While these groups work on developing secure and reliable products, due to the very nature of software development it may not be possible to completely eliminate all flaws before a given product's release. Therefore, there is a need to have teams working and processes in place which allows Symantec to respond effectively to customer issues after the product has been released to market. This need is fulfilled by the Consumer Confidential team. The Consumer Confidential has been responsible for analyzing and prioritizing the issues including security vulnerabilities, critical in-market issues, OEM and SOS showstoppers and all other top technical support issues and finding the bugs.

Roles/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.

Programmer Analyst

Confidential

The Digiterra Program involves the total re-engineering of Best Buy's current BestBuy.com site in meeting its mission statement. The new e-commerce platform will exhibit extreme customer centricity, remarkable flexibility, store-complimenting capabilities and integration with Enterprise systems. Customers may access the new platform using a variety of devices, including PC's, handsets, PDA's, interactive TV, e-Book, etc. The associated business environment will offer improved administration, new organizational opportunities and increased operational efficiencies. The new platform and business environment will support multi-national, multi-brand, and multi-product-type operations.

Roles/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

Oracle Programmer Analyst

Confidential

Confidential is a set of four In-Store-Processor applications.

• Back Office System BOS - BOS application acts as an intermediate agent, between BOS and other external systems POS . Some of the salient features of BOS include handling and maintaining price changes, wet and dry stock management, shift management, reconciliation of dry stock, wet stock, shifts, basic features of PO generation, Invoice verification and supplier management.

• .Remote Site Management RSM - RSM is used to manage the communication between different sites and head office.

• Open Database Merchandising System ODBMS ODBMS system was designed so that it can replace the existing BP head office system, BPM.

• Non-RAP FOS to BOS Converter - This application talks to BOPIS with the Non RAP Front Office System.

Roles/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