Done!
 

Résumé

PERSONAL PROFILE

Solid Quality Mentor
Principal Database Architect, SQL Server Trainer and Consultant
Microsoft Most Valuable Professional (MVP - SQL).


I am a Database Architect and Corporate Trainer specializing in SQL Server Query Optimization and & Performance Tuning having 7 years of rich, hands-on experience. I have been awarded as the Microsoft Most Valuable Professional (MVP) in SQL Server technology. I am Microsoft Certified Trainer (MCT) and also a Microsoft Certified Professional with certificates of MCP, MCDBA, and MCAD backed with a degree in Master of Science (Computer Networks). My expertise lies in Performance Tuning, and I have exceptional analytical skills. I have also participated (as Key Speaker) in International Conferances (TechEd, SQL PASS) and SQL Server user group meetings to share my knowledge to fellow developers, and enhance my technical skills through learning other techniques from them as well. Moreover, I am an outgoing and passionate team player dedicated to sharing my valuable experience and technical knowledge with other technology enthusiasts.

Technical writing is another aspect in which I have done extensive and commendable work. Being a prolific technology writer, I have written over 1300 articles related to SQL Server Technology. I am an avid blogger who posts regularly in my very own SQL-dedicated technology blog, http://blog.SQLAuthority.com. In addition to this, I am also a regular columnist for several well-known IT websites and magazines.

I am an SQL Server specialist teaching a popular training class. Details about this are found here: Microsoft SQL Server 2005/2008 Query Optimization and & Performance Tuning

EDUCATIONAL QUALIFICATION

2003 - Master of Science (Computer Networks) - GPA 3.70
University of Southern California, Los Angeles.
2001 - Bachelor of Engineering (Electronics & Communication) - GPA 3.65
Nirma Institutes of Technology, Gujarat University, India.
2008 - Microsoft Most Valuable Professional (MVP)
2006 - Microsoft Certified Professional (MCP)
2006 - Microsoft Certified Database Administrator (MCDBA)
2006 - Microsoft Certified Application Developer (MCAD)
2006 - Macromedia Certified ADVANCED ColdFusion MX Developer 2010 - Microsoft Certified Trainer (MCT)

TECHNICAL PROFICIENCY

SQL Server 2008, SQL Server 2005
.NET C#
Performance Tuning & Query Optimization
Database Architecture
Project Management

PROFESSIONAL ASSOCIATION

President - SQL Server User Group, Gandhinagar, India - Link
Leader – SQL Server User Group, Ahmedabad, India - Link
Member – Professional Association of SQL Server (PASS) - Link

PROFESSIONAL EXPERIENCE

Mentor - June 2009 till date
Solid Quality India Pvt. Ltd. Mumbai, India
  • Subject Matter Expert (SME) – SQL Server and Business Intelligence
  • Delivered 100+ Hands-On-Lab (HOL) in different cities
  • Conducted various corporate trainings and workshops in several leading IT Industries (Please send me an email for the Client List and Reference)
  • Delivered numerous technical sessions in prominent technology conferences around the world
  • Implemented End-to-End Business Intelligence (BI) stack solution
  • Designed and employed complex Database Architecture; applied innovative strategies to make the database be of high availability and scalability
Principle Database Architect - March 2009 to June 2009
Digicorp Information Systems Pvt. Ltd. Ahmedabad, India
  • Introduced tactical advancements and performance improvement in Query Optimization
  • Formulated and presented new ideas through Data Model Documentation and ensured that the documentation was updated
  • Established standards for SQL installations, maintenance, tuning and coding
  • Leader in the development of our OLAP Data Warehouse Reporting Initiative
  • Provided training, mentoring, and feedback to team members to enhance communication and performance
  • Owner of the current operational data structures; have initiated optimizations and reconfigurations, as needed
  • Envisioned and presented employees’ ideas on the concepts of technologies to the Management to enhance Staff development and boost team spirit
Senior Project Manager - Nov 2008 to Feb 2009
Leading Healthcare Industry, Ahmedabad, India
  • Designed and implemented complex database architecture
  • Implemented strategies for database highly availability and scalability
  • Provided leadership to employees to make the website productive
  • Researched and executed production methodologies and documented system
  • Created bug tracking database and quality assurance systems to locate and organize project assets in a short period of time
  • Proposed systems to collect, arrange, and display electronic correspondence to increase client satisfaction and Management expectations
Principal Database Administrator - Jul 2004 to Oct 2008
Leading Automotive Industry, Las Vegas, USA
  • Responsible for logical and physical designs for application and database tuning
  • Leader in major activities which include advanced performance tuning, database design, and capacity planning
  • Established standards for SQL installations, maintenance, tuning, and coding standards
  • Built and executed large volumes of Leads Management System
  • Instituted Data Mining Algorithms to create excellent Self Learning Automated System
  • Designed the Single Page Application and implemented the Database Driven navigation
  • Launched and wrote Performance Tuning guidelines to enhance the quality of the product
  • Reformed a thorough backup and recovery strategy for all major production systems
  • Upgraded all SQL Server 2000 to SQL Server 2005, without any service interruption
  • Effectively trained and managed a brilliant outsourcing team in India
Teaching Assistant - Jun 2003 to Jun 2004
University of Southern California, Los Angeles, CA
  • Trained and assisted over 200 students to execute class projects on various technical work
  • Teaching Assistance for courses at University of Southern California: 1) Broadband Network Architecture (500-level), 2) Introduction to Digital Electronics (100-level)
Web Developer and Database Administrator - Feb 2002 to Jun 2004
University of Southern California, Los Angeles, CA
  • Proposed and employed a relational database with an outstanding Web interface
  • Created a web-based Control Panel

SELECTED PUBLICATION

SQLAuthority.com (Total over 1300 Articles)
  • SQL SERVER - 2008 - Interview Questions and Answers Complete List Download (Link)
  • SQL SERVER Database Coding Standards and Guidelines Complete List Download (Link)
  • SQL SERVER - Download FAQ Sheet - SQL Server in One Page (Link)
  • SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure, Functions , Triggers, Tables, Views, Constraints and All Other Database Objects (Link)
  • SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL (Link)
  • SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma Delimited File Into SQL Server ( Link)

TECHNICAL PAPERS

  • "Location-centric Isolation of Misbehavior and Trust Routing in Energy-constrained Sensor Networks". IEEE Workshop on Energy-Efficient Wireless Communications and Networks (EWCN), April 2004, Phoenix, Arizona.
  • "Secure Locations: Routing on Trust and Isolating Compromised Sensors in Location-aware Sensor Networks". ACM Sensys November 2003, Los Angeles. California.
  • "Insecure Location Avoidance and Routing on Trust in Location-aware Sensor Networks". IEEE International Conference on Network Protocols (ICMP), November 2003, Atlanta, Georgia

Community Links

LinkedIn - Pinal Dave Twitter - Pinal Dave facebook Feed Email Idera
 
home  | about me  | résumé  | community  | photos  | blog  | mvp  | ip address  | sitemap
Top Downloads  | Script Bank  | Best Articles  | Search  | Jobs
© Copyright 2000-2010 Pinal Dave. All Rights Reserved.