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
undefinedTimeline
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
Similar Profiles
Vivek GawariVivek Gawari
Expert Software Engineer at Altera Digital Health (a part of Harris Computer now, previously known as Allscripts)Expert Software Engineer at Altera Digital Health (a part of Harris Computer now, previously known as Allscripts)
Anthony DsouzaAnthony Dsouza
Senior Specialist-Team Lead at FIS (SunGard)Senior Specialist-Team Lead at FIS (SunGard)
Avery Gladue-AugerAvery Gladue-Auger
Babysitting at -Babysitting at -
David ValentaDavid Valenta
Meat/Seafood Clerk at Jewel / OscoMeat/Seafood Clerk at Jewel / Osco
Terry PinkasTerry Pinkas
Warehouse Supervisor at EchoStarWarehouse Supervisor at EchoStar