Learning Center
Plans & pricing Sign in
Sign Out



									                                        LYNN SCHLEBECKER PRESTON
        23751 Mariner Drive, Unit 178, Dana Point, CA 92629; cell phone (949) 887-6807;
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; Quicken user; QuickBooks research; 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,
          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
                   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
                   2008- Volunteering for training purposes: Coding Visual Basic for Application programs inside Excel macros for a
                   payroll consultancy group, completing a new payroll system installation and implementation onsite at a large, public
                   company based in Los Angeles. Also providing English editing for an IT consultant in the group.
COMMUNITY          Dana Hills High School Parent Volunteer Worker. Secretary for a YMCA after-school daycare program‟s parents‟
SERVICE:           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
          and now in my own Website,, creator and developer of
                   a new type of vocabulary-building crossword puzzle for SAT/ACT vocabulary exam preparation.
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.
                  Accountant/Online Database Administrator/Website Designer & Developer:
         Using QuickBooks managed all business accounting. Business
                  Web Analyst and Writer for a new successful professional‟s business Website, http://www.davidchapman-plays-
                  trumpet. Designed original Websites, and
                  Worked in development and as Online Database Administrator/Treasurer of and
         Finished 21 semester units in related course work at Saddleback College in
                  Mission Viejo; Dean‟s List, g.p.a. 4.0 out of 4.0. Advertise business through original 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.
                Accounting Clerk and Administrative Assistant for health insurance company: (Temporary position through an
                agency 10/21/03, 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, Irvine, CA
                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 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, 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.
                 Information Processing Technician: (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, 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
                Administrative Assistant 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       
                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
                     House transactions.
                    Special Projects:
                         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
                          online banking.
                         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   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:
                Spring, 2000: As part of a team, built a Web application using HTML, JavaScript, Java applets, and CGI script.

01/99 – 12/99   MARCONI SERVICES (formerly Systems Management Specialists, Inc. (SMS)), Brea, CA
                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
                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, Azusa, CA
                Administrative Assistant: (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)
                Administrative Assistant: 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. 1000 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.
                   Special Projects:
                         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
                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.

                Technical Writer and Business Information Services Programmer/Analyst: 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), Pasadena, CA
                Technical Writer and Business Information Services Programmer/Analyst: Interfaced with JEG accounting,
                payroll, personnel 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 Project Accounting Reporting System, Staff Payroll Labor System, MSA ALLTAX2 Software Package, Print
                Reproduction System, JEG Online Personnel System, Subledger Accounting System, Uniform Computer Billing
                System, MSA Staff Payroll System, Craft Payroll System, Project Accounting Reporting System, and A/P System.

01/84 – 03/84   COMMERCIAL MANUFACTURING, 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.

To top