ELVIRA SAKWE

Contact: 832-***-****

Email: ady555@r.postjobfree.com

PROFESSIONAL SUMMARY

Results-oriented Power BI Developer with seven years of experience in designing and delivering data-driven solutions.

Skilled in developing interactive dashboards, reports, and visualizations that enable stakeholders to gain actionable insights from complex data sets. Power BI Paginated Reports, and Tableau Dashboards based on business requirements.

Proficient in data modeling, ETL processes, and data integration, utilizing SQL, DAX, and M languages to extract, transform, and load data effectively. Power Query editor in Power BI, and SQL to meet business requirements for Report development and Dashboard creation.

Experience with developing various types of reports in SSRS, report management, report delivery.

Excellent understanding of relational database concepts, constraints, referential integrity, and normalization.

Experience in Extracting, Transforming and Loading (ETL) data from different source into Staging environments and Data warehouse.

Good understanding of creation and configuration of Data Gateways for secure data access.

Experience managing Power BI Admin Portal, utilizing Power BI REST APIs in data management, Workspace management and Power BI Tenant settings.

Experience building SSAS Tabular model and connecting to Power BI for Self-Service Business.

Experience integrating data from various sources after transformation and loading into Data warehouse using SSIS.

Good experience in writing queries in T-SQL, Oracle SQL, Postgres SQL, MySQL, with good understanding of use cases for Stored Procedures, indexes, Triggers, views and CTEs and Derived table and Transactions.

Experience with various Cloud data sources like Azure SQL Database, Databricks, Snowflake.

Proven ability to collaborate with cross-functional teams, communicate complex concepts effectively, and deliver projects within deadlines

Strong analytical and problem-solving abilities, with a keen eye for identifying trends and patterns to support informed decision-making.

PROFESSIONAL EXPERIENCE

Employer: I-Ping Solutions

Client: XXXXXXXXXX

Power BI Developer October 2021 –Present

Built Business Intelligence and data visualization dashboards using various technologies such as Microsoft Power BI

Created dashboards and interactive visual reports using Power BI to identify KPIs with clear objectives

Experience working with analysis services, SQL querying for best results, use of filters and graphs for better understanding of data

Create views, stored procedures, CTEs and functions using TSQL which was used extensively in optimizing data extraction and performance optimization

Document BI reporting and Data Warehouse processes and related maintenance steps to ensure system reliability and accuracy of Data Warehouse data and reports/dashboard

Used Power Query to clean, shape, transform and model data to meet organizational goals and reporting.

Developed intelligence-sharing dashboards, providing company-wide access to collected data.

Creation of Paginated Reports in Power BI Report Server used for embedding in Web Portal and setting up Row-Level Security for secured access to developed Report.

Assist in scheduling refreshes and Gateway support.

Gateway Server setup and configuration.

Daily Dataflow and Power BI Dataset refresh.

Employer: I-Ping Solutions

Client: Sutherland Global – Healthcare Solutions

Power BI Developer July 2018 – Sept. 2021

Used data from databases to create power BI reports for management, which carried visuals on the company’s sales’ performance, forecasts, trends, and portfolio dynamics. Use of joins and SQL operators to combine customer records from the various tables within the database to know what transactions were carried out at what time and date.

Wrote views, stored procedures, CTEs and functions which I used extensively in the development process.

Performed operations to optimize and trouble shoot packages, queries, stored procedures, indexes and reports.

Actively engaged in client meetings in requirement gathering and development updates.

Managed day to day activities to ensure the completion of deliverables on time by providing a weekly status report on progress made.

Used DAX queries and functions in Power BI and SSAS tabular model to create calculated measures, columns, and filters.

Worked with data modelers in building SSAS Tabular model for report development in Power BI.

Used Power Query to clean, shape, transform and model data to meet business requirements for reporting

Employer: I-Ping Solutions

Client: DTE Energy - Detroit

Power BI Developer May 2016 – June 2018

Wrote views, stored procedures, CTEs and functions which I used extensively in the development process.

Created reports and dashboards in Microsoft Power BI with visuals that track KPIs and reports that track inventory for various Healthcare institutions serviced by Signify Health.

Actively engaged with other team members to gather requirements, design, code, debug, document, implement and maintain various database objects.

Extensively used joins and sub queries for complex queries involving multiple tables from different databases.

Modeled data using DAX, Power Query and SQL according to business requirements.

Created views, stored procedures, CTEs and functions using TSQL which was used in optimizing data extraction and performance optimization.

Worked closely with key customers to troubleshoot and resolve data and report related Issues.

Maintained existing database and BI systems

Carried out performance tuning and worked with Back-end developers to review stored procedures to improve performance.

EDUCATION

Bachelor of Education: Curriculum Studies – University of Buea, Cameroon. Advanced Diploma in Accounting and Business - Association of Chartered Certified Accountants

(ACCA).

Contact this candidate