Alvin Jiang Email & Phone Number

Tauranga, New Zealand

• Develop ETL/ELT data integration system, internal sales management system and related tools using C#/Angular/Bootstrap in Windows and CentOS environment, provide automotive parts data to internal application and B2B website daily/weekly.• Design/maintain automotive parts database, SQL Server/ MongoDB.• Analyze sales data, develop internal data dashboard, provide analytics insights.• Integrate external Web API with internal applications.• Assist to set up and maintain company’s IT systems and hardware throughout NZ.

• Develop function and script to process automatic testing for data of Bing Map according to the requirements, using VS 2015/SQL Server 2014/Git. Dealing with average 10G size DB files in each version.• Fix issues which found in test, maintain and ensure the data integrity before next data migration and ingest process in other teams. • Data mining work to find out and fix invalid and inaccurate geographic data of all continents, using SQL batch script and Cosmos DB query; • Trouble shooting and fix online issue in Bing Map, using TFS and Microsoft internal bug management tools. Dealing with about 30 cases every day.

Jinan, Shandong, China

Duties:• Design and develop the company’s internal core information system; Sever 17 branch companies and 1 headquarter, thousands of staffs, including work flow(dozens of flows per day), website CMS, contract information management(hundreds contracts per month), finical information analysis, FTP server, internal knowledge base system. Using C#/ASP.NET/SQL Server/jQuery Open sources framework;• Implement system in China Telecom internal cloud. Choose suitable infrastructure, security group to ensure the stability of system.• Worked as technical support for China Telecom Outsourcing Call Center. Provide technical solution and service to external clients, such as China Food and Drug Complaint Reporting Hotline, Haier Service Hotline, etc.

Tianjin Suburb, China

• Develop Volvo Local Dealers System which used in Volvo Truck Car Market all over the world, according to the requirements from clients, under Agile/scrum, using C#/ASP.NET, Entity Framework, MVC, TFS;• Communicate with end clients to collect, confirm requirements and provide sound technical solutions;(e.g. clients from Malaysia, Russia, India, Argentina)• Data migration when roll out the new market in different countries using SQL patch files in SQL Server 2008; processing 3-5 G size DB in every data migration; • Identify the improvement opportunity and optimize the performance of system. I found the reason of low speed in front page, which is caused by duplicate logic when access database. After fixing the front page waiting time was reduce about 20%, evaluated by test team.• Develop several internal tools to improve development efficiency, such as data migration connection editor, data comparison tool.

Beijing City, China

• Responsible for develop, test and maintain data analysis sub system of SKYLINK system which provides both-way communication services between ground and airplane, using C#/Winfom/Windows service/MSMQ/Oracle 9. The system provides data link service for all main airline company in China.• Responsible for develop, test and implement Network Operation Control (NOC) Support System which provide passenger information management service for Air China company, using C#/ASP.NET/Oracle 9;• Design and develop core data analysis system of Aircraft Meteorological Data Relay (AMDAR) which provides real-time meteorological message analysis to participate the international meteorological information open exchange. • Write development documents under CMM3 requirements;

Jinan, Shandong, China

• Write and debug the sub module by using the C# in the Visual Studio 2003 development environment, such as automatic build web site system;• Maintain the database table structure and table fields;• Test and maintain the software;• Write the documents on the basis of development specification;• Solve computer problems and provide technical support for end users;

Bachelor Of Engineering (Be), Computer Science And Technology

Diploma, Detection Technology And Application

Activities and Societies: Minister of P.E Department of Student Union