Worked as a Sr.BI Production Analyst in RSI – server CPG companies around the world and provide intelligent solutions to them to improve their profitability.  Ensure the retailer’s completeness and correctness of data during the daily ETL process.  Provide the on-shelf availability alerting report and predictive analytics to customer to cut down repeated manual work, avoid potential loss, improve efficiency and help customers to gain profit. Develop web crawlers with… Show more Worked as a Sr.BI Production Analyst in RSI – server CPG companies around the world and provide intelligent solutions to them to improve their profitability.  Ensure the retailer’s completeness and correctness of data during the daily ETL process.  Provide the on-shelf availability alerting report and predictive analytics to customer to cut down repeated manual work, avoid potential loss, improve efficiency and help customers to gain profit. Develop web crawlers with Python to gather the data from our internal ticket system ZenDesk and then do analysis to assess the tickets by elements such as response rate, owners’ workload and resolution rate, which subsequently produces a series of feasible advices for ticket dispatching and prioritizing.  Focus on the migration project recently - migrate our system from the old platform to the new. Execute the newly developed programs for data migration; compare the outcomes with the business requirement documents; in case of unexpected result happening, debug the programs using setting up breakpoint, log analysis and consulting with developers; define the standard operating process on new service for team’s further reference. Show less

Worked in Microsoft Shanghai Campus as an Office 365 support engineer, providing Technical support with SLA to the APGC customers. Focus on Exchange Online.  Technique required: Exchange Online Server, Exchange Server hybrid deployment, Active Directory, PowerShell, DireSync Tool.  Solve IT Admins’ enquiries about the functions of Microsoft products, such as the permission control of Office 365, DNS configuration, Exchange mail flow setup, Outlook rules configuration, as well… Show more Worked in Microsoft Shanghai Campus as an Office 365 support engineer, providing Technical support with SLA to the APGC customers. Focus on Exchange Online.  Technique required: Exchange Online Server, Exchange Server hybrid deployment, Active Directory, PowerShell, DireSync Tool.  Solve IT Admins’ enquiries about the functions of Microsoft products, such as the permission control of Office 365, DNS configuration, Exchange mail flow setup, Outlook rules configuration, as well as the External Communication or Federation, etc.  When problem happens, troubleshoot the issue via remote control. If the issue is proved to be related to the Office 365 service degradation or bugs, I need to escalate the issue to the Production Group for solving from backend.  In Sep/2014, I was prompted as a Technical Lead to manage my own team (train my team members, share knowledge among team to improve each other both technical skills and communication skills, supervise team-level performance); also cooperate with other O365 teams as well as global teams. Show less