Here's a brief summary about myself!Personally, I am a person who loves to write, is passionate about data, enjoys listening to music and playing games and believes that with small attitudes, actions and thoughts you can contribute to a better world. I am also an eternal apprentice in the 'position' of Luísa's father, my daughter who was born in 2021.Academically, I am:- Graduated in Internet Systems from UniCesumar.- Specialist in Business Intelligence by UniCesumar.- Certified as Green Belt - Six Sigma by RL Associados.- Google Search Network Certified by Google itself.- Fluent in English at Fisk Centro de Ensino.Professionally, I always try to deliver the best, always looking for scalability and sustainability of projects, avoiding unnecessary maintenance. In addition, I have been working with data since 2018, especially with Data Warehouse, both in structuring and development and in implementation. I've already used BI tools like Qlikview and Power BI and ETL tools like SSIS, Google Big Query and Databricks, in addition to having a lot of experience with Advanced T-SQL, working mainly with the creation of data transformation artifacts.By the way, if you've made it this far, take a look at my articles here on LinkedIn and also follow me on spotify, who knows, maybe we can swap songs? https://linktr.ee/tameimpalan
-
Líder De DadosAstrazenecaMaringá, Pr, Br
-
Senior Data Analyst - Squad LeadAstrazeneca Mar 2023 - PresentAllocated by Eleflow in the squad, focusing on enhancing performance, applying best practices, and optimizing ETL processes for continuous improvement and scalability. This resource is dedicated to projects that empower end users to embrace data culture daily, with a strong emphasis on self-service BI.Participated directly in the refactoring of the existing data stack and architecture, applying medallion architecture concepts on AWS using S3, Athena, RedShift, and Power BI.Also responsible for analyzing, improving, and preparing project documentation, as well as implementing solutions to mitigate transactions that strain the Premium Capacity environment, ensuring alignment with global team best practices.Currently leading the project sustainment squad, managing resources and backlog of demands, screening, and organizing demands in collaboration with internal clients. Additionally, responsible for periodically presenting results to internal clients.
-
Senior Data AnalystEleflow Big Data Aug 2022 - Present -
Data AnalystEleflow Big Data Feb 2022 - Jul 2022
-
Data AnalystMills Jan 2023 - Feb 2023 -
Data AnalystAmericanas S.A. Feb 2022 - Dec 2022Allocated by Eleflow Big Data in the human experience squad, I worked directly with data structuring and recruitment and selection indicators with Power BI, applying data security principles appropriate to the LGPD, using a star model in structuring datasets and applying transformations of data mostly in SQL and Power Query language, in addition to assisting in ETL processes with SQL.Also responsible for centralizing indicators with tools such as Azure Databricks, Google BigQuery, Power BI Dataflows and also for conducting staff, recruitment and leadership projects. -
Bi SpecialistUnicesumar Nov 2021 - Feb 2022Maringá, Paraná, BrasilI started to work in the implementation and maintenance of the institution's DW in the distance learning niche, using Integration Services and SQL Server, versioning packages, database objects and qlikview scripts (.qvs) with git, gitlab and sourcetree.I worked with data integration via HTTP and REST APIs (GET and POST) using Integration Services to execute the packages.I maintained projects created with Power BI, using dataflows and datasets, consuming data from DWs, always seeking to apply the star model for its work flexibility and integration between events and dimensions.I also acted as scrum master of the intelligence core data team in the management of sprints, tasks, projects and backlog. -
Bi AnalystUnicesumar Dec 2019 - Oct 2021Maringá, Paraná, BrasilI started to work with more robust projects for the institution, being the main focus of the capture and digital niche, I worked constantly in the production of two DWs in co-participation with the IT department, in addition to centralizing and automating several ETL processes in a way self-sustaining, avoiding periodic maintenance and changing manual parameters.I also started to work a lot more with SQL, with an emphasis on creating robust procedures, views and queries aimed at performance, automation and integrity.
-
Junior Bi AnalystUnicesumar Oct 2018 - Nov 2019Maringá, Paraná, BrasilI participated in the creation of applications using the QlikView and Power BI tool, always applying visual concepts so that the end user always has the best possible experience in querying and analyzing the presented data. In the ETL part, I perform the extraction with DW modeling, maintaining an organized and self-explanatory design pattern, making it easier for another analyst to maintain it, so that rework or parallel queries are not necessary to understand the flow of information.
-
Technical Support AssistantTransportes Rodoviário 1500 Ltda May 2016 - Sep 2018Maringá, Paraná, BrasilAssistant in the company's operation, assisting in problems that may cause obstacles to boarding. Possession of the system's master password, enabling the creation and maintenance of users, including governance.Participated in the restructuring and optimization of internal and external processes, facilitating the use of the system and increasing the integrity and reliability of the information entered there.It uses tools such as Excel, Power BI and QlikView for data manipulation and analysis (Business Intelligence).Responsible for implementing the Power BI tool in the company, structuring the bases and building analyzes for decision making.Also responsible for the technical implementation of the GLPI tool in the Orders Department, expanding control over service deadlines, quality indicators, measurement of problems, analysis of variables and conditionals to map problems and identify their root causes.Also responsible for the management and preparation/revision of internal communication, such as newsletters, notices and notices. -
Sales AssistantTransportes Rodoviário 1500 Ltda Dec 2015 - Apr 2016Maringá, Paraná, BrasilAssistant in the collection of outstanding amounts with customers, dealing with payment compositions and settling pending issues and stagnant situations. It analyzed provisions, registration situations and trips whose invoicing was done routinely, without the need for receipts of unloading.
-
Accounts Receivable AssistantTransportes Rodoviário 1500 Ltda Jul 2015 - Dec 2015Maringá, Paraná, BrasilAssist in the collection and tracking of unloading receipts for billing and receipt of customers who require the presentation of the same for payment, contacting suppliers and support units frequently. Sporadically, it also assisted in collecting vouchers from drivers who had not yet exchanged their trip balance, delaying and distorting indicators of internal average terms.
-
Administrative AssistantTransportes Rodoviário 1500 Ltda Jul 2014 - Jul 2015Maringá, Paraná, BrasilAssist in the scanning of unloading receipts for digital file and physical file of freight letters and advance forms. Responsible for sorting documents received by posts and external suppliers. Treatment of retention of unloading vouchers and entry of arrival weight in the system. Also, according to scale, responsible for sending pouches via Correios.
Alan Avelar Skills
Alan Avelar Education Details
-
Business Intelligence
-
Superior De Tecnologia Em Sistemas Para Internet
Frequently Asked Questions about Alan Avelar
What company does Alan Avelar work for?
Alan Avelar works for Astrazeneca
What is Alan Avelar's role at the current company?
Alan Avelar's current role is Líder de dados.
What schools did Alan Avelar attend?
Alan Avelar attended Unicesumar, Unicesumar.
What skills is Alan Avelar known for?
Alan Avelar has skills like Microsoft Excel, Marketing, Adobe Photoshop.
Who are Alan Avelar's colleagues?
Alan Avelar's colleagues are Monique Mulder, Vanessa Nohra, Syed Rumana, Mariya Hasan, Jamie Haley (Doughten), Mba, Aravindak Kumar, Isma Yasou.
Not the Alan Avelar you were looking for?
-
Alan Avelar
Duque De Caxias, Rj -
-
-
Alan Avelar
Brazil
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial