Experiences of
J. S. Levenson, Certified
Computer Services
Expert Computer
Services  A + 
Five Stars   ☆☆-☆-☆-☆
Spreadsheet Programming





FoxPro
                                          database
                                          software

FoxPro
                                          database
                                          software

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Microsoft
                                          Excel,
                                          Corel Quattro Pro,
                                          Lotus 123, Visual
                                          FoxPro, QuickBooks
                                          Professional

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Intuit
                                          QuickBooks
                                          professional
                                          integration

Intuit
                                          QuickBooks
                                          professional
                                          integration

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                           spreadsheet
                                           rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Intuit
                                          QuickBooks
                                          professional
                                          integration

Microsoft
                                          Excel,
                                          Corel Quattro Pro,
                                          Lotus 123, Visual
                                          FoxPro, QuickBooks
                                          Professional

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          conversion
                                          project

Excel
                                          spreadsheet
                                          conversion
                                          project

Excel
                                          spreadsheet
                                          conversion
                                          project

Excel
                                          spreadsheet
                                          conversion
                                          project

Excel
                                          spreadsheet
                                          conversion
                                          project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          convert project

Excel
                                          spreadsheet
                                          convert project

Excel
                                          spreadsheet
                                          convert project

Microsoft
                                          Excel,
                                          Corel Quattro Pro,
                                          Lotus 123, Visual
                                          FoxPro, QuickBooks
                                          Professional

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project



app
                                          integration
                                          application
                                          automation
                                          architecture
                                          database automated
                                          integration
                                          interface

Excel
                                          spreadsheet
                                          rewrite project

FoxPro text
                                          database book
                                          editing

app
                                          integration
                                          application
                                          automation
                                          architecture
                                          database automated
                                          integration
                                          interface

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

app
                                          integration
                                          application
                                          automation
                                          architecture
                                          database automated
                                          integration
                                          interface

Excel
                                          spreadsheet
                                          rewrite project

Microsoft
                                          Excel,
                                          Corel Quattro Pro,
                                          Lotus 123, Visual
                                          FoxPro, QuickBooks
                                          Professional

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

app
                                          integration
                                          application
                                          automation
                                          architecture
                                          database automated
                                          integration
                                          interface

Microsoft
                                          Excel,
                                          Corel Quattro Pro,
                                          Lotus 123, Visual
                                          FoxPro, QuickBooks
                                          Professional

Microsoft
                                          Excel,
                                          Corel Quattro Pro,
                                          Lotus 123, Visual
                                          FoxPro, QuickBooks
                                          Professional

Microsoft
                                          Excel,
                                          Corel Quattro Pro,
                                          Lotus 123, Visual
                                          FoxPro, QuickBooks
                                          Professional

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel VBA
                                          visual basic 6
                                          programmer

Excel VBA
                                          visual basic 6
                                          programmer

Excel VBA
                                          visual basic 6
                                          programmer

Excel VBA
                                          visual basic 6
                                          programmer

Excel VBA
                                          visual basic 6
                                          programmer

Excel
                                          programming
                                          spreadsheet
                                          rewrite project

FoxPro
                                          database software
                                          Programmer

Excel
                                          programmer
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project


FoxPro
                                          database
                                          software

FoxPro
                                          database
                                          software

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Microsoft
                                          Excel,
                                          Corel Quattro Pro,
                                          Lotus 123, Visual
                                          FoxPro, QuickBooks
                                          Professional

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Intuit
                                          QuickBooks
                                          professional
                                          integration

Intuit
                                          QuickBooks
                                          professional
                                          integration

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                           spreadsheet
                                           rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Intuit
                                          QuickBooks
                                          professional
                                          integration

Microsoft
                                          Excel,
                                          Corel Quattro Pro,
                                          Lotus 123, Visual
                                          FoxPro, QuickBooks
                                          Professional

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          conversion
                                          project

Excel
                                          spreadsheet
                                          conversion
                                          project

Excel
                                          spreadsheet
                                          conversion
                                          project

Excel
                                          spreadsheet
                                          conversion
                                          project

Excel
                                          spreadsheet
                                          conversion
                                          project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          convert project

Excel
                                          spreadsheet
                                          convert project

Excel
                                          spreadsheet
                                          convert project

Microsoft
                                          Excel,
                                          Corel Quattro Pro,
                                          Lotus 123, Visual
                                          FoxPro, QuickBooks
                                          Professional

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project





Excel
                                          spreadsheet
                                          rewrite project

FoxPro text
                                          database book
                                          editing

app
                                          integration
                                          application
                                          automation
                                          architecture
                                          database automated
                                          integration
                                          interface

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

app
                                          integration
                                          application
                                          automation
                                          architecture
                                          database automated
                                          integration
                                          interface

Excel
                                          spreadsheet
                                          rewrite project

Microsoft
                                          Excel,
                                          Corel Quattro Pro,
                                          Lotus 123, Visual
                                          FoxPro, QuickBooks
                                          Professional

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

app
                                          integration
                                          application
                                          automation
                                          architecture
                                          database automated
                                          integration
                                          interface

Microsoft
                                          Excel,
                                          Corel Quattro Pro,
                                          Lotus 123, Visual
                                          FoxPro, QuickBooks
                                          Professional

Microsoft
                                          Excel,
                                          Corel Quattro Pro,
                                          Lotus 123, Visual
                                          FoxPro, QuickBooks
                                          Professional

Microsoft
                                          Excel,
                                          Corel Quattro Pro,
                                          Lotus 123, Visual
                                          FoxPro, QuickBooks
                                          Professional

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel
                                          spreadsheet
                                          rewrite project

Excel VBA
                                          visual basic 6
                                          programmer

Excel VBA
                                          visual basic 6
                                          programmer

Excel VBA visual basic 6 programmer

Excel VBA visual basic 6 programmer

Excel VBA visual basic 6 programmer

Excel programming spreadsheet rewrite
   project

FoxPro database software
   Programmer

Excel programmer spreadsheet rewrite
   project

Excel spreadsheet rewrite project

Excel spreadsheet rewrite project

Excel spreadsheet rewrite project
J. S. Levenson owner, instructor and lead programmer at Certified Computer Services has worked for twenty five years as a Computer Instructor,
Programmer ⁄ Analyst, offering software-programming solutions for businesses of all sizes.  

Specializing in automation programming featuring Excel, Lotus 123, Quattro Pro, Word, Word Perfect, FoxPro database, QuickBooks accounting software, Visual Basic, php, Java script, automation anywhere. We take a seemingly impossible and difficult tasks make them easy to use, saving you time, labor and money. Automation techniques decrease errors and fatigue, simplifying your computer chores, turning labor intensive tasks into a few simple steps.    Headquartered in beautiful West Palm Beach, Florida (USA), Certified Computer Services can help you solve difficult business problems using powerful automation software to your best advantage.

Our goal is to offer you trust, confidence and a job well done. Call 1-561-843-2944 now!

Certified Computer Services five star A+ highest possible rating.

The following Programming and Consulting jobs are in the experience portfolio of J. s. Levenson/Certified Computer Services.  Jan has received many accolades for his innovative work.


Project:  Micro Stock exchange real time Ticker Tape Trading Analysis Program
Client:  Client in England using eSignal real time worldwide stock exchange data analysis system
Description:  Developed a Microsoft Excel Visual Basic macros that enabled the client to receive live streaming ticker tape data from various data sources showing trends updated in real time every second. Instant micro trading decisions can be made using micro trading on the stock exchange. This program was designed as a custom add-on using eSignal real time data sources streaming ticker tape. This speeds up buy or sell orders and relevancy decisions for the trader.

Project:  Excel Spreadsheet Programming, Design Analysis and Support
Client:  J.P. Morgan Chase Finance
Description:  Spreadsheet System problem resolution. This project included analyzing, debugging and creating additions to a large multifaceted internal financial Spreadsheet used for sales incentives and reports.

Project:  Internet accounting automation John Deere Corporation computerized system Excel add-on program.
Client:  John Deere Corporation Management
Description:  Information could be download from the John Deere web Configurator Web Configurator web clearing house of company data Cover page and a Lease breakout page converted into a Quote Programed in Microsoft Excel visual basic spreadsheet for employees. Jan programed Automation Anywhere allowed employees to use the JD company database on the internet (computerized system by John Deere Corporation). The Internet Web Site Configurator system automated data so the sales person could design invoices with correct spelling, wordage and prices from the main online catalog imported to an Excel spreadsheet. The AUTOMATED data extraction tool utilized down loadable data imported into an Excel version of the quote. Sales & Operations Manager A project tracking inventory shipments and checklist summary that was automatically entered into a database for reports. The program was user friendly to allow easy data entry and easy to read navigation menus.


Project:  Customized software to import and export QuickBooks data, saving time and money.
Client:  Various Business Accounting related clients
Description:  To create a specialized set of books for business or industry you use a file called an .iif data file. These data files allow input and export data into and from QuickBooks pro. Using .iif data files you can specify the exact names and accounting names and functions, sequence even large sophisticated sets of books to export the data in a specified format, transposing accounting account names to a new or customized set of books specified by commands you create.

Project:  Product safety check sheets. Technical safety specifications for train tank car requirements and checks.
Client:  National Energy Company
Description:  Converting a Quattro Pro spreadsheet to Microsoft Excel macros. Train car chemical product limitations, safety checks and parameters from COMPANY database data compared to tables of safety checks and allowances. used To fill train tanker cars with propane and other fossil fuels.

Project:  Paid Consultant programming corrections and design corrections for a non-functioning complex Excel Spreadsheet for a Security Based Programming Engineering.
Description:  Spreadsheet tool used by the Army Corp of Engineers to simulate materials reactive modeling and imagery for a variety of reports for National Homeland Security.

Description:  Spreadsheet Microsoft Excel Visual Basic Macro programming, design advice. Accounting system updates and rewrite in Microsoft Excel
Client:  College accounting system
Description:  Spreadsheet Accounting System rewrite in Microsoft Excel VB Visual Basic. This project included analyzing, debugging and adding new additions to a large 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:  Quick Books Professional quick, easy and efficient method to enter large amounts of data;
Client:  MGMT. Group, Inc. Las Vegas, NV
Description:  Jan programmed Visual Basic macros that allowed the company to bypass manually entering data into QuickBooks professional . This process makes quick, easier and more efficient to enter large amounts of departmental sales; Automatically imported data from satellite offices via secure emails to the home office. QuickBooks Accounting System correct balanced accounting processes and QuickBooks professional flags were maintained in their QuickBooks Accounting system after importing each Excel file into their main office QuickBooks Accounting system saving (time and money.

Project:  Shipping service tally sheet used by office personnel so they can automatically notify each apartment residence of shipping packages due to be delivered to their reside ENE.
Client:  Nationwide Apartment Management Company
Description:  Microsoft Excel Spreadsheet Visual Basic Macro programming, design and support. The spreadsheet was used as a helpful tool as an automatic process to send emails to residences when packages via different mail courier services were ready to be picked up at the main office with 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 pending packages were to be received or picked up using their shipping pickup preferences. The emails were sent via Excel automatically if person's had email, else other communication was used. Automated emails notified condo owners or renters.

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
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 usage and cost totals over a four year period. utility usage and billing averges were presented in attractive easy to understand graphs. The charts could then be used for marketing or printed out for client's to visualize their consumption of different utilities over a period of time. Data was plotted on colorful graphs showing usage in months and years and 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 accounting 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 were 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 concept model whereby most communications take place using email, computerized fax emails, PDF files, electronic messaging and automated payments. A data source and paper trail can be generated as a backup record for the 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 sales. The sophisticated Excel program allows easier scheduling of sales and support personnel and national training sessions 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 Microsoft Word Perfect.
Client:  NOAA - National Oceanic and Atmospheric Administration - United States
Description:  Converted a set of scientific related Quattro Pro spreadsheet formats to Microsoft Excel to generate statistical reports regarding nationwide river flooding potentials. (Jan) won 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 . Updating templates for forms as a VBA developer. This increased efficiency in the National office document processing by converting simple non-functioning Word Perfect Forms to more professionally illustrated and attractive automated forms in Microsoft Word. Visual Basic was used within Microsoft Word to design automated forms.

Project:  Microsoft Excel Visual Basic PLC Programming Logic
Client:  Engineering Firm in Missouri R & D Research and Development
Description:  Jan wrote a program that interfaced Microsoft Excel Visual Basic with packing machinery hardware. The program could be used as a control panel and run routines to maximize the bin content and then communicate to a $70,000 PLC (Programming Logic Control) machine that bagged bulk foods within seconds for a large food producer in California.

Project:  Pharmaceutical Drug Trials event planning tool written in Excel Visual Basic
Client:  Johnson and Johnson Pharmaceuticals International
Description:  Multiple projects included developing an easy to use form for senior marketing Vice Presidents worldwide. This was an easy to use form to quickly calculate sets of data and set dates of prospective Pharmaceutical Drug Trials (event planning scheduling). The program was written in Excel Visual Basic with an attractive graphic interface.

Project:  Lotus 123 to Excel Conversions
Client:  RAC Royal Auto Club Motoring Services, UK
Description:  Converted and designed a complex 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 sales person´s travel costs analysis accounting system. The data could be inputted easily and then exported to the company´s main accounting data system.

Project:  Contractors tool using Microsoft Excel
Client:  Building Contractors - TX
Description:  Multifaceted Contractor's 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 could then be downloaded to the office computer to create lists of 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 business statistics
Client:  National Education Consulting Student/School Aptitude Analysis Services and Solutions Group
Description:  File Conversion Tool Kit Software update for a nationally known Education Consulting Service and Solutions Group. 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 planning to assess education quality and degrees of success and/or failures by various subjects of measured school performance systems for each student.

Project:  Project Management Scheduling Gantt Chart Project Milestones Gantt Chart Analysis Tool using Microsoft Excel
Client:  Project Analysis with active graphing system
Description:  A tool written in Excel Visual Basic. 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 knockout job on the project", "thank you Jan", "thank you for you lightning fast turnaround",

Project:  Development and design of a real time, multi membership, and web based interactive Sports Statistical analysis web site.
Client:  Sports Statistical analysis entertainment program
Description:  Development of a real time, web based multi membership web site interactive Sports Statistical analysis program

Project:  Nutrition and Vitamin software product using Microsoft Excel
Client:  Nutrition and Vitamin Service Company
Description:  Nutrition and Vitamin related software product sold to clients. The program accesses a vitamin nutrition database so that a breakdown of foods consumed on a daily, weekly or hourly basis could be analyzed down to types of food eaten, units of protein, vitamins, carbohydrates, cholesterol, amino acids, weight, calories. (Protein, lipids, Carbs, chol, saturated and unsaturated fats, mono fats, poly fats, water, Vitamins, Protein gram weights amounts food intake).

Project:  Company Address Database Information System
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:  Digital Imaging Company
Description:  Edited a spreadsheet to analyze, calculate and print needed reports for an international oil well discovery business.

Project:  Casino Slot Machine Gaming Profit Analysis System
Client:  Grand Casino Avoyelles
Description:  Successfully implemented and developed a complex Excel spreadsheet using Visual Basic to simplify statistical cost analysis reports using probability of each individual slot machines to audit expected profits and or losses. The program included analysis for thousands of slot machines for management reports. The mathematical known probability of wins for a particular slot machine could be analyzed, the money spent on the machine and compared to the actual wins and losses, management had a new tool to see if the slot machines were working as expected or if there were any issues that needed special attention.

Project:  Real Estate Developer Automation Programmer / Analyst
Client:  Real Estate Broker Financial Analysis System
Description:  Designed a program that automatically downloaded real-time real estate web data to the client's computer for mass mailings and instant sales. (One of those things you see on television to make millions and yes I wrote this one). Successfully researched and developed automated software using Tethys Automation anywhere Programming ools, Macro Express Tools, and Automation Anywhere. The most powerful automation software available to automate complex sequences of computer processes. Automated real time web site seek and copy specified data to the broker's computer system for mass mailings, creating a money profit system automatically, (increasing sales, saving time and money. Jan programmed the macro languages creating a complete automatic system of real-estate foreclosure data. Calculated averages of real-estate of similar types of houses in a neighborhood to establish the actual value of houses for sale. Foreclosure and other real-estate uses, current listing of average prices with the broker’s percent of profit on the sale included so the real-estate broker could determine which properties were within the customer’s interest and budgets. Mass mailing of thousands available houses to prospective customers. The potential buyers could make a decision on properties they may want to purchase and send an email back to the broker (a contract to finalize the sale and sent out), all of the paper work determining standard methods of costing methods had already been prepared by the software, The automated system, could be updated real-time data to make fast sales, offer excellent purchasing properties for clients, After verification, the paper work, and a quick sale could be made. You have a happy salesman, a happy home buyer with the purchase of their dreams, profit for the sales team and savings for the buyer. A no haggling method of buying and purchasing real estate . This system could be used with many forms of real-estate, car and/or other research able products, whereby a dedicated computer is available. With up to twenty comparisons of similar properties values for quick sales could be made to potential home owners looking for low cost housing and ownership. RealQuest real estate internet data an inexhaustible list of foreclosure and other real estate records for automated sales. This program could run 24 hours per day on a dedicated computer with Internet access. It would take a team or data entry persons thousands of hours per day seven days a week, to do the same work as the dedicated computer program produces in hours.

Project:  Development of a Mass Mailing Address Database
Client:  Professional Typing and Computer Services
Description:  Developed a premium Professional database system in the greater Charleston area for mass mailings and marketing. Product sold to top businesses for business to business sales.

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 sales purchase orders.

Project:  State of West Virginia Assets Inventory System
Client:  State of West Virginia
Description:  Designed a computer database application that contained all of the assets of the State of West Virginia, for the state government's "Department of Finance". Complimented on "a job well done" by a CPA analyst from Deloitte & Touché accounting firm.

Project:  Truck Chemical Delivery Inventory System
Client:  Union Carbide Corporation current Dow Chemical
Description:  Documented and developed Lotus 123 spreadsheets from inputted data to analyze yearly deliveries 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 Car dealership that totaled monthly through yearly repair department totals. Printed cost and profit analysis reports for the company's .

Project:  West Virginia state government, Department of Health Comparative costs Analysis System
Client:  West Virginia Department of Health
Description:  Developed a spreadsheet template that produced a comparative analysis of costs, profits and quality control statistics of institutions in West Virginia for the West Virginia state Department of Health.

Project:  School Lunch/Juice Accounting Program
Client:  Catholic School System
Description:  Wrote a School Lunch/Juice Accounts program interfacing a Lotus 123 Spreadsheet template with a FOXPRO database program was used by each student to have a credit card like account where lunches and juice money payments could be charged and attractive monthly billing statements were sent to parents bi-weekly or on a monthly basis.

Project:  Analysis Dentistry Book Keeping System written in Microsoft Excel
Client:  Corporation Specialist's Company Dental accounting Bookkeeping Systems Microsoft Excel
Description:  Jan's programming ⁄ analysis skills assisted in developing a Professional Accounting System written specifically for Dental practices. Could be used in small medical or health care related offices. Real-time graphs are the key to the system that displays profit and cost margins in real-time. This accounting program is easy to use WYSIWYG "what you see is what you get". Enter the data and see the data reports in multi colored graphs. Plain, simple and good.

Project:  Pharmaceuticals Conglomerate Accounting Analyst
Client:  Designed automated, and recommended work solutions to reconcile balance sheets.
Description: 

Helped develop an attractive accounting sheet report complex and easy to use (dashboard) visual graphics menu system. Automation accounting processes in Microsoft Excel and Intuit QuickBooks Professional accounting. Importing QuickBooks data from spreadsheets for different classes (departments). Jan programmed commands to import or export data from QuickBooks accounting software. Commands for daily, weekly and yearly automated data reports, department and product costing. Transforming data into various software applications. Jan designed new additions and functionality to forms. (Quarterly, annual reports). Integrating Excel with QuickBooks (automatically creating .iif files) saving time and (money and increasing accuracy)


Project:  Media real time Sales Data Tracking system for Television, Radio and News Paper media advertising comparisons, showing success or failures of advertising strategies and various advertising market buys.

Client:  National Advertising and Marketing Campaign for Aldis grocery store chain.
Description:  Using data provided by Aldi's headquarters, Jan utilized a raw data database to export data to Excel for reporting purposes to evaluate the effectiveness of a national media advertising buy, week by week advertising by store Divisions. Comparison of total sales lift using TV SALES Store Information Report: Basic reports for advertising analysis. Store List, many thousands of data lists, with all Store details Store list by Division Weighted Weeks Report: Sales increase THRESHOLD weeks vs. STRONG weeks by Division and overall corporate totals. Line charts as well as in a worksheet that shows weekly data.

Project:  Elevator Sales Invoice System
Client:  Dover Elevator Company Inc.
Description:  Jan designed a FoxPro computerized elevator sales invoicing system that printed sales invoices for customized elevators. The regional manager of Dover Elevator Company liked the program and said, "the entire project was paid for when one new elevator was sold using the invoicing system."

Project:  Turner Construction Company Internal Accounting Database Analysis program, government labor requirements and print reports.
Client:  Turner Construction Company, Inc.
Description:  Jan 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 each employee works so that the payroll system could run more efficiently and could be based on the need for special payroll governmental reporting requirements. Employee and project records could be maintained and reports printed for a wide variety of payroll 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 Inc.
Description:  Jan designed and programmed a FoxPro database application that analyzed cost over and under runs (payments that were made by the major federal and state medical insurance companies to a large health care billing financial, 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. Job well done.

Project:  Excel 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) to quickly generate and submit bids for potential jobs. A separate integrated Excel spreadsheet gave the management an overview from every accounting perspective of costs, profits and accounting breakdown on large bids to better manage their bidding process, project management and planning.

Project:  Excel spreadsheet template for customer proposals
Client:  BioTrak Corporation
Description:  Excel Programming and Design Excel spreadsheet template for customer proposals given to customers as a free financial interactive model gift. Program implemented drop down menus and automatically populating cell areas with data depending on selections chosen by the user. Customers enjoyed receiving the software for their own use and financial review of discount factors used in their proposed investments portfolio's performance.

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 bookkeeping system to work better, maintain more records and operate more efficiently concerning reports and auditing.

Project:  Party Sales Business Accounting Program
Client:  Party Sales Funds Raising Business, Dallas, TX
Description:  Accounting system for a Regional Manager of a party sales business used to maintain sales records and details of products sold by each Rep to analyze and calculate commissions, overall costs, analyze profits and expenses, taxes and reports.

Project:  COBOL Programmer / Analyst
Client:  The State of West Virginia, Department of Employment Security
Description:  Jan was employed by the State of West Virginia Department of Employment Security, Division of Labor and Economic Research as a COBOL Programmer / Analyst. Jan wrote a COBOL program that calculated and printed WV unemployment statistics. Jan organized and clarified extremely large detailed flowcharts and designed an analysis of a complex COBOL program for the State of West Virginia Department of Employment Security and Federal integrating the State employment records, part of a federally funded computer programming project.

Project:  Accounting and marketing support
Client:  Foxfire Vacation Resort Inc.
Description:  Vacation Resort and Family Recreation Center. Helped revitalize their advertising campaign doubling the company's business. Assisted with Accounting System overhaul, mass mail marketing brochures and Accounting support.

Project:  Computer Teacher & for Multi-Cap, Inc. and Advisory Council Member
Client:  Multi-Cap, Inc.
Description:  Served as Multi-Cap, Inc. Advisory council member and computer business instructor. Charleston, WV 1992-93. Instructor for clients of Multi-Cap :Overview of the corporate and small business work place critical business record keeping and practices training.

Project:  Instructor for a large medical center, SMS Health Record Software
Client:  CAMCARE, Inc.
Description:  As a Programmer / Analyst Jan's offered security and programming logic, and design concepts that were used in the final actual run time version of this worldwide software life-record keeping system. 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 how to use patient's life record keeping software (real time life records) management system key to achieving accuracy, easy of use and immediate medical life records of patient's. The software allows less errors in patient medical records so medical decisions can be made quicker and more reliably.

Project:  Accounting Software Systems Analysis and Program Implementation
Client:  Canadian Manufacturing Company
Description:  As an Analyst and Consultant Jan recommended and helped implement the financial accounting system to a large manufacturing company in Canada. Allowed quicker reporting and processing of product development and accounting transparency, decision analysis and evaluation of past, current and future business trends.

Project:  Funeral business Sales team and sales analysis system.
Client:  Pierce Certified Public Accountant Management CPA group
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 Microsoft Excel. The lead CPA said "the program has been used on twenty different systems every day 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. Greatly surpassed all expectations of product effectiveness.

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 Analysis Accounting Software Design
Client:  California Veterinary Hospital
Description:  Enhanced integration of Excel accounting spreadsheet data analysis programming and design. Consulting services for a nationally known veterinary practice in California Peer group analysis network solutions integration source code programming. Transforming consolidated accounting practices, systems evaluations , easy-to-use financial analysis system for many Veterinary Hospitals.

Project:  Lotus 123 to Excel iif files 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.

Project:  Lottery Program Simulation
Client:  Gaming client
Description:  Designed a lottery game program written in Quattro Pro spreadsheet Visual Basic macros.

Project:  Statistical Analysis Questionnaire
Client:  Business in England UK
Description:  Designed Questionnaire and statistical analysis real time graphing system for a company in the U. K. The system can be used by a large organization. After questionnaires are answered, data is imported into the main spreadsheet where multiple statistical chart graphs showing relationships of numbers and statistical charts. The program is menu driven with viewing and printing options menus.

Project:  Designed an Excel program that simplified the sales telephone, invoicing system, 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 system to help speed up and increase sales for a Midwestern company that sold volumes of Maddox shelving products. Product orders could be graphically displayed and illustrated to go along with the costing invoices and in store design requested.

Project:  Designed an automated spreadsheet for equipment maintenance, quality control and certification records
Client:  Superior Test and Balance Inc.
Description:  Designed an automated spreadsheet for equipment maintenance, quality control and certification records.

Project:  FoxPro Programmer
Client:  Osteopathic Physicians of West Virginia Inc.
Description:  Jan programmed a membership organizational database that was used to produce form letters, maintain member´s information for expedited support and political action services benefiting the group.

Project:  Wright-Patterson Air Force Base Excel spreadsheet consultant. Bookkeeping Spreadsheet Support
Client:  Wright-Patterson Air Force Base Clerk
Description:  Wright-Patterson Air Force Base Excel spreadsheet consultant. Assisted with a simple efficient bookkeeping system

Project:  Auto Repair Service Center, Business Support and programming
Client:  Auto Repair Service Center
Description:  Computer assistance, trained employees, programmed support for QuickBooks used in a NAPA computerized auto service/repair shop.

Certified Adult Teaching Positions Held by Jan Levenson
Institution: Capital High Community Education Teacher Position: Technical Education Center Instructor, Industrial Computer Instructor

Institution: Benjamin Franklin Career & Technical Education Center Position: Computer Instructor for hundreds of students, business owners, government employees, public and private business, individuals, chemical engineers, accountants,

Institution: Teaching Position: Training Place, Town Center Mall, Charleston, WV Position: Jan instructed a wide variety of computer classes including technology, corporate security measures, employee and computer training software strategies for increasing a data rich business environment using common analysis, trends, visual graphic representations (numeric data graphs) easy-to-use technologies, increased efficiency, logical, security, solutions, records. Reduced errors, more reliable software performance, issues. Business and Industry Computer Instructor for employees of Bell Atlantic Telephone, McDonough, Caperton Insurance Inc. McJunkin Corporation, and employees of the Kanawha County Board of Education.

Institution: Teaching Position: Garnet Career Center, Charleston, WV Position: Computer Instructor of educational computer training classes in computer related technologies. Instructed a variety of students from, business owners to Harvard Graduates.

Institution: Teaching Position: Carver Career Technical Education Center, Belle, WV Position: Business/Industry Instructor organized workspace data processing seamlessly used in simplifying office data.

Institution: Teaching Position: St. Albans High School Community Education Position: Computer Instructor

Institution: Teaching Position: West Virginia Junior College, Charleston, WV Position: Computer Instructor of data processing, computer science, spreadsheet office automation.

Institution: Teaching Position: National Institute of Technology, National Education Center, Charleston, WV Position: Instructor of Computer Science, Accounting, RPG, COBOL and BASIC programming. Logic Analysis, programming and coding strategies. Transparency of accounting, utilizing a computer network tools.

Project:  Chosen Federal Express Industrial Instructor
Client:  Federal Express
Description:  Selected as a spreadsheet-training consultant to train employees of Federal Express.

Project:  Miscellaneous: Professional musician, featured at the World famous Greenbrier Hotel Resort, computerized sheet music system transposed notations. Professional symphony musician, librarian, symphony musician fifteen years
www.ccsplus.com/basses/index.HTML
Jan was the payroll operator in charge of payroll and accounting maintenance at a large Garden Center.

As a Programmer Jan wrote a scheduling program for Educational Tutor Scheduling for Apple Computers.

Jan has programmed many applications regarding Spreadsheets (Quattro Pro, Excel, Lotus 123), file recovery, formulae conversion, computer forensics security, customized accounting software systems for a wide variety of business and computer training, interactive data analysis, license to write Tethys Automation Anywhere coding, scripts and macros software. System Analysis tools and techniques used to analyze the needs of prospective client’s software integration uses and various software programs and data sources, and advised each client on the correct use of the recommended software programs. Certified Computer Services LLC highest business satisfaction rating
Copyright © 2014 Certified Computer Services LLC
 >
Send an Email
   !
Visa MasterCard Discover American Express PayPal src="../../PayPal_logo.gif" border="0" >