P. Gayathiri Devi

With over 12 years of experience in Microsoft BI tools, I have honed my expertise in Power BI, SSRS, SSIS, and SSAS. My career progression from Software Specialist to Solution Architect spans renowned firms like Sundaram Infotech, Hexaware Technologies, ILink MultiTech and Sutherland Global Solutions. I am recognized for my ability to deliver critical Power BI solutions, train colleagues, and ensure project success through effective client coordination and technical proficiency. As an architect, I excel in designing and implementing robust data solutions that meet complex business requirements and drive strategic outcomes. My dedication to technical excellence and team leadership has facilitated successful BI implementations and advanced analytics.

• Analyzing and Visualizing Data with Microsoft Power BI (70-778)
• Microsoft SQL Server 2008, Business Intelligence Development and Maintenance (70-448)
• Microsoft SQL Server 2008, Implementation and Maintenance (70-432)
• Querying Microsoft SQL Server 2012/2014 (70-461)
• Implementing a Data Warehouse with Microsoft SQL Server 2012/2014(70-463)

EXHIBIT 1: POWER BI MVP PROJECT - HEALTHCARE DRUGS ANALYSIS AND PATIENT DATA ANALYSIS

Databricks Querying and Power BI

The Purpose of the Project is to create Power BI Reports on analyzing different modules based on different drugs and patient services.

Roles and Responsibilities
One to One Client Co-ordination | Architecture and Design for entire project. | Developed end to end functionalities. |

Built Data Model, implemented Dynamic RLS. | Following Best Practices on creating Dax measures and M Query columns. |

Implemented Bookmarks, Drill through and Drill down reports, Paginated Reports |
Developing Power BI Reports using source as Data bricks and synapse |

Publishing Power BI Reports in Service | Successfully delivered reports- Go Live with in planned dates.

EXHIBIT 2: POWER BI REPORT – HEALTHCARE (DATA BRICKS AND SYNAPSE)

Databricks Querying and Power BI
The Purpose of the Project is to create Power BI Reports on Health care machines and Analyzing Data from Machine Results.
Roles and Responsibilities
Client Co-ordination | Architecture and Design for the project. | Creating Power BI Data Model |

Implemented Bookmarks, Dynamic RLS, Drill through and Drill down reports | Developing Power BI Reports using source as Data bricks and synapse | Publishing Power BI Reports in Service.

EXHIBIT 3: POWER BI REPORT - UK

BI Solution: Business Intelligence and Power BI
Power BI Dashboards for Driver Quality – Audit Report
Roles and Responsibilities
Client Co-ordination, Requirement Analysis | Architecture and Design for the project. | Creating Power BI Data Model |
Developing Power BI Reports using Oracle Source – Import Option | Publishing Power BI Reports in Service |
Sharing Reports to End Users with Row level security.

EXHIBIT 4: POWER BI – SERVICE NOW

BI Solution: Business Intelligence and Power BI
Power BI Dashboards for Incidents, service request, Change Requests.  
Roles and Responsibilities
Governing the Team | Client Co-ordination, Requirement Analysis | Architecture and Design for the project. |
Creating Power BI Data Model | Coding SQL Procedures /SSIS jobs for Staging and scheduling jobs |
Developing Power BI Reports using SQL – Import Option/Direct Query (composite Model) |
Publishing Power BI Reports in Service | Scheduled using Gateway.

EXHIBIT 5: POWER BI REPORT – SPEECHSTORM

BI Solution: Business Intelligence and Power BI
Power BI Report designed in the Purpose of Analyzing IVR Customer Hang-up & System Hang-up Calls for all Line of Business with respective to Date Dimension. Survey Analysis with NPS and CSAT is Calculated. IVR Journey for all Call Flows are listed.
Roles and Responsibilities (Working in Client Place for 4 months)
Client Co-ordination, Requirement Analysis | Architecture and Design for the project. | Data Analysis |
Modelling & developing SQL Query | Developing Power BI Reports using SQL – Import Option/Direct Query (Dual Model)
Implemented RLS in Power BI Reports for LOB | Publishing Power BI Reports in Service | Scheduled using Gateway.

EXHIBIT 6: POWER BI REPORT - TIME & ATTENDANCE DASHBOARD

BI Solution: Business Intelligence and Power BI
Power BI Dashboard designed for Time & Attendance Management Analysis. Analyzing Shrinkage and Created Reports for Company Level, Manager Level and Supervisor Level.
Roles and Responsibilities
Client Co-ordination & Support | Architecture and Design for the project. | Creating SSAS Model |
Developing Power BI Reports using SSAS Source – Import Option | Implemented RLS in Power BI Reports
Publishing Power BI Reports in Service | Scheduled using Gateway.

EXHIBIT 7: POWER BI REPORT – RECEIPT ANALYSIS DASHBOARD

BI Solution: Business Intelligence and Power BI
Power BI Report designed for Receipt Analysis Dashboard for Management Analysis. Analyzing Different Payment Modes and Focusing for Online Payment Mode.
Roles and Responsibilities

Client Co-ordination & Support | Modelling & developing SQL Queries
Developing Power BI Reports using SQL Source – Direct Query Option | Implemented RLS in Power BI Reports |
Created User Interactive Bookmarks | Publishing Power BI Reports in Service | Configuring gateway for SQL Source.

EXHIBIT 8: POWER BI REPORT – SALES DASHBOARD FOR FINANCIAL SERVICES

BI Solution: Business Intelligence and Power BI
Sales Dashboard designed for Sales Management for Dealer Information.

Roles and Responsibilities
Client Co-ordination & Support | Creating ETL and SSAS Cube | Designing Power BI Reports using SSAS – Import Option
Sync Slicers for Dealer level filter for much better End user interactivity in Power BI report.
Publishing Power BI Reports server. | Schedule Refresh in Power BI report Server.

EXHIBIT 9: BI FOR ENGINEERING ADHESANT & SEALANTS MAJOR IN INDIA

BI Solution: Multi-dimensional reporting solution using SSRS & Cubes

The objective of the proposed solution is to build OLAP cube for the following dimensions:
•Sales •Purchase •Work order  
The data for the cubes is maintained in a separate repository database from the Live data captured using MS Dynamics Navision. The client accesses the cubes using Power BI and Report Builder tool of SSRS which is part of MSBI. The training for the same has been provided beforehand. Interactive Dashboards for End users provided with scheduling of data refresh and filters.

Roles and Responsibilities
Client Co-ordination & Support | Modelling & Creating SSAS Cubes |

Provided Training to Client to work in Report Builder & Power BI with well defined documentation.
Creating SSIS Package for Scheduling Jobs for Data Refresh | Handled Deployment Activities |
Creating Reports and Dashboards using Power BI -Desktop |

Creating different Visualizations and group interactions using Slicer | Creating Dashboards and Implemented RLS. |
Publishing Reports to Dashboards – Power BI Service.

EXHIBIT 10: BUSINESS ANALYTICS FOR LEADING NBFC COMPANY IN INDIA

BI Solution: On-the-fly business analytics

The objective of the solution is to create OLAP Cubes for Non-Banking Finance Company using SSAS and creating SSIS Package for Cube Refresh. OLAP Cubes designed for the following dimensions & measures:
•Customer •Transactional Data •Asset Maintenance Data •Financial measures
Access to the created OLAP cubes were provided to the customer via the familiar Microsoft Excel.

Roles and Responsibilities
Client Co-ordination & Support | Modelling & Creating OLAP Cubes using Microsoft SSAS |
Creating SQL Codes and Procedures. | Developing SSIS Package for Cube Refresh | Modelling & Creating Cubes |

Creating well defined Design Documents.

EXHIBIT 11: BI FOR NON-BANKING-FINANCIAL-CORPORATION (INDIA BASED)

BI Solution: Bespoke business intelligence

The objective of this application is to provide an end-to-end online solution where the business users have access to the system and can:

Onboard their Business Partners | Evaluate their financial performance periodically | Provide various loans and track their repayments | Arrange loans from various investors | Maintain investor relations & lead follow-up | Perform Credit Risk Monitoring, Credit Risk Analytics | 

Manage Treasury | Carryout Lender & Borrower Covenants tracking | Track compliance and exposures as per internal and various Regulatory guidelines.

Roles and Responsibilities

Developing SQL Procedures | Maintaining existing functionalities. | Modelling and creating SSAS Cubes | Creating SSRS drill down Reports with cascading parameters | Performance tuning | Deployment Activities | Scheduling Jobs for Cube Refresh