Jiahao Pan Email & Phone Number

Mckinney, Texas, United States

● Working in the Information Technology Department, designing, developing, and maintaining RESTful APIs using PHP. The developed API is used to get orders, process orders, and provide them to partners to create orders. These APIs improve the efficiency of data transmission and ensure data consistency and security between systems.● Developing and maintaining EDI integration, developed files such as 850, 856, etc for trading partners to process orders, invoice synchronization, and logistics tracking. Set Cron timed job on Linux to achieve automation. Significantly reduced the error rate of manual data entry and improved the level of business automation.● Developing and maintaining all web development work. Developed the official website using PHP, HTML, and CSS. Developed frontend and backend work for e-commerce web pages on GitHub using PHP, HTML, and CSS.● Providing software technical support for APIs, EDIs, and existing company management system. Processing requirements and bug tickets submitted by customers and various departments. With automation and system optimization, the company saved 6.42% of operating costs. And achieved 20% improvement in operating efficiency.

● Working in the Information Technology Service Management Reporting Team, managing data warehouse(Kafka, AmazonRedshift) and providing dashboard reports to the manager.● Writing, maintaining, and enhancing automated test scripts to verify the functionality, performance, and reliability ofsoftware applications. Using programming language: Java. Testing frameworks and tools: Selenium, TestNG, JUnit,Cucumber, and Eclipse.● Collaborating with developers, product managers, and quality assurance (QA) engineers to plan testing strategies for newfeatures or bug fixes. Reviewed requirements, identified test scenarios, and determined which tests should be automatedand which require manual testing.● Using Jira to Identify, report, and manage bugs. Working with developers to analyze and debug issues. Worked with otherteam members to ensure the quality and maintainability of automated test code. They provide feedback on codingstandards, test coverage, and potential improvements.● Automate the process of integrating code changes, building applications, running tests, and deploying software withJenkins.● Integrating with MicroStrategy dashboard, generating real-time data issue reports for interactive visualization andanalysis. Organize and manage test cases, track test execution, and generate test reports with Xray(Jira)

Richardson, Texas, United States

- Upgraded and developed the company’s website search function using JavaScript & HTML - Resolved company’s software technical issues on the daily basis

Master Of Science - Ms, Computer Science

Bachelor'S Degree, Computer Science