SUMMARY:

• 11 years of IT experience with Oracle, Netezza, DB2 database development including Analysis, Modeling, Design, Administration and Maintenance on both UNIX and NT platforms.
• 11 years of database experience on Oracle 12C/11G/10G/9i, PL/SQL, Data Modeling, Data Export/Import, Tuning & Optimization.
• 4 years of development experience on Netezza Mustang and Twinfin Databases creating extensive ETL scripts for various business purposes.

TECHNICAL SKILLS:

Databases: Oracle 12c,11g/10g/9i, Netezza, MS SQL Server 2008/05, DB2 8.0

Programming/Others SQL, IT: SQL, PL/SQL, Developer, Unix Shell Scripting, DOS Batch Scripting, SQL*Loader, SQL*Plus, HTML 4.0, JavaScript, CSS.

Environment: Win 3.x/95/98/XP/Vista/7/10, IBM AIX, HP - UX, Linux, MS-DOS, Sun OS

Reporting Tools: Business Objects, Cognos, SQL Server Reporting Services

Others: Oracle Warehouse Builder, Oracle Data Integrator, Sql Server Integration Services, Informatica, Erwin, Oracle Forms, Autosys, Jira, Rational Clearcase, Rational Clearquest, Apache Subversion, Quality Center, Quick Test Professional, Lotus Notes, EndNote, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Senior Oracle PL/SQL Developer

Responsibilities:

• Developed optimized PL/SQL modules to transform and load data from source system into the target system.
• Fine tuned existing scheduled PL/SQL workflows to execute faster than earlier.
• Worked on the migration of design time metadata from OWB 11g to ODI 12c.
• Designed a datamart from scratch for the YouthBuild program by analyzing the source systems data and creating necessary Fact/Dimension tables.
• Worked with the BI team in providing required data for the creation of report dashboards for the end user.
• Automated manual data transfer workflows.

Environment: Oracle 12C, OWB 11g, ODI 12C, Toad(oracle), CA Harvest, Business Objects 4.0, Windows 7, Putty.

Confidential, Reston, VA

Senior Oracle PL/SQL Developer

Responsibilities:

• Facilitated the restoration efforts for high severity and high impact incidents.
• Performed proactive problem management and incident trending to eliminate future incidents.
• Modified existing PL/SQL program units to upgrade and alter functionality.
• Worked with business users, technology staff and vendor partners to troubleshoot operations.
• Developed complex ad hoc SQL queries using hierarchical and analytical functions for reporting purposes.
• Executed daily data transfer feeds from various state departments and validated them for successful completion.
• Performed extensive investigative analysis on the incidents reported and scripted appropriate work around in a timely manner to fix the issues.
• Increased performance of the outgoing feeds by tuning the underlying extraction SQL’s.
• Worked on Informatica PowerCenter tools - Designer, Workflow Manager and Workflow Monitor.

Environment: Oracle 11G (11.2), Linux 2.6.18, Toad(oracle), DBeaver, PL/SQL Developer, Appian Scheduler, Flux job processing, Informatica PowerCenter, Windows 7, Jira, MS SharePoint, Putty.

Confidential, Washington, DC

Senior Oracle PL/SQL Developer

Responsibilities:

• Designed detailed flow diagrams for each developed module listing the processes, entities and program units involved, mapping out existing and new processes.
• Developed several parameterized Unix scripts to transfer data between servers and subsequently load them into database staging tables for further PL/SQL processing.
• Developed various PL/SQL program units from scratch adhering to the business requirements to accomplish an optimized workflow.
• Worked extensively with Ref Cursors in conjunction with reporting applications.
• Incorporated detailed logging capability in developed applications for easier failure cause detection and management.
• Created detailed technical specification documentation from the business requirements provided and later documented the developed workflow.
• Modified existing Forums and created new Forms using Oracle Form Builder to introduce new application functionality.

Environment: Oracle 11G (11.2), Sun OS 5.10, PL/SQL Developer Ver 8, Apache Subversion, Windows 7, Jira, Oracle Forums 11.1.2, Putty, Crystal Reports 12.5

Confidential, Herndon, VA

Senior Oracle PL/SQL Developer

Responsibilities:

• Developed parameterized batch scripts to automate the load of upstream interface flat files in the database.
• Designed and developed optimized ETL workflows.
• Tuned existing sql/plsql code for improved run time.
• Fixed oracle errors and troubleshot failed maintenance jobs.
• Designed and developed efficient database packages, functions, procedures and triggers.
• Interacted with business teams to gather necessary requirements for design and development.
• Created technical design documents, implementation instructions and process flow charts for new interfaces and enhancements.
• Performed peer reviews to ensure quality work.
• Extensively worked on SQL Loader to load flat files from various source systems.
• Used Oracle optimizer hints to force specific approaches and execution plans.
• Generated formatted reports in accordance with end user requirements.
• Programmed interfaces using advanced concepts of dynamic SQL, records, collections and bulk techniques to improve performance.
• Aided scalability and performance of the database tables having incremental incoming data using partitioned tables and partitioned indexes.

Environment: Oracle 10G, Rational Clearcase/Clearquest, Toad, IBM AIX, Quality Center 10, DOORS, Windows XP

Confidential, Bethesda, MD

Senior Database Developer/Analyst

Responsibilities:

• Developed ETL scripts to populate dimensions and facts from different reservation systems.
• Designed multiple Datamart interfaces from ground up based on the business requirements.
• Developed automated Unix shell scripts that processed SQL that ran the production batch/interface cycles.
• Developed in all stages of the data migration cycle from Oracle, DB2 to Netezza.
• Performed integration testing to ensure modules are in sync with each other.
• Involved in the data migration from Mustang to Twinfin in Netezza database.
• Created stored procedures, functions and packages to assist in the daily migration of the data.
• Performed sql and pl/sql tuning through modifying the existing code and using various oracle tools.
• Developed source qualifier sql’s in the oracle operational data source and optimized them to work with Informatica in the ETL process.
• Extensively worked with pl/sql Triggers to enforce business rules.
• Supported on-call production issues and batch cycle failures.
• Worked on NZSQL (netezza) to load flat files into different tables.
• Developed detailed design documents for the application modules.
• Worked with the Maestro job-scheduling software to schedule the batch scripts developed.
• Fixed data issues on the fly reported from the downstream reporting/user systems and other application teams.

Environment: Oracle 10G, Netezza Twinfin 12 ver 6.0.5, DB2 9.7, Maestro, Rational Clearcase/Clearquest, Toad, WinSQL 9, Red Hat Enterprise Linux 5.9 ( Tikanga ), IBM AIX, Windows 7, Informatica 9.1, Cognos 10.1

Confidential, Herndon, VA

Senior Oracle PL/SQL Developer/Analyst

Responsibilities:

• As a part of FS team worked closely with members of other Servicer and Investor Reporting functional development and supporting teams such as Architecture, Database Management and Operation, Test (UAT), Requirements and Business teams during entire life cycle of the project.
• Involved in gathering requirements, analysis and design of the overall business process.
• Responsible in developing high level and detail design documents for the entire application design and architecture.
• Module Design/Development - PL/SQL programming on Oracle 10g database using concepts like partitioning, partition pruning, dynamic SQL, Insert All.
• Handled code defect and release management using tools like Rational Clearcase and Rational Clearquest.
• Use dasqlplus as a wrapper utility to connect to the database.
• Used Analytical Functions to calculate aggregations/averages to amounts under different modules.
• Analyzed requirements, effort estimates, tracking and review of SIR Consolidation UAT and Validation requests.
• Extensively used Bulk Collect for processing records in bulk with less time, used NOCOPY hints for INOUT and OUT parameters.
• Developed PL/SQL procedures/functions/packages by using Varrays, Associated Arrays, PL/SQL tables, Ref Cursors, Bind Variables, user-defined records and objects.
• Created B-tree indexes for faster retrieval of data.
• Effectively used Global Temporary tables along with the common framework.
• Used optimizer hints, explain plan to run SQL scripts and statements in less time. Used Exception Handling to handle unexpected runtime exceptions in PL/SQL packages/procedures.
• Performed performance tuning for faster retrieval of data using various optimizer hints such as parallel, ordered, append and use hash.
• Generated SQL scripts to create and drop database objects including tables, views, primary keys, constraints, sequences, grants and synonyms.
• Created and used customized v$ scripts to monitor the database processes and performance.
• Worked with other database developers to ensure adherence of the database guidelines and to review production support and software development status.

Environment: Oracle 10G, Rational Clearcase/Clearquest, Toad 9.5, PLSQL Developer 7, Sun OS 5.8, Windows XP 5.1.2, Ab Initio, Business Objects, DOORS, Textpad 5

Confidential, NJ

Oracle PL/SQL Developer/Analyst

Responsibilities:

• Responsible for the System Study & Business Requirements Analysis & Documentation.
• Extensively involved in loading the flat files data into Oracle tables using SQL Loader and UTL FILE package.
• Developed several SQL’s to standardize data for converting dates and business rules to fit into Oracle format.
• Used various Triggers and Stored Procedures to validate data at each level.
• Performed data extraction by using Import/Export, Data Pump and Stored scripts.
• Converted Proprietary Markup Language scripts into HTML with the use of Dynamic SQL and UTL FILE.
• Performed ETL using PL/SQL by using of External Tables, Pipelined Table Functions and the Merge Statement.
• Developed and monitored Sql Server Integration Services(SSIS) packages to perform ETL process between the data source and its target.
• Automated data extraction from a remote database by using DBMS JOB API to call stored procedures that used explicit cursors, database links and native dynamic SQL.
• Analyzed tables and rebuilt indexes to improve performance.
• Performed performance tuning with the help of explain plan, SQL Trace, Clusters, Optimizer hints, Partitioned Tables and TKPROF.
• Developed master-detail, drill down, matrix, nested and summary detail reports using Business Objects XI.
• Maintained documentation related to difficulties, complexities that arise during the development phase and also wrote technical user documents for further enhancement of the product using Quality Center.
• Worked extensively with exception handlers for ease of maintenance of the Database.
• Used Heterogeneous Data Access utility to successfully import and query data from a non Oracle Heterogeneous Data Source.
• Also involved in query optimization choosing the best algorithm to use for executing operations and specific indices to use.
• Used Erwin Data Modeler to reverse engineer the database schema and find the entity relationships.
• Developed test cases for unit, integrated and system testing.

Environment: Oracle 10G, Oracle Reports 10g, Sql Server 05/08, T-SQL, Business Objects XI, SSIS, SQL*Loader, Mercury Quality Center 9.0, UNIX Shell Scripting, HTML, TOAD 8.x, Erwin 7.3, Windows NT 4.0, IBM AIX 5.3.

Confidential

Responsibilities:

• Used various levels of triggers to validate the data at each level.
• Created database tables with complex constraints applicable to the business rules.
• Created indexes for faster retrieval of information.
• Created a very user-friendly GUI interface.

Environment: Oracle 9i database, Reports 2, Windows 98 and UNIX.