DAWIT MAMO

SILVER SPRING MD /720-***-****, ad2h4q@r.postjobfree.com

PROFILE SUMMERY

•Over 7 years of Business Intelligence Developer with technical knowledge to design, Developed and implement data and analytical solution.Data warehouse design,Data analysis/reporting with power bi experience,verbal and written communications. I have over the years leveraged my bi experiance and expertise to contribute to numerouse project helping organizations achieve business goals.

•Hands on experience in Gathering Data from Variouse source and transforming it into Insightful Report and Dashboards.Proficient in Data Modelling and Integrating Reporting components from multple data sources.

•Skilled in performing data transfer between different heterogeneous systems (Excel,Flatfile,Snowflake, OLTP,DB) and SQL Server as part of Migrations,Date Maintenance.

•Managing and Develoing BI Reports to truck new and existing claims.ie interactive Dashboards,mobilized Business Intelligence,Online Reports and scorecard.

•Reviewing Changing Market condition and Historical Performance,Identifing opportunities,Delvering insight,and Assessing the impact of Strategic initiatives that improve business profitability and shareholder value.

•Developed and implemented reporting,analytics and data visualization solution with power bi,tablue.

•working knowledge of power bi(power pivot,power view,power bi online,powerbi desktop,power bi publisher)and dax.

• Design and Implement reporting solution using reporting service,power bi or other data visualization tools.

•Design and Implement Complex Data Model reporting solution using reporting service,power bi or other data visualization tools.

•Design and Developing Big data model using different performance optimization technique and make multiple dimension table and fact table using star schema.

•Creating Static and Dynamic Row Level Security with power bi desktop and integration with power bi service portal.

•Experience in optimizing reports and setting up power bi service,geteways,and scheduling data refresh.

•Experinence of creating,configuring,and maintaining system database.

•Collaboation in software developement life sycle (SDLC) using different methodologies.

•Full lifecycle development from analyzing current processes, providing functional specification, designing, and developing solutions, and testing and providing ongoing support.

•Managing Business intelligence initiatives

Experience of Data flow /power query online/to import big data to cloud.

Configuring Datacenter

Migration to Azure/azure data factory/

•Supporting, Structuring and Delivering concise data driven narrative to drive the company’s priorities; by translating data into compelling stories which connect finding from different sources and synthesize them into one complete picture

•Expertise in dealing with RDBMS including E/R Diagrams, Normalization and De-Normalization, Constraints, Data Import and Export for existing table for faster query retrieved.

•Create and modify reports and report template using SQL Server Reporting Service (SSRS)

•Maintain Legacy SSRS report & Migrate SSRS report to POWER BI

•Integerate power apps with power bi to expand capablity of power plat form

•create power automate pipe line to automate some report in power bi

•Developed a complate SSIS life cycle creating SSIS packages including building, deploying, excuting, and scheduling the package.

•created test scripts to evaluate database and application reliability.

•TECHNICAL SKILLS

Data Source:

SQL Server Database, EXCEL, CSV, SALSEFORCE, JSON, SNOWFLAKE

BI Tools

Power BI, SSRS,SQL Server and SSIS

Cloud Computing:

Azure

Operating System:

Windows, Mac

Database:

DBA, SQL Server, Oracle, MS Access

Data Visualization & Reporting of Database Management Systems Enterprise Data Warehousing

ETL Workflow Development

Methodology:

Agile with Multiple Sprint Cycles

Customer focused & Rapid delivery

Adaptive to changes in technology

Adaptive to changes in requirements

Highly collaborative with Daily Scrum

PROFESSIONAL EXPERIENCE

POWER BI DEVELOPER ADMIN

TATA CONSULTANCY SERVICE

COLUMBUS,OHIO DEC 2022 – CURRENT

Responsibilities:

•Gazering data from sql server database,excel,snowflake,dataset,and other sources.transformed the data and produced reports using power bi platform.optimized the dashboard with focus on usablity and performance.

•Design and Create innovative and valuable visualization to identify patterns,trends,and exceptions which enables the business excutives and senior leaders to make data driven decision.

•Collaborate with cross-functinal teams to identify data sources and streamline data collection resulting in reduction in report development time.

•Improve dashboard usablity by implementing interactive visualization resulting increase in user engagement.

•Optimized dashboard performance by implementing different performace improvement technique /lower data model size,limit number of visual per page,and using correct dax logic/.

•Interpret business requirement and translate them into power bi, transform, build, maintain and automate the dashboard to refresh the data Support the transfer excel based analysis tools to advance analysis product.

•Understand,own,and supports operational dashboard,business performance dashboard,interprate the result,and summarize opportunities for improvment and make recommendation to senior leadership.

•Provide technical support across the division as directed by client including providing SharePoint Online and Microsoft Office 365 support to stakeholders and end users

•Interpreting business request and translating them into SQL. build, maintain and automate complex SQL queries to research, compile performance data, investigate for any strategy analysis or build report

•Create and Manage the work space,Grant access,deny access for the end user.

POWER BI/SQL/ETL DEVELOPER /DATA ANALYST

CAPGEMINI

SILVER SPRING, MD MAY 2016 – DEC 2022

Responsibilities:

•Developed and Implement ETL process using SSIS to increase data integration efficiency.

•Understand,Identified,acquired,and analyzed data from multiple sources to streamline.The delivery of information across the company platform using ETL and Ms.SQL Server.

•Developed complex T-SQL codes to create/update database objects such as Tables, Views, Stored Procedures, User Defined Functions, Triggers, Indexes, and Cursors.

•Used SSIS to create ETL packages to Extract, Transform and Load data to Data Warehouse and Data Mart Databases.

•Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging Database.

•Extracted data from different sources (CSV, Excel, and MSSQL and Oracle database sources) and load to Data Warehouse using SSIS complex data transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split, Lookup, Fuzzy Lookup, Slowly Changing Dimension, Derived Column, Row Count, and more) for existing/new packages.

•Developed SSIS packages using For Each Loop Container in the Control Flow elements to process all Excel files within folder; File System Task to move file into Archive after processing; and Execute SQL task to insert transaction log data into the SQL Table.

•Involved normalization and demoralization of existing table for fast query retrieval cleansing data in power query using power apps and power automate and its visualization for better utilization and performance of power BI.

•Created a reusable /repeatable process in Power automate by integrate with power bi

•Configured varies event driven e-mail notification process in SSIS package

•Integrate power bi with power apps to connect to business data provide data insight and visualization, and enable users to take action from within power bi report and dashboard.

•Worked with type 1and type 3 dimensions, fact table, star schema, operational data store (ODS), levelling and other data warehouse concept

•Develop ETL process using data integration tools, scripts, and stored procedures to extract data from multiple system, application, and other sources, and load data into enterprise data warehouse

•Configured and manage power bi clustered data gateway in power BI service to avoid single point frailer.

•Worked as power bi admin, granted /denied access for user, managed data getaway and upgrade workspace to premium.

•Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.

Environments: Microsoft SQL Server 2012/2008, T-SQL, Power bi,SSIS

EDUCATION

•BAHIR-DAR UNIVERSITY

BACHELOR OF ELECTRICAL ENGINEARING 2000

CERTEFICATION

•CERTIFICATIONS OF POWER BI (FROM MICROSOFT)

TRAININGS

•DATA VISUALIZATION & REPORTING OF DATABASE MANAGEMENT SYSTEMS

•ENTERPRISE DATA WAREHOUSING

•ETL WORKFLOW DEVELOPMENT

Contact this candidate