Sql Server Power Bi
Resume:
Eden Mellese
SQL/Power BI Developer/Data Analyst
*********@*****.***
PROFESSIONAL SUMMARY:
US Citizen with 5+ years of experience in SQL Development, MS SQL Server Administration, Suites of product like SSRS, SSAS and SSIS of MS SQL Server 2019/2017/2016/2014/2012.
Experience in configuring Integration Services packages, SSIS designer and other package execution utilities for performing ETL operations.
Experienced in BI Solutions (ETL & Reporting) utilizing SQL Server and Oracle databases, SSIS, SSAS, and SSRS in OLTP/OLAP/BI environments.
Creating reports with Power BI desktop, Report Builder using DAX. Experience working with Multi-Dimensional Expression (MDX).
Knowledge of Software Development lifecycle, DB design, RDBMS, data warehousing and data modeling concept.
Some knowledge about Teradata and Informatica data handling/processing.
Ability to work in Azure and AWS cloud.
Expertise in working with OLTP/OLAP/BI environments.
Expert in ETL (SSIS) and DTS packages to perform data transfer from different server locations and heterogeneous sources like Oracle DB, Excel file, CSV, XML, MS Word and Text Format Data.
Experience in creating various SSIS packages, troubleshoot errors and creating alerts using Send Mail tasks.
Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and power pivot.
Experience in designing report using SQL Server Reporting Services, generated drill down report, parameterized report, linked report, sub reports, matrix dynamic and filter, charts in SSRS.
Experience in using multiple transformation provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, Merge, Merge Join, Union All and Slowly Changing Dimension.
Expert in presenting multi-platform data visualization like pie/bar/graph chart and Donut Chart, adding slicer to reports.
Designing SSAS cube, writing MDX Queries, used Partition to manage and store the data. Deploying and processing SSAS cube.
Experienced in developing OLAP Cubes, Dimensions using SQL Server Analysis Services (SSAS)
Good SQL Server Administration skills, including backup-recovery, database maintenance, database version upgrade. Working knowledge about user authentication, user/role creation, Database creation, Tables, Indexes and Partitions.
Experience in creating Data Marts, Operational Data Store (ODS), OLAP and Dimensional Data Modeling for FACT and Dimension Tables using Analysis Services.
Proficient in Microsoft Business Intelligence Suite (Power Pivot, Power View, Power Query, Power Maps, Power BI Desktop, Power BI Service, Power BI Mobile App).
Experience in using Tableau and Power BI to generate various reports.
Experience in implementing the Indexes such as clustered index, non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
Experience in writing Sub-queries, Joins, T-SQL queries to create database objects and to simplify complex queries involving different tables, and to create relationship between tables using foreign key and primary key.
Experience in Database/Data Mart Design, stored procedures, Triggers, Indexes, Data Cleansing/Data Mining.
Experience working with Agile and Waterfall methodologies in SDLC
Able to work collaboratively, quickly understanding the system architecture and business needs towards achieving goals.
Excellent communication and management skills. Quick learner and excellent team player, ability to complete task on time.
Technical Skills:
Databases
MS SQL Server2016,2014,2012,2008, MS-Access, Oracle, MySQL, DB2
Programming language
T-SQL, PL/SQL, C, Python, C++, .Net, R, vb.net
BI Tools
MSBI Stack (SSIS, SSRS, SSAS), Microsoft Visio, SQL Server Management Studio
Reporting Tool
SQL Server Reporting Services (SSRS), MS Excel, Power BI, Tableau Reporting Tool, Report Builder
ETL Tool
SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Informatica
Operating System
Windows, Unix/Linux
PROFESSIONAL EXPERIENCE:
Client: AVER, Washington, DC Mar 2024 – Present
Role: Power BI/SSIS/SSRS Developer
Responsibilities:
Publishing reports and dashboards using Power BI.
Supporting and creating KPI, calculating Measures and Groups and MDX queries.
Configuring SSIS packages for run time parameters and config files.
Extensively involved in SSAS storage and partitions, aggregations, calculation of queries with MDX, Data Mining Models, Tabular developing reports using MDX and SQL.
Used SSIS for Extracting and Merging of data from multiple different sources to single target.
Scheduling Jobs to run SSIS Packages in the night feed to DSS for fresh day data.
Scripting using SSIS packages for data cleansing, encrypting and decrypting sensitive information.
Created SSIS packages to automate different FTP’s files and emailing to different clients.
Generated reports from SQL Server Database and OLAP data warehousing.
Deployed Reports to Report Manager and Troubleshooting for any errors during in execution.
Scheduled the Reports to run on the daily and weekly basis in Report Manager and email them to the directors and analyst to review in Excel sheet.
Created Sub-Report, Matrix Report Tablix Report Drill Down Report and Charts using SSRS.
Deployed and subscribe Reports using SSRS to generate all daily, weekly and monthly reports.
Designed a Power BI Data model with multiple Facts and Dimension Tables based on the requirement.
Designed and Implemented analytics solutions using Power BI Dashboard and Reports.
Based on the business requirement written complex T-SQL queries to perform data and graph validation to make sure that the test results are matched. Creating SQL statements for building Power BI reports.
Experience working with Multi-Dimensional Expression (MDX), functions and statement to create complex calculations.
Created Power BI Reports and Dashboards with various Slicers, Visualizations enhancing data exploration.
Created Power BI, Power Pivot for data analysis, and Power View, Power Map for visualization.
Created Drill Down Report, Summary Report, Sub Report and Parameterized Reports in SSRS.
Developed calculated columns and measures using DAX in power BI
Client: TALENT GROUPS, Houston, TX Dec 2023 – Apr2024
Role: SQL/ETL Developer
Responsibilities:
Designed ETL Packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kind of SSIS transformation.
Modified the existing SSIS packages to improve the performance of data loading.
Used various SSIS task such as Conditional split, Derived column, data validation checks etc. during staging, before loading the data into various sources.
Successfully migrated SSIS packages from development to test and production environment using SSIS Configuration files and development wizard.
Configured and Maintained Report Manager and Report Server for SSRS.
Generated ad-hoc reports using MS SQL Server Reporting Services.
Created user defined hierarchy in dimensions.
Moved data from old legacy system to new sources based on the given requirement.
Design and Implemented database application using MS SQL Server 2012 and Business Intelligence (BI) tools to support transaction and business decision making.
Evaluated database performance and performed maintenance duties such as tuning, backup and restoration.
Developed script to find missing Indexes, unused Indexes and duplicate indexes and created appropriate indexes to optimize slow running queries
Professional Experience:
Client: Insight Systems Corporation, Arlington, VA May 2023 – Dec 2023
Role: SQL BI/Power BI Developer
Responsibilities:
Developed and maintained ETL/ELT pipelines using Informatica PowerCenter, NiFi, Talend, and Apache Spark to ensure efficient data extraction, transformation, and loading.
Created Power BI Reports and Dashboards with various Slicers, Visualizations enhancing data exploration.
Created Power BI, Power Pivot for data analysis, and Power View, Power Map for visualization.
Configured ETL job scheduling and automation using Universal Automation Center (UAC), ensuring reliable and consistent data processing.
Maintained operational reports (dashboards, charts, KPI-based scorecards) using SQL Server Reporting Services (SSRS), Power BI, and Report Builder.
Developed and optimized complex SQL queries and data transformations across BigQuery, Redshift, and Snowflake platforms, ensuring efficient data retrieval and analysis in diverse cloud-based data warehouses.
data environments.
Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.
Installing and monitoring PostgreSQL database using the standard monitoring tools
Installing and Configuring PostgreSQL from source or packages on Linux machines.
Created Azure SQL database, performed monitoring and restoring of Azure SQL database. Performed migration of Microsoft SQL server to Azure SQL database.
Experienced in developing and manipulating complex queries, stored procedures, functions and triggers in Oracle, SQL Server, Teradata, and other databases.
Performed ETL Transformation activities in Data Factory and built pipelines and loaded to Azure SQL DB.
Performed database administrator responsibilities such as storage management, indexing, backups, replication, and monitoring production jobs.
Designed and implemented complex ETL pipelines using Azure Data Factory to efficiently ingest and transform data from multiple sources into Azure SQL Database.
Utilized DataStage for efficient data integration, ensuring real-time data availability.
Built and managed Data Pipelines and Jobs with Azure Data Factory to streamline data processing.
Leveraged Databricks for advanced data analytics and processing tasks, using Hadoop, HDFS, and Hive for big data storage and processing.
Creating Stored Procedure and Scheduled them in Azure Environment.
Building the pipelines to copy the data from source to destination in Azure Data Factory
Implemented data partitioning on Big data using Azure Databricks -Extract Transform and Load (ETL) data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics.
Experience on Migrating SQL database to Azure data Lake, Azure Data Lake Analytics, Azure SQL Database, Data Bricks and Azure SQL Data warehouse and Controlling and granting database access and Migrating On premise databases to Azure Data lake store using Azure Data factory.
Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks
Migrating data from different sources to the destination with the halp of ADF.
Expertise in REST web services and technologies such as Flask, JavaScript, XML, and JSON, facilitating seamless data integrations with external systems and applications.
Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files and scheduled SSIS packages using SQL Server Agent, Jams.
Client: Sentara Healthcare, Norfolk, VA Jun 2019 – May2023
Role: SQL/SSIS/SSRS Developer
Responsibilities:
Created SSIS packages to perform filtering operations and to import the data on daily basis from the legacy data sources to SQL Server 2016.
Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.
Installing and monitoring PostgreSQL database using the standard monitoring tools
Installing and Configuring PostgreSQL from source or packages on Linux machines.
Creating complex SQL scripts to transform legacy data in staging area using SSIS packages.
Used SSIS for Extracting and Merging of data from different source to single source.
Scripting using SSIS packages for data cleansing, encrypting and decrypting sensitive information.
Created SSIS packages to automate different FTP’s files and emailing to different clients.
Created SSIS packages using various Transformation to generate underlying data for the report and to export the cleaned data from Excel, CSV, Flat file and MS Access to data warehouse.
Generated reports from SQL Server Database and OLAP data warehousing.
Deployed Reports to Report Manager and Troubleshooting for any errors during in execution.
Scheduled the Reports to run on the daily and weekly basis in Report Manager and email them to the directors and analyst to review in Excel sheet.
Created Sub-Report, Matrix Report Tablix Report Drill Down Report and Charts using SSRS.
Deployed and subscribe Reports using SSRS to generate all daily, weekly and monthly reports.
Designed a Power BI Data model with multiple Facts and Dimension Tables based on the requirement.
Created and Modified database structure using Data Definition Language (DDL) statements to create tables, indexes, store procedures, functions, views and triggers
Analyzing the data and performing ETL in setting up SSIS packages for data integration
Created trace in SQL Profiler and used Database engine tuning advisor for performance tuning on scripts and stores procedures.
Used various SSIS task such as Conditional split, Derived column, data validation checks etc. during staging, before loading the data into various sources.
Implemented data partitioning on Big data using Azure Databricks-Extract Transform and Load (ETL) data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics.
Experience on Migrating SQL database to Azure data Lake, Azure Data Lake Analytics, Azure SQL Database, Data Bricks and Azure SQL Data warehouse and Controlling and granting database access and Migrating On premise databases to Azure Data lake store using Azure Data factory.
Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks.
Evaluated database performance and performed maintenance duties such as tuning, backup and restoration.
Experienced in writing complex DAX functions in Power BI and Power Pivot
Designed and Implemented analytics solutions using Power BI Dashboard and Reports.
Participated in testing during the UAT (QA Testing). Mentored and monitored team development and status.
Drop and recreate Index on the DSS System while migration data.
Based on the business requirement written complex T-SQL queries to perform data and graph validation to make sure that the test results are matched.
Created trace in SQL Profiler and used Data base engine tuning advisor for performance tuning on scripts and stores procedures.
Using Database management Administered and maintained databases like (SQL Server, Oracle & MySQL).
Work closely with IT and the Business group to understand business reporting requirements and analyze logical model and develop subject matter expertise in a short time.
Database
Education:
Bachelors Degree from Haramaya University
Contact this candidate