John Jagoe

About John Jagoe

I\'m in this business because it\'s the last resort for artists that have absolutely no skills in music, painting or acting. It allows me to create something that wasn\'t there before, and that\'s why I love what I do. As an analyst with software development and consultancy experience, I have played an active role in delivering many complex, business-focused software solutions for more than 10 years. Like many analyst/developers, I have strong software development and mathematical skills. My differentiation comes from combining these with effective communication skills to build rapport with colleagues and clients, adopting a pragmatic can-do attitude and enjoying problem solving in a commercial environment. Known as the go to person with transferable skills; attention to detail, organized, work with patience, flexible, persuasive and the consummate team player. I\'m proficient in multiple core languages, including, but not limited to: VB.Net, C#, VBScript, Access, and SQL-) Strong report development skills using the following tools: MS Access, SQL Server 2008, Crystal Reports and MS Excel-) Strong VBA coding skills for MS Access or MS Excel-) Strong Query capability or Stored Procedure Creation using SQL Server 2008-) Demonstrated Adhoc reporting experience (such as merge together new, disparate data sets into common data set/report for requests. I love making new professional acquaintances. Reach out if you want to talk tech or business. Specialties • Visual Basic 6.0/VB.Net 2005/2010 • C# • SQL/Server 2005/2008R2 SSIS • Process Modeling • MS Access/MS Excel/VBA 2010 • Business Objects/Crystal Reports • Business Analysis • Data Analysis using R

Experience

1. Business Planning & Analyst Iii

   M&T Bank

   Oct 2011 — Present

   Develop and produce complex departmental reports, databases and spreadsheets to include but not limited to Key Risk Indicator and Past Due Maturity, Incentive Compensation and Treasury Management reporting. Automate the creation of reports in a variety of reporting tools such as MS Access, MS Excel, VB.Net, SQL Server, Business Objects or additional reporting tools-) Helped redesigned sales goal setting process by developing a new Goal Tracker application utilizing VB.Net 2010 and SQL Server 2008. Application was instrumental in reducing the time it takes Commercial and TM Group managers to enter sales goals for Relationship Managers-) First to develop Live Excel reporting to the Commercial Banking community. Thru SharePoint these reports provide an innovative way to deliver secured ERM data via MS Excel linked to ERM/SQL data and updated automatically-) Served as database administrator for department’s SQL Server 2008R2 Databases.

Education

• Mortgage Bankers Association

  School of Mortgage Banking I - An Introduction to the Real Estate Finance Industry

  2015

• Mortgage Bankers Association

  School of Mortgage Banking III - Strategic Planning for Mortgage Bankers

  2017

• ServiceNow

  ServiceNow RiseUp/NextGen Externship

• Syracuse University

  Bachelor of Arts (BA), Mathematics

  1980 — 1985

• Cloud Code Academy

  Salesforce Developer Kickstart Program, Salesforce Development

• Mortgage Bankers Association

  School of Mortgage Banking II - Managing Profitability and Risk

  2016