Hi, I’m
Durai Fernandous S
PLSQL Developer
Chennai,TN
Summary
Senior SQL Developer with nearly 10 years of experience in database management, query optimization, and building efficient data models. Expert in the full software development life cycle (SDLC), specializing in ETL processes (SSIS), Legacy-to-Cloud migrations, and RDLC reporting. Proven track record of leading teams and delivering high-impact solutions for clients in Banking, Healthcare (HIPAA compliant), and Retail sectors.
Detail-oriented, organized, and meticulous employee. Works at fast pace to meet tight deadlines. Enthusiastic team player ready to contribute to company success.
Overview
10
years of professional experience
3
Languages
8
years of post-secondary education
Work History
Equifax
Software Engineer
11.2024 - Current
Job overview
- Executing the migration and conversion of legacy data systems to a new Cloud Environment using SQL and Perl.
- Developing and maintaining complex ETL workflows using SSIS to ensure data integrity during the migration process.
- Collaborating with cross-functional teams to map data fields and resolve discrepancies between legacy and cloud architectures.
- Project: Paynet BAU (Legacy to Cloud Conversion)
UST
Lead Developer
05.2022 - 10.2023
Job overview
- As part of 'Lift and Shift' strategy to migrate on-premise local databases to the Cloud, ensuring minimal downtime.
- Optimized existing SQL queries and stored procedures to improve performance in the new cloud environment.
- Served as the Senior SQL resource, conducting code reviews on best practices.
- Project: MDS Lift and Shift
Karvy Fintech
PLSQL Developer
03.2022 - 05.2022
Job overview
- Managed database schema changes, including altering tables and updating records based on specific portfolio requirements.
- Developed and maintained RDLC reports for banking financial data.
- Ensured data accuracy for critical banking transactions and customer records.
- Clients: Axis Bank, HDFC Bank
Triyam Information Technology
Team Leader
12.2018 - 02.2022
Job overview
- Lead a team of developers in converting historical data from old EHR systems to modern EMR platforms.
- Ensured strict adherence to HIPAA regulations while handling sensitive patient data.
- Specialized in complex ETL development and RDLC reporting to visualize patient data history.
- Project: Live Fovea (EHR to EMR Conversion)
- Clients: Memorial Community Hospital-Blair,Navos Mental Health, Mangolad Health System, Burrell Behavioral Health, Beatrice Community Hospital.
Brandidea Consultancy Pvt Ltd
SQL Developer
03.2016 - 12.2018
Job overview
- Developed complex queries to calculate CAGR (Compound Annual Growth Rate) and analyzing growth metrics.
- Processed raw customer data to generate area-wise and colony-wise growth reports to support business decision-making.
- Project: Brandidea UI (Client: Hindustan Unilever - HUL)
Education
Perunthalaivar Kamarajar Institute of Engineering&TechnologyKaraikal, India
B.Tech / B.E. from Information Technology
04.2012 - 05.2015
Karaikal Polytechnic CollegeKaraikal, India
Diploma from Information Technology
05.2008 - 10.2011
St. Mary's Higher Secondary SchoolKaraikal
SSLC from State Board
04.2007 - 04.2008
Skills
Databases: MS SQL Server (2012-2019), MySQL 57, Oracle 10g
undefinedTimeline
Software Engineer
Equifax
11.2024 - Current
Lead Developer
UST
05.2022 - 10.2023
PLSQL Developer
Karvy Fintech
03.2022 - 05.2022
Team Leader
Triyam Information Technology
12.2018 - 02.2022
SQL Developer
Brandidea Consultancy Pvt Ltd
03.2016 - 12.2018
Perunthalaivar Kamarajar Institute of Engineering&Technology
B.Tech / B.E. from Information Technology
04.2012 - 05.2015
Karaikal Polytechnic College
Diploma from Information Technology
05.2008 - 10.2011
St. Mary's Higher Secondary School
SSLC from State Board
04.2007 - 04.2008