SUMMARY:

• Over 6+ years of experience in analysis, design, development, testing and implementation of application software as Oracle PL/SQL developer.
• Expertise in SQL and PL/SQL programming and strong Knowledge on oracle architecture and database design.
• Expert in using tools such as Oracle PL/SQL Developer, SQL Plus, TOAD.
• Experience in using Microsoft SQL server 2008 for granting server level access.
• Extensively worked on Oracle backend Programming using PL/SQL, Stored Procedures, Functions, Packages, Ref cursors, Database triggers in Oracle 11g/10g/9i and also SQL queries.
• Experience in writing SQL queries for relational databases like Oracle 11g/10g/9i.
• Strong Experience in designing and developing oracle objects Tables, Views, Indexes PL/SQL Packages, Functions, Stored Procedures, and Triggers.
• Experience with various DDL functions like Creation of Schemas, tables, Indexes, Materialized Views, and Partitioning tables.
• Good knowledge in front end development using Oracle Forms6i/Reports6i/10g.
• Experience in the Deploying Forms and Reports on the web.
• Managing the end - to-end implementation of the project including designing, development, testing, implementation and support of software applications.
• Experience in Developing Forms based on views, Tables and Procedures in tabular and form layouts.
• Excellent analytical and problem-solving skills.
• Excellent Interpersonal and communication skills, efficient time management and organization skills.
• Detail Oriented, able to multi-task effectively. Willing to relocate anywhere and travel.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i, Oracle forms 10g/9i/6i, Oracle reports 10g, SQL server 2008, Microsoft Access.

Development Tools: Toad, SQL *Plus, SQL *Loader, SQL Developer, Oracle Enterprise Manager (OEM).

Operating Systems: Win XP, Win 7/8, UNIX.

Web Technologies: HTML, XML, Java Script, CSS.

Programming Languages: C, C++, Java, Unix Shell, and PL/SQL.

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Oracle Developer / Database Administrator II

Responsibilities:

• Designed and created database tables for storing domain id’s and other user records.
• Created stored procedures, functions and tables for packages for multiple applications.
• Created scripts to generate new tables, views for enhancement in application using TOAD and SQL developer.
• Developed PL/SQL triggers on master tables for automatic creation of primary keys values.
• Modified the existing code for Oracle provisioning tool and created a new Dev instance.
• Moved schemas and data from one database to other database for migration purpose.
• Monitored Database system inventory for duplicate, retired and connectivity issue databases.
• Figured and cleaned up the user ids from multiple tables under multiple databases.
• Upgraded Oracle 10g to 11g software in different environments for latest features and also tested databases.
• Granted access and created tickets to other development teams for supporting applications.
• Resolved tickets that are assigned to AOC for database accessing issues.
• Fixed defects for existing code in production environment.
• Fixed code defects by replicating same errors from production in test and development environment.
• Worked on SQL tickets to grant logins to server level using SQL server and performed user actions on DB.
• Worked closely with management to prioritize business goals and information needs.

Environment: Oracle 10g/11g, TOAD, SQL Developer, PL/SQL, Microsoft SQL server 2008, Windows.

Confidential, Richmond, VA

Oracle Developer

Responsibilities:

• Developed various PL/SQL stored procedures and functions
• Wrote PL SQL scripts and used couple of metadata tables to do Data Profiling, Referential Integrity and Data Quality before loading data into staging area.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD
• Developed PL/SQL triggers and master tables for automatic creation of primary keys and foreign keys.
• Development of the Mappings, Lookups, reusable components, Sessions, Workflows
• Coordinated with DBA in creating and managing Tables, Indexes, Table spaces, Triggers, DB Links and Privileges
• Developed back end interfaces using PL/SQL Stored packages, Procedures, Functions, Collections, Object Types, Triggers.
• Developed PL/SQL Procedures at the database level that were used in the mappings through Stored Procedure Transformation.
• Utilized SQL*Loader to load flat files database tables.
• Handled various exceptions to troubleshoot PL/SQL code.
• Formulated procedures, functions and packages; ensured that the quality, programming and project management standards were met.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table
• Created indexes on tables for fast retrieval of data.
• Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL’s thorough out the projects.
• Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages like DBMS SQL, DBMS XPLAN, DBMS PROFILER, DBMS JOB, and UTL FILE.
• Designing and rebuilding indexes for faster overall data processing.
• Gathering the requirements through meetings with the Business Users
• Worked closely with end-users and team members to understand business requirements that drive the analysis.
• Test case/data preparation, execution and verification of the test results.
• Responsible for documentation of all the project developments and modulations as per the standards defined and the system requirements.

Environment: Oracle 11g, TOAD, SQL * Loader, Windows XP, Java.

Confidential, Sacramento, CA

Oracle developer

Responsibilities:

• 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.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• UsedOracle 10gsoftware in different environments for latest features and also tested databases.
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Provide technical support for database maintenance and disaster recovery.

Environment: Oracle 10g/11g, PL/SQL, SQL, Forms 10g, Reports 10g, Oracle EnterpriseManager, SQL*Loader.

Confidential, FL

Oracle developer

Responsibilities:

• Created Oracle 10g databases for 2 large departments, from planning and testing through production.
• Managed database remodeling and interface development during migration MS Access to Oracle 10g.
• Closely monitored functionality of development and online production servers. Rendered 24-hour on-call, database support services.
• Database cloning and using export and import mechanism.
• Undo Table space Development.
• Performance tuning of SQL and PLSQL Scripts.
• Writing PL/SQL scripts, procedures and packages.
• Performed data loads using SQL*LOADER.
• Tuned SQL and PL/SQL code using Oracle Enterprise Manager Tools and Explain plan.
• Supported Oracle developers. Performed database tuning, created database reorganization procedures, scripted database alerts, and monitored scripts.

Environment:Oracle 10g, SQL*loader, SQL developer, Pl/SQL, UNIX. SQL, MS Access, .Net.

Confidential

Oracle Developer

Responsibilities:

• Analyzed the requirements and designed the program flow for CIMS.
• Participated in the full life cycle of this project including information gathering, analysis, design, development, testing and support of this module.
• Complete study of the system and prepared Logical and Physical database design.
• Implemented triggers to enhance functionality supplement validation and control navigation.
• Worked extensively as PL/SQL programmer, Developed PL/SQL Procedures that handle key business logic.
• Created front-end screens for opening new registrations.
• Designed and Created database using SQL and PL/SQL, wrote backend stored procedures, functions and triggers which allow users to analyze daily, weekly and monthly connection requests, issued connections versus projected issues and keeping track of customer details monthly.
• Created database objects like Tables, Indexes, Sequences, Constraints, and Views.
• Wrote SQL loader scripts to load the data from flat files.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.

Environment: Oracle 9i, PL/SQL, Forms 6i, Reports 6i and Windows, UNIX, HTML,