Tom Chen Data Engineer Mcdba Mcsa Edw Ssis Bi Dotnet Email & Phone Number

San Jose, Us

Delivered a few complex web forms used by the Navy in a key web application for Navy wide equipment repairs and budgeting . Work received high marks from the client. C#, VB.net, asp.net, SQL Server.

Redmond, Washington, Us

Vendor at a great place of innovation building top notch data analytics, data pipelines and business intelligence.

Noida, Uttar Pradesh, In

HCL Technologies vendor, .net / azure developer. 2017/2-2017/3. Automations for Azure resource creation, query and deployment application POC using AAD ( azure active directory ) authentication and ARM (Azure resource manager) API. Added workflow front pages and Typescript using Rest, Json, Node.js and Aurelia javascript framework.

Redmond, Washington, Us

Contract through Tata (TCS) with MS Customer Service & Support Analytics Group.Developed Cosmos and Azure data pipelines. Azure SQLDatabase. Developed Web Api, Cloud services.Developed SSIS packages for incremental loading of large volume of data ( >20 million rows of large tables ) using watermarking, hashing algorithm, and best practices of Microsoft data warehouse technologies.Developed a machine translator in C# which can translate about 200-400 customer support notes or 40 million characters per hour on a i5 laptop.Hortonworks trained Hadoop Administrator, Big Data ETL Developer. Azure Data Factory. HDInsight. Installed, configured, maintain Hadoop 2.2 Cluster on Windows Server 2012 multinode cluster in AD for Microsoft. Automated HDP 2.2.4 install using Powershell in AD. Worked closely with Hortonworks windows engineering team, tech support staff, and Hortonworks superb instructor Ronald Daskevich.

Redmond, Washington, Us

Microsoft vendor ( Feb 2014 – Feb 2015 ), REDMOND WA. Data Warehouse, T-SQL, SSIS ETL, Architect - Developer. Supported Office 365 EDW, Visual Studio BI teams. Developed and added new data fields to existing SSIS packages based on Microsoft data warehouse design pattern cbf (common BI framework ) to onboard new metrics rapidly. Used Powershell to automate database build and deployment ( dacpac). Analyzed and developed indexes to improve ETL performance. Developed ETL SSIS packages to push data to Windows Azure storage. Developed data pulls from Cosmos using Scope scripts. Deployed SQL database projects using Octopus. Developed CDM (Consumer Datamart) SSAS cubes and cube security. Developed stored procedures using T-SQL. Resolved issues for Exact Target (ET) data mart, ETL process, and data quality. Determined complex ETL jobs dependency. Transferred knowledge from another vendor. Optimized ETL performance ( eg optimized one task from 45 min to 10 min). Developed ETL SSIS packages, .NET applications and SQL data processes. Developed stored procedures and parameterized SSRS reports. SRA ( service risk assessment ) status change tracking. Loaded Excel data into SQL Azure database in the cloud through HDInsight and Hadoop using Powershell, as part of a Proof of Concept (POC ) project. T-SQL. Visual Studio (VS ) 2015 / 2014 / 2013 / 2012 Ultimate, MS SQL Server 2014 / 2012 / 2008 R2, SSIS, SSAS, SSAS Tabular, Sharepoint 2013, Powerpivot, Power BI, Excel, SSRS. T-SQL, SSDT, GIT, TFS / VSTS change processes, shelveset / Code Flow / Code Review.

SQL Developer, SSIS ETL Developer. Developed SSIS & SQL data processes, stored procedures, designed and processed SSAS cubes and sales metrics KPI to drive growth in sales, as part of the enterprise EDW & BI analytics team. Worked as development SQL DBA. Developed a utility in C# / .NET to scan space info for hard drives / mountpoints, scan SQL databases for data / log files, developed CLR stored procedures to load delimited files and Excel files into SQL databases. Developed a SSIS package to test write permissions using specified credential. Teradata 13 / 14, SQL Server 2012 / 2008 R2 , Visual Studio 2012 / 2010, SQL Server Data Tools (SSDT). C#. ADO.NET, ASP.NET, SSIS.

Buffalo, New York, Us

Arenanet. Built a prototype business intelligence solution for GuildWars game to identify suspicious players, hackers and bots in a game play, aggregated hourly loads of game play data. Succeeded in performance tuning for report rendering from fact tables with more than 5 millions of records.

Houston, Texas, Us

Vale Business Intelligence and EDW Development via HP, Seattle WA, June 2011 – June 2012. DW & BI Architect / Developer. Delivered reports to project managers of HP and Vale executives for a large scale windows 7 upgrade and migration project (Application Remediation) . Designed enterprise data warehouses and data marts, reporting solutions using Microsoft BI stack. T-SQL,SSIS, SSRS, SSAS, Visual Studio 2010, MS SQL Server 2008 R2.

Us

contractor at Washington Air National Guard, McChord AFB. Industrial control systems (ICS), network vulnerabilities assessment and security tool development. C#, LINQ. SQL Server, database and report designs, ETL, SSIS, data cleaning and loading, SSRS, business intelligence, Visual Studio 2010, entity data framework (EF). VMWare, Data Collection on systems, registries, applications installed.

Randolph Afb, Tx, Us

As Sr Developer, Sr Database Engineer, Sr System Engineer I proudly supported USAF / Washington Air National Guard Cyber Command operations as civilian contractor through Quantum Dynamics Inc. under outstanding leadership of Colonel Michael Burk ( https://www.linkedin.com/in/mike-burk-b94b00/ ) Developed security tools to scan hosts and devices on the network, developed reports with a goal to discover host or network vulnerabilities. Developed SSIS / ETL packages to cleanse, extract and load data into custom databases for analysis and reporting. C#, Visual Studio 2010 Ultimate, entity data framework (EF), LINQ, ICS (industrial control systems), network and security tool development.

Redmond, Washington, Us

Vendor through various Microsoft partners or agencies.Microsoft GFS, Sr SDE / Database Engineer. Developed and maintained SSIS packages for data feeds, and developed FOPE subsystems, enterprise dashboard, Developed database schemas and SSIS to store and display complex hierarchy data. Also installed and maintained sharepoint servers 2010. Business Intelligence, Data warehouse, ASP.NET.Visual Studio 2010 Ultimate. Developed SSIS packages.

Armonk, New York, Ny, Us

Clients include Ameriprise, Avaya, ICI etc. (a) Led SQL server data collection and sizing, analysis, and consolidation design, database migrations, SQL server clustering, SAN storage / partition design, Veritas enterprise administrator. (b) Data collection web tool (Deuce ) development using ASP and SQL server 2005. Wrote stored procedures, triggers, views, DTS packages to pull data from diverse data sources etc. Designed most of the front pages in ASP and backend database in SQL server. Deuce database backup and system maintenance, and troubleshooting application errors / debugging. Got 5 star rating from Paul Hawbaker, PM on the Ameriprise account for IBM. Team was quite impressed by Tom's sizing calculations on the Avaya account.

Salem, Or, Us

Ported, deployed and maintained NEDSS, i.e. National Electronic Disease Surveillance System, JAVA /J2EE health application from Oracle – Silverstream environment to DB2 – Websphere environment. Added data export, secure file upload / download, and email notification features to eSentinel app. Supported NBS production and maintenance under excellent leadership of Stephen Ladd-Wilson, Program Manager, https://www.linkedin.com/in/stephen-ladd-wilson-7738952/ ; Pete Hale, Technical Lead and Architect, https://www.linkedin.com/in/pete-h-0731587/ .

Santa Clara, California, Us

Implemented and revised user interface of American Medical Association (AMA) Internet ID Application using JavaScript, VBScript, dhtml, ASP and visual Interdev, and JAVA applet calls. Developed browser detection feature which fully detects and routes users based on browser type, platform, version, cookie, and java capabilities.

Washington, Dc, Us

Contractor through Futron. Developed a database-driven web reporting application for project & program management using classic ASP / SQL under superb leadership of Kevin Repa ( https://www.linkedin.com/in/kevin-repa-290a5524/ ) and Joe Fuller.

Norfolk, Va, Us

Developed a database-driven web reporting application for project & program management using classic ASP / SQL under superb leadership of Kevin Repa ( https://www.linkedin.com/in/kevin-repa-290a5524/ ) and Joe Fuller.

Hadoop Administration And Development

Secret Clearance, Security Applications

Coursework, Computer Science

Education record

Java, Uml

Java, Websphere