Summary
Overview
Work History
Education
Skills
Accomplishments
Additional Information
Timeline
BusinessAnalyst
John Woodland

John Woodland

Marysville,WA

Summary

Perceptive Business Manager/Senior Business Analyst with 20+ years driving successful business processes for leading financial, communications, and software companies. Dedicated to maximizing impact of key performance metrics to enhance and expand business operations. Known for leveraging both macro and micro-scale analyses to generate holistic images of ongoing business operations for immediate actionability.


Dependable, energetic individual with multiple years of experience as a shift supervisor and electronics technician in the Navy, a product manager and business analyst working in online banking/bill pay services with Washington Mutual Bank, Service Partner Management with T-Mobile USA, Payment Services Analytics with JP Morgan Chase Bank, and a senior business analyst with Beyondsoft Consulting. During this time in these roles, proving myself to be an effective leader and trainer, someone who is competent, organized, with the ability to handle any task or role presented by creating reports, applications and streamline processes to help reduce employee workload, overall costs, and improve customer/client satisfaction.

Overview

20
20
years of professional experience

Work History

Senior Business Analyst

Beyondsoft Consulting, Inc.
05.2019 - Current
  • Analyzed performance metrics to identify opportunities to increase SLA performance from 77% to over 94% within first year in role.
  • Interacted with internal customers to understand business needs and translate into requirements and project scope on contract earning approximately $2 million dollars per year.
  • Supported leadership team with reporting, analysis and business presentations to inform divisional strategies.
  • Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
  • Supported leadership team with reporting, analysis, and business presentations to inform divisional strategies
  • Managed team performance by implementing measurable metrics to track delivery of supporting requirement artifacts
  • Effectively supervised team performance by implementing measurable metrics to assess delivery of requirements

Business Systems Analyst II, Associate

JPMorgan Chase & Co
07.2007 - 03.2019
  • As lead analyst for JP Morgan Chase's Natural Language Search reporting team, developed reporting strategy, process, data models, SQL queries, and Excel based user tools to collect metadata to show customer’s search to call journey analytics to aid reducing phone calls into customer by ~15,000 per month saving ~$2.5 million annually.
  • Bill Payment Operations budget, driving continuous improvements, and informed decisions to aid in reducing cost per transactions by ~375,000 per month - $4.5 million annually.
  • Developed training documents/job aids and mentored and trained newly hired Business Analysts in processes, reporting, database structure and analytical design of Bill Payment Operations tools and data warehouses.
  • Trained business personnel in use of systems.
  • Collected, defined and analyzed business requirements.
  • Coordinated data migration and consolidation efforts.
  • Helped deploy system enhancements to improve field operations.
  • Tracked feedback at all levels and researched resolutions for common concerns.
  • Created and maintained standard operating procedures governing system functions and features.
  • Identified needed business improvements and determined appropriate systems required to implement solutions.
  • Assessed business requirements to create focused solutions.

Business Analyst II

T-Mobile
12.2005 - 07.2007
  • Created and managed invoicing approval process for $300M annual spending budget for senior staff reviewers that provided graphs, historical information, and call outs for items of note or impact to team and budget.
  • Effectively communicated and escalated discrepant issues/items to Service Partner Business Manager, where necessary, for reconciliation and resolution.
  • Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
  • Drafted quarterly and yearly reports on company financial metrics to assess successes and account for deficiencies.
  • Developed and controlled execution of reporting and analytics for multiple operations departments.
  • Built and harmonized operations reports for team leaders, senior managers and executives, supervising automation of reports and data sources to eliminate errors.
  • Interacted with internal customers to understand business needs and translate into requirements and project scope
  • Performed gap analysis to identify areas of improvement
  • Improved business direction by prioritizing customers and implementing changes based on collected feedback
  • Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement

Asst. Manager/interim Manager

Washington Mutual Bank
02.2003 - 12.2005
  • As interim manager for Workforce Management (WFM) department’s Command Center, recruited and developed 7 employees for day to day operations.
  • Managed Command Center staff performance, coaching, counseling, and professional development of personnel.
  • Evaluated employee performance on monthly basis and conveyed constructive feedback to improve skills.
  • Supervised site investigations, reported issues and escalated those that required further assistance.
  • Identified and diminished performance gaps by coaching and supervising 10 subordinates.
  • Identified conflicts among employees and used interpersonal communication to find effective solutions.
  • Maintained positive customer relations by addressing problems head-on and implementing successful corrective actions.
  • Established team priorities, maintained schedules and monitored performance.

Education

No Degree - Computer And Information Sciences

Edmonds Community College
Lynnwood, WA

Skills

  • Analytic tools such as SQL & Excel (Power Query, Pivot Charts, Pivot Tables, vLookups, Filtering, & VBA)
  • Database design and data extraction (ETL) working with large data sets
  • Data visualization tools such as Power BI and Tableau
  • Microsoft Power Automation (MS Flow)
  • Microsoft Power Apps
  • Agile and Scrum Environments
  • User Acceptance Testing (UAT)
  • KPI Tracking
  • Python/R Programming
  • Kusto Query Language
  • Project Management
  • Product Management
  • Staff Management
  • Staff Training
  • UAT Support
  • Process Optimization
  • Workforce Management - Forecasting and Planning
  • Business Requirements
  • Business Process Mapping
  • Client Meetings

Accomplishments

  • Twenty years of experience in a Data Analyst role with a strong focus on supporting financial systems, ETL, data cleansing and mining, data governance, and query and report writing. Ensuring data accuracy by performing detailed analysis and researching and resolving exceptions by providing practical solutions to reduce future occurrences.
  • Twenty years of experience with SQL Server and querying relational databases. Extracting and reconciling customer data from multiple sources, including internal/external databases, SharePoint, and spreadsheets.
  • Ten years of experience in supervisory/management role managing day-to-day operations and training of personnel by prioritizing tasks and project deadlines in accordance with company goals and obligations.
  • Client Interface - Developing a deep understanding of client data schemas and data models to automate reporting and reconciliations while also developing a comprehensive understanding of the processes that currently exist and how to automate them for the future.
  • Coordinated and collaborated with cross-functional teams (ex. Engineering, Data Engineering, Data Analytics, Treasury, Compliance, etc.) to understand business requirements and develop solutions business analysis to address reporting automation, including internal tool development and implementation of third-party tools (Power BI, Power Automate and Power Apps).
  • Partnering with product and operation teams to prepare and deliver regular reports, providing insights and recommendations to management based on data analysis to identify areas for improvement, increasing overall KPI scores by streamlining business processes and identifying areas for improvement.
  • Project Management - Directed development team of 5 developers/analysts. Supervised deployment and integration of project to handle real-time monitoring, alerting and report generation to support client’s worldwide contact centers.
  • Earned the T-Mobile’s Simply the Best “SMART” Award winner for documenting, redesigning, and improving invoicing approval process senior managers and key stakeholders to make informed decisions regarding invoices totaling more than $300 million dollars per year.

Additional Information

Awards

  • Seattle Children’s Chorus’ Kevin Corvin Volunteer of the Year Award Winner.
  • Chase Consumer & Community Banking’s Five Keys Recognition – Building Lasting Relationships.
  • T-Mobile’s Simply the Best “SMART” Award winner.
  • Washington Mutual’s Enterprise Contact Center’s Annual Frontline Winner.
  • Washington Mutual’s Enterprise Contact Center’s Service Excellence Award Winner.

Timeline

Senior Business Analyst

Beyondsoft Consulting, Inc.
05.2019 - Current

Business Systems Analyst II, Associate

JPMorgan Chase & Co
07.2007 - 03.2019

Business Analyst II

T-Mobile
12.2005 - 07.2007

Asst. Manager/interim Manager

Washington Mutual Bank
02.2003 - 12.2005

No Degree - Computer And Information Sciences

Edmonds Community College
John Woodland