Post Job Free

Resume

Sign in

Sql Server Project

Location:
San Diego, CA
Posted:
October 10, 2013

Contact this candidate

Resume:

KARISHMA DHANANI

San Diego, California *****

858-***-****

ab93km@r.postjobfree.com

OBJECTIVE:

To pursue a high challenging career as a Professional, where I can apply my knowledge, acquire new skill and contribute

to organization.

PROFESSIONAL SUMMARY:

5+ years of IT experience in Analysis, Design, Development, Testing, Implementation and Maintenance of N-

Tire Enterprise Applications in Web, Window Forms, and Client/Server Environment.

Extensively worked with all the Phases of Software Development Life Cycle (SDLC). Familiar with Agile

Methodologies (Extreme Programming, Scrum), Waterfall Methodologies, Test-Driven Development (TDD), and

Design Patterns.

Expertise in developing applications using Microsoft technologies such as .NET Framework 3.5/3.0/2.0, Web

applications using ASP.NET, Win Forms using Microsoft Visual C#.NET and VB.NET, Visual Basic 6 .

Database access using ADO.NET and distributed applications using WCF, XML Web Services and Messaging

system.

Developed reports extensively using MS SQL Server Reporting Services (SSRS) and Crystal Reports 8.0.

Experienced in developing SQL Server Integration Services (SSIS) as well.

Extensive experience in web-based page and site designs using HTML, HTML5, XHTML, DHTML, CSS, CSS3,

Themes, Master Pages, Site Map, JavaScript, jQuery and AJAX.

JavaScript client side validations were done for ASP.NET W eb Applications.

Experience with Data Accessing including using Data Adapter, Data Reader and Dataset in ADO.NET and

Language Integrated Query (LINQ) Providers for data manipulation.

Experience in developing stored procedures, triggers using SQL and T-SQL in relational databases such as My

SQL and SQL Server 2005/2008/2012.

Experience in Object Oriented Analysis and Design methodology with strong knowledge and experience in

Structural, Creational and Behavioral Patterns like Model viewer controller (MVC2/MVC3/MVC4).

Experienced in creating corresponding Unit Test Suite f or applications at various modules.

EDUCATION:

Bachelor of Technology in Electronics and Telecommunication, Santh Gadge Baba Amravati University, INDIA

TECHINCAL SKILLS:

.Net Framework 4.0/3.5/3.0, ASP.NET 3.5/3.0/2.0, MVC 3.0,MVC 4.0, Visual Basic 6,

. NET Technologies

ADO.NET, LINQ, Entity Framework, .Net Web Services, WPF(Window Presentation

Foundation), CSS, CSS3, AJAX.

Development Tools Visual Studio 2010, Microsoft SQL SERVER Management studio 2005/2008, Business

Intelligent Development Studio, SVN, Visual Studio Team Foundation Server(TFS).

C#.Net, SQL, Jquery, T - SQL, HTML,HTML5, PHP.

Programming Languages

Java Script, VB Script,

Scripting Languages

SQL SEVER 2008/2012, MySQL.

Relational Databases

SQL Server Integration Services (SSIS), SQL Reporting Services (SSRS), Crystal Reports.

Reporting Services/ETL

Packages

Windows 7 Enterprise, Windows Server 2000/2003, XP.

Operating Systems

Other Tools Microsoft Office 2010, Fiddler, XML, Notepad++, FileZilla 3.6.

PROFESSIONAL EXPERIENCE:

Client: Nasco (National Accounts Service Company), Atlanta, GA December 2011 – August 2013

Project Name: Capitation Role: Analysis, Design & Development

Description: The project involves the functionality to calculate the total capitation amount to be paid to the doctor by an

insurance company as a part of the health Policy of the person. Capitation is a method of paying health care service

providers a set amount for each enrolled person assigned to that physician or group of physicians, whether or not that

person seeks care, per period of time. NASCO’s existing solution offering in support of capitation processing is not robust

enough to adequately address the needs of the Horizon and Massachusetts Groups planned for migration in 2013-2014.

The current functionality was designed in the early 1990’s and is limited to supporting member selection of a PCP and

the ability to process encounters. It does not support the ability to define a capitation contract or the ability to calculate

a capitation payment within a capitation payment cycle. To meet the business requirements of Plans with Groups

currently processing capitates claims on Local systems, NASCO has made the decision to enhance its current capitation

solution to allow for full migration to the NPS platform.

Roles and Responsibilities:

• Employed Agile Process(Scrum Methodology) and TTD(Test Driven Approach) for Incremental build and

Continuous Integration of Independent Modules to Meet Tight Dead Lines and Dynamically Changing

Requirements

• Involved in designing Rich UI using Telerik, Expression Blend developing Presentation logic using C# and View

Models using MVC design pattern

• Developed Data Transfer Objects (DTO) in C# for business entities

• Customized the look and feel of the Rich Interactive User Interface using Data Templates, Control Templates,

Styles, and Resources using Visual Studio 2010.

• Created Styles with Control Templates for all the controls at Various Levels to Maintain Consistency &

Uniformity across the Applications.

• Created Custom Controls, User Controls with Content Control, C#,VS2008 and Dependency Properties and

Involved in Usability Testing with End Users, BA’s and QA Architect

• Implemented Data Validation Rules and Exception validation Rules in UI and Validation Process using C#

• Developed with Entity Framework, T4 templates, Business Entities and exposed DataContext using C#, Visual

Studio.NET2010.

• Involved in Unit and Integration Testing, Production Migration and Support

• Responsible for writing Complex Queries, Stored Procedures, and Triggers using SQL Server 2008.

• Created SSIS packages for Extraction, Transformation and Loading operations.

• Fixed Bugs created By QA and created Functional Tests and Unit Tests to reproduce the scenario and document

such edge cases

• Have written Technical documentation for all the use cases implemented.

Environment: .NET 3.0, VS.NET2010, Entity Framework, LINQ, C#, ASP.NET,CSS, IIS7, XML, JavaScript, JQuery, Windows

7 Enterprise, MS Unit Testing Framework, MVC3.0, MVC4.0, Telerik Control, SSRS, SSIS, TFS.

Client: Nasco (National Accounts Service Company), Atlanta, GA Jan 2011 – November 2011

Project Name: MedEFT Role: Analysis, Design & Programming

Description: HEALTHPLANS presently employ an automated process for generating paper checks and paper vouchers for

payment of claims. Each week the finalized claims are sent to check printing processes where the checks and vouchers

are printed and mailed. Each year HEALTHPLANS spends approximately $3 million printing and mailing checks and

vouchers for providers. The objective of this project is to reduce the cost of distributing payments by implementing an

electronic distribution of the payment and voucher. Payments are to be distributed via Electronic Funds Transfer (EFT)

and the eVouchers (Electronic Remittance Advice – ERA) will be made available through the Provider Portal.

The scope of project is focused on implementing the EFT/ERA capability for Providers registered with the Health Plan.

Roles and Responsibilities:

• Involved in Understanding the Requirements with HTML mockups, Business Analyst and Business Team

• Involved in Developing Rich Interactive GUI using Telerik User Controls, .NET 3.5, Visual Studio 2008, C#, XML.

Implemented client side data validation using JQuery and created custom class.

• Involved in bug fixes and change requirements in UAT and Production Environments

• Employed LINQ to XML to read from setting for the application from XML file using LINQ

• Developed Unit Test for View Models and used Mock framework to implement UnitTests for MVC Controllers.

• Developed with Entity Framework, T4 templates, Business Entities and exposed DataContext using C#, Visual

Studio.NET2010.

• Involved in Unit and Integration Testing, Production Migration and Support

• Responsible for writing Complex Queries, Stored Procedures, and Triggers using SQL Server 2008.

• Created SSIS packages for Extraction, Transformation and Loading operations.

• Have written Technical documentation for all the use cases implemented

Environment: .NET 3.0, VS.NET2010, Entity Framework, LINQ, C#, ASP.NET 3.5, JavaScript, JQuery, Ajax, IIS7, XML,CSS3,

Windows 7 Enterprise, MS Unit Testing Framework, MVC 3.0, MVC 4.0, Telerik Control, SSRS, SSIS, TFS.

Client: Haye Capital Group Financial Services, USA. April 2010 – Jan 2011

Project Name: Stock Trading in Real Time using quotes from Yahoo and Quote Tracker.

Role: Analysis, Design & Programming

Description: Software as a service system (SaaS) for Haye Capital clients and Users to monitor quotes for stock tickers in

Real time on web and take trading decisions from NYSE. Stock Quotes trends for specify symbols for which users have

subscribed to and allow trading for that symbol based on the volume and price at any Particular time during the trading

window.

Functionality: System constituted two areas:

Admin Area: Controller of the system that is the admin who can create users and allocate specific Symbols for them.

Editing and Deletion of the users of the system can also be done but only by the administrator of the website admin can

view the stock Quotes of all the Symbols the users have subscribed to.

User Area: Users of the system can login to the system to view the stock quotes for the symbols they have subscribed

to. Trends and Historical prices for their symbols can be viewed as well as Trades can be done for the trends of the

symbols which the user currently selected.

Trades values are calculated depending on the holding period as well as the search period.

Roles and Responsibilities:

• Involved in Developing Rich Interactive GUI using Asp.NET 3.5, Visual Studio 2008, Microsoft Expression

Blend/Designer, C#, HTML, Java Script.

• Created Several Reusable User Controls and Custom Controls using Microsoft Expression Blend/Designer, XAML,

Themes, C#, and Customized Controls using Data Templates, Events, and Control Templates

• Extensively used C#.Net 2.0 to develop business components.

• Developed Various Static and Dynamic Charts using Chart FX Controls for 3D Data Visualization with

C#,XAML,VS2008,Blend and Data Binding implemented in C# using Generic Lists and Observable Collections

• Implemented Data Binding using Data Context, Object Providers and Implemented Business Logic using Class

Library with C# Custom Business Entities

• Used jQuery to create impulsive animations and user interactivity using unobtrusive scripts

• Deployed Application on Staging and Testing Servers on IIS/Windows Server 2003.

Environment: ASP.net, C #, SQL Server Express Edition, Ajax, QTracker Web Services, JavaScript, HTML,CSS,XML, MVC,

Telerik Control, SSRS, SSIS, TFS.

Client: Nasser Entertainment, Los Angeles, CA Aug 2008 – March 2010

Project Name: Nasser Entertainment corporate site Role: Analysis, Design & Programming

Description: Nasser Entertainment is a film and television production and development studio. The corporate site is

designed in two levels Administrator and User. Administer is responsible for adding the various types of master entries

like details about the project(film or television show), trailers, gallery images, videos, news and press events etc. and

user can view all the details about the project.

Roles and Responsibilities:

• Involved in Developing Rich Interactive GUI using Asp.NET 3.5, Visual Studio 2008, Microsoft Expression

Blend/Designer, C#, HTML, Java Script.

• Created Several Reusable User Controls and Custom Controls using Microsoft Expression Blend/Designer, XAML,

Themes, C#, and Customized Controls using Data Templates, Events, and Control Templates

• Extensively used C#.Net 2.0 to develop business components.

• Developed Various Static and Dynamic Charts using Chart FX Controls for 3D Data Visualization with

C#,XAML,VS2008,Blend and Data Binding implemented in C# using Generic Lists and Observable Collections

• Implemented Data Binding using Data Context, Object Providers and Implemented Business Logic using

Silverlight Class Library with C# Custom Business Entities

• Used Jquery to create impulsive animations and user interactivity using unobtrusive scripts

• Deployed Application on Staging and Testing Servers on IIS/Windows Server 2003

Environment: ASP.Net, C#.net, SQL Server 2005, ASP.net MVC3, SSRS,SSIS, IIS 6.0. Flash, C#,HTML, JavaScript, AJAX,

XML,Windows XP/Windows 2003, Visual Source Safe 6.0, MS Office.



Contact this candidate