tom hoye

Working with the Business Intelligence group and senior business analysts in Boston. Database research and design using Oracle and IBM Netezza data warehouses.

We are Information Systems Architects, specializing in information systems and relational database design and development. Our most unique and valuable trait is that we strive to fully and completely understand the existing problem and the customers needs before a single line of code is written.

Supports SHARES and ESS business systems performing the modification and execution of various stored procedures, modification of existing screens/reports/programs, application of manual data updates and researching issues raised by the business unit. Extensive direct user contact and troubleshooting.

Designed and implemented a new information system for the Business Intelligence manager at ECCO in Londonderry, NH. for use in national sales planning and forecasting.

* Created and modified Crystal Reports on claims and provider data for the Business Intelligence Group * Created and modified SQL stored procedures * Created SQL ad-hoc extracts of provider and claims data * Systems Analysis, Requirements Definition, SQL Server 2005, SQL Server Management Studio, Crystal Reports 10.0, T-SQL, MS Excel, Stored Procedures

Designed, developed and implemented a Patient Tracking System for a private Social Work practice. This system enabled the principal to track client contact, insurance and scheduling information efficiently. Systems Analysis, Requirements Definition, SQL Server 2008, VB.Net, Data Modeling, SSRS, Visual Studio, Project Management, IT/Business Liaison, HTML, SQL, JavaScript.

* Recruited as a senior consultant to perform the conversion and updating of an existing sales tool used by their advertising sales staff. Duties included the analysis of existing system and proposal/definition of new version. * Key Achievements * Converted and customized NYNEX Yellow Pages Advertising System from PenPal to Visual Basic/Access. * Made significant enhancements to the functionality of this system including the implementation of a relational database as its data repository. * Systems Analysis, Visual Basic, Access,SQL, Crystal Reports, Project Leadership, Data Modeling.

* Hired to design and develop an online course registration system for regional school districts. This project required extensive stakeholder contact during requirements definition and approval phases. * Key Achievements: * Designed and created a relational database to hold regional school registration data. * Designed, developed and implemented an online system for regional school systems to maintain course offerings and managed their enrollment and registration details. * Systems Analysis, Requirements Definition, VAX, Cobol, FMS, Rdb, SQL, Data Modeling, Project Management.

Investigated, planned and made major changes to Archdiocese of Boston Payroll system from tape-to-tape to CICS. Developed and implemented a distributed offsite front end processing system for Diocesan payroll, Retirement, Accounts Receivable and Payables and Physical Plant maintenance systems. Projects completed using Mainframe Cobol, CICS, VSAM, Four-Phase, Four-Phase Assembler.

Designed and executed database and programming changes to an eBusiness merchants website enabling the business to expand their product line. Systems Analysis, Requirements Definition, SQL Server, ASP.Net, Data Modeling, Visual Studio, Project Management, IT/Business Liaison, HTML, SQL, JavaScript.

Modify SQL Stored Procedures to streamline and enhance processing, created and modified numerous SQL scripts for data manipulation and production processing and enhanced and created SSIS procedures.

Initiated process of migrating Oracle tables to SQL Server using SSIS for Business Intelligence/Analytics Reporting for the Finance Department. Created first SSIS packages for the Oracle-to-SQL migration.

* Recruited to participate in the creation and implementation of numerous information systems for multiple Digital sites. Functioned as Senior Consultant and Project Leader on multiple projects during this tenure requiring Business Systems Analysis, Project Management, Requirements Definition, systems design & development and user training. * Key Achievements: * Designed, developed and implemented an Employee & Equipment Tracking System for Digital Security Department. This system was subsequently modified for use in numerous other Digital sites. * Developed a parts and service tracking system for Digital Field Service Logistics Departments worldwide. * Developed an Accounts Receivable/Payable system to specification. * Developed the Channels Business System which provided tracking of sales information including performance of various distribution channels. * Systems Analysis, VAX, Cobol, FMS, IT/Business Liaison, Data Modeling,SQL, Project Management & Leadership.

Made modifications and upgrades to the Student Tracking & Reporting System to specification using Mainframe Cobol, CICS and VSAM files.

Developed a Patient Acuity System for the Nursing Department to allow the department to anticipate nursing personnel requirements by hospital area using Mainframe PL1, CICS and VSAM.

* As lead SSIS developer designed, developed and modified packages for data loading for 2 major clients * Created and optimized SQL scripts and stored procedures * Trained and mentored staff in SSIS and SQL programming * Designed and implemented database changes for more efficient processing of data * Modified numerous PL/SQL scripts and procedures ; * SQL Server 2005, ETL, Data Analysis, Business Analysis, Database Design, T- SQL, , PL/SQL, SSIS, SQL Server Management Studio, Visual Studio, XML, Vault, Oracle 11g ;

* Served as Project Manager for the Logistics Software Development group where my primary function was to manage the analysis, definition, design and development of an Available-to-Promise module for their Distribution Software Suite. My responsibilities for this position included defining project scope, individual programmer specifications and supervision, programming and testing. * Key Achievements * Managed the conversion of Ross' Inventory Control System for VAX Rdb relational database. * Managed the conversion of an Available-to-Promise module in the Inventory Control System to VAX Rdb technology. * Initiated and managed a project to develop a Windows version of Ross' Inventory Control System using Visual Basic and Access. * Initiated and managed a project to develop a Windows version of Ross' Inventory Control System using MicroFocus Cobol and Access. * Systems Analysis, Requirements Definition, Project Management & Leadership, VAX, Visual Basic, Access, Data Modeling, Rdb, SQL, MicroFocus Cobol.

Former Senior Data Analyst / Business Intelligence at Liberty Mutual Insurance