SUMMARY

• 7 years of programming experience as Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Professional experience as Oracle Developer in designing goals of ER modeling for OLTP and dimension modeling for OLAP, Data Ware Housing Applications, Oracle Forms/Reports Developer.
• 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.
• Expert in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, SQL*LOADER.
• Strong skills in Oracle including SQL, PL/SQL (Packages, Functions, Stored Procedures and Database Triggers, Views, Cursors and Ref Cursors).
• Experience in Dynamic SQL, PL/SQL Collections and Exception handling.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Expertise in Database Performance Tuning and Optimization of SQL statements using Oracle Hints, Explain plan, Tkprof, SQL*Trace and Table partitioning.
• Identified several SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS_PROFILER), explain plan, auto trace.
• Experience in implementing ETL using oracle PL/SQL, sql loader and utl_file.
• Expertise in Designing, developing & Fine-tuning data Migration, data-retrieval scripts.
• Expertise in writing Conversion and Interface programs using advanced PL/SQL concepts like Bulk Fetch, sql loader, built in packages (utl_file, dbms_utility).
• Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
• Expertise in loading data from legacy systems using SQL*Loader.
• Experience in using Database utilities such as export, import, data pump.
• Extensive Programming experience in designing reports using Reports 10g/9i/6i and designed user interfaces with Forms 10g/9i/6i.
• Developed master detail forms, customized existing forms, created number of triggers.
• Working Knowledge on UNIX, Windows and Shell Scripting.
• Supported integration and end user testing with efficient defect management process.
• Strong interpersonal skills, ability to interact with people at all levels.
• Good communication and presentation skills.

TECHNICALSKILLS:

Languages: SQL, PL/SQL, Unix Shell Scripts, JSP, C, C++, java, HTML, XML.
RDBMS: Oracle 11g/10g/9i/8i/8.0/7.0, MS-SQL Server 2000/2005, Sybase, DB2 MS Access.
Oracle Utilities: SQL*Plus, SQL*Loader, SQL developer, TOAD 9.0/9.1/9.5, Import, Export, Data Pump.
GUI Tools: OracleForms10g,9i,6i,5.0,4.5 and Reports 10g,9i,6i,3.0,2.5,ERWIN

PROFESSIONAL EXPERIENCE:

Client : Confidential, Fort Worth, TX Feb'12 - Till Date
Role : Oracle Developer

Description: Confidential, is the world\'s third largest airlines in passenger miles transported and operating revenues. American Airlines is a subsidiary of the AMR Corporation and is headquartered in Fort Worth, Texas, adjacent to its largest hub at Dallas/Fort worth International Airport. American Airlines operates an extensive international and domestic network, with scheduled flights throughout North America, the Caribbean, South America, Europe, and Asia/Pacific. All this was achieved by their website for which the content system is Interwoven Team site. The whole AA.com content is stored in team site and deployed to the various servers from Interwoven. This is one of the most important Applications for the company. This application created a more user friendly experience.

Responsibilities:

• Created custom PL/SQL procedures to read data from flat files to dump to Oracle database using SQL * Loader.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Created database objects like packages, procedures, and functions according to the client requirement.
• Used the Explain Plan for tuning the queries and also used the TKPROF for tuning the procedures by setting up the trace and generating the trace files.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
• Creation of database objects like tables, views, materialized views, procedures, packages using oracle tools like SQL *plus.
• Created database links to retrieve data from multiple servers.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Create and run batch files on regular basis.
• Created records, tables, collections for improving performance by reducing context switching.
• Created number of database triggers according to business rules using PL/SQL.
• Extensively used explain plan, TKPROF for SQL query tuning.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Developed Oracle Forms for form end user using oracle form builder 10g.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Developed Grouping report and matrix reports using oracle reports 10g report builder.
• Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements.
• Developed Unix Shell Scripts to Schedule jobs to automate tasks of loading data into Tables.
• Used version control tool VSS which helps multiple users to access and make changes to the collection of source code files.

Environment: Oracle 11g, SQL*Plus, SQL*Loader, TOAD 9.5, UNIX, Oracle Forms 10g and reports 10g, VSS.

Client : Confidential, Atlanta, GA Mar ' 11 - Jan ' 12
Role : Oracle Developer

Description: The project involved development of customer service information system for various products supplied to customers. This system maintains information about customer details, products supplied & warranty and inventory information. Other important feature of this application is that it keeps track of the details of customer complaints and the concerned action taken. Check statements/alert statements were designed using triggers, procedures and functions.

Responsibilities:

• Gathered Business Requirements from the client and translated the business detail in to technical design and specification.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Involved in logical modeling and physical modeling of application.
• Written packages, triggers, stored procedure and functions for the following modules products, catalogue, billing, shipping, rejected material, purchase orders and material receipts.
• Involved with the Performance tuning, Optimization of queries and standardization of the code.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Used pl/sql tables, pragma autonomous_transaction to avoid mutating problem in database trigger.
• Suggested and Implemented indexes for faster retrieval of data in Weekly and Monthly Metrics reports.
• Created records, tables, collections (nested tables and varrays) for improving performance by reducing context switching.
• Worked on data conversion, loaded data from different Sources into the Temp data backup environment using SQL Loader and validated the data before loading it into oracle tables.
• Optimizing PL/SQL code and SQL queries using Explain Plan, Indexes and Hints.
• 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.
• Provided database support to testing team in writing complex SQL queries.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used UTL_FILE PACKAGES for writing output messages to file.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Involved in designing of required end user forms and reports using Oracle forms 10g & Reports 10g.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Customization of existing forms and development of new forms using different form built - inn's, created LOV's and record groups.
• Worked with different triggers in forms like Block processing triggers, Interface event triggers, navigation triggers and validation triggers etc.

Environment: Oracle 11g, UNIX, SQL, PL/SQL, SQL Loader, UNIX shell script, Erwin, XML, Forms & Reports 10g, and Toad.

Client : Confidential, Baltimore, MD Oct' 09 - Mar' 11
Role : Oracle Developer

Description: Confidential, state highway is responsible for maintaining different departments related to pavements, construction, traffic etc. Pavement and Geotechnical department is primarily concerned about the pavement information, maintenance, and bid and built road projects. The project deals with developing a data warehouse, migrating the data from the access database and automates monthly data loading tasks coming from their construction sites. It should also accommodate requirements such as displaying a report for analysis of the construction data along with friction, cracking etc.

Responsibilities:

• Custom tables and new custom objects were designed as per business requirements.
• Created database triggers to validate complex integrity.
• PL/SQL Procedures, functions, cursors, triggers and packages were created using TOAD.
• Created the Object Relational Database Tables with all the necessary Constraints.
• Developed back end interfaces using PL/SQL Packages, Stored Procedures, Collections and Triggers.
• Used Control Structures like IF, CASE, FOR, and WHILE Loops for standard PL/SQL programming.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using SQL in Development and Production environment for Oracle 10g and was involved with the Performance tuning, Optimization of queries and standardization of the code.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Created SQL*Loader control files for moving the data from flat files to staging area tables.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Developed SQL and PL/ SQLscripts for migration of data between databases.
• Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL packages, complex database triggers and data migration scripts.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas
• Involved in designing of required end user forms and reports using Oracle forms 10g & Reports 10g.
• Developed Master Detail, Detail reports using tabular and Group above reports.

Environment: Oracle 10g, UNIX, SQL, PL/SQL, SQL Loader, UNIX shell script, Erwin, XML, Forms & Reports 10g, and Toad.

Client : Confidential, Louisville, KY Feb'09 - Oct'09
Role : Oracle Developer

Description: Confidential, is one of the nation\'s largest publicly traded health benefits companies, with approximately15 million medical members located primarily in 15 states and Puerto Rico. Humana offers coordinated health insurance coverage and related services to Medicare members. This system takes the input from different tables and makes the timesheet for each employee. This timesheet contains Employee id, employee name, project code, time spent in each project, extra activity like project meeting and so on. On basis of this output, one ASCII flat file will be generated that contains an extra column, which reflects the percentage time spent on each project.

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 10g, UNIX, SQL, PL/SQL, SQL Loader, UNIX shell script, Erwin, XML, Forms & Reports 10g, and Toad.

Client : Confidential, Minneapolis, MN Nov '07- Feb '09 Role : Oracle PL/SQL Developer
Online Banking/E-Brokerage

Online Banking is a comprehensive integrated application software solution programmed in JAVA and HTML, which has been developed to extend the facility of Banking right into the consumers Desk. The System consists of two modules one with security (SSL) i.e. the user has to login with a password before he can use the services of the bank and the other is without security available to all. The unsecured module consists of advertisement of banks products and services like Investment schemes, Loan schemes, Credit Card information, and Application forms.

Responsibilities:

• Performed review of the business process, involved in Requirements Analysis, System design documents, Flows, Test Plan preparations and Development of Business Process and Work Flow charts.
• Developed database objects like Tables, Views, Indexes, Synonyms and Sequences.
• Involved in Creation of tables, Join conditions, correlated sub queries, nested queries, views, sequences, synonymsfor the business application development.
• Created Materialized viewsto calculate aggregated data, such as Sum of monthly revenue.
• Developed complex ORACLE stored procedures and packages to calculate borrower\'s debt ratio, property taxes, mortgage insurance, regular/ irregular payments, etc.
• Loaded traffic data logs into staging tables using SQL loader and shell scripts
• PL/SQL coding for Exception Handling and duplicate data maintenance.
• Used Triggers in Customizing Error conditions.
• Developed / modified PL/SQL code like stored procedures, packages etc for interfaces.
• Developed UNIX Shell Scripts and PL/SQL procedures to extract and load data for month-end batch processing.
• Developed PL/SQL code for updating payment terms.
• Supported DBA team for the data migration from oracle 9i to 10g.
• Creation of Forms, Pop-up Menus and maintaining Master Detail relationship.
• Used various LOVS (List of Values) and record groups at various points in runtime.
• Involved in the design and development of User Interfaces using Forms 6i, Reports 6i and coding modules in PL/SQL.
• Development of pl/sql program units and sharing them among multiple applications for processing business logic in the database.
• Testing all forms, PL/SQL code for logic correction.

Environment: Oracle 9i (SQL, PL/SQL), SQL *loader, Toad 9.0.1, Forms/Reports 6i, UNIX.

Client : Confidential, Charlotte, NC Jan '07- Sep '07 Role : Oracle PL/SQL Developer
Online Banking/E-Brokerage

Operational Data Store (ODS), data pertaining to the services, customer and locations rendered by Time Warner Cable. Services are categorized based on different Divisions, Regions, Systems, and Channel Lineup Areas. The objective of the Project was to collect data from different customers and replicated the data and the pooled data was modified and used for Reporting.

Responsibilities:

• Actively involved in interacting with front end Java developers, and gathered User Requirement and Specifications
• Created new logical and physical database design to support multi-year conferences for the tables of employees, histories, skills, experience and payroll.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
• Normalized to 3NF to acquire least data repetition required by business.
• Migrated old data from Flat Files, Excel File and legacy System into the new database using SSIS.
• Created PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
• Filtered bad data from legacy system using various T-SQL, and implemented constraints and triggers into new system for data consistency.
• Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Created/ reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Implemented security by creating User logins, Roles and granting Users access to the database according to their role.
• Used UTL_JOB to automate the plsql procedures and packages.
• Developed Master Detail reports in Reports 6i to meet the requirements of end users within the system.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS_SQLTUNE.
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Environment: Oracle 9i, SQL Server 2000, Windows 2003, UNIX, SQL,PL/SQL, T-SQL, SQL Loader, Visio and SQL Navigator.

Client: Confidential, India Aug '05 - Nov' 07
Role : Jr. Oracle developer

Confidential, is a knowledge services company. It is Responsible for application development and providing technical leadership for application development projects. Application development projects involved direct interaction with business unit members and IT personnel. I worked as a Developer in the Development of BUDGET SYSTEM (Budget System application) for the Investment Banking group. This System Deals with the Internal Budgets of karvy.

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 existingprograms 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 8i, SQL, PL/SQL, SQL*Plus, Forms 6i, Reports 6i, Windows.

EDUCATION & CERTIFICATION

• Bachelor of Technology
• OCA - Oracle 9i Certified Associatein 9i SQL/PLSQL 1Z0-007 Certification