SUMMARY

• 9+ years of experience in analysis, design, development, testing, implementation and production support of various Applications and development of client - server applications as a PL/SQL Oracle developer and database designer
• Excellent working and conceptual knowledge of ORACLE PL/SQL, SQL, UNIX Shell Scripting, Java, C/C++ languages
• Well versed in developing various database objects like packages, stored procedures, functions, triggers, compound triggers, tables, indexes, constraints, views and in Oracle 11g/10g/9i.
• Used Collections, Records, Cursors, REF Cursors, Dynamic SQL and Exception Handling.
• Enforced data integrity using integrity constraints & database triggers.
• Experience with using oracle long data types like BLOB, CLOB
• Expertise in developing and customizing Oracle Forms and Reports using Oracle Forms 10g, Reports 10g and developing concurrent programs using SQL, PL/SQL.
• Solid experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Tuned SQL queries using EXPLAIN PLAN, optimizer Hints, TKPROF utility, Indexes and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Experienced with SQL performance tuning and optimization using execution plans.
• Excellent in writing UNIX and LINUX Scripts.
• Experience in handling very large data files using Export-Import utilities
• Automated the source to target loads using UNIX shell scripting and CRONTAB
• Experience with tools like SQL developer, SQL plus, TOAD, Eclipse, Net beans and SPSS Dimensions.
• Strong Background in Data modeling concepts like ER Diagrams, Normalization and De-normalization of Tables.
• Strong understanding of Principles of Data Warehouse using Fact Tables, Dimension Tables and Star/Snowflake schema modeling.
• Strong understanding of data extraction, transmission and loading (ETL).
• Experience and Good Knowledge in Scripting and UI languages like Java Script, HTML
• Understanding of Database security concepts like database auditing, Permissions, cursors/record level security.
• Experience in functional and technical design, test plan preparation, unit testing, system integration and documentation. Wrote test cases for each and every requirement in all the application forms and reports.
• Strong experience in providing technical documentation and status reports of applications.
• Strong problem solving, decision making and result oriented skills.
• Highly organized and efficient to prioritize and manage multiple tasks.
• Proven ability to work efficiently both independently and team environment as a team player
• Trained and supervised new junior employees

TECHNICAL SKILLS

Languages: PL/SQL, SQL, Shell Scripts, Java, HTML, IBM SPSS MR Dimesion, C & C++

Databases: Oracle 11g/10g/9i/8i & SQL Server

Operating Systems: Windows 9x/2000/XP/7, Linux Red Hat and Debian

Tools: Toad for oracle, SQL Developer, SQL PlusOracle form and Oracle reportsEclipse, Net beans & Oracle query builder

Scripting: UNIX shell scripting, Java scripting

Package: Linux: Abi Word, Libre Office & MS Office

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Oracle Developer

Responsibilities:

• Involved in the Analysis, Design, CodingandTestingof the application.
• Created and ModifiedPL/SQL Triggers,Procedures, FunctionsandPackages.
• Wrote complex SQL queries and sub-queries for faster data retrieval.
• Used Bulk Collect and FOR ALL to improve the retrieval of multi row and to insert/delete multi-row from table.
• DevelopedER Diagrams, Data flow diagramsbased on the requirement.
• Developed SQL scripts tocreate database objects like tables, viewsandsequences.
• Created UNIX shell scripts and scheduled Crontab jobs.
• UsedSQL*Loaderto load bulk data from various flat files and legacy systems.
• Developed SQL and PL/ SQL scripts for transfer of data between databases.
• Testing and debugging the existing procedures.
• Developed complex triggers in reports before/after for validation of user input.
• Performed unit testing and supported integration testing and end user testing.
• Wrote complex SQL scripts and was responsible for Performance tuning of SQL Queries.
• Extensively worked on production issues with effective defect management.
• Used exception-handling methods along with RAISE APPLICATION ERROR in order to associate self-created exception names.
• Involved inlogical and physical database design,IdentifiedFact Tables,Transaction Tables.
• Proactively tunedSQLqueries and performed refinement of the database design leading to significant improvement of system response time and efficiency.

Environment: Oracle 11g,SQL,PLSQL, SQL*Loader, TOAD, Oracle Forms 10g

Confidential, Chicago, IL

Oracle PL/SQL Developer

Responsibilities:

• Responsible for Study, Analysis, Design, Development/Customization & Testing/Debugging of the application
• Involved in writing Procedures, Functions, Triggers, Packages, Cursors, Dynamic SQLs, Views and data loading using TOAD and SQL Loader utility for new/enhance requirements.
• Experience in using Dynamic SQL, BULK COLLECT, REF Cursors and VARRAYS.
• Designed and developed master tables, indexes, views, sequences and synonyms.
• Developed various Complex Queries, Views for Generating Reports.
• Prepared final design documents and general instruction to follow during development.
• Loading data from flat files into database tables using SQL* Loader.
• Used pipelined functions for faster data accessibility.
• Analysis of customer reported issues, which could be a code issues, Data fix issues, performance issues, setup issues, functional issues or an RDBMS issue.
• Automated the source to target loads using UNIX shell scripting and CRONTAB
• Interacted with the requirements team during development and with client users during implementation and analyze new business requirements or enhancements or change requests and prepared Functional/Technical Design documents.
• Effective Interaction with Support and other Application groups through on call for high priority issues
• Developed Test Plans and participate in Unit testing, System testing, thru production implementation.
• Involved in writing data Migration scripts/create table scripts to load data successfully from old schema to new structured schema.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Extracted data from the XML files transmitted to the bank and load them efficiently into oracle temp tables for day to day customer financial transaction reconciliation.
• Prepared status reports and attended status meetings on a daily basis to understand the resource utilization and assignments progress.

Environment: Oracle Database 11g, Oracle Database 10g, Windows XP/7, SQL * Loader, TOAD, PL/SQL, UNIX, XML

Confidential, San Francisco, CA

PL/SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Involved in designing ER diagram using Erwin, to set the logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used ORACLE SQL DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 10g/11g, Toad, PL/SQL, SQL, UNIX, Oracle forms and reports, SQL Loader and SQL developer.

Confidential, New York

PL/SQL Developer

Responsibilities:

• Coding of Application Program from Specifications using Oracle PL/SQL
• Developed programs for Data Load from Flat Files to Raw Tables
• Developed database triggers to improve the system security and capture the transactions.
• Developed Procedures, functions, triggers and packages for new requirements and involved in Performance Tuning of SQL and PL/SQL.
• Developed SQL queries, Exception Handlers, Ref Cursors and Database Objects.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Developed Database Triggers for audit and validation purpose.
• Extract data from the XML files transmitted to the bank and load them efficiently into oracle temp tables for day to day customer financial transaction reconciliation.
• Writing SQL Queries for data validation, extraction and loading.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Interact with the requirements team during development and with client users (at banks) during implementation and analyze new business requirements or enhancements or change requests and prepared Functional/Technical Design documents.
• Onsite support includes being available on-call (24X7) overnight to resolve production batch issues.
• Strong debugging skills ensuring both the technical and functional aspects of the requirement.

Environment: Oracle 10g, SQL Server, PL/SQL, SQL*Plus, SQL*Loader, TOAD 10, UNIX Scripts & MS Office

Confidential, Lansdale, PA

PL/SQL Developer

Responsibilities:

• Involved in SDLC process. Prepared project plan with deliverables and time lines.
• Created the tables and sequences for the experimental data load capture.
• Extracted the data from ELN database by writing the procedure and loaded into the table.
• Used the Bulk binding techniques for query optimization.
• Created indexes on tables and optimized procedure queries.
• Retrieved the user’s email address from the LDAP Server and stored them in a table.
• Created PLSQL procedure, which sends an email notification to the users.
• Used the HTML Coding for sending email notification for the users.
• Used the UTL SMTP Server connection for sending emails.
• Created PLSQL procedure, used the DBMS SCHEDULER for automatic weakly sending emails to the users.
• Involved in UAT testing, Bugs fixing and the code was sent to Production.
• Developed Excel Report using the procedural code.
• Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.
• Effort also included development of stored procedures.
• Prepared the Design specification and IQ Documents.

Environment: Oracle 10g, PL/SQL, SQL*Plus, SQL developer, TOAD.

Confidential, Bridgewater, NJ

Responsibilities:

• Extracted data from the InForm data from the source and created CSV files
• Created relevant staging tables to load the CSV files, identified the business validation rules
• Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.
• Created the tables and sequences for the experimental data load capture.
• Loaded the data into the created tables using TOAD and SQL*plus.
• Created metadata validation lookup tables and pre populated them using SQL Loader generator application.
• Wrote Packages to store the business rules and exceptions and wrote PL/SQL code to load data from staging tables to the SDTM target schema
• Created PL/SQL procedures and packages to convert clinical data into the format according to Clinical Data Interchange Standards Consortium (CDISC) standards.
• High End-Client Interactions for solving User Acceptance Testing (UAT) issues.
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling.
• Created triggers for auditing purpose and created group, tabular, and form reports.
• Database security by authenticating users, using logon triggers.
• Created materialized view on remote database and automated scheduler of refreshing of materialized view.
• Created indexes on tables and optimized procedure queries.
• Responsible for writing the technical documents and maintaining the documentation.

Environment: Oracle 9i, Pl/SQL, SQL Developer

Confidential, Irvine, CA

PL/SQL Developer

Responsibilities:

• Developed new PL/SQL programs to load the most recent job details for Financial Associates, PFR and LPFR consultants before or after the measurement periods with different data logics.
• Developed new oracle packages to load the mid-month and month-end draws before or after the measurement periods.
• Developed functions and procedures for different data load modules.
• Involved in the designing team to create object models.
• Designed the database models and created entities and relationships.
• Worked very closely with functional team to understand their Development related requirements.
• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
• While coding the Pl/SQL programs building the Queries and Sub-Query’s using Inline views.
• Work together with graphic designers and user interface to apply intuitive and appealing front-ends to Perl, web-based functionality.
• Involved in customizing the web pages by modifying HTML and Java Script.
• Designed and developed several views like Materialized View for data retrieval for the reports.
• Created Table structures along with the Triggers, Indexes like Bitmap and Function based Indexes.
• Involved in tuning using Explain plan & Tkprof utilities.
• Developed Shell Scripts to call the various UNIX SQL programs which runs the model every month.
• Developed standards to be followed during the coding phase.
• Tuned SQL queries to enhance performance, using the method Explain Plan both at backend and in Toad.
• Applying patches to the database.
• Once done with Unit testing migrating the objects to the QA & UAT TEST environment.
• 10G RAC switchover and failover configuration, implentation and testing·
• Coordinating and helping the QA team to help understand what the different program aims at.
• Created test scenarios for created code and distribute across to the QA along with Knowledge transfer.
• Attending and Solving both QA and Production tickets simultaneously for different programs across different schemas at any given point of time.
• Written the excellent documentation and provided on-site production support.

Environment: Windows XP, Unix, Oracle 9i, Oracle SQL Developer, SQL, PL/SQL, TOAD 7.6, Putty, MS Access 2000/2002.