Sql Server .Net

Koushik Bolisetty

Phone: 408-***-****

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

SUMMARY:

Around 3 years of professional IT experience in Systems Design, Development, and Testing, Integration and Implementation of Client/Server and web based n-tier architecture systems with strong knowledge of Microsoft technologies.

Involved in various phases of Software Development Life Cycle (SDLC) and AGILE SCRUM methodologies of Analysis, Design, Development and Implementation, Testing and User Training of Enterprise Web Applications, Stand alone and Distributed applications.

Demonstrated proficiency in development using Microsoft.NET technologies like WCF, LINQ, ASP.Net 4.0/3.5, ASP.NET MVC 4.0/3.0, C#(4.0/3.5), VB.NET and AJAX Extensions, JQUERY with MS SQL Server (SQL 2008) and Oracle 10g/9i as database.

Hands on experience in design using Object Oriented concepts (OOPS) like Inheritance, Encapsulation, Polymorphism, Abstraction, Exception Handling, Events, Delegates and Interfaces in C#.

Extensive experience of various technologies like AJAX, LINQ, WCF, Web Services, etc.

Responsible for designing Presentation Tier (web pages) using the concepts such as Master Pages, Themes, Skins, HTML, XML, CSS, Java Script, JQuery and also Worked With ASP.NET Custom Controls.

Experience in XML technologies like DOM, X-path, XSLT, SOAT, XML-scheme, DTD, and web services.

Worked extensively with ADO.NET objects such as Data Adapter, Dataset, and Data Reader to interact with Databases like SQL Server 2008/2005 & Oracle 9i/8i.

Experience in database related work primarily creating complex stored procedure, DTS packages, Views, Triggers, Functions, using PL/SQL, T-SQL.

Very good experience with Reporting Tools SQL Server Reporting Services (SSRS) and Crystal Reports.

Experience in developing automated tool to use TFS API’s for check in/checkout/Branch/Merge. Experience in adding and updating TFS work item using TFS API.

Excellent Written, Analytical Skills, Verbal Communication skills with a customer service oriented attitude and worked with the offshore team as onsite coordinator to provide the update on the daily basis.

EDUCATION:

Masters in Computer Science from Virginia International University

Bachelors in Computers Science from JNTU

TECHNICAL SKILLS

Programming Languages: C# 4.0/3.5,VB.NET, PL/SQL

WEB Technologies: .NET Framework 3.5/3.0/2.0, ASP.NET 4.0/3.5/3.0/2.0, ASP.NET MVC

4.0/3.5

XML Technologies: XML, XDOCUMENT, XSLT, XPATH, XSL

UI Technologies: Win forms, WPF, ASP.NET Web Forms

IDE Tools: Visual Studio 2013/2012/2010, SQL Server Management Studio

Databases: MS SQL SERVER 2008/2005/2000, MS Access and LINQ

Middle ware: WCF, ADO.NET 4.0/3.5/3.0/2.0, MSMQ, Web Services, Enterprise Library 4.1/3.1, Entity Framework

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

Version Control Tools: Visual Source Safe 2005/2008

PROFESSIONAL EXPERIENCE:

CLIENT NAME: FIRST DATA CORP. LOCATION: OMAHA, NE

DURATION: MAY 2016 To TILL DATE

ROLE: .NET DEVELOPER

DESCRIPTION: First Data’s Open Loop Prepaid business unit operates open loop prepaid programs, primarily under the Money Network brand. It provides the technical and operational facilities to enable organizations and financial institutions to market and operate the hosted open loop prepaid programs. It supports funding, payment, and program management services for association-branded prepaid cards programs as well as reporting services for paystubs. Card Management System (CMS) is a web application for administration of its Prepaid Open Loop card operations.

ROLES & RESPONSIBILITIES:

Responsible for developing Application using ASP.NET MVC 4.5 and C#.

The project went through full SDLC using Agile.

Involved in Requirement gathering, design, development and maintenance. Used UML for designing the application.

Actively involved in coding and designing using C#, XML, ADO.NET, JavaScript, HTML, and Cascading style sheets (CSS3) and JQuery.

Used WCF Client, Soap UI and Fiddler tools for validating WCF request and responses.

Used Validation Controls for corresponding validations required for business logic in the Forms.

Responsible in developing Stored Procedures, Views, Indexes, Scripts for database transactions on SQL Server 2014.

Used Entity Framework to retrieve and save data and also utilized LINQ to SQL queries.

Involved in developing Web Service classes using SOAP to communicate with legacy Systems and also deployed web services as per business requirement.

Created reusable Partial Views and used them in the user interface along with a third party Graphical Menu controls.

Created custom java script templates.

Responsible for developing Layout, Nested Layout Pages, Partial Views Using CSS style sheets for having common layout and look and feel to all the controls.

Responsible is using JQuery for Client Side Validations, Calling the Controller Actions, and Making calls to the WCF Services.

Generated reports using SQL Server Reporting Services (SSRS) and responsible for SQL query optimization using profilers.

Used SSIS to developed packages for data migration

Used TFS for maintaining the component and for release and version management.

Coordinate with the QA Team for Unit Testing and Integration Testing of different modules.

Responsible for resolve bugs according priority.

Responsible for project related things like Code reviews, documentations, gathering requirements from BA, creating new builds and observing existing builds.

Used SLICK JQuery plugin to display carousal design in UI.

Environment: Visual Studio 2012, C#, VB.Net, .Net Framework 4.0,ASP.NET MVC 4.0, WCF, Entity Frame Work 6.0, JQuery, TFS 2010, WCF, IIS 7.0, AJAX, ADO.NET, LINQ, XML, Microsoft Enterprise Library, NUNIT, SQL Server 2008 R2, T-SOL, REST, SOAP.

CLIENT NAME: CA&L (COMPUTERIZED ASSESSMENTS AND LEARNING) Internship LOCATION: LAWRENCE, KS

DURATION: AUGUST 2015 To APRIL 2016

ROLE: .NET DEVELOPER

DESCRIPTION: Computerized Assessments and Learning operates as an indirect, wholly owned subsidiary of ETS and continues to provide the flexibility, efficiency and agility in the delivery of services to its clients. Educational Testing Service develops, administers and scores more than 50 million tests annually.

Developed the application using ASP.NET MVC 4.0, C#.NET, AJAX, JQuery, HTML5, JavaScript, Bootstrap and CSS3.

Extensively implemented Object Oriented Programming Functionalities.

Developed Business Logic for the modules in a separate Business Layer in C#.Net.

Created the Editor and Display templates for MVC controls.

Used Master Pages, shared layouts, CSS & Themes for the consistent look of the application.

Created View models to encapsulate all models and classes used on the different views for a more organized, structured, and clean code.

Used EDI to create EDI Generator, Translator, and Analyser.

Used EDI to tackle EDI file conversions such as converting EDI to XML.

Used Share Point in different aspects like creating customized pages and in making search process more efficient.

Designed and developed class library for Domain entities using Entity Framework 5.0.

Used Interfaces to provide service and implementations.

Written AJAX asynchronous calls.

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

Involved in writing complex SQL Statements, Views and Stored Procedures, Indexes to validate data and ensure system integrity and security Written LINQ functions for data access.

Developed test-driven development (TDD) strategy guiding use of the NUnit unit testing framework.

Used Team Foundation Server (TFS) for continuous integration and version control.

Used Fiddler to debug web request and responses.

Assisted QA team in building scripts in Test Partner tool for functional testing.

Used BizTalk Server to map different database schemas.

Used WCF service to make the web service available to remote users regardless of the platform they are using.

Environment: ASP.NET MVC 4.0, N-Unit, Entity Framework 5.0, SQL server 2012, visual studio 2012, TFS, C#, java script, JQuery, HTML 5, WCF, AJAX, LINQ, CSS 3, Boot Strap.

CLIENT NAME: SYMBIOSIS TECHNOLOGIES LOCATION: HYDERABAD, INDIA

DURATION: DECEMBER 2013 To SEPTEMBER 2014

Role: Software Engineer/.Net Developer

DESCRIPTION: Apollo DKV Insurance Limited is one of the largest health care companies in India. The product developed included various modules like Health, Personal Accident, Travel and Corporate Solution modules. Login information is stored in the database and reporting the current status of their policy is done in timely manner.

ROLES & RESPONSIBILITIES:

Developed basic windows based application using c#.net for various desktop applications used in the company.

Developed Web forms for registration, to update the policy installment pages and application logic in ASP.Net, C# utilizing the power of Microsoft .NET Framework.

Used ADO.Net in connecting to Data Access management with SQL Server.

Design and development of user interface using ASP.NET, VB.Net, HTML, and JavaScript.

Used User Controls for a group of common controls.

Implemented Win Forms to provide GUI components using .NET Framework.

Responsible for writing SQL Queries based on business logic with XML integration.

Designed XSD using tool Liquid XML studio and involved in creating XML files and writing XPATH Queries.

Written Batch files for firing processes and to execute commands in windows.

Understand and Involve in conversion of JSON JavaScript to AJAX Compatible and VBScript to C#.

DTS packages were written to dump data from SQL 2000 to Oracle.

Creation of stored procedures, views, functions, triggers and DTS in MS SQL server2000.

Developed web forms with C# to store the customer policy data in Database.

Generated the required reports with the help of data grid, data list.

Environment: .NET Framework 1.1, C#.NET, Win-Forms, ASP.NET, ADO.NET, SQL Server 2005, IIS 5.0, Windows 2000, HTML, XML, Visual Studio.NET 2003, Java Script, XML, XPATH, AJAX, JSON.

CLIENT NAME: MAHITHI SOFTWARE PVT LTD LOCATION: HYDERABAD, INDIA

DURATION: FEBRUARY 2013 TO DECEMBER 2013

ROLE: SOFTWARE ENGINEER

DESCRIPTION: The project aimed at providing a comprehensive web portal for a movie multiplex and shopping mall. The portal would house various services such as movie tickets, mall and shop inventories, pertinent information and key contacts. The portal was designed within the .NET framework by using C# programming language. The project mainly comprised with the development in ASP.NET and was used in designing, developing the web forms.

ROLES &RESPONSIBILITIES:

Performed Daily, Weekly and monthly check points and status update meetings. Interacted with end users and vendors as part of problem resolution.

Developed UI components using ASP.NET and C#.

Interacted with external clients for and requirements gathering.

Involved in Analysis and Design of all the modules within the application.

Created ASP.NET Web forms and server controls to display dynamic data obtained through the use of Microsoft ADO.NET and Data binding.

Used CSS and Themes to maintain design consistency across all web forms.

Used JavaScript for Client side validation.

Heavily used .NET Web Controls, Validation Controls and User Controls.

Performed Unit Testing on the entire application.

Involved in testing the product during post-production.

Used cookies, Sessions and View state to store user information.

Wrote SQL scripts and stored procedures, Functions in SQL Server to execute various database routines.

Involved in developing user manuals and help documents.

Environment: Visual Studio.NET 2005, ASP.NET Web Forms, C#.NET, ADO.NET, Java Script, CSS, SQL Server 2000, Unit Testing, SQL Scripts.

Contact this candidate