Hien Ferber Email & Phone Number

San Francisco, California, United States

San Francisco, California, United States

San Francisco Bay Area

• Manage 4 Salesforce instances and support 60+ users. Duties include automation configuration, reports/dashboards creation, custom fields & objects setup, data quality review, user provisioning, etc.
• Worked as the Salesforce consultant for San Francisco's largest Head Start provider (Wu Yee Children's Services)
• Automated cleaning & formatting of 40,000 data fields for California Academy of Science using Python & advanced Excel.
• Evaluated customer profitability for an advertising agency using SQL, resulting in customer pricing adjustments
• Conducted plant mortality studies & improved data quality by recommending validation measures to the Director of San Francisco Botanical Garden
• Analyzed 70,000 sales transactions to identify customers’ buying patterns for inventory planning at San Francisco Conservatory of Flowers

Vietnam

• Assigned branch's most important and challenging global enterprise clients for ongoing project management: handled daily disbursements, payments, trade finance activities, overdue collections,etc.;
• Supported 2 large enterprise clients' credit on-boarding process: loan documents vetting,regulatory/legal filings assurance, collateral documentation perfection, covenants compliancemonitoring, etc.;
• Created Excel based system to monitor at-risk loans for special case customers, successfully tracked full repayment of 200 delinquent loans;
• Enhanced efficiency in manual spreadsheet maintenance using advanced Excel features
• Achieved 0 defects in 2 major audits for all assigned portfolios.

Singapore

• Wrote 60% of QA acceptance test cases for 2 major system releases and 50+ minor releases of internal commercial banking system;
• Conducted 30 monthly system training classes, averaging 10 users per class;
• Supported 150 topmost revenue-generating commercial banking relationship managers of internal lending system.

Singapore

• Assisted with senior management's decisions on major M&A transactions by conducting market studies, industry studies and bench-marking analysis;
• Reported on OCBC's overseas investments' performance - prepared profitability reports and translated board meetings' minutes from Vietnamese to English.
• Assisted in the development of presentations to Division Head and Board of Directors;
• Compiled news updates for the CEO and Board of Directors on the banking industry in SouthEast Asia.