Sql Server Developer

SANDHYA

SR. Dot Net Developer

PROFESSIONAL SUMMARY

Over 7 years of experience which include Analysis, Design, Development, Implementation and Testing of Client/Server/Internet/Intranet Systems for Business requirements with Microsoft Technologies

Strong experience in developing applications using Microsoft .NET Technologies: C#, VB.NET, ADO.NET, ASP.NET, Web Services, WCF, Visual Studio, Visual studio Team System, IIS,.NET Class Libraries,

Solid internet based software apps: ASP, ADO, HTML, DHTML, CSS, AJAX, XML, XSLT, XSD, JavaScript and JQuery experience, Angular.js

Extensive experience monitoring, troubleshooting and supporting .NET based applications and infrastructure.

Expert Object-Oriented Analysis & Design (OOAD), Client/Server Applications & Relational Databases.

Expertise in developing customized applications using User Controls and Custom Controls.

Expertise in generating the reports using Microsoft reporting services tools like Report Viewer, Active Report, Crystal Report and SSRS.

Developed Object Relational Mapping Tools like Entity Framework, POCO, Typed Datasets, Linq2Sql.

Good understanding of RDMS in writing Views, stored procedures, triggers and complex SQL queries using SQL Server 2005/2008/2008R2 and Oracle 10g.

Good knowledge in Microsoft technologies like Sharepoint, Biztalk server.

Experience in developing UML diagrams for visualizing object oriented analysis and design using VISIO.

Exposure to Software Configuration Management (SCM) using TFS, VSS.

Highly Motivated, committed and a natural team player with Capability to work independently, strong analytical ability coupled with good communication skills

TECHNICAL SKILLS

Operating Systems : Windows XP, NT/2000, 2003 and Windows Vista, Windows7

GUI Tools : Visual Studio.NET 2005/2008/2010

Languages/Technologies : C#.NET, VB 6.0, VB.NET, PL/SQL, UML, T-SQL, SQL

Web Technologies : ASP.NET, AJAX, HTML, XML, XSL, XSD, WCF, WebServices, JavaScript,

JQuery, CSS, Razor and SKIN

Databases : MS-SQL Server 2005/2008/2008R2, Oracle 10g

Middle Ware : LINQ and ADO.NET

Methodologies : OOP, OOAD, Client/Server, Agile

ORMT : Entity Framework, POCO, Typed Datasets, LINQ2SQL

Version Tool : Team Foundation Server 2008 (TFS), Visual Source Safe 2005 (VSS)

Reporting Tools : SQL Server Reporting Services (SSRS), Active Reports, Crystal Reports

Web Servers : IIS 5.0/6.0

Frameworks : .NET Framework 2.0/3.5/4.0

EDUCATION

Masters in Computer Engineering, Fairleigh Dickinson University, New Jersey, USA. May 2006

Bachelor of Technology from Jawaharlal Nehru Technological University, Hyderabad, 2002

PROFESSIONAL EXPERIENCE

Geico, Inc., Chevy Chase, MD Jan 2014 – Till Date

Sr. Dot NET Developer

Geico is Second-largest private passenger auto insurer in the United States and One of the fastest-growing major auto insurers in the U.S. A new Rental Process was developed to give their customers a Fast and easy approach to rent a vehicle online without the Hassle of going personally to the Rental Location.

Responsibilities

Used Agile Scrum methodology and participated in designing and planning the project.

Created dynamic web interface layouts using ASP.NET, MVC 3 Framework, JQuery, JavaScript, C#, HTML, LINQ, and Razor View Engine.

.

Used custom controllers like CRUD controller, Search controller, Wizard controller, Summary controller for application using Entity Framework object model.

Worked as a UI - design and development of dynamic and browser compatible pages using HTML, CSS3, jQuery, AngularJS and JavaScript.

Implemented lookup service using WCF service to bind the constant values from the database.

Utilized ADO.Net Entity framework extensively for data retrieving, querying, storage and manipulation using LINQ.

Created custom AngularJS directive for UI validation and formatting.

Used TFS for version control on a shared team environment and Bug Tracking.

Involved in Unit and Integration Testing and Implementation.

Participated in User Acceptance Testing (UAT) with business users.

Worked in Production Support after the release.

Ensure an excellent quality of deliverables, high team productivity and efficiency in meeting deadlines for all assignments.

Environment

.NET 4.0, Visual Studio 2010, C#, ASP.NET, Razor, WCF, XML, Team Foundation Server, ORACLE 11g, Sharepoint 2010 .

Fannie Mae, VA Feb 2012 – Dec 2013

Sr. Dot NET Developer

This application serves as an automated loan approval system to bank loan officers and allowed them to explore the various options for loan approval process easily. Application performed various other business functions involved in loan life cycle such as account set-up, new loan set-up, appraisal, credit analysis, underwriting, closing and loan servicing, also this application is used to bundle group of loans that will be purchased by Fannie.

Responsibilities

Involved in requirements analysis, design, and development stages.

Involved in developing Multi -Tier Application in .NET using 3 layers approach. Presentation layer developed using ASP.Net and .Net, Business Layer developed using C#, and Data access layer developed using ADO.Net in C#.

Created Tables, Stored Procedures, Views and Triggers for the Database layer by embedding needed business logic and validations.

Created the Data Access Layer with Entity Framework commands and fetched the data from SQL Server 2008 R2 using Stored Procedures and Views using SQL Data Reader and Dataset Objects.

Created the pages with dynamic control rendering technique (all the controls data is stored in the database).

Used Telerik AJAX controls for making the application more users friendly.

Used Angular.js to create the data in the table using ng-repeat attributes.

Developed and used various Web forms and User controls using ASP.Net, C# and JavaScript.

Consumed WCF Web Services for Interaction between WebPages and Business layer.

Used ASP.NET web server controls like GridView and Repeater controls to display the records.

Extensively used Partial Classes, Generics, Interfaces and Object-Oriented concepts for developing the application.

Environment

Visual Studio 2010, ASP.NET 4.0, ADO.NET, HTML, CSS, JavaScript, IIS 6.0, MS SQL Server, Telerik AJAX, Sharepoint

Capital One, Richmond, VA Aug 2011 –Jan2012

Dot NET Developer

Capital One is an American multinational banking and financial services holding company. The project I worked for was a credit card processing system in which, it covers all the aspects from requesting of the credit to cancelling the credit card.

Responsibilities

Involved in gathering of requirements and creation of functional specifications for the project, based on the real-world cases and situations presented by the client.

Established communication between different applications running on same/different platforms using Windows Communication Foundation (WCF).

Used LINQ to Entities, LINQ to Dataset to get the data from the backend and developed the application in C#.NET using Object Oriented Programming.

Used Try, Catch, Finally exceptional handling to avoid circumstances leading to abnormal program termination.

Utilized Master pages, Themes, Navigation controls, Authentication and profiling to design secure web pages using ASP.NET and built highly responsive and interactive AJAX -enabled Web applications using AJAX Tool kit.

Used ADO.NET for creation of front-end database clients and middle-tier business objects used by applications, tools, languages.

Developed database objects such as tables, views, stored procedures, triggers and user defined functions for database operations in SQLSERVER 2008.

Used SSRS to create, manage and deploy reports.

Tested the application and sorted out the errors and also good experience on automated testing.

Maintaining the Source code using Team Foundation Server (TFS) in a multi developer environment.

Provided Production Support to troubleshoot and debug the issues.

Environment: WCF, C#, ASP.NET 3.5, AJAX, CSS, XSD, LINQ, UML, Visual Studio2008, SQL SERVER 2008, IIS, web services.

Dassault Systemes, Eagan, MN Oct 2010 - Jul 2011

.NET Developer

Intercim is part of Dassault systems develops manufacturing operations management software called VELOCITY, a web application used by manufacturing industry especially aerospace and defense industry to help the engineering, quality and shop floor personnel to quickly build and/or help them perform corrective action to resolve discrepancies in the aeronautical equipment build process flow.

Responsibilities

Developed WebForms in ASP.NET using C# as the code-behind language and ADO.NET as the SQL data consumer.

Created Master Page to provide rich look feel for entire application.

Developed Custom User Controls to reduce the Complexity in User Interface Coding.

Designed the Style sheets and maintained Java Script and XML files.

Coded using XSLT in generating the list taking the data from XML document and formatting with XSL.

Created WCF service as a service layer to expose business objects from business logic layer to user interface logic layer in SOAP format.

Used LINQ to SQL as ORM for querying and retrieving data from the database.

Developed the required stored procedures, views and database functions.

Implemented Email alerts for sending the notifications to business as requested.

Involved in peer review of code before deploying to test environment.

Automate the process to get updated balances on invoices from Oracle to SQL database using Windows Service.

Involved in Unit and Integration Testing and Implementation.

Environment

ASP.Net 3.5, WebForms, C#, ASP.NET, WCF, XML, SQL Server 2005, Transact-SQL, Oracle, IIS 6.0,

Sharepoint 2007

MSC Care Management, Jacksonville, FL Nov 2009 – Sept 2010

Web Developer

The Project handles the Central billing system for MSC. The Billing Engine module is built to translate MSC bills into valid Oracle format by validating the data passed on the bills. The billing data is passed to Oracle from different MSC systems for invoice generation. Once invoices are generated in Oracle, they are extracted by another process that routes the invoices to Ebills or paper forms (DWC10, CMS1500, etc.)

Responsibilities

Created and designed project architecture using visual studio solution and created components using class libraries for reusability.

Designed and created the components like object library, data access layer, business layer, reporting and user interface layers and implemented Singleton design pattern.

Created schema classes to map the database schema and data model using object relational mapping.

Developed windows application using C# as the code-behind language, and used oops concepts extensively like inheritance, polymorphism, encapsulation and abstraction.

Designed interfaces, user controls using Win Forms.

Implemented Validation rules for user input data validation.

Created WCF service and configuring end point Address, Binding, Contract (A, B, C) at client application to access the business logic through service.

Create the deployment project using visual studio IDE to generate MSI and Executable for deployment and create over writable and shortcut MSI for easily accessible.

Used Use Cases, UML Class diagrams and Interaction diagrams for describing, visualizing and documenting the object oriented analysis and design (OOAD) using Visio.

Used Team Foundation Server version control on a shared team environment.

Coordinating with team members in resolving project related issues and delivering the source code in estimated time.

Generated embedded reports for displaying payment details using Microsoft reporting service tool SQL Server Reporting Services (SSRS).

Involved in production support defect fixing and releasing hot fixes.

Attended Scrum Meetings and achieved each sprint goals.

Involved in Unit, Integration and load testing. Well co-coordinated with testing department.

Environment

.NET 2.0, C#, WCF, XML, Team Foundation Server, SQL Server 2005, Transact-SQL, SQL SSRS.

WELLPOINT INC, Richmond, VA Jan 2007 – Oct 2009

Web Developer

The Lumenos division of WellPoint Inc is the pioneer in consumer driven health care providing top rated Health Reimbursement Account and Health Savings Account solutions. Responsibilities at Lumenos Production Operations division encompass efforts to ensure high quality and best efficiency through all aspects of documentation and data analysis to support software delivery.

Responsibilities

Key liaison to the technical team for the Production Operations division with a team size of over 80

Utilized domain knowledge expertise to augment the data analysis requirements of Production Operations division

Facilitated team interactions during problem tracking leading to efficient resolutions.

Formulated test plans based on requirements documentation in conjunction with Quality and Compliance team.

Experience with Business Analysis during company restructuring. Ability to adapt to rapidly changing environment.

Analyzed business requirements and Reviewed tests specifications, cases and performed manual testing.

Strong relational database experience with SQL Server 2000/2005 and Oracle 9i.

Translated complicated enterprise specific business rules and procedures into appropriate business logic components such as code libraries, stored procedures, and security modules.

Programmed in ASP.NET with C# and SQL Server 2000/2005

Environment

Visual Studio.Net 2003, SQL Server 2000/2005, Toad, Windows server 2000, JavaScript, Oracle, ASP.Net 2003, C#.

Contact this candidate