Post Job Free

Resume

Sign in

.Net SQL Server Developer

Location:
Irving, TX, 75063
Posted:
June 18, 2018

Contact this candidate

Resume:

PROFESSIONAL SUMMARY:

Over * plus years of experience in developing, implementing Web Applications, Windows Applications, middleware, Integrations and products using Visual Studio 2015/2013/2010/2008, Vb.net, c#.NET, ASP.NET, Team Foundation Server (TFS), Dot NET Framework and Databases such as SQL Server 2015/2012/2008 with N-tier development environment.

Strong Experience of SDLC (Agile, Iterative, SCRUM) including SRS, Design & Analysis, Development, Implementation, Build, Deployment, Version Controlling, Testing & Post implementation & UAT issues support, migration and conversion of existed project.

Good working experience in writing JQuery 2.0/1.0, AngularJS, JQuery / AngularJS AJAX based web applications to improve the response time and extensively implemented update panels, script manager and triggers.

Strong hands on programming, design, understanding and deep functional experience in creating, deploying and consuming of XML Web Services, WCF services, RESTful Services and Web API.

Experience with the Object Relational Mapping (ORM) using Language-Integrated Query (LINQ).

Strong in Object Oriented Analysis and Design (OOAD) and UML concepts. Used JIRA for Project Development and Bug tracking as internal tool to track items.

Proficient in Database designing, performance tuning including indexing, schema optimization, de-normalization techniques and query execution plan analysis.

Good experience in design, modeling and development of Databases MS SQL Server (T-SQL), PL-SQL and implementation of database objects like Tables, Views, Stored Procedures, Functions and Triggers.

Created Error and Performance Reports on SSIS Packages, Jobs, Stored procedures and Triggers.

Experience with code-first approach and database-first approach of Entity Framework.

Expertise in implementing SOA architecture through WCF services which used to rapidly building service-oriented applications that communicate across the web and the enterprise with features Serialization, Versioning, Interoperability and hosting.

Used C#.Net for Serialization and Generics for integrating with the tool for XML file generation.

Experience in developing ASP.NET Web customs controls, user controls, Data Controls like Data Grid, Rich UI with extensive use of ASP.NET AJAX, Angular2, Bootstrap and JQuery.

Solid experience in developing Single Page Applications (SPA) based on client side JavaScript framework Angular2 employing ASP.NET MVC and Web API.

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

Expertise in Implementing Lambda expressions or LINQ Query Expressions for standard query operators that allow traversal, filter, and projection etc.. Operations applied to any IQueryable<T>, IEnumerable<T> different data sources.

Experienced in building animations for desktop applications using Extensible Application Markup Language (XAML) files in Visual Studio and Expression Blend.

Experienced in SQL Server Reporting Services (SSRS) and Crystal Reports for report generation, integration into .NET applications.

Experienced in Version Control Systems using Visual Source Safe (VSS), Team Foundation Server 2012/2010/2008, GIT.

Good experience in designing Technical Framework and defining Non-Functional Requirements

Excellent Written, Verbal Communication, Analytical Skills with a customer service oriented attitude and worked onsite with the offshore team as coordinator to provide the update on the daily basis. Highly organized and able to work tight deadlines and communicate effectively with technical peers.

Extensive working experience in unit, integration and performance testing framework – NUNIT, MS Unit Tests.

Very good inter-personal skills and has the ability to work independently as well as in a team environment.

EDUCATION:

Bachelor of Technology in Computer Science & Engineering at Jawaharlal Technological University, India.

TECHNICAL SKILLS:

Programming Languages : C# .NET, C, VB.NET

Web Technologies : ASP.NET, ASP.NET MVC6.0/5.0/4.0/3.0, HTML5, CSS3, JavaScript, AJAX

3.0/2.0, Angular2, JQuery, Web Services, VB Script.

Xml Technologies : XML

IDE Tools : Visual Studio 2015/2012/2010/2008, SQL Server Management Studio, SQL Server Management R2

.Net Frameworks : MS.Net Framework 4.5/.4.0/3.5/3.0

Databases : MS SQL Server 2012/2008R2/2008/2005, MS Access, Oracle11g/10g

Reporting Tools : MS Access, MS Excel, Crystal reports 9.0, SSIS, SSRS

Modeling Tools : UML, MS Visio 2010/2007, MS Office

Version Control Tools : Team Foundation Server (2012/2010/2008), Visual Safe Source, GIT

Middleware : WCF, ADO.NET 4.5/4.0/3.5/3.0/2.0, Enterprise Library 5.0/4.0/3.1

Servers : Windows Server 2008/2003/NT, Microsoft IIS (7.0/6.0/5.0/4.0).

PROFESSIONAL EXPERIENCE:

Comnet Software, Miamisburg, OH

.Net Develop July 2016- Till Date

Project: (Airport Voice)

Airport Voice is a system that manages audio messages and live announcements. The system is capable of playing messages on a certain schedule or dynamically triggered from interfaces like FIDS system to do automated announcements when a gate or status changes.

Responsibilities:

Implemented the project according to the Software Development Life Cycle (SDLC) and programming by using fast paced agile methodology, involving task completion, user stories, and iterations.

Agile methodology and SCRUM for the development and Responsible for attending daily scrum meetings to accommodate client’s requirements.

Responsible for developing the reusable Components on UI(Views) by developing the Partial Views, View starts, and reusable components for implementing the business rules with C# and OOPS Concepts.

Implemented MVC Architecture on client side and creating Models, Controllers, and Views Scope etc. Using Angular2 Coded frontend interface with CSS3, Bootstrap and HTML5.

Developed MVC application by using Layouts to have consistent look of and to add styles to each page in application and Involved in development of MVC 4.0/5.0 patterns for client server interaction.

Used ASP.NET MVC framework to support the use of Dependency Injection to inject objects into a class, instead of relying on the class to create the object itself.

Used ADO.Net extensively for database interactions using Data Reader, Data Adapter, Data view and Datasets.

Involved in the entire conversion of the application from VB to ASP.NET MVC5.

Implemented UI using Angular2, ASP.NET MVC 4.0/5.0, CSS3, HTML5, JavaScript, JQuery, Bootstrap, AJAX and Kendo UI Controls to create responsive web pages, developed Layouts.

Worked on JavaScript, JQuery with Ajax / Server calls for the client validation and to get server data.

Converted JavaScript to JQuery, and moved server side code to client side using JQuery to speed up the website.

Worked on Angular2 of Scopes, Models, Directives, Filters, Services, Dependency Injection, Routing and Prototyping.

Used Angular JS as framework to create a Single Page Application (SPA) which can bind data to specific views and synchronize data with server. Created custom directives in Angular JS for re-usable components.

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

Designed, developed and consumed .Net Web Services for the project and Development support for .Net web services in ASP.Net with C#.Net and consumed it.

Designed and developed various abstract classes, interfaces, classes to construct the business logic in Model using C#.

Working Experience on Azure Storage, SQL Azure and also in different PaaS Solutions with Web, and worker Roles and Azure Web Apps

Converted .Net application to Microsoft Azure Cloud Service Project as part of cloud deployment.

Implemented Interface whenever possible to enhance usability, testability and to increase performance.

Extensively used XML and JSON Serialization for transferring the data from controller to view.

Created WCF REST Services and also used different bindings to make it available to different types of clients.

Built a robust and scalable application that calls a data service based on the SOA (Service Oriented Architecture) paradigm and built using WCF.

Built WCF clients to make synchronous calls to Web Services over HTTP and SOAP.

Worked on SOAP and RESTFUL Services using Web API which return JSON data.

Implemented Web API Services for CRUD operations with HTTP verbs GET, POST, PUT and DELETE.

As database developer responsible in create and support database objects like complex Stored Procedures, Packages, Triggers, Tables, Functions and Views.

Performed complex parameterized SQL queries to multiple tables in SQL server 2015 and implemented Joins in Stored Procedures to get the desired data by joining multiple tables in Domain layer.

Implemented Unit Testing, Integration Testing and System Testing using NUNIT. Implemented Unit Testing through MS Test and created tests for all functions used in the application.

Used Entity Framework 6.0 to Implement Code First Approach to interact with Database and also implemented the Mappings, Model Changes and UI in Razor View Engine.

Used Entity Framework (ORM) code first approach to created data access layer to interact with SQL server.

XML Serialization and Deserialization was used before and after data transmission.

Created SSIS packages for importing data from various data files/excel to the data source.

Created complicated reports like parameter based reports, sub reports, well formatted reports, matrix reports, chart and tabular using SSRS 2008.

Team Foundation Server (TFS) is used as a version control for code repository

Utilized the TFS source control to keep track of new and past versions of code written in my application.

Environment:

C#, ASP.NET 4.5, MVC 5.0, HTTP, ADO.NET, AJAX, TDD, Entity Framework 6.0, AngularJS, HTML5, CSS3, JavaScript, Bootstrap, JQuery, TFS, WCF, Restful Services, SOAP, Web API, XML, Microsoft Enterprise Library, SSRS, LINQ, SSIS, Windows XP, MS Test, PL/SQL, SQL Server 2014, IIS 8.0, Visual Studio 2013/2015..

AmerisourceBergen, Chester brook, PA

.Net Developer Sep 2014- June 2016

Project: (Pharma Network)

AmerisourceBergen is driving innovative partnerships with global manufacturers, providers and pharmacies to improve product access and efficiency throughout the healthcare supply chain. As part of the largest global generics purchasing organization, the leading specialty pharmaceutical services provider and the partner with more community and health system pharmacy relationships than any other we’re well positioned to help you capitalize on the dynamic changes in healthcare.

Responsibilities:

Involved in the complete Software Development Life Cycle (SDLC) including Analysis, Design, Implementation, Testing and Maintenance.

Developing Web application using ASP.Net, ASP.NET MVC5, and C #, Entity Framework, JavaScript, Angular 2, JSON, HTML5, CSS3 and Bootstrap.

Designed and developed web forms in ASP.Net and C# .Net using .Net Framework. Developed the application Framework in ASP.Net primarily using C#.Net with the business logic implemented using .Net Assemblies.

Responsible for making AJAX Calls for the UI Interactions to the Controller Actions using JQuery and getting the Data back as JSON and parsing it onto the UI.

Extensively used C#.Net to develop server side event handling and components to handle business process

Extensively used User interface controls which use JQuery to validate client side validation. Effectively used JQuery a concise JavaScript Library for traversing HTML document, event handling and AJAX interactions.

Has worked on Angular2 which combines web applications with Model View Controller capability to make development and testing of code efficient.

Implemented Logging for ASP.net MVC applications with Log4Net.

Implemented CRUD functionality with Entity framework in ASP.NET MVC and implemented sorting, filtering and paging with Entity framework in MVC.

Expertise in Azure infrastructure management (Azure Web Roles, Worker Roles, SQL Azure)

Developed the reusable framework for the application using the ASP.NET MVC 4.0/5.0 and Web solutions developed using ASP.NET MVC, Razor and Entity Framework.

Used WCF for developing and deploying services on windows in line with the Service Oriented Architecture (SOA).

Used Windows Communication Foundation (WCF) REST services for multiple services to interact with the application for the clients.

Developed Web Services and invoking them by using XML, XSL, SOAP and WSDL for creating proxy classes. Used Web Services (SOAP, WSDL) for communicating with other application and components.

Worked on the enhancements of service layer and consuming the services using WCF services.

Modified Web Services to interact with the other applications and exposed them using SOAP and HTTP.

Developed ASP.Net Web API controllers that involved in implementation of service layer components and data object layer components using ASP.Net MVC web application.

Created CRUD operations with Web API Models and Entity Framework.

Used Http Response Exception to handle the exceptions in Web API and also customized the Exceptions using Exception Filters and registered them at the Action Level.

Converted .Net application to Microsoft Azure Cloud Service Project as part of cloud deployment.

Worked on Entity-Framework for Object-Relational Mapping (ORM).

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

Creating Tables, Indexes, Views, User defined functions, Triggers, Parameterized Query, Stored Procedures, Constraints and Roles for quick and efficient retrieval of data using SQL Server 2014.

Worked Extensively with Query Optimization Techniques to Fetch Data with better Performance Tuning.

Experience in developing the business reports using SSRS and Crystal Reports and Experience in SQL Server Integration Services (SSIS).

Used Windows Azure to deploy the application on the cloud and managed the session.

Develop applications using XAML and C#.

Used SSIS for data transformation from Excel data base to SQL Server 2014 and SSRS for reporting.

Performed Unit testing using NUNIT from the Designer GUI and participated in System Testing.

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

Used Team Foundation Server (TFS) for Version Control, Team build, Project Management, Data Collection, and Reporting.

Worked with testing team to fix the bugs as part of Bug life cycle and Production support.

Supported Operations team during the deployment and troubleshooting the production issues during deployment and on regular basis.

Environment: Visual Studio 2013, C#, ASP.NET MVC 4.0, WCF, Java Script, JQuery, ADO.Net, IIS 8.0, AJAX, Angular2, Bootstrap, HTML5, CSS3, Web API, XML, TFS, NUNIT, SSRS,Entity Framework, SQL Server 2012, UML, Windows Server 2012.

CIGNA HEALTH CARE, Bloomfield, CT Nov 2012- Aug 2014

.Net Developer

Project: (Health Management Connect)

Cigna is an American worldwide health services organization. Its insurance subsidiaries are major providers of medical, dental, disability, life and accident insurance and related products and services, the majority of which are offered through employers and other groups. Cigna also offers Medicare and Medicaid products and health, life and accident insurance coverage’s primarily to individuals in the U.S. and selected international markets

Responsibilities:

Worked on Agile methodology this includes Daily Scrum, Retrospectives.

Involved in the Software Development Life Cycle (SDLC) for the documentation, designing, development phase of the System.

Implemented ASP MVC 5.0 framework for the development of the application.

Created Data Access Layer, Business Logic Layer Classes using C# and .Net 5.0.

Used role based security functionality in MVC to restrict Users to certain pages Read only.

Extensively used JQUERY to make client side validations and used AJAX calls where ever necessary for auto filing fields and performing asynchronous calls.

Improvised user experience using JQuery. Used JQuery event handling mechanism to dynamically assign events on web controls.

Leveraged JQuery for page scripting, AJAX calls, JSON and XML for passing objects from Controller to View and vice versa.

Created various Angular Services &amp; injected them into Angular Controllers (using Dependency Injection) to enable AJAX calls and created custom angular directives to create own HTML tags and induce some kind of functional behavior to those tags.

Designed Front end using Bootstrap, Html, CSS, jQuery, JavaScript and AngularJS.

Utilize Font Awesome, Found Icon Components to design the bootstrap applications.

Extensively used XML and JSON Serialization for transferring the data from controller to view.

Created WCF REST Services and also used different bindings to make it available to different types of clients.

Designed and developed SOA architecture with WCF binding concepts for making data binding for end points.

Developed Web API REST controllers that involved in implementation of service layer components and data object layer components using ASP.Net MVC web application.

Used custom error handling in Web API to pass proper error message rather than generic error message to better understand the error.

Consumed different ASP.Net Web APIs to retrieve customer information and other application related information.

Used JQ-Grid View, Data List with Paging and Sorting for displaying various data on to the page.

Extensively used master pages for the layout of applications and used Partial Views.

Created reports for weekly, monthly and yearly schedule using Crystal Reports.

Created and maintained database objects like complex Stored Procedures, Packages, Triggers, Tables, Functions and Views.

Involved in deploying and testing Web Applications on IIS.

Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Team Foundation Server (TFS) is used as a version control for code repository.

Implemented Unit Testing, Integration Testing and System Testing using NUNIT.

Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files.

Implemented Interface whenever possible to enhance usability, testability and to increase performance.

Environment:

C# 4.5, Visual Studio 2013, ASP.NET MVC 4.0/5.0, ASP.NET 4.0/4.5, ADO.NET, VB.NET, Entity Framework 6.0/4.0, WCF, Web API, IIS 7.0, JavaScript, JQuery, AJAX, TFS 2012, XML, LINQ, NUNIT, Boot Strap, AngularJS, Microsoft Enterprise Library, SSIS, SQL Server 2012/2008 R2, SSRS, Windows XP, Windows Server 2008 R2/2008, SSRS, SSIS, SQL Server 2014.

Phycare Solutions, BANGALORE, India Nov 2010- Oct 2012

.Net Developer

Phycare solutions is a leading healthcare management company specializing in revenue cycle management solutions with a primary goals to optimize goals and ensure compliance by building high-end technology and personnel

working together in an efficient and cost effective manner.

Responsibilities:

Used AGILE SCRUM methodology to deliver in sprints and Status Meetings, Code Review Meetings.

Involved in scrum meetings, sprint reviews to better design a develop use cases and user stories in an efficient way.

Involved in creating user controls in ASP.NET 4.5 with MVC 4.0.

Designed and implemented application using Object Oriented Programming Web Forms, C#, HTML, ASP.NET, ADO.NET and User Controls.

Involved in Building web applications with ASP.NET MVC, JavaScript, JQuery, HTML, CSS.

Designed and developed various abstract classes, interfaces, classes to construct the business logic in Model using C#.

Extensively used ADO.Net objects to populate Data sets, Data grid and Repeater controls for display and manipulation of records.

Created a Data Layer object in C# language which gives the common classes of methods to execute stored procedures into a Data Set, Data Table and Data Reader.

Worked with ASP.NET Web Forms, Web Services, and State Management, Caching features, Configuring optimizations and securing the web application.

Maintenance of the existing application written on VB.net, Asp.Net on the forecasting space and re-writing those using the latest technologies as web based application.

Written code to access secure Web Services using .Net, Web form using C# and ASP.Net, WSDL, XML/SOAP.

Designed, developed and consumed .Net WebServices for the project and Development support for .Net web services in ASP.Net with C#.Net and consumed it.

Extensive use of Web Services, SOAP, XML, XSL to expose the reports to facilitate information sharing.

Created Data tables and applied the Web Service Enhancements to the Web Service so that the reliability increases.

Involved in POC (Proof of Concept) phase for design WCF service for connecting frontend interface and backend database and redesign SQL server database.

Develop and update enterprise solution using .NET technology with Oracle 11g in the back end to meet clients need.

Implemented Web Services and WCF to use in the application for critical operations.

Modified Web Services to interact with the other applications and exposed them using SOAP and HTTP.

Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins, sub-queries, accommodating complex filters and database links.

Developing SSIS packages for integration with downstream / upstream application and generating reports which could be sent to other systems.

Reports are generated by using SSRS and Reports variables are passed from ASP.NET web pages.

Involved in creating Dataset in the MS reporting services(SSRS) for calling the stored procedures and passed the parameters to the dataset.

Testing the application as per the test cases and business logic.

Performed Unit testing of the application and subsequently handled the debugging issues.

Using GIT as source control to check-in and check-out the code, TFS for tracking the status of the work.

Environment:

Visual Studio 2010/12, MVVM, C#, WCF Services, CSS, Design Patterns, SQL Server 2008, Entity Framework, JSON, XML/XSLT, JQuery and Agile Methodology.



Contact this candidate