Post Job Free

Resume

Sign in

Power Bi Sql Server

Location:
Beltsville, MD
Posted:
February 02, 2024

Contact this candidate

Resume:

SEID Yasin

Email: ad3bau@r.postjobfree.com

Cell Phone:240-***-****

PROFESSIONAL EXPERIENCE SUMMARY:

Power BI Developer Over 7 years of experience

• Worked on all types of transformations that are available in the Power BI query editor.

• Published reports and dashboards using Power BI Desktop.

• Expert in creating and developing Power BI Dashboards with a rich look.

• Created Row-level security in the Power BI desktop and assigned the role.

• Used Power BI Gateways to keep the dashboards and reports up to date.

• Created Workspace, App, and content packs for business users to view the developed reports.

• Scheduled Automatic refresh and scheduling refresh in power BI service. Installed and Configured Enterprise Gateway and Personal Gateway in Power BI Services.

• Installed and configured Enterprise gateway and Personal gateway in Power BI service.

• Designed expressions to calculate, slice, group, bin, sort, filter, parameterize, and report contents.

• Generated scorecards with executive summary dashboards to display performance monitoring measures.

• Worked on all kinds of reports such as Yearly, Quarterly, Monthly, And Bi-weekly.

• Worked with internal and external business users and developers to assist with the development and implementation of new reports.

• Interact with various development teams, project managers, internal and external customers, and senior management.

• Provide estimates for development work and understand deadlines.

• Imported data from a variety of data sources like; SQL Server DB, Azure SQL DB, and Oracle database to Power BI to generate reports.

• Used Azure DevOps to Implement Scrum and sprint methodology practices.

• Running AI systems experiments and tests.

• Designing and developing a machine learning data model.

• Performing statistical analyses.

• Implementing machine learning algorithms

Technical Skill/ Environment

Power BI, Power Apps, Access, MS SQL Server, PLSQL, Oracle, Excel, API, Python, R, Pandas, SSIS, SSRS, SSAS, Machine learning, NumPy, Jupyter Notebook, Matplotlib, Scikit- Learn, Hyperion, power pages, Power Agent, HTML, Power Automate-flow, Azure AD, API, CSS, OMS and Repository, Word, PowerPoint, Teams, OneNote, ETL, Visual Studio 2016, SQL Server Profiler, Dashboard, SQL Server Management Studio, SQL Server Data Tools

(SSDT), Azure DevOps, Azure, Ad hoc environment, and Tableau Visualization, Azure Data Factory, Azure Data Lake

SEID Yasin

Email: ad3bau@r.postjobfree.com

Cell Phone:240-***-****

Exelon (BSC) May 2022 to current

Power BI Developer

• Used Power BI, and Power Pivot to develop data analysis prototypes.

• Develop and maintain Power Apps, Power Automate, Canvas Apps, Power platform, and model- driven Apps.

• Maintained, analyzed, and provided current information on the operation's business scorecard or key performance indicators (KPIs).

• Provided broad analytical and operational support to the business unit.

• Imported ServiceNow data from ENP into Excel and imported it to the Power BI desktop for the VPC monthly report.

• Building, and publishing customized interactive reports and dashboards, report scheduling using access, and transforming massive datasets through filtering, grouping, aggregation, and statistical calculation.

• Worked on headcount report and created calculated columns and measures by using DAX to achieve business logic needs.

• Wrote calculated columns, and Measures queries in the Power BI desktop to show good data analysis techniques.

• Maintained gateway in Power BI Service to schedule refresh.

• Used various data sources to pull data into Power BI such as Excel, SQL Azure Database, and SQL Database, Access, and Azure-based data services like Azure Data Factory, and Azure Data Lake.

• Worked on all types of transformations that are available in the Power BI query editor.

• Designed expressions to calculate, group, filter, parameterize, and format report contents.

• I set up Power Automate- flow for daily occurrence run reports with complex queries.

• To handle prior day data with the most current data to pick for Power BI, the Report runs daily and refreshes the data source whenever the file arrives at the source.

• Provided reports with great analysis and applied business logic concepts, customer intelligence gathering, forecasting, planning, scheduling, analytical and statistical problem solving, financial, accounting, business, and budget analysis.

• Applied analytical skills for project evaluation including analysis of departmental projects with economic, financial, risk, and decision analysis. Experience in business use case development.

• Provided customer-driven skills and basic analytical, problem solving and report management skills.

• I used Power Automate to Generate reports daily basis run in Power BI.

• Develop and conduct short-term and long-range business planning. Conduct complex modeling, forecasting, trending, variance analysis, business case development, and other financial and operational analysis.

• Prepared and analyzed comprehensive and detailed reports.

• I analyzed the operation's cost elements to ensure effective and efficient operations.

• Developed, organized, and presented detailed performance reports for both internal and external use.

Humana January 2021 to March 2022 Louisville Kentucky Power BI /SQL Developer Responsibilities:

• Expert in creating and developing Power BI Dashboards with a rich look. SEID Yasin

Email: ad3bau@r.postjobfree.com

Cell Phone:240-***-****

• Hands-on development assisting users in creating and modifying reports and data visualization dashboards.

• Created Power BI reports and dashboards to address business objectives and reporting requirements.

• Wrote calculated columns, and Measures queries in the Power BI desktop to show good data analysis techniques.

• Worked on all kinds of reports such as Yearly, Quarterly, Monthly, And Bi-weekly.

• Worked with internal and external business users and developers to assist.

• Created Workspace, App, and content packs for business users to view the developed reports.

• Scheduled Automatic refresh and scheduling refresh in power BI service.

• Generated scorecards with executive summary dashboards to display performance monitoring measures.

• Used various data sources to pull data into Power BI such as Excel, SQL Azure Database, and SQL Database, Access, Azure Data Factory, and Azure Data Lake.

• Used Azure DevOps to Implement Scrum and sprint methodology practices.

• Worked on Ad- hoc environment and created reports using SQL script.

• Updated Oracle script into Microsoft SQL script. USAID School Dropout Prevention Pilot Program January 2018 to September 2020 Washington, D.C

Power BI Developer Responsibilities:

• Used various sources to pull data into Power BI such as SQL Server, Azure DB, Oracle, and Excel

• Expertise in writing complex calculated measures by using DAX.

• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, bar, and density charts. Integrate custom visuals based on business requirements using Power BI Desktop.

• Exploring data in a different way and across visualization by using Power BI.

• Develop a Power BI dashboard and report from multiple data sources by using data blending. • Used various sources to pull data into Power BI such as SQL Server, Azure DB, Oracle, and Excel.

• Installed and configured Enterprise gateway and Personal gateway in Power BI service.

• Created Workspace, App, and content packs for business users to view the developed reports.

• Scheduled Automatic refresh and scheduling refresh in power BI service.

• Worked on all kinds of reports such as Yearly, Quarterly, and Monthly, and worked on weekly presentations to the business users about the reports and their changes as required.

• Generated scorecards with executive summary dashboards to display performance monitoring measures.

• Used multiple join statements to retrieve data and update the tables.

• Develop SQL queries/scripts to import data from the Oracle database.

• Created stored procedures, Views, and SQL queries to pull data into the Power BI model. provide basic analysis and apply managerial accounting concepts, customer intelligence gathering, forecasting, staff planning, scheduling, analytical and statistical problem solving, financial, accounting, business, and budget analysis. SEID Yasin

Email: ad3bau@r.postjobfree.com

Cell Phone:240-***-****

• Basic analytical skills for project evaluation including analysis of departmental projects with economic, financial, risk, and decision analysis. Limited experience in business case development.

• Customer-driven with good oral and written communication skills and basic analytical, problem- solving, and project management skills.

Montgomery County Public Schools January 2016 to January 2018 Silver Spring, Maryland SQL Server BI / Power BI Developer Responsibilities:

• Expert in creating and developing Power BI Dashboards with a rich look.

• Created Power BI reports and dashboards to address business objectives and reporting requirements.

• Used multiple join statements to retrieve data and update the tables.

• Develop SQL queries/scripts to import data from the Oracle database.

• Created stored procedures, Views, and SQL queries to pull data into the Power BI model.

• Creating team sites and communication sites in SharePoint.

• Delivered on-demand and scheduled reports on daily, weekly, monthly, and quarterly Reports including status for business analysis or management decisions using SQL Server Reporting Services.

• Develop a Power BI dashboard and report from multiple data sources by using data blending.

• Wrote calculated columns, and Measures queries in the Power BI desktop to show good data analysis techniques.

• Embedded Power BI report in SharePoint sites.

• Created Views and SQL queries to pull data into the Power BI model.

• Worked with database objects like Stored Procedures, User Defined Functions, Triggers, and Indexes using T-SQL to create complex scripts and batches.

• Implemented package configurations on the development, test, and production environments.

• Responsible for the performance tuning of the SQL Commands and the troubleshooting of the technical problems in MS SQL Server with the use of the Query Analyzer and Database Engine Tuning Wizard.

• Wrote SQL queries on data staging tables and data warehouse tables to validate the data results in Database creation (DDL, DML, DCL), database tuning, SQL tuning, and performance planning. Education

Bachelor’s degree in veterinary - JIMMA University June 2012 Master of Data Science planned Graduation July,2024 Microsoft Certified: Power BI Analyst Associate January 2024 Business Analytics and Data Visualization Nanodegree-UDACIT October 2020



Contact this candidate