Summary
Overview
Work History
Education
Skills
Websites
Disclaimer
Languages
Accomplishments
Timeline
Generic

Prasannakumar Dhanabal

Chennai

Summary

Data Engineer with extensive experience in data integration and performance tuning. Expertise in leading cross-functional teams and enhancing ETL processes. Proficient in MS SQL and incident management, delivering solutions that significantly improve operational efficiency.

Overview

10
10
years of professional experience

Work History

Product Engineer - Team Lead

Intellect design Arena Ltd
Chennai
06.2022 - Current
  • Executed product migration and implemented automated pre-checks to prevent ETL failures.
  • Designed load monitoring tool in Excel to effectively track ETL progress.
  • Developed SSIS packages for data transfer, tested data loads, and prepared unit test case results.
  • Resolved data issues within product environment through thorough analysis and troubleshooting.
  • Provided support to production team by addressing incidents and application problems.
  • Managed escalations with responsibility, coordinating effectively across multiple teams.
  • Optimized performance of stored procedures and SSIS packages through tuning techniques.
  • Mentored team members by offering technical guidance, conducting code reviews, and overseeing process management.

Release Management Lead

St. James's Place
England
02.2024 - 01.2025
  • Served as primary liaison among data operations, project, QA, DevOps, DBA, cloud-ops, and business teams.
  • Communicated release scope, timelines, risks, and dependencies to stakeholders effectively.
  • Organized and led weekly release knowledge transfer meetings with status updates.
  • Ensured seamless execution of releases through code deployment, configuration, and testing.
  • Troubleshot release-related issues and coordinated resolution efforts across teams.
  • Developed rollback plans to mitigate risks during release failures.
  • Conducted post-implementation reviews to identify areas for release improvements.
  • Maintained infrastructure details for owned servers and managed obfuscated databases in lower environments.

Data Analyst

HDFC bank Limited
Chennai
03.2020 - 06.2022
  • Managed overall portfolio details for credit card customers nationwide.
  • Analyzed customer performance daily, reporting findings to policy and post-issuance review teams.
  • Determined personal loan eligibility based on behavior scores and policy documentation for all Indian credit card customers.
  • Oversaw monthly PL2CC process for HDFC Bank credit card holders across India.
  • Designed reports in Tableau, creating dashboards and storyboards to visualize data effectively.

Data Engineer

Equitas Small Financial Bank
Chennai
12.2018 - 03.2020
  • Designed and developed ETL jobs in Talend Open Studio for effective data integration.
  • Automated execution of batch files through Windows Task Scheduler and scheduled queries.
  • Contributed to MIS team by designing reports in Tableau for business stakeholders.
  • Executed server-to-server data transformation on FRM project using ETL tools.
  • Managed user access for IBM Cognos portal to ensure secure data retrieval.

Technical Consultant

Smartmegh Solutions Pvt. Ltd.
Chennai
09.2016 - 11.2018
  • Developed logic for screens utilizing stored procedures, functions, triggers, and cursors in MS SQL database.
  • Scheduled jobs to populate records in staging tables efficiently.
  • Conducted performance tuning through execution planning and SQL profiler analysis.
  • Prepared comprehensive test case results to ensure data integrity.
  • Executed data integration across servers using SSIS tool and automated package deployments.

Project Trainee

Ramco System Ltd.
Chennai
11.2015 - 08.2016
  • Designed screens using IEDK and implemented logic with stored procedures, functions, triggers, and cursors in MS SQL database.
  • Created reports with Jaspersoft iReport and DW Reporting tools to meet client specifications.
  • Utilized SQL Profiler and Index Tuning Wizard for debugging and optimizing slow-running queries.
  • Conducted testing and documented test case results to ensure quality assurance.
  • Managed version control of objects in Tortoise Subversion and Visual SourceSafe.
  • Resolved issues and provided project support to maintain operational efficiency.

Education

Bachelor of Technology - CSE

Perunthalaivar Kamarajar Institute of Engineering & Technology
Nedungadu
06-2015

Skills

  • Snowflake
  • MS SQL
  • Oracle databases
  • Data integration
  • Data warehousing
  • ServiceNow
  • Release managment
  • Creating dashboards
  • Performance tuning
  • Debugging
  • Report designing

Disclaimer

I hereby declare that the information furnished above is true to the best of my knowledge.

Languages

Tamil
First Language
English
Proficient (C2)
C2

Accomplishments

  • Received multiple Gold Star ratings for resolving the incidents raised by clients
  • Received multiple spot awards and received cash prizes

Timeline

Release Management Lead

St. James's Place
02.2024 - 01.2025

Product Engineer - Team Lead

Intellect design Arena Ltd
06.2022 - Current

Data Analyst

HDFC bank Limited
03.2020 - 06.2022

Data Engineer

Equitas Small Financial Bank
12.2018 - 03.2020

Technical Consultant

Smartmegh Solutions Pvt. Ltd.
09.2016 - 11.2018

Project Trainee

Ramco System Ltd.
11.2015 - 08.2016

Bachelor of Technology - CSE

Perunthalaivar Kamarajar Institute of Engineering & Technology

Similar Profiles

CREATE PROFILE
Prasannakumar Dhanabal