Jian An Chiang Email & Phone Number

Toronto, Ontario, Canada

• Effectively mapped and bucketed general ledger hierarchical expense data into custom categories using a recursive algorithm• Eliminated monthly work effort by designing an admin page where admin users can operate and run commands to pull in financial data• Introduced bulk ingestion to eliminate duplicate users and aggregate different profiles allowing ingestion for larger data sets.• Designed a notifications system to effectively onboard new notifications and allow users to modify notification parameters• Tech Stack: Angular/JQuery/Javascript, Python/Django, Postgres SQL

Toronto, Ontario, Canada

• Built an insurance policy web application (Core Java, Oracle SQL, HTML/CSS/Javascript, J2EE)• Contracted to provide developer support to bank client's Hadoop environment. • Monitored the Cloudera Hadoop cluster and resolved any environmental failures and memory issues. • Facilitated data flow in and out of the cluster using Podium Platform, Sqoop and Tibco. • Deployed Talend, Autosys, and Oozie jobs and addressed any execution failures promptly. • Ensured that data reports are delivered as per schedule and resolved critical issues with SLA of <1 day• Developed Bash, HiveQL, and MySQL scripts to generate comprehensive data load reports and perform catchup loads saving 30 mins of work each day.• Support Operations Team Lead overseeing operations in Personal/Business Banking

Ridgetown, Ontario, Canada

• Improved pesticide and mycotoxin detection methods in water, soil, flowers, grain, insects, and dust• Drafted new pesticide extraction protocols for honey and beeswax • Reduced experimental testing time by 32% by installing a revolutionary analytical LCMS/MS system (SCIEX QTRAP 6500+) for high sensitivity, speed, and accuracy in toxin analyte detection • Utilized Excel VBA to automate calculations for toxins of interest in several substances.

Suzhou, Jiangsu, China

• Designed nanocatalysts to improve efficiency in water oxidation for efficient solar water splitting• Conducted MATLAB computations to narrow down 100+ materials to a few candidates• Reduced cost by 10x by introducing nickel-based catalysts instead of platinum exceeding performance standards

Toronto, Ontario, Canada

• Researched potential markets through the use of questionnaires, focus groups and surveys. • Produced and coordinated distribution of marketing materials (i.e. promotional videos, leaflets, e-newsletters, posters and DVDs.) • Established SQL Server database and migrated the customer/agents database from Excel.