Esther Tang Email & Phone Number

Des Moines, Iowa

Des Moines, Iowa

Ames, Iowa

• Extracted, transformed, and loaded datasets with over 1 million records using SQL or R for queries and data analysis
• Generated statistical models (negative binomial regression) for the development of safety performance functions for Iowa roadways and intersections in R
• Utilized Highway Safety Manual predictive methods to predict future crashes for Iowa roadways and intersections in R
• Performed data validation and metadata maintenance to ensure consistency and accuracy… Show more
• Performed data validation and metadata maintenance to ensure consistency and accuracy between different datasets
• Designed Potential Crash Reduction calculators for 29 categories of Iowa roadways using Excel VBA

Kuala Lumpur, Malaysia

• Performed credit risk analysis and writing in-depth reports on assigned portfolio of corporate clients
• Interpreted financial analysis results and conducted liquidity analysis, stress testing, and cashflow projections
• Reviewed and updated risk ratings of clients based on internal company rating models
• Identified, escalated, mitigated, and resolved clients’ financial conduct and compliance matters
• Provided recommendations to senior management based on clients’ financial… Show more
• Provided recommendations to senior management based on clients’ financial performance, conduct, and credit limit utilization

Kuala Lumpur, Malaysia

• Completed rotations with Consumer Banking, Branch Operations, and Corporate Banking departments
• Performed market research on potential customers, competitors, and several industries
• Designed and conducted surveys and questionnaires for the collection of data on target market
• Analyzed and interpreted data collected and proposed recommendations to relevant stakeholders
• Created pitchbooks and developed marketing campaign for corporate banking products
• Achieved… Show more

Des Moines, Iowa

• Achieved highest personal quality score of 100% in May, September, October and November 2017
• Practiced the ideas of Lean methodology in daily workflow and operational processes to ensure quality and efficiency
• Led daily team huddles and weekly root cause problem solving sessions
• Utilized Tableau to analyze data trends and patterns for root cause problem solving sessions
• Underwrote auto, home and umbrella new business and endorsements based on company guidelines and… Show more
• Underwrote auto, home and umbrella new business and endorsements based on company guidelines and state regulations

Des Moines, Iowa

• Reviewed claims for individual risks and determining chargeability based on company and state guidelines
• Underwrote new business, renewals and endorsements using company tools and systems to analyze individual risks
• Communicated underwriting decisions to agents and providing rationale for decisions through phone calls and emails
• Responded to agents’ insurance inquiries based on contracts, company and state guidelines
• Researched information from multiple company… Show more
• Researched information from multiple company platforms to determine risk acceptability for policy changes

Des Moines, Iowa

• Planned tutorials and supported learning activities alongside the Chinese language professor
• Provided assistance with writing, listening and speaking skills
• Evaluated assignments and online discussion board posts

Des Moines, Iowa

• Handled moderately complex phone calls from customers about insurance services and products
• Made alterations to policy, managed policy and billing questions, received payments and provided documentation required
• Completed and processed all necessary forms submitted by policyholders
• Proposed to customers solutions which were aligned with company and state guidelines
• Quoted policy rate changes through internal business systems for policyholders
• Provided performance… Show more

Master Of Science - Ms, Information Systems With Business Analytics Certificate

Coursework completed: Intro to Management Information Systems E-Commerce Systems Engineering (ASP.Net, PHP, SQL, HTML, XML) Data Mining in.

Bachelor Of Science In Business Administration, Finance And Information Systems

Activities and Societies: Drake University Chinese Students and Scholars Association, Drake University Malaysian Student Association.

Edexcel General Certificate Of Education Advanced Level

Activities and Societies: MCKL Christian Fellowship, Japanese Club • Studied Economics, Accounting, Mathematics and Further Mathematics •.