SENIOR-LEVEL SPECIALIST: VBA, Quality Assurance, Project Management, Process
Improvement, Configuration Management, Organizational Change Management

•	Expert at Visual Basic for Applications (VBA).  Developed MS Excel, MS Word,
MS Project, and PowerPoint tools to facilitate data extraction, transformation,
aggregation and loading into other applications.  Examples
(http://www.pdcaregiver.org/JeffreyParkJones/Jeffrey_Park_Jones_MS_Office_Based_Tool_Examples.html).
•	Strong programming, DBA, data analysis background.  
•	Logical business analyst adept at identifying business practices and
streamlining processes to support them.
•	Highly skilled information specialist with more than 27 years of demonstrated
achievements streamlining programs and processes by identifying the smartest
methodology to achieve goals, cut waste, and boost productivity.
•	Intuitive ability to discern inconsistencies across requirements,
specifications, and systems. 
•	Big-picture thinker adept at synthesizing disparate parts into a cogent whole.

•	Masterful project manager known for developing automation tools/enhanced
processes that promote efficiency, save time, and slash costs
•	Talented coach/mentor of individuals and organizations.

PROFESSIONAL EXPERIENCE
Independent Contractor, Wake Forest, North Carolina • 2008	VBA Developer
Gathered requirements and developed multiple MS Excel based tools.  Stepped in
to redesign tables, forms, reports, and queries to repair an MS Access 2007
database that had never made it to production.
•	Created MS Excel User Forms to enter new rows or modify existing rows in a
spreadsheet.  The data was retained in multiple worksheets.  Dropdown lists
enabled easy selection of existing data.  Data validation and accumulation of
numeric data were built in to ensure integrity of data.  (Wake Forest Psychiatric
Associates)
•	Developed MS Excel tools to merge data exported from accounting and payroll
systems to be uploaded into other applications.  This provided both data
integrity and significant time savings over manually entering the data.  (Mr.
Paul Sipe, CPA, ABV in Durham)
•	Analyzed and redesigned the tables in an MS Access 2007 database to ensure
referential integrity and consistent data entry.  The redesigned tables use
actual data as primary keys rather than MS Access assigned, auto-numbered keys
that had to manually be managed in additional tables.  The original design was
never able to support requirements and was therefore never promoted to
production.   The redesign ensured data integrity and has resulted in the ability
to produce reports to support the enterprise.  (K L Shane Inc.)
•	Developed MS Access tool to import timecard data from MS Excel.  This tool
pulls in data from each worksheet, edits it, and either updates existing rows or
adds new rows to appropriate tables. 

Smart Online Inc., Durham, North Carolina • 2008	Senior Quality Assurance
Engineer
Responsible for developing QA processes and procedures to integrate QA into the
appropriate touch points within each project's life cycle.
•	Developed, when needed, MS Office based tools to automate repetitive tasks. 
This included an Excel-based tool to automatically format, total and graph MySQL
query data. 
•	Developed SQL queries and analyzed the results from a MySQL database to
produce defect quality and density statistics.  This gave Smart Online the needed
data to determine that money would be saved by bringing the development work in
house. 
•	Responsible for developing QA processes and procedures to integrate QA into
the appropriate touch points within each project's life cycle.
•	Evaluated, tested, and recommended a tool to automate testing.

EDS, Raleigh, North Carolina • 1988–2007	Senior Information Specialist
Expertly developed, maintained, and promoted processes used across EDS
(International technology services company with $26.5B in contracts in 2006) to
manage organizational change, manage projects and develop software as part of a
dynamic global team. Oversee all aspects of an enterprise-wide quality-management
system utilizing quality-assurance processes. Command several helpdesks that
support the process sets across EDS. Coach and mentor project teams and
organizations.  
•	Developed numerous C-lists, MS Word and MS Excel–based VBA tools, and process
enhancements that potentially affected 65,000+ users company-wide, providing
significant ongoing time/cost savings for EDS.
•	Managed development and ongoing maintenance of an MS Access database.  This
included tables and relationships, forms, queries and reports.
•	Developed MS Excel, MS Word, PowerPoint, MS Access, and MS Project VBA tools
that automated repetitive tasks.  These tools were shared across EDS.  One Excel
tool ran weekly in 1.5 minutes rather than the 40-minutes it would take to do
manually.
•	Responsible for the construction and maintenance of multiple corporate-wide MS
Office VBA based tools created with MS Excel and MS Word.
•	Analyzed business needs to tailor processes and procedures to organizations
and project teams to solve business problems.
•	Regularly tested updates to an XML / ASP.Net application and developed a paper
explaining how to test the application so regression testing could be performed
and consistency could be maintained.

AIRBORNE EXPRESS, Seattle, Washington • 1984–1988	Senior Programmer/Analyst
Analyzed data and designed and installed several high-performing programs at
Airborne Express (acquired by DHL in 2003).  This included a new CICS transaction
to allow users to request accounting information through a batch process, a
system to receive electronic data interchange transmissions of shipment data
through job-entry subsystem–IBM mainframe, and an online and batch
time-accounting system using a fourth-generation language, ISPF dialogues, and
Clists. Performed careful data and system analysis and provided expert
maintenance on various batch and online systems.
•	Delivered a database-synchronization project estimated to require 2,080 hours
in only 70 hours by creating, implementing, and promoting an alternate solution.
•	Created a mainframe, TSO-based time-accounting system that was used by all IT
projects and teams.

SUNSTRAND DATA CONTROL, Seattle, Washington • 1982–1984	Senior
Programmer/Analyst
Drove productivity at Sundstrand Data Control (electronics) and ensured results
as a skilled technical lead on major projects, directing the efforts of five
other programmers. Spearheaded the testing and implementation of Arthur
Anderson’s Manufacturing package and Software International’s General Ledger
System. Developed, installed, and maintained several programs and systems to
satisfy user needs in the areas of inventory accounting, sales, and inventory
control, using structured COBOL techniques.  
•	Discovered an oversight in the lack of performance of general ledge year-end
running, as well as a lack of proper documentation; personally spearheaded
project and documented procedures so that others in the future could perform
procedures.
•	Led the redesign of the manufacturing work order used by three different
departments, resulting in a 2.5-year period in which there were no requested
changes to the form or the application.

Early Career Note: Professional experience also includes a position as
Programmer/Analyst at Simpson Timber Company in Seattle, Washington (1977–1982).


EDUCATION

Many years experience with the following disciplines:
Quality Assurance • Organizational Change Management • Performance Management
Requirements Gathering • Project Management • Project Tracking • Configuration
Management
Process Improvement • Disaster Recovery • Documentation • Metrics • Performance
Reviews
Gathering/Managing Requirements • Records Retention/Recovery •
Mentoring/Coaching

Bachelor of Arts, General Studies 
University of Washington, Seattle, Washington

*An extensive list of additional course work and professional training is
available on request.

http://www.pdcaregiver.org/JeffreyParkJones/Jeffrey_Park_Jones_Resume.html

http://www.visualcv.com/jeffreyparkjones