SUMMARY:

• Dynamic professional with 8+ years of extensive experience as an Oracle PL/SQL Developer with ETL, shell scripting experience in diverse sectors including Finance, telecommunication, Health care.
• Expertise in Software Development Life Cycle(SDLC) of client implementations including requirements gathering, business analysis, system configuration, design, development, testing, technical documentation and support.
• Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, Tables, Indexes, Constraints, Materialized Views and others in Oracle 12c/11g/10g database.
• Strong experience in providing technical documentation and status reports of teh applications as per teh requirement.
• Expertise in developing and customizing Oracle Forms and Reports using Oracle Forms10g/9i, Reports10g/9i, Discoverer 9i/10g, XML Publisher and developing concurrent programs using SQL, PL/SQL.
• Solid experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Strong technical background with approximately three years of production support experience in SQL, PL/SQL, Oracle, UNIX, and Shell Scripting.
• Proficient in loading data from flat files into database tables using SQL*Loader scripts.
• Involved in Oracle Performance Tuning which included creating indexes, partitioning tables, providing Hints, modifying tables using Explain Plan, SQLTrace and TKPROF.
• Worked with tools like PL/SQL Developer, SQL Developer, SQL*Loader, TOAD, SQL Plus,FileZilla, WinSCP.
• Working experience in Data Extraction, Transmission and Loading (ETL).
• Experience in using data sources/targets such as Oracle 12c/11g/10g, MS SQL Server 2008/20012, DB2, XML and Flat files.
• Good understanding of data modeling concepts like ER Diagrams, UML, Use Cases, Normalization and De - normalization of Tables.
• Developed Oracle Forms and Oracle Reports using 11g,10g depending on teh functional requirement document.
• Proven ability to work efficiently in both independent and team work environments.
• Excellent communications and analytical skills.
• Having experience as Lead. Lead offshore team.
• Having knowledge on TALEND.
• Highly organized and efficient to prioritize and manage multiple tasks.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g, MS SQL 2008/2012, MS Access, DB2

Languages: SQL, PL/SQL, XML, UNIX Shell Scripting, Perl Scripting, C, C++, Perl programming

Oracle Tools/GUI: Forms 9i/10g, Reports 9i/10g, Discoverer 11g

Tools: PL/SQL Developer, TOAD, SQL Developer, SQL*Loader, Oracle SQL*Plus, SQL Navigator, PUTTY (Unix/Linux Utilities), Solaris, FileZilla, WinSCP

Web Technologies: HTML, Apache, Microsoft Internet Information Server (IIS), VBScript, JavaScript, CSS, DHTML, XML

Operating Systems: Windows Family, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Oracle PL/SQL Developer

Responsibilities:

• Involved in analysis, requirements gathering, functional/technical specification, development, deploying and unit testing.
• Worked in PL-SQL code tuning System Analysis, Design, Coding, Testing, Development and Documentation.
• Created schema objects like tables, indexes, synonyms, sequences, stored procedures, functions, packages and views.
• Heavily involved in UNIT testing teh database code for data integrity, module testing for validating each module independently, application testing for application functionality and integration testing of all modules together.
• Worked on both proactive and reactive SQL Tuning and Query Optimization Techniques for complex SQL Statements.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance teh performance of databases.
• Worked on Query Optimization Techniques for complex SQL hints Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance teh performance of databases.
• Fixing performance problems with PL/SQL programs.

Environment: Oracle 11g client version,12c, SQL Developer, UNIX Shell Scripts, Perl programming, ETL, SQL*Plus, MS Excel, MS- Visio, VI Editor, HTML, Java script, CSS.

Confidential, Rochester, NY

Oracle PL/SQL Developer

Responsibilities:

• Custom tables and new custom objects were designed as per business requirements.
• Involved in all phases of SDLC as active participant.
• Designing, Developing, Enhancing and Maintaining Data warehouse Oracle ETL Processes, PL/SQL scripts, DB Procedures, DB functions, creating tables and indexes.
• Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
• Used various Indexing and partition techniques to improve teh query performance.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Improved teh performance of teh application by rewriting teh SQL queries.
• Created Materialized Views, tables, complex SQL queries, correlated sub queries, Nested Queries, Views and Function Based Indexes for effective Business Application Development.
• Designed and developed Oracle PL/SQL Procedures, Functions and Database Triggers and involved in creating and updating Packages to meet business requirements.
• Created PL/SQL stored procedures, functions and packages for moving teh data from staging area to data mart.
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.
• Used Dynamic SQL to implement DDL statements in PL/SQL programs.
• Created scripts to create new tables, views and queries for new enhancement in teh application using TOAD.
• Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
• Leading offshore team.

Environment: ORACLE 11g, SQL Developer, TOAD, UNIX, FileZilla & WinSCP, WebLogic, Vector wise.

Confidential, king of Prussia, PA

Oracle PL/SQL Developer

Responsibilities:

• Created numerous stored procedures and used procedural parameters to work with packages & exception handling.
• Designed and developed Oracle database Tables, Views, Indexes, Sequences and Synonyms.
• Experience in working with scalar and composite data types.
• Extensively used PL/SQL Packages, Stored procedures, Triggers and tuned them for performance considerations
• Used SQL Loaders to load data from flat files into database tables.
• Dedicated to optimizing teh code written by various developers and worked on performance tuning with optimization techniques in PL/SQL.
• Wrote feed handlers using Perl and DBI to update an Oracle 10g/11g database.
• Collaboratively worked with DBA on performance tuning.
• Used oracle forms and created various reports using Oracle Reports Builder for day to day validations.
• Involved in performance testing of teh overall application and tune teh SQL Queries and database where needed using Explain plan.
• Expertise in solving complex queries and improves teh performance of application by performance tuning.
• Implemented ETL processes, Data flows and Data Marts based on business requirement.
• Understanding and Troubleshooting complex customer issues on production environment. Responsible for identifying any bugs occurring in teh applications as well as fixing them.

Environment: Oracle 11g, Forms 9i, Reports 9i, SQL Loader, SQL Developer, Windows 7, UNIX Shell Scripts, Perl programming, ETL, MS Excel, MS- Visio, VI Editor, HTML, JavaScript, CSS.

Confidential

PL/SQL Developer

Responsibilities:

• Implemented views for security purposes. Assigned views to other schemas when needed to hide teh business information.
• Developed stored procedures and triggers to facilitate consistent data entry into teh database.
• Developed Oracle Forms and Oracle Reports using 10g depending on teh functional requirement document.
• Involved in database migration from Oracle 9i to 10g database and generated oracle forms and reports.
• Actively involved in system analysis and data modeling to create tables, views, indexes, synonyms, triggers, functions, procedures, packages and cursors.
• Worked on advanced concepts of PL/SQL such as Records, Collections and Dynamic SQL.
• Created Database triggers for quickly retrieving a row and performed validations.
• Used pipelined functions for faster data accessibility.
• Expertise in solving complex queries and improves teh performance of application by performance tuning.
• Resolved teh issues in conflicts between teh target and source database in gloden Gate.
• Expertise on performance tuning on SQL using Auto Trace, Explain Plan utilities.
• Created various stored procedures, functions, packages and triggers using TOAD environment.
• Wrote feed handlers using Perl and DBI to update an Oracle 11g database.

Environment: Oracle 11g, Crystal Reports XI, Data Integrator, MS Excel, TOAD, WebLogic, XML, XSLT, UNIX, Microsoft Office, Version Control Software, UNIX Shell Scripts.

Confidential

Oracle Developer

Responsibilities:

• Created well defined stored procedures, functions, packages, collections, triggers & object types.
• Improved Data optimization and manipulation of staged data using PL/SQL packages.
• Proficient in SQL DDL, DML, DCL, TCL & SELECT statements.
• Involved in database migration and identified various scenarios during teh upgrade for oracle 10g.
• Worked on complex SQL and PL/SQL queries. Implemented cursors, ref cursors, sub queries, correlated sub queries.
• Developed Test Cases in Unit Testing and System Integration Testing.
• Created SQL code for generating PRIMARY KEY using Oracle SEQUENCE objects.
• Worked with Erwin for data modeling. Participated in code review meetings with teh development team.
• Effectively used Oracle predefined functions such as Single row and multiple rows.
• Documented and archived historical data for future auditing purposes. Responsible for production support and troubleshooting teh production issues.

Environment: Oracle Database 10g, Windows XP, TOAD, SQL Loader, JavaScript, LINUX.

Confidential

Jr. Oracle Developer

Responsibilities:

• Analyzed business requirements of teh project by studying teh Business Requirement Specification Document.
• Creation of database objects like tables, views, procedures, packages using Oracle utilities like SQL Plus, SQL Loader and Exception handling.
• Designed teh front-end interface for teh users using oracle Forms, Reports using 8i
• Timely monitoring of database and system backups developedOracle stored procedures, functions, packages and triggersthat pull data for reports.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Participated in Performance Tuning for query optimization and program performance.
• Involved in Technical Documentation, Unit testing, Integration testing and writing teh Test plan.
• Use joins on various tables and display data from multiple tables.
• Automated Quality Check tasks by creating PL/SQL cursors, functions and dynamic SQL.

Environment: Oracle 10g, SQL Plus, Windows XP, UNIX, HTML, Oracle SQL Developer, Erwin, Oracle, InformaticaPowerCenter 8.6/8.1, Java, MS Access 2000/2002.