SUMMARY

• Over 7 years of experience in Application Development using Oracle SQL, PL/SQL, and Developer Forms and Reports.
• Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
• Strong Knowledge on Oracle Architecture and Database Design.
• Excellent conceptual knowledge of Oracle 10g/11g, PL/SQL and SQL.
• Experience in Database design using Normalization and E/R Diagrams.
• Rich experience in writing SQL Queries, Views, Materialized Views, PL/SQL Procedures, Functions, Packages, Triggers, Cursors, Collections, Ref Cursor, Cursor variables, System Reference Cursor, Dynamic SQL, Exceptions.
• Experience in designing business requirements and modeling using oracle designer.
• Experience in developing External Tables, Joins, Indexes and sequences.
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Extreme Use of Exception Handling methods along with Pragma Exception init in order to associate our own created exception names.
• Experience in using several built - in database packages such as DBMS JOB, DBMS OUTPUT, UTL MAIL, UTL FILE, and DBMS SQL to name a few.
• Experience in using DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
• Expertise in loading data from legacy systems using SQL*Loader.
• Good knowledge in front end development using Oracle Forms/Reports6i/9i/10g.
• Experience in Deploying Forms and Reports on the web.
• Experience in Developing Forms based on Views, Tables and Procedures in tabular and form layouts.
• Experience in developing both Web Layout and Paper Lay out Reports in various styles based on the user requirements.
• Extensively worked with third party database tools like TOAD & PL/SQL Developer.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Good in creating users and maintaining their roles and responsibilities.
• Experience in writing Technical Design Documents and Developing Unit Test Documents.
• Good knowledge in Java, HTML, XML.
• A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g.

Scripting: SQL, UNIX.

GUI: Oracle Forms 6i and Reports 6i

Languages: SQL, PLSQL, HTML, CORE JAVA, UNIX.

Tools: SQL Developer, TOAD, SQL plus.

Applications: MS Office

OS: Windows 7, Windows Vista, XP, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Conway AR

Solutions 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 oracle designer, 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.
• 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.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Used ORACLE sql DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 11g, Reports 10g,SQL, PL/SQL

Confidential, Dallas, TX

Sr. Oracle 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 oracle designer, 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 6i and Oracle Forms builder 6i 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 11g, Reports 10g,SQL, PL/SQL, TOAD, UNIX, MS Windows 7, Oracle Development Suite, Apex 3.2,4.2.

Confidential, Sacramento, CA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in Requirement Analysis, System Design, Preparing Functional Specifications, Preparing Design.
• Creates scripts for Validating extracted data from Legacy systems before loading into target system.
• Migration of scripts from oracle 9i to oracle 10g.
• Developed database objects including Tables, Clusters, Indexes, Views, Sequences, Packages, Triggers and Procedures to troubleshoot any database problems.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Used oracle forms builder 6i for developing oracle forms.
• Involved in uploading of the data from flat files into Databases and Validated the Data with PL/SQL procedures.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.
• Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
• Usage of XML db for applications with data processing.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Worked on various Back End Procedures and Functions using PL/SQL.
• Involved in Requirement gathering and creating Dataflow Diagrams, ER diagrams and database diagrams using Oracle Designer.
• Wrote shell scripts for calling functions to automate the loading and extraction process from legacy system.
• Performances tuning using Explain Plan, TKPROF and Stats Pack.
• Check the functionality of data in the front-end whether it is displaying properly or not.

Environment: Oracle 11g, SQL, PLSQL, SQL*Loader, SSIS, TOAD, Oracle Forms 10g, Reports10g, Oracle Apex 3.2.

Confidential, Virginia Beach, Virginia

Oracle PL/SQL Developer

Responsibilities:

• Involved in analysis, Design, Development phases of the project.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database.
• Involved in walkthrough sessions with business users during Analysis and Designing phase. Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Extensive use of XML.
• Writing SQL reports and scheduling these reports from UNIX scripts.
• Created SQL*Loader control files for moving the data from flat files to staging area tables.
• Worked on performance issues and used EXPLAIN PLAN for tuning the queries
• Worked with Bulk Collections for bulk load processing. Involved in code walk through and review sessions with the development team.
• Involved in the migration project to load data from mainframe systems into oracle database.
• Involved in Troubleshooting Performance issues and bugs within packages and stored procedures using dbms output and Explain Plan.
• Performance of the queries is enhanced by executing optimization techniques such as Index Creation, Table Partition and Coding Stored Procedures.
• Involved in developing data conversion programs using SQL *Loader, PL/SQL and UNIX Shell Scripts.
• Developed Master Detail reports in Reports 6i to meet the requirements of end users within the system.
• Developed Data Entry Forms, complex and template forms in Forms 6i.Creation of Pop-up Menus and maintaining Master Detail relation-ship.
• Development of client side program units and sharing them among multiple applications for processing business logic in the database.

Environment: Oracle11g, SQL, PLSQL, SQL*Loader, TOAD, UNIX Oracle Forms 10g, Reports10g.

Confidential, Grand Rapids, MI

Oracle PL/SQL Developer

Responsibilities:

• Developing SQL and PL/SQL scripts for problem solving.
• Generating reports using Report builder
• Establish onsite/offshore communication between onsite users and offshore project teams.
• Tracking and ensuring timely deliveries as per SLAs committed to the client.
• Interacting with the client and project teams to ensure issue resolution and to provide technological and business solutions to the clients.
• Interacted with the Business Analysts in understanding the business requirements for the project.
• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Involved in SDLC including designing, coding and testing.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL and TOAD.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Developed complex SQL queries, triggers for building reports using Form, form letter and mailing label report styles.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.

Environment: Oracle11g, SQL, PLSQL, SQL*Loader, TOAD, UNIX Oracle Forms 10g, Reports10g.

Confidential

Oracle Developer

Responsibilities:

• Involved in Database Design and Analysis.
• Analyzed and Created Partitions on the tables to improve the performance and enhance parallel processing.
• Design and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions, and Triggers using Oracle 9i.
• Created Control Files and used SQL* Loader to upload bulk data into database from external files.
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages
• Involved in Code Standardization and Documentation.
• Involved in Logical and Physical Database design. Identified the tables and relationship between tables.
• Used for all and bulk collect to fetch large volumes of data in PL/SQL objects.
• Involved in database Performance Tuning and monitoring.
• Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Developed complex triggers in reports before/after for validation of user input.
• Coordinated between management, users and technical teams for Requirement Gathering
• Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing