Gowthami

Project Details: Project 1:

Client : JOHNSON & JOHNSON Role : Power BI Developer Database : SQL Server Environment : Power BI and SQL Server Project Description: Johnson & Johnson (J&J) is an American multinational corporation founded in 1886 that develops medical devices, pharmaceuticals, and consumer packaged goods. Johnson & Johnson's brands include numerous household names of medications and first aid supplies. Among its well-known consumer products are the Band-Aid Brand line of bandages, Tylenol medications, Johnson's Baby products, Neutrogena skin and beauty products, Clean & Clear facial wash and Acuvue contact lenses The company published "Modern Methods of Antiseptic Wound Treatment", a guide on how to do sterile surgery using its products.

Roles & Responsibilities:

• Extracting data from multiple sources like, Excel and validating data and loading into Final Destination.

• Good Experience on Power Query and DAX functions.

• Creating a drill down and drill through reports.

• Created charts like Lines, Pies, Bar, Scatter, Area, Tree map, Map, filled map, Gauge, Funnel, Single Card, Multi row card, Slicer etc. • Followtheexisting reports and createnewreportusing Power BI.

• Modifying existing reports as per client requirements.

• Applying filters toparticular visual or tablein thereport and editinteractions.

• Have good Experience to Implement RLS as part of security.

• Working on DAX functions like Date & Time, Information, Filter & Value, Logical, and Text.

• Updating weekly status and keeping track of overall development status for the project.

• Generated Dashboards for different modules.

• Created Relationships for Customer Data and created reports.

• Experience in developing Visualization reports and dashboards using Power BI. Project 2: Client : CISCO SYSTEMS INC Role : Power BI Developer Database : SQL Server Environment : Power BI and SQL Server Project Description: Cisco Systems, Inc. is an American multinational technology conglomerate corporation headquartered in San Jose, California. Cisco develops, manufactures and sells networking hardware, software, telecommunications equipment and other hightechnology services and products. Cisco partners can offer cloud-based services based on Cisco's virtualized Unified Computing System (UCS). Cisco specializes in specific tech markets, such as the Internet of Things (IoT), domain security and energy management.

Roles & Responsibilities:

• Working on MS SQL Server and written queries to import the data into Power BI.

• Implemented Visual Level, Page level, report level filters and pinning in dashboards.

• Written simple DAX calculation as per the requirement to maintain business measures.

• Worked on report permissions and dashboard permissions to provide access to different users.

• Designed complex and interactive Web reports based on discussionswith users and created various objects using functions, complex SQL queries and joins considering best business practices using RichClient.

• WorkedonthePower BI Reports &Dashboards with PowerBIServices.

• Creating the roles for the dashboards, sharing the developed dashboards to the client in power BI.

• Used various filters to restrict the data and created Slicers for the user perspective.

• Created New Calculated column and Measureusing DAX Expressions.

• As per the requirements, rendering the reports in the form PDF, CSV and Excel formats.

• Connect, import, shape, and transform data for business intelligence (BI).

• Experience in developing Visualization reports and dashboards using Power BI

• Visualize data, author reports, and schedule automated refresh of reports.

• Designed different Types of reports like Table, Matrix, Drill Down, Drill Through, Sub reports, Parameterized Reports and Cascading reports based on client requirement.