PROFESSIONAL SUMMARY:

• About 8 + years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of client/server and 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 Analysis and SQL query tuning, while designing scalable applications from scratch and maintaining existing ones, using Query Optimizer, Indexes, Execution Plans, Hints, Explain Plan, And Tk - prof.
• Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation, and Post Implementation surveys. Highly skilled in Design, Development, Implementation, and 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.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges on OLTP server.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, V arrays, 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.
• Experience with data flow diagrams, data dictionary techniques, Entity relation modeling and design techniques, database normalization theory.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof 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.
• Develop many front end applications using APEX 4.2.
• Assist in design and development of large-scale perl applications and Created perl scripts using DBI/DBD for data extraction
• Developed and designed dynamic configuration wrapper in perl to generate flat fund reports
• Worked on Oracle Forms 11g/10g/9i/6i Reports 11g/ 10g/9i/6i.
• Well-versed with different stages of Software Development Life Cycle (SDLC).
• Extensively used PL/SQL to build Oracle Reports 11g/10g and views for processing data, enforcing referential integrity and needed business rules.
• Design and software coding using C, C++, multi-threading, data structure and Algorithms in different OS environments like WINDOWS, LINUX.
• Experienced in Tuning Queries for better performance with large volume of data. Extensive experience in developing applications using Oracle Forms / Reports. Experience in almost all the versions of Forms/Reports.
• 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.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Expertise in implementing ETL (extract, transform and load) by using Oracle Warehouse Builder (OWB).
• Experience in migration of source code using version control system (CVS, Arch, Visual source safe, svn, TFS).

TECHNICAL SKILLS:

Operating systems: UNIX, LINIX, Windows VISTA/XP/2000/98, MS DOS, MAC

Languages: SQL, PL/SQL, Unix Shell Scripts, C, C++, CSS, HTML, XML.

RDBMS: Oracle 12c/11g/10g/9i/8i, MS-SQL Server 2000/2005, Sybase, DB2, MS Access.

Oracle Utilities: SQL*Plus, SQL*Loader, SQL developer, TOAD.

GUI Tools: APEX 4.2,3.2,Oracle Forms 11g,10g,9i,6i and Reports 11g,10g,9i,6i, ERWIN,VISIO, Golden gate, Autosys, Control-M, JIRA and QC quality center, PAC 2000.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Oracle PL/SQL/Informatica Developer

Responsibilities:

• Involved in designing ER diagram using ERWIN and VISIO. To set the logical and physical relationships of database.
• Worked on loading cobol format file into oracle using informatica.
• Created new work flows to load the data into oracle tables on incremental basis.
• Created new autosys jobs to execute sql scripts through autosys.
• Created new materialized views to pull the data from remote database and created job to to refresh mv on daily basis.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Used tortoise TFS and Perforce version control for changing the codes.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Developed and designed dynamic configuration wrapper in perl to generate flat fund reports.
• Provided backend support for various perl based applications.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even have experience with exception handling..
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Experience in creating DTS/SSIS packages for transferred data modifications.
• Hands on experience in creating ETL packages using SQL Server 2008 Integration Services (SSIS
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Archived many applications in the existing system and retrieval of necessary data from them.
• Worked with java 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.

Environment: Oracle 12c/11g,, TOAD, UNIX, MS Windows 7, ERWIN, VISIO, Informatica Power Center, Perforce, TFS, Autosys, Winscp.

Confidential, Concord, CA

ORACLE PL/SQL DEVELOPER

Responsibilities:

• Worked as an Oracle Developer to provide basic support to the client for Database and Banking Application. Also provided support for primary level debugging ( application problems )
• User interaction, requirement analysis , functional specification , design , development and implementation .
• Involved in developing DB objects like tables, triggers and View s.
• Involved in the development of Functions , Procedures , and Packages to transfer data into the database tables.
• Involved in formulating general methodologies , naming conventions and coding standards for various procedures and packages .
• Wrote SQL, PL/SQL , programs to retrieve data from the flat files
• Transferred data from flat files into the database tables using SQL* Loader.
• Extensively used IMPORT utility to load the exported files .
• Developed database objects including tables, clusters, Indexes , views , sequences , packages , triggers and procedures to troubleshoot any database problems.
• Worked on developing software applications using C++/SQL development environment
• Used Explain Plan , HINTS , DBMS Profiler for performance tuning of sql, pl/sql queries .
• Supported code push preparing change for new version release of application support to eod jobs, also involve in Troubleshooting, fixed, and implemented bug fixes and enhancements within tight deadlines.
• Extensively used Cursors , User - defined Object types , Records , and Tables in PL/SQL Programming for generating worksheets.
• Create/maintain and modify complex database triggers and data migration scripts .
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Used SQL * LOADER to upload data into the tables.
• Supported C++ testing framework to improve automated testing

Environment : Oracle 11g, SQL, PL/SQL, Oracle SQL developer, SQL navigator 7.2, Autosys, Oracle RDBMS,LINIX, UNIX, PAC2000.

Confidential, Monroeville, PA

Oracle Developer

Responsibilities:

• Studied user requirements and functional specifications.
• Developed Entity Relationship diagrams/Dimensional Diagrams for business requirements
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Involved in designing ER diagram using VISIO, to set the logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Experience with Oracle partitioned tables and queries.
• High-Transaction environment experience.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even have experience with exception handling..
• Created scheduled and schedule now reports.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
• Created perl scripts using DBI/DBD for data extraction.
• Used various CPAN perl modules to enhance the functionality
• Written C++ scripts for Unit tester.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Creating and enhancing daily, monthly, yearly jobs using Perl and UNIX shell Scripting.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Using Swing Concepts in Java Front End Forms are designed.
• Developed and customized number of reports using Oracle Reports and Forms.
• Using Oracle Jdeveloper Database tools to write triggers and procedures, Function.
• Worked with java 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.
• Good experience in GG mapping.
• Created materialized views to assist GG development.
• Good in understanding the GG deployment and tune the performance.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF and AUTOTRACE.
• Using Bash script for database connectivity using DBI which connects to backend database drivers.
• Developed UNIX Shell scripts to run various utilities & wrote UNIX Cron jobs for the scheduled batch processes.
• Expertise in creating shell scripts and used Crontab in UNIX environment for scheduling routine tasks.
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 11g, SQL, PL/SQL, TOAD, UNIX, Forms and Reports 11g, MS Windows 7,VISIO, GOLDEN GATE, Informatica Power Center

Confidential, Denver, CO

Oracle PL/SQL Developer

Responsibilities:

• Involved in designing ER diagram using oracle designer, to set the logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Migration of dbms jobs to control M.
• Scheduling jobs in control M and handling them.
• Used tortoise svn version control for changing the codes.
• Making changes to the existing apex applications in the production.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Created and maintained various perl libraries to support the application.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Customized various Forms and Report according to the requirements.
• Modified and u pdated existing custom forms to adapt to new database schema
• Part of a development team for creation and maintenance of custom apps/reports .
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in pl/sql blocks and even have experience with exception handling.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Troubleshoot T-SQL, SSIS and SSRS errors and performance issues and address them as required
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Archived many applications in the existing system and retrieval of necessary data from them.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Worked with java 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.
• Used ORACLE SQL DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 9i/10g, Forms 9i/10g,Reports 9i/10g, SQL, PL/SQL, TOAD, SQL*Loader, UNIX, MS Windows XP/2000, Oracle Development Suite.

Confidential, Phoenix, Arizona

Oracle PL/SQL Developer

Responsibilities:

• Involved in designing ER diagram using ERWIN and VISIO. To set the logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Migration of dbms jobs to control M.
• Scheduling jobs in control M and handling them.
• Used tortoise svn version control for changing the codes.
• Making changes to the existing apex applications in the production.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Developed and designed dynamic configuration wrapper in perl to generate flat fund reports.
• Provided backend support for various perl based applications.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even have experience with exception handling..
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Experience in creating DTS/SSIS packages for transferred data modifications.
• Hands on experience in creating ETL packages using SQL Server 2008 Integration Services (SSIS
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Archived many applications in the existing system and retrieval of necessary data from them.
• Worked with java 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.

Environment: Oracle 9i/10g, SQL, PL/SQL, TOAD, UNIX, MS Windows 7, Apex 4.2, SVN, ERWIN, VISIO.

Confidential, West Des Moines, IA

Oracle PL/SQL Developer

Responsibilities:

• Actively involved in interacting with front end Java developers, and gathered User Requirement and Online System Specification.
• Created new logical and physical database design to support multi-year conferences for the tables of employees, histories, skills, experience and payroll.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
• Normalized to 3NF to acquire least data repetition required by business.
• Created PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
• Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Created/ reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Implemented security by creating User logins, Roles and granting Users access to the database according to their role.
• Converted all Oracle ETL Packages to Informatica Mappings and created workflows/sessions.
• Used UTL JOB to automate the plsql procedures and packages.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF and AUTOTRACE
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Environment: Oracle 9i, Windows 2003, UNIX, SQL, PL/SQL, SQL Loader, Erwin and SQL Navigator.

Confidential - General Insurance System

Jr. Oracle Developer

Responsibilities:

• Responsible for analyzing business functionality for the back end processes.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging.
• Involved in using dimensional modeling, created fact tables, dimensional tables and other database objects in the Star schema model.
• Developed ETL processes for Data Extraction, Data Mapping and Data Conversion using PL/SQL scripts and load data into warehouse Schemas.
• Worked on improving the Performance of SQL queries by extensive usage of Explain plan and various hints and indexes.
• Responsible to load various table data, flat file data to populated and processed on daily basis from legacy to online production environment using SQL*LOADER.
• Involved in creating user interface Forms and reports using Oracle Forms/Reports 6i.
• Participated in performance tuning, unit test case preparation and execution.

Environment: Oracle 8i, SQL, PL/SQL, TOAD, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i, Windows 2000.

Confidential

SQL Developer

Responsibilities:

• Worked on the project that involved development and implementation of a data warehouse.
• Created Store Procedures, Functions, Triggers, Indexes and Views using T-SQL in all the environments for SQL Server 2000.
• Developed DTS Packages to transfer the data between SQL Server and other database and files.
• Scheduled jobs & Re-Scheduled on Production Databases.
• Created report form with Stored Procedure using T-SQL
• Wrote and optimized Triggers, Stored Procedures and Queries in T-SQL.
• Created database objects like tables, views and indexes.
• Created and modified stored procedures, triggers and cursors.
• Designed, developed and modified various Reports.
• Handled and managed customer relationship management system.
• Designing and modeling database according to Requirement. And made changes according to it.
• Designed, developed, and tested complex queries for Reports distribution.
• Built and performed user acceptance testing on modified reports.
• Skilled in running jobs in Enterprise Manager using job-scheduling tool.

Environment: MS SQL Server 2000/2005, My SQL, Lotus Notes, MS Access, MS Office Suite (Word, PowerPoint, Excel).