Eden Tesfyae

SQL BI Power BI Developer

Email:ad2x7v@r.postjobfree.com Phone: 202-***-****

Professional Summary:

Experienced SQL/MSBI/Power BI Developer with 7+ years of expertise supporting OLTP and OLAP Applications. Including creating different database objects like tables, stored procedures, views, and functions. Also worked on data modeling, data integration, data visualization, and report configuration. Skilled in Power BI components and functionalities, data warehousing, and ETL process design. Possesses a strong business and technical vision, effective people skills, and the ability to manage complex projects.

Education: Bachelor’s Degree in Computer Science

Technical Certification:

SQL Server Database SSIS and SSRS

Power BI

Python for Data Analyst

TOOLS AND TECHNOLOGY

RDBMS Azure SQL database, SQL Server 2019/2016/2014/2012, Oracle, Snowflake Languages\Tools Visual Basic, PowerShell, C#, T-SQL, Java, Python, .Net Modeling Tools MS Visio, Oracle SQL Server Data Modeler, and Erwin ETL Tools SSIS, Azure Data Factory, Informatica Cloud, IBM DataStage Visualization Power BI Desktop, Power BI service, Tableau, Report Builder, Visual Studio Analysis Tools SQL Server Analysis Server (Tabular and Multidimensional) Professional Experience:

Role: SQL/Power BI Developer/Analyst

Client: Exelon, Chicago, IL April 2022 - Present

Collaborated with Business Systems Analysts to fine-tune specifications and ensure database constraints were met.

Developed complex database objects, including stored procedures, triggers, functions, indexes, and tables contributing to a robust and optimized database structure.

Optimized T-SQL queries for improved performance and executed impact analysis of changes ensuring minimal disruption to existing processes.

Utilized Power BI components for data visualization, implemented row-level security, and managed the Power BI environment for seamless analytics.

Imported diverse data from various sources to Power BI, performed data cleaning, and applied DAX queries for effective data manipulation.

Developed visual reports, dashboards, and KPI scorecards using Power BI desktop providing actionable insights to stakeholders.

Implemented Azure services such as Azure Analysis Service, Azure Data Factory, and Azure Blob for efficient data processing and storage enhancing the overall data infrastructure.

Supported ad hoc access to large databases and provided ongoing maintenance and enhancements.

Developed and maintained Extract,Transform,Load(ETL) processes using SQL Server Integration Services (SSIS), ensuring the accuracy and integrity across multiple data sources.

Applied advanced calculations using DAX and Power queries to meet specific dashboard requirements enhancing the depth and granularity of analytical insights.

Worked extensively with diverse data sources,managing both relational and non- relational databases including SQL,Snowflake and more. Environment: SQL Server 2019/2016/2012, SQL BI Suite (SSIS, SSRS), T-SQL, Power BI, SQL Profiler, MS Office, Erwin, Windows Server 2016. Role: MSBI/SQL Developer

Client: Aetna, Philadelphia, PA Dec 2019 - March 2022

Gathered requirements, performed data modeling, and developed logical and physical models to align with business needs..

Created T-SQL stored procedures and triggers to enhance performance and functionality for database operations.

Utilized SSIS for data migration and transformation ensuring data integrity and efficiency in large scale projects.

Designed and implemented ad hoc reports using SSRS providing valuable insights to stakeholders and enhancing data driven decision making.

Managed alerts and monitored scheduled jobs guaranteeing the successful completion of essential tasks within specified timeline.

Conducted index analysis and optimized SQL queries and stored procedures significantly improving database performance and responsiveness.

Participated in testing, bug fixing, and documentation efforts contributing to the overall stability and reliability of the developed solutions.

Developed incremental loading strategies using MERGE statements and improved performance through index optimization.

Generated quality reports and functional dashboards based on business requirements fostering a data driven culture within the organization.

Collaborated with cross functional teams to enhance the overall data infrastructure bringing valuable insights to the organization processes and contributing to its growth. Environment: Microsoft SQL Server 2008/2008R2, MS SQL integration Services 2008, SSRS 2008, SSAS, Microsoft Excel, C#, XML, ASP.NET, MS Office. Role: Junior BI Developer

Client: Ethiopian Shipping Lines, AA, Ethiopia Mar 2016- Nov 2019

Designed and improved data models for Power BI dashboards resulting in improved data visualization and analysis.

Ensured data quality assurance through testing, auditing, and data ownership models ensuring accuracy and reliability in BI reporting.

Developed and optimized Extract,Transform,Load(ETL) jobs using SSIS for data extraction, transformation, and loading processes.

Connected applications to databases and wrote functions, stored procedures, and triggers to facilitate efficient data operations.

Imported and exported data from various sources using SSIS,contributing to comprehensive and well integrated data ecosystem.

Demonstrated proficiency in data management by creating databases and schema objects ensuring a structured and organized data environment.

Developed visual reports, KPI scorecards, and dashboards using Power BI desktop delivering insightful data representations to support business decision-making. Environment: SQL Server, Power BI, SSIS, SSRS, T-SQL, Windows Server.

Contact this candidate