.Net Sql Server Developer Business Management

CHARMI SHAH

******.*.****@*****.***

Ph: 813-***-****

SUMMARY:

. Over 4 years of work experience and 8 years of technical experience

in Microsoft Technologies like .NET Technologies.

. Worked with .NET Technologies such as C, C++, C#, VB.NET, Win-

Forms, ASP.NET, ADO.NET, IIS, Visual Studio, Windows Services,

MSMQ's, .NET Framework 1.1/2.0/3.5.

. Experience of Java Technologies like Java, J2ee Technologies.

. Experience in Serialization Techniques (Binary, SOAP, XML) with Web

Services and Windows Communication Foundation (WCF).

. Comfortable with client side scripting technologies like

JavaScript, AJAX toolkit, HTML/DHTML, Cascading Style Sheets (CSS),

JQuery.

. Very good understanding of XML, XSD, XPath, XQuery, XSLT with their

validation, transformation and manipulation.

. Good experience of RDMS concepts, SQL Server 2005/2008 and

comfortable using T-SQL, Stored Procedures, Optimizing SQL Queries,

Reporting Services and Crystal Reports.

. Through understanding of Software Development Lifecycle Models

including Requirements Specifications, Design Specifications,

Development, Implementation and Support.

. System level programming on Operating Systems such as UNIX,

FreeBSD, JNachos involved in kernel programming, Shell development,

developed multi-threading model in Nachos and page replacement

algorithms and schedulers for FreeBSD.

. Excellent presentation and communication skills, Team Player, Quick

Lerner, Organized and Self Motivated.

. Enthusiastic to learn new Systems and technologies and fast

adaptability to new platforms and environment.

TECHNICAL SKILLS:

Programming C, C++, C#, VB.NET, Java, UML, Visual Basic 6.0, PL/SQL

Languages

Databases SQL Server 2005/2008, SSRS, SSIS, DTS, MySQL, Oracle

Technologies 9i/10g, TSQL

Web Technologies ASP.NET, ASP 3.0, ADO.NET, Web Services, WCF,

Silverlight, HTML/DHTML, CSS, JavaScript, AJAX,

JQuery, J2EE Technologies

Web Servers IIS 5.0/6.0/7.0, Apache Tomcat, Glassfish

Markup Languages XML, XSD, XSLT, XPath, XQuery, XHTML.

Tools Visual Studio 2003/2005/2008/2010Beta, Team Foundation

Server 2008, XML Spy, NUnit, FxCop, Macromedia Dream

weaver, Net Beans, Eclipse, JN Bridge.

Distributed MSMQ, Windows Services, LINQ,

Computing

Operating Systems Windows 98/XP/Vista/7, Unix, Mac OS, FreeBSD, Nachos

Miscellaneous MS Office 2003/2007, MS Visio, MS Project, Visual

Source Safe, Perforce.

PROFESSIONAL EXPERIENCE

Fiserv Output Solutions, Fiserv, Hartford, CT

January 2010 - Current

Sr. Software Developer

WC3- Clear Vision: WC3 was legacy website for Fiserv developed with

classic ASP and re-designed and re-architected to Clear Vision is the

upgrade on ASP.NET 3.5. This website would be used by Fiserv clients who

can than personalize it according to their needs.

Responsibilities:

. Involved in overall SDLC of WC3CV project which included requirement

gathering from the client, incorporated those requirements into project

architecture design, business analysis, system architecture, data design,

creation of functional, technical specifications documents, test cases,

test plans, operational manuals using agile development process.

. Worked on UI, Business Logic for the middle tier and Database tier for

the entire Systems Admin module for client applications and System Log

module for CV.

. Developed Web Forms using XML, XSD, XSLT, XPath, HTML, ASP.NET server

controls for the WC3CV web site.

. Used CSS, CSS 2.0, JavaScript, JQuery and AJAX for user friendly creative

web forms.

. Performed DOM programming to generate dynamic HTML. Used Nitobi Grids for

customized client specific and/or module specific data view.

. Extensively used LINQ, ADO.NET for data retrievals and created data

access layer using advanced features like Typed Datasets, Object Data

Sources, Entity Framework.

. Highly involved in developing optimized stored procedures, functions and

complex SQL queries using T-SQL triggers and cursors.

. Developed lot of WCF services for the dynamic data retrieval and

integrated with current modules. Created a central repository for

Services management.

. Created test plans for UAT and did unit testing using NUnit and

TestDriven.Net.

. Used BugTracker for bugs and generated various sub-reports, drill-downs,

cross-tab reports, fusion charts, summary reports using ClearVision

Reporting tool.

. Performed presentations, created videos, demos for management, users.

. Used SharePoint 2007 as central storage and collaboration space for

documents, information and ideas.

Environment:

Windows Server 2003, .NET Framework 3.5, Visual Studio 2005/2008, SQL

Server 2005/2008, Fusion Charts, AccuRev, Visual Source Safe 8.0,

EditPlus, IIS 6.0, MOSS 2007, SSRS, Nitobi Ajax Toolkit

vFinance, Boca Raton, FL Nov 2009 -

Dec 2009

ASP.NET Web Developer

National Holdings Corporation is a holding company for National Securities

Corporation, vFinance Investments, Inc., EquityStation, Inc., which are

broker-dealers registered companies. The role for this project was to re-

architect and re-design legacy web application from ASP to ASP.NET giving

them enhanced user friendly graphical user interface and more security for

brokers.

Responsibilities:

. Re-designed and re-developer National Holding Corp Website from ASP to

ASP.NET and SQL Server 2005

. Developed web interface in ASP.NET using .NET 2.0 Framework and VB.NET.

. Used Ajax Toolkit and Jquery Library, CSS, PureCSS to create interactive

and efficient User Interface

. Used VB.NET, Javascript/ VB Script, HTML, DHTML, CSS, PureCSS, SharePoint

2007

. Mostly involved in development for Content Management Provider module.

. Developed Web Based client portal for Stock Holders and Brokers.

. Provided separate modules for Brokers and Employees with Role Based

access rights.

. Used Team Foundation Server for source control.

. Generated reports using SQL Server Reporting Services for end of the

reports for Investors, brokers and client companies - website users.

eClinicalWorks Inc., Westborough, MA

May 2009 - Oct 2009

Software Engineer

The project was to integrate eClinical Works products like Electronic

Medical Records (EMR),

Enterprise Practice Management, Patient Portal, Patient Accounting and

Healthcare Billing,

Healthcare Revenue Cycle, Electronic Health eXchange, Enterprise Business

Optimizer (eBO)

With existing client (MAeHC) applications and data.

Responsibilities:

. Very actively participated in regular project design, updates and team

meetings.

. Designed and developed the client Web Interface in ASP.NET and used C#

and .NET 3.5 framework and also used AJAX, JQuery, and CSS for the Web

UI.

. Used JN Bridge as a bridge to integrate existing eCW product like eEHX,

EMR based on Java platform and client application based on .NET and SQL

platform.

. Integrated eCW's product - Patient Portal with the client data access

layer by developing plug & play components using WCF for exposing

Business Logic as Services.

. Involved in hosting client Web Applications on IIS 6.0 and security

configurations

. Used SQL Server 2005 as the main database and used ADO.NET and LINQ for

easy database interaction with the UI and Business tier.

. Involved in designing of data layer and also wrote bunch of Stored

Procedures, Triggers, used SQL Server Reporting Services to generate

reports and present them into eCW product eBO.

. Performed upgrades, installation of software's, drivers and essential

network troubleshooting. Troubleshooting File Servers, MySQL and SQL

Database Servers, Network Administration, Network Security, Apache Tomcat

- AppServers and Workstations and other related systems. Experience and

skills involves debugging server side JSP files, XML and XSL scripts,

relational databases and server side programming using VB / COM.

. Developed User Manuals and presented various components related to the

module.

. Deep understanding of HIPPA and EDI. Presented HIPAA compliances in

conference with other seminars.

Environment:

Windows Server 2003, Visual Studio 2005/2008, Team Foundation Server, .NET

Framework 2.0/3.5, Microsoft Office, SQL Server 2005, PerfForce, IIS 6.0,

Apache Tomcat 6.0

Syracuse University, Syracuse, NY

Jan 2008 - May 2009

Teaching Assistant

Responsibilities:

. Preparing presentation for conducting classes.

. Conducting help sessions for students for SQL Server and Oracle Server.

. Managing grading and examination documents at confidential level.

. Grading of examinations and feeding reports in the Database.

. Responsible for mentoring and motivating students and planning weekly

plans with the professor.

AIMS International, Baroda, India

April 2007 - July 2007

Software Developer

The objective was to create a overall software development of Online

Research Papers Submission under .NET platforms. A stand alone Windows

based registrations module that will allow Administrators to manage and

maintain scheduling, recording the presence and participation of the

clients in the conference and Paper Presentations. The pupil module allows

registered candidates to view their stats and enroll in particular session

or multiple sessions.

Responsibilities:

. Created (BLL) Business Logic Layer and Presentation layer in ASP.NET.

. Developed Windows Forms and ASP.NET web forms using VB.NET as a code

behind and ADO.NET for database interaction.

. Developed Web based Portal GUI using VB.NET, HTML, DHTML and CSS.

. Implemented password hashing for login pages and email activation for new

registrations.

. Created SSIS Packages to grab data from different servers and also

created Stored Procedures and triggers and SQL Scripts to data cleansing

and also for data validation.

. Used Adobe Photoshop graphical editor for image manipulation and effects.

. Involved in conversion of classic ASP files to ASP.NET using C#.

Sun InfoTech IT Solutions, Baroda, India

June 2006 - March 2007

Software Programmer

The purpose of this project was to implement a system that provides a

central maintenance and availability of replenishment schedule information

required to implement automated system for a Warehouse and stores. This is

the only user interface of a complex system that includes demand planning,

replenishment planning and production planning systems. The system

accomplishes a centralized interface for automated, just in time

replenishment making a direct link between products source of supply and

its final destination.

Responsibilities:

. Designed and coded UI using Microsoft ASP.NET 2.0 and Data access layers

and Web Access layers were developed in C# .NET.

. Developed SQL Server Queries, Stored Procedures and Triggers.

. Developed .asmx and asmx.cs web service files for data access.

. Developed and maintained Reports using SQL Server Reporting Service.

. Worked with ASP.NET Web Forms, ASP.NET State Management and ASP.NET

Caching Features.

Digital 2 Virtual Pvt. Ltd, Baroda, India

Dec 2005 - May 2006

Fulltime Software Intern

Pharmaceutical Business Monitoring System using J2ee Technologies like JSP,

Servelets and JavaBeans and Oracle 9i on the back end. A management level

module of ERP was developed which reduces the manual insertion providing

easy reviewing of the Business Data by presenting it in text and graphical

reports.

TECHNICAL PROJECTS:

. Clamshell: Implemented a command interpreter for korn-shell-like commands

in C using Yacc and Lex running under FreeBSD. Shell accepts the standard

input and files from command lines, parses them and executes the command.

The core of the shell consists of pipes, background jobs, I/O

redirection, shell variables, simple aliases, tilde expansion, pathname

searching and very elementary job control and filename completion.

. Small Business Data Management System (DMS): Designed and Developed web-

based DMS system for a Software development company to automate their

business process.

. Call Dependency Graph: Visual C++

Developed a template- based set of classes to represent graph data

structures and calling dependency structures to represent the strong

component that is mutual dependency relationships between more than two

calls, due to recursion in any graph.

. Remote Data Structures : Visual C++

Transmission process of STL- based containers between remote machines.

This process consists

Of serializing the source data structure into a sequence of messages,

transmitting those across the

Network and de-serializing into the target data structure.

. Profiler Framework: Visual C++ Developed extensible framework for

profiling of C++ source code that analyses the code for functions timing,

code coverage and history of parameter values at invocations.

. Remote UML Diagrammer: C#, Socket Programming.

Whiteboard tool that collaborates on UML diagrams with remote client and

server and allows the remote listeners clients to view sharing and

updates activities on collaborating clients.

. Chit Chat (Chat Server): VB.NET Chat application for users to send and

receive messages between more than two computers and developed video

conferencing as email facility.

EDUCATION:

Master of Science (MS), Computer Science

August 2007- May 2009

Syracuse University, Syracuse, New York

Bachelor of Engineering (BS), Information Technology

June 2002 - June 2006

Gujarat University, India (with distinction)

Contact this candidate