Sql Server .Net

Location:

Boston, MA

Salary:

$65

Posted:

June 20, 2016

Contact this candidate

Resume:

Bhargavi Kotha

Software Engineer

SUMMARY

Over 8 + years of experience in all stages of the SDLC (Software Development Life Cycle) - user requirements phase, analyzing, designing, implementation, testing, deployment, documentation and maintaining of various stand-alone, intranet, client-server, Internet, windows based and web based applications using Microsoft Technologies with exposure to diverse business domains.

Extensive experience of designing and developing software applications with the .Net Framework 1.1/2.0/3.0/3.5/4.0 using MVC 4, C# and ASP.NET.

Extensive experience in creating rich content Model-View-Control, Web-Forms, Win-Forms, Web User Controls, Server Controls, Web API, WCF and Web Services.

Extensive experience in web-based page and site designs using HTML5/4, CSS3, Themes, Master Pages, Site Map, Knockout, AngularJS, JavaScript, JQuery and JSON framework in AJAX-driven websites.

Proficient in application development using RDBMS, Service-Oriented Architecture (SOA), Object Oriented Analysis, Design and Programming (OOPS) for the development of Multi-tiered solutions.

Experience with Data Accessing including using Data Adapter, Data Reader and Dataset in ADO.NET, Entity frame work 6.0/5/0.

Extensive experience in SQL Server Database design, Database maintenance, developing T-SQL queries, stored procedures using SQL Server 2000

Knowledge in Database Programming using RDBMS databases like SQL Server 2000/2005/2008/2012, Oracle 9i/10g.

Intensive knowledge and experience in source control and version control (MS Visual Source Safe (VSS)/Team Foundation Server (TFS).

Exceptional knowledge and experience in Microsoft Patterns & Practices like Enterprise Library for reusable software components.

In-depth experience with program design, specification development, program logic, flow charting, testing, debugging and documentation Web front end development projects.

Excellent end-to-end hands-on experience with design and development of maintainable and scalable business application.

Writing power shell scripts for automatic deployment tools

Excellent inter-personal, problem solving skills and ability to adapt to rapidly changing technology.

Good Team Player with excellent communication, analytical, verbal and writing skills along with strong management, organizational and mentoring skills.

EDUCATION

Masters of Computer Science, Andhra University, India

SKILL SETS

Programming Languages:

C# 4/3/2/1.2,1.0, ASP.Net 4/3.5/2.0, ADO .Net, C, MVC4, Power shell scripts

Application Technologies:

.Net Framework 4.5/4/3.5/2 Web Forms, MVC3/4, Win Forms, Web API, Web Service, WCF, XML, Java Script, HTML5, DHTML, CSS3/2.1/2, SOAP, JSON, JQuery, KnockOut, Angular JS, Node.JS

Tools:

VSTS/Visual Studio 2013/2015, IIS 8.5/ 7.5, 6.0,7.0

Databases:

MS SQL Server 2000/2005/2008/2012/2014, ORACLE 9i/10g

Software Methodology:

Agile methodology, Water Fall model.

Build & Testing Analyzer

NUnit 2.5, Microsoft Testing.

Version Control Tools:

MS Visual Source Safe, Team Foundation Server, Subversion (AnkhSvn)

Operating Systems:

Windows 9x/NT/2000/XP, Windows 2012 Server, Windows Vista, Windows 7

Packages:

MS Office 2003/2007/2013

Deployment Tools:

Data Manager, CCnet, Performance tool, Octopus, Kentico

Design Tools

Wireframes

WORK EXPERIENCE

CITIZENS BANK March’16 – Present, Medford, MA

Senior Software Engineer

Project Title: Whole sale Credit Risk Infrastructure

Environment

.Net Framework 4.5, MVC 4, asp.net, C#, Entity Frame Work 6, SQL Server 2012, IIS 7.5, Visual Studio 2013, MVC, Windows Server 2012, SVN, HTML5, Agile Methodology, AJAX, Log4Net,, WPI, LINQ, JavaScript, JQuery, Knockout, Boos trip, SSRS, Web Services, Microsoft unit testing, ALM.

Role & Responsibilities

Prepare test based applications for various Dot Net applications.

Prepare and maintain code for various dot Net applications and resolve any defects in systems.

Manage defect tracking system and resolve all issues and prepare update for systems.

Administer change requests and provide estimation of all risks.

Develop documents for various policies and procedures for applications.

Design various application systems for Dot Net applications.

Work on SharePoint and ProClarity and prepare various complex projects.

Participate in status meetings for projects and prepare new proposals and draft strategies.

Prepare prototypes for architecture layers for various applications and databases.

Provide support to development teams.

Monitor all phases of projects and assist in developing specifications and architecture design for application systems.

Assist domain experts and analyze business requirements for clients.

Monitor everyday activities of system and provide require support.

Inflexxion June’14 –Feb’16, Newton, MA

Senior Software Engineer

Project -1 Title: Behavioral Health Care solution

Environment

.Net Framework 4.5, MVC 4, C#, Entity Frame Work 6, SQL Server 2012, IIS 7.5, Visual Studio 2013, MVC, Windows Server 2012, SVN, HTML5, Agile Methodology, AJAX, Log4Net,, WPI, LINQ, JavaScript, JQuery, Knockout, Boos trip, SSRS, Microsoft unit testing.

Description

The overall goal of this project is to develop a scalable, high performance search engine for our own content management system. The main focus is on the algorithmic challenges in compactly representing a large data-set while supporting fast searches on it and each and every article has very detailed, references and related contents links, admin portal maintain user authorization and authentication, user tracking system, providing the facility to individual user favorites and they can recommend article within the organization and many features. SSRS reports for internally to see status of our project

Role & Responsibilities:

Involved in design, implementation and testing of the application

Upgraded kentico to .net application.

Implemented web based front end using HTML 5, JQuery, CSS, AJAX and business logic using MVC razor engine with C#.

Involved agile methodology scrums and sprint planning and reviews, having developed enterprise cultures exceeding efficiency and quality expectations while improving corporate governance

Developed Model view controller format business logic Data Controls like Web Grid View, Data List in UI design

Developed the administrative module to assign levels of authorization to the end users.

Good experience of .Net 4.5 & VS 2013 application development utilizing WPI (SOA), LINQ and VS 2013.

Involved in writing complex SQL queries, stored procedures views, functions, constraints and triggers in SQL Server 2012 database.

Project 2. Title: Inflexxion.com

Environment

Description

Re designed whole website with new technology and pardot salesforce and the overall goal of this project is to develop a scalable, high performance. The main focus is expose our products and contact information and free trial pages and our owner/leadership information.

Role & Responsibilities:

Involved in design, implementation and testing of the application

Implemented web based front end using HTML 5, JQuery, CSS, AJAX and business logic using MVC razor engine with C#.

Involved agile methodology scrums and sprint planning and reviews, having developed enterprise cultures exceeding efficiency and quality expectations while improving corporate governance

Developed Model view controller format business logic Data Controls like Web Grid View, Data List in UI design

Developed the administrative module to assign levels of authorization to the end users.

Good experience of .Net 4.5 & VS 2013 application development utilizing WPI (SOA), LINQ and VS 2013.

Involved in writing complex SQL queries, stored procedures views, functions, constraints and triggers in SQL Server 2012 database.

Project-3 Title: Content Management System

Environment

Description

Content Management System has basically Content repository collect data from our clients (IRETA, Public Domain, Hazelton ... Etc.) in different formats. This project works multipurpose like webAPI and User interface to modify/import/export the data. Internally we followed algorithm to provide search results.

Role & Responsibilities:

Involved in design, implementation and testing of the application.

Writing business classes using c# concepts.

Implemented web based front end using HTML 5, JQuery, CSS, AJAX and business logic using MVC razor engine with C#.

Involved agile methodology scrums and sprint planning and reviews, having developed enterprise cultures exceeding efficiency and quality expectations while improving corporate governance

Developed Model view controller format business logic Data Controls like Web GridView, Data List in UI design

Developed the administrative module to assign levels of authorization to the end users.

Good experience of .Net 4.5 & VS 2013 application development utilizing WPI (SOA), LINQ and VS 2013.

Implemented Entity frame work 5 based on database.

Involved in writing complex SQL queries, stored procedures views, functions, constraints and triggers in SQL Server 2012 database.

The Advocator Group May’13 –May 2014

Wakefield, MA

.NET/ Web Developer

Project Title: Advocator Group

Environment

Windows XP, JQuery/JavaScript, Visual Studio 2010, ASP.Net (C#) 4.5, SQL Server 2008, MVC3, Win Forms, HTML 5, CSS3, .Net Framework 4.0, IIS 7.0, Team Foundation Server(TFS), AJAX, Telerik Controls, Web Services, N-Tier Architecture, Windows services, VBA .

Description

The Advocator Group is a nationwide advocacy organization dedicated to helping individuals apply for and obtain Social Security Disability Insurance. In addition, we help Medicare beneficiaries navigate the complexities of their health insurance options in order to identify the best coverage possible based on their unique needs. Our mission is to help preserve or improve the financial well-being of our clients. This project I have involved in support and development of multiple applications including web-based and internal applications based on .Net platform. I involved in development of proposed enhancements, bug fixes and production issue resolutions. I have created outlook rules using VBA to transmit mails and save data into data source. I have created windows services and task scheduler to read data from database and design pdf/excel/word documents, attached those files to email and send email to group. I involved in designing Facebook pages and widgets creation for business and other users.

Role & Responsibilities

Design, program, and deliver web/local development projects (ASP.Net, C#, and related platforms) within the schedules and budgets

An agile methodology expert, having developed enterprise cultures exceeding efficiency and quality expectations while improving corporate governance.

Re-design sophisticated SQL Server database queries (T-SQL, stored procedures)

Used extensively Java Script and ASP.NET for AJAX Implementation and Client Side Validations.

Use SMTP standard for e-mail transmission across Internet protocol (IP) networks.

Developed scheduled windows services and Task schedulers.

Developed VBA code to save the emails in database and Created Outlook rules and alerts to forward emails to different teams.

Created PDF and Excel reports from C#

Code review and bug fixing.

Writing unit test cases and Unit testing and integration testing.

Design Facebook pages and widget etc.

Trained and Used the Object Lune software.

Understanding the requirement and designing the solution.

Designing and Developing WPF/Windows forms in C#.

SITA June’12 –Apr’13

Bohemia, NY

Web Developer

Project Title: NWAF (New way Architectural Framework)

Environment

.Net Framework 4.0, ASP.NET, C#.NET, ADO.NET, Oracle 11g, IIS 7.0, Visual Studio 2010, MVC3, Win Forms, Team Foundation Server(TFS),Agile Methodology, JavaScript, JQuery, AJAX, Web Services, Web Services, WCF, N-Tier Architecture, JIRA.

Description

SITA is the world's leading specialist in air transport communications and information technology. Provide the services for airline commercial management, passenger operations, flight operations, airport management and operations, baggage operations, transportation security and border management, cargo operations.

In SITA I involved in developing different modules to provide functionality to maintain airport, flight and passenger information. In this project I involved in development of proposed enchantments a d bug fixes. In this application I participated in creating application to read csv/text files and import data to oracle database and creating stored procedure to take backup. Created the Microsoft Unit testing for projects and created test case documents.

Role & Responsibilities

An agile methodology expert, having developed enterprise cultures exceeding efficiency and quality expectations while improving corporate governance

Create sophisticated SQL Server database to responsively handle complex queries (T-SQL, stored procedures) and .NET data access components.

Envisioned and built front-end for the site written in ASP.NET, MS Visual Studio .NET, C#.NET

Extensive use of Grid View, Details View, Session variables for data binding.

Works extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET to access and update database.

Code review and bug fixing.

Creating the Microsoft Unit Testing classes (MS-Test).

Efficient in working independently and collaboratively in team.

Understanding the requirement and designing the solution.

Designing and Developing WPF/Windows forms in C#.

Creating Installer Setup project for installing solution on various machines.

LVPrasad Eye Hospital Sep ’09 – May‘12

Hyderabad, India

.Net Developer

Environment:

.Net Framework 3.5, ASP.NET, C#, ADO.NET, JavaScript, SQL Server 2008, IIS 7.0, Visual Studio 2008, Windows Server 2008, Ankh Subversion, JQuery, AJAX, XML, XSL, XSLT, iTextSharp, SSRS, SSIS.

Description

It’s a complete Human resource Management solution to increase consistency and flexibility to all the Employees in an organization. The features of this Project include Attendance capture from Iris Device and Calculation of Attendance with respect to shifts, Leaves. Leave management includes from Leave application to Leave Approval, Shift Management for more than 20 shifts with Permissions and Exchange shift. Survey Management for survey reports (SSRS) and creating Questionnaire. Training Management and Recruitment Management

Role & Responsibilities

Involved in the design, development and implementation of web user interfaces in ASP.NET2.0.

Performed Client side validations using validation controls in ASP.NET

Extensively used Themes and Skins for styling the ASP.NET pages

Database design and Writing Stored Procedures.

Developed Master page and Web User Controls.

Used ADO.NET objects in accessing and retrieving data from the SQL server database

Involved in Crystal reports generation.

Consult IT (Botswana Govt) Jun ’07 - Aug ’09

Hyderabad. India

.NET Developer

Environment

.NET Framework 2.0, C#, ADO.Net, N-Unit testing, Web forms, Win Forms, Windows XP, IIS 5.1, Visual Studio 2005, Team Foundation Server (TFS), SQL Server 2005, SSIS.

Description

LITS (Livestock Identification and trace back System) was developed as RFID (radio frequency ID device) tracing application for animals and animal by-products. It has two modules one is developed for rugged mobile (touch screen) and other for computers. It uses synchronized database connectivity to ensure secured data transfer even in low connectivity area. Timely production of various reports such as Animal movements reports, census, ownership, registration and Certificate generation.

Role & Responsibilities:

Involved in the design, development and implementation of web user interfaces in ASP.NET2.0.

Performed Client side validations using validation controls in ASP.NET

Extensively used Themes and Skins for styling the ASP.NET pages

Database design and Writing Stored Procedures.

Developed Master page and Web User Controls.

Used ADO.NET objects in accessing and retrieving data from the SQL server database.