Praveen Raj Nagaraj

About Praveen Raj Nagaraj

15 Years of Extensive experience in IT Industry with emphasis on Quality Assurance & Software Testing.•Experience in Data Warehousing/ ETL Testing within the environment of Oracle, SQL Server and in manual testing on web based, Client/Server and data warehousing applications.•10 years of experience in QA Lead working closely with the QA Director, Business team and testers to ensure that projects are delivered on time and with the highest possible level of quality.•Expertise in writing SQL Queries using Oracle, MS SQL Server and Teradata in validating data into Data Warehouse/ETL applications.•Experience with testing mobile (iOS, Android, Windows) applications over different platforms. •Experience with working tools like MS SQL Server Management studio, SQL Developer, Win SQL, Teradata for creating and executing SQL Queries.•Experienced in complete Software Testing Life Cycle (STLC) and Defect Life Cycle.•Extensive experience in Black Box Testing, Smoke testing, Functional Testing, Integration Testing, System Testing, Regression Testing, End-to-End Testing, User Acceptance testing (UAT)•Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.•Have worked on testing SOAP web services and API Testing•Worked under testing methodologies like Agile-SCRUM and Waterfall Model.•Expertise in Defect management, Bug tracking, Bug Reports and generating the graphs using tools such as HP Quality Center ALM, QAComplete, Zephyr, Azure Devops, JIRA.•Have experience in Retail domain, Healthcare Insurance, P&C Insurance.•Have worked in testing Healthcare systems such as EPIC, Point of Sales, Payments, Claim processing, Billing.•Have hands-on experience in different insurance products such as POINT-IN, Policy Pre-Bind, Online Premium Audit, Online Payroll, Endorsements, and Ebilling.•Have been trained in Automation Testing and tools such as Selenium, QTP, UFT and Cucumber.•Having experience in testing HR systems, ID creation and Access provisioning for new employees with retail domain.•Experience in testing with POINT IN, Duck Creek, PolicyCenter, Claim systems and Billing systems.•Having hands-on experience in ETL tools such as Informatica and DataStage.•Worked and reviewed along with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications.•Experience working with onsite-offshore model and in managing the teams, complex and multiple projects.

Experience

1. Qa Test Lead

   Coforge

   Jun 2022 — Present

   Requirement analysis of functional requirements and ensuring proper understanding of the requirements to be tested• Develop Quality Assurance test plans, test strategy document and test cases to thoroughly test the business applications based on the client\'s\' requirements and the development release documents• Document and perform functional, regression, and integration testing for all releases• Testing Policy Pre-bind application if user is able to create a quote and submit it properly.• To test if quote is approved, denied, reviewed properly in application• To test policy creation, renewal of policies, cancellation of policies in POINT-IN application• To test Policy audits in OPA application• To test if policies are endorsed in Endorsement application• To test the creation of claims, Bill payments, Indemnity payments in ClaimsPro application• Database Testing and ETL Testing with Mongo DB, PostgreSQL DB, Oracle DB• Writing complex SQL queries to test business scenarios and validate all the possible conditions during ETL testing• Creation of Test data for various scenarios with source applications such as Policy Pre-bind, POINT IN, OPA, OPR, Ebilling, Point of Sale, ClaimsPro• Testing the data coming from Policy and Claim applications.• Policy creation in Duck Creek since current policy tool is going to be replaced by Duck Creek tool• Testing of policy management, billing platform, Claim system with Duck Creek• Working with ETL tools such as DataStage, Informatica and Defect Management tools such as QAComplete, JIRA, and HP ALM• Validation of Downstream reports• Coordinating with and managing onsite, offshore teams

Education

• College of Engineering, Guindy, Anna University

  B.E., Mining Engineering

  2004 — 2008

• Sri Ramakrishna Sarada H.S.S

  S.S.L.C

  1997 — 2002

• St.John's Matric. H.S.S

  Higher secondary, Physics, Chemistry, Maths, Biology

  2002 — 2004

Skills

• Software Quality Assurance
• Oracle Sql
• Java