Berhan Hailu Phone 380-***-**** Washington DC email@example.com
Complete understanding of Software Development Lifecycle and core area of experience in validating end-to-end business scenarios of B2B (Business to Business) applications, Enterprise Applications developed expertise in SSIS/SSRS/SSAS.
Good exposure to entire Software Life cycle Phases (Feasibility, System studies, Design, Coding, Testing, Implementation and Maintenance).
Solid skills in designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.
Experience in creating Index, Views, complex Stored Procedures, appropriate user defined functions (UDF) and effective Triggers to facilitate efficient data manipulation and data consistency on Microsoft SQL Server database platform.
Having over 5 years of strong ETL and data integration experience in developing ETL mappings and scripts using Microsoft SSIS.
Extensive experience in MS SQL Server 2008/2008R2/2012/2014 and solid hands on experience in installing, configuring, managing, monitoring and troubleshooting SQL Server in Dev, Testing and Production environments.
Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2012/2014.
Proficient with SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS)/SSDT, SQL Profiler, Performance Monitor.
Experienced with the creation of SSIS packages in Data Extraction, Transforming, and Loading (ETL) from various sources using SQL Server Integration Services, Bulk Insert, and Bulk Copy Program (BCP).
Extensive experience with writing T-SQL scripts, stored procedures, triggers and functions, creating SQL Server Jobs/alerts, and scheduled tasks to automate tasks.
Strong experience with server/database/scripts Performance tuning and optimization.
Strong experience with SQL Server performance monitor and performance tuning, maintenance and SQL Server version upgrade.
Results-Driven with ability to take initiatives and meet deadlines in a fast paced changing environment; Strong analytical and communication skills with the enthusiasm to learn new technologies.
Turbo Federal LLC Feb/2018 – Jun/2020
Position: Mid. MS SQL Server Developer (T-SQL, SSRS, SSIS)
Partner with data and business analysts to refine the business requirements that must be met for building and maintaining data warehouses/marts built on Microsoft SQL Server 2012.
Designed, created and regular tuned of physical database objects (tables, views, indexes) in MS SQL Server 2012 to support normalized and dimensional models.
Worked as a primary T-SQL developer in creating complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
Designed and implemented Modular and Reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Data Balancing & Reconciliation, Exception Handling & Reject Recycling, Surrogate Key Generation & Assignment, Data Lineage Tracking, ETL Auditing, etc.
Used SQL Server Profiler to trace long running queries for optimizing databases.
Provided day to day support of data warehouse and troubleshooting of existing process and procedures.
Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, Oracle etc. to SQL Server using SSIS various features such as multitasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion.
Troubleshot SQL Server related CPU/Memory, I/O using Performance Monitor; Collaborated with system teams and development teams for codes release including MSSQL database changes and patches.
Documented All MSSQL database structures and functionalities. Worked with Auditors and Provided Database related documents.
Worked on 7X24 on-call rotation to support the production environment.
Elan Financial May/2016 – Jan/2018
Position: Jr.MS SQL BI Developer
Involved in gathering requirements, performing source system analysis and development of ETL jobs to migrate data from the source to the target Data Warehouse.
Designed and deployed SSIS packages using various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Slowly Changing Dimension, Aggregate, Conditional Split, and Derived Column Transformations.
Transformed data from MS SQL Server 2008R2 to MS SQL Server 2012 using OLE DB connection by creating various SSIS packages.
Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
Built reports in SSRS for errors generated by SSIS Packages; generated Reports using Data Source Views in Report Builder; created Drill Down, Drill through, linked and sub reports using SSRS.
Generated various type SSRS reports that could be used to send information to different vendors, clients and managers.
Scripted several database maintenance tasks reducing manual processes and related overheads.
Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2008R2 Analysis Services (SSAS) and Reporting service (SSRS).
Designed, developed, tested, and implemented SSRS reports with multi-parameter, chart, drill-down, drill-through, sub-report and interactive sorting capability for business teams.
Generated variety of business reports using SQL Server 2008 SSRS including matrix report, parameter report, and dashboard with charts and drill down function.
Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects. Tuning long-running SQL Queries, Procedures and Functions using SQL Profiler, SQL analyzer, Index tuning wizard.
Work with development teams to make best schema design that balances feature requests with performance concerns.
Coordinate with the team that responds to all system problems in order to reduce or eliminate production problems by analyzing production usage information and using that information to design a better architecture.
Built efficient ETL packages with SSIS to fetch, cleanse and transform data from various types of sources. Develop package configurations dynamically as well as populating variables dynamically.
Increase availability and performance of applications by gathering and analyzing server and database metrics with various monitoring tools.
DATABASE: SQL Server 2008-R2/2012/2014, MS Access
LNGUAGE: T-SQL, C/C++/C#, PowerShell, VB.Net
MS BI STACK: SSRS, SSIS, and SSAS, VSDTS 2012/2013/2015
DEVELOPMENT: Agile/Scrum, Git / Subversion, JIRA, Rally
Relational Database Management System Training
Studying Information Technology