Lauren Marie Hughes

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

Landover, MD 20785

301-***-**** (Home)

240-***-**** (Cell)

Email: ac9spt@r.postjobfree.com

QUALIFICATIONS SUMMARY: A highly creative, goal-oriented professional with solid computer analytical and programming experience. Demonstrated experience in computer systems management, analysis, and programming; database design, development, implementation, and management. Highly organized with the ability to manage multiple projects and meet deadlines. A strong work ethic combined with a commitment to excellence in all projects undertaken. A team player, that works effectively with staff and senior management in accomplishing objectives. That possesses exemplary communication and presentation skills.

AREAS OF STRENGTH: Database design and development, computer hardware and software analysis and information technology

JOB RELATED SKILLS/COMPUTER SOFTWARE PROFICIENCY:

SQL-2005/2012

JSTARS (Justice Security Tracking and Adjudication Record System) an entilltak web-based application

Avectra NetForum- 2005-2013

iMIS

Salesforce

Jira

Agile

Microsoft Visual Studio

Microsoft Access

Microsoft Excel

Microsoft PowerPoint

Microsoft Publisher

Microsoft Word

Word Perfect for Windows

Harvard Graphics for Windows

Typing Speed - 65 wpm

DBase III/IV

Visio, Professional (Business Diagramming Software)

PROFESSIONAL EXPERIENCE

The Judge Group/KAA (Contractor)

The US Department of Justice/Overseas Private Investment Corportion

Office of Personal Security (JSTARS)

(Recipient of a Public Trust Clearance)

October 2015 – June 2019

Data Analyst /System Technical Support

Created queries using SQL Server 2005/2012 and manipulating the data using MS Access and MS Excel and MS PowerPoint

Provided custom reports and metrics according to the client’s specifications

Monitored system for any block transactions and restoring system to full capacity

Responsible for database starts and re-starts all servers associated with JSTARS application (3 servers)

Strong analytical skills with the ability to connect, organize, analyze and disseminate significant amounts of information with attentions to detail and accuracy

Strong communication skills; I am often called to present my finding or translate the data into an understandable document; I speak clearly and concisely when communicating complex ideas

Provides Tier I, Tier II and Tier III technical software managing overall user support for JSTARS system

Using SQL queries to find data anomalies and create scripts to correct deficiencies

Responsibilities included providing technical support and documented work-a-round solutions of system malfunctions.

Create reports and dashboards to desired specifications

Support numerous teams and their reporting needs

Utilize many reporting and dash boarding platforms for data presentation

Employ-R Solutions, Inc. – Crescent Solutions

The American Red Cross

The American Institute of Architects

The Urban Land Institute

National Association of County and City Health Officials

National Association of Independent Schools March 2011 – August 2015

Data Analyst /Specialist, Business System Technical Support

Responsibilities included providing technical support and documented work-a-round solutions of system malfunctions.

Created and maintained charts, graphs, organizational maps and other manuals and/or automated documentation supporting the various managerial functions

Created queries using SQL Server 2005/2012 and manipulating the data using MS Access and MS Excel

Developed policies and procedures for analytically reviewing and updating informational systems to reflect changes in operations, management and/or the organization structure; and

Managed and directed the design, development, installation, implementation of system extraction errors and developed resolutions.

Support staff in assigned project based work

netFORUM design, development, implementation, maintenance and support, and security

eWeb/login support and development

AMS training/Advanced netFORUM Queries, Reporting and Exports

Membership support (netFORUM and Access Queries and reports, Data extraction, Member Invoicing)netFORUM Training for Staff

Batch Reports (Bookstore accounting reports, netFORUM batch reports)

Technical Assistance (Lost Passwords, Billing questions (bookstore and membership), Helping Members)

Data updates (population, contact information, updates, special projects (MRC units, mailing lists, funds, etc.), e-mail bounce backs)

Distribution list for management

Bookstore management

AMS individual to Organization match ups

Membership support

Other duties as assigned

Carl Duncan, Esquire, LLC (Office Merger) February 2009 – December 2010

System Consultant:

Provides Tier I, Tier II and Tier III technical software

Hardware and Network problem resolution

Question/Problem diagnosis and guiding users through step-by-step solutions in a on call or direct contact environment

Communicated technical solutions in a user-friendly, professional manner; provided one-on-one end-user training as needed;

Conducted hardware and software inventory for database maintenance and reporting utilizing SQL 2008 and Microsoft Access; and perform related work as required.

NW Systems (Contracted to Army Corp Engineers Lockheed Awarded Contract) June 2008 – January 2009

Help Desk Technician:

Provides Tier I, Tier II and Tier III technical software, hardware and network problem resolution to all Military Headquarters District computer users by performing question/problem diagnosis and guiding users through step-by-step solutions in a call center environment;

Troubleshoot computer hardware, software or network

Install new software on users computers

Clean, modify and repair computer hardware including monitors, keyboards and printers

Provide good customer service to telephone callers, responding to email requests

Coordinated timely repair of PC computer equipment covered by third-party vendor maintenance

Performs minor desktop hardware repair for PC/Laptop computer equipment and peripherals

United Way of America June 2007 – April 2008

Database Manager/Analyst:

Analyzed national data in order to arm the National Corporate Leadership Team (NCL) with focused strategies for best practices/next steps for the year’s corporate campaign.

Maintain CRM System (Salesforce) to manage system’s data integrity and accurateness. To create reports from Salesforce as requested for United Way Staff.

Devised and managed recommended changes to Salesforce for better business processing practices.

Created reports from past years to analyze trends and methodology for benchmarking techniques. Process NCL as well as non NCL reports for posting to the United Ways online intranet application for local United Ways processing of pledge allocations

Pulled from various FTP locations third party processors pledge files and retrofit for configuration to United Ways intranet application.

Developed and devised specific and detail oriented Microsoft Access queries to answer specific NCL senior staff pledge trending questions. Develop unique queries to process files from local United Way staff from MS Excel for posting to the United Ways’ intranet application in MS Access. Compile NCL company national pledge results for financial analysis.

Designed significant data trending and monitoring queries to ascertain and measure financial NCL initiatives

Coordination of statistical data for management reports to senior management and NCL staff

IDEA (National Electrical Manufacture’s Association Office Merger) March 2006 – February 2007

Data Quality Coordinator: Help manage and operate IDEA’s Industry Data Warehouse data quality program to advance customer data synchronization and electronic commerce initiatives in the electrical industry and other vertical markets. Responsibilities included review manufacturer data validation results and causal factors. To assist manufacturers with data reconciliation and timely system uploads to maintain the volatile cost perspectives. Conducted manufacturer and distributor customer data quality education and training. Continued customer support for data content and quality problems. Downloading and processing manufacturer data for the Data Audit and Certification program, reviewing and revising The Industry Data Warehouse data validation and certification rules. Further enhancing manufacturer product descriptions and other qualitative data items. UNSPSC and enriched attribute schema enhancements Product code management and cross reference table. Support Data Content subcommittee with data standards review and revisions.

The Center for Data Quality (Position Downsized) June 2005 – November 2005

Contracted to the US Patent and Trademark Office

Data Quality Analyst:

Provided error detection and correction; process control and improvement; and recommended system design solutions.

Responsibilities included comparisons against another data sources; data edit checks and duplication record check

Developed, documents to promulgate and maintain data quality goals and standards.

Monitor to resolve data quality problems through appropriate choice of error detection and correction, process control and improvement, or process design strategies. Measure and report to management on the progress of data quality improvement.

Designed significant data quality queries to monitor/measure data quality initiatives

Coordination of statistical data for management reports to senior management and staff

Department of Housing and Urban Development June 1994 – February 2005

Advanced Technology Systems

Department of Housing and Urban Development Temporary Employee

Program Analyst:

Participated in the design and development of the Real Estate Management System, an interactive internet based system. The first system where the Department reconciled physical, financial and tenant logistics in a real time interactive multi-level, multifunctional, assessment-based system.

Participated in the Department’s Appropriations process, including budget reporting to Congress pertaining to Section 8 pass back and recapture. Proposed new appropriations reconciling and accessing Section 8 outlays.

Freedom of Information Act (FOIA) requests. These responsibilities entailed daily system extractions and detailing the methodology behind such responses and significant special projects.

Associate Systems Analyst:

Responsibilities included data extractions to provide customized reports to management to use in the development of policies and procedures for The Department of Housing and Urban Development (HUD), Office of Multifamily Housing Programs. \ Tenant information.

Maintained a historical database on properties which are no longer insured and/or assisted by the department

Design develop, program, install and implement Real Estate Management System computer software for the purpose of analyzing data to achieve parameters and formats of housing statistics; and

Collated and coordinated statistical data for management reports to Departmental and Congressional Staff

Management Information Assistant:

Participated in the design and development of the Multifamily Data Warehouse Initiative Project. Responsibilities included retrieving data extractions from existing systems and identifying extraction errors.

Correlated system extraction changes and maintained real time corrections for management reporting purposes for the Portfolio Re-engineering Microsoft Access based Internet System

Responsible for system security, personnel training, system maintenance and data reporting.

Provided technical support and documented work-a-round solutions of system malfunctions.

Designed the Expiring Section 8 database as well as provided related informational requests.

Developed policies and procedures for analytically reviewing and updating informational systems to reflect changes in operations, management and/or the organization structure; and

Managed and directed the design, development, installation, implementation of system extraction errors and developed resolutions.

Shearson Lehman Hutton/Prudential Securities January 1988 – September 1993

Computer Specialist

Computer transmission of orders, reports and messages for conveyance to brokers for execution.

Process and validated customer orders with consultants to ensure accuracy of stock purchases.

Researched prior stock quotes to ascertain profit or loss ratios. Responsible for troubleshooting and performing minor system maintenance to ensure ongoing operation and connectivity to major stock exchanges; maintained telephone contact with the New York and Chicago stock exchanges during periods of prolonged system failure.

Ability to handle multiple tasks and deal with stressful and conflicting situations with customers, brokers and agents; and

provided technical solutions to a wide range of problems demonstrating superior research and problem solving skills.

United States Army February 1985 – January 1988

NSA Fort Meade, Ft. Meade, MD

Salary – E-4 Specialist

Telecommunications Communication Center Specialist:

Granted a Top Secret Sensitive Compartment Information with Polygraph (TS/SCI w poly) security clearance status = Inactive.

EDUCATION:

Mt Vernon High School, 4500 Old Mt Vernon Road, Alexandria VA

Major Courses: General Studies, Diploma Received - 06/84

Strayer College, Washington, DC,

Working Toward a Information Systems Technology Degree

Major: Information Technology

JOB-RELATED TRAINING COURSES:

STRAYER COLLEGE: Certificate, Computer Information Systems Operator, (in progress)

Major Courses: DBase, COBOL, FORTRAN, Basic, C++

USDA GRADUATE SCHOOL

Microsoft Access Developers Application (July 96)

Concepts of Developing Information Systems (May 96)

NEW HORIZONS

Microsoft Access (November 95)

Microsoft Excel (November 95)

JOB-RELATED HONORS, AWARDS, MEMBERSHIPS, ETC.:

Outstanding Performance Appraisal - 1/98 - 1/97 - 1/96 - 1/95

On the Spot Award Outstanding work for the Mark to Market Program - 9/98

On the Spot Award Creating Management Reform Database - 9/97

On the Spot Award Creating Physical Inspection Reporting - 9/97

On the Spot Award Organizing Management Reform Team - 8/97

On the Spot Award Housing Community Outreach - 4/96

Honorable Mention FHA Commissioner Award for Outstanding Achievement - 1/98

HUD Customer Service Award Office of Asset Management & Disposition - 5/97

HUD Community Service Award Christmas in April - 4/98 - 4/97 - 4/96

HUD Community Service Award Organizer (HUD), Hands Across America Wash, DC - 6/97

REFERENCES:

Mr. Lanier M. Hylton

Director, Multifamily Office of Housing Assistance & Contract Administration Oversight

410 7th Street SW, Room 6130

Washington, DC 20410

Telephone 202-***-**** Ext. 2510

Email ac9spt@r.postjobfree.com

Ms. Monique S. Love

Housing Project Manager, Multifamily Office of Asset Management

410 7th Street SW, Room 6176

Washington, DC 20410

Telephone 202-***-**** Ext. 2382

Email ac9spt@r.postjobfree.com

Ms. Sharon E. Parker

Housing Project Manager, Multifamily Office of Program Systems Management

410 7th Street SW, Room 6120

Washington, DC 20410

Telephone 202-***-**** Ext. 2557

Email ac9spt@r.postjobfree.com

Contact this candidate