Fikadu Beyene
Liberty,MO
Summary
Highly analytical and certified Azure and Snowflake Data Analyst with over 7 years of experience in data management, data warehousing, and business intelligence. Proven ability to leverage Azure Data Factory, Azure Synapse Analytics, Azure SQL, and Snowflake's unique architecture to deliver actionable insights and drive business decisions.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
GetInsured
Liberty, MO
10.2021 - Current
- Worked on clients' file transfers, data integration details, including but not limited to file layouts, extractions, data uploads, and delivery requirements.
- Worked on management and storing data in Azure SQL databases, Azure Cosmos DB, and Azure Storage Explorer.
- Developed and implemented data integration processes using Azure Data Factory to extract, transform, and load (ETL) data from various sources into data warehouses.
- Designed and created efficient SQL queries for data extraction, transformation, and loading operations.
- Participated in a data migration project to migrate the data from Azure CosmosDB to Microsoft SQL Server databases using ADF and SQL scripts.
- Owned, improved, and automated assigned day-to-day data operations tasks using Data Factory and Databricks in Azure.
- Diagnosed, researched, and resolved technical issues independently or with other team members.
- Analyzed and improved performance as needed.
- Used Agile methodology to develop and iterate on tasks.
- Collaborated with other developers and data engineers.
- Worked within a team and as a self-directed individual contributor.
- Worked responsibly for updating documentation of data operations processes and procedures.
- Designed and implemented data storage in Snowflake.
- Developed and optimized performance of Snowpipes.
- Ensured data security and compliance within Snowflake.
- Set up resource monitors, models like roles, databases, and schemas on Snowflake.
- Performed data ingestion into Snowflake from various sources.
- Designed and implemented features for identity and access management.
- Solved performance and scalability issues in the system.
- Performed data integration with third-party tools, including architecting, designing, coding, and testing.
- Updated codes, wrote new codes, and reverse-engineered ETL/ELT processes.
- Migrated data from one database to another in Snowflake.
- Regularly engaged with teams for status reporting and daily activities.
ETL and Datawarehouse Developer
Colaberry Inc.
Plano , TX
11.2019 - 09.2021
- Performed data warehousing and management using Microsoft SQL scripting and Azure cloud-based data automation for data cleaning, extraction, loading, and transformations.
- Developed, implemented, administered, and supported the ETL processes (ADF and SSIS) based on the client's request.
- Used ADF and SSIS to create ETL packages to validate, extract, transform, and load data into different databases (environments).
- Worked on changing functionalities of the existing ETL processes based on clients' requirements.
- Worked on troubleshooting and performance tuning of queries, stored procedures, ADF, and SSIS ETL pipelines.
- Participated in the daily scrum.
- Performed code reviews.
- Provided production support for integration and transformation pipelines.
- Worked on Azure Storage Explorer to move data around.
- Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency, and accuracy in data analysis.
ETL and SQL Developer
National Advisors Trust (NATC),
Kansas City, MO
12.2020 - 05.2021
- Successfully and efficiently migrated legacy ETL processes (like DBase, Access, PHP, etc.) to better ETL processes using SQL and SSIS.
- Automated ETL processes in ActiveBatch and SQL Agent Job.
- Maintained, troubleshot, and improved the performance of ETL processes, both on the code level and in automation.
- Gathered requirements, then designed and created the required new ETL processes.
- Worked on the development, implementation, administration and support activities of ETL processes.
- Applied advanced SQL and SSIS tools to construct multiple ETL processes.
- Used performance tuning techniques of SQL Queries.
- Worked with other departments to improve ETL and automation processes.
Education
Data Analytics Certificate - Data Processing Technology
Colaberry School of Data Analytics
Plano, TX10-2019
Master of Arts - Accounting And Financial Management
DeVry University
Villa Park, IL07-2013
Skills
- Data Warehousing
- Data Modeling
- Documentation
- Process Development
- Data Mapping
- SQL and Databases
- Problem-solving aptitude
- Process Automation
- Data and Analytics
- Data Management
- Attention to Detail
- Effective Communication
- Analytical Skills
- Team Collaboration
- Interpersonal Skills
- Time Management
- Database Design
Certification
- Certified Azure Data Engineer Associate
- Snowpro Core Certification from Snowflake
- Certificate of Data Analytics from Colaberry School of Data Analytics
Timeline
Senior Data Analyst
GetInsured
10.2021 - Current
ETL and SQL Developer
National Advisors Trust (NATC),
12.2020 - 05.2021
ETL and Datawarehouse Developer
Colaberry Inc.
11.2019 - 09.2021
Data Analytics Certificate - Data Processing Technology
Colaberry School of Data Analytics
Master of Arts - Accounting And Financial Management
DeVry University
Similar Profiles
Kayla KarsKayla Kars
Account Support Specialist at GetInsuredAccount Support Specialist at GetInsured
Luka AllenLuka Allen
Customer Service Agent at GetInsuredCustomer Service Agent at GetInsured
Shemarrionna BuchananShemarrionna Buchanan
CSR at GetInsuredCSR at GetInsured
Maria Delfina Bee MangueMaria Delfina Bee Mangue
Health Insurance Advisor at GetInsuredHealth Insurance Advisor at GetInsured
Jude KingJude King
Mobile Unit EIC at LTN GlobalMobile Unit EIC at LTN Global