SUMMARY:

• Senior Oracle PL/SQL Developer, Data warehouse Analyst and Production Support professional with over 16 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, 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, Cognos 10 Framework Manager, Visual C++ 5.0/6.0; SQL Server BI, SSIS, SSMS; MS Access, core Java /J2EE, jQuery, JavaScript, Business Objects XI, CVS, Rational Clear Case and Clear Quest, ALM and SDLC, Big Data stack including Apache, implementation of reports, cubes, and Hadoop.
• 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
• Proficient with ETL, data mart, and data warehouse concepts.
• Familiar with ERP based solutions -- Sales Analysis, Accounts Receivable, Accounts Payable, General Ledger, Warehouse Management Systems (WMS), Customer Relationship Management (CRM), etc.

PROFESSIONAL EXPERIENCE:

Confidential, Lorton, VA

Oracle PL/SQL Developer

• 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 for the new data ware house. Utilized SQL and Cognos for reporting
• Reporting using Cognos 10 Framework Manager. Cognos report design, development and testing.
• 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 and java

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. Configured AWS and developed Big Data stack including Apache and Tableau for analytics reporting.
• 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 and SME

• Developed Informatica mappings to move data from stage to target tables for Accenture/USPS 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.
• Contributed in innovation challenge with a new concept and proof of concept on random number generation using embedded programming in C++, Bigdata and Hadoop for data analytics.
• 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 from the Data warehouse using BO Crystal Reports.
• 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 in OBIE and Bigdata.

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 in a Data warehouse environment. 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, and SQL Server.
• 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 as part of Data warehouse implementation.
• 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) using Cognos.

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.

Confidential, Melville, NY

Lead Developer/Architect/Business Analyst

• Developed addendum process to track and report addendum related adjustments for invoice division using Oracle Developer 9i and Oracle 8i. Provided support to business users for their monthly reporting activities and client service procedures and accounts Receivable, Accounts Payable, General Ledger.
• Automated, scheduled and maintained several monthly recurring reports utilizing Oracle SQL and Shell scripts. Automated data processing system using VB 6.0.

Confidential, Port Washington, NY

Oracle PL/SQL Developer

• Maintained the website, on line catalog marketing web store for computer parts and office furniture.
• Production support to business users and third parties for data integration of products.
• Responsible for writing PL/SQL, stored procedures, and packages for order entry system.
• Utilized Oracle 9i as the back-end database and in Solaris Unix environment.
• Generated Shell scripts and schedule scripts in cron and ftp for the output files to the client’s ftp sites.

Confidential, Hempstead, NY

Oracle PL/SQL Developer/ Oracle Database Architect

• Analyzed, designed, developed, implemented and tested a client-server system for the network operation system utilizing Oracle 9i, SQL scripts, Shell scripts, Oracle report writer 6i in AIX Unix operating system.
• Developed and implemented Intranet web reports utilizing Oracle * Report Writer 6i, Oracle 9i and PL/SQL in AIX Unix and Perl. Reporting in webfocus and db2 environment.

Confidential, Jersey City, NJ

Consultant / Oracle PL/SQL Developer

• Analyzed, developed, implemented and tested a client-server system. Developed and QA tested the Revoke Consent process utilizing Oracle 8i and PL/SQL in Solaris Unix.

Confidential, Melville, NY

Senior Programmer Analyst

• Wrote the Merchant Processing Application using PL/SQL stored procedures. Designed, developed, implemented and tested a client-server system.

Confidential, New York, NY

Programmer Analyst

• Responsible for design, development and implementation of editorial cost tracking system that kept track of the editorial Cost of a magazine in both NT and UNIX platforms.
• Responsible for all aspects of project management.
• Created comprehensive management reports like Aging and Write-off reports using SQL, PL/SQL and Crystal Reports 6.0 resulting in 30% savings to the company.
• Project Lead for the editorial cost tracking system, front-end screen design, and code conversion from Centura SQL Gupta to Visual C++ 5.0. Managed and distributed tasks to the development team using MS Project.
• Designed a relational database model for system using Oracle 7.3 database. Maintained and modified the system, resulting in a 25% savings in magazine distribution. Wrote stored procedures, packages and triggers