Bobby Chau Email & Phone Number

Irvine, California, United States

Lake Forest, California, United States

Lake Forest, California, United States

Aliso Viejo

• Carrington MortgageProvide Reporting, Analytics and Solutions for all departments within Investor Reporting departments. Built and maintained Reports utilizing a custom Excel Application to support business needs.
• Developed/Maintained Report for all departments within Investor Reporting utilizing a custom Excel Forms (User based front end) and SQL Backend
• Ability to provide users with speedy results utilizing XML as a bridge between Excel VBA and SQL.
• Developed a Workflow Management System (VBA/SQL) to track Internal Investor Reporting KPIs
• Automate manual reports resulting in a productivity gain of 60% +
• Query optimization / Indexing / Columnstore Indexing

Tustin, CA

• Ditech Financial, LLCProvide Reporting and Analytics for the financial and servicing departments. Built and maintained workflow Excel Applications to support the business reconciling over $270 Million in Claims.
• Developed/Maintained Reports for the following departments: Loss Analysis, Payment Recon, Claims, and Invoicing
• Maintained Excel Workflow Applications via VBA/SQLo Claims Process and Trackingo Maintenance Templates for User Updates, Uploads, and Deleteso Employee Hierarchy
• Run/Maintained ETL Packages
• Query optimization / Indexing / Columnstore Indexing
• Proficient in T-SQL (Stored Procedures, Functions, Triggers, Queries) utilizing MS SQL Server 2016

Irvine, CA

• Provided Reporting and Analytics for the entire company (Senior Staff, Management, Sales, etc.). Built prototypes, data models, forecast and projections, and insights based on data findings to help gain revenue (from.
• Logical Data Model and data warehouse for Real Estate Agent Store (Agent Subscriptions) o Classification of New, Recurring, Reinstated, or Cancelled agentsAt Product Level, Agent Product Level, and Agent Level o.
• Developed and Implemented Micro Strategy Reporting Process to the team. POC selected with intent and effectiveness to drive revenue.
• Developed Loan Modification NPV (Net Present Value) Visual Basic Calculator in Excel based on HAMP (Home Affordable Mortgage Program) requirements. The calculator was made available to clients via customer portal. Upon.
• Query optimization and data standardization. Year over year, as data evolved, query optimization and data standardization every few months saves time and reduce errors.
• Developed a KPI dashboard to provide executive management visibility to Workstation Timelines, Trends, and Metrics to allow for more effective decision making.

Irvine, CA

• Sourced and implemented Upside Software (contract versioning software) resulting in the digitization of over 1.2 million paper contacts. Cost savings of over $2M per year in reduced waste, storage space, and efficiency.
• Developed a Pharmacy Network workflow application in MS Access (VBA) to digitize and scrub over 500K pharmacy records with collision detection and audit trail
• Primary administrator for the Upside Software System to include:o created and provided reports to management on timeline and execution of contractso managed the release of different software versionso Added additional.

Irvine, CA

• Coordinated and managed a team of 2 onshore and 3 offshore (India – Speridian) staff. Onshore provided internal reporting and offshore was utilized for development of application calculators.
• Built a business intelligence ASP web portal that gave clients manageability of their portfolio of over $3 million in assets.
• Built a real time workflow ASP application managing business artifacts, portfolio, files/package tracking.
• Suggested and implemented Management Reporting Platform for Leadership Team in the form of a web-based dashboard (KPIs)
• Automated manual reports resulting in a productivity gain of 25% and reducing error rates by 35%

Costa Mesa, CA

• Formerly: GMAC ResCapPrimary role was to assess current processes and workflows and suggest and implement solutions for optimization.
• Developed Loan Modification NPV (Net Present Value) Calculator in Excel (VBA) based on HAMP (Home Affordable Mortgage Program) requirements. Utilized within the company to help make decisions and saving on cost per loan.
• Built a real time workflow ASP application managing business artifacts, portfolio, files/package tracking.
• Developed Agent Match tool based on geo location to help asset managers quickly assign agents resulting in productivity gain of 15%
• Provided Management Reporting (KPIs)

Irvine, CA

• Formerly: Option One Mortgage Corp (OOMC) and American Home Mortgage Servicing Inc (AHMSI)Managed a reporting team of 10 focused on developing reporting analytics and workflow optimizations for an organization with.
• Developed and maintained an in-house web based reporting dashboard in ASP (VB Script) providing KPIs and drill downs for asset managers to manage their portfolio
• Programmed screen scrapes off old main-frame system utilizing MS Excel (VBA) for additional data not captured in the database
• Created interactive Flash training packages for external users (Agents/Vendors) saving costs on trainers, traveling, and event facility rentals
• Developed an in-house workflow application in ASP (VB Script) for portfolio tracking, files/package tracking for asset managers
• Automated existing reports utilizing SSIS reducing error rates and productivity gain of 50%