Summary

• 7 years of Strong analytical and conceptual skills in database design and development on client/server applications under Oracle 11g/10g/9i/, Sybase, SQL, PL/SQL, T-SQL
• Expert in the development of stored Procedures, Functions, Packages and SQL Script.
• Familiar with database various objects includingschemas, tables, indexes, views, materialized views, triggers and so on.
• Expert in implementing cursors, ref cursors, dynamic SQL, temporary tables, session tables, indexes and exception handler during procedures development.
• Strong databaseperformance tuning skills.
• Good knowledge on advanceddatabase features like Result Cache, Bulk loading, Oracle Hints , Partitioning, VPD, and Explain Plan etc.
• Good knowledge on technical skills related to Database: Data Warehousing, ETL, AutoSysetc
• Experience in UNIX Shell Scripting for batch processing.
• Experience in users and privileges management.
• Good communication skills, Analytical and problem solving Skills, Efficient Team Player, fast learner, openness to help, willing to travel, Optimistic attitude and Enthusiastic.

Technical Skills

• Database: Oracle 9i/10g/11g, Sybase , DB2
• Related Skills: Data Warehouse, ETL, Autosys
• Developer Tools: Rapid SQL, SQL PLUS, Star Team, HP Application Lifecycle Management, HP Service Manager, Informatica , Toad ,Notepad , WinSCP
• Programming Languages: SQL, PL/SQL, T-SQL, C, C , Java, Shell Scripts, HTML
• Operating Sys: Windows, Linux

PROFESSIONAL EXPERIENCE:

Confidential

Role: Database developer Technical Supporter

Responsibilities :

• Involved in Gathering and Understanding the business requirements, analysis, design, development and implementation into the system.
• Created stored procedures under Sybase, Oracle, DB2 based on the business requirements.
• Converted stored procedures amongdifferent database environment.
• Convert SQL scripts into stored procedures and vice versa
• Provided sample data for stored procedures and packages for testing purpose
• Analyzed and compared the results from procedures and packages and checked results' rationality
• Involved in performance analysis using explain plan, query options and provided solutions for better performance
• Designed and managed box/job information for Autosys, including environment, dependency, scheduling time etc.
• Developed Reports for products and their price under DB2 Data Warehouse.
• Monitored box/job lifetime and workflows using Service manager, Informatica, and figured out the root problems once job failed.
• Test latest released applications, provided details about theirfunctionalities, compatibility and performance.
• Reviewed existing stored procedures/packages and made changes based on new business requirements, tables' changes, logical errors, new programming rules added and bad performance and provided solutions for fixing them.
• Created different scenarios to simulate potential timing issues that existing inside data transfer process
• Implemented Quality Centerto create test cases
• Involved in running weekly reports and provided results for business analysis
• Implemented Star Team to compare different versions of code and generated requests for procedures/packages immigration
• Responsible for monitoring the performance and stability of the software during performance test prior to going- live.

Environment Tools: Oracle, Sybase, DB2, Informatica, Service Manager, Data Warehouse, Rapid SQL, PL/SQL, T-SQL, SQL Plus, SQL Loader, Star Team, Quality Center, Windows 7, Linux, Notepad .

Confidential

Role: Oracle SQL, PL/SQL developer

Responsibilities :

• Involved in Gathering and Understanding the customer requirements, analysis, design, development and implementation into the system.
• Involved in the creation of database objects like tables, views, stored procedures, functions, DB triggers, Indexes and Collections.
• Extensive use of advanced techniques like Parameterized Cursors, Ref Cursors, Dynamic SQL in the PL/SQL Blocks.
• Involved in Tuning the SQL and PL/SQL Procedures
• Created materialized views for quick SQL queries.
• Heavily optimized the code for high performance using bind variables, bulk collects.
• Implemented 11g new features including using new data type, interpreted/native compilation modes switch, caching, subprogram inlining, etc.
• Responsible for development and testing of conversion programs for importing data into Oracle database utilizing PL/SQL, SQL Loader and UNIX shell scripts, to load data from flat files to Oracle database.
• Developed, Tested and Migrated UNIX Shell Scripts.
• Actively involved in Technical Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Worked with analysts, users, and other IT technical professionals to understand requirements.
• Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.
• Code review of fixed issue.
• Documentation of user manual and other generic documentation required for the module.
• Responsible for designing, developing, specification of test plans.
• Testing against SQL Injection.
• Responsible for monitoring the performance and stability of the software during performance test prior to going- live.

Environment: Oracle 11g , Toad 9.0, PL/SQL, SQL Developer, SQL Plus, SQL Loader, Unix and Shell Scripting, Windows 7.

Confidential

Role: Oracle PL/SQL developer

Responsibilities:

• Involved in analysis, design and coding of Oracle processes in PL/SQL to build packages.
• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle 9i.
• Used SQL LOADER and UTIL file loader to upload bulk by writing scripts for the Control file and interactive data between Database and Microsoft Excel.
• Created VPD for security policies.
• Created Global Temporary Tables to handle one-to- many records manipulations.
• Created partitions for parallel processing of data.
• Using Ref Cursors to pass variables between subprograms.
• Involved in performance tuning.
• Using partitions to provide quick queries.
• Error handling using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Writing SQL queries, Cursors using embedded SQL, PL/SQL.
• Testing and debugging of the applications.
• Testing and against SQL Injection.
• Tuned PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, Explain Plan, TKPROF and analyzing the tables.
• Tuning SQL and PL/SQL performance using explain plan, bulk collect, subprogram in lining and caching.
• Worked on production support, and receive production calls, and working on trouble reports which are received from clients

Environment: Oracle 11g, CVS, Windows 2007, Linux, SQL LOADER, and Toad.

Confidential

Role: Oracle SQL, PL/SQL developer

Responsibilities:

• Gathering development requirement from client's functional team and from functional design specification documents.
• Created logical and physical database objects - tablespaces, tables, indexes, referential integrity constraints, and triggers to development needs.
• Created and edited procedures and functions to suite the improved business requirements
• Developed and modified Oracle PL/SQL codes like Stored Procedures, Functions, Triggers and Packages based on technical and functional specification documents. Sub-queries, Merge statements and appropriate Joins were extensively used in stored procedures.
• Optimized the Oracle PL/SQL queries by Performance Tuning.
• Fine-tuning of PL/SQL Stored Procedures using HINTS in Explain Plan.
• Worked on enhancement of existing functions and packages.
• Testing codes developed by self and team.
• Bug Fixing while in Production with top priority.
• Refresh databases, schemas using Datapump Export and Import.

Environment :Oracle 9i, CVS, Windows XP, SQL LOADER, and PL/SQL, Eclipse

Confidential

Role: Oracle SQL, PL/SQL developer

• Developed Stored Procedures, Functions, and Packages using Pl/SQL as per the design documents.
• Analyzed all business functionality related to back end database interfaces.
• Involved in writing Event Triggers, PL/SQL Program Units for Forms and Reports for Client Validations.
• Formatting, Testing and rerunning the existing forms and reports.
• Coordinated with DBA in creating and managing table, indexes, table spaces, triggers, db links and privileges.
• Developed automated UNIX shell scripts to schedule the load of flat files on daily, weekly and monthly basis.
• Granted end-users the privileges to view
• Involved in Web design and programming using JavaScript, XML
• Developed user documentation for all the application modules.
• Responsible for monitoring the performance and stability of the software during performance test prior to going- live and after going-live continued to monitor as part of the post-production support.
• Also responsible for writing test plan documents and unit testing for the application modules.

Environment: SQL, PL/SQL, Oracle 9i, Toad, Reports 9i, SQL Plus, SQL LOADER, Windows XP, UNIX, HTML.