Sql Server .Net

SUMMARY:

Over * years of experience in various areas including Human Resources, Health Care, Insurance and Finance/Mortgage. Highly skilled in engineering and development of IT Projects.

Experience in developing Web and Client/Server Applications based on Microsoft .NET Technologies and expertise in implementing N-Tier Architecture, Data Access Layer (DAL), Business Logic Layer (BLL) and User Interface (UI).

Designing and developing web based and windows based applications using ASP.Net, C# .Net, ADO.Net,VB.Net Web Services, ASP, IIS, JavaScript, HTML, DHTML, CSS, XML, AJAX and XSL.

Sound knowledge of Object Oriented Language Principles (C#) and design practices (object modeling, use cases, activity diagrams, UML).

Thorough knowledge and experience on all phases of Software Development Life Cycle (SDLC) by following Water Fall, Agile and Scrum methodologies.

In-depth understanding and experience in building server applications using C#, ASP.Net, ADO.Net, XML Web Services, HTTP modules and handlers based on .Net Framework 4.5/4.0/3.5/3.0/2.0.

Good knowledge of ASP.NET UI controls like Grid View, Detail View and Data Source Controls such as Object Data Source, SQL Data Source and Master Pages for consistent layout of pages in the application.

Used TFS (Team Foundation Server) and Tortoise SVN for Source Versions Control systems.

Well-versed in ADO.NET, having built query-driven applications.

Developed GUI (Graphical User Interfaces) using C# Win Forms and ASP.Net Web Forms.

Experience in Database Design, Database Management and Data Migration using SQL Server, Oracle.

Experience in working with Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF) and Windows Workflow Foundation (WWF) in .Net Framework 4.0/3.5/3.0 and Language Integrated Query (LINQ) in .Net Framework 3.5.

Experience in developing and building rich user interface web applications using Silverlight 3.0/2.0/1.0 and XAML.

Extensively used Eclipse IDE for developing, debugging, integrating, and deploying the application.

Experience in Content Management Sytsem such as Kentico CMS and Drupal.

Experience working with SSIS packages for data Importing, Cleansing, and Parsing etc.

Experience in modelling the Data Access layer of application using Data Adapter, Data Reader, Data Tables and Dataset in ADO.NET and Language Integrated Query (LINQ) Providers for data manipulation.

Knowledge of Design Patterns like MVC and Singleton Patterns.

Experience in Microsoft Business Intelligence tools – SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

Experience in Crystal Reports XIR2 / CRS2011 and Reporting Services.

Used Business Intelligence Development Studio to develop and deploy SQL Server Analysis Services (SSAS) projects.

Experience in using Web Server – IIS 7.5/7.0/6.0/5.0.

Worked on REST Web Services using AngularJS, JavaScript, JQuery, HTML5, CSS3, Ajax, Web API and Bootstrap.

Experience in designing and developing Databases in SQL Server 2000/2005/2008/2012, Oracle 9i/10g includes the development of functions, stored procedures and triggers using Transact SQL.

Knowledge of Database design and implementation, hands on experience in T-SQL (stored procedures, functions, data types, queries, Indexes, triggers, views, functions, Performance Tuning, Query Optimization.

Worked on .NET Security features such as Authentication & Authorization.

Proficient in building Web Applications using C#.NET4.0/3.5/2.0, ASP.NET 4.0/3.5/2.0, HTML5, XML, AJAX, JavaScript, JQuery and CSS3 in a Client/Web Server environment.

Experience with Oracle RDBMS, Share point 2012.

Good team player and communicator with interpersonal and presentation skills & excellent work ethics, self-motivated, quick learner & flexible to adapt new technologies.

TECHNICAL SKILLS:

.NET Technologies

.Net Framework 4.0/3.5/3.0/2.0/1.x, ASP.Net 3.5/3.0/2.0/1.1, VB.NET, ADO.NET, Web Services, .Net Remoting, Web Forms, Win Forms, WCF, WPF, WWF,LINQ

IDE

Visual Studio 2015/2013/2012/2010/2008, Visual Studio 6.0,

Web Technologies

ASP, XML, HTML, DHTML, XHTML, CSS, XSLT, JavaScript, AJAX, DOM, Silverlight3.0/2.0/1.0

Programming Languages

C#, ASP.NET, VB .NET, VBScript

Databases

SQL Server 2008/2005/2000 (T-SQL, Stored procedures, Triggers, DML, DDL, DTS, SSIS, SSRS, SSAS), Oracle 10g/9i, MS Access, DB2.

Protocols

SOAP, SSL, FTP, TCP/IP, HTTP

Reporting Services

Crystal Reports, SSRS, SSIS

Web/Application Servers

Internet Information Server (IIS) 7.0/6.0/5.0/4.0

XML Technologies

XML, XSLT, X Link, XPath, XQuery, DTD’s Schemas

Application Tools

Visual Interdev 6.0, Visual Studio.Net, Front Page, SQL Enterprise Manager, SQL Server Management Studio, Adobe Photoshop 7.0, SharePoint Designer

Operating Systems

Windows Server 2008, 2012, Windows XP/NT/2000/Vista, Windows 7, UNIX. Solaris.

Version Controller

MS Visual Source Safe 6.0(VSS).

PROFESSIONAL EXPERIENCE:

Client: Ernst & Young, Atlanta, GA Oct '2015 – Till Date

Title: C# .NET Analyst

Description: EY provides global services to management risk, assurance, transactions, financial and tax. This project deals with maintaining data for different portals and modifying websites based on the user requirements.

Responsibilities:

Involved in all SDLC phases - Requirement Specifications, Technical Design Documents, Development, Test plans and release plans, Implementation and Production Support.

Developed application using MVC design pattern.

Involved extensively in developing components for Business and Data tier using C#.NET and also involved in creating controllers/View Models to handle the events raised on the Razor views/Partial Views in ASP.NET MVC framework.

Worked on Agile Methodology to meet timelines with quality deliverables.

Provided the estimates for each story by understanding the requirements and existing functionality of the application during the SCRUM planning.

Embedded ASP .NET user controls into Kentico CMS.

Used ASP.NET MVC Data annotations and JQuery to do validations on the Model Data.

Developed client call back mechanism together with heavy JavaScript and JavaScript frameworks, like Backbone, Underscore and JQuery to provide better user interactivity.

Rendered HTML Views from XSLT/XML, populate the XML data generating for various delivery formats like RTF, PDF, Microsoft Word.

Development of Web applications for managing using Kentico CMS.

Used Kentico CMS/EMS for the development of ASPX Template method.

Developed Report Interface tool to generate flexible reports based on customized format. The tool is written in JAVA, XML, SQL Server and ECLIPSE.

Designed and implemented JS view models as well as the underlying JSON model data.

Developed new reports and chart interface components using High Charts Ajax API.

Involved in creation and modification of JSON data.

Created dynamic HTML templates and Light box pop-ups using JavaScript.

Developed Visual studio integrated Unit test project for the business logic of the application and tested the data access layer by using mocking framework.

Involved in regular code check-ins, internal and external code reviews.

Used Microsoft Team Foundation Server for the purpose of version Control and source code maintenance needs.

Experience in structuring different web applications and make the coding easy and understandable using Backbone JS.

Worked on new level architecture design and established a setup in Cloud environment for staging.

Involved in designing database Tables and creating Queries, Stored Procedures for databases.

Environment: ASP.NET 4.5/4.0, MVC5 to ASP.NET MVC 4.0, C#, HTML5, CSS3, JavaScript, Eclipse, JQuery, Underscore, Kentico CMS, Backbone, LINQ, IIS, ASP.Net MVC 5, JSON, XML, XSLT.

Client: Citi Bank, Warren, NJ Jun '2014 –Sep '15

Title: Software Programmer

Description: Personal Loan Management System provides operational and decision-making support to the asset side of balance sheet for bank. The scope of the project is to design a web application to handle life cycle of a personal loan post origination until termination.

Responsibilities:

Developed and maintained web portal intranet based application using agile methodology.

Interacted with application admin users for day to day and weekly activities and Scrum meetings.

Involved in Requirement gathering, Design, Development, Unit testing, and Integration testing.

Developed new screens based on client requirement for the application using .NET framework 4.0 with Object Oriented Principles (OOP) in MVC.

Developed Application layer using ASP. Net, Server controls, HTML Controls and Validation controls.

Designed Graphical User Interface (GUI) for various web pages using, HTML, CSS, JavaScript and AJAX interactions. Experience in developing Rich UI with the use of ASP.NET, Angular JS, Bootstrap and JQuery.

Inbound and Outbound WCF Services / Web Services have been created to integrate with Email client and support applications using VB.Net.

Using JQuery, JavaScript and Model Binder attributes for implementing client side validations at Controller level.

Maintained changes for PL/ SQL packages to develop stored procedures design and develop database.

Responsible for creating the Tables, Views, Functions, Jobs using Oracle10g.

Used SQL Server Integration Services (SSIS) for extraction transformation and loading data.

Extensively used SQL Server Reporting Services (SSRS) for generating reports populated by data in databases.

Used Microsoft Team Foundation Server version control and source code maintenance tool.

Implemented new designs, porting and styling legacy pages, integrating JQuery plugins, converting static forms into Ajax overlays.

WCF the front end using XAML Browser based WPF and Silverlight for Rich UI.

Developed animations for the deal page using MS Silverlight and Double animations in WPF.

Designed and implemented Data access layers using LINQ for XML Data.

Used Visual Source Safe (VSS) for source control.

Used WPF in creating different animated scenes using the combination of transforms, animation controls (storyboard, double animation) and color effects.

Environment: ASP.NET 4.0/3.5, ADO.NET, C#, MVC 5, C# 4.0, WCF, WPF, Silver Light, VB 6.0, Angular JS, Web services, Oracle 10g, Crystal Reports, XML, XAML, HTML, .NET Framework 4.0, Silverlight, TFS 2010, DHTML, Java Script, JQuery, N-Unit.

Client: Prudential Financial, Newark, NJ Oct '2013 -Jun '2014

Title: .Net Programmer

Description: Life Insurance Company provides immediate online access to healthcare options. The basic aim is to give the flexibility to business and number of new feature with easy to use for Affiliates with latest technologies like .NET Framework 3.5.0, ASP .NET 4.0, C# Windows Server 2003, IIS 6.0 and SQL Server 2008 with Enterprise Architecture.

Responsibilities:

Developed application using ASP.NET 4.0, MVC 3, Razor, C#, HTML5/CSS3, JavaScript, HTML helpers.

Developed programming scenarios in C#, object oriented Programming (OOP) concepts like encapsulation, inheritance, polymorphism, and abstraction.

Designed user interface screens and implemented application logic under Microsoft .NET framework powered with CLR using C#.

Developed new features and maintained modules on N-tier, multi server, e-commerce web applications.

Designed and implemented an email formatting subsystem and related admin tools for all e-commerce related emails using SQL Server, C#, ASP.NET and XML/XSLT.

Wrote all ASP and HTML code and developed Content Management System.

Formatted HTML or text emails sent to customers for any e-commerce transaction, which are easily editable through a set of product-specific templates.

Worked on ASP.NET Web Forms, ASP.NET State Management, ASP.NET caching features, configuring ASP.NET optimizations, securing ASP.NET web applications.

Used ADO.NET components like Data Adapter, Data Reader and Data Set to access data and display in grid view.

Used data annotation for server-side validation and JavaScript validators for the client side validation.

Created Graphical User Interface (GUI) applications that was designed using ASP.NET 4.0/3.5 and the business logic was coded in C#.

Followed the N-tier architecture for the application development with Presentation Layer (UI), Data Access Layer (DAL) and Business logic layer (BLL).

Prepared various test cases to fix the bugs and ensure the application error-free.

Lead the development of Classic ASP Web based application for maintaining portfolio of successful customer engagements.

Created stored procedure for user Authentication to avoid SQL injection.

Designed and developed Class Libraries for Data Access, Exception Handling, Logging and Session Management etc.

Environment: Visual Studio 2010/2008, .Net Framework 4.0/3.5, C#, ASP.NET, Classic ASP,SQL Server 2008, WCF Web Services, ADO.Net, HTML, AJAX, JavaScript, AJAX, SSIS, N Tier and Web forms.

Client: UnitedHealth Group, Hyderabad, India May'2010- Sep'2013

Title: .Net Developer

Description: Web based application for Health care Company. The project deals with workers compensation providing online transactions and has Modules like Inquiry, Claims, Patient Entry, Products, QA, Billing and Administration. Product Catalog is a module for MSC. The Product Catalog mainly deals with the products which supplies by the MSC to users, pricing strategy and geo updater.

Responsibilities:

Used UML to design Structure, Behavior and Interaction diagrams defining highly refined Use.

Designed the win forms, wpf framework using C#.Net.

Customized various controls for Application by developing Custom Controls and User Controls.

Used VB.NET and updated almost all WINDOWS FORMS to implement the AJAX functionality.

Presentation Layer was build using Silverlight.

Created several Silverlight apps using Expression Blend 2.5 and Deep Zoom with Silverlight 2.0; this case, Dataflow, Sequence and all other diagrams that have addressed almost all of the client issues. There by achieving performance enhanced application. Involved creating user controls in Silverlight, designing buttons in Blend and many other Silverlight toolkit items.

Designed GUI using WPF, Silver Light, XAML.

Performed conversion of existing Classic ASP web applications into ASP.NET for various short term contract projects utilizing VB.NET or C#.

ADO.NET was used to implement the data access layer to communicate with databases.

Responsible for Database design, and creation of Stored Procedures using T-SQL, triggers to perform.

Did changes to some applications involving Classic ASP.

Implemented customized caching so that it works on load balancing server.

Implemented Role Based Security and SSL to make application secure.

Responsible for managing requirements to ensure timely deliverables and status reports. The Data retrieval from multiple tables in SQL Server 2005.Visio.

Environment: VB.NET, ASP.NET, Classic ASP, C#.NET, VisualStudio .NET 2008, .NET Framework 3.5, Crystal Report, Java Script, Silver light 2.0, Web Services, XML, SOAP, IIS 6.0, SQL Server 2005, Windows 2003/2000,T-SQL,SSRS,VSS.

EDUCATION:

B.Tech (CSE), JNTUH, INDIA.

Contact this candidate