Thennarasu V
Bengaluru
Summary
Dedicated and adaptable professional with 6.4 years of experience and a proactive attitude, demonstrating a strong work ethic and effective communication skills. Proven ability to learn quickly and contribute to dynamic teams, specializing in ETL processes, data migration, and member management for the airline industry. Eager to support organizational goals and drive operational efficiency.
Overview
7
7
years of professional experience
Work History
Lead Data Analyst
IBS Software Pvt Ltd
Bengaluru
07.2022 - Current
- Performed ETL tasks to convert database information into accessible forms like XML, data files, and text files.
- Created SQL queries, stored procedures, and functions to effectively extract valuable insights from extensive datasets.
- Optimized existing queries for better performance using SQL query tuning techniques.
- Collaborated with business analysts to understand project requirements, customer expectations and timelines.
- Delivering assigned CRs with good quality and ensuring on-time completion.
Software Engineer
Marlabs Innovations Pvt Ltd
Bengaluru
11.2021 - 07.2022
- Created database objects like tables, views, indexes and synonyms in Postgres databases.
- Designed complex reports using SQL Server Reporting Services.
- Successfully executed data migration from Oracle to Postgres by transferring queries like Procedures, functions, Packages, and triggers.
- Tested changes to ensure that the system works correctly after implementation.
Associate Software Engineer
Cigiliant Techno Solutions
Bengaluru
02.2018 - 09.2021
- Generated reports by writing SQL queries with the use of different joins and subqueries.
- Successfully transferred data from various file formats to the database using SQL Loader.
- Worked on Indexing, Views, Materialized views, and Triggers
Education
B.E - Mechanical Engineering
Paavai Engineering College
Namakkal,Tamilnadu06-2017
Skills
- PLSQL
- Data Migration
- SQL and Databases
- Pentaho(ETL Tool)
- GIT and SVN
- SQL Performance Tuning
Timeline
Lead Data Analyst
IBS Software Pvt Ltd
07.2022 - Current
Software Engineer
Marlabs Innovations Pvt Ltd
11.2021 - 07.2022
Associate Software Engineer
Cigiliant Techno Solutions
02.2018 - 09.2021
B.E - Mechanical Engineering
Paavai Engineering College
Projects
Integrated Data Solutions for Global Airlines:
- Developed automated ETL processes for multiple airlines, including a Japanese airline for member profile extraction and validation, ensuring data accuracy during enrollment and seamless integration with downstream systems. For All Nippon Airways (ANA), I created a system to gather and convert member data from SQL to XML whenever profiles were updated. Additionally, I facilitated data migration for Qantas Airlines, transforming Oracle queries to PostgreSQL while implementing unit tests to ensure data integrity and performance.
Similar Profiles
Dominic Ashok X FDominic Ashok X F
Lead Product Consultant at IBS Software Pvt LtdLead Product Consultant at IBS Software Pvt Ltd
Megha VeettilMegha Veettil
Senior Business Analyst at IBS Software PVT LTDSenior Business Analyst at IBS Software PVT LTD
Mereena VargheseMereena Varghese
Senior Solution Engineer at IBS Software Pvt. LtdSenior Solution Engineer at IBS Software Pvt. Ltd