Ravichandran Vellingiri

18 years of experience in the Software Quality Assurance field and complete SDLC across diverse solutions that includes ETL-DW/BI and Manual Testing Good experience of testing a large BI&DW solution that includes Data Integration Testing (Data Acquisition, Data Load/ETL/ BI Reporting Applications/ OLAP) Expertise in working on Data Migration, Data Mart, Master Data Management projects Working knowledge on tools like Gitlab, DBT, JIRA, IICS, TM4J, Confluence, HP ALM & QC tools Sound knowledge on Healthcare industry (Membership, Claims, Providers etc.…) Experience in creation and understanding of testing artifacts like test strategy, test plans, test cases, and Test effort estimations Sound experience in test designing, verification, validation, testing techniques for ETL applications Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing Ample experience in working on Agile & Water Fall methodologies Strong in developing SQL’s based on the business requirements Highly flexible and adaptable contributor; adept at multi-tasking, meeting deadlines, and thriving in a fast-paced environment Quick Learner and Good team player with solid work ethics and Good Analytical skills

Results-driven quality assurance professional with extensive experience in overseeing complex testing environments and driving process improvements. Known for fostering team collaboration and consistently delivering high-quality outcomes. Adept in adapting to changing project requirements and utilizing key testing methodologies and leadership skills to achieve objectives.

• 1, Leading Humanitarian Organization, Dallas, TX, Director, SQL Server, Teradata, IICS, Power BI, JIRA, TM4J, Redshift, S3, Oracle 11g, Teradata, 05/01/20, Present, Develop and deploy the SQL codes to Prod and non-prod environments, Hands on experience on CI/CD tools like Gitlab, Being a Change resolver, ensure the go-live is performed with no hiccups, Managing the Data engineering Team and be a point of contact for business team, Defining Test Strategy and Expectation for Test Planning for data warehouse-based development projects, Ensuring all the aspects of ETL process from data acquisition through the various warehouse layers are covered in Test Scenarios, Implementing and supporting of Data Extract, Transformation and Load (ETL) and Extract Load and Transformation (ELT) methods and end-user testing tools, Making recommendations for standardized data warehouse test tools and automated solutions, Configuring Data Warehouse Testing tool as per the project’s requirement, Developing standardize QA template for Test Plan, Test Summary, Test Cases and QA metrics, Developing testing process and communicate standards and methodologies to participants in the process, Ensuring test process are followed and test defects are managed appropriately, Mentoring the test team, track test execution, traceability and test data, Coordinating the triage process and ensure that all defects are documented and tracked through resolution or acceptance, Reporting issues/defects to the project team, and follow up in issues for the assigned, Work on gap analysis and improvement plans for team/project
• 2, Leading Alternate Assets Management, Arlington, VA, Technical Manager, SQL Server, SSRS, JIRA, TM4J, Confluence, Oracle 11g, 04/01/18, 04/01/20, Managing the QA Team and be a point of contact for business team, Accountable for Requirement gathering from Business Team, study AS-IS system and develop data mapping, Defining Test Strategy and Expectation for Test Planning for data warehouse-based development projects, Ensuring all the aspects of ETL process from data acquisition through the various warehouse layers are covered in Test Scenarios, Implementing and supporting of Data Extract, Transformation and Load (ETL) methods and end-user testing tools, Understanding and helping in identifying the performance gaps and scalability of test case execution against large data systems, Making recommendations for standardized data warehouse test tools and automated solutions, Configuring Data Warehouse Testing tool as per the project’s requirement, Developing standardize QA template for Test Plan, Test Summary, Test Cases and QA metrics, Developing testing process and communicate standards and methodologies to participants in the process, Ensuring test process are followed and test defects are managed appropriately, Mentoring the test team, track test execution, traceability and test data, Coordinating the triage process and ensure that all defects are documented and tracked through resolution or acceptance, Reporting issues/defects to the project team, and follow up in issues for the assigned, Work on gap analysis and improvement plans for team/project
• 3, Leading Health Insurance Provider, Des Moines, IA, ETL – Test Lead, SQL Server, Teradata (EDW), Mongo, Oracle 11g, Sybase, 02/01/16, 04/01/18, Responsible for preparing Test estimates, Test strategy & Test plan document and obtain sign off from the Business Stakeholders, Maintain RTM and ensure no requirements are missed, Leading a team of 3 onsite resources, 5 offshore resources, Review and Fine tune the SQL’s prepared by the team members, Ensure business/functional scenarios are covered, Create test data in sources for System & UAT testing with respect to Business Requirements, Coordinated with multiple vendors to bring the data into DB, Responsible for ETL Jobs which used to load the data from different source systems to Development & QA Db’s (EDW, Sybase), Conduct defect triage meeting with Development, Project, Business team on the defects, Prepared weekly status reports and reported it to Project team and Business
• 4, DHCS, West Sacramento, CA, ETL – Sr. Quality Analyst, SQL Developer, 10/01/15, 01/01/16, Responsible for preparing test estimates & test plan document, Prepared SQL queries and validated the data in SQL Developer, Verified ETL transformation logic when data loaded through different layers, Demonstrate the stories to the clients, at the end of each Sprint and obtaining sign off
• 5, Leading Health Insurance & Service Provider, Pleasanton, CA, ETL – Sr. Quality Analyst, SQL Developer, 02/01/13, 10/01/15, Responsible for Non-Prod environments (Dev, QA & UAT) & Prod (Production & Disaster Recovery) environments testing, to ensure the data transition from Oracle 10g to Oracle 11g happened successfully, SPOC for all the testing activities that happens in different environments, Responsible for deriving the test strategy, testing efforts (estimates) and approach towards ETL testing, Involved in designing the framework for automation testing, As a Test Lead, managing a team of 10 offshore and 2 onsite resources & responsible for allocating the task to the team, Preparing SQL queries and validating the data in SQL Developer, Verifying the data in SQL Developer and validating, in different layers like, Target & Stage, Responsible for presenting the deliverable to the client, with respect to the requirements, Preparing daily, weekly, monthly status reports and responsible for presenting the projects progress to the client
• 6, Leading Energy & Utilities Provider, La Palma, CA, ETL - Test Analyst, Business Objects, Teradata, 06/01/11, 01/01/13, Responsible for preparing test estimates & test plan document, Prepared SQL queries and validated the data in Teradata, Toad and AS 400, Verified ETL transformation logic when data loaded through different layers, Responsible for verifying the data in BO reports and validating in Teradata, in different layers like Semantic, Core & Stage and source systems (Oracle, DB2), Responsible for test execution and defect reporting in HP QC, Managed a team of 3 onsite resources and coordinated with multiple vendors, Responsible for ETL Jobs which used to load the data from different source systems to Development & QA Db’s (Teradata), Prepared weekly status reports and reported it to Business team
• 7, Life Science, Chennai, India, Test Analyst, Web Based Application, 09/01/09, 05/01/11, Prepared Test Effort Estimation and Test Strategy document, Handled a team of 6 members and task allocation to the team, Reviewed the test cases, developed by the team members, Co-ordinated with development team for system design and defect triage sessions, Worked as a Configuration Controller for the team
• 8, Life Insurance, Mysore, India, Test Engineer, Web Based Application, 01/01/09, 08/01/09, Involved in analysing the Requirement, identifying the test scenarios, manage the RTM, Responsible for preparing test cases and walkthrough with business, Worked as a single offshore resource and handled the entire module, SPOC for test execution and defect reporting, Involved in management level activities such as preparing metrics report, estimation, Direct reporting to the client, with the daily status and weekly status reporting., Defect Prevention anchor for the team
• 9, Life Insurance, Mysore, India, Test Engineer, Web Based Application, 05/01/08, 01/01/09, Responsible for analysing the requirements and identifying the test Scenarios based on the States and Products, Preparation of Test plan with respect to Functional, Performance and Automation Testing, Completed the project as a single resource with zero production defects, Coordinating with different team from different vendors, to get the testing completed, Bottom line responsibility for the End to End testing
• 10, Life Insurance, Mysore, India, Test Engineer, Web based Application, 02/01/08, 05/01/09, Involved in identifying the key functionalities from Manual Test cases for converting into regression suite, Holding the major responsibilities in Test execution and defect reporting, Worked as a mentor for new joiners and guided them with the project activities
• 11, Mortgage Insurance, Mysore, India, Test Engineer, Windows base application, 10/01/07, 01/01/08, Analysing the requirements and identifying the testing scenarios, Test execution and Defect Reporting & Tracking, Worked as the Defect Manager, handled all the defects logged by the entire team and coordinating development team for any issues and track them to closure
• 12, Mortgage Insurance, Mysore, India, Test Engineer, AS400, 03/01/07, 09/01/07, Responsible for test execution and Defect Reporting & Tracking, Responsible for executing the Regression Suites