SUMMARY

• 7+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle 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.
• Experience with Entity relation modeling.
• Expertise in Client - Server application development using Oracle 11g/10g, PL/SQL, SQL *PLUS and SQL*LOADER.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Strong in using tools such as PL/SQL developer, SQL*Loader, oracle Discoverer, TOAD and SQL*Plus.
• 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 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 Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Databases: Oracle 11g/10g, Oracle reports 10g/9i/6i, ETL, Oracle Portal, SQL, PL/SQL, SQL Server 2005

Languages: SQL, PL/SQL,HTML, Visual Basic, AJAX, XML, CSS

Operating System: Win 7, Windows Vista, Windows XP, Windows 2000

Query and GUI Tools: SQL PLUS, PL/SQL Developer, SQL Navigator, and ETL

Other Tools: MS Project, MS SharePoint, MS Visual Studio MS Office Suite, CSS, Minitab, SAP, Discoverer 9i, Toad 10.6.13, Putty, TWS, PVCS, BASE, CYGWIN, WinSCP, OracleJ Developer 10.1.3.3, ERWIN

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

ORACLE PL/SQL DEVELOPER

Responsibilities:

• Involved in analyzing the system and business.
• Developed, Modified, Tested and Debug the PL/SQL Packages, Materialized Views, Functions, Procedures and Triggers according to the requirements.
• Wrote complex SQL queries with Co-Related Sub queries, nested loops for faster data retrieval from multiple tables.
• Involved in unit testing, system integration testing and user acceptance testing.
• Involved in the changing existing SQL Queries according to the new requirement.
• Involved in loading the data from flat files, CSV files, MS XL sheets into database.
• Used Bulk and FORALL to improve the performance of PL/SQL blocks.
• Involved in working with Implicit Cursors, Explicit cursors and Ref Cursors.
• Creating and worked with GTT (Global Temporary Table).
• Involved in creation of various indexes on relational tables, which are B-tree, Bitmap, and Function Based.
• Create various user defined exceptions to control the process based on the business requirement.
• Improved the performance of queries by using Explain Plan and Hints

Environment: Oracle 11g, PL/SQL, SQL Developer 4.0.1, Toad 10.6.13, QC Mercury, TortoiseCVS, Putty, Windows 2003/XP, Microsoft Visio, Dicoverer.

Confidential, Richardson, TX

ORACLE PL/SQL DEVELOPER

Responsibilities:

• Heavily involved with the Logical and Physical Design of the Database.
• Creation of database objects like tables, views, procedures and functions.
• Developed PL/SQL-Packages, SQL Scripts and Database Triggers for making history of insertion, updating, deletion and all kind of Audit routines.
• Used various Joins for data retrieval from multiple tables according to the requirement.
• Experience with usage and creation of indexes on the table for better performance of complex query.
• Extensively used cursors (refcursor, sys refcursor), sequences in the procedures according to the requirement.
• Used Wrappers for data security which encrypts the PL/SQL code (hide the customer information).
• Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN, HINTS, and DBMS PROFILER.
• Used crontab, dbms job and dbms schedular for scheduling of jobs.
• Used Dynamic SQL for Query Optimization and by using this dynamic sql it increases the performance and also to perform error detection and cleanup.
• Involved in Doing Partitioning and Sub partitioning on table to improve performance.
• Worked on User-defined and System defined exceptions to handle different types of Errors.
• Used SQLCODE and SQLERRM for the exceptions error code.
• Extensively worked on SQL Loader for loading data into tables from flat files and CSV files.
• Experience in using packages like DBMS JOBS, DBMS SCHEDULER to schedule tasks.
• Extensively used FORALL and BULK COLLECT to fetch large volumes of data from table.
• Using the Crontab in UNIX and Scheduler in windows for Automatic Tasks (Analyzing tables, loading into Tables, Imp/Exp).
• Developed UNIX shell scripts (Korn/Bourne/bash) for routine tasks.
• Used merge with insert and update statements.
• Developed flat files using UTL FILE Oracle supplied packages.
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops while developing procedures.
• As a team member, involved in interacting with business users, gathering business requirement.
• Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.

Environment: Oracle 10g, Solaris 5.10, UNIX, Windows XP, SQL Developer, MS Visual Studio, MS Office Suite.

Confidential, New Hartford, NY

ORACLE PL/SQL DEVELOPER

Responsibilities:

• Creating database objects like tables, synonyms, sequences and views
• Created, edited procedures and functions to suite the improved business requirements
• Created records and nested tables in the procedures for handling of data
• Used SQL Loader to load data into the database coming from Knipper and FICO
• Used export/ import and expdp/impdp database utilities for data transfer
• Coded complex SQL queries to retrieve data from the database depending on the need
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors
• Creating and working with GTT (Global Temporary Table)
• Made use of Sub query-Factoring (WITH clause) to make complex SQL statements simple and make them more efficient
• Performed tuning for PL/SQL procedures and packages and modified code accordingly to improve performance
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus
• Performed exception handling for the procedures created
• Written and edited shell scripts to automate the execution of the procedures and report the results through e-mail
• Experience in resolving anomalies in the production database
• Created indexes for faster retrieval and improved query performance tools like Oracle optimizer, explain plan, hints to improve the database performance
• Support for the development, test and the production databases
• Used SQL plus and TOAD to develop database applications
• Documentation of the technical work done

Environment: Oracle 9i, oracle forms/ reports 9i, Erwin 4.0, UNIX, TOAD.

Confidential, Grand Rapids, MI

PL/SQL Developer

Responsibilities:

• Worked on complete SDLC (system development life cycle) including system analysis, high level design, detailed design, coding and testing.
• Created Database tables in GDS architecture and performed DDL, DML and DCL commands.
• Participated in designing new applications for Sales and Invoicing & Billing and providing technical services in major development and implementation of business procedures and plans.
• Wrote the Scripts to create tables, functions, stored procedures, Triggers, Packages, Indexes, Views and also analyzing.
• Created Packages, Procedures that performs the above logic to process claims.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Used FTP, SCP and WinSCP to transfer the files between different servers.
• Involved in data modeling and creating ER Diagrams using MS-Visio.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Created Custom Stored Procedures, Packages and SQL Scripts
• Used version control software to keep track of the project using IBM Rational Clear Case.
• Created job schedules in UNIX for the automation of the process of acquiring the feeds, matching the data with existing data, validating the data and using the data for other applications.
• Managing Version Control Tool CVS for source code migrations.
• Executing ftp, telnet for remote access between UNIX systems.
• Extensively worked on FACETS tables.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.
• Also worked on Oracle APEX tool.
• Created front end Oracle form using Oracle Forms builder 9i for customer which uses package coded by myself in the back end.
• Created VB 6.0 executables for deployment of application through Lotus Notes agent.
• Prepared the technical documentation and user support documents.
• Documenting procedures and scripting, and eventually be drafting up them into Unit test plans..
• Performed DBA activities includes creation of users & table spaces, indexes, Creation of database Links, performance tuning, disk space monitoring and File transfers using FTP.

Environment: Oracle 10g, SQL, PL/SQL, Visual Basic 6.0,Forms 9i, TOAD, UNIX, GDS Architecture, Agile Methodology, Master Job scheduler, APEX 4.1, Production Support, SVN, CVS.

Confidential, Minneapolis, MN

Oracle developer

Responsibilities:

• Maintaining the Operation Readiness Review database for the LVTS.
• Analysis of business requirements and major developments.
• Involved in gathering the requirements, Documenting and Review from the SLM’s, work streams & performance testing teams.
• Handling the ORR database completely.
• Responsible for moving the source code to Production.
• Involved in Pre-Production Changes that are part of a Pre-Production Environment.
• Scheduled review & status updates meetings with the stake holders and off shore team.
• Based on the feedback, small enhancements have been implemented into the ORR database.
• Involved in resolving the problem and requesting a solution in Problem Management and Change Management.
• Created Manage Now id’s as per the requirement.
• Lead experience with the offshore and onsite from India/ China Development team.
• Worked with Oracle Business Object Developers in planning sessions with PM, BA and team members to analyze business requirements.
• Worked with Test Environment Management team in solving the raised issues. Supported developers for efficient SQL query and performance.
• I am involved in developing Oracle Reports; maintain the database using PL/SQL.
• Created the Environment Tasks Plan for Monitoring, Readiness, DR setup & other tasks.
• Created the Batch jobs using TWS.
• Involved in writing the shell scripts for checking the web, application provided production support and played a major role in debugging errors during implementation and deployment.
• Given transition to the new project mates.

Environment: Oracle 10g, ORR database, GIM Application, TWS, SQL & PL/SQL Development, Forms & Report, Dynamic SQL, SQL*Loader, Oracle SQL Developer, UNIX Shell Scripting and Windows XP.