PROFESSIONAL SUMMARY:

• 7+ years of programming experience as an Oracle Developer PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System.
• Experience in Application development using Oracle SQL, PL/SQL and Oracle Developer Forms and Reports.
• Experience with Software Development Life Cycle (SDLC) process, performing detailed analysis, collecting requirement, coding and unit testing, integration and system testing.
• Experience working with SQL Server Database and SSIS (ETL) for loading data from one database to another
• Experienced working in Agile Methodology and Water Fall Model.
• Experience with Client interaction, adherence to client specifications, system enhancements, understanding business data flow, data relations and production system support.
• Proficient working experience with SQL, PL/SQL Stored Procedures, Functions, Packages, Database triggers and using the advanced features to optimize performance(Bulk binds, collections, Global Temporary Tables) and Developer 2000(Oracle Forms, Oracle Reports).
• Experienced in debugging the code and Analysis the data for various reporting and analysis purpose
• Experience in Dynamic SQL, PL/SQL Collections and Exception handling.
• Extensive experience in developing UNIX Shell scripts, SQL and PL/SQL.
• Worked with various performance tuning techniques using tools provided by Oracle like EXPLAIN PLAN, SQL Trace, Tkprof, Oracle hints, DBMS PROFILER, DBMS STATS.
• Proficient in Oracle Tools and Utilities such as TOAD, SQL*Loader, PL/SQL Developer, SQL Developer, External tables and UTL FILE.
• Experience in Database design using Normalization and E/R Diagrams.
• Expertise in Designing Tables Structures, Views, Constraints, Indexes (B Tree, Bitmap and Function Based).
• Expertise in Database Performance Tuning and Optimization of SQL statements using Oracle Hints and Table partitioning
• Expertise in using ERWIN Data Modeling Tool to design Relational Databases.
• Performed Extraction, Transformation, and loading (ETL) data from various sources into Data Warehouses.
• Expertise in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, SQL*LOADER
• Experience in development of applications using Oracle 10g/9i/8i, SQL, PLSQL

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i

Languages: SQL, PL/SQL,C#, Shell Scripting, Perl, Power Shell Scripting

Operating Systems: UNIX(AIX), Sun Solaris and Windows NT

Oracle Tools: SQL*Loader, TOAD, Forms Builder 10g/9i/6i, Reports Builder 10g/9i/6i

GUI: Developer/2000 Forms 10g/9i/6i, Reports 10g/9i/6i

Other tools: Sub Version (Microsoft), FileZilla, Putty, Crystal Reports, Tivoli

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

Oracle Plsql Developer/ SQL/SSIS

Responsibilities:

• Responsible for migrating the SQL and Windows jobs onto Tivoli Workload Scheduler.
• Developed the Power Shell Scripts to execute the store procedures and SSIS packages commands in Tivoli command line.
• Responsible for writing PL/SQL Packages, Functions, Procedures, Collections and cursors.
• Creating primary objects (tables, views and indexes) once the application developers design an application.
• Responsible for keeping all three environments PROD, UAT and DEV in sync for phase wise production releases and DB change management
• Responsible for creating the Dynamic SQL to load the Data.
• Experienced in Performance Tuning of poor SQL and PLSQL Procedures with the help of Explain Plan, DBMS PROFILER and Oracle Optimizer Hints.
• Experienced in developing Database Types and Objects for the purpose of front end applications and call them using a function.
• Developed Triggers on tables and handled Mutating errors with the help of PRAGMA AUTONOMOUS Transaction.
• Developed Views, Materialized Views based on the requirement and refreshed them periodically with the help of DBMS Mview.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Experienced in Handling Exceptions in oracle Packages and procedures using Oracle Pre defined exception handlers and DML Error Logging techniques.
• Experienced in using Oracle Exceptions like SQL Err and SQL MSG to handle exceptions with error number and error messages.
• Developed Various SQL Scripts for Automation Process and AD Hoc Report Generation Process.
• Data loaded from legacy systems (ETL Operations) using PL/SQL,SQL*Loader and SSIS
• Involved in SQL and PL/SQL performance tuning using EXPLAIN PLAN, TKPROF and DBMS PROFILER.
• Hands on experience with oracle Export and Import Utility tools to migrate data through different environments.
• Worked with Business team to gather the requirements.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Generated CSV Files with the help of UTL PACKAGES and placed them into FTP Location.
• Used PRAGMA Autonomous Transaction to avoid mutating error in database trigger

Environment: Oracle 11g, UNIX, SQL, PL/SQL, Power Shell Script, Tivoli Workload Scheduler, UNIX shell script, Toad 12.6

Confidential, Alpharetta, GA

Oracle Developer / Oracle Administrator

Responsibilities:

• Responsible for migrating the Data from Oracle database (PRODUCTION) to other database for company usage.
• Involved in SQL and PL/SQL performance tuning using EXPLAIN PLAN and DBMS PROFILER.
• 24/7 production support.
• Installing and upgrading the oracle server and application tools .
• Responsible for writing PL/SQL Packages, Functions, Procedures, Collections and cursors
• Importing and Exporting the schemas using Datapump and maintained schema objects.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Responsible for running the DML and DDL scripts in UAT and PRODCUTION.
• Wrote PL/SQL scripts for bulk data upload, data analysis and correction.
• Worked on Perl scripts to transfer files using FTP to all the UNIX servers at one time.
• Automatic email generation was used to monitor various back-end processes.
• Loading the data from large files into Oracle tables using SQL*Loader, PL/SQL
• Responsible for creating Control files for SQL*Loader.
• Creating primary objects (tables, views and indexes) once the application developers design an application.
• Enrolling the users and maintaining security.
• Controlling and monitoring users access to database.
• Monitoring and optimizing the database performance.
• Hands on experience with oracle Export and Import Utility tools to migrate data through different environments.
• Worked with developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Monitoring, resolving and testing the customer’s oracle deployments using Oracle Enterprise Manager.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Wrote SQL queries for business teams for reconciliation purpose.
• Developed shell Scripts to automate the Load process.

Environment: Oracle 11g, UNIX, SQL, PL/SQL, SQL Loader, UNIX shell script, XML, Toad 12.6, SQL Developer

Confidential, Phoenix, AZ

Oracle Developer

Responsibilities:

• Worked closely with business users to develop BRD(Business Requirement Document), FSD(functional Requirement Document), TSD(Technical Requirement Document) for successful implementation of the project
• Responsible for writing PL/SQL Packages, Functions, Procedures, Collections and cursors.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database.
• Created different schemas and maintained schema objects.
• Experienced in working with SSIS to load large data files (txt, csv) and data migration from one to another DB using SSIS Transformations and C# Script.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Hands on experience with oracle Export and Import Utility tools to migrate data through different environments.
• Involved in Data Migration from SQL Server to Oracle as well as Oracle to Oracle in different environments
• Worked with developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Created database objects like packages, procedures, and functions according to the client requirement.
• Data loaded from legacy systems (ETL Operations) using PL/SQL,SQL*Loader and SSIS
• Involved in SQL and PL/SQL performance tuning using EXPLAIN PLAN and DBMS PROFILER.
• Handed errors using PL/SQL Exception Handling for the ease of debugging and displaying error messages.
• Used UTL NOTIFY built in packages for the Purpose of the email Notifications
• Wrote SQL queries for business teams for reconciliation purpose.
• Developed shell Scripts to automate the Load process.
• Performed Unit and Integration Testing on Interface programs and all the reports developed to maintain consistency and efficiency to meet the user requirement.

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

Confidential, White Plains, NY

Oracle/ SQL Server/SSIS

Responsibilities:

• 24/7 Production support for all the database issues with integration of DBA’s during the data loading process.
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Responsible for writing PL/SQL Packages, Functions, Procedures, Collections and cursors.
• Created the Object Relational Database Tables with all the necessary Constraints and Referential Integrity using ERWIN Data modeler
• Designed and Developed Data Marts from the DWH for application users to configure their application.
• Created new database objects like tables, Indexes, Views using SQL in Development and Production environment for Oracle 11g and was involved with the Performance tuning, Optimization of queries and standardization of the code.
• 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.
• Experience in performance tuning to tune the queries using EXPLAIN PLAN and SQL Tuning Advisor
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using SQL*Loader.
• Developed crystal reports as per Business Requirements and scheduled the reports to run on SAP BO server.
• Used Built in packages like UTL FILE to read the data from flat files and load them into their respective tables
• Developed UI using Taro customized Application and configured work flows for the UI, where SQL statements were used with the help of Sub Queries and Oracle Defined Functions
• Participated in Debugging critical Production issues by working as a Team.
• Configured Mapping of the fields to match the User Interface for the front end developers.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF and AUTOTRACE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Created some oracle objects for OLAP.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

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

Confidential, Virginia Beach, VA

Oracle Developer

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.
• 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, 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 Stored Procedures to include in the existing Packages and used the same to set up scheduler Jobs
• Worked with Sales force CRM tool Backend to load data from existing extracts to Sales Force Cloud
• Developed file mover and Archive process scripts using Perl
• Configured Data Loader for CLIQ process to load data into CRM tool
• Configured Mapping of the field to Match the User Interface
• Performed Extraction, Transformation, and loading (ETL) data from various sources into Data Warehouses.
• Used exception handlers to handle exceptions like no data found, too many rows, dup val on index
• Developed SQL and PL/ SQL scripts 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.
• Responsible for raising Change requests and Change schedules for Database change management using Remedy Change Management Software
• Responsible for keeping all three environments PROD, UAT and DEV in sync for phase wise production releases and DB change management
• Developed Master Detail, Detail reports using tabular and Group above reports.

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