Patrick Franklin

Experience

• 

  Radian Guaranty

  Sept 1998 - Mar 2001

  Mortgage Insurance Tech

  -Work with client (Lender) to apply correct mortgage insurance policy to loans;-Coordinate billing with home office;-Build and track office staff productivity.

• 

  ABN AMRO Mortgage Group

  Mar 2001 - Mar 2007

  - Analyze business processes for key metrics to measure and evaluate company/department performance;- Develop process for communicating metrics to management and employees;- Create data pulls from key systems including Oracle DBs, MS SQL servers and locally stored data in MS Access to aggregate data for key metrics;- Publish data in presentable and easily understood formats;- Explain and instruct other technical users in best data-gathering practices;- Recommend improvement opportunities to business management based on data. Show less - Managed staff of 3 technical professionals designing database applications and reports supporting business processes;- Designed and maintained MS Access "small" database applications that ran daily key business processes used by 40+ simultaneous users;- Created complex reports aggregating and dissecting data to support process automation and business process monitering;- Worked with business management to determine ways database and reports could assist in making informed, data-based decisions; Show less

  • Operations Metrics Analyst II

    Oct 2006 - Mar 2007

  • Senior Business Analyst

    Jul 2002 - Oct 2006

  • Mortgage Underwriter 1

    Mar 2001 - Jul 2002
• 

  CitiMortgage

  Mar 2007 - May 2008

  Operations Metrics Analyst II

  (Transfer of position from ABN AMRO's sale to CitiMortgage)- Analyze business processes for key metrics to measure and evaluate company/department performance; - Develop process for communicating metrics to management and employees; - Create data pulls from key systems including Oracle DBs, MS SQL servers and locally stored data in MS Access to aggregate data for key metrics; - Publish data in presentable and easily understood formats; - Explain and instruct other technical users in best data-gathering practices; - Recommend improvement opportunities to business management based on data. Show less

• 

  University of Michigan

  May 2008 - Jun 2016

  Co-lead a team to create and customize a new SQL Server data warehouse. Designed and Created business intelligence user definition layer in BusinessObjects Designer tool. Wrote business technical requirements for data extracts for new database tables using the source application's database. Created dozens of new reports, including the department's key fundraising metrics report. Managed creation and organization of ~200 reports by the team.Participated in 6 design teams for new fundraising application; tested new system functionality.Created two in-application screens using software development kit features saving the University ~$40,000. Show less

  • Associate Director

    Mar 2015 - Jun 2016

  • Assistant Director

    Mar 2013 - Mar 2015

  • Team Lead, Sr. Business Analyst

    Aug 2011 - Mar 2013

  • Revenue Reporting and Business Analyst

    May 2008 - Aug 2011
• 

  University of Michigan Information and Technology Services

  Jun 2016 - Jan 2024

  Business Intelligence Analyst Lead for the new Information Quest team in the University of Michigan's ITS Department. I am responsible for: 1. Increasing the University's Business Intelligence capabilities and capacity;2. Managing, leading and co-developing the first Executive dashboard suite for the President, Regents, and Vice Presidents;3. Managing, leading and co-developing the Budget dashboard suite for the University's Deans, Finance Directors, and Budget Administrators;4. Creating the strategy and vision for the new U-M Metrics platform, metrics.umich.edu;5. Co-creating the strategy and vision for our BI tool set and integrating them. Show less

  • Business Intelligence Manager

    Jan 2019 - Jan 2024

  • Business Intelligence Analyst Lead

    Jun 2016 - Dec 2018
• 

  University of Michigan College of Literature, Science, and the Arts

  Jan 2024 - now

  Application Programming Manager