|
|
 |
Jan Levenson lead programmer at 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 process programming
labor intensive tasks to a few automated 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:
|
|
| DATABASE SPREADSHEET PROGRAMMING DEVELOPMENT
and SUPPORT |
| Project: |
Analysis Dentistry book keeping System written in Microsoft
Excel |
| Client: |
Accounting Specialist Company specializing in simplifying Dental
accounting bookkeeping systems programmed using Microsoft Excel |
| Description: |
Jan's programming / analysis skills assisted in developing
a Professional Accounting System written specifically for Dental
practices and could be used in small medical or health related
practices or Small business offices. Real-time graphs are the
key to the software that display for all profit and cost margin
reports. Making this program a very to use accounting system
with a WYSIWYG "what you see is what you get". Enter the data
and see the data reports in multi colored graphs, accounting
bookkeeping system. |
|
| 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 designed as 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: |
Accounting system update and rewrite in Microsoft Excel |
| Client: |
Nationally Recognized College |
| Description: |
Spreadsheet Accounting System rewrite in Microsoft Excel Visual
Basic. This project included analyzing, debugging and adding
new additions to an extremely large and multifaceted accounting
system used by the college adding new design improvements and
support. Client exclaimed, "you really do help people,
it is such a large and complex spreadsheet." |
|
| 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
the company to bypass manually entering data into QuickBooks.
This process automatically imported data from satellite offices
daily Excel spreasheets via secure email to the home office QuickBooks
Professional Accounting System whereby with Jan's macro's, correct
balanced accounting processes and flags were maintained in their
QuickBooks Accounting system after importing each Excel set into
their main office Quickbooks Accounting system, saving additional
data entry costs (time and money) everyday. |
|
| Project: |
Shipping service tally sheet used to automatically
notify apartment residence of shipping packages due to be delivered
via email |
| Client: |
Nationwide Apartment Management Company |
| Description: |
Microsoft Excel Spreadsheet Visual Basic Macro programming,
design and support. The spreadsheet was used to send emails to
residences that were to receive packages via different mail courier
services automatically with included shipping pickup information.
A second generated log sheet was used for each resident to sign
off with their name when they received their packages as noted.
The sheet would automatically be reset as needed and recreated
automatically on a daily basis with a backup of the sheet used
for record keeping purposes and to remind residences of when
packages were to be received or picked up using their shipping
pickup preferences. |
|
| Project: |
Graphing Utility Usage Software Microsoft Excel Visual
Basic |
| Client: |
Real Estate Management property's maintenance and utility usage
records, Crescent Heights, Los Angeles, California 90035 |
| Description: |
Automated Real Estate rental properties maintenance records
usage 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 client´s
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, Excel spreadsheet data was converted so that sales
billing statements, addresses, quotes, client lists and invoices
were instantly available in QuickBooks Pro with customer data
ready to print (Quickbooks invoices 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 their
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 by the national
territory sales team. |
|
| 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 of individual river systems.
CCS (Jan) won consecutive multiple bid contracts on projects
including 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. Updating templates for forms as a vba developer.
This increased efficiency in National office document processing. |
|
| Project: |
Microsoft Excel Visual Basic PLC Programming Logic |
| Client: |
Engineering Firm - Missouri |
| Description: |
Wrote a program that interfaced Microsoft Excel Visual Basic
with mechanically machinery. The program could be used as a control
panel and 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 using a PLC interface to Visual Basic and Excel. |
|
| Project: |
Pharmaceutical Drug Trials event planning scheduling
program written in Excel Visual Basic |
| Client: |
Johnson and Johnson Pharmaceuticals |
| Description: |
Multiple projects included developing an easy to use form for
senior marketing people world wide in different international
Locations of this billion dollar company to quickly calculate
sets of dates of prospective Pharmaceutical Drug Trials (event
planning scheduling). The program was written in Excel Visual
Basic with a graphic interface. |
|
| 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 sales person´s travel cost analysis 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 invetory and⁄or service sub contracting jobs needed
in the purchases department for jobs. |
|
| Project: |
National Education Consulting Services and Solutions
Group, a National Education Analysis Resource for local statistics |
| Client: |
National Education Consulting Services and Solutions Group |
| 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 from different perspectives for education
courses, teachers, students and strategic analysis programs to
assess degrees of success and/or failures by various statistics. |
|
| 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. Comments made
by the client
"You did a knock out job on the project", "thank
you Jan", "thank you for you lightning fast turn around", |
|
| Project: |
Development of a real time, multi membership, web based
interactive Sports Statistical analysis entertainment program
web site. |
| Client: |
Sports Statistical analysis entertainment program |
| Description: |
Development of a real time, web based multi membership web
site interactive Sports Statistical analysis entertainment program |
|
| 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,
vitamin iu, vitamin rae, vitamin B12, vitamin B6, vitamin C,
vitamin E, vitamin 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 using expectations
and probability of individual slot machines to audit expected
profits and or losses of thousands of slot machines for management
reports. |
|
| Project: |
Real Estate Financial Analyst/Developer Automatic download
of web site data to the client's computer for mass mailings |
| Client: |
Real Estate Financial Analyst/Developer |
| Description: |
Researched and developed automated software using Computer
Automation Programming Tools, Network Automation's automation
tools, Macro Express Tools, Automation Anywhere Automation Tethys
Solutions that most powerful and capable automation programming
tools currently available to automate complex sequences of different
computer processes, Jan automated real time website download
of system data to the client's office computer system for dispersion
and mass mailing distribution (increasing sales, saving time
and steps to sell real-estate. Jan programmed the macro languages
creating a complete automatic download of real-estate foreclosure
data and automatically calculated standard real-estate houses
pricing practices used to establish the actual value of houses
for sale, foreclosure or other real-estate uses, so that a current
listing of actual prices with the brokers percent of profit on
the sale included so that the real-estate broker could determine
what properties were within the criteria they wanted to purchase
and offer to clients and at the same time send mass mailing of
thousands of currently available houses to prospective purchasing
information, what ever real-estate descriptions about the properties
so that the potential buyers could make a decision on properties
they may want to purchase and send back to the broker a contract
to finalize the sale, because all of the paper work determining
standard methods of costing methods had already been prepared
by the software, allowing and automated system, that could be
updated on a daily, weekly, monthly or other schedule with near
real-time data to make fast sales, offer excellent purchasing
properties for clients, and after verification, of all of the
paper work, a quick sale could be made, so you would have a happy
salesman, and a happy buyer with purchase of their dreams, profit
for the sales team and savings for the buyer, by receiving a
no haggling form of buying and purchasing of real estate. this
system could be used with many forms of real-estate, car and/or
other researchable products whereby the computer data is available.
with up to twenty comparisons of similar properties values so
those quick sales could be made to potential home owners looking
for low cost housing and ownership. RealQuest real estate web
site was used for an almost inexhaustible list of foreclosure
and any other type of real estate records for research and automated
sales. This program could run 24 hours per day on a dedicated
computer with internet access. It would take a team of computer
data entry persons 24 hours per day seven days a week, to do
the same work as the automated program. |
|
| 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 batch data files processing, inventory database. |
|
| 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 satisfy government report requirements
and print reports. |
| Client: |
Turner Construction Company |
| Description: |
Won multiple bid contracts from this international construction
company. Jan was asked by a senior CPA Financial Analyst for
this international company to design a customized 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 and reports could
be based on governmental reporting requirements. 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
compiler programming. 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) users
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 performance analyst for personalized
software. |
|
| 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, reports
and auditing. |
|
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 solution integration source code
programming. transforming consolidated accounting practices,
systems evaluations demonstrations, easy-to-use technologies, |
|
| 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. |
|
| Project: |
Designed an Excel program that simplified the sales
telephone, faxing and email contact order system |
| Client: |
Maddox Shelving Sales Company |
| Description: |
Designed an Excel program that simplified the sales telephone,
faxing and email contact order system to help speed up and increase
sales for a Midwestern company that sold volumes of Maddox shelving
products. |
|
| Project: |
Superior Test and Balance Inc. |
| Client: |
Superior Test and Balance Inc. |
| Description: |
Designed an automated spreadsheet for equipment maintenance,
quality control and certification records. |
|
| 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
increasing a data rich environment using Analysis, trends, visual
graphic representations (numeric data graphs) easy-to-use technologies,
increased efficiency, logical operations, security, solutions,
better results, controlling strategies, reduced errors, more
reliable software performance, strategic issues. 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 Training Programmer |
| 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.
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.
|
|
|
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 |
| |
|
    
Automation Software for business, consulting,
sales, scientific, automated techniques software, voting systems,
opinions research, automated data mining, and databases integration
turned into simple to use turn key systems. Web site integration,
Spreadsheets, Microsoft Excel, Lotus 123, Quattro Pro, FoxPro,
MySQL, databases, QuickBooks accounting, billing, inventory,
integration, migration, PLC (program logic control), word processors,
data management, programming hardware and software integration.
The user is responsible for all computer hardware, software,
licenses, network software, secure connections, internet access,
if internet access is required for your automation process).
Specialized databases, web sites links, electronic services,
licenses or subscriptions that will be used within the automation
process. Integrate processes into one automated process that
can be initiated from your computer desktop. The automation software
automated services supplied by Certified Computer Services allows
all processes that the user can produce manually to take place
at a certain time or time interval. Contact this Jan at Certified
Computer Services for a free proposal for your project to determine
the amount of labor hour units that will be necessary to complete
your automation project. Make the magic happen! Projects will
be accepted on a first come, first serve basis. Project time
line will depend on the current workload. Please contact us to
discuss special issues and options that are available for your
automation project. For real estate related research purposes
the user would need a subscription to a real estate database
site similar to RealQuest.com and have access an internet connection,
a dedicated computer and /or software that to obtain the users
results. Real-estate foreclosure or any available criteria to
search for (potential clients) and automatically calculate standard
real-estate comparable houses pricing practices to establish
the actual value of house. A current regional area listing of
actual price percent of profit, on the sale can be determined
by criteria variables that are previously defined, and offered
to (prospective customers for a particular product). Potential
buyers could make decisions on properties they may want to purchase
and sign an agreement or contract to finalize the sale, via automated
email, fax and / or courier services. Real Estate Financial data
can be automatically downloaded from a web site similar to www.RealQuest.com,
logical, operations multiple sorts and filtering of data, formulas
applied data manipulation automatic mass mailings by e-mail or
courier services can be sent to potential clients. Up to twenty
comps of similar regional properties are compared and the correct
value determined by the user by way of formulas. Quick sales
can be made to potential home owners looking for low cost housing
and ownership. www.RealQuest.com real estate web site was used
for an almost inexhaustible list of foreclosure and any other
type of real estate records for research and automated sales.
This program should run on a dedicated computer without interference
except for periodic observation, by the user that it is running
correctly, (viewing program logs). Computer Automation Programming
Tools allow automation to be commenced from your desktop to produce
sophisticated, complex, elaborate reports (for your particular
use) (mass mailing lists, pre sales contracts can be signed on
a near instantaneous basis. Automate complex sequences of computer
processes, automate real time websites, download of current data
for dispersion and mass mailing distribution (increase sales,
saving time and money to sell specialized products or services,
collectibles or information mining, in one step using one computer.
Paper work prepared, and sent to prospective customers. Reports
can be updated with fresh data searches resulting in live data
to make, new exciting offers for clients or buyers, researches,
analysis, etc. After verification, contracts can complete the
deal; a quick sale can be made. Customers (clients) are happy
with fresh data to make quick finds treasured deals, decision
report filtering, sorting, tally, sophisticated data manipulation,
logically based data for distribution for the user to obtain
results they are seeking. Personal use or professional use -
many options are available to automate processes. Customers purchase
their product; the user can set profit margins and / or use a
no haggling form of buying and purchasing. This system can be
used in many different forms, different areas of commerce, research
etc., or other researchable products whereby the computer data
is available. The automation can be tailored to your exact needs.
It could take teams of computer data persons 24 hours per day
seven days a week, to do the same work, as the automated program
on one computer. The speed of the automation depends on the software
languages used, the speed of the computer and peripherals, the
speed of the internet connection, and the complexity and number
of formulas and/or or programming routines that are necessary
to derive at a particular set of reports of data for the user.
It is the user's responsibility to supply the internet access,
data, web hosting service for a dedicated web site server, data
computer ready lists, database software, subscriptions, any special
language licenses for the computer hardware or software, other
than the automation software licenses that will be supplied by
our company. There are many solutions that are available that
may require more or less programmed labor hours. Customized automation
macro advice and automation software license starts at $650 U.S.
dollars. This includes 10 unit hours programming analysis at
$65 U.S. dollars per hour. Contact CCS for a free proposal to
determine how many unit hours will be necessary to complete your
project. (What will be involved and how long your project will
take to complete) before you finalize and purchase work hours
to be applied to your project. An abbreviated description proposal
with an estimate to complete you automated process will be included
and sent to you for your review. Contract agreement services
are available and special arrangements may be considered. The
automation process is dependent on a repeatable set of commands
(no matter how complex) that you currently use or are wanting
to use to obtain a particular computerized result. The automated
process can be repeated as needed. Many services are available
at www.ccsplus.com listed on the Better Business Beaurow Web
site bbb.com as Certified Computer Services with a satisfactory
(highest) customer rating. Contact CCS for a free estimate to
determine how many programming labor hours and or other costs
will be necessary for your project. Thank you. All requests will
be kept confidential and answered as completely as possible.
Project work is portioned in a "work as you go basis", so you
can see progress being made on your project taking place before
making further payments and commencing to the next step of your
project. On a large or very complex project it may be necessary
to charge for one to several programming analysis hours of labor
to make a careful evaluation of what is needed to complete your
software project. Please contact CCS@ccsplus.com for a free estimate
on what is needed to proceed to on your project. Thank you. Sincerely,
J. S. Levenson Certified Computer Services Certified Computer
Services is an experienced computer company offering solutions
for many computer programming topics: including (spreadsheets
workbooks, worksheets and advanced tables) converting outdated
programming to newer versions of software (databases, spreadsheets,
Excel, Lotus 123 and Quattro Pro). formulas resulting in easier
to use, more meaningful information for the end user.
Current professional software support includes: software analysis
and deployment, enhanced functionality, development, digital
processing, faster speed optimization, increased efficiency,
logical operations, security, solutions,better results, controlling
strategies, reduced errors, more reliable software performance,
strategic issues, risk assessment, rapid software development,
modeling operations, transparent help desk, web based, virtual
office, verify accuracy, spread sheet programming macros and
scripts programming development, help with VBA Visual Basic applications
macros, Microsoft Excel, Corel Quattro Pro, Lotus 123, Visual
FoxPro, QuickBooks Professional, technical writing, editing,
technical manual writing editor, database management control,
hospitality management systems - micros pos spreadsheets interfacing
with Microsoft Word, Word Perfect, Windows Professional, XP,
Vista, Microsoft Visual FoxPro, Computer animated graphics, internet
web design html, css, Java, seo search engine optimization editing,
web page development, Paint Shop Pro imaging, desktop publishing,
structured programming techniques, Logic&flowcharting, applications
development, accounting programs Intuit QuickBooks professional
integration, forensic data password recovery research, accounts
setup, systems analysis and design.
A certified computer professional helps you with your work. Solution
Provider, custom designed unique turn-key automatic applications.
If you need help converting Lotus 123 macros to Excel Visual
Basic macros, Quattro Pro to Excel VB macros, databases, spreadsheet
programming. linking scripts macros, interactive, skills accounting
management system, software integration, software development.
Online spreadsheets, computer help desk available 24/7/365. Applications
programming development designed for Lotus 123, designer spreadsheets,
Visual FoxPro - VFP - Visual Basic- Teacher educator trainer
can help and be of assistance. accounting system integration,
template advanced programming, app integration, application automation,
architecture database, automated integration, automation interface,
business spreadsheet, calc conversion, chart analyst compiler
programming, applications analyst, clipper conversion, coldfusion
programmer, computer applications help, computer programming
logic, computer coders, Facilitating, support, programming methods
and results. Automated computerized programming. marketing advertising.
If you ask,"where can I find good computer help"or"I
need help with a computer Project?"Or"who can I trust
to find programmers computer work offering Reliable help?"Online
database systems. Languages compatible for most available software
and computers. Contact Certified Computer Services. Our specialty
is to solve problems with easy to use, customized database and
spreadsheet programs, complex large spreadsheets, original out
of the box creativity, flexible macros and scripts solving complex
problems. If you need temporary help, our staff is technically
and computer ready to help. Professional spreadsheet computer
help is a call away + simplify your work load - business spreadsheet
solutions, get more done in less time - data entry forms - input
output menu driven applications with multiple choice easy to
use menu systems for database and spreadsheet and accounting
systems.( buttons, pull down, multi choice menus) Jan Levenson,
software developer has developed distributed spreadsheet systems
using excel software integration source code hardware integrate
applications, integrate apps integrating software, integrating
systems, excel 6.0, lotus 1 2 3,lotus 9.8,123 97, 1-2-3 Millennium
Edition, Excel XP, Quattro Pro 9, or Calc 6, Quattro Pro for
Windows, Microsoft Excel 5.0 6.0 7.0 1.0 dos versions lotus approach,
lotus conversion, lotus smart suite, lotus SmartSuite 9.8, VB
, vb6 excel VB FoxPro, vb net excel, vb net FoxPro, plc automation,
lotus SmartSuite millennium, Microsoft access spreadsheet, Microsoft
office spreadsheet, FoxPro database software, internet programmer,
FoxPro, visual basic, excel dbase, spreadsheet 123 accounting
Jan Levenson lead director of programming and Certified Computer
Services provide the following: engineering programmer, IT programmer, excel
consultants, excel conversions, excel developer, excel experts,
excel migrations, excel relational database managers, excel spreadsheets,find
programmers, FoxPro access, FoxPro conversion, function programming,
historical analyst, India programmers, applications architecture,
softwares management, solution, solutions, technology, interface
programming, Linux programmer, Macintosh macro programmer, methods
analysts, Microsoft spreadsheet help, model analyst, model database,
monthly spreadsheet,ms access conversion,ms access spreadsheet,ms
spreadsheet, object oriented spreadsheet,odbc database,office
web components spreadsheet, online programming course, open conversion,
opens source conversion, Openoffice conversion, pivot table spreadsheet,
pocket pc custom, price analyst, problem analyst, process analyst,
process control automation, process migration, process software,
product integration, product software, production analyst, professional
programmer programing computers, programing help, programmer
agreement, programmer developer, for hire, India, programmers
help project integration, project management integration, project
management software, management spreadsheet, migration, quality
control, project spreadsheet, PeopleSoft, paradox conversion,
qa programmer, quantitative analyst, Quattro conversion, quickbook
developer methodology, quote analyst, Rdbms database, query spreadsheet,
requirements software, research analyst simulation analyst software
integrators, software life cycle, lifecycle, methodologies, methods,
models, programmers, sdlc,analysis spreadsheet converters spreadsheet,
databases spreadsheet developer, spreadsheet development, doc,
document, engineering forecasting, format, forms, formulas, functions,
help lotus openoffice, operations, optimization pdf, pro, problems,
programs, projects report, research share, simulation source
code, statistics stocks, table techniques, template testing,
tools, trading sql conversion,sql migration statistical analyst,
analyst support programmer, systems administrator, systems automation,
systems programmer tables, technical programmer calendars, telecommute
programmer, text to conversion, Toronto tutor trade trading analyst,
training automation, transportation analyst, Unix programmer
vb excel, vb6 programmer, vba programmer,vba,visual basic 6 programmer,
visual basic accounting, visual basic automation word, works
conversion, wps conversion, xls, xml programmer. Save money (up
to thousands of dollars) Contact us for customized programming
analysis services. Thank you!
Certified Computer
Services Company Offering Excellent help Writing and Designing
Spreadsheet Applications with Excel, Lotus 123 and Quattro
Pro.
Email Jan for expert
computer spreadsheet help and assistance today.
You will be glad
you did .
Help is a click
away!
Please Email
for expert, reliable help and assistance today. Thanks
!
|
|
|
Experience 
