REDIET DEMISSIE

Atlanta, GA

Email: ac9x7v@r.postjobfree.com, Phone: +1-404-***-****

LinkedIn: www.linkedin.com/in/reddemissie

PROFILE:

I am highly motivated Business Intelligence (BI) Professional with more than 4 years of experience developing SQL Server Databases and Microsoft BI Solutions. Extensive experiences with MSBI Tools (SSIS, SSAS & SSRS), Tableau and Power BI

PROFESSIONAL SUMMARY

Experience in analyzing requirements and translate business needs into long-term business intelligence solutions leveraging the MSBI Suites (SSIS, SSAS & SSRS), Tableau and Power BI

Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.

Experience in Installation and Configuration Tableau Desktop/Server, creating users, groups, projects, providing access levels.

Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.

Expertise in creating various SSRS Reports like Charts, Filters, Sub-Reports, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting.

Experiences creating reports with conditional formatting, prompts, filters, case statements and conditions in SSRS

Experiences developing various operational Drill-through and Drill-down reports in SSRS

Experiences Testing and validating the reports developed in SSRS

Scheduling the Reports Weekly and Monthly basis as per the Client Requirements.

Extensive experience using Tableau Server, Tableau Desktop and Tableau Public.

Proficient in Installing, Configuring and Administration of Tableau Server.

Experience creating Tableau Dashboards to replicate existing broken reports and migrated reports from other reporting tools to Tableau and created models, reports in Excel using Pivot Tables.

Experience designing and developing various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations in Tableau.

Experience designing and developing various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Extensive experiences on SQL, PL/SQL Scripting.

Experience in building SSIS packages involving ETL process, extracting data from various heterogeneous sources like flat files, excel files, legacy systems and loading into SQL Server.

Strong understanding in installing MS SQL SERVER on both AWS and Azure environments.

Experienced in Power BI, Power BI Pro, Power BI Mobile, Dashboards

Extensive experiences working on Microsoft Excels :Lookup,PivotTables and power pivot

Extensive experiences working on Microsoft Azure and AWS Cloud services

Good team player with a clear understanding of business needs. TECHNICAL SKILLS

Databases: RDBMS (Oracle, SQL Server, MySQL), Microsoft Azure and AWS Cloud services. ETL Tools: SQL Server Integration Services (SSIS) Reporting and Data Visualization Tools: SQL Server Reporting Services (SSRS), Tableau and Power BI Other Tools: Microsoft Visual studio 2010, 2015, 2017, XML Scripting. Programming Languages: PL/SQL, T-SQL, PowerShell and Python Tableau/SQL Developer January 2019 to present

Co-op Financial Services, Duluth, GA

Responsibilities:

Tableau Developer and SQL developer:

REDIET DEMISSIE

Atlanta, GA

Email: ac9x7v@r.postjobfree.com, Phone: +1-404-***-**** LinkedIn: www.linkedin.com/in/reddemissie

Gathering user requirements analyzed and designed software solution based on the requirements.

Creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.

Extensively used table calculations and Tableau predefined functions for developing Reports.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Restricting data for particular users using Row level security and User filters.

Developing Tableau visualizations and dashboards using Tableau Desktop.

Extracted data from internal data warehouse system to SSRS.

Created ad-hoc reports.

Analyzed data models, data relationships and dependencies for great optimization.

Designed and developed stored procedures, queries, and views necessary to support SSRS report

Working on Tableau workbooks from multiple data sources using Data Blending.

Providing production support for Tableau users.

Create SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Constraint, Temporary Tables and User defined data types and functions using T-SQL.

Develops logically and Physical Data Models by using ER and Normalize or De-Normalize according to business requirement.

Write T-SQL script to use in Joints, Queries and sub-queries to retrieve data from multiple tables.

Review and rewrite scripts and code written by the third party as needed

Create tabular and matrix reports by using SSRS and use stored procedures and functions to create SSRS reports.

Develop and deploy reports using SSRS and configuring the SQL Server Reporting Server

Create SSIS packages to export and import data from CSV files, Text files, Excel spreadsheet and other databases.

Develop and supported packages using variables, master child packages and Execute Package Task in SSIS, executing with bath files and moving along with SQL servers.

Create SSIS package to Import/Export Wizard to perform ETL operations and various containers to do the loop generating..

Develops and maintains T-SQL scripts, utility jobs or implement database maintenance.

Monitors and troubleshoots the performance issues and optimized TSQL queries, stored procedures, functions.

Environment: Tableau, SQL Server Integration Services tools, XML, SSIS, SQL SERVER Reporting Services, and Window server 2010R2, VMware and Microsoft Azure

Tableau/SQL Developer June 2016 to September2018

Digi-safari, Atlanta, GA

Responsibilities:

Tableau Developer:

Gathering user requirements analyzed and designed software solution based on the requirements.

Creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.

Extensively used table calculations and Tableau predefined functions for developing Reports.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Restricting data for particular users using Row level security and User filters.

Developing Tableau visualizations and dashboards using Tableau Desktop.

Extracted data from internal data warehouse system to SSRS.

Created ad-hoc reports.

REDIET DEMISSIE

Atlanta, GA

Email: ac9x7v@r.postjobfree.com, Phone: +1-404-***-**** LinkedIn: www.linkedin.com/in/reddemissie

Analyzed data models, data relationships and dependencies for great optimization.

Designed and developed stored procedures, queries, and views necessary to support SSRS report

Working on Tableau workbooks from multiple data sources using Data Blending.

Providing production support for Tableau users.

SQL Developer:

Create SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Constraint, Temporary Tables and User defined data types and functions using T-SQL.

Develops logically and Physical Data Models by using ER and Normalize or De-Normalize according to business requirement.

Write T-SQL script to use in Joints, Queries and sub-queries to retrieve data from multiple tables.

Maintain, update and monitor the existing database on daily basis functions

Review and rewrite scripts and code written by the third party as needed

Create tabular and matrix reports by using SSRS and use stored procedures and functions to create SSRS reports.

Develop and deploy reports using SSRS and configuring the SQL Server Reporting Server

Create SSIS packages to export and import data from CSV files, Text files, Excel spreadsheet and other databases.

Develop and supported packages using variables, master child packages and Execute Package Task in SSIS, executing with bath files and moving along with SQL servers.

Create SSIS package to Import/Export Wizard to perform ETL operations and various containers to do the loop generating.

Installs and configures MS SQL Server2017/2016/2014/2012/2008R2/2008

Schedule SQL agent jobs to inspect and automate database backup, monitoring database health, disk space, and alerts.

Provide appropriate access to client so that they will have access to their respective needed server and database objects.

Develops and maintains T-SQL scripts, utility jobs or implement database maintenance.

Consulates the designing, testing and implementing disaster recovery plan.

Monitors and troubleshoots the performance issues and optimized TSQL queries, stored procedures, functions.

Environment: Tableau, SQL Server Integration Services tools, XML, SSIS, SQL SERVER Reporting Services, and Window server 2010R2, VMware and Microsoft Azure

Internship at Captive Insurance February 2015 to March 2016 Atlanta, Georgia

Responsibilities:

Create Tables, Stored Procedures, Views, Indexes, Triggers, Constraint, Temporary Tables and User defined data types and functions using T-SQL.

Develops logically and Physical Data Models by using ER and Normalize or De-Normalize according to business requirement.

Write T-SQL script to use in Joints, Queries and sub-queries to retrieve data from multiple tables.

Create tabular and matrix reports by using SSRS and use stored procedures and functions to create SSRS reports.

Develop and deploy reports using SSRS and configuring the SQL Server Reporting Server

Create SSIS packages to export and import data from CSV files, Text files, Excel spreadsheet and other databases.

Develop and supported packages using variables, master child packages and Execute Package Task in SSIS, executing with bath files and moving along with SQL servers.

Create SSIS package to Import/Export Wizard to perform ETL operations and various containers to do the loop generating.

REDIET DEMISSIE

Atlanta, GA

Email: ac9x7v@r.postjobfree.com, Phone: +1-404-***-**** LinkedIn: www.linkedin.com/in/reddemissie

Monitors and troubleshoots the performance issues and optimized TSQL queries, stored procedures, functions.

Environment: SQL Server Integration Services tools, SSIS, SQL SERVER Reporting Services DeKalb Farmer market March 2011 to June 2014

Decatur, Georgia

Responsibilities: Receiving and shipping

Maintains vendor relationships with over 40 vendors

Developed qualified vendors for specialized products

Managed software that tracked orders and created purchase orders from many locations

Processes Accounts Receivable for all vendors with high sales volume

Implemented inventory control and tracking through specialized software

Analyze product lists, vendor lists and management, and bought appropriate and well-priced items to meet company objectives.

Manage communication and negotiation efforts between company management and vendors on various items.

Dire Dawa Minister of Education October 2008 to January 2011 Dire Dawa, Ethiopia

Responsibilities: Record Officer

Maintain and organize school database system

Create and maintain database school by using Microsoft Access

Update weekly student performance record to regional school database system EDUCATION

Bachelor Degree in Geography and Environmental Studies, Addis Ababa University, Ethiopia, 2007

Associate Degree in Applied Science Database Specialist, Georgia Piedmont Technical College, Clarkston, GA, 2017

Diploma in Database Specialist, Georgia Piedmont Technical College, Clarkston, GA, October, 2017 Certificate Earned

Microsoft Network Administrator, Georgia Piedmont Technical College, Clarkston, GA, May 2017

Computer System Application –Micro-link College, Dire Dawa, Ethiopia-August 2010 REDIET DEMISSIE

Atlanta, GA

Email: ac9x7v@r.postjobfree.com, Phone: +1-404-***-**** LinkedIn: www.linkedin.com/in/reddemissie

Contact this candidate