|
|
1234567891011121314151617
Resume 17
Jay Hilton
Cincinnatus, NY
SUMMARY
Broad experience in a wide variety of computing environments and businesses. Extensive academic and practical hands on experience. Professional, dedicated, competent.
SKILLS
Hardware
PC Compatible
Operating Systems
Win 2000, WinNT 3.51/4.0, Win95/98, Windows for Workgroups v3.11
Programming Environments
Visual Interdev 6.0, HTML, XML, VBScript, Javascript
Visual FoxPro v3/v5/v6, FoxPro for Windows v2.6,
FoxPro for DOS v2.6, Clipper v5.2
[ Also: JAVA, Oracle, Access, VBA ]
Related Tools and Apps
Crystal Reports Professional v5.0/6.0
Blinker v4.1, FiveWin v1.9.2, COMIX v3, dClip v3.5
WORK HISTORY
Vental & Co., L.L.C., New York, NY 7/2001-4/2002
Senior Programmer/analyst
- Maintain online survey system for annual Compliance Questionnaire: Visual Interdev 6.0, HTML, VBScript, JavaScript, XML, SQL Server, ODBC
- Design and develop systems to facilitate several annual marketing contests: VFP, Access, SQL Server, Sybase, ODBC.
- Create specifications using the Rational Rose Suite. Primarily created Vision Document and System Requirements Specification
- Adhoc queries of data using SQL against combinations VFP, SQL Server, Access and Sybase databases.
- Maintain, operate and enhance the company s main reporting system. Design and create a interface to facilitate report creation. VFP
- Data transformation between various databases and output file formats. Primarily this involved creating spreadsheets, fixed length test files, or comma delimited files that could be read by others. Examples of this are the Bluesheet system, PAM Fees, SELECT Fees, Money Manager Fees. VFP
- Create reports against existing VFP datasets. VFP 6.0.
- Query Sybase dataset and format results for users or for import into VFP tables.
- Program using Gruntal corporate standards and consistently with the standard framework.
- All programs must integrate with the existing in-house systems.
Internetwork, Inc., New York, NY 3/2000-6/2001
Consultant
Assignment: Consultant to
Vental & Co., L.L.C.
New York, NY
- Web Development using Visual Interdev 6.0, HTML, VBScript, JavaScript, XML
- Numerous VFP Reports created/enhanced.
- Numerous VFP interfaces against VFP/SQL Server/Sybase databases.
- Data manipulation using SQL directly against VFP/SQL Server databases.
- Transfer an existing Access database to Outlook 2000. Create a custom screen in Outlook 2000. Manipulate the Outlook data to change formatting. Add custom fields as needed by a user. VB/VBA.
- Write the system that creates Quicken QIF files for importing into Quicken. These QIF s contain a client s transaction history. This system is initially for only one client but is the prototype for all Gruntal clients.
- Create reports against existing VFP datasets. VFP 6.0.
- Query Sybase dataset and format results for users or for import into VFP tables.
- Program using Gruntal corporate standards and consistently with the standard framework.
- All programs must integrate with the existing in-house systems.
Hanks, Inc., Austin, TX 1999-2000
Programmer
- Maintenance and enhancement of existing FoxPro 2.6 Windows and Dos apps.
- Database design, detailed design, and programming on the Quantum Loyalty Project. Coordinate efforts with the web developer. FoxPro 2.6 and Visual FoxPro 5.
- Develop a VFP app to process incoming text files from a supplier Petco .
- Participate in a training QAT to evaluate in-house training and make recommendations for improvement.
- Respond to urgent requests for resolution of emergent problems.
- Participate in company sponsored training in the Unified Modeling Language.
- Participate in company sponsored training in JAVA several classes .
- Participate in company sponsored training in the Total Quality Advantage.
- Ensure year 2000 compliance in apps.
Project United, Inc., New York, NY 1998-1999
Consultant
Assignment: Consultant to
Dresdner Bank
New York, NY
- Migration of an existing app from Visual FoxPro 3 to Visual FoxPro 6.
- Ensure year 2000 compliance
- Ensure the app will properly handle the European Monetary Unit
Advanced Communication Systems, New York, NY 1998-1999
Consultant
Assignment: Consultant to
Vental & Co., L. L. C.
New York, NY
- Port an existing Stratus mainframe system written in PL1 to Visual FoxPro 5. This system exports securities trades information, as requested by the SEC, and formats the required text file for electronic transmission and upload by the SEC. This is commonly called "producing Blue Sheets".
- Write a querying utility to query data in Sybase and VFP tables using a common front end.
- Create the statusing and tracking system to monitor progress in a sales
- Promotional contest in-house. This involves querying data from incompatible systems.
- Setup and troubleshoot the electronic communications between Gruntal and SIAC. Uploads of the Blue Sheet files and downloads of security information travel through these communications channels.
- Operate the production downloads on an as-needed basis. These downloads are the heart of the compliance system and are mission-critical information.
- Program using Gruntal corporate standards and consistently with the standard framework.
- All programs must integrate with the existing in-house systems.
Datasoft Technology Group, New York, NY 1998
Consultant
Assignment: Consultant to
Donaldson, Lufkin and Jenrette
New York, NY
- Write data conversion programs Visual FoxPro 5 to import and process information from external market information sources. These data feeds drive the internal compliance monitoring system at DLJ.
- Program using DLJ corporate standards.
- All programs must integrate with the existing compliance system.
- Contribute suggestions to the ongoing system design process as part of a team effort.
First Health Networks of America, Albany, NY 1997
Programmer/Analyst
- Continue refining the system developed as a consultant.
- Simplify the operation and enhance maintainability of code written by others. Use modular programming to eliminate re-stated code.
- Increase fault tolerance of the system by adding code to recover gracefully from common problems encountered.
- Participate in the capacity planning process to upgrade the company s computing infrastructure.
- Support of other FoxPro programmers on an as-needed basis for programming questions.
- Monthly processing for eleven clients with as-needed program enhancements while under tight time constraints.
Rutwind Associates, Rochester, NY 1996 1997
Sr. Programmer/Analyst
Assignment: Consultant to
First Health Networks of America
Albany, NY
- Translate a flat file into a relational Access database. Create a FoxPro system that automates this task. Wrote approximately 6400 lines of code in one week.
- Translate Oracle PL/SQL scripts to optimized Clipper v5.2 code that runs in a windows environment using the FiveWin v1.9.1 library. Resulting code was compiled into an existing system and needed to "understand" the system philosophy.
- Create new Clipper programs based on COBOL programs and incomplete specifications by applying my experience and helping the customer clarify their objectives.
- Operate and test the monthly processing portion of the next release of the NCMS system and suggest improvements. This system has multi-gigabyte tables and requires a substantial run time.
- Use FoxPro v2.6a during the testing and debugging develop supporting reports/test programs.
- Develop custom reports to be compiled into the HEDIS 3.0 application using Crystal Reports v4.5 and v5.0.
- Project management and project enhancement suggestions.
Rutwind Associates, Rochester, NY 1996
Programmer/Analyst
Assignment: Consultant to
Sun Vision Software
East Palm Beach, FL
- Continue Phase II of the development of a commercial loan management software package for Windows.
- Write a financial calculator program that calculates interest and amortizes loans. Calculator supports many different compounding periods and calculation methods.
- Program tracks payments, charges, current balance and customer information.
- Written in FoxPro for Windows v2.6a using Stonefield AppMaker/Reports/Data Dictionary v2.6 as a base.
ARCO Staffing Services, Amsterdam, NY 1995
Programmer/Analyst
Assignment: Consultant to
Sun Vision Software
East Palm Beach, FL
Begin Phase II of the development of a loan management software package for Windows. Phase I was completed by another consultant and the client wanted someone different to complete the project.
ARCO Staffing Services, Amsterdam, NY 1995
Consultant
Assignment: Application Engineer for
GE FANUC Automation
Albany, NY
- Assemble and configure hardware for HP 9000, HP X-Terminal and PC compatible systems. Prepare system documentation, packing lists and assembly instructions.
- Load and configure HP-UX and Interactive UNIX OS and UNIX application software.
- Field service assignment in Houston, TX.
- Phone support for shipped systems.
- Application transfer from UNIX to NT.
Richardson Polytechnic Institute, Siracuse, NY 1993-1994
Teaching Assistant
- TA ed course in Manufacturing Systems Management for 4 semesters.
- This course covers PERT/CPM, scheduling, planning, Manufacturing Resource Planning, job shops, Statistical Quality Control, and other manufacturing issues.
- Maintain grade lists, grade tests, interact with students.
General Dynamics, Electric Boat Division, Troy, NY 1985-1990
Engineer
- Hands-on field and design engineering to support commercial, Nuclear and Non-Nuclear electrical systems.
- Multiple responsibilities included management support, field engineering, design engineering, database design and development, PC administration.
- Designed and developed over 200 database systems dBase III/III+ to monitor and control work flow. These systems were for accounting, document control, dosimetry, project management, issue tracking, and personnel.
- Developed a highly successful database system used to save time and increase accuracy when tracking thousands of work items for a pre-overhaul inspection of a nuclear reactor.
- End user computer support and "Help Desk" supporting al PC desktop applications on the site.
- Pushed for and conducted computer software training in the use of the common PC applications available to users. DisplayWrite, dBase III+, Lotus 1-2-3.
EDUCATION
Degree Concentration Date School
MS IME Manufacturing Systems December 1995 Richardson Polytechnic Institute
MBA Information Systems May 1993 Richardson Polytechnic Institute
BSEE Digital Logic Design, Math May 1985 University of Maryland
1234567891011121314151617
|
|