| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email: EMAIL AVAILABLEPhone: PHONE NUMBER AVAILABLEPROFESSIONAL EXPERIENCEPower BI Developer Over 7 years of extensive experience in developing Business Intelligence (BI) solutions, ETL processes, business flows, and data analysis using Power BI, SQL Servers, and financial models. Proficient in MS SQL Server Integration Services (SSIS) and MS SQL Server Reporting Services (SSRS) for Business Intelligence applications. Skilled in data cleaning, validation, and analysis using Data Analysis Expressions(DAX) for creating calculations and measures in Tabular Models. Proficient in Power BI UX Admin, using Power BI Desktop and generating Power BI Reports. Hands-on experience with SQL programming and Transact-SQL (T-SQL) for creating tables, stored procedures, triggers, user-defined functions, views, indexes, and relational database models. Knowledge in managing Azure Data Factory (ADF), Azure Blob Storage, Azure Data Lakes (ADLS), and Azure SQL Data Warehouse (DW). Expert in developing SSIS packages to extract, transform, and load (ETL) data into data warehouses from heterogeneous databases such as MS SQL. Strong knowledge of Data Warehousing methodologies, including star schemas, snowflakes, ETL processes, dimensional modeling, and reporting tools. TECHNICAL SKILLS Data Warehousing and MS BI: SSIS, SSRS, SSAS DAX Power BI: Power BI Desktop, Power BI Service, Data Gateway, Database and Sources: Advanced Excel, SQL Server, Azure Data Factory (ADF), Azure Blob, Azure Data Lakes (ADLS) Manhattan WM, SAP Extended Warehouse Management (EWM) WORK EXPERIENCESr. Power BI DeveloperOne Main Financial, Feb. 2021 Present Structured semantic layer data for improved analysis and reporting. Integrated Manhattan WM, SAP EWM, and Oracle WMS for seamless data flow. Utilized DAX for creating complex measures and calculated columns. Optimized performance by writing and refining complex queries. Candidate's Name
Email: EMAIL AVAILABLEPhone: PHONE NUMBER AVAILABLE Implemented Power BI gateway for real-time data updates from on-premise sources. Set up Power BI environments, creating app workspaces, publishing apps, and configuring Power BI Gateway. Imported custom themes and page backgrounds for enhanced visual appeal. Performed end-to-end testing to ensure data quality and accuracy. Managed schema objects, including tables, views, indexes, and referential integrity. Scheduled and maintained various tabular reports in Power BI. Managed the complete SSIS lifecycle, including development, deployment, and execution. Worked closely with the Safety and Compliance department to ensure data integrity and compliance.Power BI DeveloperOne Main Finance, Jan. 2020 Feb. 2021 Set up Power BI environments, created app workspaces, published apps, and configured Power BI Gateway. Leveraged bookmarks for efficient report navigation. Utilized Power BI gateway for real-time updates with on premise data sources. Developed drill-down and drill-through reports with hierarchical details. Created calculated columns and measures using DAX. Maintained and scheduled various tabular reports in Power BI. Explored data across multiple visualizations using Power BI. Data AnalystTravelers, NY, July 2017 - Dec 2019 Gathered report requirements and determined optimal solutions for reporting. Developed monthly, weekly, and daily reports and managed roles and user access. Implemented row-level security and application security models in Power BI. Set up Power BI environments and configured Power BI Gateway. Utilized Power BI gateway for real-time data updates from on premise sources. Generated accurate queries for Power BI using Direct Query. Utilized Power Query for data cleansing and transformation. Implemented event handlers and error handling in SSIS packages. Candidate's Name
Email: EMAIL AVAILABLEPhone: PHONE NUMBER AVAILABLE Created dashboards from live SharePoint lists and other data sources. BEST EXPERIENCE AND PROJECTHighlight Project: Comprehensive Financial Reporting Solution At One Main Financial, I spearheaded a project to develop a comprehensive financial reporting solution. This project involved: Integrating multiple data sources including Manhattan WM, SAP EWM, and Oracle WMS into Power BI for a unified reporting platform. Developing complex financial and sales reports that provided actionable insights to stakeholders. Utilizing advanced DAX expressions to create sophisticated measures and calculated columns. Implementing real-time data updates using Power BI gateway for on-premise data sources, ensuring stakeholders had the latest data for decision-making. Optimizing performance through efficient query writing and index tuning, ensuring fast and responsive reports.What Makes Me Special Technical Expertise: Proficient in a wide range of BI tools and technologies, including Power BI, SSIS, SSRS, and SQL Server, ensuring robust and scalable solutions. Problem-Solving Skills: Exceptional ability to analyze complex business requirements and translate them into effective BI solutions. Attention to Detail: Rigorous in ensuring data accuracy and quality, leading to reliable and trustworthy reports. Collaboration: Strong communicator who works effectively with stakeholders at all levels to deliver solutions that meet business needs. Continuous Improvement: Always looking for ways to enhance processes and deliver more value through innovative solutions.EDUCATION Bachelor of Applied Science in Accounting & Financial Technology, Addis Ababa University |
