Power Bi Consultant Resume
3.00/5 (Submit Your Rating)
SUMMARY
- Having 4+ years of IT experience in Business intelligence (Power Apps Studio, Power BI desktop, Power BI desktop Pro, Power BI Service report server, SQL Server) and other related IT development technologies.
- Strong knowledge on Power Apps development for various business users according to their requirement.
- Experience in customizing the Power Apps according to the need of business users.
- Worked on integrating data from Excel sheets, SQL server, SharePoint, and Office 365 for app building.
- Ability to build Power Apps using SharePoint as a data source and utilize SharePoint lists to access, share and collaborate around structured data.
- Experience in importing power apps feature within Power BI reports.
- Experience with Power Automate, creating flows within power apps.
- Experience using DAX for various data modeling and data operations.
- Experience in communicating with stakeholders, Subject Matter Experts (SMEs), and end - users to better understand, analyze, communicate, and validate requirements.
- Experience in developing custom reports, and different types of Tabular Reports, Matrix Reports, Ad-hoc Reports, Drilldown, Parameterized, Cascading, Conditional, Table, Matrix, Chart, and Sub Reports.
- Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model) and MS Excel.
- Worked on creating SSIS packages to schedule data transfer from FTP to SQL data warehouse.
- Responsible for creating automated business process improvement solutions using web forms, metrics, workflows, and dashboards.
- Ability to deliver the required work assigned ahead of the given time frame.
- Experienced in adapting to different working atmospheres and possess the unmatched ability to work in teams.
- Ready to face new challenges every day and overcome them with utmost hard work.
TECHNICAL SKILLS
- Power BI
- DAX
- Power Apps
- SQL
- Microsoft Office: Word
- Excel
- PowerPoint and Access
- Windows
- UNIX
- C++ and C.
PROFESSIONAL EXPERIENCE
Confidential
Power BI Consultant
Responsibilities:
- Worked as a Power BI consultant where I have developed the dashboards for different business teams.
- Fetched the data from different sources like SharePoint and cloud solutions like O Data feed and MS Access data base - Flat files, Excel, SQL servers, Azure SQL and Azure SQL DW.
- Used different features in Power BI like Transpose, Split column by delimiter, add column, Get Data, Report tab, Data Tab, Relationships.
- Used the option Replace Values to dynamically replace the values for few business cases.
- Created New measures, New Columns and applied the DAX statements to dynamically populate the business logics in the New Columns/New Measures
- Used different Visualizations like Donut Chart, Clustered Column Chart, Table (For detailed level data), Slicers, Text boxes, Pie Chart, Waterfall Chart, Filled map etc.
- Used the options like Buttons to guide the data for end users like Left Arrow, Right Arrow and Reset.
- Initially created the dashboards using desktop version and then published to the workspaces of different businesses in the app.powerbi.com
- Sorted the months based on number instead of default behavior by alphabets.
- Develop Power BI reports used for sales and inventory reporting of vehicles for each dealer around North America.
- Use various sources to pull data into Power BI such as SQL Server, Data Lake, Amazon redshift, SQL Azure etc.
- Create Workspace and content packs for business users to view the developed reports.
- Experience in importing customized SQL Queries to Power BI.
- Experience in creating Ad-hoc granular reports within Power BI.
- Schedule Automatic refresh and scheduling refresh in Power BI service.
- Develop Power BI model used for financial reporting of P & L and Headcount.
- Use various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
- Weekly presentation to the business users about the reports and their changes as required.
- Created Power BI dashboards for a rewards program as per the requirements given by the business.
- Highlight different KPIs as per the business requirement to show the number of registered user scans and different bonuses offered in the dashboard.
- Developed dashboards over different timelines (i.e. Daily, Weekly, Monthly MTD, YTD).
- Worked extensively with bookmarks to meet different business requirements in Power BI.
- Created dashboard displaying the information required for the Construction Managers and Regional Construction managers.
- Proficient working in Agile Scrum model to deliver different stories within 2-week sprints.
- Provide daily status report on the stories being worked on and proper burn down chart efforts tracking.
Confidential
Power BI Developer
Responsibilities:
- Develop Power BI reports used for sales and inventory reporting of vehicles for each dealer around North America.
- Use various sources to pull data into Power BI such as SQL Server, Data Lake, Amazon redshift, SQL Azure etc.
- Create Workspace and content packs for business users to view the developed reports.
- Extensive experience using Power query for data preparation.
- Experience in importing customized SQL Queries to Power BI.
- Experience in creating Ad hoc granular reports within Power BI.
- Schedule Automatic refresh and scheduling refresh in Power BI service.
- Weekly presentation to the business users about the reports and their changes as required.
- Load data through a JSON file which can be connected by calling an API.
- Worked on creating multiple layouts with different look and feel for the business users.
- Create stored procedures and SQL queries to pull data.
- Preparing the migration/deployment documents during the deployments.
- Monitoring the SQL agent jobs and communicating the job statistics and failures.
Confidential
Power BI/Power Apps Developer
Responsibilities:
- Created and customized various mobile layouts using Power Apps Studio.
- Created Power BI dashboards for a rewards program as per the requirements given by the business.
- Highlight different KPIs as per the business requirement to show the number of registered user scans and different bonuses offered in the dashboard.
- Developed dashboards over different timelines (i.e. Daily, Weekly, Monthly MTD, YTD).
- Worked extensively with bookmarks to meet different business requirements in Power BI.
- Created dashboard displaying the information required for the Construction Managers and Regional Construction managers.
- Worked on fetching the data from a third-party application using the FTP integration.
- Created an SSIS package to automate transfer of new incoming files from FTP server to Local shared path and then transfer to Data warehouse from where it can be loaded to Power BI.
- Managed publishing the dashboards on the app.powerbi.com workspaces and scheduling the dashboards to refresh the data on a daily/weekly basis.
- Proficient working in Agile Scrum model to deliver different stories within 2-week sprints.
- Provide daily status report on the stories being worked on and proper burn down chart efforts tracking.
Confidential
Power BI Consultant
Responsibilities:
- Worked as a Power BI consultant where I have developed the dashboards for different business teams.
- Fetched the data from different sources like SharePoint and cloud solutions like O Data feed and MS Access data base - Flat files, Excel, SQL servers, Azure SQL and Azure SQL DW.
- Used different features in Power BI like Transpose, Split column by delimiter, add column, Get Data, Report tab, Data Tab, Relationships.
- Used the option Replace Values to dynamically replace the values for few business cases.
- Created New measures, New Columns and applied the DAX statements to dynamically populate the business logics in the New Columns/New Measures
- Used different Visualizations like Donut Chart, Clustered Column Chart, Table (For detailed level data), Slicers, Text boxes, Pie Chart, Waterfall Chart, Filled map etc.
- Used the options like Buttons to guide the data for end users like Left Arrow, Right Arrow and Reset.
- Initially created the dashboards using desktop version and then published to the workspaces of different businesses in the app.powerbi.com
- Sorted the months based on number instead of default behavior by alphabets