Experience

Infotek Consulting Inc.

• Canada
• IT Services and IT Consulting
• 1 - 100 Employee

• Analyst TD Bank

  • Aug 2014 - Present



LiquidHub

• United States
• IT Services and IT Consulting
• 300 - 400 Employee

• Associate

  • Oct 2017 - Oct 2017

  MS Access Development of Financial Applications MS Access Development of Financial Applications



Tyco

• Ireland
• Security and Investigations
• 700 & Above Employee

• Consulting Project Manager

  • Apr 2014 - Aug 2014



CAI

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Microsoft Access Consultant

  • Jan 2014 - Feb 2014

  Conversion of Applications at Air Products in Allentown pa. Conversion of Applications at Air Products in Allentown pa.



Paragon

• United States
• IT Services and IT Consulting
• 500 - 600 Employee

• Consultant

  • Aug 2013 - Dec 2013

  Application Developer at Merck Vaccine Division. Supported Vaccine Pricing Systems. Application Developer at Merck Vaccine Division. Supported Vaccine Pricing Systems.



PHH Mortgage

• United States
• Financial Services
• 700 & Above Employee

• Project Lead - Reporting - Access based Systems

  • Sep 2008 - Jun 2013

  PHH September 2008 to June 2013 Project Lead/ Lead MS Access Application Developer Served as the Project Lead Developer supporting development projects for 14 Applications performing the following Functions: - Business Analysis - Project Management - Technical Lead, Responsible for overall approach to the application design. - Database security and Development of Admin level Reporting and Maintenance functionality - Development of Scheduled Overnight Reporting and download procedures. - Development of VBA Code Modules - Data Validation and Standardization - Beta and Regression Testing PHH PROJECTS INCLUDE: - STARS Team - PRUW Database Developed MS Access application for managing STARS Project Underwriting data and reporting on over 7000 mortgages. STARS Team – STARS Appraisal Data Developed MS Access application for managing STARS Appraisal Data to provide individual State level Reporting for Appraisal Management. Repurchase Indemnification Database Developed MS Access application for Tracking, Managing status and providing reporting on over 100 Billion dollars in Mortgages. These loans include those which have Repurchase or Indemnification Requests from current investors Productivity Reporting Applications in MS Access Developed three applications for Productivity Reporting: Master Securities Forward Transaction Agreement (MSFTA) The Decision Analyzer determined eligibility of Residential Mortgages for Secondary or Interim Funding Solutions. The MS Access rule based Application managed over 1.5 Billion Dollars in I Interim Financing solutions for the Residential Mortgage Market. Responsibilities include: Gathering, Specification Development, System Analysis and Design, Technical Lead, Development. Legal Portal - Implemented improvements to the Hyperion Legal Portal Reporting system.



Merck

• United States
• Pharmaceutical Manufacturing
• 700 & Above Employee

• Senior System Analyst

  • Jan 2001 - Apr 2006

  CDP Sharepoint Portal System: • Served as a member of the Design team. • Partnered with Team members to gather Functional Requirements and assist in implementation of a Sharepoint Portal Environment to support ten unique business Areas within the Clinical Development Area. Financial Planning Systems - CDP Resource Planning System: MS Access based System for Project Resource and Budget Planning for all Phase 4 Clinical Trials. • Partnered with Business Team members to gather Functional Requirements. • Defined process flow documents. • Developed Specification Documents and Use Cases in accordance with Company Systems Lifecycle Standards • Defined and implemented process improvements to MS Access code. The resulting impact was that regeneration was reduced from a three-hour process to a 15-minute process. This modification allowed RPS to become a more interactive and effective planning tool. Approximately 15 man-hours were saved on a weekly basis. • Implemented MS Access import/export features. • Coordinated with Desk Side Support to develop Win-install to standardize RPS Upgrades. • Developed Project plan to manage time line. • Implemented 27 major reporting enhancements. • Updated User Documentation and provided user training. • Served as key technical support. Executive Reporting Systems Project: Generation of Executive Summary Reports to manage Clinical Resource Time and budgets. Interfaced with Managers to define IS Resource Requirements Forecasts. Monitored Plan vs. Actual Resource and Budget Utilization. Reports were available in a variety of formats including Cognos, Brio and Sharepoint team sites. • Developed Functional Requirements and Technical Design Documents in accordance with Company Systems Lifecycle Standards. • Served as administrator. • Developed SQL and Cognos Queries and Reports. • Developed Sharepoint site. • Developed and implemented a formal Test Plan and Test Scripts.