.Net Sql Server

Name: SAI JOSHNA

Phone: +1-551-***-****

Email: ***********@*****.***

Professional Summary:

6+ years of IT experience in Analysis, Design and Development of high scalable Multi-tiered

Web Applications, Distributed Applications and Web Services using Microsoft Technologies.

Strong experience in various phases of Software Development Life Cycle ( SDLC). Expertise in

Application development, Project Management, Deployment and maintenance life cycle process.

Expertise in developing windows applications, web applications and programming with C#.NET,

VB.NET, ADO.NET, ASP.NET, JavaScript, AJAX, Assemblies, JQuery and Angular JS by

using .Net Framework 2.0/3.0/3.5/4.0/4.5.

Developed Graphical User Interfaces using HTML/HTML4/HTML5, CSS/CSS3, XML,

XAML, Java Script and AJAX.

Experience in developing applications using Entity Framework MVC architecture and

MVVM.

Extensively used Windows Communication Foundation (WCF) & Web services for Web

applications using SOAP, WSDL and UDDI to implement SOA.

Expertise in using Language Integrated Query (LINQ) providers for data manipulation.

Extensive experience in XML, XML Web Services, WWF, WPF, XSLT Security in ASP .NET.

Good knowledge in Object Oriented Analysis/Design and implemented Design Patterns across

the applications.

Implemented Object Oriented Programming (OOP) concepts in most of the applications.

Proficient in Application Design, developing Use-case diagrams, class diagrams, sequence

diagrams using UML.

Strong knowledge in writing unit tests with MS Unit and NUnit.

Experience in developing UI using Silverlight 3.0/4.0,WPF, ASP.Net Server Side Controls,

HTML Controls, CSS, JavaScript, and JQuery.

Extensive database designing and programming skills using SQL Server 2000/2005/2008/2010,

RDBMS and MS Access.

Hands of experience in SQL Server in writing database queries using joins, Indexes and in

creating Tables, Views, Indexes, writing Stored Procedures, Functions and Triggers using T-

SQL, Maintaining Database, Experience in Query Optimization.

Developed the test scripts and performed the unit and integration testing of the functionality.

Good knowledge on reporting and analysis using Crystal Reports, SQL Server Reporting

Services (SSRS) and SQL Server Integration Services (SSIS) with the .net environment.

Developed out-of- box workflows and custom workflows for CRM 2013/2011 based on user

needs.

Good experience in deploying and testing web applications on IIS 5.0/6.0/7.0.

Experience in using Team Foundation Server (TFS), Visual Source Safe (VSS) and CSV for

Version Controlling.

Experience in implementation of N-Tier Architecture in Windows and Web based, Client/Server,

internet/intranet and distributed applications in Microsoft Technologies.

Excellent Analytical, Organizational, Interpersonal, Communication skills, technical skills

and developing systems using different software methodologies like Agile and Waterfall,

accustomed to work in a team environment with tight schedules and capable of working

efficiently under pressure.

Using IIS 10, GIT, Umbraco, CMS setup the environment to run the websites based on

authentication and authorization and loading the shared networks.

Good experience in deploying and testing web applications on IIS 6.0/7.0.

Extensive experience in creating tables using PL/SQL, Oracle, reporting solutions like Crystal,

RDLC reports.

Education: Bachelor of Engineering from Jawaharlal Nehru Technological University, India.

Technical Skills:

Microsoft Technologies Microsoft .Net Framework, ASP.Net, MVC 4, Silver light, Web Forms, Win

Forms, WPF, WCF, ADO.Net, LINQ

Web Technologies Web Services, HTML, DHTML, SOAP, WSDL, AJAX, XML, XSL,XSLT

Web Servers IIS 5.0, IIS 6.0, IIS 7.5

Programming C#, ASP.NET, VB.NET, VBScript, HTML, CSS, DHTML, PHP

Languages

Development Tools Visual Studio .NET 2003/2005/2008/2010/2012, Microsoft Team

Foundation Server, Agile Methodology, Rational Rose, UML, Microsoft

Office Visio, Dreamweaver.

Client side Technologies JavaScript, JQuery, AngularJs, Bootstrap

Frameworks Microsoft .Net 4.5/ 4.0/ 3.5/3.0/2.0

Databases SQL Server 2012/2008/2005, Oracle 10g, 11g, PL/SQL

BI Tools SSIS, SSRS, SSAS

Version Controller Visual SourceSafe(VSS), Subversion(SVN) and Team Foundation Server

(TFS)

Database Tools SQL Server Query Analyzer

Software Packages MS-Office 2003/ 07/10/13

Operating Systems Windows Win7/XP/NT/2000/2002/2008/2012

Methodologies Agile, Scrum, OOPS, OOAD, SOA.

Professional Experience:

Client: Infoblox, Santa Clara, CA July 2015 June 2016

Role: .NET Developer

Description: The Company focuses on software and hardware for managing Internet addresses and

identifying devices connected to networks specifically solutions for Domain Name System, Dynamic

Host Configuration Protocol and IP address management.

Responsibilities:

Involved in all stages of SDLC including designing, coding, testing and implementing the

application following Scrum (Agile) methodology.

Involved in designing, trading and documentation of application flows and developed functional

diagrams using Visio worked on presentation layer for developing GUI and developed various

Web forms using ASP.Net.

Coding, testing and implementing the project using C#. NET, ASP.NET, SQL Server, SQL

Integration Services and Oracle.

Created Windows Power Shell Scripts for SFTP, TFS, Packages and Autosys Jobs.

Developed ASP.Net Custom controls and User Controls.

Developed UI controls using VB.NET.

Worked on Service Oriented Architecture (SOA) for developing application.

Worked with ASP.NET Web Forms, Web Services, and State Management, Caching features,

configuring optimizations and securing the web application.

Developed Web Services and invoking them by using XML SOAP and WSDL tool for creating

proxy classes.

Worked on AZURE, created the instances, Configured the Geo-Replication, Installed the

Windows server, adapted web applications to run in Windows Azure against SQL AZURE using

Azure Queues for background processing.

Worked on customizing Microsoft Dynamics CRM securities, hierarchies, roles, profiles etc. for

the company.

Migrate from MS CRM 2011 to MS CRM 2015.

Customize MS CRM on business requirement.

Designed Web UI Interface using HTML5, CSS3, Bootstrap, JQuery, and AJAX.

Used Web API, Entity Framework, LINQ, Lambda Expression, JSON for REST Services.

Applied HTTP methods to perform CRUD Operations.

Used HTML5 validators, bootstrap validator for handling inputs from the users for client side

validation and data annotations and forms authentication for server-side validation.

Implemented search filter using AngularJSfilter, create custom filters for specific use.

Used AngularJS directives such as ng-model, ng-bind, and ng-repeat to display data from

AngularJS controllers, factory and services.

Used Web Services (SOAP, WSDL) for communicating with other application and components.

Worked on AJAX frame work for interactive web application and used Microsoft ADO.NET to

access data from database in them.

Extensively used the LINQ feature in .NET 4.0 for querying collections and integrating with

SQL.

Used SQL server 2012 for writing Stored Procedures, Views and Triggers.

Developed web pages with data bound controls like Data Grid, Data List and Data Repeater

using the methods Data Binding and Data Templating.

Designed large numbers of Windows Presentation Foundation (WPF) Window Forms,

Custom Controls and User Controls using XAML language for UI and Dynamic Web Parts for

personalized content which allows Change, Edit, Move the content on pages as per users' own

choice. Used WPF built-in set of data controls to bind and manipulate data within applications.

Extensively used Report Wizard, Report Builder and Report Manager for developing reports and

deploying reports in SSRS.

Experienced in Software Configuration Management, setting up company Version policies

utilizing Team Foundation Server (TFS).

Consumed WCF services to get the Customer Information from different legacy applications.

Implemented Javascript and Jquery script to implement UI validations with Angular JS for the

client.

Environment: ASP.Net, Visual Studio 2010, ADO.Net, C#.Net, VB.Net, Microsoft, JQuery, IIS V.7,

CSS, WPF,AJAX Controls, WCF, Web services,HTML5, XML, XSLT, SOA, ASP.NET MVC 4,

MVVM, SQL Server 2010, SSRS, XAML, Javascript, Angular JS.

Client: Thomson Reuters, Minneapolis, MN October 2014 June 2015

Role: .NET Developer

Description: The software that contains all input and output tax forms, is a Silverlight application written

in VB.Net. This project involves making changes to the business logic of the application as per the new

rules by IRS, writing unit tests to meet the tax reason.

Responsibilities:

Participated in System Analysis and Application Designing Sessions with project managers,

business analysts and team members to analyze business requirements and outline the proposed

IT solution.

Developed a 3- tier web application following agile development methodology.

Design, develop, test, debug, and implement Silverlight 5.0 based applications following the

MVVM framework template.

Implemented rest services using MEF and .Net 4.0 for Silverlight client.

Developed programming scenarios in C#, object oriented Programming (OOP) concepts such

as: encapsulation, inheritance, polymorphism, and abstraction.

Involved with Analysis and designing of the application.

Used Team Foundation Server (TFS) as Source Control and Document management.

Performed unit testing to ensure quality and optimum performance output.

Involved in design and maintenance of DB2 Server database, including requirements analysis,

design, data conversion, data loading, testing and implementation.

Writing Stored procedures, triggers, views and function for enhancements and development.

C#.NET is used to program business logic including Code-behind files and Classes in the middle

tier.

Used JavaScript and .NET Validation Controls for performing client-side validations.

Developed Service Oriented Architecture (SOA) that provided methods for system

development and integration.

Extensively involved in User Interface designing using Web forms and also Win forms.

Extensively created GUI User Controls using server controls of ASP.Net like Data grids,

Repeaters, Textbox, Button, Dropdown List etc.

Designed user interface screens and implementing / coding application logic under Microsoft

.NET framework using C# to use .NET features that powered with CLR.

Worked on ADO.NET Entity Framework and LINQ for developing the core data layers.

Designed and Architected the Application using MVC and designed the application using

responsive web design to work on different devices.

Worked in ASP.NET Web Forms, ASP.NET State Management, ASP.NET caching features,

configuring ASP.NET optimizations, securing ASP.NET web application and used ADO.Net

to connect to SQL Server.

Developed client side validation through Angular JS and dynamic UI using JavaScript and

HTML5 and DHTML.

Implemented SSIS and DTS packages to extract, transform and load (ETL) data packages.

Used Web forms, ADO.Net in ASP.Net for security checking purposes.

Documentation of developed Components and module.

Testing and packing of the developed module.

Responsible for Database support of the application.

Performed database operations on SQL Server 2008 to create and maintain customers

information by creating SQL queries, stored procedures, functions, and views.

Developed and consumed WCF service to access Data layer components.

Created complicated reports like parameter based reports, sub reports, well formatted

reports, matrix reports, chart and tabular using SSRS 2008.

Environment: Windows server, Visual Studio 2008/2010, ASP.Net, C#, VB.Net, ADO.Net, XML, .NET

Framework 4.0, IIS 6.0, C#.NET, HTML4, CSS, AJAX, JavaScript, Silverlight 4/5, Angular JS, WCF,

Web Services, SQL Server 2008, T-SQL, Crystal Reports, SSIS, SQL Reporting Services(SSRS).

Client: HSBC, Chicago, IL December 2013 September 2014

Role: .NET Developer

Description: The project involved redesigning the Home Banker portion of the application according to

the new business specifications. The new modifications which had to be incorporated mainly involved

segregation of both checking and saving account modules into several other that s uit each customers

individual profile and needs. The project also involved making change and adding some additional

features into the existing electronic banking.

Responsibilities:

Primary responsibilities entailed analysis, design and development of the application.

Did the documentation of the functional/requirement specifications.

Used Model View Controller (MVC) architectural Design Patterns for the development of the

product.

Developed solutions using C#, ASP.NET MVC and ADO.NET Entity Framework.

Involved in translating business requirements into technical solutions.

Created and validated Views, Models and Controllers of MVC Framework and implemented

features of security, testing of application.

Developed detailed Technical Specifications for subsystems and code for enhancing existing

programs or developing new programs.

Designed interactive ASP.NET MVC views using JQuery, HTML5, CSS3, AngularJS,

Knockout JS and AJAX to provide excellent user experience.

Followed SOA (Service Oriented Architecture) and built loosely coupled layers.

Developed and consumed RESTful Services using WEB API.

API is secured using the popular OAuth 2.0 standard, and communicates with the client

using JSON.

Implemented XML Web Services in ASP.NET to extract the data from Java application.

Developed and consumed WCF, REST Services in the services layer.

Maintained ASP.NET Web services using C#.

Implemented client side validations/scripting using JQuery and also used AJAX.

Involved in Web Services to WCF based on Service Oriented Architecture (SOA) using SOAP

messages.

Maintaining records in excel spread sheets and exploring data in to SQL Server Database.

Implemented Stored Procedures, Triggers, Tables, Views and SQL Joins in SQL Server 2012.

Performed Unit Testing on the code.

Utilized ADO.NET Entity framework extensively for data retrieving, querying, storage and

manipulation using LINQ.

Involved in preparing the documentation for design and code module that developed.

Environment: C#4.0, ASP.NET4.5, ADO.NET, SQL Server 2012, ASP.NET MVC 4.0, JQuery,

HTML5, AngularJS, CSS3, IIS 7.0, AJAX, SOAP, SOA, Visual Studio 2012, WCF, Web Services,

XML, TFS, Entity Framework.

Client: CVS Caremark, Irving, TX October 2012

November 2013

Role: .NET Developer

Description: The purpose of Health Management System is to develop and deploy a new front-end tool

to view the Patients full data & medical repository data belonging to CVS Caremark. It gives the user

access to patients information, doctors information, patients diagnosis, business inventory, services

information, and information about business marketing besides enhanced the billing software to bill

Medicare.

Responsibilities:

Analyzed the complex requirements and quickly turned around the code.

For Case Management System, implemented JavaScript and Jquery to perform CRUD

operations with validations.

Creating intuitive, flexible User Interfaces using Razor view engine.

Developed Web application using ASP .Net MVC, C#, JavaScript, Jquery, HTML5

and CSS3.

Worked on ADO.NET Entity Framework and LINQ for developing the core data

layers.

Practiced zero defect strategy continuously for 3 months by working closely with QA,

BA and the end users to deliver code efficiently with highest quality standards.

Involved in testing of application by Unit Testing, Integration Testing and User

Acceptance Testing (UAT).

Mentored co developers and offshore team members.

Developed and consumed Restful Services using WEB API.

Worked with Team Foundation Server (TFS) control which stores all code, as well as a

record of all changes and current check-outs in Project.

Implemented SSIS and DTS packages to extract transform and load data packages.

Developed and consumed WCF service to access Data layer components.

Maintained and developed few complicated reports like parameter based reports, sub reports, well

formatted reports, matrix reports, chart and tabular using SSRS 2012.

Environment: MVC, C# .NET, MS SQL Server 2012, Microsoft Visual Studio 2013, jQuery, Java

Script, Type Scripts, Bootstrap.

Client: Flipkart, Hyderabad, India June 2011 August 2012

Role: Jr.NET Developer

Description: Flipkart is a complete, fully integrated order and production processing system for fashion

manufacturers, wholesalers, importers, and distributors. With Flipkart, apparel businesses of all sizes can

leverage a full suite of management tools that automate and enhance critical operations. This featured-

rich system offers sophisticated tools to help manage all functions of your business, such as our unique

and customizable dashboards.

Responsibilities:

Involved in analysis, design, development, testing, implementing and supporting large scale web

based applications in Microsoft/Windows platform using .Net framework 2.0, ASP. Net,

VB.Net.

Direct experience in performing analysis and requirements gathering with customers.

Developed and maintained 3-tier application for maintainability and scalability of the application.

Created classes and core modules in VB.Net for implementing business layer.

To exchange data from database used ADO.Net objects and developed LINQ Queries.

Created and consumed WCF services and Web services to store product data in SQL Server

Tables and to get the data from the external system.

Developed Web Forms Using ASP.NET & VB.Net.

Used Java Script for validating client side data entry web screens.

Developed the components for middle tier (Business Layer) using VB.Net.

Developed Tables, Joins, Functions, Views, Constraints and Triggers in Microsoft SQL

Server 2005. Extensively developed Stored Procedures in Microsoft SQL Server 2005 in

exchanging data through database tables.

Worked with a team to design and implement module level unit test cases.

Improved the application performance using stored procedures and connection pooling and

Memory management.

Involved in bug fixing and unit testing.

Environment: .NET Framework 2.0, VB.NET, ASP.NET 2.0, ADO.NET, XML/XSLT, Web Forms, SQL

Server 2005, HTML, Java Script, Visual Studio 2005.

Client: Whirlpool AMC, Hyderabad, India April 2010 May 2011

Role: Jr.Net/UI Developer

Description: The Whirlpool Corporation is an American multinational manufacturer and marketer

of home appliances. The applications for the client involves with product inventory details, product parts

Id, processing employees data through kiosk machines, sales. There are more than 50 applications

dealing with various functionalities in project.

Responsibilities:

Developed Web Forms Using ASP.NET & VB.Net.

Used Java Script for validating client side data entry web screens.

Developed the components for middle tier (Business Layer) using VB.Net.

Developed Reusable Classes using VB.Net.

Developed Data Layer using ADO.NET to communicate with MS SQL Server.

Improved the application performance using stored procedures and connection pooling and

Memory management.

Developed Custom User Controls to reduce the Complexity in User Interface Coding and provide

better look and feel.

Environment: .NET Framework 2.0, VB.NET, ASP.NET 2.0, XML/XSLT, Windows XP, SQL Server

2005, HTML, Java Script, Visual Studio 2005.

Contact this candidate