Senior Developer Data Analyst Business Analyst

MICHELLE E. WILSON

**** ******** ****, #****, *********** MD 20782

**********@*****.***

301-***-**** (h) 240-***-**** (c)

Wilson, Michelle

Experience Over 3 years of experience in Data Loss Prevention

technology and methodologies

Over 3 years of experience in Agile\Scrum project management

and software development methodologies

Over 18 years of experience as programmer/business

analyst/systems analyst/application developer

Over 15 years of experience developing and implementing

proprietary applications for corporations using a variety of

technologies

Over 17 years of experience with the full life cycle of

application/project development

Over 17 years of experience with JAD and Elicitation

Techniques

Over 17 years of experience documenting and programming

business rules; developing application specifications;

developing and performing test plans/test scenarios; writing

technical documents; creating training documents, and

successfully integrating applications

Education Associate of Applied Science Degree -Chattanooga State

Community College, Chattanooga, TN, 1996

Political Science -American University, Washington, DC,

1973-1974

Political Science/Community Organization -Malcolm X

Liberation University, Greensboro, NC 1969-1972

Certifications Implementing & Maintaining MS SQL Reporting Services, 5/2013

and Relevant

Training Implementing & Maintaining MS SQL Analysis Services, 2/2013

Symantec Data Loss Protection (DLP) Administration, 12/2012

Mastering Web Application Development Using Microsoft Visual

Interdev, 9/2001

Crystal Reports Integration for Developers, 5/2000

MS SQL Server Database Design, 4/2000

Summary of Qualifications

See "Experience" Above

Technical Skills

SQL - 16 Years MS Access - 18 Years COBOL - 17 Years

Oracle - 8 Years Crystal Reports - 16 PL/SQL - 15 Years

Years

Visual Basic - 15 Years Java Script - 15 Years HEAT/iHEAT - 2 Years

Cold Fusion - 6 Years RoboHelp - 5 Years ASP - 11 Years

COGNOS - 9 Years HTML - 10 Years Symantec Data Loss

PowerBuilder - 8 Years Visual Studio - 14 Years Prevention (Vontu)

Remedy - 4 Years Application - 3 Years

PowerPoint - 10 Years MS SQL Analysis Services MS SQL Reporting

TOAD - 8 Years - 2 Years Services - 1 Year

Visio - 10 Years Mercury Quality Center -

Excel - 12 Years 2 Years

Experience History

Technical Lead\Reporting Lead, Federal Aviation Administration (FAA) Data

Loss Prevention (DLP) Project, Tantus Technologies, Washington, DC, 5/2011

to 9/2014

o Operated the FAA Symantec Data Loss Prevention (DLP) system to extract

and manipulate complex DLP data and create automated representations of

this data for multiple FAA Lines of Business (LOBs) and Staff Offices

(SOs)

o Provided FAA-wide Symantec DLP system engineering support, including

modifying system settings; researching and resolving threat vector issues

(Data-at-Rest, Data-in-Motion, Data-in-Use); diagnosing and correcting

performance bottlenecks/technical problems and communicating the issues

and results of the effort

o Automated processes to verify data accuracy and integrity

o Provided day-to-day support to Symantec DLP application users, including

researching issues relative to scan results; assisting in remediation

efforts; creating new accounts; conducting threat vector scanning

o Served as Tantus DLP liaison with FAA DLP Steering Committee, FAA DLP

Working Group, and FAA LOBs/SOs and attended meetings with FAA staff to

review, revise, and plan ongoing FAA DLP operations

o Created training materials on FAA DLP SOPs, DLP processes, DLP business

rules; use of Symantec DLP application to create and extract scan results

for both PII and scanned assets; Symantec DLP remediation and reporting

o Conducted trainings on Symantec DLP systeam use, reporting and

remediation, scanned assets processes, and DLP applications for both

internal Tantus Tech staff and FAA staff

o Designed and created proprietary automated data extraction and reporting

applications that programmatically manipulate complex DLP data sets to

output presentation-grade reports that can be tailored for audiences

ranging from senior executives to privacy business process owners to

technical/security staff

o Created user manuals for each proprietary application designed and

created to automate DLP data extraction and reporting

o Provided written justification for unachievable service requests

o Researched information for advancing DLP analysis and reporting

methodologies and technologies

o Provided documented feedback on ways in which the DLP concept of

operations can be modified to enhance reporting

o Configured Symantec DLP system reporting macros, including manipulating

Symantec DLP system report filtering to generate the required query

results for FAA Lines of Business (LOBs) and Staff Offices (SOs)

o Acquired and documented DLP reporting requirements based upon interviews

with FAA personnel and Tantus DLP subject matter experts

o Translated Symantec DLP application data into various types of Crystal

Reports reports and dashboards, Excel reports, MS Access reports, and

presentations per operational requirements

o Codified automated reports as per report definitions

Lead Technical Developer, Pension Benefit Guaranty Corporation (PBGC),

Washington, DC, ATSC, 9/2009 - 3/2011

o Managed a team of developers in creating applications and methodologies

to convert over 2,000 PBGC plans from old legacy systems to current

technologies

o Translated business rules and requirements to design, code, and develop

conversion applications and methodologies

o Developed and implemented reusable methods to deliver project objectives

successfully and timely

o Managed testing and implementation of project applications; developed

code and documented templates to facilitate ongoing project tasks

o Trained QA Engineers about technical requirements and technical aspects

of application development and plan conversion to create applicable test

case scenarios

o Participated in meetings with business staff, project managers,

developers, and other project personnel to automate, upgrade, and expand

applications that accomplish assigned project development, QA, and UAT

o Created, designed, and formatted technical and business specifications

including process flows and other information needed to describe required

processes for project development, QA, and UAT

o Researched, designed, and developed application to facilitate project

tracking and reporting

o Trained project team and business staff on use of project tracking

application

o Created users' manuals for newly created applications and other training

documentation

o Completed required project documentation including project design, unit

test, and other ITSLCM artifacts

o Performed data and business analysis to develop and produce project

reports

o Served as project liaison with Federal entities

o Interviewed prospective technical team personnel.

Senior Developer, Gwinnett County, GA Government, CDI, 6/2008 - 4/2009

o Supported and developed various Elections, DMV, Tax Assessor, and

Gwinnett County Police Department VB- and MS Access-based applications

o Developed and documented data standards

o Prepared documentation for new systems and systems modifications

o Planned and developed third-party systems

o Trained users

o Troubleshot SQL and Oracle errors

o Developed SQL and Oracle stored procedures and views

o Served as project lead and liaison with clients

o Supported Manatron (Tax) application

o Planned, analyzed, developed, and implemented computer applications

o Developed and troubleshot complex Crystal Reports

o Defined requirements for logical and effective solutions

o Assisted with problem and process identification and definition

o Analyzed system problems and provided corrective action

Senior Programmer/Analyst, Gwinnett County, GA Public School System,

COMSYS, 9/2006 - 5/2008

o Served on project team responsible for performing a feasibility study for

a knowledge management system

o Tested potential applications/tools to provide knowledge management

technology

o Developed prototype of the county-wide knowledge management system

o Revised, developed, and published Crystal Reports associated with the

company's Remedy Magic Service Desk application

o Worked with senior executives and other personnel to gather report

specifications and translating specifications into complex reports -

application served staff in the entire Gwinnett County Public School

System.

o Created complex stored procedures and other SQL objects for reporting

purposes

o Troubleshot problem reports and associated data sources

o Redesigned reports and rescripted SQL objects when necessary

o Developed on-line and hard-copy user's manuals to train users on the

Remedy Magic reporting module

o Facilitated development meetings

Business Analyst/Senior Crystal Reports/SQL Developer, Opteum Financial

Services, Roswell, GA, 2/2005 - 2/2006

o Provided day-to-day technical and user support for a web-based reporting

system containing over 300 reports and serving over 100 users

o Created new Crystal Reports and updated existing reports

o Created complex stored procedures and other SQL objects for reporting

purposes

o Troubleshoot problem reports and associated data sources and redesigned

reports and rescripted SQL objects when necessary

o Worked closely with upper management and other personnel in developing

report specification documentation

o Documented business rules for data gathering

o Performed extensive analysis of database table/fields and data mapping

based on business rules and reporting needs

Immigration Software Analyst, Paul, Hastings, Janofsky & Walker LLP,

Atlanta, GA, 10/2004 - 12/2004

Software Architecture, Design and Build Service Consultant, Imerys,

Roswell, GA, 7/2004 - 8/2004

Senior Programmer/Business Analyst, McKesson Industries, Alpharetta, GA

5/2004 - 8/2004

Senior Programmer/Analyst, Beneficial Life Insurance, S.A., Abidjan, Cote

d'Ivoire, West Africa (Went Out of Business 5/04), 9/2003 - 5/2004

o Designed and developed company-based intranet/internet system for use by

company employees to enter, edit, and view client data

o Developed SQL stored procedures, triggers, and functions

o Developed complex statistical Crystal Reports

o Developed user interfaces with VB Script and JavaScript ASP

o Developed an internet-based reporting system.

Senior Programmer/Business Analyst, UPS Chain Supply, Alpharetta, GA,

1/2003 - 6/2003

o Data mapped and created data mapping documentation for converting over

400 Crystal Reports from a Vantive database schema to a NextJet database

schema (Oracle 8i/9i on UNIX platform)

o Converted complex statistical Crystal Reports based on a Vantive database

(Oracle 8i) schema to pull data from new NextJet database (Oracle 9i)

schema

o Converted Crystal queries to Oracle stored procedures, triggers, and

packages

o Rescripted Oracle PL/SQL stored procedures and packages for optimization

o Scripted new Oracle views, functions, stored procedures, and packages

o Developed unit testing scenarios and performed unit testing

Senior IT Consultant, MCIC Vermont, Inc., Atlanta, GA, 3/1998 - 9/1998;

12/2008 - 11/2000; 9/2001 - 11/2002

o Functioned as programming consultant to company converting all

applications developed in Access '97 to a web version in Cold Fusion

o Developed data entry/reporting "Physician Exposure Management System "in

Access 97 allowing medical center users to enter and report on physician

demographic and insurance coverage information

o Developed a "Management Team Physician Exposure Management System" in

Access 97 that performed various complex calculations on physician data

to count physicians in various risk classes in order to determine the

company's insurance premiums

o Developed and implemented company's SQL 2000 Data Warehouse

o Developed the MCIC Vermont Reporting Application.

o Developed a conversion utility to quarterly convert the individual

hospital databases into a company consolidated database.

o These systems were implemented at the following institutions:

o Yale University School of Medicine Medical Center

o Yale-New Haven Hospital

o Johns Hopkins Medical Center

o Columbia-Presbyterian Medical Center

o University of Rochester Medical Center

o Bridgeport Hospital

o Greenwich Hospital

Senior Consultant, Matrix Resources, Inc, Atlanta, GA, 3/1998-11/1998 and

12/2000 - 8/2001

o SQL Programmer, HEAT/iHEAT Programmer, HEAT/iHEAT Trainer, Crystal

Reports Developer, Oglethorpe Power Corp., Tucker, GA

o Business Analyst/Crystal Reports Developer/SQL Database Developer,

Hatfield Philips, Inc., Atlanta, GA

o Senior MS Access/SQL Developer, Kimberly Clark, Atlanta, GA

o Senior MS Access Developer, HIM Solutions, Atlanta, GA

Professional Experience Prior to 1998 Available Upon Request

Public Trust/Clearance Information

Contact this candidate