Nithyapriya Elangovan

Project : insights(Nokia Client)

• Developed over 50 reports and dashboards resulting in a 70% increase in operational efficiency.
• Generated actionable Power BI reporting through data transformation and report production.
• Data Pipelines and deployment pipelines had been built and managed in Power BI service.
• Optimized dashboards with a focus on usability and performance by implementing interactive visualizations resulting in a 20% increase in user engagement.
• Reduced report development time by 50% by implementing best practices and utilizing custom visuals.
• Collaborated with cross-functional teams to identify data sources and streamline data collection, reducing report development time by 25%.
• Helped clients enhance internal structures and improve handling of current and potential problems.
• Automated all the regular refresh monitoring of Power BI dataflows and datasets via Power Automate to get the failure notifications.
• Led Power BI development, assigned tasks using Tasks planner, tracked defects, demands using JIRA tool, managed issues/incidents using Redmine ticketing tool and updated best-practice documentations to enhance project delivery.
• Expertise with Power BI Service, Premium capacity where Power BI dataflows, dashboards, upgraded Gateways, created workspaces, sourced data, and managed change activities.
• Performed Administrator role which includes managing users and data, handled security policies, monitoring usage and performance of reports.
• Engaged with customers and end-users to gather functional and non-functional requirements, improving alignment with user needs.
• Improved team output by coaching developers, supporting knowledge transfer, and tracking deliverables.
• Achieved comprehensive data consolidation by gathering inputs from PostgreSQL, Azure SQL database, SQL Server, Azure Synapse, Azure Databricks, MS Excel, SharePoint, ODBC and Elastic.
• Assisted with testing processes and delegated tasks to team members.

Project : Remediation Tool Development(Nokia Client)

• Optimised database performance and designed efficient complex functions, stored procedures, and analysed queries to enhance speed and security.
• Created queries for integration with other applications, triggers, scripts, functions, and procedures required for application development.
• Worked in creation of database tables, structures, schemas, and dictionaries.
• Captured and processed user input data, saving proposed values to SQL Database for further analysis.
• Managed and updated user permissions through T-SQL queries, DML, DDL, and DCL.
• Tested databases and resolved bug-related issues to enhance overall database performance.
• Authorised databases, managed memory for the systems, and assisted with database backup, recovery, and upgrade.
• Developed Remediation tool to store site-related information, enabling creation and management of tasks, event forecasting, and reporting.

Project : fALU to SharePoint Migration(Nokia Client)

• Migrated all Lotus Notes fALU applications to SharePoint using ShareGate tool.
• Extracted data with Lotus scripts and VBA macros to support migration.
• Validated data using Excel macros and PowerShell scripts for accuracy.
• Contributed to Lotus Notes applications migration to SharePoint project.