Naresh Paruchuri (Azure Data Engineer)

• Led design, implementation, and optimization of comprehensive data solutions for CTM, focusing on enhancing operational efficiency through advanced data engineering practices.
• Azure Functions & Data Integration: Developed and deployed robust Azure Functions using C#, automating complex data integration workflows across multiple platforms. Improved data processing efficiency by 35% through advanced error handling and monitoring.
• Database & ETL Management: Architected and managed Azure SQL databases, creating tables and stored procedures to efficiently process and store JSON data. Designed and optimized end-to-end Azure Data Factory pipelines for seamless data flow and transformation, reducing manual intervention by 40%.
• Databricks & Power BI Integration: Utilized Databricks for high-performance data differentiation, extraction, and transformation. Developed interactive Power BI dashboards, integrating data from Databricks and Azure SQL to provide real-time business insights.
• Advanced-Data Modeling: Designed star schema data models and implemented Kimball’s dimensional modeling principles, optimizing data retrieval for fast and efficient querying, which reduced query times by 30%.

Project: Venue Directory

• Developed Azure Functions using C# for data integration and deployed them in Azure through Pair programming.
• Constructed and maintained scalable databases within Azure SQL Server, architecting 25+ tables and 8 stored procedures specifically tailored for JSON data processing, resulting in a streamlined workflow for data operations utilized by cross-functional teams.
• Implemented Azure Data Factory pipelines for end-to-end data operations, including scheduling with Azure Trigger.
• Enhanced Azure Data Factory pipelines by incorporating data validation, error handling, and monitoring capabilities, ensuring reliable and accurate data processing.
• Leveraged Azure Data Factory's integration with other Azure services, such as Azure Storage and Azure SQL Database, to create seamless data flows across the platform.
• Utilized Databricks for data differentiation, extraction, transformation, and aggregation using Spark_SQL and PySpark.
• Optimized Databricks workflows by implementing best practices for cluster management, including auto-scaling and cost optimization, to improve performance and reduce costs.
• Developed advanced Databricks notebooks for data cleansing and preparation, enabling high-quality input for downstream analytics and reporting processes.
• Integrated Databricks with Azure Data Factory to automate complex ETL processes, facilitating efficient data movement and transformation across different environments.
• Designed and developed interactive Power BI dashboards, leveraging data from Databricks and Azure SQL Server to provide real-time insights and visualizations for stakeholders.
• Optimized Power BI reports by using advanced data modelling techniques, such as creating calculated columns, measures, and aggregations, to enhance report performance and user experience.
• Implemented row-level security in Power BI to ensure that sensitive data is accessible only to authorized users, maintaining data privacy and compliance.

Project: CMAC

• Designed star schema data models and applied Kimball’s dimensional modeling principles for efficient querying and reporting.
• Integrated SharePoint folder files with Microsoft Dataverse using Power App and Power Automate flows.
• Implemented Dynamics 365 integration with Microsoft Dataverse to synchronize data between CRM and other business systems, enabling unified customer insights and streamlined operations.
• Developed custom Dynamics 365 plugins and workflows to automate business processes and enhance data accuracy across different modules.
• Built and scheduled Azure Data Factory pipelines for data processing and storage in Azure SQL Server.
• Leveraged Azure Data Factory to integrate Dynamics 365 data with other data sources, facilitating comprehensive data analysis and reporting.
• Developed real-time Power BI dashboards to provide stakeholders with key performance metrics.
• Created custom Power BI reports and dashboards directly from Dynamics 365 data, using Power BI’s native connectors to ensure real-time updates and accurate visualizations.
• Implemented a proof of concept using Microsoft Fabric to streamline data integration, transformation, and analytics, leveraging its unified platform to enhance data governance and collaboration.

Project: Reports Migration

• Optimized SQL code and migrated SSRS and paginated reports, ensuring high performance.

Technologies: Microsoft Fabric, Azure Data Factory, Databricks, Azure Storage Gen2, SQL Server 2018, SQL, T-SQL, Power BI, Power Apps, Power Automate, Dataverse

• Collaborated with leading partners to drive digital transformation through innovative data engineering and visualization solutions, contributing to enhanced customer engagement and operational efficiency.
• ETL & Data Warehousing: Developed and optimized star schema data models and ETL pipelines using Azure Data Factory, facilitating efficient data analysis and reporting. Integrated Google Big Query and Google Analytics with Azure services to enable cross-platform data analytics.
• Databricks & Synapse Analytics: Engineered scalable data processing solutions using Databricks, optimizing cluster configurations and job scheduling to improve performance. Developed serverless SQL pools and Synapse pipelines for high-efficiency data transformations.
• Power BI Development: Delivered comprehensive BI solutions by creating and optimizing Power BI dashboards. Enhanced report performance by implementing advanced data modeling techniques, improving report efficiency by 25%.

Technologies: Azure Data Factory, Azure Synapse Analytics, Databricks, Google BigQuery, Google Analytics, Azure Storage Gen2, PowerShell, SQL Server 2018, SQL, T-SQL, Power BI, Azure DevOps, PySpark, PySpark SQL.

• Led data migration projects for systems like EPR, Cancer, and Pharmacy.
• Designed and developed SSIS packages for complex ETL processes, ensuring seamless data migration and integration across various healthcare systems.
• Developed and optimized SQL queries to support system migration and ETL processes.
• Implemented error handling and logging mechanisms in SSIS to improve data reliability and traceability.
• Created Tableau visualizations for advanced data analysis and reporting.
• Enhanced Tableau dashboards by integrating multiple data sources, applying advanced calculations, and optimizing performance for better user experience.
• Collaborated with stakeholders to gather requirements and refine Tableau reports, ensuring they met business needs and provided actionable insights.

Technologies: SQL Server 2018, SQL, T-SQL, PowerShell, SSIS, Visual Studio 2017, Tableau

• Migrated data from Rio system to SystmOne.
• Developed Azure APIs using .Net and moved documents to Azure blobs , Azure Storage accounts for secure and scalable storage.
• Implemented Azure Data Factory pipelines for orchestrating data movement and transformation between on-premises and cloud environments
• Utilized Azure Cognitive Search for data indexing and retrieval.
• Created SQL code and SSIS packages for data migration and reporting.
• Configured Power BI Gateways and developed dashboards for COVID-19 reporting.

Technologies: Azure Cognitive Search, Azure Data Factory, SQL Server 2018, SQL, T-SQL, SSIS, Visual Studio 2017, Power BI gateway, Power BI, Azure DevOps

• Migrated data from various sources into a new SQL Server.
• Developed SSIS packages and SQL scripts for data transfer and reporting.
• Created QlikView dashboards for various healthcare metrics.
• Automated data reporting using QlikView, Qliksense and NPrinting.

Technologies: SQL, SSIS, QlikView, Qliksense, NPrinting, Jira.

• Managed data migration projects using SQL Azure and Azure Data Factory.
• Designed and built data pipelines and developed paginated reports.
• Created Power BI dashboards for comprehensive data insights.

Technologies: SQL Server Management Studio 2016, VSTS, Azure DevOps CI/CD, Azure SQL, Azure Storage Explorer, Azure Blob, Power BI Desktop, PowerShell

• Developed SSIS packages and QlikView dashboards for various healthcare metrics.
• Worked on end-to-end QlikView dashboard development, from requirements gathering to deployment.

Technologies: SQL Server 2016, SSMS, BIDS, SSIS, T-SQL, SSDT, Git, QlikView 12

• Managed data projects according to GDPR rules, focusing on data cleansing and quality.
• Developed SSIS packages and Power BI dashboards for various data sources.
• Worked in an agile environment, contributing to sprints and scrums.

Technologies: SQL Server 2016, 2008R2, SSIS, SSRS, T-SQL, SSDT, Agile methodology, Sprint, Jira, Power BI

• Handled monthly SUS submissions and developed SQL scripts for performance tuning.
• Utilized SSIS as the ETL tool to extract, transform, and load data from various sources into the data warehouse, ensuring data quality and consistency.
• Created SSRS reports and Power BI dashboards for financial and board data.
• Used SSDT for database development and version control with Git.

Technologies:SQL Server 2008R2, SSMS, SSIS, SSRS, T-SQL, Excel, C#.net, SSDT, CI/CD, Git, Power BI

• Migrated data from Rio System to SystmOne and developed ETL processes using SSIS.
• Handled data quality issues and migrated SSRS reports.
• Developed Power BI dashboards for financial and board data.

Technologies:SQL Server 2008R2/2012, SSMS, BIDS, SSIS, SSRS, T-SQL, Power BI

• Developed end-to-end QlikView dashboards for various healthcare metrics.
• Migrated database tables and implemented ETL processes using QlikView scripting.

Technologies:SQL Server 2008/2012, SSMS, BIDS, SSIS, Oracle 10g/9i/8i, T-SQL, QlikView 11.2

• Extracted and analyzed data for NHS services and developed SQL scripts.
• Created dashboards using QlikView and Tableau for various healthcare metrics.

Technologies:SQL Server 2008R2, SSMS, BIDS, SSIS, SSRS, ETL, T-SQL, Excel VBA, TFS, C#, QlikView 11/11.2, QlikSense 1.0, Tableau 8.0

• Developed SQL queries and stored procedures for mental health datasets.
• Generated customized reports using SSRS.

Technologies: SQL Server 2008R2, SSMS, SSRS, BIDS, Visual Studio, ETL, Excel VBA, T-SQL.