Learn Data Skills
Beta
Dawit Adane

Dawit Adane

BI Developer

WEX | 75126

Technologies

My Portfolio Highlights

My New Workbook

My workspace

My New Course

Introduction to SQL Server

My New Workbook

Try out AI

Data juggler, effortlessly balancing variables to unlock insights.

My Work

Take a look at my latest work.

DataLab

My workspace

course

Introduction to Relational Databases in SQL

course

Introduction to SQL Server

course

Intermediate SQL Server

DataLab

Try out AI

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

AWS AWS Cloud Practitioner

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

USDA-NRCS | Apr 2022 - Present

Database Engineer

● Create repository, push, pull, and split directories from TFS and Upload to Bitbucket. ● Using Jenkin for creating Pipelines and Automation. Use scripts for post and pre-server Pre- and Post-SQL installation Configuration for T-SQL. ● Deploying backpack from visual studio to AWS Cloud ● Configure EC2 and S3 for SQL for T-SQL on AWS. ● AWS instance and server’s configuration and Patching. ● Data preparation and Transformation using T-SQL ● ETL preparation and implementation with SSIS and Datawarehousing ● Helped my team reduce 23% cost reduction for S3 payment
Show More

Genzeon | Jan 2022 - Mar 2022

SQL Developer (ssrs)

● Creating and Editing SQL based on the client's requirement, testing, and troubleshooting Code with T-SQL ● Create a new SSIS package for ETL and Edit existing packages using T- SQL. Testing Development environment and moving to stage server, getting Test files and test troubleshooting the packages ● Modifying Data from Loading to the landing page ● Establishing standards for SQL installations, maintenance, tuning, and coding standards. ● Full-time production support for SQL and ETL for different medical-related applications using T-SQL ● Made changes and modifications with Redgate. ● Writing and modifying complex T-SQL code, SAS Code, or Store procedure ● Creating, Modifying, or maintaining T-SQL, SSRS and SAS Reports ● Responding to user requests for new tables, procedures, views, and reports. ● Designing, developing, implementing, and tuning complex enterprise-level reporting database systems ● Supporting the development and maintenance of existing and new application requests ● Providing support for production systems, including rotational on-call support ● Mentor junior developers on Specialty business, database structure, and technical support on complex reporting processes.

American Structurepoint, Inc. | Mar 2019 - Jan 2022

IT Consultant(SQL Server)

● Responsible for logical and physical design toward application and database tuning as well as backups and migrations. ● Major activities include advanced database performance tuning, database design, and capacity planning. ● Establishing standards for SQL installations, maintenance, tuning, and coding standards. ● Convert page-embedded T-SQL queries to secure and optimized Stored Procedures T-SQL. ● Establish data mining algorithms to create a self-learning automated system. ● Create visualization and reports using SSRS and Power BI ● Established and wrote performance tuning guidelines to enhance the quality of a product. ● Maintain the performance of databases using advanced tuning methods and customized scripts. ● Redesigned a thorough backup and recovery strategy for all major production systems. ● Utilizes T-SQL, HTML, CSS, and JavaScript for web development.

Carter Logistics LLC | Dec 2017 - Feb 2019

Database Administrator

● Created and supported new and existing databases and database objects using T-SQL. ● Created Complex ETL Packages using SSIS and T-SQL to extract data from staging tables to partitioned tables with an incremental load. Involved in scheduling and administering SSIS packages. ● Built and implemented MS SQL installations and software upgrades while debugging, monitoring troubleshooting patching, and upgraded database servers. ● Tuning query performance and optimization. ● Wrote parameterized queries for generating tabular reports using expressions, functions, and defining data sources. ● Generated reports using SSRS that was used to send information to vendors, clients, and managers.

My Education

Take a look at my formal education

Bachelor's degree, Engineering and TechnologyMekelle University | 2014
Maricopa Community Colleges

About Me

Dawit Adane

Highly motivated Database Developer with expertise in designing and optimizing large-scale database solutions. Proven track record in collaborating with cross-functional teams to enhance SQL queries and API platform performance. Certified AWS Cloud P

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free