May 2020 – Nov 2020 - Backend Developer, EPAM SystemsCustomer: Retail & Distribution – P & GProject: SKII SPA application support P&G company offline store sales, orders, inventory, audit, consumers, the end user are P&G internal Counter and Sales Manager, include China, Japan, Hongkong, Taiwan markets.Team Size: PM: 1, SA: 1, DBA: 1, Backend: 2, QA: 2Project Role: Key DeveloperTasks performed:• Responsibility:• 1. Setup databases(Oracle, SQLServer and PostgreSQL) and migration tool (SSMA, ESF Data Migration Toolkit) in local, analysis data schema mapping issues in different DB, tried asynchronizing data from Oracle to SQLServer/PostgreSQL.• 2. As a backend developer, finished code refactor for DB provider layer independently, finally the access layer supported 3 types of DB. Helped PM estimate data access layer changes, effort with detail data matrix.• 3. Implemented data layer access layer codes, had unit test and integration test on WPF application, 3 features(Login, TODO Items, Schedule Event) were delivered successfully.• 4. Created codes effort calculation mini-program by using PowerShell scripts, could generate codes difference rate report by compare multiple markets, strongly supported PM on the PoC presentation.• 5. Facing SPA application performance challenge problem, resolved top cost SQL by analyzing backend business and data access layer logic, especially on Linq optimization.Environment:• Oracle, SQLServer, PostgreSQL, SQLite• Azure, Git, SSMA, Oracle SQL Developer, SQLiteStudio, ESF Database Migration Toolkit, Orafce, LinqPad, EntityFramework Profiler, Windows PowerShell• .Net Core, WPF, Data Migration, SQL, Linq, Oracle.EntityFrameworkCore

Customer: Credit-SussieProject: Alpha web based application used for automation of coverage workflow based on data of clients, trade history, current orders, news, research and market actions Create evergreen task lists that provide meaningful, effective reasons to contact customers and reasons for them to tradeTeam Size: Frontend: 2, Backend: 4, PM: 1Project Role: backend developerTasks performed:• 1. As a backend developer, responsible for Credit-Suisse Alpha project backend requirements implementation, include break-fix, enhancement, new features.• 2. Follow TDD and CICD• 3. Main skills in Alpha:- Use Linq and script to optimize Mongo query- Create data index in redis, improve common data query- Create unit-test, integration-test, acc-test support CI by using SpecFlow(BDD) and Nunit.- Use Teamcity and Octopus support CD- Implement Excel VBA codes to support team generate Mongo DB migration script data automatically• Other Contributions:Shared a session of “How to use Excel assist development as a tool” in .NET Community, in order to show a good demo, I developed following functions:1. Generate JSON/XML/SQL script data by internal excel functions, it works as a common tool by using data template.2. Generate all kinds of random data automatically, such as string, integer, decimal, date, datetime type of data.3. Developed a Resful API calling template as a common tool by using VBA, end user is able to send multiple GET/POST/PUT request according to table data.4. Developed a useful SPLIT functions by using VBA, it support split all kinds of array, and change it to required formated data.Environment:• MongoDB, Redis, Sysbase• VS2017, Git, Jira, NUnit, Swagger, SpecFlow, AutoFac, TeamCity, Octopus• .NET, TDD, CICD, VBA

Customer: Retail & Distribution - WatsonProject: Watsons WTCCN Automation project POC for Finance department.Team Size: Dev Team:3, Team Leader: 1, BA: 1, PM:1Project Role: Workfusion RPA Developer.Tasks performed:• 1.Key developer in Development team for RPA automation implementation contribution, joined serveral automation programs, such as Wechat auto-reply message, Uber auto request order, HR CV template management App.• 2.Responsible for RPA web base automation process and RPA desktop automation process implementation, delivered all Watsons frontend automation programs independently.• 3. Analyzed Watson internal system on Excel, extracted VBA business codes into RPA platform, made RPA frond end work closely with back end.• 4.Responsble for new technical research which been used in development team, such as OCR, baidu & google lang api, UiPath activities, other RPA platform open sources.• 5.Collebrate with team leader with schedule design and code quality controlEnvironment:• PostgreSQL• Workfusion SPA Studio,Workfusion RPA Express,UiPath,BluePrism,AutoIt, Excel Macro• RPA

Customer: HuaweiProject: Huawei MatebookTeam Size: App software team 10, QA team 3Project Role: Tech LeaderTasks performed:• 1. MateBookAssistant- Finished MateBook Service UWP Demo app, supported product owner choose the right UI technical skills.- MateBook service requirement analyze, investigated Huawei existed android service, list all feasible functionality, supported material for product strategy.- PSI requirement analyzation, list all security risk, department interface which need to communicate, data transfer interface, it helped designer get detail information.- Deisned and developed MateBookAssistant application independently, finished localization solution fro more 54 languages and 100+ countries.• 3. MateTrans - MateTrans is a tool to share and transfer files between MateBook and Phone, it used WiFi, Bluetooth, MTP Protocol, Message Stack, PC server App and Phone as client App. This App project fell into problem during the end of delivery lifecycle, as the good performance in MateBookAssistant App, I was nominated as owner of MateTrans App, took over all codes from Supplier, defined transition plan, leaded 4 members take over the codes, defined sprint plan, fixed Arabic and Hebrew UI 180 revert problem, localization words display problem, UI issue and previous bugs.- Got Delivery Star in Huawei Tablet PDU department, the performance level is excellent level in Q2 of 2016.Environment:• VS2015, Git, infosight, DTS• .NET WPF, UWP, COM

Customer: TiffanyProject Role: Tech LeaderTasks performed:WOT(World Of Tiffany) 2012/12 ~ 2013/6• 1. Built a CN development team• 2. Communicated with Onshore architect and tech leader, reviewed and adjusted DB design, clarified requirement and analyze Design feasibility.• 3. Responsible for Detail design document, defined CMS and Frontend Interface, let all team members follow.• 4. Developed most of the core User Controls in CMS, finished all Frontend site independently.• 5. Delivery global site http://www.tiffany.com/WorldOfTiffanyTiffany.com maintenance 2013/6 ~ 2014/1• 1. Delivered big enhancement WOT Bridal successfully.• 2. Leaded all SEO works, delivered SiteMapGenerator application with high quality successfully.• 3. Fixed more than 30 global sites defects.• 4. Team size grow to 8.Compass Case 2014/1 ~ 2015/4• 1. Supported PM define component development cadence, make whole team work efficiently, all drops can match schedule.• 2. Designed webservice, auto-case generation component, DB SP standard, webAPI code standard, UI localization framework, UI validation samples, etc.• 3. Reviewed developers' codes, dad code refactor during development cycle, improved much to promote code quality.• 4. Defined deployment process, owner of deployment and release announcement.Compass EOM 2015/4 ~ 2016/1• 1. as PM role, lead all team members on EOM UI works.• 2. Had Lesson learn frequently, propose improvement solutions to GEO nearly each month.• 3. Fixed more than 50 defects by myself.• 4. Care about team members, to control the sepration rate, promoted 5 team members in 2015. max team size is 10.• 5. EOM 1.2 go-live in 2016/9.Environment:• SQLServer, Redis, MongoDB• VS2010, SQLServer, BugTracker• .NET MVC 4, webAPI, WCF, Jquery, Kendo UI, SSRS, SQLServer, Store Procesure, Triggler, SQL optimization, IBM Watson Explore

Customer: Nertherland GovernmentProject: Gate & TAQATeam Size: Dev team: 5 team member DB team: 2 QA team: 1Project Role: Biztalk DeveloperTasks performed:• 1. Both Gate and TAQA are the Gas energy company of Netherlands, they have multiple Gas proxies and suppliers, several systems(GTS, ETRM, OASIS, Customer Nomtool, Finance System, Nimvua-T, Energy Componnets, ect..) and different GAS request interface exist in Gas assignment management.• 2. IBM supports development work, change request and maintenance for more than 20+ servers in Test, Acc, PROD, DR environment, include Oracle DB servers, Biztalk Application server, Message SQLServer, BO Server, External Application servers• 3. After implementing Biztalk solution, more than 100 types of message kept in communication among GATE & TAQA integraion systems every day, the request processing perfomance was improved from 2 hours to less than 1 minute, less manual fault, cut down 10+ operation labor expenditure, most important, Gas agencies can get gas assignment on time, it highly supports Energy Management, the people in Europe can use Gas conveniently.• 4. Customers satisfied with my support in 2012, they trusted my capability and attitude in Biztalk domain very much, during the TAQA Integration test cycle, I worked very hard, some days worked even whole night.Environment:• Oracle, SQLServer• VS2008, SQLServer, JBoss, MS Active Domain, Nagios, Linux, IIS• Biztalk, JBoss, Webservice, SQLServer Agent Job, SSiS, DB Disaster Recovery.

Customer: GMProject: GM ABMTeam Size: Sustain team: 9 team membersProject Role: Sustain LeaderTasks performed:• Project Brief: ABM Applications is a team which supports applications solution for GM, includes GM Assets, Datamart, Global Lease management and Product Oder.• Responsibility & Achievement:• Responsible for CR tasks, follow delivery process strictly.• Supported 2 critical jobs, never happened emergent issue. Responsible for CR tasks, got a formal praise letter from Onshore PM in Jan 2011.• Built a ABM sustain team for GM China in 2010, 7 members took over much Monitor and Change Package validation work from Brazil team, GM ABM moved its support center offshore to China, 9 members in sustain at last, and many further positions would be gotten in 2011 as Onshore PM and senior manager trust us very much, they assigned 15 minutes to us to introduce our China team in the Global GM Town Hall. I was responbile for helping SIT manager lead this sustain team, weekly sustain meeting, issue solution, training program, common task assignment.Environment:• SQLServer, Access• VS 2008, SQLServer, Access, Startteam, Sharepoint• VBA, VB, ASP, ASP.NET, SSiS, DTS, Agent Job

Customer: Continental AirlinesProject: Flight Of Operation - Aircraft MovementTeam Size: dev team: 6 team members in Aircraft Movement, 5 team members in Food Service, 7 team members in Flight Planning QA team: 6 team memberProject Role: .net developerTasks performed:• Project Brief: Both AM(Aircraft Movement) and FS(FoodService) serves for Continental, parts of Transportation team. Skills mainly focus on SOA AppService and Silverlight. Business includes Aircraft and Flights controlling and Food Schedule Service for Continental.• Responsibility & Achievement:• 1. Personal Development Work: Develop AppService and GUI, solve bugs in MO cycle. Finished all tasks on time, built a good steady and reusable security framework for AM GUI, helped AM as one of the best team in Transportation.• 2. Contribution Works: Built a GUI Security framework for AM and FsReportService, it was implemented in many other FOT teams. Played a mentor role of junior developers, and help to build a strong AM team, it is the best team in FOT.• 3. Sustain internal code review system by using Excel Macro, change the review business logic according to organization process, fully supported entire FOT development team.Environment:• SQLServer• VS2008, SOA Factory, TFS• ASP.NET, WCF, WSDL ,Silverlight, WWF, CrystalReport, VBA

Responsibility & Achievement:• 1.MES WebConfig- Responsbile for Basical Data, Report programs, and finish Security module independently- Developed SelectBox UserControl, DynamicRemovingControl, used XML to export and import Security data.- WebConfig became the basic framework in MES department.• 2.All Parts Tracking System- At beginning, I practiced in product line, responsible for computer management( place, name, IP, access authority) , device alarming, program updating, user survey, FAQ, exception, operation documents, operators training.- Mastered this system’s all workflow, receive requirement from customer to enhance previous functions.- At the end of this project, I took over all web site project independently, it never happened any critical exception during that time, customers were very satisfy with my support.• 3.RMA(Returning product Management and Analyzing)- As a senior developer, I designed the code framework and offer a sample code to other developers so that they could follow my style.- Supported PM design program interface so that we could develop programs easily and quickly, I also assigned development task to team members.- Developed the most difficult programs and supported other new developers so that processing could always follow schedule.