SUMMARY

• Over 7 years of IT experience in developing software applications using Oracle 11g/10g/9i/8i and its products in a variety of applications.
• Programming experience using PL/SQL, SQL, T SQL, Stored Procedures, Functions, Cursors, Constraints, Triggers, Indexes (B - tree Index, Bitmap Index), Views, Materialized Views using SQL.
• Extensive work experience in writing and implementing database objects like Tables, Views, Indexes, Sequences, Synonyms, Stored Procedures, Functions, Exceptions, Triggers and Packages.
• Expertise in working complete System Development Life Cycle (SDLC) such as analysis, design, development, testing, implementation and support with exposure in database.
• Extensive knowledge of Relational Database Management System (RDBMS) Concepts.
• Data Cleansingexperience using PL/SQL, SQL Coding, UNIX Shell scripting.
• Modified existing complex queries into easily understandable by using Sub-query and Loop structures.
• Excellent knowledge of SQL and UNIX shell scripting.
• Efficient in Creating and Using Cursors and Ref Cursors in processing of data.
• Experience with writing SQL queries for data validation and data integrity testing.
• Experience in Query optimization/Performance tuning like Performance Planning, Instance Tuning.
• Used Collections and Bulk Techniques to improve performance.
• Experience with performance testing for data loading process in DWH environment.
• Extensively worked on Packages, Functions, Procedures and Triggers in PL/SQL.
• Extensively used ETL methodologies for Data Extraction, Transformation and Loading processes.
• Good knowledge of STAR Schema, Snow Flake Schema, FACT Tables and Dimensional Tables.
• Experienced in User Acceptance Testing (UAT), Unit testing, System testing, Integration testing, Development and Production.

TECHNICAL SKILLS

Database: Oracle 11g, 10g, 9i, 8i, SQL Server 2000/2005

Operating System: Windows NT, Windows 95/98/2000, Windows XP

Tools: TOAD, Putty, OWB/ETL, SQL Developer

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++, Perl Scripting

DB Utilities: SQL*Loader, Explain Plan, vi Editor, Data pump, Export / Import, Expdp / Impdp

File Transfer: TCP, UDP, FTP, DNS, SMTP, DHCP

Web Technologies: HTML, DHTML, XML, JavaScript, CSS

Other Application: MS Office, Adobe Acrobat Reader/Writer

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Oracle PL/SQL Developer

Responsibilities:

• Involved in writing complex queries to generate reports as per client request as a part of production support.
• Created Stored Procedures, Functions and Triggers to maintain various business rules in the Active Data Warehousing Project.
• Modified Procedures and Functions to suite the improved business requirements.
• Created records and nested tables in the procedures for handling data.
• Analyzed the existing Stored Procedures, Functions, Triggers and Cursors thoroughly on Performance issues.
• Involved in creating Sequences (to generate consequence numbers) and Constraints (to limit the type of data).
• Used JDBC (Java Database Connectivity) connection in support of creating and executing queries.
• Also analyzed Indexes on regular basis.
• Used export/import and expdp/impdp database utilities for data transfer.
• Tested Oracle PL/SQL and Stored Procedures.
• Used Performance Tuning tools like Explain plan, Oracle optimizer to improve the database query performance.
• Extracted data from the Customer Interaction Center and creating separate flat file (text file) to load data into database table.
• Created SQL Scripts, Functions, Procedures and Packages for customer interface.
• Handled errors using System defined exceptions and User defined exceptions like INVALID NUMBER, NO DATA FOUND, CASE NOT FOUND, INVALID CURSOR, TOO MANY ROWS.
• Used Oracle packages like DBMS ALERT, DBMS OUTPUT and UTL FILE.
• Used %TYPE and %ROWTYPE for anchoring the variables to the database data types.
• Developed Row level and Statement level Triggers for auditing tables in PL/SQL.
• Developed Views and Materialized Views for specific data retrieval for the reports.
• Coded statements to retrieve data from the database depending on the need.
• Written PL/SQL Cursors for transaction processing.
• Used Bulk Collect feature to process the data from Cursor/Ref Cursor.
• Created Indexes for faster retrieval and improved query performance.
• Used SQL plus and TOAD to develop database applications.
• Developed Unix Shell Scripts and DBMS Jobs to automate jobs and loading data into the Database using SQL* Loader.
• Worked extensively with the universe team and database team and users to analyze the gaps

Environment: 10g, TOAD, SQL*PLUS, Export, Import, SQL, UNIX, SQL*Loader, JDK, J2EE

Confidential - Richmond, VA

PL/SQL Developer

Responsibilities:

• Gathered and analyzed requirements from business users.
• Created database objects like tables, synonyms, sequences and views.
• Edited procedures and functions for improved business requirements.
• Used SQL Loader to load data into the database coming from Metavance and Standby Databases.
• Wrote complex PL/SQL packages for Customer Interfaces, Payment Interfaces and Broker Commissions for Oracle Applications.
• Used Materialized Views, Hints, SQL Trace / TkProf, Indexes for query tuning and optimizations.
• Used BULK COLLECT, and External Tables for improving performance on the Enterprise DataWarehouse.
• Created Test Cases, Technical Design Documents, Install Plans and worked with Release Engineering teams.
• Used ClearCase, ClearQuest, and Sharepoint for defect creation/resolution, documentation, development tracking and Code repository.
• Worked with BOXI universe and Webi Reports along with Discoverer reports.
• Collaborated with Data Warehouse Architect in writing SQL scripts, Shell Programs, Data Flows, and more.
• Worked with Oracle Forms 6i and Reports 6i.
• Supported development, test and the production databases.
• Used SQL Developer and TOAD to develop code.

Confidential, Dearborn, MI

Oracle PL/SQL Developer

Responsibilities:

• Created database objects like Tables, Indexes, Views, Materialized Views, Triggers, Procedures, Functions, Exceptions using SQL*plus and TOAD.
• Involved in creating Sequences (to generate consequence numbers) and Constraints (to limit the type of data).
• Used JDBC (Java Database Connectivity) connection in support of creating and executing queries.
• Created and managed users, roles and profiles, monitored databases and user access.
• Analyzed time consuming SQL and PL/SQL block queries and tuned them to run in less time by using cost based Optimizer hints, Explain plan.
• Worked with different types of Sub-queries and Loop structures which suit according to business logic.
• Written Cursors and Ref Cursors to fetch records.
• Created Indexes on the tables and on another Index for easy retrieval of the data to make the data searching speed faster.
• Planned Index Rebuilding, Index Analyze and Table Analyze on periodic basis.
• Involved in creating users and privilege Management using roles and grants.
• Used Pragma Exception INIT to name the system exceptions that are raised by the program.
• Handled errors using System defined exceptions and User defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.Developed Row level and Statement level Triggers for auditing tables in PL/SQL.
• Written Shell scripts to automate loading the files into database using Crontab.
• Developed Views and Materialized Views for specific data retrieval for the reports.
• Made used Sub-query (WITH clause) to make complex SQL statements simple and make them more efficient.
• Used PL/SQL tables to avoid mutating problem in database triggers.
• Used Public Synonyms, read only User Accounts and Database Links for remote database access.
• Used Oracle supported DBMS STATS, DBMS JOB packages to gather the statistics and schedule job respectively.
• Used %TYPE and %ROWTYPE for anchoring the variables to the database data types.
• Worked with Bulk Collects to improve the performance of multiple-row queries.
• Documentation of the completed work.

Environment: Oracle 11g/10g, UNIX Shell Scripting, Export/Import, SQL Developer, SQL*PLUS, TOAD, Oracle Forms, vi editor, JDK

Confidential, Denver, CO

Oracle Developer

Responsibilities:

• Developed Proceduresand functions to reflect the desired functionality for the enhancement task using PL/SQL.
• Supported commitment-tracking account, developed procedures and functions for the commitment tracking application using PL/SQL.
• Designed and developed customized report SQL per client requirements and also involved in documentation design and unit testing of packages produced
• Developed lower level design for the project, developed procedures, triggers to reflect business rules.
• Developed test scripts for Forms and also involved in functional testing of these Forms.
• Designed complex SQL queries to extract the data from multiple tables to extrapolate the desired output according to the current needs.
• Developed forms in Forms 6i and maintained forms in Forms 6i.
• Extensively used SQL* LOADER and SQL Scripts to load data fast.
• Developed shell scripts to schedule the processes to run at particular time intervals.
• Designed and created customized reports using report builder 6i and also maintained existing version 2.5 reports.
• Developed new standard financial reports using Oracle Reports 6i and also maintained existing financial reports in Reports 6i.
• Worked on Materialized views to improve the performance of distributed queries.
• Performed performance tuning for various report queries using Explain Plan and TKPROF.
• Used partitioning of tables to improve the performance of queries.
• Performed technical assessment, coding activity requests for changes and enhancements to existing Forms and Reports.
• Migrated Oracle Forms 3.0 applications to Oracle Forms 6i (GUI, Character) and Reports 2.5 to Reports 6i in Windows 98, UNIX environment.
• Tested migrated forms and reports by writing test plans and scripts.

Environment: Oracle Database 8i/9i, Oracle Forms 6i and Oracle Reports 6i, Toad, SQL, PL/SQL, SQL*Loader, UNIX shell script

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Designing module wise Oracle 8i/9i database structure and its implementation on the client server.
• Extensively used Explain Plan, TKPROF utilities for SQL query optimization.
• Used PL/SQL table to avoid mutating problem in database trigger.
• Using the Crontab in UNIX and Scheduler in windows for Automatic Tasks (Analyzing tables, loading into Tables, Imp/Exp).
• Develop tables, views, stored procedures, triggers, indexes, rules, defaults, and user-defined data types.
• Worked on tuning the SQL queries and stored procedures.
• Used various forms of control structures including IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.
• Used EXPORT/IMPORT to do table level and full database de-fragmentation.
• Developed packages, procedure and functions for complex Reports.
• Utilizing Built in Oracle Packages like (UTL FILE, DBMS OUTPUT) for better debugging.
• Worked on User-defined and System defined exceptions to handle different types of Errors like NO DATA FOUND, TOO MANY ROWS.
• Developed PL /SQL code for updating payment terms.
• Developed SQL * loaderscripts to load data into the database tables.
• Created database links to retrieve data from multiple servers.
• Created public synonyms on the database links for easy reuse.
• Developed invoice-printing reports for single and consolidated invoices
• Modified existing codes PL/SQL packages to perform Certain Specialized functions and enhancements.

Environment: Oracle 8i/9i, SQL*Loader, TOAD, SQL*PLUS, UNIX