Hello, I'm Pedro, a 23-year-old university graduate with a Bachelor's degree in Business Informatics. Having recently completed my studies, I'm excited to embark on the next chapter of my journey.
Throughout my academic career, I've also been gaining invaluable hands-on experience as a dual student at an IT company for the past 3.5 years. Here, I've delved into various aspects of IT, honing my skills in PowerShell automation, project management, data analysis with Power BI, and effective client communication.
Driven by a passion for data analysis and visualization, I've recently embarked on a new adventure at "The Information Lab." Here, I'm excited to further develop my expertise and contribute to impactful projects in the field.
Outside of work and academics, I'm a fervent advocate for self-improvement. You'll often find me on the basketball court, playing American football, swimming laps, throwing punches in the boxing ring, or hitting the gym. When I'm not staying active, I indulge in my love for podcasts, music, and devouring books across various genres.
Personally, my interests lie in the financial realm, where I enjoy exploring investment opportunities in stocks and real estate. I'm thrilled about the possibilities that lie ahead and am committed to seizing every opportunity for growth and success.
Data School
Worked on the concept of
Data Structure
Data Source & Architect
Requirements Engineering
Data Preparation
Developing
Presentation Skills
Project Managing
Concept Designing
Requirements Engineering
Skills
Data Visualization: Tableau, Power Bi
Data Preparation: Alteryx, Tableau Prep
Programming: Python, SQL, Java, PowerShell
Automation: PowerShell
Design: Canva
Key competencies
Requirements Engineering
Statistical Analysis
Data Manipulation
PowerShell Automation
Transparent communication
Experience before Data School
BfD: In the area of Sports
3NET GmbH: Automation, Project Management (3,5 Years)
Studies: Business Informatics (B.A.)
Coffee Segment Analysis (Placement 1)
Data Processing and Transformation:
Adapted new data structures (B) to match existing ones (A) using SQL in BigQuery.
Transformed and aligned dataset headers and content for seamless dashboard integration.
Automated SQL query creation using PowerShell to enhance efficiency.
Cloud Technologies:
Gained hands-on experience with Google Cloud Platform (GCP), including BigQuery and Google Cloud Storage.
Established connections between BigQuery and Google Cloud Storage for data ingestion and processing.
Data Visualization and Analysis:
Integrated and updated dashboards in Tableau by swapping data extracts and connecting new data sources.
Improved Tableau workflows by automating color adjustments in
.twbfiles using PowerShell. That saved us many weeks of work.
Project Management and Collaboration:
Managed and coordinated data integration projects independently.
Maintained regular communication with stakeholders, presenting progress and addressing challenges.
Technical Problem Solving:
Identified and resolved compatibility issues during data integration to ensure the continuity of dashboard functionality.
Ensured that dashboards remained operational despite changes in data structure.
Efficient Workflow Automation:
Used PowerShell scripting to automate repetitive tasks and optimize project efficiency.
Implemented practical solutions to reduce manual workload and improve data processing speed.