Python, Spark and Data modeling
Devendhiran Velu
Data Engineer
Chennai
Summary
Dedicated professional with 10+ years of experience in IT industries, Seeking for job which offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
12
12
years of professional experience
3
3
years of post-secondary education
2
2
Certifications
2
2
Languages
Work History
Specialist Database Developer
Bank of New York Mellon
Chennai
08.2021 - Current
- Developed data models and schemas, including the use of normalization principles and denormalization techniques for optimizing query performance.
- Implemented data security measures, including encryption, user access controls and data masking to protect sensitive data.
- Tuned database performance by analyzing query execution plans, implementing indexing strategies and optimizing database configurations.
- Managed a team of database developers and administrators, providing guidance and mentorship on best practices and standards.
- Provided support for development teams on database-related issues, including query tuning, data modeling, and schema design.
Lead Data Engineer
ADP India pvt. ltd.
Chennai
09.2019 - 08.2021
- Built databases and table structures for web applications.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.
- Designed and developed analytical data structures.
- Analyzed large datasets to identify trends and patterns in customer behaviors.
- Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions.
Project Lead
Inautix Technologies
Chennai
11.2010 - 09.2019
- Planned, executed, and controlled assigned projects, ensuring work performed complied with contractual requirements.
- Met with manager weekly to provide detailed project report and milestone updates.
- Partnered with project team members to identify and quickly address problems.
- Maintained tactical control of project budgets and timelines to keep teams on task and achieve schedule targets.
Education
Bachelor of Science - Physics
Pachaiyappa's College
Chennai 06.2003 - 06.2006
Skills
Performance Tuning & Optimization
Datawarehouse Architect, Database Specialist, Data Modeler
ETL/ELT Expert, Report Designer
Domain: Finance, Banking, ERP, Loans, CLO, Bonds, Equity, Regulatory and Compliance, Mutual Fund, Trading and Clearing System, Advisory Solution, Payroll Processing
Software
Oracle, MS SQL, Sybase and Vertica
SSIS, Pentaho, Informatica, Azure Data Factory
SSRS, Power BI, Jasper and Business Objects
GIT, TFS, VSS and SVN
Remedy, ServiceNow and JIRA
Certification
Microsoft Certified: Azure Data Engineer Associate
Timeline
Microsoft Certified: Azure Data Engineer Associate
12-2022
Specialist Database Developer
Bank of New York Mellon
08.2021 - Current
Lead Data Engineer
ADP India pvt. ltd.
09.2019 - 08.2021
Project Lead
Inautix Technologies
11.2010 - 09.2019
MCITP - Microsoft Certified IT Professional – Database Administrator 2008
07-2010
Bachelor of Science - Physics
Pachaiyappa's College
06.2003 - 06.2006