Headline

Database Administrator | Clinical Data Layer | AWS Certified Cloud practitioner | Oracle / PL/SQL / Python/ PySpark/ Databricks | Gen AI leader | Life science domain | 8 years in Application and Production Support

About

I am an experienced IT professional with 7+ years of hands-on experience supporting and optimizing large-scale, database-driven applications in the healthcare and life sciences domain. My career began in application and production support, where working closely with real-time clinical systems helped me build a strong foundation in database management, data integrity, and performance tuning. Over the years at HCLTech, I have played a key role in supporting and enhancing Clinical Data Repository (CDR) systems. I have worked extensively on PL/SQL packages, procedures, cursors, triggers, and views, handling complex study-related data flows, report generation, refiring processes, and mismatch resolution to ensure accurate and timely clinical data delivery. By analyzing execution plans and optimizing SQL logic, I have consistently improved query performance and reduced processing time for critical data operations. Beyond day-to-day support, I have been actively involved in performance tuning, automation, and process optimization, ensuring system stability for business-critical applications. I am known for handling high-priority production issues, performing emergency fixes, and collaborating with cross-functional teams to minimize downtime and maintain compliance in regulated environments. In parallel, I have expanded my skill set into cloud and data engineering technologies, including AWS (S3, Glue, Lambda, Redshift), Python, PySpark, and Databricks, enabling me to bridge traditional database systems with modern data platforms. My experience with clinical data models (SDTM) and ETL workflows allows me to effectively support data transformation and analytics use cases. With a strong analytical mindset, problem-solving approach, and continuous learning attitude, I thrive in roles that demand deep database expertise, performance optimization, and reliability in production environments, while steadily evolving toward modern, cloud-based data solutions. Core Skills highlighted: Oracle SQL & PL/SQL (performance tuning, optimization) Healthcare & Clinical Data (CDR, SDTM) Production & Application Support (7+ years) AWS & Data Engineering exposure Strong problem-solving and ownership mindset

Location

Madurai

AI stack

grok

kilocode

replit

sora

Work experience

Senior Software Engineer at HCLTech, Apr 2022 - Present · 4 yrs 3 mos, Madurai, Currently, as I am Supporting application development and maintenance in Clinical Data Repository (CDR) and Clinical Data Layer with expertise in Oracle PL/SQL, Databricks and PySpark along with airflow for job monitoring. Handling database management, study id related supports, Dataflow, Reports handling and Delivering, Mismatches by doing Refiring process, Override the query, Flush the records, performance tuning, and optimizing data processes to ensure seamless clinical data operations.Using python to work on PySpark tool to monitor job and Databricks with daily basis activity work regularly.

Software Engineer at HCLTech, Aug 2018 - Mar 2022 · 3 yrs 8 mos, Madurai, Tamil Nadu, India, Proficient in ServiceNow and Remedy application usage‬ ‭Assigning and resolving tickets across multiple Merck applications‬ ‭Monitoring different applications across sites in a 24/7 role‬ ‭Generating reports to showcase business importance‬ ‭creating PPT and working on multiple use cases with state in service now‬.

Software Engineer Trainee at HCLTech, Aug 2017 - Aug 2018 · 1 yr 1 mo, Madurai, Tamil Nadu, India

Education

Master of Computer Applications - MCA, Computer Programming, Specific Applications, Shanmugha Arts, Science, Technology & Reserch Academy (SASTRA), Thanjavur

BCA, Computer and Application, Shanmugha Arts, Science, Technology & Reserch Academy (SASTRA), Thanjavur