OBJECTIVE:

Experienced and motivated IT Professional seeking a technical position in a performance oriented environment.

SUMMARY:

• Extensive experience with Scope, Cosmos, Azure, ADF, T - SQL, SQL server, database design, database performance tuning, and ETL process.
• Self-starter.
• Analytical and critical thinking skills.
• Experience in different environments and roles.
• Team Leadership and project management skills.

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Data Engineer II

Responsibilities:

• Implement Upgrade Feature Training dataset pipeline using C#, Cosmos, XFlow, and Scope
• Implement Insider Retail Prediction for windows insider program using Cosmos, Scope, Azure Data Lake, U-SQL, XFlow, Azure Data Factory, Azure Blob Storage, and Databrick
• Write Window MAD Variant pipeline using Cosmos, Scope, XFlow, C#, and Powershell
• Implement SiMAD data pipeline using Cosmos, Scope, XFlow, and Azure Data Factory
• Write Scope and C# code for Asimov Event data ingestion pipeline for Windows Server Group Leadership reports using Cosmos, SQLizer, CAS job scheduler, Azure Data Factory, and Git
• Write Scope and C# code for UTC census data ingestion pipeline for Windows Server Group Leadership reports using Cosmos, CAS job scheduler, Azure Data Factory, and Git

Confidential - Redmond, WA

Sr. BI Consultant

Responsibilities:

• Write Scope and C# code for UTC census data ingestion pipeline for Windows Server Group Leadership reports using Cosmos, CAS job scheduler, Azure Data Factory, PowerBI, and Git
• Write Scope and C# code for UTC event data ingestion for various Window Server Feature Team like networking, nano, system center, etc.
• Implement ETL process to move data from Cosmos to SQL Azure Database using SQLizer, SSIS, and SQL Azure Database
• Working with PM for story clarification and definitions
• Conduct data exploration using Scope or iScope for problem understanding

Confidential - Redmond, WA

Sr. BI Consultant

Responsibilities:

• Implement ETL and cube features for big volume data for Confidential CDnA NorthStar Unified project using Metrics Explorer, DBLoader, AutoCube, SSAS and SQL Server 2012
• Implement ETL and cube features for Confidential CDnA NorthStar MSN project using Metrics Explorer, DBLoader, AutoCube, SSAS and SQL Server 2012
• Implement ETL and cube features for big volume data for Confidential NorthStar Unified Cube using SSAS and SQL Server 2012
• Implement the FormCode project for Bing Mobile Cube using SSIS, SSAS, and SSRS
• Provide Production Tier 3 support for Bing Mobile Cube
• Implement COSMOS Scope Views, PDS Semantic and SQL Models for Confidential BICI Next Generation Analytics projects
• Implement COSMOS Scope code enhancements to pull NIF data from Cosmos for BICI Bing Mobile MBR report by processing hundreds of TB data
• Implement T-SQL code enhancements of BICI pipeline for Legacy Data for the monthly business reports
• Create Excel reports for ad hoc business requirements using pivot table and cube browsing
• Author scope code to conduct data analysis for Bing Mobile Customer Churn Rate Analysis, User Segmentation Analysis, etc.

Confidential, Redmond, WA

Sr. BI Consultant

Responsibilities:

• ETL Performance Tuning for the Web Analytics Project for Confidential MSCOM, which improves 200% and 60% for two major components
• Design and implement System Maintenance Automation Module for the Web Analytics Project for MSCOM using T-SQL, and SSIS
• System performance tuning for the Web Analytics Project for MSCOM, which involves tables with 100+ million records
• Test the ETL and Data Mart Loading code for the Web Analytics Project for MSCOM
• T-SQL Performance Tuning for the Ultraviolet project for MSIT using T-SQL
• Unit Test Case Development for the Ultraviolet project for MSIT using C# and Visual Studio 2010
• Design and implement CPE Customer Experience database warehouse project for Confidential Customer Experience Management Division using T-SQL, PowerPivot and SSIS
• Design and implement MEG Competitive Intelligence database warehouse project Confidential Media and Entertainment Division using T-SQL, SSIS, PowerPivot, and C#
• Design and implement various features for Confidential Zune BI team using T-SQL, SSIS, SSAS, Visual Studio, and TFS
• Manage MEG project on project scope and feature prioritization

Confidential, Seattle, WA

Project Manager/DBA

Responsibilities:

• Design and implement database objects (table, proc, UDF, trigger, etc) based requirement documents for corporate SSRS and Access reporting system
• Design and migrate 60 DTS packages to SSIS packages
• Redesign ETL data warehouse system which is written in T-SQL and VBS
• Migrate the SQL server 2000 platform to SQL Server 2008
• Design the new Sharepoint Architecture and migrate Sharepoint 2003 to MOSS which failed many developers
• Manage outsourcing IT projects on project scope and feature prioritization
• Monitor and fine tune the SQL Server databases for this 0.5 billion business
• Staffing and junior staff mentoring

Confidential, Issaquah, WA

Software Tech Lead

Responsibilities:

• Design the conceptual and physical data model using ERWin 7.2
• Design and implement various Data Access Layer (DAL) components using T-SQL, C#, SQL Server 2005
• Design and implement the performance tuning project of Intersys Clinical Suite (ICS) product using Confidential SQL Server
• Manage the Distributed Data Storage Engine (DDSE) project using Confidential Project
• Manage the Data Storage Engine (DSE) team on staffing, training, performance evaluation, and status reporting
• Participate in the marketing requirement (MRD) analysis and system design (ERD) of company’s new patient monitoring product line, serve as voting member of the System Engineering Team (SET) for this 20+ million dollar project
• Author and manage SWRS, SWADS, and SWTP for the Salish Distributed Data Storage Engine (DDSE) using Word, Visio, UML, DocIT, and DOORS

Confidential, Seattle, WA

Database Architect

Responsibilities:

• Author the Joint Application Document (JAD) for website
• Design and implement the database architecture for windows mobile website
• Design and direct the implementation of notification and reporting subsystem of the windows mobile website using T-SQL and C#

Confidential, Vancouver, BC

Tech Lead

Responsibilities:

• Create JAD for system architecture design
• Design and implement data management system for natural resource management
• Collect customer requirement and write project proposal
• Communicate with contractor regarding project scope, budget, timeline and documentation
• Conduct acceptance testing on outsourcing projects
• Provide strategic value on product roadmap, new product planning, and staffing
• Remotely manage team members

Confidential

Sr. Software Engineer

Responsibilities:

• Software architecture and system design
• Participated in project planning and status reporting
• Mentored junior staff on technical difficulties
• Designed and developed “Go POS™” system using Visual Basic, Appforge MobileVB, Confidential Access, MSR reader, receipt printer
• Designed and implemented “Go Customer™” project using Visual Basic, Appforge MobileVB, Confidential Access, MSR reader, receipt printer
• Created “Go Gift™” software using Visual Basic, Appforge MobileVB, Confidential Access, MSR reader, receipt printer
• Designed and coded the “Desktop Opus” reporting software using Visual Basic, Confidential Access, ODBC, ADO
• Generated “Go Hotsync™” system to synchronize transaction data between desktop computer and handheld device

Confidential, San Jose, CA

Software Engineer

Responsibilities:

• Designed and implemented various Placement/Router engine modules in C++ using Visual Studio, Windows 2000
• Tool software tuning and unit testing
• Porting the software to UNIX platform using Mainsoft Mainwin, Sun Workshop
• Designed and developed a data mining system using java servlet, oracle, PL/SQL, HTML, and Apache Web Server
• Maintained, designed and implemented new features for the Defect Tracking System using oracle, SQL, tcl, perl, Netscape Enterprise Web Server
• Designed and implemented “Interactive Web Reporting” system using Crystal Report, oracle, perl, Netscape Enterprise Web Server
• Provided end-user training and software technical support
• Wrote data conversion script to convert legacy data from DDTS to DTS using perl and SQL
• Generated and ran the regression test suite
• Wrote script to automate the feature testing
• Worked closely with managers to create defect summary reports

Confidential, College Station, Texas

Program Analyst

Responsibilities:

• Developed the “Inventory Management System” for the warehouse using oracle, visual basic, crystal report, SQL
• Developed the “Foreign Nationals Information System” for the Business office of the Department using oracle power object, oracle database, crystal report
• Trained users to operate software and provided necessary technical support
• Software installation, configuration and maintenance

Confidential

System Analyst

Responsibilities:

• Designed and developed Import/Export Trading Management System using foxpro
• Maintained, designed and implemented the enhancement of the Corporate Electronic Accounting System using foxpro
• Trained customers to operate software and provided technical support
• Administered company Management Information System with respect to software, and a LAN of Novell Netware file server with respect to hardware with MS-DOS workstation clients