SUMMARY

• Over 4 plus 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, TOAD 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.
• 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.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Hands on experience working on Java applications.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Expertise in data modeling, normalization, database design, data loading, data retrieval, modification and archival techniques.
• Developed HTML web pages.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i

Scripting: UNIX Shell Scripting

Languages: SQL, PL/SQL, HTML, XML, C, C++, Java, JavaScript

Programming and GUI: TOAD, SQLPLUS, SQL Developer, SQL Navigator, Putty

Operating Systems: Windows 95/2000/Vista/XP/7/8/10, UNIX, LINUX

Tools: Microsoft Visio, MS Office 2007/2010, Data Modeler

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Database Developer

Responsibilities:

• Installed and tested new versions of DBMS.
• Controlled access permissions and privileges.
• Maintained data standards and written database documentation including procedures and definitions for data dictionary.
• Ensured that storage and archiving procedures are working successfully.
• Performed importing and exporting on the dump file to a new Oracle database.
• Worked closely with IT Project managers, applications and operational staff to ensure database security and integrity.
• Commissioned and installed new applications and customized existing applications in order to make them fit for purpose.
• Developed procedures, packages and functions as per the new requirements.
• Created database triggers to maintain the security.
• Developed SQL queries using joins, sub-queries and views to retrieve data from the database.
• Attended Design meetings, code review and test review meetings.
• Involved in performance tuning by modifying the queries and creating indexes.
• Performed staging of the data before migrating to the target system.
• Took ownership of design, development and testing of all data transformation, extraction and migration responsibilities.
• Performed different data type conversion techniques using conversion functions Cast, Convert, Compose, Decompose, etc.
• Developed database procedures and UNIX shell scripts.
• Involved in writing scripts to perform database clean-up to maintain and upgrade the company’s storage capacity.
• Kept the databases up to date and also involved in writing disaster recovery plans.

Environment: Windows 7 / XP, Oracle11g, SQL, PL/SQL, SQL*Plus, SQL*Loader, TOAD, UNIX Shell script.

Confidential, Tampa, FL

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in Requirement gathering from the existing applications and end users and worked with the Architects and Tech Leads for architecting the product as per the business requirements
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements
• Created materialized views, Inline Views & normal views where business requirements needed
• Tune the SQL queries and complex procedures to improve performance
• Created database triggers for data security & Consistency
• Developed procedures, functions and packages for new requirements
• Developed SQL*loader scripts to load data from various forms of flat files into staging tables in Oracle database using shell scripts.
• Developed packages for processing data in the staging tables according to the Clients requirements
• Implemented Advanced PLSQL Concepts for better performance of PLSQL Applications.
• Designed and developed user interfaces using Oracle Forms.
• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.
• Developed and created various scenarios for testing the code
• Performed unit testing and supported integration testing and end user testing.
• Worked closely with QA testing resources to ensure the Testing issues are resolved on time.
• Debugged existing code for business logic issues.
• Production support and maintenance for the current application and fix/rewrite the PL/SQL code if any ticket assign from users.
• Extensively involved in UNIX shell scripting for writing Wrapper scripts, SQL Execution scripts in ETL processes
• Supported in updating the technical documents as per new design.

Environment: Windows 7 / XP, Oracle11g, SQL, PL/SQL, SQL*Plus, SQL*Loader, UNIX Shell script, TOAD.

Confidential

Database Programmer

Responsibilities:

• Developing the Oracle reports based on the project requirements.
• Conducting the unit testing and performance testing on the reports.
• Experience in Oracle Backend programming in SQL and PL/SQL, Procedures, functions, triggers and packages in Oracle database server and also for Oracle Application Server using PL/SQL.
• Wrote DDL Scripts to create new database objects like tables, views, sequences, synonyms, and indexes.
• Created Materialized views and Materialized view logs.
• Wrote extensive Exception handling procedures to handle exceptions.
• Generated monthly reports in different formats like tabular, form and matrix using Oracle Reports.
• Created LOV’s for data elements in Oracle Forms.
• Created Master/Detail forms.
• Wrote SQL scripts to perform Back End testing of the Oracle database using SQL.
• Involved in writing Unit Test Cases and Test Scripts for Manual Testing from Use Cases.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Attended Design meetings, code review and test review meetings.
• Data loading from other databases and text files into Oracle Database using SQL*LOADER.
• Extensive experience in loading high volume data and Performance tuning.
• Experience in Performance Tuning using various types of Hints, Partitioning and Indexes.
• Expertise in handling errors using Exceptions.
• Attended meetings and review to discuss current issues and processes to tackle issues.
• Worked as a Developer, did requirement analysis, design, developed (Oracle - PL/SQL), tested and implemented and provided infant care on production.
• Involved in Logical and Physical Database design and Star Schema design. Identified Fact tables, Transaction tables.
• Gathered the requirement from the client and translated the business design into technical design.
• Involved in creating Procedures, Functions, Packages, and Triggers. Creating reports using Reports 6i.
• Extensively involved in writing SQL queries (sub queries and join conditions) for generating complex reports.
• Involved in the development of UNIX shell scripts.
• Performed tuning of the SQL queries using Explain Plan.

Environment: Oracle 9i, PL/SQL, Shell script, Oracle Web Server (OAS), JavaScript, UNIX, Oracle Forms and Reports, HTML and CSS