R. Kent Francis 3251 West 6610 South West Jordan, UT 84084-6902 (801)966-0999 home office 718-1525 cell cyberman@xmission.com SUMMARY OF QUALIFICATIONS A highly qualified multi-disciplined business, marketing, and technical manager with 39 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. Most comfortable language PLSQL/Oracle developer. Familiar with QuickBasic Visual Basic and some Java plus many more. Skills/Tools PLSQL, Oracle 6i developer/reports, QuickBasic, plus many more languages. Mainframe, Unix, Windows environments. Oracle 9i,10g,11i. TOAD. Oracle Reports,XML Publisher 5.6 and XML procedures under Concurrency Manager; also Crystal 10 reports, PivotLink, Discoverer 10g Education: San Jose State University, BS Engineering Management, MS Cybernetics (Operations research/computers/organizational communication/systems engineering) Work Experience - Oracle Programmer Analyst/Consultant, Various short term contracts City of Minneapolis Mar 2007-Present • Work on City’s Oracle 10g KIVA database (Permits, Request For Services, Land, Assessments Applications), create and apply database procedures to scrub/restructure the data, Management Reports using PLSQL and Oracle 6i tools; Use Toad for DBA analysis work on large database. Convert city departments (e.g. Zoning) to KIVA application and train staff. Novell Jan 2005-Feb 2007 • Extract legacy data using SQLLDR into Oracle 11i databases and Financial Applications, create and apply database procedures to scrub/restructure the data, create materialized views and load into data warehouses. AP/ AR/ GL/ Project Accounting /Time Cards/ Credit Rebill/ Internal Consumption/Open Orders/various Transaction Analysis Forms and Management Reports using Oracle 6i,Discoverer 10g, XML Publisher 5.6 and XML procedures under Concurrency Manager; also Crystal 10 reports and PivotLink. Use Toad for DBA analysis work on large databases. Nomad VPN connect using HS internet connection from home office. Version control Subversion/Tortoise. Document application and mentor internal staff. TEKSystems/Bearing Point, Hill AFB, UT Feb 2004-Dec 2004 • Pathfinder Advanced Planning System (Manugistics) for Air Force logistics to extract Air Force data using SQLLDR into Oracle 9i database, create and apply database procedures to scrub the data and load into Manugistics tables for Supply, Demand, Collaboration and TopView ( Cognos) reports. Use Toad for DBA analysis work on large databases on Unix (PERL scripts) and Windows servers. Document all processes using CMMI. Mentor and train Air Force personnel and other contractors. Senior Programmer/Analyst, KIVA/Accela Inc., Sandy, UT 1998-2004 Providing enterprise ORACLE software in both client/server & web environment to large city/county/state government clients. Proficient in both 4.5 and 6i developer and reports. Databases 8.17 and 9i. Use Toad and DBA studio for DBA analysis work on large databases. Maintain 350+ forms, database procedures & triggers. Design, Create, integrate and document new applications including GIS. Mentor new programmers. Company downsized group. Programmer/Analyst, ISCS Inc., Midvale, UT 1997-1998 This Property/Casualty Insurance software provider on HP Unix system delivers complete production and support over an NT network to their clients. SurePower 2000 was enhanced and re-written by our group. I wrote code to make it year 2000 compliant, added inquiry function, created analytical reports, re-wrote and debugged major modules, and added new function to the product using 4GL and Informix. Company downsized development group. President, Cybernetic Solutions Company, Salt Lake City, UT 1984-1997 With the demise of CDC time sharing division, 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. Principal application tools: dBase, QuattroPro, WordPerfect, QuickBasic. 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 the website http://www.cneticsolutions.com Taught computer classes at Utah Valley Community College. Director of Marketing, Olympus Software SLC, UT 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 time-sharing 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 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 Specs for hardware and software offerings. Managed professional Sales and Technical Support organization of 150. Created customer conference and training seminars. Sold, installed and supported computer systems for largest credit unions in Utah 1977-1979. Wrote management information system programs in timesharing environment. Product Planner/Programmer, CDC/IBM Corporation, San Jose, CA 1966-1976 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. Computer Programming and Operations, Bank of America, Lindsay Mgmt 1963-1966 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)