TA for DAMG6210 Data Management and Database Design

• Led a team of 9 in developing a mobile application that tracks hate crime incidents and fosters volunteer activities, promoting inclusivity and unity• Developed robust APIs to handle CRUD operations for user-generated data, achieving an average API response time of less than 100 milliseconds• Resolved data query challenges with GCP database, enabling seamless data transmission• Enhanced code efficiency by implementing React Redux for the application

• Orchestrated data warehouse schema design, defined optimized data structures for storage and analyses• Streamlined and automated operation workflow by implementing Excel functions and macros scripts, reduced settlement processing time by 70%• Designed data collection solution to extract operational data, ensured data integrity through data cleaning with SQL and Python, contributed to the accurate tracking of profit and loss• Conducted ad-hoc data analysis and effectively communicated results to management through dashboards