Elakkiya Selvaraj

• Employed in the HDFC Bank Salary Team, where responsibilities included the development of scorecards encompassing salary and business particulars for all HDFC Bank employees, utilizing SQL and SSIS.
• Conducted comprehensive analysis of business data to generate reports covering various scenarios.
• Engaged in the creation of new scorecards and the optimization of existing ones.
• Executed daily, interim, and monthly job runs for account balance, employee, and product details, along with conducting testing procedures for the same.
• Addressing HDFC customer technical inquiries by examining transactions using Talk2BIU tool within the specified Service Level Agreements (SLAs) and providing clear explanations for customer queries.

Client - Ameri source Bergen Duration –Sep 2015 to Jun2017

• Engaged in every phase of the project life cycle
• Analyzed requirements and produced technical design documentation
• Developed ETL code using Informatica and SQL
• Conducted testing on Informatica mappings
• Automated the validation of existing source files
• Executed Functional testing and unit testing of ETL codes, assessing various scenarios
• Contributed to the tuning and optimization of Informatica and SQL codes

Client- Experian Duration – May 2015 to Sep2015

• Analyzed SQL Server stored procedures and assessed their process flow
• Replicated equivalent stored procedures in Netezza, ensuring the preservation of logic despite the substitution of SQL Server-specific functions
• Modified the cross-database process in SQL Server to incorporate new procedures, as the cross-database concept is not applicable in Netezza
• Conducted Functional testing and unit testing of the stored procedures, evaluating various scenarios and validating proper exception handling for error management
• Executed unit testing by comparing data between SQL Server and Netezza tables

Client - Wash Laundry Duration – May 2014 to May 2015

· Daily Load monitoring, testing in SQL, Report creation in SQL.

ELT Training – Nov – 2013 to May 2014

I underwent comprehensive training in all aspects of the ETL (Extract, Transform, Load) process conducted by the internal training team.