• Designed and implemented data source scope down policies, allows customer to customize the data source permission at a more granular level by using Elastic Search, DynamoDB, Amazon IAM, table replication and Amazon STS.• Designed and implemented dashboard and template public APIs, set up a new public API service provides a program interface to manage resources in QuickSight by using EC2, ELB, Amazon IAM.• Designed and implemented billing system, including billing models for standard edition, enterprise edition and reader users by using Amazon SQS, Amazon SNS, DynamoDB and table replication.• Implemented subscription process for amazon directory service and Microsoft Active directory by using Amazon Simple Workflow, DynamoDB and table replication.• Designed and implemented resources search user experiences and public APIs by using Elastic Search, DynamoDB, Amazon lambda functions and Amazon Kinesis.• Implemented data sources permissions such as Amazon S3, Athena. It allows QuickSight to connect customers’ data sources in their AWS account by using Amazon IAM and DynamoDB• Designed and implemented S3 Analytics data source and deep link user experiences by using MVC, cookies and React flux.• Designed and implemented Salesforce and Twitter data sources by using Oauth authentication• Designed and implemented client long polling Restful APIs for scheduled refreshing for data set, fetching data ingestion status and fetching sign up status by using React flux.

Designed and implemented front end public and internal websites as well as challenging back-end server code for the Visual Studio Team Services (VSTS) which has been used by millions of customers.• Designed and implemented the brand new Admin Branch Policy web page for VSTS Pull Request to add different gated code submission policies with pluggable frame using Typescript and CSS.• Designed and implemented the Admin Branch Policy Restful APIs using SQL, C# and Typescript.• Implemented different font stacks for supported languages by checking the culture number from the browser language setting to make the localization more robust using C#, SCSS and Typescript.• Debugged and identified issues with build system and worked with corresponding engineers to fix the issues.• Obtained business requirements from Program Manager to create clean interfaces and intuitive interactions such as redesigning new versioned modern dialogs which can be changed between old version and new one, and remodeling all image icons with font icons using Typescript, CSS and XML.• Designed, implemented and unit tested the Admin Branch Policy and modern dialogs.• Improved the Pull Request web page loading speed by reducing the contents which were required from server and changing the order to draw page elements. Also improved the voting features and comment features in Pull Request using Typescript and CSS.• Won the second prize in Microsoft 2015 Hackathon by creating a “footprint” page in VSTS to display and manage current user’s branch and Pull Request using Typescript and CSS.

Provided a stable and highly test coverage environment for the Version Control Team.• Created and maintained high quality tests to ensure the reliability of Visual Studio Team Services and Team Foundation.• Prepared database queries to generate feature usage report in MS SQL.