Satish Nemoori
Hyderabad
Summary
Overview
9
9
years of professional experience
1
1
Certification
Work History
QA Test Lead
Virtusa - JP Morgan Chase
01.2024 - 02.2025
- Contributed to the gathering of business requirements and functional specifications, involving a comprehensive review of existing system configurations, operational methods, and evolving business needs.
- Developed test plans, test cases, test data, and test summary reports following Agile/Scrum processes.
- Developed complex SQL queries for database testing and produced test data for functional testing purposes.
- Suggested solutions for data configuration issues and assisted in identifying and resolving related issues.
- Recognized recurring processes and developed stored procedures to validate data for these repetitive scenarios.
Handled post-production support issues, prioritizing and resolving critical defects promptly and updating the regression suite accordingly. - Led a team of testers, providing guidance and mentorship to ensure high-quality deliverables.
- Presented test reports and metrics to project stakeholders, facilitating data-driven decision-making.
- Established a robust regression testing suite, optimizing test coverage while minimizing redundancy.
System Analyst
Cognizant - Anthem Inc
12.2020 - 01.2024
- Participated in business requirements and functional requirements gathering
which involves a review of existing systems configuration and operating methods as well as understanding evolving business needs. - Analyzed the existing/ New system requirements and capture functional and business requirements in the system use case and boundary specifications documents for migration of provider data to FACETS and impacts on various downstream.
- Provide support for business/system and functional acceptance testing which involves ensuring technical specifications meet business requirements.
- Developed testing routines or procedures, test software to ensure best performance & use analytical and problem-solving skills in IT solutions.
- Perform testing based on established best practice methods of Cognizant's project test strategy documents.
- Attended meetings with the Business Team and Build Teams to gather the information about the project and the design methodology and the testing requirements,Test plans, test Cases, Test data and Test Summary Reports and followed Agile/Scrum Process.
- Perform defect management activities Defect Identification, Root Cause analysis, re-testing and tracking till closure using Qtest tool.
- Design complex SQL queries to perform database testing and create test data for functional testing.
- Provider support for business and functional acceptance testing which involves ensuring technical specifications meet business requirements
which includes coordinating with Cognizant offshore team of developers and onshore centers of excellence to ensure best practice standards are implemented. - Attend Project team meetings to learn about change and/or modifications to customized software solutions.
PLSQL Developer - GPI(Provider Interface)
Cognizant - Anthem Inc
01.2018 - 12.2020
- Designed and developed several complex database procedures, packages. Extensively used features like Cursors, autonomous transactions, distributed transactions, exception handling, Dynamic, PL/SQL tables, bulk load methods, optimizer Hints, Cursor variables and returning of multi record set from procedures and functions.
- Generated DDL scripts and created and modified database objects such as tables, views, sequences, functions, synonyms, indexes, packages, store procedures using TOAD tool.
- Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable.
- Created B Tree indexes, Function based indexes on columns to minimize query time and achieve better performance.
- Created and modified database objects such as Tables, Views, Materialized views, Indexes, Sequences and constraints, SQL queries (Sub queries and Join conditions).
- Implemented CTAS (Create Table As Select), Exchange Partition approaches to optimize archive process.
- Provide quality operations support for production environment. Work with QA and provide support to provide timely technical resolutions for defects.
- Created various UNIX Shell Scripts for scheduling various data loading process. Maintained the batch processes using Unix Shell Scripts.
- Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query factoring etc.
- Created and tested various complex reports in different styles.
Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data. - Created SQL Loader scripts using UNIX shell scripting and PL/SQL
Used Bind Variables while writing Dynamic SQL to improve performance. - Involved in performance tuning using Indexes, Hints, Explain Plan, Stats gathering etc.
- Performed SQL and PL/SQL tuning to improve the performance with the help of Explain Plan, Indexing and Hints.
Quality Analyst
Cognizant - Anthem Inc
09.2016 - 12.2018
- Analyze provider rosters for creation of new providers change to existing providers and termination of existing providers as per the health system request by verifying the data in EPDS and NPPES.
- Provider data reconciliation and clean-up activities requiring analysis of source data and correction of target data in facets system.
- Utilize the roster automation management system (ram) to build provider data set and templates for load.
- Propose and develop automated solutions for faster turnaround on analysis and processing of provider data.
- Interact with the business team to identify and understand business requirements.
- Proposing solutions to the provider data configuration issues and also help in identifying and resolving issues related to them.
- Work with client teams to co-ordinate and complete reconciliation of the CA, KS, NY, TX and WA Medicare provider data and the primary care provider (PCP) crosswalk.
- Prepare high level estimation and solutions for projects during software development life cycle system requirements and work with team on provider data.
- Responsible for QA support activities like data/environment setup, system and integration testing, defect analysis and fixes.
- Work and co-ordinate with the offshore provider data management (PDM) team for assignments, clarifications, review the deliverable and close the service forms before the SLA timeline.
- Track and report the project status to client and cognizant leadership.
- Used following software's and tools owned by cognizant to perform Medicare/Medicaid migration. These tools are owned and managed by Cognizant's healthcare business unit:
- FACETS (An integrated solution to manage US Healthcare payer value chain).
- Contract Tool (To know what contracts a provider is affiliated to load in to Facets).
FACETS - Training
Cognizant/Trizetto, Inc
08.2016 - 09.2016
- This training was about FACETS (Health Care Core System) which covered Health Care Overview, Facets Product foundations
Facets Technical foundations and Facets System Integrations. - Trained on FACETS and worked on its Data tables and created audit reports using queries. I also performed system configuration in FACETS.
- Created provider and member records and set up basic medical plans as well as process claims and gave review on his plans.
- Trained on benefit configuration and NetworkX pricing. Helped in technical designs for modules in FACETS for real time client problems during my training period.
Education
Master of Science - Computer Science
University of Central Missouri
Missouri, USA05-2016
Skills
- Oracle PL/SQL
- T-SQL
- Toad Data Modeler
- Jira
- Tidal Scheduler
- CONTROL-M
- Bitbucket & Tortoise SVN
- DVO (Informatica)
- FACETS
- Test data management
- Regression testing
- Defect management
- Functional testing
- User acceptance testing
Certification
Certified “Professional, Academy for Healthcare Management (PAHM)”.
Timeline
QA Test Lead
Virtusa - JP Morgan Chase
01.2024 - 02.2025
System Analyst
Cognizant - Anthem Inc
12.2020 - 01.2024
PLSQL Developer - GPI(Provider Interface)
Cognizant - Anthem Inc
01.2018 - 12.2020
Quality Analyst
Cognizant - Anthem Inc
09.2016 - 12.2018
FACETS - Training
Cognizant/Trizetto, Inc
08.2016 - 09.2016
Certified “Professional, Academy for Healthcare Management (PAHM)”.
Master of Science - Computer Science
University of Central Missouri
Similar Profiles
Lisa Olivia GrenviczLisa Olivia Grenvicz
Private Client Banker at JP Morgan Chase & Company (Chase Bank)Private Client Banker at JP Morgan Chase & Company (Chase Bank)
Brendy KambaBrendy Kamba
ASSOCIATE, CLIENT ASSOCIATE at J.P. MORGAN CHASE & CO. | JP MORGAN ADVISORSASSOCIATE, CLIENT ASSOCIATE at J.P. MORGAN CHASE & CO. | JP MORGAN ADVISORS
Miranda GuerreroMiranda Guerrero
Associate Banker Market Expansion at Jp Morgan Chase ChaseAssociate Banker Market Expansion at Jp Morgan Chase Chase