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