Project Manager Quality Assurance

Grace Spear

*** ******** ***** **

Albuquerque, NM 87108

505-***-**** ***********@***.***

SUMMARY

Database programmer / analyst professional with wide-ranging experience in

database application development. Successfully analyzed, designed,

converted and implemented international enterprise products with multi-tier

client server architecture. Proven success developing new applications

with improved process performance.

Core strengths in

Object-query Design and Programming Data Model and Database Programming

Product Conception, Design and Specification Unified Project Teams

Cross-Function Communication Troubleshooting and Problem Solving

TECHNICAL SKILLS

Databases MS SQL Server 2005, MS Access 97 & 2007, Db Access, DB2, dBase IV,

Paradox, Informix

Languages VB .Net, 2005 SQL scripts, XML, ASP, Visual Basic, Visual C++,

4GL, COBOL

Accounting Systems J.D. Edwards, MACOLA, Enterprise, Elite 3E web based

Platforms Windows XP, NT and 2000, IBM AS400, Unix

Tools VMware, Citrix, ODBC, PC Anywhere, Rumba, VPN, WebEx

Other MS Visual Studio, Crystal Reports v7, Monarch, MS Office Suites,

Stored Procedures

PROFESSIONAL EXPERIENCE

DATA NETWORK CORPARATION, Reston, VA, Federal Government Contractors

2010

SQA Analyst & Tools Engineer

Provided independent validation and verification (IV&V) of Resource and

Patient Management System (RPMS) for Indian Health Services (IHS) under

American Recovery and Reinvestment Act (ARRA) of 2009. Validated install

procedures according to Programmer's Standard and Convections (SAC) for

MUMPS and GUI.

. Revised standard operation procedures (SOP) to current process flow

for verification, beta release and national release of KIDS builds to

12 area offices. To ensure processes meets the SAC requirements and

provided continuous process improvement through timely and effective

communication to project team.

. Redesigned MS Access 2007 database to track software builds during the

SQA beta testing process. Incorporated SQA process flow checklist to

gather data for reporting statistics to federal government.

ELITE, THOMSON REUTERS BUSINESS, Albuquerque, NM, Legal Software Developer

2003 - 2009

Conversion Programmer / Analyst 2006 - 2009

Performed data mapping onsite with new customer for legacy systems and

documented conversion statistics and presented to customer. Loaded

customer data extracts into SQL 2005 database and prepared VB and SQL query

load scripts. Preformed data cleansing on the staging tables using

validation scripts.

. Documented Accounts Receivables reconciling results for 8 countries with

cross currency conversion to extracted data. Designed and developed

specialized SQL queries for reconciling currency conversion values.

Collaborated with project manager, international conversion colleagues

and senior application analyst.

. Resolved urgent problem on final conversion. Updated and re-linked

related information with minimum impact using customized SQL queries

scripts. Completed final conversion with tight schedule and high

pressure from customer, resulting in acceptance of new application.

. Performed troubleshooting and resolved critical problem on converted data

on live system. Collaborated with application developer, business

analyst and project manager for solution validation on test database.

Documented procedures to complete resolution to high profile customer.

Grace Spear Page Two

Application Support Analyst 2003 - 2006

Resolved customer problems in an effective and efficient manner within 72

hours. Optimized troubleshooting processes by re-evaluating on moment-by-

moment basis. Communicated extensively with customers to get clear

understanding of their needs and followed-up until resolution. Interacted

with colleagues in escalation of incident in written manner via e-mail,

internal software and phone calls.

. Improved customer productivity by encouraging and facilitating

involvement in process improvements and implementing applicable

suggestions. Achieved performance evaluation rating of far exceeded

customer satisfaction standards by clearly communicating technical

information to non-technical customer.

. Far exceeded company's problem resolution standards by researching

knowledge base, testing processing errors, documenting step by step

resolution process, and collaborating with cross functional teams.

. Demonstrated database architect, application functionality, and

accounting process knowledge resulting in a performance evaluation that

far exceeded company's technical expertise standards.

GCC RIO GRANDE, INC., Tijeras, NM, Cement Manufacture 1997 - 2002

DOC Data Coordinator

Assisted in auditing J. D. Edwards Accounting and Manufacturing system to

advise management of any discrepancies in processing information in

compliance with Department of Commerce. Supported coworkers by extracting

data for reconciliation and customized reports for trouble-shooting

purposes using crystal reports.

. Improved data integrity and increased analysis time by inter-related

links between multiple data sources via ODBC drivers into MS Access

database and crystal reports applications.

. Reduced postage cost 75%, increased productivity 50%, and reduced lawyer

fees 20% by utilizing email communication and sending scanned documents

directly to lawyers in Washington, DC.

. Advised management of data processing solutions by troubleshooting data

problems imported into MS Access database in conjunction with JD Edwards

application.

. Reduced lab scheduling time 68%, eliminated pre-printed forms cost,

facilitated process improvement and improved data integrity 90% by

consolidating multiple Excel data sources (shift report, daily lab report

and silo measurement report) into centralized MS Access database

application scripted in Visual Basic as special project.

SP PHARMACEUTICALS, Albuquerque, NM, Oncology Drug Manufacture

1994 - 1997

Software Analyst

Programmed database applications in multi-user environment using MS Access

and Paradox. Administered the Macola Accounting, Distribution and

Manufacturing system.

. Implemented first phase of inventory bar coding to comply with required

FDA mandate by minimizing equipment cost, minor procedural changes and

engaged warehouse personnel in all phases of the project.

. Identified, evaluated and implemented multi-user database application in

MS Access 97 for Quality Assurance department for standard operation

procedures (SOP) training which reduced printing time from hours to

minutes. Improved department heads monitoring of employee training by

instituting security hierarchy.

. Improved Macola database efficiency 50% by converting index structure

from a sequential method to Btrieve structure.

PREVIOUS EXPERIENCE

JC PENNEY TELEMARKETING CENTER, Rio Rancho, NM

Technical Operations Specialist

MONCOR BANK, Albuquerque, NM

Decision Support Analyst

US NAVY, San Diego, CA

Computer Technician, Honorably Discharged, 2nd Class

EDUCATION

BS, Applied Management, National American University, Albuquerque, NM

Graduated Summa Cum Laude, Salutatorian

AS, Computer Science Information Systems, Technical Vocational Institute,

Albuquerque, NM

Contact this candidate