SUMMARY

• Over 8 years of extensive experience as an oracle PL/SQL developer.
• Extensive experience in application data modeling and building data warehouse architecture (Star & Snowflake schemas) using Erwin and IBM Rational Rose data modeler tool.
• Have created large scale normalized data models for complex OLTP applications and denormalized models for OLAP databases.
• Excellent knowledge of various domains including financial, communication, pharmaceutical and health care industry.
• Experienced in working with Oracle (7, 8i, 9i,10g,11g,12c), DB2, MS SQL Server, Sybase databases on various platforms like UNIX (Solaris, AIX), Linux (RHEL, Fedora, SUSE) and Microsoft NT/2000/2003 Server systems.
• Proficient in Oracle PL/SQL, writing stored procedures and custom routines.
• Involved in all stages of Software Development Life Cycle.
• Expertise in developing strategies for Data Cleansing & Migration from various operational sources into data warehouse & data marts using Oracle PL/SQL.
• Expertise in Data Warehouse programming and fulfillment of data warehouse project tasks such as data extraction, cleansing, transforming and loading.
• Extensively worked in writing PL/SQL stored procedures, database triggers, exception handlers and cursors and ref - cursors and utPL/SQL test cases.
• Expertise in various reporting tools ( Crystal Reports, Oracle Reports ).
• Experienced in working with many complex SQL queries with joins, date functions, inline functions, cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports.
• Expert in maintaining data integrity using various constraints and database triggers.
• Expertise in data migration projects with both ( target - source ) same database as well as with heterogeneous databases.
• Proficient in interpersonal relations, team lead skills, project management, communication, outsourcing partner teamwork and organization with excellent communication and presentation skills.

TECHNICAL SKILLS

• Toad
• Oracle developer tools
• DB Artisan
• Oracle 12c/11g/10g/9i/8i/8.x/7.x
• MS SQL server 2000/2005/2008
• SQL
• PL/SQL
• T-SQL
• SQL*Plus
• Oracle Enterprise Manager (OEM)
• STATSPACK
• AWR
• TKprof
• Explain plan exp/imp
• DataPump
• OWB
• ERwin
• Rational Rose Data Modeler 7
• Star Schema/Snowflake Schema Modeling
• Crystal Reports v10
• Oracle forms
• Oracle Reports
• LDAP
• Password Management Utilities clear case clear quest
• Informatica
• Sybase
• C
• C++
• Java
• XML
• Unix Shell Scripting
• Windows 98/2000/NT/XP
• AIX5L
• Sun OS 5.8
• Linux
• Unix shell scripts
• Perl
• MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Piscataway, NJ

Senior PL/SQL Developer

Responsibilities:

• Designed / Developed/ Maintained & Supported for network capacity planning applications ( RANFT / MRIFT / NOVA - AI - for LTE )
• Worked with various research teams to understand complex forecasting algorithms designed in C/C++/VB and translated them into Oracle PL/SQL solutions.
• Created daily / weekly ETL cron-jobs to automate the data gathering from various sources.
• Optimized the application processing architecture and achieved significant reduction in forecasting algorithm execution time.
• Created parallel batch processing architecture using shell scripts and PL/SQL for maximum efficiency.
• Wrote complex PL/SQL functions, triggers, procedures, packages for rigorous data processing.
• Wrote ad hoc SQL queries using various oracle analytical functions for analyzing data for research.
• Identified / documented data sources and transformation rules required to populate and maintain data warehouse content.
• Identified source systems, their connectivity, related tables and fields and ensured that the data was suitable for mapping.
• Created the Logical / Physical model of the Data Warehouse (DW) tables
• Designed reporting solutions using shell scripts and SQL.
• Optimized SQL by analyzing execution plans and PL/SQL with bulk operations using oracle collections.
• Worked with various cross functional teams to device impromptu solutions.
• Worked with external tables and data loading operations with SQL*loader
• Created complex migration scripts ( DDL / DML ) for production releases.
• Created and maintained Database Objects (Tables (partitioned / non-partitioned), Views, Indexes, Sequences, Database triggers, Stored procedures, functions, packages etc).

Environment: Oracle 10g/11g/12c, Windows, SunOS, Toad 9.7, PL/SQL, Unix shell scripting, C, C++, Visual Basic, Excel, XML

Confidential, Trenton, NJ

Senior PL/SQL Developer

Responsibilities:

• Created Logical / Physical data models using IBM Rational Rose Data Modeler and ERwin for new requirements after discussions with technical team and application users.
• Knowledge transfer / explanation for various data entities and relationships to technical team members.
• Maintained database objects for development, training and production databases.
• Made changes in existing PL/SQL functions, procedures, and packages and also wrote new code to suit new requirements.
• Created Crystal Reports for various requirements and wrote background PL/SQL functions, procedures and packages for reports.
• Converted existing PL/SQL package procedures into table functions for Jasper reporting.
• Wrote ad hoc SQL queries for to assist in JAVA coding according to application requirements.
• Worked on migration and integration of different application (JEMSTAT) into existing Hippocrates application.
• Worked with other DBAs in upgrade of Oracle 10g to Oracle 11g.
• Wrote triggers and procedures for database security and backup requirements.
• Created PL/SQL packages to create XML files using oracle xml functions.
• Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries.
• Moved / manipulated data from one environment to another for development, testing and debugging of application.
• Involved in Data Loading and Data Migration. Used SQL*Loader to load data from flat files and Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Created and maintained Database Objects (Tables, Views, Indexes, Sequences, Database triggers, Stored procedures etc).

Environment: Oracle 9i/10g/11g, Crystal Reports v10, IBM Rational Rose Data Modeler 7.0, Windows, Toad 9.7, Microsoft Visual SourceSafe 6.0, PL/SQL, T-SQL, shell scripting, MS Access, Excel files, XML

Confidential, Reston, VA

Senior Oracle PL/SQL Developer

Responsibilities:

• Worked with pool ( collection of loans ) team to support existing PL/SQL code and provided solutions to assigned tasks for various enhancements and defects.
• Modified batch process for multifamily and upper level pool dissolve operation.
• Provided enhancements for pool collateral updates and collateral behavior batch processing.
• Executed, monitored and troubleshoot various UNIX batch processes for business operations.
• Worked with functional team to provided suited technical solutions.
• Wrote complex database modification scripts for hot fix solutions.
• Wrote packages for unit testing using utPL/SQL and debugged using DBMS debug packages and other PL/SQL developer tools.
• Prepared and documented the Technical Design according to the business requirements.
• Wrote PL/SQL Stored Procedures, Functions and Packages and Triggers with extensive use of cursors, complex joins, date functions and string handling functions to implement business rules into the application.
• Created complex PL/SQL packages for business operations using various PL/SQL records and collections.
• Wrote large complex SQL scripts for database object management and space management ( to move / rebuild indexes / tables ) and reporting packages.
• Worked with Queue tables (AQ) and partitioning for better handling of batch processes.
• Tuned SQL using STATSPACK, AWR reports.
• Wrote ad hoc queries for business data requirements.
• Created views to apply security policies and also created materialized views to achieve performance gain.
• Optimized SQL queries generating trace files and using TKprof and Explain Plan utilities.
• Worked with DBA for performance tuning and space management.
• Knowledge transfer with other departments and team members.

Environment: Oracle 11g/10g, UNIX, Sun Solaris, Shell scripting, Clear case, clear quest, Erwin, MS Visio, Windows, Toad 9.0, PL/SQL, XML, MS Excel

Confidential, Manhattan, NY

Senior Oracle PL/SQL Developer

Responsibilities:

• Reversed engineered existing database and refined existing database schema to make more effective and efficient database model.
• Prepared the Technical Design according to the business requirements.
• Made one universal data model combining four different application databases ( Mortgage database, Investment Database, Accounts Database, Bonds Database ) to make one comprehensive financial application.
• Created suitable data models for existing application data from XML and mapped it with new table schema.
• Documented comprehensive data dictionary for each application data field.
• Created DDL for various modules of data model for testing and implementation.
• Wrote PL/SQL Stored Procedures, Functions and Packages and Triggers with extensive use of cursors, complex joins, date functions and string handling functions to implement business rules into the application.
• Wrote T-SQL procedures and functions.
• Wrote large complex SQL scripts ( DDL / DML ) for database object management and space management ( to move / rebuild indexes / tables ) and reporting packages.
• Created views to apply security policies and also created materialized views to achieve performance gain.
• Optimized SQL queries generating trace files ( DBMS trace ) and using TKprof and Explain Plan utilities.
• Imported data from flat flies using SQL * Loader.
• Created detailed source - target database mapping with transformation required.
• Discussed migration policies with other developers and DBAs for quick and error-free migration between heterogeneous databases.
• Discussed the data model with application users to refine the design and made changes accordingly.
• Wrote custom procedures and functions to transfer data from various sources to universal application database.
• Knowledge transfer to incoming DBA and other team members.

Environment: Oracle 9i/10g/11g, MS SQL Server 2000, T-SQL, RHEL, Erwin, MS Visio Data Modeler, Windows, shell scripting, Toad 9.0, PL/SQL, XML, MS Excel

Confidential, Stamford, CT

Senior Oracle PL/SQL Developer

Responsibilities:

• Analyzed existing logical data model (LDM) and made appropriate changes to make it compatible with business logic.
• Created normalized Physical Data Model (PDM) for the OLTP application using IBM Rational Rose Data Modeler.
• Identified important tables to apply Oracle Virtual Private Database (VPD) security policies to those tables.
• Wrote complex PL/SQL codes ( functions, procedures, triggers ) to support the application and to enhance application functionality.
• Involved in data model reviews with internal data architect, business analysts and business users and explained the data model in depth to make sure it’s in sync with business requirements.
• Defined data migration policies and documented detailed source to target mapping for data migration from existing Sybase database to target Oracle 10g database.
• Identified source systems, their connectivity, related tables and fields and ensure that data is suitable for mapping.
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
• Worked with cross functional teams and prepared detailed design documents for production phase of current application decommission and building a new application.

Environment: Oracle 10g, IBM Rational Rose Data Modeler, Sybase, HP-UX, Sun Solaris, shell scripting, Windows NT, Toad, PL/SQL.