Post Job Free

Resume

Sign in

.Net Sql Server

Location:
Sterling, VA
Posted:
November 02, 2016

Contact this candidate

Resume:

Carrie Xia

Email: acxcpw@r.postjobfree.com

t :650-***-****

Summary:

* ***** ** ********** ** software design and development. Experience using ASP.NET MVC 5.0/4.0, ASP.NET 4.5/3.5/3.0, C#, .NET Framework 4.5, WCF 4.0/3.5, WebAPI, XML, CSS3, AJAX, JavaScript, JQuery, HTML5, and SQL Server 2012/2008R2, SSRS, SSIS, JSON, ASP.NET Web Services, Sharepiont2013, Angular JS, Knockout JS.

Strong knowledge in OOP (Object Oriented Programming), good Coding Practices, Design and Analysis.

Experienced in Rapid Application Development implementation.

Experienced in Web and Desktop Applications development with .NET in different Frameworks versions like: 4.5, 3.5, 3.0 and 2.0.

Skilled using databases such as Microsoft SQL Server2012/2008 and Oracle 10g.

Strong knowledge in implementing N-Tier architecture applications and SOA (Service Oriented Architecture) based services.

Implemented client-side interfaces with JavaScript Technologies like JQuery.

Experienced in asynchronous programming and data retrieval with Ajax requests, handling information in JSON and XML format.

Experience building, managing Web Applications using ASP.NET Web Forms and MVC (Razor/ASPX engine), HTML, CSS, jQuery.

Worked extensively with ADO.NET, LINQ, WCF, Entity Framework and Lambda Expressions.

Proficient in LINQ for data retrieval, CRUD operations, data filtering, sorting, among others.

Skilled in writing SQL Queries, Stored Procedures, Views, Triggers. Also implementing Transactions and Error Handling (try-catch) when needed in database Store Procedures. Using SQL Server 2012.

Worked with Tabular reports, Matrix reports, Parameterized Reports as well as Drill down Reports using SQL Server Reporting Services (SSRS). Package creation and data conversion through SQL Server Integration Services (SSIS).

Hands on various Object Relational Mapping (ORM) technologies such as ADO.NET Entity Framework and LINQ to SQL.

Skilled with Sharepoint Provider Hosted apps build, configuration settings and SharePoint Client application

Great experience in all SDLC cycles, document requirements of all the SDLC phases, designed and developed software applications/services with given requirements, timeliness and quality.

Experience using Agile, and Waterfall methodologies.

Technical Proficiency:

Languages : C#, T-SQL, and PL/SQL.

Internet Technologies : ASP.NET, ASP.NET MVC, WebAPI, Sharepoint2013, JQuery, JSON, and CSS.

Databases : Oracle 11g/10g/9i, MS-SQL Server 2008, DB2.

Scripting Technologies : VB Script, Java Script

Markup Languages : XML,HTML.

Enterprize Servers : IIS.

Configuration Management : SVN,TFS, VSS 6.0

Testing Tools : NUNIT, VS.NET Testing

Professional Experience:

Project

ACCESS IFC

Client

World Bank Group International Finance Corporation(IFC)

Duration

Jan 2016 - Till Date

Description

ACCESS IFC is an external investment portal for clients and partners to communicate with internal users about investment projects, teams and product. It is mainly composed of three parts, one is WebAPI services, one is file upload MVC applications, one is SharePoint provider hosted apps. This product is used to allow external users to upload multiple documents with their personal details and internal users to review those documents with authorization. The webapi services consume some internal IPortal api services and are consumed by ESB services, which are also IFC IPortal system components. As for security purpose, WebAPI services are under ADFS protection and provider hosted apps are under windows authentication and ADFS authentication.

Role & Responsibilities

As a Senior Developer

Designed and developed rich and enhanced web applications using MVC 5.0, WebAPI, C#, SharePoint2010, JSON, HTML 5, CSS3, Bootstrap, JQuery and Angular JS.

Built web services like CRUD services using ASP.NET Web API 2.0.

Consume WebAPI services by using AJAX call and service call to integrate with different internal system.

Built JSON structure and generated JSON output based on requirements

Integrated MVC application with SharePoint to build a provider hosted app

Uploaded and extracted data from document library and list library using SharePoint Client code, lazing loading

Implemented Sharepoint configuration settings for DEV and QA environment

Designed and implemented UI for the application using ASP.NET MVC 5.0 Razor, JQuery, Angular JS and Bootstrap

Implemented .NET classes for business logic layer using C# and used ADO.NET to implement data access layer.

Managed Oracle/PL SQL database and wrote queries, stored procedures and triggers.

Used ADO.NET to integrate database and business layer.

Used Postman to test WebAPI post and get methods.

Used TFS for source control and JIRA for task management

Implemented design pattern, like dependency injection in Web API application

Implemented SharePoint server environment settings, like lists and document library.

Set up environment in SharePoint 2013 for provider hosted apps

Team Size

8

Environment

.NET 4.5, VS.NET 2013, ASP.NET, ASP.NET MVC 5.0, WebAPI, SharePoint2013, AJAX, JQuery, JavaScript, AngularJS, JIRA, WCF, LINQ, WCF, C#, MS Unit, Agile Scrum and TFS.

Project

Ready! Set! Go!

Client

International Association of Fire Chief (IAFC)

Duration

Dec 2015 - Jan 2016

Description

Ready! Set! Go! Is a web application that allow internal staff to view all fire association details around the world. Internal user can also add and delete users and projects for each associations.

Role & Responsibilities

As a Senior Developer

Designed and developed rich and enhanced web pages using MVC 5.0, C#, Entity Framework, JSON, HTML5, CSS3, JQuery, Knockout.

Designed and implemented presentation layer for the application using ASP.NET MVC 5.0, Knockout JQuery.

Consumed services by using JQuery AJAX call and rendering through JSON.

Implemented .NET classes for business logic layer using C# and used Entity Framework to implement data access layer.

Managed Microsoft SQL Server database and wrote queries, stored procedures and triggers.

Used ADO.NET to integrate database and business layer.

Used Knockout JS to bind data with UI

Implemented UI using Knockout JS, HTML, css

Used GitHub for source control.

Wrote LINQ queries in MVC controller.

Team Size

3

Environment

.NET 4.5, VS.NET 2013, ASP.NET, ASP.NET MVC 5.0, AJAX, JQuery, JavaScript, Knockout JS, WCF, LINQ, WCF, C#, MS Unit, Agile Scrum and GitHub.

Project

ABC PLUS

Client

South Carolina Department of Social Services (SCDSS)

Duration

Jan 2015 - Nov 2015

Description

SC Voucher (previously named ABC Voucher) makes payments to child care providers to care for children from low-income families so their parents can work. It allows the employees of SC HHS to manage the complete program. It has 3 different sections one for the applicant to apply for the SC Voucher program, one for Child Care Providers to register with the program to provide the services and third where the internal employees of HHS will review the applications from applicants for SC Voucher program and approve them based on different state rules. The staff also can review and approve the applications form Child Care Providers . Using this system child care providers will submits the bills for the services provided and staff can approves the payments

Role & Responsibilities

As a Senior Developer

Designed and developed rich and enhanced web pages using MVC 5.0, C#, Entity Framework, JSON, HTML 5, CSS3, JQuery and JQuery UI.

Designed and implemented presentation layer for the application using ASP.NET MVC 5.0, HTML Controls, JavaScript, JQuery and CSS.

Used MVC framework for developing the application as it will distribute the development in Model, Views and Controllers and also it supports stateless development.

Implemented .Net classes for Business logic Layer using C# and used Entity Framework to implement data access layer.

Developed the independent Windows Communication Foundation (WCF) services and defined Service Contracts for specific functionality.

Hands on experience on implementing AJAX functionalities for partial page rendering through JSON.

Writing the JavaScript, JQuery, JQuery UI, JSON and Ajax to handling the client side validations and dynamic page updates.

Designed and developed web application using Microsoft. Net technologies, Web layer with ASP.NET and business layer with C#, Data access layer with ADO.NET entity framework advanced functionality and Microsoft SQL Server 2012.

Exposed and consumed WCF Services to integrate with different vendor systems.

Created and maintained database objects like complex Stored Procedures, Triggers, and Tables, Views and SQL Joins.

Worked on .NET security features such as Form-Based Authentication and Role-Based Authorization.

Created design documents and test cases for development work.

Team Size

10

Environment

.NET 4.5, VS.NET 2013, ASP.NET, ASP.NET MVC 5.0, AJAX, JQuery, JavaScript, JIRA, WCF, LINQ, XML, XSD, Entity Framework, WCF, C#, MS Unit, Agile Scrum and TDD.

Project

ALLERTEK APPLICATION

Client

Segue Technologies Inc., Alexandria, VA

Duration

Aug 2013 - Dec 2014

Description

Application is to provide an application that will assist Allertek practitioners in the testing for and treatment of sensitivity to various allergens. This application assists Allertek practitioners in testing for and treatment of sensitivity to various allergens. This system allows practitioners to record client- and treatment-specific information and also a reporting system which will house all allergen definitions and key patient metrics.

Role

As a Developer

Developed application using C#, ASP.NET, ADO.NET.

Involved in understanding and transmitting the business requirements for the project, and translating these into functional specifications

Directly accountable for various aspects of product design including assessment, coding, testing and optimization. Involved in code review and performance improvement as well as documentation.

Extensively worked on ADO.NET using Data Adapter, Data Readers and Data Sets.

Used .NET Validation Controls for server side validations and JavaScript client side validation.

Implemented Queries using LINQ for effective access with database and easy handle of file operations and XML.

Used LINQ to Entities, LINQ to Dataset to collaborate the domain and integration objects with the view objects.

Involved in fixing bugs based on the client requirements and worked on the enhancements for the web pages, scripts and stored procedures.

Implemented AJAX Update Panel with the Script Manager Control to enable partial page rendering.

Team Size

18

Environment

NET Framework 4.0, Visual Studio 2010, ASP.Net, ADO.NET, SOAP, WCF Services, AJAX, SQL Server 2008, JavaScript, HTML, CSS & TFS.

Project

Metal Product Quality Control Inspection System

Client

Tewoo Group Company Limited - Beijing, CHINA

Description

Tewoo Group is the largest state-owned material circulation enterprise in Tianjin, China. Metal Product Quality Control Inspection System is an Ecommerce web application developed to check the quality of the products before accepting new products and delivering them to the end users. Inspection results would be received in a data feed from inspection firms and some inspections are conducted internally by Tewoo Group.

Duration

Aug 2011 – Oct 2013

Role

Implemented abstract, sealed classes, interfaces and classes to construct the business and data tier using C# and ADO.NET.

Used 3-tier architecture to handle the business logic which requires heavy traffic with server.

Developed Web Services to auto populate the dropdown items based on the selection of an item in another dropdown.

Used ADO.NET components like Data Adapter, Data Reader and Dataset.

Used ADO.NET to communicate the database, wrote complex Queries, Stored Procedures and Triggers.

Used SSRS for generating Reports.

Used AJAX coding techniques to update parts of a web page and developed.

Designed and developed Stored Procedures, tables and views, Used SQL Server as database.

Actively involved in Code-Reviews & Coding Standards, Unit testing & Integration Testing.

Team Size

25

Environment

Visual Studio 2008, C#, ASP.NET, ADO.NET, HTML, CSS, AJAX, JavaScript, JQuery, Web Services, SQL Server 2008.

Project

PAMS (Portfolio Analysis and Management System)

Client

Misys Financial Systems - Beijing, CHINA

Description

Misys provide deepest portfolio of financial services software on the market. Solutions cover retail and corporate banking, lending, treasury, capital markets, investment management and enterprise risk. This project mainly developed for customized features for Summit (A software solution for treasury and capital markets) clients from Hong Kong and London. Treasury Management includes a firm's collections, disbursements, concentration, investment and funding activities

Duration

Aug 2009 – July 2011

Role

Involved in development of Web Form, Classes using C#.NET that incorporates both N-tier Architecture and database connectivity.

Used ADO.NET technology in accessing Database with Data Controls, Parameterized Queries using Datasets, Data Tables, Data Views and Connection, Command objects.

Wrote event based code in C# using server controls like Grid View and Data List.

Created Web services to interact with the License Server and to update the local database periodically.

Written stored procedures, user defined functions, views and Triggers for data layer of the application in various databases.

Development of enterprise reports by pulling data from various sources and presenting in SQL Server Reporting Services (SSRS).

Prepared unit test cases and performed Unit testing prior to system implementation.

Team Size

12

Environment

C#, ASP.NET Web Forms, Custom/User Controls, IIS, ADO.NET, Web Services, HTML, CSS, SQL Server 2005, Visual Studio 2008, Visual Source Safe.



Contact this candidate