• Collect and analyze data related to Six Sigma and U.S. patents by Excel and VBA.• Help professors with research on “Biotechnology startups and their financing” and “Relations between Six Sigma and faster project completion times”.

• Research on market trends in insurance industries, identifying the potential insurance market. • Construct data base by doing data cleaning, data consolidating and data standardizing.• Provide quantitative delivery prediction by estimating universal state premium for target products.• Communicate with underwriters and develop rating methodology in spreadsheet for General Liability and Liquor Liability.

• Build VBA macro-based spreadsheet to automate monthly Credit and Collateral Risk Management Report, reducing project run time by 90%.• Conducted and monitored the process of updating Lendable Collateral Values by credit scores.• Assist with report generation and maintenance for Credit and Collateral department.

• Identified and fixed computer software and hardware problems for faculty and students.• Coordinated with colleagues on computer problems.• Spoke to faculty and students over phone to identify and interpret computer questions.