Current Data Services Developer/Analyst specializing in T-SQL feeds and reports, Data Warehouse, SDLC, project
planning, unit testing and SSRS development. Professional, detailed, flexible with
proven analytical skills. Adept at researching and learning. Dedicated to process improvements, testing, and
in-depth documentation with experience in managing sensitive materials, working
with big data, updating feeds from data warehouse and supporting team members.
Development Tools: SSRS, TFS, Red Gate, Visual Studio
Testing Tools: Microsoft Test Manager, Visual Studio TFS.
Internet Technologies: XML, HTML
Software: Microsoft Office, Active Batch, Beyond Compare,
Software: Ultra Edit, Macro Express, Nova PDF, SolutionSoft (TimeMachine)
Data Services DeveloperJan 2016 to Current Long Term Care Group － Eden Prairie, MN
Manage weekly deployments for Data Services team
Write Validations in T-SQL against our data warehouse
Create and Update SSRS reports through reporting services
Create Jobs through Active Batch to run reports and feeds
Create reports using stored procedures
Utilize reference architecture SSIS to Text
Write SQL for ticket request for internal and external customers from data warehouse
TFS management of code base and unit tests
Creating unit test cases to validate code
Lead Data Warehouse QA analystFeb 2014 to Mar 2016 Long Term Care Group － Eden Prairie, MN
Manage and improve processes for QA team such as help Create Entrance/Exit criteria
T-SQL knowledge to data mine cases for testing requirements as well as validate development code
Experience with QA methodologies, Requirement analysis, writing test plans and test cases based on system requirement specifications as well as identifying potential gaps.
Excellent hands on experience in handling the defects throughout the bug life cycle from detection until resolved using Microsoft TFS and Test Manager for test tracking and defect management.
Helps manage and guide off-shore resources
Manage team's servers and databases
Lead and mentor QA analyst
Independent and self-directed – Can work with minimum supervision.
Strong analytical skills, combined with effective communication, organizational skills and planning ability working with SDLC
Testing using data warehouse, user interface, cross departmental collaboration
Detailed writing of test documentation and assisting of team members in creation of documentation
Flexible often work external client testing (full integration testing) and internal functional testing projects simultaneously
External Client QAOct 2009 to Oct 2016 Long Term Care Group － Eden Prairie, MN
Estimates testing in coordination with the client work effort for assigned projects.
Compose test cases to test application or system functionality.
Write test plan and test case workbooks for quarterly code release for operations.
Executes manual test cases for application or system functionality and performs analysis to ensure that it meets design specifications.
Document and publishes testing results, troubleshoots, and escalates issues as appropriate.
Communicate with internal clients
Composed external client communications
External client testing test case entry and bug recognition and analysis
Database management (deployment of new code, refreshing, etc.) Working with DBA's to get databases refreshed/created
T-SQL queries for data mining
Integration Testing End to End testing of internal systems to external client validation
Strong communication skills in written and verbal
Enterprise Implementation AnalystJul 2005 to Oct 2009 Long Term Care Group － Eden Prairie, MN
Prioritized workflow for all processes based on client set up needs and identified report issues
Maintain and Create word documents using merge fields and IF statements
Manage and maintain user access by determining what the needs are of the users, and the ability to trouble shoot errors to resolve access issues.
Serve as a tester for new code releases to the system and identify defects, log them and monitor their status.
Set up and maintain client information in the system, trouble shoot errors, and resolve outstanding issues.
Enter test cases for clients in a quick and accurate manor, run and post files 3 times weekly.
Create test cases for system modifications and accurately analyze output before sent to client.
Execute Queries in SQL 2005 to reference tables and analyze information.
Interact with Business users, developers, and clients to ensure timely and accurate delivery of product
Education and Training
Bachelor of Arts, Business Administration International Studies2005University of Wisconsin River Falls
Business Administration and International Studies
Abroad Program: Wisconsin in Scotland
Study Abroad Program: Taiwan Exchange (Fall 2003)
Online Training, ITPluralSight.com
Visual Studio 2012 - Part 1
Completed on Mar 11, 2015
Completed on Feb 24, 2014
XML tools by
Completed on Apr 28, 2014
Transact-SQL Basic Data Retrieval
Completed on Jan 30, 2015
Completed on Jun 09, 2014
How to Have a
Better Career in Software
Completed on Jul 16, 2014
Completed on Mar 11, 2015
Technology in the Information Age
Completed on Jul 17, 2015
Completed on Jul 27, 2015
Completed on Sep 29, 2015
Automated Testing Framework With Selenium
Completed on Dec 09, 2015
Completed on Dec 16, 2015
Fundamental SQL Querying course completion - Fall of 2008