Roxy Bao
About Roxy Bao
Roxy Bao is a Database/ETL Developer at CIBC with extensive experience in ETL processes, data mining, and database management.
Company
Roxy Bao is currently employed at CIBC as a Database/ETL Developer. This tenure began in 2016 and continues to present day in Toronto. Previously, Roxy worked at A2A Web Solution Inc. in Markham, Ontario as a Database Specialist & ETL Developer for 11 months in 2015-2016. Additionally, Roxy has worked briefly at ChamShan Temple and RioMotion Corp in 2014 and held a position at TBC IT Partner as an Application Developer from 2011 to 2014 in Markham, Ontario.
Title
Roxy Bao holds the title of Database/ETL Developer. Her experience in this role extends from her current position at CIBC, where she has been working since 2016, through previous engagements where she specialized in similar capacities.
Education and Expertise
Roxy Bao completed her Master's degree in Environmental Engineering Technology/Environmental Technology at the University of Guelph from 2009 to 2012. Prior to that, she earned her Bachelor of Science (B.S.) in Environmental Science and Engineering from Fudan University between 2002 and 2006. She also pursued an Advanced Database Administrator Diploma in Data Modeling/Warehousing and Database Administration at the Canadian Business College from 2015 to 2016. Her expertise includes deploying ETL processes using SSIS and Informatica, data mining with SSAS, and creating reports using SSRS and Crystal Reports.
Background
Roxy Bao has a diverse professional background in Database and ETL Development, having worked across various organizations in Ontario. She began her career at TBC IT Partner as an Application Developer from 2011 to 2014 and subsequently took on multiple short-term roles between 2014 and 2016 before joining CIBC. Her technical proficiency spans across SQL/T-SQL/PLSQL query coding, debugging, and tuning as well as operating systems such as Windows Server, Linux, and UNIX.
Skills and Technical Proficiency
Roxy Bao is highly skilled in SQL/T-SQL/PLSQL query coding, debugging, and tuning. She possesses strong capabilities in ensuring database High Availability (HA), utilizing technologies such as Oracle RAC and Windows Server Failover Clustering. Roxy is adept at database backup and recovery using RMAN and Database Duplication, and she demonstrates proficiency in deploying ETL processes with SSIS and Informatica, and data mining with SSAS. Additionally, she is well-versed in creating advanced reports using SSRS and Crystal Reports, and has substantial experience with operating systems including Windows Server, Linux, and UNIX.