Uploaded File
add photo
Baweke
yashenfalbaweke@gmail.com
904-651-6753
1141 Kendall Town Blvd Unit 2101
Jacksonville, FL 32225
Business Intelligence Developer
11 years experience W2
0
Recommendations
Average rating
85
Profile views
Summary

Experience
Business Intelligence Developer
Information Technology
Jan 2015 - Nov 2017

Responsibilities:
• Installation and configuration of SQL Server 2008R2/2016
• Implementation and delivery of BI platform solutions in developing and deploying ETL Packages, Analysis Services and Reports using SQL Server 2008R2/2016 (SSIS, SSAS, SSRS, SSMS).
• Maintained user/groups access and security permissions in accordance to policies and procedures.
• Developed Transact-SQL (T-SQL) Queries, Stored Procedures, Triggers, User Defined Functions (UDF), Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constrains, Rules and Default.
• Involved in Migration of Databases from SQL Server 2008R2 to SQL Server 2016 using SSIS.
• Used Fuzzy Lookup transformation to perform data cleaning tasks such as standardizing data, correcting data, and providing missing values.
• Created various types of reports including matrix, sub reports, list, chart and linked reports in various formats (PDF, XML, HTML, and CSV).
• Created filters, prompts, and business calculations in Report Model of SSRS. This enabled end users in increasing the speed of Ad-hoc report generation.
• Used SQL Server Analysis Services 2008R2/2016 (SSAS) to create OLAP Cubes and defined data source, data source views, dimensions, measures, user defined hierarchies, calculated measures, KPIs and roles. ENVIRONMENT: SQL Server 2008R2/2016, MS-Access 2003/2007, MS-Excel 2003/2007, MS-Visio, Windows 2000, Windows XP, Windows Vista, Windows 2003 Server.

Data Integrity Data Cleansing ETL T-SQL BI Developer SQL Server SQL SSAS SSRS OLAP SSIS SSIS/ETL Business Intelligence Stored Procedure HTML Triggers XML Microsoft Excel Windows
Remove Skill
SQL Server Developer
Information Technology
Oct 2013 - Oct 2014
Responsibilities:
• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs with solution options.
• Developed Transact-SQL (T-SQL) Queries, Stored Procedures, Triggers, User Defined Functions (UDF), Views and Indexes strictly following the Data Integrity using Constrains, Rules and Default.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to Staging and Staging to Data Warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more.
• Wrote complex SQL queries using joins, CTE, sub queries and correlated sub queries to retrieve data from the database.
• Involved in migration of DTS packages (2008) to SSIS (2012) and troubleshoot migration issues.
• Deployed and scheduled reports using SSRS to generate all daily, monthly and quarterly reports including status. ENVIRONMENT: SQL Server 2008R2/2012, T-SQL, SQL SSIS, SSRS, SSAS, XML, Windows 2000, Windows 2003 Server.
XML T-SQL Stored Procedure SSRS SSIS SSAS SQL Server SQL OLTP ETL Data Warehousing Triggers Windows
Remove Skill
IT Expert
Information Technology
Feb 2005 - Apr 2012
Responsibilities:
• Installing network and computer systems.
• Maintaining, repairing and upgrading network and computer systems.
• Diagnosing and fixing problems or potential problems with the network and its hardware, software and systems.
• Monitoring network and systems to improve performance ENVIRONMENT: MS-Windows XP, MS-Access 2010, MS-Excel 2010, MS-Word 2010, MS-PowerPoint 2010.
No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
CONSTRUCTION MANAGEMENT
Addis Ababa University 2009
COMPUTER SCIENCE
Addis Ababa University 2004
Skills
ETL
2017
3
SQL
2017
3
SQL Server
2017
3
SSAS
2017
3
SSIS
2017
3
SSRS
2017
3
Stored Procedure
2017
3
T-SQL
2017
3
Triggers
2017
3
Windows
2017
3
BI Developer
2017
2
Business Intelligence
2017
2
Data Cleansing
2017
2
Data Integrity
2017
2
HTML
2017
2
Microsoft Excel
2017
2
OLAP
2017
2
SSIS/ETL
2017
2
Data Warehousing
2014
1
OLTP
2014
1
XML
2017
1