Nayon Kumar Roy

Experience

1. Business Intelligence Analyst

   SF Fire Credit Union

   Apr 2022 — Present

   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.