Nayon Kumar Roy Email & Phone Number

United States

• Developed and optimized complex Power BI dashboards and reports using advanced DAX functions, integrating data from diverse sources including SQL databases, Excel, and web services, resulting in analytics solutions for.
• Implemented and managed ETL processes using SSIS packages and Alteryx Designer, streamlining data transformation workflows and improving data quality for critical financial reports such as CECL.
• Integrated Salesforce CRM with Power BI using APIs and custom connectors, enabling real-time visualization of sales, customer, and financial data alongside other BI insights.
• Implemented Salesforce automation tools like Process Builder and Flow to streamline loan application processes, reducing manual data entry and improving overall efficiency of member services.
• Designed SQL databases, including star schema modeling, index tuning, and query optimization, significantly enhancing system performance and report generation speed.
• Leveraged Snowflake for large-scale data processing and analysis, implementing cloud-based data warehousing solutions to improve data accessibility and scalability.

• Generated Power BI reports and dashboards, increasing in data-driven decision-making across departments, deployed row-level security and integrated with Power BI service portal, ensuring secure access for diverse.
• Employed advanced DAX functions to create complex data models and measures, optimizing data analysis capabilities. Collaborated with stakeholders to refine reporting needs, leading to more actionable insights and.
• Optimized ETL processes using SSIS, incorporating transformations for multiple data sources including Excel, OLE DB, and flat files. Integrated cloud-based data sources, improving data quality and processing efficiency.
• Created and maintained SSRS reports with features such as sub-reports, dynamic sorting, and parameterization. Managed deployment through Report Manager and Report Server, increasing report adoption through targeted.
• Utilized SSAS to develop tabular data models and MDX scripts for KPIs, integrating with SharePoint for enhanced data visualization.
• Deployed a cloud-based data warehouse solution, integrating OLTP and OLAP systems. This initiative boosted data accessibility and enabled real-time analytics, resulting in a 35% reduction in report generation time and.

Ontario, Canada

• Constructed a comprehensive Power BI dashboard suite, integrating data from multiple sources including clinical trials databases, pharmacovigilance systems, and azure cloud platforms. This initiative improved.
• Designed complex ETL processes using SSIS, Alteryx, and Talend, resulting in a 50% improvement in processing efficiency for large scale clinical trial data, applied data quality checks and governance protocols using.
• Leveraged advanced DAX functions and Python scripting to create sophisticated data models for analyzing drug efficacy and patient outcomes. These models provided actionable insights that increased operational.
• Led the migration of on-premises research data warehouses to a cloud-based solution using Azure Synapse Analytics, implementing star and snowflake schemas. This modernization effort improved system performance by 70%.
• Developed a suite of SSRS reports and Tableau visualizations for tracking key performance indicators in drug development, sales, and market share. Incorporated dynamic parameters and drill-through functionality for.
• Collaborated with cross-functional teams including clinical research, regulatory affairs, and marketing using Agile methodologies to gather requirements, design solutions, and implement BI projects.