| Candidate Information | | Title | Power Bi Data Analysis | | Target Location | US-TX-Wylie |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidatePROFILEETL/BI Developer with 6+ years of experience in data integration planning, design, and implementation. Proficient in creating, publishing, automating, and maintaining Power BI reports, dashboards, and data visualizations.Extensive knowledge of Cloud Migration, Azure Data Factory, Data Lake Storage, Azure SQL Data Warehouse, and Power Platform Power Apps.Skilled in using source control systems and project management tools like Agile, Jira, DevOps, and MS Team Foundation Services.Confident working both independently and in diverse team settings.Quick learner, driven by curiosity, and able to adapt quickly to any role, delivering outstanding results. Comfortable working across various business sectors, including automotive technology, healthcare, banking, and insurance.SKILLSMicrosoft Visual Studio 2017 Adobe Dreamweaver 2021 PC based systemsAutoCad Proteus Arduino MATLAB 7.0.4Java C++Power BI MikroC PythonHTML, CSS, PHPReact SQLSpring Boot ElectronDAX expressionsData modeling ETL processesMachine LearningPower Query Data Visualization NoSQLGit RestfulAPIMicrosoft Excel AzureWORK EXPERIENCEPower BI DeveloperAcclaim Software / IC Solution May 2023 - PresentUtilized Power Query to import, clean, and transform data from various sources. Design and implement efficient data models using Power BI Desktop.Created visually appealing and interactive reports and dashboards using Power BI. Utilized Power BI Performance Analyzer and other profiling tools to identify bottlenecks.Used PowerShell scripting for automating routine tasks such as data refresh and report deployment. Optimizing report performance by fine-tuning queries and data refresh schedules.Optimized data refresh times by 30% through query optimization and server-side adjustments. Developed a custom visual that enhanced the representation of complex financial data, resulting in improved user comprehension.Successfully implemented row-level security, ensuring data confidentiality and compliance with privacy regulations.Automated report deployment and reduced manual intervention, resulting in a 20% time-saving in the deployment process.Conducted comprehensive training sessions that led to a 40% increase in user adoption and engagement with Power BI reports.Used DAX (Data Analysis Expressions) for creating complex calculations and measures. Incorporate data from external sources through APIs or custom connectors.Collaborate with business users to understand requirements and provide solutions.Conduct training sessions for end-users on using Power BI reports and dashboards effectively. Utilize version control systems (e.g., Git) for managing Power BI report versions.Implement best practices for deploying reports across different environments.Power BI DeveloperCiti Group, Seattle, WA May 2021 to May 2023Creating dynamic and interactive reports and dashboards using Power BI. Designing compelling visualizations to present complex data in a meaningful way. Developing data models to organize and structure data for efficient analysis.Creating hierarchies, measures, and calculated columns for in-depth data exploration.Writing advanced DAX (Data Analysis Expressions) calculations to derive insights and perform complex data analysis.Data modeling, time intelligence calculations, creating DAX measures, and calculated columns for advanced data analysis.ETL (Extract, Transform, Load) processes to extract data from various sources, transform it using Power Query Editor, and load it into the data model.Integrating data from multiple sources to create comprehensive datasets. Cleaning and preparing data for accurate analysis and visualization.Using Power Query Editor and Power Query M Language for data shaping and manipulation.SQL and T-SQL for data querying and manipulation. Experience with SSIS for data integration and ETL workflows.Connecting to various data sources, including SQL Server, Excel, SharePoint, Web Services, and APIs. Performing data analysis, data mining, and predictive analytics to derive actionable insights.Optimizing Power BI reports for enhanced performance and faster data refresh.Knowledgeable in best practices for data visualization and effectively communicating insights through storytelling.Implementing row-level security to restrict data access based on user roles.Setting up on-premises data gateways and configuring them for secure data access.Power BI Embedded to integrate reports into custom applications using the Power BI REST API. Utilizing Power Apps and Power Automate for creating custom applications and automating business processes.Using Power BI Dataflows for data preparation and Power Automate (formerly Flow) for workflow automation.Implementing machine learning with Python, focusing on Statistics, Probability, Predictive Modeling, developing Recommender Systems and using advanced Data Mining techniques to solve complex problems.Proficient in designing robust databases, Data Warehouses, and efficient Data architectures for enhance performance and analytics.Creating and managing change requests for board review and approval, ensuring streamlined development processes.Daily use of version control with branches and committing changes for effective collaboration with thedevelopment team.Azure Developer/ETLUnited Health Care, Washington Dc Apr 2020 Apr 2021Cloud migration experience, specializing in Azure SQL Data Warehousing.Building efficient data pipelines in Azure Data Factory to copy data from source to destination and transformations.Creating and scheduling Stored Procedures in Azure for streamlined data operations. Data synchronization between SQL DB and ADLS (Azure Data Lake Storage) using Flows. Scheduling Jobs in Flows and ADF Pipelines for automated data processing.Deploying SSIS packages to Azure using Azure SSIS Integration Runtime (Azure -SSIS IR) and integrating with Azure Data Factory.Data validation, error handling, and debugging pipelines in Azure Data Factory for seamless ETL solutions.Proficient in creating Azure DevOps projects, configuring repositories, and managing version control with branches and pull requests.Experienced in working with Azure Data Factory pipelines for orchestrating data workflows and integration processes.Implementing DevOps practices and setting up continuous integration/continuous deployment (CI/CD) pipelines using Azure DevOps for efficient and automated application deployment.Using Azure Blob Storage, Azure Data Lake Storage, Azure SQL Database, Azure Data factory, Azure Synapse Analytics (formerly Azure SQL Data Warehouse), Azure Databricks, and Azure Analysis Services for effective data storage, integration, and analytics.Implementing IAM solutions using Azure Active Directory (Azure AD) for user authentication and authorization. Experienced in setting up role-based access control (RBAC) and managing Azure AD identities.Implementing security best practices, Azure Security Center, Azure Key Vault, Azure Firewall, and Azure Policy to ensure data protection and compliance with industry standards and regulations in the Azure environment.Deploying to development and testing environments, conducting business approval, and ensuring quality assurance.Gathering and analyzing QA results, making necessary adjustments, and pushing the final solution to production.ETL/SQL DeveloperBank Of America, Dallas, Texas Sep 2018 Apr 2020Developing SSIS packages for connecting to various data sources and constructing ETL workflows. Data validation, error handling, transformation, and loading for maintaining data integrity.Dynamic parameter and connection string management during package deployment across environments.Designing, building, and deploying ETL solutions packages for data integration and transformation. Experienced in designing and maintaining data warehouses to ensure efficient data storage and retrieval.Populating ETL tables with dynamic connection strings for flexible data processing.Developed intricate ETL solutions to extract data from diverse sources (SFTP, Excel, JSON, XML, CSV, flat files) using various source connections (OLEDB, ODBC, Excel, flat files) in SSIS.Utilized SSIS PowerPack source connection and script tasks to connect to SFTP servers, download and unzip zip folders.Employed script component as a source to connect to JSON source files for data extraction. Proficient in data transformation using SSIS components such as Data Conversion, Conditional Split, Sort, Multicast, Merge Join, etc.Proficient in deploying and automating SSIS packages for seamless data integration.Familiarity with Snowflake Data Warehousing, including the creation of external staging, file formats, and tables.Skilled in loading data to Snowflake Tables for efficient data storage and retrieval. Utilized cascading parameters in SSRS reports to create dynamic and interactive reports.Created schedules and email subscriptions in SSRS report manager for automated report delivery. Designed parametrized, drill-through, and drill-down SSRS reports and sub-reports for detailed data analysis.Developed, implemented, automated, and maintained ETL programs for streamlined data operations. Developing and optimizing sophisticated stored procedures and User Defined Functions (UDF).Utilizing temporary tables, views, and common table expressions for data aggregation. Performance optimization and query tuning using key lookup, indexes, statistics IO, and execution plans.Implementing various incremental loadings for optimized data updates and processing. Updated and optimized complex stored procedures to enhance data processing efficiency. Utilized window functions for ranking, sorting, and removing duplicates in data.Created and maintained databases and database objects, including stored procedures, views, CTEs, and temporary tables.Board DesignerTom Renewable Electric Bike, Addis Ababa, Ethiopia (Internship) Jan 2017 - Sep 2017Worked on a three-wheel board design on both hardware and software for the manufacture of electric vehicles in Ethiopia.Delivered presentations on our projects progress for the company and guests. Managed to successfully communicate with clients from China about technical stuff.Attended Prevention of Environmental Pollution meetings at, representing Tom Renewable Electric Bike Company.EDUCATIONMasters in Project ManagementAdmas UniversityBachelors Degree in Electrical and Computer EngineeringAddis Ababa University/ Addis Ababa University institute of technologyCERTIFICATIONSData Analytics, Nanolink Data Analytics Training Aircraft Flight Training, Leading Edge Flight AcademyEntrepreneurship Training Workshop, Entrepreneurship Development Center (EDC), (ETW)HANA MEKONNENDear Hiring Manager,I am writing to express my keen interest in your organization for a better career growth. With six plus years of experience in data analytics, healthcare technology, and financial domains, I am eager to bring my extensive expertise to your team and contribute to your innovative projects.During my tenure as a Power BI Developer at City Group, I honed my skills in crafting advanced DAX (Data Analysis Expressions) calculations to extract insights and perform intricate data analysis. I specialized in data modeling, incorporating time intelligence calculations, and creating DAX measures and calculated columns to facilitate advanced data analysis. My passion for transforming data into actionable insights, combined with my strong analytical capabilities, enabled me to deliver meaningful reports that empowered decision-makers.Furthermore, my tenure at United Healthcare allowed me to gain comprehensive knowledge of the healthcare landscape. This experience equipped me with a deep understanding of industry-specific challenges and opportunities, enabling me to create data-driven solutions that improve patient outcomes and operational efficiency.My role as an ETL/SQL Developer at Bank of America was pivotal in solidifying my expertise in the banking domain. I successfully developed SSIS packages, establishing connections with diverse data sources and constructing ETL workflows. This experience afforded me a holistic view of the financial sector, enhancing my ability to develop data solutions that align with industry-specific requirements.In my current role as a Power BI Developer at Acclaim Software / IC Solution, I am leveraging my proficiency in Power BI and Power Query for efficient data management, and to craft dynamic and interactive reports and dashboards. My diverse background and cross- disciplinary skills enable me to contribute to projects at both the front-end and back- end layers of developments.I am excited about the opportunity to bring my skills and experience to your company. Thank you for considering my application. I look forward to the opportunity to discuss my qualifications further.Best Regards,Hana Mekonnen |
