LiveCareer-Resume

bi developer power bi developer resume example with 6+ years of experience

Jessica Claire
  • , , 609 Johnson Ave., 49204, Tulsa, OK 100 Montgomery St. 10th Floor
  • Home: (555) 432-1000
  • Cell:
  • resumesample@example.com
Professional Summary

Highly qualified Business Intelligence Developer focused on translating complex mandates into actionable plans and working systems. Specializing in Data Warehouse , Power BI Reporting Service , SQL Server , Azure Cloud Computing, ADF (Azure Data Factory), Database and BI developer with SQL Server, Developing Complex SQL query SSMS and Data Modeling. Ready to bring more than 5 years of related experience to a challenging new role. And highly motivated and competent Team Leader and team player with strong vision to achieve successful outcomes for clients and colleagues. This vision has included successful corporate strategy sessions, innovative ideas, and extensive liaison with corporate clients. Demonstrated strong project developing managing skills as leader and coworker of a motivated team. These unique capabilities would be a major asset to a company seeking to increase turnover and client satisfaction.

Accomplishments
  • Achieved Microsoft certificate badge by completing Az-900 with accuracy and efficiency.
Skills
  • MS SQL Server 2017/2016/2014/2012/2008,
  • SQL Server Management Studio (SSMS),
  • SQL Server Data Tools,
  • T- SQL,
  • Power BI Report Service,
  • SQL Server Integration Services (SSIS),
  • SQL Server Analysis Service (SSAS),
  • SQL Server Reporting Services (SSRS),
  • Data Transformation Services (DTS),
  • Business Intelligence Design Studio (BIDS),
  • ER-Studio,
  • Erwin Data Modeler,
  • SQL, DAX, C#, Phyton,
  • Team Foundation Server (TFS),
  • Azure Data Bricks,
  • STATA.
Education
Bachelor of Computer Science: Computer Science, Expected in 07/2014
Bahir Dar University - Ethiopia ,
GPA:
Master of Science: physics Bahir, Expected in 06/2011
Bahir Dar University - ,
GPA:
Bachelor of physics: Applied Physics , Expected in 08/2008
Mizan Tepi University - Ethiopia ,
GPA:
Work History
BI Developer, Power BI Developer, 02/2019 to Current
Equity ResidentialCity, STATE,

Responsibilities:

  • Create SSIS packages to extract data from different sources.
  • Responsible for developing, support and maintenance for ETL (Extract, Transform and Load) processes using SSIS increased performance by 15%
  • Aggregate, Derived Column, and Data Conversion Transformations.
  • Create indexes on tables; Trace out for any table required any indexes and determine type of indexes on it.
  • Place huge table/non-clustered index on separate file group to improve performance by 40%.
  • Worked with more than 20Client/Business Analysts to define data requirements for reporting and data maintaining.
  • Interacting with Business Analysts and Developers in identifying requirements, designing, and implementing Database Schema.
  • Attend backlog grooming, sprint planning , retrospective meetings and experience as scrum muster.
  • Worked as team following Agile/SCRUM methodology for iterative and incremental development.
DATA WAREHOUSE Developer/ETL Developer , 11/2020 to 09/2021
My Vision Match Thce. GroupCity, STATE,

Responsibilities:

  • Primary Data warehouse developer responsible of business intelligence stack from beginning to end (Design, Analysis, Data Warehousing Reporting System and Support).
  • Develop improved data warehouse that is optimized by 15% reducing number of stored procedures and manual interventions, in to comprehensive and easy-to-understand stored procedure. Increasing performance of power bi report service by 34% with excellent approach.
  • Designed and developed ETL job end to end using MS visual studio from heterogenous sources XML file, JSON File, and EXCEL file, Oracle DB.
  • Provided timely supporting for various developed data Warehousing (SSAS) cubes and related data inquiries.
  • Establishing and maintained data quality practices within business intelligence/Data warehousing team.
  • Generated reports, maintaining dimensional as well as relational data structures and managing operational data store and data warehouse.
  • Created data models and mapped content storage pathways to facilitate easy access and support troubleshooting access issues.
SQL BI Developer, BI Developer, 08/2015 to 04/2018
Ethiopian Ministry Of EducationCity, STATE,

Responsibilities:

  • Designed, developed, modified, and enhanced database structures and objects.
  • Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in databases.
  • Responsible for database portion of application and providing any database needs to .NET framework developers.
  • Worked on Full cycle development (SDLC) involving in all stages of development.
  • Designed complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Diagnosing and tuning optimal server performance using SQL Server, SQL Profiler and Database Engine Tuning Wizards.
  • Partnered with employees for business requirements to design and develop innovative technology solutions to meet these requirements.
  • Data Transformation Services DTS / ETL.
  • As technical specialist assisted in solving technical and non-technical issues.
  • Debugging and troubleshooting technical issues while executing applications.
  • Used multiple transformations in SSIS to meet business requirements by collecting data from various sources.
  • Created different user level groups, and assigned permissions levels to reports, to ensure access to information for right persons with authorizations based on their levels in Organizational.
SQL SSIS/SSRS/BI Developer Analyst, 12/2013 to 06/2015
Commercial Bank Of EthiopiaCity, STATE,

Responsibilities:

  • Created DDL scripts to create database schema and database objects like tables, stored procedures, views, functions, and triggers using T- SQL.
  • Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, and Constraints.
  • Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
  • Implemented database management techniques that include backup/restore, import/export and generated scripts.
  • Implementing Backup and recovery process and Replication process.
  • Act as a liaison between various other departments and Reporting & Analysis for report requests in a timely manner.
  • Maintain SQL Server database, including creating and modifying tables, Views and Stored Procedures.

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Bahir Dar University
  • Bahir Dar University
  • Mizan Tepi University

Job Titles Held:

  • BI Developer, Power BI Developer
  • DATA WAREHOUSE Developer/ETL Developer
  • SQL BI Developer, BI Developer
  • SQL SSIS/SSRS/BI Developer Analyst

Degrees

  • Bachelor of Computer Science
  • Master of Science
  • Bachelor of physics

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: