Abiy Mengesha

About Abiy Mengesha

Over 7+ years of IT experience in Database Design, Modelling, Development,Implementation, and application Support.Experience in maintaining one-to-many and many-to-one relationships while moving data between two databases.Skilled in error and event handling: precedence Constraints, Break Points, Checkpoints, and Logging.Supported team in resolving SQL Reporting services and T-SQL related issues andProficient in creating different types of reports such as Cross-Tab, Conditional, Drilldown, Top N, Summary, Form, OLAP, and Sub reports, and formatting them.Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS).Experienced in installing and configuring Reporting Services and assigning permissions to different levels of users in SSRS.Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drill down, and Drill through reports.Used incremental approach in the Workflows and Data Flows to integrate source data into warehouse tables using required transformations.Experience in providing System and User-defined Variables, Logging, and Error handling by using Event Handlers, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

Experience

1. Sql Server Ssis Ssrs Developer

   Capital One

   May 2022 — Present

   Design, develop, and deploy reports in MS SQL Server environment using SSRS and SSIS. Create multiple parameterized stored procedures for report data retrieval. Use SSIS for ETL jobs to extract, clean, transform, and load data into the data warehouse. Create databases and schema objects, including tables, indexes, and constraints. Connect various applications to the database and write functions, stored procedures, and triggers. Design SSIS Packages to transfer data from flat files to SQL Server using BIDS. Utilize SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate,Conditional split, SQL task, Script task, and Send Mail task. Use Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries andenhance database performance. Develop Power BI dashboards and reports for business analytics. Create data models and measures in Power BI to support data visualization. Perform data transformations and cleaning in Power BI to ensure accurate reporting.

Education

• University

  Bachelor of Science - BS