SUMMARY

• Around 10+ years of experience in analysis, design, development, and testing of business applications in OLTP, web based Client/Server architectures.
• Proficient in analyzing the end user requirements and converting them into efficient Technical Solutions.
• Strong Knowledge on oracle architecture and database design.
• Excellent conceptual knowledge of Oracle 9i/10g/11g, PL/SQL.
• Experience in Database design using Normalization and E/R Diagrams.
• Extensive experience in database programming using SQL and PL/SQL following industry best practices.
• Expertise in creating stored procedures, functions, packages, collections and bulk collections using PL/SQL.
• Strong knowledge in front end development using oracle forms/reports 9i/10g/11g.
• Experience in developing forms based on views, tables and procedures in tabular and form layouts.
• Experience in creating master detail forms and adding alerts.
• Experience in developing both web layout and paper lay out reports in various styles based on the user requirements.
• Experience in deploying forms and reports on the web.
• Expertise in loading data from legacy systems using SQL*Loader.
• Worked with various performance tuning techniques using tools provided by Oracle like EXPLAIN PLAN, SQL*TRACE, TKPROF, HINTS, DBMS PROFILER, DBMS STATS etc.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL*Loader.
• Experience in working with version control tools such as Tortoise SVN and PVCS.
• Strong knowledge on OLAP components development.
• Experience in writing Technical design and unit test documents.
• Supported integration and end user testing with efficient defect management process.
• Strong Analytical, Problem solving and communication skills.
• Strong communication and inter - personal skills at the technical and user level.
• Experienced in all SDLC stages with CMMI level procedures and processes.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i, SQL Server, MS Access.

Scripting: SQL, PL/SQL, UNIX Shell Scripting.

Languages: C, C++, XML, HTML.

Operating Systems: Windows, UNIX, LINUX.

GUI: Oracle Forms 11g/10g/9i/6i and Reports 11g/10g/9i/6i.

Tools: and Utilities: SQL Developer, Toad, Tortoise SVN, PVCS, SQL*PLUS, SQL*LOADER.

Data Modeling: Erwin, Visio.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Application Developer

Responsibilities:

• Developed PL/SQL packages and stored procedures to support Forms and perform standalone functions.
• Involved in the Analysis, Design, Coding and Testing of the application.
• Involved in developing custom Forms and Reports as per client requirements and making them web enabled using Oracle Forms builder 11g and Oracle Reports builder 11g respectively.
• Design and development of conversions, interfaces, customizations, Custom Forms and Reports.
• Created indexes for faster access of data.
• Developed stored procedures, functions, packages, collections and bulk collections using PL/SQL.
• Involved in creating Design and User Interface documents to help both the Testing and Business teams better understand the enhancements made as part of the projects.
• Experience working with version control tools such as Tortoise SVN and PVCS.

ENVIRONMENT: Oracle 11g, Oracle Forms 11g, Oracle reports 11g, PL/SQL, TOAD, SQL Developer, Tortoise SVN, PVCS, Windows 10.

Confidential, Omaha, NE

Sr. Developer

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in developing custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Extensively worked on production issues with effective defect management.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Involved in PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN and DBMS PROFILER.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed UNIX Shell scripts to automate table creation, execute procedures and scheduling batch jobs.
• Worked with 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.
• Design and development of conversions, interfaces, customizations, Custom Forms, Reports and all Technical design and solutions.
• Developed and modified Pro*c scripts along with scheduling jobs on Autosys

ENVIRONMENT: Oracle 11g, Oracle 10g, Oracle 9i, Oracle Forms 10g, Oracle reports 10g, PL/SQL, TOAD, SQL Developer, SQL*loader, SQL*Plus, AIX, Windows XP.

Confidential, Memphis, TN

Oracle Developer

Responsibilities:

• Designed and developed complex reports to meet end user requirements.
• Developed complex SQL Stored Procedures, Functions, and Packages for building reports.
• Created indexes for faster access of data.
• Documented business rules for writing functional and technical design documentation, test cases and user guides.
• Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Worked with developers to repair and enhance current base of PL/SQL packages to fix production issues and improve processing time.
• Used PL/SQL packages like DBMS JOB, and DBMS OUTPUT.
• Prepared daily reports from the invoice data received for different department like sales, marketing.
• Creating and editing database tables, views, constraints, indexes on the tables for faster retrieval of the data to enhance database performance.
• Automated routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• As a team member interact with Business Analysts, Data architect and client representatives for requirements gathering, research and solving client specific data issues.

ENVIRONMENT: Oracle 9i, PL/SQL, TOAD, SQL Developer, SQL*loader, SQL*Plus, Linux, Windows XP.

Confidential, Pittsburg, PA

Oracle Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• 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 Queries, 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.
• 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 10g and Oracle Forms builder 10g respectively.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Worked with 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.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

ENVIRONMENT: Oracle 10g, Oracle Forms 10g, reports 10g, PL/SQL, TOAD, SQL Developer, Shell scripting (Bourne and Korn), SQL*loader, Stored Procedures/Triggers, XML, Windows NT.

Confidential, Austin, TX

Oracle Developer

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.
• Created and Modified PL/SQL Triggers, Procedures, Functions and packages.
• Developed ER Diagrams, Data flow diagrams based on the requirement.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Used SQL*Loader to load bulk data from various flat files and legacy systems.
• Developed SQL and PL/ SQL scripts for transfer of data between databases.
• Designed and developed complex reports to meet end user requirements and deployed using Oracle Report 10g.
• Developed complex SQL queries, triggers for building reports using Form, form letter and mailing label report styles.
• Developed complex triggers in reports before/after for validation of user input.
• Designed and developed user interfaces using Oracle Forms 10g.
• Performed unit testing and supported integration testing and end user testing.
• Extensively worked on production issues with effective defect management.
• Involved in logical and physical database design, Identified Fact Tables, Transaction Tables.
• Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, DBMS PROFILERetc.
• Design and development of conversions, interfaces, customizations, Custom Forms, Reports and all Technical design and solutions.
• Implemented Application Infrastructure policies, procedures and standards, and ensured their continual compliance.

ENVIRONMENT: Oracle 10g, SQL, PLSQL, SQL*Loader, KORN Shell script, TOAD, Oracle Forms 10g, Reports10g.

Confidential, Minneapolis, MN

Oracle Developer

Responsibilities:

• Involved in design of database and created database objects.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Involved in developing packages for implementing business logic through procedures and functions.
• Developed and modified procedures, Function, triggers, forms, reports and deployed the changes in the system.
• Developed user interfaces using Oracle Forms.
• Extensively involved in application tuning, SQL tuning, memory tuning and I/O tuning using Explain Plan and SQL trace facilities.
• Performance of the queries is enhanced by executing optimization techniques such as index creation, table partition and coding stored procedures.
• Performed load and integration tests on all programs created and applied version control procedures to ensure that programs are properly implemented in production.
• Responsible for creation of new users and setting up privileges and policies for protection of data.

ENVIRONMENT: Oracle 9i, SQL, PL/SQL, SQL*Loader, KORN Shell script, Oracle Forms 9i, Reports9i.

Confidential, Louisville, KY

Oracle developer

Responsibilities:

• Worked on Database design with the team.
• Measured the performance of the shell scripts by getting the expected results.
• Worked on Logical, Physical and conceptual design of Database Data Modeling, and Data Architecture with the use of Erwin as a modeling tool.
• Writing PL/SQL code using the technical and functional specifications.
• Generated SQL and PL/SQL scripts to install create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
• Involved in writing Packages, Functions, Stored Procedures and Database Triggers.
• Created stored procedures, functions, packages, data base triggers and cursors based on requirement.
• Developed complex queries to retrieve the data.
• Created indexes for faster access of data.
• Documented business rules for writing triggers and constraints, functional and technical design, test cases and user guides.
• Involved in testing all forms, PL/SQL code for logic correction. Performed Unit testing on queries and reports.
• Using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Involved in debugging and error handling.
• Involved in creating Index’s, passing hints, analyzing the table.
• Built custom forms using Oracle Forms Builder to fulfill the business requirements of the client.
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.
• Worked on Database tuning and performance monitoring.
• Wrote UNIX Shell scripts.

Environment: Oracle 9i, forms 9i and reports 9i, UNIX shell programming, TOAD, SQL*Plus, Linux.

Confidential

PL/SQL Developer

Responsibilities:

• Performed review of the business process, involved in Requirements Analysis, System Design Documents, Flows, Test Plan preparations and Development of Business Process / Work Flow charts.
• Developed PL/SQL procedures, customizing existing programs according to the needs of the client testing.
• Wrote PL/SQL packages consisting of procedures and functions.
• Created Materialized Views, Triggers, Sequences, collections.
• Involved in development and testing of oracle back-end objects like database triggers, stored procedures, Sequences and Synonyms.
• Involved in design, development and Modification of PL/SQL stored procedures,
• Functions, packages and triggers to implement business rules into the application.
• Extensively used cursors for fetching the rows.
• Loading data through SQL Loader and UTL FILE.
• Involved in tuning the SQL queries create database objects and optimally set storage parameters for tables and indexes.
• Designed reports using Reports as per user requirements. Created Reference and Master/Detail tables to store information. Tested forms and reports using test data.
• Wrote Shell scripts to insert data to database tables. Wrote PL/SQL code to retrieve data for master and detail blocks.
• Customized forms and reports as per user requirements using Oracle Developer Forms & Reports.
• Interacted with clients in remote locations to verify customer requirements.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, Forms 6i, Reports 6i, Windows.