MS Access Programmer / Data Analyst

E. DON LOMAX

Pasadena, TX ***** 281-***-**** ******@*********.*** linkedin.com/in/don-lomax

DATA ANALYST

Data Analyst with extensive broad-based experience in the design, implementation and administration of database, information systems and automated reporting. Strong background in relational database concepts. Ability to gather and analyze business requirements from users and propose solutions. Special expertise in end user support, training, and accurate customized report generation. Recognized for ability to design reliable, efficient, and user-friendly systems.

TECHNICAL EXPERTISE

Windows: MS Office, MS Word, MS Excel, MS PowerPoint, MS Outlook, MS Access

Databases: Oracle 11i OBIEE, MS SQL Server 7.0, MS Access 2010, MS Access 2007,

MS Access 2003, POCOPS, AS 400, Alltel CPI

Additional: Visual Basic 6.0, PC Anywhere 5.0, Monarch 6, Crystal Reports, MS Access Runtime

PROFESSIONAL EXPERIENCE

RICOH USA, formerly Ikon Office Solutions, Houston, TX 2000 – 2018

Senior Data Analyst / Database Programmer, 2008-2018

Member of the Planning, Analysis and Reporting team specializing in MS Access and automated metrics reporting.

Designed, implemented, and administered a database to track new Customer Account onboarding, including all tasks, assigned employees, customer contacts, process notes and metric reporting.

Reduced process time by 83% by redesigning the Month End Meters database, combining 28 Oracle reports into a multi tab dashboard distributed company wide.

Streamlined the order coordination database to combine 18 reports to track new orders, notes, and metrics for over 200 order coordinators, supervisors, and management.

Designed the “RMS Billtrack” database, a copy of IMS Billtrack for Ricoh Outsourcing group.

Designed, implemented, and administered “IMS Billtrack” database, which tracked IMS Outsourcing billing for Monthly, Quarterly, Semi-Annual, Annual, and special billing periods, as well as Pre billed, Current billed and Arrears billed accounts. During design research, detected five unbilled accounts and recaptured over $1 Million.

Data Management Coordinator / Database Programmer, 2000-2008

Legal Document Solutions national account billing and collections group. Created electronic billing files and MS Access reporting from billing system.

Designed, implemented, and administered “Strategic Accounts” billing database, which allowed for multiple Billing groups within each National Account using multiple billing formats, including Electronic Data Transfer, Excel for email billing, and printed consolidated.

Designed, implemented and administered “Legal Doc Solutions Collection” database. Emergency design when all collections moved in house with short notice.

E. DON LOMAX

Pasadena, TX 77505 281-***-**** ******@*********.*** Page Two

Designed, implemented, and administered “Global Client Services” database, a collection database and companion to Department Billing Database. Incorporated various automated processes to increase department productivity over 60%. Produced Electronic Data Interchange files for electronic billing of National Accounts, both direct to customer and via third party billing system.

Created the Days Sales Outstanding (DSO) database to accurately calculate DSO by Region, National Account, National Sales Consultant, and National Sales Manager.

Designed and implemented new “Import” database. Used to upload monthly sales data into department billing system. Emergency design due to previous program failure. New design is 400% faster, more accurate and more user-friendly.

Designed new Master Customer Index, which linked customers from the same company from the national customer list. Used for various Upper Level Management reports. Also used to produce sales revenue reports for Legal Solutions sales force.

Designed and implemented “Contract” database to maintain and track contract information for Ikon Legal Document Solutions National Accounts.

Designed and implemented “Commission” database to calculate Signing Bonus, New Contract Commission, Revenue Growth Commission for Legal Solutions Sales team.

Designed, implemented, and administered “Field Location Collection” database. Used by field locations for collection of Non National Accounts. Maintained Customer invoice balances, collection notes and contacts information. Produced Collection activity reports for field location managers.

ADDITIONAL RELEVANT EXPERIENCE

Chase / Mellon Mortgage, Houston, TX, Document Pursuit Coordinator / Data Analyst

EDUCATION

Houston Community College, Introduction to MS SQL Server, Introduction to Oracle, Advanced Visual Basic, Visual Basic Programming, Introduction to Networking / Windows 2000

DeVry Institute, Irving, TX

U. S. Coast Guard Aviation Electronics School

Contact this candidate