| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Azure Data Sql Aurora, IL Data Warehouse Modeling Aurora, IL ETL Developer, SQL Developer, Data Analyst, Programmer Hoffman Estates, IL Sql Server Data Architect Buffalo Grove, IL Datastage Developer Data Warehouse Chicago, IL Inventory Control Data Entry, Warehouse supervisor, plant superv Chicago, IL SQL, Microsoft Excel, Power Bi, Data Analytics, Python Chicago, IL |
|
Click here or scroll down to respond to this candidateEMPLOYMENT HISTORYBible League International Crete, IL - REMOTECandidate's Name Street Address presentDevelop 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 - 2018Business Intelligence Analyst IIDeveloped 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 AnalystGathered 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 users 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.EDUCATIONKeller Graduate School of ManagementMaster of Information Systems Management |
