PROFESSIONAL SUMMARY:

• I have 3 plus years of experience in IT industry working with SQL Server 2008R2/2012/2014 Business Intelligence Tools. Working in different teams at different times and levels, I have worked on designing and implementing BI solutions with MSSQL 2010/2013/2015, T - SQL programming, ETL (SSIS) package/data set migration/transformation, data loading, Logical data modeling and Physical Data Modeling, enterprise reporting (SSRS) and Power BI reports. I have understanding in SSAS skills including DAX queries. I have knowledge on creating report form Cube.
• I am a self-starter, highly motivated and have a very good problem solving and communication skill. I am experienced in industries like Services and Merchandise Business, Health and Higher Education across a wide variety of systems and companies from small to large size.
• 3+ years of SQL Server and Business Intelligence tools experience
• 2+ years of design and develop various business reports using SSRS, Excel &Power BI
• 2+ years of ETL development for data acquisitions from various sources using SSIS data tools
• 3+ years of experience in writing T-SQL scripts, stored procedures, triggers, views, tables, indexes, constraints, user defined functions
• 3+ years of experience in logical and conceptual Relational Database Design using Erwin and MSVisio
• Team-oriented, with strong communication and interpersonal skills

TECHNICAL SKILLS:

Business Intelligence Tools: SQL Server 2008R2/2012/2014 Business Intelligence Development Studio, 2012/2013 MS Data Tools

Data Warehouse Tools: MS SQL Server 2008R2/2012/2014 Integration ServicesReporting Tools: Power BI, SQL Server 2008R2/2012/2014 Reporting Services

Data Modeling Tools: Microsoft Visio, Erwin

Languages: T-SQL, PL-SQL

System Development Life Cycle (SDLC): Agile

Source Control Tools: Jira, TFS

Data Analysis and Mapping: SPSS, MATLAB, ArcGIS

MSOffice: Access, Power point, Outlook, Excel, Visio and Project

Familiar with: XML, HTML, XHTML, CSS, C ++

PROFESSIONAL EXPERIENCE:

BI Developer

Confidential

Responsibilities:

• Writing TSQL scripts, stored procedure, user defined functions and views
• Developing reports per user requirements using SQL Server Reporting Services (SSRS)
• Enhancing Reports using Variables, Expressions and Functions of SSRS
• Extracting data using SQL Server Integration Services (SSIS) packages (ETL) for transferring from heterogeneous sources like Excel, CSV, flat file data to destination
• Developing various data transformations during ETL development
• Giving different access privilege for reports of different users using report manager security feature
• Developing data visualization and dashboards using Power BI
• Creating different types of reports using Power BI desktop
• Fixing SSRS report and ETL package bugs
• Working on query performance optimizations
• Working on creating cache and snapshot data per business request for urgent business reports
• Enhancing existing reports according to requirements of the end users

Environment: s: MS SQL Server 2014, Power BI, Windows Server 2012, Visual Studio 2013, TFS

BI Developer

Confidential, Seattle

Responsibilities:

• Created, developed and managed database objects such as tables, views, indexes, stored procedures.
• Extracted data using SSIS packages (ETL) to transfer from heterogeneous sources to destination
• Created Visualizations and reports for requested projects
• Created executive summary report using SSRS
• Configured Reporting Services Manager
• Build and deploy the report to different environment
• Prepared dashboard using Power BI
• Developed Report using pivot table in MS-Excel
• Prepared dashboard using charts, executive summary report that enable to analyze performance of projects

Environment: s: - MS SQL Server 2012, Visual studio 2015, Power BI, TFS, MS-Office

Database Developer/Report Developer

Confidential, Ethiopia

Responsibilities:

• Developed complete life cycle including conceptual, logical and physical data design, development and test of DB Projects
• Gathered requirement and analysis, to assist the needs of the end users
• Experienced in designing conceptual, logical, physical data modeling, data mapping, and normalization
• Created and managed objects such as Tables, Views, Indexes and referential integrity depending on user requirements
• Developed ETL packages using SSIS for data migrations from heterogeneous sources (Excel, CSV, flat file) data to destination database
• Applied various data transformations during ETL development
• Wrote T-SQL scripts for data visualization and analysis
• Tuned performance of existed stored procedures and SSRS reports
• Designed different types of SSRS reports like parameterized and drill-down based on requirements
• Created executive summary reports using SSRS
• Configuration of Report Manager for subscription and caching
• Build, deploy and test SSRS reports in different environments
• Provide different access privilege for reports of different users using report manager security feature

Environment: s: MS SQL Server 2012, Windows Server 2010, XML, Visual Studio 2013, Erwin

Data Analyst

Confidential, Ethiopia

Responsibilities:

• Developed functional work flows from source systems to destination systems
• Involved in database planning in relation to physical and logical data architecture
• Analyzed business requirements and build logical data models
• Deployed new database objects in various environments
• Gathered business and document requirements, profile and report on data
• Provided recommendation on addressed data quality issues
• Conduct analysis of the data collected and assured compliance with the organization’s standards
• Designed prototype SSRS reports with mock data as part of data analysis process

Environment: s: MS SQL Server 2008R2, Windows Server 2008, Visual Studio 2010, MS Excel, Access, Visio