Achievement-oriented financial professional with diversified financial instittion experience in corporate finance, risk based pricing, FTP, financial and data analysis, TM1, and SQL. Strong database skills, excellent organzational, analytical, and proven ability to lead projects, employees, and departments. Extensive experience in analysing and mining data from different sources using SQL, Essbase, and TM1.
| Excel Access DBII SQL, SQL Server | QRM Visual Basic TM1 Hyperion Essbase |
- Managed monthly funds transfer pricing process and worked with methodology manager in developing methodologies for internal performance measurement.
- Facilitated end user research requests into variances and anomalies with the FTP processing and managed restatements for methodology changes
- Worked with business partners to test the FTP system for model validation purposes, line of business partners to create ad-hoc pricing scenarios, and treasury department in testing new QRM account builds.
- Collaberated in the development of a balancing process for QRM using SQL BIDS packages which reduced the balancing procedure from one day to 10 minutes.
- Enhanced the existing RAIQ model for CML by integrating the models with SQL integration of minimums, FTP data, and market data.
- Developed the RAIQ model for CIB by working with business partners to identify unique needs and intergrations with the ORION system to provide historical relationship information and pro-forma analysis.
- Led quarterly training of the RAIQ model for new commercial relationship managers. Provided daily support for RAIQ and pricing questions.
- Advised CML and W&IM LOBS regarding changes in FTP and market pricing and worked to adjust pricing model minimums accordingly.Â
- Redesigned the loan fee pricing reports used in incentives for the relationship managers. The previous reports took a week to compile and they are currently processed in three hours.
- Worked with IPPMS and cost managers to manipulate data sets to create analysis if cost and profitability of multiple origination channels within consumer/retail lobs.
- Managed the model validation process for the RAIQ models and FTP calculators.
- Designed and coded the FTP calculator by reverse engineering the QRM methodology for FTP purposes. This design incorporated the bootstrap approach to the swap curve and the monotonic cubic spline interpolation of the swap curve.
-
Designed and maintained multiple TM1 Models for controllers, performance measurement, and management accounting.
-
Maintained interfaces to various relational stores for analysis and reporting.
-
Designed a restatement engine withing TM1 that would run outside of IPPMS due to system constraints. The TM1 solution took one restatement from running in a week's time to 30 seconds.
-
Collaberated on a solution for restatments and instrument availability that allowed IPPMS results to be avaiable a week week early.
-
Lead SunTrust technical resource in building out an instrument level profitability and reporting environment which allowed insight into pricing and profitability on the instrument level which had not existed previously. This involved working with consultants and solutioning a TM1/Essbase/SQL model.
- Managed a team of TM1 analysts
- Worked in the financial reporting department. Responsible for regulatory reporting, financial statements and accounting analyst.
By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy
Disclaimer
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score
could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
resume Strength
- Personalization
- Target Job
Resume Overview
School Attended
- Georgia State University
- Auburn University
Job Titles Held:
- Risk Based Pricing and FTP Manager
- Risk Based Pricing Manager
- TM1 Manager
- Accountant
Degrees
- MBA
- Bachelor of Science
By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy
Similar Resume
View All
