North Carolina Software Support

 

Business Analyst Drew Eccles
Summary of Experience Applications

15+ years of ATM related conversion work and have also been involved in over 20 banking acquisitions.

Major strengths

• Business Requirements Definition
• Business Process Analysis
• Project Management
• Technical Specifications
• Test Case Development and Reporting

Fidelity IMPACS (IM)
Fidelity Savings Time (ST)
Card Systems 

Tools, Systems, Platforms/Utilities/Programming Languages

Cobol ZOS EZTRIEVE
CICS JCL ENDEVOR
VSAM OS SYNCSORT
PVCS VB6 Microstrategy
Informatica    
Assignment Start End  Client Site

Business Analyst

07/08 11/08 Citizens Bank
  • Business Systems Analyst supporting divestiture activities for CV Card Applications.
  • Duties included analysis of the business requirements necessary for divestiture, documenting requirements through research and fact-finding activity & translating this information into an Approach Document for the CV application divestiture.
  • Responsible for creating report mock-ups and report specs for the developers.
  • Coordination and support of testing region file population build out of divested accounts for cycle testing and Mock activities.
  • Provide Adhoc reporting as required using EzTrieve Plus. 
  • First line of validation of outgoing Mainframe/PC files & reports to the acquiring bank.  .
  • Facilitator of weekly ATM Meetings reviewing agenda items, action items with the business line and technical staff. 

Business Analyst

10/07 07/08 RBC Centura Bank
  • Business Systems Analyst for Web Banking, CMS & Credit Card applications defining systems scope & objectives based on the user’s needs for conversion related activities.
  • Duties include analysis of the business needs and documenting requirements through research and fact-finding & translating this information into systems requirements specifications. 
  • Activities also include participation in data mapping, user acceptance testing and implementation of information systems.
  • Provided detailed Adhoc reporting to the business line utilizing EzTrieve Plus.
  • Provides technical & user support for IBM Mainframe & PC application software platforms.

Business Analyst

11/06 10/07 IBM Corp.
  • Completed analysis on 40+ Mainframe online programs written in CA-UFO (User Files Online) and prepared associated Analysis and Design documents for these programs to be re-written in native CICS by an offshore team in India.
  • Created the test scripts needed for testing the new CICS screens for the offshore team along with providing technical assistance on an “as needed” basis.
  • Currently working as a sub-contractor to IBM Corporation thru CIBER, Inc., supporting the following applications which were outsourced from CVS to IBM Manila: CVS HR & Payroll, Accounts Payable Sub-system, and Time Input Management.  Also responsible for providing KT (Knowledge Transfer) to other IBM resource(s) for secondary production support functions. 

Business Analyst

06/06 11/06 Citizens Bank - RI
  • Involved with an analysis review on the main processing component for the bank’s ATM Card processing program.  This program contains three major components: Daily Card Create, Emergency Card Processing & the Monthly Re-Issue Process. 
  • As part of a system tuning initiative, this process was identified & targeted for a rewrite of the program due to the volume of data it processes, the number of runs and a desire to streamline redundant common processes.  My tasks for this effort include writing the Technical Design Documents for the steps necessary to split off all of the reporting pieces into separate modules that will be called from a new primary processing program.  
  • Reviewing the existing documentation for the MA System Run Book and comparing existing documentation against the production libraries, procs, jobs, etc and updating the documentation as needed. 

Technical Analyst

07/04 10/05 Citizens Bank, RI
  • Providing the following support for the Charter One Bank conversion acquisition effort: Provided support for Citizen’s ATM & MA (Merger Acquisition) applications.  I wrote the conversion program to handle the in-flight transactions file from Charter One Bank for Phases 1 thru 4, which needed to be re-formatted from a Stratus file format to a Concord file format which is what Citizens uses for their nightly batch processes for posting ATM activity.  These files contain in excess of $8 million dollars of ATM card/Debit card transactions which needed to be properly debited /credited to converted customers accounts. 
  • In addition, I updated the banks on-line CICS application to include new bank numbers/regions for the acquisition.  I am also involved in executing test scripts for ATM testing of new cards for each phase of the conversion task.  I am also called upon for giving direction to other contractors here on-site from other agencies and acting liaison to Charter One Bank contacts for ATM related tasks/issues.
  • Responsible for updating / creating documentation for enhancements and provide technical support / on-call rotation duties for nightly batch processes & testing cycles for conversion.

IS Engineer

05/01 12/03 CVS Pharmacy
  • PVCS Administrator/Configuration Mgmt for Corporate Real Estate & Treasury System.
  • MicroStrategy Administrator/Developer for Corporate Systems.
  • Informatica PowerMart/PowerCenter 5 & 6 (ETL) Developer.
  • Project Manager/Coordinator for SunGard’s Treasury Workstation implementation & testing support.
  • Microsoft Office Tools, Microsoft VISIO (Strong documentation skills)
  • Project Manager/Coordinator for ePropertyTax software implementation.
  • Visual Basic 6 coding / packaging support for Tax application.
  • Disaster Recovery planning, documentation & implementation for Mainframe  Legacy Systems.
  • IBM Mainframe support for Real Estate/Treasury Systems Legacy Systems.
  • Provided remote dial-up support & Pager support as required for Mainframe    Systems & PVCS Admin duties.

Project lead

03/97 04/01 Price Waterhouse
FLEET Bank, RI
BOSE Corporation, MA

Senior Consultant-

  • Project Lead for Mainframe Legacy Systems Y2K effort overseeing 5 team resources and code review.
  • Project Lead for code design to create new PO numbers for an existing in-house SMEPO (Store Maintenance & Equipment Purchase Order System).  PO number field was changed from a numeric to an alphanumeric field eliminating the need for file expansions.  Code design included alphabetic character with a numeric numbering scheme.  This effort was a high-profile assignment considering the fact that this system would have run out of valid numbers within a 5 month period in which the system would have generated duplicate PO numbers.  Coding changes were made to the online-system utilizing CA’s UFO  (User Files Online) along with batch programs.  New JCL was written along with JCL enhancements.
  • Project Lead/team member for Store Number enhancement project.  Increasing internal table size for store number range from 4000 to 8499.  This effort included increasing internal tables, table indexes, testing scenarios for new store number range.
  • Acted as on-site training resource for new consultants needing acclamation to CVS environment. 

 Project Coordinator

  • Fleet Bank’s External Software Vendors for Y2K Compliance.  This assignment included responsibility of contacting the banks external software vendors to gather information ensuring Y2K software compliance for scheduled software upgrades.  These upgrades had to be orchestrated within a specific time frame due to Federal regulations.  Represented SVP (whom I reported to) at weekly Y2K meetings and presented issues at hand, findings, progress & recommendations.

 Microsoft Access Project developer

  • DB design tracking tool for BOSE Corporate Financial  Systems.  Presented weekly reviews & presentations with client staff & consulting team.

Technical Analyst

04/93 02/97 Atlantic Data Services, MA
  • Provided Mainframe support for Data Management Systems Banking Clients & their acquisitions &  conversions.
  • Created Ad-hoc reporting requests using EZTrieve Plus &COBOL coding enhancements to existing financial systems.

Technical Analyst

 01/88 03/93 BISYS, TX            Citizens Bank, RI           Canadian Imperial Bank, Canada
  • Mainframe support/COBOL coding for new Mortgage system for BISYS Corporation.  I was responsible for writing the primary reporting module and sub-modules (called routines) performing /producing various reporting levels of detail and sorting functionality in which the users could select.
  • Provided support for Bank Acquisitions & System Conversions. (DDA & Savings)
  • Provided support for ACM (Asset Card Mgmt) Conversion.
  • Testing of Plastics (Debit Cards) after Mock Conversions.
  • Provided support for Bank’s Name & Address System.
  • Provided support for Bank’s DDA Statement System.
  • Provided support for Safe Deposit System.
  • Provided Remote support of the LOC (Letter of Credit System).  DDA (Demand Deposit Accounting), Utilizing EZTrieve Plus, SYNCSORT, DB2, COBOL & CICS,.  responsible for writing testing scripts for users & setting up remote test environments.
 

Education

Available upon request

Contact Jay at (919)562-8795 Ext. #301 or e-mail Jay@ncsoftwaresupport.com