Resume

Sign in

Sql Server .Net

Location:
Houston, Texas, United States
Posted:
February 02, 2018

Contact this candidate

PROFESSIONAL SUMMARY:

Over *+ years of experience in IT industry, involving in all phases of the Software Development Lifecycle (SDLC) including analysis, requirement gathering, database design, development, enhancements and maintenance in various domains such as Insurance, Retail and Health.

Experience in working with different object oriented programming techniques, Microsoft design patterns like Model View ViewModel Patterns (MVVM), Model View Controller (MVC), Service Oriented Architecture (SOA), WCF, WPF and Data Transfer Objects(DTO).

Expertise in Microsoft Technologies and Web Technologies such as .Net Framework,ASP.NET, C#, VB.NET, WCF, AJAX, ADO.NET, XML, LINQ, Entity Framework, Web Services, SOAP, WSDL, XSL, XSLT, HTML, Javascript,Silverlight.

Sound understanding of Interoperability, Multithreading, Windows components deployment, and a solid grounding in object-oriented design concepts such as Interface, Inheritance, Polymorphism and Delegates.

Strong conceptual knowledge in RDBMS monitoring tools: SQL Server Enterprise Manager, SQL Profiler, and SQL Query Analyzer.

Expertise in writing unit tests and integration tests using NUnit framework.

Experience in designing entity relationship diagrams, use cases, class diagrams using Microsoft Visio.

Expertise in Client/Server (Win Forms) and Web based (Web Forms, ASP.NET) application development.

Proficient in writing complex SQL queries, StoredProcedures, Indexes, Constraints, Views, Cursors, Triggers, and User Defined Functions.

Experience in handling data import from NoSQL solutions like Oracle.

Worked extensively in Entity Framework queries, mapping classes, Knockout bindings, Knockout Validations, Kendo controls and Ajax calls for API controllers.

Good experience in developing applications using different SDLC methodologies like Agile, SCRUM, and Waterfall.

Expertise in Client/Server (Win Forms) and the Web based (Web Forms, ASP.NET) application development.

Experience in developing portals using Microsoft Share point, Microsoft share point Designer.

Worked extensively with ADO.NET objects, LINQ, Entity Framework, to interact with databases like SQL Server, Oracle.

Proficient in developing N-tier distributed .NET applications using SOAP-based and RESTFUL Web services using Windows Communication Foundation (WCF), WEB API.

Experience using configuration Management Tools such as Team Foundation Server (TFS).

Innovative problem solver and capable team player with good interpersonal communication skills, ability to work collaboratively and commitment to achieve corporate goals with zeal.

TECHNICAL SKILLS:

.Net Technologies

ASP.NET, MVC, ADO.NET, Win Forms, Web Forms, Web Services, WPF, WCF, LINQ

Web Technologies

HTML/HTML5, CSS/CSS3, DHTML, XML, XSD, XSL/XSLT, JavaScript, Angular JS, Knockout.JS, Bootstrap, MVC, JSON, PHP, Web API, JQUERY, SASS, SSIS and share point designer.

Microsoft Technologies

.Net Framework 2.0, 3.0, 4.0 and 4.5, C#, ASP.NET 4.0, VB.NET.

Application Servers

IIS 5.1, IIS 6.0, 7.5, 8.0,Microsoft SQL Server, Windows Server 2012 R2 Standard, Exchange Server 2013, Team Foundation Server 2013.

Tools & IDE

NetBeans, Eclipse, Visual Studio, Microsoft Expression Web.

Database Languages

Microsoft SQL Server 8/10/12, Oracle 9i/ 10g/ 11g/ 12c, MYSQL.

Reporting Tools

Crystal Reports, Microsoft SQL Server Reporting Services (SSRS).

Operating Systems

Windows, Windows Server

Protocols

HTTP, SMTP, FTP, TCP/IP, SOAP

PROFESSIONAL EXPERIENCE:

Cerner Corporation, Kansas City, MO Feb 2016 to Present

Role: Senior .Net Developer

Cerner is the leading U.S. supplier of healthcare information technology solutions that optimize clinical and financial outcomes. Cerner offers clients a dedicated focus on healthcare, an end-to-end solution and service portfolio, and proven market leadership. The Project Insurance Management System(IMS) was developed to provide information about the claims, issuance,renewal and cancellation of the health insurance policies.The main aim is to develop an advanced Insurance system which can make stored information easily available to customers, agents and to the company.

Responsibilities:

Involved in System Analysis, requirement gathering, specification/documenting, designing, coding, testing, debugging, application evaluation and implementation.

Working on Web Service calling using jQuery and AngularJS for Synchronous and Asynchronous Ajax calls in HTML web pages.

Developed REST- API based web service to consume data by the client. Implemented provider based services.

Developed UI Pages using Razor Views, CSS3, JavaScript, and jQuery.

Developed application using ASP.NET, MVC framework.

Designed Business Logic Layer, Data Access Layer using C# and MVC-5 as per the project specifications and implemented 3-Tier Architecture.

Created ASP.NET Web Service to serialize XML data over HTTP; where the third party uses XML for the query and transferring the data.

Created Partial Views/User Controls for better reusability of codes in the application.

Designed and implemented UI for the application using ASP.NET MVC 5 Web Server controls.

Written stored procedures, triggers using T-SQL for data access from SQL Server 2008 R2.

Developed module which deals with validating the user, changing passwords and searching of information depending upon the priority of user in the site using ASP.NET and C#.

Worked on all client side controls in HTML5 using jQuery, AngularJSUI libraries.

Worked on implementing Entity framework at service level for performing database operations.

Worked on Indexes to speed up the query process in SQL Server.

Worked with Agile/Scrum Environment to meet the timelines and interaction with the team.

Designed and Developed Web Forms using ASP.NET, C#, XML, XSLT.

Involved in handling concurrency issue by using optimistic locking in Entity Framework.

Responsible for developing the Data Access Layer (Model) using ADO.NET Entity Framework Model, LINQ toEntities, and C#.

Worked on HTML5 validations and new form element types to implement validation in Angular JS.

Utilized User controls to avoid repetitive UI code blocks in multiple .aspx pages.

Used the ADO.NET data binding controls like Grid View in order to bind the data to the control and displayed the retrieved data.

Developed Dynamic web applications with AJAX and Websockets.

Worked on deploying the web application on IIS, creating virtual directories and setting permissions in IIS.

Worked on analyzing the Query plan, logical operators and logical reads in SQL Server.

Developed web services automated scripts from API document to verify RESTful web service calls using XML and JSON format.

Performed unit testing and functional testing using XUnit.

Maintained detailed technical documentation for application systems and software applications.

Used Team Foundation Server (TFS) for Version Control.

Environment: Visual Studio 2013, Bootstrap, ASP.NET 4.5.1, REST, JavaScript, JQuery, AngularJS 2.0, Xamarin studio,MVC 5, HTML,CSS, Entity Framework, IIS 7.5, AJAX, XML, SQL Server 2008 R2,Websocket, Team Foundation Server 2013.

InEight, Scottsdale, AZApr 2014 to Jan 2016

Role: Sr .NET Developer

InEight is a company which provides technology solutions for the construction and engineering industry with a vision to help companies manage, estimate and control all aspects of capital and maintenance. The project is to keep track of all the installed equipment like underground wiring, gas pipes etc., and it also helps to assign work to crew's member, check work progress, create reports of work done.

Responsibilities:

Involved in the Design and Implementation phases of agile software development lifecycle.

Designed the complete solution using N-tier Architecture model with ASP.NET and design patterns mainly Abstract Factory and Singleton.

Implemented MVC design pattern for developing the Web Application.

Involved in application enhancements and bug fixing and developed concepts using C# business entities and Entity Frameworks.

Implemented Server Side and Client side validations using ASP.NET validation controls and Javascript.

Developed dynamic Client UI using HTML and Angular JS.

Worked as UI Designer and Developer for the Web application using C# and ASP.NET.

Used AJAX Controls to increase the responsiveness of the web application, used AJAX Toolkit for user Interface Development.

Developed Web Forms using ASP.NET/C# language which communicates to the server via SOAP.

Design and development of front end GUI modules for technical support personnel using C# and ASP.NET.

Used ASP.NET Web Forms, server controls extensively, setting up an inheritance chain of Forms following Object Oriented Programming Principles.

Created controllers updated services necessary to manage the JSON objects displayed.

Design and implementation of tables, stored procedures, triggers, views, SQL statements for database operations using ADO. NET.

Enhanced the application's performance by constantly monitoring the queries by running Execution plans and query optimization techniques in SQL server.

Experienced in Developing and Enhancing Web Forms, Master Pages, User Controls and Custom Controls by using HTML, CSS, and ASP.NET Controls.

Developed REST APIs using Web API (SOA).

Designed and implemented Web API (SOA) to support mobile applications.

Used Node.js for server side code and Express.js as the framework. Written callback functions for the RestFul API.

Scheduled reports for daily, weekly, monthly reports for executives, Business Analyst and customer representatives for various categories and regions based on business needs.

Written Stored Procedures in SQL Server 2008 and Grid View, Data List, Details view, Repeaters, Dataset Classes for data manipulation by using store procedures.

Performed debugging and N-Unit testing, designed navigational flow and defined usability and GUI guidelines.

Environment:ASP.NET 4.0, C#.Net, XML, Jquery, Ext Js 4.0, JavaScript, Web API, MVC 4, WCF, Web Services, ADO.NET, Windows DAP Server 2008, JSON, Visual Studio 2010, Windows Services, IIS 6.0

Digital Intent, Chicago, IL May 2013 to Mar 2014

Role: .Net Developer

Digital Intent is a company that does digital strategy, marketing, product management, UI/UX design, software engineering and much more. Their main objective is to build bespoke software solutions and products for the enterprise and the app market. The project focuses on basic search criteria for a business user to search for order task or search for equipment.

Responsibilities:

Used Software Development Kit (SDK) shipped with Microsoft CRM to develop the connection between the IP Office solution and the Microsoft CRM application.

Creating two-week sprint and assign the task or subtask to complete the business requirement and update work log using JIRA for story progress as Agile Process.

Experience in working extensively on Server side & Client-side JavaScript, jQuery, JSON, Ajax, HTML, HTML5, DHTML, CSS, CSS3, and XML

Developed Web Forms and Web Pages using ASP.NET, HTML, AJAX, CSS to facilitate the registered and new agents and customers.

Used OOPS concepts for implementing the applications.

Involved in Front End Developing using ASP.NET, HTML, CSS, and jQuery.

Used jQuery and JavaScript for client side validations that depreciate the processing time and resource consumptions.

Developed complex modules including business entities and data access layer using C#.

Responsible for developing the Data Access Layer (Model) using ADO.NET Entity Framework Model, LINQ to Entities, and C#.

Involved with Database team to enhance the performance and get the search result view inappropriate time.

Involved in designing and developing the database objects like Tables, Views, and Complex queries and T-SQL statements, Stored Procedures involving Joins and using Temporary Tables, UDF (User Defined Functions).

Responsible for designing, coding and consuming well-defined WCF Services.

Implemented ASP.net MVC design pattern architecture.

Environment:Visual Studio 2010, .NET Framework 4.0, WCF, ASP.Net MVC4, jQuery, ADO.Net Entity Framework, HTML, JavaScript, C#, SQL Server, Oracle, Microsoft Office, GIT, Source Tree, Agile Methodologies (JIRA).

Beqom, Redmond, WAOct 2012 to Apr2013

Role: .NET Developer

Beqom is a fast growing global enterprise software company that focus on managing compensation and performance for the world’s leading organizations. TheBeqom Total Compensation platform is used to addresses all Performance and Compensation aspects such as Salary Review, Bonus, Long-Term Incentives, Commissions, Benefits, Non-cash rewards and all key drivers towards Employee Performance.

Responsibilities:

Designed and developed the web forms using ASP.NET 3.5 with Silverlight.

Developing and coding the new module using .NET Framework 3.5, C#, WCF, jQuery, LINQ, XML and SQL server 2008.

Designed WCF Service Contract for validating the user input.

Involved in Requirement gathering, Functional and technical specification.

Creating framework using design patterns for caching and pooling the application level resources and objects.

Used JavaScript for client side validation thereby optimizing the code and database queries.

Used Microsoft reporting services to generate reports.

Technical Code Review, Code and Memory profiling.

Implemented Exception handling to store all the exceptions in SQL Error Log table.

Enhanced the application's performance by constantly monitoring the queries by running Execution plans and query optimization techniques in SQL server.

Releasing to live data center servers with high availability systems.

Experienced with LINQ to SQL, LINQ to XML, and LINQ to Objects for retrieving the data efficiently from the server.

Utilized User controls to avoid repetitive UI code blocks in multiple .aspx pages.

Mentored the other people in the team and training them to best practices in the industry.

Environment: .NET Framework 3.5, C#, WCF, JQuery, LINQ, XML and SQL server 2008, Visual Studio 2008.

SmartPak, Plymouth, MA May 2010 to Sep 2012

Role: .Net Developer

SmartPak is a retail store that has grown from a small supplement company to the largest online tack store. There is a requirement to create an eCommerce websitethat will feature their products and services in order to increase their market. This project also facilitates the retailer to keep track of their inventory.

Responsibilities:

Developed the web pages in ASP.NET/Visual Studio 2008.

Developed Web Services with C# Winforms, Product developed using Visual Studio.Net.

Worked on Classic ASP to ASP.NET migration, .NET web forms and .NET web services in scrum Development methodology.

Developed Web Application with VB.NET in scrum development.

Data migration using ETL Tools in DTS and Batch EDI processing used PL/SQL.

Worked on SSRS 2005 to generate about 30+ reports for various user groups and developer groups.

Developed GUI front end using Windows forms (Win Forms) in C# and Design, code, test, debug and document the programs.

Create UML diagrams for the back-end server side development.

Written an Application Layer in VB 6.0 and VC++ by passing Response and Request objects from ASP Pages to COM Components, Service-Oriented Architecture (SOA).

Worked on IIS administration in web server 2008 by usingWAM and connection for different data sources access connx String in configuration files used in .Net workflow framework.

Using company requirements to apply C#.Net develop new applications and features to provide enhanced functional capabilities to the customers.

Used JavaScript to validate the user input and VB Script on the server side.

Used ActiveX Data Objects to communicate with the database.

Developed database stored procedures, functions, views and created DTS (Data Transformation Services) packages for data transfer from various files.

Worked on SQL Server 2008. Tasks involved were creating backups, restoring databases, SSIS and loading the data, etc.

Involved in Data modeling and coding Stored Procedures and triggers.

Used XML for paging and used DOM to parse the XML documents write XSLT.

Developed Report Generation module by using Crystal Reports 8.0.

Environment:ASP.NET 2.0, VB.NET 2.0, Classic ASP, ADO.NET, .NET Framework 2.0, MS SQL Server 2005, Visual Studio 2005, Windows 2003, Cascading Style Sheet (CSS), HTML5, SOA, scrum methodology, WWF, Windows Development.

Spectra Mind Solutions –Hyderabad, India Jul 2008 to Apr 2010

Role: VB.Net Developer

Spectra Mind Solutions has rich domain expertise in providing software application development, technical services support, and maintenance.There was a requirement to create a web portal that will provide a better solution for its customers where they could easily find multiple insurance products.

Responsibilities:

Participated in the analysis, design & development phases.

Participated in meetings with Business Users and with other project teams to ensure that the volatile business requirements reflect in the project development.

Developed web pages using HTML, Cascading Style Sheets (CSS) and ASP.Net controls.

Developed the server side code using C# and client side code using VB Script with Visual Studio IDE.

Involved in the design of the use case diagrams and class diagrams using Rational Rose.

Extensively worked on Master Pages, Themes/skins to give consistent look and feel to the application.

Used SOAP protocol to transfer the XML-based message such as applicant's requests over computer networks.

Involved creating GUI using Windows applications.

Used validation techniques and JavaScript for User Input Validations. Designed and developed web forms using ASP and VB Script.

Used OOPS concepts to develop the web services.

Involved in setup security for the ASP.NET application using Forms Authentication and Active directory.

Interfaced with the Database and stored procedures using ADO.Net datasets, data adapters.

Used OSI model's network layered system and worked on the PI system to integrate the Microsoft Office for the business usage.

Environment:Windows XP, Visual Studio 2005, SQL 2005, VB.Net, ASP.NET 3.5, VB Script, C#, ADO.Net, Web Services, JavaScript, UML, IBM Rational Rose.

EDUCATION: Bachelor of Engineering, Computer Science.



Contact this candidate