SUMMARY

• About 8+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Data Modeling (Logical and Physical). Development of client/server, multi tired applications using the Oracle Relational Database Management System (RDBMS), SQL and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux.
• Good experience of Performance AnalysisandSQL query tuning while designing scalable applications from scratch and maintaining existing ones, using Query Optimizer, Indexes, Execution Plans, Hints, Explain Plan
• Experience in Gathering Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation and Post Implementation surveys. Highly skilled in Design, Development, Implementation, Testing of business applications, Unit and System testing on database.
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Have an extensive knowledge on advanced PL/SQL concepts like Bulk collections, Multi Table insert, PL/SQL tables, Cursors, Nested tables, Varrays, Records, Types and Dynamic SQL for DML operations for better performance.
• Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL back end applications development Toad, SQL Plus, and PL/SQL Developer.
• Worked as a member in the design team for creating data flow diagrams and Entity relation modeling using Erwin tool.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table Partitioning.
• Experience in creating SQL loader scripts to load data from flat files into the database and also creating External Tables to manage data which is store at the OS level.
• Experience in use of SDLC methodologies, standards and Gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).
• Experience in Data Migration across various databases as well as within the same database across different systems.
• Well-versed with different stages of Software Development Life Cycle (SDLC).
• Well experienced working with Waterfall &Agile Methodologies.
• Experienced in Tuning Queries for better performance with large volume of data.
• Quick learner with ability to master new concepts and applications.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.

TECHNICAL SKILLS

Oracle Tools: SQL*LOADER, SQL Developer, SQL Plus, SQL Developer, Data ModelerOracle Forms 6i/9i/10g, Oracle Reports 6i/9i/10g, Crystal Reports, ETL,SSIS, Oracle XML/BI Publisher reports

Third Party Tools: PL/SQL Developer, TOAD, Putty, WinScp

Languages: SQL, PL/SQL,C,C++,HTML,JAVA

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

Microsoft Tools: MS-Office, Share point

Internet Tools: XML, JavaScript

Operating System: UNIX (Solaris, AIX), Windows 7/XP/VISTA.

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Sr. Oracle Developer

Responsibilities:

• Generated DDL scripts and Created and modified database objects such as tables, views, sequences, functions, synonyms, indexes, packages, stored procedures, Records and Collections using TOAD tool.
• Used Bulk Collect, PL/SQL tables, arrays and other collection for huge data manipulations and improve the performance of the system. Involved in the detailed data mapping from the source legacy systems
• Created and modified database objects such as Tables, Views, Materialized views, Indexes, Sequences and constraints, SQL queries (Sub queries and Join conditions).
• Implemented CTAS (Create Table As Select) approach to optimize an update process reducing runtime
• Provide quality operations support for production environment. Work with QA and provide support to provide timely technical resolutions for defects.
• Gathered the business requirement from clients and translated the business details into technical requirements.
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
• Enhanced a Champ module's performance in a preexisting product by 2800% faster (reducing runtime from 16 hours to 40 mins) adopting a more efficient data accessing path than the old one.
• Used Bind Variables while writing Dynamic SQL to improve performance.
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
• Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance.
• Used Bulk collect and Forallin stored procedures to improve the performance and make the application to run faster.
• Improved the performance of Materialized View Refresh from 4 hrs to 25 min using WITH clause/MATERIALIZE HINT, Indexes and Bulk Processing.
• Performed SQL and PL/SQL tuning to improve the performance with the help of SQL Trace, Explain Plan, Indexing and Hints.
• DBMS STATS is used to collect and build various Data statistics to provide information to COST based optimizer, to find chained rows, to build histograms.
• Expertise in handling System Analysis and Business Analysis related issues when the application is in earlier stages.
• Implemented Data loading process using UNIX Korn shell scripts resolved application issues in UNIX production environment. Read and interpreted UNIX logs
• Involved in client interaction, handling change requests and implementing the application on the client side.
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored Procedures/Functions/Packages
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Involved in preparing the test scenarios and performed unit tests on PL/SQL programs.

Environment: Oracle 10g/11g, PL/SQL Developer, SQL*Plus, TOAD 10.1, SQL*Loader, TFS, Windows Server 2008/Windows 7, UNIX, IBM Rational Synergy 7.1, Eclipse IDE, Bing Maps API.

Confidential, NC

Oracle Developer

Responsibilities:

• Involved in getting the User Requirements, Data Modeling & Development of the system
• Writing (Back-end) PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor or TOAD.
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
• Used Bulk collect and For all in stored procedures to improve the performance and make the application to run faster.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), and Error Handling.
• Extensively usedCursors, Ref Cursors, Dynamic SQL and Functions.
• 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.
• Extensively involved in performance tuning using Explain Plan, DBMS PROFILER and Optimized SQL queries, created Materialized views for better performance.
• Developed UNIX Shell Script as required.
• Used DBMS SQLTUNE.REPORT SQL MONITOR package to generate sql monitoring report and tune the queries.
• Developed Unix Shell Scripts to automate backend jobs, load data into the database.
• Analysis and gathering of new business requirements from the business resources.
• Extracting and Loading inventory data from various systems by using PL/SQL packages and procedures.
• Bulk upload /extract of data from databases using adhoc procedures.
• Developed PL/SQL routines for daily checks and automated them on windows scheduler.
• Created temporary tables and materialized views on Oracle Database.
• Performance tuning of SQL queries using Explain Plan to generate efficient monthly and quarterly reports.
• Developed PL/SQL Functions in-order to get hierarchy of locations.
• Extensively used tools like Oracle SQL Developer and Toad to generate PL/SQL programs.
• Created and maintainedDatabase Objects(Tables, Views, Sequences and stored procedures).
• Involved in debugging andTuning the PL/SQL code, tuning queries, optimizationfor theOracledatabase.
• Extensively used PL/SQL Collections, BULK Collect, Table Types, And Record Types, UTL FILE.
• Wrote complex stored procedures and packages.
• Created various Function Based Indexes to significantly improve performance.
• Extensively used Bulk Collections to insert and update huge amount of data into target databases.
• Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
• Used SQL* Loader to load csv files on to database’s temporary tables.
• Adhoc bulk loading Inventory items into DB using PL/SQL scripts.
• Optimized SQL to improve query performance using SQL Navigator and PL/SQL Developer.

Environment: Oracle 10g/11g, PL/SQL Developer, SQL*Plus, TOAD 10.1, SQL*Loader, SVN, Oracle Forms 10g, Oracle Reports 10g, Windows Server 2008/Windows, UNIX, JIRA, Confluence, Metasolve App.

Confidential, Peapack, NJ

Sr. Oracle PLSQL developer

Responsibilities:

• Views are created at the source side.
• Created or Modified the SQL Script(.sql file) to point to the current source.
• Extracted data from the source using the DB Export and stored in flat files.
• Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.
• Created the tables and sequences for the experimental data load capture.
• Loaded the Sales data into the created tables using SQL Loader script.
• Interacted with Business Analysts and Users in requirement gathering, Built complex queries using SQL and wrote stored procedures using PL/SQL.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Implemented Complex business Logic as per the client requirement using triggers.
• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Creation of database objects like tables, views, synonyms, materialized views, Stored procedures, packages using oracle tools like SQL* plus.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Involved in moving the data from flat files to staging area tables using SQL *Loader.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Performed performance tuning using the DBMS PROFILER package, this checks the run time behavior.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Registering various forms and reports in Oracle applications frontend.
• 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.
• Prepared daily reports from the invoice data received for different department like sales, marketing and monthly reports to extract the monthly sales information.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Wrote Packages to store the business rules and exceptions and wrote PL/SQL code to load data from staging tables to the target schema
• Modified the queries by using less functions in the Where condition and used Hints to force the query to use the index for reduction of time for Performance issues.
• High End-Client Interactions for solving User Acceptance Testing (UAT) issues.
• Automated Quality Check tasks by creating PL/SQL Anonymous blocks, procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling.
• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect&Minus set operators.
• Database security by authenticating users, using logon triggers.
• Created materialized view on remote database and automated scheduler of refreshing of materialized view on source side.
• Created indexes on tables and optimized procedure queries.
• Responsible for writing the functional and technical documents and maintaining the documentation.
• Responsible for Unit, System and UAT testing the data.
• Involved in UAT testing, Bugs fixing and the code was sent to Production.
• Loading the data from source to target using Informatica mapping.

Environment: Oracle 9i/10g/11.2, PL/SQL, SQL*Plus, PL/SQL Developer 6.0, Toad, UNIX, Informatica power center tool 8.1.1.

Confidential - Daytona Beach FL

Oracle PL/SQL Developer

Responsibilities:

• Extraction of data from different flat files into Oracle Database using SQL* Loader.
• Gather Business rules from the end users that are to be incorporated into the system.
• Worked on PL/SQL Tables, Records and Collections.
• Wrote PL\SQL Procedures, Functions, and Triggers for Insert, Update and Delete transactions.
• Analyzed Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance.
• Changed existing logic within the packages for optimum performance using Oracle Hints, Explain Plans and Trace Sessions.
• Developed multiple layouts in a single template to get the desired output using Oracle XML/BI Publisher administrator.
• Tested the original and optimized codes thoroughly for failures before exporting to other environments.
• Worked on Materialized view by creating an estimated cost and solved costing issues in Production release.
• Developed interface to load Invoice data into Account Payables. Developed validations programs to load the data into AP INVOICE INTERFACE, AP INVOICE LINES INTERFACE.
• Data was loaded into temporary table from flat file and then into AP INVOICE INTERFACE and AP INVOICE LINES INTERFACE tables.
• Worked with the Business users in Vendor reconciliation process between Great Plains system and Oracle System.
• Wrote SQL scripts to insert the vendor data into PO VENDOS ALL, PO VENDOR SITES ALL, PO VENDOR CONTACTS.
• Wrote SQL scripts to create temporary tables and developed SQL*LoaderControl files to load the data into the temporary tables.
• Data was loaded into temporary table from a flat file and then into RA INTERFACE SALESCREDITS ALL and RA INTERFACE LINES ALL tables.
• Worked with Bulk Collects to improve the performance of multi-row queries.
• Handled errors using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Created Shell scripts for regular back up instance start and shut down.
• Created Logical and Physical Models using ERWIN.
• Worked on profiling and tracing PL/SQL program to analyze the execution of program in order to enhance performance of program.
• Worked on Database Links to import/export data.
• Worked on DBMS SCHEDULER to automate jobs.
• Implemented triggers based on the business rules.
• Optimizing and fine tuning the Crystal Reports for efficiency.
• Used ADO, ODBC for accessing and retrieving the data from database to Crystal Reports.
• Worked on minimizing CPU overhead by Tuning SQL Statements, Tuning Subprogram Invocation and Tuning computation-intensive PL/SQL Code.
• Creating and Maintaining of different levels of users with different levels of securities by creating User Roles and Privileges.
• Support for the development, test and the production databases.

ENVIRONMENT: Oracle 10g, SQL Developer, UNIX Shell scripting, ETL, Oracle Enterprise Manager, HP-UNIX,ERWIN 3.5, Toad 8.0, Crystal reports 9.0, VSS, .NET, MS SQL server 2005.

Confidential - Dublin, Ohio

Oracle PL/SQL Developer

Responsibilities:

• Interacted with Business Analysts and Users in requirement gathering.
• Created Technical Design for the Back End PL/SQL based on Business Requirement Documents and the Functional System Design.
• Creation of database objects like tables, views, synonyms, materialized views, stored procedures, packages using oracle tools like PL/SQL Developer.
• 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 into updating procedures, functions, triggers, and packages based on the change request.
• Built Complex queries using SQL and wrote stored procedures using PL/SQL.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Involved in moving the data from flat files to staging area tables using SQL *Loader.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Get all Design and Coding Reviewed and Approved by the concerned authorities.
• Provide support to Front End and fix defects in various stages of Testing i.eIST, ET and UAT.
• Perform Technical Validation on production Release day and send a Success/ failure report accordingly.
• Building the reports using XML Packages.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Involved in developing SQL queries for developing ORACLE 10G Reports.
• Multi Task 4,5 TARS(Projects) at a time in a release.
• 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.
• Involved in the Migration of Oracle Forms & Oracle Reports.
• Used Crontab to schedule the shellscripts to run at particular time on a particular day.
• Used Oracle XML Bursting process in order to send the output to multiple email id’s.
• Worked on Form Personalization for disabling few fields, Making few field’s Non updatable .
• Worked closely with users in gathering and analyzing requirements and providing solutions that meet their requirements.
• Worked in Oracle Applications Environment for registering Forms/ Reports in the front end.
• Worked on Oracle XML/BI Publisher Reports to show the Data from Custom tables as requested by the business.

Environment: Oracle 11g, PL/SQL, SQL Developer, TOAD, Oracle Forms 6i/9i, Oracle Reports 6i/9i, XML Reports, Unix Sun Solaris 2.6, XML, Oracle Applications R11i/R12,WINDOWS NT Workstation.

Confidential 

Oracle 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.
• Involved in logical modeling and physical modeling of application.
• 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.
• Developed data model, SQL Queries, SQL Query tuning process and Star 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 the 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 UTI FILE PACKAGES for writing DBMS 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 the Master Detail, Detail reports using tabular and Group above reports.
• Customization of existing forms and development of new forms using different form built - in’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.

Environment: Oracle 10g, UNIX, SQL, PL/SQL, SQL Loader,Unix shellscript, ERWin, XML, Forms & Reports 9i, PL/SQL Developer and Toad.