SUMMARY

• 8+ years of experience as an Oracle PL/SQL Developer implementation of various Business Applications using the programming experience in Oracle 11g/10g/9i, SQL, PL/SQL, Unix and Performance tuning.
• Experience in project planning, scheduling, system design, white board sessions, impact analysis, code development, code review, system test plan, system testing, solution demonstration to stakeholders and postproduction support
• Strong knowledge on oracle architecture and database design concepts like Normalization and ER Diagrams
• Extensively written PL/SQL code, packages, Stored Procedures, Functions, Triggers and Views to implement business logic and to extract, manipulate and migrate complex data sets in Oracle Databases.
• Experienced in Performance Tuning and Query Optimization using Baselines, Trace utility & TKProf, Hints, Indexes, and Explain Plan.
• Strong Knowledge on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, V - arrays, Object types, standard API’s, Records and Types.
• Highly involved in all phases of Software Development Life Cycle (SDLC) from Analysis, Design, Development, Test, Implementation, Documentation and Production Support.
• Strong experience in writing Perl scripts covering data feed handling, implementing business logic, communicating with web-services through WSDL.
• Expertise skills in using the tools TOAD 9.0.1, SQL * Loader, Oracle SQL Developer
• Good Exposure to UNIX shell scripting.
• Good exposure to Oracle Forms and Reports
• Hands on experience in Data migration (ETL) across different databases via SQL scripts.
• Hands on experience as support engineer in a production support environment.
• Possess strong communication and problem solving skills developed through a variety of projects over a period of time.
• Flexible, highly adaptable, team player, pro-active and eager to learn and perform new tasks.

TECHNICAL SKILLS

Operating Systems: UNIX, Linux, Windows, MAC

Database: Oracle 11g/10g/9i, MS SQL Server and MS Access

Tools: Oracle APEX, SQL developer, TOAD, SQL * Loader, SQL*Plus, PL/SQL Developer, Oracle Forms and Reports 10g/9i/6i, Erwin r7.1/7.2, Informatica 8.5.

ERP: Oracle Applications R12.

Languages: SQL, PL/SQL, JAVA, HTML, XML, PERL 5.8 and shell scripting

Tracker Apps: BMC Remedy, BugZilla

Version control: SVN, PVCS

Office Tools: MS Office and Generic text editors.

PROFESSIONAL EXPERIENCE

Confidential - Englewood, CO

Senior Oracle PL/SQL Developer

Responsibilities:

• Involved in data base design and development by creating Oracle PL/SQL Functions, Stored Procedures, Packages, Triggers, Records and Collections.
• Development of SQL scripts to handle new processes.
• Involved in process like data transformation, transaction and loading data from different sources like Oracle External tables, SQL server and Flat files.
• Developed Perl scripts for frequent reports automation for the users.
• Development of UNIX shell script (wrapper scripts) for the AUTOSYS batch jobs.
• Part of a project team to deliver OLAP solutions for better performance.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
• Involved in the Development of PL/SQL procedures used to extracted data from a data warehouse for policy reporting.
• Performed Error Handling and Created Tables, Records, Objects, Collections, Views, Materialized views and Global temporary tables (Nested Tables and V arrays)
• Used Cursors, Ref Cursors, Dynamic SQL and Functions.
• Used Explain plan for Performance Tuning
• Involved in the Application framework design with respect to convenience of the end user
• Involved in Performance tuning, Application diagnosis and generating reports for clients
• Used HINTS to enhance the performance of the SQL
• Participated in the development of process using External tables, SQL* LOADER, PL/SQL Package.
• Developed business objects and SQL*plus reports as per client's requirements
• Developed SQL scripts for Referential Integrity check
• Participated in designing of CUSTOM forms and reports in order to meet the Business requirements.
• Participated in Technical Documentation, development of Test plan, Integration Test and Unit test.
• Tracked the development progress using Team Tracker
• Ability to identify the changes in packages and procedures using Toad Comparison Utility
• Identification and comparison between forms using Forms Compare tool

Environment: Oracle 11g (SQL, PL/SQL), Forms 10g, Reports 10g, SQL *Loader, Toad, Perl Scripting, UNIX Scripts, HTML.

Confidential - Englewood, CO

Senior Oracle Pl/SQL Developer

Responsibilities:

• Involved in all the stages of SDLC (Software Development Lifecycle) such as analysis, design, development, testing and deployment of timesheet application.
• Involved in gathering business requirements, program specification preparation, design document necessary for the development of the Timesheet Application.
• Development of PL/SQL packages, functions, procedures applying the business logic for updating database with employee’s timesheet and to calculate payroll
• Development of scripts to create tables, views, indexes and sequence.
• Creation of custom triggers for automatically data population across different tables and to enable data restriction into timesheet tables.
• Deal with the creation of custom tables to import and insert the employee data into the timesheet database.
• Loaded data into the staging tables from the flat files by developing SQL*Loader scripts.
• Involved in the usage of DTS package data Migration from the previous timesheet database in SQL Server database to Oracle 10g.
• Used Hints and Query tuning to enhance the performance of the SQL queries.
• Development of Shell Scripts for automated execution of PL/SQL subprograms and the storage of data into historical folders.
• Involved in the process of transferring the files into various different servers using FTP based on the needs of the business users.
• Involved in the preparation of user document, functional document, process flow diagram and flow charts.
• Development of test scripts and complex queries to test the timesheet application and quality assurance of the data.
• Involved in implementation, maintenance and preparation of test plans for Unit testing and System integration testing.

Environment: Oracle 9i/10g, SQL Server, PL/SQL, SQL*Plus, SQL*Loader, TOAD, Visual SourceSafe, FTP, DTS package, MS- Office, UNIX, Shell Scripts, MS Office, MS Visio.

Confidential - San Francisco, CA

Oracle PL/SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for gathering requirements, business analysis, testing, metrics and project coordination.
• Involved in handling data requests from multiple clients, file generation based on daily requirement and complex SQL scripts for data retrieval.
• File transfer to client side using UNIX.
• Engaged in the Development of Stored Procedures, Packages, Functions and SQL Scripts using PL/SQL to implement business rules
• Performing DML operations for daily activities.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Extensively worked in data transaction, transformation, loading data into database tables using PL/SQL and SQL*loader from legacy systems.
• Used Toad for creating PL/SQL trigger, sequence and stored procedure.
• Involved writing DBMS OUTPUT messages to file using FILE PACKAGES.
• Developed UNIX Shell scripts to automate table creation, execute procedures
• Involved in designing ER diagram using oracle designer, to set the logical and physical relationships of database.
• Development of data model, test scripts, test cases, SQL Coding, SQL Query tuning process and Schemas.
• Involved in the development of SQL QA scripts for enhanced Unit Testing, Load Testing and System Testing

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Java

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.
• 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.
• Involved in database Performance Tuning and monitoring.
• 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

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Java.

Confidential

Oracle Developer

Responsibilities:

• Involved in the Development of user interface windows for sales order processing, invoicing, customer billing & inventory.
• Implementation of Validation rules by writing procedures during data input.
• Participated in Custom report generation using Reports 2.5.
• Used SQL and PL/SQL to create stored procedures, Packages, Functions and triggers.
• Involved in analysis of user/business requirements and mapping into technical specifications.
• Involved in data analysis and generation of weekly, biweekly, monthly reports by using reports 2.5.
• Involved in the design and implementation of a new security (based on the standard concept of roles and privileges) for handling reports in the oracle database to prevent confidential data from being displayed to all users.
• Used functions and views to store all the security roles and privileges are stored in the database tables and logic implementation.
• Promoted the security feature to the existing reports with a very minor code change in the actual reports.

Environment: Oracle 8i, PL/SQL, SQL * PLUS, Forms4.5 and Reports 2.5