Post Job Free

Resume

Sign in

Sql Server Engineer - 9 Years, Data Analyst, Report/Database tester

Location:
Kirkland, WA
Posted:
July 02, 2014

Contact this candidate

Resume:

Bruce Burke

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

Kirkland, WA *****

acetot@r.postjobfree.com

425-***-****

SUMMARY

Over 25 years of enterprise-level IT experience with a valuable blend of

technical and management skills required for the development and

implementation of successful, cost-effective software systems. Strong

experience in software QA, database analysis and ETL processes.

. Expertise in designing and developing information technology solutions

to support core business processes.

. Extensive experience in leading QA teams in defect tracking strategies

and solutions.

. Strong understanding of banking and loan systems and regulations.

TECHNICAL SUMMARY

TestDirector, TestTrackPro, Bugzilla, VSS, MS SQL Server 2005 & 2008,

Oracle 7.3/8.0/8i, TOAD, Crystal Reports Paradox 3.5, PowerBuilder 6.5, MS

Office Suite, WinRunner (10+ years ago)

PROFESSIONAL EXPERIENCE

4/2005 - 1/2014 Milliman Inc.

Seattle, WA

Data Analyst / Database Tester

Responsible for Database Analysis, Database Testing, Testing ETL

procedures, and creating numerous reports using custom SQL or stored

procedures.

. Have used SQL Server 2005/2008 on a daily basis since April 2005.

. Wrote ad-hoc stored procedures to generate various reports for the

Benefits Coordinator

. Created and debugged complex ETL processes using T-SQL queries,

functions, stored procedures and SQL Server Agent jobs.

. When problems occurred, I was always the first person our Benefits

Coordinator would come to with the question "Is this a bug, bad data

or wrong specifications?"

. Created and debugged various SQL Server SSIS processes and Agents.

. Our team was called "Health and Welfare Outsourcing Services" (HWOS).

We handled the various Benefit Types for our clients.

Technologies used: MS SQL Server 2008, T-SQL, MS Access

9/2004 - 1/2005 Promium (contract)

Seattle, WA

QA Engineer (Database and UI Testing)

Promium writes software for companies that do chemical testing in the

environmental industry.

. Responsible for database and UI testing

Technologies used: MS SQL Server 2005

12/2003 - 5/2004 Microsoft (contract) Redmond, WA

Software Design Engineer in Test (SDET)

Member of team responsible for database and data integration testing for a

large internal database and CRM application.

. Responsible for data analysis and integration between Siebel CRM and

internal databases.

. Bug regression and tracking

. Test Case planning/writing

. UI testing

Technologies used: MS SQL Server 6.5, RAID

10/2001 - 6/2002 Bellevue School District

Bellevue, WA

High School Mathematics Teacher (temporary)

Taught trigonometry, pre-calculus, algebra and geometry classes

12/2000 - 6/2001 Community Health Information Services

Seattle, WA

Systems Test Manager

Managed team of 6 QA engineers.

. Maintained the bug tracking system (TestTrackPro)

. Maintained the test case tracking application (TestDirector 7.0I)

Technologies used: TestTrackPro, TestDirector 7.0

3/1999 - 12/2000 Tidemark Solutions Seattle, WA

PowerBuilder Developer

Lead Developer in charge enhancement and maintenance of company's

Municipal Building Permit System software products.

. Conducted company-wide seminar on bug detection techniques.

. Developed and implemented coding standards (naming conventions,

comments, code reviews, etc.)

. Liaison with the Sales Dept. and Technical Support in answering their

questions.

Technologies used: PowerBuilder 6.5 and MS SQL Server 6.5/7.0 and Oracle

7.3/8.0/8i; Crystal Reports

4/1998 - 3/1999 DeviceGuys Inc.

Redmond, WA

QA Team Lead

QA Team Lead testing UI and print drivers for multi-functional peripherals.

. Mentored two other testers.

. Wrote over 1200 test cases.

1/1998 - 4/1998 Catapult Inc. (subsidiary of IBM)

Bellevue, WA

QA Manager

Responsible for testing software geared to the Computer-based Training

(CBT) market.

. Managed team of 8 QA engineers (Three permanent and five contractors)

. Developed and implemented QA standards.

. Wrote recommendation for software bug tracking system to replace

cumbersome manual system.

. Mediated between QA team members and members of the Development team.

. Conducted interviews for new team members

. Provided written recommendations for QA team members.

. Wrote test plans and test cases

11/1997 - 12/1997 Infomodeler (contract)

Bellevue, WA

QA Engineer

Short-term contract to test database-modeling software in the areas of UI

and SQL-generated scripts.

8/1997 - 11/1997 Microsoft (contract) Redmond, WA

QA Lead

. Wrote test scripts for the GUI on three internal VB projects: (Mail

Administration, AP Metrics and Executive Office).

. Wrote test cases, and performed regression, ad-hoc, and database

testing.

Technologies used: Test Case Manager, VSS, Visual Basic

4/1993 - 5/1997 ServerLogic Corp.

Bellevue, WA

Senior Consultant

Developed source code solutions and provided extensive telephone, fax and

email technical support for company's flagship 3rd party PowerBuilder Class

Libraries: PowerClass, PowerObjects and PowerLock.

. Preformed beta-testing of core software products.

. Trained additional technical support personnel.

. Wrote the invoicing module for an large accounts receivable

application in MicroFocus COBOL.

Technologies used: PowerBuilder 2.0 - 6.5, MicroFocus COBOL

8/1987 - 4/1993 Bank of America

Seattle, WA

Lead Analyst Programmer

Part of team that developed a customized PC-based branch bank support

system that gave bankers the ability to provide loan quotes and manage

customer relationships more effectively. System was built using Paradox

3.5 and then rewritten using Visual Basic 2.0.

. Customized and supported ProLog-based application that printed all of

the bank's loan documents. Worked closely with the bank's legal

department to ensure the wording of all forms was correct.

. Developed a "Financial Calculator" in MicroFocus COBOL that computed

payments, APR, etc.

. Wrote an on-line help system for the Visual Basic version of the

application.

Technologies used: MicroFocus COBOL, ProLog, Paradox, Visual Basic

EDUCATION/CERTIFICATIONS

Master's Degree - Mathematics Bemidji State University

Bemidji, MN



Contact this candidate