Data Developer
Resume:
REDIET DEMISSIE
Atlanta, GA
Email: ***********@*****.***, 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: ***********@*****.***, 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: ***********@*****.***, 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: ***********@*****.***, 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: ***********@*****.***, Phone: +1-404-***-**** LinkedIn: www.linkedin.com/in/reddemissie
Contact this candidate