Nirmalya Maity

Results-driven System Engineer with extensive experience in utilizing Azure services and ETL tools to optimize data processing and system administration. Demonstrated ability to troubleshoot complex technical issues, streamline operational processes, and collaborate with teams to drive project success. Highly skilled in implementing innovative solutions to enhance system efficiency and reliability. Eager to apply expertise in technical support and project management to contribute to organizational growth.

• Team NSA Tracker Management | TATA Consultancy Services - Maintained the monthly NSA tracker on behalf of the entire team, ensuring accuracy and completeness of data., Coordinated with stakeholders by sending the tracker for approvals and addressing any follow-ups., Supplied approved data to the rostering team to facilitate timely scheduling and operational actions.
• Weekly Reporting and Governance Support | TATA Consultancy Services - Collaborated with the manager to prepare weekly ServiceNow incident and RITM reports, ensuring accurate and timely delivery., Assisted in creating governance call reports to support key decision-making processes., Played a vital role in streamlining reporting processes, contributing to improved team efficiency and accountability.
• HR SPOC for Interview Panels | TATA Consultancy Services - Functioned as the HR SPOC for 200+ experienced interview panels, coordinating end-to-end interview processes., Contributed to enhancing the overall candidate experience and optimizing interview workflows.

Hand-On project work on End-to-End Data Engineering Pipeline for Sales Data Integration and Reporting

Developed an end-to-end data engineering pipeline for integrating, transforming, and analyzing sales data using Azure  services such as Data Factory, Databricks, Synapse Analytics, and Power BI. Automated data workflows for seamless  ingestion, transformation, and reporting, enabling real-time analytics and business insights.

• Designed and implemented Azure Data Factory (ADF) pipelines to dynamically fetch and ingest raw sales data into a centralized Azure Data Lake.
• Enabled incremental data loading into SQL databases after an initial full load, ensuring efficient and scalable data processing.
• Built a Databricks environment with Unity Catalog for secure role-based access and Delta Live Tables for automated transformations of raw data into refined Silver and Gold layers.
• Created external tables and views in both Databricks and Azure Synapse Analytics for analytical querying and efficient data access.
• Established secure access between Databricks and Azure Data Lake using Access Connectors, ensuring proper role-based management.
• Developed dimensions and facts based on Silver layer data to facilitate business-focused analytics and reporting.
• Automated data ingestion, transformation, and reporting workflows using Databricks and ADF pipelines.
• Published interactive and insightful Power BI dashboards directly connected to Synapse and Databricks, enabling real-time visualization and decision-making.

Value Add:

• Centralized raw data into a secure and scalable data lake, simplifying data accessibility and preparation for analytics.
• Applied robust data transformations to produce clean and standardized datasets in the Silver and Gold layers, improving the accuracy and reliability of analytics.
• Reduced manual intervention and improved operational efficiency by automating data pipelines and transformation workflows.
• Designed a flexible and scalable data architecture capable of handling increasing data volumes and integrating new data sources seamlessly.
• Delivered actionable business insights through Power BI dashboards, enabling faster and more informed decision-making.
• Gained expertise in Azure tools (ADF, Databricks, Synapse, Power BI) and demonstrated proficiency in implementing advanced features like Unity Catalog, Delta Live Tables, and Access Connectors for secure and efficient data handling.

A Comprehensive Review of the Available Microgrid Protection Schemes and Their Challenges

• Presented in an International Conference Published in the First Global Conference on Artificial Intelligence and Applications (GCAIA 2020)
• Published with DOI: https://doi.org/10.1007/978-981-33-4604-8_45