We provide IT Staff Augmentation Services!

Oracle Pl/sql/etl Developer Resume

Trenton, NJ

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

Hire Now