Scott Langridge

Experience

• 

  US Cellular

  Jan 1995 - Jan 1996

  Credit Analyst
• 

  Transamerica

  Nov 1996 - now

  - Create Management Reporting in Tableau for Underwriting Department in the Individual Solutions Division.- Mentor colleagues on Tableau and Data Visualizations- Primarily utilizing Tableau and custom SQL queries as data sources - Create dashboards in Tableau and reporting in SSRS for several Operational departments (Underwriting, New Business, Compliance, Vendor Liaisons, Technology, etc.) in the Individual Solutions Division.- Mentor colleagues on Tableau and Data Visualizations- Primarily utilizing Tableau and custom SQL queries as data sources • Lead for Technology projects for Tax Department.•Administrator for the TIA (Tax Investments Accounting) database. Key responsibilities: • Co-Lead for the Operational Excellence (O.E.) Targeted Result for the Tax Department. • Co-Lead of Business Continuity Plan for Tax Department.• Member of the Management team for Tax INV Reporting and RMT (Resource Management Team). • Member of team responsible for GAAP pricing for securities in PAM on a monthly basis.• Developed ad – hoc reporting from IDW (Investments Data Warehouse) for business stakeholders using Crystal, Business Objects and MS Access.• Liaison between business users and INV Division IT personnel to develop production quality reports.• Responsible for gathering requirements and user acceptance testing for both the Internal Pricing and Rating Intranet websites. • Responsible for reconciliation of assets held at custodian banks, paying and tracking custody bank fees, researching and resolving cash claims, and participating as subject matter expert for various projects.• Represented the Custody Operations department on the PAM Change Management committee.• Lead for user acceptance testing and database requirements for MS Access database used for bank reconciliations.

  • Lead Research Analyst - Underwriting

    Mar 2022 - now

  • Intermediate Business Intelligence Developer/Analyst

    Oct 2014 - Mar 2022

  • Tax Manager

    Jun 2002 - Oct 2014

  • Senior Financial Systems Accounting Analyst

    Dec 2000 - Jun 2002

  • Senior Custody Administrator

    Nov 1996 - Dec 2000
• 

  Center Point-Urbana High School

  Mar 2022 - Jun 2023

  Head Varsity Girls Golf Coach