SUMMARY

• Worked as Oracle PL/SQL Developer & Oracle Forms & Reports Developer in all phases of SDLC involving Analysis, Design, Development, Implementation, Testing and Deployment of Business applications using Oracle RDBMS on various platforms
• Used Cursors, REF Cursors, Exceptions and Hints.
• Knowledge in RDBMS concepts, with hands on exposure in the development of relational database environment using Oracle 11g/10g, SQL, PL/SQL, SQL*Loader, TOAD, SQL*PLUS in many development projects
• Excellent SQL skills, experience writing complex queries and working with database objects like Tables, Sequences, Synonyms and Views
• Proficient in Oracle SQL, advanced PL/SQL includes creating Packages, Functions, Procedures, Triggers and materialized views with emphasis on maintaining standards and handling errors in a consistent and robust manner
• Good experience in writing Test cases, Test scripts and Unit test plans
• Experience in writing high level test plan for the whole project
• Experience with normalization, partitioning of data and indexing of partitioned tables
• Bulk Data Loading using Oracle utilities namely SQL*Loader and External Tables
• Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect Feature, Materialized Views, Dynamic SQL, Oracle Hints and Troubleshooting Oracle database issues for better performance
• DB Design, Oracle Forms and Reports, PL/SQL Development
• Data Migration, Data Mapping or Table Mapping, Data Loading and exporting by using SQL*Loader and UTL File Utilities
• Good experience in creating the Project Release Plan for the operations team for deployment
• Proficient in developing front - end interface using Oracle Forms and Reports Developer suite
• Developed new screens using forms builder.
• Extensive knowledge of SQL*Loader and Oracle supplied standard packages
• Loading test files into unix environment using FTP client using Core FTP
• Involved in testing files in development and production by running Unix shell scripts
• Involved in Encrypting and Decrypting of files for secure communication using GnuPG
• Handled ADHOC requests from the Business System Analysts
• Adding a PGP key to the public key ring
• Updating ACE directories on development and production with the latest data as per USPS and running audits +
• Scheduled jobs to be run daily in production using Maestro Job Scheduler
• Handled tasks when an ABEND alert is created on production
• Involved in data sweeps when BSA requests to update a table
• Involved in killing jobs when they get stuck and re-running the jobs on CONMAN
• Worked with BSA’s for doing QC (quality check) after running the audit and update korn shell scripts
• Worked on Teradata database
• Worked on SAS Enterprise Guide to pull data from Teradata and Oracle databases
• Excellent communication skills, interpersonal, strong architecture skills and a good team player

TECHNICAL SKILLS

Programming Skills: Oracle PL/SQL, SQL, HTML, UNIX Shell Script, C, SAP, Teradata, MS Office

Software Tools: SQL Developer, Oracle Forms & Reports Developer Suite, Toad, SQL*Loader, Core FTP, Putty, Maestro, GnuPG (Encrypting & Decrypting Data), IBM Tivoli Work Load Scheduler, Ultra Edit

Databases: Oracle 11g/10g

Operating Systems: Unix, Windows 8/7/XP, DOS

Hardware Tools: Microprocessor (8085/8086/8051), FPGA, MAT Lab, Xilinx, OPNET, SIMULINK

Networking protocols: TCP, UDP, DHCP, DNS

PROFESSIONAL EXPERIENCE:

Confidential - COPPELL, TX

ORACLE DEVELOPER

Responsibilities:

• Involved in Development, Implementation, and Testing and Deployment of Business applications using Oracle RDBMS
• Loading test files into Unix environment using FTP client i.e. Core FTP
• Involved in working on the requests made by other teams.
• Involved in manually pushing the files into production as requested by SA Auditors team.
• Involved in fixing the translate errors before that day’s batch of jobs starts
• Involved in generating monthly tax report and bag fee report as requested by other teams.
• Involved in coding as per the change requests.
• Involved in file transfers to First data client
• Involved in ON CALL production support 24/7 and fix the jobs which are failed.
• Involved in using PL SQL techniques to create tables, perform DML’s to load data.
• Involved in using Unix commands to write and modify scripts on Unix
• Involved in using Autosys to see job status.
• Written complex SQL queries using joins, sub queries and correlated sub queries
• Handled errors using system defined exceptions and user defined exceptions
• Using SQL Loader to load files into tables for comparison

Environment: Oracle 11g, PL/SQL, TOAD, SQL Developer, Forms 11g and Reports 11g, UNIX, WinSCP, Autosys, SVN, PVCS, Windows XP

Confidential - RICHARDSON, TX

ORACLE DEVELOPER

Responsibilities:

• Involved in Development, Implementation, and Testing and Deployment of Business applications using Oracle RDBMS
• Involved in developing new screens and modifying existing screens on Forms Builder.
• Involved in creating built-in triggers on Forms Builder.
• Involved in modifying packages and creating new packages.
• Involved in creating new triggers.
• Involved in creating design documents.
• Involved in creating the new stored procedures and wrappers for execution
• Written complex SQL queries using joins, sub queries and correlated sub queries
• Developed / modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers based on technical and functional specification documents
• Used Joins extensively in stored procedures, packages
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases
• Handled errors using system defined exceptions and user defined exceptions
• Loaded the data into database tables using SQL*loader from text and excel files
• Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards.
• Written test cases on stored procedures
• Developed Unit Test Plans
• Developed Unit Test Cases to test the functionality of the procedure
• Written Test case scripts
• Developed high level test plan for the whole project
• Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functions as per the business requirements
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plan and Trace sessions for Cost based optimization
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning
• Tuned SQL queries for new reports for faster response time
• Tuned the SQL Queries and Stored procedures for better Performance
• Collaborated with other project teams for performance tuning of queries.
• Created Oracle Hints and worked on Partition tables in Oracle Database, Dynamic SQL
• Created the Project Release Plan for the operations team for deployment
• Worked on Teradata database
• Worked on SAS Enterprise Guide to pull data from Teradata and Oracle databases

Environment: Oracle 11g, PL/SQL, TOAD, SQL Developer, Forms 11g and Reports 11g, SVN, PVCS, Windows XP

Confidential - LEWISVILLE, TX

ORACLE PL SQL & ABINITIO DEVELOPER

Responsibilities:

• Involved in Development, Implementation, and Testing and Deployment of Business applications using Oracle RDBMS
• Involved in getting requirements from the Business.
• Involved in making amendments on the business requirement document (BRD) based on the developer analysis.
• Involved in working with the business analysts to document the FSD (Functional system document).
• Involved in working on ADHOC requests in reporting different types of manual submissions to the Treasury.
• Worked on the Change Requests requested by the CAB every month.
• Worked on the mapping documents from source to target in order to load the columns through Abinitio into the target database tables.
• Worked on modifying packages and creating new packages, creating new stored procedures and wrappers for execution of procedures, views, triggers in development phase of the change requests.
• Written complex SQL queries using joins, sub queries.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Worked on documentation for each Change Request I.e. Technical Design Document, Unit Testing Document, Impact Analysis Document, Migration Document.
• Worked on code versioning tool SVN.
• Worked on creating the approval work flows for the manger on the documentation.
• Involved in unit testing the developed code before promoting to UAT.
• Involved in working with the Business Analyst in testing the functional requirement.
• Involved in creating conditional scripts to create data in order to fall into testing criteria for the Business Analyst.
• Involved in production support and validating the Change Request at the time of release.
• Developed number of Ab Initio Graphs across multiple projects based on business requirements using various Ab Initio Component sets like Database, Transform, Partitioning, Translate etc.
• Developed Ab Initio graphs to extract/load huge amounts of datasets from multiple Databases, used several DML core functions for data type conversions, searching for data in lookup files, performing mathematical computations.
• Hands on Experience on Tagging of code, supporting the code migrations and usage of AIR commands for importing, exporting objects to and from EME Technical repository.
• Self-initiative, good team player, excellent problem solving and communication skills, exceptional skills in Agile development and Test driven development.

Environment: Oracle 12.1, PL/SQL, TOAD, SVN, Visio, Ab Initio (GDE 3.2.5.1; Co>Operating System 3.2.5.2), Windows XP

Confidential - MONROEVILLE, PA

ORACLE DEVELOPER (PL/SQL & FORMS AND REPORTS)

Responsibilities:

• Involved in Development, Implementation, and Testing and Deployment of Business applications using Oracle RDBMS
• Involved in developing new screens and modifying existing screens on Forms Builder.
• Involved in creating built-in triggers on Forms Builder.
• Involved in modifying packages and creating new packages.
• Involved in creating new triggers.
• Involved in creating design documents.
• Involved in creating the new stored procedures and wrappers for execution
• Written complex SQL queries using joins, sub queries and correlated sub queries
• Developed / modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers based on technical and functional specification documents
• Used Joins extensively in stored procedures, packages
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases
• Handled errors using system defined exceptions and user defined exceptions
• Loaded the data into database tables using SQL*loader from text and excel files
• Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards.
• Written test cases on stored procedures
• Developed Unit Test Plans
• Developed Unit Test Cases to test the functionality of the procedure
• Written Test case scripts
• Developed high level test plan for the whole project
• Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functions as per the business requirements
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plan and Trace sessions for Cost based optimization
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning
• Tuned SQL queries for new reports for faster response time
• Tuned the SQL Queries and Stored procedures for better Performance
• Collaborated with other project teams for performance tuning of queries.
• Created Oracle Hints and worked on Partition tables in Oracle Database, Dynamic SQL
• Created the Project Release Plan for the operations team for deployment
• Worked on Teradata database
• Worked on SAS Enterprise Guide to pull data from Teradata and Oracle databases

Environment: Oracle 11g, PL/SQL, TOAD, SQL Developer, Forms 11g and Reports 11g, SVN, PVCS, Windows XP

Confidential - Irving, TX

Oracle Developer

Responsibilities:

• Involved in Development, Implementation, and Testing and Deployment of Business applications using Oracle RDBMS
• Loading test files into Unix environment using FTP client i.e. Core FTP
• Involved in testing files in development and production by running Unix shell scripts
• Tested the file by running audits on a file using shell script
• Transferring encrypted files from client server to vendor server for the vendor to pick those encrypted files using his private key.
• Running shell scripts to update the tables with the raw data in the files
• Handled ADHOC requests from the Business System Analysts to re-set profanity email for a consumer id
• Handled ADHOC request from the BSA’s to re-set deceased setting for a particular consumer id
• Encrypting a file as per the request of BSA
• Decrypting a file as per request of BSA
• Adding a PGP key to the public key ring
• Updating ACE directories on development and production with the latest data as per USPS and running audits on them
• Handled tasks when things break in production as scheduled by maestro
• Updating maestro calendar with holidays for jobs to run as scheduled
• Handled tasks when an ABEND alert is created on production which run overnight everyday by debugging logs and the Korn shell scripts involved in that job
• Involved in data sweeps when BSA requests to update a table
• Involved in killing jobs when they get stuck and re-running the jobs on CONMAN
• Involved in debugging the code when BSA request the reason for the populated data
• Worked with BSA’s for doing QC (quality check) after running the audit and update Korn shell scripts
• Involved in modifying packages and creating new packages.
• Involved in creating new triggers.
• Involved in creating design documents.
• Involved in creating the new stored procedures and wrappers for execution
• Written complex SQL queries using joins, sub queries and correlated sub queries
• Developed / modified Oracle PL/SQL code for stored Procedures, Functions, Triggers based on technical and functional specification documents
• Used Joins extensively in PL/SQL code development.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Handled errors using system defined exceptions and user defined exceptions
• Loaded the data into database tables using SQL*loader from text and excel files
• Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards.
• Written test cases on PL/SQL code developed
• Developed Unit Test Plans
• Developed Unit Test Cases to test the functionality of the procedure, function, package, trigger, views
• Written Test case scripts
• Developed high level test plan for the whole project
• Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functions as per the business requirements
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plan and Trace sessions for Cost based optimization
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning
• Tuned SQL queries for new reports for faster response time
• Tuned the SQL Queries and Stored procedures for better Performance
• Collaborated with other project teams for performance tuning of queries

Environment: Oracle 11g, PL/SQL, SQL Developer, Core FTP, GnuPG (Secure Communication), TOAD, Forms 11g and Reports 11g, Unix Shell Script, Putty, Maestro, Windows XP, Ultra Edit

Confidential, MONROEVILLE, PA

ORACLE DEVELOPER

Responsibilities:

• Involved in Development, Implementation, and Testing and Deployment of Business applications using Oracle RDBMS
• Involved in developing new screens and modifying existing screens on Forms Builder.
• Involved in creating built-in triggers on Forms Builder.
• Involved in modifying packages and creating new packages.
• Involved in creating new triggers.
• Involved in creating design documents.
• Involved in creating the new stored procedures and wrappers for execution
• Written complex SQL queries using joins, sub queries and correlated sub queries
• Developed / modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers based on technical and functional specification documents
• Used Joins extensively in stored procedures, packages
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases
• Handled errors using system defined exceptions and user defined exceptions
• Loaded the data into database tables using SQL*loader from text and excel files
• Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards.
• Written test cases on stored procedures
• Developed Unit Test Plans
• Developed Unit Test Cases to test the functionality of the procedure
• Written Test case scripts
• Developed high level test plan for the whole project
• Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functions as per the business requirements
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plan and Trace sessions for Cost based optimization
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning
• Tuned SQL queries for new reports for faster response time
• Tuned the SQL Queries and Stored procedures for better Performance
• Collaborated with other project teams for performance tuning of queries.
• Created Oracle Hints and worked on Partition tables in Oracle Database, Dynamic SQL
• Created the Project Release Plan for the operations team for deployment
• Worked on Teradata database
• Worked on SAS Enterprise Guide to pull data from Teradata and Oracle databases

Environment: Oracle 11g, PL/SQL, TOAD, SQL Developer, Forms 11g and Reports 11g, SVN, PVCS, Windows XP

Confidential, West Sacramento, CA

Oracle Developer

Responsibilities:

• Involved in Development, Implementation, and Testing and Deployment of Business applications using Oracle RDBMS
• Involved in writing the new stored procedures and wrappers for execution
• Written complex SQL queries using joins, sub queries and correlated sub queries to retrieve relatable claims
• Developed / modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers based on technical and functional specification documents
• Used Sub-queries, Merge statements
• Joins extensively in stored procedures
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases
• Handled errors using system defined exceptions and user defined exceptions
• Loaded the data into database tables using SQL*loader from text and excel files
• Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards.
• Written test cases on stored procedures
• Developed Unit Test Plans
• Developed Unit Test Cases to test the functionality of the procedure
• Written Test case scripts
• Developed high level test plan for the whole project
• Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functions as per the business requirements
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plan and Trace sessions for Cost based optimization
• Performance Tuning of Informatica Mapping and workflow.
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning
• Tuned SQL queries for new reports for faster response time
• Tuned the SQL Queries and Stored procedures for better Performance
• Collaborated with ETL teams for performance tuning of queries.
• Created Oracle Hints and worked on Partition tables in Oracle Database, Dynamic SQL
• Created the Project Release Plan for the operations team for deployment

Environment: Oracle 11g, PL/SQL, TOAD, Forms and Reports, Informatica, Windows XP, Lotus Notes

Confidential, Addison, TX

Jr Oracle Developer

Responsibilities:

• Written complex SQL queries using joins, sub queries and correlated sub queries
• Developed PL/SQL procedures, functions, packages and triggers
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases
• Handled errors using system defined exceptions and user defined exceptions
• Loaded the data into database tables using SQL*loader from text and excel files
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database
• Worked on Oracle Hints. Partition tables in Oracle Database, Dynamic SQL
• Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functions as per the business requirements
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plan and Trace sessions for Cost based optimization
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning
• Tuned SQL queries for new reports for faster response time
• Developed application using Oracle Forms & Reports
• 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
• Tuned the SQL Queries and Stored procedures for better Performance
• Optimized the performance of queries by Data Manipulations which includes modifications in SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary
• Modified existing packages, procedures, functions, views and triggers to handle new database design
• Collaborated with other project teams for performance tuning of queries.

Environment: Oracle 10g/11g, PL/SQL, SQL * Plus, Oracle Forms and Reports, SQL Developer, Unix

Confidential, NJ

Database Developer

Responsibilities:

• Written complex SQL queries using joins, sub queries and correlated sub queries
• Developed PL/SQL procedures, functions, packages and triggers
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases
• Handled errors using system defined exceptions and user defined exceptions
• Loaded the data into database tables using SQL*loader from text and excel files
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database
• Worked on Oracle Hints. Partition tables in Oracle Database, Dynamic SQL
• Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functions as per the business requirements
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plan and Trace sessions for Cost based optimization
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning
• Tuned SQL queries for new reports for faster response time
• Developed application using Oracle Forms & Reports
• 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
• Tuned the SQL Queries and Stored procedures for better Performance
• Optimized the performance of queries by Data Manipulations which includes modifications in SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary
• Modified existing packages, procedures, functions, views and triggers to handle new database design
• Wrote Unix for clean-up, logging, file manipulation and transferring the files
• Collaborated with other project teams for performance tuning of queries.

Environment: Oracle 11g, PL/SQL, XML, Forms and Reports, UNIX, TOAD, Windows XP

Technical Assistant

Confidential, NJ

Responsibilities:

• Created tables with data types, inserted data and solved queries using DDL, DML, DCL statements.
• Designed a database for a deluxe departmental store, casino.
• Extensively Used Cursors, REF Cursors, Exceptions and Hints.
• Proficient in RDBMS concepts, with hands on exposure in the development of relational database environment using Oracle 11g/10g, SQL, PL/SQL, SQL*Loader, SQL*PLUS, TOAD and SQL Navigator in many development projects
• Excellent SQL skills, experience writing complex queries and working with database objects like Tables, Sequences, Synonyms and Views
• Proficient in Oracle SQL, advanced PL/SQL, SQL*PLUS includes creating Packages, Functions, Procedures, and Triggers and materialized views with emphasis on maintaining standards and handling errors in a consistent and robust manner
• Done normalization and partitioning of data and indexing of partitioned tables
• Done Bulk Data Loading using Oracle utilities namely SQL*Loader and External Tables
• Done Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect Feature, Materialized Views, Dynamic SQL, Oracle Hints and Troubleshooting
• Oracle database issues for better performance
• Done DB Design, Oracle Forms and Reports, PL/SQL Development
• Done Table Mapping, Data Loading and exporting by using SQL*Loader and UTL File Utilities
• Developed front-end interface using Oracle Forms and Reports
• Extensive knowledge of SQL*Loader and Oracle supplied standard packages

Confidential

PL/SQL Developer

Responsibilities:

• Performed review of the business process, involved in Requirements Analysis, System Design Documents, Flows, Test Plan preparations and Development of Business Process / Work Flow charts
• Developed PL/SQL procedures, customizing existing programs according to the needs of the client testing
• Wrote PL/SQL packages consisting of procedures and functions
• Created Materialized Views, Triggers, Sequences, collections
• Involved in development and testing of oracle back-end objects like database triggers, stored procedures, Sequences and Synonyms
• Worked with tuning the complex Stored Procedures for faster execution using bulk collections and Dbms Profiler
• Involved in design, development and Modification of PL/SQL stored procedures, Functions, packages and triggers to implement business rules into the application
• Extensively used cursors for fetching the rows
• Loading data through SQL Loader and UTL FILE
• Involved in tuning the SQL queries create database objects and optimally set storage parameters for tables and indexes
• Designed reports using Reports as per user requirements. Created Reference and Master/Detail tables to store information. Tested forms and reports using test data
• Developed complex triggers in reports before/after for validation of user input
• Designed and developed user interfaces using Oracle Forms
• Wrote Shell scripts to insert data to database tables. Wrote PL/SQL code to retrieve data for master and detail blocks
• Customized forms and reports as per user requirements using Oracle Developer Forms & Reports

Environment: Oracle 9i, PL/SQL, SQL*Plus, Forms, Reports, Windows