George Fouhy

PO Box **

Crompond, NY *****

914-***-****

ad4icq@r.postjobfree.com

These are some of my professional projects:

Converted corporate reporting system from Access to SQL Server Reporting Services at Castle Oil. Also checked for orphaned records in database tables. Accounts receivable errors were rolled up in reports and checked by AR staff.

Replaced legacy DOS invoicing system with a .NET application at Castle OIL. The new application also emailed Invoices to customers and imported the DOS flat file invoice into SQL Server. Customer email addresses were validated in the app and stored in a database table and monitored, returned emails and undeliverable faxes were checked and monitored and cleansed by Billing Department staff. No new equipment needed at Castle.

Created SQL Server Integrated Services package that used FTP to pull oil prices stored in a flat file on a server in London, imported the prices into a database at Castle Oil. The price information was then sent to the appropriate employees by subscription in Report Services. This was done every weekday at 7pm. All data captured from the London Server was automatically analyzed, cleansed and stored in database tables. Data integrity was checked daily and also searched for orphaned records. Saved Castle about $35,000.

ColdFusion Web development at Pace University. (Five Years)

ColdFusion, JavaScript, JQuery, ASP for NACTEL web site at Pace University.

Set up automated system for online course posting at Pace University i.e. course schedule entered in database table by course advisors, then this information was selected from the table by the web page.

Created a stored procedure that did the work of a student advisor. It selected the student’s program then displayed the courses that the student has passed. Then selected the courses required to finish that program. Calculated the number of credits passed the number required. Displayed the courses the courses in a web page showed courses passed courses left to take and determined when the course will be scheduled again at Pace University’s NACTEL program. Saved hours of work for Student Advisors.

Student information for bachelor’s degree students had to be modified to include the school year and semester the course was taken because this information was not originally needed since the school only granted associates degrees in telecommunications. This information was needed to determine what courses were required for a BS degree when the student entered the program. Course requirements changed each year.

Created a Point-of-Sale program for black top at Peckham Industries. All data was verified at the application level. Brought the Point-of-Sale program in house.

Imported personnel information i.e. work experience for applicants from an Access program to SQL Server at Personnel Systems.

Setup SSRS at Castle Oil and Pace University.

Created reports in SSRS at Castle Oil

Created reports in SSRS at Helen Hayes Hospital.

EDUCATION

Pace University, Master of Science, Computer Science, June 1998

TECHNICAL SKILLS

Programming Languages - Visual Basic, .Net, C#, C++, Pascal, Delphi, HTML

Applications – MS Office, Crystal Reports, ColdFusion, Dreamweaver, .Net, SSRS, SSIS, HTML, SAS, JQuery, JavaScript, ASP

Databases - SQL Server, Access, Paradox, Oracle, MySQL

Helen Hayes Hospital, West Haverstraw, NY (2019 – 2020)

Report Writer (SSRS)

Write Queries, Procedures, Triggers, etc.

Extract data from Excel spreadsheets

SUNY Orange, Middletown, NY (Fall 2018)

Adjunct Teacher

Database Administration

MySQL

Castle Oil Corp. Harrison, NY

Database Administrator (2012 – 2016)

Administrator for several databases. Monitor database activity using query analyzer.

Write Queries, Procedures, Triggers, etc.

SQL Server Database Tuning.

Set up SQL Server Report Server.

Setup SSRS and create reports, Business Intelligence.

Import Data using SSIS.

Update legacy Access applications to .Net.

Pace University, White Plains, NY

Data Analyst (August 2007 – 2012)

Design Web Applications, ASP, ColdFusion

Upgrade from ColdFusion MX to ColdFusion 8

SQL Server database Queries, Stored Procedures, Jobs

Upgrade from SQL server 2000 to SQL Server 2008

Setup and Create Reports for SQL Server Report Server

Imports and Exports using SSIS

Familiar with Banner and Oracle database queries

Personnel Systems Inc., Pomona, NY

Consultant (2006 – 2007)

Design an Applicant Tracking System in VB

Design SQL Server Database based on existing Access Database

Design new Stored Procedures, tables and database maintenance procedures

Export Access data to new SQL tables

Scheduled database jobs for backups

Design Web Applications, ASP, Coldfusion

Peckham Industries, White Plains, NY

Applications Programmer (2000 –2006)

Design client server applications using Visual Basic and SQL Server 2000

Design and implement Database Applications.

Database Administration, SQL Stored Procedures, Triggers, VB Scripts, Import - Export DTS scripts, Job Scheduling, Database Backups, Database Security, User Defined Functions, Views, T-SQL, Performance Tuning

Create Crystal Reports for each application

Iona College, New Rochelle, NY

Technical Analyst (June 1999 – July 2000)

Designed and developed applications for the Student Financial Services office

Maintained Student Billing Application, written in Access.

Year 2K testing with the Department of Education

Technical training and support for Student Financial Services Staff

PeopleSoft support for end users

* PeopleSoft training: PeopleSoft Student Financials

PeopleSoft Query and Crystal Reports

Touchstone Applied Science Associates (TASA), Brewster, NY

Applications Developer (1998 -1999)

Design and develop Paradox Database application using Delphi

Designed and wrote code for “DRP Booklink”, an Application used to search a book database and produce reports

Westchester Community College, Valhalla NY

Adjunct Professor, Computer Information Systems (Jan. 1999 – 2000)

References available upon request

Contact this candidate