Manager Sql Server

Sanjay Chouhan, (PMP)

Technical Manager (Data Services) at Farragut Systems

1.

Employer Farragut Systems 2775 Meridian Pkwy Durham NC 27713

Email *************@*****.***

2.

Phone 919-***-****

Background

Summary

A proactive, performance-driven, conceptually strong individual having 13+ years of IT industry experience. Strong

emphasis on SQL Server 2005/2008/2012 Database Design, Development and Administration for web based and

client/server applications, from last 10 years. Strong analytical and solution oriented problem-solving skills with

attention to quality and improvement.

Visa Status - Green Card Holder

TECHNICAL SKILLS

• Database: Microsoft SQL Server 2005-2012, T- SQL, SSIS (SQL Server Integration Services), SQL Server Reporting

Services (SSRS), Oracle 8i, PL/SQL.

• Development Platforms: Microsoft Visual Studio .Net C#, Visual Basic for Applications, Visual Studio 2003 - 2010,

HTML, ASP, Crystal Reports, XML, VB Script and Java Script

• Applications: Microsoft Office; Visio; Subversion; Visual SourceSafe, Microsoft Project 2007-2010

• Project Management Professional (PMP), Project Management Institute (PMI), Active from August 2011.

• Using agile methodology for project development

MAJOR ACCOMPLISHMENTS

• Completed end to end implementation and data migration for NCPTS product in 12 North Carolina counties. The

NCACC Collaborative Property Tax System (NCPTS) is a web-based ERP application which consists of following

modules: Assessment, Billing, Collections, Enforced Collection and Land Records for Counties and Cities. This

application supports integration with critical applications including Register of Deeds, Planning, GIS, and Finance.

• Played role of technical manager (database) for a project with NCDOT and NCDOR to combine vehicle taxes and

vehicle tag fees (Tax and Tag system) into one combined notice for all 100 counties in North Carolina. Designed core

system and six integration points between NCDOT and Vehicle tax system.

• Designed and Implemented data collection process for receiving 3 years of Vehicle tax data from 100 North Carolina

Counties and load it in the state-wide Vehicle tax system.

Experience

Technical Manager (Data Services)

Farragut Systems

January 2009 – Present (6 years) Durham North Carolina

Currently responsible for managing multiple data migration for NCPTS implementation and product customizations to

meet customer requirements, validating migrated data and software integration with external third party systems.

Diagnosing and resolving database and query performance issues. Assist operational DBAs whenever needed.

- Managing project team of 10 personnel to perform various data migration activities for NCPTS

- Performing Data mapping between County legacy databases and NCPTS SQL Server database.

- Designing data migration processes using SSIS (SQL Server Integration Services).

- Managing data imports & restores for successful data migration.

- Reviewing and analyzing execution plans for optimizing SQL Server query performance.

- Developing process for reconciling financial data between legacy system and NCPTS.

- Technical skills utilized: SQL Server 2008 – 2012, SSIS, SSRS, C# .NET

Technical Manager (Database)

Farragut Systems

July 2012 – October 2013 (1 year 4 months) Durham, North Carolina

Worked with NCDOT and NCDOR staff to determine and implement North Carolina Vehicle Tax System. North

Carolina’s vehicle Tax System was designed to integrate with DMV STARS system to collect vehicle property taxes

along with registration renewals and to conveniently pay them together.

- Designed and defined data model for collecting data from North Carolina Counties, for statewide Vehicle tax system

and NCPTS implementations.

- Designed and developed data migration process using SSIS (SQL Server Integration Services).

- Designed process and writing T-SQL scripts for validating and reporting errors for data provided by NC Counties

- Collected requirements and implemented data import and export with the DMV STARS system

- Managed and designed core application and configurations for application.

- Managed project team personnel to design, develop, test, and deploy NCVTS to all 100 counties

- Completed 3 cycles of user acceptance testing with over 90% pass

- Technical skills utilized: SQL Server 2012, SSIS, SSRS, C# .NET

Senior Member of Technical Staff

Farragut Systems

April 2006 – December 2008 (2 years 9 months) Durham North Carolina

Developed new version of NCPTS using C# and.Net framework and SQL Server. NCPTS is a comprehensive, tax

system that is designed to enhance the effectiveness of a county while providing better service to its citizens.

- Performed Data mapping between County legacy database and NCPTS SQL Server database.

- Data Migration from legacy to NCPTS database using T-SQL stored procedures and T-SQL scripts.

- Development of complex batch processes using SQL Server stored procedures.

- Created views to facilitate easy user interface implementation, and triggers for change history.

- Created indexed views in T-SQL to increase the query performance.

- Created reports using SSRS (SQL Server Reporting services).

- Trouble shooting performance problems by using SQL server profiler.

- Technical skills utilized: SQL Server 2005, C# .NET

Member of Technical Staff

Intelligent Information System

August 2002 – March 2006 (3 years 8 months) Noida Area, India

Developed early version of NCPTS, NCPTS 2.x was N-tier web application developed using Visual Basic 6.0 and

Oracle 9i.

- Performed Data mapping between County legacy databases and NCPTS Oracle database.

- Data Migration from legacy to NCPTS database using Oracle PL/SQL packages, stored procedures and functions.

- Design and development of assessment and cashiering module.

- Supported acceptance testing for the application.

- Post production support & leading enhancements in system.

- Technical skills utilized: Oracle 9i, Visual Basic 6.0, COM and DCOM using VB 6.0, XSL and XML

Member of Technical Staff

Network Programs

August 2000 – July 2002 (2 years) Noida Area, India

- Worked as a programmer/analyst, and was involved in entire project development lifecycle of Net-Collaborator, an

outsourcing management tool for the program manager (client representative) to outsource projects involving multiple

developer organizations on the same project. Extensively worked on design snapshot of GUI screen and prepared the

system requirement specification (SRS)

- Understood the user requirement and changing GUI screen shots and SRS to meet the user expectation

- Programmed in Transact-SQL, database design and data modeling

- Designed physical and logical database, created tables, views, roles and default data.

- Worked as software configuration manager (SCM) for release and builds

Software Developer

PI Softek Ltd

August 1999 – July 2000 (1 year) Noida Area, India

- Worked as a software developer on accounts payable, purchase orders, and accounts receivable modules of Win Job

9X, an integrated software tool set for planning, design, validation and implementation of business logic of building

construction and accounting processes and operations for DENEB, Inc.

- Understood the user requirements and user expectations

- Developed SQL database stored procedure, functions and triggers

- Wrote business logic component using Visual Basic 6.0

- Involved in unit testing, modular testing, and integrated testing, system testing with real data

- Reports (Using Crystal Report 8.0)

Contact this candidate