About

Franco Lopes is a highly skilled Sr. Manager in Data & Analytics with over 15 years of experience in Solutioning & Architecture, Business Analysis, and Team Management. He is a certified Power BI Data Analyst and Scrum Agile Practitioner. Franco has an excellent track record of delivering IT solutions and possesses exceptional interpersonal and communication skills. Franco is a technically-sophisticated professional with a passion for developing and driving business by empowering organizations with innovative BI & Advanced Analytics solutions. He has extensive experience in delivering comprehensive Business Intelligence through Microsoft BI tools, Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS), Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS), Advanced extensible reporting skills using SQL Server Reporting Services (SSRS), and Visual intuitive dashboards using Power BI. Franco has also delivered hands-on labs MSBI Trainings to the Partners and Prospective customer’s of Microsoft in PAN India Microsoft Offices. He is also an author on the http://www.sql-server-performance.com and mentors colleagues on development and delivering the solutions on the scheduled deadline. Franco is highly adaptable and flexible to work with a blend of technologies. His technical specialties include SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, MDX, SQL, PowerPivot, PowerBI, DAX, Azure DataLake, Azure Data Factory, and Azure Data Bricks. In addition to his technical expertise, Franco has functional experience as a Business Analyst in understanding functional and business requirements and bridging the gap between the Product Owner and Agile Teams. He provides techno-functional consultation for solution propositions, updates stakeholders with weekly status reports as a project management tool, and coordinates with the client’s team for issue/bug fixing, closure, and sign-off. Franco is proficient in Agile-Scrum Methodology, Team Management, Planning and Managing Deliveries, Customer Engagement, and Co-ordination. Franco is a certified Prince 2 Practitioner, Microsoft Certified Professional, and Microsoft Certified Solution Associate: BI Reporting. He has worked in the Banking and Insurance domains and is currently a Senior Manager - Insights & Data at Capgemini. Franco’s past experience includes working as a Manager - Insights & Data and Senior Consultant - Insights & Data at Capgemini. He holds a B.E (IT) degree from St. Francis Institute of Technology. Franco’s tech stack includes SQL, Azure, Integration, and ETL.