Post Job Free
Sign in

Data Developer

Location:
Aurora, CO
Posted:
March 12, 2020

Contact this candidate

Resume:

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)



Contact this candidate