M. Lisa Smith
960 Clan Court, Worthington, OH 43085-2911
614-433-0354, smith1028@columbus.rr.com
Education:
Bachelor of Science in Information Technology, Franklin University, May 2009 (GPA 3.67).
Letters of Recognition in
Perl and UNIX from Prince George's Community College, 1998-99.
Certificate of Completion in Introduction to SQL from Sybase® Learning
Center, 2000.
Certificate of Completion in PHP/MySQL from TDS Interactive, 2002.
Certificate of Completion in Introduction to Cascading
Style Sheets, Introduction to JavaScript, Active Server Pages for
Non-Programmers, and Accessible Web Design from HTML Writer’s Guild,
1997-2000.
Skills:
Software: DSI Client/Server Circulation Management Software on Oracle database
Microsoft Access, Excel, Word, FrontPage, Publisher, PowerPoint
Adobe GoLive, Acrobat, Photoshop, Photoshop Elements, PageMaker, Illustrator
UNIX VI editor
Oracle 10g with SQL*Plus
Languages: HTML, basic UNIX (with VI Editor), basic Perl & Javascript, VB. NET, PHP, LaTEX, SGML, and SQL.
December 2003 – Present – The Columbus Dispatch, 34 S Third St, Columbus, OH 43215
Responsibilities include all duties related to management of the circulation subscriber database and analysis and reporting on single copy draw data for the Dispatch and other non-Dispatch publications.
· Data analysis of single copy draws for the Dispatch and other non-Dispatch publications.
· Timely updating of draw amounts in the system via automatic upload or manual entry.
· Weekly and monthly processing and dissemination of reports on various draw/returns data.
· Currently exploring other options for single copy reporting including using third-party reporting and data analytics software.
· Manage the subscriber database for circulation of all non-Dispatch publications.
· Perform daily automatic data uploads using; including data editing to ensure error-free uploads.
· Developed an auditing process for one of the non-Dispatch home delivery products.
· Research and provide accurate routing information for all vendor requests.
· Broadcast subscriber delivery complaints to the field during daily recovery hours.
· Assisted in developing the automated upload process for subscriber transactions, including criteria research, testing, and troubleshooting.
· Wrote and maintain user manual for Alternate Product Transaction Processing.
· Wrote and maintain the Alternate Product Exception Reporting SOP.
· Assisted the Super Express Manager and District Managers with weekly reports and maintained Super Express and division records.
· Created training documents for use by other Super Express Clerks during and after training on new procedures on the DSI database.
· Worked with the Standards Manager to create and document standard procedures for submitting subscriber complaints into the dispute process.
February 2001 – 2004 — Freelance Web Development/Web Site Management
Responsibilities included research, page content development, preparation of graphics, creation of banner ads, site management, and link updates. Updating and editing pages developed using Adobe GoLive and ColdFusion.
· February 2001-2004 — FineLine Design, 1501 Charles Street, Fredericksburg, VA 22401. CommuterPage.com - part of the Arlington County Commuter Assistance Program.
· October 2002 - December 2002 — American Association of Museums, 1575 Eye St., NW, Suite 400, Washington DC 20005
1999 – 2001 DynamicDiagrams, A Division of Cadmus Professional Communications
940 Elkridge Landing Rd, Linthicum, MD 21090
Account Manager – Virtual Journals (July 1999-January 2001):
Responsibilities included SGML to HTML conversion, graphics preparation, HTML coding, quality control and final posting on web sites; managed client subscription databases, uploaded subscription lists, edited accounts and provided Help Desk services; scheduling and supervising production.
· Created procedures for efficient production of monthly and bi-monthly online scientific journals.
· Created Perl scripts for streamlining conversion process.
· Problem-solved with Production Specialists to standardize criteria for acceptance of SGML delivery from composition department, thereby reducing production time and increasing productivity.
· Performed database queries using iSQL that gave clients more efficient use of database information.
· Coordinated with clients to keep their Web Sites updated and research adding new features as necessary.
· Developed and maintained production schedules, and delegated work load for three Production Specialists so that deadlines would be consistently met.
· Worked with Production Specialists to improve results of conversion processes.
· Designed “splash page” and developed production procedures for new addition to existing journal.
Organizations: Association of Information Technology Professionals; The Association for Computing Machinery; The International Webmasters Association/HTML Writers Guild; The Information Systems Security Association.