John Liber
Information Delivery Analyst at State of Wisconsin Investment Board- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Power Platform Functional Consultant Associate (Exam PL-200)
MicrosoftJul, 2023- Nov, 2024 -
Microsoft 365 Fundamentals (Exam MS-900)
MicrosoftSep, 2020- Nov, 2024 -
Analyzing and Visualizing Data with Power BI (Exam 70-778)
MicrosoftFeb, 2020- Nov, 2024 -
Azure Fundamentals (Exam AZ-900)
MicrosoftSep, 2019- Nov, 2024 -
Implementing Microsoft Azure Infrastructure Solutions (Exam 70-533)
MicrosoftDec, 2018- Nov, 2024 -
Microsoft Certified Systems Engineer (MCSE): Messaging on Windows Server 2003
MicrosoftOct, 2006- Nov, 2024 -
Microsoft Certified Systems Engineer (MCSE): Windows Server 2003
MicrosoftJan, 2004- Nov, 2024 -
Microsoft Certified Systems Engineer (MCSE): Windows 2000
MicrosoftFeb, 2001- Nov, 2024 -
Microsoft Certified Systems Engineer (MCSE): Windows NT 4.0
MicrosoftOct, 1998- Nov, 2024
Experience
-
State of Wisconsin Investment Board
-
United States
-
Investment Management
-
100 - 200 Employee
-
Information Delivery Analyst
-
Oct 2020 - Present
Collaborate with all divisions within the agency to develop new reports using Microsoft Power BI that provide business insights & analysis. The role typically requires elements of each of the following areas, delivered using a lightweight version of Scrum: 1. Business Analysis – Interface with the requesting team to understand the purpose of the report, help prioritize features to be developed based on feasibility/value/effort, and estimate a timeline for delivery. 2. Data Sourcing – Interface with the Data Management teams to map data requirements to existing sources or create new data sources. Where possible, implement ETL or business logic in the upstream data source rather than within the report. If necessary, perform ETL in Power Query or Dataflows as a proof of concept or interim solution. Primary data sources include many different databases housed on Snowflake, Oracle, and Microsoft SQL. These sources are occasionally supplemented with other SharePoint or file-based data. 3. Report Development – Use Power BI to develop the report using Power Query or DAX. Utilize Power BI best practices when developing reports aiming for simplicity, reuse, and extensibility. After approximately 2 weeks of development & testing, perform a Sprint Review with the agency representatives and release the newly developed features. 4. Automation – Leverage Microsoft Power Automate to automate various repeatable processes including user notifications, trigger-based report refreshes, or other regular report updates. I started the role during the pandemic, so this has been primarily a work-from-home position (2020-2022). Show less
-
-
-
Microsoft
-
United States
-
Software Development
-
700 & Above Employee
-
Customer Success Account Manager
-
Jan 2018 - Oct 2020
Account Manager for Premier customers in the Financial Services & Insurance vertical. Serving as the primary customer-facing support role, responsible for the overall health, profitability, and growth of a set of customers who utilize a portfolio of Microsoft services. Help those customers successfully operate, consume, and realize the value of Microsoft products and the Microsoft cloud (including Azure, Office 365, Dynamics 365, Intune, and Enterprise Mobility + Security) by focusing on the following areas: • Develop service delivery plans based on customers’ business and IT objectives. Facilitate the delivery of these services and regularly review progress with key stakeholders and sponsors. • Articulate the case for change and help customers evolve their IT maturity in order to meet the needs of their business more effectively and efficiently. Recommend services that aid the customer in managing change and accelerating adoption. • Create a strategic support relationship with key customer stakeholders, both within IT and in the business groups, to enable quality delivery aligned to their business outcomes. • Manage and escalate complex customer support issues in partnership with Incident Managers, Critical Situation Managers, and other escalation points from teams throughout Microsoft. This was a nearly 100% work-from-home position with only occasional on-site visits with my customers or Microsoft teammates. Show less
-
-
-
State of Wisconsin Investment Board
-
United States
-
Investment Management
-
100 - 200 Employee
-
Investment Information Analyst
-
Jul 2014 - Dec 2017
As a member of the Asset & Risk Allocation team, support the Front Office investment teams (Public Equity, Fixed Income, and Multi-Asset) in a wide variety of areas: • Provide subject matter expertise in multiple investment systems including FactSet, MSCI RiskManager, and Barclays POINT • Build new reports using native systems, Tableau, or Excel to provide the investment teams with insights & analysis of exposure, risk, and performance • Work directly with the business to gather requirements and select the best technology solutions • Assist with investment modeling and analysis using Excel with investment system integration (e.g. FactSet Excel Add-on) • Scripting (R, PowerShell, VBA) to automate investment processes, investment strategy, and reporting • Ensure data quality by assisting with data reconciliation and issue resolution (T-SQL queries, Tableau, data feed troubleshooting) Show less
-
-
-
Artisan Partners
-
United States
-
Financial Services
-
400 - 500 Employee
-
Platform Engineer
-
Apr 2008 - Jul 2014
Primary responsibilities: • Windows Server, Active Directory, and VMware vSphere engineering and support • Messaging engineering and support including Exchange Server, SMTP gateways, and spam filtering • Infrastructure and process automation using workflow/orchestration tools, PowerShell, VBScript, and VB.NET • Platform Monitoring using Nimsoft and custom development • HP server and EMC SAN administration • ServiceNow IT Service Management • Varonis Data Governance Suite for permission reporting, access management, and change audit Example Projects: • Exchange 2003 to 2010 transition (design, deployment, migration) • PowerShell development for user provisioning, mailbox provisioning (Exchange Management Shell), and server VM deployment (PowerCLI) • ServiceNow workflows, process automation, and Service Catalog • Varonis Data Governance suite deployment • VDI pilot: VMware View with AppSense and Symantec Endpoint Virtualization Show less
-
-
-
Baird
-
United States
-
Financial Services
-
700 & Above Employee
-
Server Analyst (Team Lead)
-
Feb 2005 - Apr 2008
• Windows Server and Active Directory engineering and support • Messaging engineering and support including Exchange Server, SMTP gateways, and spam filtering • Platform Monitoring using Microsoft Operation Manager 2005 and custom development • Development of hundreds of VBScripts for automation, reporting, and auditing • Windows server OS deployment and refresh • Windows Server and Active Directory engineering and support • Messaging engineering and support including Exchange Server, SMTP gateways, and spam filtering • Platform Monitoring using Microsoft Operation Manager 2005 and custom development • Development of hundreds of VBScripts for automation, reporting, and auditing • Windows server OS deployment and refresh
-
-
-
Berbee
-
United States
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Consultant for the Microsoft Practice
-
Mar 2003 - Feb 2005
Typical Engagement Topics: Active Directory design and Windows Server & Exchange Server engineering Typical Engagement Topics: Active Directory design and Windows Server & Exchange Server engineering
-
-
-
Microsoft
-
United States
-
Software Development
-
700 & Above Employee
-
Associate Consultant for Microsoft Consulting Services
-
Jan 2000 - Mar 2003
Typical Engagement Topics: Active Directory design and Windows Server & Exchange Server engineering Typical Engagement Topics: Active Directory design and Windows Server & Exchange Server engineering
-
-
Education
-
Marquette University
MBA, Finance Specialization -
University of Wisconsin-Madison
Bachelor of Science (B.S.), Computer Science