RAHUL T
Calicut
Summary
- Comprehensive experience specializing in ETL (Extract, Transform, Load) processes, database management, and workflow automation. Proficient in utilizing tools such as dbt (Data Build Tool) and Apache Airflow to architect, develop, and optimize end-to-end data pipelines
- Expertise in supporting the application software development for various domains like Banking, Non-banking (NBFC) Payroll, Mobile Banking, RTGS, NEFT, Palm-Tech and so on.
- Customer-centric professional; skills in managing client challenges and providing effective technical support within TAT/SLA .
- Successfully worked on functions like database administration on production servers with server configuration, performance tuning & maintenance with outstanding troubleshooting capabilities; managing overall implementation projects works, encompassing planning, controlling phases of project & STLC
- Exposure in configuration, deployment, administration, management, troubleshooting and maintenance of SQL server high availability and disaster recovery strategies.
- Acting as an escalation gate to resolve critical issues of the team members; expert in mapping client’s requirements, custom designing solutions & troubleshooting for complex Information Systems Management.
- Supervising & controlling migration of programs, database changes, reference & master data changes through the development life cycle.
Overview
8
8
years of professional experience
Work History
Senior Database Developer
PIT Solutions
05.2023 - Current
Projects worked on:
Title: Frontiers
Description: FRONTIERS is the science journalism initiative funded by the ERC to design a residency program for journalists wishing to experience an immersive period in a research institution.
Key Result Areas:
- Modifying SQL scripts to report customization
- Optimized ETL processes for faster data extraction, transformation, and loading.
- Automated manual data processing tasks using Airflow DAGs,
- Designed and implemented complex data models in BigQuery using dbt, incorporating business logic and transformations to prepare clean and structured datasets for analysis
- Implement data quality checks within the pipeline to ensure the integrity and accuracy of the processed data.
Associate Team Lead
Sesame Software Solutions Pvt. Ltd.
10.2019 - 05.2023
Growth Path: Sr.Software Engineer >> Associate Team Lead
Projects worked on:
Title: Beacon Pro – The Core Banking Suit
Description: A Generalized Core Banking Solution.
The application caters to the requirements of the various departments of Bank
Title: NBFC– The Core Non-Banking Suit
Description: A Generalized Core Non- Banking Solution.
The application caters to the requirements of the various departments of NBFC/NIDHI clients
Title: My Bank - Mobile Application Used in Cooperative Banks
Description: It is a Mobile Application Used in Cooperative Banks
It is Mainly Used for Mobile-Recharge, Billing like (KSEB, Water and so ons) Fund-Transfer, IMPS, NEFT & RTGS, and so on
Key Result Areas:
- Enhancing the main product of the company ‘Beacon pro’, a core banking solution and ‘Payroll’ for Co-Operative Banks
- Managing the customization of Product ‘Beacon pro’ Core Banking, 'Non-banking’ and ‘Payroll’’ based on Customer Requirements
- Performing Version Bug checks
- Migrating the Script Writing (Migration of data from different databases)
- Modifying SQL scripts to report customization
- Working on the database maintenance and administration, backup & restore, log shipping, troubleshooting & application hosting
Sr. Software Engineer
Perfect Software Solutions
01.2016 - 04.2019
Growth Path: Jr.Software Engineer >> Sr.Software Engineer
Projects worked on:
Title: Score (Web Application Based Core Banking Solution)
Description: Software developed for Automating Banks in Co-Operative And urban sector
System consists of the following modules- shares, Deposits, Loans and GDS & so on
Title: EASYSHOPPLUS
Description: A fully Inventory Web Application integrated with windows application including POS as well as browser-based POS
Title: EASYSHARE
Description: A Web application for documents management and event management for cooperative sectors across Kerala and for other clients
Skills
- RDBMS: Microsoft SQL Server 2008R2,2012,2014,2016
- Reporting: SQL Server Reporting Services
- SQL Tools: Query Analyzer, Profiler
- Operating Systems: Windows XP, Windows 7, Windows 8, Windows Server 2008R2, Server 2012
- Operations with various SQL queries:
O Procedures
O Functions, Views
O CTEs, Temp tables and table variables
O Transaction -SQL
O DDL, DML
Personal Information
Date of Birth: 6th January 1994
Languages Known: English & Malayalam
Address: Tharol House, Medical College Post, Amabalakoth, Calicut, Kerala
Core Competencies
- Database Designing & Debugging
- Software Development
- Database Integrity & Design
- SQL Server Performance Tuning & Troubleshooting
- Disaster Recovery & Planning Solutions
- SQL Server Installation, Configuration & Maintenance
- ETL Testing and Developing
- Data ingestion
- Bigquery(data warehouse)
- Airflow DAG
- Version control(Git)
- Data modeling
Academic Details
B.Sc. (Computer Science) from University of Calicut in 2014
Timeline
Senior Database Developer
PIT Solutions
05.2023 - Current
Associate Team Lead
Sesame Software Solutions Pvt. Ltd.
10.2019 - 05.2023
Sr. Software Engineer
Perfect Software Solutions
01.2016 - 04.2019
Similar Profiles
Sumesh T KSumesh T K
Test Manager at PIT SolutionsTest Manager at PIT Solutions
GOKUL G DASGOKUL G DAS
Senior Software Engineer at Pit SolutionsSenior Software Engineer at Pit Solutions
Vishnu V NairVishnu V Nair
Product Owner at PIT SolutionsProduct Owner at PIT Solutions
Rahul R LRahul R L
Lead Software Engineer at PIT SolutionsLead Software Engineer at PIT Solutions
Dhanasyam PNDhanasyam PN
Project Manager at Emvigo TechnologiesProject Manager at Emvigo Technologies