Patrick McShane

Experience

• 

  Washington Mutual

  Nov 1998 - Sept 2008

  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 recovery. Designed and implemented custom trial-balance reporting which enabled the reconciliation of the General Ledger to enterprise Hyperion financial reporting. Show less

  • Business Operations Manager

    Jan 2003 - Sept 2008

  • Senior Business Analyst

    Jan 2001 - Dec 2002

  • Business Analyst

    Nov 1998 - Dec 2000
• 

  JPMorgan Chase

  Sept 2008 - Nov 2009

  Senior Finance Analyst-Operations

  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- Testing and coordinating implementation for version-release testing, hardware upgrades and functional improvements- Supporting and designing tools to streamline month-end and year-end close processes. Show less

• 

  Resources Global Professionals

  Nov 2010 - Sept 2013

  Consultant

  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 year close reconciliation by pulling summary balance and transaction-detail from Oracle Financials using Unix SQL- Analyzing synopses of reconciliation outages to derive business requirements and build queries to quantify reconciliation findings- Tailoring query inputs so that output volumes matched business users' data-management capacities Show less

• 

  Expedia Group

  Sept 2013 - Sept 2019

  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 parameters. Implemented weekly backup-and-restore of production SQL Server databases to virtual machines to improve data redundancy and recovery. Automated rollout of daily archival of changes to tables and stored procedures. Built dashboard to review SQL Server logins across multiple servers to simplify security audits of our server environment. Show less 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 reasonability analysis of bookings across reporting platforms via SQL Server and Business Objects. Managed monthly Line of Business Revenue reporting from PeopleSoft and Oracle. Show less

  • Revenue Systems Manager

    Aug 2016 - Sept 2019

  • Senior Revenue Systems Analyst

    Sept 2013 - Jul 2016
• 

  RGP

  Oct 2019 - now

  Business Finance Consultant

  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 shorten reconciliation of trial balances against client’s enterprise financials from ten days or more to two or three days.- Continuously refine processes and deliverables to achieve greater efficiency, enrich analytics and drive more value for customers. Use Alteryx Designer to simplify identifying and assessing impact of changes in enterprise trial balances on monthly consolidation processes, to create trending of when changes occurred, and to discern which accounts and entities were affected. - Iteratively develop and refine solutions to analysis and reporting of trial balance and related data streams to drive new views into the data, simplify analytics and consolidate EBT year-end reporting from over 20 teams to one.- Drive Tax Account Reconciliation and EBT Forecast processes to reconcile over 20 operating companies’ results from against enterprise financials of a global investment holding company - Manage user accesses on critical platforms including Corptax, Vertex Tax Performance Engine and My Insight Client Edition. Ensure that access needs are addressed quickly, that requisite approvals for changes meet compliance needs and that accesses are periodically audited. Show less