PROFESSIONAL SUMMARY:

• 7+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Experience in financial, healthcare, pharmacy, retail and Shipping - Logistics Management - Supply Chain Management domain.
• Expertise in performing Data export, Import and various operations using TOAD, SQL DEVELOPER, FORMS AND REPORTS.
• Extensively worked in Client-Server application development using Oracle 11g/10g/9i FORMS 9i/6i, REPORTS 10g/6i, Oracle Import and Export Utilities.
• Experience in application development using various advanced features of Oracle like Bulk Collections, Table Functions, and Autonomous Transactions, Dynamic SQL, Object types and Records.
• Developed Complex trigger using PL/SQL for data integrity and enforcing business rules.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* LOADER, UTIL file loader and batch processing.
• Demonstrated expertise utilizing ETL tools, including Oracle Data Integrator, Informatica (power center 9.1), Data stage and RDBM systems like Oracle, DB2, Teradata, Sybase and SQL Server.
• Experience with Oracle APEX to develop new and support existing business applications.
• Experience with Data Vault Concepts for ETL loads to load from date warehouse.
• Experience with DBA activities like creating table spaces, granting and revoking privileges on database objects.
• Developed and maintained data preparation and validation routines to support Data warehousing
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Extensively involved in Oracle SQL, PL/SQL tuning in OLTP and DWH applications using STATSPACK, Explain Plan, TKPROF, and Hints.

TECHNICAL SKILLS:

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

Oracle Tools: SQL * Loader, TOAD, SQL Developer, SQL Tool, SQL Navigator, Developer 2000 (REPORTS 6i/9i/10g/11g, FORMS 6i/9i/10g/11g), SQL*Plus, Discoverer, Power Builder 12, Oracle APEX, Data Vault

ETL Tools: Informatica Power Center 8.6.X/6.1, Data stage

Data Modeling Tools: Erwin 4.5/4.0/3.5, Designer 2000, Microsoft Visio 2003

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.

Programming Languages: Unix Shell Scripting, Perl Programming, XML, C, C++,Java, HTML,XML

Environment: Sun Solaris 2.6/2.7/2.8/8.0 , Red Hat Linux, Windows NT/ 95/ 98/ 2000/ XP,MS DOS 6.22

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

PL/SQL developer (DBA)

Responsibilities:

• Involved in analysis, design and coding of Oracle processes in PL/SQL to build packages.
• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle 11g.
• Used SQL*LOADER and UTIL file loader to upload bulk data by writing scripts for Control file.
• Working on the ETL side of the process to load data into database from different servers.
• Created variables, sequences, user functions, scenarios, procedures and packages in ODI.
• Programed in UNIX shell scripts to provide a user interface to Oracle forms and reports.
• Developed and implemented Oracle Forms and Oracle Reports.
• Designed and Developed several reports using Oracle Reports 11g.
• Developed UNIX Shell scripting for job automation and daily backup.
• Involved in performance tuning using with TKPROF.
• Documentation of the business process through Designer.
• Developed Procedures, Functions and Triggers to be implemented in the Reports.
• Developed data models for adding new tables and fields to the data warehouse.
• Worked on production support, and receive production calls, and working on trouble reports which are received from clients
• Tuned SQL statements using hints for maximum efficiency and performance, created and Maintain/modify PL/SQL packages, mentor others with the creation of complex SQL statements, perform data modeling and create/maintain and modify complex database triggers and data migration scripts.

Environment: Oracle 11g, Oracle 10g, Oracle Data Integrator (ODI) 11g,Oracle REPORTS Developer (11g), SQL Developer, Oracle Application Servers, UNIX Server 4.3, Windows NT, SQL*LOADER, TOAD, JavaScript, HTML, XML, CSS.

Confidential, Exton, PA

Oracle Programmer/Developer

Responsibilities:

• Oracle data warehouse developer responsible for the technical design, development and testing of extract, transform, and load (ETL) programs.
• Responsible for working with data architect and business analysts to design/build data loading and conversion programs.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Loaded data using oracle database utilities such as data pump, SQL*loader and external tables.
• Developed PL/SQL package procedures using REF cursor, Collections and Dynamic SQL.
• Developed PL/SQL package procedures to fetch bulk rows from cursor variable to collections.
• Used Data Vault concept for loading data from data ware house.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Operated BLOBS, CLOBS and BFILES using PL/SQL (DBMS LOB) packages.
• Enhanced database functionality using Oracle supplied PL/SQL packages.
• Primary ETL Developer for creating and enhancing multiple data feeds including standard feeds like Enrollment, Awards, Transactions, and Coupons etc.
• Programed in UNIX shell scripts to provide a user interface to Oracle forms and reports.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.

Environment: Oracle 11g, Data Stage, Oracle Developer Suite 10g,Data Vault,, Oracle Forms 10g, Reports 10g, Informatica Power Center 9.1/9.5, TOAD, SQL DEVELOPER, UNIX SHELL Scripting.

Confidential, Harrisburg, PA

Oracle PL/SQL developer

Responsibilities:

• Database performance monitoring and identifying bottlenecks hindering the performance of the existing applications.
• Created ODI packages, scenarios using interfaces, variables, procedure. Performance tuned the ODI interfaces.
• Participated in code reviews. Did code promotions from Dev to test, staging and production environment using ODI.
• Worked on Informatica Power Center to develop various mappings using different transformations and also developed workflows.
• Design and implementation of stored procedures and triggers for automating tasks
• Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Developed SQL* loader scripts to load data in the custom tables.
• Formulated SQL queries, functions and processes as per customization requirement for APEX
• Supported APEX applications and conducted performance tuning for PLSQL.
• Analyzed, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
• Maintained a series of UNIX Shell Scripts to manage batch order processing.
• Used ETL tools to extract and load data from SQL Server and flat files to Oracle database.

Environment: Oracle 11g, Informatica Power Center 9.1, Oracle Data Integrator 10.1.3.5, UNIX Server 4.3, SQL DEVELOPER, Windows NT, SQL*PLUS, SQL Navigator and TOAD.

Confidential, Jacksonville, Florida

Oracle PL/SQL developer

Responsibilities:

• Primary responsibilities included system analysis, coding, testing, debugging and deploying.
• Developed Forms Screens used by Oracle Developer Suite for forms procedures, functions and packages generate to end product of forms.
• Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created scripts to createnew tables, views, queriesfor enhancement in application using TOAD.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage
• Used SQL*LOADER and UTIL file loader to upload bulk data by writing scripts for Control file.
• Created changes in the database according new requirements (new tables in the existing database and fields in the existing tables).
• Design and implementation of stored procedures and triggers for automating tasks
• Developed the UNIX scripts using KORN shell to automate jobs.
• Analyze the source data structure and perform the Logical mappings.
• Created Forms using forms builder to showcase the data to users and enable them to perform the required updates
• Monitored the database and tuned the application code for better performance using with TKPROF.
• Scheduled batch jobs using ODI scheduler. Wrote technical specification requirements and provided production Support.
• PowerBuilder used for simplifying migration process.

Environment: Oracle 11g/10g, Oracle Developer Suite 10g (Forms and Designer), ODI 10.1.3.6, Oracle Application Servers, PowerBuilder12, UNIX Server 4.3, Windows NT, SQL*PLUS, SQL Navigator and TOAD.

Confidential

Oracle Developer

Responsibilities:

• Planning Backup/Restoration Strategy, Executing UNIX Shell Scripts using jobs, Planning and scheduling Backups, taking Logical Backups (with Export / Import utilities).
• Tuning Applications, Tuning Memory and Tuning Disk Usage.
• Coding procedures, functions, and triggers and generating the specified reports.
• Tuning of the SQL queries using Explain Plan, SQL*Trace and TKPROF.
• Refreshing the test database with the production database.
• Created and maintained the UNIX shell scripts to automate common tasks.
• Created of Roles, Users, Table spaces, database triggers, procedures etc.
• Modifying the database design and structure, as necessary, from time to time upon information given by application users and developers.
• Created FORMS and REPORTS using Visual Basic.

Environment: Sun Solaris 7, Oracle9i, Oracle Enterprise Manager, SQL*LOADER/Import/Export Scripts, Erwin, TOAD, Visual Basic 5.0, Crystal Reports.