Power Bi Sql Server

Meron Taddesse

**** ****** **** ****, *********, GA 30021 *****.*.********@*****.***

SUMMARY

Highly motivated Power BI/SQL server developer with 5+ years of IT experience having multiple skill set and extensive working experience in Business Intelligence, Software development.

Technologies with expertise in SQL Server development, MSBI stack (TSQL, SSIS, SSAS, SSRS), Power BI for building, deploying, and managing.

Created different visualization in the reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc. Also, using different transformation inside edit query into clean-up the data.

Experience in data visualization and report development techniques

To prepare communication, reports, presentations and other products by operating Microsoft Word, Excel, and PowerPoint.

Experienced in developing Power BI reports and dashboards from multiple data sources.

Explore data in a variety of ways and across multiple visualizations using Power BI.

Expert on creating multiple kind of Power BI Reports and Dashboards.

Created, Maintained & scheduled various reports in Power BI.

Published Power BI reports from Power BI desktop to Power BI service.

Created different visualizations in Power BI according to the requirements.

CERTIFICATIONS

MSBI/Power BI Training Completion

TECHNICAL SKILLS

SQL Server Tools:

SQL Server Management Studio, Enterprise Manager, Query

Analyzer, SQL Profiler, Database Engine Tuning Advisor, BI

Development Studio, SSIS, SSRS, Data Transformation Services,

Power BI, Microsoft Azure.

RDBMS:

SQL Server 2019

Languages:

T-SQL, SQL, DAX

Reporting Tools:

SQL Server Reporting Services 2019, PBI and PBI Services

Data Modeling:

SQL diagrams, PBI, MS Office, Visual studio 2019

Operating Systems

Microsoft Windows/Advanced Server

KEY SKILLS

Microsoft Power BI Desktop

Trouble shooting

Data visualization and modeling

Data query language: SQL, DAX

Data warehousing and analytics

ETL (SSIS, SSRS)

Critical thinking

Eye for detail

Communications skills

Teamwork skills

Problem-solving skill

PROFESSIONAL EXPERIENCE

BUSINESS INTELLIGENCE DEVELOPER June 2022 – Now Epsilon Remote

Interacted with the business users to understand the business requirements and the existing system.

Developed Calculated Measure, Calculated Column and Role level security using DAX.

Collaborated with business users, collected requests, and updated the set of existing BI reports to accommodate business needs.

Provide customized solutions.

To test and troubleshoot whenever needed.

ETL Tools: Experienced in working with industry-leading ETL tools, such as Informatica, Talend, SSIS (SQL Server Integration Services), and DataStage, to streamline data integration processes.

Data Extraction: Proficient in extracting data from various sources such as databases, APIs, flat files, and web services using tools like SQL, Python, and ETL-specific technologies.

Job Scheduling: Developed and managed ETL job scheduling using tools like Control-M, Cron, or Airflow, to automate data integration processes and maintain data consistency.

Troubleshooting and Debugging: Proficient in identifying and resolving issues in ETL workflows, conducting root cause analysis, and implementing preventive measures to enhance system reliability.

Created Drill-down and Drill-through reports to provide interactive representation of data for Data Analysis, Forecasting and business decisions.

Comprehended business requirements in a BI context and developed 15+ data models to convert raw data into actionable insights.

Developed analysis reports and visualizations using DAX functions like table function, aggregation function and iteration functions.

Operationalized business intelligence solutions and conducted advanced analytics to identify opportunities and strengths to meet business goals.

Develop Power BI dashboards and reports and publish reports to Power BI server considering appropriate security level.

Published Power BI reports and made Power BI Dashboards available in Web clients and Mobile apps.

Ownership for Azure SQL server DB deployment& managed the continues integration & continues deployment.

To prepare communication, reports, presentations and other products by operating Microsoft Word, Excel, and Power point.

Meetings with the client to understand their requirements and figure out an approach to solve the problem or issues.

Develop 50+ reports by utilizing knowledge of SQL queries, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).

SQL DEVELOPER/BI DEVELOPER March2018 – June 2022

Epsilon Remote

Oversaw requirements gathering from business analyst for the design & development of BI solutions (ETL).

Played a role in data preparation with experience in bending multiple data connections and creating multiple joins across same and various data sources.

Designed SSIS packages to import data from multiple data sources and transform data between Databases and external data sources using various transformation like Data conversion, File system task, Row count, OLE DB source, OLE DB destination, OLE DB command, Merge join, Lookup, Sort, and Data Flow task.

Multi step zaps Build Zaps that automate several tasks at once.

Completed incremental load with several Data Flow Task and Control Flow Tasks using SSIS and created and implemented master child package using variables in SSIS.

Created complex Stored procedures, Triggers, Functions, Views, Joins, CTE, and Constraints.

Checking the code into TFS (Stored Procedures, Views, Tables, Schema) for the deployment process for the production environment.

Analyze existing SQL queries for performance improvements. Develop procedures and scripts for data migration.

To oversee the clerical support function of an office, business or based on client specific requirements.

Support business requirements and deal with all the CRM needs of the client.

Create Zaps that perform different actions based on if/then logic

Used and created various visualizations in reports like Scatter plot, box plot, Bar graph, waterfall charts, heat maps, geo-maps allowing end users to utilize the full functionality of the dashboard.

Conducted meetings with business stakeholders, clients and director level members for requirement gatherings and presented various solution using best practice. Actively listened to customers, handled concerns quickly and escalated major issues to supervisor.

Education

Kennesaw State University

B.S. in Cybersecurity, May 2020 – Now

Georgia State University – Perimeter College

A.S, August 2013 – December 2015

Top dual enrollment student of 2013, student of the Semester and Dean’s list for consecutive years

Clarkston High School

Highschool Diploma, January 2011 – May 2013

Honor student and Dean’s list for all semesters, best volleyball player of 2012

Contact this candidate