Programmer Analyst Resume

PROFESSIONAL EXPERIENCE

Confidential

Programmer Analyst

Responsibilities:

Migrated MS Access 2010 Accounting System to MS Access 2016. Required updates to data types and api libraries.
Migrated MS Access 2010 Compliance Applicaiton to SQL server back end.
Supported a Dozen Accounting Reconciliation Systems Written in MS Access VBA with over 35 Gig of data and backend data connections to Oracle and MS SQL Server repositories.
Supported MS Excel 2010 VBA macros used to generate reports and journals used in the Accounting Reconciliation Processes.
Initiated the Documentation of the MS Access systems.
Created Load for migration of Accounting Systems to Oracle.

Confidential

Programmer Analyst

Responsibilities:

Upgraded Excel 2010 Bid sheet, Container Management Sheets and Purchase Order sheets
Implemented data validation to streamline downstream processing.
Automated SKU data downloads from DB2 database on AS400 machine
Created Notification system to confirm successful download of data and audit outputs.

Confidential

Programmer Analyst

Responsibilities:

Administered intranet SharePoint 2007 site in both content (documents and applications) and availability
Supported VB 6 daily reporting creation and distribution.
Managed the Nursing Annual Mandatory testing website which included uploading test content.
Created SQL server ad hoc reports using DSN less connections within Excel spreadsheet.
Create Stored Procedure, Triggers, and Functions in SQL server
Created MS Access custom menu ribbons for reporting features.
Created Excel Ad Hoc reporting sheet using parameterized data input(ActiveX) and VBA coding for DSN less connections to patient data.