Abebech Chekol

• Designed and developed reports, visualizations, and custom extracts using business intelligence tools including, but not limited to SQL Server Management Studio, SQL Server Reporting Services, Power BI, Tableau, SAP Business Objects and Python
• Developed customized reports using SSRS, and scheduled daily and weekly reports
• Designed and developed dimensional data models, ETL/ELT frameworks and processing, metadata management, and operational data integration
• Managed, transformed, and verified the integrity of data used for analysis
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Restricted data for users using Row level security and User filters
• Prepared and reviewed technical design documents for ETL Development
• Worked with business users to gather and compile reporting and data ETL requirements
• Used Power BI Gateways to keep the dashboards and reports up to date
• Experience in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements
• Designed/Developed complex queries efficiently as per the given business requirements
• Loaded flat files data into database using SQL Server Integration Services (SSIS) after applying various transformations like Lookup, Merge join, Aggregation, Derived column, Data Conversion, Script Task etc
• Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI
• Created complex Transact-SQL Queries, stored procedures, views, triggers, sub-queries and joins
• Generated reports using SQL server reporting services (SSRS) that includes matrix and tabular, drill down, drill through, and parameterized reports based on the requirements
• Created report snapshots and cache for better performance
• Deployed and processed SSAS cubes daily/Weekly to update information using SQL Server Agent
• In collaboration with Production DBAs, scheduled Jobs that runs SSIS packages periodically for data loading and alerting using SQL Server Agent
• Designed and managed data warehouse components for solutions that take into consideration the value of performance, scalability, operability, flexibility, affordability, and ability to be audited
• Working very closely with data quality team to identifying and resolving issues related to data quality raised by lines of business users
• Provide ongoing technical support and refinement for existing reports, dashboards, or other tools
• Knowledge sharing and training to internal and external users

Environment: MS SQL Server 2016/2014/2012, SSIS, Power BI, DAX, Power BI Gateway, Power Query, SQL,T-SQL, PL/SQL, Oracle , MS Word, MS Excel, UNIX , Windows OS, Azure

• Worked closely with various teams across the company to identify and solve business challenges
• Gathered and analyzed requirements of clients, understood and converted them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation
• Imported data from different data sources to create Power BI reports and Dashboards
• Experienced in developing Reports, Charts, and Dashboards using Power BI Desktop and manage security based on requirements
• Transformed, defined, navigated the data from data source and performed merge and append queries using Power Query
• Implemented complex query techniques of passing Multi valued parameters and Cascading parameters in MDX
• Performed different types of context like Row context, filter context and query context using Power BI Desktop
• Performed transformations like Pivoting, Unpivoting and Splitting of the columns using Power Query
• Performed Query Folding using Power Query to filter data in the data source server
• Created different chart types and drill down reports using Power Bi Desktop (SSRS)
• Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI
• Published reports and visualizations to Power BI Service and thereby created dashboards
• Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc
• Worked with both live and import data into Power BI for creating reports
• Used different type of slicers available in Power BI for creating reports
• Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided
• Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations
• Shared the created workspace across the organization using Power BI Apps

Environment: Power BI, DAX, Power BI Gateway, Power Query, MS SQL Server 2019/2016/2014/2012, T-SQL, PL/SQL, Oracle, SSIS, Visual studio, ER Diagram, UNIX-Shell Scripting.