Open to opportunities

Marco Alexandre Lázaro

@marcoalexandrelzaro

Message

Experienced Business Intelligence Specialist with expertise in data analytics.

Zimbabwe

Message

What I'm looking for

I am looking for a role that challenges my skills and offers opportunities for growth in a collaborative environment.

I am a dedicated Business Intelligence Specialist with over 10 years of experience in data modeling, ETL/ELT processes, and data visualization using Microsoft BI tools. My journey in the field has been marked by a commitment to excellence and a passion for transforming data into actionable insights. I hold certifications in Microsoft Power BI Data Analyst and have successfully led numerous BI projects across various industries, including pharmaceuticals and consumer goods.

Throughout my career, I have been responsible for the architecture, implementation, and management of BI solutions, ensuring data integrity and optimal performance. My expertise extends to advanced T-SQL programming, where I have developed stored procedures, views, and managed database servers. I take pride in my ability to understand user needs and translate them into effective BI solutions, fostering collaboration and driving project success.

Experience

Work history, roles, and key accomplishments

Sr. Business Intelligence Analyst

BDBI Tec

May 2024 - Feb 2025 (9 months)

Maintained enterprise-wide BI environments, validating data loads and interacting with users to understand and specify new demands. Built reports using Microsoft BI tools including SSAS, SSIS, SSRS, and Power BI. Acted as a DBA and tuned T-SQL queries for optimal performance.

SSAS SSIS Microsoft SSRS Power BI SQL Server T SQL DBA Data Validation Project Management

Business Intelligence Specialist/ Data Analytics

Runtalet

Mar 2021 - Apr 2023 (2 years 1 month)

Specialized in BI projects within the pharmaceutical and consumer goods industries. Structured and constructed Datawarehouses, load pipelines, and OLAP cubes in Analysis Services. Created visualizations in Power BI and managed projects based on user needs.

Data Warehouse ETL OLAP Analysis Power BI Project Management Pharmaceutical Consumer Goods Data Analytics

Sr. Business Intelligence Analyst

BDBI Tec

May 2015 - Feb 2021 (5 years 9 months)

SSAS SSIS Microsoft SSRS Power BI SQL Server T SQL DBA Data Validation Project Management

Business Intelligence Architect

Niteo Consulting Services

Nov 2012 - Oct 2013 (11 months)

Led BI projects, providing technical leadership to a team of analysts. Interacted with clients to understand needs, gather requirements, and prepare functional and technical documentation. Defined architecture, modeling, and development patterns, supervising and monitoring the development team across multiple projects.

BI Architecture Technical Leadership Requirements Gathering Documentation Data Modeling Consulting Team Management

Business Intelligence Architect

Peixe Urbano

Aug 2011 - Oct 2012 (1 year 2 months)

Designed the BI environment for Peixe Urbano, a large coupon site in Brazil. Led a team of developers, defining the architecture and modeling the data warehouse. Assisted in tool selection and managed demand queues with users.

Performance Point BI Design Data Warehouse Team Leadership SQL Server SSIS SSAS Architecture

Sr. Data Administrator

Programmers Consulting Services

Jan 2010 - Jul 2011 (1 year 6 months)

Responsible for synchronizing data models and databases, standardizing and approving requests for database object creation/modification. Assisted developers and architects in data modeling and managed model promotion between environments. Maintained and enriched the data dictionary and created metadata for better data environment organization.

Data Management Data Modeling Database Management SQL Server Synchronization Metadata Environment Promotion

Sr. Business Intelligence Analyst

Recall Information Management

Jul 2009 - Dec 2009 (5 months)

Designed Business Intelligence Solutions including ETL, Cubes, Reports, and Dashboards using Microsoft technologies. Utilized SQL Server 2008 (SSIS, SSAS, and SSRS), SharePoint sites, and Performance Point 2007.

BI Design ETL SSIS SSAS Microsoft SSRS SQL Server SharePoint Performance Point I Cubes Reports

Sr. Business Intelligence Consultant

Arbit BI Solutions

Dec 2006 - Apr 2008 (1 year 4 months)

Prepared multidimensional models based on customer requirements to build cubes and reports supporting business decision-making. Used Microsoft’s BI platform on SQL Server 2005 and Panorama NovaView. Constructed web portals in ASP.NET/C# to manage aspects of the BI environment.

SQL Server Panorama NovaView ASP.NET C++Web Portals Data Extraction Oracle

Business Intelligence Analyst

Credigy Financial Solutions

Apr 2005 - Nov 2006 (1 year 7 months)

Managed environmental data on the SQL Server 2000/2005 platform. Developed and maintained OLAP cubes using Analysis Services and Data Marts. Developed reports using tools like SQL Query Analyzer, Microsoft Excel, and Microsoft Reporting Services. Collaborated with users to survey needs for new or modified reports.

SQL Server OLAP Analysis Data Marts Reporting SQL Query Analyzer Microsoft Excel Data Management

Sr. System Analyst

IT Marketing S/C Ltda.

Aug 2001 - Apr 2005 (3 years 8 months)

Modeled and developed databases in SQL Server 2000 and MS Access, including data quality analysis and data structure creation. Served as a SQL Server DBA, leading a team of trainees in database administration. Developed user interfaces in Access and programmed extensively in T-SQL.