Personal details
Marcel P.
Summary
Please, visit my Linkedin for more details: https://www.linkedin.com/in/marcel-pallete-81166b2b/
I'm specialized in Business Intelligence, DataViz, Data Engineering and Cloud, developing solutions for collecting, processing, storing and visualizing strategic data and critical KPIs for decision making and machine learning/ AI applications with high quality and performance, actively contributing to business success.
I have a strong analytical, quantitative, logical, detail-oriented, curious, Data Driven and hands on profile, determined and oriented to solve and prevent problems through technology.
- DISC = C and MBTI = Architect (INTJ-A)
Knowledges in:
- Power BI Specialist (Premium, Pro, Cloud Service, Desktop, Dax Studio, Tabular Editor)
- Google Data/ Looker Studio, Looker, Google Analytics, Tableau, Qliksense, Excel & storytelling
- SQL, M, DAX, LookML, Python and PySpark
- Data and BI modeling
- DW, DM, DL, DLH, OLAP cube, relational and NoSQL databases modeling
- Apache NiFi, MS SSIS, SSAS, SSRS, Pentaho, Alteryx, dbt
- Azure Cloud Data Eng, ML/ AI & Big Data Stack (Azure Data Factory, Databricks, Machine Learning, Synapse, Monitor, Storages & DevOps)
- Apache Spark, Hive, Hadoop
- SAS EG/Studio, Minitab
- DataOps and MLOps Squads
- Data quality
- Agile/Scrum teams, Jira, Confluence
- Lean 6 Sigma Black Belt
- UX/ UI
- Powerpoint
I also have extensive experience in business, processes and business operations management, having worked in the business in a multidisciplinary way for years before working with Business Intelligence.
For 2 years I supervised a market intelligence area, working in commercial planning, sales strategy (Volumes, margins, purchases, inventories), product performance, demand forecasting, S&OP, business intelligence, data analysis, pricing, management information and Ad Hoc studies.
Before that I worked for 5 years as a Black Belt certified business and process analyst. I led Lean 6 Sigma projects of continuous improvement, automation, IoT, digital transformation and innovation, always supported by data and KPIs, with a comprehensive scope in several areas such as sales, purchasing, MKT, costs, pricing, finance, controllership, logistics, industry, inventories, maintenance, etc.
Before, I worked in commercial, financial, industrial and logistics operations.
For 3 years I was also part of an IT team as a key user/ BA in an ERP system implementation, with activities related to As is/To be mappings, master data, analysis of requirements and business rules, functional specification and documentation, automation, testing, user training and support, being the fundamental bridge between technology and business needs.
Work Experience
Lead Big Data Engineering, Cloud, BI, and DataViz professionals aiming continuous development of technical/behavioral skills and raising the levels of quality and speed of delivery of projects and demands to end customers
Activities:
- Technical reference for other professionals and clients
- Refine demands for distribution across team members
- Plan team members activities
- Monitor evolution of team members activities
- Mentor and teach
- Give periodic feedback to professionals
- Member of management, leadership and employee development group
- Teach and assure Software and Data Engineering good practices and excellence
- Approve learning badges
- Lead & Develop EY's internal BI, DW/ ETL/ Data Eng projects
- Develop training programs focused on specific skills of different professional paths for Data & Analytics
- Lead problem solving groups and war rooms
- React quickly to incidents aiming at a quick and effective solution
- Search for root cause and create definitive solutions to problems
- Lead tech innovation and productivity efforts
- Research and apply new tools, languages and functionalities aimed at automation, productivity, accuracy, resource savings
- Connect and apply new global functionalities with local environment applications and processes
- Plan, structure and develop environments, tools, teams and processes to enhance client's and EY's management team's ability to make better data-driven decisions
- Data solutions for EY in Azure, MS Fabric & Power Platform (Power Automate, Dataflow, Dataverse, Power BI, etc)
- Code & projects review/ approval (SQL, Python, PySpark, Spark & ETL jobs, ERwin data modeling, Azure Cloud, Power Platform, Power BI/ M/ DAX, Tableau, Google Looker Studio Dashboards, Git repositories)
- Technically interview candidates
Senior consultant specialized in BI, cloud and big data engineering, providing technological consulting services in Data & Analytics team in large banks, insurance and financial companies.
Working in BI and Big Data Engineering agile squads, acting in innovation, digital transformation, cloud migration, open finance, CRM, OMNI channel, customer experience (CX), digital analytics and Apps monitoring, covering the entire data cycle from the stages of discovering the needs of the business areas, requirements analysis, data modeling, design/ prototyping, architecture and provisioning of Cloud resources, development of data/ETL pipelines, Data Warehouses and DataViz to delivery of value-generating information to end consumers as high-level full automated Dashboards or Data lakes/ warehouses.
Activities:
- Ingestion, ETL and orquestration pipelines in Azure Data Factory and Apache NiFi
- ETL Pipelines with SQL, Python, PySpark, Pandas, KQL and Cobrix in Data Lake House environments using Spark (Databricks/ Delta in Cloud or Jupyter Lab on-prem)
- Convert jobs to Spark
- Tuning
- Hive, HDFS, HUE
- Advanced Dashboards in Power BI, Tableau and Google Data/ Looker Studio, using tools like DAX Studio, Tabular Editor, Performance Analyzer, applying specialized development and tuning techniques to ensure high performance on giant datasets
- ETL using Power Query advanced techniques
- Dimensional data modeling using ERwin and Power BI
- Author complex analytical queries
- Data quality planning, monitoring, issues investigation and fixing (bugs)
- Azure Cloud migration, moving and setting on-premisses data, storage and processing resources and scripts to cloud environment for Big Data, ML/ AI & BI workloads
- Teach users on Azure cloud resources
- Interface with Microsoft and EY global specialists
- Integrations for OLAP and OLTP applications
- DevOps/CI/CD with Gitlab & Azure DevOps