Post Job Free

Resume

Sign in

.Net Sql Server

Location:
San Francisco, CA
Posted:
July 02, 2015

Contact this candidate

Resume:

Professional Summary:

Over *+ years of strong professional .Net Development experience in various applications based on Object Oriented Programming (OOP), Client/Server, N-tier architecture, Web based and Internet Technologies.

Good knowledge in Software Development Life Cycle (SDLC) i.e. Analysis, Design, Development, Implementation, Testing and User Training of Enterprise Web-Applications, Stand alone and Distributed applications.

Extensive experience in developing Web based applications and Client/Server applications using C#, ASP.NET (4.0/3.5/3.0/2.0/1.1), Classic ASP, ADO.Net, XML, HTML, XHTML, JavaScript and CSS.

Hands on experience with OOPS concepts and Multi threading.

Profound knowledge on Web Services (SOAP), Windows Presentation Foundation (WPF), XAML, Windows communication Foundation (WCF), Windows Workflow Foundation (WWF) and Silverlight.

Expertise in design and development of user interface (GUI) using XML, XSL, XSLT, AJAX, HTML, DHTML, VB Script, JavaScript and CSS.

Extensive experience in Database design, Modeling and Database maintenance in SQL Server environment.

Working experience on Grid View, Details View, Repeater and other ASP.NET Server controls for state management in .NET.

Good working experience on XML, Web Services, Windows Services, Web and Windows Custom Controls, User Controls, Data based controls like Data grids, Data lists, Repeaters, Class Libraries and LINQ.

Experience in .NET security features such as Authentication (Windows-based Authentication, Forms-based Authentication) and Authorization (Authorizing Users and Roles).

Good knowledge in using the Data Access Components i.e. ADO. Net, ADO, DAO, ODBC and the SQL Server, Oracle coupled with good understanding of RDBMS concepts.

Familiar with MVC, Command, Controller, MVVM design patterns and various design methodologies like Rational Unified Process, Waterfall and Agile Software Development with Extreme Programming, Scrum, Paired Programming, TDD and Continuous Integration.

Excellent skill in writing stored procedures, T-SQL Queries, functions, triggers, views and schemas.

Experience in MS Share Point Portal Server and BizTalk Server environment developing Web Parts.

Strong working experience in developing Web Services, .NET Remoting and Data Transformations.

Experience in working with Visual Source Safe (VSS), Visual Team System (VTS), and sub version configuration (SVN).

Experienced in designing reports for Web Applications using Crystal Reports and SSRS and also worked on SQL Server Integrating System (SSIS) using SQL Server 2008/2005.

Extensive experience in SQL Server Database design, Database Maintenance, developing T-SQL queries, stored procedures and SQL Server, DTS, SSIS, SSRS.

Profound knowledge in working with RDBMS includes MS SQL Server 2008/2005/2000, Oracle 9i, 10g, 11g and MS-Access.

Experienced with Agile SCRUM methodology used for new product development.

Good working experience with office software’s such as MS Project, Visio, Rational Rose, MS Office.

Strong analytical and dynamic trouble shooting skills coupled with excellent communication skills and able to work individually or lead others.

Technical Skills:

. NET Technologies

.NET Framework 1.1, 2.0, 3.5, 4.0, 4.5, WCF, WPF, ASP.NET, ADO.Net, C#, Window forms, AJAX, Web Services, Silverlight, SOAP, ADO.NET, XML, LINQ, SOA, .Net Remoting, VB.NET, IIS.

Languages

C#, VB.NET, VB 6.0, C++, PL/SQL, TSQL, ASP.

Web Technology

ASP.Net, AJAX, AJAX toolkit, ASP, HTML, DHTML, CSS, JavaScript, Web Service, XML, XSL, XSLT

Databases

MS-Access, Oracle 9i/10g, SQL Server 2000/2005

IDEs and Tools

Visual Studio .NET 2012/2010/2008/2005, EditPlus, MS Office, SQL Management Studio 2008/2005, SQL Developer, SSIS, SharePoint.

Other Concepts & Technologies

XML Web Service, Windows Communication Foundation(WCF), Windows Presentation Foundation (WPF), MVC, Unit Testing

Operating Systems

Windows XP/7, Unix

Professional Experience:

Client: Televox, Mobile, AL.

Jan 15 – Till Date

Role: Sr .Net Developer

Project: HealthCare System

Televox delivers technology with the purpose of improving health outcomes, enabling providers to deliver crucial between-visit communications that support patients by delivering appointment reminders for physicians visit that are crucial part of treatment.

Responsibilities:

Worked closely with clients in gathering and analyzing requirements and providing solutions that meet the client’s requirements.

Implemented MVC architecture to accomplish task of isolating Business Layer, Presentation Layer and Data Layer.

Designed the UI Mockup’s for various use cases

Created Controllers, Models and Views for implementing Business Scenarios

Developed presentation layer Components and created reusable components in ASP.NET MVC to use across the application.

Developed User Interfaces using ASP.NET MVC Views

Created Shared Views

Used Entity Framework for Database Interactions

Created Stored Procedures for fetching complex business data

Business Logic has been implemented using the concepts of Object Oriented programming (OOP) with Code behind language C#.

Used TypeScript to create different client side functions that greatly decreased processing time and resource consumption.

Worked with ORM using LINQ to SQL/Entity framework designer for ASP.Net MVC application.

Used active directory used by windows based computers and servers to store information and data about network and domains.

Involved in designing database, Backup and Restore Database, Define roles, Create database users and SQL queries optimization and performance.

Involved in creating Unit and System Integration test plans.

Client: Comerica Bank, Barrington, IL. Jan 14 – Jan 15

Role: Sr. .Net Developer

Project: Loan Payment and Approval system

Comerica Bank is one of the leading and secured financial institutions in the state of Illinois. Loan Payment and Approval system is a multi application system which is very useful for the customers of bank who can have an easy access to their loan (Home, Personal) applications and set up one-time or recurring payments.

Responsibilities:

Worked closely with clients in gathering and analyzing requirements and providing solutions that meet the client’s requirements.

Implemented MVC architecture to accomplish task of isolating Business Layer, Presentation Layer and Data Layer.

Developed presentation layer Components and created reusable components in ASP.NET 3.5/4.0 to use across the application.

Developed Web Forms for User Interfaces using ASP.NET with Server Controls, HTML Controls and User Controls.

Worked on front end designing of forms with Silverlight and prototype approvals, displaying data, validations and binding fields to the data source.

Extensively Used. ASP.NET 4.0 controls like Master Page Templates, Menu Controls, Grid View Controls and File Upload Controls.

Developed and consumed WCF Web Service to access data layer components.

Used service tier to define and implement all the web services and classes, and presentation tier to perform all GUI functionality.

Development of Share Point portals with extensive workflow capabilities to manage client projects. Portals with extensive workflow capabilities to manage client projects.

Business Logic has been implemented using the concepts of secure coding features and Object Oriented programming (OOP) with Code behind language C#.

Applied Themes and CSS styles for UI design of WebPages.

Implemented AJAX control in multiple web pages for partial page update and for more users friendly.

Used JavaScript to create different client side functions that greatly decreased processing time and resource consumption.

Worked with ORM using LINQ to SQL/Entity framework designer for ASP.Net MVC application.

Effectively designed application windows using XAML using various WPF controls like DataGrid, Combobox, Textbox, etc.

Created WCF Services responsible for communicating and providing real time data from integrated server to Client Application.

Used LINQ, WPF to communicate between DAL and other business components.

Used .Net Security features such as Authentication and Authorization.

Implemented Data access layer using ADO.NET to connect, retrieve or manipulate data from Oracle 10g/11g.

Used active directory used by windows based computers and servers to store information and data about network and domains.

Used XML for data storage and XSLT to transform the PLSQL queries returned as XML nodes.

Involved in designing database, Backup and Restore Database, Define roles, Create database users and used Data Transformation Services (DTS), SQL queries optimization and performance.

Developed web services for defining patient’s health disorder and treatments or tasks that a care provider performs on behalf of the patient.

Used ADO.Net for DML/DDL operations with the SQL Server.

Created complex Views, Store Procedures and user defined functions using SQL Server 2008 and designed reports using Crystal Reports.

Stored and accessed data from XML files programmatically using C# and LINQ to XML.

Used Microsoft Visual Source Safe (VSS) for the purpose of version Control and source code maintenance needs.

Deployed the system to the production server and effectively involved in trouble-shooting various issues in production.

Involved in creating Unit and System Integration test plans.

Environment: C#, ASP.NET 3.5/4.0, ADO.NET, Web Services, Crystal Report, MVC3, WCF, WPF, LINQ, Visual Studio 2008/2010, AJAX, XML, HTML, JavaScript, MS Visio, Unit, TFS, PL/SQL, SQL Server 2008, Windows.

Client: State Farm Insurance, Bloomington, IL. Nov 12 – Dec 13

Role: Sr. .Net Developer

Billing Payment System (BPS) is a complex intranet application developed for multiple areas like CRC, Operation centers (Finance and Divisional areas), Support center and Systems. BPS application provides services like Inquiry on bills/payments, generates Credit Card Payments, generates Credit Card Refunds, generates a Remittance document, and generates Transaction History Report and Locate Customer.

Responsibilities:

Gathered requirements through interaction with all the relevant teams and prepared high level design and detailed design documents.

Graphical User Interface (GUI) was designed using ASP.NET MVC3 and the business logic was coded in C# [MVC Controllers].

Designed and Developed Web Forms using ASP.NET controls, C#, CSS and HTML to facilitate the registered users.

Designed the application as a three-tier application with UI in the presentation layer, Business logic in the middle layer and Database activity in the third layer.

Developed site map path, master pages and themes to be used throughout the application for consistent appearance, and navigation.

Used ADO.NET and data objects such as Data Adapter, Data Reader, Dataset, data table for consistent access to SQL data sources.

Wrote WPF code following MVVM architecture and designed GUI using XAML, displayed data in form, created user controls, consumed data services in WPF, created WPF Data grid, details data entry form, applied layout, styles and used data templates

Developed various custom controls to have modular design in the Forms, one of them being Custom GridView developed using new features of GridView of .Net framework to show the entire data collected.

Used Windows Communication Foundation (WCF) for multiple services to interact with the application for the clients.

Used AJAX for partial rendering of the Web Forms to improve performance by not having the whole page post back.

Implemented CSS classes to customize html/web server controls and skin on web server controls for consistent look and feel for all controls throughout the application.

Used ADO.NET and LINQ to SQL database programming to access and retrieve data from the SQL Server 2008 database.

Implemented Web Services in C# based on SOAP protocols using XML, XSLT and WSDL transforms extensively for data transfers.

Designed and developed to perform user authentication and screen access authentication.

Developed windows services to send automatic emails and notifications based on the activities performed.

Worked with web.config files, debug VS .Net 2008 files and worked with IIS 6.0 server for creating the virtual directories and to setup of the website and run.

Created WCF Services responsible for communicating and providing real time data from integrated server to Client Application.

Extensively used datasets, Data table and Data view to retrieve and manipulate data and display it in an ASP.NET page.

Worked with WSDL document and SOAP protocol while working with Web service. Developed and Maintained portal using ASP.NET, C#.

Performed client and server validations using Validation Controls.

Designed and developed normalized database in SQL Server 2008 to maintain various details of the devices, team members, device history, and access permissions and so on.

Wrote SQL Queries to create tables, stored procedures, triggers, creating DTS Packages using SQL server and LINQ.

Generated reports using SQL reporting tool.

Involved in integration of applications and maintained versions using VSS (Visual Source Safe).

Involved in the deployment of project on the development and production Web servers.

Involved in creating Unit and System Integration test plans.

Environment: ASP.NET 4.0, C#, WCF, WPF, Visual Studio 2008/2010, ADO.NET, MVC3, XML, LINQ, XSLT, CSS, SQL Server 2008, Windows.

Client: Aetna, Hartford, CT. Sep 11 – Oct 12

Role: .Net Developer

The Quoting and renewal System (QRS) is a web – based quoting tool in the Sales Rating and Quoting domain in the health insurance. It is an Insurance Quote Generation System used in Aetna for Small Business Segment. It is designed to be used for Quoting by Underwriters, Brokers and General Agents access to real-time new business quoting, online renewal and auto renewal. It enables Aetna user’s to Create and edit new business quotes, Send proposals to customers and View the status of the case as it moves through the quoting, underwriting and installation process.

Responsibilities:

Involved in development cycle including high-level design, data design, coding, testing, and creation of functional documentation.

Extensively involved in developing components for Business and Data tier using C#, ADO.Net, LINQ.

Created design documents, which include Use Cases, Process Flow Diagrams using MS Visio.

Worked on presentation, business and data access layer.

Designed and developed Web Forms using ASP.NET and C# and created necessary classes in the business components.

Involved in application design based on Model View Controller (MVC) Design Pattern and OOPS concepts.

Used AJAX Tool kit controls extensively to enrich the GUI and usability.

Widely used JavaScript for Client Side Validation.

Involved in the designing the HTML and developing CSS, Skins for the site.

Involved in designing the Configuration XML for the site.

Used WCF of credit card service while customer payment process.

Deployed WCF service as TCPIP as well as HTTP service.

Identified the appropriate site structure and taxonomy to include site collections, top-level sites, child sites, and libraries.

Implemented Microsoft Enterprise Library Blocks like Data Access, Exception Handling, and Logging.

Developed large number of stored procedures for database operations using T-SQL.

Involved in creating Unit and System Integration test plans.

Environment: C# 3.0, ASP.NET 3.0, WCF, Windows Workflow, JavaScript, MVC, CSS, AJAX, SQL Server 2005, Visual Studio 2008, IIS, Windows.

Client: Norwest Venture Partner, San Francisco, CA. Nov 10 – Aug 11

Role: .Net Developer

Solution Set combines industry-leading technology with user-centered creative to deliver the next, new things in web development, digital marketing and brand experience. Norwest Venture Partners offers its portfolio companies the essentials of success: a sound reputation, significant financial resources, seasoned business experience and a network of relationships.

Responsibilities:

Gathered user requirements by interacting with users and prepared Software.

Created the user controls and web pages using Asp .NET.

Created Classic ASP application using HTML and Java script.

Designed and developed UI (Web Forms), User controls using ASP.NET (C#) after interacting with users for requirements.

Worked with SOAP Web services, Windows Services, .NET Remoting and SOAP Extensions.

Involved in redesign of Web Pages using MVC and JQuery for new interactive features.

Implemented GUI using HTML, XML, CSS and Web Form Controls to create web pages, developed Master Pages, classes for reuse.

Implemented Data access layer (DAL) using ADO.NET to connect and retrieve and manipulate database information.

Implemented Functions, Triggers and Store Procedures using SQL in SQL Server 2005.

Imported all the price lists data from existing excel sheets to SQL Server database.

Responsible in Generating Reports and Bug fixing.

Provided assistance for integration of front end and back end applications.

Involved in creating Unit and System Integration test plans.

Environment: Microsoft Visual Studio (2006), .Net Framework 2.0(c#), ASP.NET, ADO.NET, SQL Server 2005, Web Services, XML, HTML, CSS, Unit Testing, Integration Testing.

Company: RSK Info Solution Pvt Ltd, India. Feb 09 – Oct 10

Client: Smile Quarto

Role: Jr .Net Developer

Smile Quarto can revolutionize their financial processes from managing meager accounting transactions to proactive real time finance engines, able to deliver true financial intelligence and to drive strategic changes throughout the organization.

Responsibilities:

Developed User Interface using ASP.Net web forms and web User Controls in C#.NET.

Retrieved and stored data using ADO.Net and SQL stored procedures.

Implemented live stock quote pricing using web services (webservicex.net).

Developed site map feature from XML Data source used for Menu using XMLDOM and ADO.Net concepts.

Created website using VB.NET.

Used JavaScript, VB script.

Developed several user controls for reusability in several Web-Forms.

Customized and integrated database driven content for the web pages for the portal.

Developed features for subscribing and sending newsletters.

Debugged, corrected and resolved all errors identified by client’s quality team.

Environment: ASP.Net 2.0, C#. NET, JavaScript, Web Services, XML, SQL Server.

Company: Sunsign Computers Ltd., India. Aug 06 – Jan 09

Role: Software Developer

This Project Deals with creation of website for shopping various Computer parts online. Using this project the Company has been maintaining all the information about their Products, Sales and Customer information data. Sunsign Computers deals with the Maintenance of their products, providing the information about the rates and availability of the products and provide online shopping. It gives an automatic reminder when the shipping is due and the amount of payment due by the Customer. This project stores the data in the Database regarding the products.

Responsibilities:

Designed and Developed Web Forms using ASP.NET controls, C#, CSS and HTML to facilitate the registered users.

Used Custom Validation and User Validations.

Used ADO.NET for data access layer to communicate with the SQL Server 2005 database.

Wrote T-SQL queries and Stored Procedures using MS SQL Server for data access and reports.

Involved in transformation of XML data using XSLT into HTML format.

Involved in unit testing.

Involved in deployment and post production support for the application.

Generated reports using SQL reporting tool.

Environment: ASP.NET, VB.NET, HTML, XML, SQL Server, Visual Studio.

References: Will be provided upon request.



Contact this candidate