Post Job Free

Resume

Sign in

.Net Sql Server

Location:
Lake Forest, IL
Posted:
July 27, 2015

Contact this candidate

Resume:

Professional Summary

*+ years of extensive experience in developing Client-Server and Web-based n-tier Architecture applications for windows and web based technology.

Experience with all phases of SDLC in the Waterfall model and Agile (SCRUM) methodologies.

Developed N-tier web applications using Visual Studio 2008/2010/2012, C#, ASP.Net 3.0/3.5/4.0/4.5/5.0, ADO.Net, WCF, XML, SOAP, VB.net,Web Services, Web Forms, Win Forms, Microsoft .Net Frameworks.

Proficient in Web Programming to enhance user experience and performance using JavaScript, jQuery, Knockout.js, EXT JS, AJAX, AJAX Toolkit and CSS.

Experience in developing applications using ASP.Net MVC 4.0 Framework, HTML5, CSS 3.0 and Entity Framework.

Experience in creating SQL Server objects like Tables, Stored Procedures, Views, Indexes, Triggers, Cursors, user defined data types and functions.

Created Stored Procedures, PL/SQL statements, Functions to manipulate the databases

Implemented ADO.Net data access techniques i.e. SQL Connection Objects, SQL Command Objects, Dataset Objects, DataReader Objects and DataAdapter Objects using DataGrid and DataList in ADO.Net

Extensively used LINQ (LINQ to SQL, LINQ to XML), ADO.NET, Entity Framework 4.0/5.0/6.0 and T-SQL in developing Data Access Layer.

Strong working experience in managing Security policies including Authentication, Authorization, Identity, Encryption, Personalization, Membership, Roles, Profiles and Resource Access Control.

Extensive experience with development & deployment of Web Services (SOAP, UDDI & WSDL), WCF services, SOA and MSMQ using the .NET Framework 3.0/3.5/4.0/4.5.

Worked on extensively on Oracle, HTML, HTML5, GUI, PL/SQL, XAML and XML.

Extensively worked on developing applications using ASP.Net MVC.

Worked on CRYSTAL REPORTS for managing business intelligence applications.

Good experience with MVP, MVVM, MVC and Singleton design pattern.

Good Knowledge on Web API, WPF, Azure/Cloud, Silverlight and Microsoft Dynamics CRM.

Good Experience with WWF 3.0/4.0, Oracle and Log4net.

Good Experience with ACCUSOFT, REST.

Knowledge on Telerik third party controls.

Worked on DATA MODELS for various information systems.

Good Knowledge on PowerShell and Angular JS.

Good experience on LOGICAL DATA MODULES.

Knowledge on CMS (Content Management Systems), WCF.

Experience in domains like Manufacturing, Retail, Health Care, IT and Insurance.

Experience with Entity Framework approaches such as code-first and database-first.

Edited and corrected errors in jQuery functions for improving performance of a page.

Worked with IIS and Windows Server 2008 during application deployment.

Proficiency with Object Oriented Principles, Concepts and Best Practices.

Excellent in Communication and strong Presentation Skills, Leadership qualities, quick adaptability with team members and ability to work independently.

Technical Skills

Languages

ASP.NET, C#, VB.net,Javascript, jQuery, HTML, WSDL, C.

.Net Technologies

ASP.NET, ADO.NET, AJAX, C#.NET, Entity Framework 6.0/5.0/4.0, Web Forms, MVC based development, Crystal reports, Javascript, jQuery,TSF, CSS,Data models, WCF, WWF, MSMQ.IIS,

Database

PL\SQL,SQL Server 2005/2008/2012, Oracle

Development Tools

Visual Studio 2005/2008/2010/2012, SQL Server Management Studio 2012/2008/2005.

OS

Windows 7/Vista/XP/NT/98, Windows Server 2008/2003.

Reporting Tools

SSIS, SSRS, Microsoft Reporting Services, Crystal Reports.

Hardware Exposure

System Integrating, Trouble Shooting, Handling of Intel 805X processors and programming them with C language.

Professional Experience

Client: Grainger, Lake Forest, IL Aug 2014 to Current

Role: Sr. .Net developer

Responsibilities:

Worked in close quarters with clients in order to gather the requirements. The requirements were dynamic and needed to be updated frequently.

Interacted with Business Analyst team for gathering requirements.

All modules were developed in 3-tyre architecture containing the presentation layer, business logic layer and application layer.

Developed View-Models in order to restrict the controllers to control the dataflow between the model and view.

Developed View-Models in order to restrict the controllers to control the dataflow between the model and view.

Used MVC (model-view-controller) architecture based development for creating Views and Partial Views – UI and middle tier for various modules.

Implemented knockoutJS for data binding and dynamic JavaScript UI.

Worked on DurandalJS to implement SPA Framework in the application.

Implemented BreezeJS for querying and handling rich data and track changes.

Implemented BootStrap for responsive UI design, so that application can be used from various browsers with devices like computer, tablets, mobiles.

Implemented OData on ASP.NET WebAPI for convenient querying and changing data.

Involved in modules like Collection, Beverage, Recipe, Ingredients, Dispenser.

Used the latest WPF/XAML vector based UI framework for the front end and WCF to implement the various services such as the QA Services.

Developed good user interfacing applications using WPF.

Used Validation Controls, CSS in Web Forms for frontend development..

Designed the database structure for storing users’ personal information.

Developed style-sheets for UI design and layout.

Used MVC and MVVM pattern.

Used WCF for creating services for the application.

Client side validations were designed using Data Annotations and javascript.

Edited and corrected errors in jQuery functions for improving performance of a page

Experience on data integration using SSIS.

Developed Log4Net for creating log files.

Experience with razor code in View pages.

Designed class libraries for database connection using ADO.NET.

Used ADO.NET and related data objects such as Data Adapter, Data Reader, Data Set and Data Table for consistent access to SQL data sources.

Used LINQ and ADO.NET Entity Framework 5.0 for Database interaction.

Created Stored Procedures, PL/SQL statements, Functions to manipulate the databases.

Product development is an Agile (SCRUM) methodology, where progress and task assignment is discussed in everyday meetings.

Developed applications in Test driven environment using Unit testing

Generate reports from wide range of data sources.

Performing unit-testing on logics that are being built.

Actively participated in project schedule, code reviews and deliveries.

Deployed the application and components on the test and production servers.

Used TFS for the purpose of project tracking and Source Control.

Environment: VisualStudio 2012, ASP.NET 4.0, C#, MVC 4.0, Web Services, WCF, WWF,LINQ, HTML; CSS,IIS, Pl/SQl, SQL Server 2008 R2, DurandalJS, BreezeJS, BootStrap, WPF,SQL Server Management Studio 2012; Entity Framework 5.0/6.0;AJAX, knockoutJS,ADO.NET Framework, TFS.

Hcentive, Lakewood, Co June 2013 – July 2014

Role: .Net Developer

Responsibilities:

Involved in gathering of requirements and creation of functional specifications for the project, based on the existing use cases and new use cases proposed by the client.

Involved throughout in Software Development Life Cycle (SDLC) process.

Implemented IOC (Inversion of Control) through Structure map.

Used C#.Net to implement business logic.

Developed Web Services to identify employee hierarchy and contact info for budget approval process and also consumed them in front end to auto-populate hierarchy for better user experience.

Used Try, Catch, Finally blocks to catch exceptions thrown.

Utilized Master pages, Themes, Navigation controls, Authentication to design secure web pages using ASP.NET MVC 2.0 and built highly responsive and interactive AJAX -enabled Web applications using AJAX Tool kit.

Experience in using Windows Communication Foundation (WCF). Used WCF services for communicating with Microsoft SCCM (System Center Configuration Manager) server. One of the purposes was for license management.

Involved in coding member validation business functionality using WCF and client front end layers using WPF and Silverlight.

Experience in using interactive user experiences for Web Application.

Programmed VB6 DLL Object to automatically update certain flags in main frame system via MSMQ on nightly basis driven by SQL Server Job.

Have used Service Oriented Architecture (SOA) to develop web services.

Experience in using RAPID APPLICATION DEVELOPMENT (RAD), to create a system that can be modularized in 2-3 months of time.

Used BizTalk framework provided by Microsoft for integrating with the web services that supports both SOAP and WSDL.

Used Azure to provide both PaaS and IaaS services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems.

Extensively worked on developing applications using Azure.

System design and development, Rapid Application Development (RAD) using MVC and MVP patterns with design patterns, code review, release management.

Experience in NoSQL development using Azure Storage.

Designed and coded asynchronous messaging system using MSMQ, reflection, and XML serialization.

Experience in OOAD with all phases of SDLC in the Waterfall model and Agile (SCRUM) methodologies.

Experience in using Angular.js 8, ability to test views and able to do end to end unit testing. Also, using continuous integration.

Used Entity framework as ORM tool to map classes with tables to enable working with rows as objects.

Experience in working on bootstrap loader global CSS3 settings and improve the html5 elements style behavior for the UI display.

Used LINQ to retrieve the data from the backend through Entity framework.

Transferred data to front-end in JSON format.

Developed database objects such as tables, views, stored procedures, audit triggers and user defined functions for database operations in SQL SERVER 2008 standard edition.

Followed TDD (Test Driven Development) when implementing Web Service for budget approval process.

Involved in debugging and testing of Win Forms in the application using the trace and Log Files.

Used Visual Source Safe (VSS) for source control.

Provided Production Support to troubleshoot and debug the issues during migration.

Used Jenkins for continuous integration.

Environment: C#, ASP.NET MVC 2.0, AJAX6, bootstrap.js, WCF,CSS3 60, LINQ, JSON, Entity Framework, Agile (scrum), web API’S, Visual Studio 2010, EAI, HTML5, SQL SERVER 2008, Win Forms, jQuery6,T-SQL 8, Backbone.js & Angular.js 8 framework, VSS, IIS, WPF,Jenkins, Web Services. Silverlight, Rapid Application Development (RAD).

Horace Mann, Springfield, IL Dec, 2011 – May, 2013

Role: Product Developer/Analyst

Responsibilities:

Worked on Agile Methodology (Scrum) to meet timelines with quality deliverables

Communicated with client for daily updates, reviews and demos. Involved in user training programs.

Coach and help develop team members, help resolve dysfunctional behavior. Familiarize the team with the client needs, specifications, design targets, the development process and design standards support task performance

Designed Business components and Data Access Layer using C#.

Used LINQ to XML and LINQ to Objects for retrieving the data efficiently and Just in Time manner.

Developed complex stored procedures using temporary tables and loops using SQL and PL/SQL.

Used JQuery to dynamically render the content on web pages developed using C#.

Experience in building rich user interface web applications using Silver light (MVVM) and XAML.

Experience working with Silver light Unit Test Framework, involved in Unit testing and have created unit test cases

Involved in gathering and preparing the requirements from clients for product design and enhancements.

Was able to upload multiple files and contact groups using SharePoint.

Developed Cascading Style Sheets (CSS) for User Interface uniformity throughout the application.

Developed JQuery code for client side validations

Used List, Trees, Toolbars, Menus and Context Menus for navigating between pages in Windows Presentation Foundation (WPF).

Used ASP.NET MVC Page Controller pattern to add functionality to individual pages such that

to accept input from the page request, invoke the requested actions on the mode.

Responsible for designing the ASP.NET application authentication using .NET Framework, Model View Controller MVC and IIS security model.

Worked on designing and development of Forms using MS Visual Studio 2008, VB.NET

Used ADO.NET Entity Framework Model as the Data Access Layer (Database First) and implemented the CURD(Create, Update, Retrieve and Delete) operations, Mapping and executed stored procedures

Used the LINQ to Entities, Query projections, Grouping, Entity SQL, Querying with LINQ to SQL, Eager Loading, defining Mapping and Inheritance

Developed complex Stored Procedures and Sql queries to perform database operations in SSDT Server 2008 database for creating field reports.

Created WCF Service to lookup and retrieve the data from database.

Hosted WCF Service manually to provide multiple end points, which can then used by other modules.

Involved in Extraction transformation and loading of data using SSIS to create packages

Involved in user trainings and implementation.

Implemented application variables for application level reports.

Involved in creating, deploying and managing reports using SSRS

Environment: Asp.net MVC 3.0, .NET Framework 3.0, C#, HTML, CSS, JQuery, DHTML, Visual Studio 2008, Web Services, WCF, SharePoint, MS Visual SourceSafe, XML, XHTML, XSLT, MS VISIO(UML), Microsoft Silver light, SharePoint, WPF,SQL Server Integration Services 2008, SSDT, SQL Server Reporting Services 2008.

Client: Marvell Semiconductors, Santa Clara, CA Nov 2010 – Nov 2011

Role: .Net developer.

Responsibilities:

Product development is an Agile (SCRUM) methodology, where progress and task assignment is discussed in everyday meetings.

MVC (model-view-controller) architecture based development.

Developed View-Models in order to restrict the controllers to control the dataflow between the model and view.

Created Views and Partial Views – UI and middle tier for various modules using C#, MVC 3 (Razor View Engine), AJAX, jQuery, HTML, CSS.

Used AJAX for Partial Page Updating, Invisible Data Retrieval, Constant Updating, Smooth Interfaces, Simplicity and Rich Functionality.

Created Forms that provide Asynchronous operations using AJAX Helper Class to provide functionalities like Partial Page Rendering, Client Side Validations, Error Handling and Auto Complete to optimize UI.

Designed and developed UI using ASP.NET, HTML, CSS, jQuery, JSON and AJAX.

Designed an Enrollment UI for the project, where one can register with personal details.

Designed Login, change password, forgot password UIs and their functionalities.

Designed the database structure for storing users’ personal information.

Developed style-sheets for UI design and layout.

Edited and corrected errors in jQuery functions for improving performance of a page.

Experience with razor code in View pages.

Built dynamic web view applications using ANGULARJS.

Used ADO.NET and related data objects such as Data Adapter, Data Reader, Data Set and Data Table for consistent access to SQL data sources.

Used LINQ and ADO.NET Entity Framework 4.0 for Database interaction.

Created Stored Procedures, PL/SQL statements, Functions to manipulate the databases.

Developed applications in Test driven environment using Unit testing

Actively participated in project schedule, code reviews and deliveries.

Deployed the application and components on the test and production servers.

Used TFS for the purpose of project tracking and Source Control.

Development process was swift in order to meet deadlines and I was very flexible with over time work.

Environment: ASP.NET 4.0; C#; Web Services; WCF; MVC 3.0; LINQ; HTML; CSS; IIS, Visual Studio 2010; SQL Server 2008 R2; SQL Server Management Studio 2008; AJAX; Entity Framework 4.0; MVC Architecture; TFS; VB.net; SSIS;ANGULARJS

Client: Yash Technologies, India Aug 2008- Sep 2010

Role: Jr.Net developer

Responsibilities:

Involved in Client Gathering and analyzing requirements, and documenting them with use cases.

using C#.NET, VB.NET, Jquery, JavaScript, XML, HTML and ASP.NET.

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

Implemented web based front end application using classical ASP.

Used Cascading Style Sheets (CSS) to maintain design consistency across all web forms.

Business logic and calculation were implemented via stored procedures, triggers and function.

Implemented transaction executions safely by using COMMIT and ROLLBACK commands.

Developed ADO.NET modules for communication of the Application with the Database layer.

Responsible for writing SQL queries to fetch data as per the business requirements with proper tuning techniques.

Implemented Components for Exporting Data to CSV Format and EXCEL Format.

Involved in testing different functionality.

Provided Code Maintenance and Customer Support.

Environment: ADO.NET, VB.NET, C#.Net, Win Forms, SQL Server 2005, T-SQL, Visual Studio.NET (VS.NET), Visual Source Safe.

Client: Accu Solutions, India Nov 2006 – July 2008

Role: Jr.Net developer

Responsibilities:

Got trained on various techniques in .NET application development with ASP Web Forms, Win Forms, C# .NET as code behind and SQL Server 2005 as database.

Understanding the functional requirements, studying the system specifications and designing the Object Model for the software using Object Oriented Techniques with the 3 - tier architecture.

Designed and developed user interface using ASP.NET and C#.NET.

Developed user controls and validation controls using ASP.NET.

Created applications using SILVERLIGHT

Was involved in all the stages of development from the Design till the Maintenance.

Master Pages were developed and used for uniformity and CSS were coded and used for implementing themes.

Implemented business logic as .NET Framework assemblies using C#.NET.

Used ADO.NET and related data objects such as Data Adapter, Data Reader, Data Set and Data Table for consistent access to SQL data sources. Used LINQ for updating data through C#.

Coded Stored Procedures that contained joins and used in ADO.NET for creating, updating or deleting the data and even perform some information related tasks with multiple tables.

Prepared user documentation.

Environment: .NET 2.0; C#; Visual Studio 2005/2008; SQL Server Management Studio 2005; ADO.NET Entity Framework; Silver light.



Contact this candidate