Quality Assurance Sql Server

Chuck Lavergne

.NET/Business Intelligence Developer

Kirkland, WA 98034

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

425-***-****

Synopsis

** ***** ********** **** *** Server within Development, Operations, and Test.

3 years working with Microsoft SQL Server Business Intelligence products supplemented with formal training.

Summary of Assets

Development Skill Set

PowerShell • C# • VB.NET

TSQL • MDX • ASP.NET • XML

Warehouse Architecture

ETL • SSAS • SSRS • SSIS

Business Intelligence Technologies

Microsoft Excel Automation

SQL Server Analysis Services PerformancePoint

SharePoint Integration

Professional Roles

Data Analyst

SDE and Development Lead

SDE/Test and Test Lead

Technical Product Manager

Jun 2011 – Dec 2011 Speech@Microsoft Group – .NET SDE (Volt Contract)

.NET Development: C#, ADO.NET, XML, Excel Interop, XBox Kinect Speech API.

• Develop .NET classes and tools to parse, aggregate, and report XML data.

• Develop application to execute speech recognition engine by reading configuration from database.

PowerShell:

• Develop Hyper-V automation scripts using WMI to create and configure Virtual Machines.

• Enhance existing scripts. Consolidate logic from several scripts for flexibility and supportability.

Excel Automation and Charts: Develop data driven charts using Excel formulas.

Sep 2010 – Mar 2011 SQL Server Business Intelligence Training and Exam 70-448 Preparation

Course curriculum included the following topics:

• SSAS cube development and Data Warehouse Modeling.

• ETL using SSIS and TSQL.

• SSRS using TSQL, MDX, DMX.

Preparation for Exam 70-448 certification.

Aug 2007 – Jun 2010 Extended Results, Inc. – Senior BI Consultant and Developer

.NET Development

• Develop assemblies using C#, SharePoint API, PerformancePoint Server API.

• Develop SharePoint ASP.NET application to extend PPS scorecard capabilities to render customized KPI details.

• Apply C#, ASP.NET, JavaScript, XML, and AJAX to enhancement and fix ASP.NET application, MSI Installer, and Desktop Widget.

Excel Automation (MDX and VBA)

• Develop Excel application used for adding KPI commentary to BI Dashboard.

• Apply Excel formulas to dynamically set chart properties and query parameters.

SSRS and SSIS

• Develop stored procedures and SSRS reports. Maintain existing SSRS report.

• Develop SSIS package for importing flat file data.

May 2005 – Jul 2007 Costco Wholesale – .Net Development in QA

C# Automation Testing

• C#, NUnit, TSQL, BizTalk. Create .NET assemblies and tools for automation testing of credit card authorization process.

• Test Lead – Design test plans, schedule work items, identify dependencies and risks, assess resource allocation, delegate task completion, and report progress.

Feb 2002 – Feb 2005 Volt and Excel Data Corporation – .Net Development in QA

Microsoft Windows Server Feedback:

• Automation testing w/ C#, ASP.NET, SQL Server. Review design specs and collaborate with Development for test planning.

Microsoft Windows Hardware Online Services: Test Lead, Tester, test automation

• C#. Develop assemblies for internal automation testing framework Microsoft’s WHQL website.

• Responsible for mentoring new QA personnel, test planning, and directing leading test effort.

Microsoft Windows Media Group:

• Develop automated tests against the WMP API using VB, VBA, XML, JavaScript.

• Develop automated BVT for Office XP embedded OCX.

• Manage test environments and OS imaging used for compatibility testing.

Oct 1999 – Apr 2001 Codesic, Inc. – Web Developer

eSociety.com: ASP Developer and Lead for trade association vertical portals.

• Responsible for developing website features and integrating third party services.

• Provide technical consultation and mentoring. Initiate coding standards.

AT&T Wireless: Web Developer.

• Develop application to enable management to monitor wireless phone activation data.

• Design and develop security feature used for user-level access to sensitive information.

Nov 1997 – Sep 1999 Best Consulting – Web Developer / Quality Assurance

Provide software development and testing for Microsoft, AT&T Wireless, and Virtual Source Network.

Virtual Source Network: ASP VB COM Developer for e-commerce procurement application.

Microsoft Corporation, MCSP: Support Analyst. Fix stored procedures and website code.

Microsoft MS Product: Document system infrastructure used for Bill of Materials and Pricing data.

AT&T Wireless: Quality Assurance Tester

Jun 1997 – Nov 1997 Excell Data Corporation – Web Developer / DBA / Reporting

Microsoft Windows Group: Support for Windows 98 Beta Test and Install Fair Web Sites.

• Aggregate and report customer satisfaction.

• Routine DBA maintenance, schema design, data migrations, and web development using ASP, SQL Server, MS Access, and Excel.

Education

• Associates of Applied Science in Computer Science from Renton Technical College. (1997)

• Associates of Science in Engineering from Bellevue Community College. (1995)

Contact this candidate