Allan Scherger Email and Phone Number
Allan Scherger personal email
- Valid
Experience providing day to day business intelligence for 6,000+ employee department; dashboards; financial, operational, and productivity analysis.I manage and present information in a clear and compelling way to allow end users to make business decisions with current information. I have also designed, implemented, and run presentation layer tools (ie QlikView / Tableau / Power BI / etc) for 100s of other analysts.Business intelligence / data analyst - advanced analytics and operational analytics. Led team to stand up data science platform (including jupyter hub) to leverage expertise across teams and implement use cases to move to a big data lake platform. Standardized use of python, java, R, and related libraries across large group of expert data scientists and data analysts. Successfully worked with executive lead team to achieve over $150M in annualized financial savings (synergies) due to the CenturyLink integration of Qwest following merger.Other Experience: work with executive lead teams of departments with 3,000 to 7,000+ staff (plus contractors) on 6 major integrations or spin-offs over 15+/- years. 3 at Sprint (Local consolidation; Local/Long Distance/Wireless consolidation; and Nextel integration); 1 Embarq spin-off; 1 CTL/Embarq merger; 1 Quest/CTL merger. In these transactions my official role was as a finance adviser but I've always had experience working with the overlapping issues of organizational design; headcount reductions & realignments; functional design; project management; production processes and metrics; synergies; etc.Specialties: Python, Java, SQL, Excel, Oracle, Numpy, Pandas, Jupyter, Cloud, etc. Cross-functional work between operating groups and finance. Proactive Business Intelligence and Business Analytics approach to deliver results.
Marine Credit Union
View- Website:
- marinecu.com
- Employees:
- 412
-
Director Of FinanceMarine Credit UnionCoon Valley, Wi, Us -
Sr Data Analyst (Financial & Operational Analytics)Marine Credit Union Sep 2021 - PresentLa Crosse, Wisconsin, Us~$1B Regional Credit Union Lead benchmark study of Income Statement; Balance Sheet; and Sales / Operational metrics with external consultants. Product business cases; sales team bonus plan automation; Power BI dashboards.~50/50 split between FP&A/Accounting/Deposit Ops and Data Analytics. SQL Server, Python, Excel, etc to analyze data and automate data flows. -
Data And AnalyticsGig Work Jan 2020 - PresentRecent & Current Clients: NIH - National Institute of Health Department of Defense - Research, Development, Test & Evaluation, Air Force eCommerce Startup - confidential Renewable Energy Company - confidential Others Data driven, software driven, results driven. I'm open to one-off projects and on-going projects.I am part of a strong network of freelancers that I can partner with to deliver data driven solutions across many different software languages. I'm responsible for hands on work and for delivering quality results (right time, right cost, right look and feel, right performance, etc).Please reach out if you'd like to sync up to share ideas or think through 'the art of the possible'.
-
Sr Data Consultant (Business Intelligence / Financial & Operational Analytics)Sunpro Solar Energy Specialists Dec 2020 - Sep 2021Mandeville, La, UsSunpro Solar – Covington, LAPrivately held high growth company (2x per year) in renewable energy with 3,000+ employees Daily interaction with senior management & owners to analyze and deliver on budgets; P&L; and KPIs on $0.75B+ of total company revenue in a high-growth environment. Build and present current year and 5-year financial plans to senior management and investors. Design, analyze, & build metrics tracking tools and work with field operations (1,100+ people) to deliver on budgeted daily/weekly/monthly objectives. Use Power BI, Tableau, & Snowflake to analyze data and implement change to improve results. -
Sr Manager Advanced Analytics And Business IntelligenceLumen Technologies Feb 2018 - Jan 2020Monroe, Louisiana , UsCenturyLink - Data Science / Big Data Center of Excellence.Lead team of 5-7 people with senior titles including 3 PhD data scientists. Hands on work on team that delivered Data Science initiatives >$30M in benefits across multiple business units.Deploy Jupyter Python platform; demo use cases; consult; and onboard >200 data science end users with connections to data lake.Use data and systems to deliver business value across multiple organizations.Use Python, Numpy, Pandas, Jupyter, etc for data analysis, data cleaning, data exploration, etc.Active part of a Scrum Team – knowledgeable of Agile processes.Hands on and in-depth experience with QlikView in a production setting with 100s of end users.Develop, enhance, and troubleshoot QlikView and QlikSense Dashboards working with multiple end user groups.Daily hands on work with SQL Queries against Oracle, SQL Database, Data Lake, Warehouse, etc.Worked with all three architecture tiers of Qlik applications.Used APIs to connect data via Python and Java, etc. -
Manager Operations Productivity And Financial AnalysisLumen Technologies Jul 2011 - Feb 2018Monroe, Louisiana , UsSuccessfully Led a team of 5-7 people with senior job titles. Operational Analysis; Business Intelligence; Advanced Analytics; Big Data & Predictive Analytics.Reduce cycle time 30% to save ~$300M in short term funding requirements for projects.Hands on and in-depth experience with QlikView/Tableau in a production setting with 100s of end users.Develop, enhance, and troubleshoot QlikView and QlikSense Dashboards working with multiple end user groups.Daily hands on work with SQL Queries against Oracle, SQL Database, Data Lake, Warehouse, etc.Worked with all three architecture tiers of Qlik applications.$2B capital budget for network construction; designed, built, managed Force to Load productivity management tool for ~14,000 employees (Eng, Construction, Field Ops); Network construction project management cycle time and unit cost analytics.2017+ Big Data Services & Rapid Advanced Analytics; deployed Jupyter data science platform; staff manager (conducted over 50 interviews for principal architects; PhD data scientists; etc)2015 Launched Predictive Analytics Center of Excellence (Advanced Analytics; Data Science; Big Data)2011 Roll out QlikView for intranet reporting to 250+ end users and Tableau for visual data analysis. -
Manager - Fp&A (Financial Planning & Analysis)Embarq Jan 2005 - Jul 2011Monroe, La, UsFull finance support for $1B IT department during and after the spin-off from Sprint/Nextel. Budgeting; Forecasting; Variance Analysis. Provide financial and operational analytics to the IT organization via benchmarking analysis, cost driver analysis, outsource analysis, business case analysis, and other financial analysis. Also perform all month end financial analysis and reporting for IT and work on multiple ad hoc finance requests for the entire IT department at Embarq.(Embarq is a $6B Revenue company - it was a division of Sprint/Nextel prior to the spin-off in 2006. Embarq offers a full range of telecom services in its local territories) -
Supervisor - Financial AnalysisSprint 1998 - 2005Overland Park, Kansas, UsStarted as a contractor in 1998; converted to employee in 1999.Provide financial decision support to the IT lead team with multiple directors and VPs. In 2001 I consolidated support of 3 divisions (long distance, wireless, and local) into a consolidated department. We reduced Expenses by $150M (15%) between 2001 and 2004 via layoffs and cost reduction efforts. During this time company revenue and customers continued to grow dramatically (Sprint PCS was launched - PCS was the fastest company to go from launch to $10B in Revenues). -
Operations AnalystChristensen Farms 1997 - 1998Sleepy Eye, Mn, UsLender Interface (interim de facto Treasurer)Lead finance person during growth from ~$30M to $100M in assetsStructured FinanceFinancial and Operational Analysis -
Project AnalystAgstar Farm Credit 1995 - 1997Direct Deals across 5 states (MN, ND, SD, IA, WI)Loan and Traunch Participation deals (both buy and sell) across United StatesAgribusiness Loan analyst - $1M+Large Dairy Project Analysis - $1M+ loansSBA Dairy Loans - 1100 cow turnkey farm dealsLarge Hog Farm Project Analysis - $5M+ loansBillable Consultant
Allan Scherger Skills
Allan Scherger Education Details
-
University Of Kansas - Graduate School Of BusinessCorporate Finance / Marketing -
Drake UniversityCorporate Finance / Bank Management
Frequently Asked Questions about Allan Scherger
What company does Allan Scherger work for?
Allan Scherger works for Marine Credit Union
What is Allan Scherger's role at the current company?
Allan Scherger's current role is Director of Finance.
What is Allan Scherger's email address?
Allan Scherger's email address is al****@****ail.com
What schools did Allan Scherger attend?
Allan Scherger attended University Of Kansas - Graduate School Of Business, Drake University.
What skills is Allan Scherger known for?
Allan Scherger has skills like Cross Functional Team Leadership, Business Intelligence, Financial Analysis, Telecommunications, Analysis, Vendor Management, Process Improvement, Business Process, Business Process Improvement, Integration, Mergers, Business Analysis.
Who are Allan Scherger's colleagues?
Allan Scherger's colleagues are Taylor Wheeler, George Weidert, Robert Hayes, Veronica Koester, Aaron Blaine, Vincent Hoehn, Cody Catt.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial