Sql Server Quality Assurance

May Woo

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

Kent, WA *****

Home: 253-***-**** abl50y@r.postjobfree.com Cell: 206-***-****

SUMMARY

Highly Motivated and experienced Business Intelligence Professional using

SQL Server 2005 and Microsoft Technologies. Over 10 years of experience in

areas of QA Analysis, Development, Testing and Data Analysis. Demonstrated

leadership abilities to work successfully with variety of teams onshore and

offshore.

Proven experience manipulating various data sources to support Senior

Management decisions.

http://www.linkedin.com/in/maywoo

CERTIFICATIONS

CSQA (Certified Software Quality Analyst), CSTE (Certified Software Test

Engineer) - Certificates from QAI (Quality Assurance Institute) (re-certify

every 3 years since 2000)

Leadership Program Certificate from EDI (Executive Development Institute) -

Leadership Program for culturally diverse leaders

TECHNICAL SKILLS

Microsoft Technologies: SQL Server 2005 Integration Services, SQL Server

2005 Analysis Services, SQL Server 2005 Reporting Services, Microsoft

Office SharePoint Server 2007, Microsoft Visio

Databases: MS SQL Server 2005, MS SQL Server 2008

Software: Visual Studio .NET 2005, SQL Server Business Intelligence

Development Studio, Server SQL Server Management Studio

Operating Systems: UNIX, MS-DOS, VAX/VMS, IBM Mainframe, TSO/ISPF

Programming Environments: VB, C, UNIX shell script, XML, HTML

Experienced Environments: Teradata, Data Mart, DB2, Mainframe, INSYNC, OLAP

cubes, Excel, ACCESS, Excel Pivot table, Netezza, WinSQL, Defect Tracking

Tools

QA Specific Skills: Black box testing, white box testing, regression

testing, integration testing, performance testing, test preparation &

planning, test cases, test scripts building, test estimation, troubleshoot

defects, root cause analysis, good knowledge of software development life

cycle (SDLC), Lean Six Sigma for process improvement, and Infrastructure

Library (ITIL) standards.

SetFocus, LLC., Kent, WA 7/2009

- 9/2009

Business Intelligence Master's Program

. Implemented a Labor Analysis Business Intelligence solution for a

fictitious national construction company.

. Existing data from diverse data sources were consolidated into a uniform

SQL server 2005 database. SQL Server Integration Services was used to

define imports of the data, build scheduling packages, to define

integration flow, log data error exceptions and orphaned data and to

define Database Maintenance Plans and send emails.

. Created a number of cubes, dimensions, and business critical KPIs using

SQL Server Analysis Services representing aggregations in several

different ways - hierarchically and using custom groupings that the

company will use to analyze performance. Created several MDX queries

according to business requirements.

. Developed several detail and summary reports including line and pie

charts, trend analysis reports and sub-reports according to business

requirements using SQL Server Reporting Services.

. Implemented business intelligence dashboards using MOSS 2007 Report

Center and Excel Services producing different summary reports results

based on user view and role membership.

. Created score cards with executive summary dashboards using MS Office

Performance Point Server 2007 Dashboard Designer that display performance

monitoring measures for sales, Sales trends, and book return rates for a

fictitious book publisher deriving data from a SQL Server 2005 OLAP data

source and deployed them to SharePoint sites. The dashboards also

contain drill-down capabilities to view book sales by book category and

customer, through summary reports and sales trend charts.

. Created score cards with advanced set of dashboards using MS Office

Performance Point Server 2007 Dashboard Designer that feature executive

summary measures for revenue, overhead costs, material purchases, labor

and profitability trends for a fictitious construction company extracting

data from a SQL Server 2005 OLAP data source and deployed them to

SharePoint sites. The dashboards also contain pages to view performance

by employee, by region, by quarter enabling end-users to make filter

selections.

PROFESSIONAL EXPERIENCE

LG Consulting - Premera Blue Cross, Mountlake Terrace, WA

10/2009 - 12/2009

Data Warehouse QA Analyst - LG Consulting Staff at Premera Blue Cross

. Assisted Data Warehouse team in testing, analysis and validating

accuracy of data on different databases by building queries, doing

data mapping, creating MDX scripts to validate data against end-user

eClare cube all of which was ran on vendor Verisk Health Business

Intelligence (BI) analytical tier.

LIBERTY MUTUAL COMPANY (formerly Safeco Insurance) Seattle, WA 5/1999

- 3/2009

Sr. Quality Assurance Analyst

Led 7-10 QA (on-shore/offshore) in Enterprise Data Warehouse Business

Intelligence Program Production Support Team.

. Participated in requirements and tested cases reviews; tested Production

Support work and development projects.

. Participated in defect analysis and root cause analysis. Provided test

status and test reports and tracked work requests to successful

completion.

. Increased data quality and productivity 25% by streamlining QA best

practices and processes.

. Generated QA new processes or approaches resulted in freeing up QA

resource to work on new enhanced work requests.

. Reduced project defects 15% by effectively testing small to large

projects, provided project risks and making recommendations to project

team.

. Mentored QA Analysts resulting in increased product delivery by 30%.

THE BOEING COMPANY, Seattle, WA 3/1991 - 4/1999

Business System Programmer Analyst

Developed specifications, systems analysis, coding and testing activities

from HP9000 system platform to UNIX platform and then initially started to

program data into VB platform, and provided consultation to customers.

. Increased customer satisfaction 35% by delivering data to customers with

more robust system

Engineering Data Control Specialist

Analyzed and translated product data to computer system codes and formats.

. Provided resolution to correct the discrepancies for engineering

suppliers and customers resulting in defect free output.

VA MEDICAL CENTER, Seattle, WA 6/1988 -2/1991

Medical Insurance Clerk

Billed third party medical insurances by transcribing patient's prognosis

into medical code.

. Generated monthly reimbursable insurance reports to help Finance

Department for additional income visibility.

. Served as a liaison between Accounts Receivable and the Billing

Departments on account status.

. Received certificate of achievement for superior performance.

EDUCATION

University of Washington, Seattle, WA

Bachelors of Science, Mathematics (Numerical Analysis)

PROFESSIONAL AFFILIATIONS

. Executive Development Institute (EDI)

. Seattle Area Software Quality Assurance Group (SASQAG)

. University of Washington Alumni

. Washington Technology Industry Associations (WTIA)

. Microsoft Business Intelligence Professionals

. Business Intelligence Group

. QA & Testing Group

. SetFocus MP Alumni

Contact this candidate