PROFESSIONAL SUMMARY:

• About 7 + 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.
• 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
• Provided backend support for various perl based applications.
• Worked on Oracle Forms10g/9i/6iReports10g/9i/6i.
• Well-versed with different stages of Software Development Life Cycle (SDLC).
• Extensively used PL/SQL to build Oracle Reports 10g and views for processing data, enforcing referential integrity and needed business rules.
• 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.
• 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: HP-UX 11i, Solaris 2.x/8, AIX 5.3, OpenVMS, Windows XP/NT/2000

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

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

Oracle Utilities: SQL*Plus, SQL*Loader, SQL developerTOAD.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 HP quality center.

PROFESSIONAL EXPERIENCE:

Confidential, Monroeville,PA

Oracle PL/SQL 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 perl scripts using DBI/DBD for data extraction.
• Used various CPAN perl modules to enhance the functionality
• 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.
• Using Swing Concepts in Java Front End Forms are designed.
• 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

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.
• 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.
• 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, Reports 9i, SQL, PL/SQL, TOAD, SQL*Loader, UNIX, MS Windows XP/2000, Oracle Development Suite.

Confidential, Phoenix, Arizona

Confidential

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.
• 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.