• Developed changes and created new functionality for Pentrax(Pension Tracking System) in Oracle APEX 4.2.These changes included changing datatypes in database, modifying and re-creating PL/SQL packages, as well as modifications to existing APEX pages, and creation of new ones. Changes involved modifications of interactive reports , adding and deleting charts and maps.Senior Developer for Pentrax 2.0 changes, including adding functionality to delete Acquiring Institutions, deleting duplicated Institutions, deleting multiple pension participants from an existing plan. These changes were created in APEX 4,2, handling processing on backend using PL/SQL packages, functions and procedures.• Tested functionality of multiple applications in APEX 5.1.1, including Pentrax app, SMART, BOLD RPT, and AWSM. This testing was in anticipation of upgrade from APEX 4.2 to APEX 5.1.1.Assisted in development of regression testing for Pentrax and other APEX applications.

• Redesigned Greenplum PL/SQL functions to produce Rate reports for GTR Billing for Canadian provinces and territories to reflect changed rules for report gathering and to reflect 10 new additional Canadian provinces and territories to be covered.Redesigned Greenplum PL/SQL function to produce Rate reports for GTR Billing for Canadian provinces and territories to reflect changed rules for report gathering and to reflect 10 new additional Canadian provinces and territories to be covered.• Worked with Team Lead to convert logic of main report calling function in Greenplum to work with redesigned report types (Credit, Rates, Equity, FX, Commodity). Also implemented new functionality to incorporate more data availability for Substantiation Reports and Exception Reports.

• Designed and wrote Oracle PL/SQL packages, procedures and functions for payroll extract in the HR module of EBS for FlowServe employees in France and England. These extracts were designed to conform to ADP Europe specifications, to run daily (after an initial extract), were encrypted using BizTalk encryption keys and transported to the ADP payroll vendor. These scripts were built for use in Oracle EBS HR app for concurrent programs, and for stand-alone ad hoc execution. • Performed data cleanup tasks for various tickets in the GEMS database pertaining to data leaks populating unused fields in the database. Tickets had to be created, migrated thru the Stat ticketing system, required code review, testing, creation of backup tables and migration to production environment.• Performed troubleshooting of Oracle PL/SQL generic errors when unhandled exceptions made their way thru various Oracle packages within the EBS environment, such as WHEN OTHERS errors and fixed issues resulting from this.

Set up and configured QA environment for Smart Connect 2013 and 2014. Built new Smart Connect integrations supporting new business, which accessed new databases and which were then migrated to production environment. • Modified existing integrations for changes in source data, involving re-writing and re-deployment of SQL queries to fit new requirements for TLPro, EALPro, and Atlas POS systems. • Set up and configured QA environment for Scribe 7.0.2 integration tool to work with QA source and target databases. • Troubleshot integrations issues with both Scribe and Smart Connect production integration tools and worked closely with accounting team to resolve integrations issues into Great Plains target databases. • Built workaround solutions using SQL Server stored procedures and functions to solve integrations issues that would work around support issues resulting from Scribe integration tool and managed staging table data so that duplicate deposit and receipts information did not reach the Great Plains destination databases. • Worked closely with cash accounting team to resolve daily integration errors and ensure that all data was properly loaded into Great Plains databases.• Supported conversion of Scribe integrations into Smart Connect and Informatica integrations. Managed daily integrations of Smart Connect once these were implemented. • Set up and supported APEX application using TMX Oracle database back end, which incorporated Classic Reports, Interactive Reports, Master/Detail, and Form and Report types for accounting end user teams. Developed PL/SQL packages to handle processing on the backend. Also assisted users in learning the capabilities of this reporting tool for use with month-end rollup reporting.

• Converted existing reports from old format to APEX 4.0 reports, using new modernized database for customer call data.• Managed continuing effort to build ad hoc reports for customers using Oracle 11g databases and Toad 11.x, sqlplus, PL/SQL, and APEX. Many of these reports were automated in linux environment using mail or sftp tools and delivered in either csv, xlsx, or Adobe Acrobat format and scheduled using cron. • Supported and Validated MySQL activities as backup to MySQL DBA.

Performing analysis and cleanup of SQL Server stored procedures to reformulate calculation of PO numbers, and scrub user data derived from multiple data sources.• Managing standardization of data for ETL from several new sources into expanded corporate data warehouse, for use for reporting purposes.• Mapping new data sources to existing Data Mart for expanded Data Warehousing capabilities.

Modified or redesigned Korn shell scripts to read large flat files from vendors and credit bureaus into databases (Oracle) or data warehouse (Netezza) in a Linux or UNIX AIX environment. Built C programs for the purpose of validating flat files and manipulating files and extracting portions of large flat files. Designed views and tables for use of the business. Changed or re-created SQL*Loader ctl files. Collaborated with Business Systems Analysts and business SMEs to design and build solutions to mine new business from Data Warehouse. Unix Linux shell scripting Oracle 11i 11g

Developed Reports for Asset Reconciliation and Collateral System (ARC) using Developer 2000 and PL/SQL from 11i database. Designed ad hoc reporting capabilities from Oracle 11i database and MS SQL Server using Crystal Reports, MS Excel, and MS Access 2002 for decision support systems in support of ARC system.

Ocular OCS

Technical Team Lead - Senior PL/SQL Developer.