Risk Management Department - Credit Portfolio Reporting* Contribute regulatory check visuals to team presentations* Prepare the bank’s asset Quality Numbers for the Federal Reserve Bank* Submit regulatory ratings that is mapped from internal ratings * Developed a query to automate collection of problem assets* Developed desk procedures to serve as reference for colleagues* Automated report formatting of working copy to a final version for regulatory submission.

End to End Reporting• Manage internal customer and facility grading check reconciliation by teaming with IT and head office stakeholders to develop a prototype system report using Cognos Report Studio• Reduced regulatory risk by utilizing an analytical approach, resolving reporting discrepancies, and providing a summary mismatch productQA testing• Mitigated reporting risk and optimized data integrity by leveraging production files to ensure the accuracy of reporting using real-time transaction data from the data warehouse system• Reduced processing time by 25% and increased accuracy by satisfying a regulatory requirement by developing a detailed checking on grading process of data management to verify data before publishing formula structureDocumentation Processes• Drafting two reference manuals and documented formulas for recovery and reference from additional data feeds as part of Capital Analysis and Review regulatory requirements, providing proper links to source material• Created two training manuals for use as a reference to support the repair of corrupted formulas used in monthly reporting of customer and credit loan ratings to facilitate use by other professionalsRequirements Gathering• Provided a previously unavailable credit gradings report by teaming with Risk Management SMEs to understand the process for identifying credit application details on supporting guarantees and collateral for loans• Used an analytical approach to provide a business requirements document with class diagrams and flow to integrate the Loan and Credit Application System to facilitate management reportingProcess Improvements• Captured time savings of 25% by using an analytical review of mapping data to production warehouses to compile a complete set of loan transactions, and subsequently tested reporting capabilities• Reduced processing time 75% by analyzing, synthesizing, and extracting data from two separate systems (on and off-shore)