Jungchan (Roger) Hsieh
**** ******** **., **********, ** 75083 • 214-***-**** • *************@*******.***
EDUCATION
M.B.A., Healthcare Management & Information Technology Management – The University of Texas at Dallas, Richardson, TX Aug. 2014
M.S., Healthcare Management – The University of Texas at Dallas, Richardson, TX Aug. 2014
M.S., Information Technology Management – The University of Texas at Dallas, Richardson, TX Aug. 2013
B.S., Electronics Engineering Technology – The University of North Texas, Denton, TX
B.A., Computer Science – The University of North Texas, Denton, TX
CERTIFICATION
CSXF, MCSE (Data, BI), MCSD, MCSA SQL 2008, MCITP, MCPD, MCTS, OCP, Healthcare IT Certificate
COMPUTER SKILLS
Languages: C/C#/C++, VB.NET/VB/COM/ASP, XML, SAS, SPSS, Python, HTML, Java, AJAX, jQuery, JavaScript, and Scripting
Database: Oracle PL/SQL, MS SQL Server 7/2000/2005/2008/2008 R2 (SSRS, SSIS, SSAS, Data Warehouse), MySQL
Systems: Win7/Win XP/2003/Vista/2008, IIS 5/6/7, ArcGIS Server, and ArcSDE, UNIX/Solaris/Linux, Macintosh, MOM 2005, COBIT, NIST, and EDI
Software: MS Visual Studio, MOSS, DNN, Telerik components, CodeSmith, Resharper, LLBLGen Pro, DevExpress, DotNetNuke, PowerBuilder, Cold Fusion, Flash, Adobe Suite CS5, Epics, Clintrial, LabVIEW, HRIS, MicroSim, AzureML, Spotfire, SAS Enterprise Miner, SAP, SAP P A, R, Tableau, Qlikview, VNC, GIS, and ArcGIS
RELEVANT EXPERIENCE
Programmer/ SQL DBA – Halff, Richardson, TX April. 2014 – Present
Developed, and updated Web application in bootstrap.js, MVC 5, and SQL 2012 (BI Stack) to improve the processing mechanization over 20%
Created, developed triggers and store procedures to proficiently update spatial data between ersi and database over 30%
Web Developer / SQL DBA – Haynesboone, Dallas, TX Nov. 2012 – Sept. 2013
Created, and updated portlet in Coldfusion, ASP, and PhP for Plumtree, and Oracle Webcenter in order to increase the efficiency of processing automation of data over 25%
Implemented and maintained corporate blog site to promote company business via PHP, MySQL
Supported various corporate database via SQL 2005, SQL 2008, and SQL 2008 R2 with Profiler, DTA, PerfMon, sprocs
Analyzed the big data for corporate employees internet usage for phishing email campaign via IIS Log, TSQL, SAP Predictive Analysis, and SQL2008 R2
Technologist – CITM The University of Texas at Dallas, Dallas, TX June 2012 – Nov. 2012
Migrated campus life educational web game database from MySQL to SQL 2008 R2
Maintained and updated PHP scripts to connect with SQL 2008 R2
ACADEMIC PROJECT
Heart Failure - 1 Performance rate for hospitals participating in Value Based Purchasing Program
Utilized business intelligence skills to predict HF-1 performance rate would respond to readmission rate and mortality rate, predicted higher performance rate has an indicates lower mortality and readmission rates using Tableau,R and Rattle
ADDITIONAL EXPERIENCE
Sharepoint Administrator/ Sharepoint Developer – The Shams Group, Irving, TX Dec. 2011 – April 2012
Implemented and designed the multi-tendency of server farm in Share point 2010, ADFS 2.0
Designed and reported the chat history on Lync in Share point 2010, Share point designer, and External data type
Application Developer – Army Air Force Exchange Services, Dallas, TX Dec. 2009 – Aug. 2010
Designed and developed mobile performance management application for payroll system in C#.NET, Web Services in Visual Studio 2008 with DB2
Maintained, updated performance evaluation management system in C#.NET, AJAX, Web Services in Visual Studio 2008 with DB2
Designed and developed the scan-document web application for Human Resource Department in C#.NET, AJAX in Visual Studio 2008 with DB2
Designed, and developed the job_lookup, fac_lookup for Human Resource Department in C#.NET in Visual Studio 2008 with DB2
Application Developer – Trinity Consultants, Dallas, TX Jan. 2008 – Dec. 2008
Designed, developed, and unit tested Worldgeodata.com for online data processing tool for environmental customers in C#.NET application with Google Map (API), AJAX in Visual Studio 2005 via SQL 2005
Designed, developed, and unit tested the remote modeling data processing application for environmental customers in C#.NET, AJAX, Web Services via SQL 2000
Maintained, updated trinityconsultants.com, breeze-software, ondemand Environmental, 56 stories, and T3 to market corporation business
Sharepoint Administrator / Developer – Layered Technologies Inc., Plano, TX Aug. 2007 – Dec. 2007
Collected and analyzed data, implemented the dynamic ax ERP project within project, CRM, inventory, and scorecard module in X++
Developed and maintained corporate site with Window SharePoint Service, and Visual Studio in C#
Application Developer – Cityon Systems Inc., Plano, TX June 2006 – July 2007
Designed a web-base C#.NET application that views documents and event logs status for Denton County Transportation Association with JavaScript in Visual Studio via SQL 2000
Developed and maintained ticket purchasing ASP.NET web application for Denton County Transportation Association with JavaScript via SQL 2000
Deployed and maintained a Winform .NET application for project management
Analyzed, designed, and developed a dynamic layered event logs web ASP.NET application for Tricare group using Visual Studio with SQL 2000 as storage engine
System Analyst – Texas Instruments, Dallas, TX April 2000 – June 2006
Supported Spotfire application in yield data analysis.
Supported SQL 2000 database application development and application usage for online documents access.
Developed Windows Forms application for Inventory Database in ADO.Net
Maintained and tuned SQL 2000 database Corporate TimeCard program.
Team leader for web development projects
System Analyst – DataPro International, Inc, Middlesex, NJ Sept. 1998 - April 2000
Assisted Baxter Pharmaceutical Product, Inc. project manager in developing Clinical Analysis application system, which assists Physicians to obtain statistical information regarding medical diagnosis. This entailed accessing Oracle database information to generate query statements and creating spreadsheets for the office application (Adverse Event Analysis Application) in Visual Basic 6.0
Designed the Copy Utility to access97 database source, manipulate the records, set the new password protection, transfer the database cross the wide area network, and log the results into the text log file in Visual Basic 6.0
Developed the Access 97 database projects with Micros, forms for the Drug Inventory System.