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 |
| |
|
Return
to top of page 
