Data Analyst Power Bi

AMEN TEMESGEN

Aubrey, TX *****

www.linkedin.com/in/amen-t-5420a228 214-***-****

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

SUMMARY

·Meticulous BI developer/Data analyst/BI Administrator with high level of responsibility, excellent at juggling multiple tasks and working under pressure.

·Excellent resource and time management skills with best decision-making quality.

·High level of independence that can plan, work and carryout tasks without detailed instructions, always prepared for problems or opportunities in advance.

·Consummate strengths in project reporting, database administration, demand planning, and workflow documentation.

·Outstanding blend of communication, organizational, prioritization and negotiating skills.

·Highly versatile, focused and methodical; quickly adapt to new roles, responsibilities, industries, software, and environments.

PRACTICAL SKILLS

·Power BI Tableau Snowflake Python Microsoft Azure SQL IaaS PaaS SaaS Workplace Modernization Microsoft 365 Microsoft Azure Virtual Desktop (AVD) DevOps and CI/CD Azure DevOps Git Automation ARM Templates PowerShell Cloud Migrations Azure Migrate Azure Data Factory (ADF) Azure Synapse Azure Monitor Log Analytics Networking and Security Firewalls VPNs SQL server Windows Server Technical Documentation Agile PowerShell

PROFESSIONAL EXPERIENCE

Microsoft Corporation, Remote June 2024 – August 2024

Azure Event Support Engineer

·Supported proactively multilateral Azure Data Factory connectivity issues.

·Supported and configured Virtual Machines, Azure SQL Servers, Azure Blob Storage, Log Analytics, pipeline issues, triggers, and linked services.

·Configured diagnostic tools and collected logs.

·Oversee the installation, configuration, and maintenance of BI tools and platforms (e.g., Power BI, Tableau, SSRS, SAP BI).

·Use Python scripts to clean and preprocess data before loading it into Power BI. This includes handling missing values, filtering data, and restructuring data tables.

·Built Key Vaults, CI/CD pipelines for Azure Data Factory.

·Manage user access, roles, and permissions, ensuring data security and appropriate access controls.

·Configured Integration Runtimes (IR), including SHIR and SSIS IR.

·Optimize and troubleshoot BI platforms, addressing any performance issues.

·Implemented cost management strategies that reduced cloud spending by 40% through efficient resource allocation and utilization monitoring.

·Connect to and combine data from multiple sources using Python libraries, which can then be fed into Power BI for further processing and visualization.

Mr. Cooper, Dallas,TX November 2018 – March 2024

Sr Data Analyst and Power BI Developer/Administrator

·Architected/Designed/Developed/Administered customer service dashboards that accommodate all the business units for monthly summary reports using Power BI.

·Conduct regular audits of system access and data usage to identify any security or compliance risks.

·Designed data models for different business units reporting inquiry.

·Create, manage, and distribute dashboards, reports, and data visualizations to meet business needs.

·Designed effective SSIS packages to build the data warehouse and Data Marts.

·Created templates for the internal team to simplify data cross checking procedures.

·Troubleshooted data lineage related issues of SSIS jobs/Data Algorithms/ERDs.

·Migrated 100+ SSRS and Excel reports to Power BI service.

·Provide technical support and training to end-users, including troubleshooting issues and offering guidance on BI tools and features.

·Managed and configured Data Gateways/Workspaces/Workspace Apps/REST APIs.

·Verified SQL/DAX codes for correct syntax and high efficiency.

·For reports involving text data, use Python for NLP tasks such as sentiment analysis or topic modeling, providing insights that Power BI visuals can display.

·Evaluate and implement new BI technologies and methodologies to enhance data-driven decision-making capabilities.

·Worked closely with cross functional teams, including business stakeholders to deliver successful end to end solutions.

National Lloyds Insurance, Dallas,TX December 2017 – November 2018

SQL BI/Power BI Developer

·Designed All-In-One dashboard for the higher management.

·Developed efficient SSIS packages and migrated the data from the Legacy system to the data warehouse (SQL Server).

·Regularly review and update BI processes and guidelines to reflect best practices and evolving business requirements.

·Remodeled the architecture of the BI data mart to enhance the efficiency of the reporting server.

·Use Python to generate visualizations that can dynamically update based on user input or interactions within Power BI, providing a more interactive experience.

·Developed visual reports to provide insights, manage risks, and to realize business opportunities and areas of concern in the business performance.

·Developed TICO, NISS and ISO transactional compliance reports due monthly, quarterly and yearly.

·Troubleshooted different issues/inquiries in the production environment.

Bank of America, Dallas, TX April 2017 – October 2017

SQL Data Analyst

·Worked as a Sampler for Global Risk and Compliance business unit.

·Developed/executed data packages to pull the sample data.

·Developed scripts and automated templates for internal team members to reduce testing times.

·Verified SQL codes for correct syntax and high efficiency within sampling procedures.

·Reviewed the business process to audit the Risk Management and Compliance procedure.

·Supported the migration and delivery of testing samples from Test Execution resources to the centralized Sampling data center.

Microsoft, Irving, TX October 2015 – April 2017

SQL and Power BI Support Engineer

·Supported connection issues of Power BI to various data sources.

·Consulted customers with creating reports, resolving issues, publishing reports, transforming data, and use of multiple visualizations.

·Supported Data Gateways configurations.

·Supported various service subscription, administration and licensing issues.

·Supported refresh issues, embedding reports to third party and web applications.

·Consulted 100+ companies on how to design advanced and effective reports.

·Assisted product management teams by providing insights on various customer scenarios and solutions.

Expo Mart LLC, Takoma Park, MD, July 2012 – July2013

Inventory System Administrator

·Managed a SQL database and coded complex store procedures to adjust costs and selling prices dynamically.

·Migrated all files from different locations to a centralized SQL Server.

·Generated reports for the management and provided data to interactive dashboards.

·Generated weekly and monthly expenses/profit reports using SSRS.

Ethiopian Airlines, Addis Ababa, Ethiopia December 2007 – April 2012

Applications Analyst

·Supported the integration of GDS System with different Airlines/Hotels/Car Rentals databases.

·Assisted product management teams by providing insights on various customer scenarios and solutions.

·Delivered feedback on live site issues, contributing to continuous product improvement.

·Actively participated in technical forums, offering support and solutions to the stakeholders.

·Engaged in weekly live site meetings with product teams, reporting critical customer issues to enhance product quality.

·Led the migration of 100+ agencies from their local systems to the GDS system.

·Provided expert guidance and support to customers, ensuring successful adoption and implementation of these services.

EDUCATION:

·B.SC. Information System, Addis Ababa University Addis Ababa, Ethiopia, 2007

Contact this candidate