Database Design and Development: Collaborate with project managers, developers, UI/UX designers, and data analysts to architect and refine databases essential for application functionality. Play a pivotal role in designing systems that support robust data analytics and user interface requirements.Cross-Functional Team Coordination: Engage regularly with UI designers, developers, and test engineers to ensure database structures meet the complex needs of business applications. Efficiently negotiate meeting schedules to accommodate diverse time zones and team availabilities.Communication and Remote Collaboration: Utilize Google Space for dynamic communication with team members, ensuring continuous progress and immediate support when challenges arise. Contribute actively to team meetings by preparing agendas and documenting outcomes, facilitating effective asynchronous work across different geographic locations.Quality Assurance and Testing: Work closely with test engineers to execute thorough database testing, ensuring reliability and performance meet design specifications and user expectations.

•Business Intelligence Development: Engineered a SQL database and devised Tableau dashboards that tracked client metrics, reducing report generation time by 30%.•Advanced AI Marketing Analytics: Implemented GPT-4 for enhanced data analysis, optimized data pipelines with Python and SQL, providing clients with insightful market trends that informed major campaign strategies.•Interactive Chatbot Innovation: Designed a user-friendly, OpenAI-powered chatbot on AWS, which became a key tool for client market analysis, increasing user engagement by 20%.

•Cost-Saving Data Analysis: Analyzed 600,000+ entries of map data using ODPS (SQL), identifying optimization opportunities that suggested a potential 10% cost reduction in logistics.•Operational Data Integration: Collected and integrated high-frequency modification data of roads andintersections presented operational insights to the business through the data analysis platform fbi (SQL based) and enhanced operational workflows and supported data-driven decision-making.

•IPO Market Research: Executed in-depth industry research and analyzed prospectus data to pinpoint potential listings for the Shenzhen Stock Exchange IPO, enhancing the listing selection accuracy by 15%.•Database Quality Improvement: Expanded the global industry database, enriched company profiles, and heightened data quality, resulting in a 20% increase in data retrieval efficiency for comparative analysis.•Data Integrity Project: Collaborated with the Shenzhen Stock Exchange, utilizing Excel and Python to audit and correct data discrepancies, bolstering the financial data's accuracy.

•Processed and analyzed 30k pieces of data with Excel to obtain information on equipment utilization and electricity saving, rendered corresponding solutions to realize cost-decreasing and benefit increasing•Assisted quality control in analyzing 3.56k customer complaints data, categorized problems in complaint handling, and proposed analytics-based suggestions for improvement