James Spinato
670 West Woods Rd
Hamden, CT 06518
(203) 287.0055
(203) 848.4462
spinatjr@att.net
Objective: To achieve a position where I can contribute my computer programming and information technology skills.
Experience:
• Microsoft Access/.Net Developer Consultant 2011-Present
Developed a consulting web site: http://www.spinsoft.biz this website targets the small business owner looking for custom software to handle his or her business functions.
I also provide freelance consulting on oDesk a website for clients looking for consultants and contractors who provide the consulting job.
• Yale University School of Medicine (Administration) 1995 – 2010 New Haven, CT
Senior Programmer/Analyst
? Developed a Microsoft Access/VB application for calculating credential statistics for Yale physicians.
? Updated MS Access applications for departments to combine information from data mining procedures.
? Created a conversion process for consolidation of Access databases and migration of data to an Oracle and SQL databases. Migrated and created SQL Server procedures using T-SQL.
? Developed and maintained a data entry and reporting application on physician malpractice insurance for the Yale Finance Department using VB6 and Microsoft Access and Excel.
? Developed and implemented web sites for Yale Medical Group (YMG) using Oracle Application Server and IIS/ASP and ASP.NET technologies.
? Supported Parking system for Howard Avenue garage. System is on a SQL Server and my responsibilities include creating reports and stored procedures.
? Supported users and applications for the Yale Medical Group including physician credentialing and billing.
? Converted a FileMaker database of Physician and credential data to an Access database. Implemented an interface to write information of a physician’s credentials to a form customized for each insurance carrier. Forms are created and maintained using Crystal Reports 10.
? Provided modifications to the Yale Child Study Access applications. Applications were modified to accommodate user requests.
? Developed a web application for displaying case information for clinicians allowing them to print selected information from Child Study databases using.
? Created a monthly upload procedure for extracting data from Child Study databases and writing it to a pre-defined DCF extract file.
? Assigned key role in conversion of Yale Medical Group’s Account Receivable application from Microsoft Access to Oracle. Conversion included using Oracle Forms and Reports for the user interface and updating Access database to Oracle 10g.
Yale University School of Medicine (Facilities) 1995 – 2010 New Haven, CT
Senior Programmer/Analyst
• Yale School of Medicine Facilities Space Inventory and Production Systems:
? Provided system analysis and project estimates for clients.
? Provided desktop configuration for client server and web applications.
? Supported Space Inventory System (An AS400 legacy application known as SIS)
Through frequent meetings with SIS users a strong rapport was developed.
From these meeting a thorough knowledge for the current and future SIS needs was acquired.
? Implemented a Crystal Reports system including a report server, scheduler and security features.
? Integrated Crystal Reports in the Space Inventory System. Created many reports with Crystal.
? Converted the “Green Screen” legacy SIS with a Windows “GUI” interface using IBM Web Sphere technology.
? Provided support for Facilities Production System – MPAC.
? Participated in conversion of MPAC to EMPAC (Enterprise web version).
? Programmed and updated PDA applications for entering work orders and updating parts inventories.
? Replaced paper forms for requesting room keys with a secure intranet application.
? Created and maintained a work order request internet application.
? Supported the Lock shop’s Key software. Applied vendor updates, set up nightly backup scripts. Integrated Crystal Reporting.
? Implemented and configured Morse Watchman Key System to provide physical distribution of room keys to authorized personnel. Duties included physical installation of key cabinet and installation of vendor software on supervisor desktops.
? Implemented and configured Kronos Time and Attendance system for Clerical and Technical personnel. Implementation included set up of Oracle database and installation of vendor application on supervisor desktops and installation and configuration of network time clocks. Attended training classes for learning how to use Kronos in a supervisory role including the creation of work rules, pay rates, overtime calculations, scheduling and customization.
Professional Pensions 1990 – 1995 New Haven, CT
Programmer/Analyst
• Developed and maintained pension and group insurance software on an AS 400 platform.
• Modified and implemented software for client 1099 and other tax forms.
• Participated in implementation of a PC Lan Network with PC desktops replacing AS400 Twin AX monitors and switching to TCP/IP protocols for AS400 communication.
• Assisted in conversion and migration of data of pension applications from the AS400 platform to a Microsoft SQL Server platform.
Jackson Newspapers 1986 – 1990 New Haven, CT
Programmer/Analyst
• Maintained and updated software for newspaper’s classified advertising database.
• Participated in conversion of general ledger system from a DEC VAX 780 to AS400 DB2.
• Supported client requests and technical assistance as needed.
• Worked with Operations in applying AS400 system updates.
Additional Experience:
Friends of the New Haven Animal Shelter (Volunteer) 2010-Present New Haven, CT
• Created and support Animal Shelter website. Site was created using ASP.Net and Visual Studio 2010.
• Set up and support online application responsible for tracking Animals, Contacts, Donations, Vet Visits.
Expertise:
Extensive Microsoft Access experience including upgrading Access databases to Oracle and Microsoft SQL.
Other technologies include Visual Basic, Crystal Reports, Oracle Forms, PLSQL, Oracle Databases, Microsoft SQL Server (T-SQL,SSRS,SSIS,SSAS), IIS, ASP.NET, AS400, RPG, CL, JavaScript, Oracle JDeveloper, Oracle APEX, IDX, XML, desktop configurations, web applications using both Oracle and IIS platforms, Microsoft ASP.NET VB/C+, Web Forms/Pages, MVC, AJAX and jQuery programming skills. I have written a prototype web application utilizing most of the features of the .NET platform; the application could be customized to provide the requirements for various applications. In addition, I have achieved excellent communication skills with clients.
Education:
University of New Haven, West Haven, CT 1974 – BS Business Administration
Southern Connecticut State University, New Haven, CT 1986 – Computer Science
References:
Furnished upon request
Salary Range: $65,000 – $80,000