SUMMARY:

• More than seven years of IT Experience as Oracle Developer for System Analysis, Designing, Testing Development & Support of Oracle 8i, 9i, 10g, 11g & 12c in Production, Staging, Development environments.
• Experience in financial, health and telecom domain.
• Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors.
• Created database objects like views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
• Proficient in advance features of Oracle 11g and 12c for PL/SQL programming like Using Bulk Bind, Ref. Cursors, Varrays, Nested tables .
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, TKPROF, Explain Plan, DBMS PROFILER.
• Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and Data Pump.
• Extensively used package like DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL MAIL.
• Hands on experience with Crontab in UNIX environment for scheduling routine tasks.
• Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
• Extensively used Cubes & Rollups for making cross tabular reports.
• Strong knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table.
• Expertise in handling errors using Exceptions.
• Experience in working high transacted OLTP systems.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
• Strong interpersonal and communication skills in dealing with customers.

SKILL & TECH MATRIX:

Languages: LINUX, Sun Solaris 5.10/5.9/5.8 , HP - UX 11i 3/11i 2, IBM AIX 5.2/5.3, Windows 7/XP/2000/98, SQL, PL/SQL, UNIX shell Scripting

Database Tools: Oracle 12C/11g/10g/9i, MS SQL Server 2008/2005SQL*PLUS, TOAD, SQL Developer, Erwin 8, VI EditorData Utilities

Quality Assurance: SQL Loader, Export/Import, Data pump, Explain Plan, System Testing, Functional Testing, Unit Testing, System Integration Testing (SIT), User Acceptance

Other Tools & Web Application: Testing (UAT), Test Plan, Test Scripts and Test Cases, HTML 5, XML 1.1, UML 2.3, Filezilla 0.9.40, SFTP 6, WinSCP 5.1Automation Job/Batch Scheduling Tools

Project Management Tools: Autosys 11.3, Cron Jobs

PM Tools: MS Project 2013Rally methodologies: SDLC & AGILE

Modeling Tools: MS Visio 2010, MS Office 2010

PROFESSIONAL EXPERIENCE:

Confidential, Collegeville, PA

Oracle PL/SQL Developer

Responsibilities:

• Involved in System Analysis, Design, Coding, Data Conversion, Development and Implementation.
• Modified and created tables, synonyms, sequences, views, stored procedures and triggers.
• Ensured conformance to code standards and documentation requirements.
• Fixed performance issues and bugs with packages and stored procedures using DBMS PROFILER.
• Performed Unit Testing and ensured all the exceptions are handled according to the business logic.
• Scrutinize performance of long running scripts Using AWR reports, Explain Plan, SQL Trace, TKPROF.
• Loaded flat file using SQL*LOADER into database.
• Used TOAD for querying and debugging application.
• Written Cursors and REF Cursors for transaction processing.
• Implemented database triggers based on the business rules and requirements.
• Wrote PL/SQL Wrapper for maintaining data & code security.

Environment: UNIX, Oracle 10g, SQL*Plus, Sun Solaris, Oracle Forms and Reports, HTML, MS Visio, Data Stage.

Confidential, Grand Rapids, MI

Oracle PL/SQL Developer

Responsibilities:

• Generated SQL and PL/SQL scripts to populate datamart on top of the ware house.
• Enhanced & created DB objects like tables, views, sequences, synonyms, indexes.
• Extensively worked on Nested Tables, Varray and PL/SQL records.
• Created Cursors and Ref Cursors to process the required data.
• Used Bulk Collect and FOR ALL to DML multi-row from table.
• Loaded data from various databases using SQL *LOADER utility.
• Created UNIX shell scripts and scheduled Cron jobs.
• Testing and debugging the existing Procedures, Packages and Reports.
• Created Oracle Forms and Reports, Stored Procs, Functions, and Packages as per the business need.
• Created automated and manual scripts for satisfying the testing purpose.
• Drill down the root cause of slow running processes & provided suitable performance technique.
• Used Oracle packages - DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL MAIL.
• Wrote Dev Test Plan, Design Doc & Code Review Doc as part of project deliverable.
• Developed complex join queries for Star Schema, Snow Flake Schema, Dimension and Fact table.

Environment: Oracle 11g 12c, IBM AIX, UNIX, MS Office, TOAD, Oracle Report and Forms 10g & 11g

Confidential, DE

Oracle PL/SQL Developer

Responsibilities:

• Worked to load OLTP data into the Staging Area and Data Warehouse using transformation.
• Made structural changes to database objects using Oracle tools like SQL*Plus and TOAD.
• Wrote complex SQL queries, Sub queries and nested loops for faster data retrievals.
• Extensively used cursors, sequences, indexes in the procedures according to the requirement.
• Involved in Performance Tuning for the SQL, PL/SQL scripts.
• Extensive Knowledge and working of Bulk Collect and Bulk Binding for data retrieval.
• Used various Shell Scripts and Scheduled jobs on Crontab in UNIX environment on a routine basis.
• Modify and made tables for the loading of data from different sources using SQL*loader.
• Used exception methods with pragma exception init to associate customized exception names.
• Handled XML Files for data loading purposes.
• Used UTL file package for automated ETL processes.
• Used APEX to develop end to end Web Application Development.
• Organized and managed routine jobs using packages like DBMS SCHEDULER to schedule tasks.
• Involved in the designing of databases architecture and developed the ER Diagrams with ERWIN.
• Created B-tree, Bitmap indexes, Partition table for enhancing the performance.
• Used Hints and Generate Statistics command to enhance the performance.

Environment: UNIX, Oracle, PL/SQL, SQL*PLUS, SQL Developer, Toad, IBM AIX, IBM RUP, HPQC, WinCVS, WinSCP, APEX, Data Stage.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Extensive understanding on high level business scenario of the company's financial functional structure.
• Involved in Requirement gathering & Analysis, Database designing and normalization of database tables.
• USED SQLCODE returns the current error code from the error stack SQLERRM returns the error message from the current error code.
• Involved in the development of database objects.
• Involved in Oracle User creation & assigning Roles & Privileges.
• Involved in Doing Partitioning and Sub partitioning on table to improve performance.
• Used the pragma Exception Init to name the system exceptions that are raised by the program.
• Wrote UNIX shell scripts to automate the daily process as per the business requirement.
• Writing Tuned SQL queries for data retrieval involving complex join conditions.
• Wrote stored procedures, functions, Packages, Triggers.
• Involved in writing cursors and handling exceptions.
• Used Import/Export utilities of Oracle.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Created and managed primary data base objects such as Tables, Views, Indexes Sequences and Synonyms.
• Good exposure in creating and maintaining UNIX Shell scripts.

Environment: Oracle 9i, Windows XP, PL/SQL, SQL*PLUS, Oracle 9i Forms & Reports, SQL Developer,RDBMS

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Performed logical and physical data modeling with extensive normalization and proper naming conventions using ERwin.
• Implemented business rules on data using Stored Procedures, Functions and Packages.
• Created new Tables, integrity constraints (Primary Key/Foreign Key) in Oracle.
• Developed PL/SQL Triggers, Stored Procedures, Functions and Packages to replicate data in real time which is used by ERP system.
• Created global temporary tables, bulk processes, table partitioning on large volume tables and worked on materialized views. Created new partitions for existing partitioned tables.
• Used Analytical function and materialized view, regular expression etc.
• Minor DBA activities like import/export, creating/maintaining database objects like table, index, sequence, views, DB links.
• Created useful Indexes and Query optimization for system performance and tuning.
• Integrated and managed whole networking system of two locations.

Environment: Oracle 9i, SQL Server2005, Toad, ERwin, SQL Loader, HP-Unix