Yonathan Wolezg
Malden,MA
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
• Worked with Live Data (Direct Query) and import data connectivity Mode.
• Worked on predictive analytics use-cases using Python language.
• Transformed data in a Power query Editor by adding conditional/custom/index columns, merged/append and parse queries , changed data types, unpivot/pivot columns, add/remove columns/rows, split columns, etc.
• Created models and established relationships in Model tab of Power BI Desktop.
• Published and scheduled Power BI reports.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Power BI Developer/Data Analyst
Colaberry Inc
Plano, TX
09.2017 - Current
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
- Designed customized data collection models for specific visualization tasks.
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
- Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
- Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
- Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.
- • Built ETL process with the help of SSIS tools such as Control flow, Data Flow, Execute SQL, Expression, File System, Script, XML tasks and For Loop Container, For each Loop Container, Sequence Container and etc.
• Established connections using different connectors to the source such as ODBC, OLE DB
• Monitored error logging and error recovery capability of ETL jobs.
• Extracted data from various sources (SQL Server, text files and excel sheets), used ETL load scripts to manipulate, concatenate and clean source data.
• Performed data connecting to data sources such as SharePoint, SQL server, Rally, Azure services, SSAS, Web.
• Worked with Live Data (Direct Query) and import data connectivity Mode.
• Worked on predictive analytics use-cases using Python language.
• Transformed data in a Power query Editor by adding conditional/custom/index columns, merged/append and parse queries , changed data types, unpivot/pivot columns, add/remove columns/rows, split columns, etc.
• Created models and established relationships in Model tab of Power BI Desktop.
• Published and scheduled Power BI reports.
• Designed dashboards/reports/visualizations in Power BI desktop.
• Performed data connecting to data sources such as SharePoint, SQL server, Rally, Azure services, SSAS, Web.
• Worked with Live Data (Direct Query) and import data connectivity Mode.
• Worked on predictive analytics use-cases using Python language.
• Transformed data in a Power query Editor by adding conditional/custom/index columns, merged/append and parse queries , changed data types, unpivot/pivot columns, add/remove columns/rows, split columns, etc.
• Created models and established relationships in Model tab of Power BI Desktop.
• Published and scheduled Power BI reports.
Education
Bachelor of Science - Civil Engineering
Adama Science And Technology University
Adama,Ethiopia09.2015
Associate of Science - Irrigation Engineering
Arba Minch University
Arba Minch,Ethiopia09.2005
Skills
- Extract, Transform, Load (ETL)
- Microsoft SQL Server
- SQL Server Management Studio
- SQL Server Reporting Services (SSRS)
- SQL Server Integration Services (SSIS)
- SQL Server Analysis Services (SSAS)
- Microsoft Excel
- Data Analysis
- Data Warehousing
- Data Modeling
- Data Visualization
- Data Cleaning Microsoft Power BI Python (Programming Language) ,Data Warehousing,Data Analysis,RDMS Development and SQL
Certification
- Certified Data Analyst from Colaberry
Timeline
Power BI Developer/Data Analyst
Colaberry Inc
09.2017 - Current
Bachelor of Science - Civil Engineering
Adama Science And Technology University
Associate of Science - Irrigation Engineering
Arba Minch University
Similar Profiles
Samuel LazarusSamuel Lazarus
Power BI Developer at Colaberry INCPower BI Developer at Colaberry INC
EFE AGBONAYEEFE AGBONAYE
Power BI Developer at Colaberry IncPower BI Developer at Colaberry Inc
SHAHAD JAWADSHAHAD JAWAD
BI/Power BI Developer at Colaberry IncBI/Power BI Developer at Colaberry Inc