Sql Server C#

Chung Han Wu

562-***-****

********@*****.***

Technical Experience:

Western Growers. 11/2018-3/2023

●c# 6, web api, database design, data modeling, stored procedures, udf, git: back end for Pinnacle Rx Solutions web site

●Requirements gathering, interface with end users and product stakeholders, build prototype, generate UML diagrams

●ETL into sql server 2016: eligibility, group, plan and prior authorization data, C# windows service, scrubbing the data, performance optimization

●Visual studio 2017 with git repository command line

●Automate unit and integration testing. Ensure good code coverage with JetBrains Dot Cover. Refactoring to improve code metrics.

●Data transfer with legacy systems (VMS) using Json and newtonsoft.

●Build permutations of VMS file structure in xml considering all combination of variants.

●WPF, C# and sql server: View and rollback change logs stored in json and xml, performance tuning, query optimization, database design, technical documentation

●Pascal, C : maintain legacy health insurance claims processing system on VMS using Extensible Versatile Editor, troubleshoot computation errors, generate financial reports

●Jquery: enhancing diagnosis management system

●Arbinger's outward mindset and how my work affects others on the team.

●Complete Python programming certificate from Cornell University

Bristol Farms. 5/2018 - 9/2018

●Excel and Outlook interop

●C# and sql server: internal winforms tools to manage inventory, costs and prices; tool to manage email marketing campaigns, integration with Mail Chimp via JSON; inventory repricing tool, performance improvement achieved utilizing multi threading with TPL

●Convert existing VB 6 application into c# 4.0 to generate and send out reports of sales, purchases and profit margins by the various departments

●Utilize sql server Stored procedures, user defined table types, bulk insert, complex queries in sql server 7 and 2008, query and database optimization

●Utilize Farpoint spread control to display data

●Collaborate with product owners to develop comprehensive documentation for all applications built and maintained

●Automated report generation and delivery

TraPac 1/2016 - 3/2018

●C#/sql server 2014/web API/AS400/Db2/REST: Build replacement for legacy Gate system written in RPG for the Los Angeles and Oakland terminals. Collaborate with third party vendor in Taiwan who provided interactive UI. The front end was later changed to windows based, and batched AGS provided by Nascent Technologies with Integration via XML. Definition of XSD using Liquid XML. Integration with existing yard automation software via Apache JMS (ActiveMQ). Data access components using Sql server and Enterprise Library. TFS and visual studio 2015. Data store is sql server.

●C#/XML/JSON/sql server: middle and back tiers for company web site. Front end was provided by third party ImageX. Real time updates of loaded/empty containers, chassis, cargo status flowing through the TraPac terminals. Maintenance of booking and equipment master. Data access through Enterprise Library data block.

●Requirements gathering, interface with end users and product stake holders, build prototypes

SynerMed 5/2011 – 12/2015

•C#/VB/SQl Server 2008/WCF: Custom business rules engine – application of xml formatted business rules to facilitate automated processing of authorizations and claims submitted by healthcare entities. Design and build winforms tools for maintenance of xml formatted business rules and monitoring of workflow. Integration with proprietary HEALTHX workflow product and third party EZ-CAP. Winforms app to maintain xml formatted business rules, association with IPAs and prioritization.

•Asp.net MVC, typescript, angular : Provider and participant portal to submit and review claims for healthcare provided, workflow management

•Retrieval of data from EZ CAP database, query optimization

•Automated report generation and delivery

Los Angeles County Office of Education 4/2011 – 5/2011

•C#, Sql Server 2008, JQuery : Create and enhance dot net nuke modules as part of EPIC student information system. EPIC is used by public schools county wide.

•SPED – special education, build reports in SSRS and data entry forms for preparing plans of special education students

Zynx Health 1/2008 – 12/2010

•C# and SQL Server 2005/2008

•Reengineering legacy VB.NET 1.1/ADO.NET application to use C#, WCF, LINQ To SQL, UpdatePanel, jquery, extJS, scrum/agile

•Requirements gathering and reverse engineering of legacy application; generating activity, class and sequence diagrams with Enterprise Architect; writing use cases

•Implement security enhancements including password strength, expiration, logging of user activity

•Participate in QA during reengineering process and fixing defects

•Enhance database performance by extracting business logic from stored procedures into dot net business layer

•Generate unit and UI tests utilizing unit testing and test manager in Visual Studio 2010

•VB.NET/SQL Server 2000

•Maintain legacy web application that was written in VB.NET 1.1, SQL Server 2000, Ajax, utilizing Visual Studio 2003/2005

•Maintain legacy winforms application used by internal writers and editors to generate content for reference site

•Analyze legacy stored procedures, index creation

•Javascript, Ajax

•Technical interests/reading list

•Brownfield Application Development in .NET

•Clean Code (Robert Martin)

•Refactoring (Martin Fowler)

•Gaining additional experience in WCF, LINQ, Entity Framework, dot net MVC framework

•Working Effectively With Legacy Code

•Additional training (UCLA extension)

•SOA concepts

•Information security concepts

•Management of database systems

Word and Brown. 8/2005 – 12/2007

•C# and SQL Server 2000

•Meet with end users to discover business requirements. Draft functional specifications from business requirements.

•Build class hierarchy, implement interfaces and utilize custom collections to support online benefits quoting and enrollment system for small (2-50 employees) and large (51-200) groups, online life events management. Maintain existing code. Develop user controls. Validate user input using standard dot net validation controls and implement custom validation logic using custom validators.

•Integration with legacy PICK/Universe back end using IBM Universe OLEDB drivers

•Maintain multiple branded web sites on the same code base using asp.net configuration management

•Optimization of long running processes using asynchronous processing and implement job control (observer pattern)

•Work with visual studio .net versions 2003 and 2005 beginning with Windows XP and then Vista.

•Prepare battery of NUnit tests for business and data access objects

•Build rich user interface using a variety of Telerik and AJAX controls

•Convert existing pages to use master pages and resolve JavaScript issues resulting from the changes in clientID.

•All enhancements go through full SDLC

•Build internal use web pages that are processed into pdf documents

•Contractor’s Choice (prevailing wage hour banking) line of business - Build stored procedures and user defined functions to generate customized reports in crystal reports, utilize vb6 to customize and enhance trust administration system.

•Familiar with design patterns and productivity enhancements to VS2008

O’Neil Data Systems 12/2004 – 6/2005. XML, XSLT, and C# windows-based and web-based applications to facilitate their printing and fulfillment business. Database design, stored procedures and user defined functions.

Haas Automation, Inc. 9/2002 – 10/2004

•VB.NET and stored procedures on SQL Server 2000.

•Meet and collaborate with users on-site to develop requirements and specifications, develop detailed designs. ER-diagramming with ERWin. Flowcharting with Visio 2000.

•Develop a centralized system to maintain product specifications and marketing data. All phases of SDLC. Generate system documentation. Interface with MRP system written in Pick Basic via XML. Utilized in sales, marketing and manufacturing. Visual Studio .NET

•Develop a web-based customer relationship management system.

•Develop a windows-based application for receiving, tracking and diagnosing defective parts returned to the factory. Generate custom reports.

•Develop a web-based application to track all hardware and software assets, utilizing web services to interface with SQL Server 2000.

•Develop PC-based reporting system (401K and profit sharing) to interface with payroll system.

•Oversee beta testing and provide end-user training during implementation of each product.

•Interface with legacy systems via XML.

•Utilize PICK Basic to modify and enhance ERP system (Avante 9.1.7A). Participate in planning, specification, design and implementation of enterprise-wide applications. Interfaces with Microsoft Dot Net via UniObjects. Create views in Visual Schema Generator and enable access via ODBC.

•Develop customized financial, pick list, and inventory reports to run on SB client’s ReportWriter and as stand-alone reports.

•Enhancements to accounting system to automate daily tasks performed by accounting staff.

•Design and code new programs as well as modify existing Avante programs to better fit needs of end users.

•HP-UX 11.0 administration. Unidata 6.0 administration. Performance monitoring. Document administration procedures, including backup and security. Handle day-to-day issues regarding access, performance and disaster prevention.

•Utilize ERWin 3.5.1 and Visio 2K to map the 25+ Access databases that are currently used in various areas of the company such as sales, production/manufacturing, electrical/mechanical assembly, R&D and QA. Consolidate and migrate to SQL Server 2000 running on IIS 5.0. Develop windows-based front ends with .NET Develop web based reporting with .NET Total users 200+. Create complex queries and functions in SQL Server.

•Additional training in Pick/Unibasic Programming, Unidata Administration and SB+ development from IBM Training Services (10/2003 – 12/2003).

Marketping Inc. 9/2000 – 4/2001. 3333 Brea Canyon Road, Diamond Bar CA 91768. Maintain company site and customize Commerce Server products to streamline the buying and selling of pollution control products and services. Build RFP system to facilitate the management and procurement of pollution control projects, supply chain management. Catalog and directory, online bidding platform Utilize VB Script, HTML, dHTML, SQL, JavaScript, XML, ADO and stored procedures on IIS/SQL Server 7.0 platform. Microsoft Interdev Enterprise and Visio (ER Modeling), Stored procedures on SQL Server. Develop administrative functions and statistics gathering. Javascript programming specific to Internet Explorer and Netscape. Extend platform to client web sites. Meet with clients to determine requirements and provide training. Participate in discovery of requirements and specifications. Perform analysis and design. Develop customized reports from database.

University of California, Los Angeles 1991 – 1994

Student research. Determine requirements and specifications. Computer Simulation of Protein Folding in Fortran 77 using Monte Carlo Method and statistical analysis. Department of Chemistry and Biochemistry, Dr. Todd Yeates

University of Southern California 6/1989 – 8/1991

Student research. Determine requirements and specifications. Computer Simulation of Protein Folding in Fortran 77 using Monte Carlo Method and statistical analysis. Department of Chemistry, Dr. Ariel Warshel. This was funded by a grant from the Southern California Academy of Sciences

Computer Skills:

Programming languages— VB.NET, C# 6, ASP.Net MVC 5, JavaScript, JQuery, Java (Swing, Java2D, JSP, javabeans, servlets, RMI, CORBA, JDBC), C, C++ 14, Visual Basic 6, Fortran 77, ASP, SQL, PL/SQL (Oracle 8i/9i), HTML, VB Script, XML (and WML), UML, MFC, Pascal, Pick Basic, Angular, dot net core, entity framework core modelBuilder, React, React Components, JSX

Applications—Microsoft Office 97/2000, Visual Studio 6/.NET 2003/2005, Visual Interdev, Borland Jbuilder, Front Page, Adobe Acrobat, Commerce Server 3.0, Macromedia Dreamweaver/Fireworks/Flash, Project 98, VI, emacs, System Builder 5, Epicor Avanté 9.0.1, crystal reports

Databases—Microsoft Access 97/2000/2005/2008, SQL Server 7/2005/2008/2015,2017, Oracle 8i/SQL Plus, PowerBuilder 5, Unidata 6.0

Operating Systems—Windows 95/98/NT Server 4.0/2000/XP, Unix/Linux, VMS

Other—SDLC, COM, ActiveX, ODBC, LDAP, UNIX Shell Scripting, database design, ER modeling, Accounting principles

Networks--Linux installation, Linux to Linux and Linux to Windows NT Server 4 and Linux to Windows 95, knowledge of Ethernet, LAN/WAN/MAN

Education:

Cornell University - python programing certificate, NumPy, Pandas

Cal State Fullerton, University Extended Education - Certification in Java 2/J2EE with Swing, Oracle Developer, XML.

Azusa Pacific University - Master’s of Science, Applied Computer Science Coursework includes Office 2000, C, C++, data structures, object oriented and structured approaches to software engineering, Visual Basic, database design (using PowerBuilder), networks, software engineering/software development life cycle, software engineering best practices, Java (GUI, exception handling, multithreading, applets and applications), GUI design principles, operating systems (UNIX kernel and internal architecture) and PC Hardware

Computer Learning Centers - Diploma, Computer and Internet Programming, summa cum laude. Relevant coursework includes MS Access, C++, Visual Basic (includes ADO), Java, E-commerce development, XML, and seminar by C-tech instructor

University of California, Los Angeles - Bachelor’s of Science, Cell and Molecular Biology

Contact this candidate