Detail Resume: Michael R Royce 77 Auburn Street MRR@RoyceFamily.com Concord, NH 03301-3047 (603) 224-3805 ______________________________________________________________________ Full Featured "Best Ideas That Work" (Proven Track Record of Completed Projects) · Offers many years experience · Development of productive applications such as: accounting administration capacity planning data conversions financial insurance networks payroll personnel scheduling utility billing web design · Installation of hardware and software · Database, Web design & maintenance · Training ______________________________________________________________________ A BRIEF SUMMARY OF WHY YOU NEED ME ______________________________________________________________________ I offer a distinctive blend of vision, creative problem solving & computer skills with a collaborative style of leadership that gets quick results that everyone can use. This is not about me - This is about what you need to improve your productivity !!! I don't just complete projects, I create solutions to business problems that you don't know you have until you find how much better your computer systems can work !!! I have a proven track record of extensive computer skills and successes. I have "high energy" and will do what ever it takes to complete projects successfully. My innovations come from observing computer users and fitting their needs to usage. All I need is some idea as to expected results and I will make it happen. Yes, I understand my "Detail Resume" is "daunting". It has developed over the years to meet your needs (and to remind me of my extensive work history). You can skim it to meet your needs (only the last 10 years, whatever). The premise here is to give you the best information to understand my skills and experience. A problem of being a contractor for many years is that I have had many assignments which, obviously, extends my resume considerably. I am not limited to the standard canned solutions to problems. The best person to ask questions about my special computer skills is: Norman Demers (407) 884-5920 DemersN@embarqmail.com. Norman was on the selection committee when I was hired (with only three years of computer experience and no Unisys experience) to work for the Concord School District. I also completed a contract project to develop the City of Concord's water & sewer billing system when Norman transferred to the Water & Sewer Department. After working for Concord a couple of weeks, I asked Norman why I was hired with no Unisys experience. He said, "You can think". (Good answer !!!) If a person can think clearly, there are no limits to solving problems. I am open to contract or full-time employment. The position I liked best, most challenging & responsible: The best position I have had with my career was 10 years as IT Director / Systems Analyst / Programmer for the CSD. I started building their Unisys mainframe computer system (I had no prior Unisys experience) 6-months after CSD's purchase. I added applications (payroll, budgets, account receivable / payable, personnel, student records / scheduling, health records, food services, attendance, report cards, guidance analysis, utility usage (electricity, fuel oil & gas), etc.) purchased from Unisys and extensively altered or custom built new applications to meet the ever changing school district needs. I have been networking computers for many years. At Concord, I designed & installed equipment to network the computer system that tied all 12 schools together with the business office. I liked that position best because I was allowed to utilize all of my computer skills to do everything that was necessary to solve computer-related problems. The only reason I am not with Concord today is because of budget cuts. At Concord, the computer support I offered was to the superintendent's business system and administration of all schools. I made all decisions on projects needed and implementation by aquatinting myself with key personnel in all departments and seeing projects through to completion exceeding user expectations. I bring many skills to this position. What makes me different than most other professionals, plain and simply, I provide service others only talk about. I see what needs to done and then take the steps necessary to complete projects without trying a lot of things that I know wouldn't work. It seems I do this so well that Unisys technical staff, from throughout New England, visited Concord's data center to under- stand what I was doing that was so much better. One team manager told me that nobody was utilizing computer resources and producing results like I was. At the time, I didn't think much about this comment (I always expect the best results) but over the years I have learned he was correct - not very many computer systems work well - most IT departments & software vendors are not responsive to user needs. Many NH school districts visited Concord's Development Center to learn of computer systems that may help their districts. I gave them sample reports and screen printouts that they could evaluate and modify to meet their needs. Concord was the first district that the State of NH Department of Education accepted computer generated attendance reports. This may be "old hat" today, but 25 years ago, this was a big deal. With Assistant Superintendent Bob Silva, I developed a high school guidance system that tracked students 9-12 making sure all courses and credits met graduation requirements through their four years of high school (At Concord, students can take classes in any order - BUT - All requirements needed to be met before graduation). Many reports could be generated by guidance staff to consult with their assigned students. Throughout my career, I have used many computer systems, languages, applications, databases and completed many data conversions. I work well with all levels of staff & management, teaching them how to get the most out of their information systems, which is economical and makes their job easier and more fun. Many forms of resumes are here to meet your needs: http://www.RoyceFamily.com/resume.htm Try to envision how a few of my project solutions would help your organization: Example (1): A quote from a Micro Focus Cobol newsletter: "With project failure rates considered the "worst in decades", the challenges of distributed teams, numerous automation tools, and multiple methodologies, mean today's software development teams are inherently burdened with a tremendous amount of complexity. Yet despite increasing failure rates, teams continue to ignore the true reason for these failures - requirements definition." I read this stuff all of the time. My projects do not fail because I take all steps necessary to achieve expected results. Example (2): Most challenging project completed: I rewrote the Unisys financial package that did not work at all. This is a very long story but the net result is that the school district had a full functional financial system and Unisys paid the school district $10,000 for my batch program changes that they could not fix themselves. Unisys did not want my new on-line program (workhorse of the system - theirs didn't work at all) because they thought it was too complicated. My on-line program was 50% smaller and accomplished more. Over time, I rebuilt the payroll & financial systems, taking the best features of each totally unrelated application and making them work seamlessly together. Example (3): Very good working with clients: At the Bank of Boston, the payroll systems manager told me I was the only consultant that gave him what he wanted. (Again, I provide service, I get things done correctly) Example (4): Creative computer processing: On a Y2K project, one phase was to merge on-going development from other departments with source code that had already been Y2Ked. With my process, I could merge 125 programs per day. Other contractors would merge 5 programs per day. I offered to share my process with other Y2K contractors but they were not interested (nor did the company care). Example (5): Flexible creative computer projects: The past few years, I have donated consulting days to our Public TV Auction, Channel 11, Durham, NH (1 day per auction day - 87 consulting days in 9 years). These consulting days are very diverse - that is, I need to be very creative instantly. Again, plain and simply, I get things done. With my extensive experience, I have many supporting stories. Just ask, chances are I have already solved your typical kinds of problems elsewhere. ______________________________________________________________________ TECHNICAL PROFILE ______________________________________________________________________ HARDWARE: IBM PC, PS/2 Mainframes: IBM 1401, 370, 3090, 9021/982, 9672, Unisys B1865, B1990, Honeywell 2040A NETWORKS: Local/Wide Area, Novell, Peripherals. SOFTWARE: Operating Systems: Mainframe & PC Operating Systems: MVS/XA, VMS, VS, DOS/VSE, MCPII, MS-DOS, OS, OS/2, Windows 3.1 / 95 / ME / NT / 2000 / XP / 2003 7 / 8. Programming Languages: BAL, DAP, NDL, JCL, Cobol, Cobol/2, Micro Focus (MicroFocus) NetExpress Cobol, Flexus SP2, RM Cobol, C, C++, 4GL, Fortran, Quick, SPD Professional and Visual BASIC, MS-ACCESS, HTML, Microsoft .NET Technology. Applications: Microsoft, Data Conversions, data editors BRIEF & Multi-Edit, Insurance, Payroll, Financial, Education, Administration, Retail, TSO, ICCF, Cande, Endevor, PVCS, IQ Report Writer, On-line HELP. ______________________________________________________________________ ACHIEVEMENTS PROFILE ______________________________________________________________________ Project Management Style: Self-starter with strong planning, organizing and controlling skills, minimizing downtime. Consistently manages time and multiple tasks to meet deadlines, established objectives and quality performance standards. Applications Development: Worked on a team to develop a networked insurance application system marketed nationally for $2,000,000. Creates user-friendly batch and on-line systems that interface with many existing applications utilizing data to it's fullest capacity. Standard Setter: Subcontracted for extensive modifications to applications Unisys Corporation was technically unable to do. Unisys sent numerous regional technical staff to evaluate the successful data processing standards developed and adopted such standards. Analytical Troubleshooter: Identify complex problems; resourceful and inventive in developing and implementing solutions with enhanced sensitivity to cost, efficiency and deadlines. Developed strategies to address the coming world-wide YEAR-2000 computer crisis. Skilled Instructor / User Trainer: Articulate and effective in explanation and demonstration of concepts and techniques to system users. Instructor of computer courses at NH Technical Institute in Concord, NH with mixture of adult / college students and class size from 12 to 18. Publishing Highlights: Since 1993, I had been focusing my technical skills towards the YEAR-2000 computer date problem with many articles in magazines and newspapers. Most notably, my picture was featured on the September 1998 cover of Interface Monthly, a northern New England technical magazine. ______________________________________________________________________ EXPERIENCE ______________________________________________________________________ May 2002 COMPUTER CONTRACTOR Present Hardware: PC / Client Server Operating Systems: WindowsXX Languages: Micro Focus (MicroFocus) NetExpress Cobol, Flexus SP2 (Windows interface to Cobol), MS-Access databases, HTML File Structures: VSAM, SEQUENTIAL o State of NH Veteran's Cemetery MS-Access database application adding features with Micro Focus NetExpress Cobol & Flexus SP2. o Cobol application conversion project from AS/400 to Windows Client Server. o Built a few "proof of concept" Cobol application projects. A fully functional sample application is here: www.roycefamily.com/convert.htm o Built a few databases & Web sites, fixed a few computer problems & viruses for non-profit organizations. o Donated 87 consulting days (in 9 years) to our local PBS TV auction. These assignments are very interesting in that they deal with everything that is computer related such as installing hardware & software, training on any application that a client may have, suggesting hardware, software & upgrades, digital photography, clean up computer systems, etc. ______________________________________________________________________ February 2002 IMPLEMENTATION SUPPORT SPECIALIST May 2002 Horizon-Boss Loganville, GA Hardware: PC, Client / Server Operating Systems: WindowsXX Application: Food Service POS o Installation of hardware & software, training & support of Food Service POS systems. ______________________________________________________________________ April 2001 SYSTEMS DEVELOPMENT February 2002 CCR Data Systems Concord, NH Hardware: PC, Client / Server Operating Systems: WindowsNT Languages: Micro Focus (MicroFocus) NetExpress Cobol, Flexus SP2 (Windows interface to Cobol) File Structures: VSAM, SEQUENTIAL Applications: Retail Inventory Management System (RIMS80) o Development of inventory control system. This is an interesting project that uses a Windows interface (Flexus SP2) with Cobol source code in the background originally based on RealWorld accounting system. ______________________________________________________________________ February 2000 SYSTEMS DEVELOPMENT SPECIALIST VI April 2001 State of New Hampshire Department of Health and Human Services Hardware: Mainframes, PCs Operating Systems: IBM Mainframe Multiprise 2003/225, VM/VSE V2.3, VSE/ESA, V2.4 running under a VM environment utilizing the American Management Systems Enterprise Server 2.0 Middleware, MS-DOS, Win95 Languages: JCL, Cobol, Cobol II File Structures: VSAM, SEQUENTIAL Applications: On-line & Batch o NECSES (New England Child Support Enforcement System) technical team leader for development & support. ______________________________________________________________________ March 1999 SYSTEMS DEVELOPMENT SPECIALIST V February 2000 State of New Hampshire Department of Administrative Services Hardware: Mainframes, PCs Operating Systems: IBM Mainframe Multiprise 2003/225, VM/VSE V2.3, VSE/ESA, V2.4 running under a ICCF environment utilizing the American Management Systems Enterprise Server 2.0 Middleware, MS-DOS, Win95 Languages: JCL, Cobol, Cobol II File Structures: VSAM, SEQUENTIAL Applications: On-line & Batch, Data Conversions, Many varied o Y2K JCL data conversion & updates. o IFS (Intergrated Financial Systems) developer & support. ______________________________________________________________________ October 1989 COMPUTER CONTRACTOR Present Companies, Small Businesses including the next 5 contract positions Hardware: Mainframes, PCs Operating Systems: Mainframe, MS-DOS, Windows 3.1, Win95, WinNT Applications: On-line & Batch, Data Conversions, Many varied o Contract programming and specialized services such as installation and setup of PC computer systems and training. o Develop / maintain genealogy, cemetery management, file management tools, water / community association billing system, computer dating, program modules and strategy that solve the coming world-wide YEAR-2000 computer crisis. ______________________________________________________________________ June 1998 COMPUTER CONTRACTOR January 1999 Sun Life of Canada Boston, MA Agency: Ambit Technology Hardware: IBM Mainframe, PC Operating Systems: MVS, MS-DOS, Windows 3.1, Win95 Languages: JCL, Cobol, Cobol II, Quick BASIC File Structures: VSAM, RANDOM, SEQUENTIAL Applications: Group Life Annuity o Complete Y2K methodology changes to a series of programs and test system. o TU bypass conversion. o Merging of Y2K correction code with developing products. ______________________________________________________________________ February 1997 COMPUTER CONTRACTOR March 1998 Fidelity Boston, MA Agency: The Systems Group (TSG) Hardware: IBM Mainframe, PC Operating Systems: MVS, MS-DOS, Win95, WinNT Languages: JCL, Cobol, Cobol II File Structures: VSAM, DB2, IDMS, RANDOM, SEQUENTIAL, SAS Applications: MAPS, Y2K, FBSI, SAS, CA Contract 1 - February 1997 to June 1997 o Fidelity Investment Retail Marketing Company (FIRMCO) Analyze MVS MAPS Leads database to develop a plan that would convert FOX Pro transaction data to go through the MAPS Leads production process and then design a report and output data back to the FOX Pro format. Contract 2 - June 1997 to September 1997 o Fidelity Customer Processing Group (FCPG) Develop and program a YEAR-2000 prototype solution for the MAPS Leads system to allow data to be read and written in centuries 1900 and 2000. Contract 3 - September 1997 to October 1997 o Fidelity Investment Retail Marketing Company (FIRMCO) Complete another MAPS Lead design process similar to contract 1 but using data from a DB2 database. Contract 4 - October 1997 to March 1998 o Fidelity Data Research (FDR) Analyze corporate-wide data to design audit trails for potential high-risk fraud applications. Capture MVS daily production data files, convert extracted data to SAS format, upload to Client/Server for technical analysis. Design, build and load data tables from MVS transaction data to MS-ACCESS database. ______________________________________________________________________ May 1996 COMPUTER CONTRACTOR January 1997 The Bank of Boston, Boston, MA Agency: The Computer Merchant (TCM) Hardware: IBM Mainframe, PC Operating Systems: MVS, MS-DOS, Windows 3.1 Languages: JCL, Cobol, Cobol II File Structures: VSAM, DB2, IDMS, RANDOM, SEQUENTIAL Applications: DBS - Payroll, HR, TSO, ISPF, ENDEVOR o Convert Cobol to Cobol II. o Analyze and correct problems with employees in a HR IDMS database. o Analyze newly purchased BayBank payroll / HR transaction data and develop a plan to load and convert data of the 8,000 BayBank employees to Bank of Boston IDMS database. o Apply payroll year-end updates to archive system. ______________________________________________________________________ April 1996 COMPUTER CONTRACTOR May 1996 Anderson Systems Management Associates, Inc. Salem, NH Agency: Kenda Systems Hardware: PC, Client / Server Operating Systems: MS-DOS, Windows 3.1 File Structures: Btrieve Applications: Smithware Btrieve DDF Sniffer and Builder o Analyze client Btrieve DDF files (data dictionary) and develop data keys that allow these files to be loaded and used with MS-ACCESS database. ______________________________________________________________________ June 1995 COMPUTER CONTRACTOR January 1996 Genesys Software Systems Methuen, MA Agency: New Boston Systems Hardware: Large IBM mainframes 3090 & 9672, PCs Operating Systems: MVS, VSE, MS-DOS, Windows 3.1 Languages: JCL, Cobol, Cobol II, Micro Focus (MicroFocus) Cobol, Quick BASIC File Structures: VSAM, DB2, IMS, RANDOM, SEQUENTIAL Applications: Batch, Payroll o Develop several reporting systems for audit and tax purposes, tax system data transfer. o Data file conversion from a payroll service bureau to Genesys format. ______________________________________________________________________ October 1993 SPECIAL PROJECTS PROGRAMMER / ANALYST April 1995 RealWorld Corporation Concord, NH Hardware: PC, Client / Server Operating Systems: MS-DOS, Windows 3.1, UNIX Languages: Cobol, Cobol II, Micro Focus (MicroFocus) Cobol 3-0-54, RM Cobol, C, Professional & Quick BASIC, MS-ACCESS File Structures: ISAM, VSAM, RANDOM, SEQUENTIAL, BTRIEVE Applications: Client / Server, On-line & Batch, Payroll, Accounting, PVCS, IQ Report Writer for DOS, Windows 3.1, UNIX, On-line HELP o Develop / maintain / support accounting software modules. o Test / correct / package application problems for current and prior versions. o IQ Report Writer data dictionary creation automation for ISAM and BTRIEVE files. o Develop / maintain on-line HELP system for many applications. o Packaging of third party applications for distribution. ______________________________________________________________________ December 1992 ADJUNCT PROFESSOR March 1997 New Hampshire Technical Institute Concord, NH Hardware: PC Operating Systems: MS-DOS, Windows 3.1 Languages: Quick BASIC File Structures: RANDOM, SEQUENTIAL Applications: Batch, Word Processing, Spreadsheet o Taught several semesters of "Introduction to Computers" "MS-DOS" "Microsoft Works for Windows" including course design, selecting books and additional training materials. The age of students was from high school to grandparents. ______________________________________________________________________ October 1990 SENIOR PROGRAMMER ANALYST October 1992 ISI Systems Andover, MA Hardware: Large IBM mainframe 3090, PC, PS/2 Operating Systems: MVS, OS/2, MS-DOS, Windows 3.1 Languages: JCL, Cobol, Cobol II, Micro Focus (MicroFocus) Cobol, Quick BASIC File Structures: ISAM, VSAM, SQL, DB2, IMS, RANDOM, SEQUENTIAL Applications: Batch, Client / Server, Insurance o Develop automated underwriting system. o Develop / maintain project software tools / technical analysis / programming and test plans. ______________________________________________________________________ February 1982 COMPUTER CONTRACTOR (part-time, as needed) October 1989 City of Concord Water & Sewer Department, Concord, NH Hardware: UNISYS mainframes B1865 & B1990 Operating Systems: MCP II Languages: JCL, Cobol, NDL File Structures: ISAM, RANDOM, SEQUENTIAL Applications: On-line & Batch, Municipal Water & Sewer o Develop / maintain water & sewer billing system for City of Concord. ______________________________________________________________________ May 1979 IT DIRECTOR / SYSTEMS ANALYST / PROGRAMMER October 1989 Concord School District Concord, NH (best position) Hardware: UNISYS mainframes B1865 & B1990 Operating Systems: MCP II Languages: JCL, Cobol, NDL File Structures: ISAM, RANDOM, SEQUENTIAL Applications: On-line & Batch, Payroll & Accounting, Education Administration o Managed total operations of a mainframe data processing center including: System / data back-up and recovery, user training, system / user documentation. o Converted databases from NCR to Unisys. o Major upgrade and computer conversion from one Unisys system to another Unisys system that improved productivity by four and saved space and cooling needs. o Selected / installed / maintained / troubleshoot 100+ node data network, terminals printers and related equipment at 12 sites. o Select / modify / develop Cobol application packages for personnel, payroll, budget, accounting, student records and scheduling including: Converted batch payroll system to on-line. Develop interface programs between payroll and budget applications saving many hours of reentry per week. Automate procedures for retroactive pay, pay increases and expected budget cost increases for new budget year. Monitor quality assurance for all application systems. ______________________________________________________________________ February 1976 PROGRAMMER May 1979 Concord Group Insurance Company Concord, NH Hardware: HONEYWELL mainframe 2040A Operating Systems: OS Languages: SPS ASSEMBLER, JCL, Cobol, DAP File Structures: ISAM, RANDOM, SEQUENTIAL Applications: On-line & Batch, Insurance Administrative, Payroll, Accounting o Computer conversion from IBM 1401 Assembler to Honeywell Cobol. o Develop / maintain statistical, auditing and claims processing programs. o Develop / maintain / troubleshoot national data network. o Install / service terminal & printer equipment. _______________________ End of Resume _____________________________ ________________________ References ________________________________ On request _____________________ End of References ____________________________