SUMMARY OF QUALIFICATIONS:

• Over 17 years of experiences as system engineer, d Confidential base engineer, d Confidential base administrator, cross platform full stack developer mainly on Microsoft .NET and SQL Server platform but also Big D Confidential / Hadoop, HDInsight, Microsoft Cloud, Cosmos and Azure, Terad Confidential, Confidential Websphere, BEA Weblogic, Oracle Java, and open source platforms. Well endorsed work history in US federal and militaryagencies for example NASA, WASHINGTON AIR NATIONAL GUARD - United States Air Force, State of Oregon, and in private consulting such as Microsoft Corp, Intel Corp, Confidential Global Services etc.
• Recent focus on Microsoft Business Intelligence, Enterprise D Confidential Warehouses (EDW), Cloud and Azure developer. Big D Confidential, D Confidential bases, Systems, Applications & Security. Cosmos, SSIS ETL, SSRS, C#, ASP.NET, Hadoop, HDInsight, Java, MVC, Silverlight, Web Services, SQL Server, DB2, MySQL. Process automations, d Confidential cleansing,d Confidential extraction,d Confidential movement, d Confidential quality.
• Experienced Hadoop Administrator - Developer, Windows System Engineer, Sharepoint Server Administrator, IIS or Web Administrator, Build and Deployment Engineer, DevOps, Active Directory, LDAP, Storage / SAN Architect. System&Application Management, Operations& Production Support, Migrations and Consolidations ofD Confidential bases, Servers andApplications. Disaster Recovery Architect, Solution Architect

TECHNICAL SKILLS:

System Engineer, Build & Deployment, Release Engineering, Security & Network Engineer, Windows Servers Administration & Operations

Windows Server Administration, Installation, Configuration, Build, Deployment, Release Management - all versions of Visual Studio, TFS, VSO (Visual Studio Online or Visual Studio Team Services), Windows Servers, SQL Servers, IIS Web Servers, Service Packs, Patching, Windows Clusters, SQL Server Clusters, Hadoop Clusters, Octopus, Visual Studio, Powershell for d Confidential bases, systems, web applications, windows applications, MSI installer, system packaging.

OS / Windows NT / / R R2 64 bit and 32 bit server administration. Builds, configuration. LINUX (Ubuntu, SUSE, Redhat); Active Directory, universal / global /security groups, O.U. admin, LDAP server configuration, administration: SunOne. Set up DNS and DHCP server, add / replicate zones. WINS. Nslookup. Ipconfig. Ping.

Web server and application server administration. Builds, patching, configuration. All versions ofIIS, .NET framework all versions, Websphere and Weblogic Application Servers. Apache, Tomcat, JBOSS, Perl on Windows. Application pooling, DCOM, SSL s, TCP /IP restriction, host header, load balancing, IISactingas proxy to Weblogic or Websphere. IIS log analysis, web trends, performance. Server load / stress tests. Web and application architecture

Sharepoint server / 2013 administration and support.

Virtualizations. 5 years including VMWare, Vcenter, VSphere, Virtual PC, MS Virtual Server 2005, Microsoft Hyper V. Install, Configurations. Oracle Virtual Box.

Scripting Languages: Powershell, DHTML, Ajax, JavaScript, Jscript, VBScript, DHTML, XML, XSL, XLST, XHTML / HTML, CSS: 12+ years

Build & Release, Continuous Integration / Deployment (CI / CD): MSBuild, TFSBuild, Wix, MSI, source depot. Ant. 5+ years.

Change Management and Source Control: 10+ years. Experience level in descending order: VSTS, GIT, SVN, Visual Source Safe, Team Foundation Server, TFS, PVCS, CVS. File server and repository builds, configuration and administration.

Network administration. scanning tools - wireshark. Cisco network assistant. Netstat, port query. psTools. ACL. GPedit. Windows security policies, security baseline analyzer. Security templates. Batch edit security to apply across many servers. LAN subnet masking. Cisco network administration client.

Security administration. Firewalls (eg Zywall) / NAT / DMZ / VPN / IPSec setup for multi-tier servers, SSL, SSH, Routing, DNS: configuration, setup: 10 years, client and server s, Encryption authentication, public-key cryptography, PGP, Authentication / security software (eg Baltimore, Network Associates, Symantec), SSL. Infrastructure, SSH, Routing, DNS, Citrix.

RAID setup on HP & Dell servers. PXE, RIS, SMS, SCOM network install of OS and apps. Installed, configured, administered, troubleshot DNS, WINS. Antivirus, TCP/IP, LAN, FTP, HTTP, LDAP, Telnet, Ethernet, PPP, SMTP, Modem Access, ISDN, Firewall / Router Config. (3com, US Robotics, Linksys, Cisco). RAID5. HP Proliant DL 360/380/385/580 G4, Dell 0 / T7400 / Hyper V.

Disaster recovery. Imaging. P2V, V2P, & V2V for Total Virtual Disaster Recovery Flexibility and Virtual Migrations. P2P restore to dissimilar hardware, UBDR. Physical Server Snapshot. Bare Metal Recovery of 32 and 64-bit Servers in less than 10 Minutes. Acronis. Fast system imaging, backup, Instant restore using Ultrabac / UBDR, TrueImage Server, Norton Ghost, PowerQuest Drive Image 7, Tivoli. SAN. Cluster Admin. Expert to troubleshoot no boot, use recovery console, rebuild boot.ini, BartPE, direct edits of registry. Build of multiboot OS systems. Store Backups on TSM, SAN, NAS, Tape Library, VTL, and USB.

D Confidential base Administrator: Strong. 10+ years administering Access, MS SQL Server 6.5, 7.0, 2000, 2005, 2008, Specialized in Development and administration of SQL Server Reporting Service, Analysis Service and Integration Service, d Confidential base mirroring, clustering, including SSRS / SSIS / SSAS 64 bit and 32 bit. D Confidential warehouse design, DBArtisan, ERWIN, ER/Studio, DTS, ETL design (Extract - transform - load), Cube design / administration, MDX query development, Stored Procedures, Functions, Triggers, T-SQL, Performance Tuning, OLAP, OLTP, DBASE, MySQL. Oracle 8, 9, 10. Confidential DB2. RDS, ADO. Access Programming. SQL RDBMS (Relational d Confidential base) design, d Confidential schemas, normalization, replication, publishing, d Confidential import, export, Lotus Approach. Reporting d Confidential bases, replication, publishing, d Confidential import, export.

Remote administration and support: Putty. SSH. Remote desktop, TightVNC, RealVNC, Teamviewer, Webcasting, Office Communicator, Remote Administrator, VPN, citrix. Windows and DOS command lines, batch scripting, ssis / sql jobs

Programming Languages: Powershell, C#, VB, Java, UML, SQL, VB.NET, ADO, ADO.NET, Classic ASP, ASP.NET, VBA, JSP, Servlet, EJB, J2EE, open source, cocoon, XSP, LDAP, Tomcat, Xerces, .NET framework, Struts Framework, MVC, Websphere Studio (WSAD), COM DLL, COM+, DCOM, MTS, Web Services.

Microsoft Platform Development And Operations

SQL, SQL Server: 12+ years; all versions from SQL Server 2014, 2012, 2008 R2, 2005, 2000, 7, 6.5. Stored Procedures, Functions, Triggers, T-SQL, Performance Tuning, OLAP, OLTP. Confidential DB2 v7 & 8 (4+ years), Oracle 8 / 9i for NT/2000 (3+ years), MySQL (6+ years), SQL. Access, DBASE: 14+ years.

SQL Server Integration Service or SSIS (7+ years), DTS (6+ years), ETL design (Extract - transform - load) including replication, publishing, d Confidential import, export. D Confidential base design, d Confidential schemas, OLTP normalization & denormalization for reporting d Confidential bases.

SQL Server Reporting Service or SSRS (7+ years), some Analysis Service . D Confidential warehouse / d Confidential mart (multidimensional d Confidential base design).

KPI, Cube design (5+ years), MDX (1 years).

Visual C# ( / / . NET), ASP.NET, ADO.NET, Web Services: 8 years. Entity Framework: 2 years (implemented EF and EDM for a Silverlight web portal at MSN Live Op in 2010 and, for a windows form application, a command and control system at USAF / Washington National Guard / Quantum Dynamics Inc)

Silverlight: 2 years. MVC in J2EE: 6+ years. MVC in ASP.NET: 3+ years.

Visual Studio, Visual Basic, VB, ADO, Classic ASP, VBA, COM, COM+, DCOM, MTS: 12 years. All versions: Team System 2010 Ultimate / 2008 / .NET / 6.

Non-MS Platform Development

Java, JSP, Servlet, EJB, J2EE, open source, cocoon, XSP, LDAP, Tomcat, Xerces, Struts Framework, Websphere Studio (WSAD 4 and 5.1): Apache, Eclipse, MyEclipse, Tomcat, JBoss, SUSE, Ubuntu, Linux: 9 years. Perl, Python, C++, J++, FORTRAN: 3+ years

WORK EXPERIENCE:

Responsibilities:

• 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 Aurelia javascript framework.
• Microsoft vendor for CSS BI etc, through T Confidential (TCS), 2015/5-2016/10.
• Developed SSIS packages for incremental loading of large volume of d Confidential (>20 million rows of large tables) using watermarking, hashing algorithm, and best practices of Microsoft d Confidential warehouse technologies. Developed Scope scripts and SSIS packages to pull d Confidential from Cosmos or push d Confidential to Azure.
• Developed Azure SQL D Confidential base, Azure Cloud WCF Services, Web API. Developed a machine translator in C# which can translate about customer support notes or 40 million characters per hour. Developed build and release processes using TFS / VSO (VSTS).
• Hortonworks trained Hadoop Administrator, ETL Developer. Installed, configured, maintain Hadoop 2.2 Cluster on Windows Server 2012 multinode cluster in AD for Microsoft. Automated HDP 2.2.4 install using MSI, Powershell in OU (Org Unit) in AD. Worked closely with Hortonworks windows engineering team. Developed build and release processes using TFS / VSO (VSTS). Developed SSRS reports.
• Microsoft vendor for Office 365 BI then Visual Studio BI (2014/2-2015/2 ), REDMOND WA. D Confidential Warehouse, T-SQL, SSIS ETL, Architect - Developer. D Confidential Mart team. Developed and added new d Confidential fields to existing SSIS packages based on Microsoft d Confidential warehouse design pattern cbf (common BI framework) to onboard new metrics rapidly. Used Powershell to automate d Confidential base build and deployment (dacpac). Analyzed and developed indexes to improve ETL performance. Developed ETL SSIS packages to push d Confidential to Windows Azure storage. Developed d Confidential pulls from Cosmos using Scope scripts. Deployed SQL d Confidential base projects using Octopus. Developed CDM (Consumer D Confidential mart) SSAS cubes and cube security. Developed stored procedures using T-SQL. Resolved issues for Exact Target (ET) d Confidential mart, ETL process, and d Confidential quality. Determined complex ETL jobs dependency. Optimized ETL performance. Developed ETL SSIS packages, .NET applications and SQL d Confidential processes. Developed stored procedures and parameterized SSRS reports. SRA (service risk assessment ) status change tracking.
• Confidential, Bellevue WA, 2 /9. Software and BI Developer, SQL DBA. Developed SSIS & SQL d Confidential processes, stored procedures, designed SSAS cubes and sales metrics KPI to drive growth in sales. Developed utilities in C# / .NET to scan space info for hard drives / mountpoints, scan SQL d Confidential bases, developed CLR stored procedures to load delimited files and Excel files into SQL d Confidential bases.
• ArenaNet, Bellevue, WA, 2 /11. BI Developer. Built a prototype BI solution for GuildWars game to identify suspicious players, hackers and bots in game play, aggregated hourly loads of game play d Confidential . Prototyped d Confidential mart. Succeeded in performance tuning.
• HP ES for Vale BI, Seattle WA. 2011/6-2012/6. SSIS, SSRS BI Developer. Delivered reports for a large-scale windows 7 upgrade and migration project (Application Remediation). Designed enterprise d Confidential warehouses and d Confidential marts, reporting solutions.
• WASHINGTON AIR NATIONAL GUARD via Quantum Dynamics Inc., McChord AFB, WA, 2010/9-2011/7. Sr Developer, SrD Confidential base Engineer, Sr System Engineer. 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 d Confidential into custom d Confidential bases for analysis and reporting. C#, Visual Studio 2010 Ultimate, entity d Confidential framework (EF), LINQ, ICS (industrial control systems), network and security tool development.
• Microsoft vendor, REDMOND WA, 2007/7-2010/8. Consultant D Confidential Engineer at various Microsoft teams. Developed and maintained SSIS packages for d Confidential feeds, developed FOPE subsystems for a Silverlight web application as enterprise dashboard for monitoring of server operation metrics and performance etc. Installed and maintained sharepoint server 2010 on windows server 2008 R2 x64 in a farm engaged in a multiforest AD. Developedd Confidential bases and Web services inC# and ASP.NET, Visual Studio 2008. ASP.NET 3.5. Developed SSIS packages to extract and load d Confidential from sharepoint portals into SQL Server. Created test OLAP cubes for reporting.
• THOMSON PHYSICIANS WORLD 2007/5-2007/6, Secaucus NJ. Sr. DBA, Developer. Migrated / converted some Access 2000 queries to MS SQL 2000 db. Created Access passthrough queries to use SQL server 2000 procedures / views to feed access reports, dramatically improving performance.
• MOBILE PHONE APP LLC (The Ringleader) 2007/3-2007/5, New York NY. D Confidential base Architect. Design, model, architect and integrate d Confidential base for mobile phone ad camp Confidential ns. Provided system architecture, d Confidential base architecture, O.R.M (object relational mapping) design documentations, migrated / ported Atlas / Accipiter ad serving d Confidential base to MSSQL from MySQL and Oracle using SQL Server DTS / SSIS, produced ERD, ORM / UML diagrams and d Confidential models to assist developers with d Confidential structure.
• Confidential Global Services 2006/2-2007/2. Designed reporting architecture and migration path for Ameriprise etc. Lead SE, DE for SCON(Server Consolidations). Designed windows servers, SAN storage, architecture. D Confidential collection and sizing of d Confidential bases, partitions and SAN volumes. Developed ad Confidential collection tool using ASP and SQL server 2005.
• ABBOTT 20 /1. Web Developer, ASP / VBScript / JavaScript / SQL
• Confidential, 2005/8-11. ETL developer. Created DTS packages to load d Confidential from Bank One PCS Access / Excel d Confidential source to SQL server. BEA Weblogic Application Server, Java, JSP, Servlet.
• STATE OF OREGON Health Services 2002/3-2005/5. Web Developer and Production Support Engineer. 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 d Confidential export, secure file upload / download, and email notification features to eSentinel app. Supported NBS production and maintenance.
• INTEL, Hillsboro, OR. 2000/9-2001/3. Web Developer. Implemented and revised user interface ofAmerican 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 onbrowser type, platform, version, cookie, and java capabilities.
• SALTMINE, Seattle, WA. 2000/4-2000/8. Lead Web Developer at ArtsPatron.Developed a classic ASP web app and SQL server d Confidential base for information collection, profiling, updating and queries for art organization module, visitor module etc.
• NASA Confidential SPACE CENTER, FUTRON, Houston, TX. 1999/1-2000/3. Sr. Developer. Developed a d Confidential base-driven web reporting application for project & program management using classic ASP / SQL.
• N Harris & Tomball College, Houston, TX. 1998/6-1998/12. Part-time CIS Instructor.
• s, Honors: Intel, Nov 2000, for promptly delivering the AMA Internet ID application. State of Oregon Appreciation by Ladd-Wilson 2005. Futron / NASA presented a gift to Tom Chen in March 2000 during his farewell event appreciating his efforts at NASA JSC.
• List of websites I developed
• s: Available upon email request.