SUMMARY:

• Senior Oracle PL/SQL Developer, Data Analyst and Production Support professional with over 13 years of experience in analysis, database design, modeling, development, data conversion, SQL* Loader, implementation, 24X7 production support, system integration testing, code migration, database change management, database administration.
• Technical strengths include solid working knowledge of: Unix, C, SQL Server 2000/2005, Oracle 9i/10g/11g/12c/12g, Oracle Application express (APEX 5.0), Oracle BI Publisher 12c, MYSQL, SQL, PL/SQL, T - SQL, Developer 2000/6i/9i, Unix Shell Scripting, SQL*Loader, Erwin, ASP.Net, C#, Toad, SAS, BO Crystal Reports 7.0/8.0/9.0, Visual C++ 5.0/6.0; SQL Server BI, SSIS, SSMS; MS Access, Java /J2EE, JQuery, JavaScript, Business Objects XI, CVS, Rational Clear Case and Clear Quest, ALM and SDLC
• Possess government, medical, publishing, telecom, asset management, trade processing, fixed income, retail, email marketing, mortgage and financial industry experience.
• DB setup using DDL/DML, Oracle Data Guard, Oracle Grid Control, Oracle Diagnostics and Tuning Packs, Shell scripting including vi. Database partitioning, database failover models, hardware architectures, SAN administration, scripting, and print management, data management through the various stages of the development life cycle
• RMAN and knowledge of ALL Oracle backup and recovery scenarios.

PROFESSIONAL EXPERIENCE:

Confidential, VA

Oracle PL/SQL Developer

Responsibilities:

• Analyze, design, develop, implement and maintain ADIS database for internal and external users/clients for customs and border protection agency using PL/SQL, Oracle 12c and Unix in Agile methodology. Updating large volumes of production data as a part of development, heavy SQL*Load of large volumes of data into staging area for data repairs.
• Contribute object testing in database system migration from Oracle 11g to 12C
• Develop PL/SQL Packages, Procedures and Functions per Business Requirements to load data into database tables. Utilized application Life cycle management tool to track the progress of SDLC.
• Data conversion from flat file to intermediate tables using SQL*Loader and Data mapping.
• Develop Unix Shell scripts to perform a nightly refresh of the test system from production databases.
• Create documents and implement standards/modeling to monitor and enhance database capacity and performance; develop data import and export routines to automate data loading in Agile Scrum process.
• Enhance web functionality to the ADIS website with banner maintenance and traveler overstay functionality using Oracle PL/SQL on 12G R1 and Oracle BI Publisher 12c

Confidential,NY

Sr. Oracle Developer

• Designed and developed custom ETL process for Canada division to capture meeting reference and member data information for payroll process. Create staging tables, contributed writing packages using Oracle 11g and PL/SQL. Identify poorly performing SQL and did performance tuning.
• Created external tables and heavy SQL loading functions using PL/SQL and shell scripts in Linux
• Architected, Configured and Automated the batch process using sql/shell scripts and cron jobs in Linux environment. Performed file encryption using gpg and file transfers using sftp/scp protocol. Collaborated with networking team and Canadian team to fix configuration issues.
• Collaborated with offshore team for QA and project completeness.

Confidential,Dulles,VA

Sr. Oracle PL/SQL Developer

• Designed and developed Oracle Packages and SQL scripts for Prism Suite in Agile environment. Prism is the contract writing system for defense, intelligence, and civilian agencies using Oracle 12c, ASP.Net and IIS web server in Agile process.
• Trained and certified in Prism application. Developed functionalities related to SSA Vendor management, General Page description, Audit workspace and Audit workspace template. Unit/application tested several SCRs and found solutions to the issues.
• Designed and developed Oracle Packages and SQL scripts for Business Acquisition Management (BAM). Functionalities include Checklist, Checklist Routing, Attachment Routing, Follow, Print Route History, Arc Market Survey/RFI and Widgets and dashboard reports using Crystal report; used SQL to load and archive data. Utilized application Life cycle management tool to track the progress of SDLC.
• Database was upgraded from Oracle11g to Oracle12C; converted BE objects in the current build using new features such as pluggable database (PDB) in a shared environment.

Confidential,Chantilly,VA

Sr. Oracle PL/SQL Developer

• Developed Informatica mappings to move data from stage to target tables for Accenture/ Confidential client during the latter part of my project.
• As the monitoring specialist, worked during second/night shifts to monitor/process production ETL Informatica work flows using PowerCenter as Admin, and as level 2 production support.
• Handled heavy volumes of data, batch jobs, cron jobs in Unix and Oracle. Created manual procedures, provided status of daily jobs, maintained job schedules, fixed database deadlocks and improved performance as part of daily responsibilities. Created scripts for remedy tickets to reset and kill jobs to allow required jobs to be completed on time.
• After deployment, maintained schedules during database upgrade from Oracle11g to 12c.
• Developed Oracle Packages and SQL scripts for incorporating rate changes for PostalOne team. Made several enhancements to the system with ETRs, ECRs and Data repairs including performance and tuning of SQL. Performed AWR report generation; read, analyzed and suggested essential changes to SQL and database.
• Designed and developed packages for refunds of unused labels, payment of transaction fees, finalizing statements, and sending fee information via ftp/aft to government agency to fulfill SOX requirement using Oracle PL/SQL.
• Led and implemented Projects for Financial Activity Management and Interfaces divisions that include IME, CDM, CBCIS and RPW. Utilized SQL loader to load data from these systems and push/pull methods to import/export data.
• Provided Financial Activity Management reports using Oracle Application Express utilizing user interface like Page Designer, a browser-based IDE for user applications customized using Template Options.
• Developed packages and scripts for incorporating rate changes for San Mateo PostalOne team for a January 2013/2014 release on srs-834/1006. Unit tested rate changes from back-end. Responsible for Priority and Fist class mail form changes, pre-development and post-production scripts. Utilized application Life cycle management tool to track the progress of SDLC.
• Developed interface between Postal One and FIWS systems which allowed Postal One to transmit end-to-end drop ship and origin entry content data collected from Mail.dat/Mail.XML to the FIWS system.
• Utilized Oracle 10g, Unix, SQL scripts; performed AWR report generation and fixed performance issues in pre-production environment.

Confidential,Melville,NY

Oracle PL/SQL Developer

• Designed and developed Oracle packages/procedures for several clients to enhance existing functionality for direct mail and email marketing including ETL using DM Express tool, customized data processing using dynamic SQL, bulk processing, analytical functions and report build process.
• Utilized Oracle 10g/11g, SQL scripts and Appworx to schedule jobs.
• Handled large volumes of customer transaction data, control logic with Metadata, analytical functions and report build process.

Confidential,Virginia

Oracle PL/SQL Developer/ Project Support

• Involved in Data Warehouse/ETL analysis and testing for Data Quality Program using Informatica Developer, (IDQ) 9.0, Power Center Workflow Monitor/Manager and Repository Manager. Used SQL to load data into Oracle Database.
• Utilized Unix, Perl script, SQL scripts and tested UNIT Test framework for testing data quality rules.
• Coordinated with developers on code check-in and release management using ClearCase and ClearQuest. As lead on duty, worked with system test personnel on defects and supported performance team on a 24X7 basis for pre-production activities.
• As a Senior Developer Analyst, designed and developed Oracle packages and procedures for several builds for the HAMP (Home Affordable Modification Program) project including second lien cancellation and rules for unemployment program. Wrote functional specifications based on business requirement documents; developed and unit tested packages for first lien, second lien (2MP), and servicer transfer rules using Oracle PL/SQL.

Confidential,New York,NY

Lead Client Service Engineer/Project Lead

• Served as email marketing division Tech Lead for several premier and select client projects.
• Served as data resource for several export/import projects for 25+ clients.
• Performed custom ETL loading of user data into company’s database using Oracle SQL scripts, shell scripts, and push/pull data using Unix and Oracle, SQL Server and MYSQL.
• Scoped and wrote specifications for several projects related to email marketing and client business analysis; developed backend processes with SQL loader using Oracle 10g.
• Tuned SQL and enhanced performance of several Oracle database clusters. Performed file transfers from client’s ftp site to company’s internal ftp servers using Unix Shell scripting and saved 20% in outsourcing costs.

Confidential,Port Washington,NY

Project Lead/Architect

• Developed ETL Design and Package to Load the purchase order Data Mart in SQL Server 2005.
• Developed data loading scripts using MS SQL server 2005 and T-SQL. Conducted performance tuning of the database and stored procedures.
• Created scripts and scheduled jobs using MS SQL server 2005; generated ad hoc reports using Transact SQL and BO crystal Reports 8.2; administered Business Objects.
• Developed and automated ETL process using DTS and SSIS provided flat files such as master site data information for SAP BI system. Automated and scheduled several SQL jobs.
• Served as backup to SQL DBA; performed all administrative functions.
• Developed backend processes for GERS project using SQL, PL/SQL and Oracle 10G
• Create analytical reports (i.e. Cubes).

Confidential,Stamford, CT

Consultant/Sr. Oracle PL/SQL Developer

• Automated and developed process to generate US Treasury bond and fixed income information from ETL batch.
• Redesigned the search process and recommended data warehouse features of Oracle 9i. Rewrote CDR search tool process using table functions and materialized views. This process searches bond information with various search criteria using Oracle 10g /PLSQL.
• Tuned several SQL queries, created and scheduled materialized views and replicated data using Oracle Data Guard. Utilized RMAN.

Confidential,New York,NY

Consultant/Sr. Oracle PL/SQL Developer

• Developed International portfolio loading (IPF) process using Oracle 9i, PL/SQL. Portfolios are currency stream of security purchases (inflows) and sales (outflows) that change over a period. International portfolio flows (IPFs) are streams of cross-national or cross-market purchases and sales. This project publishes PAH (Portfolio Asset Holding).
• Worked with fixed income products such as Municipal bonds and corporate bonds.
• Analyzed data partitioning algorithm and helped implement Oracle partitioning on Cash transaction tables.

Confidential,New York,NY

Consultant/Lead Oracle and UNIX Developer

• Developed and implemented SOA reconciliation process using Oracle PL/SQL and Shell scripting in Solaris Unix and Oracle 8i. This process synchronizes data of five secondary servers with a primary server.
• Developed routing test cases using Oracle 9i utilizing PL/SQL, packages and procedures.
• Reports were enhanced using APEX Version 2.1.