Skill set (10)
Andre in a few words
Data analyst/engineer experienced in developing reports, working with stakeholders and building data pipelines. Looking to combine technical knowledge with communication skills gained negotiating with stakeholders, hosting workshops and mentoring junior analysts.
Experience
- Sapenta Analytics LtdDirectorDIGITAL & ITJanuary 2023 - Today (1 year and 10 months)Ferndown Town, England, United KingdomCreating data products for insurance consultancies, charities and public sector organisations with Power BI, SQL and Excel.
- Analysed factors influencing customer behaviour using SQL in Azure Virtual machines to extract and transform data and Power BI and Tableau to present findings
- Automated Excel marketing reports with VBA
- Identified and resolved issues with published Power BI reports, using SQL in azure synapse analytics to amend ETL pipelines
- Developed custom DAX measures to analyse insurance premium data
- Arranged and led workshops with Policing stakeholders to gather requirements for Power apps solution to streamline cautioning processes. Created user stories and process flow diagrams to guide development based on information gathered
- Nato Communications and Information AgencyOperational Analyst/Data EngineerDEFENSE & MILITARYApril 2024 - June 2024 (2 months)The Hague, The NetherlandsBuilding applications and researching business processes to identify bottlenecks and opportunities
- Analysed NATO processes to find bottlenecks. Communicated with military stakeholders to understand business context and develop useful insights
- Built applications with react javascript, showing overlaps and duplication of effort for AI projects
- Created dashboards and reports in Power BI presenting analysis to stakeholders
- Designed databases and modelled data from surveys, interviews and workshops
- Department for Environment, Food and Rural AffairsData Analyst/EngineerPUBLIC SECTORAugust 2023 - September 2023 (2 months)Creating Power Platform solutions for a project management team
- Developed workforce planning and stakeholder management solutions with Power BI and Power Apps
- Carried out sentiment analysis on Stakeholder comments using R and added results into Power BI dashboards
- Built ETL pipelines with Python in Azure Databricks, collecting data from Microsoft Project via API
Recommendations
Education
- Computer Science (MSC)Wrexham Glyndwr University2023Key Modules included Machine Learning, Database Systems and Data Structures/Algorithms
Certifications
- Project ManagementAssociation for Project Management2019