SUMMARY:

• 17+ years of experience using Oracle database Development.
• Development (Stored Procedure, Package, Functions, Triggers, Views, Materialised Views Etc)
• Good understanding of teh Oracle RDBMS architecture including underlying objects, schemas/products, database objects, file system structure, tables, views, packages, procedures, sequences, indexes, partitioning and constraints.
• Design databases, such as interfaces, global temporary tables, data partitions etc.
• Analysis of business and technical requirements, and mapping them to implementation strategies and design (system/application architecture).
• Architect Centralized approach VPD (Virtual Private Database)
• Design/Develop high quality database schema to meet performance and expandability expectations
• Optimisation of existing and development and review of new PL/SQL code for faster execution and rendering.
• Advanced knowledge of SQL and PL/SQL.
• Experience in design of Oracle database in a distributed environment with good understanding on partitioning
• Building teh databases using RMAN, IMP/EXP and DATA PUMP.
• Solid understanding on Schema, Objects and Tablespaces
• Strong experience developing efficient Oracle PL/SQL batch programs
• Analysis of Execution Plans using Explain Plan and TKPROF
• Revamped of Historical Reports Module to bring them from inactive state to active state by introducing Partitioning, Decreasing database Calls from front end and rewrote optimized queries

PROFESSIONAL EXPERIENCE:

Confidential, Malvern, PA

Oracle PL/SQL DB Developer

Responsibilities:

• PL/SQL Coding, Changes for teh Asset Management Project, Tasks on changes to teh existing package, Areas of customization involves some changes in teh existing procedures, manupulation of collections, Cursor outputs.
• Major tasks on working on a PL/SQL Package dat is designed for search operations, with few dynamic sql’s and static with a ref cursor output.
• New procedure development for reporting, Collection of taxlots dat violates certail rules are gathered in to a staging table and spool them to a report.
• Oracle PL/SQL Code Review. Tuning SQL’s used for Reporting. knowledge of Oracle SQL tuning concepts, Indexing, Hash Joins, Nested Loops.
• Re - writing query whenever required for better way of execution.

Environment: Oracle 11g, PL/SQL in Unix

Confidential, Boston, MA

Oracle PL/SQL Database Developer

Responsibilities:

• Analysing Existing System (Derivative Reporting System).
• Understanding teh customization requirements to prepare Techno specific document, explaining teh area of changes.
• Database Development of Reporting Packages

Environment: Oracle 11g in Linux, SQL, PL/SQL.

Confidential, Madison, WI

Oracle PL/SQL DB Architect

Responsibilities:

• Technical Design of PL/SQL Programs for integration of Ebay and Amazon payment methods for Confidential Doll portal. Integrating of Orders, Shipment, invoicing etc. with commerce hub.
• Technical Design to interface with e-commerce Hub on Market Place Model to account with ecommerce portal of Walmart, JC Penny Etc.
• Understanding teh existing programs, understanding teh format of teh interface e-commerce Hub Expects, preparing Technical Specifications for teh Developers to ensure dat an error free program can be developed without much effort.
• Review of PL/SQL Programs, Assisting teh Developers to ensure dat they are not blocked by any technical or business feasibility.

Environment: Oracle 11g in Linux, SQL, PL/SQL

Confidential

Associate Vice President

Responsibilities:

• Collective responsibilities of DB Team, MIS Team Deliveries, Hands on in Development.
• Recruit, train and mentor team members.
• Assisted developers with application design and performance tuning of complex queries. dis included using teh dictionary tables, TKPROF and other tools.
• Design, Architect, Document and Development of PL/SQL Packages.
• Replicate Data’s from TLM Product using efficiently build Database routines.
• Troubleshoot Database performance issues.
• Design and Implementation of Data purging mechanism

Environment: Oracle 11g in Linux, SQL, PL/SQL.

Confidential

Oracle Developer

Responsibilities:

• Design and development of New PL/SQL Packages and customization of existing Programs for a Stock Control Application.

Environment: Oracle 11g (SQL & PL/SQL), Solaris.

Confidential

Senior Software Engineer

Responsibilities:

• Development of PL/SQL Programs of a Retail application developed for NessPro.
• Installation, configuration and maintenance of Oracle 10g (10.1.0.1) database.
• Performance Improvement on Existing PL/SQL Programs.

Environment: Oracle 11g (SQL & PL/SQL), Windows/Unix Environment.

Confidential

Sr. Systems Analyst

Responsibilities:

• Architected Centralized approach VPD (Virtual Private Database) & Storage pattern of data by utilizing partitions.
• Organize storage act by utilizing partitions Historical Schema for Archival and to generate Historical reports, optimizing them under teh effective usage of partitions of data and managing its storage.
• Created and maintained Materialized view databases to create non-master sites kept in sync using replication. They were kept in sync with teh master by frequently refreshing teh data from teh master site tables.
• Re-architected Database Packages to optimize execution, Review code and bring in Optimized way of writing SQL’s and PL/SQL.

Environment: Oracle 9i, Oracle 10g, Solaris (PL/SQL, SQL).

Confidential

Associate

Responsibilities:

• Implemented Database Packages for Exception, CDD (Compliance Due Diligence) Module.
• Performed application tuning in Oracle by identifying slow queries and tuning.
• Removal of older partitions, Created automated script to remove teh oldest partitions using data dictionary table.

Environment: Oracle 9i, Unix, TOAD

Confidential

Senior Software Engineer

Responsibilities:

• Development of Technical Specification from BRD.
• Data modelling using Rational Rose Tool. Maintenance/Customization of Data Model.
• Standards on Naming Columns, table column Changes, Generation of DML Scripts
• Implemented Clients Outstanding for Loans using PL/SQL Packages
• Participation in collaborative design discussions, development process decisions & Performance improvement programs
• Installation and administration of Development Database and QA Database (Oracle) Windows & Solaris

Environment: Oracle9i, UNIX, Windows Server, TOAD

Confidential

Technical Consultant

Responsibilities:

• Development of stored Procedures & packages for Internet Banking in Oracle
• Installation, administer, configure Oracle 8i in Solaris Box.
• Oracle network configuration (listener and tnsnames).
• Tablespace creation/ Resizing Tablespaces, User creation.
• Creation of Objects like tables and Indexes.

Environment: Oracle 8i, Solaris (OraclePL/SQL, SQL), TOAD.

Confidential

Software Engineer

Responsibilities:

• Product Development (Foreign Exchange, Clearing Settlement).
• Oracle Database creation, Installation and configuration of Oracle Developer 2000.
• Data Migration from legacy systems to Production database either in teh form of data file loading via SQLLDR.
• Onsite support on parallel run/production, support users for tallying their accounts on day end.
• Installation of Client Server Oracle Forms/ Reports,Oracle 8i on Windows/UNIX (SCO).
• Mapping database with clients to establish client server connectivity.
• Managing database sizing, like tablespace creation, addition of data files etc.

Environment: Oracle 7.3 & 8i, PL/SQL, Sco, Forms 3 / 4.5, Reports, TOAD