| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateMaki KetemaEmail: EMAIL AVAILABLE Phone: PHONE NUMBER AVAILABLEAddress: Street Address Sophie Pearl Ln., Columbus, OHDATA ANALYSTSUMMARYExperienced Data Analyst and BI Developer with over 7 years of expertise in data analysis, reporting, and business intelligence. Proven ability to lead the full development life cycle of Power BI projects, including data extraction (ETL), data transformation, and visualization. Skilled in SQL, data warehousing, and data modeling with a strong background in delivering actionable insights to drive business decisions. Adept at working with large datasets, building automated dashboards, and translating complex data into easy-to-understand formats for stakeholders.TECHNICAL SKILLSData Analytics & Visualization Tools: Power BI, Tableau, SSRS, Excel (Advanced), Power QueryETL Tools & Data Warehousing: SQL Server Integration Services (SSIS), Azure SQL Data Warehouse, Snowflake, and data modeling.Databases & SQL: T-SQL, MySQL, PostgreSQL, Stored Procedures, Query Optimization, JoinsProgramming Languages: Python (Pandas, NumPy), DAX, Data GovernanceCloud Platforms: Azure, Snowflake, AWSProject Management Tools: Jira, ConfluenceAgile Methodologies: Agile, Scrum, WaterfallOther Tools: Google Analytics, Git, Visual Studio (2012/2016/2019)PROFESSIONAL EXPERIENCEProgressive Healthcare SolutionsData Analyst Power BI DeveloperApril 2022 PresentDeveloped and implemented Power BI dashboards to track key performance indicators (KPIs) and business metrics.Ensure accurate reporting by verifying data integrity and cross-referencing information from multiple sources.Prepare and present reports to stakeholders, management, or clients to support their decision-making processes.Gathered and translated business requirements into data-driven solutions, enhancing operational efficiency and decision-making.Designed data models and created advanced reports using DAX, ensuring accuracy and data integrity across multiple systems.Collaborated with stakeholders to align reporting frameworks and provide training to internal teams on Power BI usage.Migrated data across cloud platforms (Azure, Snowflake, and implemented ETL processes to optimize data pipelines.Ensured compliance with data security policies by implementing row-level security and managing access control.Data Storytelling: Interpret complex datasets and effectively communicate insights both in written and verbal format.BGE (Baltimore Gas and Electric), Baltimore, MDData AnalystFebruary 2020 March 2022Designed, developed, and supported enterprise-level dashboards and reports in Power BI to monitor key metrics and performance indicators.Collaborated with cross-functional teams to gather reporting requirements, ensuring alignment with business objectives and data needs.Utilized SQL to extract, transform, and load (ETL) data from the companys data warehouse, improving data accuracy by 15%.Delivered ad hoc reports and automated dashboards that streamlined data analysis, reducing manual reporting time by 40%.Provided training and technical support for Power BI end users, improving user adoption and self-service reporting capabilities.JP Morgan Chase, Columbus, OHData AnalystJanuary 2018 January 2020Write and optimize SQL queries to extract data from relational databases.Use Python, R, or other programming languages to automate data extraction, transformation, and analysis.Retrieve and manipulate data from multiple data sources (structured and unstructured).Work closely with business units, IT teams, data scientists, and product managers to understand data needs and objectives.Translate business requirements into technical specifications for data solutions.Collaborate with stakeholders to identify their goals, challenges, and how data can address them.Built and optimized Analysis Services reporting models using Power BI Desktop and SQL, improving reporting efficiency.Developed visual reports, KPI scorecards, and dashboards, using advanced DAX functions and transforming data from multiple sources.Created and managed SQL databases, ensuring high availability, security, and disaster recovery.Worked with business and IT teams to implement BI reporting solutions, resulting in more informed decision-making across departments.EDUCATIONBachelor of Science in Computer ScienceAddis Ababa UniversityGraduation Date: May 2017 |