PRADEEP PRABHAKARAN
Mysore
Summary
Project Manager with around 1y years of experience in Quality Assurance involved in ETL Testing, Report Testing, Master Data Management Testing, Risk Based Testing and User Acceptance Testing. Managed large team of 28 employees working on a critical project with stringent delivery timelines and complex delivery structure. 6 years of onshore experience in US as Technical Test lead working in ETL/Data warehousing projects, cross workstream projects with end-to-end implementation. As a Techno functional resource for various banking projects, exhibited excellent results during Requirements, Gap and Impact Analysis, Design, Development and Quality Assurance phases. Successful in managing global delivery models working with offshore & onsite teams.
Overview
16
16
years of professional experience
Work History
Technology Architect
Infosys Ltd.
10.2023 - Current
Project Manager
Infosys Limited
01.2022 - 10.2023
- Managed a large team of 28 employees.
- Test Estimation, Budgeting and Staffing.
- Proactively managed Project risks from the lessons learnt in the earlier releases.
- Mentored the offshore employees to follow best QA practices and successfully achieved the project scheduled goals. Motivating the team to reskill as per the clients’ future guideline.
- Project Name: Truist Enterprise Reporting Mart
- Project Overview: This project was part of a merger between 2 big US banks – BB&T and SunTrust Bank. The result was that – a new ETL DataMart had to be build and reports had to be developed from the new DataMart. This validation consisted of 600 reports and 305 tables as part of Phase 1 scope.
- Testing: ETL/Data Warehouse Testing, Report Testing
- Software/Tools Used: Oracle SQL Developer, Putty and QlikView
Technical Test Lead
Infosys Limited
04.2019 - 12.2021
- Used Agile Scrum methodology in my work – participate in the Daily Scrum, Sprint Planning, Review and Retrospective meetings.
- Build SQLs and Test cases required for the ETL validation as per the business rules.
- Scripting using PowerShell and Python to automate the ETL regression Test suite which reduced the regression testing window from 5 days to 1 person day.
- Mentored team of 4 offshore employees to follow best QA practices and successfully achieved the project scheduled goals.
- Project Name: Ally Mortgage
- Project Overview: The purpose of this project is to source files from multiple data sources like Cenlar, Better, Bulk and build a single ODS for all Mortgage data. This enables business to perform analytics and generate required business/ regulatory reports.
- Testing: ETL/Data Warehouse Testing
- Software/Tools Used: JIRA, IDTW, SQL Server Management Studio, Oracle SQL Developer, Putty and SOAP UI
Consultant - US
Infosys Limited
04.2017 - 03.2019
- Interacting with Business Analysts and Business Teams for any clarifications on the User stories and produce the Test Case and Test approach.
- Used Agile Scrum methodology in my work – participate in the Daily Scrum, Sprint Planning, Review and Retrospective meetings.
- Build SQLs, Test cases and scenarios for testing the Match and Merge, Suspect processing and Address Standardization functionalities.
- Supported the team in UFT automation using VB scripting to automate the regression Functional and Data validation Test cases.
- Mentored team of 1 onshore and 6 offshore employees to follow best QA practices and to achieve the project schedule goals. Coordination with offshore test team.
- Project Name: Customer Information & Analytics (CIA)
- Project Overview: The purpose of this project is to establish a Master Data Management solution for customer data across all product lines of Ally Financial to assure data completeness and consistency from multiple data sources. It provides a singular view of customer data for Deposits, Invest and Mortgage LOBs. This data is then ingested to the HADOOP platform where the Business users can perform analytics operations and generate POWER BI reports.
- Testing: Master Data Management Testing
- Software/Tools Used: Version One, Unified Functional Test, Cloudera Navigator, HIVE, Impala, Putty and SOAP UI
Technical Test Lead
Infosys Limited
08.2016 - 04.2017
- Interacting with Business Analysts for Business Requirements, testing scope reviews and test planning.
- Participated in review meetings for creating Test plan and test results summary.
- Effort Estimation for the project and preparation of the staffing plan.
- Test case review and Test scenario matrix review.
- Managed defect review meeting for all cross workstream applications thereby ensuring timely closure of the defects.
- Tested source data for data completeness, data correctness and data integrity.
- Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
- Developed test reports and participated in testing prioritization and archived test results and user signoff.
- Coordination with the Offshore Team.
- Created Test metrics using Dashboard module in ALM and participated in status meetings and reported the progress in the form of daily Testing status report to the project team.
- Project Name: CIS-Master Data Management (MDM) Upgrade
- Project Overview: The project will support the up-to-date technology for Enterprise Client Master Data Management. The implementation of MDM version 11.4 to the core Customer Information System will provide unified security, enhanced deployment capabilities, and supporting a Wholesale 360 view of a client. Potential benefits from the Probabilistic Matching Engine (PME) match / merge strategies.
- Testing: Master Data Management Testing
- Software/Tools Used: HP ALM, TOAD Data Point, IBM DB2, Putty
Technical Test Lead
Infosys Limited
06.2015 - 07.2016
- Requirement Analysis, Feasibility Analysis, Effort Estimation, Reports generation in ALM, Coordination with Offshore team
- Project Name: BASEL III Hybrid Solution
- Project Overview: The Hybrid Solution will provide a solution based on an upgraded Reveleus/OFSAA platform which will enable the client to be compliant with Basel III and will need to accurately report under Basel III with Federal Reserve Board reports.. It will maximize data alignment of RWA reporting between Regulatory Reporting , reporting teams, centralize calculation through common data foundation, transparent and auditable solution, and store the results across the unified platform, OFSAA/Reveleus and RID.
- Testing: ETL/Data Warehouse Testing
- Software/Tools Used: HP ALM, TOAD Data Point, Oracle SQL Developer, Putty
Test Analyst
Infosys Limited
06.2014 - 09.2015
- Requirement Analysis, Feasibility Analysis, Effort Estimation, Query preparation and execution, Reports generation in ALM, Coordination with Offshore team
- Project Name: Instrument and Organizational Profitability
- Project Overview: Instrument & Organizational Profitability project is planned to implement a new Cost Rate and Cost Allocation solution and retire current IPPMS system and replace it with the new EFI system based on Oracle's OFSAA solution. EFI will become the new platform for Cost allocation, FTP and Profitability measurement among other financial calculations.
- Testing: ETL/Data Warehouse Testing
- Software/Tools Used: HP ALM, TOAD Data Point, Oracle SQL Developer, Putty
Test Analyst
Infosys Limited
09.2013 - 06.2014
- Requirement Analysis, Feasibility Analysis, Effort Estimation, Query preparation and execution, Reports generation in ALM, Coordination with Offshore team
- Project Name: Key Performance Indicator
- Project Overview: Build dashboard for Wholesale Banking LOB to monitor KPI/KRI associated with lending process.
- Testing: ETL/Data Warehouse Testing, QlikView Reports testing
- Software/Tools Used: HP ALM, TOAD Data Point, Oracle SQL Developer, Putty
Test Analyst
Infosys Limited
05.2013 - 05.2014
- Requirement Analysis, Feasibility Analysis, Effort Estimation, Query preparation and execution, Driving Defect Triaging meetings, Reports generation in ALM, Coordination with Offshore team
- Project Name: BankTrade Replacement
- Project Overview: The main objective of this project is to replace the current ClientTrade and BankTrade applications with a more user-friendly and competent system for the benefit of the end-users in the Commercial Lending Group. BankTrade is the existing back-office processing and accounting system that supports standby letters of credit, trade letters of credit and documentary collections. It is classified as a Key Financial Application (KFA) and is the system of record for all letters of credit and documentary collections.
- Testing: ETL/Data Warehouse Testing
- Software/Tools Used: HP ALM, TOAD Data Point
Test Analyst
Infosys Limited
11.2011 - 05.2013
- Requirement Analysis, Feasibility Analysis, Effort Estimation, Query preparation, Data conditioning and Test data procurement
- Project Name: Test Data Management
- Project Overview: A core test data management team to understand the requirements provided by various functional teams, write optimized queries and provide the test data. TOAD for Data Analysts tool was used to connect DB2 databases which consisted of highly normalized tables
- Testing: Test Data Management
- Software/Tools Used: HP ALM, TOAD Data Point
Test Engineer
Infosys Limited
11.2009 - 12.2011
- Requirement Analysis, Test Estimation, Meetings with Client, Onsite Team and Development Team, Test Execution and Defect Reporting
- Project Name: Default Evolution Conversion
- Project Overview: Clarifire is an application provided by EMason (third party vendor) that automate the SunTrust’s Default Management workflow.
- Testing: Manual Testing
- Software/Tools Used: HP ALM, TOAD Data Point
Education
Bachelor Of Engineering - undefined
Atria Institute of Technology
Karnataka, INDIA01.2008
Skills
Proficient in ETL/Data warehouse testing, Data Migration Testing, Master Data Management Testing, Migration Testing, Front end (Functional & GUI Testing), Risk Based Testing and User Acceptance Testing (UAT)
Good hands-on experience on various tools like SQL 2007, SQL 2008, IBM DB2 Control Centre, IBM Data studio, TOAD data point, UNIX Putty, Oracle SQL Developer and SOAP UI
Good experience of IBM Master data Management (MDM) products used in banking industry
Experience in Python scripting
Experience in Test Management tools such as JIRA, HP Quality Centre (Test Design, Test Execution, and Defect Tracking), Quick Test Pro (Test Automation) and Version One
Well versed in Test Data Creation and Management
Certified in DEVOPS PROFESSIONAL, SCRUM MASTER and Software Development Engineer in Test (SDET)
AWS CERTIFIED CLOUD PRACTITIONER
RDBMS: Oracle, SQL Server, IBM DB2
Framework/APIs: REST, SOAP
Scripting: Python, PowerShell, UNIX Putty, VB Script
SQL Development Tool: IBM DB2 Control Centre, IBM Data studio, TOAD data point, SSIS, Oracle SQL Developer, HIVE, Impala
Product experience: IBM Infosphere MDM server 114
Quality Management Tool: JIRA, HP ALM, Version One
Accomplishments
- Most Valuable Player Award at DC level in Infosys Dec’12.
- Insta award at unit level in Mar’20.
- Additional role of Unit Anchor for providing Proposals, POCs/demo to various Banking clients on Testing tools and solutions developed at Infosys.
Timeline
Technology Architect
Infosys Ltd.
10.2023 - Current
Project Manager
Infosys Limited
01.2022 - 10.2023
Technical Test Lead
Infosys Limited
04.2019 - 12.2021
Consultant - US
Infosys Limited
04.2017 - 03.2019
Technical Test Lead
Infosys Limited
08.2016 - 04.2017
Technical Test Lead
Infosys Limited
06.2015 - 07.2016
Test Analyst
Infosys Limited
06.2014 - 09.2015
Test Analyst
Infosys Limited
09.2013 - 06.2014
Test Analyst
Infosys Limited
05.2013 - 05.2014
Test Analyst
Infosys Limited
11.2011 - 05.2013
Test Engineer
Infosys Limited
11.2009 - 12.2011
Bachelor Of Engineering - undefined
Atria Institute of Technology