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),
Jan Levenson, of Certified Computer Services can help you
solve business problems by using powerful computer software
to your best advantage.
Jan Levenson of 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 Programmer 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. 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 account processing). |
|
| Project: |
Equipment Maintenance Control Corporation automated
Vendor Invoicing System (paperless office) |
| Client: |
Equipment Maintenance Control Corporation |
| Description: |
Jan developed an Excel system that EMC Corp. wanted, an automated
paperless 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, linked information 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 can be 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 training seminars,
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 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 user friendly data entry
and functionality to reports in 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 |
| |
|
Spreadsheet
Programming
Return
to top of page 
