https://www.heidelberg.edu/directory/jingyi-suDesign and prepare new/existing course syllabus, materials and assignments for each course, ensuring alignment with the departmental and university learning outcomes and standardsTeach four courses per semester in the areas of computational problem solving, computer programming, spreadsheet modeling, systems development and data-driven decisions, using a variety of instructional methods and technologies to engage students in active… Show more https://www.heidelberg.edu/directory/jingyi-suDesign and prepare new/existing course syllabus, materials and assignments for each course, ensuring alignment with the departmental and university learning outcomes and standardsTeach four courses per semester in the areas of computational problem solving, computer programming, spreadsheet modeling, systems development and data-driven decisions, using a variety of instructional methods and technologies to engage students in active learningEvaluate and grade students’ performance and provide feedback in a timely and constructive mannerConduct research in computer science and data science and publish findings in conferences, contributing to the advancement of knowledge and innovation in the field, collaborate with National Center for Water Quality Research (NCWQR) on data explorationSupport new major and minor Data Analytics in a bachelor of science degreeSupervise and mentor undergraduate students, providing guidance on their academic progress, research projects, career goals and support their higher education applicationsParticipate in departmental and university committees and activities, such as attending faculty development workshops, serving as a member of the Search Committee and Faculty Development Committee, and collaborating with other faculty members on curriculum development and improvementProvide guidance to students/advisees on shaping their career development and planningParticipate in Teach CS Grant Program to support K-12 computer science instruction• Courses Taught: CPS 201: Computational Problem Solving, CPS 202: Intermediate Computer Program, CPS 314: Database Management, CPS 316: Spreadsheet Modeling, CPS 342: Systems Development, GSB 561: Data-Driven Decisions for Managers, MTH 119: Statistics I, MTH 219: Statistics II, HYPE 2113: JobSrch: Resume Writing Computer Science, HYPE 2123: Excel-Data Analysis, AIM101/102: Advise/Inspire Mentoring I&II Show less

Enhancement on Zero-shot/Few-shot Transfer Learning in Reinforcement LearningReinforced Contrastive Graph Neural Network on multi-relational graph anomaly detection tasksAutomated Software Vulnerability DetectionSoftware vulnerability management project with Spectare-Systems, Inc with advisor Dr. Yan WuDesign machine learning algorithms to make priority software vulnerabilities and exposuressuggestions according to user preferenceUse advanced machine learning techniques… Show more Enhancement on Zero-shot/Few-shot Transfer Learning in Reinforcement LearningReinforced Contrastive Graph Neural Network on multi-relational graph anomaly detection tasksAutomated Software Vulnerability DetectionSoftware vulnerability management project with Spectare-Systems, Inc with advisor Dr. Yan WuDesign machine learning algorithms to make priority software vulnerabilities and exposuressuggestions according to user preferenceUse advanced machine learning techniques (NLP for big code) in Python (Tensorflow, Pytorch, Scikit-learn) to fit and optimize statistical regression and classification models and apply machine learning approaches with encoder/decoder, attention module in neural networkPublication: Co-author of Features Selection and Prediction for IoT Attacks in High-Confidence Computing Volume 2, Issue 2, June 2022, 100047 Show less

Support teaching 200+ undergraduate/graduate students for CS core courses: CS4620/5620 Database Management System, CS3080 Operation System, CS2010 Programming FundamentalsPrepare and/or grade lessen material, homework and exam and hold Office hours

Function tasks development and testing in C#:Import pattern pieces from third-party software, automate paired handle point sewing, automate panel position setting

*Onsite contract development role via CCS Global TechHosted joint requirements planning meeting and developed databases following agile methodology in Azure DevOpsExamined and evaluated data structures of the existing database and performed data cleanupsDesigned and implemented procedures as generic partition switching method, data validation and data onboarding in Star schemaMonitored and supported with incidents and job failures with hot fixAutomated database maintenance… Show more *Onsite contract development role via CCS Global TechHosted joint requirements planning meeting and developed databases following agile methodology in Azure DevOpsExamined and evaluated data structures of the existing database and performed data cleanupsDesigned and implemented procedures as generic partition switching method, data validation and data onboarding in Star schemaMonitored and supported with incidents and job failures with hot fixAutomated database maintenance work for Dev/UAT/Prod environments and logged historiesDesigned SSIS packages in VS2019 and automated ETL process execution with SQL agent for production runDesigned and implement data pipelines in Azure Data Factory for on-premise dataSetup scenario and schedule on MantisUI for customer usageBuilt and optimized Tabular model for CaPla, DCCM databasesMonitored and patched flagging local servers, virtual machines with vulnerabilitiesMigrated database objects to new environments and guaranteed the stability of the systemDeveloped PowerBI report/dashboard to monitoring system status and data validation Show less

Advanced development experience at client sites with integration tools such as SSIS, SSRS, Azure Data Factory, Azure Data Lake, Power BI, Tableau; Development experience with SQL Server database and Oracle DB; Working with XML and APIs, and Using Javascript, Python, C#, .Net, or SQL.

*Onsite contract development role via CCS Global TechEvaluated and upgraded 75+ SSIS ETL packages from 2008R2 to 2016 manually in CPS system.Migrated SSIS packages from package deployment model into project deployment model with environments, and project parameter for new configurationExtracted, transformed and loaded data from various sources such as SQL Server, Flat files and Excel filesManaged errors with event handlers, error outputs, and precedence constraints, adapt custom… Show more *Onsite contract development role via CCS Global TechEvaluated and upgraded 75+ SSIS ETL packages from 2008R2 to 2016 manually in CPS system.Migrated SSIS packages from package deployment model into project deployment model with environments, and project parameter for new configurationExtracted, transformed and loaded data from various sources such as SQL Server, Flat files and Excel filesManaged errors with event handlers, error outputs, and precedence constraints, adapt custom loggingsAnalyzed tables, views, stored procedures and indexes in support of various databases and ETL applications.Designed Columnstore indexes on various tables in central data warehouse to enhance SQL read operation.Analyzed dimensional model architecture identifying required modification on dimension and fact tables to improve PHI (Patient health information) report rendering performance.Developed reports and dashboard for Tableau based BI productManaged source code version control on GitHub for GLFHC BI team Show less

Worked on an NSF grant supported project using Boa, a new domain-specific programming language, to automatically infer postconditions by using static analysis and data mining techniques Deployed new releases for Boa to support new specification features for Java Modeling Language (JML) and other behavioral languagesOptimized the Boa compiler and its infrastructure, identified/fixed bugs on GitHubEnhanced technical supports by publishing the Boa handbook on GitHubCo-author of… Show more Worked on an NSF grant supported project using Boa, a new domain-specific programming language, to automatically infer postconditions by using static analysis and data mining techniques Deployed new releases for Boa to support new specification features for Java Modeling Language (JML) and other behavioral languagesOptimized the Boa compiler and its infrastructure, identified/fixed bugs on GitHubEnhanced technical supports by publishing the Boa handbook on GitHubCo-author of Using Consensus to Automatically Infer Post-conditions in International Conference on Software Engineering (ICSE) 2018Worked with a team of four student software developers to design and successfully create a 3D strategy planet simulation game, “S.T.E.L.L.A.”, using Unity3DDesigned and implemented a real-time chat tool, Flyer: IM Chat Tool, in Java and Eclipse, to be used on both LAN and Internet Created Behavioral and Structural UML diagrams in Visio for a library information management system Show less

Provided requirement analysis, design and programming support for the enhancement of Web application Served as a liaison between clients and the development team during the entire SDLC Monitored the development status in MS Project, performed quality assurance and acceptance testingAnalyzed and modified database objects such as stored procedures, User Defined Functions, Triggers and Indexes utilizing T-SQL.Coordinated with Business Analyst for data cleaning and variable… Show more Provided requirement analysis, design and programming support for the enhancement of Web application Served as a liaison between clients and the development team during the entire SDLC Monitored the development status in MS Project, performed quality assurance and acceptance testingAnalyzed and modified database objects such as stored procedures, User Defined Functions, Triggers and Indexes utilizing T-SQL.Coordinated with Business Analyst for data cleaning and variable selection to ensure records in database meaningful and analyzable.Developed Dynamic SQL script with join and filtering logic pulling data from EDW system for analysis purposes.Generated data source with cross-database joins, unions, and calculated in Tableau.Implemented extract in Tableau data source and configured a subscription to deliver Tableau dashboard.Designed complex LOD expression in Tableau to answer complex business question. Show less

Focused on Search Engine Optimization, specifically on improving the performance of the first-level search engine, so.com, which later became to the second popular search engine in China.Wrote user stories, identified and quantified issues, and designed user-friendly layouts for various use casesSentiment analysis and opinion mining using Python to help with classify websites and calculate suggestion engine ranking scoresConsulted users with technical problems and conducted testing… Show more Focused on Search Engine Optimization, specifically on improving the performance of the first-level search engine, so.com, which later became to the second popular search engine in China.Wrote user stories, identified and quantified issues, and designed user-friendly layouts for various use casesSentiment analysis and opinion mining using Python to help with classify websites and calculate suggestion engine ranking scoresConsulted users with technical problems and conducted testing (A/B testing/unit testing), wrote test cases Show less