Liandra V.Data Analyst
Skills
Specialist in BI/Analytics projects with extensive experience in SQL across various platforms, including SQL Server, PostgreSQL, BigQuery, and MySQL. Proficient in Power BI, utilizing M for data modeling and DAX for advanced function creation. Certified as a Tableau Business Intelligence Analyst, with expertise in Tableau Desktop and Looker Data Studio. Currently focusing on Software Engineering, with a particular interest in data visualization using D3.js.
Data Analyst
7/1/2023 - Present
Executed and created ETL processes using Microsoft SQL Server Integration Services (SSIS), managing extraction, transformation, and loading of data across various data sources. Developed proficiency in creating SSIS packages and handling their full lifecycle including building, deploying, and running them. Facilitated smooth data migration from diverse sources to SQL Server databases through SSIS. Collaborated with business teams to gather requirements and maintain Microsoft Power BI reports, while creating DAX calculations and measures to effectively provide essential metrics and KPIs for business operations. Key projects included the creation of different views in SQL Server to seamlessly combine transactions across product categories or sales channels with real-time updates reflected in Power BI reports, and optimization of complex queries, reducing execution time by 40%, from 60 minutes to 20-30 minutes.Engineering Associate
1/1/2022 - 4/1/2023
Demonstrated expertise in Python and Pandas for data extraction, transformation, and loading (ETL) processes. Conducted exploratory data analysis (EDA) to discover patterns, trends, and insights in datasets. Proficient in creating and modifying database objects such as tables, views, stored procedures, functions, and triggers using SQL. Managed data migration from various sources to SQL Server databases utilizing SQL Server Integration Services (SSIS). Applied Python libraries such as Pandas, Matplotlib, and SciPy for data preprocessing, analysis, and trend identification. Developed comprehensive dashboards with Power BI, leveraging M for modeling and DAX for creating measures.
Key accomplishments include creating SQL Server views that integrate data from various anomalies, facilitating direct connections in Power BI dashboards with automatic notification triggers for hardware project managers. Discovered critical anomaly modes, providing pivotal support in enhancing hardware manufacturing projects, leading to improved customer satisfaction and a significant reduction in critical anomalies.Engineering Associate
8/1/2020 - 11/1/2021
Utilized Alteryx for ETL processes, enhancing data transformation and workflow automation. Leveraged Looker and LookML for creating compelling data visualizations and interactive dashboards. Managed and optimized MySQL and BigQuery databases, including the creation and modification of database objects such as tables, views, stored procedures, functions, and triggers using SQL. Applied Python libraries such as Pandas, Matplotlib, and SciPy for data pre-processing, data analysis, and trend analysis, ensuring accurate and insightful data-driven decision-making.Project Assistant
5/1/2018 - 9/1/2020
Developed statistical models and implemented end-to-end strategies to identify improvement opportunities and assess project feasibility. Demonstrated expertise in monitoring projects with MS PROJECT and utilized BPMN process modeling tools, specifically Bizagi, to streamline and optimize project workflows.
Bachelor of Business Administration at Paulista University
2017 - 2020Bachelor of Software Engineering at Estácio
2021 - 2024Software Engineering at Federal University of Technology - Paraná
2024 - 2025
Alteryx Designer Core Micro-Credential: Data Manipulation at Alteryx
4/1/2024Tableau Business Intelligence Analyst at Tableau
3/1/2024Alteryx Designer Core Micro-Credential: Data Preparation at Alteryx
1/1/2024
Liandra is available for hire
Hire Liandra V.
All Howdy Candidates are vetted for skills and english proficiency.
