William Kessler Email & Phone Number

United States

- Lead cross-department projects to consolidate and automate business processes. One such project resulted in the creation of a reporting dashboard and improving data quality for over 4,000 active clients.- Develop and maintain comprehensive reports and dashboards in Power BI, including a specialized reporting dashboard for business users to oversee and manage data delivery to an external vendor.- Transitioned data delivery frequency from monthly to daily for critical work compensation data, reducing manual effort through automated workflows and SQL scripts.- Oversaw report access and licensing across the organization as the Power BI Admin, ensuring proper usage and compliance.- Engage with senior executives and "C" level leaders to create meaningful metrics that drive informed business decisions, and collaborate with development teams to enhance code quality and ensure data integrity.

Minnesota, United States

- Improved PowerBI dataflow performance by leveraging Sharepoint APIs to directly query data. Process went from 90 minutes to less than 20 seconds. - Acted as main contact for report and data support to the Treasury department. Collaborated with business users on multiple enhancements to improve report stability. Used by company partners daily for decision making. - Created a report which analyzed liquidity across multiple (15+) funds. Prior to the report, it would take a business user an hour to analyze a single fund.- Developed several SQL scripts to support reporting and data transformation needs.

Mendota Heights, Minnesota, United States

- Wrote some of the most complex and intricate SQL of my career up to this point. The overall Data Migration project was an ETL process but did not leverage SSIS – instead it was spread across SQL stored procedures, Power Shell scripts, and SSRS Dashboards.- Collaborated with colleagues to deliver on a company wide initiative to update and migrate an entire data transformation process from the UK to the US.- Worked remotely on a SQL Development team spread across multiple time zones and continents. Adjusted working hours to best accommodate the team.

- Improved billing process scalability by implementing detailed billing rules into SQL queries and automated using SSIS. During development, I discovered, and fixed errors within existing dependent processes and implemented improvements to reduce execution times to thirty seconds from 8+ minutes. - Designed and developed a Power BI dashboard to provide operational product billing data for users to identify trends, pinpoint issues, and provide IT teams with enough context to quickly correct underlying data gaps. Seized opportunity to create new billing metrics and paired them up with appropriate visuals for the finance team.- Improved performance of existing SQL Stored Procedures for use in SSRS reports resulting in significant reduction in load times. One report went from 2+ minutes down to less than 10 seconds, in addition to adding report filters for improved usability.

Greater Minneapolis-St. Paul Area

• Designed a dashboard for senior leadership to quickly identify employees requiring safety training to meet internal and regulatory needs. • Utilized DAX functions to create complex functions and metrics which were dynamically updated based on the users selections. • Used Microsoft tools to start the process of moving away from a legacy mainframe process, to a more modern and normalized data structure. • Quickly worked with experts within various business units to better understand what data is actually needed, and reconcile data definitions. Required working both as an efficient database developer, but also look at the project as a Business Analyst and Report developer.

Greater Minneapolis-St. Paul Area

• Designed interactive operational reporting dashboards using Power BI and SSMS to track incoming file traffic and alert users to any bottlenecks or missing files. • Used DAX to create custom metrics.• Lead the design and creation of an analytical dashboard which combined sales data with various demographics. Will be used by the client to sell additional financial products to existing customers.• Create SSIS packages to load incoming data from flat files into a common data structure.

• Work with MS BI tools (SSMS, SSIS, SSRS) to create data structures, stored procedures, ETL processes, and dashboard reports.• Collaborated with cohort of BI Developers to create a suite of reports organized into a dashboard as part of a major initiative to overhaul outdated processes.• Shared several stored procedures with team to streamline reporting logic and simplify parameter behavior.• Interacted with several legacy systems (mix of DB2 and older SSMS databases) to gather data into the Data Warehouse.

• Produce reporting requirements and design. Identify key data and, if necessary, coordinate with data warehouse ETL developers to update processes.• Utilize Agile methodologies. Create stories to support report and ETL developers. • Use SQL queries to analyze data to identify gaps or production issues. Tables contain upwards of 1 billion records. • Work with Data Architect to migrate legacy systems to new DB structure and ensure adequate query performance and reporting accuracy.

• Elicit IT business requirements for the creation of a unified e-commerse website for a large airline company.• Travel to stakeholders location for checkpoints and information sharing as needed. • Defined technical requirements for an expanded CQ5 release, allowing marketing department ability to edit content without IT involvement.

- Data warehouse requirements and analysis. Data sourcing from varied sources.- ETL requirements and initial process design.- Proactively identify key metrics and set up reports to measure performance.- Utilize SSMS to create stored procedures or AdHoc scripts to support business needs.- Write operational and technical requirements for reporting and data needs.- Identify data discrepancies, trace to source, document and resolve.- Have some hands-on development experience with SSRS .

- Clearly document business and technical requirements for new system enhancements and production fix solutions- Provide in-depth technical support for applications used in government sponsored foreclosure prevention programs, HAMP being most common- Collaborate with technical BA’s on large scale production fixes and process redesigns to create a complete solution- Utilize SQL to devise ad-hoc reporting for senior management. Also employ SQL when researching issue scope and root cause- My reports are the primary source for key statistics used by senior management during loan modification planning and forecasting meetings- Support identified issues scheduled for delivery at a future date

- Wrote project related test plans, based on requirements design documents, and compiled training materials for business users- Conducted testing to ensure program functionality and deliver a quality product to production- Acted as subject matter expert for loss mitigation solutions providing vital insight into Loan Servicing policies, procedures and underlying system processes - Led the development of a modification document verification tool which is used by our legal, compliance, servicing and technology departments to validate modification terms are correct before documents are sent to customer- Write/build queries using Access for reporting and analysis needs- Create customized excel spreadsheets to streamline data mining and present information in an easy to understand format for senior management

Provided in depth account level research to identify and resolve issuesAnswered business users questions, from collections staff to managementProcess complex modifications at an account level while maintaining accuracy. Modifications ranged from full contract changes to standard payment reallocations. Assist the account conversion process when GT boards new loans from other servicers. This ranged from account research to ensure account balance/due date and other key data was correct to processing sensitive maintenance when an issue was identified.

Bachelor Of Arts

Associates Of Arts