Rakesh Kumarapillai Selvi
Trivandrum
Summary
Accomplished Data Engineer with extensive expertise in AWS and Azure. Proven track record in data engineering and team leadership, driving successful large-scale data analytics projects. Adept at optimizing ETL processes and enhancing BI reporting, contributing to improved operational efficiency and decision-making capabilities.
Overview
9
9
years of professional experience
Work History
Senior Technical Architect
IBS Software
01.2021 - 08.2024
- Company Overview: A leading SaaS provider offering mission-critical solutions to optimize operations and enhance customer experience in the travel, transportation, and logistics industries.
- 10 years of experience in data services, part of highly versatile and cross skilled team.
- Strong analytical, problem troubleshooting/solving skills, self-starter, Quick Learner.
- Experience in large data analytics in Retail domain and designing reports/scorecards for data interpretation and decision making.
- Strong Data engineering experience in designing data pipeline in Azure that supports various data needs for different Consumers.
- Proficient in business analysis to get the requirements.
- Proven work experience in ETL and API development using Python and AWS Cloud.
- Strong expertise in MSSQL, PostgreSQL, Tableau, AWS Lambda, Python, Azure Cloud Service, Databricks and GCP Platform.
- Team player, Mentored and groomed junior team members to enhance their professional growth and skillset.
- A leading SaaS provider offering mission-critical solutions to optimize operations and enhance customer experience in the travel, transportation, and logistics industries.
Senior Data Engineer
H&R Block
01.2021 - 08.2024
- Company Overview: H & R Block is a leading American Tax preparation company which is expanded over Australia, Canada.
- Manage and lead a 2-member team, ensuring efficient allocation of tasks and timely delivery.
- Perform technical lead activities, including schema level changes and impact analysis.
- Drive development tasks, including database modifications and dashboard updates due to schema changes.
- Onboard Tables in DataLake, Ensure performance optimization of SQL queries.
- Ensure the technical design aligns with architectural standards and best practices.
- Oversee the planning and execution of user stories for system enhancements.
- Troubleshoot and resolve complex technical issues, ensuring system reliability and scalability.
- Identify opportunities to enhance workflows and processes for improved team productivity.
- Implement best practices for code quality, testing, and deployment.
- H & R Block is a leading American Tax preparation company which is expanded over Australia, Canada.
- Technology Used: Pyspark, Snowflake S3, Tableau, Airflow, GIT, AWS
Python ETL Developer
UST
11.2019 - 01.2021
- Company Overview: A North American leading retirement services company that issues, reinsures, and acquires retirement savings products designed for individuals and institutions.
- Understand the ETL requirement and implement the business logic into python code.
- Responsible for implementation of certain modules and involve in defect fixing.
- Developing and maintaining certain modules in the ETL tool.
- Involved in the Table Design and defect fixing.
- Exposure to the performance optimization of the SQL and python code.
- Involved in developing and deploying AWS Lambda, Lambda layers, AWS API gateway.
- Responsible for developing certain modules in Lambda layers.
- A North American leading retirement services company that issues, reinsures, and acquires retirement savings products designed for individuals and institutions.
- Project designation: Python ETL Developer
- Software and Services Used: Python 3, PostgreSQL, AWS RDS, AWS Lambda, AWS SQS, AWS API Gateway
Senior Data Engineer
UST
03.2018 - 11.2019
- This Project aims to remediate the database to Sox Compliance Standard.
- This is a database security project that ensures sox access standards for oracle and postgresql database environments.
- And it facilitates data security for auditing to establish the rules, standards, and quality control mechanisms that govern financial reporting.
- This application standardizes the database roles to onboard in the IAM tool for requesting access and it supports the onboarding and cloning of new database and schema with the environment specific SOX standards.
- Project designation: DBA & SOX Compliance Automation
DBA
UST
02.2015 - 03.2018
- This Project aims to provide solution for the client on the BI Reporting requirements.
- Management is monitoring to see the insights on the various Key Performance Indicators on the business areas like Sales and Margin Based Analysis, Life Cycle and Inventory Management, Point of Sales, and Service Level Analysis.
- Client: A Fortune 500 manufacturer and marketer of leading everyday basic apparel under some of the world's strongest apparel brands in the Americas, Europe, Asia, Australia, and South Africa.
Education
Bachelor of Technology - Computer Science and Engineering
Kerala University
04.2014
Skills
- AWS
- Azure
- Python
- ETL
- BI Reporting
- Databricks
- Data engineering
- Tableau
Accomplishments
- Awarded for 'Execution Mindset' for Quarter 3 performance in 2016.
- Awarded for the Team player in the Dream Team from the Core Emerging North American Account.
- Won D3 Programming Challenge 2018 in Hacker Rank competitions conducted by UST.
- Active participant in Hackathon. Listed out in the Top 10 team in D3 UST Hackathon 2019.
Timeline
Senior Technical Architect
IBS Software
01.2021 - 08.2024
Senior Data Engineer
H&R Block
01.2021 - 08.2024
Python ETL Developer
UST
11.2019 - 01.2021
Senior Data Engineer
UST
03.2018 - 11.2019
DBA
UST
02.2015 - 03.2018
Bachelor of Technology - Computer Science and Engineering
Kerala University
Similar Profiles
Sreejith NairSreejith Nair
Lead Solution Engineer at IBS SoftwareLead Solution Engineer at IBS Software
Midhun KMidhun K
Senior Product Analyst at IBS SoftwareSenior Product Analyst at IBS Software
Anasooya KailasAnasooya Kailas
Lead Software Engineer at IBS SoftwareLead Software Engineer at IBS Software
Gowri SheelaGowri Sheela
Senior Analyst- Enabling Transformation at IBS SoftwareSenior Analyst- Enabling Transformation at IBS Software
SIDDU HUSSAIN ASIDDU HUSSAIN A
SENIOR INSURANCE OPERATIONS EXECUTIVE at AFIA INSURANCE BROKERAGE LLC (INSURANCE MARKET.ae)SENIOR INSURANCE OPERATIONS EXECUTIVE at AFIA INSURANCE BROKERAGE LLC (INSURANCE MARKET.ae)