Sql Server Project
Resume:
KARISHMA DHANANI
San Diego, California *****
*******.*********@*****.***
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