Manager Analyst

Andrew Zygarewicz

Pacifica, CA ***** 650-***-**** ******.**********@*****.***

[pic]

SQA Manager /Analyst

Proficient in QA techniques and methodologies focusing on functional,

system integration, regression, platform testing, user acceptance testing

(UAT) and managing teams from developers to Business Analyst to working

well with Management and providing support at all levels.

Skills

. Anticipated potential issues and created effective solutions;

saving time, re-work and money

. Experience building and training QA teams, planning resources,

managing offshore contributors up to 14 members including

programmers.

. Proficient in designing and executing SQL queries for testing

purposes

Willing to travel: Yes 30%

U.S Citizen: Yes

Availability: 1 week

Type of position: Full time or contract

Tools: Microsoft Project, Mind Manager, MindJet, Visio, Visual Source

Safe, Subversion, MS Office, SQL Server 2005, VMWare, Virtual PC, XML,

Enterprise Architect, Classic ASP, ASP.Net, C#, HTML, JavaScript, Flash

Action Script, VB Visual Basic, Access, SQA, LMS, Crystal Reports, IIS,

Test Complete, PhotoShop, MySQL

[pic]

Professional Experience

SFL SQA Manager Analyst (Contract): 9/2009 to 6/2010

. Scoped Media Tracker for working with multiple intakes which

included a WinForms application which utilized google style

searching with DevExpress components developed in VB.NET. VS2010

. Created scripts and triggers for dynamic database and index

creation including test scripts

. Created data model for project and UDFs in SQL 2008

. Participated in software walkthrough. Tested MediaTracker Light on

iPhone 2g, 3g, including downgrading firmware.

QA Manager Analyst -- Williams Sonoma : 6/2008 to 6/2009

. Managed development and testing scope of Store Portal, Gift

Registry and PreTek.Net. These applications were developed in

ASP.Net and C#. Store Portal was a load balanced web based

application used for communications with over 650 stores

nationwide. Pretek.Net, a WinForms application, was used in

forecasting SKU inventory across all concepts.

. Developed testing automation scripts in Test Complete.

. Conducted baseline performance testing of SQL reports. Reduced

operating cost by implementing Jira bug tracking software for

tracking bugs as well as user Stories for product development

. Check / Review existing Test Cases and develop new test cases as

needed

. Trained business team to write requirements in a use case format

. Kicked of VM Ware effort between technology teams to consolidate

applications and testing.

. Updated SharePoint templates to accommodate new stores.

QA Manager Analyst - HUMAN RESOURCE MICRO SYS (Full Time ) 1/2006 to

5/2008, SF CA

. Assigned work for local and offshore teams leading enhancements to

HREntre (an HRIS web application) in a SQL Server 2005 ASP.Net C#

environment.

. Created test environments by installing VMWare virtual machine,

Window XP, SQL, Server

. Higher level requirements were modeled in greater detail, while

keeping lower priorities to a minimum via agile methodology.

. Increased productivity by devising system to track hours and

resource allocation by project.

Business Analyst (Contract) -- Wells Fargo Bank, Corporate HR 3/2004 to

01/2006, SF

. Held rapid application workflow prototyping sessions increasing

participation and excitement around process improvement resulting

in highly productive meetings by utilizing Mind Manger. Designed

and directed development of Executive Coaching web application that

supported needs of senior executives, used for entering, searching,

sorting, email alerts and displaying profiles for qualified

coaches.

. Performed User Acceptance Testing (UAT) to ensure developed

application was in compliance with business.

. Helped design stored procedures, interactive html demos on IIS.

Successfully improved Wells Fargo's requirements gathering

processes using collaborative workflow prototyping tools .

Developed Saba Centra site usage reports utilizing data warehouse

development.

Release Manager Analyst (Contract), CaseCentral.com, 4/ 2002 to 2/2004,

SF CA

. Managed Release improvement, Print Production and Pitney Bowes

partner integration projects. Improved code releases to production

by establishing development and release standards.

. Changes were made across six web servers, three MSMQ Servers and

three SQL servers.

. Created functional specs for Print Production application. Held

regular status meetings with cross functional teams. Define

deliverables and commitments with engineering team. Utilized Dev

Partner Studio to pinpoint performance issues in COM components.

Wrote test scripts and automated testing using Selenium

. Worked with business users to populate customer data in SQL Server,

in appropriately-designed tables.

Product Manager, Ensera (Startup), 1/2001 to 2/2002, Redwood City CA

. Successfully lead 2 projects consisting of 9 developers, 2

business analysts, 1 DBA and 7 support personnel.

Ensured all deliverables and milestones were met for projects.

. Demonstrated skills in analyzing and re-engineering web based

customer satisfaction reports for 3000 business clients from MS

Access printed reports to SQL 2000 data warehouse development, a

classic ASP solution (AutoChex).

. Salvaged IonControl by focusing reengineering efforts in object

oriented design.

. Mentored Jr. developers on adding multi-user features, and reducing

code size by reusing modules and converting ASP based applications

into VB.NET and moving client side SQL into SQL 2000 with Stored

Procedures.

Systems Analyst, MyEvents.com (Startup), 10/1999 to 2001, SF CA

. Lead development of Tasks, Photo Album and Weather modules on

MyEvents.com, a portal similar to MySpace and Facebook. Developed

core business logic in components. All developed code scaled well

on a web farm with many simultaneous users.

. Developed XML export routines for updating Earthlink's PSP. Cross

trained development team's 14 engineers on functional specification

development and release procedures.

Systems Analyst / Architect, Tuttle Decision Systems Internet 1997 to

10/1999, Mill Valley CA

Developed project plans throughout the year for the web team and provided

the marketing group with training on in-house developed software.

. Organized weekly web focus group meetings.

. Designed and developed thin client applications including Automated

Servicing Transfer (AST), Career listings, Career Admin and Sales

Admin Tool. Configured and maintained corporate, backup, stage and

Intranet web production servers in the public internet domain.

Remotely managed web team.

Business Analyst, Providian Financial, 1995 to 1997, San Francisco CA

Developed Support Analyst, a multi user call tracking system developed

using VB and Access. Streamlined call time turnaround by providing a

problem search knowledge base and eliminating redundant input, call

logging and generating weekly reports; the software aided in increasing

support staff performance by 35%.

. Developed a Dunn & Bradstreet middleware program which generated

custom letters via automation. Created GUI front ends for

transforming 3270 mainframe data. Stabilized a multi user Time-

Tracking application with FoxPro on the Apple Macintosh.

Training:

Bachelor of Science Degree Pending

A.S. Degree in Computer Science, Heald Institute of Technology

Hobbies:

Umpiring baseball games

Contact this candidate