Sql Server Management

Jayesh Patel

**** ******** ******,

North Andover, MA 01845

978-***-**** (C)

978-***-**** (H)

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

SUMMARY:

Over twenty years experience in software architecture, design, analysis, project implementation, testing, installation and maintenance. Enterprise experience in Microsoft SQL Server including implementation, performance optimization, high transaction and availability. Ability to motivate and manage development teams on delivering high quality products within budget and utilizing the latest in technological advancements. Outstanding communication skills and ability to simplify complex business processes and to transfer the business knowledge into simplified software solutions.

OBJECTIVE:

Seeking a software department/development lead position utilizing my advanced skillset and excellent management experience. As a hands-on leader, looking to contribute at multiple levels within an organization that will allow the freedom to innovate and to expand my current expertise in an enterprise system development.

APPLICATION AND SOFTWARE KNOWLEDGE:

Database: SQL Server 2012/2008/2005/2000, Oracle V7.X, MySQL and V8.x, Web Database Application

Document Management: Documentum Document Management, Document Imaging and Workflow.

Workflow: UNIX Eastman OPEN Workflow 2.X and NT Eastman OPEN/Workflow 3.X

Imaging: Eastman: OPEN/image, OPEN/COLD, Xionics and Kofax imaging APIs and Kofax Ascent Scan subsystem

Languages: C#, VB.NET, VB Script, HTML, XML, CSS, MS VS.NET 2003/2005/2008/ 2010

Protocols/Modules/Technologies: SaaS, .NET, WCF, Web Services, SOAP, REST, HTTP, HTTPS, AJAX

Operating Systems: Windows 7/XP/NT/2000, 95/98, DOS 6.22

GUI/SDK: Windows 3.11, Windows 95, Windows NT, Windows XP, Window 7.0, Visual Basic 6.0/5.0/4.0

System Expertise: Windows (95/98/NT/2000/2003), Optical sub-systems, PC Workgroups

Methodologies: Understanding of Software Development Life Cycle using Agile & Waterfall models; Project Management, Business Process Analysis, Object Oriented Design and Development, Service Oriented Architecture (SOA), Unit and Load Testing

Certified Scrum Master

EXPERIENCE:

Technical Lead

Measured Progress Dover, NH October 2010 – Present

Rearchitect and redesigned the iScore application and databases using the latest .NET/C# architecture and Microsoft SQL Server 2008. System is a SaaS implementation with high transactional capability and ultra-high availability. Develop ETL process to import data from various source.

Designed and managed BAS Scoring & Managed Manual Entry Projects utilizing an outsourced team. Responsible for overall architecture, project management, implementation and on-time delivery. Team consists of several senior developers based in Costa Rica and Peru as well as a team of engineers in Dover, NH.

Developed a MSMQ driven notification application to process XML data from numerous varied sources. Technologies used consisted of C#/.NET and REST services.

Agile methodologies drive the team focus while using tools like Jira for use case development and defect tracking.

Also worked with Federal Government agencies (GSA, Department of Energy) in business development projects.

Principal Software Engineer

SoluSoft Inc. North Andover, MA Sept. 1995 – Sept. 2010

Worked on iScore project (scoring, system administration, QAC application) developed in Visual Basic 6.0 and Microsoft SQL Server 6.5.

Designed and developed DocMgr Database for iScore application. This application stores pointers for images for online display.

Upgraded iScore application to internet base application using Microsoft Visual Interdev and Microsoft SQL Server 2000.

Redesigned iScore application and databases to internet base application using Microsoft Visual Studio .NET 2003 and Microsoft SQL Server 2000.

Managed iScore redesign development team.

Upgraded iScore application databases from to MS SQL 7.0 to MS SQL 2005 and added benchmarking functionality.

Managed iScore production environment and export data to various groups.

Managed deployment of DELTEK time capture system to all temporary employees of Measured Progress for several departments and scoring sites.

Database development work for on Scan Edit and KFI application for Measured Progress.

Developed TRF and TRUS system for Measured Progress.

Designed and developed iScore report application for real time data analysis.

In-depth knowledge of K-12 education scoring process.

Worked on databases enhancement for KRONOS PEYCHINEY, HAWAII and TSA project.

Designed and developed:

oMPEG Video Delivery System for horse races.

oNirvana Document Management System for Enterprise Knowledge Management.

oAccounts payable application for Lockheed Martin using Oracle database and Eastman Software Work Flow software.

oNirvana ISO 9000 (document management system).

oDevelop ETL Bridge for iAnalyze system.

EDUCATION:

Boston University, Boston, MA

Graduate-level classes completed in: Advanced Database and Object Oriented Design, Software Systems Design.

University of Massachusetts, N. Dartmouth, MA, May 1992

Bachelor of Science in Electrical and Computer Engineering

References provided upon request

Contact this candidate