Sql Server Engineer - 9 Years, Data Analyst, Report/Database tester
Resume:
Bruce Burke
Kirkland, WA *****
*********@*********.***
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