Data Warehouse Sql Server

EMPLOYMENT HISTORY

Bible League International – Crete, IL - REMOTE

Data Visualization Developer 2019 – present

Develop and enhance data visualization reports via Power BI creating global ministry impact data.

Create and troubleshoot complex queries, views, tables, functions, and stored procedures via SQL Server Management Studio (SSMS).

Investigate and resolve data warehouse errors in TEST, STAGE, and PROD.

Make recommendations for data that needs to be added to or removed from the data warehouse.

Manage the monthly data warehouse and ministry application data validation testing process.

Actively participate on the Power BI team in the capacity of a Data Wrangler.

Create and maintain a data warehouse data dictionary including database tables, fields, and definitions, descriptions, and other report-related information.

Developed and maintain technical documentation including report specifications, business process maps, Power BI functionality instructions, SQL query instructions, requirements documentation, data discrepancy investigation/solution documentation, and templates.

Maintain and support data confidentiality requirements.

Berkley Select – Chicago, IL - HYBRID 2008 - 2018

Business Intelligence Analyst II

Developed both SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) business reports via queries created from a relational database in SQL Server Management Studio providing professional liability insurance product data for both internal and multiple sister companies.

Tested SSAS cube dimensions and attributes data for data integrity purposes.

Gathered user requirements, designed, tested, and deployed SSRS reports to production.

Served as the SSRS subject matter expert (SME).

Created, updated, tested, and maintained SharePoint web parts.

Maintained well over 200 business reports published on the report server.

Completed monthly release validation testing for the claims, underwriting, and agent online portal applications.

Managed the report server project during the launch of the 2nd version of the underwriting application.

Business Analyst

Gathered professional liability insurance product business requirements from underwriting specialists, claim professionals, and stakeholders ensuring claims and underwriting applications new functionality requests and enhancements to existing functionality met the user’s needs.

Served as the business analyst subject matter expert (SME) for the claims application.

Composed and maintained use cases, manual test cases, and document specifications via Microsoft Word, Microsoft Excel, Wiki, and SharePoint.

Created workflows and wireframes for the underwriting, claims, and client portal application features via Microsoft Visio.

Devised and maintained automated test cases for the claims application via Telerik Studio.

Tested underwriting, claims, and client portal applications data via queries created in the SQL Server Management Studio relational database.

Managed, investigated, and resolved underwriting, claims, and client portal application helpdesk issues via TechExcel.

Performed user requirements gathering, interface design, and application testing during the launch of the claims application.

EDUCATION

Keller Graduate School of Management

Master of Information Systems Management

Contact this candidate