Timothy Mcmahon Email & Phone Number

Philadelphia, PA, US

Villanova, PA, US

Villanova, PA, US

• Administration of Data Insights Analytics Platform and user access
• Develop Redshift data models and Tableau KPI dashboards
• Support Internal and External University Reporting
• Work with Data Stewards Committee to develop and monitor data policies

Malvern, PA, US

• Work with business unit directors and business users to gather requirements and KPIs for Qlikview application development.
• Design and implement strategy for implementation of new applications.
• Develop Qlikview applications to provide business insights to plant managers, planners, directors, and executive teams.
• Consult with business users to resolve reporting and data issues related to Qlikview applications and provide end user training for Applications.
• Consult with internal SAP and Salesforce Teams to develop business data mapping and improve data quality.
• Optimize data scripting to improve performance and reporting accuracy.

Wayne, Pennsylvania, US

• Provided financial and activity data from current and potential clients for Board and Executive team by developing a market dashboard in Tableau.
• Prepared plan performance analytics reports via Tableau for clients, TPA, and brokers.
• Collaborated with outside consulting firm to develop predictive model for client attrition to improve customer service and retention.
• Provided daily client status summary by developing dashboards for Client Relation Managers and CRM Director in Tableau.
• Developed an automated process in SQL allocating fixed legal expenses to balance bills and providing insight for future business strategy.
• Developed an automated email notification via C# for management team on specific client status changes.

Wayne, Pennsylvania, US

• Collaborated with cross-functional team to develop Client P&L reports and calculated client EBITDA for the Board and Investors.
• Developed employee performance dashboards in Tableau for employees and managers to track daily performance.
• Leveraged internal claims data along with Medicare/Medicaid data to develop insight into providers as part of a new platform to assist members in choosing a healthcare provider.
• Leader in developing first Tableau dashboards utilized in the company, representing major shift in company-wide reporting techniques.
• Analyzed market data and developed pivot table for provider contracting strategy.

Philadelphia, US

• Created an automatic Loan Reporting system by Excel VBA and formulas to track the payment status of clients’ loans, significantly increased the quality control level of the loan payment data.
• Developed Macros to assist in automating the generation process of reports, and recording/tracking of account payments
• Designed/Created/Updated fillable PDF forms by Adobe LiveCycle Designer based on account type and action type for clients
• Reconciled federal tax withholding reports daily and state tax withholding reports monthly
• Developed SQL queries to generate accounts reports for departments across the board, as well as to identify errors in records.
• Processed client account transactions, and submitted forms.

Villanova, PA, US

Teach calculus to undergraduate college students.

Villanova, PA, US

Grade student homework, conduct problems sessions for calculus classes, tutor students in courses including calculus and differential equations.

Williamsport, PA, US

Tutor students in math classes through calculus level.

Certificate, Applied Project Management

Master Of Business Administration - Mba

Master Of Arts (Ma), Mathematics

Bachelor Of Science (Bs), Mathematics