R. Kent Francis 3251 West 6610 South West Jordan, UT 840846902 (801)966-0999 home 718-1525 cell cyberman@xmission.com SUMMARY OF QUALIFICATIONS A highly qualified multi-disciplined business, marketing, and technical manager with many years of experience in the data processing industry in analyzing and solving business problems. Technical programming skills in development, applications, and management information systems environments. Skills/Tools PLSQL, Oracle 6i developer/reports, QuickBasic, Visual Basic net, Java plus many more languages. Mainframe, Unix, Windows environments. Oracle 8.17 and 9i databases Work Experience Senior Programmer/Analyst, KIVA/Accela Inc., Sandy, UT 1998 - present * Providing enterprise ORACLE software in both client/server and web environment to large city/county/state government clients. Proficient in both 4.5 and 6i developer and reports. Database 8.17 / 9i. Use Toad and DBA studio for DBA analysis work on large databases. Maintain 350+ forms, database procedures & triggers. Create, integrate and document new applications including GIS. Mentor new programmers. Detail follows: * Created specifications for an Infrastructure Inventory Control System (Asset Management); then designed, coded, and integrated it into the main product line. In addition to maintaining information about the asset, a model can be created which mirrors transactions performed against the asset with standard budgets for materials, hours and costs. These can be compared against actual services performed and a series of work orders and Oracle management reports generated. * Designed and created Hazardous Materials System for use by San Diego/LA County (to comply with California State requirements for recording/tracking historical status of thousands of sites). * Created and coded a Code Violations system for Minneapolis. * Customized the whole Professionals system for Kansas City. * Progressively all the programs for the Kiva system (including over 500 forms)have been enhanced from a character-based to bitmap-based set of forms; oracle 4.5 thru 6i. Databases also have evolved thru 9i and the forms have been standardized to run concurrently in both a client server and web based environment. I have become proficient in all aspects of forms programming/ triggers/procedures and SQL. I have fixed major components of every module. I implemented standards for report variables and the forms interface with reports; Added LOV's and hover text for all standard fields in the system. I adjusted, standardized and fixed the majority of the "system" maintenance forms. I reviewed all the forms for year 2000 compliance and repaired the majority of the form and reports date handling. I converted many of the validation triggers to cursors. * I learned Oracle and Crystal Reports, and created custom reports for over 30 clients. These include public forms (building and business permits, elevator postings, transaction receipts, professional licenses), management reports (inspections undone, Professional licenses expiring, audit trails, historical fees analysis and projection), public notification letters (code violations, hearing notifications, tax assessments), professional tracking (work orders, certification, inspection workload) and many more. * As far as DBA type work: I have used DBA studio to set up a database, define tablespace, and grant privileges. I have imported and exported databases. I have used SQL scripts run in sqlplus to set up tables, views, triggers, indexes, constraints. I have used Toad to model/debug SQL statements. I have used TOAD explain plan to check for number of rows returned from a complex query to debug it. I have used Oracle Net8 easy config to define the connections to the database for the listener. * I trained the contract programmers we hired, as well as the new programmers in reports, forms, and the Kiva coding standards. I attended Oracle classes and trained our group in the changes. I have attended two classes on Java as well as other Oracle classes and seminars. * I helped establish standards for the ESRI Graphic Interface System integration into the core system and modified all query forms so maps can highlight the information queried and likewise query highlighted map elements. * I modified all query forms in the system to be completely flexible/ customizable by city and by user. They can specify for each user which fields will appear what they will be called, how big the fields are, and how the form is sorted. * In an effort to increase my productivity, I purchased my own laptop computer with sufficient memory and speed to be an efficient development platform. I acquired Comcast broadband service into my home office and set up a local network so that I could efficiently work from home 4 days a week. Programmer/Analyst, ISCS Inc., Midvale, UT 1997-1998 * Property/Casualty Insurance software provider on HP Unix system. I wrote code to make it year 2000 compliant, added inquiry function, created analytical reports, re-wrote and debugged major modules, adding new function to the product using 4GL & Informix. President, Cybernetic Solutions Company, Salt Lake City, UT 1984-1997 * I started a consulting company and created major software applications for local corporations in office management, accounts receivable, budgeting, investment tracking, stock distribution, and client information systems. Designed, programmed, packaged, and successfully marketed THE SURVEY - An Opinion Research Software Tool for the PC. Improved and matured the product while test marketing it in specific industries and to well known companies and government agencies. You may acquire additional information by visiting http://www.cneticsolutions.com * Taught computer classes at Utah Valley Community College. Product Planner/Programmer, CDC/IBM Corporation, San Jose, CA 1966-1984 * Over the years I have acquired an extensive background in operations, operations research, computer systems programming, product development, test and control, networking, technical writing, application development, customer assistance, management information systems, technical support, headquarter operations, sales, marketing, customer conferences, and human resource training and development. As a Computer Programmer, Software Engineer, and Analyst, I have written programs in Assembly, PL/1, COBOL, Fortran, Basic, Pascal as well as many 4th Generation languages R. Kent Francis (marketing) Director of Marketing, Olympus Software 1986-1987 * Marketing management positions were taken with Clyde Digital and with Olympus Software to explore the marketing channels and the operation of a small company. At Olympus, an advertising campaign was created, the packaging was designed for the UNIX spreadsheet product, office procedures written for distribution, sales personnel hired and trained (with a ten-fold increase in revenue), and a major government contract was negotiated. Marketing Support Representative, Control Data Corporation SLC, UT 1982-1984 * Sold computer timesharing services to business executives. Designed decision support software systems. Programmed applications and trained customer's staff. Managed $600,000 revenue territory. Marketing Programs Administrator, Control Data Corporation, CT 1979-1981 * IBM division was acquired by Control Data, and I worked for both the Business Information Systems and Credit Union Services divisions at headquarters in Greenwich, Connecticut. Created Long Range Strategic and Operational Plans, Sales Compensation Plans, and successfully implemented them for $45 million division. Designed and Programmed a comprehensive Management Information System. Wrote Functional and Marketing Specifications for hardware and software offerings. Managed professional Sales and Technical Support organization of 150. Created customer conference and training seminars. * Sold, installed and supported online computer systems of largest credit unions in Utah 19771979. Wrote management information system programs in timesharing environment. FORMAL EDUCATION San Jose State University, BS Engineering Management 1969 (Engineering core/business core/management science - Minor in Spanish) San Jose State University, MS Cybernetics 1972 (Operations research/computers/organizational communication/systems engineering)