cheryl dillon

Excel VBA automation of financial and labor cost analysis reporting for executives using Microsoft Access and Excel, Ad hoc reports, tie-outs and documentation of existing systems and databases. Design and automation of pivot tables, charts and query extracts from Oracle and Access databases. Reverse engineering complex Access databases including managing large text file imports and exports as well as extracting data for reports in Excel. New Access database design and development. AS9100 technical documentation. Advanced Excel training classes.

Managed customer service department, responsible for incoming sales and sales support calls, domestic and international order processing, customer satisfaction and all related customer service activities. Worked in tandem with the technical support team to maximize customer satisfaction, resolving software-related issues and providing excellent service. Instituted a bug management and feature request system. Set up and managed a product key and password generation system for domestic and international customers.

VBA Development / Software Instruction Designed, built and implemented efficient solutions in MS-Excel, MS-Access and MS-Word. Core strength in moving, transforming and converting data to and from mainframes, databases, data stores, presentation layers, forms and any other data format. Consistently helped customers solve complex data issues with user-friendly solutions. List of projects/clients available. Developed, delivered and taught software classes for various Microsoft Office technologies at all levels. Taught students at Fortune 500 firms (GTE, Edison International, ITT, SGE), non-profits and public services (LA County Museum of Art, Riverside County, LA Dept Water & Power, City of Pasadena), entertainment (Warner Bros, Universal Studios, KABC Radio) and aerospace, transportation, and many other industries. Responsible for designing custom classroom curriculum as well as teaching pre-designed courses. With a consistently high student success rate, was called upon by over 30 companies to help them expand their computer training courses and end-user efficacy

Office automation, reporting, analysis

Activities and Societies: Women's Club, Spanish Club, Chorale and Small Chorale, Band Wagon Review

Quick Basic Programming Language","PC University, Visual Basic","World Trade Association, Export Regulations & Controls","Ambassador College, Education and Spanish"]