Spreadsheet Programming J. S. Levenson Expert Computer Services with a rating of A+by the Better Business Bureau. ☆-☆-☆-☆-☆      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

Computer Experience of J. S. Levenson, Certified Computer Services

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 and Visual basic. We make seemingly impossible and diificult tasks easy to do, saving you time and money. Automation techniques decrease errors and fatigue, simplifying your computer chores, turning labor intensive tasks into a few simple steps.    Headquartered in beautiful Boca Raton, Florida (USA), Certified Computer Services can help you solve diificult business problems using powerful computer 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 is listed in the Better Business Bureau's database of Better Businesses with the highest possible rating A+.

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


Project:  Micro Stock Trading Real Time Ticker Tape Analysis Program
Client:  Client in England using eSignal real time worldwide stock exchange data analysis system
Description:  Developed a Microsoft Excel Visual Basic macro 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 could be made doing micro trading on the stock exchange. This program was designed as a custom add-on using eSignal real time data streaming ticker tape. This would speed up buy or sell orders and relevancy 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 financial Spreadsheet used for sales incentives and reports.

Project:  John Deere Corporation computerized system Excel add-on program.
Client:  John Deere Corporation Management
Description: 

Information could be download from the JD Web Configurator web clearing house of company data Cover page and a Lease breakout page converted into a Quote Program in Microsoft Excel spreadsheet for employees. Jan wrote an Excel program using Automation Anywhere that allowed employees to use the central 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 catalog imported to an Excel spreadsheet. The AUTOMATED data extraction tool utilized down loadable data imported into an Excel compatible 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, prompts, etc.


Project:  Custom software analysis to create customized QuickBooks data
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 to a specified format, backup or 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 physical capability, requirements and checks.
Client:  A 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. To fill train tanker cars with propane and other fossil fuels.

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

Description:  Spreadsheet Microsoft Excel Visual Basic Macro programming, design advice. Accounting system updates and rewrite in Microsoft Excel
Client:  Nationally recognized College
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: 
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 entry into QuickBooks. This process was quicker, easier and more efficient entering large amounts of departmental sales. Automatically imported data from satellite offices daily via secure email to the home office. QuickBooks Professional Accounting System macro, allowed correct balanced accounting processes and QuickBooks professional flags were maintained in their QuickBooks Accounting system after importing each Excel data set into their main office QuickBooks Accounting system, saving (time and money) every day.

Project:  Shipping service tally sheet used personal email to automatically notify each apartment residence of shipping packages due to be delivered to them
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 diiferent 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 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 addresses otherwise other communication was used. Automated descriptions were included with the personal emails.

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 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 diiferent utilities over a period of time. Data was plotted on 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 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 of river systems. (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 documents. Updating templates for forms as a VBA developer. This increased efficiency in 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 automate the forms.

Project:  Microsoft Excel Visual Basic PLC Programming Logic
Client:  Engineering Firm - 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 several 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 using a PLC interface to Visual Basic and Excel.

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 a graphic interface.

Project:  Lotus 123 to Excel Conversions
Client:  RAC Royal Auto Club Motoring Services, UK
Description:  Converted and redesigned 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 contractor - 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 inventory 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 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 diiferent 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 Milestones Gantt Chart 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 knockout job on the project", "thank you Jan", "thank you for you lightning fast turnaround",

Project:  Development 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 company software product using Microsoft Excel
Client:  Nutrition and Vitamin Service 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 analyzed down to types of food eaten, units of protein, vitamins, carbohydrates, cholesterol, amino acids, weight, calories. (Protein, lipids, Carbs, chol, saturated fats, mono fats, poly fats, water, Vitamins, Protein gram weight amounts totals daily food intake).

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:  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 expectations and probability of individual slot machines to audit expected profits and or losses. The program included analysis for thousands of slot machines for management reports. With the mathematical known probability of wins for a particular slot machine could be analyzed the money spent on the machine and 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 site 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 Automation Programming Tools, Macro Express Tools, and Automation Anywhere. Tethys the most powerful automation programming tool available to automate complex sequences of computer processes. Automated real time web site seek and copy specified data to the client'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 thr 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 budget and offer to buyers. Mass mailing of thousands of currently available houses to prospective purchasers, could be emailed to potential 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), all of the paper work determining standard methods of costing methods had already been prepared by the software, The automated system, could be updated with near real-time data to make fast sales, offer excellent purchasing properties for clients, and after verification, all of the paper work, 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 automatically. This system could be used with many forms of real-estate, car and/or other research able products, whereby the dedicated computer 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 internet 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 or data entry persons 24 hours per day seven days a week, to do the same work as the dedicated computer produces in hours.

Project:  Advertising Mass Mailing Address Database
Client:  Professional Typing and Computer Services Company
Description:  Developed a premium Professional FoxPro address database system in the greater Charleston area for professional 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 and final sales purchase orders for the equipment company.

Project:  State Assets Inventory System
Client:  State of West Virginia
Description:  Assumed responsibility and helped design 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 Inventory System
Client:  Union Carbide Corporation current Dow Chemical
Description:  Documented and developed 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. Printed reports for the company's cost and profit analysis.

Project:  Statewide Health care 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:  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 and could be used in small medical or health care related Small Business 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 t use (dashboard) visual graphics. Automation accounting processes in Microsoft Excel and Intuit QuickBooks Professional accounting. Importing QuickBooks data from spreadsheets for diiferent 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. Automatically integrates raw data. Commands to obtain QuickBooks .iif files data structures 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 tremendous amounts of time, (saving money and increasing accuracy)


Project:  Media near 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 company and National Marketing Campaign
Description:  Using data provided by Aldi's headquarters, Jan utilized raw data database to export data to Excel for reporting purposes to evaluate the effectiveness of media advertising buys. Week by week advertising by store Divisions with line charts. Comparison of total sales lift using TV SALES Store Information Report: Basic reports for advertising analysis. Store List, 2500 or so lines 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
Description:  Jan designed a FoxPro database 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 itself when a new elevator was sold using the invoicing system."

Project:  Turner Construction Company Internal Accounting Database Analysis program to satisfy government labor report requirements and print reports.
Client:  Turner Construction Company
Description:  Jan won multiple bid contracts from this international corporate 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 could be based on payroll governmental reporting requirements. Employee and project records could be maintained and reports printed for a wide variety of payroll systems and analysis. The database program was written in Visual FoxPro Database language. The financial analyst told Jan that "he was glad Jan was working on the database program because Jan's understanding of programming analysis was simplifying their payroll records and streamlining their overall accounting system".

Project:  Medical Insurance Cost Analysis System
Client:  University Health Associates
Description:  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.

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 diiferent 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 the costs, profits and accounting 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 interactive model gift. 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 financial 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 spreadsheet bookkeeping system to work better, maintain more data records, operate more smoothly and include more reliable automation, reports and auditing.

Project:  Party Sales Business
Client:  Party Sales Funds Raising Business, Dallas, TX
Description:  Accounting system for a Regional Manager of a party sales business. Maintain sales records for sales reps and details of products sold for each Rep to maintain commissions, overall costs, 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 extensive and detailed flowcharts and designed an analysis of a complex COBOL program for the State of West Virginia Department of Employment Security and Federal computer records integrating with the State 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 revitalize advertising campaign doubling the company's business. Assisted 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 instructor. Charleston, WV 1992-93. Support instructor for clients of Multi-Cap : Best accounting practices, overview of the corporate and small business work place critical business record keeping and practices training.

Project:  SMS Health Record Software
Client:  CAMCARE, Inc.
Description:  CAMCARE Inc. - As a Programmer / Analyst 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 how to use the new SMS health record software (real time life records management system key to information achieving accuracy and easy to use hospital record system. 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:  Analyst and Consultant recommended and helped implement the 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 analysis and evaluation of past, current and future business trends and statistics. MISCELLANEOUS

Project:  Funeral business 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 Microsoft Excel. The lead CPA said "the program has been used on twenty diiferent 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 Software Design
Client:  Veterinary Hospital Finances
Description:  Enhanced integration consult of Excel accounting spreadsheet data analysis programming and design. Consulting services for a nationally known veterinary practice in California. Featuring peer group analysis networks solutions integration source code programming. Transforming consolidated accounting practices, systems evaluations demonstrations, easy-to-use financial analysis system.

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
Client:  Gaming client
Description:  Designed a lottery game program written in Quattro Pro spreadsheet.

Project:  Statistical Analysis Questionnaire
Client:  Business in England UK
Description:  Designed a Questionnaire and statistical analysis, 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, data is imported into the main spreadsheet where hundreds of statistical chart graphs showing relationships of numbers and statistical analysis in near real time are presented. The program is menu driven with viewing and printing options menus.

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. Product orders could be graphically drawn and illustrated to go along with the costing invoices and shelf in store design requested.

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.

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

Project:  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:  Business Support and programming
Client:  Auto Repair Service Center
Description:  Computer assistance, trained employees, programmed support for QuickBooks used in a professional NAPA auto service/repair shop.

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

Institution: Teaching Position: 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 learning software strategies for business increasing a data rich environment using common analysis, trends, visual graphic representations (numeric data graphs) easy-to-use technologies, increased efficiency, logical, security, solutions. 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 the Kanawha County Board of Education.

Institution: Teaching Position: Garnet Career Center, Charleston, WV Position: Computer Instructor of traditional computer training classes in computer business 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 significant amounts of 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 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.

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

As a Programmer Jan wrote a scheduling program for Apple Computers.

Jan has programmed many applications regarding Spreadsheets (Quattro Pro, Excel, Lotus 123), file recovery, formulae conversion, computer forensics, customized accounting software database systems for a wide variety of business and institutional use including strategic analysts, interactive data analysis, license to write Tethys Automation Anywhere scripts and macros software. 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 LLC is listed in the Better Business Bureau's database of businesses with the highest business satisfaction rating possible.
Copyright © 2014 Certified Computer Services LLC
 >
Send an Email !
Visa MasterCard Discover American Express PayPal src="../../paypal_logo.gif" border="0" >