Akhil Surendran

Involved in core project meetings to understand Requirements, Gathering details which will aid to prepare Test Scenarios to perform detailed ETL testing.

• Worked with business users to get their sign off on QA validated ETL components and reports.
• Worked with Data Stewards to ensure Data elements are captured in Data catalogs maintained and to prepare and implement Data Quality Rules.
• Verification of SOX controls which are daily and monthly and working with Data governance team to ensure SOX evidences are documented for Audit purposes.
• Mentored and guided offshore team on Test Execution and migration activities.
• Prioritized and assigned daily tasks for offshore team and having daily calls with offshore team to track work status.
• Participated in Defect triage calls to discuss and address bugs discovered during validations and track them to closure.
• Participated in Daily scrum calls, discussing day to day activities and backlog items.
• Prepared healthy dashboard for sprints and maintaining good backlog stories for upcoming sprints for team.
• Automated test scenarios and detailed test cases using in-house ETL Automation tool - Jumbo

• Single Point of contact for QA efforts for the factory work
• Created Test plans, Test Strategy and summary reports.
• Requirement analysis and scoping for efforts.
• Creating and reviewing test scenarios and test cases
• Test environment data set up for scenarios under validations.
• Executing test cases, defect triaging and reporting
• Production Deployment and post deployment support.
• Effort estimation and JIRA management
• Coordination with UAT team for their data needs and with other vendor partners

• Worked in a project that deals with the development of business solutions for determining the cost and profitability of various data processing cycles we have across the business units.
• The work includes the validation of data loaded from various source systems using Unix scripts and control M jobs to the target which is usually a Netezza database. The processed data available is later projected through OBIEE as reports for the business users to view, analyze and decide.
• Escalated concerns about project and process quality, referring discovered issues to engineering manager for correction.
• Reduced product defect rates by creating robust test cases and meticulously executing them and used QC/ Jira for reporting bugs and track them for closure
• Increased customer satisfaction by diligently identifying and reporting bugs for prompt resolution.

• Prepared test scenarios and test cases and executing the test cases in HP-ALM.
• Prepared the test data in source CSV files, covering all the possible scenarios.
• Executed the unix scripts in Hadoop environment to get the data loaded in Hive and validating the data quality and accuracy.
• Validated the data at the target oracle database by preparing SQL queries for and comparing them against Hive data.
• Reporting the bugs in JIRA if there are any discrepancies in data quality, accuracy and readiness.
• Interacting with the offshore/Onshore-BA to get knowledge on terms and scenario preparations.
• Trained junior engineers through WebEx or live KT sessions with team members.