Dhaval Pujara
Summary
Dynamic Technical Project Lead with extensive experience at Dynatech Systems, specializing in Microsoft Fabric architecture and governance. Proven ability in data integration and optimization, leveraging advanced SQL and strategic planning skills. Adept at driving analytics initiatives and fostering collaboration across teams to enhance business intelligence and reporting capabilities.
Overview
15
15
years of professional experience
1
1
Certification
Work History
TECHNICAL PROJECT LEAD
DYNATECH SYSTEMS
03.2024 - Current
- Defined enterprise Microsoft Fabric architecture and platform standards, implementing Medallion architecture (Bronze, Silver, Gold) for analytics delivery.
- Established data ingestion, transformation, and orchestration standards using metadata-driven and low-code Fabric patterns.
- Implemented hybrid data access using Fabric Shortcuts and Mirroring across on-premises systems, Microsoft Dynamics 365, and cloud data sources.
- Defined Lakehouse and Warehouse architecture guidelines supporting analytical, reporting, and finance workloads.
- Led Fabric governance and security design, including workspace strategy, role-based access control (RBAC), lineage, naming standards, and lifecycle management.
- Designed master data management (MDM) and conformed dimension standards for Customer, Product, and Vendor domains.
- Defined enterprise data integration standards using Fabric Dataflows Gen2 and Pipelines for SaaS, digital, and API-based sources.
- Established Power BI semantic model standards aligned with star schema and enterprise reporting best practices.
- Implemented Fabric Data Agent for governed natural-language Q&A, enabling business users to query trusted Fabric datasets securely using metadata and semantic models.
- Enabled Microsoft Fabric Copilot for Q&A and Power BI report insights, defining governance, security boundaries, and best practices for AI-assisted analytics.
- Led Fabric capacity planning and cost optimization, including F-SKU sizing, concurrency management, and autoscale strategies.
TECHNICAL PROJECT LEAD
STRIDELY SOFTWARE PVT. LTD.
07.2019 - 03.2024
- Advanced Data Visualization: Utilized Power BI to explore and visualize data through diverse methods, ensuring comprehensive data interpretation and analysis.
- Strategic Data Analysis and Design: Demonstrated strategic expertise in designing experiments, collecting data, and visualizing insights for informed decision-making.
- Power BI Reporting & Dashboard Development: Skilled in developing intricate Power BI reports and dashboards by blending data from multiple sources for enhanced business intelligence.
- Power BI Gateway Management: Proficient in using Power BI gateway to synchronize dashboards and reports with on-premise data sources for real-time data accuracy.
- Power BI Administration: Managed Power BI Tenant and Office 365 Center, ensuring seamless operation and administration of Power BI services.
- Microsoft Fabric Component Exploration: Explored and utilized various Microsoft Fabric components such as One Lake, Lakehouse, and Data Warehouse for optimized data handling and activation.
- Deployment Pipeline & Data Pipeline Management: Led the development and management of deployment pipelines (Test, Dev, Prod) and dataflows in Power BI Service, integrating Power BI code management with Azure DevOps using GitHub. Additionally, spearheaded the BI Support and Development team, providing essential support as required.
BI ANALYST
IBASET SOFTWARE PVT. LTD.
04.2018 - 07.2019
- Talend ETL Job Development: Expertly created Talend ETL jobs to handle email attachments using tools like tPop, tFileList, and tFileInputMail, and efficiently loaded data into databases.
- Data Mapping Management: Successfully created and managed source-to-target mapping documents for Fact and Dimension tables to ensure accurate data transformation.
- ETL Methodologies and Standards: Utilized best practices in ETL methodologies to develop Talend ETL jobs, adhering to advanced programming and naming standards.
- ETL Design and Implementation: Designed and implemented ETL processes to transfer data from various sources to Azure SQL and Oracle databases, focusing on Fact and Slowly Changing Dimensions (SCD-Type1 and SCD-Type2).
- Talend Mapping Skills: Demonstrated expertise in creating mappings in Talend using a variety of tools such as tMap, tJoin, tReplicate, and tFlowMeter for optimal data processing.
- Comprehensive ETL Process Development and Reporting: Developed end-to-end ETL processes from source systems to Data Marts, and contributed to major projects at Lockheed Martin and HoneyWell by creating diverse reports in Power BI, executing DAX calculations, and maintaining reports in Power BI, SSRS 2016, and Excel.
SYSTEM ANALYST
ALLSCRIPTS SOFTWARE PVT LTD
01.2016 - 03.2018
- Power BI and Excel Reporting Proficiency: Demonstrated up-to-date knowledge and utilization of Power BI reporting objects and Excel features like Power Pivot and Power Query to create sophisticated reports and dashboards.
- Power BI Mobile App Deployment: Managed and deployed reports and dashboards in Power BI Mobile App, including overseeing Data models, datasets, Content Packs, Apps, and Dashboards in Power BI service.
- Collaborative Project Management: Worked closely with various support teams to ensure adherence to project delivery schedules and Service Level Agreements (SLAs).
- Reporting and Stakeholder Communication: Effectively communicated project progress to senior management and stakeholders through detailed reports and presentations for informed decision-making.
- SSIS Package Development: Developed diverse SSIS packages utilizing control and data flow tasks, including Union, Merge, Lookup, and Data Conversion, along with scheduling SQL Jobs for SSIS Packages.
- Major Project - The Brooklyn Hospital Center, Resolute Hospital: Created a range of charts and reports for The Brooklyn Hospital Center and Resolute Hospital, employing Power BI, SSRS 2016, Dax Studio, and Excel. Developed combo charts, bar charts, line charts, waterfall charts, pie charts, tree maps, and KPI dashboards using real-time datasets, custom visuals in Power BI, and managed reporting and alert schedules in Tableau.
SR. SYSTEM ANALYST
ACCENTURE PVT LTD
11.2014 - 01.2016
- Tableau Reporting and Data Analysis: Skilled in utilizing Tableau for advanced reporting, working with transformations, filters, calculated fields, sets, groups, and parameters; developed and managed dashboard reports for Key Performance Indicators catering to top management needs.
- SSRS Reporting and Data Integration: Proficient in setting up Data Blending in Tableau for merging diverse data sources, deploying and managing SSRS reports on Report Server, and creating detailed Drill Down, Drill Through, and sub-reports in SSRS for various business requirements.
BUSINESS ANALYST
NETWORK 18 (HOME SHOP 18)
01.2013 - 11.2014
- Advanced Reporting and Analytics: Expertly prepared and presented periodic reports utilizing SQL Server Reporting Services (SSRS) and Tableau, incorporating statistical analysis. Demonstrated proficiency in creating complex reports using filters, expressions, parameters, and cascading parameters in SSRS, as well as mastering sorting, bins, combined fields, and hierarchies in Tableau.
- Interactive Dashboard Development and Database Management: Developed interactive dashboards in Tableau with advanced actions like filtering, highlighting, and URL integration, showcasing a variety of visualizations including waterfall, bump, Pareto, bubble, donut, and word clouds charts. Additionally, constructed and managed database objects like tables, views, sequences, and expressions, contributing to project automation and analytics across SSRS, Tableau Desktop, Tableau Server, SQL, and Windows 7 platforms.
SQL DEVELOPER
ACS - XEROX COMPANY
08.2010 - 01.2013
- Advanced SQL Development and Reporting: Demonstrated expertise in TSQL DDL/DML, skillfully managing SQL Server Enterprise Manager and Management Studio using T-SQL scripts. Developed complex SQL queries with multiple table joins and advanced query concepts, and created detailed reports including matrix/tabular reports, drill-down reports, charts, and graphs in Yellow Fin Tool. Contributed to the ELOADER project, a J2EE-based customizable SECAB input processing product for clients like TATA, NOVAX, AT&T, and IBM, by crafting tables, views, stored procedures, and user-defined functions for various applications.
Education
Master of Computer Applications - Computer
South Gujarat University
05.2010
Bachelor of Science - Computer Science
Sardar Patel University
05.2007
Skills
Microsoft Fabric & Governance: Microsoft Fabric (Lakehouse, Warehouse, OneLake), Microsoft Purview (Data Catalog, Lineage, Data Governance), Power BI (Semantic Models, DAX), SSRS
Architecture & Optimization: Medallion Architecture (Bronze/Silver/Gold), Direct Lake, Capacity Planning, Cost Optimization, DAX Studio, VertiPaq Analyzer
Data Engineering & Integration: Fabric Dataflows Gen2, Fabric Pipelines, Talend ETL, Power Query (M), Advanced SQL (T-SQL)
Data Platforms: Azure SQL Database, SQL Server,Oracle
Certification
- SQL Expert
- Querying Microsoft SQL Server 2012
- Analyzing and Visualizing Data with Microsoft Power BI
Timeline
TECHNICAL PROJECT LEAD
DYNATECH SYSTEMS
03.2024 - Current
TECHNICAL PROJECT LEAD
STRIDELY SOFTWARE PVT. LTD.
07.2019 - 03.2024
BI ANALYST
IBASET SOFTWARE PVT. LTD.
04.2018 - 07.2019
SYSTEM ANALYST
ALLSCRIPTS SOFTWARE PVT LTD
01.2016 - 03.2018
SR. SYSTEM ANALYST
ACCENTURE PVT LTD
11.2014 - 01.2016
BUSINESS ANALYST
NETWORK 18 (HOME SHOP 18)
01.2013 - 11.2014
SQL DEVELOPER
ACS - XEROX COMPANY
08.2010 - 01.2013
Master of Computer Applications - Computer
South Gujarat University
Bachelor of Science - Computer Science
Sardar Patel University