Data Web

Christopher Tian

Email Id: ******************@*****.*** Phone No: 703-***-****

Summary

●7+ years of experience in all phases of Software Development Life Cycle (SDLC) with concentration in design, analysis, development and implementation of client server architecture applications using Microsoft technologies.

●Developed n-tier web applications in .NET environment using C#, MVC 5, Web API 2, Entity Framework, Web Forms, ADO.NET, AJAX, LINQ, Visual Studio, SQL Server, .NET Framework and WCF.

●Experience in designing web pages with Angular 4, AngularJS, Bootstrap, HTML5, JavaScript, CSS3, Web Services and jQuery in a hand-coded environment.

●Profound knowledge of Angular 4 concepts like dependency injection, promises, services, scopes, controllers and directives.

●Working with Angular 4 such as building nested components, interpolation, data binding & creating pipes, building and testing with CLI.

●Expertise in creating stored procedures, T-SQL queries, functions, triggers, indexes, transactions, views and constraints.

●Solid understanding of the REST architectural style and building RESTful Web APIs.

●Working experience on Entity Framework in both Code First and Database First Approaches and experience in Code First Migrations.

●Proficient in debugging and performance testing of RESTful Web APIs using tools such as Fiddler and Postman.

●Experienced in Angular testing frameworks Karma & Jasmine to unit test components.

●Experience in writing test cases to test the Libraries/Components written in C# using NUnit, MOQ and MS Unit.

●Working experience in Agile methodologies, Waterfall model as software development life cycle models.

●Working knowledge of using project management tools, version control tools including Team Foundation Server (TFS), SVN, JIRA and GIT.

●Highly proficient in working with users to gather requirements, a good team player with strong interpersonal and presentation skills.

Technical Skills

Languages

●C#

●HTML5

●CSS3

●JavaScript

●T-SQL

●PL/SQL

●C, C++

●Java

Frameworks/Libraries

●ASP.NET MVC 5

●Angular 4

●LINQ

●Entity Framework

●jQuery

●AngularJS

●WCF

●Azure

●Web API 2

●Jasmine, Karma

●Web Forms

●ADO.NET

●Bootstrap

Databases/Concepts/Others

●VS Code

●Microsoft Visual Studio 2010/2012/2013/2015

●Agile/Scrum methodologies

●SQL Server 2008/2012/2014

●Client/Server Architecture

●TFS, SVN, GIT

●Postman, Fiddler

●Excel VBA

Work Experience

Client: Verisk Analytics Jersey City, NJ

Project: LightSpeed Property Jan 2019 to May 2019

Description: Verisk Analytics, Inc. is an American data analytics and risk assessment firm based in Jersey City, New Jersey, United States, serving customers worldwide in insurance, natural resources, financial services, government, and risk management. The LightSpeed Property project aims in building an AWS Lambda RESTful API to provide property-related data to our customer in a timely fashion. The data comes from three sources and each needed a functional API.

Responsibilities:

Used C# .NET Framework to process CSV data through Melissa address scrubber and SSA to generate collections of SSA keys. Helped with creating the template and loading data to Elasticsearch database in AWS S3 buckets.

Wrote queries to analyze and verify data in Elasticsearch using Kibana development console.

Used C# .NET Core to design XSD schemas and data models for HTTP requests and responses as per business requirement. Created domain models for other data objects.

Created repositories and DAOs to fetch data from Elasticsearch using asynchronous tasks to improve performance.

Built a serverless vendor API as a data pump and implemented error handling with corresponding HTTP status codes (400s, 500s). Participated in building the project API which integrates all data from three vendor APIs.

Implemented Factory design pattern - used Dependency Injection to determine which concrete class to use.

Added transaction logging and performance tracing using AWS SQS and X-Ray Recorder.

Created server-side unit tests using Microsoft test tools and NUnit framework.

Used Postman to manage and mock HTTP requests and analyze responses in order to debug/test the code.

Used SourceTree, Stash (Bitbucket) for version control, JIRA, and Bamboo/Octopus for Continuous Delivery to Test/Accp/UAT/Prod environments.

Environment: Elasticsearch, Kibana, C#, ASP.NET Core, Web API, Visual Studio 2017, Postman, Git, SourceTree, Stash (Bitbucket), JIRA, Bamboo, Octopus.

Client: Chipotle Mexican Grill Denver, CO

Project: Internal Applications Aug 2018 to Jan 2019

Description: Chipotle Mexican Grill, Inc. is an American chain of fast casual restaurants in the United States, United Kingdom, Canada, Germany, and France, specializing in tacos and mission-style burritos. It is one of the first chains of fast casual dining establishments. In May 2018, Chipotle announced the relocation of their corporate headquarters to Newport Beach, CA. Chipotle’s internal applications include Benefits Hub, Online Order Manager, Restaurant Data Manager, Workday Integration, and so on. They are frequently used by Chipotle’s employees as well as the customer service and business management team, thus are crucial to Chipotle’s business.

Responsibilities:

Used C# to create models, repositories, services and controllers, and LINQ to implement business logic.

Utilized Entity Framework to realize object-relational mapping with data in SQL server database, and

responsible for designing database objects like tables, indexes, stored procedures and user-defined functions.

Created RESTful ASP.NET Web API services including HTTP get, post and delete methods with conventional and attribute routing.

Used AngularJS to design and create controllers, services, modules, directives and for web applications.

Utilized AngularJS $http service to get service request from the server and process JSON data.

Utilized AngularJS routing to create a seamless navigation and Bootstrap to implement both server-side and in-memory pagination.

Used HTML5, CSS3 and Bootstrap to create new user interface and enhance user experience.

For web applications, used Chrome development tools for designing, smoke testing and debugging.

Updated server-side unit tests and integration tests using C#, and client-side unit tests using AngularJS and Jasmine.

Used Git and TFS for version control and code reviews.

Involved in sprint planning and grooming meetings through Rally and daily stand-up meetings, as well as code deployment for QA testing and preparing the release notes.

Environment: C#, Entity Framework 6, ASP.NET Web API 2, AngularJS, JavaScript, HTML5, CSS3, Bootstrap, Visual Studio 2017, Postman, Jasmine, SQL Server Management Studio 2017, GIT and TFS.

Client: Citizens Financial Group Providence, RI

Project: Claim Administrator Nov 2017 to June 2018

Description: Citizens Financial Group, Inc. is an American bank headquartered in Providence, Rhode Island, which operates in the states of CT, DE, MA, NH, NJ, NY, OH, PA, RI and VT. It operates more than 1,200 branches and approximately 3,200 ATMs across 11 states under the Citizens Bank brand. Claim Administrator is a streamline internal claims management system that allows you to manage all your claim files as well as your organization. It offers solutions for independent adjusting agencies, third party administrators, self-insured companies, public entities, and more. Managing a claim through Claim Administrator is easy and intuitive. It offers custom built step-by-step workflow that is geared for speed and simplicity. Our automated process allows you to manage your claims better.

Responsibilities

●Designed and developed the application using Angular 4 along with Bootstrap, JavaScript, HTML5, CSS3 and Typescript.

●Used TypeScript to write the Angular components, modules, services and models.

●Utilized Angular 4 routing and configured the routes to allow a seamless navigation.

●Implemented Angular 4 pipes such as date, string length slice and number.

●Used Angular 4 HttpClient service to get data from Web API and process JSON data to render in the UI.

●Created Typescript reusable components and services to consume REST APIs using component-based architecture provided by Angular 4.

●Used Angular to perform client-side validations and data annotation to validate the values at server side.

●Utilized Entity Framework 6 to realize Object-Relational Mapping with data in SQL server database and responsible to design the database objects like tables, indexes, constraints, procedures and user defined functions.

●Created RESTful ASP.NET Web API services including HTTP get, post, delete and put method with both convention-based routing and attribute routing so that users can interact with the server and get result from it.

●Used Jasmine and Chrome Developer tools for testing and debugging.

●Utilized Postman/Fiddler for testing the developed Web API HttpClient services and in the authentication process.

●Used GIT for version controlling and document collaboration tool.

Environment: C#, Angular 4, TypeScript, VS Code, HTML5, CSS3, JavaScript, Entity Framework 6, Web API 2, ASP.NET, Visual Studio 2015, Postman, GIT, Jasmine, Fiddler, SQL Server 2016, Azure and Bootstrap.

Client: Centreville Bank Providence, RI

Project: Digital Asset Management System Sept 2016 to Oct 2017

Description: Digital Asset Management System is used to track, manage and store documents and reduce paper. This application is capable to organize, tag, find, share, edit and download all your digital files quickly, easily and securely. Online chats and sharing support centralized, collaborative working with internal teams and external partners.

Responsibilities

●Designed and developed the application using Entity Framework, LINQ, C#, AngularJS, Web API, Bootstrap, JavaScript, HTML, CSS.

●Implemented many directives from AngularJS in order to create all the functionalities related to the user interface, creating models and controllers with the help of JavaScript.

●Worked on services like $location to get information about location of current webpage, $http to get service request from the server in AngularJS.

●Utilized $broadcast, $emit, $on and $rootscope to pass data between controllers.

●Developed custom-form validation using built-in Angular form properties such as $valid, $invalid, $pristine and $dirty.

●Developed pages using components such as Bootstrap grid, scheduler, tabs and other input components and used HTML and CSS for an improved organization of style sheets.

●Developed generalized script functions written in JavaScript which are used throughout the application.

●Developed multiple Web APIs that serves login, registration and user settings functionalities for all dependent applications.

●Used Entity Framework for ORM mapping to relational databases, classes to database tables and CLR data types to SQL server data types.

●Implemented tests on the Web API using Fiddler/Postman web debugging proxy.

●Involved in scrum meetings, sprint reviews to better design a develop use cases and user stories in an efficient way.

Environment: C#, Visual Studio 2015, AngularJS, Web API, Bootstrap, JavaScript, HTML5, CSS3, Agile, Entity Framework, SQL Server 2014, Fiddler, Postman, and User Stories.

Client: Maanshan Iron & Steel Hefei, China

Project: Discrete Manufacturing Execution System Jan 2015 to May 2016

Description: Maanshan Iron & Steel is China's ninth largest steel producer, better known as Masteel, turns out 8 million tons of steel annually, 80% of which are of international grade. It has 44,104 employees. Discrete Manufacturing Execution System is designed to give better control of and visibility into the manufacturing process. It focuses on reducing costs by limiting waste and reducing time to produce the product. A typical system will implement a lean manufacturing philosophy, matching the inflow of parts, materials and subassemblies with the production of finished goods. This application contains the modules like Resource Management, Supplier Management, Quality Control and Reporting.

Responsibilities

●Involved in Software Development Life Cycle (SDLC) including analysis, design, development, and testing of the project.

●Developed application using C#, ASP.NET MVC 5, JavaScript, jQuery, HTML, CSS, WCF, LINQ, Entity Framework.

●Developed MVC Razor views, partial views, layout pages, controllers, helper methods, views and models.

●Used Microsoft Entity Framework Code First Approach for the data access layer and defined entities that are used for data access MVC 5 application.

●Implemented client-side validations using jQuery and ASP.NET MVC validation implemented at Model attribute.

●Applied JavaScript to minimize the number of page refresh and used themes and CSS styles for UI design of web pages.

●Implemented WCF service and developed asynchronous callback methods in class library project to communicate with different layers of the solution.

●Performed unit testing modules according to the requirements and development standards with NUnit testing.

●Used Tortoise SVN to maintain different versions of source code.

●Used JIRA for bug analysis and fixes in web-industry standards.

Environment: C#, Visual Studio 2013, WCF, Entity Framework, JavaScript, jQuery, LINQ, NUNIT, ASP.NET MVC5, SVN, JIRA.

Client: Anhui Ankai Automobile Hefei, China

Project: Production Planning and Control System Oct 2013 to Dec 2014

Description: Anhui Ankai Automobile Co., Ltd. is a Chinese automotive manufacturing company headquartered in Hefei, Anhui, which specializes in the production of buses and coaches. Ankai's products include urban buses, regular coaches, sleeping berth coaches, bus and coach chassis and automotive components. Production Planning and Control System ensures that at the time of production right quality and quantity of raw materials, equipment, etc. are available to complete production process and utilization of resources is always ready to meet demands at all time. This application has multiple modules, which are Inventory and Stock Control, Estimating, Sales Order, Quality Management, Customer Relationship Management, Delivery Recording and Job Costing.

Responsibilities

●Actively involved in all phases of application lifecycle development following Agile Methodology.

●Developed business logic layer by implementing Object Oriented Programming Language. Designed and created dynamic web pages using HTML, jQuery, JavaScript, CSS, Bootstrap, Entity Framework, C# & ASP.NET MVC.

●Designed the application using MVC (Model View Controller) Architecture that establishes a clear separation of data access layer, business logic layer and presentation layer.

●Worked with action filters in MVC for error handling and custom authorization filter for different levels for the application.

●Developed design pattern such as unit of work, repository, implemented dependency injection using dependency resolver in MVC.

●Used jQuery as it is a lightweight JavaScript library that emphasizes interaction between JavaScript and HTML.

●Performed client-side validation using Unobtrusive JavaScript.

●Generated new and edited existing user interface with CSS to accommodate new changes in design and logic.

●Implemented the data access layer using LINQ to Entities and used Entity Framework Database First Approach to perform CRUD operations.

●Designed and developed WCF web service and configured the web service with appropriate endpoints for consuming them in web application.

●Created and maintained database objects like complex stored procedures, triggers, tables, views and SQL joins.

●Used SVN for all the source code maintenance among the whole team members.

Environment: ASP.NET MVC, C#.NET, HTML, JavaScript, jQuery, LINQ, AJAX, Visual Studio, SQL Server 2012, Entity Framework, Bootstrap, WCF, Agile, CSS, SQL Server 2012, SVN.

Client: JAC Motors Hefei, China

Project: Statistical Process Control June 2012 to Sept 2013

Description: JAC Motors is a Chinese state-owned automobile and commercial vehicle manufacturer. The company is based in Hefei, Anhui Province, China. The company produced about 445,000 units per year. Statistical Process Control is an internal application for monitoring and controlling quality during the manufacturing process. It is a process to optimize product quality and process efficiency, reduce the cost of compliance, and enhance manufacturing visibility across the product life cycle and supply chain. This application has multiple modules, which are Point-of-Production Analysis, Regulatory Compliance, Real Time Data Collection, Data Management, Data Entry, Corrective Actions, Data Linking, Performance Metrics and Excel Loader.

Responsibilities

●Developed UI using HTML, CSS and JavaScript.

●Designed and developed ASP.NET User Controls and used ASP.NET Web Forms controls.

●Developed Web Forms using ASP.NET under Visual Studio .NET environment.

●Developed Web Forms for user interfaces using ASP.NET and C#.NET using Server Controls, HTML Controls and User Controls.

●The coding of the application was in C# using an n-tier architecture consisting of presentation layer, data access layer and database layer.

●Used data adapter, data command, data set, data table, data relations and constraints for database access.

●Designing and developing stored procedures and functions in SQL Server 2008.

Environment: Visual Studio 2010, ASP.NET, HTML, CSS, Web Forms, C#.NET, JavaScript, SQL Server 2008.

Contact this candidate