PL/SQL DEVELOPER Resume Philadelphia, Pennsylvania - Hire IT People

PROFESSIONAL SUMMARY:

Seasoned programming professional well - versed in working on applications forms and databases. Expertise includes data modeling tools and report development tools. Team-oriented and hardworking with good verbal and written communication skills.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g

ETL Tools: Informatica (PowerCenter Oracle Developer (Forms 3.0x, 6i and 5.1/6.2 and SQL*Loader, DesignerReports 2.0, 6i).SQL Server, Toad

O S: Windows, UNIX, Shell Script

WebServices: XML MS Wind. Server 2003-2012 r2

PROFESSIONAL EXPERIENCE:

PL/SQL DEVELOPER

Confidential, Philadelphia, Pennsylvania

Responsibilities:

Working on a project as database application developer (Oracle, MS Access) with Forms.
Developing a small database of Art Management System, including forms, filters, reports, tables, and queries (front end) supported by Ms Access.
Coordinated and performed logical and physical systems design.
Successfully deliver theseexperiences, with customer and product data must be in top shape inInformaticaMaster Data Management.

PL/SQL DEVELOPER/COMPUTER PROGRAMMER

Confidential

Responsibilities:

Analysis, Design and Implementation of Business Applications using (RDBMS).
Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing and implementation.
Experience with DFD, Data dictionary, Database normalization theory techniques, ERP(small business) and design techniques
Create Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based)
Developed Complex database objects like Stored Procedures, Functions Packages and Triggers using SQL and PL/SQL.
Partitioned large Tables using range partition technique.
Expertise in Dynamic SQL, Collections and Exception handling.
Having experience in Data warehouse concepts, ETL.
Good knowledge on logical and physical Data Modeling using normalizing techniques.
Technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
Better communication, interpersonal, analytical skills and ability to perform as part of a team.
Strongexperiencein writing Unixshell scriptsand Oracle PLSQL procedures covering data feed handling, implementing business logic.
Coordinated with the front - end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files. Performed SQL and PL/SQL tuning and
Application tuning using various tools like Collections, EXPLAIN PLAN and AUTOTRACE.
Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
Software Developer (Database) 03/2005 to 02/2009
Project Management Organization | Islamabad, Pak.
Designed classes on Computer fundamentals and basic database concepts for college level students.
Developed activities and integrated technology to diversify instruction.
Developed small computer programs to work with students and increase interest in higher learning in computer sciences.
Taught Operating Systems, database and office suite abilities.

JUNIOR PROGRAMMER

Confidential

Responsibilities:

Utilized programming capabilities in Ms Excel, Ms Access and PL/SQL and other libraries as needed.
Independently designed and executed small projects and assignments.
Managed creative projects from concept to completion while managing outside vendors and online.
Provided methodologies for efficient software development and basic database design.

We provide IT Staff Augmentation Services!

Pl/sql Developer Resume

Philadelphia, PennsylvaniA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship