Summary
Overview
Work History
Education
Skills
Languages
Areas Of Excellence
Projects
Accomplishments
Timeline
Generic
Mahendran Rajendran

Mahendran Rajendran

Bangalore

Summary

Competent and results-driven IT professional with over 13.8 years of experience in Test Management, Project Delivery, and Data-Centric Quality Assurance across banking, insurance, and enterprise domains. Demonstrated expertise in ETL Testing, Data Load Validation, Defect Management, Test Strategy, API & Mobile Testing, and Data Automation. Adept at leading testing schedules, managing incident workflows, and ensuring seamless release coordination with stakeholders. Proficient in BI Reporting, Data Warehousing, Data Migration, and Big Data technologies including Hadoop Hive and FICO Tonbeller. Hands-on experience with cloud platforms such as AWS, Google Cloud Platform (GCP), and Microsoft Azure, supporting scalable data testing, automation, and migration initiatives. Spearheaded pre-sales engagements for data-centric testing solutions—owning solution design, effort estimation, and implementation planning. Successfully responded to RFPs and RFIs, aligning technical and commercial narratives to client requirements. Led strategic transformation initiatives, QA governance (CAB), and operational execution across global programs. Delivered high-quality releases through risk-based testing, defect containment, and automation-driven continuous improvement. Skilled in tools like Informatica PowerCenter, DataStage, Selenium, Ambari Hive, SOAP UI, Postman, and reporting platforms. Strong database expertise in Oracle 11g, SQL Server 2012, Teradata, Netezza, and Unix environments. Served as a Subject Matter Expert (SME) in testing methodologies, embedding best practices across manual and automation frameworks. Experienced in KYC, AML, Real-Time Screening, and CFT compliance. Collaborated closely with program managers and development teams to define and track quality metrics throughout the SDLC. Gained 20 months of onsite experience, demonstrating strong client-facing communication, team leadership, and delivery ownership. Analytical IT professional specialising in Test Management with a keen focus on data integrity and quality assurance. Managed complex testing frameworks, optimising processes through automation and strategic planning. Championed quality improvement initiatives, ensuring compliance with industry regulations and stakeholder expectations. Proactive solution consultant with a strong foundation in requirement analysis and client engagement. Cultivated cross-functional collaboration to design tailored solutions that align with client objectives, ensuring feasibility and scalability. Leveraged strong communication and leadership skills to mentor teams and drive project success. Results-driven IT professional with expertise in Test Management and Data-Centric Quality Assurance across banking, insurance, and enterprise domains. Spearheaded pre-sales engagements for data-centric testing solutions, enhancing client engagement and proposal success. Delivered high-quality releases through risk-based testing and continuous improvement initiatives.

Overview

13
13
years of professional experience

Work History

Solution Consultant

Wipro
12.2022 - Current
  • Led end-to-end pre-sales activities for Data Assurance, including client engagement, requirement analysis, and customized solution design across BFSI, Retail, and Telecom domains.
  • Developed and presented tailored solutions aligned with client needs, collaborating with cross-functional teams to ensure feasibility and scalability.
  • Owned effort estimation and pricing strategies for proposals, balancing cost-effectiveness with delivery excellence.
  • Successfully responded to multiple RFPs and RFIs, crafting compelling proposals and technical narratives that enhanced win probability and client confidence.
  • Partnered with delivery and sales teams to refine go-to-market strategies and support deal closures through impactful presentations and demos.
  • Approved requirements and design specifications, technical documents, source-to-target mapping documents, and other related documentation from a testing perspective.
  • Accountable to both the Quality Assurance Manager and Project Delivery Team.
  • Worked with project teams to define detailed Test Plans, working through Test Managers, Test Leads, or to ensure that test plans are effectively executed.
  • Provided Go/No Go recommendations to the Project team and the Project Management Office (PMO).
  • Defined the Test Strategy to include the number of required phases, risk level, performance testing, required environments, and data management, ensuring alignment with broader Organizational Test Strategy.
  • Ensured that approved changes in program scope and schedule are communicated and shared with appropriate stakeholders.
  • Managed the scripting of test plans and test cases with requirements and got them reviewed with data analysts.
  • Created and maintained the test strategy document for ETL tasks and other related applications that communicate with ETL tools and technologies.
  • Designed test cases as per test plan and user specs.
  • Assessed the entrance and exit criteria for code and data migration into the test and production environment.
  • Led the Test data creation for volumetric testing and any performance testing, including test cases for capacity planning.
  • Established Standard Test Processes and Deliverables (including defect management and quality metric reporting) within the gated process to streamline testing and support automation efforts.
  • Built Quality Gate Development processes and procedures; deployed short- and long-term Quality Improvement Programs such as CI/CD and DevOps implementations.
  • Defined the scope of testing and produced/managed test planning documents for all releases; estimated effort for each release and procured resources required.
  • Articulated and managed testing issues and risks; managed project stakeholders and tracked schedules.
  • Supervised the documentation of all software deployed into production, developing highly technical release notes for the engineering team.
  • Mentored and coached the Testing Team as Quality Assurance Lead.
  • Conducted release planning, requirement analysis, and effort estimation.
  • Led pre-sales engagements for data-centric testing solutions, including solution design, effort estimation, and implementation planning across BFSI, Retail, and Telecom domains.
  • Owned effort estimation, pricing strategies, and responses to RFPs/RFIs, aligning technical and commercial aspects to client requirements.
  • Handled escalations by articulating and managing testing issues, risks, and incident workflows, ensuring timely resolution and stakeholder communication.
  • Took ownership as Release Lead for insurance companies’ compliance such as KYC/AML & CFT.
  • Took ownership of Incident Management team and built testing team for QA chapter.
  • Took ownership to train freshers on technical and non-technical skills.
  • Emerged as a key technical panelist role for data testing in Wipro.
  • Gained experience of working in South Africa for two years.
  • Trained freshers to deploy into projects.
  • Upskilled junior associates.
  • Skilled in maintaining the test environment and preparing test data and test cases for Testing suites.

Project Lead

Liberty Retail Insurance
08.2018 - 02.2024
  • Joined the project during transition from L&T to Wipro, taking ownership from the beginning.
  • Formulated and executed enterprise-level test strategies, planning, and estimation.
  • Managed functional, automation (mobile, mainframe, IVR, UI, data), API, data migration, data warehouse, regression, and end-to-end testing.
  • Oversaw testing across CRM, customer, advisor, quotes, proposals, billing, collections, payments, claims, commissions, compliance (KYC, AML, CFT), and integrations with banks, tax systems, and investment companies.
  • Approved CIRs from QA to UAT environments and ensured timely releases.
  • Led new tool adoption, POCs, and optimization with automation/regression packs.
  • Handled demand fulfillment, resource changes, KT sessions, and onboarding of new resources.
  • Directly managed 12 reportees and indirectly coordinated with 95 team members across enterprise QA, including teams from Wipro and other vendor partners.
  • Raised invoices based on team timesheets for resource billing.
  • Drove transformation from Waterfall to Agile and Kanban to Agile, working closely with IT Heads and RTEs.
  • Actively participated in PI planning for 4 Agile trains with 24 Scrum teams.
  • Presented project status to IT heads and vendors, actively participated in Serco and Exco meetings for strategic alignment.
  • Liberty has emerged as the number one insurance company, providing risk, investment, and health insurance.
  • Enterprise QA leadership, Agile transformation, PI planning, planning & estimation, resource onboarding/KT, automation, release management, compliance testing, stakeholder communication, vendor coordination, financial tracking.

Project Lead

Cigna Health Insurance
12.2017 - 08.2018
  • Took active part in PI planning and sprint planning.
  • Coordinated with project teams to ensure test environments and data availability.
  • Managed Informatica workflows, loaded data from source systems, and validated results.
  • Scripted test plans and test cases, reviewed with data analysts.
  • Oversaw defect lifecycle and ensured timely releases.
  • Used job scheduler tools for data loads and managed test documentation in HP ALM.
  • Upskilled functional/manual testers into data testing and API testing.
  • Cigna is an insurance service provider company, presenting insurance services for health-related issues and online recording services for worldwide customers.
  • Informatica, SQL, HP ALM, Agile (PI/Sprint planning), defect management, mentoring, healthcare domain knowledge.

Project Lead

Dish Network
02.2016 - 12.2017
  • Worked on Informatica to load and validate data from source systems.
  • Led a team of 5 testers, assigning tasks and ensuring timely completion.
  • Managed deployments in both test and UAT environments.
  • Automated database validation using testing tools.
  • Scripted test plans and test cases, reviewed with data analysts.
  • Led defect tracking and ensured timely releases.
  • Independently managed full environment (deployment, data load, bug fixes, SVN code updates).
  • Uploaded test plans, test cases, and results in HP ALM.
  • Worked on Dish Network, a satellite service provider company. It provides satellite TV, set-top boxes, and online recording services for US customers.
  • Informatica, SQL, automation tools, HP ALM, SVN, leadership, end-to-end environment management.

Test Lead – Data Testing

GSK & Parexel
08.2015 - 02.2016
  • Formulated test plans and designed complex test cases for healthcare data.
  • Assessed source data from GSK and validated Slowly Changing Dimension (SCD) Type 2 tables.
  • Monitored defect lifecycle per process and ensured timely releases.
  • Performed test cases and tracked defects using HP Quality Center/HLM.
  • Validated dimension and fact tables, performed mockups, and ensured data accuracy.
  • Worked across two vendors (Parexel & GSK) to align testing efforts.
  • Supported junior testers with guidance on data validation and defect tracking.
  • Parexel is a healthcare company that deals with human life data, extracted from GSK Company.
  • SQL, SCD Type 2 validation, Oracle/BI testing, defect management tools (HLM), healthcare domain knowledge, cross-vendor collaboration.

Senior Software Test Engineer – BI/Data Warehouse

Union Bank of India
05.2015 - 08.2015
  • Defined strategies for validating 30+ BI modules (deposits, profitability, etc.).
  • Ensured accuracy and integrity across multiple Oracle databases.
  • Validated end-to-end data flows, scalability, and dashboard/reporting validation for different users.
  • Confirmed data meets banking regulatory and audit requirements.
  • Worked directly with business UAT users at client location to validate functionality and resolve issues.
  • Guided junior testers in test case design, execution, and defect reporting.
  • Partnered with BI developers, DBAs, and business stakeholders to ensure smooth delivery.
  • Union Bank maintains a very large BI and data warehouse environment. It consists of a portfolio of more than 30 different subject areas or ‘modules’, supporting thousands of business users.
  • SQL, Oracle BI/data warehouse testing, validation, banking domain knowledge, leadership, mentoring, UAT coordination.

Senior Software Test Engineer

Wal-Mart
12.2014 - 04.2015
  • Defined and executed test strategies for Wal-Mart’s data warehouse technology refresh.
  • Ensured accuracy, consistency, and integrity of data across collection, analytics, and reporting layers.
  • Validated end-to-end data flows, scalability, and reports and dashboard functionalities.
  • Collaborated on testing new technologies to strengthen competitive retail advantage.
  • Guided junior testers in test case design, execution, and defect management.
  • Worked with developers, data engineers, and business stakeholders to resolve issues.
  • Wal-Mart planned expansion includes a data warehouse technology refresh program which aims to keep Wal-Mart's data warehouse on the leading edge of technology adoption.
  • SQL, data warehouse testing, analytics tools, validation, leadership, mentoring.

Test Lead

Telkomsel Indonesia
02.2014 - 12.2014
  • Defined strategy and detailed plans for data collection, analytics, and reporting systems.
  • Validated accuracy, transformation logic, and KPIs across OSDSS modules.
  • Ensured end-to-end data flow and dashboard functionalities.
  • Verified adherence to telecom regulations and secure data handling.
  • Guided junior testers in test case design, execution, and defect reporting.
  • Worked with developers, data engineers, and business teams to resolve issues.
  • Telkomsel is implementing an OSDSS solution that comprises the Data Collection & Transport System; Analytics System & the Reporting & Visualization System.
  • SQL, telecom data knowledge, analytics tools, leadership, mentoring.

Test Engineer

Wipro InfoTech
10.2013 - 01.2014
  • Reviewed functional specifications for modules like timesheet management, employee onboarding/offboarding (joiners & movers), and reporting hierarchy.
  • Executed predefined functional test cases to validate workflows.
  • Ensured timesheet entries, approvals, and escalations worked as expected.
  • Verified onboarding workflows, role changes, and access provisioning for new/moved employees.
  • Confirmed reporting lines, manager assignments, and escalation paths were correctly reflected.
  • Identified functional gaps or mismatches and reported them to senior testers or developers.
  • Re-ran test cases after fixes or updates to ensure stability.

Test Engineer

Citi Bank
03.2013 - 09.2013
  • Verified data extraction from source systems (e.g., core banking, CRM).
  • Ensured business rules (interest calculations, transaction limits) were correctly applied during transformation.
  • Confirmed accurate loading into target systems (data warehouse, reporting tools).
  • Ran predefined ETL test cases and documented results.
  • Identified discrepancies in data and reported issues to senior testers/developers.

Education

M.Sc. - Computer Science

Vellore Institute of Technology (VIT)
01-2016

B.C.A. - Computer Sceince

Bangalore University
SSMRV
01-2012

Skills

  • Informatica PowerCenter
  • QuerySurge
  • Hadoop Hive
  • Teradata
  • TEAMS
  • Test Data Management (Broadcom)
  • AWS Athena
  • S3
  • SOAP
  • Postman
  • SQL Server
  • HP ALM
  • Teradata (Utilities)
  • Unix Shell Scripting
  • DataStage
  • BI Reports
  • Selenium
  • AWS
  • Azure
  • FICO Tonbeller
  • API Testing
  • Azure Databricks
  • GCP BigQuery
  • Power BI
  • Tableau
  • SQL
  • ERP/BI/Data Warehouse tools
  • APIs
  • Informatica
  • Agile
  • SAFe
  • PI planning
  • Scrum
  • Kanban
  • RFI
  • RFP
  • POC
  • Leadership
  • Collaboration
  • SLA metrics governance
  • Stakeholder communication
  • Financial tracking
  • Client engagement
  • Requirement analysis
  • Solution design
  • Effort estimation
  • Pricing strategies
  • Data testing
  • Test strategy
  • Agile transformation
  • Cross-functional collaboration
  • Stakeholder management
  • Risk assessment
  • Quality assurance
  • Team leadership
  • Incident management
  • Training and mentoring
  • Customer service excellence
  • Time-management
  • Decision making
  • Effective communication
  • Technical troubleshooting
  • Relationship-building
  • Product knowledge
  • Technical communication
  • Client Relationship Management
  • Critical decision making
  • Project Management
  • Client focus
  • Process Improvement
  • Initiative taking
  • Business analysis
  • Visionary thinking
  • Analytical

Languages

English
Hindi
Tamil
Kannada

Areas Of Excellence

  • ETL & BI Reports Testing
  • Automation Testing
  • IT Services
  • Quality Assurance
  • Leadership
  • Service Delivery
  • Data Warehousing
  • Data Migration
  • Regulatory and Compliance
  • Defect Management
  • IT Project Management
  • Team Management
  • Pre-sales
  • Incident Management
  • Soft Skills

Projects

  • ANZ Bank – Bengaluru, India, HR Data & Analytics Lead – SAP SuccessFactors, 2024-02-01, 2025-09-30, Led the employee data management and analytics initiative for ANZ Bank, leveraging SAP SuccessFactors to streamline HR operations, enhance data integrity, and support strategic decision-making across global teams., Managed end-to-end employee data lifecycle within SAP SuccessFactors, ensuring accuracy, compliance, and readiness for analytics., Collaborated with HR, IT, and compliance teams to align data structures with regulatory requirements and internal governance policies., Designed and implemented dashboards and reporting frameworks for workforce analytics, attrition trends, and performance metrics., Enabled data-driven decision-making by integrating SuccessFactors modules with downstream analytics tools., Conducted regular audits and health checks to maintain data quality and system performance., Supported global HR transformation initiatives by customizing SuccessFactors workflows for ANZ’s regional needs., Provided training and documentation for HR teams to ensure consistent data handling and reporting practices., Played a key role in transitioning legacy systems to SAP SuccessFactors, minimizing disruption and ensuring continuity.
  • Wipro Data Assurance Practice - SAP SuccessFactors, Data Assurance Practice Lead, 2024-02-01, 2025-09-30, Requirement Analysis & Solution Design: Gathered and analyzed business requirements, translated them into technical specifications., Testing & Validation: Prepared test plans, executed functional/data validation, and supported UAT. Ensured compliance with regulatory, security, and audit standards., Innovation & Tools: Proposed and evaluated new tools, conducted POCs, and drove adoption for process optimization. Handled RFI/RFP responses with customers to support new business opportunities., Global Project Leadership: Led projects across America, Europe, and Australia, ensuring delivery excellence. Managed demand fulfillment, estimation, and implementation planning. Oversaw resource allocation, onboarding, and knowledge transfer (KT)., Team & Stakeholder Management: Acted as an interview panelist for new demand and resource hiring. Directly managed project teams and coordinated with vendor partners. Collaborated with Wipro practice heads on solutioning and upskilling resources. Liaised with IT Heads, RTEs, and business stakeholders for alignment., Agile Transformation: Drove transformation from Waterfall to Agile and Kanban to Agile. Participated in PI planning for 4 Agile trains with 24 Scrum teams., Governance & Reporting (SLA Metrics): Monitored defect management, tracked project health, and ensured entry/exit criteria were met. Ensured SLA metrics were achieved across testing and delivery cycles. Presented project status to leadership and vendors, actively participated in Serco and Exco meetings. Managed invoicing based on team timesheets for resource billing.

Accomplishments

  • Worked directly with senior leadership to develop and administer Rand (64512000)-per year department budget.
  • Recognised by management for Regulatory projects delivering outstanding [Result] Best team, Best Leader, zero Production .
  • Enhanced Water fall to agile processes, implementing across All the testing team for increased productivity and profits.

Timeline

Solution Consultant

Wipro
12.2022 - Current

Project Lead

Liberty Retail Insurance
08.2018 - 02.2024

Project Lead

Cigna Health Insurance
12.2017 - 08.2018

Project Lead

Dish Network
02.2016 - 12.2017

Test Lead – Data Testing

GSK & Parexel
08.2015 - 02.2016

Senior Software Test Engineer – BI/Data Warehouse

Union Bank of India
05.2015 - 08.2015

Senior Software Test Engineer

Wal-Mart
12.2014 - 04.2015

Test Lead

Telkomsel Indonesia
02.2014 - 12.2014

Test Engineer

Wipro InfoTech
10.2013 - 01.2014

Test Engineer

Citi Bank
03.2013 - 09.2013

M.Sc. - Computer Science

Vellore Institute of Technology (VIT)

B.C.A. - Computer Sceince

Bangalore University
Mahendran Rajendran