SUMMARY

• 10 years of software development and test experience with technologies including: C#, SQL Server, Business Intelligence Tools, XML, JSON, PowerShell, Client/Server, WinForm/WPF, ASP.NET, WCF, Windows Service, Office Apps with VSTO and VBA, and REST/SOAP/SSRS/TFS APIs
• Strong programming, debugging, and problem solving skills through code review, .NET Reflector, WinDbg, crash dump, Fiddler, PowerShell debugging, service trace logs, system event logs, SQL profiler, and root cause analysis
• Solid knowledge of CodeSign technologies with public and private keys, HSMs, certificates, and digital signatures, which is the area I have worked in for 5+ years
• Extensive experience in data analysis, visualization and reporting with SQL Server BI tools (mainly SSRS) and Power BI in Excel: Lots of SSRS reports designed and developed with report designer, published on report manager, exported to Excel, enhanced and customized with Power BI to drive decisions
• Extensive exposure to SQL: Creating database, T - SQL, stored procedures, tables, views, triggers, indexes, constraints, and user defined functions
• Experience in Black box, White box, Unit, Integration, Functional, Web, BI, Performance, Capacity, and Scalability testing
• Extensive experience in performance/capacity/stress testing in production for Microsoft product groups’ major builds and their performance analysis reports on system capacity, bottlenecks (e.g. High CPU usage, memory leaks, deadlocks, etc.), scale out for File/Web/App/Signer/CA/SQL servers, optimal number of threads for services, and performance counter analysis
• Strong experience in designing and developing test automation tools and PowerShell automation
• Passionate about technology, quality, customers and an innovation in test
• Passion for learning new things and take on new challenges
• Experience in developing and testing complex and distributed cross-domain systems
• Experience in Production issue support and escalation
• Familiarity with both Agile and Waterfall software development life cycle

TECHNICAL SKILLS

Operating Systems: Windows 8.1/8/7/XP/NT, Windows Server 2012/2008/2003 , Unix/Linux

NET Technologies: C#, VB.NET, ASP.NET/ASP, ADO.NET, T-SQL, WPF/WinForm, WCF, Web/Windows Service, and MSMQ

XML Technologies: XML, XSD/DTD, XSLT/CSS, XSL-FO, XQuery, XPath

Database Systems: SQL Server 2012/2008/2005/2000 , MS-Access, MySQL

Web Servers: Internet Information Server, Apache

Programming Languages: Fortran, C/C++/C#, Java, Swing, OpenGL, T-SQL, VSTO, VBA, Lex/Yacc, and MPI/OpenMP/HPF

Business Intelligence: SQL Server 2010/2008/2005 BIDS

Reporting Tools: SSRS reports, Power BI (Power Query/Pivot/View/Map), and Crystal Report

MS Office Suite: Access Project (ADP), Access (Queries, Forms, Reports, Pages), Word, Excel, Outlook, PowerPoint, Visio

Scripting Languages: PowerShell, JavaScript, VBScript, HTML, CFML, and ActionScript

Applications: Visual Studio 2013/2012/2010/2005/2003/2000 , TFS, VSTS, Product Studio, Source Depot, Dreamweaver/Flash/Fireworks/ColdFusion MX, Acrobat, FrontPage, Photoshop, and NetBeans IDE 3.6

Debuggers: WinDbg, Fiddler, Visual Studio debugger, gdb, dbx, pdbx, and xpdbx

PROFESSIONAL EXPERIENCE

Software Development Engineer in Test

Confidential

Responsibilities:

• Designed, developed and maintained CodeSign automation tools and scripts:
• Performance test platform using PowerShell Remoting (WinRM) that removed manual setup process and enabled users to run a performance/capacity test in one click
• SSRS reports with report designer and T-SQL to analyze the performance metrics for projects and products
• Multi-threaded CodeSign automation tool using C# and WinForms for BVT/Functional/Regression tests, which was designed to share current works with team members by transferring the information in an XML format
• Windows service to check system health by sending jobs into the system and reporting the status of them via SMTP email notification. It’s designed to check all signing technologies in the system based on the configurable values in an XML format: e.g., key technologies (Authenticode and StrongName) every 10 minutes and BVT at 4 am every day. It enables all disciplines to have an early warning of system issues and better address concerns the business may have on the stability of the system
• WPF application to run XVT (EVT/IVT) using PowerShell Remoting in C#. It enables the Engineering team to run commands on a remote machine and verify the environment (both hardware and software) under which an application is subject to run and whether it is installed successfully or not on all servers in Public and Private domains
• TFS work item analysis tool with a GUI. It has been developed with WPF and TFS APIs and used WPF Toolkit for data visualization. It allows users to navigate, retrieve, manage, and analyze work items on the fly through TFS APIs
• Worked on PKI CA onboarding to onboard CodeSign system to PKI system so that all dynamic certificates were provided by PKI to CodeSign
• Worked on decoupling of Signing and Scanning Services to increase the performance significantly in terms of E2E time
• Collected all supported file types for COPS across all CodeSign lanes in an effort to quality improvement, which allows us to deliver a higher quality and exceed our business expectations
• Worked on Marketplace projects: APPX for Windows Store, and XAP for Silverlight and Windows Phone, WinStore Online CA & CRL, Signing and Scanning of 3rd party apps from WinStore, Signtool update, SCOM monitoring, Website, Windows APPX SIP, Web/App/File server upgrade
• Involved in code-signing Xbox 360/One teams’ applications
• Worked on the cache features of a new Submitter Object which improved job intake capacity by ~20% at least and more in case of production lanes with network latency
• Completed a CodeSign production E2E performance testing against Scan production Pod using the performance test platform and reported the performance analysis to business and engineering teams
• Conducted performance tests in production for Microsoft product groups’ major builds and their performance analysis reports on how the builds were submitted and how our system could handle the load
• Performed capacity tests in production on a quarterly basis
• Tested the data migration project between data centers for Deliver & Store (DS) project
• Worked on D&S 4.0 Storage path Calculation Re-Architecture (SPArch) project
• Involved in bug migration from Product Studio to VSTF (Visual Studio Team Foundation server)
• Added new functionalities such as BVT, IQuery, and UpdateFileMetadata to DS Test Website

Software Design Engineer in Test

Confidential, Redmond

Responsibilities:

• Executed Black and White Box testing for Deliver & Store (DS)
• A whole range of Deliver & Store functional testing including Publish, Export, Copy, Remove, Download, Upload, IQuery, Caching, etc.
• Writing Test plans, Use cases, and Test cases and tracking bugs with Product Studio
• File Transfer Manager (FTM) installation testing with other platforms such as Windows Vista, XP, NT, 2K, 98, Windows Server 2003, etc.
• FTM UI and Central Web Site (CWS) localization testing
• FTM system testing for platforms, languages, and browsers
• Tested Web services, Windows services, and assemblies
• Tested database objects including table data, stored procedures, user defined functions, DTS packages, SQL scripts, etc.
• Performance testing for stored procedures
• Writing, running and assisting in manual and automating test scripts
• Developed Deliver & Store Automation (DSA) application including System test, BVT, Regression test, etc.
• Developed DS Test Web site for one-stop testing
• Developed Web Services to get the information of DS components sit on remote Web Servers for testing purpose
• Developed FTM Controller using Windows API
• Built DSTest database for both DSA and DS Test Web site using SQL Server 2005
• Setup and deployment of DSA
• Created Split-Streaming Template in Excel VBA macro to automate segment information, transfer bytes and speed
• Setup and deployment projects for DSA, FTM Controller, etc.
• Knowledge of VSTS (Visual Studio Team System) and working on converting the current automation code to VSTS technologies.

IT Specialist

Confidential, Seattle

Responsibilities:

• Experience in testing Database Applications of SQL server and MS Access
• Experience in functional, regression testing of VBA projects
• Localization testing of OCR SQL database data for Chinese, Japanese, and Korean
• Developed VBA automation tool to convert the Program Information Management System (PIMS) reports into Excel spreadsheets
• Created Access Database Templates with VBA for Outreach Mailing Lists and PowerPoint Presentation Projects
• Database development and programming using VBA, ADO, and SQL

Web developer

Confidential, Seattle

Responsibilities:

• Experience in functional, regression and stress/load/performance testing of web-based and client-server applications
• Tested the entire functionality of the application on different browsers like IE, Netscape, and Firefox
• Performed Black box and White box testing for the application
• Updated and maintained the existing sites
• Developed a Web-based faculty evaluation application to replace its paper-based process
• Developed a Windows-based Online Publisher application for Human Resource Management System
• Used classic ASP, ASP .NET, VB .NET, C#, ADO .NET, SQL Server, Crystal Report, and graphic applications