Sql Server Project

Summary of Experience

Over ** years of IT professional working Experience in analysis, object oriented design, development of web based applications using the latest technologies.

Strong expertise in Microsoft .Net 4.0/3.5/3.0/2.0/1.x, C#.Net, ASP.Net, Ajax, Silverlight, ADO.Net, Web Forms, Win Forms, Web Service, Restful Web services, Design Patterns, JQuery, Object oriented design, WPF, MVVM, MVC, T-SQL, SQL Server 2000/2005, Integration Service (SSIS), Reporting Services (SSRS), Crystal Report and Team Foundation Server (TFS).

Extensively worked on ASP.NET, C#, WPF, ADO.NET, Ajax, JavaScript, JQuery, MVC, MVP, MVVM, LINQ, WPF.

Experienced in using Rhino Mock framework, NMock framework, NUnit, MSUnit and Test Driven Development (TDD) to ensure complete test coverage of the code base.

In Depth experience in working with Infragistics 2005/2009/2011/2013, Dundas Charts and Gauges for rich user Interface layer.

Have expertise in Service contract, service implementation, and business logic, leading the migration of applications to production, documentation, participated in the development of department technical procedures and designs user guides.

Expertise in using S.O.L.I.D design principles and several design patterns.

Good Knowledge on Silverlight and Sharepoint.

Experienced in SSIS, SSAS, SSRS and MBI.

Demonstrated ability to complete all phases of the project cycle including research, analysis, requirements gathering, development, design, functionality, maintenance, testing and support.

Hands on experience in Developing Rich User Interface on web using JQuery, Java Script, HTML, DHTML, IIS, Master pages and CSS, HTML5 mark up elements, CSS3, Javascript web API, Modernizr, Jquery UI, Jquery Mobile framework and HTML5 boiler plate.

Experienced in creating reports using Drill-Through Reports, Parameterized Reports, and ad hoc reports using SQL Server Reporting Services 2005/2008 (SSRS). Deployed reports across development, testing and production environments.

Experienced in defining, developing and deploying Cubes using fact, dimension tables, identifying KPI’s and measures using MS SQL Server 2005/2008 Analysis Services (SSAS).

Performed several ETL transformations and data cleansing on data including fuzzy lookup, slowly changing dimension, union all, merge join and check points/break points.

People skills

Results oriented and a proven ability to meet project deadlines and find solutions to challenges.

Very well organized, creative thinker, self-starter and quick learner.

Technical Summary

Web Development

ASP.NET 4.0/3.5-SP1/2.0/1.1, JQuery, AJAX, AJAX Control Toolkit, C#.Net, Silverlight 4, EF4

OOP, Re-Sharper, HTML5, CSS3

NUnit, MSUnit, NMock, Rhino Mocks

MVC, LINQtoSQL, Silverlight, MVC3,MVP, MVVM, S.O.L.I.D Design principles

WCF, WPF, Sharepoint

Visual Studio 2013/12/10/08/05/03/02, SourceSafe, Team Foundation, N Tiers, N Projects

XML, XSLT, Web Services, Application Blocks, ELMAH

ASP3, VB6, VBScript, JavaScript, HTML/DHTML, CSS, Balsamiq

Macromedia Dreamweaver 8

Database Tools

MS SQL Server 2000/05/08, DTS, T-SQL, DTS, SSIS, Entity Framework

SSAS 2005, Data Warehouse, RDBMS, ODBC and ADO.NET

SSRS 2005, Crystal Reports, MBI Reports, Pro-clarity

Environment, Protocol and Fundamental

MS Windows 7/Vista/XP/ME/CE/9X, Windows 2000/XP/03/07 Server

MS Office 2010/2007/2003 (PowerPoint, Outlook, Word, Excel, Visio)

SQL Server Red-Gate, Web Publication, TCP/IP, HTTP/FTP, IIS

Project Management

Primavera Teamplay

Education/Training/Certification

EDUCATION

Masters in Information Technology

TRAINING / CERTIFICATION

HTML5 and CSS3

Project Management

Building fast and adaptable software using Visual Studio and C#

Test Driven Development

Oracle certified

OOPS, Java, ASP, Oracle

Work Experience

Client - ExxonMobil, Fairfax, VA August 2013 - Present

Role – Sr. Developer

Roles

Developed loosely coupled application using WPF with MVVM pattern and object oriented programming to create new application modules.

Designed and developed rich user interface using XAML. Used various WPF controls like DataGrid, CollectionViewSource, StackPanel, DatePicker and other controls.

Leveraged Styles, Animations, Story Boards, Resource files, Data Templates, Control Templates, Data Triggers, Converters to facilitate rich presentation and complex functionality.

Developed REST WCF service to capture application usage, store it on local database and synchronize data with central database when the user is connected online.

Created Web services to pull down new information and plugins/modules on users machines. The base application will connect to the web service to determine if there are any new plugins or new plugin versions and then will synchronize down to update the application.

Used Infragistics WPF reporting controls to create reports.

Refactored code to compliance the coding standards.

Directly worked with Engineers/Leads to understand the core requirements.

Worked in an Agile environment using Proper methodology and concepts.

Environment: VS 2013, .NET Framework 4.0, MVVM, WPF, C#, LINQ, VS 2013 local database, REST WCF Services, OOPS Concepts, TFS, Infragistics WPF 2013.

Client – Carefusion, Reston, VA March – August 2013

Role – Sr. Developer/Lead

Responsibilities:

Developed corporate IOS, Android application prototypes using HTML5, CSS3, JQMobile, Jquery

Involved in creating application framework for mobile applications.

Created ETL packages using Sql Server Data Tools in Visual studio 2012.

Created web services to accommodate corporate web application needs in order to consume by large clients.

Extensively used Model-View-Controller (MVC) Pattern for separating the modeling of the domain.

Extensively used design patterns and S.O.L.I.D design principles and developed highly cohesive/Low coupling code.

Followed Test driven development and created testable, extensible and Maintainable code.

Followed Scrum in Agile methodology to produce high Quality software.

Environment: .NET Framework 4.5, MVC4, C#, Razor Views, Web API, HTML5, CSS3, Rho project, XCode, Test Flight, EF, LINQ, T-SQL, VS 12, SQL Server 2012, OOPS Concepts, Entity Framework, Linq to SQL, Design Patterns, Design Principles, Knockout.js, N Tiers, JQuery, JavaScript, Jquery Mobile, CSS, TFS.

Client - Progressive Insurance, Cleveland, Oh Feb 2005 –Jan 2013

Project - Metadata Manager

Role – Sr. developer/Lead

Metadata Manager Portal contains functionality to allow various teams within the Enterprise Project Management team to maintain information for resources and projects. It gives ability for project managers to maintain resource platform and resource pool Information.

Responsibilities:

Involved in all the phases of the Project Life Cycle and also analysis of the system based on n-tier architecture.

Followed Scrum and Test Driven Development Methods in Agile methodology to produce high Quality software.

Designed and developed metadata manager portal using new cutting edge .Net technology including ASP.NET 4.0, MVC 3, C#, Razor, EF 4, Jquery and LINQ.

Extensively applied the S.O.L.I.D design principles, Object Oriented Analysis and Design (OOAD) concepts, and used design patterns like Repository, Strategy, Command and Model-View-Controller (MVC) architecture framework.

Developed highly cohesive/Low coupling code and created testable, maintainable and extensible application.

Extensively used Model-View-Controller (MVC) Pattern for separating the modeling of the domain.

Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#, ADO.NET Entity Framework and LINQ.

Developed maintainable code by using the OO concepts like Encapsulation, Interfaces and Polymorphism.

Used Inversion of Control (IOC) container to inject objects into a class instead of creating them in the class itself.

Used Repository pattern to provide create read, update and delete (CRUD) methods for entities in the domain model.

Designed Application Exception Handling and Error Logging mechanism for providing the information for tracking down the application code.

Used Data Annotation attributes in MVC for Model validation.

Incorporated many rich, user friendly, responsive features in the application using .Net framework, Jquery, JavaScript and CSS.

Implemented Web pages in.NET 4.0, MVC 3 (VS 2010) with JQuery based UI and using AJAX-JSON post-back method calls.

Used DynaGrid JQuery control to display dynamic data in hierarchical manner.

Used Jquery methods and selectors to provide visual effects.

Created screen mock-up’s using Balsamiq tool.

Created unit tests using RhinoMock framework and MSUnit.

Automated builds by implementing continuous integration.

Created various technical documents for design, Testing and deployment.

Developed ETL jobs in SSIS.

Environment: .NET Framework 4.0, MVC3, C#, Razor Views, EF 4.0, LINQ, T-SQL, Web Services, VS 10, SQL Server 2008, OOPS Concepts, Design Patterns, N Tiers, JQuery, JavaScript, KnockOutJs, CSS, MSUnit, Rhino Mock, TFS.

Project – Staffing Fulfillment Tool

Role – Sr. developer

Designed and developed staffing fulfillment tool. Th is tool Provides visibility into resource utilization and forecasting in an effort to optimize the application of staff and resources to the prioritized portfolios of projects. This tool provides ability to evaluate and match resource skill capacity against project demand for forecasting and planning and to staff resources.

Responsibilities:

Worked as an individual and as a team member. Worked on all stages of full life cycle of web application development. Including Analysis, Architect Design, Layout Design, UI Specification, Application Workflow Design, Database Structure Design, Code Development & Implementation, Deployment and support.

Created web pages and user controls with ASP.Net AJAX Controls, Infragistics controls JQuery controls.

Extensively used Ultrawebgrid, Webdropdown, Webcombo and ExcelExporter, infragistics controls.

Used Rhino Mock framework and Test Driven Development (TDD) to ensure complete test coverage of the code base.

Used Separation of Concerns (SOC) through partial classes and extension methods to enforce re-usability of code.

Used Constructor flavor of Dependency Injection pattern to initialize dependency objects required for mocking methods.

Used Repository pattern to provide create read, update and delete (CRUD) methods for entities in the domain model.

Using strategy pattern, command pattern and S.O.L.I.D principles defined a family of algorithms, encapsulated each one to make them interchangeable.

Used Model-View-Presenter to raise events in the View for requesting data from the Presenter.

Used Jquery Dropdown checklist control to let the user select multiple options from dropdown.

Used JQuery, ASP.NET AJAX toolkit controls and CSS to give better performance and richness to the user interface

Used indexers and anonymous methods to perform specified action on all elements of generic collections.

Created User Stories from high-level business requirements defined in the Change Description Master document.

Modified and enhanced various Queries, Storage Procedure, tables with SQL Server 2005/2008

Extensively use LINQ for retrieving and inserting data in to SQL Server 2005.

Created various technical document for design, Testing, deployment and involved in user training process.

Domain / Industry: Project Management, Auto Insurance

Environment: ASP.NET 3.5, MVP, C#, EF 2.0, LINQ, AJAX, AJAX Toolkit 4.0, VS 08, Web Services, SQL Server 2008, WCF, OOP, OOD, N Tiers, JQuery, JavaScript, CSS, Infragistics 2009/2011, NUnit, MSUnit, NMock, Rhino Mock

Role – Sr. Developer

SSIS

Involved in developing the ETL jobs in SQL Server Integration Services (SSIS).

Responsible for analysis, requirements gathering, documentation of functional/technical

Specifications, data mapping, development and testing.

Wrote complex queries, CTE’s (Common table expressions), stored procedures, functions and views to ensure data integrity, data consistency and to meet the business rules.

Created configuration files, Logging and Error handling using Event Handlers in SSIS.

Performed several transformations and data cleansing on data including fuzzy lookup, slowly changing dimension, union all, merge join and check points/break points.

Responsible for analysis, requirements gathering, documentation of functional/technical

Specifications, data mapping, development and testing.

Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task etc to achieve business needs.

Created data sources and data source views (DSVs), named calculations and named queries calculated members, named sets, KPIs, drill through, report actions and perspectives as per the business requirement.

Created SSIS packages (.dtsx files) using SSIS to validate, extract, transform and load data to data warehouse databases and data mart databases.

Designed, tested (unit testing and integration testing) and implemented stored procedures and triggers for data processing of huge volume of data.

Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.

Used the Team Foundation Server version control tool for project management.

SSAS/SSRS

Experienced in generating several drill-down report using ProClarity.

Created SSIS packages in 2005/2008 and did conversion of DTS packages from 2005 to 2008

Developing OLAP cubes using SSAS 2008 and calculated the metrics that were revealed in the functional analysis.

Created temporary tables and table variables while creating complex queries in SQL Server 2005/2008.

Defined Indexes, Views, Constraints and Triggers to implement business rules.

Developed OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting Services (SSRS), Dashboards.

Built SSRS reports from various heterogeneous sources like SQL Server,

Created cubes and dimensions using SSAS.

Created sourcing, unit test plans, Implementation plans for several packages

Improved performance of package by replacing look ups with Merge Joins

Developed/Monitored ETL packages with different data sources (SQL Server, Flat Files, Excel files, etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Wrote MDX queries and expressions for use in Front End BI Applications

Creating Parameterized Reports, Drill down, Sub-reports using SQL Server Reporting Services 2008.

Created reports from various migrated data sources into simple dashboards for easy reviewing.

Generated of Ad-Hoc reports as per the client requirements using MBI reports and SSRS reports

Project – Dashboard

Designed and developed Dashboard Application. This tool provides IT Managers, Customers & Project Managers key Portfolio and Project metrics to assist them in taking business decisions. This Application provides metrics on all key areas of Project Portfolio Management like Resource Management, Demand Management, Project Management, Financial Management, Process Management and Portfolio Management

Responsibilities:

Responsible for creating web forms using Asp.Net, C#, Ado.Net, SqlServer.

In depth experience using third party controls like Infragistics, Dundas Charts and Gauges.

Used Infragistics control throughout the application for displaying custom grids that contained advanced features such as displaying hierarchical data.

Extensively used Graphical tools Dundas Charts and gauges for displaying several metrics like Resource Metrics, Project Metrics.

Implemented several .net features like State Management, Session Management, Exception Handling, Event handling and Caching.

Used Data Grids, Data Sets, Data Views, Data Adaptors and Data Readers to extract data from Backend.

Created User Controls and Custom Controls in ASP.NET

Implemented OOPS concepts (inheritance, interfaces, properties, delegates and polymorphism) through out the application.

Written JavaScript for User Input Validation, Progress bar control and Pop UP Screens.

Used Cascading Style Sheets (CSS) and DHTML for designing rich user interfaces.

Used JavaScript for client side validations and for dynamically controlling the scroll bar based on the page length.

Involved in design and complete coding of the front end and key functionality.

Created generic class libraries using C# for Interacting with the Database.

Disconnected Record sets are used for application performance boost up.

Developed custom objects to transfer data in between the layers from backend.

Written Complex Queries and stored procedures.

Experience with Sql Server DTS Packages, Scripts for transferring Data between various systems.

Made extensive use of Stored Procedures to provide quick access to data.

Was involved in various design meetings with the end users, project managers and IT Managers.

Used Visual Source Safe integrated with Visual Studio.Net for version Control

Environment:

Windows 2000, C# 1.0, .Net Framework 1.1, Web Forms, Asp .Net, Infragistics 5.1,Dundas Charts 4.5, Dundas Gauges 1.5, Sql Server 2000, Visual Studio. Net 2003, Visual Source Safe, css, HTML, DHTML, JavaScript.

DigtalGroup, Princeton (NJ) June’04 –Jan’05

This Project was developed to maintain a repository of Legal Information services provided by the Companies. It maintains records to support Business Processes such as Annual Invoicing, Pricing and provides reports and Information to the Customers.

Role and Responsibility:

As a team member, developed the application using C#, ASP.NET, XML and Oracle.

Responsible for creating Web Forms using several ASP.NET server controls like Calendar Control, Data Grid control, Data List control. Worked on validation control like Custom Validator, Range Validator.

Created User controls and Custom Controls like Calendar Control, Login Control, Error Box, Information Box, Header Control, Footer control and Image Selector controls.

Involved in creating C# class libraries and projects.

Created Generic and Self contained Interfaces.

Created Business object Layers, which provides the functionality to hide and save and retrieve the Business objects.

Implemented several .NET features like Caching, Trace and State management, Centralized exception handling and Server side event handling.

Involved in writing XML schema and XML files for components.

Written views, functions, stored procedures to perform core lower layer effective transactions.

Provided better Access and performance by Maintaining Sql’s in a Repository.

Followed Singleton Design Patterns in most of Base classes like connection and Sql Repository.

Was very much responsible from design to completion of the application.

Environment:

VisualStudio.Net, MS.Net Framework (Visual C#, VB.Net, Web Forms, ASP.Net, ADO.Net, CSS, JavaScript, XML, XSLT, XMLHTTP, Oracle 9i, Windows XP, Source Offsite(Version control)

Contact this candidate