Dhrumil Patel Email & Phone Number

Jacksonville, Florida, United States

• Integrated data from various on-premises and cloud sources into Azure Data Lake, improving data accessibility and scalability.• Migrated legacy data to Snowflake using DBT within Azure, enhancing performance and reducing query latency.• Leveraged Azure Databricks to perform ETL processes, optimizing data transformation and reducing processing time by 30%.• Developed and maintained data pipelines using Azure Data Factory, ensuring seamless data flow between systems.• Optimized Azure SQL Database performance through indexing and query tuning, reducing query execution time by 40%.• Conducted comprehensive data validation and cleansing, resulting in a 98% accuracy rate in the final datasets.• Implemented data governance practices in Azure, ensuring data quality, consistency, and compliance across all environments.• Ensured data security and compliance with HIPAA standards during the migration and storage in Azure environments.• Designed and implemented complex data models, enhancing the organization’s ability to perform advanced analytics.• Developed predictive models using machine learning algorithms in Azure Databricks, forecasting trends and identifying risks.• Applied machine learning algorithms to identify key trends and predictive insights, aiding in proactive business decisions.• Created interactive Power BI dashboards connected to Azure SQL Database, providing real-time insights for stakeholders.• Developed over 20 interactive dashboards in Power BI, providing real-time insights that supported strategic decision-making.• Integrated Azure Monitor to track data pipeline performance and diagnose issues, improving system reliability.• Engaged with business stakeholders to gather requirements and tailor data solutions, improving user satisfaction by 30%.• Automated repetitive data tasks, saving the team over 15 hours per week.• Documented all data migration processes and ETL workflows, providing a comprehensive reference for future projects.

Tampa, Florida, United States

• Architected and managed an Azure SQL Data Warehouse, improving data retrieval speed and storage efficiency.• Integrated diverse data sources into Azure Data Lake, providing a unified platform for data analysis.• Integrated data from multiple sources, resulting in a unified data warehouse that supported comprehensive business analysis.• Utilized Azure Databricks to process and analyze large datasets, reducing data processing times by 40%.• Developed complex ETL workflows in Azure Data Factory, streamlining data ingestion and transformation processes.• Tuned SQL queries in Azure SQL Database, improving performance by 35% and reducing resource consumption.• Established data governance practices using Azure Purview, ensuring data quality and compliance.• Enhanced data quality processes, reducing data errors by 20% and improving overall data reliability.• Developed data profiling solutions and managed data controls, ensuring high-quality data outputs.• Designed Star and Snowflake schemas in Azure SQL Data Warehouse, enhancing data query performance.• Implemented predictive analytics models to forecast sales trends, resulting in a 10% increase in revenue.• Generated capacity planning reports using Python and SQL, helping optimize resource allocation.• Automated report generation in Power BI, connecting it to Azure Synapse for real-time data updates.• Developed interactive dashboards in Power BI with live connections to Azure databases, providing stakeholders with timely insights.• Created advanced drill-down and drill-through reports in Power BI, providing deeper insights and enabling data exploration.• Collaborated with IT, finance, and marketing teams to ensure that data solutions aligned with business objectives.• Developed and delivered training sessions on Power BI and SQL, empowering over 50 team members to utilize data tools effectively.

Cleveland, Ohio, United States

● Designed and implemented data workflows in Azure Data Factory to automate data extraction and transformation tasks.● Integrated marketing and sales data into Azure Data Lake, providing a centralized repository for analytics.● Integrated SAS analytics with Azure environments, enhancing the capability to analyze large datasets.● Employed Azure Databricks for data processing tasks, optimizing performance and enabling scalable data analysis.● Automated ETL processes using Azure Data Factory, reducing manual data handling and improving efficiency by 50%.● Consolidated data from multiple sources, harmonizing datasets for improved consistency and reliability.● Conducted data profiling and cleansing in Azure SQL Database, improving data accuracy and consistency.● Ensured data accuracy and integrity through rigorous validation processes across all data systems.● Developed detailed data mapping documents, ensuring seamless data conversion and integration across platforms.● Performed in-depth customer segmentation using SAS, helping to identify high-value customer segments and target them effectively.● Analyzed marketing campaign performance, leading to a 15% improvement in campaign ROI.● Utilized advanced data mining techniques in SAS to uncover actionable insights, supporting data-driven decision-making.● Connected Power BI dashboards to Azure SQL Database, enabling real-time data visualization and analysis.● Transformed static Excel reports into dynamic, interactive Power BI dashboards, connected to Azure for real-time updates.● Worked closely with senior management to define and track key performance indicators (KPIs), aligning analytics with business goals.● Trained team members on the benefits of interactive reports and dashboards, enhancing the organization’s analytical capabilities.