Quality Assurance Project

STEPHEN J. JOYCE

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

Arlington, VA 22203

Cell #: 703-***-****

Email: *******@***.***

EDUCATION: Master of Science in Telecommunications & Computers

The George Washington University

School of Engineering and Applied Science

January 2007

Bachelor of Business Administration,

The George Washington University

School of Business and Public Management

May 1998

CERTIFICATION: VA Bureau of Insurance Life, Health & Annuity License

November 2010

Oracle 8i DBA (by Oracle Corporation)

August 2002

GOAL: CISSP (by ISC)2 Estimated Time: Summer 2011

SUMMARY OF QUALIFICATIONS

Over 10 years of consulting and technical experience in the data processing field, including direction quality assurance (QA), Database Administration, Testing, Independent Verification and Validation (IV&V), consulting, and system monitoring administration of database, Information Security and performance with SQL Server 2003, used to produce special reports by utilizing applications such as AS400, Toad, Advance Query Tool (AQT), IBM DB2 (via HTSO, Spufy & QMF) & Microsoft Office Products (Access, Excel & Word).

HARDWARE / SOFTWARE EXPERIENCE:

HARDWARE IBM Mainframes including IBM z/OS; PC

OPERATING IBM z/OS. Windows XP, and Disk Operating System (DOS),

SYSTEMS

LANGUAGES Java; Cold Fusion; HTML; Visual Basic; SQL; and FORTRAN

DATABASE Microsoft's SQL Server (RDBMS);

IBM's DB2 and NOMAD

Microsoft Access

Oracle.

OTHER SOFTWARE:

IBM's TSO, Mainframe and Legacy Applications, QMF, Netscape

Enterprise Manager (Users & Group Administration), Network

Simulation (NS), Microsoft Outlook. Microsoft Office Suite, UNIX

HIGHLIGHTS OF EXPERIENCE:

Aflac Sales Associate/Data Analyst 8/2010 – Present

This is a 1099 employment, where it is solely based on commissions. We are marketing with business owners, interested in enhancing employee benefits with supplemental insurance products offered by Aflac. Aflac is recruiting everyone from all fields, as part of their marketing campaign of expanding their business. This is a completely different field from the kind of work I’ve been pursuing, but I still fully intend to continue with my technical experience.

Precision Management Solutions Data Analyst 4/2005 – 9/2010

Project I (4/2005 – 7/2007): HUD SAMS M&M Server Project

During this project, I’ve resumed supporting the same client that I’ve worked with my previous employer, but on a project that was awarded to Precision, Inc., which was an 8a Woman Owned Small Business. My primary functions were to continue supporting HUD Single Family & their clients, by managing and maintaining the reporting requirements generated from Web Based SQL Server 2003 Application. The HUD Reports Generated were Case Management Information as each property goes through a 10 Step Case Management Process, when it goes through Acquired, Maintenance, Marketing & Reconciliation phase that could take months & HUD manages an average of 60,000 new property cases each year. I’ve continued to perform quality assurance for HUD’s Case Management Reports including defining requirements, and test based on user’s acceptance level, using Quality Assurance/Quality Control (QA/QC) methodologies. In addition, writing SQL Queries using DB2 & Oracle (Toad), for Quality Assurance.

In the technical area, my primary duties was to ensure that each business day, all database information has been successfully updated after close of business the previous day, which includes steps of monitoring the following each morning:

• Complete Data Transfer (FTP) from Mainframe Production Information (Job Control Language (JCL)/CICS to SQL Server.

• Verification and Validation of Case Management Data between:

o HUD’s IBM Mainframe 370 (HTSO, QMF, NOMAD & Spufy); and

o SQL Server 2003 (Generated by Cold Fusion).

• Execution of Database Update of SQL Server 2003 tables.

• Cold Fusion Batch Report generation for all HUD Reports, including:

o Case Step Report

o Selling/Listing Brokers

o Inventory Report

o Closed/Reconciled Properties, & more

Most of the work was done early in the morning, because if a problem occurs, we will want to get it all resolved as soon as possible, so that it won’t have much of an impact for the end users as they need current information, to continue managing and marketing the properties they are responsible for. As for the rest of the business day, we were primarily responsible for releases of minor enhancements to the Web-Based Application, which includes:

• Adding New Reports

• Ensuring appropriate error messages are generated, when human error occurs, for example:

o Please Enter Date in: MM/DD/YYYY format.

o Case Step Must be between 1 and 10.

o History Date must be Greater Than 1/1/1990, & more

• Bulletin Board Message Display

Most of my responsibility for each release was documentation of the following:

• Verification of Requirement (VOR), signed by Client (if required).

• Test Plan & Results (Taking screen-print of results for each step described in the document)

• Final Release Notes.

All information was secured through https:// and restricted to authorized users, via User ID and Password. When a user becomes unauthorized for mainframe access, that information is carried over in a flat-file, where it is updated during the next business day. Also, the website is enhanced to allow users to change their own password, based on information that only the personal themselves know, such as last 5 digits of Social Security, “What is your pet’s name?”, “What is your mother’s maiden name?”, and other validation techniques.

During Implementation, we backup the old production files and moved the approved file changes from development to production. We do a quick test with production, ensuring everything is working perfectly, and during non-business hours to ensure unnecessary impact at client-end. We also ensure, all reports are successfully generated and accessible to authorized users. All reports were eventually transitioned to Yardi, headquartered in California, as described in the next project.

Project II (9/2007 – 1/2008): Yardi Conversion Project

During this time, we interfaced with the technical team for Yardi, as they were planning to replace the entire HUD Single Family Acquired Asset Management System (SAMS), with their new Web-Based application for authorized HUD users. Yardi, became responsible for all the Web-Based Reports generated for HUD clients, as we assisted in answering and responding to any technical or report issues, presented by Yardi.

Project III (9/2007 – 9/2010) HUD SAMS Post Insurance Project

During this time period, we were also responsible for supporting HUD SAMS Post Insurance Notes Division, by becoming responsible of producing reports already generated by a JAVA Program written by Richard Stewart. In case he became unavailable, the client wanted someone else as a backup to be able to generate the same reports that he was primarily responsible for. During the course of this project we were:

1) Reviewing requirements to have system updated to current database technology.

2) Processing Special Reports with execution of Java Programming Code, and using SQL.

3) Received a Training Certificate for Java Programming.

4) Documenting Staff Meetings, including future proposals, for Notes.

5) Consolidating all available codes into one word document.

6) Review data extractions with Structured Query Language (SQL) from Production Table.

HUD Post Insurance Division was already transitioning these reports from their database systems: STRATEGY to the SMART System, based in Tulsa, OK. STRATEGY was the only system I had access to, and until the SMART system became completely operational in March 2010, the Post Insurance Division no longer needed reports from STRATEGY, and therefore closed the contract project with Precision by September 2010. Afterwards, Precision no longer had any more contracts and therefore closed the office.

McDonald Bradley, Inc. (MBI) Help Desk/Data Reporting 7/2003 – 3/2005

Supporting 1200 users for SAMS Mainframe Database Application users by:

• Write and execute SQL (via SELECT statements) queries to generate ad hoc reports, through QMF, Nomad & QList Applications.

• Generate and format reports in excel.

• Respond to email queries, telephone calls and STAR Tickets, in a timely manner.

• Refer to appropriate support group on issues about Password Resets & Network Connection.

• Scheduling and Training User’s Access to SAMS.

• Consult with Subject Matter Experts on SAMS related issues.

Log and update all call requests to the Access Database.

Independent Verification and Validation (IV&V) Website pages and SAMS Applications by:

• Evaluating, Identifying & Resolving Complex Problems (e.g., Broken Links, etc.)

• Writing Test Procedures/Defining Test Requirements

• Testing for broken links, Systems, Acceptance User Level and Regression.

• Client/Server based application Testing

Process Data Fix Request via approval process and notifying the end user, when completed.

Escalate priority calls to the team and upper management.

Assist the project team to comply with CMM Level 3 Certification, via ProcessMax.

Process the A43/Notes Procedure, utilizing DTSO, Python, & A43Strategy Interface applications.

Develop, modify, execute test plans, and report/track defects on any issues that should not have any significant impact with production prior to any new release implementation.

Develop over 3,000 special ad hoc reports for HUD for both authorized customers, by using Nomad, QMF, and SPUFI applications.

Volt Services Group Help Desk Support 3/2000-12/2002

Primary functions, includes web maintenance, reset passwords and perform log entries.

Physical Inventories on all hardware products (printers, computers, monitors, fax & all machine products) for Verizon in New York City, NY; Philadelphia, PA; Baltimore, MD; Washington, DC; Arlington, VA; & Richmond, VA .

Respond to Phone Calls and Email Queries, requesting support for technical issues, interfaced with the Network Administration Team.

Supported 80,000 internal Verizon users by receiving escalations from tier I help desk; support Lotus Notes mail; proprietary products; worked in accordance with service level agreement; generate reports using Microsoft Office products; and provided training on Help Desk responsibilities.

Received escalated issues through proprietary ticketing database built in Microsoft Access.

Supported 500 Vendor Documentations; 80,000 PeopleSoft Users, Customer Support, and application consolidation, for Verizon.

Training and assisting users access to Web/Mainframe/Legacy applications.

Technical Documentation: Wrote instructions on various Help Desk Activities.

Contact this candidate