Mohan Prakash Rangaraj

Mohan Prakash Rangaraj Email and Phone Number

QA Manager, AI and Analytics @ Cognizant Technology Solutions
Fort Mill, SC, US
Mohan Prakash Rangaraj's Location
Fort Mill, South Carolina, United States, United States
Mohan Prakash Rangaraj's Contact Details

Mohan Prakash Rangaraj personal email

Mohan Prakash Rangaraj phone numbers

About Mohan Prakash Rangaraj

Quality Assurance Professional with 17+ years of progressive experience in Big Data, Data Warehouse ETL and Report Testing with a wide variety of projects and technology stacks in Banking & Financial, Healthcare, Retail, Insurance, Life Sciences, Consumer Goods • Proficient skill level in SQL• Familiarity in testing various databases – Oracle, SQL Server and Teradata• Worked on Hadoop components like HDFS, Hive, Sqoop and Impala• Responsible for Data Validation of ingested data in landing, staging and Data Lake in System Integration Test environment (SIT) as per the transformation rules for Hadoop based systems• Excellent testing experience in all phases and stages of software Testing life cycle (STLC) and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies• Worked extensively with all phases of testing deliverables including creation of Test Strategy, Test Plan, RTM, Test Scenarios, Test Cases, Defect management in ALM & qTest, test results documenting and reporting• Hands-on data setup, Sanity, Functional, UI, E2E Regression testing, data reconciliations, automation, test execution and defect management tools like HP ALM, qTest & JIRA • Proficient in scrum and waterfall methodologies• Collaborate with business stakeholders on providing walkthrough for various business scenarios and reconciliation metrics to meet user acceptance criteria• Handle SIT closure activities like release sign-off documents, test coverage matrix and providing approvals for production migration.• Good interpersonal skill with the ability to work as a team and independently, quickly learn new technologies and always willing to take up additional responsibilities.

Mohan Prakash Rangaraj's Current Company Details
Cognizant Technology Solutions

Cognizant Technology Solutions

View
QA Manager, AI and Analytics
Fort Mill, SC, US
Mohan Prakash Rangaraj Work Experience Details
  • Cognizant Technology Solutions
    Qa Manager, Ai And Analytics
    Cognizant Technology Solutions
    Fort Mill, Sc, Us
  • Lpl Financial
    Senior Quality Assurance Lead
    Lpl Financial Jun 2020 - Present
    San Diego, Ca, Us
    • Managed and successfully delivered several projects running in parallel across multiple scrum teams • Effectively took over a sinking project and was able to deliver it successfully on time – that avoided hefty FINRA fines.• Mentor the team members on the business and use cases associated to the projects by aligning with the product owners, business analysts and business partners• Participated in daily scrum, planning, and retrospective meetings• Closely worked with business to understand the features and design the test approach• Managed QA team of 6+ members for manual & automation projects under Supervision and Surveillance products• Optimized the existing regression test suit – reduced the run time by 30% and increased the efficiency of test automation• Coordinate with the offshore team in the creation of test cases, test scripts, API automation use cases and conduct review in qTest• Test Data setup that satisfies the functionalities for that Sprint/Release• Collaborate with the upstream/downstream data & application owners• Test the web application - UI, APIs, Mule scheduler and scenarios associated with the Stories in scope• Conduct defect triage meetings with the project development team for a resolution• Prepare for re-test and final build certification• UAT Support - Coordinate with the business users for UAT testing• Provide product Demo to the business stakeholders • Test automation implementation using an internal Automation Framework• Provide QA test artifacts and prepare for QA sign-off• Coordinate with the UAT partners to ensure all the stories meet the expected acceptance criteria• Production deployment support and post-production validation.
  • Cognizant Technology Solutions
    Qa Manager, Ai & Analytics
    Cognizant Technology Solutions Nov 2013 - Present
    Teaneck, New Jersey, Us
  • Emblemhealth
    Quality Assurance Lead Consultant
    Emblemhealth Aug 2018 - Jun 2020
    New York, Ny, Us
    Technology Stack: Coludera, Hadoop, HIVE, Shell Scripting, Spark, Cognos, Tableau, SQL server, OGG, Elasticsearch, Kibana, Informatica BDMResponsibilities:• A multiphase Big data project with phase 1 on understanding the business requirements, perform gap analysis, meet with different stake holders to understand their expectation, prioritization and business criticality of the deliverables• Extensively involved in development of project estimations, forecasting, Test Plan and Test Strategies• Understanding the data models, mapping documents and mentored the test analysts to come up with a testing strategy and test plan document• Developed Test Strategy and approach and reviewed with the stakeholders to get it approved• Work with the Business Analysts and Data Modeler to get the clarification addressed• Prepare Test Scenarios, test cases and uploaded them to Application Lifecycle Management (ALM) tool for tracking the System Integration Test (SIT) progress• Collaborate with source teams & development Leads to make sure the appropriate data is available and loaded to the Enterprise Data Lake• Source data from HDFS files were validated by using Scoop scripts to load into Hive tables and compared against the Landing tables• Data Quality Rules applied were validated and verified on the tables• Create scripts to perform validations related to data replication, data integrity and raw data validation between Clinical Management system & Enterprise Data Lake• Execute the Test Cases and tracking the SIT progress on a daily basis• Conduct defect triage meeting with development team and set the ETA’s for the fix• Send a detailed SIT status update to the Program Team and all stakeholders• Provide a sign-off based on the release scope for production deployments• Walkthrough with business stakeholders on the various business scenarios and reconciliation metrics in the pre-production environment
  • Sanofi Genzyme
    Lead Quality Assurance Analyst Consultant
    Sanofi Genzyme Aug 2016 - Mar 2017
    Paris, France, Fr
    Technology Stack: Informatica , HP ALM 11.00, Oracle 11g, Qlikview 11.2.0 SR15Responsibilities:• Understand the business and technical requirement documents and guide the offshore team on any clarification • Understand the data models, mapping documents for guiding the test analysts to come up with a testing strategy and test plan document• Coordinate with sanofi subject matter experts, business analysts, business users for any clarification on business requirements • Review the created test plans, test strategy documents and get it approved from the stakeholders • Coordinate with the offshore team in the creation of test cases, test scripts, review and upload them to application life-cycle management tool before the System Integration Testing schedule• Provide guidance to test analysts for building etl/report knowledge, implement cognizant's proprietary testing tools such as texecutor, platinum suite of automation testing tools as a value add during the System Integration Testing process • Coordinate with the development team to make sure the test environment is ready for testing and the code has been migrated • Update project team with the daily and weekly status on the test execution progress • Conduct defect triage meetings with the project development teams and client manager provide the test execution metrics to the project manager for consolidation and analysis • Provide QA signoff for the production deployment prior and post production deployments. • UAT Support - Coordinate with the business users for UAT testing – help in uploading the UAT cases to ALM before UAT schedule• Track and report the UAT defects, collaborate with the Users and Development teams for issue fixes and defect closure• Request for UAT sign-off based on the users acceptance criteria met • Provide the lessons learnt document to the project manager for best practices documentation• Coordinate with the project manager on the project closure documentation
  • The Estée Lauder Companies Inc.
    Cognizant - Program Manager
    The Estée Lauder Companies Inc. Jan 2016 - Jul 2016
    New York, Ny, Us
    Technology Stack: SAP, HP ALM 12.01, SQL Server, Oracle, HyperionResponsibilities:• Plan on migration cutover activities by working with tower leads and ELC stakeholders for in scope applications• Review the migration cutover plan with infra support teams based on the Non Prod and Prod move groups and align my team according to the schedule• Coordinate with my Belgium counterpart on the schedule and plan to make sure the offshore teams – remediation, testing and performance monitoring teams are available• Conduct daily internal review meetings with the offshore team to ensure on the right application access permissions, test strategy, plan and test cases for each application is identified• Oversee the team’s meetings with application owners to make sure the test coverage of their applications is sufficient and sign-off on the cases• Collaborate with Test Management Office, ELC leadership, database and infra support team to update the program status• Review, rationalize and coordinate with cross functional tower leads and stakeholders on consideration for impacts on existing systems planned development/enhancement activities due to current DC migration activity• Work with other vendor Project Managers to ensure that risks and issues are assessed and managed; resources conflicts are identified and resolved• Work with the internal test manager to make sure the testing efforts are on track for the in-scope applications for the ongoing move group and ensure that there are no road blocks• Ensures all the defects are tracked and escalated to the right vendor/support teams to get it addressed immediately without any delays within the hyper-care window • Assures high quality and timely delivery of application testing results, and deliverables, including participating in reviews, triage and retrospect meetings• Provide sign-offs by reviewing the generated summary reports and publishes it to the Test Management Office(TMO), ELC stakeholders and vendors
  • Warner Bros. Entertainment Group Of Companies
    Cognizant - Qa Program Manager
    Warner Bros. Entertainment Group Of Companies Jul 2015 - Nov 2015
    Burbank, Ca, Us
    Technology Stack: Workday, HP ALM 12.01, Informatica 9.5.1, SQL Server, SAP ECCResponsibilities:• Review the payroll test strategy and make sure scope, purpose and objectives are met during the testing schedule.• Review the HPQC test sets and verify all the scenarios are covered for the current SIT cycle.• Conduct meetings with the project team, SMEs and developers to make sure all are on the same page on the scope of current testing cycle.• Send and follow-up on the action items from the meeting.• At the end of every integration, make sure the comparisons are being done right and the differences are justified and agreed upon by the technical and business POC.• Monitor the test execution in HPQC and regularly keep track the test execution and defect resolution progress.• Conduct the defect triage meetings to make sure the defect resolutions are agreed upon.• Generate test reports for the PMO and stakeholders which clearly communicates test results, concerns and current project status.• Support Integration Managers to identify project risks and develop mitigation strategies.• Point of contact for Integration Managers for all testing status needs.• Proactively follow-up with Integration Managers, SMEs, business owners to identify the root cause of the issues/defects and try to resolve immediately.• Follow-up with the integration managers to make sure they are getting sign-offs from the business on time.• Ensure all the required processes are being followed across the teams throughout the testing cycle.
  • The Walt Disney Company
    Cognizant Qa Consultant
    The Walt Disney Company Apr 2015 - Jun 2015
    Burbank, Ca, Us
    Technology Stack: Informatica 9.6.1, Informatica DVO, Greenplum 4.2.8.2, Unix, Linux, ALM 12.01, Jira 6.4.3Responsibilities:• Review the High Level Design Document (HLD) for the Jira and prepared a high level test plan.• Conduct a test plan review session with the project team, business analyst and ETL lead and get it approved.• Design End to End data verification and validation strategy and prepare/review test cases based on the strategy.• Test data (files) setup to facilitate the testing plan.• Track the daily test execution progress in ALM and keep the team updated.• Prepare and communicate test progress and status reports to the project management office.• Preparation/ Review of summarized Test Execution reports, test Status Reports, Defect summary reports and Test completion reports• Verification and validation from source files to Data warehouse by running the maestro schedule.• Perform a round of regression testing.• Conduct/attend the regular core team meetings, weekly status meetings, client meetings, and defects triage meetings.• Update the ALM and Jira by providing appropriate comments.• Provide QA signoff for the production deployment prior and post production deployments.• Participate in Go-No Go meetings with the leadership, stake holders and business sponsors.• Perform high-level post-production validation.
  • Charming Charlie
    It Qa Consultant
    Charming Charlie Nov 2014 - Feb 2015
    Houston, Texas, Us
    Technology Stack: SQL Server 2012 , SSIS, SpiraTestResponsibilities:• Review the Business Requirement Specification document, high level deisgn document• Prepare the master test plan, requirement traceability matrix (RTM), test strategy and review the different scenarios to be tested and documented• Review the Master Test Plan with the stakeholders and get it approved• End to End data verification and validation strategy from RMS Source to Data warehouse (ODS)• Prepare the test scripts and upload to Spira, a test management tool• Execute test scripts to check the data flow from RMS Source tables to ODS Data Warehouse• Run the SSIS Packages and monitor the progress, report for errors if any• Validate the ODS data against the RMS source tables• Preparation Review of summarized Test Execution reports, test Status Reports, Defect summary reports and Test completion reports• Point of contact for escalations and coordination with the Development team, project manager and QA team• Work with the project manager to keep them updated about the project status and the delivery schedules• Conduct and participate in defect triage meetings• UAT support• Provide QA signoff for the production deployment prior and post production deployments.
  • Belk
    Sr. Qa Lead
    Belk Jul 2012 - Oct 2014
    Charlotte, North Carolina, Us
    Technology Stack: Oracle Hyperion essbase, MicroStrategy, BI publisher, Teradata, SQL Server, Unix, HP Quality Center, Leankit – Kanban, TableauResponsibilities:• Review Business Requirements Document (BRD), Detail Design Document (DDD) and prepared a High level test plan.• Prepare master test plan, requirement traceability matrix (RTM), test strategy and review the different scenarios to be tested and documented.• Prepare the test cases and get it approved.• Design End to End data verification and validation strategy from Source to Data warehouse and the BI Reports.• Test data preparation and planning to facilitate the testing of MicroStrategy, BI Publisher reports in line with the source and Data warehouse data.• Track the daily test execution progress in Quality Center and keep the team updated.• Transition and implementation of Agile process model across the projects. Participate in the daily standup’s for critical projects as, and when required.• Prepare and communicate test progress and status reports to the project management office.• Preparation/ Review of summarized Test Execution reports, test Status Reports, Defect summary reports and Test completion reports• Review and design the Testing process for the Data management Organization for End to End project flow.• Verification and validation from source to Data warehouse to the MicroStrategy, BI Publisher Reports, UI and data validation test scenarios.• Regression testing with the use of excel’s macros.• Attended the regular core team meetings, weekly status meetings, client meetings, and defects review meetings.• Provide QA signoff for the production deployment prior and post production deployments.• Participate in Go-No Go meetings with the leadership, stake holders and business sponsors.
  • Amd
    Bus. Intelligence Qa Lead
    Amd Apr 2011 - Jul 2012
    Santa Clara, California, Us
    Environment & Tools: Informatica, SAP, SSRS, Tableau 7.0, ALM 11Responsibilities:• Prepare a high level test plan by reviewing the business requirements document (BRD) • Submission of estimated level of efforts to the client on various functional modules like system integration, regression and reporting components for ETL and cube.• Represent the QA team at the Project Initiation phase to give inputs from test strategy point of view.• Prepare the test strategy, test scenarios and corresponding test cases documented.• Prepare, review the test cases and upload to ALM and maintain requirements traceability.• Responsible for the deliverable of testing team across the projects in Integrated Data Management team. • Preparation/ Review of summarized Test Execution reports, test Status Reports, Defect summary reports and Test completion reports• Point of contact for escalations and coordination with the Development team, project manager and QA team. • Work with the project manager to keep them updated about the project status and the delivery schedules.• Review Defect logs created and co-ordinate with Development team in fixing the defects. Conduct Regression testing on the fixed defects and also to validate the related functionalities.• Attended the Regular Core Team Meetings, Weekly Status Meetings, Client Meetings, and Defects Review Meetings • QA Signoff Responsibility for the Production deployment prior and post production deployments.
  • Loblaw Companies Limited
    Offshore Test Lead
    Loblaw Companies Limited Mar 2010 - Jan 2011
    Brampton, Ontario, Ca
    Technology Stack: Teradata, MicroStrategy, HP Quality CenterResponsibilities:• Test Management, Preparation of Estimation, Test Plans, Approach and Test Strategies for ETL and BI projects• End to End data verification and validation from Source to Data warehouse and the MicroStrategy Reports• Prepare the test strategy, test scenarios and test approach documents and review with the onsite lead.• Prepare the test scripts and send it to onsite lead for their review and approval.• Execute test scripts to check the data flow from Source tables to Data Warehouse and Data Marts. Validate the data flow from source to target tables and the MicroStrategy reports. • Conduct a manual MicroStrategy report performance testing and user profile testing.• Responsible for all the deliverables from offshore.• Raise and assign defects to the development team and follow up to get the defects retested.• Participate in defect triage meetings.• Coordinate with onsite counterpart in updating the daily status and project progress, issues and risks associated with the project.• Co-ordination with onsite leads for successful execution of projects. • Attended the Regular Core Team Meetings, Weekly Status Meetings, and Defects Review Meetings
  • Travelers Insurance
    Bi Cognos Developer
    Travelers Insurance Mar 2009 - Nov 2009
    New York, Ny, Us
    Technology Stack: Teradata, Cognos, SQL Server, Quality CenterResponsibilities:• Review and analyze the business requirements documents (BRD) and come up with a design document.• Once the design is approved, start with the report development.• Prepare and execute the unit test cases to validate the report.• Run the report manually and verify the report performance for SLAs.• Coordinate with the onsite lead for status updates and development progress.• Work with the QA team to address the defects.• Attend the defect triage meeting conducted by the QA team and provide resolutions and fix the defect.
  • Netapp
    Bi Data Analyst
    Netapp Jun 2005 - Feb 2009
    San Jose, California, Us
    Technology Stack: DataStage , Cognos, Oracle 9i, Quality CenterResponsibilities:• Write the SQL queries on data staging tables and data warehouse tables to validate the data results. Retrieve information from different tables in database to check the database on a regular basis using SQL queries.• Validated the data flow from source to target tables by verifying the mappings in ETL jobs.• Execute test scripts to check the data flow from Source tables to Data Warehouse and Data Marts. Validate the data flow from source to target tables by verifying the Sequences and Jobs in Data Stage. • Defect logs created and co-ordinate with development team in fixing the defects. Conduct regression testing on the fixed defects and also to validate the related functionalities.• Prepare manual test scripts covering different scenarios and documented in HP Quality center.• Executed test scripts to check the data flow from Source tables to Data Warehouse and Data Marts.• Validated the data flow from source to target tables by verifying the mappings, transformations in Informatica Power center.• Executed test scripts to validate the Cognos reports generated through Oracle. • Defect logs were created in Quality Center and co-ordinate with Development team in fixing the defects. • Conducted Regression testing on the fixed defects and also to validate the related functionalities.
  • Wipro Technologies
    Project Intern
    Wipro Technologies Nov 2003 - Apr 2004
    Bangalore, Karnataka, In
    Developed an Intranet Knowledge Base regarding RFID Technology with its latest News, Articles, Events, Links and Downloads.

Mohan Prakash Rangaraj Skills

Teradata Technology Agile Testing Offshore Management Requirements Analysis Data Warehousing Test Planning Sdlc Etl Co Ordination Datastage Cognos Oracle 8i Program Manager Microsoft Sql Server Business Analysis Defect Tracking Integration Testing Agile Methodologies Quality Center Regression Testing Solutions Tableau Quality Assurance Hp Quality Center Oracle User Acceptance Testing Test Cases Testing Microstrategy Program Management Pl/sql Test Strategy Business Intelligence Sql Software Quality Assurance Requirements Gathering System Testing Software Development Life Cycle Alm Project Management Agile And Waterfall Methodologies Microstrategy Reporting Analytics Informatica Test Management Software Project Management Integration Manual Testing Databases

Mohan Prakash Rangaraj Education Details

  • Bharathiar University
    Bharathiar University
    Computer Technology
  • Coimbatore Institute Of Technology
    Coimbatore Institute Of Technology
    Computer Technology

Frequently Asked Questions about Mohan Prakash Rangaraj

What company does Mohan Prakash Rangaraj work for?

Mohan Prakash Rangaraj works for Cognizant Technology Solutions

What is Mohan Prakash Rangaraj's role at the current company?

Mohan Prakash Rangaraj's current role is QA Manager, AI and Analytics.

What is Mohan Prakash Rangaraj's email address?

Mohan Prakash Rangaraj's email address is mo****@****ant.com

What is Mohan Prakash Rangaraj's direct phone number?

Mohan Prakash Rangaraj's direct phone number is +151222*****

What schools did Mohan Prakash Rangaraj attend?

Mohan Prakash Rangaraj attended Bharathiar University, Coimbatore Institute Of Technology.

What skills is Mohan Prakash Rangaraj known for?

Mohan Prakash Rangaraj has skills like Teradata, Technology, Agile Testing, Offshore Management, Requirements Analysis, Data Warehousing, Test Planning, Sdlc, Etl, Co Ordination, Datastage, Cognos.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.