John Zea
Business Intelligence Manager
Downers Grove,IL
Summary
Specialties: Power BI DAX Dimensional Modeling Business Intelligence SQL C# Treasury Finance Accounting Reporting Crystal Reports Project Management SDLC
Overview
33
33
years of professional experience
10
10
years of post-secondary education
Work History
Director - Global Reporting and Interface Solutions
SunGard - now part of FIS
01.2018 - Current
- Managing teams handling Business Intelligence, Interfacing solutions specializing in Corporate Treasury with the Integrity Treasury Workstation application.
Team Lead, Enterprise Solutions
SunGard - now part of FIS
08.2006 - 01.2018
- Managing a team with the Enterprise Solutions team at SunGard
- Providing custom solutions for Corporate Treasury departments
- Specializing in Business Intelligence solutions utilizing SQL, Crystal Reports, SQL Server Reporting Services, Logi AdHoc and .Net
- Review client requirements, provide estimates, create custom reporting solutions, mentor team members.
Program Manager
Microsoft
10.2003 - 07.2006
- Program Manager for Microsoft IT managing projects for Microsoft's global Treasury department
- Worked on implementation of SAP Treasury Module
- Bank Account Administration custom application to manage Bank Account management using Microsoft technologies married with third party workflow engine
- Multiple smaller initiatives in the Treasury department space.
Programmer
Allstate
05.2003 - 10.2003
- Developed a custom enterprise wide streaming application.
Technical Consultant
Integrity Treasury Solutions
02.1998 - 10.2003
- Developed custom solutions for the Treasury Workstation platform
- With with Visual Basic, ASP.Net, C#, SQL.
Technical Support
Newedge
01.1995 - 02.1998
- Worked on multiple projects related to the GMI Futures software system
- Helped to initially develop the FIMACIS online trading application.
Sales Assistant
Dean Witter Futures
09.1993 - 01.1995
- Back office for Futures clearing firm.
Back Office Clerk
Tokai Bank
12.1990 - 09.1993
- Back office clerk for Treasury Department
- Settling FX Spot & Forward deals
- Cash Management activities
- Wires, drawdowns and maintaining Bank Balances.
Education
Computer Science, Accounting -
DePaul University
01.1989 - 05.1994
undefined
Lake Park
01.1983 - 05.1987
Skills
SDLC
SQL
Crystal Reports
C#
Accounting
NET
Business Intelligence
SQL Server
Requirements Analysis
FX
Timeline
Director - Global Reporting and Interface Solutions
SunGard - now part of FIS
01.2018 - Current
Team Lead, Enterprise Solutions
SunGard - now part of FIS
08.2006 - 01.2018
Program Manager
Microsoft
10.2003 - 07.2006
Programmer
Allstate
05.2003 - 10.2003
Technical Consultant
Integrity Treasury Solutions
02.1998 - 10.2003
Technical Support
Newedge
01.1995 - 02.1998
Sales Assistant
Dean Witter Futures
09.1993 - 01.1995
Back Office Clerk
Tokai Bank
12.1990 - 09.1993
Computer Science, Accounting -
DePaul University
01.1989 - 05.1994
undefined
Lake Park
01.1983 - 05.1987