Franco Lopes

About Franco Lopes

Franco is a seasoned data and analytics professional with over 18 years of experience in Business Intelligence, Data Architecture, and Advanced Analytics across the Banking and Insurance domains. He has built a strong reputation for delivering enterprise‑scale BI solutions, designing modern data architectures, and driving data‑led transformation initiatives for global organizations.Known for his ability to bridge business needs with technical execution, Franco excels in solution architecture, business analysis, stakeholder engagement, and team leadership. His work blends deep technical expertise with strong communication skills, enabling him to translate complex requirements into scalable, high‑performance analytics solutions.Franco’s technical expertise spans Microsoft Power BI, Microsoft Fabric, Azure Data Services, SQL Server BI Stack, Tableau, and cloud-native data engineering platforms. He has led the development of intuitive dashboards, robust semantic models, optimized ETL pipelines, and enterprise BI frameworks that support governance, performance, and long-term scalability.Beyond delivery, Franco has contributed as a trainer, mentor, and thought leader. He has conducted MSBI training labs for Microsoft partners across India and authored articles for SQL‑Server‑Performance.com, reinforcing his commitment to knowledge-sharing and capability building within teams.Core Technical Skills:• Business Intelligence: Power BI, SSRS, SSAS (Tabular/MDX), Tableau• ETL & Data Engineering: SSIS, Azure Data Factory, Azure Databricks• Data Architecture: Dimensional and semantic modeling, cube development, Lakehouse concepts• Cloud Platforms: Azure SQL, Azure Data Lake, Snowflake, Microsoft Fabric• Platform Administration: Power BI & Fabric governance and administrationFunctional & Leadership Strengths:• Business analysis and requirements discovery• Pre‑sales, RFP solutioning, and customer presentations• Agile delivery, planning, reporting, and stakeholder communication• Customer engagement, UAT support, and production readiness• Team leadership, mentoring, and quality governanceFranco’s domain experience covers regulatory reporting, credit and risk analytics, customer insights within banking, and claims and underwriting analytics in insurance. He remains passionate about building modern analytics ecosystems, enabling data‑driven decision-making, and guiding teams to deliver impactful and sustainable BI solutions.

Experience

1. Portfolio Manager - Insights & Data

   Capgemini

   Oct 2025 — Present · Navi Mumbai, IN

Education

• St.Francis Institute of Technology.

  B.E (IT)

Skills

• Performancepoint
• Business Intelligence
• Managed Services
• Sdlc
• Analysis Services
• Sql
• Business Intelligence Tools
• Sql Server Integration Services (Ssis)
• Ssas,Ssis,Ssas
• Sharepoint
• Performance Point Services 2010
• Data Warehousing
• Etl
• Data Analysis
• T-Sql
• Crystal Reports
• Ssrs
• Sql Server
• Olap
• Software Development Life Cycle (Sdlc)
• Ssas
• Sql Server Reporting Services (Ssrs)
• Ssis
• Microsoft Sql Server
• Databases
• .net Framework
• C#
• .net
• Pl/Sql