| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateAssefa TsegayeEMAIL AVAILABLEPHONE NUMBER AVAILABLELINKEDIN LINK AVAILABLE Dat-Summary POWER BI, SQL, SSIS and SSRS DEVELOPERExperience Summary:A Microsoft POWER BI Developer,SQL,SSIS,SSRS and with 8 years IT experience: As a professional Database and power BI developer, I have implemented supported both OLTP and OLAP applications, created different database and database objects using SQL Server, created application integration and data transformation using SSIS packages and developed reports using SSRS, TABLEAU and POWER BI. Hands-on experience in Power BI platforms: Power bi desktop, Power Bi Service, power Bi report builder and power bi mobile app. Specializing in Data Warehouse, Power BI Reporting Service, SQL Server, Azure Cloud Computing, ADF (Azure Data Factory), Database and BI developer with SQL Server, Developing Complex SQL query SSMS and Data Modeling, Proficient in relational database modeling (Conceptual, Logical and Physical Modeling) and normalization. Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers .Experience supporting Data Flow transformations:I am a dedicated and results-driven professional with extensive experience in Power BI development, SQL development, and business intelligence with a proven track record of delivering data-driven insights and solutions. I excel in transforming data into actionable insights, optimizing database performance, and automating workflows. Adept at collaborating with cross-functional teams, designing data models, and creating interactive reports, Strong expertise in SQL, data transformation, and visualization tools. My journey in the field of data analytics has allowed me to work on impactful projects, enabling organizations to make informed decisions and drive business growth.Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All. Expertise in enhancing and deploying SSIS packages from development server to production server, Keen understanding of dimensional Star Schema and Snowflakes Schema.I specialize in Microsoft Power BI to create a report using datasets and Power Bi desktop tools to understand the data in depth Experienced in Microsoft Power BI Premium, Power BI Pro, Power Query, Power Pivot, Power BI Service, Power BI Desktop, Power bi report builder, Microsoft Excel Pivot Table, and data models to gather information from multiple sources and deliver information to the end user.Design and develop Power Bi report and dataset gathering, manipulating, and loading data. Building and Designing power bi reports and dashboards, developing data models creating custom visuals and calculations, connecting and integrated data, Designing and creating paginated reports, configuring data sources, building and designing reports layouts creating parameters and complex calculations.Develop and deploy power bi solutions to support business processes and decision making, stay up-to-date with the latest power bi features and best practices and incorporate them into development processes. Adhere to compliance procedure and internal/operational risk controls in accordance with all applicable regulatory standards and policies ExperienceDeveloped and maintained interactive Power BI reports for the organization, leveraging Sales force data to provide key insights into business performance. Designed custom dashboards integrating Sales force data to track sales metrics, customer behavior, and financial outcomes, enabling real-time decision-making.Gecom Software LLC and Voyatek VA October, 31/2022 present ( 2 years)Role: Power BI Developer. Data Integration & Modeling: Experience: Connecting Power BI to multiple data sources, such as SQL Server, CSV files, or APIs related to police data (e.g., arrest records, incident reports).Example: You might create a data model by pulling data on criminal records from multiple police databases, relating it through common fields (like case number or officer ID) for use in reports.. DAX (Data Analysis Expressions):Experience: Writing DAX functions to perform calculations and create measures or calculated columns.Example: Using DAX to calculate the average response time of officers for different types of incidents and displaying this in a report.. Advanced Query Writing (Power Query):Experience: Querying large datasets using Power Query for transformation and cleaning, as well as writing advanced SQL queries to retrieve data from relational databases. Example: Writing an SQL query to filter arrest records based on date, crime severity, or officer department, then transforming the data in Power Query to clean inconsistencies before reporting.Report & Dashboard Development: Experience: Designing interactive reports and dashboards for visualizing crime data, police performance metrics, or other KPIs (Key Performance Indicators).Example: Building a crime heat map to show the distribution of offenses in different regions, along with drill-down capabilities for specific crime types.Troubleshooting: Experience: Identifying and resolving issues related to data accuracy, performance (slow reports), and misconfigured data models. Example: Troubleshooting slow report performance by analyzing inefficient .DAX expressions or optimizing SQL queries to reduce load times when generating reports.Performance Optimization: Experience: Optimizing Power BI performance by query folding, reducing visuals on the page, and avoiding expensive DAX functions. Example: If a report displaying monthly arrest trends runs slow, you might optimize the underlying query or reduce the complexity of the visuals by using simpler DAX functions.. Collaboration with Team members :Light house mortgage HAUPPAUGE, NY, 2021 February-October/28/2022Role: Power bi developer and sql developerWorked closely with Business Analyst and all team within the organization to understand business processes.Developed complex SQL queries, stored procedures and views to be used in Power BI reports as well as for ETL workflows and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor. Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.Designed, reviewed, and created primary objects like views, indexes, stored procedures, functions, and triggers based on logical design models, user requirements and physical constraintRegularly monitored SQL Server performance, analyzing logs to ensure optimal database functionality.Troubleshot and resolved SQL Server issues, including concurrency problems such as blocking, locking, and deadlocks, using tools like Activity Monitor.Diagnosed and addressed SQL Agent job execution failures to ensure seamless job scheduling and processing. Used the tabular model cubes as the source in Power BI to visualize the data.Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard. Created interactive reports customized for the business using Power BI Desktop.Installed and configured and maintained Power BI Report Service, Worked on a project in the migration of Tableau reports to Power Bi report server.Manage, monitor, and improve Power BI environment including ongoing changes and active product backlog, imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.Cleaning up datasets using Marge queries, append queries, and sort data column to properly fit our reports. Created Dax Queries to generated computed columns in Power BI, also applied DAX calculated measures and columns.Design and develop Power Bi report and dataset gathering, manipulating, and loading data.Building and Designing power bi reports and dashboards, developing data models creating custom visuals and calculations, connecting and integrated data.Designing and creating paginated reports, configuring data sources, building and designing reports layouts creating parameters and complex calculations.Generated computed tables in Power BI by using DaxExperience with AWS services, including data storage, computing, and integration for cloud-based analytics and business intelligence solutions like power bi.Involved in creating new stored procedures and optimizing existing queries and stored procedures. Created Azure Blob Storage for Import/Export data to/from .CSV File also access and analyze dataset and KPIs to create reports.Used Power BI to created visualization tools intended for diverse users.Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.Explore data in a variety of ways and across multiple visualizations using Power BI.Used Power BI Gateways to keep the dashboards and reports up to date.Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.Published reports and dashboards using Power BI.Highmark Health Pittsburgh, PA Jul 2018 - Jan 2021Role: SQL/ETL/Power BI DeveloperWorked closely with SMEs end users/internal customers to understand project/requirement scopeWorked with Business Systems Analysts to fine tune specifications by ensuring that all database constraints are satisfied and perform impact analysis of changesInvolved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to validate the solution met requirements, and prepared documentation for same.Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. (Used CTE, temporary tables, user defined table types in codes developed)Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2014/2017.Experience in Power BI and with different BI component like (Oracle, SQL, SSIS, SSRS, SSAS).Manage, monitor, and improve Power BI environment including ongoing changes and active product backlog.Experience working with Snowflake for data warehousing, including querying, data modeling, and integration with business intelligence tools like Power BI.Experience in automating tasks and work flows between applications and services using Microsoft Power Automate tool.Imported data from Oracle DB, SQL Server DB and Azure SQL DB to Power BI to generate reports. Created Dax Queries to generate computed columns in Power BI, also applied DAX calculated measures and columns.Created Azure Blob Storage for Import/Export data to/from .CSV File, also assess and analyze dataset and KPIs to create reports.Used Power BI to create visualization tools intended for diverse users.Experience with AWS services, including data storage, computing, and integration for cloud-based analytics and business intelligence solutions like power bi.Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.Developed and maintained interactive Power BI reports for the organization, leveraging Sales force data to provide key insights into business performance. Designed custom dashboards integrating Sales force data to track sales metrics, customer behavior, and financial outcomes, enabling real-time decision-making.EAGLE BANK Bethesda, MD Jul 2015 - NOVEMBER 2017Role: Business Intelligence Developer (SQL/SSIS/SSRS/SSAS)Worked closely with internal and external users to understanding and gathering business requirements. Designed a complex SSIS package for data transfer from three different firm sources to a single destination like SQL Server 2005.Designed, reviewed, and created primary objects like views, indexes, stored procedures, functions, and triggers based on logical design models, user requirements and physical constraintRegularly monitored SQL server, analyzing the logs, troubleshooting SQL Server problems such as Concurrency problems (blocks, locks, deadlocks, activity monitor), and SQL Agent job execution problems.Administered the MS SQL Server security by enforcing security policy, creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.Implemented a DB maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space) and running, SQL Tracer and SQL Profiler.Enhanced performance by running index tuning wizard for creating, rebuilding and reorganizing indexes on various tables.Used Merge replication to update the publisher from the subscribers as well as from the subscriber to the publisher periodically.Log shipping database for reporting server within the firms latency objective.Mirrored one of our critical databases with zero latency/synchronized- with witness/for critical Database on SQL 2008.Part of the team which configured Always On with availability group for one of our critical servers on SQL 2012 that was installed via nodes on WSFC (Window Server Failover cluster).Performed full, differential and transaction log backups.Designed Extraction Transformation and Loading (ETL) process using SSIS to extract data from flat files, excel files and SQL server database.Used the SQL Server profiler to capture and store the execution plan.Provided weekly, monthly, yearly quality control reports for work orders, service requests.Represent reports in different forms using graphs, charts, tabular, area and pie charts as required. Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS). Worked with XML configuration files and variables for deploying SSIS packages into various environments.- S Education:Bachelor's Degree in Information Technology (IT)Skills:- Power BI Development- SQL Development- Data Analysis- Data Modeling- ETL Processes- Business Intelligence- Database Optimization- Data Visualization- DAX Queries- Report Generation- Database Administration- Security Policies- Data Integration-business analysis-charts-customer relations-data transfer-Etc.QL Development- Data Analysis- Data Modeling- ETL Processes- Business Intelligence- Database Optimization- Data Visualization- DAX Queries- Microsoft Power Automate- Report Generation- Database Administration- Index Tuning- Security PoliciesData Integration |
