.net Developer Resume
Nashville, TN
SUMMARY
- Full stack .net developer with 8 years of experience in design, development and implementation of Client - Server (WinForms) as well as web-based computing solutions in Microsoft platform working as Programmer Analyst and Web Application Developer.
- Design, Develop and Implement Web Applications using .NET3.5,4.0,4.5 Framework Architecture including C# .NET, Win Forms, ASP.NET core, ASP.NET, AJAX, WCF, MVC, Web Services, ADO.NET, Data Entity Framework, XML, IIS and Visual Studio.
- Experience in handling, configuration and administration of databases likeMySQLand NoSQL databases likeMongoDBand Cassandra.
- Implemented APIs using play framework in Scala to perform analytics and persist results in Elasticsearch
- Experience in creating web applications implementing the Web API and WCF Restful architecture.
- Expertise with application development using Object Oriented Analysis & Design techniques (OOAD).
- Experience in SQL Server 2016/2014/2012/2008 , SQL Server 2005/SQL Server 2000, with technologies such as Stored Procedures, Views, Triggers, Transact SQL, SSIS, and SSRS.
- Implemented load-balancing with NGINX to allow dozens of Node JS instances to handle thousands of concurrent users.
- Experience in front end development including extensive experience usingBootstrapframework for responsive site
- Worked on development of UI of various modules mostly based onAdobe Flex.
- Developed and consumed Mobile/Web Development, Web services (HTTP, SOAP, XML) and WCF services (HTTP, Net TCP, SOAP, XML)
- Designed and implemented the application using MicroService Architecture for its various distinct advantages like loose coupling and design patterns.
- Experienced working on Docker ORM for containerization.
- UsedReact JSfortemplatingfor faster compilation and developing reusablecomponents.
- Created WPF for attractive and effective user Interface usingXAMLDocument.
- DevelopedWebApplication by MVC patterns.
- Proficient in Elasticsearch, data modeling and querying using log aggregation, data extraction and reporting using Elasticsearch, Logstash, Kibana tools.
- Experience in overseeing MongoDB condition from accessibility, execution and adaptability points of view
- Extensive database designing and programming skills using MongoDB.
- Having good experience in writing and executingPowerShellscripts.
- Experience in developing UI using ASP.Net Server-Side Controls, HTML Controls, CSS, JavaScript, and JQuery.
- Experience in implementing client-side JavaScript, JQuery, HTML, DHTML, and CSS.
- Experienced with setup, configuration and maintain ELK stack (Elasticsearch, Logstash and Kibana) and OpenGrok source code (SCM)
- Expertise in Design and Development of User Interfaces, User Controls and Custom Controls using ASP.NET and C#.
- Worked on .NET3.0, 3.5, 4.0, 4.5 framework Security features such as Authentication & Authorization, Forms-based Authentication, Authorizing Users Roles and User Account Impersonation.
- Generated reports using various reports generation tools/services like SQL Server Reporting Services and Crystal Reports.
- Working knowledge on Cloud computing usingMicrosoft Azure for enabling services on cloud.
- Implemented client-side Interface usingReact JS. Build stable React components and stand-alone functions to be added to any future pages. Used React-Router to turn application into Single Page Application
- Managing iOS & Android Mobile Applications for more than 2 years (Deployment, Testing & Build Process).
- Domain knowledge and business expertise in healthcare, insurance, financial and automobiles.
TECHNICAL SKILLS
Programming Languages: C, C++, C#, PowerShell, VB.net, and ASP.net.
.NET Technologies: ASP.NET core, ASP.net, ADO.Net, Web Services, MVC, WCF, WPF, LINQ, Entity Framework, AJAX Framework, .NET FRAMEWORK 1.1/2.0/3.0/3.5/4.0/4.5
Front End Tools: Visual Studio 2017/2015/2013/ 2012/2010/2008/2005/2003
Web Related Technologies: AJAX, Java Script, JQuery, Angular JS, Angular 1.5, 2.0, HTML4/HTML5, DHTML, CSS2/CSS3, XML, XSD, XSLT, XPATH,XAML.
Web & Application Servers: IIS 6.0, IIS 7.0
Database Server& Services: MS SQL Server2017/ 2016/2014/2012/2008 , Oracle 11g, MS Access, SSIS, SSAS and DTS
Reporting Tools: Crystal Reports 12/11, SQL Server Reporting Services, Elastic search
Operating Systems: Windows XP/Server 2003/2008/7/8
PROFESSIONAL EXPERIENCE
Confidential, Nashville, TN
.NET Developer
Responsibilities:
- Used AGILE RALLY/SCRUM methodology to implement the application
- Used x-confluence page for project documentation and also internal errors or issues.
- Created Single Page Application (SPA) usingAngular 8framework for binding data to specific views and synchronize data with server.
- Elasticsearch and Logstash performance and configuration tuning.
- Excellent experience onJ2EEdesign patterns such as Business Delegate,Service Locator, Transfer Object, DataAccess Object,Session Facade,Singletonpatterns
- UtilizedReactfor its efficient dataflow architectureto create a lightweight and render efficient web app that searched projects via theGitHub APIthrough keywords.
- ImplementedReactcontainerandpresentationalcomponents(as Stateless and Functional components when applicable).
- Skilled in monitoring servers using Nagios, Data dog, Cloud watch and using EFK Stack Elasticsearch Fluentd Kibana.
- AddedExcel-Builderto downloadthe Tabular datain Excel format usingReact
- Used Restful web services and developed dynamic web pages.Develop Business logic layer by implementing Object Oriented Programming languages (OOPS) concepts abstraction, encapsulation, inheritance, polymorphism in C#.
- Develop Business logic layer by implementing Object Oriented Programming languages (OOPS) concepts abstraction, encapsulation, inheritance, polymorphism in C# 6.0.
- Implemented a Restful API server withNodeJSand Express JS.
- Worked on MVC architecture (Controllers, View Models, Models, Views, Business Layer, and Data Access Layer), built using OOP’s principles and migrated the application business logic from ASP.NET webforms to ASP.NET MVC.
- Providing Global Search with Elasticsearch
- Experience in handling databases likeMySQLandNoSQLdatabases likeMongoDB.
- Used JSON objects effectively for efficient client-side coding and Typescript/JavaScript template design.
- Transformed conceptual designs into interactive user interface using HTML5, CSS3 and Bootstrap.
- ImplementedAngular 8Router to enable navigation from one view to the next as agent performs application tasks.
- Implemented http asynchronous post calls using JQuery, AJAX & JSON data.
- Used Angular 8 and Typescript to develop single page application (SPA).
- Developed business tools using ASP.NET MVC and Angular 8 framework which brings more value to the organization.
- Expertise inReact JSframework to develop theSPA.
- Implemented Disaster management for creating Elasticsearch clusters in two DC and configure Logstash to send same data to two clusters from Kafka.
- Experienced inReact JSand working withReact Flux architecture.
- Planned, developed & maintained Infrastructure as code for CI/CD deployments using Terraform.
- Troubleshoot Saleslogix application issues within a complex environment with multiple application and sync servers based on SQL databases.
- Experience with creating script for data modeling and data import and export. Extensive experience in deploying, managing and developing MongoDB clusters. Experience in creating JavaScript for using DML operation with MongoDB.
- Designed and Developed Microservice's for the business components using .NET framework.
- Configured and maintained Jenkins to implement the CI/CD process and integrated the tool with Git, Maven, Nexus, Docker, Nagios and Jira for end to end automation and took the responsibility to maintain the CI/CD Jenkins server.
- Delivered architecture designs and solutions for public, private and hybrid clouds covering the cloud architecture tiers and portfolios of cloud services. IaaS, PaaS, SaaS.
- Creating Azure Artifactory and nuget packing for continuous integration and deployment (CI/CD).
- Developing a Continuous Delivery (CD) PIPELINE with Docker, Jenkins, GITHUB and Azure pre-built images
- Developed ASP.NET Core Web API based on departmental requirements and specifications.
- Experience in Client-side web development utilizing HTML, CSS3, Bootstrap, and Angular7/8, Typescript.
- CreatedAngular 8components, implemented Interpolation, input variables, Bootstrapping, Ng For, Ng If, Router Outlet, binding the click event, Component decorator, binding to the hidden property.
- LeveragedAngular 8resources for all data access, encapsulating URLs and standardizing data access interfaces. Created custom directives for re-usable components (Multi-filed form elements, background file uploads etc.)
- Worked with advanced concepts of ASP.NET Core MVC such as Models and Providers, Filters used for developing backend technology.
- Responsible for writing Stored Procedures and User Defined Functions to retrieve the data from the central database and extensively worked on bug fixes in SQL procedures using SQL Server 2016/2014.
- Developed new user interface components for different modules usingKendo UI.
- Used the Kendo UI controls for more robust requirements. Controls used such as grid, panel, date picker, combo box, validation, dropdown and Auto complete etc. throughout the application.
- Implemented data access using EntityFrameworkto store and retrieve new user information for further use.
- Used N-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#. Net. Good Experience in Developing Applications using Microservices architecture.
- Worked extensively on connecting applications to database using Entity Framework, LINQ andLambdaExpressions.
- Currently working on Microsoft Azure for enabling services and pushing the data into the cloud.
- Modified Web Services to interact with the other applications and exposed them usingSOAPand HTTP.
- Managed Clusters with various Servers inAzureCloud Resource Groups.
- Developed windows services to store SQL Server data in to Cloud base data warehousing by using Microsoft Azure.
- Working knowledge onAzureCloud IaaS and PaaS Services.
- Involved in Unit testing (N unit), Build and integration testing for the interfaces.
- Automating using C#.net and N-unit testing.
Environment: .Net 4.0,4.5, MS Visual Studio 2017,2015, 2012.ASP.NET Core2.0,C#.NET, NPM, HTML5, CSS3, Angular 2, Java Script, Typescript, Bootstrap 3.0, Entity Framework 6.0, Kendo UI, Microsoft Azure,SQL Server 2014,2016, Perforce, Cherwell, GIT.
Confidential, Cleveland, OH
. NET Developer
Responsibilities:
- Actively involved in SCRUM meetings discussing the implementation, integration of backlog modules considering the released version of software and best practices for solutions.
- Developed the web pages using ASP.NET core MVC4, C#, HTML5, JavaScript, XML and CSS3.
- Used Angular2 framework where data from backend is stored in model using http andsecurity configurations for authentication and authorization for populated model on to UI.
- Created Typescript reusable components and services to consume REST API's using Component based architecture provided byAngular2.
- Responsible for creating the .NET builds and making sure the builds are migrated all the way up to the Production Environment.
- Experience in usingReact JS components, Forms, Events, Keys, Router, plus Redux, AnimationsandFlux concept.
- Good Experience inReact.jsfor creating interactiveUI'susingOne-way data flow, Virtual DOM, JSX, React Nativeconcepts.
- Familiar with creating Custom ReusableReactComponents Library
- Developed ASP.NET user controls adding component reusability.
- Used various TPs to bypass HIPAA edits during the submission of EDI claims.
- Implemented Web Parts, AJAX, web services and globalization in the project.Database design and development of database objects in SQL Server 2008 using Microsoft SQL Server Management Studio Express.
- ImplementedJAVA/J2EEdesign patterns such as Factory,DAO, Session Fa ade, and Singleton.
- Implemented J2EE Design Patterns likeMVC, Service Locator and Session Facade.
- Created stored procedures to load the data coming from external systems to SQL Server 2008.
- Front End/ UI developer with expertise in AJAX, JavaScript, JQuery, HTML5, CSS3
- Experience in creating dynamic web interfaces using Angular JS/Angular 2.0.
- Developing the application using MVC, Entity Data Model and RESTful and WCF services.
- Created custom elements, HTML imports, shadow DOM to allow fully encapsulated custom elements by using Angular 2.0.
- Define new UI elements / frameworks for use by development teams.
- Developed login page, security for the application.
- Used ASP.NET Core, Telerik, CSS3, HTML5, Bootstrap and Entity Framework.
- Develop and Consume Windows Communication Foundation Services (WCF) which interfaces with Windows Active Directory and SQL Server
- Designed and Developed Logging and Monitoring for Microservices by fluentd.
- Designed and Consumed XML Webservices using Microservices.
- Delegating tasks and prioritize work load amongst development teams and coordinating the entire project group under various project activities.
- Responsible for creating & Managing Docker ORM files for creating necessary base images used for automation of build & deployment environments.
- Designed and coded Win Forms using C#.NET.
- Used Angular 2 Npm packages like ng2-datepicker, ng2-pdf-viewer, ng2-auto-complete etc., to meet the requirements of the project.
- Implemented UI using MVC 4.0, HTML, XML, CSS, JavaScript, AngularJS, AJAX and Web Form Controls to create responsive web pages, developed Master Pages.
- Developed module which deals with validating user, changing passwords and searching of information depending upon priority of user in site. Debug and test new applications created using MVC 4,Silverlightand Entity Framework.
- Implemented code for AJAX based application by fetching the response from backend API as a part of JSON
- Manage environments for legacy codes using specific Docker containers based on the required architecture.
- Designed the new Web UI andWeb API Layer.
- Using IIS 7, create web sites, services sites, deploy new applications created usingSilverlightand Entity Framework, JavaScript maintain web sites, services sites.
- DevelopedData Access LayerusingLINQtoSQL, T-SQL, and ADO.NET.
- Worked onReact JS Virtual DomandReact views, rendering using components which contains additional components called customHTML tags.
- Implemented various screens for the front end usingReact.jsand used various predefinedcomponentsfromNPM (Node Package Manager)andredux library.
- Worked in usingReact.JS components, Forms, Events, Keys, Router, Animations,andFlux concept.
- Transformed XML document with XSLT in ASP.NET application.
- Involved in Production Support and minor enhancements as per application requirements; HTML5,CSS3, JavaScript, JQuery, Angular2, Ajax, Agile Methodology, Windows.Created Views and Partial Views - UI and middle tier for various modules using MVC (Razor View Engine), AJAX, jQuery, HTML, CSS.
- Developed ASP.NET user controls adding component reusability.
- Import data from SQL Server, MS-Access.
- Experience in usingTeamFoundationServer (TFS), Microsoft Visual Source Safe (VSS) and Subversion (SVN) for Source management.
- Utilized JIRA during development for project management.
- Used AngularJS to create Controllers to handle events triggered by clients and send request to server.
- Developed the code to integrate IBM WebSphere MQ with MongoDB enabling real-time messaging updates.
Environment: Angular2.0, 1.5. Net4.0, 3.5, ASP.Net core, MVC 4, C#, ADO.Net, LINQ to SQL, HIPAA, AJAX, HTML, MS Visual Studio 2015/2013, WCF, Bootstrap, CSS, JAVASCRIPT and SQL Server 2008, TFS, Microsoft Azure.
Confidential, Omaha, NE
.NET Developer
Responsibilities:
- Involved in Daily Scrum (Agile) meetings.
- Worked with n-Tier Architecture involving Services Layer, Data Access Layer, and Business Layer
- Major role in the development of the web application using ASP.NET 4.5.1, Telerik .NET UI Controls, MVC 6.0, C#, Java script, JQuery, Bootstrap, Entity Framework, Angular JS and AJAX.
- ImplementedUIScreen using MVC Razor Engine, JQuery,and KendoUI Assisted in developing database objects like Tables, Views, Stored procedures and Triggers in SQL Server 2008/2012/2014.
- Assisted in preparing presentations and scheduling meetings
- Good experience in developing Configured and Consumed RESTful Web Services using Windows Communication foundation (WCF) in C# / VB.NET
- Developed the web pages using ASP.NET MVC4, C#, HTML5, JavaScript, XML and CSS3.
- Provided expertise on Web Content Accessibility Guidelines(WCAG) 2.0 compliance
- Designed the dynamic and web compatible pages using the HTML5, CSS3, Gulp, Node JS, JavaScript, Bootstrap.
- Created & Exposed RESTful Web API endpoints using HTTP verbs of GET, PUT, POST&DELETE for all database CRUD operations.
- Used OOP’s Concepts and SOLID principles with C #6.0 languages to implement business logic and code behind view models.
- Developed the win forms and web applications for the Duplicate Detection toll using Asp.Net, C#, MVC 5 and .Net Core 4.7.0.
- Used Source tree, Bitbucket, Jira for development and tracking issues purpose.
- Developed and tested user-friendly navigators by utilizing JavaScript and VB .NET.
- UsingVB.Net in relation and collaboration with object-oriented programming.
- Used Entity Framework Code First approach to implement data access layer, used LINQ to Entities to write Lambda Expressions for data sorting, filtering and projection in various dimensions.
- Created the Controllers and Controller Actions, Filters, Routing, Custom Action Filters using ASP.NET MVC.
- Implemented both MVC architecture and Entity Framework to create automated view models and entity classes.
- Designed and Developed WebApi's for Microservice's.
- Worked on Visual Studio 2017 / .Net CORE 4.6 Framework to implement Business Logic.
- Developed Data Access Layer to communicate with SQL Server 2014 using Entity Framework Code First approach and queries being written using LINQ to Entities, worked with performance tuning of Entity Framework too.
- Leveraged AngularJS 2.0 resources i.e. AngularJS controllers, components, factory, directives and services, routings and events etc. for all data access, encapsulating URLs and standardizing data access interfaces.
- Used Microsoft Excel sheet for the quick import of all the various Application data into the AUS database using C# 6.0.
- Resolve the UNIX requests or issues for SAP developers.
- Performance monitoring and tuning on UNIX systems. Develop step-by-step method using predesigned Worksheets to eliminate much of guesswork in performance monitoring and tuning.
- Developed WEB API 2.0 Services to capture important life insurance policy application data from clients to provide an interactive approval process for underwriters.
- Worked on automation of Test cases using XUNIT for unit testing of existing modules.
- Used WPF 4.5 built-in set of data services to bind and manipulate data within the web-application.
- Used TPL (Task Parallel Library) for scheduling of threads on Thread Pool and state management and worked on Azure.
- Used TFS 2013 for Version Control and Dimensions for deployment of code to SIT and UAT test servers.
- Written packages to transfer the data between the systems using SQL Server Integration Services (SSIS).
- Implementation of Custom reports by pulling data from various sources and presenting in SQL Server Reporting Services (SSRS).
- Written & optimized T-SQL statements, Views, User Defined Functions, Stored procedures with SQL server database.
- Designing and deploying dynamically scalable, highly available, fault tolerant, and reliable applications onAzure.
- Migrating complex, multi-tier applications onAzure.
- Lift and shift of an existing on-premises application toAzure.
- Employed HTTP for Client/ Server communication.
- Experience with supporting SQL Server within anAzurePaaS environment
- Involved in writing test cases for the application.
Environment: Microsoft .Net Framework3.0,3.5, VB.net,ASP.Net, .Net Core, MVC 4, C#, ADO.Net, LINQ to SQL, AJAX, HTML, MS Visual Studio 2015,2012,JavaScript,Bootstrap,WCF, CSS, and SQL Server 2008,TFS.
Confidential, Syracuse, NY
.NET Developer
Responsibilities:
- Involved in Daily Scrum (Agile) meetings, Sprint planning and estimation of the tasks for the user stories, participated in retrospective and presenting Demo at end of the sprint.
- Designed the dynamic and web compatible pages using the HTML5, CSS3, Gulp, Node JS, JavaScript, AngularJS 2.0, Bootstrap.
- Worked on UI to make the updates for all the state-specific and generic application types present in the project usingASP.NET MVC 5.0, HTML 5 and CSS 3.
- Used OOP’s Concepts and SOLID principles with C #6.0 languages to implement business logic and code behind view models.
- Developed and tested user-friendly navigators by utilizing JavaScript and VB .NET.
- UsingVB.Net in relation and collaboration with object-oriented programming.
- Used Entity Framework Code First approach to implement data access layer, used LINQ to Entities to write Lambda Expressions for data sorting, filtering and projection in various dimensions.
- Created the Controllers and Controller Actions, Filters, Routing, Custom Action Filters using ASP.NET MVC.
- Implemented both MVC architecture and Entity Framework to create automated view models and entity classes.
- Use ASP.NET Web API as the platform for building Restful applications on the .NET Framework.
- Developed Data Access Layer to communicate with SQL Server 2014 using Entity Framework Code First approach and queries being written using LINQ to Entities, worked with performance tuning of Entity Framework too.
- Created and consumed WCF web services .Used Basic Http Binding for binding purposes.
- Leveraged AngularJS 2.0 resources i.e. AngularJS controllers, components, factory, directives and services, routings and events etc. for all data access, encapsulating URLs and standardizing data access interfaces.
- Used Microsoft Excel sheet for the quick import of all the various Application data into the AUS database using C# 6.0.
- Used Jira, Confluence, Slack and Goto Meeting for work assignments, scrum meetings, code reviews, and peer reviews.
- Developed Restful service using web API for communicating with the in-rule service.
- Developed and Enhanced Master Pages, User Controls, Custom Controls, User Interface by using HTML, CSS, Asp.Net Controls, Telerik .NET UI Controls.
- Resolve the UNIX requests or issues for SAP developers.
- Used Code integration, management using Git (Bitbucket) and deployments using Bamboo.
- Performance monitoring and tuning on UNIX systems. Develop step-by-step method using predesigned worksheets to eliminate much of guesswork in performance monitoring and tuning.
- Developed WEB API 2.0 Services to capture important life insurance policy application data from clients to provide an interactive approval process for underwriters.
- Worked on automation of Test cases using XUNIT for unit testing of existing modules.
- Used WPF 4.5 built-in set of data services to bind and manipulate data within the web-application.
- Used TPL (Task Parallel Library) for purpose of scheduling of threads on Thread Pool and state management and worked on Azure.
- Used TFS 2013 for Version Control and Dimensions for deployment of code to SIT and UAT test servers.
- Worked on Electronic Data Interchange (EDI) to get the data from the other location based on X12 standards.
- Looking into the codes of financial series in EDI like 822, 821, 828, 829, etc.
- Written packages to transfer the data between the systems using SQL Server Integration Services (SSIS).
- Implementation of Custom reports by pulling data from various sources and presenting in SQL Server Reporting Services (SSRS).
- Written & optimized T-SQL statements, Views, User Defined Functions, Stored procedures with SQL server database.
- Worked with the different type of UNIX and Linux commands, software troubleshooting and systems installation.
- Provided expertise on Web Content Accessibility Guidelines(WCAG) 2.0 compliance
- Prepared unit test cases and performed N-Unit testing prior to system implementation.
- UsedNHibernateas an object-relational mapper for .Net Framework.
- Used NHibernate to facilitate data access and utilized the ASP.NET AJAX Extensions and toolkit extensively to make the interface rich and interactive.
- Responsible for developing full stack (front-end development, application logic, services, data persistence) as well as server setup and maintenance.
- Developed rich UI for the application usingWindows Presentation Foundation(WPF) and done data binding using one way, two ways and one way to source data binding.
Environment: Net4.0,4.5.1, MS Visual Studio 2017, ASP.Net, VB.net, MVC 5, C# 6.0, Web API 2.0, AJAX, HTML5, CSS3, AngularJS 2.0, Ext JS, JQuery, JavaScript, Bootstrap 3.0, Entity Framework 6.0, Azure, SQL Server 2014,TFS.
Confidential
Software Developer
Responsibilities:
- Involved in Design, Development and Testing of Windows Forms, Web Forms and Web Services using IIS, ASP.NET, C#, XML Dataset and .NET Framework3.0, 3.5.
- Created reports using Crystal Reports
- Used ADO.NET extensively to access the database.
- Developed applications for the provided requirements.
- Perform Unit testing.
- Accomplished cross-Browser compatibility and simplicity through JQuery.
- Client-side JavaScript& DHTML scripts, Unicode support, and server-sideRegular Expressions, for strict input validations.
- Handled SharePoint Administration related tasks like Site Restore, Backup, SSP configuration, SharePoint Installation and Service Application Creation, Deployment of Solutions usingPowerShell.
- Extensively involved in using UML in the design process - Use cases, Process diagrams, Sequence diagrams, Class diagrams. Prepared detailed design document for the application.
- Designed and implemented multiple web services using C#, XML and WCF and consumed them using proxy classes.
- Developed ASP pages using VB on the approved Design Document. Used JavaScript to handle Client-Side validations.
- Suggested various design changes in SQL Server tables and Stored Procedures.
- Used XML and XSL Transformations to display content on the website.
- Developed enterprise n-tier software agent using Windows Communication Foundation (WCF) web service hosted in a Windows service.
- Used CSS and jQuery to create visually appealing User Interfaces.
- Assisted in System Testing and other ad-hoc activities.
- Involved in testing and fixing the issues occurred in the testing process.
- Assisted in developing database objects like Tables, Views, Stored procedures and updating the databases.
Environment: ASP.NET1.1, VB.NET, C#, IIS 5.0, ADO.NET, Visual Studio.NET and XML, XML Web Services, XSL/XSLT, JavaScript, SQL Server 2008, VSTS.