Post Job Free

Resume

Sign in

Sql Server .Net

Location:
St. Louis, MO
Posted:
March 01, 2017

Contact this candidate

Resume:

PROFESSIONAL SUMMARY

Professional Software developer with 8+ years of diverse Experience in System Analysis, design, development and implementation of various enterprise e-business solutions and n-tier architectures leveraging the power of Microsoft Technologies for various business domains.

Expert in designing and developing web and windows based applications using MVC, ASP.NET, C #, ADO.NET, Entity Framework, Enterprise Library, LINQ, SOAP, Web Services, Web Api, AJAX Control Tool Kit, IIS, XML, XSLT and SQL Server, JavaScript frameworks like (Knockout/Angular/React/Require js).

Experienced in building rich internet (RIA) web applications using HTML, HTML5, XML, Ajax, JQUERY, JavaScript, Angular JS, and CSS 3.

Experience in building SOA applications using .NET, JSON, Web-API, Web services, WCF, SOAP and REST.

Good experience with development methodologies like Agile (SCRUM), Waterfall and Test driven development.

Good working experience with ADO.NET, Microsoft Application Blocks and Entity Framework as a part of accessing and updating the database.

Strong Experience of using MVC 5.0/4.0 Razor view engine.

Expertise on using Re sharper 7.0 tools for Code Optimization

Worked with Telerik Kendo UI Dropdown List, Grids, and Editor Etc.

Experience in working with Language Integrated Query (LINQ) especially LINQ to object and LINQ to SQL.

Experience in designing and developing Databases in SQL Server 2012/2008/2005 which includes the development of Stored Procedures, User Defined Functions and Triggers using Transact SQL.

Expert in creating SSIS Packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Experience in updating, accessing and version controlling the source code using Visual Source Safe (VSS), Team Foundation Server (TFS), Subversion (SVN), and GIT.

Experience in interacting with client, end users for understanding the requirements and preparing Business Requirement documents and Functional Specifications, Process Flow diagrams, Class diagrams, Sequence diagrams and UML data Models.

Strong knowledge of Object Oriented Programming System(OOPS/OOAD) concepts including inheritance, polymorphism, encapsulation and abstraction and Used design patterns like Factory, Singleton and Observer Pattern, Facade etc...

Experience in accessing Azure BLOB, Table and Queue Storages.

Experience in implementing Securities like Authentication and Authorization using Form-based & Window-based authentication, Authorizing Users, Roles and User Account Impersonation.

Good experience in Exception Handling, Debugging and tracing by which the whole picture of application runtime behavior can be seen and analyzed more efficiently.

Experience with different debugging tools like Developer tools, Fiddler, Firebug, and Sql Profiler etc.

Maintaining and setting up new IIS application pools across multiple domains.

Expertise in trouble-shooting and problem solving with proven ability to design and develop reliable data driven applications.

Excellent debugging skills in resolving the problem logs and bugs logged by testers and business users.

Strong and effective problem-solving, analytical and interpersonal skills, besides being a valuable team player.

TECHNICAL SKILLS

Microsoft Technologies

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

ADO.NET

Programming Languages

C#, VB.NET, Java, SQL, Windows Scripting

Web Technologies

HTML, HTML5, CSS, Bootstrap, CSS3, XML, JavaScript, Angular JS, JSON, JQUERY,

Testing Frameworks

Visual Studio Unit Testing Framework, N Unit, Unit testing.

Database Languages

Microsoft SQL Server 2005/2008/2012, Oracle 10g, MS Access

.Net Technologies

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

Tools & IDE

Microsoft Visual Studio 2005/2008/2010/2012/2013/2015, SQL Server Management Studio, Eclipse

Application Servers

IIS 4.0/ 5.0/6.0/7.0

Reporting & Integration Tools

Microsoft SQL Server Reporting Services(SSRS), Microsoft SQL Server Integration Services(SSIS)

Version Control Tools

Tortoise SVN, TFS, GIT

Development Environments

Agile/Scrum, Waterfall

PROFESSIONAL EXPERIENCE

Client : BCBSNC, Valley park, NC Dec '15 – Current

Role :Sr .Net Developer

Environment: Visual Studio 2015, C#, ASP.NET 4.0, TFS, GIT, OData, Web API, XML, IIS, Bootstrap, HTML5, CSS3, JavaScript, Razor, WCF, SQL Server 2012, Agile,.NET Framework 3.5/4.5, Web Services, Angular JS, MVC 5, Dependency Injection, NUnit, Image Builder, Power Shell, iScope, Rascal Mini.

Responsibilities:

Analyzed business requirements, and participated in Object Oriented design discussions.

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

Greatly involved in the Software Development Life Cycle, from the Design phase to the Implementation phase, Testing and Deployment. Used the MVC Design Pattern.

Worked on proven design pattern, designed and created views, controllers and models using ASP.NET MVC 5, C# within MS Visual Studio 2015

Worked on creating Factory pattern in data access layer to provide the interface handle to business logic layer.

Worked on Dependency Injection Design Pattern in presentation layer for creating loosely coupled classes with business layer.

Worked with ASP.NET MVC 5.0/4.0 View Engines like ASPX and Razor.

Used Bootstrap, AJAX, JQUERY with MVC views to produce rich user interface.

Worked on JQUERY lib to post data to MVC action method.

Working with JQuery Ajax, CSS3, and callback Objects, Effects and Events.

Contributed in UI Development using AngularJS and JQuery.

Created various Angular Services to make AJAX calls and custom angular directives to create own HTML tags and induce some kind of behavior to those tags.

Wrote SPA (Single Page Web Applications) using RESTFUL web services plus Ajax and Angular JS, HTML 5, CSS3, jQuery, LESS, Bootstrap.

Worked on creating the business logic layer and used log4net to log errors to the database.

Used WCF Services for communicating with other application and components.

Developed application in Agile model and involved in daily scrum meetings. Deployed the application on test and production servers.

Extensively used Nuget packages.

Hands-on experience in implementing application security using Forms authentication mode.

Involved in support and maintenance. Developed code documents and user documents.

Worked on Team Foundation Server (TFS) for version control during development and maintenance.

Involved in technical support and documenting the user manual. Performed NUnit testing for system, automated and end-end testing and prepared requirement documents for testing.

Performed unit testing and functional testing. Fixed the issues occurred during testing process.

Client : Western Digital, San Jose, CA Jan '14 – Nov '15

Role :Sr .Net Developer

Environment: ASP.Net 3.5/4.0/4.5, C#, iBATIS.net, N Unit, Log4Net, JavaScript, Jquery, AJAX, Perforce Version Control, XML, Oracle 11g, Toad, HTML5, Linq, MSMQ, Web-Services, IIS7, Visual Studio 2010/2012, Telerik Controls, Reflection, Spring, MVVM.

Responsibilities:

Working as a Sr. .Net Developer on the web based application.

Application was developed on the platform of Visual Studio 2010 with .Net Framework 3.5 which got converted to .Net Framework 4.0 with Visual Studio 2012 providing platform for development.

Web Services (WCF/Web API/json based services) were used for premium calculations functionality.

Normalize the Logical data-model and edit the fields if not required from the existing tables.

Create relational database for new requirements and newly added tables to the database.

Application state used to preserve data on both a per-page basis and an application-wide basis

Create Customized Business Objects for implementing required business logic.

Used Perforce version control tool for tracking different environment code.

Used Telerik /Kendo UI Controls and FMH's developed controls for the UI developments.

Worked on the navigations of the application by using Spring technology.

Worked on Third-party web service to consume them and to send the data for storage in third party tool.

Create Business logic and provide view objects for the UI, code-behind and the domain level data connectivity.

Worked in a agile environment where Test Driven Development is adhered. Developed test cases using NUnit /MSTest/MOQ frameworks. Used entity framework as an ORM for mapping between SQL and .NET objects

Used Log4Net tool for the logging functionality in the application.

Interacting with business users, analyzing the existing business processes and systems.

Discuss the requirement with clients to provide valid scenarios of the application.

Working with end clients to understand their business needs and providing cutting edge solutions for their business growth.

Client :Steel wedge, Pleasanton, CA Oct '12 - Jan '14

Role : .NET Developer

Environment: ASP.NET, C#, VB.NET, ADO.NET, Visual Studio.NET 2010,T- SQL, XML, SQL Server 2008, AJAX Control Toolkit, AJAX Library, WCF.

Responsibilities:

Designed and Developed Business Layer/Data Layer using C#.NET, VB.NET, ADO.NET and SQL Server.

Gathering functional requirements for the module.

Involved in developing the WCF services for Loan, recent Campaign Loans and Borrower modules.

Developed Loan, Recent Campaign Loans and Borrower modules for web portal using ASP.NET, JQUERY, C#.NET and Web User Controls using Test Driven Development (TDD).

Designed User Controls for document upload, Comments Input, Multi Select Dropdown etc. which were used heavily across the application.

Worked on JavaScript/validation controls for client side validation.

Worked on AJAX Library to make client side web service calls and partial post backs.

Worked on CSS classes/skins for client side control UI formatting and provide same look and feel throughout the application.

Worked on creating and consuming WCF web services using C#.

Used LINQ to SQL to access the Database.

Worked on writing several stored procedures, functions in T-SQL.

Wrote SQL Queries, Stored procedures, Joins and LINQ queries to process large collection of products, rules and used ADO.NET Data Reader, Data Adapter, SQL Command and Dataset for retrieving data from database

Carrying out unit testing and integration testing of the module.

Extensively used T-SQL in constructing Stored Procedures, triggers, cursors, tables, user defined functions, views, indexes.

Worked on using Tortoise SVN for source repository and version control.

Client :Nineminds, India Mar '10 – Sep '12

Role : Sr. .Net Developer

Environment: ASP.Net 4.0, C#, MVC 4, JavaScript, jQuery, AJAX, Commerce Server 2009, XML, SQL Server 2005/2008, HTML, WCF, Web Service.

Responsibilities:

I was working on UI performance of the website and was also involved in creating and adding new modules to the web application.

All 7 web application were developed in .Net3.5 and then converted to .Net4.0 framework with c#.

Worked with Commerce Server 2009 tool to handle the dynamic Image/ Advertisement uploading for the website.

Extend the Commerce Server Line-Item object to add customized functionality on Line-Items within a Commerce Order-Form.

Used Commerce Server to enables vendors to upload product information, modify existing product information or deactivate a product from catalog sale list.

Used Omniture facility to get most recommended products from the site and for the random Ads for different products on the website.

For version controlling and code implementation TFS 2008 has been used. And was in process of upgrading to TFS 2012.

Created User controls for reusability of the same control in different pages.

Involved in the new module planning designing and development cycle.

To increase the performance of the websites developed some of the JavaScript and Jquery.

CSS was also very important part of the development in which I was involved as it was retail based website look of the site must have to be attractive.

Client : Enterprise T Sysytems, India Jun '07 – Feb '10

Role : Software Developer

Environment: Visual Studio.NET 2005, C#, ASP.NET, ADO.NET, IIS, XML, SOAP, SQL Server 2005, CSS, HTML, Web Forms, DB2.

Project: BOSS (Brokerage Operations Support system)

Responsibilities:

Worked on developing specifications for e-Leave and e-Claims modules.

Worked on ASP.NET Server Objects to define declarative, modular functionality and reused by other ASP.NET pages.

Worked on creating data flow diagrams and flow charts for the above two modules.

Worked in the data-modeling phase of Database design (creating ER Diagrams & data document).

Worked on the UI design of the ASP.Net pages.

Worked on developing Web Forms using ASP. NET, C#, SQL server, WCF.

Created XML data and Schema Files.

Worked on Themes and CSS for the layout of the web application

Worked on developing the code behind classes in C#.NET.

Used ASP.NET validation controls (Required field validator, regular expression validator, compare validator, range validator), User Controls, Custom Controls, Data Grid Web Control.

Worked on output and data caching of frequently requested web pages and data objects.

Created data access layer to communicate with the SQL Server Database with ADO.Net objects

Worked in developing the component that talks to database using ADO.Net objects.

Worked in implementing Stored Procedures call in the data access layer.

Used ADO.NET and data objects such as Data Adapter, Data Reader, Dataset, data table, stream reader and XML Text reader/Writer for access to SQL data sources.

Created Stored Procedures, Functions, and Triggers using T-SQL in SQL Server to insert, update, and delete data inside tables.

Created Stored Procedures in both SQL Server and DB2 and involved in several DTS.

Worked in implemented role based security for the user groups.

Worked in Functional Test, User Acceptance Test and stress test.

Performing unit testing for various modules of the system.

EDUCATION

Professional Qualification: Bachelor of Engineering in Computer Science.

REFERENCES

Will be provided on Request.



Contact this candidate