Commercial Credit / Portfolio Management

C&I Underwriter

• Created 3 extensive database Entity Relationship Diagrams on Microsoft Visio• Procedural documentation on SQL database designs and troubleshoot solutions in 3 database

• Utilized project management Excel database to update and track action items of over 10 members from 2 project workflows • Excel troubleshooting and formatting (PivotTable, VLOOKUP) on cost estimation tools

• Reviewed risk overview and mitigation report on bank’s quarterly internal risk utilizing key compliance standards of risk profiles (Credit, Market, Interest Rate, Liquidity)• Applied macroeconomic analysis by using industry, economic, and real estate market statistics (Vacancy Rate, Rent Growth) towards credit underwriting summaries of Bank’s commercial real estate loans portfolio.

• Conducted base statistical analysis to highlight trends and characteristics of health care fraud in Excel• Consolidation and visualization of key data on 10 preliminary reports for efficient policy evaluation

• Data management of our inventory supply-chain logistics for 150 containers per day to enable efficient warehousing (Data Entry, Documents and Contracts Management)• Analyzed 30 customer accounts for inventory management to optimize their just-in-time purchasing schedule using a forecasting model on Excel (Review and Modeling)• Created a report on 3 potential regional competitors using import/export data from U.S Customs database