SUMMARY:

• Having 9 years of programming experience in IT. Over 6 years of experience as an Oracle PL/SQL developer and 3 years of experience as T - SQL developer in Analysis, Design and Implementation of Business Applications using the Relational Database Management System (RDBMS).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Expertise in Client-Server application development using Oracle 11g/10g/9i PL/SQL, SQL*PLUS, TOAD and SQL*LOADER.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write.
• Data integration and migration specialist with over 3 years of extensive experience in leading the conversion of multiple legacy data systems from different sources into Oracle databases.
• Strong experience in Data warehouse concepts, ETL.
• Expertise in writing shell scripts for scheduling jobs, rebuilding indexes.
• Good knowledge on logical and physical Data Modeling using normalizing techniques.
• Working knowledge of PRAGMA features, PLSQL OPTIMIZE LEVEL, BLOB, CLOB.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan and tkprof.
• Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
• Created Tables, Views, Constraints,DB Links and Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range,list partition technique.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Cursors,Ref Cursor and Collections.
• Expertise in Dynamic SQL and Exception handling.
• Good knowledge of key oracle performance related features such as Query Optimizer, Execution Plans and Indexes,statspack,AWR.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS:

Databases: Oracle 9i, 10g, 11g, MS SQL SERVER 2000/2005/2008

Operating Systems: RHEL 5.x, 6.x and Windows 2003/7/2008/2012.

Programming Languages: SQL,TSQL,PL/SQL and Java

Tools: & Utilities: SQL*Plus,OEM, Toad, SQ*Loader, Export/Import,RMAN,Data pump,DBCA,SSMS,SQL Profiler, Informatica

Tuning Tools: ADDM, AWR, TKPROF, EXPLAIN PLAN, STATSPACK

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

PL/SQL Developer

Description:

• The Clinical Trial Management System(CTMS) has the ability to add visits,elements,study protocol,personnel,add sites and organizations, management of invoices and payments, as well as keep track of patient data, and recruitment resource. The CTMS is a fully integrated with the document management system to maintain the patient information as a paperless solution and it is automatically send appointment confirmations and reminders to the patients.
• Responsibilities:
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several shell scripts according to the changing needs of the project and client requirements.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed initial data migration, subsequent delta migrations and validated the data been converted.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools likeToad, PL/SQL Developer and SQL* plus.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Linux, Windows, Java,Crystal Reports,Oracle 11g, SQL*Plus, TOAD, SQL*Loader, SQL Developer, Shell Script.

PL/SQL Developer

Description:

• The Pharmacy Information Management System(PIMS) can assist in patient care by the monitoring of drug interactions, drug allergies and other possible medication-related complications.When a prescription order is entered, the system can check to see if there are any interactions between two or more drugs taken by the patient simultaneously or with any typical food, any known allergies to the drug, and if the appropriate dosage has been given based on the patient’s age, weight and other physiologic factors.
• Responsibilities:
• Developed Advanced PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using TOAD. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Involved in creating shell scripting. Defragmentation of tables, partitioning,indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions table and Partition Indexes to make Database faster and easier to maintain.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development LifeCycle.
• Migration of existing data attributes from SQL Server, Oracle into Oracle.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK binding involved in writing database procedures, functions and packages for front end module.
• Used principles of normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed shell scripts to automate repetitive database processes.

Environment: Linux,VB 6, Oracle 11g, SQL,PL/SQL, SQL*Loader, SQL Plus,TOAD,shell scripting,PostgreSQL,PGAdmin,PSQL.

Oracle PL/SQL Developer

Responsibilities:

• Wrote Shell Scripts for Data loading from DDL and DML Scripts.
• Worked in production support environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Wrote conversion scripts using SQL, PL/SQL stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects including tables, indexes, views, sequences packages and procedures.
• Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.
• Involved in Logical & Physical Database Layout Design.
• Set-up and Design of Backup and Recovery Strategy for various databases.
• Performance tuning of oracle databases and user applications.
• Used SQL*Loader as an ETL tool to load data into the staging tables.
• Provided user training and production support.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Environment: Java, Oracle 9i SQL, PL/SQL,SQL*Loader,Crystal Reports, TOAD,Enterprise Manager.

SQL Developer

Responsibilities:

• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Worked with installing,designing and managing MS SQL Server 2008.
• Installation of SQL client and establishing connectivity to databases
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Involved in modifying various existing packages, procedures, functions and triggers according to the Client Requirements.
• Used stored procedures, wrote new stored procedures, modified existing ones, and tuned them such that they perform well.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Used indexes to enhance the performance of individual queries and enhance the Stored Procedures.
• Managed all indexing, debugging, optimization and performance tuning using SQL Profile and SQL Server Agent.
• Designed, developed, and tested stored procedures, views and complex queries for Reports distribution.
• Developed database triggers and stored procedures using T-SQL cursors and tables.
• Effectively used views to prevent unauthorized access.
• Tuned SQL queries using execution plans for better performance.

Environment: Windows 2003 Server,.Net,SQL Server 2005/2008,SSMS,SQL,T-SQL,SQL Profile,DBCC, SQL Queries, Stored Procedures, Office, Excel, SSRS.

SQL Developer

Description:

• Document Management System is used for Scanning the Case Sheets of the Patients, X-Rays and all other related information of the Patient and saving the scanned files in JPEG, PNG, TIFF, BMP, etc.. Maintaining separate tables for storing the files information. This DMS is mainly used for reducing the patient documents in Hard Copy and become easier if they are scanned and saved in files, So that concerned authorized person can view the respective patient files in system rather in a Hard Copy.
• Responsibilities:
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Wrote identity for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.
• Worked with installing, designing and managing MS SQL Server 2008.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and T-SQL procedures to create database objects dynamically based on user inputs.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Created Triggers, Views for Audit and security purposes.
• Created different types of User-defined functions.

Environment: Windows 2003 Server, Dot Net.,SQL Server 2005/2008,SSMS,SQL Profile,DBCC, SQL Queries, Stored Procedures, Office, Excel, SSRS.