Siraw Tom
Email: **********@*****.*** Tel. (***) 306 –1721 USA
SQL BI Developer (SSIS/SSRS/Power BI/SSAS), ETL Developer/Data Warehouse/DBA Skills
Databases: MS SQL Server 2008/2008R2/2012/2014/2016/2017/2019
ETL Tools: Data transformation services (DTS), SQL Server Migration Assistant (SSMA), SQL Server Integration Services (SSIS)
Reporting Tools: Power BI, SQL Server Reporting Services (SSRS), Report Builder 2.0/3.0
Data Mining Tools: SQL Server Analysis Services (SSAS)
Database Tools: SQL Profiler, Database Engine Tuning Advisor, SSMS, Activity monitor, Performance monitor, SQL Agents
Language: Transact SQL (T-SQL)
Operating Systems: Windows 7/8/10, Windows 98/2000/XP, Linux, MS-DOS
Version Control Tools: Git/GitHub
Project Management Methodologies: Agile and JIRA
Statistical Tools & Models: SPSS, R, Linear Regression, Binary Logistic Regression, Chi-Square test, T-test, and Independent T-test analysis
MS-Office: MS-Word, MS-Excel, MS-Access, Outlook, PowerPoint Professional Summary:
Over 7+ years of experience as SQL/BI Developer in Database Design, Development, ETL Implementations, Designing, Developing and Support of OLAP/OLTP/ Data Warehousing system and visualizing reports using MS SQL, Microsoft Visual Studio (SSIS, SSAS, SSRS) and Power BI.
Strong knowledge and experience in various sectors such as healthcare, HR, Social Services, and finance and banking
Advanced experience with end-to-end business intelligence solutions from requirements and specification writing; ETL design, testing, and deployment of packages; data visualization and development of dashboard platforms; scheduled delivery and automated data refresh; and system testing, optimization and performance analysis
Hands-on experience in using SQL Server and T-SQL for developing Stored Procedure, Tables, Triggers, User Defined Functions, Indexes and SQL Join
Experienced with Full life cycle of ETL development to address business needs including design, mappings, data transformations, scheduling, and testing
Advanced knowledge of Power BI Desktop, Power BI Services, Power Query, Power View, Data Management Gateway, Design and Management of dashboards
Advanced knowledge of SSRS reporting platforms such as sub-reports, matrix, drill-down and drill through reports
Experienced with SSAS, building, deploying and processing Cubes, data sources, data source views
Demonstrated knowledge of Data Warehouse architecture and concepts, star schema, snowflake schema, data normalization and Denormalization, Data Mart, staging table
Extensively uses SQL native tools like Index tuning wizard, Database tuning advisor (DTA), SQL profiler, Performance monitor, Activity monitor, Event viewer, Dynamic management views and Dynamic management functions for monitoring and performance tuning/troubleshooting
Demonstrated knowledge and experience with SQL Server Installation, Configuration, Migration and administration
2 P a g e
Significant experience in Conceptual, Logical and Physical Modeling
Extensive experience in Normalization and Denormalization
Experience in publishing reports to Power BI Services, embedded Power BI reports into SharePoint Sites and configured Power BI Workspaces
Experience in managing Power BI Subscription and managing users to access Power BI Reports
Experience in writing T-SQL query in populating Dimension and Fact tables in Data Warehouse from staging tables using Incremental approach
Experience in designing & implementing Database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
Experience working with business owners to gather and define requirements for report generation
Proficient in the use of Data Analytics Expressions (DAX) and Power Query
Experience in Developing high performing, reliable, and scalable Self Service (SS) BI solutions
Aptitude to learn new subjects and emerging technologies and articulate their business implication
Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box. PROFESSIONAL EXPERIENCE:
Cleveland Clinic July 2018 – Present
BI Developer / SQL Developer Cleveland, OH
Implement the full cycle of power BI visualizations such as extracting and transforming data in Power Query, designing various visualizations in Power BI desktop, publishing reports into Power BI Services, and developing and managing dashboards
Automate integration and reporting processes
Created dashboards for tracking live data
Interact with end users, research and identify business requirements and translate business needs to technical specifications
Create, maintain and improve databases, schema objects, SQL queries, stored procedures, indexes, functions and views for data migration and ad-hoc reporting
Use Informatica PowerCenter Designer analyzed the source data to extract and transform from various source systems (Oracle, SQL Server, and Flat Files)
Clean and transform data in Power BI Query editor
Migrated old data source platforms, built data mapping and integrated the ETL platforms with the target database
Build calculated fields in DAX (Data Analysis Expression) for basic reports and analysis
Develop ETL workflows and mappings to extract, transform, and load data into target environments, in line with current data loading architecture or on an ad-hoc basis
Design, code, test, monitor, troubleshoot and improve ETL processes and reporting platforms
Implemented Slowly Changing Dimensions to incrementally load dimension tables to the target Data Warehouse
Employed temporal table to track changes overtime for reporting and analysis purposes
Presents project progress and reports to internal staffs and stakeholders
Built and reorganize indexes for performance enhancements
Collaborate with IT professionals to audit user access to SQL Server databases based on security standard methodologies.
Environment: MS SQL Server 2016/2012, Power BI Desktop, Power BI Services, SQL Profiler, SSIS, SSRS, SSAS, SSMA, SQL Server Management Studio, Visual Studio, Database Engine Tuning Advisor, SharePoint
3 P a g e
Bellco Credit Union January 2017– May 2018
BI Developer / SQL Developer Greenwood Village, CO
Design and develop commercial data warehouse that supports analysis and reporting of banking services, sales, and marketing activities
Design and develop various BI reporting and visualization solutions including drill through and drill down reports, Matrix, Sub-report, Key Performance Indicator (KPI), Key Influence, Combo Chart, Ribbon chart
Generated pre-designed, dynamic and ad-hoc reports for end-users
Build, troubleshoot, modify complex and efficient queries, views, and stored procedures
Pulling and aggregating data from multiple disparate sources
Provide solutions for data cleaning and transformation
Develop and support the ETL process to extract, transform and load data from and to various heterogeneous sources and destinations
Employed incremental and full loading to populate dimension and fact tables into the Data Warehouse
Review ETL processes for accuracy, maintainability and performance prior to implementation
Create supporting documentation for new ETL processes
Get data from multiple sources, and review and build data model and relationships among multiple tables
Design and develop user-friendly dynamic reports and dashboard using parameter, expression, conditional formatting, and grouping to reduce ongoing ad hoc requests
Design appropriate BI solutions to measure trends and performances
Built documentation package for human resources and managers to track and update project progress and other changing attributes
Gather and translate requirements from end-users to develop and maintain BI reporting platforms
Create written communication materials summarizing findings and support recommendations Environment: MS SQL Server 2014/2012, SSIS, SSRS, Visual Studio, SSAS, SSMA, Business object, T- SQL, ER-Studio, TFS, INOTAS, JIRA, Office365, Tableau 10.5/10.2, Database Engine Tuning Advisor, SharePoint
Cigna October 2015 – December 2016
BI Developer / SQL Developer Philadelphia, PA
Assess and document data requirements and client-specific requirements to develop user- friendly BI solutions - reports, dashboards, and decision aids
Design, develop, and maintain T-SQL - stored procedures, joins, complex sub-queries for ad- hoc data retrieval and management
Develops logical and physical data flow models for ETL applications
Build, test and maintain automated ETL processes to ensure data accuracy and integrity
Adapt and optimize ETL processes to accommodate changes in source systems and new business user requirements
Build, test, and manage BI standard reporting templates and dashboards for internal and external use
Build packages recording and updating historical attributes of employees using slowly changing dimension
Configure percentage sampling transformation to identify sample respondents for survey research
Employs merge join transformation to produce ad-hoc reporting of client demography, procedures, treatment history and cost of treatment
Applied lookup and cache transformation and use reference table to populate missing columns into Data Warehouse
Transfer big data to and from the remote computer through File Transfer Protocol
Troubleshoot data integration issues and debug reasons for ETL failure
Build SSISDB Catalog and create parameters and environments for flexible project deployment 4 P a g e
Undertakes regular data mapping, parsing and ETL scanning
Create custom reports for requested projects, and modify existing queries and reports in Power BI desktop and SSRS
Managing snapshot and caching for SSRS performance
Implemented security policies for SSRS reports
Documentation of data environment and solutions to support end-users and analysts
Communicate internal business and technical users to capture business and technical requirements and specifications used to construct and deliver reports, dashboards, and analytics
Create, update and test current OLAP data cubes
Environment: MS SQL Server 2012/2008/2008R2, MSSQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), T-SQL, Erwin Data Designer, Informatica PowerCenter, Windows XP.
Commercial Bank of Ethiopia September 2011– August 2014 SQL DEVELOPER/SQL DATABASE ADMINISTRATOR ADDIS ABABA, ETHIOPIA
Creating and modifying database objects -databases, tables, indexes, views, stored procedures, triggers, functions
Participated in logical and physical data design and development of data warehouse
Compile complex data sets from a variety of sources
Developing and optimizing SQL queries, DDL /DML scripts, stored procedures, views, and functions
Create and execute ad-hoc database queries and produce reports upon request from business stakeholders
Design, build, test, and execute ETL packages to transfer transactional data into a data mart for reporting and analysis consumptions
Troubleshoot and resolve ETL failures and performance issues
Reviewing ETL workflows for performance, data consistency, and integrity
Manage reporting server and maintain end user access to reports and dashboards
Deploy SSIS packages; and performing code review and defect analysis
Built for each loop container together with file system task to copy, move, create, delete folders or file, and rename files and set attributes
Build project and package parameters for flexible and easy deployment and runtime operations
Work with stakeholders to understand the business and functional requirements to develop and architect Data Warehouse platforms
Translate business needs to technical specifications
Installing, configuring, managing, monitoring SQL Servers
Import/Export files of different sources
Manage and enforce database security by creating and managing logins, user privileges and roles and efficient resource management
Automate and monitor maintenance plan jobs in SQL Server agent and task scheduler: such as shrinking database, backup database, index rebuilding, creating filtered indexes, index reorganizing, cleaning up, and updating statistics
Reorganizing and/or rebuilding indexes to reduce disk space and enhance server performance
Enhance SQL Server Databases performance by creating alias, indexes, views, triggers and Stored Procedures
Analyzing query plans, troubleshoot Locks, Dead Locks using both SQL Profiler, Spotlight and DMVs and DMFs, and handling the isolation level and concurrency effects
Performed data partitioning for efficient management of database tables and indexes Environment: MS SQL Server 2012/2008R2/2008, SSIS, SSRS, SQL Profiler EDUCATION:
University of Antwerp
Master of Science (MSc)