Project work for a healthcare billing company configuring and administering a cloud based SQL Server 2017 environment, defining database objects (databases, tables, views, indexes, stored procedures), implementing FileStream functionality, creating SQL Server Integration Services (SSIS) ETL processes to extract data from Salesforce based Claim Vantage vendor database to populate internal database tables, analyzing data, gathering requirements to develop ad-hoc queries for internal use and external clients, creating interactive reports via SQL Server Reporting Services (SSRS) for external client web access, conversion of SQL Server Reporting Services from windows integrated security to forms based authentication implementation. Use of SQL Server Management Studio plan execution monitoring tools for performance tuning and query optimization. Automate ETL processes via SQL Server Agent jobs. Created ASP.net web forms applications for external client internet access to reporting and portal application including reporting access and file upload/download to SQL Server FileStream database, both web sites implementing forms based authentication.

Contract work for a healthcare billing company installing, configuring and administering an SQL Server 2017 environment, restoring a vendor database, analyzing data, gathering requirements to develop ad-hoc queries, and creating interactive reports via SQL Server Reporting Services (SSRS) and ETL processes via SQL Server Integration Services (SSIS).

Major enhancements and modifications to online tax collection / tracking system using VisualAge Generator on IBM iSeries AS400. Analysis, coding and implementation of new tax law calculations, modifications and corrections to existing tax calculations and external government agency interfaces, and general system maintenance and support. Migration from VisualAge Generator to Rational Business Developer EGL.

Employee with the Global Human Resources Archive group extracting employee data from diverse application/platform database environments to satisfy individual and mass requests for the legal, audit, payroll and human resources departments within a strict SLA timeframe. Worked with the DBA’s to define developer roles with the necessary privileges to create and modify relational database objects. Created multiple complex SQL queries to extract data from the Taleo Staffing application Oracle database (500+ tables) based on client requirements emulating the reports produced by the vendor package. Worked closely with client and vendor representatives acting as liaison to define report requirements and database SQL queries implemented within Business Intelligence Tools such as Cognos and OBI. Created additional complex SQL queries involving JOINs of up to twenty relational database tables with multiple nesting of subqueries and dynamic tables. Defined, normalized, loaded and tuned relational mainframe and server based database tables to hold external vendor application data. Execute, maintain and enhance ETL packages via SQL Server Integration Services (SSIS). Subject Matter Expert for support and enhancement of Timekeeping and Payroll Benefits Escalation Tool requiring modification to web-based .NET applications (MVC architecture), SQL Server stored procedures, SSIS ETL jobs and classic ASP. Managed code file storage and versioning using Team Foundation Server and replication and deployment across dev, UAT, production and staging environments via RepliWeb software.

Contractor with the Global Human Resources Archive group using data analytic and data modeling skills to define, create and load Oracle, MS SQL Server and DB2 database tables/objects, and writing SQL to extract data from server based application databases (Taleo Staffing and Performance Reviews, Oracle HRMS, PeopleSoft HR and payroll) using effective dated logic and mainframe DB2 databases. Created and loaded normalized database tables based on analysis of data existing in flat files and payroll/human resource expertise. Worked with outside recruiting and staffing vendors to bring externally housed talent acquisition and ATS data into the GHR Archive databases at contract termination. This included creating database objects, using SQL/PL, SQL queries and UNIX SSH Tectia shell commands and file transfer for loading and extracting documents in various formats (.doc, .pdf, .html, etc.) defined to the database as large object data types (LOB, CLOB). Created and executed SQL to extract individual and mass data in support of legal, audit, HR and payroll requests. Responsible for defining Bank of America B2B platform data transmission service (DTS) requests via SFTP protocol and secure mailbox access.

Performed migration of Family Court application from IBM VisualAge Generator 4GL to IBM Rational Business Developer EGL. Tasks included business analysis, install and configure RBD development environment, install / validate mainframe runtime component, install and configure DB2 UDB database, code extraction and conversion from VisualAge Generator environment, EGL code packaging, EGL code remediation and generation, and system validation.

Consultant with the Payroll/Human Resources department working as project leader, technical lead, systems analyst, database designer, business analyst, mentor/advisor, instructor and programmer to install, customize, enhance, implement, maintain and support the Integral Systems Payroll package and Payroll Self Service intranet applications. - Recently performed upgrade of online Integral system to IBM Rational Business Developer EGL from deprecated IBM VisualAge Generator 4GL. - Main contact for payroll history data extracts to respond to federal, state and local tax entity audits and upper management data requests. - Project leader, analyst, programmer and workstation software administrator to design, develop, implement, support and enhance a web-based application for employees to view and print, current and prior paystubs using IBM VisualAge Generator, Java Server Pages and Servlets, HTML, JavaScript, Websphere Application Server, CICS Transaction Gateway, ORACLE DB, and mainframe DB2 and CICS. - Developer on web-based (internet/intranet) HR onboarding application for new hires to complete and submit required forms to Merrill Lynch HR Service Center using Java Server Pages and Servlets, HTML forms, JavaScript and Java classes accessing an ORACLE database via JDBC. - Participated in Fit Gap Analysis, vendor evaluation, specification review for Oracle HR/Payroll. - Participated in Fit Gap Analysis sessions to implement the web-based version of PeopleSoft HRMS and PeopleSoft North American Payroll, functional and technical specification writing, customized existing screens and created new screens with PeopleCode using PeopleTools Application Designer. - Performed on-going design, enhancement, maintenance, and support of Employee Payroll Self Service intranet web applcation using Edify Workforce software. - Conducted technical interviews for prospective employees and consultants