Patrick Franklin

Patrick Franklin Email and Phone Number

Ypsilanti, MI, US
Patrick Franklin's Location
Ypsilanti, Michigan, United States, United States
Patrick Franklin's Contact Details

Patrick Franklin work email

Patrick Franklin personal email

Patrick Franklin phone numbers

About Patrick Franklin

-Lead and develop high-performing teams of business intelligence analysts & business systems analysts. -Able to assess, develop, and grow a business intelligence infrastructure;-Understand advanced technical concepts and able to translate between technical and non-technical people;-Train non-technical and technical users in system functionality and basic to advanced data and database concepts;-Translate business needs and processes into new system elements that work for IT and the business;-Summarize complex data to create reports and dashboards that cultivate a culture of making decisions with data for all levels of the organization, Specialties: Hiring talented, creative people who can apply their skills to creating and interpreting data. Managing teams that create complex reports and dashboards, train technical and non-technical users in their use, develop communities around data best practices, and bridge IT and business worlds.

Patrick Franklin's Current Company Details
University of Michigan College of Literature, Science, and the Arts

University Of Michigan College Of Literature, Science, And The Arts

View
Application Programming Manager
Ypsilanti, MI, US
Patrick Franklin Work Experience Details
  • University Of Michigan College Of Literature, Science, And The Arts
    Application Programming Manager
    University Of Michigan College Of Literature, Science, And The Arts
    Ypsilanti, Mi, Us
  • University Of Michigan College Of Literature, Science, And The Arts
    Application Programming Manager
    University Of Michigan College Of Literature, Science, And The Arts Jan 2024 - Present
    Ann Arbor, Mi, Us
  • University Of Michigan Information And Technology Services
    Business Intelligence Manager
    University Of Michigan Information And Technology Services Jan 2019 - Jan 2024
    Ann Arbor, Mi, Us
  • University Of Michigan Information And Technology Services
    Business Intelligence Analyst Lead
    University Of Michigan Information And Technology Services Jun 2016 - Dec 2018
    Ann Arbor, Mi, Us
    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.
  • University Of Michigan
    Associate Director
    University Of Michigan Mar 2015 - Jun 2016
    Ann Arbor, Michigan, Us
    Associate Director managing a team of 7 business systems analysts in data, business intelligence, visualizations, and marketing data.
  • University Of Michigan
    Assistant Director
    University Of Michigan Mar 2013 - Mar 2015
    Ann Arbor, Michigan, Us
    Assistant Director of Reporting and Information Analysis in the Office of University Development
  • University Of Michigan
    Team Lead, Sr. Business Analyst
    University Of Michigan Aug 2011 - Mar 2013
    Ann Arbor, Michigan, Us
    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.
  • University Of Michigan
    Revenue Reporting And Business Analyst
    University Of Michigan May 2008 - Aug 2011
    Ann Arbor, Michigan, Us
    Produced and verified fundraising revenue numbers for the Michigan Difference campaign. Designed, modified and maintained a variety of reports in BusinessObjects, Oracle SQL and other tools to support the UM fundraising community. Designed key management reports post-campaign using new, more stable methodology.
  • Citimortgage
    Operations Metrics Analyst Ii
    Citimortgage Mar 2007 - May 2008
    New York, New York, Us
    (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.
  • Abn Amro Mortgage Group
    Operations Metrics Analyst Ii
    Abn Amro Mortgage Group Oct 2006 - Mar 2007
    Amsterdam, Nl
    - 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.
  • Abn Amro Mortgage Group
    Senior Business Analyst
    Abn Amro Mortgage Group Jul 2002 - Oct 2006
    Amsterdam, Nl
    - 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;
  • Abn Amro Mortgage Group
    Mortgage Underwriter 1
    Abn Amro Mortgage Group Mar 2001 - Jul 2002
    Amsterdam, Nl
    - Underwrite A and A+ wholesale loans to corporate and industry standards to mitigate bank risk;- Work with mortgage broker customers to cure issues on loans;
  • Radian Guaranty
    Mortgage Insurance Tech
    Radian Guaranty Sep 1998 - Mar 2001
    Wayne, Pennsylvania, Us
    -Work with client (Lender) to apply correct mortgage insurance policy to loans;-Coordinate billing with home office;-Build and track office staff productivity.

Patrick Franklin Skills

Analysis Business Intelligence Access Business Analysis Data Analysis Databases Data Warehousing Sql Management Microsoft Office Business Process Training Oracle Business Objects Microsoft Sql Server Analytics Project Management Data Visualization Fundraising Vba Requirements Gathering Business Process Improvement Process Improvement Production Support Business Object Software Development Data Modeling Program Management Ms Office Suite Sdlc Sharepoint Software Project Management Microsoft Access Visual Basic Data Mining Visio Software Documentation Requirements Analysis Vendor Management Oracle Sql Business Objects Designer Technical Writing

Patrick Franklin Education Details

  • University Of Michigan
    University Of Michigan
    English
  • Williamston High School
    Williamston High School
    College Prep

Frequently Asked Questions about Patrick Franklin

What company does Patrick Franklin work for?

Patrick Franklin works for University Of Michigan College Of Literature, Science, And The Arts

What is Patrick Franklin's role at the current company?

Patrick Franklin's current role is Application Programming Manager.

What is Patrick Franklin's email address?

Patrick Franklin's email address is pf****@****ich.edu

What is Patrick Franklin's direct phone number?

Patrick Franklin's direct phone number is (734) 764*****

What schools did Patrick Franklin attend?

Patrick Franklin attended University Of Michigan, Williamston High School.

What are some of Patrick Franklin's interests?

Patrick Franklin has interest in Children, Politics, Civil Rights And Social Action, Environment, Science And Technology, Human Rights.

What skills is Patrick Franklin known for?

Patrick Franklin has skills like Analysis, Business Intelligence, Access, Business Analysis, Data Analysis, Databases, Data Warehousing, Sql, Management, Microsoft Office, Business Process, Training.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.