AT&T acquired AppNexus and rebranded it as Xandr
? Provided visibility and high-level business insights (global infrastructure cost and operation status) to the leadership team by building TechOps business dashboard using PowerBI
? Compiled and analyzed a large dataset, drew ER Diagram, and extracted the current capacity data using SQL; Reviewed and analyzed current capacity status, minimum capacity request, and capacity changes to predict future capacity needs
? Maintained and updated the web-based TechOps global capacity dashboard on a regular basis, used SQL and Python script to gather and assemble data from the database into weekly dashboard reports
? Built Statistic model (linear regression) to measure the key application performance benchmark with R Square
• Led weekly capacity planning meetings with 16 stakeholders from cross-functional teams; prioritized planning and execution of servers’ flow for capacity optimization