Ramanathan Kalitheerthan
Arlington
Summary
Product Analyst with significant experience at Prime Therapeutics, focusing on requirements analysis, data analysis, and user acceptance testing (UAT). Expertise in SQL and Agile methodologies, contributing to the development of a test automation framework that enhanced delivery quality and efficiency. Strong stakeholder management skills facilitate alignment with strategic business objectives and drive measurable results.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Product Analyst
Prime Therapuetics
05.2025 - Current
- Served as Business Analyst for a Medical Pharmacy Pre-Authorization application, driving requirement analysis, integration impact studies, and JIRA story development.
- Supported UAT and production issue resolution through SQL -based data validation and collaborated on automation framework setup using BDD and modern tools to streamline testing and improve delivery quality.
- Demonstrated adaptability by managing urgent requests during client implementation and delivering on time.
- Translated complex business requirements into well-defined JIRA stories and acceptance criteria, ensuring clarity and actionable deliveries for development team.
- Led comprehensive analysis activities, dependency evaluation, requirement clarification, research story exploration, and production issue root cause analysis to support informed decision-making.
- Executed rigorous data validation and functional verification across multiple phases, including UAT, ensuring conformance to business requirements.
- Managed test data creation and maintenance to enable accurate and repeatable testing outcomes.
- Collaborated with Product Owner, Scrum Master, and development teams to prioritize backlog, resolve impediments, and maintain alignment with strategic business objectives.
- Contributed to establishing a test automation framework leveraging BDD principles with Spring Framework, TestNG, Selenium Webdriver, Allure Reports, and Log4J, integrated via GitHub Copilot to enhance team efficiency and quality assurance processes.
- Successfully led analysis, prioritization, and testing of multiple last-minute change requests during a new client implementation, ensuring timely delivery without compromising quality.
- Environment: SSMS/AWS/REST API/ASP.NET/VB.NET/MySQL/ECS/S3/JIRA/Zephyr
Business Analyst
Toyota Motor North America
Plano
01.2024 - 03.2025
- ITT - Integration Test Trial: ITT is cross-functional test across multiple systems which certifies business process flow with live data in the production. This indicates system readiness for a new plant start up and a prerequisite for Advance Mass Production.
- Coordinating between multiple NA and Japan systems to execute complex ITT in two phases, ensuring seamless integration validation.
- Ensuring timeline setup and input interfaces are received in the Japan system as per schedule, and order calculation is executed accurately.
- Verifying outbound data from order calculation at TMNA systems, reporting and resolving issues promptly.
- Confirming orders sent to suppliers, ensuring SAP received the EDI as required. Integrating necessary data from upstreams and providing manufacturing operations with integrated data.
- Actively identifying issues, performing root cause analysis (RCA), incident management, resolving critical incidents, executing hot fixes, documenting processes, and proactively maintaining preventive actions.
- Facilitating meetings between multiple systems across the globe with 50+ attendees, ensuring clear status reporting, process improvement, and project management.
- Managed the PIE to Manufacturing Operations Management component, integrating Orders, Logistics, and Suppliers data to MOM.
- Conducted requirement elicitation and facilitated communication between users, business, and technical teams. Handled JIRA story management, feature demonstrations, and coordinated code deployment in production according to requirements.
- Acted as the Production Point of Contact for Parts Ordering System at Battery Plant, responsible for issue resolution, data analysis, and maintaining system stability.
- Utilized SQL queries in PostgreSQL and serverless technologies (Lambda, ECS) for effective issue resolution using data-driven problem-solving methods.
- Managed integration tasks between upstream and downstream applications, using data transfer methods such as APIs, Kafka, and Qlik.
- Environment: AWS/PostgreSQL/Lambda/ECS/Visual Studio/Kafka/Postman/Qlik/SFG/Lucid/Excel/GITHub/Agile/JIRA/Confluence/Lucid/Sail Point
Business Analyst QA
Bank of America
Plano
12.2022 - 12.2023
- The objective of this project is to establish a centralized system to produce NFRR in an automated manner, take it through various stages to analyze, validate, rectify, approve and submit the reports to regulatory agencies across the globe.
- Ensured report accuracy and quality by analyzing requirements, validating data sourcing, transformations, controls, and executing comprehensive testing throughout the report lifecycle.
- Led testing efforts, including creating and executing test plans, scenarios, and cases; conducting stakeholder walkthroughs; and incorporating business perspectives.
- Tested GRRS portal functionalities (report production, configuration, adjustments, workflow), collaborating with development teams to resolve report generation and workflow issues, while considering user needs and business processes.
- Performed data validation using SQL queries in Apache Zeppelin, aligning with business data requirements.
- POC for MiFID reports, including business analysis, test planning, execution, UAT, parallel support, and risk analysis, focusing on delivering reports that meet business objectives.
- Conducted UAT sessions with report users, gathering feedback and ensuring alignment with business requirements.
- Utilized qTest for test management (plan/case uploads, requirement mapping, test suite creation, and bug linking), maintaining traceability to business requirements.
- Reported daily and weekly testing status to stakeholders, including updates on business requirements coverage.
- Managed defect resolution, including walkthroughs with development teams, prioritizing issues based on business impact.
- Coordinated offshore testing team and workload, ensuring alignment with project goals and business priorities.
- Provided daily testing status reports to clients, including key metrics related to business requirements validation.
- Environment: Selenium/Apache Zeppelin/Mongo DB/Informatica/JIRA/Eclipse/qTest/MicroStrategy/PEGA/Apache Ni-Fi/Kafka/Agile
Quality Analyst DWH
Rabobank
Utrecht
04.2019 - 05.2021
- The work at Rabobank involves working on a SQL Server Credit Risk database. Datawarehouse is realized in DATAVAULT model. Data from branches/entities around the world and source systems, onboarded into staging and validated functionally and technically.
- Data is then loaded into the RawVault and BusinessVault. Testing is carried out using SpecFlow in an agile environment with 2 weeks sprints and Monthly releases.
- When the Team lost two experienced testers at the same time, I stepped into the role of Sole Tester handling multiple responsibilities in the team and received appreciation from the client for successfully managing the challenge for 5 months.
- Conducted functional and integration testing of new stories using SpecFlow, including business rule, validation, error handling, and new interface testing, validating new reports, and performing UAT integration testing with production-like data.
- Employed a Test-Driven Development (TDD) and Acceptance Testing approach to software delivery.
- Developed test plans and strategies aligned with the iteration model.
- Derived test scenarios based on requirements.
- Debugged C# glue code and modified/created basic C# glue code on the .Net automation framework.
- Utilized Azure DevOps (formerly TFS) to create tasks/product backlog items.
- Demoed software to product owners and business analysts for acceptance after 2-week sprints.
- Provided insights to developers on issue resolution.
- Maintained and updated regression tests and monitored daily green builds.
- Managed releases, including creating builds, deploying to servers, and establishing deployment pipelines.
- Collaborated with release management to prepare UAT environments with expected data slices.
- Served as the UAT anchor for the team, managing UAT testing, conducting bi-weekly UAT meetings, performing end-to-end chain tests, demoing to business users for approval, and managing the bug process.
- Established strong relationships with business users as a UAT anchor, bridging communication between business and development teams.
- Served as a Technical Business Analyst for deliveries to two downstream teams.
- Actively participated in stand-ups, retrospectives, and refinement meetings.
- Collaborated closely with business analysts and developers throughout the software development lifecycle.
- Utrecht
- Environment: SpecFlow/Visual Studio/TFS-AZURE DevOps/ Agile/ DataVault/GIT/PowerDesigner/SSIS/SSRS/TDD/BDD/SQL Server/Visio
Datawarehouse Test Analyst
Rabobank
Sydney
09.2018 - 02.2019
- Future tech – Transitioning to a new internet banking platform from the legacy platform to improve the customer experience by creating fast, simple banking with all customer accounts and details on one page thus reducing the operating costs and infrastructure charges.
- The ROD Project (abbreviated as Report, Outbound Interface and Data) is one of the streams of the data services area of FutureTech Program. The project ensures the smooth transition of banking system (along with the associated reporting mechanism) from Thaler to T24 & MDM.
- Coordinating with 2 members offshore team from Sydney office in the AGILE environment was the challenging task I handled in this project.
- Test Coordination
- Onsite-Offshore Coordination
- Functional Testing/Shadow Testing/Regression Testing: - Environment setup including configuration/data setup/connection to external systems
- Validate all new reports created in OBIEE
- Validate all Interfaces inbound/outbound
- Liaise with external suppliers
- Support UAT/End to End Testing
- Validate functionality against requirements
- Work closely with end users
- Produce Test Plans/Test Scripts/Test Steps using HP ALM
- Perform Regression Testing
- Attend daily defect meetings
- Work closely with Business Analysts/Developers
- Developed and maintained test strategy document.
- Raise/Progress Defects using JIRA
- Report generation using OBIEE as per the requirement.
- Sydney
- Environment: SQL Server/Informatica/Agile/OBIEE suit/MS ACCESS/ Excel/ JIRA/ qTest
Test Analyst-ETL testing
RBS
Chennai
07.2016 - 07.2018
- CRS is a compliance act which is effective from January 2016. CRS was signed as a multilateral agreement between 51 countries, including UK. The application is an enhanced version of FATCA program and to test the system will meet the requirements for the Operational Tax Program (OTP) which incorporates a shared solution for FATCA and CRS.
- Involved in Requirement analysis and Test Design
- Functional Testing/Integration Testing/Regression Testing: - Creating test plans for CR
- Writing test scenarios and test cases based on FSD.
- Involved in Test data preparation in Teradata for executing the test cases.
- All the Data base validations are done using Teradata application Support UAT/End to End Testing
- Validate new functionality against requirements
- Work closely with end users
- Perform Regression Testing
- Validate ETL process from output files to DWH including mapping/transformation logic
- Interrogate database using SQL to assist in verification of test results
- Adopted Agile methodology from waterfall model
- Work closely with Business Analysts/Developers in a Scrum/Agile environment
- Collaborate with Project Managers, Business User, and Developers to coordinate project schedules and timelines.
- Raise/Progress Defects using Jira
- Writing and Running wrapper scripts in UNIX and monitoring in Informatica.
- Involved in test data mining to extract the data for test set.
- Manual Execution of Test Scripts.
- Chennai, India
- Environment: Mainframe/ Unix /Informatica / Teradata HP ALM/ SQL/ Agile/Jira
Senior Test engineer
RBS
Chennai
02.2014 - 06.2016
- Rainbow is the migration project which involves ETL migration from a RBS bank to newly created W&G bank. Both the source and target servers are mainframes hence REXX coding is used to verify and validate the transformation and migration of data between the banks.
- Understanding the Client Requirements and Functionalities.
- Prepare Test plan, Test scenarios and Test cases as per Requirement document.
- Designing Test Query for ETL Testing.
- Raise/Progress Defects using HP Quality Centre.
- Identify, research, report, track and verify software defects proactively and comprehensively.
- Defect anchor –Sanity testing, Defect analysis and documentation, bridging testers and developers, Priority handling of Defects based on ETA.
- Produce Test Scripts/Test Steps.
- Manual Execution of Test Scripts.
- Involvement in Test Reporting on daily, weekly basis through company prescribed format.
- Chennai, India
- Environment: Mainframe / SQL /HP Quality Centre/Waterfall
ETL Test engineer
VISA
Chennai
03.2012 - 01.2014
- Visa is an American multinational financial service. VISA VELT project’s main objective was to replace various legacy systems by a reporting tool which had OBIEE as the front end and oracle 11g as the back end.
- VISA VELT project had different sources like flat files and database from which data are directly mapped to staging area and from staging area ETL is performed and data is loaded into the data mart.
- Reports will fetch the data from the data mart. Our testing scope was from staging to data mart and reports testing.
- Validate the data and scheme from the Staging area to final Reporting area.
- Build SQL queries to validate the business transformation logics.
- Preparing and executing test cases.
- Chennai, India
- Environment: OBIEE / Oracle 11g / SQL
System engineer
Morgan Stanley Smith Barney
Chennai
07.2010 - 02.2012
- To automate the workflow of Financial Advisors at the branch level from the inception of creating a Joint Production Agreement form to all types of Team forms and Team Applications which includes sending system generated approvals and alerts to Branch and Regional Management Teams.
- Maintenance of backend functionality by creating SQL queries.
- Handling of various failures or interruptions affecting business functionality.
- Unit Testing and Defect Fixing.
- Preparing and executing test cases.
- Managing front end modifications and enhancements based on client requirements.
- Chennai, India
- Environment: Flex/ Java/ DB2
Education
Bachelor of Engineering -
Anna University
Chennai01.2009
Skills
- Requirements analysis and gap analysis
- Process mapping and integration analysis
- Stakeholder management
- Customer relationship management
- User acceptance testing (UAT)
- Agile methodologies
- Business intelligence tools (OBIEE, Power BI, Tableau)
- ETL testing and data validation
- Data warehouse concepts
- SQL and database management (PostgreSQL, SQL Server, Teradata, Oracle, DB2)
- Source-to-target mapping
- Reporting and documentation (BRDs, SRSs, functional specifications)
- Technical specifications and data dictionary
- User manuals and MS Office suite proficiency
- Collaboration tools (Confluence, Lucid, MS Visio)
- API development and data integration
- Message queues and IPaaS solutions
- Defect management with JIRA and Azure DevOps
Certification
AI Strategy, Cornell University, https://mycredentials.ecornell.cornell.edu/credential/TUoYVQgxMP
Training
Generic and Java (Stream), Infosys Mysore, 12/01/09, 06/30/10
Domain Knowledge
Credit and Liquidity risk data, Wholesale, Rural and retail Banking, IFRS 9 provision reports, COREP, AnaCredit, CRS, FATCA, GDPR, Order Calculation, Forecast on Demand, JIT, Logistics management, Parts integration engine, Manufacturing operations, Not Provided
Timeline
Product Analyst
Prime Therapuetics
05.2025 - Current
Business Analyst
Toyota Motor North America
01.2024 - 03.2025
Business Analyst QA
Bank of America
12.2022 - 12.2023
Quality Analyst DWH
Rabobank
04.2019 - 05.2021
Datawarehouse Test Analyst
Rabobank
09.2018 - 02.2019
Test Analyst-ETL testing
RBS
07.2016 - 07.2018
Senior Test engineer
RBS
02.2014 - 06.2016
ETL Test engineer
VISA
03.2012 - 01.2014
System engineer
Morgan Stanley Smith Barney
07.2010 - 02.2012
Bachelor of Engineering -
Anna University