PL/SQL Developer Resume

SUMMARY

Fifteen years and nine months of IT work experience and Four plus years of Technical Lead experience, Oracle11g/10g/9i/8i Developer/2000/R2.0 (Forms 10g/ 6i/5.0/4.5/, Reports 10g/6i/3.0/2.5), Oracle Database Server 11g,10g/9i/8/8i on Windows 2000, NT, UNIX and Sun - Solaris.
Expertise in client server, Internet architecture applications development using Oracle 11g/10g/9i/8i/8.x, PL/SQL, SQL* Plus, SQL *Loader.
Expertise in Developing and customizing PL/SQL procedures, functions, packages, triggers, partition tables, object tables, nested tables, Forms and reports.
Extensive Experience In development of Data Migration Data Conversions, Data Mapping, Data Extraction, Data Modeling & Data design, Customization of Products (Forms and Reports)
Expertise in SDLC, Relational database, Entity Relationship Diagrams, Preliminary System Requirement Study, System Analysis & Development, Test Plan Preparation, Unit Testing, System Integration Testing, Documentation and Implementation for VLDB’s.
Experience in PL/SQL, Stored Procedures, Packages and Database Triggers.
Experience in DBA, Performance Tuning, Optimizing SQL, PL/SQL and debugging, of the applications Using Tuning Tools (SQLTRACE, TKPROF, EXPLAIN PLAN, ANALYZE).
Expertise in SQL HINTS, Indexes like (B*Tree, Bitmap, Function Based, Hash Cluster, Reverse key) for faster performance.
Experience in using the Oracle supplied packages DBMS SQL, DBMS LOB, UTIL FILE, DBMS JOB, DBMS SCHEDULER, DBMS UTILITY.
Involved in data extraction, transformation and loading ETL operations on Oracle using SQL LOADER, External table and Informatica and involved in design of dimensional models like Star Schema, Snowflake schemas
Extensive experience in Premia custom Insurance Application and ODS data Movements and involved in writing the SQL, PL/SQL and Unix Shell scripts.
Extensive experience in Developing the Premia custom Insurance Application and ODS data Movements by using PL/SQL Procedures.
Extensive experience in Business of Future (BoF) to Common Landing Area (CLA) Online Extract transform and Load (ETL) CLA Load process.
Extensive experience using Oracle Index, Views, Materialize Views, External Tables which is Manual ETL Process and it is a new feature of 9i Database.
Exposure on EDI, Strong skills, ability to interact with people at all levels
Extensive Team Lead experience to handle the onshore and offshore teams/ onshore-offshore model.

TECHNICAL SKILLS

Database: ORACLE (11g/10g/9i/8i/8.x/7.x), SQL Server2000/2005, MS Access

GUI: Developer2000 (Forms 10g/6i/5.0/4.5, Reports 10g/6i/3.0/2.5), VB (6.0).

Languages/Internet: C, C++, PL/SQL, SQL, Pro* C, Java (2.0),Javascript, HTML, XML, XSL

Operating System: Sun Solaris, Win-NT/ 2000, HP-UNIX, MS-DOS, IBM-AIX

Data Base /Tools: SQL * Loader, SQL* plus, SQL * Navigator, Discoverer, TOAD,FTP, SCP, CSS. Informatica.

Noetix Tools: Noetix Views, Noetix Platform, Noetix NWQ, Noetix EUL Generator

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship