THRIVIKRAM KAMATH
Mangalore
Summary
A highly skilled Systems Engineer with extensive experience in SQL development, database optimization, and data extraction using Ab Initio. Proven ability to design, develop, and deploy efficient SQL views and Ab Initio graphs to handle substantial data volumes. Expertise in optimizing database performance through strategic indexing, query tuning, and the creation of robust SQL functions, stored procedures (PL/SQL), and other database objects. Adept at Agile methodologies and Jira for project management, with a focus on delivering high-quality, validated data solutions. Seeking a challenging role to leverage technical skills and contribute to data engineering and analytics initiatives.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Data Engineer
Tata Consultancy Services
01.2023 - Current
- Developed and optimized SQL views, enhancing database query performance and data retrieval speed.
- Played a key role in SQL-based view development, PL/SQL programming, and Ab Initio and informatica projects, demonstrating comprehensive skill in database technologies.
- Developed Python scripts for data validation, transformation, and automation tasks, improving data quality checks and reducing manual effort in ETL processes.
- Implemented strategic indexing strategies that improved overall query performance by 20%.
- Utilized Ab Initio (3.3.5.1/4.0.2.4) and informatica powercenter to implement data processing solutions and collaborated on the development of continuous graphs to handle substantial data volumes.
- Leveraged Google Cloud Platform (GCP) services such as BigQuery for analytical querying and Cloud Storage for staging and managing large datasets used in data processing pipelines.
- Designed and implemented Generic Extracts using Ab Initio, ensuring efficient extraction of data from various sources for downstream processing.
- Acted as Scrum Master, facilitating sprint planning and daily stand-up meetings within Jira to ensure timely task completion.
- Created detailed test results, validation reports, and supporting artifacts for Ab Initio graphs and SQL objects, ensuring data accuracy.
SQL and ETL Developer
Cognizant Technology Solutions
07.2021 - 12.2022
- Utilized Ab Initio to implement data processing solutions, improving data quality and consistency.
- Designed and developed Ab Initio graphs and created specs using GDE as per client requirements, demonstrating comprehensive skill in database technologies.
- Migrated legacy on-prem SQL Server workloads to Azure SQL with minimal downtime
- , ensuring business continuity.
- Worked with Azure SQL Database, supporting query optimization, performance monitoring, and routine database maintenance activities.
- Built Python-based utilities for log analysis and exception handling to proactively identify data processing issues.
- Developed and maintained database objects, including tables, views, indexes, and sequences, using SQL, T-SQL, and PL/SQL scripts.
- Provided application support and performed database deployments, ensuring smooth transitions and minimal downtime.
Data Analyst
Sphera India Pvt Ltd
12.2019 - 12.2020
- Data cleaning and management of data that supports performance improvement activities.
- Compiled and validated data; reinforced and maintained compliance with corporate standards.
- Worked with management and leadership to prioritize business and information requirements.
- Utilized advanced SQL queries to extract and manipulate data, providing custom reports for analysis, improving decision-making processes.
- Leveraged SQL queries to manipulate and validate data, supporting thorough backend testing processes, ensuring data integrity.
Education
Bachelor's degree - Mechanical Engineering
St Joseph Engineering College
Mangalore07.2019
Skills
- Languages: SQL, PL/SQL, Python
- Databases: Oracle, MySQL, MSSQL
- Tools: Ab Initio (3351/4024), Oracle SQL Developer, DBeaver, Jira, FileZilla, SVN, Microsoft Excel
- Core Skills: End-to-end SQL development, data extraction and transformation, Agile methodology, performance tuning
- Cloud Technologies: Google Cloud Platform (GCP): BigQuery, Cloud Storage, Compute Engine, Terraform Microsoft Azure: Azure SQL Database, Azure VM, Storage Accounts
Websites
Certification
- Ab Initio Certified (GD-100, GD-101, GD-102, GD-103, AI-100, GD-210) - Demonstrated proficiency in Ab Initio development and data processing techniques.
- MySQL for Data Analytics and Business Intelligence - Validated skills in data analysis and business intelligence using MySQL.
Language
C1English - Fluent: Advanced
B1Hindi - Fluent: Intermediate
C2Kannada- Native: Proficient
C2Konkani- Native: Proficient
Awards
Recognized with two On-the-Spot Awards for consistent high-quality work.
Timeline
Data Engineer
Tata Consultancy Services
01.2023 - Current
SQL and ETL Developer
Cognizant Technology Solutions
07.2021 - 12.2022
Data Analyst
Sphera India Pvt Ltd
12.2019 - 12.2020
Bachelor's degree - Mechanical Engineering
St Joseph Engineering College