Sudhan Mohan
Sr. Quality Assurance Specialist
Tampa,FL
Summary
Over 15 years of successful experience in Data Warehouse testing, BI reports and UI application testing. Seasoned software quality assurance professional with test architect, design, planning and engineering management experience. Worked on multiple databases like Teradata, Oracle, SQL Server. Expertise in creation of test Strategy at project level and subsequent creation of test plan at module level.
Talented Manager with expert team leadership, planning and organizational skills built during successful career. Smoothly equip employees to independently handle daily functions and meet customer needs. Diligent trainer and mentor with exceptional management abilities and results-driven approach.
Healthcare clients : McKesson, Harvard Pilgrim HealthCare/Tufts Health Plan (Point32 Health)
Overview
15
15
years of professional experience
2
2
Certifications
Work History
Manager - Enterprise Data Warehouse QA Team
NTT Data Services Inc
Quincy, MA
10.2013 - Current
- Managing Enterprise Data Warehouse QA team of 16 members at Harvard Pilgrim Health Care/Tufts Health Plan
- Participating in the initial project assessment, analyzing requirements , and providing high level estimations
- Performing Source to Target (ETL) validation by writing complex SQLs in Teradata, Oracle and SQL server databases
- Data validation for flat files, XML files, JSON formatted files and Micro-strategy reports
- Responsible for Test Data Management and end-to-end test strategies for Data Warehouse, Extracts and BI projects
- Experience in test automation tools like iCEDQ, Tosca DI. Developed SAS programs for data comparison
- Experience testing software at API level using SoapUI, Postman
- Worked on Data Masking programs using Delphix, Protegrity
- Familiarity with NCQA HEDIS metrics
- Experience in Affordable Care Act risk adjustment programs, Medicare Advantage projects, and Machine Readable files testing
- Presenting Metrics, Risks, Mitigation and improvement plans to key stakeholders.
- Maximized performance by monitoring daily activities and mentoring team members
- Onboarded new employees with training and new hire documentation
- Evaluated employees' strengths and assigned tasks based upon experience and training
QA Lead
The Travelers, Employee Of L&T Infotech
Hartford, CT
05.2011 - 09.2013
- Leading the Quality Assurance Team size of 6 from Onshore, and offshore
- Analyzing requirements and preparing Test strategy
- Providing Test plan and Test Case walk through to project team and getting their sign offs
- Executed ETL jobs and validated data transformation from various source systems to Data warehouse
- Developed UNIX shell scripts to automate process of data validation between tables and to compare data between files
- Validating Cognos reports, Crystal Reports , Xcelsius Dashboards against database and GUI applications.
- Sharing Test Execution metrics, project health, defect details with project team on daily basis during test execution phase
- Conducting Defect triage meetings with SMEs and BA to facilitate development team to fix defects quickly
- Working with offshore team on project tasks
Quality Analyst
The Travelers, Employee Of L&T Infotech Inc
Chennai,India, TamilNadu
01.2009 - 04.2011
- Understanding functional requirement of the product
- Involved in developing comprehensive system Test plan and created test cases
- Translated technical requirements into verifiable and testable scenarios
- Performed both Manual and Automated testing for UI applications
- Extensively used SQL to verify data in backend
- Automated entire regression test suite using QTP 9.5
- Provided regular updates to team leadership on quality metrics by communicating consistency problems or production deficiencies
Software Test Engineer
Mckesson Corporation, Employee Of Keane Inc
Bangalore,India
12.2007 - 12.2009
- Understanding requirement and creating test cases in Quality Center using different techniques like Boundary value analysis, pair wise etc.,
- Creating Requirement Traceability matrix to ensure all requirements are covered in the test case
- Automate regression test cases using Quick Test Pro (QTP) tool
- Created various Negative and positive test scenarios
- Manual and Automated execution of regression test cases
Education
Bachelor of Engineering - Electrical And Electronics Engineering
Anna University
India Jul 2003 - May 2007
Skills
Databases: Teradata, Oracle, MySQL, PL/SQL
Automation Tools: iCEDQ, SAS, Tosca Data Integrity tool
Data Masking Testing: Delphix, Protegrity
Type of files: Flat files, XML, Json files
API Testing: SoapUI, Postman
BI Tools: MicroStrategy, Tableau, Cognos reports testing
Test Management Tools: Microfocus ALM, Jira, TortoiseSVN
Agile, Waterfall methodologies
Healthcare Industry: Member, Provider, Claims Adjudication
Team leadership skills
Team assignments
Certification
ISTQB Foundation Certified
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Manager - Enterprise Data Warehouse QA Team
NTT Data Services Inc
10.2013 - Current
QA Lead
The Travelers, Employee Of L&T Infotech
05.2011 - 09.2013
Quality Analyst
The Travelers, Employee Of L&T Infotech Inc
01.2009 - 04.2011
Software Test Engineer
Mckesson Corporation, Employee Of Keane Inc
12.2007 - 12.2009
Bachelor of Engineering - Electrical And Electronics Engineering
Anna University
Jul 2003 - May 2007