SUMMARY:

• Around 8 years of software development life cycle experience in Software Design, Development and Implementation of Oracle, SQL, PL/SQL applications.
• Extensive experience in writing SQL, Stored procedures, Functions, Packages, Database triggers, Shell - Scripts and SQL Loader scripts.
• Strong Knowledge on Oracle Architecture and Database Design.
• Excellent conceptual knowledge of Oracle10g/11g, PL/SQL and SQL.
• Expertise in SQL and PL/SQL, Oracle Forms and Reports, and strong Knowledge on oracle architecture and database design.
• Proficient in Performance tuning on Oracle PL/SQL batch Jobs, SQL queries using EXPLAIN PLAN, TKprof, AUTO TRASE and DBMS Profiler/Debug.
• Good understanding of oracle Data Dictionary and Normalization Techniques.
• Extensive experience in Application development using Oracle Forms and Reports.
• Expertise in distributed query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle.
• Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS,SSIS,SSAS) using MSSQL Server 2000/2005/2008
• Worked on the physical transformation of the data model which involved creating the database objects like Tables, Indexes, Stored Procedures, Functions, DB Links, Packages and Triggers, Materialized Views.
• Worked extensively on PARTITIONS to enhance performance and archiving of a DW.
• Designed database schema's using Entity relationship modeling with ER diagrams & database normalization principles.
• Work Experience in writing shell script in UNIX & Perl environment.
• Expertise in performing Data export, Import and various operations using TOAD.
• Very strong in SQL Query Tuning, Database Triggers, Stored Procedures, reducing time for night batch jobs by reviewing PLSQL code, modifying database parameters.
• Good knowledge on Oracle Data dictionary, Oracle Supplied DBMS, UTL and HTP packages.
• Experience in jobs scheduling using Oracle DBMS JOB, DBMS SCHEDULER and various TP Tools.
• Extensively worked in Client-Server application development using Oracle Forms 9i/6i, Reports SQL, PL/SQL, Oracle 9iDS, Oracle Import and Export Utilities.
• Exposure in Personal Insurance, finance and enterprise resource planning domain.
• Skilled professional with expertise in development, customization, testing Oracle9i projects with Payroll system in finances.
• Expertise in full Software development life cycle (SDLC) from the analysis, design, coding and implementation with timely deliverable.
• Experience in application development using various advanced features of Oracle like Collections, Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Global Temporary Tables, Object types and Records.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing.
• Experienced in data analysis, data modeling, development, testing and documentation of projects.
• Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP Data warehouse Environment.
• Experience in implementing ETL using Informatica Power Center 8.6
• Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.
• Experience with DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
• Improve the performance of the slow SQL queries by implementing proper Index, using FORALL and BULK COLLECT.
• Experience in Installing Software's and Configuring Databases.
• Experience in UNIX Shell and Perl Scripting.
• Strong Trouble-shooting, Problem solving, Analytical & Design Skills.
• Experience in Back ends Testing of the applications by executing complex SQL commands.

TECHNICAL SKILLS:

Operating Systems: Windows 98/NT/2000/XP/2003, MS-DOS, UNIX

Languages: SQL, PL/SQL, UNIX Shell Script, Perl Script, XML, Delphi, C, C++, HTML

Database: Oracle 9i/10g/11g, MS Access, ODS

GUI: Oracle Forms 6i/9i/10g, Oracle Reports 6i/9i/10g, Crystal Report, Cognos, XML Publisher, PowerBuilder, OBIEE 10g (BI Publisher)

Scheduling Tool: Autosys, Control-M

Utilities: Toad, Oracle MQ, Oracle AQ, SQL*Plus, SQL*Loader, Tkprof, PUTTY, MS Office, WinSCP, SQL Developer, ODI, EditPlus, UltraCompare, HP Quality Center, ClearCase, Erwin, Visio, DVO 9.6

ETL: Oracle Warehouse Builder with Oracle Data Integrator ODI, DataStage, Informatica IDQ, Informatica Power Center

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Oracle PL/SQL Developer

Responsibilities:

• Gathering the requirements from Business Analysts and converting them to Functional specifications.
• Preparing Functional and Technical Design documents.
• Involved in performing DBA activities like creating users, granting and revoking privileges on database objects.
• Created test cases for Unit testing, Integration testing and User acceptance testing.
• Used cursors, records, user defined objects, dynamic SQL, bulk loads, and exception handlers.
• Used PL/SQL Tables and Records in payment generation process. Written Test Plans and Involved in unit testing.
• Involved in writing stored procedures, Functions and packages to develop dataset objects using ADO.NET
• Involved in upgrading Oracle reports and BI publisher reports for financials.
• Performance tuning of existing SQL and PL SQL codes to improve the response time.
• Created views, materialized views, sequences as per the requirement.
• Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate data to the tables.
• Handling the trouble tickets which come into an application from the users based on the priority level.
• Developed Unit test cases to validate and test the end result.
• Performed DBA activities for faster retrieval of data using various optimizer hints such as Parallel, Ordered, Append and Use Hash and used customized vscripts to monitor the database processes and performance.
• Process payments automatically and manually in case of exceptions.
• Involved in assigning assets to projects for internal and external billing of labour and expenses.
• Developed validation procedures and error reporting on the data in the intermediate tables.
• Extensively worked in performance improvement using Indexes, Parallel hints, and DBMS stats packages. Used massive parallel to run millions of data in production environment.
• Constructed complex SQL queries with sub-queries, inline views as per the functional needs. Create SQL scripts to perform unit and component testing.
• Responsible for writing the night batch process using Shell scripts and run them using Cron Job.
• Wrote packages for unit testing using PL/SQL and debugged using DBMS debug packages and other PL/SQL developer tools.
• Used Exception Handling extensively to debug and display the error messages in the application.
• Actively participated in Unit testing, Integration testing and Regression testing.
• Created report, and Oracle Alerts messages to users who are responsible for the Items Forecasting.
• Co-ordinated between Development, Testing and Production teams and attending bridge calls and technical discussions regarding future developments and releases.

Environment: Oracle 10g, SQL Developer, MCC Oracle, SQL *Plus, TOAD, and Export/Import utility, Informatica, Oracle Forms 11g/10g. Oracle Reports Builder 11g/10g.

Confidential, Seattle, WA

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Used LINQ to SQL ( object relational mapping) for integrating data validation and business logic rules into data model.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Worked on claims processing reports on investigation and payment.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• 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.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• 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 and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Fine-tuned long running claims reports. Developed Claims reports that would produce Excel outputs for users.
• Generated claims report weekly, monthly and yearly.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• 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.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

Confidential, Bloomington, IL

Oracle PL/SQL Developer

Responsibilities:

• Interacting with the clients to understand the requirements and Designing module wise Oracle 11g database structure and its implementation on the client server.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created the test scripts and complex queries to test the application and to quality assurance of the data.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
• Involved in developing and scheduling using cron jobs to load the data into the database and export/import mechanism for data migration for bulk upload
• Involved in writing the database triggers to furnish the audit details
• Used various LOVS (List of Values) and record groups at various points in runtime.
• Created Various Form Level, Block Level and Field Level Triggers.
• Developed Master Detail reports using tabular and Group above reports.
• Troubleshooted performance issues and bugs within packages, forms, and reports using DBMS output, Forms debugger, explain plan.
• Analyzed, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Developed Unix Shell Scripts to automate backend jobs, load data into the database.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package
• Partitioned the fact tables and materialized views to enhance the performance.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Provided Tier3 Application support with 24/7 production support.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX Shell Scripting, Windows XP, Oracle Form Builder 10g and Report Builder 10g.

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Worked on Creating and managing table, Indexes, table spaces, triggers, db links.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Produced SQL reports, data extraction and data loading scripts for various schemas.
• Involved in code reviews and Production Support and Carried the pager on roaster basis.
• Created and modified SQL*Plus, PLSQL and SQL*Loader scripts for data conversions.
• Analyzed the existing method for data repository refresh and then developed a new package with tuned queries to improve the performance and reduce the time taken for the refresh.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Developed complex reports based on an Oracle views using running totals, sub totals, grand totals and conditional formatting.
• Involved in uploading and porting of reports into the web based Real-time Query servers.
• Worked with Autosys for Job Scheduling and job automation.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions for Cost based and Rule based Optimization.
• As a team member responsible to work as a data modeler.
• Improved and administered the existing Oracle databases and applications.
• Responsible for installation, upgrade, account management, backup/recovery of Oracle databases.
• Coded stored Procedures, Functions, Packages and Database Triggers to support the Forms and Reports functionality.
• Created Views to fulfill the requirement of Reports and Forms.
• Created stored procedures and functions in PL/SQL to increase the performance of Forms on web server.
• Used the Dynamic SQL to create the text file for reading and writing purpose in PL/SQL.
• Created temporary table for report writing using Dynamic SQL.

Environment: Oracle 8i/ 9i, SQL*Plus, PL/SQL, SQL*Loader, Toad, Autosys, HTML, Windows, UNIX, PUTTY.

Confidential

Oracle Developer/Analyst

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Used Discoverer 2000 to provide end users easy access to data and help in data analysis.
• Created some Custom reports and Forms for the end users to check the details and errors.

Environment: Oracle 10g, SQL*Plus, PL/SQL, Erwin, Oracle Designer 2000, Windows 2000 Toad.