Résumé

PERSONAL PROFILE

Principal Database Architect, Developer, Administrator and Project Manager
Microsoft Most Valuable Professional (MVP - SQL).


I am a Principal Database Architect / Developer and Project Manager specializing in SQL Server Programming with 6+ years of rich, hands-on experience. I have been awarded Microsoft Most Valuable Professional (MVP) in SQL Server technology. I am also a Microsoft Certified Professional in MCP, MCDBA, and MCAD backed with a degree in Master of Science (Computer Networks). My expertise lies in programming logic, and I have exceptional analytical skills. I have also participated (as Key Speaker) in SQL Server user group meetings to enhance and share my knowledge. Moreover, I am a communicative enthusiastic team player and a dedicated individual who believes in sharing my valuable experience and knowledge with other technology enthusiasts.

Writing is another domain where I have done extensive and commendable work. A prolific technology writer, I have written over 100 articles related to SQL Server technology. I am an avid blogger and I regularly write on a prominent technology blog http://blog.SQLAuthority.com. In addition, I am also a regular columnist for several prominent IT websites and magazines.

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

TECHNICAL PROFICIENCY

SQL Server 2008, SQL Server 2005
.NET C#
ColdFusion MX
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

Principle Database Architect - March 2009 till date
Digicorp Information Systems Pvt. Ltd. Ahmedabad, India
  • Designed and implemented complex database architecture; implemented strategies for database high availability and scalability.
  • Introduced strategic advancements in the query optimization and performance improvement.
  • Communicated and represented ideas through data model documentation and ensured that documentation was current.
  • Established standards for SQL installations, maintenance, tuning, and coding.
  • Lead in the development of our OLAP data warehouse reporting initiative.
  • Provided training, mentoring, and feedback to team members to enhance communication and performance.
  • Take ownership of current operational data structures and initiate optimizations and reconfigurations as warranted.
  • Envisioned and presented employees’ ideas on the concepts of technologies to 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 for web site production.
  • Researched and implemented production methodologies and documented system.
  • Create bug tracking database and quality assurance systems to organize project assets, reduce time and locate assets.
  • Design systems to collect, organize, 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 design for application and database tuning.
  • Major activities included advanced performance tuning, database design, and capacity planning.
  • Establishing standards for SQL installations, maintenance, tuning, and coding standards.
  • Architected and implemented large volume of Leads Management System.
  • Established Data Mining Algorithms to create Self Learning Automated System.
  • Designed Single Page Application and implemented Database Driven navigation.
  • Established and wrote Performance Tuning guidelines to enhance quality of product.
  • Redesigned a thorough backup and recovery strategy for all major production systems.
  • Upgraded all SQL Server 2000 to SQL Server 2005, without service interruption.
  • Effectively managed outsourcing team in India.
Teaching Assistant - Jun 2003 to Jun 2004
University of Southern California, Los Angeles, CA
  • Trained and assisted over 100 students to execute class projects.
  • Maintained a web-based database for graduate level course: Broadband Network Architecture.
Web Developer and Database Administrator - Feb 2002 to Jun 2004
University of Southern California, Los Angeles, CA
  • Designed and implemented a relational database with a web interface.
  • Created web based control panel.

SELECTED PUBLICATION

SQLAuthority.com (Total over 100 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 MVP Profile - Pinal Dave
 
home  | about me  | résumé  | community  | photos  | blog  | mvp  | ip address  | sitemap
Top Downloads  | Script Bank  | Best Articles  | Search  | Jobs
© Copyright 2000-2009 Pinal Dave. All Rights Reserved.