Sql Server .Net

*

Kavitha M

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

Phone: 727-***-****

HIGHLIGHTS

* ***** ** ******* ********** in all phases of software development life cycle (SDLC), especially in Design, Development, Testing and Deploying of applications and implementing n-tier Client/Server applications using Object Oriented design methodologies

Extensive experience in .NET Framework 4.0/3.5/3.0/2.0/1.x Web based application development using Microsoft.NET technologies including ASP.NET 4.0/3.5/3.0/2.0/1.x, C#, ADO.NET, Server Controls and Web Services

Expertise knowledge on Object Oriented Programming (OOPS) Concepts including Inheritance, Abstraction, Encapsulation and Polymorphism

Extensive work experience on Web based and Windows applications using C#, ASP. NET, ADO. NET, JavaScript, XML, CSS, HTML,DHTML, Multithreading, State Management & ASP.Net Caching

Good experience in using ADO.NET objects such as Connection Object, Command Object, Data Reader Object, and Dataset Object and to access databases like SQL Server 2000/2005/2008/2012

Experience in developing Web pages using ASP.NET, AngularJS, JavaScript, and JQuery

Experienced in using AJAX controls in ASP.NET Experience in developing application with ASP.Net MVC

Extensive work in creating User Controls, Custom Controls, Navigation Controls, Master Pages, Cascading Style Sheets, Themes and Skins in ASP.NET (4.0/3.5/ 3.0/ 2.0)

Hands on experience in Windows Communication Foundation (WCF) for rapidly building service-oriented applications that communicate across the web and the enterprise

Experience in Windows Presentation Foundation (WPF) for developing attractive and effective user interfaces, providing a common programming model for standalone and browser applications

Sound knowledge in writing T-SQL queries, stored procedures, Triggers along with Data Transformation Services (DTS), views, user defined functions, packages, database performance tuning, indexing, database backup and restore using MS SQL Server 2008/2005/2000

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

Experience performing Unit and Integration Testing in the Development environments and experience in Bug Reporting and Fixing using Nunit and MS Test

Effective result-oriented team player with excellent communication and interpersonal skills with a positive attitude towards work with adherence to time schedules and quality delivery

Well versed in software development principles, methodologies, and processes – Both Waterfall & Agile Methodologies

WORK STATUS

Legally permitted to work in the United States for any employer with valid EAD EDUCATION

B. Tech., Computer Science and Engineering: Jawaharlal Nehru Technological University, Hyderabad, India

TECHNICAL PURVIEW

Operating systems : Windows Vista/Xp/2000/98/95, Windows NT 4.0/5.0/2003 Development Tools : Visual Studio.net 2010/2008/2005/2003 2

Version Control Tools : Microsoft Visual Source Safe 6.0, Concurrent Version System (CVS), Team Foundation Server (TFS)

Programming Languages : Visual C++, C#, JAVA and T-SQL,Unix Web Technologies : HTML, DHTML, XHTML, CSS, XML, AJAX, Jquery, JavaScript, AngularJS, XLST, WCF, Web Services

Web Servers : IIS 5.x/7.0/6.0/5.0/4.0

Scripting Languages : JavaScript, VBscript

Databases : MS Access, SQL Server 2012/2008/2005/2000, MY SQL, Oracle10g Microsoft Technologies : .Net Framework 3.5/3.0/2.0/1.1/1.0 ASP.Net, ADO.Net, VB.Net, WCF, Web API

XML Technologies : XML, XAML, SOAP, WSDL, Web services Reporting Tools : Crystal Reports 10/13, RDLC Reports PROFESSIONAL EXPERIENCE:

Client: MetLife Investments Insurance Company, Vancouver Wa August 2014 to Present Role: MS SQL Server Developer/SSIS/SSRS Developer

MetLife is the largest life insurance company offers life insurance, auto and home insurance, retail banking and other financial services to individuals, as well as group insurance, reinsurance and retirement & saving products and services to corporations and other institutions. Responsible for developing MetLife Bank consolidated reporting data warehouse and user interface. The Consolidated warehouse stores data from different services and generates reports for the bank use. Responsibilities

Requirements gathering from the business users, created technical specification documents

Utilized new reporting services SSRS 2008 to design and review the new report standards to ensure optimized performance

For data Warehouse, planned, designed and documented the optimum usage of space requirements and distribution of space

Migrated reports from MS SQL Server Reporting services 2008 to 2012

Wrote T-SQL queries, Store Procedures, User defined functions, Views and used them to build packages

Designed and developed packages for a data warehousing and Data Migrations projects using Integration services (SSIS) on MS SQL Server 2012

Microsoft SQL Server 2012 database environments and the development and test environments on the Microsoft Azure SQL Server platform.

Extracted the data from Oracle, Flat files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehousing using SSIS (SQL Server 2012)

Created/modified a variety of parameterized, drill down, pie charts, bar graphs, matrix, and sub reports using SSRS 2008/2012 using data from a variety of sources

Scheduled the reports on capacity levels of different servers to run on daily/weekly/monthly basis and email the results to the business users in the required format

Added/modified Users, Groups, folders and rights

Published and scheduled the reports in different formats (Email, Public folder etc.)

Managed all indexing, debugging, optimization and performance tuning using T-SQL

Designed and implemented Stored Procedures and Triggers for automating tasks

Created/modified SQL Joins, sub-queries and other T-SQL code to implement business rules 3

Technical Environment: MS SQL Server 2008 R2/2012, MS Azure, SSRS 2008 R2/2012, SSIS 2008 R2/2012, SSIS 2008 R2/2012, SSMS. Crystal reports XI, T-SQL, Oracle 10g, Access and Excel Client: AllState Insurance. Vancouver, Wa July 2013- July 2014 Role: .Net Developer

AllState Insurance provides Auto, Home & Property, Business and Life Insurance. The website provides customers access to their Insurance policies online where they can pay bills, change personal information, file claims and request policy related documents. It also allows visitors to obtain rate quotes to be compared, saved and retrieved at a later date. Additionally, it allows to lookup the nearest agent based on address, city, state and zip code or the agent last name. Technical Environment: ASP.NET, C#, ADO.NET, Visual Studio .NET, Web Services, SOAP, CSS, XSL, XML, MS SQL Server 2005, SSRS, Microsoft Visio 2000, WCF, Rest methodologies Client: Discovery Communications, Inc., MD August 2012 – June 2013 Role:. Net Developer

DCI is the global headquarters and communication wing for discovery channel. I was involved in developing several windows based and web based financial systems. This application is developed to translate the labor hours entered in time tracking system to dollar amounts and properly allocate those dollars across the appropriate projects, Cost Centers for reporting on any financial attributes. This system is transactional-based system. This system provides the historical view of the data with “as of date” concept. This system also provides the “what if” analysis for top executives in the company. Technical Environment: C#3.0, VB.Net, SQL Server 2005, Web Services, ASP.NET 3.0, AJAX, BizTalk Server, Source Safe, ADO.NET, UML, LINQ, Windows 2000 Server, Java Script, VSS, HTML, XML, XSLT, DHTML, WCF. Client: Examhook, Hyderabad, India June 2011-July 2012 Role: . Net developer

Examhook is an online examination web portal designed to automate the examination system. This web portal also has 1) Training module –it provides the necessary online training for the students via subject wise practice tests; 2) Student interaction environment –in which the ideas and innovations are shared among the students for informative discussions. This web portal is designed with best UX factor. It aims at globalization of conducting online examinations such as IIT-JEE, National-level Olympiad test and other similar competitive exams.

Technical Environment: Asp.net, C#. Net, Ado.net, MVC, SQL Server 2008 Client: GTL LTD., Mumbai, India June 2010 – May 2011 Role: SQL developer

GTL (global tele systems limited) is a leading Network Services company, bringing together the various technologies for addressing the networking, communication & infrastructure management needs have globally distributed Enterprises and Telecom Carriers. Technical Environment: Windows 2000, MS SQL Server 2005, SQL Server 2005 Analysis Services, MS access HTML

Competencies:

Programming Skills: C/C++, C#.Net, Asp.net, Java,Unix,HTML, CSS, and Javascript, AngularJS Software Testing: Manual, QTP (Quick Test Professional, 11.5) and QC (Quality Center, 11.0) Packages: Microsoft Office

Operating System: Windows XP, 7

4

Language Skills: English, Telugu and Hindi

References: Available on request

Contact this candidate