Dennis Honda Email & Phone Number

Los Angeles Metropolitan Area

Manage data related aspect of the line of business, including data sourcing, custom reporting, developing processes and reporting, and generating/delivering management reporting. Key systems used are Tableau, MS Access, Moody’s CreditLens, SharePoint, Accudraw (construction monitoring application), Salesforce and others specific to the Real Estate Banking Space. • Created a project intake process, improving requirements gathering, and setting up a defined process from design to delivery.

Greater Los Angeles Area

Manage a team of DRM and ETL/Informatica developers (4 onshore, 3 offshore) as a core team supporting many downstream applications such as Hyperion Planning, Hyperion Financial Management, PeopleSoft, OFSAA, OBIEE and QRM.Responsible for the successful transition to a new vendor to support Hyperion Planning and DRM. Includes transition plans, key milestones, escalations and communication.Key resource to bridge FP&A and Technology as it relates to Enhancements/Projects, Troubleshooting, necessary business processes and translations, and testing.

Greater Los Angeles Area

Primary functional administrator of Hyperion Planning and Reporting and related systems. Hierarchy management via Oracle Data Relationship Manager (DRM). Managed system preparation and processes as it relates to actuals loads, forecast/budget cycles, CCAR/Stress, Enhancements (requirements, testing and implementation), and communications to our user-base. Complete data familiarity with multiple financial applications; thorough understanding of the attributes, interactions, and differences between each data source (dimensional structure, data and cube characteristics, Data flow through the data source). Manage a staff of three vice presidents.• Key member of Hyperion Planning Implementation Team during development and successful launch in February 2013. System has over 800 Scripts/Rules, 212 input forms and 266 variables used to support our forecasting requirements.• Took ownership of Hyperion Planning and DRM since launch of system. Developed several base hierarchies since implementation such as FRY14a Schedule COA hierarchies, Branch Entity, COA, GLA Hierarchies and Legal Entity.• Wrote requirements, developed base hierarchy, created member formulas, developed BSO Cube forms, and created SmartView validation/reporting templates for FRY14a Schedules.

Pasadena, Ca

Analyze, validate and test property tax files received either from a vendor or directly from the county. Write logical, sequential and clearly written instructions to programmers to convert source files into Lender Processing formatted files. Review programmer output to ensure accuracy and sign off for publishing when satisfied. Review conversion instructions from offshore analysts to validate and approve for programming.Independently developed a process flow chart and wrote desk procedures for major processes related to position.

Manage a staff of analysts as well as continuing to be responsible for certain functions of my prior position such as budget plan, delinquency modeling, and developing key reporting company-wide (Executive, Capital Markets, Finance, Servicing, etc.).Key member of the transition team charged with financial reconciliation/billing, data warehouse development/integrity, staffing input, logistics, employee and furniture moves, ad-hoc analyses.Successfully migrated all databases and reporting off of prior data sources and onto the new enterprise data warehouse, automating numerous reports and enacting a necessary data integrity process to clean up existing data and provide secondary testing to newly boarded loans.Manage the data collection efforts across all divisions for the three top servicer rating agencies. One of the primary contacts for RCS/Aames as it relates to the three rating agencies.

Responsible for all facets of the Division’s Income Statement, from monitoring individual line items to researching and facilitating the correction of errors. Month-to-month and budget-versus actual-variance analyses. Cost of servicing, compensation, bonus programs and capacity analyses. Regularly interface with all levels of management. Maintain, enhance and develop MS Access databases. Extract data using SQL, ESSBASE, Business Objects, Oracle Reports and Hyperion Reports. Coordinate, stratify and report the divisional monthly reporting package that indicates our performance by area and as a whole.Perform the data analyses of quarterly securitizations providing the support for over $1 billion in securitized loans. Regular interaction with investment banks in terms of data and population. Manage the integrity of pooled data. Assisted in the coordination of due diligence efforts for whole loan sales and securitizations. Created and managed loan data and prepay validation databases, automatically flagging loans for manual file review.Responsible for the Annual Budget for the National Loan Servicing Division, consisting of 6 primary departments and, at its peak, 200 personnel. Process covered all income and expense items such as servicing fees, communications, production and personnel.Developed an MS Access database to manage our securitization process. Monitors population, pool makeup and data errors/fixes.Responsible for creating the monthly data file(s) for LoanPerformance, a third-party vendor providing peer comparison reporting. Primary user of their RiskModel product which is a projecting tool for loan prepayments/defaults/losses and cash flows.