Yongjun Xie Email & Phone Number

加拿大多伦多地区

In my role at the company, I led the development of internal ERP modules. We used a tech stack with C#, MS SQL Server, and MVC. We used Azure's DevOps CI/CD pipelines for deployment. We used Git for managing code together.Projects I led include:1. 𝑨𝒖𝒕𝒐𝒎𝒂𝒕𝒆𝒅 𝑷𝒓𝒆𝒔𝒔𝒖𝒓𝒆 𝑻𝒆𝒔𝒕𝒊𝒏𝒈:🎆 Developed Python scripts to collect Pressure test results from machines,parsing data on nearly 100 metrics and storing it in a local MySQL database.🎆 Implemented automated daily data transfer from the local database to acloud-based RDS, facilitating online report viewing for management.🎆 Utilized third-party APIs to generate visually enhanced reports, increasingefficiency by 200% compared to manual methods and enhancing reportreadability. 2. 𝑺𝒂𝒍𝒆𝒔 𝑺𝒆𝒏𝒕𝒊𝒎𝒆𝒏𝒕 𝑾𝒆𝒃 𝑺𝒄𝒓𝒂𝒑𝒆𝒓:🎆 Employed Python's Selenium to crawl data from Amazon and competitors'products, collecting parameters for analysis.🎆 Utilized dataframes for data aggregation and analysis, streamlining theprocess to near-zero cost compared to previous manual efforts, which took 2-3days.3. 𝑺𝒂𝒍𝒆𝒔 𝑭𝒐𝒓𝒆𝒄𝒂𝒔𝒕𝒊𝒏𝒈 𝑨𝒏𝒂𝒍𝒚𝒔𝒊𝒔 𝑺𝒚𝒔𝒕𝒆𝒎:🎆 Gathered data from various indicators related to sales, procurement,production, and shipping.🎆 Implemented weighted calculations to generate analysis reports, utilizingadvanced SQL Server features like stored procedures and views to optimizecomputational efficiency.🎆 Utilized C# MVC architecture for the web interface, providing seamlessinteraction for users.🎆 Reduced data administrator workload significantly, with reports thatpreviously took a week to generate now completed in less than an hour. Thequality and timeliness of reports have also improved, enabling daily reportingand enhancing decision-making agility.These projects show my skill in backend development, database management, and project leadership. They improved operations and decision-making at the organization.

Shanghai, China

Develop an internal claim system. Distributors could fill out the form to claimthe sale schedule, and customer information, so that Henkel staff (sales orchannel teams) could approve or refuse their claims. All the processes wereorganized by a work-flow management system which managed privileges androles🎆 Distributors could study knowledge of Henkel products by video or pdf andcould inquire about their studying process. All the video and pdf files werehosted by object storage services in cloudy and sped up by CDN technology.🎆 After the system went live and subsequent training for distributors, theirunderstanding of company policies and products increased by 80%. This growth can be attributed to the system providing a more organized knowledgestructure and implementing certain incentive mechanisms compared toprevious document sharing methods.🎆 Additionally, the efficiency of approval personnel improved by 100% due tothe transition from email correspondence and attachment-based documentsubmission to utilizing the system for these tasks. Previously, manual creationof Excel files and archiving were necessary, whereas now everything can beeasily managed within the system, streamlining the process significantly.

Shanghai, China

In my role at the company, I primarily handle software backend developmentand engage in communication with stakeholders. I collaborate with cross-functional teams, ensuring alignment with business needs by structuringrequirements and proposing optimal solutions based on my experience. Istrive to deliver projects within appropriate time and cost constraints whilemaintaining flexibility and scalability.Internally, I participate in the design of REST APIs, relational databases(MySQL, Microsoft SQL Server), and MVC frameworks. I maintain effectivecommunication with design and testing teams and occasionally contribute tofrontend development using HTML5, CSS, JavaScript, etc., especially duringresource constraints.Key project experiences include:🎆 Development of an e-commerce platform, where I've been responsiblefor backend design and development, API development and design. Theplatform has been stable for 8 years, with an annual transaction volume ofapproximately 100 million RMB.🎆 Website based on WordPress, involving the setup of basic frameworks usingplugins and themes, followed by customization using WordPress hooks tomeet client requirements. The process, from setup to deployment on EC2cloud servers, typically takes about one month.🎆 Development based on IoT, where I led initial research on serialcommunication protocols and interface encapsulation. I implemented MQTTsubscription distribution protocol for data exchange, with Redis as a databuffer, ensuring stable transmission of hundreds of commands per second.This experience has honed my skills in backend development, projectmanagement, and effective communication, contributing to successful projectoutcomes.

Certificate, Full Stack .Net Cloud Developer

This program is designed to provide participants with the advanced concepts, skills, and knowledge required to work as Software.

Information Technology