Sql Server Node Js

MINGTAO LI

*** **** ****, *******, ** M*J *A*

Cell: 416-***-****

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

OBJECTIVE

To secure an I.T. position in a dynamic organization where I can contribute my technical skills in computer science

PROFILE

Highly motivated problem solver.

Proven computer programming, database, network, design, systems software abilities.

Hardworking and dedicated to projects and tasks.

Resourceful and goal-oriented with strong abilities to work independently or within a team.

Focused, determined and dependable.

Bilingual: speaks both English and Mandarin fluently.

I am a Canadian citizen.

I am incorporated for contract jobs.

I am willing to travel. I have Driver’s License G.

TECHNICAL SKILLS

Database

Microsoft SQL Server, Oracle, PL/SQL, MySQL, MongoDB, SQLite, MS Access

Programming Languages

C#, VB 6, Visual Basic 6, PHP, Node.js, Java, Python, Ruby on Rails, C++, C, Visual Basic(VB.Net), Objective-C, Perl, AS/400 CL, RPG, Shell script, COBOL

Web Development

Angular JS, Angular JS 2, ReactJS, Redux, JQuery, Vue.JS, Sencha Ext JS, Ajax, Babel, Webpack, Redux, Backbone.js, Bootstrap, websocket, socket.io, NPM, Jenkins, peer to peer (P2P) network, Single Page Application (SPA), Paypal Braintree, STRIPE, Paypal buttons, JSP, Tomcat, JBoss, Glassfish server, Weblogic 10g, JDeveloper, Log4j, XSLT (style sheets), sql developer, Spring, Hibernate, Struts,Maven,J2EE,EJB 3, RESTful and SOAP Web Services, Swagger, Postman, AJAX pagination, AWS (Amazon Web Services), Azure, Accessibility for Ontarians with Disability Act (AODA), Web Content Accessibility Guidelines (WCAG), GCP (Google Cloud Platform), Linq, ASP.NET MVC, .NET Framework 4.5, ADO.NET Entity Framework, .NET Core 3.0, Microsoft Team Foundation Server, Kendo UI, Telerik Grid, Telerik Automated Testing, NopCommerce open source e-commerce, Crystal Reports, npm, Umbraco CMS, HTML5, HTTP, TCP/IP, XHTML, Perl, PHP, Laravel Framework, Zend Framework, Yii Framework, Wordpress, Wordpress Elementor, Wordpress Elementor Pro, Drupal, Django, Express Framework for Node.js, JavaScript, CSS 3, SASS, JQuery, Ajax, jqGrid, FrontPage, Dreamweaver, Flash, JSON, XML, Jasper report, Agile software development, JIRA, Kanban, S.O.L.I.D. Principles

Operating Systems

Windows, Mac OS X, iOS, Android, Unix, Linux, IBM OS/400, Windows Server 2008, Windows Server 2003

Mobile Development

iPhone, Android

Software Tools

Eclipse(for java and JUnit test), Visual Studio 2008, 2010, 2019(for C,C++,C#,VB, and unit test), VS Code, Apache, JFreeChart, AFreeChart, SVN(Subversion), GIT, Grunt, Gulp, SourceTree, bitbucket.com, Docker, UML, IBM Rational Rose, IBM Rational Developer for Power Systems(RDp), Borland C/C++, Microsoft Office, Photoshop, IBM iSeries, SQL Server 2008, ETL, SSIS, SSAS, SSRS, SQL Server Management Studio, data warehouse implemented by Microsoft SQL Server 2012

EDUCATION

Computer Programming and Analysis, Coop Diploma 2010 – 2013

Seneca College, Toronto (GPA - 3.70)

Biological Engineering, Master’s Degree 2000 - 2003

University of Georgia, Georgia, USA

Biochemical Engineering, Master’s Degree Candidate 1997 - 2000

East China University of Science and Technology, Shanghai, P. R. China

Biochemical Engineering, Bachelor’s degree 1992 - 1996

Hubei University of Technology, P. R. China

WORKING EXPERIENCE

Web Developer, Children Believe 2021.4-2024.3

https://donations.childrenbelieve.ca/

https://cb-production-applications.netlify.app/ecommerce-apps-runtime/index.js

https://childrenbelieve.ca/

I worked for the https://donations.childrenbelieve.ca C# .NET core website (based on NopCommerce) to add new features and fix bugs. A new user needs to call an API to get a token. Then this bearer token can be used for the following API calls. I also worked for a react and node.js web application to communicate with 2 websites and send data between these 2 websites. In addition, I also worked on company’s WordPress website and used the popular tool Elementor to build pages, templates, menus, headers, footers in a responsive format. PHP, MySQL, AJAX and Restful API are used for this website. For these 3 websites to run on my local computer and communicate with each other, I used XAMPP and virtual host to set up 3 localhost websites to run and debug. During the time, I used Azure repository, Azure platform, Azure board, Node.js, React js, C#, ASP.NET, .NET core, Linq, Bootstrap, SQL server, MySQL, PHP, WordPress, Elementor, jQuery, CSS for the projects. Azure cloud is used for source code and agile project management. Azure DevOps and gitlab are integrated for CI/CD. Netlify is used to host the react app website. Siteground is used to host the WordPress website, its FTP service and its MySql database. Rollbar.com is used to monitor websites’ errors. Postman is used to test the website’s API. Siteimprove.com is used to monitor WordPress website’s page formats. We use Azure to manage source code and deployment. I also worked on front end to implement Accessibility for Ontarians with Disability Act (AODA), Web Content Accessibility Guidelines (WCAG), and related regulations and standards.

Senior developer, Axiom Innovations 2018.11 – 2019.9

http://www.axiominnovations.com/

https://sso.dominionintranet.ca/?appId=10075&lan=en-ca&returnUrl=/Payroll/Receivables

https://workbench3.malink.ca:8509

https://sso.mymortgagecentre.com/?appId=10075&lan=en-ca&returnUrl=/

I created modules and maintained company’s clients’ web applications (see above, 3 websites). It’s a C# MVC web application with jQuery and Angular js as front end. Linq is used to query data from the database. These websites are for real estate companies to process payroll, deposit, receivable, expense, rebate and more. They get data from clients by ETL every day and save to database. They provide many APIs for clients to export data as an excel file and a JSON file. Telerik report is used for embedded pdf reporting. Telerik grid and jqGrid are used for grid and pagination. Bootstrap and Semantic UI are used for the front end. Also worked on one project with C#, React.js, and MongoDB for resources management. We use Azure and Team Foundation Server (TFS) to manage source code and deployment. I also worked on front end to implement Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards.

Web developer, MONEX Group 2017.6 – 2018.8

https://monexgroup.com/

MONEX group is the market leader in payment processing integration and merchant services. As a full stack web developer, I write C# code for the company’s inside dada processing website. Monex Group needs a website to create/edit contracts for customers. Everyday merchants get customers’ payment by using payment solutions for vending with contactless / chip and PIN options, debit card and credit card payment processing terminals (POS Systems). I also create C# code for reporting. Multi-threading is used for processing data fast. Cache is used for retrieving data fast. I write SQL and stored procedure to process different kinds of data. As to the front-end, the website uses Angular JS. For security reasons, the website uses LDAP to log in users in the company. Security is the most important thing to the company since we deal with confidential data. Also worked on a project with C#, React.js, and MongoDB for communication. I also worked on front end to implement Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards.

Web developer, CV Studio 2015.11 – 2017.5

http://www.unefi.com/

http://www.cvstudio.com/

http://rms.unefi.com/

As a full stack web developer, I created functionalities for the merchandising system which is used by big clients like Bell, Rogers, Telus, Starbucks, McDonald, Fido, WIND Mobile, etc. I also created a node.js responsive website to sync several Samsung smart TVs to start and replay different videos at the same time.

C# website:

Development Environment: IIS, .NET framework, Linq, Windows 7, C#, jQuery, AJAX, Angular js 2, CSS, Microsoft SQL Server.

Main responsibilities:

1.Work with solution architect and manger to design a fixture allocation and program management web application by using C#, .NET framework, Linq, jQuery, AJAX, and Microsoft SQL Server.

2.Design and develop pdf/csv report using C# library and show it on the web page using iframe.

3.Work with project manager to design the front end and the dashboard. Then use jQuery, AJAX, Bootstrap and Angular js to show data from database to the web page.

Node.js website:

Development Environment: Samsung Smart TV, Nginx, Sails framework, Linux Ubuntu, Node.js, jQuery, AJAX, Angular js 2, CSS, SASS, MySQL.

Main responsibilities:

1.Work with project manager to design a real-time node.js web application to sync 2 Samsung Smart TV’s videos at the same time and repeat again and again by using Node.js, websocket, Sails framework, jQuery, AJAX, and MySQL.

2.Using Samsung Smart TV’s own plugin and browser to show videos on the TV.

Web developer, AXIS Database Marketing Group 2014.1 – 2015.10

http://www.axisintegrated.ca/

The email on demand web application is used by a confidential client to let the users to design their email template and choose the email recipients. Then our email blaster application will send out emails to recipients and get their response: how many users opened their emails, how many users clicked their emails and the specific clicked url link, how many users unsubscribed the email, how many emails were dropped, how many emails were complained and how many emails were never sent to the recipient and the reason. We use jasper report to create a pdf file and jQuery and Angular js to create a dashboard for the client.

Development Environment: Tomcat, Eclipse, Maven, Spring, Hibernate, Java Concurrency, Angular js, MySQL.

Main responsibilities:

1.Work with solution architect to design application by using JSP, Spring Framework, Hibernate Framework.

2.Design and develop application report using Jasper report and show it on the web page using iframe.

3.Work with Business Analysts to design the front end and the dashboard. Then use jQuery, Bootstrap and Angularjs to show data from database to the web page.

The C# web application for brokers and realtors is used for Pillar and Post Agents to search, edit, add, and delete database records using .NET framework, MVC 4, Linq, Angularjs, Bootstrap, Restful web services, SPA (Single Page Application) and Razor engine. This website actually is a conversion from old VBA. The data was saved in Access database. Then the data was saved into Microsoft SQL Server database. An old VBA was changed to a modern web application. http://p2pagent.gouat.com

The Node.js web application uses sails.js framework to build a MVC website. It’s used to validate email addresses. Each time we send millions of email addresses to SMTP server to validate if it exists. We did it asynchronously, so it’s much faster than PHP, C#, Java application.

The PHP web application for Welcome Wagon is used for the company to create and edit sponsors and mailings. This project used MVC Restful web services, Angularjs, Yii framework and Bootstrap. http://wwmailapp.gouat.com

The PHP web application for Botox Clinics to create and edit coupons for their customers. This project used MVC, Zend framework, Angularjs, Bootstrap and MVC Restful web services. MPDF is used to create specific pdf file for clinics to enter customer information and print it out. http://botoxfit.gouat.com

co-op, Seneca Help Desk, Seneca College 2011 - 2012

Research Assistant, Massachusetts General Hospital, Boston, MA 2006 - 2010

Research Associate, Novartis, Boston, MA 2005 - 2006

Research Assistant, Harvard Medical School, Boston, MA 2003 - 2005

Brewing Engineer, San Miguel Corporation, Longjiang County, Guang Dong Province, P. R. China 1996 - 1997

INTERESTS & ACTIVITIES

Music, running, cooking, gardening and traveling.

References Available Upon Request

Contact this candidate