Sql Server .Net

Ramya

312-***-**** (C)

*********@*****.***

SUMMARY

Microsoft Certified Programmer with 7 years of solid experience in software design, development, implementation and software engineering.

•7 years of experience in designing, developing and deploying Internet/Intranet applications/projects using Microsoft .NET Technologies.

•Hands on experience in Healthcare, Banking & Finance and Auto Services.

•Expertise in data- centric web and windows applications, with a focus on all tires in N-tier Architecture.

•Experience in front end web application development that involved JQuery, AJAX, CSS JavaScript and Angular JS.

•Experience in database related work primarily using MS SQL Server 2005/2008 and Oracle.

•Experience with Database development experience using tables, triggers, views, stored procedures in PL/SQL & T-SQL.

•Experienced in all phases of SDLC including requirement gathering, analysis, design, coding and testing, expertise in integration.

•Strong knowledge of Object Oriented Analysis/design (OOD), UML and design patterns.

•Developed Applications using MVC3, Razor view engine.

•Good experience with Service Oriented Architecture (SOA), agile methodology, water fall model and good knowledge on other software development methodologies.

•Worked on Windows Communication Foundation (WCF) and REST Services.

•Extensively used Ajax, Telerik RADControls and Ajax Toolkit for UI developing.

•Implemented N-Tier Architecture and integrated the UI with Data base for data retrieval and manipulation using ADO.NET data objects and ADO.NET Entity Framework.

•Experience in securing web applications using ASP.Net authentication and authorization mechanisms.

•Strong Database Design and Development experience with Microsoft SQL Server 2008, SQL Server Reporting Services (SSRS), and Integration Service (SSIS).

•Worked extensively on XML/XSLT and using XML based properties in project.

•Performed N-Unit Testing for testing the applications and proficient in writing Unit Test Cases for Business logic, Web Services and WCF.

•Self-starter, fast learner and a team player with strong personal and group communication skills.

•Skilled in documentation, user presentation and user trainings.

TECHNOLOGIES

Platforms: C, C++, VB, C# (.NET), ASP, ASP.NET 1.1/2.0/3.5, VB.Net, ADO.NET.

Frameworks: .NET 1.0, .NET 1.1, .NET 2.0/3.0/3.5/4.0

Web Servers: IIS 5.0, IIS 6.0, IIS 7.0

Markups: HTML, XHTML, CSS, XML, JQuery, Angular JS, XSLT, AJAX, Java Script,

Databases: MS SQL Server 2000/2005/2008, T-SQL, LINQ, MySQL 5.0, Oracle 8i/9i/10g.

Server Side: WCF, LINQ, SOAP, SOA, REST, Web services.

Source Control: Microsoft Visual SourceSafe, Rational Clear Case, Team Foundation Server, Sub Version.

Reporting Tools: Crystal Reports, SQL Reporting Services.

CERTIFICATIONS

Microsoft Certified Professional (MCP 070-528 - Web based client development using .Net Framework 2.0)

Microsoft Certified Professional (MCP 070-529 - Application development Foundation using .Net Framework 2.0)

Microsoft Certified Professional (MCP 070-431 - Microsoft SQL Server 2005 Implementation & Maintenance)

EDUCATION

Bachelor of Technology in Computer Science, from JNTU, India. (2006)

Masters in Computer science from North Western Polytechnic University, Fremont, CA (2008)

EXPERIENCE

UnitedHealth Group (UHG), MN- Remote, Dallas, TX April 2012- Till Date

BOSS (Business Operations Support Systems), eVI (Electronic Value Delivery Interface)

Senior .Net Developer

BOSS Description: The Business Operations Support System (BOSS) is the Care Solutions source- of-truth system for customer, product, implementation, and operations information. BOSS manages detailed customer, product, and service agreement information for active Care Solutions customers including, detailed information on customer-specific product configuration, operational setup, and implementation activities, such as vendors, contacts, and integration work requests.

eVI Description: eSync Value Interface presents a user friendly view of the integrated data associated with key insight area used to predict, identify and prevent future issues through eVisor, the eVI translates these insight areas into opportunities, Trackers and assements that OptumHealth’s nurses, health advocates and wellness coaches can then share with members.

Responsibilities:

•Responsible for Project architecture, technical design/decisions and domain modelling.

•Performed Business Analyst Role in gathering the requirements and prepared documents.

•Developed user interface using Razor view engine.

•Implemented MVC design pattern for developing the C# web Application.

•Developed an MVC3 application using Razor syntax for view engine.

•Integrated JQuery, AJAX, JavaScript, HTML5 and CSS3.0 technologies into client user interfaces for smooth and enhanced UI experience.

•Extensively used Telerik grids, jqGrids and Detail views.

•Optimized LINQ/SQL Queries for SQL Server 2008.

•Consumed WCF services to for data integration.

•Implemented REST services to write the Sales Force data to Staging and Transactional databases.

•Implemented N-Hibernate for mapping database objects and actively referred them in the application.

•Implemented an Agile project methodology and Test Driven Development (TDD) approach.

•Involved in Unit testing, assembly test plans and performed Nunit and System testing.

•Responsible for all Code Reviews.

•Fixed bugs reported by QA and UAT.

Environment: Visual studio 2012, ASP.NET 4.0, MVC3.0, C#, Razor Views, Aqua Data Studio 8.0, T-SQL LINQ, N-Hibernate, Telerik Controls, HTML 5,CSS 3.0,JavaScript,AngularJS, JQuery, WCF, REST, XML, Agile,TDD, Subversion, HP ALM Explorer 11,Windows7,IIS webserver.

CarMax, Richmond, VA March 2011- April2012

Search Improvements

Application Developer

Description: System Supports: Different functionalities in improving the interactive features of user interface by developing Quick Look, Zoom and Suggestions on CarMax.com site to increase the user experience.

Responsibilities:

•Worked in Agile environment utilizing Asp.Net, C#, CSS, HTML, JQuery, Sub Version, VS2010, SQL 2008.

• Developed the website pages for creating, updating and reviewing different functionalities using C#, Asp.Net.

•Used Ajax for making web-page application faster and more responsive.

•Modified current Car page photo functionality to provide hover zoom and scroll for high resolution photo.

•Developed similar cars widget that searches for cars similar to the one that user viewing.

•Implemented features in Asp.Net MVC application using NHibernate, JQuery/JavaScript.

•Responsible for transition from Entity Framework to NHibernate and creating NHibernate conventions.

•Developed Light Box functionality to display vehicle information without having to view the Car Page.

•Involved in Unit testing and performed Nunit and System testing.

•Involved in bug fixing of the existing components.

Environment: Visual Studio 2010, MVC 2.0, ASP.NET 4.0, C#, HTML,CSS, JQuery, JavaScript, XML, ADO.NET, SQL 2008,N-Hibernate, T-SQL, Sub Version,Windows7.

CarMax, Richmond, VA August2010- March 2011

eSalesPerformer

Application Developer

Description: eSalesPerformer used by CarMax sales force to provide explanation of sales consultant’s current Sales level and also goal setting plans for future focus by the associate. Application is rewritted from vb.net to C# and enhanced to understand clearly.

Responsibilities:

•Responsible for developing the application from requirements gathering stage for architecture.

•Used MVP (Model View Presenter) design pattern to for sharing the same presenter to multiple views enhanced with custom routine front controller engine.

•Designed & developed web user interface using ASP.NET, C#, HTML, CSS, JavaScript, server controls and AJAX Control Toolkit, and developed customized Web User Controls.

•Involved in the development of business logic in C#.Net, ASP.NET 3.5.

•Authentication and User-Role used based on security mechanisms were coded and implemented.

•Generated SQL scripts exports and import of data, Developed SQL Queries for accessing data from the SQL Server2008 database and responsible for performance tuning at the application and database layer.

•Generated reports for monthly based sales using Crystal Reports.

• Responsible for configuration, deployment and administration of Clear case functions.

Environment: Visual Studio 2008, ASP.NET 3.5, C#, HTML,CSS, JavaScript, XML, ADO.NET, SQL 2008,T-SQL, IBM Rational Clearcase, CrystalReports, Windows xp.

Microsoft, Redmond, WA May 2010 – August2010

Customer360POC

SDE (Software Development Engineer)

Description: Worked in the engineering team of the PQO group, I developed an internal POC application that leverages internal search platform to provide a 360 degrees view of Microsoft customers for the purposes of providing higher quality customer support and discover various marketing opportunities(C#/WCF).

Responsibilities:

•Responsible for gathering requirements for architecture and involved in designing the architecture for POC.

•Designed Web user interface using ASP.NET, AJAX Control Tool kit, JavaScript.

•Involved in developing model which gathers potential data from multiple data sources for defined entity.

•Designed a WCF client named Model Resolver to create Data Contracts.

•Involved in consuming web Services using WCF in VS2010.

•Created Middle tier classes that can fetch and input data to the data base.

•Generated SQL scripts, exports and import of data, Developed SQL Queries for accessing data from the SQL Server2008 database and responsible for performance tuning at the application and database layer.

•Responsible for configuration, deployment and administration of TFS functions.

Environment: Visual Studio 2010, ASP.NET 4.0, C#, HTML, JavaScript, WCF, ADO.NET, SQL 2008,T-SQL, Team Foundation Server(TFS) 2010, Windows7.

Verizon, Irving, Texas. Jan 2010 – May 2010

COFEE2.0

.Net Consultant

Description: COFEE2.0 is a unique application developed for the desktop COFEE application. COFEE 2.0 will be an enhancement to the desktop application and will provide it with a wider range of features and compatibility. COFEE 2.0 will be a web based application which will provide the user a better user interface as well as enhanced security and features for effective utilization of the application and better co-ordination with the customer.

Responsibilities:

•Responsible for designing, developing and testing the multi-tier architecture involving the presentation layer, Business component layer and database layer.

•Designed & developed web user interface using ASP.NET, C#, HTML, CSS, JavaScript, server controls and AJAX Control Toolkit, and developed customized Web User Controls.

•Involved in the development of business logic in C#.Net, ASP.NET 3.5.

•Used (Model View Controller) MVC design pattern to implement the UI and business logic.

•Created custom controls and web user controls (.ASCX) files for code reuse and developed CSS for consistent look and feel of the website.

•Used controls such as Update Panel, Accordion control, Calendar Control, Collapsible panel in AJAX control toolkit to provide a rich and interactive web experience.

•Implemented for rich UI web applications and written code to change active content programmatically.

•Created Web pages that used the ASP.Net Server controls and also created XML Files on-the-fly using data entered in ASP.Net Web Form.

•Extensively used ADO.NET and data objects such as Data Adapter, Data Reader, Data Set, Data Table, Data view to access data from SQL Data sources to Business Objects Mapper and updating the changes accordingly to SQL data sources.

•Maintained state of the Webpages in using View State and Session Memory objects.

•Wrote Stored Procedures, Triggers, Functions and T-SQL Statements to access and manipulate data from SQL Server Database 2008.

•Created and exposed web services using WCF architecture for the client to communicate and exchange data and involved design of WCF based Service, Data, Fault and Message Contracts.

•Worked in Agile development environment and participated in meetings and discussions with department heads, project managers, architects and users.

•Implemented test cases using Nunit and unit test for the application.

•Used IBM Rational Clear Case for Version Control in team environment.

•Supported the systems for issues during off-hours and weekends.

Environment: Visual Studio 2008, ASP.NET 3.5, C#,XML, XSLT,HTML,CSS, JavaScript, AJAX, SQL Server 2008, T-SQL, ADO.Net, MSMQ, SQL Server Reporting Services(SSRS), WCF, IBM Rational Clear Case, MS Visio, IIS 5.0, Nunit, Windows XP.

In View Medical Imaging &Vein Care Center, Fremont, CA Jun 2008 – Dec 2009

Patient Health Record System (PHRS)

Midlevel .Net Developer

Description: This application is developed to include the Patient Demographics Details, Insurance Details and Workflow Data for the medical practice in paperless format. The medical records are electronically managed over secured connections while maintaining the data security. It is developed to increase physician efficiency and reduce costs, as well as promote standardization of care. This project complies with HIPAA (HL7 - Health Level 7) standard, which describes the standards for clinical and administrative data. HL7 standard provides a framework for the exchange, integration, sharing and retrieval of electronic health information between various medical systems. XML based Web Service which complied with HL7 was developed.

Responsibilities:

•Created Web and Windows forms using ASP.NET Server Controls, Validation Controls, and User Controls.

•Developed re-usable templates and controls using Master page and User controls.

•Worked on Web Pages to connect Providers, Employers & Examinees through Knowledge Center, Appointment Center, Event Center, and Accounting Center.

•Created Windows forms to Search Data, Select Data, Report Generation, Detail Forms, Login Forms, and Web Browser Forms.

•Developed a module which uploads Videos and Grab’s the first image of the video and upload the same in two different folders(Video, Image) of patients on Fileserver using FTP.

•Worked on Ajax controls like Script Manager Control and Update Panel control for partial-page update and created Ajax enabled grid control with expandable rows.

•Involved in the design and development of database, created Complex Queries, Stored Procedures, and Views using SQL Server 2005 and worked on Transact-SQL queries.

•Worked with ADO.NET for Data Access and used SqlClient objects like Sql Connection, SqlReader, SqlDataAdapter, and SqlCommand.

•Worked on LINQ to query the data access components LINQ to SQL and LINQ to XML.

•Implimented HIPPA Transactions payment/Advice,status request and response.

•Worked on Web services ASMX to access External Lab Data and also worked on Message Queues to communicate between different applications for the system.

•Involved in Data Analysis and SQL Reporting Services for the client on their Customer profiles.

•Performed unit testing using Nunit for the modules developed.

•Experience in agile TDD software development methodology

ENVIRONMENT: Visual Studio 2008, .NET 3.5, C#, ASP.NET 3.5, ADO.Net, XML, JavaScript, Ajax, CSS,, SQL Server 2005, Microsoft Office SharePoint Services (MOSS) 2007, Message Queues, FTP, SQL Reporting Services Web Services, VSTS, Team Foundation Server (TFS).

Campus Federal Bank, Baton Rouge, LA July 2007 – Jun 2008

Educational Loan Financial Management System

.Net Developer

Educational Loan Financial Management System is a web based comprehensive software package supporting Student Financial Aid Administration, Loans, Lenders, Faxing and Reports. The system is modular and organized to support all of the functions of the Financial Aid Office: tracking, need analysis, evaluation, packaging, notification, disbursement, funds management, reporting, verification, and compliance.

Responsibilities:

•Designed UML Diagram for the VB.NET application using use-case, sequence and class diagrams

•Developed VB.NET template class for Exception Handling

•Developed admin pages for Credit Advisor that would allow business to test XML data at various points in code. The admin pages display mortgage products, daily rates, disclosures, business scenarios, closing costs and data retrieved from the oracle database.

•Wrote UI pages for data display using JavaScript, Html and code behind using VB.NET

•Designed and developed a web based application and component using VB.NET to automatically generate constants by reading and parsing XML source files and schema files.

•Form authentication and User-Role based security mechanisms were coded and implemented.

•Worked extensively to design all possible test cases to avoid future surprises while hosting web parts in any SharePoint portal sites.

•Created the tables, views, indexes, constraints, sequences, database links, stored procedures and triggers using Oracle.

•Created the User controls and master pages to maintain the same look and feel throughout the application.

•Used Caching to improve the Performance.

•Used Master Pages for a unified look and feel of the application.

•Used Datasets and Grid View to retrieve, display and manipulate the data as desired from the User Interface.

•Performed Unit Testing using Nunit tool for developed ASP.NET Web Applications.

•Wrote PL/SQL Store procedure to automate the cloning process and to create the repository database.

•Used Visual Source Safe for source control.

Environment: ASP.NET 2.0, ASP, VB.NET, ADO.Net, XML, XSLT, HTML, DHTML, UML, Java script, Visual Studio 2003, Oracle 8i&9i, PL/SQL, Web services, COM+, Visual Source Safe 6.0, Crystal Reports, Nunit,, Windows 2007.

Contact this candidate