Enterprise Systems & LIMS Architect

Abhishek GM

Where Software Intelligence Meets Hardware Precision

Software & Data Hardware & Instrumentation
Pune, India +91 89405 99060 abhishekgm94@gmail.com Add LinkedIn URL
7.5+ Years Experience
2 Industry Domains
3 Certifications
5+ Tech Platforms
Scroll

Professional Summary

I am an enterprise systems architect with 7.5+ years of hands-on experience designing, configuring, and governing mission-critical data platforms across Life Sciences, Pharmaceutical Manufacturing, and Industrial R&D. I am a deep practitioner of LabVantage LIMS with a strong foundation in database architecture, reporting automation, and systems integration (SAP/MES).

My career spans the full system lifecycle — from requirements analysis and DB schema design through validation (IQ/OQ/PQ), version upgrades, UAT, and production support — with consistent delivery in 21 CFR Part 11 regulated environments where data integrity is non-negotiable. Beyond core LIMS, I bring complementary strengths in cloud data engineering (Azure Data Factory), business intelligence (Power BI, Jasper Reports), and SQL-based data pipelines.

What My Experience Translates To

In LIMS I've done…
Which proves I can…
Designed LabVantage DB architecture for master data, specs & workflows
Enterprise data modeling for EHR, ERP, QMS, PLM, or any complex domain platform
Built SAP and MES integration modules
Enterprise systems integration — API design, middleware, data exchange protocols
Led IQ/OQ/PQ and 21 CFR Part 11 validation
Compliance-grade delivery in pharma, medical devices, food & beverage, aerospace, fintech (SOX)
Managed version upgrades across Dev → UAT → Production
DevOps-adjacent release management; change control governance
Architected large-scale lab master data migration
Enterprise ETL, data quality engineering, migration strategy
IoT + Power BI energy analytics dashboards
Industrial IoT pipelines; operational analytics for manufacturing

Career Highlights

Architected LabVantage DB solutions encompassing product specifications, test methods, and sampling hierarchies — delivering a single source of truth for lab master data
Led version upgrade deployments across Development, Validation, and Production environments, maintaining zero compliance gaps throughout
Designed and implemented SAP/MES interface modules enabling seamless, real-time data exchange between lab and enterprise systems
Engineered automated Jasper Reports modules, eliminating manual reporting workflows and accelerating regulatory submissions
Built interactive Power BI dashboards for IoT-driven energy analytics, turning raw DAQ sensor data into operational insights

Professional Experience

Senior Analyst — Refrigeration Laboratory
Whirlpool Asia LLP, Pune
Oct 2024 – Present

Embedded within the Refrigeration R&D lab, I manage enterprise-grade database infrastructure and precision testing systems that underpin product validation programs.

  • Database Administration: I manage and optimize Oracle and Microsoft SQL Server databases underpinning laboratory instrumentation data capture, ensuring reliability for high-frequency test data workloads.
  • Systems Engineering: I diagnose and resolve technical faults within the Refrigeration Testing System (RTS), maintaining operational continuity for time-sensitive product validation cycles.
  • Instrumentation Integration: I optimize DAQ system performance and integrate tools including Wide/WIN and Nucleus to ensure accurate, traceable sensor data acquisition across test rigs.
Analyst — LIMS & Laboratory Management
Tata Consultancy Services, Bengaluru
Mar 2020 – Oct 2024

As a core member of a specialized LabVantage LIMS practice, I delivered end-to-end implementations for pharmaceutical and manufacturing clients — owning architecture, reporting, compliance, and integration workstreams concurrently.

DB Architecture & Configuration
  • Designed and maintained LabVantage LIMS modules: product specification hierarchies, test method libraries, sampling point configurations, and sample execution workflows.
  • Architected master/static data structures as the definitive source of truth for multi-site lab operations, reducing data discrepancies and audit risk.
Reporting & Business Intelligence
  • Developed complex Jasper Reports templates, automating laboratory management reports that previously required significant manual effort.
  • Delivered solutions aligned to both business KPI requirements and regulatory submission standards.
System Lifecycle & Version Management
  • Led LabVantage version upgrade projects end-to-end across Development, Validation, and Production environments with zero compliance deviations.
  • Authored and executed change control documentation, upgrade runbooks, and rollback plans for each release cycle.
Validation & Regulatory Compliance
  • Conducted comprehensive CSV-based IQ/OQ/PQ validation, producing fully traceable packages accepted by regulatory auditors.
  • Designed and executed UAT scripts verifying 21 CFR Part 11 controls: audit trails, electronic signatures, access controls.
Systems Integration
  • Architected bidirectional SAP/MES interface modules enabling real-time data exchange between laboratory results, manufacturing records, and ERP reporting.
  • Resolved integration failures and performance bottlenecks at the lab–enterprise boundary, reducing data latency and reconciliation overhead.
Developer — Energy Analytics (IoT & BI)
Tata Consultancy Services, Noida
Sep 2018 – Mar 2020

I built data-driven analytics capabilities for an industrial energy management program, working across IoT data ingestion, SQL pipelines, and interactive dashboards.

  • Analytics Development: Designed and delivered interactive Power BI dashboards for plant-level energy consumption visibility, demand forecasting indicators, and anomaly detection.
  • Data Engineering: Processed high-volume IoT sensor data using SQL, transforming raw time-series signals into structured, actionable metrics with data quality checks to flag erroneous readings.

Technical Skills

Software & Data Intelligence

LIMS & Enterprise Platforms
LabVantage LIMS Darwin LIMS SAP Integration MES
Databases & Architecture
Oracle MS-SQL Server Data Modeling Data Migration
Reporting & Analytics
Power BI Jasper Reports Advanced SQL Excel
Cloud & Engineering
Azure Data Factory Python SQL Pipelines

Hardware & Instrumentation

Testing Systems
Refrigeration Testing System RTS
Data Acquisition
DAQ Systems Wide/WIN Nucleus IoT Sensors
Lab Environment
Sample Execution Lab Workflows Instrument Integration
Engineering Background
Product Engineering (M.E.) Mechanical Systems
Compliance & Validation — Spanning Both Worlds
21 CFR Part 11 IQ/OQ/PQ Computer System Validation (CSV) UAT GxP Standards Process Validation Change Control

Key Project Highlights

Lead LIMS Analyst
LabVantage Master Data & DB Architecture

Design a scalable, auditable database architecture for a life sciences client covering product specifications, test methods, and sampling configurations from the ground up.

  • Architected the core LabVantage DB schema with normalized structures for specs, test methods, and sampling hierarchies
  • Designed a large-scale data migration strategy from legacy systems with validation checkpoints at each stage
  • Developed Jasper Reports modules that automated key laboratory insights, replacing entirely manual processes
Client achieved a consistent, audit-ready architecture supporting both day-to-day operations and regulatory inspection readiness.
LIMS Administrator
LabVantage Validation & Version Upgrade

Upgrade LabVantage across regulated environments without introducing compliance risk, data integrity issues, or operational downtime.

  • Managed the upgrade sequence across Development → Validation (UAT) → Production with rigorous change control at each stage
  • Produced complete CSV-based IQ/OQ/PQ validation packages documenting installation, operational, and performance qualification
  • Executed comprehensive UAT scripts covering 21 CFR Part 11 controls: audit trails, user access, electronic signatures
On-time delivery with complete regulatory documentation; zero compliance findings during subsequent audits.

Education & Certifications

Education

Master of Engineering — Product Engineering
PSG College of Technology, Coimbatore
CGPA 8.7 / 10
Bachelor of Engineering — Mechanical Engineering
Sethu Institute of Technology, Virudhunagar
CGPA 8.3 / 10

Certifications

  • Certified LIMS Professional LabVantage Academy
  • Data Analyst Associate (Power BI) Microsoft
  • Azure Fundamentals Microsoft

Awards & Recognition

STAR of the Month & STAR of the Quarter — Tata Consultancy Services
2× Innovation Awards — Tata Consultancy Services
Best Outgoing Student — PSG College of Technology