Sql Server .Net Developer

Cameron Cai

Contact no: 732-***-****

Email id: **************@*****.***

SUMMARY

Full-Stack Web Application .Net Developer with 5+ year’s background in diverse facets of .NET development, encompassing analysis, design, development, and execution of business applications.

Worked on both front-end and back-end web application design, implementation of object-oriented design with C#, software design patterns, service oriented architecture (SOA), Webform, MVC 5, N-tier architecture, relational database design and administration.

Proficiency in developing web applications using ASP.NET web forms, ASP.NET MVC 4/5, Web Services, Windows Communication Foundation (WCF) and ASP.NET Web API.

Extensive experience with object-oriented languages in Microsoft C#

Hands on experience of front-end development using open source framework AngularJS.

Extensive experience in front-end web development and design using HTML 5, CSS 3, and Twitter Bootstrap.

Comprehensive knowledge of interactive front-end web design using JavaScript, jQuery, client-side framework using AngularJS 1.5/1.6.

Knowledge in Database Design, Normalization, writing stored procedures, triggers, views and functions in SQL Server 2010/2012 and SSIS & SSRS Packages in MS SQL Management Studio.

Experienced in Object-relational mapping using ADO.NET, Entity Framework, and LINQ to SQL & LINQ to Object.

Proficient at Web Services, SOAP, XML, CSS 3, HTML, AJAX, and JavaScript.

Experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) to deliver data conversion, ETL solutions, and customised data reports.

Trained in both Agile and Waterfall SDLC methodologies.

Experienced with Software Configuration Management, Source Control, and Version Control using Team Foundation Server (TFS), and Git.

Experience in coordination and communication interacting with business users and technical developers

Knowledge in financial systems in different countries, including financial vehicles such as fixed equity, options, derivatives, insurance pooling, plus strategies for risk management.

Adapt to changing requirements in a fast-paced environment and multitask

TECHNICAL SKILLS

Web

HTML5, CSS 3, Bootstrap 3, AngularUI Bootstrap

JavaScript, jQuery, AngularJS 1.5/1.6

Programming

Microsoft C#, Java, Python 2.7, Python 3.5

.NET

ASP.NET Web Forms, ASP.NET MVC 5, Windows Forms, Web Services, WCF, Web AP, ADO.NET, Entity Framework 6, LINQ to Objects, Visual Studio 2015

Database

MS SQL Server 2012, T-SQL, PostgreSQL, SSIS, SSRS

Others

Git, TFS, SVN, XML, JSON, RESTful

EXPERIENCE

Fora Financial New York, NY

.NET Developer (MVC/Angular) Oct 2016 – Present

Fora Financial is a financial services company providing working capital to small and mid-size businesses nationwide in need of financing to sustain or grow their enterprise by providing innovative, customized, and flexible working capital solutions. The project was an internal management system hosted on the intranet, mainly for consultants and project managers to keep track of client portfolios, performance tracking and convenient report generation. The project was implemented using MVC utilising enterprise level N-tier architecture. Extensively contributed to implementing controllers and creating corresponding views to display data based on search results.

Roles and Responsibilities:

Development in C# and .NET Framework (.NET MVC 5, Razor)

Gather requirement and conduct analysis activities, develop use cases and create functional requirements specifications based on MVC architectural pattern.

Used Entity Framework for back-end data access - Database first approach, connected to the database with a layer of Repository and Unit of Work due to separation of concerns.

Front-end development using HTML, CSS, Bootstrap, JavaScript, jQuery and AJAX then shifted to Angular 1.5 later.

Used MVC to return data as JSON

Initially used AJAX to retrieve JSON data to populate tables, but later switched to Angular for binding using expression

Debug application, identify source of bugs in AngularJS code using Chrome plug-in Batarang and find fixes, refactor code to improve project readability and maintainability.

Implemented UI elements using jQuery plug-ins to create more dynamic and sleek looking customisation user interface

Involved in re-design of partial view shared layout in MVC for better view navigation and categorisation

Hand on experience in SQL Server Database design, worked with database team to develop T-SQL queries for dynamic SQL for AJAX calls using SQL Server 2012.

Incorporated data source connection with LINQ, Entity Framework and ADO.NET

Perform code reviews and performed unit testing.

Experience with Source Control Management using Team Foundation Server (TFS)

Developed and Integrated SQL Server Reports.

Prepared code documentation.

Environment: .NET Framework 4.0, C#, ASP.NET MVC 5, MS SQL Server 2012, HTML, CSS, JavaScript, jQuery, Bootstrap, AJAX, TFS, AngularJS 1

Infobase Holdings New York, NY

Web Developer (MVC) Feb 2015 – Aug 2016

Infobase Holdings, Inc is a privately held holding company focused primarily on providing cloud-based educational and vocational information services to the K–12, academic, and public library markets. Infobase Holdings sells educational materials, using an intra-web to link sales options across its international subsidiaries. The project utilizes .Net MVC 4/5 with JavaScript and jQuery libraries for interactive elements such as range sliders and Modal pop-up menus, creating an interface with highly customisable options for sales and marketing personnel to pick combinations of items to create price quotes to help create sale pitches to clients.

Roles and Responsibilities:

Experience with Agile development practices and Scrum methodology

Developed ASP.NET MVC application using MVC4/5 Layout with Entity Framework.

Extensively used JavaScript and jQuery to implement interactive components such as custom sliders and Modal pop-ups for user UI.

Used HTML5, XAML, XML, CSS3, Bootstrap and JavaScript, JSON to develop and implement a user-friendly UI design and for functionality, using MVC5 C# programming presentation and provided web security for the application (providing authentication and authorization) using data annotation.

Developed multi-tier web application with the use of Web Services Restful web services using ASP.Net Web API.

Implemented ASP.NET Web API services to return JSON and XML Format.

Used Entity Framework as the Data Access Layer (Database First) and implemented data objects, Mapping and executed stored procedures through dbContext and dbSet.

Used Agile Solid Principles, Control templates, Data templates.

Created SSIS Packages as per the requirements.

Performed Code Reviews of Team Members work.

Interact with Traders, Project managers and Business Analyst to resolve any issue in timely manner and keep everyone informed on the status of the project.

Environment: ASP.NET, C#.NET, SQL Server 2012, ASP.NET MVC 4/5, Web Services Restful Web API, JavaScript, Bootstrap, jQuery, Visual Studio 2013/2015, Entity Framework 4.0

Evercore Partners New York, NY

Junior .Net Developer (ASP Webform) Jan 2014 – Feb 2015

Evercore is a premier independent investment banking advisory firm providing services to leading multinational corporations, large institutional investors and financial sponsors, and high net worth individuals. Project was to develop an application called Request Centre, which allowed brokers to submit requests for funded quotes and enrolment applications.

Roles and Responsibilities:

Design Webform pages for both display and server processing using .Net framework, transitioning to MVC 4

Developed WebForms using C# and ASP.NET WebForm.

Worked with DataAdapter, DataSet, DataReader as a part of ADO.NET to access database

Implemented GridViews sorting and paging

Front-end development with HTML, CSS, JavaScript, jQuery and Bootstrap

Debugging for HTML, and C# code

Helped develop SQL views for reports

Helped develop user functions and stored procedures for T-SQL in MS SQL Management Studio 2012

Worked with common export file formats in MS Office suite such as Microsoft Excel, Word and Access

Managed Source Control using Shared Point

Environment: .NET Framework, C#, ASP.NET MVC 4, MS SQL Server 2012, HTML, CSS, JavaScript, jQuery, Bootstrap

Parker, Smith, & Feek, Inc. Bellevue, WA

Junior .NET Developer (ASP WebForm) Oct 2012 - Nov 2013

Parker, Smith, & Feek, Inc. is an insurance and risk management brokerage firm. Job scope included development and ongoing maintenance for high availability web-based content delivery applications developed in .NET with a chance to occasionally help develop SQL queries. Set in cross-functional teams with requirement to communicate well with non-technical people inside and outside of the company.

Roles and Responsibilities:

Development in C# and .NET Framework (ASP.NET WebForms)

Front-end experience in jQuery, JavaScript, HTML 5, Bootstrap and CSS 3

Experience in queries development using T-SQL and Microsoft SQL Server 2012

Data conversion using ETL process

Communication and coordination across departments and external vendors

Develop and maintain online reports and ad-hoc reports to meet the reporting needs of all departments.

Respond to issues relating to applications and database errors and correct them on a timely basis so systems are operating at peak efficiency.

Maintain documentation that assists with identification and correction of issues, maintenance of the database, deltas to all applications and all other assigned documentation maintenance.

Work with supervisor and independently to provide technology and technical support for clients/carriers to supply access to policy information, project tracking, document collaboration, request systems and new applications.

Source Control Management using TFS

Environment: .NET Framework 3.5, C#, ASP.NET WebForms, MS SQL Server 2012, HTML, CSS, JavaScript, jQuery, Bootstrap, AJAX

EDUCATION

Master of Computer Science, New York Institute of Technology (NYIT), NY

Bachelor of Creative Industries in Communication Design, Queensland University of Technology (QUT), Australia

Contact this candidate