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 management decision-making. • 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. • Developed and managed diverse SSRS reports with drill-down and parameterized options, handling deployment and scheduling via Report Manager and Server.• Applied row-level security in Power BI and integrated it with the Power BI service portal, ensuring data governance and compliance while enabling secure, role-based access to critical business information.

• 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 stakeholders. • 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 boosted business outcomes. • 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 by 40%. • 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 end-user training. • 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 enhanced decision-making capabilities across the organization. • Spearheaded the development of a data governance framework, including data quality checks and metadata management. This effort enhanced data consistency and facilitated easier data discovery, leading to more accurate and reliable business intelligence outputs.

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 visibility into drug development pipelines and reduced regulatory reporting time by 40%, contributing to more agile decision-making processes across R&D and commercial teams.• 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 Collibra, reducing data inconsistencies by 35% and enhancing overall reliability of patient safety information.• 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 efficiency in clinical trials by 20% and supported a successful cost-saving initiative in manufacturing, resulting in $2M annual savings.• 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% and enabled real-time analytics capabilities for monitoring global supply chain and inventory management.• 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 deeper analysis. Conducted training sessions for clinical researchers and sales teams, increasing report adoption by 45% and fostering a data-driven culture across departments.• Collaborated with cross-functional teams including clinical research, regulatory affairs, and marketing using Agile methodologies to gather requirements, design solutions, and implement BI projects.