Lamar Dixon



Lamar Dixon cell: 703-868-9610

3002 Woodsong Dr. E-mail: ldixonjr@

Richmond, VA 23224 Website: com

Sample application: Video of my Access app.

• Around 10 years of experience specializing as a MS Access Database Development.

• Primary development skills in all areas of Microsoft Access, VBA, Crystal Reports, Microsoft Office (interactive with Access, Word, Excel & Outlook). Custom MS Access applications

• Proficient in using VBA to create specialized functions in MS Access an Ad-Hoc reporting using User-Driven- Design methods.

• Experienced in data analysis using custom queries in SQL, MS Access, and Crystal Reports.

• Proficient in data reporting using custom reports and Brio query in MS Access and Crystal Reports.

• Primary Skills: Data Analysis, MS Access Application Programming, Data Migration

• 4/color offset, Direct Mail, Letterpress, Folding, Cutting, Scott 10000 Tab and Index

Technical Skills

• Applications: Visual Basic 6.0, VBA for Access, MS Access, ODBC, Crystal Reports Brio Query, MS Office 2000, MS Office XP, Outlook, Citrix Meta-frame, LANDesk, Royal Blue. Proprietary Software: Legal MacPac, DocX-Tools, DocX Change, P C Docs, and Comparite. BCC Mail Manager 2010 LE and Satroi Mail Management Software

Education/Training/Certifications

United Education Institute

NETWORK TECHNOLOGY: MS NT Server4.0, NT Workstation, MS Access Database, Hubs, Switches and HTML.

3.96 gpa.

Catholic University of America

Computer Science, Writing Skills Workshop

Los Angeles Trade Technical College

Database Programming, Visual Basic 6.0

4.0 gpa.

Major Assignments

May 2009 – Present

Salient Technologies, LLC

Database/MS Access Developer

Database creation, normalization, programming, ad-hoc reporting, custom functions, project lead and programmer for SMS Text Messaging application using MS Access and Outlook. Complex ad-hoc reporting, data validation, database management, GUI creation and middle tier. Microsoft Office Suite. Develop complex Visual Basic routines employing MS Access application using VBA.

May 2008 – May 2009

Finishline Diecutting and Foil Stamping

Team Lead/Production

October 2005 – December 2007

Beach Brothers Printing

Lead Printer/Master Pressman/Information Technology

Responsible for 4/color printing, Letterpress: foil stamping, embossing, die cutting, kiss cutting, scoring, cutting paper, bindry, quality control, maintenance. Process printing and finishing. BCC and Satori mail management software, implemented and wrote a set of policies and procedures checklist. Migrating data from various sources into mail management software.

March 2004 – September 2005

HP/WACHOVIA SECURITIES

Data Migration Engineer - (K-Force Staffing Consultant), Richmond, VA

Data Migration Engineer for Lotus Notes 6.0.3 – Analyst for desktop migrations of e-mail data migrating from MS Outlook to Lotus Notes. Installation, migration, connectivity issues, desktop configuration, troubleshooting, data mapping, network PSTs, QA, and technical support. Developed MS Access application to track and manage completed tasks. Multi user application and Database project tracking hosted on server where all technicians keep tracking their project.

2002 – 2004

MERLIN INDUSTRIES, Amelia County, Virginia

Production Manager responsible for project planning, scheduling, printing, quality control, equipment maintenance, job tracking, scheduling deliveries and customer contact. 4 color process printing. Developed MS Access database to track projects through production cycle and create a Bill of Materials. Kept track of all in-house projects and created complex report Bill of Material (BOM). Kept track of the customers, tracking and automatic email messaging. Ad hoc queries and custom filtering functionality using VBA for MS Access. Wrote VBA programs for MS Access. Develop multi-user Access database that tracks and records any changes/additions/updates to the database.

2002 – 2002

Philip Morris, USA, Richmond, VA

(Kelly Scientific Consultant), Richmond, Virginia

Modify existing databases, using Visual Basic to create GUI front-ends, Ad-Hoc reports and queries. Design log-on security, Audit Trail, key-stroke time-out function, data validation, E-mail report messaging. Brio Query 6.0 programming. Wrote VBA programs for MS Access and Excel that extract, apply business rules to and warehouse data. Develop multi-user Access database that tracks and records any changes/additions/updates to the database. Advanced filtering/reporting functionality. Enhanced log on Security, Data Validation, idle time shut down, auditorial reporting, advanced filtering, report messaging using VBA for MS Access.

1999 – 2000

O’MELVENEY & MYERS, LLP - Los Angeles, CA

First level support for 2000+ users worldwide. Primary role in debugging complex MS Word and Excel legal documents. Assisted users via LANDesk. Ensuring that visiting Attorneys can log into local network domain, recovered documents, set profiles in MS Outlook, set up and configured local and network printers. Remote access using Citrix Metaframe. Worked with large databases using MS Access. Track calls using Royal Blue software. Troubleshoot connectivity issues. Remedied document storage problems with PCDocs. Resolved network connection problems on a Windows/Novell environment. Ms Access data migration.

1998 – 1999

AMERICAN COMPUTER TRAINING, Encino, CA

Trained students in the use of MS Office Suite with emphasis on MS Excel and Access. Instructed students in understanding the Windows 95 directory structure and general use and maintenance of P.C.s. Responsible for student enthusiasm and performance by identifying student deficiencies and assigning extra curricular work and tutoring to keep student proficiency at acceptable levels. Assigned multi-lingual students and dramatically improved test scores.

1998 – 1998

MEXICO EXPRESS INTERNATIONAL, Mission Hills, CA

Configured and deployed Network Server for a 100-node environment. Maintain user group accounts. Daily maintenance of LAN. Rollout of software and IP addresses. Ms Access data migration from Ms Excel spreadsheets. Troubleshoot 3Com Switches-Super Stack II, 1100s. Design database queries and reports. Plan and manage relocation of department and installation of new P.C.s. Perform upgrades, acting P.C. technician.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download