Ramaswamy Iyer

Experience

• 

  LTI - Larsen & Toubro Infotech

  Aug 2016 - Jul 2019

  • SQL Server migration - Analyzed and coordinated with various application teams to investigate dependencies and perform a successful migration of the application assets on SQL Server.• Applications SOR decommission - Independently accounted for the project in capacity as a systems analyst to analyze Oracle databases and create business-critical technical documentation for obsolete database decommissions. Analyzed various ETL jobs and SSIS packages to determine the changes required for maintaining data consistency.• Azure storage proof of concept - Analyzed the existing solution and conducted a proof of concept for the client to migrate the SQL Server database backups to Azure BLOB storage using Azure Backup Services. Show less • Application upgrade - Single handedly accounted for the project in the capacity of a database administrator working on Microsoft SQL Server as well as Oracle (L1). Implemented and bolstered the successful transition of the application upgrade to the production environment.• Operations and managed services – Monitored and maintained 500+ databases across 120+ servers spanning various SQL Server versions from 2008R2 to 2016 as a crucial participant in a 9-member team. Coordinated with various application teams across different countries for deployment and maintenance of their respective application databases.• Replication setup - Independently accounted for the project in the capacity of a database administrator for Microsoft SQL Server and implemented a 3-tiered transactional replication setup. Show less

  • Systems Analyst

    Oct 2018 - Jul 2019

  • Database Administrator

    Aug 2016 - Sept 2018
• 

  Visit Health

  Mar 2021 - Mar 2022

  Data Engineer

  • Setup the data architecture and pipeline to consolidate data for the application utilization reporting for 70+ corporate clients. • Optimized the application utilization reports to reduce the query overhead in order to improve report performance by 150%.• Co-ordinated with various teams in designing and implementing an engagement system for effective and targeted communication to users to improve application utilization.• Responsible to improve the setup processes for on-boarding of new clients and integrating the data for their corporate insurances.• Played a key role in implementing an orchestration tool for management of scheduled jobs.• Leading a 4-member analytics team that was responsible to create corporate and internal data driven reports and provide analytical insights. Show less

• 

  Fractal

  Mar 2022 - Jun 2024

  Data Engineer

  • Setting up the data architecture and pipelines for data ingestion into the product for various CPG clients around the globe.• Completed successful migration of pipelines for clients from traditional solutions to big data (Databricks).• Reduced the overhead of data ingestion jobs by 90\% for efficient and faster delivery.• Responsible for optimizing and modifying pipelines for data ingestion jobs.• Played a key role in setting up product demos for potential clients including pipeline building and application configurations.• Co-ordinated with the clients and product teams for requirement understanding and building new features into the product. Show less

• 

  Navsoft

  Jun 2024 - now

  Data Engineer