LYNN SCHLEBECKER PRESTON
23751 Mariner Drive, Unit 178, Dana Point, CA 92629; cell phone (949) 887-6807; firstname.lastname@example.org
OFFICE SKILLS: Typing speed of 70 words per minute. Data Entry Numeric: 9,836 Data Entry Alphanumeric: 10,320. Meetings:
scheduling, agenda and minutes preparation. Business analysis, research and technical writing. Legal,
medical and software terminology. Accounting: invoice payment, billing resolution assistance, reconciliation of
client accounts and transactional experience; QuickBooks accounting experience; corporate accounting systems
experience; and 12 semester units of college Accounting. Expertise in Microsoft Office, with current tests for
Excel, Word, PowerPoint, Outlook, and Access on self-designed, professional Website,
http://www.prestonofficesolutions.com. Answering multiple telephone lines. Dictaphone transcription.
EDUCATION: Brigham Young University, Provo, Utah
A.A. Degree in General Studies with Business Concentration
B.S. Degree in Business Administration, California State University, Fresno
General Business Concentration with emphasis in Accounting and Information Technology
Magna Cum Laude, G.P.A. 3.77 out of 4.0
Worked as a tutor at C.S.U., Fresno in English grammar for the English Department, business statistics and computer
2000–Completed two classes: “Designing and Implementing a Database Design on Microsoft SQL Server” and
“Designing and Implementing Web Solutions with Microsoft Visual InterDev”. In 2000, received a job as an Online
Banking Web Analyst, after using classroom skills to write an original database-driven online Web application using
Visual InterDev, Visual Basic Script, HTML and Active Server Pages.
Learning Tree International, Irvine, CA
2005–Company paid for Visual Basic for Applications training which was used to code in Visual Basic for Applications.
2006–Received certificate for completing the Advanced Excel Training Course at:
New Horizons Learning Center, Anaheim, CA
May, 2010- Completed 21 semester units: Beginning and Advanced courses in QuickBooks, Adobe Flash, Flash
G.P.A. 4.0 out of 4.0; Saddleback College, Mission Viejo, CA
SERVICE: Dana Hills High School GradNite Committee Member: Treasurer using QuickBooks and Online Database
Administrator using PHP and MySQL. Secretary for a YMCA after-school daycare program’s parents’ group in
Laguna Niguel, CA. Volunteer assistant teacher at Little Friends Learning Center. Timekeeper/referee for YMCA
Youth Basketball. Recreation leader at Hy-Lond Convalescent Hospital. As portrayed originally in
http://www.riddles.com and now in my own Website, http://www.free-vocab-puzzles.com, creator and developer of
a new type of vocabulary-building crossword puzzle for SAT/ACT vocabulary exam preparation. Created a graphic
design of former, best-selling "As I Grow" poster by famed author Helene Rothschild to be distributed to charity.
ACHIEVEMENTS: Dean‘s Academic scholarship to B.Y.U.; Scored in top 1% of students entering B.Y.U. in vocabulary skills on ACT;
One of 25 women in the United States selected for officer program in U.S. Naval Supply Corps for the year; table
tennis singles medallist in the Corporate Olympics, Anaheim; Trumpet player in U.S. Naval O.C.S. Band and in a
multiple award-winning high school Stage Band; #2 Varsity Tennis singles in high school; and Student Body President
in junior high school. International travel in England, Germany, Kuwait, Canada and Mexico. PC WEEK magazine
asked to quote me for my applications development work using DbPublisher desktop-publishing software for my
employer, Rykoff-Sexton, Inc. Planned and ran tennis tournament for Jacobs Engineering Group company picnic.
MILITARY: U.S. Naval Officer Candidate School, Newport, Rhode Island. In the Supply Corps.
09/08– Current ORANGE COUNTY TECHNOLOGY SOLUTIONS, Dana Point, CA at http://www.octslive.com
Accounting Bookkeeper/Online Database Administrator/Website Designer & Developer/Technical Writer:
Using QuickBooks to manage all business accounting. Business Web Analyst and Writer for a professional artist’s
business Website, http://www.davidchapman-plays-trumpet. Designed and developed original Websites,
http://www.doyoufathomthis.com, http://www.free-vocab-puzzles.com, http://www.prestonofficesolutions.com,
http://www.tasteofdanapoint.net, http://www.lagunaniguellake.com, http://www.lnysaspiritwear.com,
http://www.badtothebone-bbqstore.com and http://www.pintarellicreations.com. Laguna Niguel Little League
Spiritwear is being redesigned. Worked as a Dana Hills Gradnite Management Committee volunteer for one year
as treasurer and two years as Online MySQL Database Administrator and Maintenance Developer using PHP at
http://www.dhgradnite.com/login.php. Blog and advertise business on youtube channel at
http://www.youtube.com/user/FreeVocabXwrdPuzzles and http://www.momwearsmanyhat.com/blog.
03/09 RICOH BUSINESS SOLUTIONS, 1123 Warner Avenue, Tustin, CA
Visual Basic for Applications (VBA) Programmer in Excel for Accounts Receivable Billing: (Temporary position
through an agency for 3/09.)
Successfully completed a 30-day contract working full-time directly for the Senior Manager of Business Operations
for Ricoh Americas Corporation, the copier company from Japan. Programmed in VBA for Excel and created
Excel formulas to run the billing system for invoicing the City of Los Angeles, encompassing over a thousand
copier leases in government offices in Los Angeles County. Produced approximately 5,000 invoices and recorded
them, from up to six months back-dated, to bring Ricoh up-to-date to the current month. Used Lotus Notes
software for email.
08/08 THE NIELSEN COMPANY, 31910 Del Obispo St., San Juan Capistrano, CA
Research Interviewer I: (Temporary position through an agency for 8/08.)
In preparation for the semi-annual Action Sports Retailer (ASR) Trade Show in San Diego, CA: conducted phone
research and performed marketing and customer service tasks for ASR clients all over the U.S.A. and Canada.
10/03– 05/08 UNITED AGRICULTURAL BENEFIT TRUST at UNITED AGRIBUSINESS LEAGUE, 54 Corporate Park, Irvine, CA
Accounting Clerk and Administrative Assistant for this health insurance company (http://www.uabt.org):
(Temporary position through an agency 10/21/2003, went permanent on 2/4/2004.)
Wrote SQL statements in queries of the AS400 system for billing data. Created an accounts receivable cycle flow
diagram which is still used by the company’s Marketing Department. Programmed in Visual Basic for Applications
to create Excel macros that reduced the account reconciliation time to about 20% of what was required in the past.
Formatted an Excel template for electronic account reconciliations, for loading the macro results of processed
billing accounting data. Trained in accounts payable duties. Among the Billing Department staff, received top
marks from the clients, resulting from the company’s Customer Service department surveys. Received positive
written reviews from the Billing Department Supervisor. Posted and reconciled the largest client accounts, for
thousands of medically-insured members. Wrote business email messages in Outlook; designed and ran
accounting reports; faxed letters and telephoned: to request client information and handle customer requests
regarding their accounts receivables and employee and/or dependent(s)’s medical insurance eligibility. Interfaced
daily with the company’s Claims Department, Customer Service Department, and Underwriting Department.
Received six incoming phone lines in the front office, screening calls for the CEO and company legal counsel.
07/03– 09/03 CHICAGO TITLE INSURANCE COMPANY, 16969 Von Karman Ave., Irvine, CA; https://www.ctic.com
Escrow Processor (front-end) for Residential Refinancing: (Temporary position through an agency.)
In the top-performing 4-person escrow unit at this large Irvine facility of the #1 title insurer in the U.S.A. Opened
escrow and title orders, prepared escrow instructions and amendments to them, issued quitclaim deeds, ordered
payoff/demand statements, processed mail and filed. Introduced verifying our clients' residential property
addresses initially with usps.com to save company title searching time down the line. Provided customer service to
mortgage brokers, lenders and borrowers. Trained co-workers in Excel. Helped to create an Excel spreadsheet to
manage our largest client's orders. Assisted in streamlining the escrow and title order processing method for rush
jobs by innovating with a parallel method of processing instead of sequential, enabling a significantly faster
turnaround time for our clients in receiving escrow instructions. Eliminated the slow handwritten order input from
our largest client into a far faster and easier for the client, computer-driven format.
07/02– 06/03 Prepared our Laguna Niguel home for sale and then sold it. Stay-at-home mother for two sons. Manage household.
06/02 SIMS LAW FIRM, 620 Newport Center Dr. #900, Newport Beach, CA
Legal Word Processor: (Temporary position through an agency.)
Using a dictaphone, transcribed legal documents using word processing software. Edited for English grammar,
spelling and usage.
10/01– 04/02 COUNTY OF ORANGE, FINANCIALS UNIT, ACCOUNTING DEPARTMENT, Orange, CA
Information Processing Technician and Accounting Clerk: (Temporary position through an agency.)
Paid lawyers’ invoices and helped to resolve billing issues on the AS400 computer. Redesigned the method of
entering data in the spreadsheet to save half the keystrokes. Using MS Word, assisted collection officers in the
preparation of Petition Modifications for the Superior Court; with the manager, redesigned this workflow to make it
faster, more accurate, cost-effective and complete. Documented and implemented these new procedures. Trained
others in software packages and offered technical advice, as necessary. Additional duties included:
Answering the telephone and emails in MS Outlook.
Maintaining personal and financial databases on the AS400 computer of Orange County clients.
Processing Juvenile Court case files, including photocopying sections, for examination by collection officers.
Organizing and updating Orange County client financial files in two rooms filled with file cabinets.
Sorting Employment Development Department forms for Orange County clients in delinquency.
09/01 ACCELL PROPERTY MANAGEMENT, 23046 Ave De La Carlota #700, Laguna Hills, CA
Word Processor: (Temporary position through an agency.)
Using a dictaphone, transcribed and edited minutes in MS Word for meetings of boards of directors for various
homeowner associations in South Orange County. Edited for English grammar, spelling and usage. Answered the
06/01– 08/01 COUNTY OF ORANGE, JOHN WAYNE AIRPORT, Santa Ana, CA
Database Developer/Administrator, Administrative Assistant and Office Receptionist in Landside Operations:
(Temporary position through an agency.)
Responsible for organizing and updating files for 162 airport ground transportation providers through extensive
telephone calls to all major local hotels, limousine services, door-to-door shuttles, and their insurance
representatives. After completion of this task, computerized this information: 1) Used MS Excel to track insurance
brokers and agencies. 2) Used an MS Access database system for tracking ground transportation permits and
performed database user training, system refining, and documenting in MS Word and MS PowerPoint. Developed
an MS Access database work-around to use with MS Word for sending out correspondence. Met with Information
Systems Department to ensure a smooth transition. Photocopied, faxed, distributed and filed documents. Also
worked at the front desk: answering multiple phone lines, scheduling meeting rooms and serving as a receptionist
to the airport public. Trained others in software packages and offered technical advice, as necessary.
10/00 – 03/01 PACIFIC NORTHWEST BANK, Oak Harbor, Whidbey Island, WA http://www.pnwbank.com/
Online Banking Web Analyst and Administrative Assistant: (Temporary position through an agency.)
Answered telephone and emails. Photocopied, faxed, distributed and filed documents. Performed data entry of
de-linking transactions for inactive online banking customers. In MS PowerPoint, created online banking Website
diagrams for senior management. In MS Excel, redesigned a form for tracking online banking Website changes
throughout the corporation. Edited the entire content of the online banking Website. Due to a merger, redesigned
online banking customer interactive application formats for loans. Trained others in software packages and offered
technical advice, as necessary.
Launching New Online Business Banking Product, “Business Express”: In MS Word, wrote detailed
minutes of weekly meetings. In MS Excel, under the direction of vice president superior, redesigned and
maintained the Business Express project management schedule spreadsheet. In MS PowerPoint, redesigned
the online banking Website diagram flow to allow for the new product. Achieved faster server response times
from the vendor of online business banking through personal networking with another vendor client bank.
“Price shopped” competitor banks through telephone calls and online banking verification. With vice president
superior and Marketing vice president, helped develop pricing for online consumer and business banking, in
meetings and by writing analytical research reports. Researched and documented in MS Word: 1) compatibility
between QuickBooks and Business Express product, 2) Open Financial Exchange, and 3) Automated Clearing
Researched and wrote an analytical report advocating the dismantling of the bank’s virtual online branch
encompassing all of the United States; top management then implemented it.
Successfully lead effort, through technical research and meeting participation, to enhance security for
Conceived of and constructed an MS PowerPoint demonstration for the online banking Website, for the
“Corporate Express,” pc-based online business-banking product.
Compiled and rewrote the company’s security policy on the online banking Website.
Monitored technical performance level of software development for the vendor of the front-end of online
banking. Documented in MS Word, using Microsoft Visual Basic Script code for Active Server Pages, how
the vendor could improve functionality.
01/00 – 09/00 Student Retraining in Up-To-Date Business Information Technology, Laguna Niguel, CA:
January 20, 2000: Attended E-Commerce session at Microsoft TechNet Briefing, Pasadena Convention Center.
March 15, 2000: Through self-training, prepared for and took Microsoft 70-176 Exam, Designing and Implementing
Desktop Applications with Visual Basic 6.0. Scored 100% on part of the exam.
March 16, 2000: Prepared for Microsoft 70-029 Exam, Designing and Implementing a Database Design on Microsoft
SQL Server 7.0. 8-week class at Learning Tree University, Irvine, CA. Received a grade of "A".
July 11, 2000: Prepared for Microsoft 70-152 Exam, Designing and Implementing Web Solutions with Microsoft
Visual InterDev 6.0. 8-week class at Learning Tree University, Irvine, CA. Received a grade of "A".
July, 2000: Working alone built a Web application using Active Server Pages (ASP), Visual InterDev 6.0, HTML,
DHTML and connected to a Microsoft Access Database using ActiveX Data Objects (ADO). Also used Microsoft
Office 2000 PowerPoint, Excel and Word in Web application. URL: http://family.domaindlx.com/recreation.
01/99 – 12/99 MARCONI SERVICES (formerly Systems Management Specialists, Inc. (SMS)), Brea, CA
Y2K-Tester and Administrative Assistant: (Temporary position through an agency.) Attended meetings; answered
telephone and emails; photocopied, faxed and filed documents; and ordered supplies for computer and
documentation. For office laser printer: changed cartridge and scheduled maintenance. Supported supervisor and
business information technology staff with special projects in Microsoft Excel. With a team, completed all Y2K IBM
mainframe batch testing for RAINBIRD SPRINKLER MANUFACTURING, INC.; WHEREHOUSE
ENTERTAINMENT, INC.; and SABRELINER CORP. In Microsoft Access, Excel, and Word: analyzed and
documented all Y2K-testing results. Performed computer operations in a secured computer room in conjunction with
commands I issued on my PC. MS Access database I created was included on company intranet.
11/98 – 01/99 WYNN OIL, 1050 W 5th St., Azusa, CA; http://wynnsusa.com/
Administrative Assistant and Legal Researcher: (Temporary position through an agency.)
Performed legal research for the C.E.O. throughout the entire company.
07/94 – 10/98 Stay-At-Home Mother to Two Sons, Temple City, CA:
Managed and organized the household while raising our two sons, infant and toddler, while my husband worked long
hours outside the home. Planned and participated in social activities with other stay-at-home mothers and their
children. Perused daily The Wall Street Journal and trade journals such as Computerworld magazine. Professional
computer software tutor for high school students. Increased expertise in Microsoft Office Professional software,
including Access database and Visual Basic for Applications. Active member in Database Programming Special
Interest Group in Pasadena IBM PC Users' Group. Designed and coded home management software tools.
Analyzed each activity of raising children in a home as “a profession”.
12/89 – 06/94 RYKOFF-SEXTON, INC., Los Angeles, CA (Currently U. S. FOODSERVICE, La Mirada, CA)
PC Programmer/Analyst, Desktop Publisher and Technical Writer: Reported to the company controller and
supported other executives. Automated, wrote and produced the company sales books for 9 branches,
encompassing the entire Western U.S. 1,000 users of these sales books, including approximately 66 buyers and
hundreds of sales personnel. More than 100,000 records to be maintained as sales book administrator.
Automation: Working alone from the beginning of the project: performed all system and database analysis,
design, development, coding, testing, documenting, refining and maintaining the automatic sales book system
in MS Access, dBase IV, and DbPublisher desktop-publishing software.
Writing and Production: The main technical writer for the content of the sales books. Handled telephone
communication with buyers, salespeople, corporate product-line managers, and outside manufacturers---to
clarify and validate what should be in the sales books. Supervised two PC operators. For office laser printer:
maintained it, changed cartridge, and ordered new supplies.
In MS Access database, tracked the entire Rykoff-Sexton, Inc. sales force in the U.S.A. and Mexico.
Successfully lead the effort to merge the IBM mainframe price file and the IBM PC sales books text file
data to print the sales book price pages with subheadings and in sales book order for all 9 Western
For corporate purchasing of produce: in spreadsheets, reported booking positions and price comparisons;
and in dBase IV, the codes on the cans.
Analyzed the cost of reprinting the sales books for varying levels of price changes.
In MS Access database, created reports comparing the 9 branches for sales of self-manufactured and
other categories of products, ran pricing comparison analyses between branches, and ran gross profit
analyses by buyer and vendor.
For the Personnel Dept., wrote the database system for random drug testing of company truck drivers.
03/89 – 11/89 ENTERTAINMENT PARTNERS (formerly IDC SERVICES), Burbank, CA; http://entertainmentpartners.com/
Business Information Services Programmer/Analyst: Analyzed all edits and processing through the database
extract program of all online input fields to a nightly batch payroll system for entertainment industry union workers.
Documented the batch payroll calculations in detail for vacation, holiday, "holiday not worked", and union benefits,
such as pension. Helped design and code Hours-To-Gross payroll system front-end.
10/87 – 03/89 KWIKSET CORPORATION, A DIVISION OF BLACK & DECKER, Anaheim, CA
Business Information Services Programmer/Analyst and Technical Writer: Wrote the Information Systems
Department Manual, providing an overview of the software and hardware environment and detailing programming and
operations procedures and forms. Provided salesperson support over the telephone for both usage of the GRID PC in
the field and the software. Performed analysis, new programming and coding maintenance on: Online Sale Order
Entry, Payroll, Personnel, Finished Goods Inventory, A/R, A/P, Sales, Billing, Price, Customer, Shippers-In-Transit,
Freight Routing, and Carrier Maintenance computer system applications.
07/84 – 09/87 JACOBS ENGINEERING GROUP, INC. (JEG),1111 South Arroyo Parkway, Pasadena, CA
Business Information Services Programmer/Analyst and Technical Writer: Interfaced with JEG Accounting,
Payroll, Human Resources and other Information Technology Departments across the country: answering questions
and solving production problems by telephone or through written correspondence. Documented the systems
responsible for, and provided booklets to management, data processing, and accounting. Documented in-house
Management Information Systems Department standards. Performed analysis, new coding and programming
maintenance on: JEG Group Project Accounting Reporting System, Staff Payroll Labor System, MSA ALLTAX2
Software Package, Print Reproduction System, JEG Online Human Resources System, Sub-Ledger Accounting
System, Uniform Computer Billing System, MSA Staff Payroll System, JEG Craft Payroll System, and Accounts
01/84 – 03/84 COMMERCIAL MANUFACTURING, 2432 S Railroad Ave., Fresno, CA
Executive Administrative Assistant: (Temporary position through an agency.) Handled six telephone lines, with
factory and office paging ability; performed receptionist duties; composed and edited correspondence; sent Telex
messages; used the Dictaphone; filed; invoiced; typed shipping papers; maintained sales and manufacturing order
backlogs; and prepared sales material for price quotes. Redesigned workflow of job with approval of company
president. Helped the sales manager organize his office and procedures.