Dhaval Patolia

Dhaval Patolia is an accomplished and highly skilled Senior Software Engineer, SQL Developer, and Business Intelligence (BI) Analytics Specialist with over 15 years of extensive experience in data engineering, business intelligence, and analytics solutions. With a Master of Science in Electrical Engineering from NYU Polytechnic and a strong foundation in software development, Dhaval has consistently driven innovation in data management, ETL processes, and enterprise reporting. Currently based in the United States, Dhaval serves as a Senior Software Engineer at Mastercard, where he plays a pivotal role in managing the Alteryx server infrastructure, overseeing eight Tableau sites, and maintaining three SQL Server databases. His expertise extends to optimizing system performance, streamlining data integration, and implementing automation solutions that enhance business intelligence capabilities. At Mastercard, Dhaval has successfully led multiple initiatives, including the automation of Alteryx API-driven processes for seamless code migration and the development of a comprehensive Alteryx Server Utilization dashboard in Tableau. His keen analytical skills and technical acumen have significantly improved operational efficiencies, ensuring optimal performance across BI and data analytics platforms. Before his tenure at Mastercard, Dhaval honed his expertise as a Senior Analytics Consultant at Aspect Software, where he spearheaded data integration and analytics projects for enterprise applications. His contributions included designing and implementing multi-dimensional databases, developing advanced ETL solutions, and optimizing complex SQL queries to enhance reporting accuracy. At Aspect, he played a crucial role in developing Power BI dashboards that provided deep insights into software adoption and agent performance metrics, enabling data-driven decision- making at scale. His ability to automate and streamline reporting frameworks resulted in a 50% reduction in reporting time, leading to greater efficiency and improved stakeholder engagement. Dhaval’s proficiency in data engineering and business intelligence is further exemplified by his tenure at Infoway Software, where he worked as a SQL Developer on high-impact projects for financial institutions such as TD Bank. His work on the BLDM (Bank Loan Data Management) system enabled seamless data warehousing, supporting advanced financial modeling and regulatory compliance. He engineered sophisticated ETL pipelines to extract, transform, and load data from Oracle databases, ensuring high data accuracy and integrity. His contributions to enterprise capacity management at Sensata Technologies further highlight his ability to develop scalable data solutions that drive business success. Throughout his career, Dhaval has mastered a diverse set of technical skills, including SQL Server, Oracle, PostgreSQL, Hadoop, MongoDB, and advanced ETL tools such as Alteryx and SSIS. His expertise in reporting and analytics tools— including Tableau, Power BI, SSRS, and Domo—has positioned him as a leader in BI and data visualization, enabling organizations to harness data for strategic advantage. Additionally, his programming knowledge in Python, XML, and JSON allows him to develop robust data transformation and automation solutions. As a certified Microsoft Certified Solution Expert (MCSE) in SQL Server BI and an Alteryx Designer Core and Server Administration certified professional, Dhaval is deeply committed to continuous learning and professional excellence. His ability to manage complex data ecosystems, optimize query performance, and develop scalable BI solutions makes him a valuable asset to any organization. Beyond his technical expertise, Dhaval is known for his leadership in mentoring and collaborating with cross-functional teams. He has successfully led analytics teams, driving innovation in data-driven decision-making and ensuring alignment with business goals. His strategic approach to project management, coupled with his ability to identify and resolve data challenges, has consistently resulted in enhanced business intelligence capabilities and process efficiencies.