Manager Financial
Resume:
John K. Hrenko
Tampa, Florida 33647
813-***-**** – ********@*****.***
Profile
A highly driven IT professional with a proven track record of success through leadership and building relationships. Expert in management relations and product transformation by implementing GL and reporting conversions. Strength in identifying problems and implementing solutions such as choosing the right reporting options for the enterprise. Ability to work in a fast-paced environment with great time management skills by continuing to exceed and meet deadlines. Positive and energetic individual with the proven ability and commitment to succeed in a highly competitive environment, while exhibiting a team building mentality. Proficiencies in SAP GUI and FIORI, BOBJ, WEBI and Microsoft Analysis for Office and Oracle OBIEE+ reporting tools.
Professional Experience
Brighthouse Financial, Tampa, FL July 2016 to Dec 2020
IT Director – Application Technology Support August 2017- Present
Coordinated and led all weekly cutover and transitional upgrade meetings regarding financial modules allowing Brighthouse Financial to incrementally upgrade systems because of production issues or end-user enhancements and new app tiles
Oversaw and managed a group of 3 employees and 46 AMS consultants in SAP financial support and development allowing Brighthouse Financial to get off the MetLife TSA using PeopleSoft creating a savings of $1.5 million per month
Supported over 400 users of SAP GL, BPC, FSCD subledger and reporting through security, troubleshooting and developing solutions for customers allowing the financial community to do proper analytics
Selected and created curriculum, for Microsoft Analysis for Office, and trained the financial community of over 300 users providing first-ever reporting platform for SAP financial
Led project team that identified and remediated financial reporting gaps between PeopleSoft GL and SAP GL while organizing planning across the enterprise to identify scope for enhancements to target state GL reporting
Prioritized the objectives and user reporting requirements into a high-level strategic plan that was used to construct customized reporting cubes built as the basis for all reporting
Created the curriculum and led the technical training team for Financial Support during production implementation of new SAP General Ledger functionality to 250+ users allowing the GL parallel process to start earlier than expected
Customized compliance for entire SAP GL team by creating controls and processes between PeopleSoft and SAP and between SAP and subledgers
Worked with SOX, internal and external audit teams to ensure that data governance is aligned with industry standards while maintaining all regulatory controls for SAP GL, FSCD and BPC
Manager of Technology Liaisons July 2016- August 2017
Provided reporting guidance in the decision to choose SAP over Oracle for all accounting systems allowing Brighthouse Financial to separate from MetLife months earlier than expected
Managed a group of the project team to convert all PeopleSoft chartfields into SAP code block for business units, accounts, profit and cost centers and the mapping tables supporting the transformation
Performed and documented testing and walkthroughs of all reporting tools used for SAP by creating and executing test scripts and adjusting specifications allowing the users to get their cubes over two weeks early
Rationalized over 1,200 standardized reports from MetLife and identified less than 60 reports allowing Brighthouse Financial to streamline reporting
Created temporary controls for internal audit to support the reconciliation between PeopleSoft and SAP while Brighthouse Financial was running parallel accounting systems allowing the accounting to stay in-sync
Evaluated internal controls and processes for internal and external audit and provided data-driven recommendations through positive process changes
John K. Hrenko Page 2
MetLife Financial, Tampa, FL July 1999 to July 2016
Manager - Reporting May 2003- July 2016
Managed a group of 11 employees and consultants supporting over 1,200 financial users in the United States and overseas on PeopleSoft and Oracle business suite of reporting tools condensing all reporting onto one platform allowing MetLife to simplify their tool suite
Centralized the development, testing, implementation and maintenance of 1,800+ reports worldwide into one group of developers located in offices in the US, Europe and the Pacific Rim reducing the overall operating budget
Gathered and documented reporting requirements and specifications from individual financial users as well as countries being implemented onto the PeopleSoft platform from their individual accounting platforms
Executed the analysis, testing and reconciliation for all reports being converted into Oracle OBIEE reports from Actuate
Led 3 conversions and upgrades of reports and reporting tools over a 12-year period from OBIEE version to newer versions where chartfields would consistently change
Senior Financial Consultant – Special Projects August 1999 – May 2003
Selected for the Y2K and Millennium to PeopleSoft projects within MetLife to control risk over implementation period
Aided in the creation of all reporting trees and hierarchies which were used as the foundation of all financial reporting
Created all PeopleSoft queries and Actuate reports built for the financial community which was the introduction into do-it-yourself basis reporting
Created PeopleSoft chartfields used for reporting and the general ledger which built the basis for financial reporting
Senior Financial Consultant – STAT Reporting July 1999 – August 1999
Produced Yellow Book reporting for the STAT group thus allowing MetLife to file their earnings within the time frames set forth by the NAIC and other regulatory agencies
Consultant – Separate Accounts November 1998 – July 1999
Supported account reconciliations and reporting on all separate accounts managed by MetLife that totaled in the billions
Salomon Brothers, Tampa, FL April 1993- August 1998
Manager – Securities Lending
Managed a team of 7 employees for both domestic and international securities lending that included a domestic portfolio of over $2B and an international portfolio of $1.2B
Performed securities lending trading on the Salomon Brothers trading floor for US based operations
Supported the US, London and Hong Kong trading desks clearing billions of dollars of trades per day on stock exchanges worldwide while reconciling customer and cash accounts allowing books to balance and stocks to be accurately valued
Maintained relationships with US based commercial and investment banks
Co-created in-house trading system for foreign trades thus allowing Salomon to save $400,000 per month
Education/Professional Memberships/Proficiencies
University of South Florida:
Bachelor of Science – Economics and Criminal Justice
Professional Certifications:
CSM – Certified Scrum Master
CSPO – Certified Scrum Product Owner
PMP – Project Management Professional – will test in Q2 2021 – Member of PMI (Project Management Institute)
Computer Skills:
SAP GL GUI and FIORI, Analysis for Office, BOBJ and WEBI – Oracle: OBIEE+, BI Publisher, PeopleSoft Query and Essbase – Microsoft Office Suite including Excel, Word, PowerPoint and Access
Contact this candidate