Efrata Legesse

6+ years of Experience in various domains like Insurance, Financial and Retail with expertise in providing ETL/Business Intelligence solutions using Microsoft components (SSMS,SSIS and SSRS), Database Design, Development and Implementation in SQL Server 2014/2016/2019/2022. Experience using complex SQL queries, SQL Scripts to perform efficient data load based on complex business rules and produced results for users and T-SQL Programming (Stored Procedures, Cursors, Functions, and Triggers) Strong technical knowledge in MS SQL Server development including DTS, Performance tuning, Reporting, Designing logical/physical databases and Trouble shooting. Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user defined functions, views, user profiles, data dictionaries, data integrity, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency. Working on SSIS various tasks such as Control Flow (Execute SQL task, for each loop container, Data Flow task, File System) and transformations such as FTP Task, Aggregate, Sort, Lookup, Fuzzy Lookup, SCD (Slowly Changing Dimension), Merge join multicast, conditional split, derived column etc. Supported team in resolving SQL Server Reporting Services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them. In-depth knowledge of Transact-SQL (Data Definition Language, Data Manipulation language). Strong experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. Extensive experience in ETL design/development using MS DTS and SSIS including data extraction and transformation between multiple data sources (Oracle, MS Access, and MS Excel). Experience in Creating and Deployment and Administration of SSIS and SSRS packages. Experienced in report generation using SQL Server Reporting Services (SSRS) and Excel spreadsheet lately using SQL Server 2014/2016/2019. Conducted Data Analysis and did Data Modeling and Created the ER diagrams using Logical Schema and Star Schema. Experience in implementing different types of Replication models like Snapshot, Merge and Transactional. Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and excellent interpersonal and team work skills.