Power Bi Data Analyst
Resume:
MERGA AYO
**********@*****.***
SUMMARY
● Proficient in creating Power BI and Tableau dashboards for data analysis.
● Experienced in writing advanced SQL queries to retrieve and analyze data.
● Skilled in automating workflows and data pipelines using Python.
● Adept at creating DAX measures for interactive reporting in Power BI.
● Knowledgeable in data governance and ensuring compliance.
● Experienced in building ETL processes with SSIS for integration.
● Strong in performing exploratory data analysis to identify trends.
● Skilled in visualizing insights with Python libraries and Tableau.
● proficient in cleaning and validating data for reporting accuracy.
● Works effectively with cross-functional teams to gather and fulfill reporting needs. 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:
● BS in
● Microsoft Certified: Data Analyst Associate with Power BI Commerce Bank - Kansas City, MO
Data Analyst
April 2023 – Present
● Created Power BI dashboards to monitor banking KPIs and financial metrics.
● Extracted customer and transaction data using SQL for analysis.
● Automated data workflows and ETL processes using Python.
● Built data pipelines with SSIS to integrate large banking datasets.
● Developed DAX measures to enable dynamic reporting in Power BI.
● Performed exploratory data analysis to identify patterns and insights.
● Ensured data accuracy by cleaning and validating raw datasets.
● Built forecasting models to predict customer loan performance.
● Presented actionable insights through clear, interactive dashboards.
● Collaborated with teams to enhance reporting and analytics capabilities. Environment Power BI Desktop, Power BI Service Pro, Business Objects, SharePoint, QlikView, SQL, MSSQL, MS Access, Microsoft Excel
Pfizer - New York, NY
Data Analyst
May 2020 – March 2023
● Designed Tableau dashboards to track clinical trials and drug performance.
● Used Python and pandas to analyze large datasets related to healthcare.
● Wrote SQL queries to retrieve and process patient data.
● Automated ETL processes for clinical data integration.
● Conducted predictive modeling to forecast market trends.
● Ensured data consistency and compliance with healthcare standards.
● Presented insights through Tableau dashboards to executives.
● Collaborated with researchers to deliver data-driven solutions.
● Trained teams on using analytics tools effectively.
● Maintained documentation of data pipelines and processes. Environment: Tableau, Microsoft Azure, Python, Pandas, Seaborn, SharePoint, Visual Studio, Scrum/Agile, XML, SQL Profiler, TFS, MS Office
Harbor Freight Tools - Calabasas, CA
Data Analyst
September 2018 – April 2020
● Developed Tableau dashboards to track retail operations and sales.
● Wrote SQL queries to analyze product and inventory performance.
● Automated data workflows using Python for efficient reporting.
● Cleaned and processed raw sales data for accuracy.
● Conducted trend analysis to forecast product demand.
● Presented insights through clear, interactive visualizations.
● Worked with marketing teams to optimize promotions and campaigns.
● Documented workflows and analytics processes for scalability.
● Ensured data quality across multiple systems.
● Trained staff in using Tableau for data analysis. Environment: Microsoft SQL Server 2012/2014, Visual Studio, SSRS, SAP Hybris, MuleSoft. .Net, GIT, Jira, and Tableau.
John Deere Moline, IL
SQL Developer
March 2017 – August 2018
● Developed SQL queries to analyze manufacturing and production data.
● Built SSIS packages to streamline data integration processes.
● Designed SSRS reports for tracking equipment performance.
● Optimized SQL queries to improve database efficiency.
● Created stored procedures for automating routine tasks.
● Implemented database security controls and user roles.
● Developed indexing strategies for faster query execution.
● Collaborated with teams to deliver data solutions for engineering needs.
● Documented database workflows and processes.
● Resolved SQL Server issues to ensure smooth operations. Environment: SQL Server Management Studio (SSMS), MS BI Suite (SSIS/SSRS), SQL Server Data Tools
(SSDT), JIRA, Agile/Scrum.
Contact this candidate