SUMMARY

• 7 years of programming experience as an Oracle SQL/PLSQL/ETL Developer in Analysis, Design, and Implementation of Business Applications in OLTP, Client/Server architecture and data warehouse applications.
• Strong Knowledge on oracle architecture and database design.
• Excellent working and conceptual knowledge of Oracle, PL/SQL, Developing Forms and Reports, C/C++, Java, UNIX and HTML.
• Experience in development of applications using Oracle 11g/10g/9i/8i, SQL, PLSQL, Oracle Forms 10g/9i/6i, Reports 10g/9i/6i.
• Extensive experience in Oracle relational and OLTP Processing.
• Good Knowledge in ERWIN in developing logical and physical models.
• Good Experience in developing PLSQLStored Procedures, Functions, Packages, Database Triggers using features like Cursors Ref Cursors, Analytical Functions, Collections, Exception Handling.
• Extensive experience in analysis and design of database, database modelling, ER Diagrams,normalization and de - normalization.
• Tuned SQL queries using Explain Plan and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Expertise in loading data from legacy systems using SQL*Loader.
• Have in-depth knowledge in Data analysis, Data warehousing and ETL techniques, Business Objects, UNIX Shell Scripting, SQL, PL/SQL scripts.
• Worked with various performance tuning techniques using tools provided by Oracle like SQL*TRACE, TKPROF, HINTS, DBMS PROFILER, DBMS STATS etc.
• Used DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
• Expert in SQL and Oracle PL/SQL languages.
• Used DBMS PROFILER package, which enables the collection of profiler (performance) data for performance improvement.
• Good understanding of Relational database design and developed various data models using ERWIN and Oracle Designer.
• Created various reports using oracle reports developer like matrix reports, matrix with group reports, and group above reports using Reports 9i/6i/3.0/2.5 and designed user interfaces with Forms 6i/5.0/4.5.
• Extensively worked with third party database tools like TOAD & PL/SQL Developer.
• Experience in using oracle long data types like BLOB, CLOB
• Experienced in Error Handling By Using Exceptions.
• Experience with software Development life cycle (SDLC) process performing detailed analysis, collecting requirements, documents requirements, coding and unit testing, integration and system testing.
• Good knowledge on MS-word, Excel, PowerPoint.
• Experience in Understanding complex performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Experience in writing Technical design documents and developing System and unit test documents.
• Ability to be an effective team player and work under severe time constraints.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals Confidential all levels.
• Motivated self-starter with exceptional team building, leadership, and interpersonal skills.Ability to learn new tools, concepts and environments.

TECHNICAL SKILLS

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.5and Reports 10g,9i,6i,3.0,2.5,ERWIN

PROFESSIONAL EXPERIENCE

Confidential, Camp hill, PA

PL/SQL Lead Developer

Responsibilities:

• Leading a Finance team on-site and USI teams to work on client needed data fixes and monthly activities.
• Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating SQL Packages to meet business requirements.
• Conducting Daily scrum meetings and setting a deadline for the tasks and tracking the status.
• Conversion of some Stored Procedures, Views, functions, Tables to PL/SQL.
• Generated SQL and PL/SQL scripts to install create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
• Fixed data cloning issues by creating PL/SQL blocks.
• Extensively worked with production support team for maintaining monthly and daily data runs by creating data scrubs.
• Extensively worked in Decision Support team for immediate assistance when the project is in Production.
• Worked on PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Used Explain plan, TKPROF to gather the statistics along with analyse command for performance tuning.
• Extensively worked on Explain Plans and various hints for Performance tuning.
• Createdindex function based and Normal indexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Wrote packages to fetch complex data from different tables using joins, sub queries and database links.
• Created procedures for retro enrollmentsand automated the script when needed.
• Extensively worked on JIRA bug tracker for production fixes for client needs.
• Extensively worked with finance team and infra team for monthly and daily EDI Runs and analysed data as per their need in SOA database.
• Work extensively on insurance Industry standards 834-enrolment and 820-payment.

Environment: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64 bit Production,PL/SQL Release 11.2.0.3.0 - Production, "CORE 11.2.0.3.0 Production",TNS for Linux: Version 11.2.0.3.0 - Production, NLSRTL Version 11.2.0.3.0 - Production, JIRA bug tracker, TOAD v.11.5, Jira versionv5.0.2#725-sha1:5735107.

Confidential, Minneapolis, MN

PL/SQL Developer

Responsibilities:

• Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating SQL Packages to meet business requirements.
• Conversion of some Stored Procedures, Views, functions, Tables from T-sql to PL/SQL.
• Generated SQL and PL/SQL scripts to install create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
• Extensively worked with Data stage, Production Team for migrating data from Sql Server to Oracle Exadata box.
• Extensively worked in Decision Support team for immediate assistance when the project is in Production.
• Loaded data into oracle database from flat files using SQL*Loader.
• Worked on PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Used Explain plan, TKPROF to gather the statistics along with analyze command for performance tuning.
• Extensively used Oracle reports to run week end reports.
• Extensively worked on Explain Plans and various hints for Performance tuning.

Environment: Oracle 11.2.0.3.0 - 64 bit Development, Microsoft SQL Server 2008 R2 (SP 2) - 10.50.4000.0 (X64), Oracle reports 9i/10g, Linux Version 11.2.0.3.0.

Confidential, Atlanta, GA

PL/SQL Developer

Responsibilities:

• Documented business rules, functional and technical design, test cases and user guides.
• Worked on Database design with the team.
• 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.
• Extensively used SQL*Loader for loading data from system to system to generate reports.
• Developed complex queries to retrieve the data.
• Created partitions for performance improvement of queries.
• Created and maintained logical and physical models using ERwin.
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packages, Procedures and Functions.
• Created indexes for faster access of data.
• Extensively used UTL FILE to transfer data from the source system to flat files to conversion staging area.
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Extensively worked on Forms and Reports.
• Extensively used bulk collect to fetch large volumes of data from the table.
• Created Jobs and stored procedures using Dynamic SQL for refreshing materialized views.
• Involved in debugging and error handling.
• Involved in creating Index’s, passing hints, analyzing the table for improving performance.
• Extensively used Agile Methodologies, It helps teams respond to unpredictability through incremental, iterative work.
• Monitored the database growth on daily basis. Established backup and recovery strategies.
• Extensively used test case scenario’s
• Extensively used TOAD for Comprehensive development and performance optimization.
• Detected and corrected bugs during system integration and user acceptance testing.
• Created UNIX shell scripts for FTP batch jobs, creating SQL reports and email notifications.

Environment: Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader, ERwin, TOAD, UNIX shell scripting, Oracle Forms 10g

Confidential -Lexington, KY

Oracle Developer

Responsibilities:

• Involved in analysis, Design, Development phases of the project.
• Designed ERdiagram using Visio, 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.
• 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 extensively in PL/SQLcoding and tuning.
• 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.
• Involved in developing data conversion programs using SQL *Loader, PL/SQL and UNIX shell scripts.
• Developed Master Detail reports in Reports 10g to meet the requirements of end users within the system.
• Developed data entry forms, complex and template forms in Forms 10g.Creation of Pop-up Menus and maintaining Master Detail relation-ship.
• Used various LOVS (List of Values) and record groups Confidential various points in runtime.
• Development of client side program units and sharing them among multiple applications for processing business logic in the database.

Environment: Oracle 10g, PL/SQL Developer, UNIX Shell Scripting, Toad, Forms and reports 10g, SQL*PLUS, Data Stage (ETL Tool)

Confidential -Atlanta, GA

Oracle Developer

Responsibilities:

• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Involved in moving the data from flat files to staging area tables using SQL * Loader.
• Implemented Complex business Logic as per the client requirement.
• Prepared daily reports from the invoice data received for different department like sales, marketing.
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Creation of database objects like tables, views, synonyms, materialized views, procedures, packages using oracle tools like SQL* plus.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Developed Reports to extract the monthly sales information.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Performed performance tuning using the DBMS PROFILER package, this checks the run time behaviour.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Responsible for code migration of existing application from SQL Database to Oracle Database.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL) program asynchronously.
• Wrote SQL Loader control file for flat file data load and scheduled them in UNIX to load every night in Production Environment.
• Extensively used Agile Methodologies, It helps teams respond to unpredictability through incremental, iterative work with team which helps for sprints.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users. Transformed complex business rules to Oracle PL/SQL.

Environment: Oracle 10g, PL/SQL, SQL*Plus, SQL, SQL*Loader, Reports, TOAD.

Confidential, Tampa, FL

Oracle Developer

Responsibilities:

• Analyzed the database design for better understanding the relations, associations and dependencies within the database.
• Analysis of business functionality with the client and the developers.
• Depending on the business requirements, created and modified database objects like tables, indexes, views, stored procedures, functions, packages, Triggers, synonyms, Materialized views, to make new enhancements or resolve problems.
• Created various SQL and PL/SQL scripts as required.
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions.
• Worked on storing, retrieving, updating, and transforming XML data through the SQL and PL/SQL interfaces.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Worked on complete SDLC (System Development Life Cycle) including system analysis, high-level design, detailed design, coding and testing.
• Developed various complex queries to generate various reports based on the requirements.
• Used Toad as an advanced SQL - PL/SQL editor. Built and tested scripts, PL/SQL packages, procedures, triggers, and functions. Creating and editing database tables, views, indexes, constraints, and users. Used for quick access to the Schema Browser.
• Performed Performance Tuning using DBMS PROFILER package, this checks the run time behavior and tunes the PL/SQL programs.
• Involved in setting up the DBMS JOBpackage, which allows a user to schedule a job to run Confidential a specified time.
• Involved in creating INDEXES to avoid the need for large-table, full-table scans and disk sorts, and for fast retrieval of data from database objects while generating reports.
• Created complex triggers for generating primary key values and for implementing the complex Business logic.
• Involved in Bulk loading of data from non-Oracle data sources, flat files using SQL * Loader.
• Optimized SQL and PL/SQL Query performance using Oracle utilities like ExplainPlan, SQL-Trace and TK-Prof.
• Worked with Bulk Collects to improve the performance of multi-row queries.
• Involved in performance tuning using Explain Plan, TKPROF utilities.

Environment: Oracle 10g, SQL, PL/SQL,UNIX Shell Scripts, TOAD.

Confidential - East Hanover, NJ

Oracle Developer

Responsibilities:

• Involved in analysis, Design, Development phases of the project.
• Designed ER diagram using Visio, 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.
• 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.
• 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.
• Used various LOVS (List of Values) and record groups Confidential various points in runtime.
• Development of client side program units and sharing them among multiple applications for processing business logic in the database.

Environment: Oracle 10g, PL/SQL Developer, UNIX Shell Scripting, Toad, SQL*PLUS, Data Stage (ETL Tool)

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 10g.
• Created Control Files and used SQL* Loader to upload bulk data into database from external files.
• 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 and Star Schema design. Identified Fact tables, Transaction 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 and developed user interfaces using Oracle Forms.
• 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.
• Developed UNIX Scripts to create FTP Jobs and data upload.
• Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.

Environment: Oracle 9i, Oracle Web Server (OAS), HTML, DB2, UDB, XML, JavaScript, Developer suite 10g, UNIX.