PROJECTS & EXPERIENCE
Client : MasterBrand Cabinets Inc
• Rebuild the SQL SERVER for parity between Stage and Production
• Developed Views, Procedures and Triggers according to business rules
• Tune the database using SQL PROFILER and Performance Monitor
• Devloped DTS packages for extracting and transforming data
Client : City and County of Evansville
Software : SQL Server 2000/ 2005, MS-Access 2003
• MS-Access database had been converted ADP project keeping the database in SQL Server for better performance.
• Designed and created the normalized MS-Access database by analyzing the requirements. Created the data entry form to easily input the data into tables.
• Linked the MS-Access databases to SQL SERVER and set up the appropriate privileges to the users.
• Created appropriate DTS packages to export all the tables from Animal Control Database into CODE ENFORCEMENT DATABASE to keep the existing records and to insert the new records.