Summary
Overview
Work History
Education
Skills
Accomplishments
Languages
Certification
Websites
Timeline
Generic
Santhosh Babu

Santhosh Babu

Bangalore

Summary

  • Proficient in SQL Server and T-SQL, including constructing tables, defining relationships, and optimizing database design.
  • Experienced in creating and using stored procedures, views, synonyms, and user-defined functions.
  • Skilled in developing sub-queries, joins, and set operators (UNION, UNION ALL, INTERSECT, EXCEPT) for complex queries involving multiple tables.
  • Experienced with Temp Tables, Table Variables, and Common Table Expressions (CTEs) for data manipulation.
  • Proficient in creating indexes, indexed views, and writing efficient functions and triggers to ensure data consistency and performance.
  • Extensive use of system-defined functions such as Window Functions, String Functions, Date Functions, and Aggregate Functions.
  • Designed efficient databases, maintaining referential integrity through triggers and constraints.
  • Hands-on experience in performance tuning, query optimization within stored procedures, and error handling.
  • Good experience in performing database backup and restore operations to ensure data recovery.
  • Skilled in generating reports using SQL Server Reporting Services (SSRS).
  • 2+ years of experience in ETL programming, including functional specifications, data mapping, and development using SSMS and mapping tools.
  • Familiar with clinical trials, SDTM, and CDISC standards.
  • Lead technical activities for multiple projects and clients (e.g., Argenx, Merck, Sionna, Blueprint, Vertex), ensuring on-time delivery and maintaining strong client relationships.
  • Supervised and mentored team members, ensuring 100% productivity and successful project execution.
  • Worked closely with onshore and offshore teams to drive project success across various ETL and database-related activities.
  • Lead the setup and configuration of clinical study environments across various URLs (Dev, Test, and Prod).
  • Manage data ingestion from multiple EDC sources, ensuring accurate and efficient integration.
  • Design and implement data sources, import definitions, and tasks to support study needs.
  • Act as a primary point of contact for clients, gathering requirements, ensuring clear communication, and delivering analytics solutions that meet their needs.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Tech Lead

eClinical Solutions
Bangalore
09.2024 - Current
  • Act as a primary point of contact for clients, gathering requirements, ensuring clear communication, and delivering analytics solutions that meet their needs.
  • Lead the setup and configuration of clinical study environments across various URLs (Dev, Test, and Prod).
  • Manage data ingestion from multiple EDC sources, ensuring accurate and efficient integration.
  • Design and implement data sources, import definitions, and tasks to support study needs.
  • Program and configure SLP, GPP, and listings for clinical data analysis.
  • Perform thorough Technical Quality Control (Tech QC) to ensure data integrity, including managing IC and QC logs and executing smoke testing (UAT) based on client requirements.
  • Develop and maintain unit test documentation for all implementations to ensure quality and adherence to specifications.
  • Oversee data and study migration to various environments, ensuring smooth transitions and minimal downtime.
  • Create and maintain task schedules and workbooks for project tracking and reporting.
  • Prepare and route checklists for approval to ensure compliance with regulatory standards.
  • Collaborate with cross-functional teams, including IC, Specification Writing, and CDA, to ensure project milestones and timelines are met efficiently.
  • Train, mentor, and monitor the team to ensure they have what they need to be successful, are moving along a path for professional development, are delivering quality deliverables, and providing overall customer satisfaction and a positive experience.
  • Analyze challenges, problems, and process breakdowns to ensure that lessons are learned, and improvements are made.
  • Collaborates with management in the evaluation of technical services personnel, which includes work allocation, training, and problem resolution; makes recommendations for improvements.

Software Developer

eClinical Solutions
Bangalore
10.2022 - Current
  • Managing a team of 4 to 6 software developers.
  • High level of collaboration with U.S. counterparts, clients, and responsible for the majority of ETL deliverables.
  • Good understanding of the concepts and best practices of data mapping, ETL design, and its applications.
  • Expertise in creating functional specifications (ETL), business logic, and schema design.
  • Translate functional specifications into elegant ETL design, supported by detailed technical specifications, by using a mapper on an ongoing basis.
  • Build reports and visualizations from specifications using the JReview or Qlik platform.
  • Support any tier 1, and tier 2 batch job schedules and data refresh failures.
  • Ensure that the data mapping and ETL work done are validated through unit testing, and produce quality output.
  • Design and development of integration projects are required to incorporate new data sources into the data warehouse, while providing data stewardship and ensuring the integrity of the data model.
  • Develop, implement, and oversee ETL processes, including onboarding and a training plan for ETL resources.
  • Work prioritization, work allocation, and resource utilization.
  • Defining and implementing the KPIs for evaluating the team's performance.
  • Managing the performance and growth plans of team members, working with them to develop and implement individual career development plans.
  • Evaluation and selection process for freshers and lateral hires.
  • Mentoring team members to promote and champion best practice ETL development techniques.
  • Hands-on in all Elluminate modules (Data Central, Importer, Exporter, RBM, RBQM, Study Setup, Elluminate configuration, Tasks, etc., and troubleshooting).
  • Hands-on experience in building CDA/SDTM mapping using raw data as per CDISC SDTM I.G, and hands-on experience in building CTOA mapping using clinical operation data on various EDC systems.
  • Hands-on experience in building various exception listings, and reconciliation listings.
  • Hands-on in building medical coding listings for medical data reviewers.

Software Engineer

Azentio India Pvt Ltd
Bangalore
04.2021 - 10.2022
  • Note: As part of a strategic business transition, 3i Infotech Ltd. Sold its product division to Azentio India Pvt. Ltd., at which point I continued my role with Azentio India Pvt. Ltd.
  • Responsibilities and achievements remain consistent with those at 3i Infotech Ltd., focusing on.

Software Engineer

3i Infotech Ltd
Bangalore
09.2020 - 03.2021
  • I worked as an SQL, T-SQL, and SSRS Developer for the MFund Plus project with Azentio Pvt. Ltd., for the Philippines National Bank (PNB).
  • Generated SQL scripts for copying databases and database objects, and gathered data for validation and population into tables using stored procedures.
  • Modified existing database structures by adding tables and altering referential integrity and relationships to support the online system.
  • Extensive experience in writing, modifying, and tuning stored procedures for optimal performance.
  • Designed and created various reports using database-generated flat files, and developed stored procedures, triggers, views, joins, and functions.
  • Created, debugged, and executed T-SQL scripts and stored procedures to meet application requirements.
  • Involved in extensive error handling for stored procedures to ensure robust and reliable data processing.
  • Imported and transformed data using SSIS from various sources, including flat files and Excel files, and created packages for data conversion and loading.
  • Performed extensive testing and optimization on stored procedures to improve database performance and reduce server load.
  • Designed complex views to enhance performance and minimize server load.
  • Wrote complex T-SQL queries, including sub-queries and joins for data retrieval across multiple tables.
  • Conducted performance testing on database and fine-tuned queries by creating appropriate indexes to optimize application performance.
  • Designed and created SQL databases, tables, and indexes while implementing efficient error handling and stored procedures.
  • Imported client data from Excel to SQL Server, ensuring accurate and efficient data migration.
  • Gained hands-on experience with Azure Data Factory and managed data flows for cloud-based data processing.
  • Actively developed SSRS reports, creating various reports for business requirements.
  • Coordinated with onsite teams through daily status calls to ensure timely project delivery.

Education

Bachelor of Engineering -

JNTU Ananthapur
01-2018

Skills

  • SQL, PL/SQL, T-SQL, RDBMS, SSRS, Data Warehousing, Qlik Sense, Elluminate, and SharePoint, with strong knowledge in Clinical Trials, SDTM/CDA, CTOA, and clinical domain experience

Accomplishments

  • Awarded first prize in eClinnovathon 2024 for the innovative idea to revolutionize the QC validation process through the development of a new elluminate module called the Validator.
  • Recognized with multiple spot awards for exceptional performance, initiative, and contributions to project success.
  • Consistently received positive feedback and formal appreciation from clients for outstanding work and successful project delivery.

Languages

English
First Language
Telugu
Advanced (C1)
C1
kannada
Advanced (C1)
C1
Tamil
Elementary (A2)
A2
Hindi
Elementary (A2)
A2

Certification

  • Certificate of Participation, SCDM 2024 India Annual Conference
    Attended the SCDM 2024 Annual Conference in Hyderabad, India, gaining valuable insights into the latest trends and best practices in clinical data management.

Timeline

Tech Lead

eClinical Solutions
09.2024 - Current

Software Developer

eClinical Solutions
10.2022 - Current

Software Engineer

Azentio India Pvt Ltd
04.2021 - 10.2022

Software Engineer

3i Infotech Ltd
09.2020 - 03.2021

Bachelor of Engineering -

JNTU Ananthapur

Similar Profiles

CREATE PROFILE
Santhosh Babu