Power Bi Data Analyst

Hareg Meng

**********@*****.***

Tel +1-571-***-****

Professional Summary

●Proficient SQL/Power BI Developer with 8+ years of experience in data preparation, modeling, visualization, Proficient in building visual dashboards using Power BI and Tableau.

●Skilled in writing SQL queries to manage and analyze data.

●Experienced in Python scripting for automating workflows.

●Strong knowledge of DAX for dynamic calculations in Power BI.

●Proficient in integrating data pipelines with SSIS for automation.

●Adapt at performing EDA to uncover actionable insights.

●Skilled in visualizing data trends using Python and Tableau.

●Knowledgeable in applying data governance and compliance practices.

●Experienced in presenting business insights through visual storytelling.

●Collaborates with teams to gather and meet data-related needs.

●Worked on AWS and azure cloud platforms

●Experienced in data integration projects consuming heterogeneous data sources.

Skills

●Databases: MSSQL, Oracle, PostgreSQL, MongoDB, MS Access

●BI Tools: Power BI, Tableau, SSAS, Crystal Reports, Excel, SSRS

●SQL Server Tools: SQL Server Management Studio, BIDS, SQL Profiler, FTP

●Methodologies: Agile, Waterfall, Data Modeling, MS Project

●Cloud Platforms: Microsoft Azure, AWS, Snowflake

Education and Certification:

●Bachelor

●Microsoft Certified: Data Analyst Associate with Power BI

BioPlus - Oralando, FL

Data Analyst

April 2023 – Present

●Designed Power BI dashboards for tracking financial operations.

●Wrote SQL scripts to extract and transform transactional data.

●Automated workflows using Python to improve reporting efficiency.

●Applied DAX for creating measures and KPIs in Power BI.

●Conducted EDA to find key insights from banking datasets.

●Built ETL pipelines using SSIS for integrating customer data.

●Prepared cleaned datasets for analysis to ensure data reliability.

●Built forecasting models for customer churn analysis.

●Presented findings to stakeholders through clear dashboards.

●Collaborated with cross-functional teams to meet reporting needs.

●Worked on migration project from on prem to Azure platform.

●Integrated data between on prem and azure.

Environment Power BI Desktop, Power BI Service Pro, Business Objects, SharePoint, QlikView,SQL, MSSQL, MS Access, Microsoft Excel

Mayo Clinic - Rochester, MN

Data Analyst

May 2020 – March 2023

●Created Tableau dashboards for patient data reporting.

●Used Python to analyze patient trends and healthcare operations.

●Wrote SQL queries to fetch and clean large medical datasets.

●Developed ETL pipelines for patient data integration.

●Visualized KPIs for hospital performance in Tableau.

●Automated routine data preparation tasks using Python.

●Conducted predictive analysis for patient readmission trends.

●Worked with medical teams to translate data into actionable insights.

●Ensured data quality and compliance with healthcare standards.

●Documented workflows for reproducibility and training purposes.

Environment: Power BI Desktop, Power BI Service, Project Online, SSAS, DAX, Tableau, Microsoft Azure, Python, SharePoint, Visual Studio, Scrum/Agile, XML, SQL Profiler, TFS, MS Office

AutoZone - Memphis, TN

Data Analyst

September 2018 – April 2020

●Built Tableau dashboards to track inventory and sales data.

●Created SQL queries to analyze product trends across stores.

●Automated data workflows using Python to streamline processes.

●Integrated real-time data into dashboards for live reporting.

●Cleaned raw sales data to improve report accuracy.

●Used predictive models to forecast seasonal product demand.

●Presented insights through interactive visualizations.

●Collaborated with marketing teams to optimize promotions.

●Documented analytics workflows for future use.

●Ensured consistency in data across multiple sources.

Environment: Microsoft SQL Server 2012/2014, Visual Studio, Power BI, SAP -Hybris, MuleSoft. .Net, GIT, Jira, and Tableau.

Honeywell International Inc. - Charlotte, NC

SQL Developer

March 2017 – August 2018

●Developed SQL queries for extracting manufacturing data.

●Built SSIS packages to integrate multiple data sources.

●Created SSRS reports for tracking production KPIs.

●Optimized database performance through query improvements.

●Designed and implemented stored procedures for automation.

●Managed database security, including roles and permissions.

●Developed indexing strategies to enhance query speeds.

●Documented database workflows and structures.

●Collaborated with engineering teams to meet data needs.

●Resolved SQL Server performance and operational issues.

Environment: SQL Server Management Studio (SSMS), MS BI Suite (SSIS/SSRS), SQL Server Data Tools (SSDT), JIRA, Agile/Scrum.

Contact this candidate