Alfred Eriliben
Summary
A highly skilled Power BI specialist with over 10 years of experience in designing, developing, and delivering data-driven solutions. Expertise in creating interactive dashboards and reports, optimizing data models, connecting to multiple data sources, and configuring incremental refresh to handle large datasets efficiently. Strong background in data analysis, business intelligence, and performance optimization, with a proven ability to deliver insights that drive decision-making.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Sr Business Intelligence Analyst
Nu Skin
07.2019 - Current
- Implemented Incremental Refresh to optimize data refresh times, especially for large datasets, ensuring only updated data is reloaded.
- Connected to multiple data sources including SQL databases, Excel files, SharePoint lists, cloud platforms (Azure, AWS), and APIs, consolidating data into unified models for reporting.
- Gathering business requirements and translating them into effective Power BI solutions, ensuring alignment with business objectives
- Creating efficient data models by transforming raw data into clean, structured datasets, establishing relationships, and optimizing performance for reporting.
- Ensuring reports run efficiently through performance tuning techniques, including data model optimization and report design best practices.
- Constructed 7+ budget vs actual reports and discovered effective solutions to eliminate redundancy and improve readability for $2.5 billion publicly traded company operating in over 50 markets globally
- Automate 5+ complex reports using Power Automate, effectively cutting manual work by 80%
- Built a daily report that captures product sales and returns of all 53 markets globally
- Created a distribution list of over 500+ employees subscribed to the daily report daily
- Created a Total Cost Fulfillments report to track margins of all SKUs enabling management to identify SKUs to eliminate or promote for each market
- Assumed added responsibilities becoming more efficient and productive as employees recently left the company
- Collaborate with internal and external stakeholders to discuss requirements like Metrics and KPIs
- Discuss with various department leaders to ensure On-Time delivery of their weekly reports
- Build variance reports across departments and relate findings and their causes of changes using Power Bi.
Power Bi Developer
Nestle
02.2014 - 06.2019
- Performed data analysis and visualization with MS power BI and deploy to power BI service
- Provides design support for the development of business intelligence solutions
- Developed data source views, dimensions, hierarchies, cubes, and reports
- Develop and manage BI solutions, Extract data from ERP systems and move them to staging
- Developed and maintained reports for both ad-hoc and ongoing business operating needs
- Configured dataset and scheduled incremental refresh to reflect Real-time dashboard
- Create new and maintain existing dashboards using MS power BI
- Model multiple data set by creating relationship with MS power BI
- Perform data profiling to identify and understand abnormalities
- Review and validate customer data as they are collected and profile data source for inconsistency
- Created Workspace and content packs for business users to view the developed reports
- Clean, transform and shape data using Power Query and power pivot
- Oversee the deployment of data to the data warehouse
- Intermediate in writing complex DAX, MDX Query and functions in Power BI
- Scheduled Automatic refresh and scheduling refresh in MS power BI service.
- Designed and implemented scalable data solutions using Azure Synapse Analytics and Azure Data Factory
- Developed complex ETL pipelines to integrate data from various sources into a centralized data warehouse
- Maintained data pipelines using Azure Data Factory and SSIS
- Implemented data governance policies and ensured compliance with data security standards
- Collaborated with data scientists and analysts to provide clean, reliable data for analytics and reporting
- Provided technical support and troubleshooting for data-related issues.
Education
Bachelor of Science - Mathematics
Delta State University
NigCertificate of Completion - Accounting - Accounting
Utah Valley University
Orem, UTSkills
- SQL
- AWS
- Stored Procedures
- Azure SQL database
- Performance Tuning
- SAP
- DAX
- Data Modelling
- CRM
- Power Automate
- Jira
- Redshift
- SSAS
- SSIS
- Azure Data Factory (ADF)
- Power BI
- Excel
- Git
- Azure DevOps
- DAX Studio
- DAX Language
Certification
- B.sc Mathematics
- Google Data Analytics
- Microsoft Certified: Azure Fundamentals
- Power BI Certification of Completion
Timeline
Sr Business Intelligence Analyst
Nu Skin
07.2019 - Current
Power Bi Developer
Nestle
02.2014 - 06.2019
Bachelor of Science - Mathematics
Delta State University
Certificate of Completion - Accounting - Accounting
Utah Valley University