John Payne
Senior Consultant at Parametrix
- Role
- Senior Finance Manager at T-Mobile
- Location
- Seattle, WA, US
- LinkedIn followers
- 500 followers
About John Payne
Possesses the vision and technical ability to design and create the architecture for…
Experience
Senior Finance Manager
Jan 2014 — Present · Bellevue, WA, US
Designed and built an automated Internal Management reporting deck for the Accounting Department using SAP\'s BPC/EPM OLAP tool, synced with Workiva to create a cloud-based, single sourced, online document that allows for individuals to add commentary, leave directed private messages, thereby creating a cohesive, collaborative, and consistent analytical package designed for monthly/quarterly review of the business that includes trends, metrics, and Rate-Volume tables.• Built a team, and led the design and develop of an SSAS environment, with multiple OLAP Cubes consisting of subscriber-level Revenue and Subscriber metrics, leveraging Alteryx as the ETL to combine various data sources, perform business logic, perform allocations as necessary, which then joined to our curated dimensions (MDM) for attribution, ultimately resulting in deep business insights for multiple departments, and showcasing the ability to slice into all the rich attribution for trends, metrics, ARPUs, and Churn for MoM, QoQ, and YoY reporting.• Created an Ambassador Program that worked with various groups within accounting focusing on automation of existing processes, typically via Alteryx workflows, BPC reports, Excel modeling, or SSAS Cubes. Provided training to improve the skill sets of people from various departments for Alteryx, SQL, BPC OLAP, SSAS OLAP, Workiva, and Excel.
Education
University of Dayton
Bachelor’s Degree
Skills
- Sql
- Strategic Financial Planning
- Business Analysis
- Forecasting
- Financial Analysis
- Business Process Improvement
- Financial Modeling
- Income Statement
- Hyperion Enterprise
- Financial Forecasting
- Data Analysis
- Pivot Tables
- Analysis
- Requirements Gathering
- Business Intelligence
- Competitive Analysis
- Start-Ups
- Analytics
- Finance
- Accounting
- Strategy
- Cross-Functional Team Leadership
- Financial Reporting
- Variance Analysis
- Access
- Cognos
- Reporting & Analysis
- P&L Management
- Ms Excel Pivot Tables
- Process Improvement
- Tableau
- Oracle Discoverer
- Leadership
- Essbase
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.