Summary:

• Microsoft Certified Database Professional with over 7+ years of solid experience in Database Administration, Development & Support on Ms SQL Server 2008/2005/2000.
• Expertise in Ms SQL Server Database Monitoring-Tuning-Optimization, Installation-Patches, Designing, Disaster Recovery, T-SQL, ODBC, OLEDB, Stored Procedures, Functions, Triggers, SQL Profiler, Replication, Integration Services (SSIS) & Reporting Services (SSRS).
• Strong skills in Ms SQL Server Database Warehousing, Analysis Services (SSAS) and Seagate Crystal Reporting.
• Demonstrated expertise in Database Management, Backup-Recovery procedures, Performance tuning, Optimization, Capacity Planning, and Database Standards-Practices.
• Ability to rapidly achieve organizational integration, assimilate job requirements, employ new ideas, methods, and technologies.
• Excellent Communication, Troubleshooting, Teamwork & Organizational skills with capability to learn new technologies and manage priorities under pressure.

Certifications:

• MCITP: Microsoft Certified IT Professional | Ms SQL Server 2008
• MCTS: Microsoft Certified Technology Specialist | Ms SQL Server 2008
• MCTS: Microsoft Certified Technology Specialist | Ms SharePoint Services 3.0
• MCTS: Microsoft Certified Technology Specialist | Ms SQL Server 2005
• MCDBA: Microsoft Certified Database Administrator | Ms SQL Server 2000
• MCP: Microsoft Certified Professional

Ministry of Health & Long-Term Care (MOHLTC), ON-Canada:

• Surgery & Diagnostic Imaging (SurgeryDI)
• Wait times in Ontario (WTIO)
• Public Reporting
• Critical Imaging System (CIS)
• Application for Rate Reduction and Exceptional Circumstances (ARREC)

Region of Peel, ON-Canada:

• Health Risk Assessment Tool (HRAT)

Operations Springboard, ON-Canada:

• Training Application (OSTA)
• Youth Justice Committee (YJC)

Social Housing Services Corporation (SHSC), ON-Canada:

• Social Housing Services Corporation (SHSC)

Operating System:

• Microsoft Windows 2003 Serve/2000/XP/Vista, Linux Red Hat 4 & Novell Netware

RDBMS:

• Microsoft SQL Server 2005/2000, Oracle 10g & MySQL 4.1

DBA Tools:

• SQL Profiler, Performance Monitor, PA Server Monitor, OpManager

Reporting:

• SSRS 2005/2000 & Crystal Reports (v10 & v8)

Applications:

• Ms Office 2003/2000/XP, Microsoft Dynamics CRM 3.0

Languages:

• Visual Basic 6.0, Visual Basic .Net.

Others:

• Visual SourceSafe, Ms Exchange, Active Directory, Remote Desktop & LAN.

CCIM

• Position: Database Administrator
• Address: 21 College Street, Toronto. Ontario. CANADA
• Description: Database Administration and Reporting.

ISTCL

• Position: Database Administrator
• Address: 2 Carlton Street, Toronto. Ontario. CANADA
• Description: Provided database support for over 20+ government clients with 98% up-time 24x7. Developed databases and prepared customized reports for Youth Justice Committee (YJC), Ministry of Health (MOH) & Long Term Care Health (LTCH) projects. Supported over 85+ production and 170+ development databases for corporate clients. Troubleshoot client issues and optimized process for optimal run. Installed & Configured Microsoft Dynamics CRM 3.0 Server. Provided support for project planning, documentation and implementation.

TELEHOP COMMUNICATIONS INC.

• Position: Database Administrator
• Address: 200 Consumers Road, Toronto. Ontario. CANADA
• Description: Identified new ways to improve existing database designs and deployments to ensure database related code is being optimally written for application. Monitored database performance, efficiency, capacity and recoverability on day to day basis. Developed standard procedures for tuning and optimized database performance. Implemented new plans for database maintenance, backups and recovery.

INNOVATION INSTITUTE OF ONTARIO

• Position: Database Administrator
• Address: HL20 MaRS Centre, Queens Park, Toronto. Ontario CANADA
• Description: Developed database for a discipline designed to fulfill the requirements of Project Management System & Impact Reporting. Designed strategies for automotive tasks for database maintenance, backups, performance tuning & optimization. Developed, Monitored and Maintained database for eGrants Management System. Designed & Implemented DRP for eGrants Management System. Normalized data and prepared schema for Data Warehousing. Designed and Implemented Data Warehouse to extract, parse and clean Thomson Scientific Information from ISI Web of Knowledge.

NEXTERNA INC.

• Position: Database Administrator
• Address: Burlington, Ontario. CANADA
• Description: Developed comprehensive reports using SSRS 2005 with enhanced capabilities of distribution and Ad-hoc reporting. Copied data between databases and systems using an Extraction, Transformation and Loading (ETL) tools such as DTS & SSIS. Created, tested and debugged stored procedures in T-SQL to ensure 24x7 supports of all corporate databases.

TRANSPEK-SILOX INDUSTRY LTD

• Position: Database Administrator/EDP Officer
• Address: Kalali Circle, Vadodara. Gujarat 390011 INDIA
• Description: Created, debugged and modified stored procedures, triggers, views and T-SQL Statements for data capturing, manipulating and retrieval. Provided 24x7 support for database troubleshooting and optimization. Worked with IT team to roll out new hardware and software troubleshooting issues.

LMP MOTORS PVT LTD

• Position: Database/System Administrator
• Address: Suraj Plaza II, Sayajiganj, Vadodara. Gujarat INDIA
• Description: Replicated database objects in multiple remote locations to make up a distributed database system on day to day basis. Administered, monitored and optimized Inventory database. Designed strategies for spares data movement analysis using FIFO method. Provided back-end support to developers for optimization of T-SQL code. Extracted legacy data using SQL and other third party ETL tools.

Education:

• Oracle Database Administration - 11g from Humber College, Toronto. CANADA
• Oracle Database Administration - 10g from Humber College, Toronto. CANADA
• Professional English Speaking from University of Toronto, Toronto. CANADA
• Programming in VB.Net from INDIA
• SQL Server Administration from INDIA
• Cisco Routing from INDIA
• Certified Course in Web Development from INDIA
• DCST from ET & T INDIA
• Computer Fundamentals from Brainbench. US

Call Centre Management:

• A well organized web based application with enhanced reporting to handle call centre management. This is also suitable for routine customer transactions, such as checking account balances, managing plans and even maintain profiles. The system uses IVR technology for inbound calls.
• Application is developed using VB .net, C Sharp on Microsoft SQL Server 2000 database.

Project Management:

• A well organized application designed to fulfill the requirements of grants management system having the ability to effectively manage grant projects. The application designed specifically for grants professionals efficient enough to track projects, manage resources, funding and deliverables within specified time constraint.
• Application developed on PHP on MySQL 4.1 as database backend.

Service Management:

• A web based application developed with the complete service management functionality providing multidimensional view of customer assets, entitlements and service history. It enables you to manage the entire service cycle including call tracking, logistics, inventory, service billing with enhanced capability of leverage integrated XML based reporting.
• The application developed on Visual Basic .Net & C-Sharp on Microsoft SQL Server 2005 database backend.

Inventory Management:

• The application developed with the ability of real-time inventory tracking, purchasing, billing, warranty tracking, bin management and other specialized features like auto purchase order generation and product tracking.
• The application developed on Visual Basic 6.0 on Microsoft SQL Server 2000 database backend.

Customer Relationship Management:

• An application that entails all aspects of interaction a company has with its customer. It keeps track of customer aspects and has an ability to quickly maintain customer profile. With build in reporting tool which can analyze this information and provide required for promotions, campaigns and evaluating their performance on day to day basis. It had an integrated emailing module which send and receive emails and automatically maintained its history.
• The application developed with Visual Basic 6.0 on Microsoft SQL Server 2000 database backend.

Pharmacy Retail Management:

• An automated interface with an ability to integrate advanced pharmaceutical product modules delivering availability of efficient and productive Retail pharmacy system. Some of the specialized features include purchase, ordering, inventory control, bin management, order tracking and built in reporting tool.
• The application was developed using Visual Basic 6.0 and Microsoft Access 2000 database as backend.

• Request a resume, please contact : HEMAL SHAH
• Email me at : hemal_s_shah@yahoo.ca