W

Wegahta Hagos

About

Detail

Data developer
Washington, District of Columbia, United States
Contact Wegahta regarding: 
work
Full-time jobs
Starting at USD110k/year
groups
Networking

Timeline

work
Job

Résumé

Jobs verified_user 0% verified
  • Humana
    SQL/Power BI Developer/Analyst
    Humana
    Jul 2021 - Dec 2023 (2 years 6 months)
    • Collaborated with Business Systems Analysts to refine specifications, ensuring compliance with database constraints and performing impact analysis of changes.
    • Developed logical and physical data models, created test cases, and prepared documentation for new and existing solutions.
    • Proficient in creating complex T-SQL database objects, including Stored Procedures, Triggers, Functions, Indexes, Tables, and Views, with advanced techniques like CTE and temporary tables.
    • Conducted T-SQL tuning and query optimization for reports, utilizing tools like MS SQL Profiler, Index Tuning Wizard, and SQL Query Analyzer in MS SQL Server 2012/2017.
    • Experience in Power BI and various BI components, including Oracle, SQL, SSI
  • NCR Corporation
    Data Engineer| Developer
    NCR Corporation
    Apr 2017 - Jun 2021 (4 years 3 months)
    • Collaborated with Business Systems Analysts to refine specifications, ensuring compliance with database constraints and performing impact analysis of changes.
    • Designed and implemented T-SQL database objects, including Tables, DML, DDL, Views, Stored Procedures, Functions, Joins, and Indexes based on functional specifications.
    • Developed complex T-SQL Queries and SQL Scripts for efficient data loading, considering intricate business rules.
    • Designed and implemented ETL strategies for extracting and transforming data from diverse sources, such as SQL Server, Oracle, and flat files, before loading it into the destination database.
    • Utilized Talend ETL tool to create mappings for populating data into dimensions an
  • KeyBank
    MSBI/SQL Developer
    KeyBank
    Oct 2015 - Mar 2017 (1 year 6 months)
    • Gathered client requirements, conducted data analysis, and designed logical and physical data models using Erwin, implementing them in SQL Server.
    • Translated client requirements into reporting objects, including scorecards, dashboards, and reports.
    • Defined reporting and alerting requirements and worked with large datasets for meaningful data analysis.
    • Communicated data decisions to ensure understanding across business and technology groups.
    • Prepared documentation for data structures and processes.
    • Analyzed multiple datasets, identifying patterns.
    • Wrote custom T-SQL stored procedures and triggers for performance improvement, referential integrity, and additional application functionality.
Education verified_user 0% verified
  • B
    Bachelor of Science in Information Technology