Sql Server Engineer
Resume:
Ruminder Kaur
*************@*****.***
* ***** ** ************ ********** as a developer in Microsoft Technologies using ASP, ASP.Net,
C#, VB.Net, ADO.Net, Web Forms, Web Services, Windows Services, LINQ to SQL, Entity
Framework, AJAX, WCF, MVC3,Team Foundation Server and SQL Server
2005/2008/2010/2012.
• Extensive experience using Visual Studio .NET platform(C#, VB.NET, ASP.NET,
ADO.NET, LINQ, Entity Framework) with knowledge of the architecture and the
framework.
• Experience in working with MVC Environment.
• Experience in writing in C#, LINQ, ASP.NET, ASP.NET MVC3 and SQL Server.
• Experience in development of Windows, Web applications using C#, WPF, ASP.NET,
ADO.NET, AJAX, .NET Framework, Web services, WCF and SOAP.
• Developed n-tier web applications in .NET environment using C# .NET, ASP.NET,
ADO.NET, XML, Web services, T-SQL, SQL server 2005/2008 and Oracle DB.
• Worked with .NET Data Grid Web Control and Form validation controls.
• Experience in database development on Access 2003, MS SQL Server 2000, 2005 and
2008.
• Excellent skills in analyzing user’s requirements, modeling the system and ensuring the
functionality, with client satisfaction as the strong and primary focus.
• Good experience in relational databases, designing database tables and developing
pertinent data structures.
• Extensive knowledge of technologies like HTML, JQuery, JavaScript, and CSS.
• Experienced in all stages of Software Development Life Cycle
• Hands on experience in migrating web based applications to .NET platform
• Hands on Experience with knockout.js in recent project.
• Hands on Mobile Application.
TECHNICAL SKILLS
Technologies Microsoft .NET: ASP.NET 1.1/2.0/3.5/4.0/4.5, C#, VB.NET,
1.
ADO.NET,
Web: ASP 2.0/3.0, JavaScript, JQuery,Ajax, VBScript,
2.
HTML/DHTML, XML
Development Visual Studio .NET (2003,2005,2008,2010,2012)
1.
Environments
Databases SQL Server: 2012/ 2010/2008/2005.
1.
Source Control TFS
1.
Visual SourceSafe 6.0
2.
Operating Systems Windows: Windows 7, Windows Server 2008, Windows Server 2003,
1.
Windows 2000
Web Servers IIS 5.1/6.0/7.0
1.
EDUCATION
• MSc. in Information Technology from Panjab University, Chandigarh, India.
• Bachelor of Computer Application from PTU, Jalandhar, India.
PROFESSIONAL EXPERIENCE
MIA, Baltimore, MD
Sr. Developer, November 2013– Till Date
Project Title: ACA Rate Disclosure
ACA Rate Disclosure allows consumers to review Health Insurance Rates and provide comments in
support of the Affordable Care Act (ACA), the federal health reform law that affects health insurance in
Maryland. The ACA encourages strong consumer protections, new health benefits options and the
information consumers need to make decisions about health care coverage.
Roles and Responsibilities
• Analyzing business requirements, Communicating with stake holders to identify the features that
need to be included to the ACA Rate Disclosure Application.
• Independently worked on the analysis, development, and maintenance phases of SDLC.
• Created Mockups for all the screens.
• Created PowerPoint presentations and presented to several stakeholders.
• Written Unit test specification and plan.
• Developed stored procedures, views and functions for extracting data.
• Used T-SQL, Joins and sub-queries concept for extracting data from multiple tables.
• Integrated admin module with existing\legacy filing system to pull data
• Created Custom error handler to get stack trace by email for any unhandled exception.
• Created\modified module to encrypt decrypt query strings.
• Worked on Sort Site tool to scan the website for 508 compliance and fixed the issues.
• Worked with APP Scan to remove vulnerabilities reported by security team.
Environment: SQL Server 2012, T-SQL, Visual Studio 2012, EF, Crystal Reports, ASP.net 4.5,
C#.Net, N-tier Architecture, RAD Methodology, SSIS, TFS, Jquery and AJAX.
Westat, Rockville, MD
Sr. Developer, June 2012 – October 2013
Project Title: CTSU
CTSU stands for Cancer Trial Support Unit. In Westat CTSU is a team of 20 developers that is
working from last 10 years to support all cancer trial cooperative groups across US. There are
several .net, and java based applications that are used to integrate all cooperative groups into one
system.
Roles and Responsibilities
• Analyzing business requirements, Communicating with stake holders to identify new features that
need to be added to the CTSU website.
• Creating web pages and C#.Net libraries as per requirement.
• Creating and modifying SQL server database objects and functions and linking them to front end
components.
• Responsible for converting data synchronization module to MVC.
• Consumed web services to integrate with other applications.
• Created WCF web service to share protocol data with other systems.
• Involved in the analysis, development, and maintenance phases of SDLC.
• Converted around 15 class libraries to use Entity Framework.
• Created Algorithms to demonstrate the flow of the modules.
• Created Mockups for several new screens.
• Created PowerPoint presentations and presented to several stakeholders.
• Designed new reports needed for site users using crystal report.
Environment: Sql Server 2010, T-SQL, Visual Studio 2010, Crystal Reports, ASP.net 4.0, C#.Net,
MVC, N-tier Architecture, Agile Methodology, SSIS, SSRS, Jquery and AJAX.
NVR Inc., Frederick, MD
Sr. Developer, October 2011 – June 2012
Project Title: Whole House Loader
Whole House Loader: NVR is one of the major building and finance firms. Purpose for Whole House
Loader project is to load all the material required for the house construction into the Informix and SQL
Databases. This includes the houses from NV Homes, Ryan and Cornerstone.
Responsibilities:
• Written C# classes.
• Reading Excel sheets and loading the building material data and non-building
material data into SQL Server 2008.
• Extensively used ADO.NET for creating Datasets and Data Tables.
• Extensively worked with SQL Server Stored Procedures, Views and Packages.
• Developed stored procedures, views and functions for extracting data.
• Used Joins and sub-queries concept for extracting data from multiple tables.
• Involved in the analysis, development, and maintenance phases of SDLC.
• Written Unit test specification and plan.
• Interacting with the business customers and across teams.
• Used the Agile methodology in working on this project.
Environment: C# ASP.NET 3.5, Web forms, ADO .NET, Visual Studio 2010, HTML, JavaScript, Microsoft
Office Excel, SQL Server 2008, Microsoft Visio, Windows 7, LINQ.
Hay Group, Philadelphia, PA
Sr. Developer, June 2011 – October 2011
Project Title: Data Integration Platform
Development Summary Reports: Hay Group is a global management consulting firm. Hay group gets a
excel report from Learn Centre which contains data for different countries. I have created a tool to extract the
input and reference files and create excel workbook for each country.
Responsibilities:
• Reviewing and analyzing requirement, drafting functional and technical
specifications.
• Created Flow Charts for requirement verification using Microsoft Visio.
• Involved in coding business logic layer and Data Access layer and written
methods in C# .NET, Visual Studio 2010 and .NET framework 3.5.
• Used Microsoft office interop library for creating Excel workbooks.
• Extensively used ADO.NET for creating Datasets and Data Tables.
• Involved in the analysis, development, and maintenance phases of SDLC.
• Used Linq for querying the Data tables.
• Interacting with the business customers and across teams.
• Work with end-users to understand reporting requirements and translate and develop
and test reports.
Environment: C# ASP.NET 3.5 ADO .NET, Visual Studio 2010 HTML, JavaScript, Microsoft Office Excel,
Microsoft Visio, LINQ.
Planet Success, India
Development Engineer, June 2008 –June 2011
Project Title: Vitunique NL
Online Shop for a large pharmaceutical company with ability to generate a vitamin formula based on
complex algorithm based on scientific findings for the customer at runtime
Responsibilities
• Worked on NopCommerce Open source to extend\customize several inbuilt features.
• Worked on Formula Search Module to evaluate Vitamin Formula that is best for user’s lifestyle
identified through an online questionnaire.
• Designed the web forms using ASP.NET and validations were achieved via JavaScript enabled
with Ajax with CSS for smoother rendering and browser-compatible pages
Environment: ASP.NET, VB.NET, Web forms, XML, .NET Framework 3.0, HTML, JavaScript, Web
Service, IIS 7.0, SQL Server 2008, AJAX.
Planet Success, India
Development Engineer, October 2007 – May 2008
Project Title: Evolve US
CMS for Timeshare company to allow sales representatives to manage Clients, Appointments and Sales.
The solution is developed on the lines of SAS (Software as Service)
Responsibilities
• Worked primarily on Business Layer to create functionality for Sales Management, and Client
Management
• Worked on UI specifically using DevExpress tools.
• Created stored procedures, user defined function, views for querying and modifying the
database.
• Client Customization of the Application and Preparation of the Required Interfaces for the
Clients.
Environment: ASP.NET, C#, Web forms, XML, .NET Framework 2.0, HTML, JavaScript, Web
Service, IIS 6.0, SQL Server 2008, AJAX, DevExpress Toolkit.
Oneders, India
Development Engineer, May 2006 – Sep 2007
Project Title: EthnicCounselors.com
Oneders has been focused as an organization that provides Software Outsourcing. Oneders has focused
just on the web applications and websites.
This is an official marketing and registration site for the Ethnic Corp.
• Multilevel User registration.
• User Rights Management.
• Database Oriented Chat.
• Message Board.
• Edit Feature for the Static Pages.
Roles and Responsibilities
• Implemented Checkout Merchant account.
• Understanding of business logic and creating SRS
• Development, Coding in Asp.net 1.0 for implemented Multilevel user registration and User
Rights Management module
• Manual testing and integration testing
Environment: Asp.net 1.0, C#, Ado.Net, SQL Server, CSS, JavaScript, Visual Studio 2003
Contact this candidate