George Fouhy
PO Box **
Crompond, NY *****
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