GWEN R. WILSON

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

Temple Hills, Maryland 20748

301-***-****

acqvjm@r.postjobfree.com

EDUCATION

Columbia Union College, Bachelor of Science in Computer Information Systems, June 2001

Strayer University, Diploma in Computer Information Systems, December 1997

COMPUTER SKILLS

Software – SQL Server, Rational RequisitePro, Rational ClearQuest, SharePoint, Crystal Reports, Toad, Microsoft Office, Microsoft Project, Visio, Microsoft Access, Bugzilla, Harvest, Personify

Programming Languages – Transact SQL, PL/SQL, Visual Basic, HTML

Operating Systems – Windows, Unix

TECHNICAL SKILLS

Business analysis to ensure efficient use of information technology processes and tools

Data analysis used to analyze data and show statistics and trends

Create test plan strategies and provide quality assurance

Project management to ensure timely and efficient scheduling and deliverables

Provide expertise to acquire, manage, manipulate, and analyze data and report results

Develop reports utilizing Business Objects, Crystal Reports and Microsoft Access

Manage user account permissions and privileges

Install and configure hardware and software

EMPLOYMENT HISTORY

Blue Canopy, Reston, VA, Business Analyst (10/14-02/15)

Provided business analysis to the National Science Foundation on FastLane application that is utilized to receive request for research grants, review proposals for grants, and provide awards for grants.

Lead meeting with stakeholders to learn business rules and gather requirements for documentation.

Wrote functional requirements documents.

Created traceability matrices.

Maintained project management schedule to ensure timely and efficient scheduling and deliverables.

Performed feasibility studies based on change requests for possible impact to systems.

Analyzed issues reported regarding functionality of the FastLane application in order to provide direction to the Foundation for enhancements, fixes, or training.

Performed impact analyses between applications working with system owners for various applications utilized by the Foundation.

Tagged requirements using Rational ReqPro to functional requirements to be utilized by test teams and quality assurance teams.

Wrote use cases.

Write test scripts and provide quality assurance testing.

Wrote operating procedures regarding FastLane business rules application

Provided training to stakeholders regarding FastLane business rules application.

Maintained SharePoint library of requirements documentation.

Tal-Ex, Falls Germantown, MD, Data Analyst (10/13-05/14)

Assisted with the administration, analysis, fixes and data cleanup of Personify Association Management software system after migration from a different association management system.

Led meetings with system owners and system users to gather requirements regarding business rules and their relationship to data in the database for reporting purposes.

Wrote reports to assist with the data cleanup process regarding membership management, dues invoicing, meeting management, financial data and subscription data using the Personify Data Analyzer tool as well as SQL Server.

Provided data analyses to display membership trends on dues paid, meeting attendance, certifications and training, products offered as well as marketing campaigns using data analysis tools.

Delivered analysis of data via pivot tables, charts and dashboards.

Created Microsoft Excel charts and pivot tables to be utilized to analyze association data.

Wrote update scripts to update data during the cleanup process using SQL language and SQL Server.

Managed system user and system owners’ roles and privileges for the Personify Association Management System application.

Wrote system documentation manuals for system users regarding membership setup.

Wrote standard operating procedures.

Rite Price Auto, Washington, DC, Business Consultant (01/07-12/13)

Developed and manage Microsoft Access database that houses automobile company inventory and financials.

Managed buyer accounts in the database to include proper licensing documents and fees as well as sales.

Created reports utilizing Microsoft Access to assist company manage inventory.

Provided data analysis on trends for sales and marketing purposes using Microsoft Access and Microsoft Excel tools.

Provide training of database application to buyers as well as assist buyers utilizing database as questions arise.

Provided training on use of auction site via the Internet.

Assisted buyers at automobile auctions filling out necessary documents upon purchase of automobiles for sale.

Processed papers to transfer titles, purchase tags and insurance for purchasers.

Acentia, Falls Church, VA, Business Analyst (09/12-10/13)

Provided business analysis support to the Department of State global financial services maintenance applications.

Led requirements gathering sessions with Department of State stakeholders.

Developed requirements documents following system development life cycle model including requirements traceability matrices, functional requirements documents, functional system design documents, use cases and test plans.

Acted as liaison between Department of State stakeholders and developers on developing financial services maintenance applications.

Provided quality assurance on application fixes and enhancements.

Wrote SQL scripts to analyze and evaluate data for integrity and quality assurance.

Ensured accurate and timely delivery of documentation.

21CT, Vienna, VA, Systems Analyst (01/11-09/12)

Provided computer systems analysis support to the Department of Labor iCERT employment and training applications.

Gathered requirements to fix bugs and enhancements to iCERT employment and training applications.

Documented fixes and enhancements to iCERT employment and training applications.

Led requirements gathering sessions with stakeholders.

Developed requirements documents following system development life cycle model including requirements traceability matrices, functional requirements documents, functional system design documents, test cases and test plans.

Worked with developers on developing fixes and enhancements to iCERT employment and training applications.

Wrote test scripts to fixes and enhancements as well as test fixes and enhancements to iCERT employment and training applications.

Wrote SQL scripts to analyze and evaluate data for accuracy.

Provided testing and quality assurance on system fixes and enhancements.

Assisted project manager with management and scheduling on projects to include defining project scope, work breakdown structure and managing deliverables.

Ensured accurately and timely delivery of applications.

Delivered numerous enhancements ahead of schedule enabling a savings to the Department of Labor as well as 21CT.

Freddie Mac, McLean, VA, Applications Systems Analyst (05/10-01/11)

Provided business analysis and data analysis support to managers and business owners of the Default Asset Management department with the loan modification database utilized to maintain loan modifications and sales.

Met with business owners to gather requirements for enhancements and fixes to asset management application.

Monitored tracking database of issues as reported by database users throughout the business day.

Provided business analysis regarding enhancements and fixes to the loan modification database.

Provided business process re-engineering regarding the analysis and design of workflows and business processes.

Provided code compare analysis.

Wrote change request documents regarding enhancements to the database.

Provided business analyst support to User Acceptance Test department with data analysis during testing of the enhancements and fixes to the loan modification database.

Wrote SQL scripts to deliver data to users to be utilized to monitor and analyze data.

Worked with Risk Management team to create a monthly scorecard report to be used by stakeholders and business owners of the loan modification database that uses various calculations to measure standards and deviations on data housed in the loan modification database.

Interactive Technology Solutions, Washington, DC, Data Analyst (06/09-04/10)

Acted as data analyst assisting the Graduate School of Washington, DC, migrate their legacy database into a commercial-off-the-shelf application.

Consulted with Graduate School to gather business rules and data reporting requirements.

Served as subject matter expert on procedures to migrate data to a new database environment.

Served as subject matter expert in developing reports in Crystal Reports.

Assisted Graduate School migrate reports from Microsoft Access environment using Business Objects and Crystal Reports.

Configured Crystal Reports Server.

Managed user account permissions and privileges.

Wrote requirements documents following CMMI processes to include requirements definition documents, build design and test plan documents.

Wrote use case and test plans to assist quality assurance team with testing.

Managed document library for various projects.

American Society for Training and Development, Alexandria, VA, Systems Administrator (1/08-5/08)

Provided assistance to American Society for Training and Development to resolve issues that arose from upgrade to Personify database software application.

Acted as liaison between American Society for Training and Development and software development company to resolve open issues.

Worked with staff gathering organization’s business requirements and organization’s use of software.

Worked with staff to ensure database setup is correct according to documentation provided by software development company.

Developed reports utilizing Business Objects, Crystal Reports and SQL Server on data affecting membership including meetings and conferences, invoicing, products, subscriptions and other data regarding members and prospective members.

Wrote test scripts and tested solutions regarding customizations and fixes.

Provided database administration to include database backup and recovery plans, optimization and performance tuning, table indexing, data analysis and security setup.

Worked with network team to resolve database performance issues.

Managed user account permissions and privileges.

TMA Resources, Vienna, VA, Business Analyst (8/07-1/08)

Provided business consulting and project management to clients purchasing accounts receivable database software program, Personify and TIMSS.

Worked with clients gathering business rules and requirements for database implementation.

Worked with clients gathering reporting requirements.

Developed reports based on client needs utilizing Business Objects universes, Crystal Reports and Business Intelligence.

Demonstrated the various modules of the database to clients such as membership, contact tracking, meetings, advertising, subscriptions, invoicing and reporting.

Provided client support to implement the various modules of the database.

Worked with clients to gather requirements regarding any possible customizations needed on the database.

Wrote requirement documents for database implementation as well as customizations.

Wrote test plans at implementation for the various modules of the database being implemented and customizations to the database.

Provided training to clients on the various database modules and features.

Acted as liaison between vendor and clients to solve database problems upon implementation.

American Trucking Associations, Alexandria, VA, Manager, Applications Services (6/00-8/07)

Provided day-to-day management and operations of the Applications Development and Support team which consists of database developers and database administrators.

Provided project management services for application upgrades, installations or modifications ensuring timely and cost effective implementations.

Created and administered department’s budget.

Wrote and administered employee performance evaluations.

Acted as liaison between software development company and organization to solve database issues regarding TIMSS application.

Participated on database task force that makes decisions regarding corresponding database setup with the company business rules.

Participated in the upgrade and conversion of the database from a customized product utilizing Oracle to a base product utilizing SQL Server.

Provided project management to include requirements gathering and implementation of Business solutions.

Managed employee contractors participating in the upgrade and conversion process of the database.

Managed conversion project converting reports from a Microsoft Access environment to a Crystal Reports environment.

Created reports on the database utilizing Business Objects, Crystal Reports, Microsoft Access and SQL Reporting Services.

Managed user accounts permissions and privileges.

Developed stored procedures and views in SQL Server utilizing Transact SQL to update and manipulate data in database.

Provided user training for the database.

Performed database administration.

Minimized outstanding issues with the software by 50%within the first year with the organization.

Consistently delivered projects ahead of schedule.

Contact this candidate