Nagarajan Subramanian
About Nagarajan Subramanian
Nagarajan Subramanian is a Technical Specialist at Aspire Systems Enterprise Integration in Chennai, India, with over 10 years of experience in IT, particularly in Microsoft Business Intelligence and SQL Server. He has a strong background in data warehousing, ETL processes, and SQL query optimization.
Work at Aspire Systems
Nagarajan Subramanian has been employed at Aspire Systems since 2019, serving as a Technical Specialist. He has accumulated five years of experience in this role, contributing to enterprise integration projects in the Chennai Area, India. His responsibilities include developing and managing technical solutions that enhance data processing and integration capabilities.
Previous Work Experience
Before joining Aspire Systems, Nagarajan Subramanian held several positions in the IT sector. He worked at Mascon Global as a Senior Executive Systems from 2003 to 2005. Prior to that, he was a Software Engineer at TAKE Solutions from 2001 to 2003. He also served as an Assistant Project Director at Mphasis from 2005 to 2008. This diverse experience has contributed to his technical expertise.
Education and Expertise
Nagarajan Subramanian earned a Master of Computer Applications (MCA) degree from Bharathidasan University, where he studied from 1996 to 1999. He holds a certification in Microsoft Certified Solutions Expert (MCSE) in Data Management and Analytics, obtained in 2016. His expertise includes SQL Server, Microsoft Business Intelligence, and data warehousing.
Technical Skills and Specializations
Nagarajan Subramanian specializes in SQL data analysis, SQL query optimization, and business intelligence. He has over 10 years of experience in IT, focusing on Microsoft Business Intelligence tools such as SSIS, SSRS, and DTS Packages. His skills include creating linked servers, configuring database mail, and managing SQL Server locking systems.
Data Warehousing and ETL Processes
Nagarajan has developed ETL processes using SQL Server Integration Services (SSIS) to load data from transactional systems to data warehouses on a weekly basis. He has experience in designing and creating data warehouse tables in SQL Server, as well as troubleshooting performance issues with SSIS and SSRS. His work involves cube integration with SSRS and optimizing data management processes.