About

Ajay Panchal is a highly experienced Sr Data Engineer with over 17 years of IT experience, 15 of which have been focused on SQL development, with a particular emphasis on SQL Server. He is certified as an MCITP Database Developer & Administration SQL Server and an MCSD. Ajay has extensive experience in database development, including data modeling, schema/table design, views, stored procedures, error handling, functions, triggers, linked servers, advanced T-SQL, encryption, data mapping, data cleansing, and data exchange. He also has experience in database administration, including maintenance plans, backup/recovery, alerts, operators, code release management, DB migration, growth monitoring/archiving, SQL Profiler, indexing, data integrity, debugging, query optimization, performance tuning, security, log shipping, mirroring, and replication. In addition to his database development and administration skills, Ajay has experience in business intelligence, including SSIS, DTS, ETL, SSRS, SSAS, and data mining and warehousing. He is a self-starter and has led small project teams, trained 50+ users, and mentored junior team members. Ajay has excellent communication skills and is able to bridge the communication gap with non-IT staff. He is meticulous, hard-working, and intelligent, and is striving to become an SQL Server MVP. Ajay's key achievements include providing last line of support for leading corporate tax software in the marketplace, which is used daily by Fortune 1000 clients containing 1 million+ lines of complex SQL code. He has also provided database/reporting solutions that decrease costs, facilitate executive-level decision making, increase reliability, boost performance, generate revenue, and positively affect the bottom line, saving his employer over $1.8M and 30,000 staff hours in a single year. Ajay is currently working as a Database Architect/Developer at Your Best House Advisor, where he has designed and developed a marketing database in SQL Server for running daily marketing campaigns. He has also created ETL processes in SSIS to load county, foreclosure, and probate flat file data into a relational database and developed stored procedures to process and output segmented marketing lists from the database. Ajay's past experience includes working as an IT Contractor - Data Analyst at Chapterhouse (Health Care Management Consultancy) and as a DBA/Developer at Carrington Carr Home Finance Ltd. At Carrington Carr, Ajay supported