We provide IT Staff Augmentation Services!

Qa Analyst Resume

4.00/5 (Submit Your Rating)

EDUCATION:

B.S, Business Administration

SPECIALIZED TRAINING:

SAP Crystal Reports, 2009
RASMM3 SAP Strategy Management 7.0, 2008
Oracle 9i Database Developer through Virginia Tech, 2003
Improving your Project Management Skills with American Management Association, 2001

SPECIALIZED CAPABILITIES:
Microsoft Office, SQL, Oracle 9i, Microsoft Project, Visio, FileMaker Pro, GoldMine, CMMI, Visual Basic and Macros in Microsoft Office Suite

SUMMARY:
Majored in Pre-Med and Decision Science (computers) while in college. Began working in the printing industry as a typesetter, which at that time involved a great deal of coding to create the printable material.With the release of desktop publishing, typesetters became obsolete. I went to work for Fairfax County Public Schools and became the program director for K-12 science. Where my experience with manipulating data, computer experience and interest in databases was put to optimal use. I then began working in the telecommunication industry and was either a project manager and/or database analyst. Knowing that the telecommunication industry was in extreme flux, became certified in Oracle 9i and SQL.

EXPERIENCE:

Jan 2008 to Nov 2009 -- Confidential, Database Developer and QA Analyst

  • Subcontractor on US Army Corps of Engineers' A-76 Quality Assurance Management support contract.
  • Developed a comprehensive Quality Assurance (QA) program related to the oversight of Information Management/Information Technology Service Providers throughout the U.S. and Overseas for the Army Corps of Engineers.
  • Provided data analysis, documentation, design and development of a Quality Management System utilizing Microsoft SQL Server Developer 2005 and SAP's Strategy Management (SSM) 2007.
  • Identified organizational objectives, metrics, performance standards, and data sources associated with the metrics and determined the data requirements for the reporting system.
  • Implemented a test environment, test plans and test cases to execute before moving environment into production.
  • Designed and developed the relational databases, collected and integrated the performance metrics and analyzed the multidimensional databases. Also developed the data mapping and configuration of the back-end database and user interfaces to support analysis and reporting via Scorecards, Dashboards and Reports.
  • Created and maintained numerous reports and ad hoc reports as requested based on the quality and quantity of the data. Further, created reports on the data that was not able to be utilized and what the various problems were with the data.
  • Analyzed the data by writing SQL queries or utilizing Excel and Access to create reports that interpreted the data for the Army Corps of Engineers. Wrote PL/SQL and T/SQL to modify the tables or databases as well as archiving and backing up the SQL and SAP databases.
  • Imported and exported data from the Army Corps of Engineers production server to our reporting server.
  • Last assignment included creating and programming three Access databases with Visual Basic and macros for use by the National Institute of Health.

Confidential, Jun, 2007 - Dec, 2007
Database Analyst

  • Ran SQL queries to run dashboard reports for executive management.
  • Wrote simple queries to pull data for executive spreadsheet reports and powerpoint decks, including Ad Hoc reports on an as needed basis.
  • Ran weekly and monthly reports generating data pertaining to ticket and circuit information for all of Verizon Business and create several types of charts and/or tables for easy interpretation of results.

Confidential, Apr, 2004 - Jun, 2006
Software Support Analyst

  • Software support of relational database known as GoldMine, as well as Business Objects, SAP and EOES (an in-house financial system).
  • Trained users on software functionality. Developed and revised training materials.
  • Supported over 300 internal users consisting of marketing directors and marketing managers.
  • Wrote SQL queries to pull data from various tables for reporting purposes and marketing campaigns. Queries were written with 9i, Enterprise Manager or embedded into Excel spreadsheets.
  • Assisted with revision and implementation of software upgrades and patches.
  • Converted ExpoCad floorplans to Cadvance and EOES for web usage and billing purposes.
  • Supported pipeline reporting for five office locations. Analyzed data to determine if expositions and/or conferences were on target for deadline and meeting sales quotas.

Confidential, Oct, 2002 - Dec, 2003
Business Analyst/Project Manager

  • Worked as a consultant at Nextel in the Program Management Department.
  • Gathered and manipulated data to track and estimate fiscal budgetary requirements for 2003 budget. This involved the use of Microsoft Excel, numerous embedded formulas, pivot tables, Visual Basic language, and creating graphs and charts for executive review of which programs would be implemented for the year.
  • Created databases and spreadsheets to project resources.
  • Assisted in development of a program tracking tool for company wide use on the intranet.
  • Coordinated the collection of project data for compilation of executive weekly reports. Maintained all files, logs and databases to support the Technical Review Board process.

Confidential, Aug, 2000 - May, 2002
Project Manager of Infrastructure Implementation

  • Co-managed a major $27 million subsea build across the Atlantic for six months
  • Solely managed a $2.7 million dollar metro ring build from backbone down to T1 level with a cost savings of $500K per month
  • Successfully implemented a major metro ring upgrade that required a six-hour outage and migration of 90% of customer traffic
  • Established and directed implementation team from the planning stages of project to operations handover
  • Created and maintained several databases utilizing Microsoft Access to track and report status of projects

Confidential, Aug, 1993 - Jun, 2000
Program Manager & Technology Specialist

  • Maintained constant contact with over 200 schools regarding material requests and program policy
  • Directed the Regional Science and Engineering Fair, which consisted of approximately 1,800 participants and 3,500 spectators
  • Posted information onto school system's intranet for 4,500+ elementary teachers
  • Coordinated and controlled several departmental budgets exceeding $1 million
  • Disseminated and controlled science materials for approximately 9,000 science teachers
  • Formatted and created teacher and student guide books for hands-on science, including graphics
  • Initiated and secured an interactive web page for utilization by all 25 high schools

Confidential, 1992 - 1993
Administrative Assistant

  • Took several positions on a temporary basis. One assignment lasted four months where I was the backup administrative assistant for the personnel department of ICF International

Confidential, 1990
Typesetter

  • Coded, typeset and designed text and graphics for newspaper layout utilizing six years experience on Compugraphic typesetting equipment

Self Employed 1985 - 1990

  • Maintained a small business with word processing for various clients, including Atlantic Research Corporation, Washington Type, and Allen Wayne Printing
  • Transcribed legal depositions involving medical malpractice
  • Programmed and wrote macros in Lotus to track statistical information

Confidential, 1979 - 1985
Senior Typesetter/Typographer

  • Coded text for publishing in various formats: journals, computer user's guides, magazines, and reports, including the Washington DC budget
  • Generated government documents which required a top secret security clearance

We'd love your feedback!