SUMMARY

• Around 7+ years of experience with Oracle 9i, 10g and 11g working as Oracle Developer and Oracle Consultant, developing back - end modules, such as packages, functions, procedures, triggers, object types, views for multitier business applications OLTP systems, in SQL and PL/SQL.
• Extensive experience in writing/debugging Oracle SQL, Dynamic SQL, PL/SQL code i.e. Packages, Stored Procedures, Functions, Triggers, Cursors, Ref Cursors, Constraints, Indexes, Views, Materialized Views, Database Links (DBLINKS), Sequences, Synonyms, and Global Temporary tables.
• Strong knowledge in using Oracle built-in packages (like UTL SMTP, DBMS JOB, DBMS SCHEDULER), Cursor management, Exception handling etc.
• Vast experience tuning Complex Queries and performance bottlenecks (using Explain Plan, HINTS, SQL Trace, TKPROF and SQL Profiler).
• Experienced in database concepts, SQL tuning, materialized views, index strategies.
• Enforcing data integrity using integrity constraints & database triggers.
• Experienced in SQL*Loader, Export, Import.
• Expertise in developing Data Conversions/Migration from Legacy System of various sources (flat files, Oracle) to Oracle system Using SQL *LOADER, Appropriate Interface tables and API’s.
• Experience in all phases of the Application Development cycle - Design, Coding, Testing, Maintenance and Documentation.
• Developed complex triggers using PL/SQL for data integrity and enforcing business rules.
• Extensive and very intense SQL coding and development experience for OLTP database.
• Experience using TOAD and PL/SQL Developer for query building and analysis and manipulations of databases for checking compatibility and integrity of RDBMS.
• Fair understanding & working knowledge in UNIX - Shell Scripts.
• Experience on control software such as PVCS for code management.
• Experience in supporting the various production issues addressed by the users from the client side and providing them with required solutions.
• Extensive experience in working with end users and documentation of business process.
• Complete knowledge on Quality processes and Version Control using PVCS.
• Excellent investigative, interpersonal skills and a team leader with very good communication skills.
• Knowledge of Cloud Computing with Cisco IAC tool.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i

Oracle Tools: TOAD, SQL Developer, PL/SQL Developer, SQL Navigator, Oracle Forms 11g/10g/6i, Oracle Reports 11g/10g/6i, SQL*Plus, Discoverer

Data Modeling Tools: Erwin 4.5/4.0/3.5, Designer 2000, Microsoft Visio 2003

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing.

Programming Languages: Unix Shell Scripting, Perl Programming, XML, Matlab, Labview, C, C++,Java, HTML

Environment: Sun Solaris 2.6/2.7/2.8/8.0 , Red Hat Linux, Windows NT/ 95/ 98/ 2000/ XP,MS DOS 6.22

PROFESSIONAL EXPERIENCE

Confidential, CA

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL packages and database triggers.
• Designed and created tables, global temporary tables, views, materialized views and other database objects.
• Developed various programs using Native Dynamic SQL and REF CURSORS.
• Wrote PL/SQL packages, functions, procedures etc.
• Involved in handling Exceptions through PL/SQL Blocks.
• Assisted in the initial tuning of several database objects.
• Extensively worked on all type of Analytical Functions (RANK, DENSE RANK, LAG, LEAD etc.)
• Developed various UNIX shell scripts for regular maintenance.
• Conducted peer design and code reviews and extensive documentation of standards, best practices.
• Loading data into tables from flat file via temporary tables using SQL * Loader and PL/SQL.
• Involved in the development of a migration tool to convert data from the existing database to the required database format.
• Developed Database Triggers for the integrity.
• Did manual testing and build test script.
• Participation in reviewing code and ensuring testing, facilitate code delivery to production environments.

Environment: Oracle 10g, PL/SQL, TOAD, SQL * Loader, UNIX, SQL*Loader, TOAD, Java, Windows 2000, HP-UNIX.

Confidential, San Jose, CA

Oracle Developer

Responsibilities:

• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Handling the tickets which comes into the queue based on the priority level. Ping the users in the chat window and confirm from them if they are able to login.
• Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the Database.
• Solving the issues which users get while working on this production Application server. Also call them and find out the issue they are going on and solve it.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.
• Created UNIX Shell scripts for automating the execution process.
• Created Packages, Stored Procedures and Functions to be called by Java modules.
• Designed and Created several Customized Reports using Oracle Reports 10g.
• Designed and developed front-end applications using Oracle Forms 10g.
• Developed Procedures and Triggers for Oracle Forms and Reports.
• Involved in writing complex queries to generate reports as per client requests as part of production support.
• Coordinated with DBA in improving Database Performance.
• Involved in developing test plans and test cases based on high-level and detailed designs.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle 11g, Toad, PLSQL Developer Oracle Forms 10g, Oracle Reports 10g, Windows XP, UNIX, Putty.

Confidential, Round Rock, TX

Oracle Developer

Responsibilities:

• Prepared program Specification and development of PL/SQL package, procedure and functions as required by the business users
• Migration of the existing SQL Server procedures, function and Views into Oracles PL/SQL Packages, Procedures, Functions, tables and views.
• Used DTS Packages as ETL tool to migrate the Data from SQL Server 2000 to Oracle 10g.
• Developed Scripts for Oracle tables, views and sequences and applied referential Integrity.
• Created Indexes and partitioned the tables to improve the performance of the query.
• Applied optimizer hints to tune the queries for faster performances.
• Modifying the procedures, functions and views based on the changes of the business requirements in T-SQL as well as PL/SQL.
• Used web service to publish the data from other dell web applications.
• Involved in preparing the OMD SQL and PL/SQL coding standard and guidelines.
• Used autosys to schedule the batch jobs to create reports and also monitor them on daily and weekly basis.
• Created Reports using complex SQL queries for the clients review.
• Designed and developed the reports for business user using Crystal Report.
• Designed and developed the data's pre-staging and staging mechanism.
• Created Staging Tables to handle the import data.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Wrote Procedures and functions for the validation of input data and to implement business rules.
• Performed Unit Testing and Integration Testing of the application.
• Involved in preparing documentation and user support documents.

Environment: Oracle 10g, SQL Server 2000/2005, PL/SQL, T-SQL, SQL* Loader, TOAD, CVS, Visual Studio, C#, ASP.Net,, MS- Office, XML, PERL, Crystal Report 9.0, MS-project

Confidential, Webster, NY

Oracle Developer

Responsibilities:

• Used SQL*Loader to upload data into the staging files from flat files.
• Created PL/SQL Packages, Procedures, Functions and Triggers.
• Wrote PL/SQL code for data migration.
• Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors, pipeline functions etc.
• Created Batch jobs, daily jobs, one time jobs and queues.
• Developed Reports using complex queries as per client request as a part of production support.
• Developed complex Oracle Forms providing extensive GUI features (multi-selects drag and drop, graphical charts, automated system alerts and notifications etc.).
• Created Test Plan for QA and implementation plan for Production implementation once the unit test is done.
• Performed SQL performance tuning using Explain plan, Trace utility & TKProf.
• Documenting all Oracle Reports, Packages, Procedures and Functions development specifications.
• Maintaining different version of software (version control) using CVS.
• Providing production support solving Tickets created using the software Unicenter.
• Preparing test plan for QA for testing before moving from PreProd to Production environment.

Environment: Oracle 10g, SQL Server, PL/SQL, Reports, Forms, Data Modeling, Data migration, SQL Navigator, Toad, PL/SQL Developer, SQL*Loader.

Confidential

Responsibilities:

• DevelopedPL/SQL packages,stored procedures, functions, Cursors, triggers.
• Responsible forinstalling, upgrading and configuring the Oracle server.
• Creating databases, objects, roles and privileges.
• Partitionedlargetablesto increase the performance.
• Configured scripts to monitor activity with database.
• Responsible for optimizing the queries and application tuning.
• ImplementHot, ColdandLogical backupplans.
• Designedbackupandrecovery proceduresfor OLTP system
• Enhanced the performance of the company’s Oracle environment by providing advanced performance tuning and coding standards.
• UseTOADtool to access the database
• Used PL/SQL developer to createPL/SQLProcedures
• Testing PL/SQL proceduresagainst the test cases.

Environment: Windows 98/NT / 2000, HP-UX, AIX, Oracle 9i, TOAD, Database Tools/Utilities, Oracle Enterpris6e Manager (OEM)