We provide IT Staff Augmentation Services!

Bi Developer Resume

EthiopiA

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

Hire Now