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 teh 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 teh advanced features to optimize performance(Bulk binds, collections, Global Temporary Tables) and Developer 2000(Oracle Forms, Oracle Reports).
• Experienced in debugging teh code and Analysis teh 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 teh SQL and Windows jobs onto Tivoli Workload Scheduler.
• Developed teh Power Shell Scripts to execute teh 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 teh 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 teh Dynamic SQL to load teh Data.
• Experienced in Performance Tuning of poor SQL and PLSQL Procedures with teh help of Explain Plan, DBMS PROFILER and Oracle Optimizer Hints.
• Experienced in developing Database Types and Objects for teh purpose of front end applications and call them using a function.
• Developed Triggers on tables and handled Mutating errors with teh help of PRAGMA AUTONOMOUS Transaction.
• Developed Views, Materialized Views based on teh requirement and refreshed them periodically with teh help of DBMS Mview.
• Developed PL/SQL Procedures and database triggers for teh 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 teh 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 teh 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 teh 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 teh oracle server and application tools .
• Responsible for writing PL/SQL Packages, Functions, Procedures, Collections and cursors
• Importing and Exporting teh schemas using Datapump and maintained schema objects.
• Developed PL/SQL Procedures and database triggers for teh validation of input data and to implement business rules.
• Responsible for running teh 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 teh UNIX servers at one time.
• Automatic email generation was used to monitor various back-end processes.
• Loading teh 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 teh application developers design an application.
• Enrolling teh users and maintaining security.
• Controlling and monitoring users access to database.
• Monitoring and optimizing teh 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 teh 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 teh 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 teh project
• Responsible for writing PL/SQL Packages, Functions, Procedures, Collections and cursors.
• Designed ER diagram using Erwin, to set teh 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 teh 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 teh 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 teh ease of debugging and displaying error messages.
• Used UTL NOTIFY built in packages for teh Purpose of teh email Notifications
• Wrote SQL queries for business teams for reconciliation purpose.
• Developed shell Scripts to automate teh Load process.
• Performed Unit and Integration Testing on Interface programs and all teh reports developed to maintain consistency and efficiency to meet teh 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 teh database issues with integration of DBA’s during teh data loading process.
• Worked with teh Business analysts and teh DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Responsible for writing PL/SQL Packages, Functions, Procedures, Collections and cursors.
• Created teh Object Relational Database Tables with all teh necessary Constraints and Referential Integrity using ERWIN Data modeler
• Designed and Developed Data Marts from teh 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 teh Performance tuning, Optimization of queries and standardization of teh 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 teh 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 teh schemas and databases.
• Data loaded from legacy systems (ETL Operations) using SQL*Loader.
• Developed crystal reports as per Business Requirements and scheduled teh reports to run on SAP BO server.
• Used Built in packages like UTL FILE to read teh data from flat files and load them into their respective tables
• Developed UI using Taro customized Application and configured work flows for teh UI, where SQL statements were used with teh help of Sub Queries and Oracle Defined Functions
• Participated in Debugging critical Production issues by working as a Team.
• Configured Mapping of teh fields to match teh User Interface for teh 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 teh Performance tuning, Optimization of queries and standardization of teh code.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Developed Stored Procedures to include in teh existing Packages and used teh 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 teh field to Match teh 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