Personal details
Marcus P.
About
Inquisitive, results-driven, and ambitious Business Intelligence Engineer ready to create a better and more efficient global community via technology and data-driven insights.
Professional with over 5 years of proven track record of achieving best-in-class results.
A visionary with expertise in the following:
• Strategic planning
• Requirement engineering for BI projects
• ELT / ETL (Pentaho Data Integration, Azure Data Factory, Python)
• Dimensional modeling (Kimball)
• SQL databases (MS SQL Server, MySQL)
• Basic knowledge of NoSQL (Mongo, Neo4J)
• Basic knowledge of Hadoop (HDFS, YARN, MapReduce), Spark (PySpark, SQL), and Delta Lake
• R / SQL / M / DAX / Python
• GitHub
• Statistical analysis (descriptive, inferential, probability)
• Dataviz tools (Power BI, Data Studio, ggplot2, matplotlib)
• Data Storytelling
Work Experience
At Anheuser Busch project as a BI Engineer contractor (02/2022 – current)
I'm responsible for:
• Meet with business stakeholders to scope the problem
• Participate in user journeys to get a deep understanding of the process
• Document problem statements and actions that need to be augmented with reporting
• Build wireframes and prototypes to quickly iterate
• Design data models required to support prototypes
• Collaborate with business stakeholders and data domain engineers to articulate data quality measures
• Collaborate with data domain engineer to build a data model
• Collaborate with data platform engineer to implement data pipeline
• Implement data visualization report and app
• Continuous Integration/Continuous Deployment
- Skills: Data Extraction · Model Design · End User Training · Technical Documentation · Technical Requirements · Business Intelligence (BI) · Dimensional Modeling · Transact-SQL (T-SQL) · Python (Programming Language) · Microsoft Power BI · Analytical Skills · Statistical Data Analysis · Big Data Analytics · Jupyter Notebooks · GitHub · Agile Methodologies · Snowflake · Tabular Editor · Microsoft Power Query · Azure Databricks · Azure DevOps · Scrum · Azure Data Factory · Communication · Planejamento estratégico · Data Analysis · Python
Responsibilities:
• Requirements engineering
• Data analysis, cleaning, and transformation
• ML model (classification) maintenance in Python
• Design and development of scalable data models (dimensional data models)
• Development of analysis and reports/dashboard (Power BI)
Main achievements:
• Relationship Campaign report data model refactoring, decreasing the update time by about 90% (5 hours to 15 minutes) and improving the user’s browsing performance
• Development of the Customer Health Score report, providing detailed inputs for strategic decisions to avoid churn
• Development of the Cadastral Management report, reducing the number of invalid contact records by 15%
• Improved critical reporting DAX measures with up to 97% reduction in execution time (from 40 sec to 1.2 sec)
Skills: Data Extraction · Model Design · End User Training · Technical Documentation · Technical Requirements · Business Intelligence (BI) · Dimensional Modeling · Transact-SQL (T-SQL) · Python (Programming Language) · Microsoft Power BI · Analytical Skills · Statistical Data Analysis · Big Data Analytics · Jupyter Notebooks · Agile Methodologies · IBM SPSS Modeler · Microsoft Power Query · Azure DevOps · Communication · Planejamento estratégico · Data Analysis · ETL (Extração, transformação e carregamento) · Python