Sandip Prakashbhai Patel Email & Phone Number

Vadodara, Gujarat, India

Vadodara Area, India

Vadodara, Gujarat

HRTP was a Staffing Solution Application Which used for US Recruitment. It was the old system working since 2005, now the new version is developed, that name is SourcePros system developed in MVC and Framework 4. For the back-end, a SourcePros system Database is developed with best normalization concepts in SQL server 2014 Enterprise. And finally, HRTP DB successfully migration is done to with a newly designed Database. DB Migration whole process is completed within a year. This process includes following steps: • Gathering and analyzing the new and undeveloped requirements. • DFD and UML Design • Designing the best normalization database structure • SQL Script is written • Test db migration on the staging server • finally, the Migration Process run on Production • Verify the report's summary with newly migrated data

Vadodara Area, India

- Responsibility of management of SQL Server 2008 & 2005 Databases, with performance tuning utility, data integrity, replication of database tables, mirroring the database, reporting services to MIS dept. - Maintenance of a large no of database files using backup and restoring function. To make the maintenance plan to manage all backups and restore. As well as create and manage the Jobs. - Manage the access the right to Database Login user and with defining the roles of users.- Analysis the System related to module applied in company. Regular Coordinating to my boss about system work efficiency. And Cooperate as not a team leader but work as team work with my juniors. - Solved the problem of running application as reengineering work to each module.

Baroda

- Setup, deployed and administered to ERP – CRM system with relational Data of SQL database 2000 and 2005. - Responsible for researching, analyzing, analytical and reporting maintain in ERP – CRM System using SQL server 2000/2005, including mail servers, file storage and network attached storage units, and load balancing SQL Database Users on SQL Server 2000/2005 on intranet and internet both environment. - Worked closely with the software ERP-CRM maintenance team in evaluating and implementing data mining and analytically reporting technology solutions required to optimize the production environment. - Manage the Backup and restoring scheduling of database.

Baroda

- Planned and coordinated the implementation of ERP Software development, Deployment and Maintenance.- Organized and managed an entire Database tables and Entities, setting up internal database servers, establishing a QA/Testing environment in SQL Server 2000 and Later.- Worked closely with the development team in troubleshooting software issues.

Mcsd, Mcad, Mcp, It

A Level, It

Bba, Administrator

BBA