.Net Core Sql Server
Resume:
BING WANG
Houston, Texas, USA
ad7niy@r.postjobfree.com
US Citizen
WORKING HIGHLIGHTS
Software Framework: .NET Framework, .NET Core, C#, Java, ASP.NET, MVC, WCF, Restful, Web Api, WPF, Entity Framework, ReactJS, Angular 2+, Azure Cloud, TIBCO Databases: SQL Server, Oracle, MySql, DB2
Methodology: Solid Software Design Principal and Design Patterns, Agile Sprint Tools: Azure DevOp, GitHub, Jenkins, Memory Profiler, TFS, Fiddler, Postman SCORE CARD
Skills Years of Experience
Total IT Experience 17
.NET C# in MS Visual Studio 16
WCF WPF Web Service Asp.Net MVC 5
.Net Core Azure Cloud Angular 2+ ReactJS 3
Restful Web Api 365 Dynamcis Azure 6
SQL Server 16
Oracle Java 4
C# in MS Visual Studio
18 years of programming experience based on Procedure and Object-Oriented Principal concepts. Application soured code documents are depicted in GitHub, TFS, Tortoise, visual source safe. Unit testing are built on the frameworks of MSTest, NUnit, and xUnit.
Programmed in Windows UI through WPF pattern of view-view model, Web UI through MVC pattern of model-view-controller and react client with Angular 2+, Html5, JavaScript, Jquery, and Ajax.
Involved in the SQL data table architect design and Entity Framework POCO data modeling and Dapper ORM. Extensive programming in service API, repository supporting Sql server, Oracle, Mongo db and Microsoft Azure Cosmos db.
Programmed in messaging system integration on top of frameworks of Tibco, RabbitMQ, MSMQ and Microsoft Cloud Message Bus.
Implemented inhouse API library, such as concurrent list, smart sorting, aggregation pipe line, split pipe line, excel import export, json utility functionalities, etc.
Involved different SDLC methodologies like Waterfall, Agile, Scrum and Sprint.
Involved CI/CD for continuous monitoring and automated testing, building and deployment through Azure DevOp, GitHub, Jenkins.
Keep learning, fumbling, researching, thinking, engaging, coding and testing. It’s my perpetual fun.
Java in Eclipse
Around 4 years programming and support in web service, servlet, JSP application
Decompiled the jar file and debug into the code to make modification to generate new jar file
Deployed and configured and hosted Apache Tomcat in windows server SQL in MS SQL Management Studio
16 years of queries written in SQL server from its version 7, to 2000, 2005, 2008 till 2020.
SSIS ETL and the table schema creation, index build and data maintenance.
Below are some tips I tried before when optimizing my complex query: 1. multiple tables better have referential integrity. 2. matching fields better are primary key column, index, referential key columns. 3. eliminate the duplicate rows return.
4. eliminate the function and implicit conversion in the where clause. 5. try to archive data out and shrink table size if the tables have billions of rows. 6. join the tables better fall into left-deep tree instead of bushy tree. 7. text search is better leading wild search: like 'xyz%' instead of full wild search: like '%xyz%'.
8. last try is using hint to see if query runs faster. Tools - I used the following major tools during my application developing:
Azure TFS DevOps - source codes control and build pipeline configuration.
GitHub and Jenkins - open source from Microsoft for CI/CD.
Memory Profiler - a good tool for detecting memory link, especially for those child object fields references are still alive while its parent object was trying to deallocated, this tool can display the diagraph showing the dangling references.
Postman - a best tool to help you test the service API.
Fiddler - a great tool to help you analyze http/https traffic, especially header, message body and encoding.
Toad - a great tool for Oracle developer.
EDUCATION BACKGROUND
University of Pittsburgh M.S. Computer Science 1997 - 1998 WORKING EXPERIENCE
Motion Recruitment LLC Houston, TX 04/2022 ~ 04/2024 Senior Software Consultant at Client Banking Financial Firm This role is designing and implementing the restful web Api services and Asp.Net MVC web applications for the retirement of legacy system and upgrade to advanced relative database system, along with payment data transaction, ETL migration, and validation. Responsibilities
Worked on the design and implementation of the C# Asp.Net MVC Angular 17 and Restful Web Api on real time data transmission in Json format. The data repository is a blending of Entity Framework Core and Dapper ORMs storing data in Sql Server and Azure database. The Asp.Net MVC UI is supported by bootstrap, Telerik Kendo and Javascript.
Worked on the modification and support of Java servlet and J2EE application hosted in Tomcat Apache and code in Eclipse editor.
Worked on the implementation of excel data import and export through OpenXml and ClosedXml open-source project, and the SSIS ETL project for data one time loading.
Worked on the support and plug in modification of the web application built on top of Microsoft Dynamic 365.
Learned
Through the programming work at this financial firm, I’ve got acquainted with financial business domain knowledge. To better finesse the business technical requirements, I’ve delved into the coding on routing-based web api and the gossamer EF Core and Dapper data repository framework based on the concept of object-relational mapping (ORM). In addition, I’ve perceived the rich yet slick CSS styled bootstrapping and Telerik UI control library and done some customization work. Furthermore, I’ve impressed by the neat and tidy of Dynamic 365 suite, the automatic generated template-based web pages and joined works on the plugin. Throughout the entire process of the application development and deployment, I joined the QA team for testing cases review and test documentation creation.
Environment and Tools
.NET Core, C#, Java, EF Core, Dapper, Sql, DevOp, Web Api, SSIS, Angular17 Tata Consulting Services. Houston, TX 03/2021 ~ 04/2022 Software Consultant at Client of Santander Consumer USA This role was maintaining and implementing new requirements for a complicated financial payment software system supporting loan and lease for automobile industry. Responsibilities
Worked on the modification and implementation of the Asp.Net Core, Asp.Net MVC and Web Api, Microservice, Angular 9 and 365 Dynamic web applications supporting financial sales contracts, credit score fetching, financial loan calculation and downstream live data transfer to data warehouse.
Worked on the modification and implementation of the Windows desktop application in Win Form and WPF.
Worked on the implementation of the T-SQL stored procedures and Entity Framework Core for SQL server and SSIS data migration and Azure data provider integration and production error data fix through complicated Sql script.
Conducted the performance tuning detecting memory leak and garbage collection. Learned
Through the maintenances of this software system, I’ve learned the loosely coupled multi-services integration with separate duties. Gateway API is a practical approach for complicated client server communication involving security, authentication and endpoint routing. The table-based asynchronous queuing processes support the data pipeline connection and transmission. Interestingly, I’ve acquainted the web api proxy file auto generation based on *.tt template file, the Entity Framework Core based data access layer buttressing the multithreading data connections with different database instances, and the multilevel config-sections loading the dynamic runtime environment. The malleable coordination between developer and QA procured the software robust to cover as many fatal cases as possible.
Environment and Tools
.NET 4.8, .NET Core, .NET Profiler, C#, Restful Api, Json, SQL, SSIS, Mvc, Angular 9, 365 Dynamics, WPF, Infragistics, Postman, GitHub, Azure DevOps. Cubic / Trafficware Inc. Houston, TX 10/2017 ~ 07/2020 Senior Software Engineer
This role was maintaining and implementing new requirements for an integrated .NET C# based software system interfacing with the traffic control embedded low-level system application to support the real time data processing of signals from traffic control. Responsibilities
Worked on the design and implementation of services architected on top of the framework of WCF, Restful, Web Api and Microservices in C#.
Worked on the designing and implementing of the windows desktop application front end UI interface rich on Infragistic library controls in win form and WPF.
Worked on the design and implementation of data access layer for Cloud Azure Cosmos database through Azure data provider API and data migration using Azure migration service.
Implemented the reporting application through the complicated Sql queries and Devexpress library for the dynamic formatting.
Learned
Through the maintenances of this software system, I gradually acknowledged where should I start when taking on support an extant completed software system. Beginning from the data, or entering the detail implementation directly, or getting into the architecture design document first? After the work here, I realize that I should start from learning the industry business contexts to gain a high-level depict of design concepts. What implementing techniques should learn when interfacing with system low-level embedded application written in C. Besides, I feel the hardness of creating a perfect software system due to the unexpected cases in production but not covered in human-brain-generated unit tests, so working with QA extensively before each CI/CD deployment is the only safeguard.
Environment and Tools
.NET 4.8, C#, WinForm, WPF, Restful, Web Api, SQL, Azure Cloud, Javascript, Infragistics, Fiddler, Postman, Git, Jenkins, Memory Profiler. Procom, Inc / Tomium / InQuest Staffing Houston, TX 09/2012 ~ 07/2017
.Net C# Developer at Client of Oil and Gas
This role was designing and implementing a software system supporting daily trading. Responsibilities
Responsible for the design and implementation of web services in C# architected on top of the frameworks of WCF and Tibco EMS messaging system. With the help of Tibco framework API implementation and maintenance, the data are broadcasted through Topic sharing among integrated systems and transferred to warehouse for ad-hoc reporting.
Built the concepts and source code in C# for pipeline worker, engine and fluent based on object-oriented and software open close principles in windows desktop WPF application. Maintained the Java service application including deployment and configuration and hosting in Apache Tomcat server.
Enhanced the concepts and coding in C# for imminent real time data filtering, processing, displaying and disposing. The real time data can be either volatile, or flushed to storage for continuous data analysis or ad hoc reporting.
Worked on SQL queries in the data migration tool informatica to load data from normalized Oracle database to denormalized Oracle data warehouse.
Understood and modified macro-VBA in excel 2003. Environment and Tools
.NET 4.0, WCF, WPF, Mvc, C#, Java, Tibco, TFS, Javascript, VBA GC Service, LLC. Houston, TX 07/2010 ~ 08/2012
Software Engineer
This role was maintaining and developing requirements for inhouse software products. Responsibilities
Worked on the design and implementation of services architected on top of the framework of WCF and Sql Server.
Responsible for designing and implementation of the windows WPF interface.
Learned software design patterns and principals. Learned and worked on WCF transaction supporting ACID operations, AppFabric of WCF service auto start, work flow and caching, XSD writing to support uniform XML configuration. Environment and Tools
.NET 4.0, C#, WCF, WPF, Devexpress, EntityFramework, TFS, Xsd Volt, Inc. Houston, TX 01/2009 ~ 02/2010
Application Developer at Client of Oil and Gas
This role was maintaining and developing new requirements for software products. Responsibilities
Worked on the design and implementation of Asp.Net web form application.
Worked on the implementation of dynamic HTML generation through Ajax. Environment and Tools
.NET 3.0, Asp.Net, C#, Javascript, Ajax, TFS
SOGETI Houston, TX 10/2007 ~ 5/2008
.Net Consultant at Client of Oil Service
Responsibilities
Responsible for the implementation of ETL application to migrate data from Sql server to Active Directory through generating import file in the designated format. Experience Summary
As a software engineer, I have been programming in .NET C# and Java from 2006 till the present time. As we all know, computing industry is such a broad embracing area that no one could touch every field in his or her career lifetime. For me, I have been encircling myself in the software developing encapsulating multiple fields stated as below. The first, in my view of the programming architecture, high level languages C and C++ in Solaris or Sparc Unix workstation need be compiled, object linked and finally generated machine code targeting the architecture. Java and .NET C# are compiled into the bytecode, which is subsequentially converted into machine code through the runtime component JIT compiler. In addition, as a high-level programming programmer, I’ve been impressed by the beauty and power of OOP and automatically steer in the stream of OOP whenever coding. Moreover, a variety of data structures such as list, linked-list, sorted list, and generic list, etc. provide categorical support. On top of that, the atomic and synchronization of data values during concurrency are always the critical points especially for service application.
The second, in my works of the software solutions, the creation of different windows user interfaces application shed light on my understanding of the GUI, ActiveX control itself, the way of control event wired, the control logic tree, the specified control appearance, and the dissolution of view and view behind. Every programmer who has been following the ascending trajectory of Unix-Motif, MFC, Visual Basic, Windows Form and WPF has the similar discernments. However, the ways of building web applications are like spectrum. The not-speedy writing of code render block in Java JSP and C# ASP is still popular in Asp.Net. The separated responsibilities of model, view and controller opened a new chapter for web framework. The react web Javascript libraries like ReactJs and typescript supported Angular 2+ initiated the lightweight of html5-template-module based web programming. The bootstrap style library amazingly brings the aesthetic and harmony of all the web pages. Certainly, the Javascript coding is always the underpin at client side. As for web service applications, they need be robust demons 24x7 run with distributed and concurrent capabilities at peak time and garbage-collect resources at down time. On the linear evolved web service frameworks such as .NET Remoting, Soap based web service, address-binding-contract based WCF, web resource based Restful Api, and currently microservice based Asp.Net core web api, each subsequent framework draws the strong points of previous one and compensates the defects. But the underline is either sync-async request-response pulling, or timer-event-driven pushing. The third, in my worked areas of the backend data stores, the Sql server is number one. I started from the Sql server version 7. The writing of Transact-Sql helps me comprehend the difference between imperative and declarative language. Besides, I realize that the SSIS is a very powerful ETL tool to transmit and assembly the data in different data system. Another interesting learned is that Microsoft’s object-context based EF and EF Core is a way of data access that suits for the relatively small-scale data store with obvious referential relationship. The ORM based EF core integrates more easily as a lightweight data provider.
The fourth, in my readings and thinking of the application design, the conventional software design patterns and principals are always the guidelines for the software implementation and performance. The gist ones are open close, reusable, dynamic dependency injection, strategy pattern, and separation of responsibilities. The fifth, in my limited yet very important time of unit testing, Numerous testing frameworks I use are MSTest, NUnit and xUnit. They have a common test class skeleton except the attributes of test method, as well for different build natures in Azure DevOp. I prefer case-based static data or formatted file-based unit testing. Unequivocally, integration testing is a must-do to observe the data flow from data input at UI to the back end. Unit testing and integration testing are far from complete without QA’s case-based validations. Therefore, the cooperation between developer and QA is the last guard for the software quality.
The sixth, in my readings and writings of the application documents, I feel a strong designation to read all the related application documents before started the software support. I’m inclined to fumble the essential application design and the pertinent information from the given documents, same for contributing to team documents or composing my personal developer notes.
The above are all I can think of, as for the subtle and detail on the problem solving during my work, it’s definitely not one or two sentences can summarize. I’m looking forward to sharing during my interview, to discussing the nitty-gritty of exampled coding issues I have luckily countenanced.
Thank you for reviewing my resume!
Contact this candidate