Maheswari Penumallu

• Led development of an interactive Power BI dashboard for a healthcare client, transitioning from manual Excel analysis to an automated data solution for growing data volumes.
• Built 50+ KPIs using advanced DAX measures to monitor revenue pipelines, monthly footfalls, and payment defaults, enabling real-time data refresh and insights.
• Delivered a solution that improved client operational visibility and decision-making speed by 50%, significantly enhancing business outcomes.
• Integrated ~2 million records from on-premise SQL and Azure cloud into Databricks using APIs and data pipelines, enabling efficient large-scale data processing and analysis.
• Supported downstream modelling by preparing clean, structured data and collaborating with data scientists on sentiment analysis of customer feedback to uncover key revenue-impacting factors.
• Contributed to a strategic case study that revealed poor customer service at specific locations as a key driver of revenue decline, enabling the client to take targeted action.
• Collaborated with a team to consolidate data from SQL Server, Excel, and SharePoint into a unified model using Power Query, enabling accurate tracking of key real estate metrics.
• Developed advanced DAX measures and designed interactive Power BI dashboards with filters and trend visualizations to provide deep insights into occupancy, rent collection, and maintenance.
• Implemented row-level security to ensure regional managers could only access data relevant to their properties, safeguarding sensitive information.
• Managed dashboard deployment and automated data refreshes in Power BI Service, delivering real-time, reliable reports that improved client decision-making and reduced manual efforts by 60%.

• Collaborated with internal TCS security and infrastructure teams to integrate ServiceNow with Power BI, enabling real-time monitoring of phishing incidents, system misconfigurations, and data vulnerabilities.
• Analyzed ServiceNow incident and audit data to identify key security metrics such as phishing trends, unresolved tickets, and SLA violations.
• Designed and developed dynamic Power BI dashboards to visualize critical security KPIs, improving threat visibility and response times across internal systems.
• Supported the team in checking the data accuracy and making sure the reports were updated regularly.
• Coordinated with both technical and security staff to understand what information was needed in the dashboards.

• Assisted in designing and maintaining dashboards using Power BI to help business teams visualize key metrics and track performance.
• Worked with team members to collect data requirements and support the creation of reports focused on business insights.
• Wrote and executed simple SQL queries to extract data and generate routine reports for business teams.

• Documenting the work to support collaboration and consistency.

• Executed data entry, cleaning, and basic analysis using Excel and SQL to ensure accurate and organized datasets for internal reporting.
• Gained exposure to tools like Power BI and participated in team discussions on data solutions.
• Engaged in internal training and team discussions on SQL, Excel, Power BI, and data visualization tools to enhance skills and contribute to data-driven solutions.