Brian Grogan
Waterford,MI
Summary
Programming Languages / (Years Experience) Power Canvas/Power Automate/Power Automate DeskTop Excel VBA Programming (20), Microsoft Access (20) PL/SQL (2)
Highly-motivated employee with desire to take on new challenges. Strong work ethic, adaptability, and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills.
Overview
33
33
years of professional experience
Work History
Comerica Bank
05.2023 - Current
- Automated over 1 million annual keystrokes using Robotics Process Automation (RPA), saving approximately 1,000 hours of labor annually (equivalent to half an FTE).
- Declaration Of Loss Power Canvas Application for lost Cashiers Checks streamlines workflows (using Power Automate). Role based access support separation of duties which ensures all accounting of DOL checks are followed.
- Built Microsoft Access databases to automate various processes, saving 2,000 hours of labor.
Senior Database Developer
Fidelity National Information Systems
01.2019 - 05.2023
- Wrote conversion programs to compare Market Value, Units, Cost from Comerica’s Trust Accounting System and compared that to the New Trust Accounting system.
- Rewrote Microsoft Access databases to work with the new Trust Accounting system. Class Action Lockbox, Advisor, Monthly Volumes, Missing Cost Basis, Trade Reversals.
Trust Operations Technology Manager
Comerica Bank
Detroit, MI
01.2010 - 03.2019
- Develop Microsoft Access database applications to support all Trust Operations including Custody Free, Corporate Actions, Control and Reconcilement, Data Input, Fund Accounting, Trade Processing, Capital Actions, Global, Pension, Institutional Trust and Fee processing.
Lead Programmer Analyst
Ford Motor Company
04.1993 - 12.2010
- Automated Cycle Planning, Lead programmer analyst.
- Visual Basic Application coding in Excel for generating sophisticated and complicated reports. Maintained application code in Visual Basic 6.0.and SQL. Oracle 8i, Visual Basic 6.0, Microsoft Source Save, Install Shield 6.03, and Access 2000, SQL Plus.
- (Contract employee, CIBER Inc.)
Education
AA - Data Processing
Oakland Community College
01.1990
Skills
- Robotics Process Automation
- Power Canvas Applications
- Power Automate
- Microsoft Access databases
- SQL programming
Summary Of Qualifications - Programming Languages
20, 20, 2
Timeline
Comerica Bank
05.2023 - Current
Senior Database Developer
Fidelity National Information Systems
01.2019 - 05.2023
Trust Operations Technology Manager
Comerica Bank
01.2010 - 03.2019
Lead Programmer Analyst
Ford Motor Company
04.1993 - 12.2010
AA - Data Processing
Oakland Community College