Jan Levenson of Certified Computer Services
is a Certified Adult Computer Instructor Programmer/Analyst,
offering software programming solutions for businesses
of all sizes.
Specializing in Excel, Lotus 123,
Quattro Pro, FoxPro database and QuickBooks accounting software
integration programming. Jan Levenson offers time and labor
saving techniques implementing computer solutions that simplify
your labor intensive tasks to a few leisurely steps.
Headquartered in beautiful Elkview, West Virginia (USA),
Certified Computer Services can help you solve business
problems by using powerful computer software that can be used to your best
advantage.
Certified Computer Services goal is to
offer trust, confidence and a job completed correctly!
Certified Computer Services is listed in the Better Business
Bureau's database of better businesses' with the highest
public service rating possible.
The following Programming and Consulting jobs are in the
experience portfolio of Jan Levenson and Certified Computer
Services. Jan Levenson has received many accolades
on his work:
System Analysis tools and techniques are used to analyze the needs of prospective client’s
accessory software program integration and uses, interfacing
various software programs and data sources, and advising
each client on the correct use of the recommended software
programs.
|
|
| DATABASE SPREADSHEET PROGRAMMING DEVELOPMENT and SUPPORT |
| Project: |
QuickBooks Professional Programming Excel database conversion programming systems and Design |
| Client: |
MGMT. Group, Inc. Las Vegas, NV |
| Description: |
Jan programmed Visual Basic
macros for the company that allowed them to bypass manually
entering spreadsheet data into QuickBooks. This process automatically imported data from satellite offices
to the home office QuickBooks Professional Accounting System
with correct balanced accounting processes and flags maintained in QuickBooks
Accounting system, saving additional data entry costs (time and money) everyday. |
|
| Project: |
Stock Market Real Time Ticker Programming and Design |
| Client: |
Client in England using eSignal real time world wide stock exchange data analysis system |
| Description: |
Developed a Microsoft Excel Visual Basic add-on system with macro programming that enabled the client to receive live streaming ticker tape stock exchange data trends updated in real time every second so that instant micro trading decisions could be automated, playing the stock market. This program was a custom add-on using the eSignal real time data electronic stream ticker tape data. |
|
| Project: |
Excel Spreadsheet Programming and Design Support |
| Client: |
J.P. Morgan Chase Finance |
| Description: |
Spreadsheet Microsoft Excel Visual Basic Macro programming, design and support. |
|
| Project: |
Graphing Utility Usage Software Microsoft Excel Visual Basic |
| Client: |
Real Estate Management property's maintenance and utility usage records in Crescent Heights, Los Angeles, California 90035 |
| Description: |
Automated Real Estate rental properties maintenance records and charts. Using Microsoft Excel Visual Basic, Jan designed a program enabling the Real estate manager to select any particular residential address and graph the utility resulting usage and costs over a four year period of time for that user. Averages were presented in attractive easy to understand graphs. The charts could then be used for marketing or printed out for the clients to visualize their consumption of different utilities over a period of time. Data was plotted on graphs showing usage in months and years and during seasonal events. |
|
| Project: |
Web Site Database Programming Project Support |
| Client: |
Symbolic Media Services |
| Description: |
The president of the company said, "when a person is looking for spreadsheet help and finds your web site, what they find is a genius, with good information, thank you Jan."
|
|
| Project: |
Data Conversion to QuickBooks Professional - Real Estate Appraisal Service |
| Client: |
Real Estate Appraisal Service in Las Vegas, NV |
| Description: |
As stated in an email, "just what the doctor ordered". Records previously maintained in a Microsoft Excel database were converted to correct formats and imported into QuickBooks Professional. When the new version of QuickBooks was implemented by the client's business, were converted so that sales billing statements, addresses, quotes, client lists and invoices were available allowing a quick start using QuickBooks Pro with customer data ready to print (records invoiced and multiple page billing statements generated and emailed to clients for immediate payment and account processing). |
|
| Project: |
Equipment Maintenance Control Corporation automated Vendor Invoicing System (paperless office) |
| Client: |
Equipment Maintenance Control Corporation |
| Description: |
Jan developed an Excel system for EMC Corp. to automate thier Invoicing System, part of a paper free office automation system, based on Excel Macros, (invoices are emailed), (Adobe Acrobat files are hyper linked to Excel spreadsheet invoice records and can be accessed), (a variety of customer transaction reports are automatically generated). The entire system is based on a paperless office model whereby most communications take place via email, computerized fax emails, PDF files, electronic messaging and automated payments. A data source and paper trail can be generated as a backup record system. |
|
| Project: |
Hospital Equipment Manufacturer |
| Client: |
Intra-op Monitoring Services, Inc. |
| Description: |
Manufacturer of high tech medical monitoring equipment. Jan developed a set of spreadsheets to analyze sales reps' commissions, sales and equipment product demonstrations. The sophisticated Excel program allows easier scheduling of sales and multiple product support sessions and national training. |
|
| Project: |
Multiple projects including conversion of complex Quattro Pro spreadsheets to Microsoft Excel formats and sophisticated interactive forms in Word Perfect. |
| Client: |
NOAA - National Oceanic and Atmospheric Administration - United States National Weather Service |
| Description: |
Converted a set of scientific related Quattro Pro spreadsheets to Microsoft Excel to generate statistical reports regarding nationwide river flooding potentials. Multiple projects included conversion of Word Perfect data entry forms to automated Microsoft Word data entry forms allowing easier data entry and functionality to reports in a Microsoft Office suite and word processing documents. This speeded up office document processing. |
|
| Project: |
Microsoft Excel Visual Basic PLC Programming Logic |
| Client: |
Engineering Firm - Missouri |
| Description: |
Wrote a program interface so that Microsoft Excel could run several routines to maximize the bin content and then communicate to a $70,000 PLC (Programming Logic Control) machine that bagged food within seconds for a large food producer in California. |
|
| Project: |
Johnson and Johnson Pharmaceutical Company |
| Client: |
Johnson and Johnson Pharmaceuticals |
| Description: |
Multiple projects included developing an easy to use form for senior marketing people in different international locations of this billion dollar company to quickly calculate sets of dates of prospective Pharmaceutical Drug Trials (event planning scheduling). |
|
| Project: |
Lotus 123 to Excel conversions |
| Client: |
RAC Royal Auto Club Motoring Services, UK |
| Description: |
Converted and redesigned a complex and automated Lotus 123 accounting program to Excel for RAC "Royal Auto Club" internationally known Travel and Automobile Service Agency in England, U. K. The program imported and exported data as an important part of their accounting system. |
|
| Project: |
Contractors tool using Microsoft Excel |
| Client: |
Building contractor - TX |
| Description: |
Multifaceted Contractors tool using Microsoft Excel for sales people to quickly give quotes on-site to potential clients. After the quote was accepted a formal proposal using the same data was used. The sales quoting system enhanced sales of home pools, spas, utility buildings and miscellaneous building and home improvements. A relational database of subcontractors was used to assist in the bidding process. Each sales person's portable handheld computer data could then be downloaded to the office computer to create lists of items needed in the purchases department for jobs. |
|
| Project: |
Consulting Services and Solutions Group, National Education Analysis Resource |
| Client: |
National Education Analysis Resource |
| Description: |
File Conversion Tool Kit Software update for a nationally known Education Consulting Services and Solutions Group in the United States. The Professionally used software product is used in house and offered as a flagship software product for student, teacher, school analysis, course and grade analysis and can be used for analysis accounting for the "Keep No Child Behind Program" and other education analysis programs |
|
| Project: |
Project Milestones Analysis tool using Microsoft Excel |
| Client: |
Project Analysis System with automatic active graphing system |
| Description: |
A tool written in Excel Visual Basic that is used as an accessory project management analysis tool that integrates with Microsoft Project software to simplify initial scheduling of steps within projects and visual viewing the scheduling data. |
|
| Project: |
Nutrition and Vitamin company software product using Microsoft Excel |
| Client: |
Nutrition and Vitamin related company |
| Description: |
Nutrition and Vitamin related company software product sold to clients. The program accesses a vitamin nutrition database so that a breakdown of foods consumed on a daily basis could be broken down to types of food eaten, units of protein, related vitamins, carbohydrates, cholesterol, amino acids by Gram, weight and calories. (protein, lipids, carbs, chol, sat fats, mono fats, poly fats, water, ash, calcium, copper, fiber, iron, mag, mang, phos, potash, selenium, sodium, sugar, zinc, thiamin, ribo, niacin, pan acid, foliate, folic acid, food, foliate, foliated fe, retinol, vita iu, vita rae, vit B12, vit B6, vit C, vit E, vit K, alpha carotene, beta-carotene, lycopene, gram weight amounts totaled daily for users for nutrition, weight gain or loss or food intake analysis). |
|
| Project: |
Company Address Database |
| Client: |
Elk Corporation |
| Description: |
Attractive Spreadsheet Address Database System written in Visual Basic within Microsoft Excel as a desktop utility interfacing all of the company´s employees and offices. |
|
| Project: |
Oil Well Discovery Database Spreadsheet Reporting System |
| Client: |
Geo Digital Imaging Company |
| Description: |
Edited a spreadsheet to analyze, calculate and print needed reports for an international oil well discovery business. |
|
| Project: |
Slot Machine Gaming Profit Analysis Software System |
| Client: |
Grand Casino Avoyelles |
| Description: |
Developed a complex Excel spreadsheet using Visual Basic to simplify statistical cost analysis reports regarding expectations and probability audits of profits and or losses of thousands of slot machines for management. |
|
| Project: |
Advertising Mass Mailing Address Database |
| Client: |
Professional Typing and Computer Services Company |
| Description: |
Large Professional FoxPro address database system in the greater Charleston area for professional mass mailings and marketing. |
|
| Project: |
Invoicing spreadsheet Sales Analysis System |
| Client: |
GEM Printing Equipment |
| Description: |
Developed team sales invoice generating spreadsheets system in Lotus 123 where custom invoices can be produced and reports printed before a final sales invoice of the same is presented to the buyer towards the purchase of high-end printing equipment. this optimized the sales process increasing sales and incentives for sales personnel and final sales purchase orders for the equipment company. |
|
| Project: |
State Assets Inventory System |
| Client: |
State of West Virginia |
| Description: |
Helped design a computer database application that contained all of the assets of the State of West Virginia, for the state governments Department of Finance. Complimented on "a job well done" by a CPA analyst from Deloitte & Touché accounting firm. |
|
| Project: |
Truck Chemical Inventory System |
| Client: |
Union Carbide Corporation currently Dow Chemical |
| Description: |
Designed Lotus 123 spreadsheets and inputted data to analyze a yearly period of scheduled truck chemical inventory shipments to and from the Carbide Institute plant for Union Carbide Corporation Roune Polenc. |
|
| Project: |
Automotive Repair Service Analysis & Reporting System |
| Client: |
Smith Motor Car, Mercedes Dealership |
| Description: |
Enhanced a spreadsheet application for the local Mercedes Motor Car dealership that totaled monthly through yearly repair department amounts and printed reports for the company's cost and profit analysis. |
|
| Project: |
Statewide Healthcare Comparative Analysis System |
| Client: |
West Virginia Department of Health |
| Description: |
Developed a spreadsheet template program that produced a comparative analysis of costs of health facilities, profits and quality control statistics of institutions in West Virginia for the West Virginia Department of Health. |
|
| Project: |
School Lunch/Juice Accounts Receivables and Program |
| Client: |
Catholic School System |
| Description: |
Wrote a School Lunch/Juice Accounts Receivable program interfacing a Lotus 123 Spreadsheet template with a FOXPRO database that was used by each student to have a credit card like account where lunches and juice money payments could be charged and monthly billing statements conveniently sent to parents bi-weekly or on a monthly basis. |
|
| Project: |
Elevator Sales Invoice System |
| Client: |
Dover Elevator Company |
| Description: |
Jan designed a FoxPro database computerized elevator sales invoice system that printed sales invoices for custom designed elevators. The regional manager of Dover Elevator Company liked the program and said, "The entire project paid for itself when one new elevator was sold using the program ." |
|
|
| Project: |
Turner Construction Company Internal Accounting Database Analysis program to print government reports |
| Client: |
Turner Construction Company |
| Description: |
Jan was asked by a senior CPA Financial Analyst for this international company to design a database program that could be used to categorize and analyze employee payroll records for multiple projects that each employee works so that the payroll system could run more efficiently.
A complicated set of employee and project records could be maintained and reports printed for a wide variety of payroll systems and analysis. The database program was written in Visual FoxPro Database language. the financial analyst told Jan that "he was glad Jan was working on the database program because Jan's understanding of programming/analysis was simplifying their payroll records and streamlining their overall accounting system". |
|
| Project: |
Medical Insurance Cost Analysis System |
| Client: |
University Health Associates |
| Description: |
Designed and programmed a FoxPro database application that analyzed cost over and under payments that were made by the major federal and state medical insurance companies to a large health care billing financial organization, University Health Associates. Jan was told by his supervisor, "He successfully programmed an application on the project that the 100 million-dollar company's team of computer programmers' said was impossible to do". |
|
| Project: |
Visual Basic Business Programming and Design |
| Client: |
Royal Guard Fence Company |
| Description: |
Lotus 123 Bid Sheet program converted to Microsoft Excel. This project included programming, design analysis and support. This Bid Sheet presentation tool was converted and included two different databases in Excel that were automated and integrated with Visual Basic macros that simplified and enabled the (sales team) user's to quickly generate and submit bids for potential jobs. A separate integrated Excel spreadsheet gave the management an overview from every accounting perspective of the costs, profits and account breakdown on potentially large bids to better manage their bidding process, project management and planning. |
|
| Project: |
Excel Programming and Design |
| Client: |
BioTrak Corporation |
| Description: |
Excel spreadsheet template for customer proposals given to customers as a free financial spreadsheet interactive model. Program implemented drop down menus and automatically populating cell areas with data depending on the selections chosen by the user. Customers enjoyed receiving the software for their own use and financial review of discount factors used in their proposed portfolio of financial options. |
|
| Project: |
Excel Spreadsheet Programming and Design |
| Client: |
National Art Gallery of Canada |
| Description: |
Jan converted their Quattro Pro spreadsheet to Excel, redesigned and simplified their spreadsheet bookkeeping system enabling their spreadsheet system to work better maintain more data records, operate more smoothly and include more reliable automation. |
|
Project: |
Party Sales Fund Raising Business |
| Client: |
Party Sales Fund Raising Business, Dallas, TX |
| Description: |
Accounting system for a Regional Manager of a party sales business to maintain sales records for sales reps and details of products sold for each Rep to maintain commissions, overall costs, profits and expenses. |
|
| Project: |
COBOL Programmer/Analyst |
| Client: |
West Virginia Department of Employment Security |
| Description: |
COBOL Programmer/Analyst for the State of West Virginia Department of Employment Security, Division of Labor and Economic Research, Jan wrote a COBOL program that calculated and printed WV unemployment statistics. Jan organized extensive and detailed flowcharts and designed a written analysis of a complex COBOL program for State employment and Federal employment records, part of a Federally funded computer project. |
|
| Project: |
Accounting and marketing support |
| Client: |
Foxfire Vacation Resort |
| Description: |
Vacation resort and family recreation center. Helped with advertising campaign doubling the company's business. Assisting with Accounting System overhaul, mass mail marketing brochures and database support. |
|
| Project: |
Computer Instruction & Organization Advisory Council Member |
| Client: |
Multi-Cap, Inc. |
| Description: |
Served as Multi-Cap, Inc. Advisory council member and computer business related instructor. Charleston, WV 1992-93. Support instructor for clients of Multi-Cap : Best accounting practices, overview of the corporate and small business work place including multi facetted and critical business record bookkeeping and practices training. |
|
| Project: |
SMS Health Record Software |
| Client: |
CAMCARE, Inc. |
| Description: |
CAMCARE Inc. - As a programmer/analyst several of Jan's security and programming module design concepts were used in the actual run time version of this worldwide software record keeping product. As a trainer in one of the largest national health care systems in the United States- Jan trained hospital personnel, doctors and nurses to learn new SMS health record software ( a real time national records management system key to information achieving accuracy and responsibility in hospital record maintenance procedures. This software allows less error in patient medical records so medically decisions can be made quicker and more reliably. |
|
| Project: |
Accounting Software Systems Analysis and Program Implementation |
| Client: |
Canadian Manufacturing Company |
| Description: |
Analyst and Consultant recommending and help implementing financial accounting system to a large product manufacturing company in Canada. This allowed for quicker reporting and processing of product development and market place accounting transparency, decision rich analysis and evaluation of past, current and future business trends and statistics. |
|
| MISCELLANEOUS |
|
| Project: |
Excel Sales team and individual sales analysis system. |
| Client: |
Pierce Management Group - CPA |
| Description: |
Assisted a Certified Public Accountant develop software for cost analysis and specialized internal information systems reports for sales persons in the funeral industry using in Microsoft Excel. The lead CPA said "the program has been used on twenty different systems everyday and that they have been able to find more uses for the software beyond what they originally could have dreamed". The program is used for current and historical sales data, forecasting expectations in trends for individual company financial statements and sales personnel records. |
|
| Project: |
First Run Features, Theatrical media booking agency, New York, New York |
| Client: |
First Run Features |
| Description: |
Supercalc to Excel legacy accounting spreadsheet systems conversion services. |
|
| Project: |
Veterinary Financial Software Design Consultation |
| Client: |
Veterinary Hospital Finances |
| Description: |
Enhanced integration insight overview of Excel accounting spreadsheet data analysis programming and design consulting services for a nationally known veterinary practice in California featuring peer group analysis networks. |
|
| Project: |
Lotus 123 to Excel conversions |
| Client: |
Real Estate Company, Florida |
| Description: |
Designed an automated reporting system with proven reliability performance and premier presentations showing relevant profitability and expenses reporting in Microsoft Excel for a real estate company in Florida. |
|
| Project: |
Lotus 123 spreadsheet programming macro updates for Trinity Lutheran Church accounting |
| Client: |
Trinity Lutheran Church |
| Description: |
Conversion of early Lotus 123 spreadsheet to newer version of Lotus 123 macros. |
|
| Project: |
Vertical Sales Mass Mailings Marketing |
| Client: |
Servco Fasteners |
| Description: |
Designed a vertical sales marketing direct mass mailing database for the Servco Fasteners Company. |
|
| Project: |
Lottery Program |
| Client: |
Gaming client |
| Description: |
Designed a lottery game program in Microsoft Excel that simulated random Lottery ball pulls. |
|
| Project: |
Statistical Analysis Questionnaire |
| Client: |
Business in England UK |
| Description: |
Designed a Questionnaire and statistical analysis and real time graphing system for a company in the U. K. The system can be used for a large organization that after questionnaires are answered on screen, data is imported into the main spreadsheet where hundreds of statistical chart graphs showing relationships of numbers and statistical analysis is shown in real time. The program is menu driven with viewing and printing options menus within Quattro Pro. |
|
| Client: |
Professional musician, Greenbrier Hotel, sheet music transposed notations
|
|
| Project: |
FoxPro Programmer |
| Client: |
Osteopathic Physicians of West Virginia Inc. |
| Description: |
Jan programmed an organization database based on logic that was used to produce form letters, maintain member´s information for organizational support and political action benefiting the group. |
|
| Project: |
Bookkeeping Spreadsheet Support |
| Client: |
Wright-Patterson Air Force Base |
| Description: |
Wright-Patterson Air Force Base Excel spreadsheet project consultant. |
|
| Project: |
Business Support and programming |
| Client: |
Auto Repair Service Center |
| Description: |
Computer assistance, trained employees, programmed and support for QuickBooks used in a professional NAPA auto service/repair business. |
|
| EDUCATIONAL TEACHING POSITIONS HELD BY JAN LEVENSON |
|
| Institution: |
Capital High Community Education Teacher |
| Position: |
Technical Education Center Instructor, Industrial Computer Trainer |
|
| Institution: |
Benjamin Franklin Career & Technical Education Center |
| Position: |
Computer Instructor |
|
| Institution: |
Training Place, Town Center Mall, Charleston, WV |
| Position: |
Jan instructed a wide variety of computer classes including technology and computer learning software strategies for business data rich environment using Analysis, trends, visual graphic representations of numeric data (graphs). Business and Industry Computer Instructor for employees of Bell Atlantic Telephone, McDonough, Caperton Insurance Inc. McJunkin Corporation, and the Kanawha County Board of Education.
|
|
| Institution: |
Garnet Career Center , Charleston, WV |
| Position: |
Computer Instructor of traditional computer training classes in computer business related technologies. |
|
| Institution: |
Carver Career Technical Education Center, Belle, WV |
| Position: |
Business/Industry Instructor organized workspace data processing seamlessly used in simplifying significant amounts of office data. |
|
| Institution: |
St. Albans High School Community Education |
| Position: |
Computer Instructor |
|
| Institution: |
West Virginia Junior College, Charleston, WV |
| Position: |
Computer Instructor of data processing, computer science, spreadsheet office automation. |
|
| Institution: |
National Institute of Technology, National Education Center, Charleston, WV |
| Position: |
Instructor of Computer Science, Accounting, RPG, COBOL and BASIC programming. Logic and Systems Analysis, programming and coding strategies. Transparency of accounting, utilizing network based telecommunications and computer systems programming tools.
|
|
| Project: |
Industrial Instructor |
| Client: |
Federal Express |
| Description: |
Jan was selected as a spreadsheet-training consultant to train employees of Federal Express. |
|
| Various: |
Jan was a payroll operator in charge of payroll processing and accounting system maintenance at a large Garden Center Business.
Jan has programmed many applications for Spreadsheets (Quattro Pro, Excel, Lotus 123), file recovery, formulae conversion customized accounting software database systems for a wide variety of businesses and institutions including strategic analysts, interactive data analysis, forensic investigations.
|
|
|
Certified Computer Services is listed in the Better Business Bureau's database of businesses with the highest business recommendation rating possible.
Copyright © 2008 Certified Computer Services |
| |
|
Experience 
