Skip to main content
Thiyagarajan Mani

Thiyagarajan Mani

Data Engineer | SQL developer | BI Analytics

Talent
Seshadripuram, Bengaluru, KarnatakaMember since July 10, 2026
T-SQLPerformance tuningTroubleshootingDatabase ManagementPower BISSISSSRSSSMSStored ProceduresViewsTriggersFunctionsIndexesJoinsCursorsDatabase MirroringClusteringLog ShippingETL processesTableauSSASSnowflake SQLSnowflake pipelineData Transformation ServicesSQL Server Integration ServicesQuery optimizationIndex analysisBackup and recoveryProduction support
·

Hire this person

Send a job offer directly to this candidate

T-SQLPerformance tuningTroubleshootingDatabase ManagementPower BI

About

Accomplished Microsoft SQL Server Database Developer and SQL Database Administrator with 15+ years of extensive IT industry experience in database development, administration, testing, implementation, and maintenance of databases and data warehouse systems. Proficient in SQL programming, ETL processes, database design, performance tuning, and production support activities. Possess strong hands-on expertise in developing and optimizing T-SQL objects including Stored Procedures, Views, Triggers, Functions, Indexes, Joins, Cursors, and complex queries.

Experienced in troubleshooting performance bottlenecks, query optimization, index analysis, database fine-tuning, backup and recovery strategies, database migrations, and high availability solutions including Database Mirroring, Clustering, and Log Shipping. Strong exposure to handling large-scale enterprise databases and supporting mission-critical production environments. Have successfully managed large data-driven global engagements, leading digital transformation, product transformation, and service management initiatives for multinational clients across various domains.

A multi-skilled professional with strong analytical, problem-solving, communication, and leadership abilities, capable of working effectively in fast-paced production and development environments.

Experience

Senior SQL database administer and developer - Eye-Q Eye hospital - Gurgaon, India

(2024-11)

Senior SQL developer - Simple Solve Inc. - Pennington, USA

(2023-08 - 2024-08)

Simple INSPIRE, a fully integrated Platform, is designed to meet the challenges of unprecedented transformation in the Insurance industry and take advantage of disruptive technologies, and digital abundance.

Policy

Management system is a platform with a visionary architecture and a foundation built on disruptive technologies for digital-first enablement. It empowers you to drive change rather than be driven by change. Introduce new norm policy products with confidence. The platform has an integrated insurance claims system to create and manage claims. A claim can have multiple claims features to manage multiple claims arising out of a single incident. Managing and reporting claims can be done at the Claim level or the Feature level. The Simple INSPIRE – Insurance Claims system can create letter templates to generate claims-related correspondence providing operational efficiency.

  • Working on SQL server development, SQL database administrator, Snowflake SQL, and Snowflake pipeline
  • Proficient in Extract, Transform, Load (ETL) processes, with expertise in designing, developing, and optimizing data workflows
  • Designed and developed SSIS packages to extract, transform, and load data from various source systems into SQL Server databases
  • Created complex SSRS reports with parameters, drilldowns, and interactive sorting to meet diverse reporting requirements
  • Implemented data cleansing and transformation logic within SSIS packages to ensure data quality and integrity
  • Designed and developed SSAS cubes to support business intelligence initiatives
  • Collaborated with business users to gather and analyze requirements for data models
  • Optimized cube performance by fine-tuning aggregations, partitions, and indexes
  • Created SSIS Log Tracking database in SQL Server Management Studio (SSMS) containing multiple tables including Execution Status, Business Scope, Processing Log, Error Log, etc.
  • Integrated SSAS solutions with other BI tools like Tableau and Excel for comprehensive reporting
  • Developing SQL scripts, Stored Procedures, Views, Triggers, Indexes, Joins, User Defined Functions and Cursors, and procures/views in Snowflake
  • Transformed data from one server to other servers using tools like Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
  • Integrated and extracted source data using SSIS ETL tool and stored procedures created in SQL Server Management Studio (SSMS), and developed transformation logic and designed ETL packages
  • Data Visualization: Expert in creating interactive dashboards, reports, and visualizations using Tableau
  • Used T-SQL in SQL Server Management Studio (SSMS) to develop Stored Procedures, User-Defined Functions (UDFs) and Views
  • Data Analysis: Strong analytical skills with experience in statistical analysis, data mining, and trend identification
  • Involved in improving the performance of Stored Procedures and queries in SQL Server Management Studio (SSMS)
  • Database Management: Proficient in SQL and data integration from various sources, including relational databases, cloud services, and flat files
  • Developed and maintained interactive dashboards and reports in Tableau, providing real-time insights to stakeholders
  • Gathered requirements and Created data models for the databases
  • Defining and Setting backup and recovery procedures

Senior SQL developer - Tata Consultancy Service Ltd - Chennai, India

(2010-07 - 2023-08)

Hospital Management System (HMS) and Electronic Medical Records (EMR) Sankara Nethralaya Eye Hospital is one of the world's best ophthalmic care and research centers, which serves around 2000 patients a day. The center houses around thirty various departments, which efficiently manage patient care and medical services. The major functionality of HMS is a fully integrated Hospital Management suit that is powered with various applications like Appointment Scheduling, Patient Registration, Billing, Clinical laboratories, Wards, Surgery Scheduling, Purchase, Pharmacy, and Stores.

  • Proficient in Extract, Transform, Load (ETL) processes, with expertise in designing, developing, and optimizing data workflows
  • Designed and developed SSIS packages to extract, transform, and load data from various source systems into SQL Server databases
  • Created complex SSRS reports with parameters, drilldowns, and interactive sorting to meet diverse reporting requirements
  • Implemented data cleansing and transformation logic within SSIS packages to ensure data quality and integrity
  • Designed and developed SSAS cubes to support business intelligence initiatives
  • Collaborated with business users to gather and analyze requirements for data models
  • Optimized cube performance by fine-tuning aggregations, partitions, and indexes
  • Created SSIS Log Tracking database in SQL Server Management Studio (SSMS) containing multiple tables including Execution Status, Business Scope, Processing Log, Error Log, etc.
  • Integrated SSAS solutions with other BI tools like Tableau and Excel for comprehensive reporting
  • Developing SQL scripts, Stored Procedures, Views, Triggers, Indexes, Joins, User Defined Functions and Cursors, and procures/views in Snowflake
  • Transformed data from one server to other servers using tools like Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
  • Integrated and extracted source data using SSIS ETL tool and stored procedures created in SQL Server Management Studio (SSMS), and developed transformation logic and designed ETL packages
  • Data Visualization: Expert in creating interactive dashboards, reports, and visualizations using Tableau
  • Used T-SQL in SQL Server Management Studio (SSMS) to develop Stored Procedures, User-Defined Functions (UDFs) and Views
  • Data Analysis: Strong analytical skills with experience in statistical analysis, data mining, and trend identification
  • Involved in improving the performance of Stored Procedures and queries in SQL Server Management Studio (SSMS)
  • Database Management: Proficient in SQL and data integration from various sources, including relational databases, cloud services, and flat files
  • Developed and maintained interactive dashboards and reports in Tableau, providing real-time insights to stakeholders
  • Trained team members on Tableau best practices and data visualization techniques
  • Created and managed business intelligence solutions, including dashboards, reports, and data models in Tableau
  • Improved data quality and consistency by implementing data governance and validation processes
  • Developed and maintained SSAS cubes to facilitate data analysis and reporting
  • Conducted data analysis to support decision-making processes across various departments
  • Created reports utilizing SSRS 2012, Power BI and deployed them on SSMS as per business requirements
  • Generated reports and dashboards using SSRS, Tableau and Power BI
  • Assisted in the development and maintenance of SSIS packages for data extraction, transformation, and loading
  • Designed and developed interactive and dynamic reports using SQL Server Reporting Services (SSRS) based on business requirements
  • Created complex SSRS reports with parameters, drill-downs, and custom expressions to provide detailed insights to stakeholders
  • Implemented SSRS subscriptions for automated report generation and distribution, improving report accessibility and timeliness

SQL Developer - Sankara Nethralaya Medical Research Foundation - Chennai, India

(2007-07 - 2010-07)

Medical Records Management System: Major functionalities of the MRD project involve the maintenance of Surgery details, Doctor Details, and Operation Theatre details.

  • Working along with programmers and contributing to the development team process
  • Managing, troubleshooting and resolving database and application related issues
  • Production Database Administrations
  • Developing SQL scripts, Stored Procedures, Views, Triggers, Indexes, Joins, User Defined Functions and Cursors
  • Assisted in the development and maintenance of SSRS reports, including report design, layout, and data visualization
  • Supported report testing and validation activities to ensure accuracy and reliability of SSRS reports
  • Documented SSRS report specifications, configurations, and deployment procedures for knowledge sharing and team collaboration
  • Checking of Cluster availability for Data Base servers
  • Creating user ids and defining roles, allocating quotas with necessary privileges for all databases
  • Gathered requirement and Created data model for the databases
  • Normalized data model for optimum performance
  • Designed and Implemented of Backup and Recovery Strategies and taken backup using scripts
  • Defining and Setting backup and recovery procedures
  • Developing backup scripts to automate the backup procedures
  • Tuning and balancing I/O by monitoring file system and table space I/O statistics

Education

Master of Computer Application (2007)

Bachelor of Science (2004)

Skills

Data EngineerSQL developerBI Analytics

Reviews

Related