SUMMARY:

• Around 7 years of IT experience as an Oracle PL/SQL/T SQL and Informatica developer, System Analysis, Design, Development & Support of Oracle Servers 8.0, 9.i and 10 g, 11g as well as MS SQL Server 2008, SSRS in Production, Staging, Development environments
• Have good experience in writing PL/SQL and TSQL scripts for the database objects like Tables, Views, Procedures, Functions, Packages, Database Triggers, Indexes and Sequences,
• Expertise in using advanced features of Oracle for PL/SQL programming like Arrays, Varrays, Nested Loops, Dynamic SQL, LOB, CLOB, Records, Objects, Exception Handling, calling web services from procedures and also several new features in 11g .
• Expertise in Table Partitioning, Index Partitioning and Exception Handling.
• Solid experience in performance tuning and Query Tuning (Generating Explain Plan, Optimizer with Hints).
• Extensive experience in using Cursors, Ref - cursors, Bulk Binds and Bulk Collects for processing of data.
• Expertise in ETL development using Informatica.
• Solid experience in data warehouse environments.
• Data loading from other databases and text files into Oracle Database using SQL Loader.
• Excellent experience in Normalization and Denormalization.
• Familiar with UNIX shell scripts and good at file handling mechanism.
• Experience in Relational and Dimensional Data modeling, Physical and Logical Data modeling using Erwin. Sound understanding of Relational and Normalized databases.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Self-motivated and committed person with excellent interpersonal communication skills and willingness to learn new tools, concepts and environments.

TECHNICAL SKILLS:

Databases: Oracle 11g, 10g,Oracle 9i, Oracle 8i, MS Sql Server 2008

Languages: PL/SQL, SQL, UNIX Shell Programming, C

Tools: Oracle Enterprise Manager, Informatica PowerCenter 9.6.1, Autosys,TOAD 9.6.1, Putty, CoreFTP, SmartFTP, SQL Developer 1.2.1, Navigator 5.5, PL/SQL Developer 7, ERWIN 4.14/4.0, SQL Loader, Export / Import, Statspack, Crystal reports XI/8.5

Operating Systems: UNIX (Sun Solaris, HP-UX, AIX), Linux, Windows 2003/2000/XP/98

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL/SQL/ETL Developer

Responsibilities:

• Efficiently developed high complex packages and procedures and functions.
• Efficiently worked on migration through releases.
• Extensively worked on Informatica development.
• Efficiently worked on production support activities by resolving high priority tickets.
• Extensively worked on code changes
• Directly worked with users to resolve issues.
• Deploy the changes into production with CRQs.

Confidential

Oracle PL/SQL Developer

Environment: Oracle 10g, PL/SQL, Toad 10.1.8, UNIX, C#, ASP.Net, Share point, Putty, Reflection

Responsibilities:

• Efficiently developed high complex packages and procedures and functions.
• Efficiently worked on migration through releases.
• Efficiently worked on production support activities by resolving high priority tickets.
• Extensively worked on batch uploads by writing shell scripts and using sql loader.
• Extensively worked on code changes

Confidential, Trenton, NJ

Oracle PL/SQL and SQL Server Developer

Environment: Oracle 11g, PL/SQL, T SQL, Toad 9.1, C#, ASP.Net, Share point, Sql server 2008, Crystal Reports.

Responsibilities:

• Efficiently migrated from Sql server to oracle.
• Database design for all the above DMHAS applications.
• Developed PL/SQL and TSQL packages, procedures, views and indexes and triggers.
• Efficiently wrote complex dynamic SQL in order to give a best user experience.
• BLOB operations are extensively used to load, store and retrieve PDF files.
• Troubleshot performance issues and bugs within packages and stored procedures using EXPLAIN PLAN, SQL TRACE, HINTS and TKPROF.
• Wrote SQL*Loader script file for reading data from text file and loading into oracle table.
• Efficiently used dynamic SQL and pivot features of SQL server for the project CLOUD.
• Wrote complex yet fast and efficient procedures/functions by using cursors to interact with Data Access Layer of the application for web pages and reports.
• Efficiently used temporary tables to store intermediate results in the procedures.

Confidential, Secaucus NJ

Oracle PL/SQL Developer

Responsibilities:

• Database Design for Admin module to achieve great scalability, efficient security and flexibility to accommodate country’s specific needs.
• Database Design for Time module.
• Wrote complex yet fast and efficient procedures, functions, packages by using cursors and collections to interact with Data Access Layer of the application.
• Efficiently used Bulk collect for bulk insert and bulk update.
• Efficiently Partitioned tables from Time module for date range.
• Efficiently used ODP.Net provider to perform bulk-insert and bulk-update operations.
• Wrote cross-tab queries to import legacy data from corporate card charges and HR Feed.
• Created Materialized views to access Employee related data from GFIS-HR.
• BLOB and CLOB operations were used to store and retrieve serialized objects across application. These were also used to store and retrieve design templates for various Reports.
• Involved in application tuning of database by defining the suitable indexes, hints and tuning SQL queries.
• Optimized and enhanced the existing procedures and SQL statements for the better performance using EXPLAIN PLAN, HINTS to tune SQL queries.
• Wrote SQL*Loader script file for reading data from text file and loading into oracle table.
• Used Export/Import utility for backup purpose and transferring data from one database to another.
• Usage of UTL FILE package to load the data from external files that is exported from Server.
• Used Cursors, Exception Handling and also used the Pragma Exception Init in order to associate our own created error messages with the error codes.

Environment: Oracle 11g, PL/SQL, Toad 9.1, Putty, WinSCP, Toad 9.6.1, C#, ASP.Net, Win forms