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, database and accounting software programming, Jan Levenson offers time labor saving techniques implementing computer solutions that simplify labor intensive tasks (to a few leisurely steps). Headquartered in beautiful Elkview, West Virginia (USA), Jan Levenson, of Certified Computer Services can help
you use powerful computer software to your best advantage.
Certified Computer Services goal is to offer trust and
confidence and a job well done!
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:
|
|
| DATABASE/SPREADSHEET PROGRAMMING DEVELOPMENT and SUPPORT |
| Project: |
QuickBooks Professional Programming and Design |
| Client: |
MGMT. Group, Inc. Las Vegas, NV |
| Description: |
Simulating a multi level accounting software package process, Jan programmed macros for the company that allowed them to bypass manually entering spreadsheet data into QuickBooks. Jan designed a macro that automatically prepared data from satellite offices that could be imported to the home office into QuickBooks Professional Accounting with correct balanced accounting processes maintained in Quickbooks Accounting system, saving the company money everyday. |
|
| Project: |
Stock Market Real Time Ticker Programming and Design |
| Client: |
Client in England using eSignal real time world stock exchange data analysis system |
| Description: |
Developed a Microsoft Excel Visual Basic system with macro programming that enabled the client to receive live streaming ticker tape stock exchange data updated in real time every second so that instant trend trading decisions could be automated, playing the stock market. This program was a custom made add-on using the eSignal real time data electronic stream ticker tape. |
|
| Project: |
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: |
Real Estate apartment and rental properties maintenance records 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 usage and costs over a four year period 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. Records previously entered into Excel were converted so that sales billing statements, addresses, quotes, client list and invoices were readily available within QuickBooks Professional, allowing a quick start using QuickBooks Pro with customer data ready to be printed (records invoiced and multiple page billing statements could immediately be generated and emailed to clients for immediate payment and accounting processing). |
|
| Project: |
Equipment Maintenance Control Corporation automated Vendor Invoicing System (paperless office) |
| Client: |
Equipment Maintenance Control Corporation |
| Description: |
EMC wanted an automated 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, so that linked information can be accessed), (a variety of customer transaction reports are automatically generated). The entire system was based on a paperless office model whereby most communications take place via email, computerized fax emails, PDF files, electronic messaging and payments. A paper trail could 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 seminars and training personnel needed for sales and product support sessions. |
|
| 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 Quattro Pro spreadsheets that generated statistical reports to Microsoft Excel formats. Multiple projects included conversion of Word Perfect Macro data entry forms to Microsoft Word data entry forms allowing easier automated data entry and functionality to reports in word processing documents. |
|
| 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 including 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 and is 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 be able to quickly give quotes and print sales 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 notebook computer proposals could then be downloaded to the office computer to create lists of items needed in the purchases department for jobs. |
|
| 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 companies 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 Receivable 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 enabling each child to have a credit card like account where lunches and juice money payments could be charged and monthly billing statements conveniently were sent to parents. |
|
| Project: |
Elevator Sales Invoice System |
| Client: |
Dover Elevator Company |
| Description: |
Jan designed a dBase 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: |
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 oriented Spreadsheet 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: |
Excel Programming and Design |
| Client: |
BioTrak Corporation |
| Description: |
Excel spreadsheet template for customer proposals given to customers as a free financial model. Program implemented drop down menus and automatically populating cell areas with data depending on the selections chosen by the user. Their customers enjoyed receiving the software for their own satisfaction and financial review of discount factors is 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 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 |
| Client: |
West Virginia Department of Employment Security |
| Description: |
COBOL programmer for the State of West Virginia Department of Employment Security, Division of Labor and Economic Research, Wrote a COBOL program that calculated and printed WV unemployment statistics. Jan organized detailed flowcharts and designed a written analysis of a complex COBOL program, part of a Federally funded computer project. |
|
| Project: |
Accounting and marketing support |
| Client: |
Foxfire Camping Vacation Resort |
| Description: |
Large vacation resort camp ground and year round family recreation center. Helped with advertising campaign doubling their business. Assisting with Accounting System overhaul, mass mail marketing brochures and database support. |
|
| Project: |
Computer Instruction & Advisory Council |
| 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 competence training. |
|
| Project: |
SMS Health Record Software |
| Client: |
CAMCARE, Inc. |
| Description: |
CAMCARE Inc. - One of the largest national health care providers in the United States- 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. |
|
| Project: |
Financial Accounting 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 of insight and 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 market direct mass mailing database for Servco Fasteners Company. |
|
| Project: |
Lottery Program |
| Client: |
Gaming client |
| Description: |
Designed a lottery program in Microsoft Excel. |
|
| 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 near real time. The program is menu driven with viewing and printing options menus within Quattro Pro. |
|
| Project: |
Lotus 123 macro programming enhancements |
| Client: |
Tony Valentine Construction Company, CA |
| Description: |
Enhanced a Lotus 123 spreadsheet for sales control, auditing and accounting reports. Designed an accounting program prototype for marketing in Microsoft Excel. Modules include Purchasing, inventory, check register, payables, monthly and yearly profit loss reports. |
|
| Project: |
Garden Center Inventory System |
| Client: |
Valley Gardens Garden Center |
| Description: |
Inventory reports could be sorted by the sizes of plants, families of plants, types of plants, costs of plants and many other sort variations allowing the company greater flexibility to produce reports that were used as sales fliers, marketing advertisements and inventory assessment |
|
| Project: |
Computerized Music Song Chord Notation Database System |
| 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 members 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 gave 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, quality assurance computer training |
|
| Institution: |
Benjamin Franklin Career & Technical Education Center |
| Position: |
Computer Instructor |
|
| Institution: |
Training Place, Town Center Mall, Charleston, WV |
| Position: |
Securely uses strategies for business data in a rich and streamlined 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 in computer technologies based on business models |
|
| 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, PRG, COBOL and BASIC programming. Logic and systems analysis, programming and coding strategies. Transparency of accounting, utilizing network based telecommunications and computer 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 Landscaping 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.
|
|
|
Certified Computer Services is listed in the Better Business Bureau's database of businesses with the highest rating possible.
Copyright © 2007 Certified Computer Services |
| |
|
Experience 
