Power Bi Business Intelligence

Manisha B Email: ************@*****.***

Power BI Cell: +1-945-***-****

Summary:

Over seven years of experience as a certified business intelligence professional involving the full life cycle of business development, including requirement gathering, analysis, design, development, and delivery of business intelligence solutions utilizing a variety of BI offerings, tools, and methodologies to transform big datasets into meaningful insights.

Proficient experienced in implementing Data Warehousing BI Application Development using Power BI.

Created highly interactive Data Visualization dashboards.

Experience in Power BI 1.X/ 2.X; proficiently designed/built complex stunning reports/dashboards in Power BI Desktop.

Developing the Relational and Dimensional Model and applied data level and object level securities.

Proficient in visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards; designed and developed dashboards by extracting data from different sources like SQL Server, Oracle, Excel files.

I have expertise in traditional databases such as Oracle, SQL Server, DB2 and Teradata and in cloud-based databases Snowflake, Impala and AWS redshift for creating the aggregated/summary views for BI needs.

Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling, and reporting tools.

Have good understanding of Tableau architecture, design, development, and end user experience.

Proficient in RDBMS and good programming experience in oracle11g /sqlserver2012 and DB2.

Experience in Handling Heterogeneous data sources like SQL Server, Oracle, MY SQL, Hadoop, Excel, and CSV files using Power BI.

Performed data cleaning, data validation, and data analysis using Data Analysis Expressions (DAX).

Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.

Handled change requests and provided support/maintenance for deployed projects.

Developed KPI’s and dashboards based on reports, spreadsheets, and charts.

Worked on data blending and increased the dashboard performance by extracting data.

Strong commitment to organizational work ethics, value-based decision-making and managerial skill.

Business Intelligence Tools

Power BI, Framework Manager, SQL server management studio, Visual Studio

Data Visualization

Tableau 8.x/9.x/10.x/2018.x/2019.x/2020.x and Power BI 1.x/2.x and AWS Quick Sight.

Databases

Oracle 8i/9i/10g/11g, SQL, PL/SQL, MS SQL Server 2014/2012/2008/2005, DB2, MS Access, Teradata

Cloud-based Databases

Microsoft Azure, AWS, DevOps

Front-End Tools

Microsoft Office, Microsoft Excel

Productivity Tools

SQL workbench, Jira

Version Control Tools

Win CVS

ETL

SSIS

Project Summary:

1.Company: Wipro Duration: Sep 2022 – Till date

Projects: US Bank Location: Bangalore, India

Technologies: Power BI, AAS, Azure, Snowflake and SQL Role: Data Analyst

Responsibilities / Deliverables:

Analyzed Business Requirements for Reports, worked closely with business analysts to understand the business needs.

Analyzed system documentation like Requirements document, Gap Analysis User Interface Specifications to develop technical document of the business flow and develop and execute the Models and Reports.

Responsible for analysis, design, and development of Power BI dashboards/reports and assisting end users on application functionality. Provided strategic solutions and troubleshooting of Business Intelligence applications.

Responsible for analysis, design, development of Actively working with the Business Partners to get the requirements and create the High-level design documents.

Attending daily SCRUM meetings related to the Projects. Participated in Retrospective Planning Meetings.

Work closely with senior management to gather requirements, prepare documentation, mockup dashboards and write functional specifications.

Connect to cubes that are available on Analysis Services with a direct connection.

Understand the mockup provided by the business users.

In depth involvement of architecture design and cloud computing, infrastructure, storage, platforms, and data.

Experience in Power BI for advanced analytics and reporting capabilities.

Experience in handling large scale data, including data ingestion, enrichment, Modeling, workflow, and implementing metrics calculation for reporting.

Experience in development of business application with focus on Microsoft Power Platform.

Experience in Agile methodology and working on JIRA stories.

Create mapping document between the cube and mockup to make the development easy.

Write DAX formulae to create calculated columns and new measures based on requirements.

Create multiple visualization like matrix, charts, slicers, buttons, and shapes to suffice the requirement.

Create bookmarks and page navigations wherever necessary.

Follow Power BI best practices by grouping the visuals for better understanding of fellow developers in the team.

Designing and implementing proof of concept solutions and created advanced BI visualization.

Power BI dashboards and assisting the end users on application functionality. Provided the strategic solutions and troubleshooting the Business Intelligence applications.

Actively working with the Business Partners to get the requirements and create the High-level design documents.

Attending daily SCRUM meetings related to the Projects. Participated in Retrospective Planning Meetings.

Collaborated with team members to prototype, test, and debug code which will provide data for use in business reports

Designing and implementing proof of concept solutions and created advanced BI visualizations using Tableau platform.

Extensively worked on Performance tuning, Testing, and validating the data.

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

2.Company: Wipro Duration: June 2020 – Aug 2022

Projects: Lloyds Banking Group Location: Bangalore, India

Technologies: Power BI, SSIS and SQL Role: Power BI developer

Responsibilities / Deliverables:

Responsible for analysis, design, development, and implementation of Business Intelligence Applications.

Interacted with business team member to gather requirements.

Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.

Create the data model by importing tables from Oracle DB, Excel files from SharePoint site, create custom columns/tables based on the requirement and ensure these tables are intact.

Write DAX formulae to create calculated columns and new measures based on requirements/enhancements.

Develop Power BI Reports, publish to Power BI service and schedule such reports as per the need.

Use Power BI query editor to create queries needed to connect views in Oracle DB, SharePoint excel files and Databricks.

Using Agile methodology worked on new requirements, enhancements to existing reports & dashboards.

Made dataset accessible to other members published on Power BI Service.

Use Row Level Security to restrict user access to data.

Create multiple reports understanding the use case of client during demo.

Provide support during Releases, Enhancements and hotfixes and ensure right changes are deployed for each sprint.

Primary contact for Development/On-call/Production support and Service Management.

Developed simple to complex reports using lists, crosstabs, charts & graphs to meet user requirements.

Design & development of the reports using Report Studio, Query Studio and Analysis Studio.

Provide continued maintenance and development of bug fixes for the existing and new Power BI reports.

Developed Powe BI reports in desktop which include multiple visuals, data models, and slicer.

Included custom visuals, parameters and filters based on business requirements using Power BI desktop.

Calculated ratio and expenses on Power BI reports using DAX function and T- SQL

Extensively used custom R-Visuals, Clustered Bar Charts, Clustered Column charts, Donut Charts, Hierarchy slicers, Waterfall charts, Scatter charts, Area charts, KPI s in power BI reports.

Embedded Power BI reports to portal. Managed and secured data and report for individual users by implementing RLS and Roles.

Built and published customized interactive dashboards utilizing Power BI.

Explore data in a variety of ways and across multiple visualizations using Power BI.

Used different types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

3.Company: WIPRO Duration: August 2018 – May 2020

Projects: AVIVA Location: Bangalore, India.

Role: Power BI Developer

Responsibilities / Deliverables:

Using a Query Editor in power BI performed certain operations like Fetching data from different file.

Worked with import and direct query, creating custom table in the power BI.

Merged and appended queries, removed and split columns, chose required columns in the data.

Worked with different transformations, Applied steps in query editor.

Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.

Involve in requirements gathering during initial project initiation.

Involve in data analysis, documentation preparation by writing SQL Queries to retrieve the data.

Create stored procedures and call them in SSIS Packages to load the data from one database to another within the server.

Prepared Root Cause Analysis reports when there is a data mismatch and document it.

Prepared documents with steps when Power BI dashboards are developed/enhanced.

Prepared Unit test cases during the testing phase to ensure the code is covered and working properly.

Create scheduled reports, jobs using SSMS to load data properly.

Make dashboards accessible to other members published on Power BI Service.

Using the Power BI Service Desktop tool, dashboards and reports were developed using data sources from Excel, SQL Server, SharePoint List, and Report Server.

Using Power BI Designer, the data model was created in accordance with the data's structure and hierarchy.

Developed suitable indexes and indexed views to shorten the execution time of intricate queries.

Developed databases with stored procedures, views, triggers, and cursors.

Created dashboards with Power BI Desktop and Power BI Service by utilizing cutting-edge data visualization tools and lightning-fast slice and dice.

Involved in creating and disseminating user-friendly, aesthetically pleasing Tableau dashboards for executive decision-making.

Designed dashboard templates as per the requirement & dashboards content which includes complex tabular reports, bar charts, water fall charts, score cards, Gantt charts, Bubble charts.

Applied joins, correlated and non-correlated subqueries to intricate business queries that comprise calculations from several databases and multiple tables.

Created Filters, Groups, Sets on Tableau Reports.

Education Qualifications:

Master of Science (Information Technology) in 2018 from Vellore Institute of Technology securing CGPA of 8.54, Bangalore, India.

Bachelor of Science (Computers) in 2013 from Acharya Nagarjuna University securing 81.6% with First Class Distinction, Andhra Pradesh, India.

Contact this candidate