Quality Assurance Sql Server

Peter Nelson Allen

(***) *** - ****

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

WORK EXPERIENCE

Sirius XM Radio Inc., New York, NY July 2008 –

Present

Operations Data Analyst – Service Management Group

Train the company staff in using BMC Remedy 7.1 ticketing system. Evaluate system service outages. Perform post

mortems diagnosing the problems and highlighting the solutions. Lead the Change Control Board meeting by recording

the minutes and creating the agenda for the following meeting. Provide ad hoc reports showing the backup data activity in

the datacenters. Generate monthly compliance reports showing the Sirius XM’s compliance with PCI standards using

ECORA.

Sirius Satellite Radio Inc., New York, NY November 2007 – July 2008

Operations Data Analyst – I.T. Operations

Performed data analysis to identify patterns and trends. Generated a variety of routine, special & ad hoc reports weekly,

monthly, quarterly, annual and special reports and/or data using MS Access and MS Excel. Identified variances to

monitoring trends, quantities, variances, budgets and forecasts. Developed and maintains customized operations

management reports. Participated in the Change Control Board meeting by recording the minutes and creating the agenda

for the following meeting using the MAGIC ticketing system. Generated monthly compliance reports.

United Parcel Service Information Services, Paramus, NJ May 2004 – November 2007

IT Associate/Jr. Business Analyst – Customer Information Management Visibility (April 2006 – November 2007)

Analyzed and communicated system policy improvements to the High Frequency Tracking process procedures.

Performed analyses using MS Access to determine tracking activity of various UPS clients (as well as 3rd party activity)

on www.ups.com. Generated daily reports on the activities and transactions by the various customers and clients.

Consulted with the customer application groups to develop appropriate business practices. Implemented policies that

enabled customers to process their information effectively and efficiently. Participated in strategic planning, design and

re-engineering for the tracking systems.

Quality Assurance Analyst– Field Certification Lab (May 2004 – April 2006)

Performed automated and manual testing in order to detect defects within the various UPS Global applications. Teamed

with the application groups and managers to identify solutions to the inaccuracies found during testing. Developed defect

reports and memorandums documenting the results. Installed UPS NT, W2K and XP operating systems as well as

performing NT to AD migrations. Set up and configured W2K and Win2003 servers. Developed an understanding of

several UPS applications.

TECHNICAL COMPETENCIES

Familiar with automated testing tools (Quicktest Pro v8.2, Load Runner, Win Runner), Assembly, AutoCAD (14.0, 2000),

MS Office (Word, Excel, PowerPoint, Access, Outlook, Visio), MS SharePoint, SQL Server 2005, Crystal Reports 10,

Remedy ARS 7.1 and Ecora Auditor 4.1.

Hands-on experience building server and workstation application environments. Working knowledge of installation and

configuration procedures using UPS versions of W2K, XP and Server 2003.

Experience with lab LAN/WAN test environment and establishing communications between servers and workstations.

Install and configure external application peripheral devices within Active Directory.

Ability to use Remedy 7.1 in expediting the Change Control and the Outage processes.

EDUCATION

New Horizon Computer Learning Center, New York, NY

Implementing a Microsoft SQL Server 2005 Database March

2008

Crystal Reports 10 - Level 1 May 2008

New Jersey Institute of Technology (Newark College of Engineering), Newark, NJ

Bachelor of Science in Electrical Engineering (BSEE) *June

2010

EXTRA-CURRICULAR ACTIVITIES

Captain of the Sirius XM Radio Soccer team (2007 – present); Member of Total Package Softball Team – Winners of the

UPS Softball League (2006 & 2007); Volunteer at the George Washington Carver Institute Career Day (2008 & 2009);

Participant in the Willow Creek Leadership Tele - Conference 2005 (Montclair, NJ).

Contact this candidate