PROFILE:

SQL Server BI Developer, Localization Project Manager/Engineer, SQL Server Engine Test/DBA, SQL Lab Administrator, and SDET Lead with 23+ years of work experience.

SUMMARY:

• Supply Chain BI Data SQL Dev (T-Mobile)
• Technical lead for Microsoft 3 tiers app Performance test
• SQL BI dev, Hierarchical multi-dimensional Data Warehouse with SSIS technology (T-Mobile)
• Lead Office 365 Portal (Azure environment) UI, Content project testing
• IPM/E for MSDN/TechNet - Office sites for International markets
• Tier 2 production SQL Server backend support + DBA
• Test Lead for 3 tiers web application development with SQL Server backend testing
• SQL Server Engine Integration testing, SQL Integration Lab admin, SQL bug DB DBA
• Microsoft ITG applications development/testing
• 3 Microsoft product/business group Best Practice award winners

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server BI Dev

Responsibilities:

• Identify, extract, transform, and transport the various key source data (Hadoop, Teradata, Oracle, Flatfile...) necessary for the business operation of the data warehouse
• Extract warehouse BI data to external business users
• Maintain quality data by cleaning, archiving, integrating and troubleshooting for data accuracy and integrity
• Provide ongoing support for BI data issues, and maintenance of the BI data warehouse operations

Confidential

SQL/API/Web Performance Technical Lead

Responsibilities:

• Gather performance testing requirements from customers across different projects to identify perf goals
• Plan testing strategy for performance tests across multiple applications, including SQL/API/Web tests
• Create load tests with parameters set to simulate multi-user conditions as specified by requirements
• Execute performance stress tests to identify and isolate application performance bottlenecks under load
• Drive to perform In-depth analysis of perf issues where perf SLA's are not met
• Establish a performance monitoring process and provide the monthly metrics to leadership team
• Mentor junior team members to enhance their performance testing skills

Confidential

SQL Server BI Dev/DBA

Responsibilities:

• Retrieve data from different data sources, populate staging tables; aggregate data to populate fact tables and implement business logic for alert with SSIS
• Day to day maintenance - support, troubleshooting and production deployment activities
• SQL performance tuning and process documentation preparation

Confidential

International/Localization Project Manager/Engineer

Responsibilities:

• provided project management expertise to drive the localization efforts for delivering the MSDN/TechNet
• Office content online for all supported Intl languages and markets. End to end tasks include:
• Worked with engineering team to drive feature/business requirements for localization tools & platform, design spec review, prioritize, enforce best practices, test features… to deliver it to production
• Developed outsourcing strategy; road map; KPIs, service level models for outsourcing.
• Managed external localization, engineering, test vendors in Europe and Asia.
• Build content plans and use BI data to define localization strategy, budget forecast, localization schedule
• Developed a process and page design for adding new BiDi languages for localization
• Managed to Implement new web controls for content promotion
• Drove to adapt (eat own dog-food) new localization tool - Universal Localization platform for production to simplify localization process to make it effective and better recycling

SQL Engineer

Confidential

Responsibilities:

• SQL Server engine test: created test cases including Confidential & Confidential design, QFE, IDW & regression test, stress & localization test, reduced automation test False Failures, special test environment setup and automation in batch, Visual Test, VB.
• Established SQL Server integration lab including setup private network with W2K, Domain Control, AD, DNS and DHCP, and Automation for OS images store and restore.
• SQL Server 7.0, 8.0 integration and performance test with Windows and Exchange server for memory allocation/balance load test.
• Worked on automation for running Early Adapter client DB at SQL Server lab with Service Pack, IDW build, and repro PSS escalated external client issue at SQL Server Lab for QFE candidate.
• SQL Server 70 and 80 DBA (ran Raid 4.x) - Microsoft internal bug management system on pre-released SQL Server ver.). tasks includes daily DBA tasks, SPs and IDWs upgrade, adding automation tools to Raid app by updating Trigger, oversee Raid performance, troubleshooting and technical support for Raid clients. Implemented SQL Raid DB with new SQL Server features - Full Text Search, Federated/Partitioned View, Replication and Fail-Over.
• Created various SQL Server TSQL scripts to support production administration tasks (requested made by dev, test and release managers) with notification vial SQL Mail, Triggers, monitoring SQL Server performance, DBCC tasks…
• Developed a tool to automate SQL Server Profiler play-back driver in VB5.0. The tool was used to automatically configure client master/user DBs at SQL Server lab dynamically.