Patrick Mcshane Email & Phone Number

Seattle, Washington, United States

Business Systems Analytics and Processing with a focus on Revenue systems and trial-balance processing and reconciliation across multiple operating companies- Partner with teams from operating companies distributed globally to tighten delivery of their trial balance results, and with developers to test and implement new analytical and reporting tools to.

Bellevue, WA

Manage high-volume monthly Loyalty reporting processes; drive process improvement and automation of reporting needs for accounting customers; manage SQL Server environment for my team's production and development processes. Built high-volume SQL Server file exports in Visual Studio to simplify management of monthly exports and promote visibility of export.

Manage ongoing process improvement for Accounting customers by promoting, designing and implementing automated delivery of reporting and data solutions. Drive analysis of Non-Contractual Lodging Revenue for Accounting and Financial Planning & Analysis Teams. Perform quarterly analysis of Stale Payments to drive reserve for same. Manage monthly.

Business and data analysis with a focus on process-mapping, transaction flow and ETL in enterprise finance applications. Projects include:- Streamlining revenue reporting by converting queries in SQL Server and DB2 from hard-coded date variables to expressions to eliminate need for monthly updates to several scripts- Supporting client's accounts-payable.

I managed a small team that performed production support and project coordination for various platforms that fed the legacy enterprise Washington Mutual General Ledger. This included:- Transition support for Chase conversion from October 2008 to November 2009.- Data analysis and management on the WaMu General Ledger to support conversion to JPMorgan Chase.

Led a team of analysts that performed production support, project coordination and testing for various business-line system integrations into the enterprise Washington Mutual General Ledger. This included coordinating implementation for version-releases, hardware upgrades and functional improvements, as well as supporting and designing tools to streamline.

Worked with business and systems resources to integrate new business-line application feeds into enterprise General Ledger; coordinated cross-functional teams to ensure success of Corporate Finance year-end close activities. Created and implemented year-end close task-management process which promoted cross-functional transparency and streamline issue.

Provided testing requirements, validation and reporting on enterprise General Ledger to maintain compliance of system-integration test results with corporate policies. Designed and validated UAT and Clean-Management test cases for Y2K testing of the bank’s General Ledger, resulting in a successful certification of readiness from the bank’s Y2K project.

Certificate, Global Supply Chain Management

Global supply chain logistics with a focus on sustainability in supply networks and quantifying risk-mitigation strategies.

Mba, Technology In Business

Activities and Societies: Participating in Pacific Northwest Investment Research Challenge for 2010.

Bachelor Of Arts, English

Activities and Societies: Varsity Football 1987-1989 Creative Writing Thesis used the structure of a short story to explore the impact of.