.Net Sql Server Business Project Experience Engineer

HARSH MEHTA, MBA(IT),**** Maristone Ct. Cumming GA 30040 ( 678-***-**** *

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

Highly motivated and results-driven individual, with over 9 years

accomplished experience, emphasizing in both service and product businesses

with life cycle implementations for a wide variety of industries. Masters

of Business Administration (MBA) with specialization in Information

Technology uniquely combines project management skills and IT/systems

analysis skills to be able to achieve exceptional results. Strong record

in maximizing efficiency and revenue/profitability and independently

driving project success. Detail-oriented and organized leader, with strong

interpersonal, collaboration, and problem-solving skills as well as

excellent communication and presentation skills, proven ability to work on

numerous projects and activities simultaneously.

Technical Skills

Operating System Win NT/2000/2003/XP Server, Windows 7 (64 bit), MVS, Virtual

Machines

Languages .NET Framework 3.5, ASP.NET 2.0, VB.NET, C# 3.0, JAVA, VBA,

HTML, XML, XSL, Web Services, WSDL, SOAP, ADO.Net, .Net

Remoting, AJAX, Jscript, VB Script, Silverlight 2.0, MOSS

Web tools MS Visual Studio 2008/2005/2003, Visual Studio 6.0,

Macromedia Flash, Sheridan Grids, MQ Series, Sheridan

Controls, Share Point 2007, Adobe Air

Concepts .Net Framework 3.5/3.0/2.0, Object Oriented and Structured

methodologies, ER Diagrams, Data Flow Diagrams, Data

Modeling, Web Services, Windows Services, COM+, SOAP, Agile &

RUP Methodology, WPF, WCF, Entity Framework, Nunit, FxCop,

Ncover.

Software IIS 6.0, Visual Source Safe (VSS), Sub version, MS Office

Suite, MS Project 2007, Erwin 7.0, Visio 2007, Telerik user

controls, Infragistic user controls.

Reporting Tools Crystal Reports 4.5/7.0/8.0, 10, .net, Reports 6i, SQL Server

reporting services (SSRS), SSIS

Database SQL Server 2008/2005/2000/7.0, Oracle 9i, MS Access

Core Competencies

System Implementation Process Improvement Web Architecture &

Administration

Business Analysis & Information Design Quality & Financial

Development Management

Leadership & Teambuilding Customer Relations Web Project Analysis & Design

Education

University of Gujarat, India

. Masters of Business Administration (MBA) in Information Technology :

June, 2000

. Bachelor of Business Administration(BBA) : June, 1998

. Diploma of Computer Application (DCA): May, 1998

National Institute of Information Technology (NIIT)

. Network Centric Computer Programming (NCCP) October, 2000

Work Authorization

. Authorized to work for any employer in USA (Green Card).

Selected Career Highlights

. More than 9 years' of experience in a Lead System / Analysis role of

responsibility.

. 5 Years' of experience in designing and developing enterprise

application as well as web applications using .Net architecture

technologies such as C#, Visual Basic.net and ASP.net using Visual

Studio 2008 / 2005/2008.

. 4 years' of designing and developing experience of enterprise level web

application using Visual Basic 6.0, VBA, ASP and Visual Interdev.

. More than 5 years' of experience proficiently combining technical and

financial expertise with technical proficiency in a systems analyst role

of responsibility

. Extensive Experience in leading the architecture and development of

cutting - edge Enterprise Applications in ASP.NET, Windows Forms, and

Windows Services since .NET inception in 2000.

. Expertise in Microsoft Technologies like WCF, WPF, WF, WMI, C#.Net 3.5,

VB.Net, ASP.Net 3.5, ADO.Net, XML Web Services, AJAX, Visual Basic 6.0,

T-SQL, SQL Server 2008/2005/2000, Crystal Reports

. Best expertise in ASP.NET/ASP.NET 3.0, C#/VB.NET, .NET Framework, SQL

Server (T-SQL, Stored Proc, DTS), Share Point 2007, UML, usability.

. Proficiency in creating web based real time application using ASP,

ASP.NET, ActiveX control, web services, UI Silverlight, XHTML,

Flash/Flex, HTML, XML/XSLT

. Fluent in Database design and Database handling with broad experience of

working with various databases like Oracle 7.0 / 8i / 9i, SQL Server

2008 / 2005, MS-Access 97 / 2000 used with different front-end user

interfaces.

. Strong control over designing and developing backend functionality in

SQL Server 7.0 / 2000 / 2003 / 2005 with development experience of

Inserts, stored procedures, triggers, DDL statements and DML statements.

. In depth experience of working with ORM tools to generate database

project code through Entity framework, nHybernate tools.

. Expertise in designing and developing Reports in Crystal Report and SSRS

using various data sources like ORACLE (PL-SQL), SQL SERVER (T-SQL).

. Fluent in a broad range of technologies, including system analysis tools

such as Microsoft Project, Excel, Access; technical assessment tools

such as IIS, MS-Visio, Data Modeling, SOAP and COM+.

. In-depth experience with design of database applications and with Full

Life Cycle (SDLC) implementing processes as well developing commercial

applications.

. Demonstrated attention to detail, creativity, with excellent time

management, team development and organizational skills and excellent

mathematics background.

. Strong troubleshooting and problem solving skills, Self-motivated,

cooperative, self-starter and interpersonal skills. Highly organized,

methodical and able to deliver quality work on time.

. Exceptional ability to build productive relationships with colleagues,

clients, and vendors across all functional and technical disciplines,

providing focused project management, and accurate and detailed system

analyses.

Work History

Technical consultant Oct, 2009 -

till date

Jackson Healthcare, Alpharetta, GA

. Envisioned and built front-end for the site written in ASP.NET, MS Visual

Studio 2008, .NET 3.5 / 3.0, C#, VB.NET, XML, HTML, DHTML, JavaScript,

Windows XP / Vista, WMI, Agile Scrum Methodology using Rally development

tools.

. Created Entity framework projects to generate data layer between

application domain and data domain.

. Designed and developed UI following design patterns MVP to support

business requirement along with CSS and XSLT.

. Continuous Integration, Rich Internet Applications, MS Build automation

using cruise control, Unit Testing using Nunit, Code Generation nHydrate,

Entity Database.

. Extensively used third party user controls like radgrid, radSchedular

through Telerik to build web application.

Accomplishments:

V Successfully designed and developed web based application to implement

credit card processing gateway.

V Helped in formulating the business case for the site, individually

designed the logical and physical structure of the Aurora web project.

V Followed Agile scrum methodology for software development by breaking

down tasks in small parts and working on them regressively.

Technical consultant July, 2009 - September, 2009

Pipeline Data Processing Inc, Alpharetta, GA

. Performed business and system analysis, designed application and database

structure, converted existing data into SQL Server using Data

Transformation Services (DTS) and VBScript

. Envisioned and built front-end for the site written in ASP.NET, MS Visual

Studio 2008, .NET 3.5 / 3.0, C#, VB.NET, XML, VBA, VBScript, JAVA,

Share Point 2007, HTML, DHTML, JavaScript, Windows XP / Vista, WMI, Agile

Scrum Methodology.

. Created sophisticated SQL Server database to responsively handle complex

queries (T-SQL, DTS, triggers, stored procedures, functions,

optimization) and .NET data access components

. Continuous Integration, Rich Internet Applications, MS Build automation,

Unit Testing, Code Generation

. Provided integration points via SOA based WCF/Web Services (WMI)

assurance services modules.

Accomplishments:

V Successfully designed and developed web based application to implement

credit card processing gateway.

V Helped in formulating the business case for the site, individually

designed the logical and physical structure of the Aurora web project.

V MS SQL Server 2005 Data Architecture, Data Modeling, Stored Procedure

Design

Technical Lead June, 2005 - February, 2009

Scientific Games International Alpharetta, GA

. Performed business and system analysis, designed application and database

structure, converted existing data into SQL Server using Data

Transformation Services (DTS) and VBScript

. Envisioned and built front-end for RIA written in Windows xp/Vista,

ASP.NET, MS Visual Studio 2005, .NET 3.0 / 2.0, C#, VB.NET, XML,

VBScript, JAVA, Adobe Air & Flex, Share Point 2007, HTML, DHTML,

JavaScript, UI Silverlight, XAML, FLASH/FLEX, Agile Scrum

. Created sophisticated SQL Server database to responsively handle complex

queries (T-SQL, DTS, triggers, stored procedures, functions,

optimization) and .NET data access components

. Implemented business logic as .NET Framework assemblies (C#, VB.NET)

. Develop the customized Web Part, SQL Server Reporting Services report

(SSRS) and InfoPath reports for implement / deploy to SharePoint portal.

Accomplishments:

V Successfully developed and instituted software on time with least number

of product defects.

V Led the development team of five programmer / analysts and one quality

assurance specialists

V Helped in formulating the business case for the site, individually

designed the logical and physical structure of the Games Management

System (GMS)

V Involved with usability testing including serving as the main point of

contact for an external usability consultant, identifying aspects of

the design to be tested, reviewing the proposed scripts, and

accompanying product managers on customer site visits.

V Consistently recognized for successful delivery of projects

Sr. Software Engineer November 2003 - May, 2005

Blue Cross Blue Shield of GA Atlanta, GA

. Functioned as key member of the consulting team in the design and

development of a web-based real time application to allow large group

insurance access.

. Developed web services and user interfaces for various business

solutions using C#, ASP.NET and VB.NET along with that Marshalling and

protocol framework for components accessed via SOAP.

. Developing the data integration process between Oracle and Mainframe DB.

Process was developed using JAVA, XML, XSL, and Oracle PL-SQL.

. Implemented business logic as .NET Framework assemblies (C#, VB.NET)

Accomplishments:

V Successfully developed and instituted a software on time with least

number of product defects.

V Led integration efforts between Employer Access legacy system to web

portal.

V Defined System requirement for processing live insurance claims

request and changes to group insurance policy and validation.

V Reduced defects in development builds by over 95%, completed

outstanding change requests and cleared all blocking issues in 4

month period

Sr. Software Engineer August 2003 - November, 2003

Associated Machine Company Miami, FL

. Performed an architectural review of a win forms client-server

application written in Visual Basic.NET migrated from Visual Basic

version 6.0

. Developed more than 100 customized reports using Crystal Report as

reporting tool and SQL Server 2000 T-SQL. Reports such as Region wise /

marketing person wise / Party wise sales and receivable analysis, daily

production schedule management, machine / process wise load analysis.

. Created both GUI and Server side data transformation layer using XML and

XSL for customized user interface as well as added number of messaging

formats for data transformation to other environment.

Accomplishments:

V Reengineered existing processes for managing software requirements,

created systems models, and developed project documentation suite.

V Created project documentation suite, designed logical data model and

implemented relational database (SQL, ODBC), developed and

implemented internationalization strategies (ASP.NET, C#), and

developed and executed test scenarios.

Software Developer / Analyst January, 2002 - August,

2003

Shilp Gravures Limited, India

Software Developer May 2000 - January, 2002

Arihant Stock Brokers, India

Contact this candidate