Deepan Kumar

• Ensured data integrity by validating end-to-end data flows in complex, multi-tier systems.
• Optimized ETL processes for faster data extraction, transformation, and loading.
• Maintained high-quality documentation of test plans, scripts, and defects to facilitate knowledge sharing among team members.
• Writing SQL complex queries with using data base object
• Generate the Report, based upon the upstream or downstream user’s request using Oracle SQL developer tool we will generate the report manually
• Create Tickets through JIRA tool and work accordingly.
• Responsible for gathering and summarizing them into a

weekly report for management.

• Operated under Agile and Scrum frameworks to complete releases and well-organized sprints.
• Developed and maintained defect databases for known issues.
• Gather and analyze the business requirement of new change request from client.
• Tested data migration environment for validating migrated data as per requirement.
• Involved database testing and data validation after the migration done.
• Detecting bugs, classifying based on the severity, Priority and documenting them
• Defects spotted in the testing environment are communicated to the Developers.
• Implemented different types of SCD to the extracts data files based on the requirements.

• Used DML operation insert/update/delete to create the mock up data.
• Used joins and sub queries to validate referential integrity relations between the fact and dim tables.
• Creation of test scripts as per the business rules which mentioned in mapping sheet.
• Used SQL joins, aggregate functions and subqueries to validate joiner, aggregate and filter transformation.
• Create bugs by using the Jira tool and attached the test evidenced and assigned to the developer to fix the issues firstly.
• Involved in Agile process and a ended all agile meeting and given inputs to the team also raised the clarification points in the same meeting.
• Giving demo of assigned user story to the product owner and business analyst during sprint end.
• Used UNIX commands to test the files and tables to the comparison of data.
• Created SQL to validate the various transformations as per the mapping sheet.
• Strong Understanding in Software Testing Life Cycle processes.
• Strong Understanding in Software Testing Life Cycle processes.
• Created ETL test Scripts based on technical specification and source to target mapping.

• Handled HR application maintenance system. Conducted troubleshooting related activities for the recruiters globally. Provided online suggestions related to troubleshooting to the recruiters mostly from The U.S.A origin.
• Resolved problems related to Onboarding barring and releases. Provided solutions to MNP related queries and issue
• Generated, prepared and circulated MNP and MIS report to top levels.
• Handled TRAI and DOT Audit Process and Customer Application form for new SIM cards.
• Coordinated with clients and resolved on - boarding issues with candidates and provided L1 & L2 level support for Client Website. Conducted troubleshooting related activities for client on Job application website for candidates. (AIG)
• Assisted the strategic clients, through in-depth knowledge of their environment in order to ensure a smooth implementation of the system, while acting as their escalation resource to drive problem resolution
• 
  

• Established effective relationships with key stakeholders both internally and externally for increased collaboration opportunities.
• Mentored junior staff members, helping them develop their skills and advance in their careers.
• Improved department efficiency by streamlining and implementing policies and processes.
• Implemented process improvements that streamlined workflows, reducing redundancies and increasing operational efficiency.