Power Bi Business Intelligence

Ed Dror

Encinitas, CA, US

Email: ********@***.***, Cell: 760-***-****

LinkedIn Profile: https://www.linkedin.com/in/ed-d-15a39013/

SUMMARY

Experienced Data Architect & Manager with expertise in handling large-scale enterprise data environments and managing offshore teams. Proven track record in designing ETL/ELT pipelines, data governance, and star/snowflake schema modeling. Skilled in Power BI, Azure SQL, and optimizing data movement across multiple platforms. Adept at mentoring teams, developing reporting strategies, and driving business intelligence initiatives.

EXPERIENCE

Sr. Reporting Lead

Independent Contractor

Aug 2024 – Mar 2025

Serve as SME in Power BI for Sempra Energy.

Participate with large (multiple teams) workshop with the stakeholders gathering current state.

Conduct comprehensive analysis about current, transition and future state providing roadmap and developing new BI strategy refactoring the existing one to new infrastructure.

Participate in the design of multi-year project plan and deliverable to the client executives

Work with database architect on new conceptual, logical and physical design to align with database inventory from the reporting underline tables and for future medallion architecture design,

Layout the foundation of data governance, source control and security aspects

Test old KPI and new KPI and make sure they are aligning with client needs

Participate in a daily meeting with multiple team members as SME database and reporting

Migrated hundreds of Power BI reports data sets from Azure SQL to AWS .

Designed medallion architecture for data loading from SAP and other applications.

Converted paginated reports into Power BI.

Created data dictionary based of inventory of current state of reports

Managed a team of developers and data modelers to execute the project plan.

Power BI Sr. Lead

Department of Energy (DOE)

Feb 2024 – Jul 2024

Held Public Trust security clearance.

Developed large data models using data flows based on business requirements.

Created data flows, calculated columns, and measures to incorporate business rules.

Implemented Row-Level Security and provided ongoing Power BI support.

Consolidated multiple datasets into Power BI apps for end users.

Designed data models with fact and dimension tables to serve business needs.

Created wireframes and data dictionaries for all dashboards.

Created user manual and data dictionaries for all dashboards.

Senior Manager, Insights & Data

Sogeti

Mar 2022 – Jul 2023

Managed small offshore and onshore teams as consultants for various industries.

Provide strategic planning for monitoring and continuous Improvement

Specialized in the Microsoft stack, including Power BI, Paginated Reports, and Azure Snowflake.

Created data models and implemented incremental refresh with XMLA endpoints.

Delivered expertise in Power BI Pipeline and Row-Level Security.

Led daily Scrum meetings and prepared wireframes for 30/60/90-day client plans.

Power BI Developer

KPMG US

Jun 2021 – Feb 2022

Consumed large datasets from Azure Synapse and SQL Managed Instances.

Built aggregation calculations and created data models for high-visibility Power BI reports.

Collaborated with large groups of end-users across various industries.

Utilized Agile Scrum and Kanban methodologies.

Implement financial and business KPI like EBITDA CAGR Etc.,

Enterprise Architect

Scripps Healthcare

Apr 2012 – May 2017

Designed and implemented BI solutions based on USE-CASE scenarios utilizing Power BI.

Created a Meaningful Use for Ambulatory side using SSIS and SSRS reporting.

Developed an EEHR Data Store for operational reports, saving organizational costs.

Consolidate data from 45 Clinique and costal into central location for reporting

Serve as SME for EEHR system for analytical reporting

Develop a website for capturing daily activities for attestation

Mapped ICD9 to ICD10 codes

Design Fact and Dim table for ENT data warehouse

Key Projects

Meaningful Use – Developed EHR system, securing $15M in funding. 340B Drug Rebate Program – Designed tracking system, generating $4.5M in savings. Medical Wellness Analytics – Improved Medicare patient engagement, adding $11M revenue. Population Health (Hypertension & Chronic Kidney) – Designed predictive analytics reducing heart attacks & dialysis rates. Data Migration Strategy – Planned Azure-to-AWS Redshift migration enhancing reporting scalability.

SKILLS

Data Infrastructure: OLTP, ETL/ELT, Kimball Methodology, Data Warehousing Business Intelligence: Power BI, Schema-on-Read, Data Visualization

Analytics & Modeling: OLAP Cubes, Star & Snowflake Schema, Tabular Models Software & Tools: SQL Server (SSIS, SSRS, SSAS), Azure SQL, DAX Studio, Visual Studio, GIT, Power Query

Healthcare Domain: ICD, CPT, DRG, HL7, HCPCS, SNOMED, LOINC

Education

Touro College – bachelor’s degree in business management.

Contact this candidate