Philip Korte Email & Phone Number

Greater Seattle Area

Responsible for collaborating with executives to understand business needs to better inform and provide for actionable information. Designed and developed business solutions that communicate performance metrics, historical trends and KPIs that focus business towards key opportunities and inform better business decisions. Deliver high quality reporting solutions by utilizing a variety of BI applications, including SQL Server, SSRS, PowerPivot and Power BI. Provide on-demand reporting on financial and operational data for directors. • Develop and maintain various ETL processes that extract data from multiple platforms, including Oracle and SQL databases, and upload to central data warehouse.• Investigate potential errors in data structures and work with business services to ensure corrective measures are taken.• Write complex SQL queries in Oracle SQL Developer and MS SQL Server.• Create and maintain monthly metrics presentation for management, documenting business status and performance.• Use Power BI and SSRS to provide dynamic and engaging visual reports to executive team.• Utilize Excel PowerPivot to provide ad-hoc reports to executives across multiple departments.

Greater Seattle Area

Collaborated with vendors to resolve any issues with accounts payable. Implemented new business procedures. Subject matter expert for company-wide software upgrade. Trained colleagues on use of Microsoft Excel components.• Reduced user error through creation of forms and templates.• Created new purchase order procedures.• Reconciled and paid employee expense claims.

Redmond, Wa

Lead specialist in charge of reconciliation project. Utilized research and cross-departmental and national communications to maintain the reconciliation project. Adjusted monies, activated and deactivated accounts, refunded customer down payments and deferred payments on customer accounts. Identified and mitigated problems with contracts. Trained new employees.