SUMMARY

• 10 years of experience as a .NET and SQL Server developer.
• Building web applications using ASP.NET Web Forms, ASP.NET MVC, and AngularJS.
• Experience using HTML, CSS3, JavaScript, jQuery, and AJAX to create web applications.
• Proficient with, ADO.NET, Entity Framework, LINQ to connect to data sources.
• Work experience creating single page applications using AngularJS.
• Experience implementing the N - Tier Architecture Service oriented Architecture - Data Access Layer (DAL), Business Logic Layer (BLL), and User Interface (UI).
• Experience designing, developing and maintaining database applications using SQL Server 2005/2008/2008 R2/2012.
• Experience writing SQL Queries, Stored Procedures, Views and Functions, creating objects in MS SQL Server 2005/2008/2012 environments.
• Skilled with SQL Server query optimization and indexing tuning.
• Experienced in MS Access and data migration from MS Access to SQL Server.
• Works well under pressure as part of a team.
• Proven ability to identify, analyze, and solve problems.

TECHNICAL SKILLS

Operating Systems: Windows Server 2000/2003/2008 , Windows XP/7/8

Programming Languages: C#, T-SQL, SQL, HTML, CSS, JavaScript, XML, VBA

Technologies: ADO.NET, Entity Framework, WCF, WebAPI, LINQ

Web Technologies: ASP.NET Web Forms, ASP.NET MVC, HTML, XML, CSS, AJAX, JavaScript, AngularJS, jQuery

Databases: SQL Server 2005/2008/2012 , MS Access

Software: MS Visual Studio 12/15, SQL Server 2012/2008R2/2008/2005, SQL Server management studio, SQL Server Profiler, Sqlcmd, SSIS, Adobe Photoshop/Illustrator/Dreamweaver, Corel Draw.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

AngularJS, C#, SQL Developer

Responsibilities:

• Actively participated in the development of the server-side web application, which is utilized by authorized users to retrieve and transform database data in EDI format to the company database.
• Created WCF Web services which were used to develop a set of services allowing the UI to connect to DB.
• Developed an interface for a server-side web application using ASP.NET 4.0 MVC, HTML, CSS, JavaScript and AJAX Controls in Visual Studio 2012.
• Utilized ADO.NET with C# in Visual Studio 2012 to establish connections between server-side web application and a Microsoft SQL Server 2012 database.
• AJAX utilized to connect to RESTful web services.
• Participated in the designing of dashboard single page application using AngularJS.
• AngularJS was utilized for user-friendly CRUD functionality.
• Utilized AngularJS Routing to attach the views for a single page approach.
• Wrote AngularJS controllers, views, and directives for application features.
• Created Tables, Views and Stored Procedures in Microsoft SQL Server 2012.
• Analyzed, designed, coded and documented new features and ensured full functionality and successful integration.
• Created CSS classes for designing Views for Dashboard and Reporting.

Environment: AngularJS, ASP.NET, WCF, ASP MVC 4, AngularJS, C#, HTML5, CSS3, Microsoft SQL Server 2012, Visual Studio 2012, jQuery

Confidential, Philadelphia, PA

AngularJS, C#, SQL Server Developer

Responsibilities:

• Designed application using AngularJS.
• Connected to a database using an ADO.NET Entity Framework model.
• Utilized a customized WebAPI for connection between application and database.
• All modification to the database completed through AJAX calls, utilizing JSON data.
• Real-time sorting using several different customizable fields, such as sorting by column, ascending or descending order, and a search bar that searched text throughout all fields in an entry for a match.
• Specialized routing allowed the application to be a Single Page Application.
• Angular service factory allowed retrieving data from the database quickly.
• Data populated via an Angular Repeater pattern (ng-repeat).
• Created customized Directives to display company productes.
• Built in CSS Styles applied to give the application a modernized look.

Environment: AngularJS, JavaScript, jQuery, Entity Framework, ASP.NET WebAPI, HTML, CSS, SQL Server 2012, SQL Server Management Studio (SSMS), Visual Studio 2012

Confidential, Pendleton, IN

.NET C#, SQL Developer

Responsibilities:

• Developed the application using ASP.NET MVC 4.
• Developed a Graphical User Interface (GUI) for the server-side web application using Razor View/jQuery widgets, CSS3, and AJAX Toolkit Controls in VS2012.
• Utilized ASP.NET Forms Authentication to prevent unauthorized access.
• Utilized ADO.NET with C# in Visual Studio 2008R2 to establish connections between the server-side web application and a Microsoft SQL Server 2008R2 database using Dataset, Data Reader and Data Adapter objects.
• Designed database, tables and stored procedures at the back end using Microsoft SQL Server 2008R2.
• Responsible for managing users and the application administration.
• Followed N-Tier architecture (UI-BLL-DAL-DB).

Environment: .NET Framework 4.0, Visual C#, ASP.NET MVC 4.0, ADO.NET, Visual Studio 2012, AJAX, JQuery, SQL Server 2008R2, SQL Server Management Studio (SSMS) .

Confidential, Oroville, CA

.NET C#, SQL Developer

Responsibilities:

• Analyzed existing data structure and relations of existing data.
• Developed new and improved data model.
• Created, designed, implemented and maintained SQL Server database and tables.
• Developed SSIS packages to transform the existing data.
• Adjusted data types for inconsistencies according to SQL Server requirements.
• Ran and troubleshot SSIS integration and results.
• Validated the imported results.

Environment: Microsoft SQL Server 2008R2, SQL Server Management Studio (SSMS), Visual Studio 2012, SQL Server Data Tools

Confidential

SQL Server Developer and Administrator

Responsibilities:

• Installed, configured and monitored SQL Server 2005/2008R2.
• Developed and implemented data model.
• Created, designed, implemented and maintained databases.
• Wrote T-SQL server statements (DML, DDL), created stored procedures, functions and views.
• Optimized queries and tuned stored procedures.
• Created and tuned indexes to improve performance.
• Automated everyday tasks, created SQL Server Agent jobs, used sqlcmd for express instances.
• Created statistics and analyzing reports.
• Responsible for backup strategies, database and log backups and restoration, and scheduling backups.
• Developed UI app for monitoring server events.
• Assembled, installed, and configured MS Server 2003.
• Created and designed the UI of Android applications.

Environment: SQL Server 2005/2008R2 SE/EE, Management Studio 2005/2008, Windows Server 2003, OpenVPN.

Confidential

DB Developer, System and DB Administrator

Responsibilities:

• Server and database Administrator for Windows Server 2003 and Microsoft SQL Server 2000/2005.
• Created and developed database solution and windows application for the production cycle.
• Created, designed, implemented and maintained MS Access and SQL Server databases.
• Created reports and GUI in MS Access.
• Migrated from MS Access to SQL Server 2005.
• Imported and transformed data to SQL Server databases.
• Created statistics and analyzing reports.
• Developed UI application (VBA) for control and managing production, wholesales and retail environment.

Environment: SQL Server 2000/2005, Query Analyzer, Management Studio 2005, Windows Server 2003, MS Access 97/2003.