Name: Hanna Taera

Phone Number: 202-***-****

Email Address: ad12t0@r.postjobfree.com

Summary:

Advanced knowledge Power BI tools and the ability to create interactive dashboards, reports and visualizations. Proficient in using ETL tools and SQL to extract, transform, and load data from various sources. Expertise in writing complex DAX formulas for calculation and measures. Strong analytical skills and ability to work with cross-functional teams to understand business requirements and deliver solutions. Work Experience:

Data Warehouse Engineer at DunaTek LLC, Feb. 2021 to June. 2023 Responsibilities:

Power BI

● Designed and developed a Power BI dashboard for an enterprise Data Warehouse, enabling users to visualize and interact with data effectively.

● Imported data from SQL Server into Power BI, transforming it to facilitate data analysis and comprehension.

● Applied data modeling techniques, including star schema, snowflake schema, OLAP, and normalization, to create efficient data structures for accurate analysis and optimized performance.

● Utilized Power BI features such as Measures to calculate various fields, ensuring accurate and meaningful reports.

● Leveraged a wide range of Power BI visualization tools, including Matrix Slicer, Bar Chart, Line Chart, Donut Chart, Pie Chart, and third-party plugins, to present data in a clear and efficient manner.

● Implemented Power BI data filters within the dashboard to facilitate easy access and exploration of data.

ETL

● Developed an enterprise SQL Server Data warehouse, replacing legacy systems and applications like SimpleNexus, LendingQB, LendingWise, UberWriter, and LendingPad, to streamline data management and improve operational efficiency.

● Utilized a variety of ETL tools and SQL techniques to extract, transform, and load data from diverse sources, including OData, Salesforce, FTP, and OAuth connections, ensuring seamless integration into the SQL Server environment.

● Implemented robust data quality checks, validation processes, error handling, and logging mechanisms to guarantee the accuracy and completeness of data within the data warehouse.

● Created and maintained comprehensive documentation for data warehouse systems, including data models, data dictionaries, and ETL processes, facilitating system understanding, troubleshooting, and future enhancements.

● Optimized data warehouse performance through effective techniques such as indexing and partitioning, ensuring efficient data retrieval and processing for improved query performance.

● Leveraged Snowflake’s cloud-based data warehousing platform to efficiently manage and analyze extensive datasets, while creating optimized SQL queries for data extraction and transformation within the snowflake environment.

● Utilized Business Intelligence tools such as Power BI to develop and maintain interactive visualizations, dashboards, and reports, providing actionable insights for stakeholders.

● Collaborated with cross-functional teams to gather and understand business requirements, ensuring the delivery of tailored solutions that meet organizational needs. Database

● Designed and developed T-SQL procedures, including query performance tuning and SSIS packages, to enhance system performance and streamline data processing.

● Implemented data mapping strategies to ensure accurate data flow from source systems to staging tables, leveraging functions to provide customized functionality based on specific requirements.

● Developed and optimized complex Stored Procedures, Triggers, User Defined Functions, Indexes, and Views, utilizing T-SQL code and SQL joins to implement business rules and improve query efficiency.

● Applied normalization and denormalization techniques to optimize database structures and improve query performance.

● Designed and created indexed views and appropriate indexes, significantly reducing query execution time and enhancing data retrieval efficiency.

● Utilized SSIS to implement slowly changing transformations, data scrubbing, and validation processes, ensuring the delivery of high-quality data to the data warehouse. Skills:

● Power BI

● Data Visualization

● Data Integration and Modeling

● Database Design

● Snowflake

● SQL and C# Coding

● Data Analysis

● Data Warehousing & ETL

● Python Programming

Education & Training:

DunaTek - Education and Training

● Data Integration with Microsoft Integration Service

● Data Visualization and Power BI

● Data Modeling and Development

● Database Design & Management