Clement Lourduraj
Pondicherry
Summary
Technical support professional offering 7.2 years of experience with strong track record in resolving complex technical issues and leading support teams. Known for results-driven approach and commitment to team collaboration. Adaptable and reliable, with focus on customer satisfaction and technical proficiency.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Technical Lead
HCL Technologies
06.2024 - Current
- Provided L2/L3 technical support in LMS, a legacy system application handling order transactions within thewarehouse and VPWIN which is a shipping system
- Strong experience in writing Unix shell scripts for data extraction, data validations and generated statistics report for business and regulatory team.
- Developed and implemented shell scripts to extract the shipments, parcel information from the database and share it with business in an automated way via FTP/EMAIL files to avoid repetitive tasks and reduce time consumption
- Handled major P1/P2 incidents by analyzing the issues in detail, coordinating with stakeholders, and working along with the vendor for resolution.
- Provided educational expertise and mentoring to junior team members.
- Evaluated and recommended new tools and technologies that resulted in increased development efficiency and up-to-date technical skillsets within the team.
Senior Data Engineer
LTIMindtree
01.2022 - 05.2024
- Developed PL/SQL procedures, triggers, functions, indexes, and collections to implement business logic and generated server-side SQL scripts for data manipulation and validation and materialized views for remote instances
- Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries
- Performed SQL, PLSQL and application tuning using multiple tools, including EXPLAIN PLAN, SQL TRACE, Auto Trace
- Experienced in working with version control systems like GIT and used Source code management client tools like Git Lab
- Knowledge of using Routed Protocols: FTP, SFTP, SSH, HTTP, HTTPS and Connect directly
- Handled problem tickets and major change requests by supporting the go-live and deploying the binaries into the production environment
- Developed and implemented pro-active monitoring scripts that detected and resolved potential issues before impacting customers resulting in a 20% decrease in critical incidents
- Provided initial response, operational assistance, and resolutions/workarounds for incidents and service requests within the defined SLA’s
- Handled major P1/P2 incidents by analyzing the issues in detail, coordinating with stakeholders, and working along with the vendor for resolutio
- Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance
System Engineer
Tata Consultancy Services
12.2017 - 12.2021
- Worked in UniServe NXT, a REAP platform to produce bills and enhance customer experiences
- Developed complex SQL queries for validating the data against different kinds of reports
- Utilized joins and sub-queries to simply complex queries involving multiple tables while optimizing triggers and procedures in production
- Responsible for day-to-day systems maintenance, such as installing patches and fixes, space monitoring, file systems maintenance, performance monitoring, and tuning
- Good Experience with Application Servers/containers such as Tomcat / Apache
- Played a key role in preventing the data loss of a massive server by splitting the data to be maintained in three servers thus adding smooth customer experience and eliminating major customer escalations
- Collaborated with frontend design team and engineers in new design introduction phases to develop and verify design changes
- Experience in working as a technical lead and driving the team and training freshers within a short span of time
- Conducted regression testing and submitted observations to the development team
- Resolved several Business Oriented Complications, improved operations and provided exceptional client support
Education
Bachelor of Engineering - Information Technology
Pondicherry Engineering College
04.2017
Higher Secondary -
Petit Seminaire
04.2013
Skills
- Unix Shell scripting
- PLSQL
- Python
- HTML/CSS
- GIT
- Operating System (Linux/Windows)
Certification
- PLSQL Boot camp
- HTML/CSS
Timeline
Technical Lead
HCL Technologies
06.2024 - Current
Senior Data Engineer
LTIMindtree
01.2022 - 05.2024
System Engineer
Tata Consultancy Services
12.2017 - 12.2021
Higher Secondary -
Petit Seminaire
Bachelor of Engineering - Information Technology
Pondicherry Engineering College
Similar Profiles
Srinivasan NandagopalSrinivasan Nandagopal
ETL Lead /Onshore Technical Business Analyst at HCL Technologies India & HCL Technologies NZ LtdETL Lead /Onshore Technical Business Analyst at HCL Technologies India & HCL Technologies NZ Ltd
Dan WyszynskiDan Wyszynski
Senior Mortgage Loan Closer at HCL Technologies/HCL Lending ServicesSenior Mortgage Loan Closer at HCL Technologies/HCL Lending Services
Sudhanshu ShekharSudhanshu Shekhar
Director at HCL Technologies/HCL America Inc.Director at HCL Technologies/HCL America Inc.