Brian Chan Email & Phone Number

Chicago, Illinois, United States

Chicago, Illinois, United States

• Utilized Python and Windows Virtual Machine to automatically run and extract data daily from Oracle PBCS and upload cleaned data to Snowflake for analysts to use for PowerBI dashboard.
• Used Databricks, Power Automate, and Azure Data Factory to activate storage events trigger whenever analysts loaded files to SharePoint and output cleaned data in Snowflake.
• Wrote multiple REST API get requests ranging from government data to third-party data, saving analysts about three hours of manual work.
• Loaded multiple files daily into SharePoint using Graph API, guaranteeing that analysts had data where it needed to be.
• Introduced combined use of Databricks, Azure Functions, Service Bus, and Logic App to streamline and eliminate technical debt to allow for easier logging and monitoring of errors.

Chicago, Illinois, United States

• Used Selenium to automate the extraction of Google Reviews from Chatmeter and utilized Python to clean and aggregate data to send out a Google Score Report of all the properties in LivCor.
• Responsible for aggregating and sending out 3 weekly reports to various people using a combination of RealPage BI, Excel, Python and PBCS providing managers with important KPIs.
• Used Snowflake, Python and Excel to query and create demographics data that was utilized for the BX Board Book.
• Queried the reasons for moving out data from Snowflake and created a PowerBI dashboard that was used to track the reason why tenants are leaving.
• Pulled Marketing Leasing Analytics data from the SFTP, cleaned and loaded them into PBCS and Snowflake to allow analysts to present this data in their PowerBI dashboard for marketing managers to make decisions.
• Maintained Oracle PBCS financial data warehouse, ensuring data was balanced and relevant users had access.

Chicago, IL

• Used combination of Python, AWS, and PL / SQL to query and clean data for bus maintenance department.
• Created Microsoft PowerBI dashboard to track performance of bus maintenance department.
• Used Python, AWS, and Apache Airflow to automate sending of bus and rail incident reports to relevant parties in CTA every morning.
• Built bus door defects report using combination of Python, AWS, PL / SQL, and Microsoft PowerBI.
• Updated and navigated CTA daily flash report tracking previous day system-wide performance of CTA.
• Built budget book posted on CTA website in 2020 using Microsoft Excel and Word.

Columbus, Georgia Area

• Worked with the team to implement a new credit card fraud scoring data model.
• Trained the data model and matured it by using authorization data for the company's credit cards platform.
• Applied the maturations for the past 12 months of historical authorizations to develop the model in the production client environments.
• Performed Machine Learning by using Python, SQL, and Excel to predict spending patterns of customers.
• Used Pandas to wrangle data sets and utilized various Machine Learning algorithms to determine the best algorithm that output the highest accuracy.
• Employed Random Forest for the data sets and was able to get 72% accuracy.

Manila, National Capital Region, Philippines

• Helped to work, grow, and expand the family business.
• Advocated and responsible for building and maintaining the sales invoice software, using Excel.
• Performed data entry and data management to ensure accuracy of data.
• Managed inventory levels by using Excel to determine whether to purchase additional supplies.
• Increased company revenue by personally doing sales and marketing to customers.