| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email: EMAIL AVAILABLEURL: https://LINKEDIN LINK AVAILABLEMobile: PHONE NUMBER AVAILABLEWork Authorization: US CitizenEducation: Master of Science, Rutgers University, NJMaster of Business Administration (MBA), IndiaProfessional Summary:Over 18 years of strong IT experience in several roles such as Quality Assurance (QA) Lead, User Acceptance Test (UAT) Lead, Data Analyst, and Business Systems Analyst. Well versed with all SDLC processes. Proficient in Agile, Scrum, Hybrid, Incremental, and Waterfall project methodologies. Extensive experience in test management, functional testing with Manual, Database testing, ETL testing, Datawarehouse testing, Webservices testing, Mainframes testing, Security testing, Cloud testing experience in AWS and Data bricks, Business Intelligence reports testing, End to End Integration and User Acceptance test approaches. Experienced in Mobile Web apps testing on iOS and Android devices on emulators. Good working experience in domains such as Health Insurance of Commercial and Government (Medicare & Medicaid) insurance products, Wealth Management, Banking, and Home Mortgage. Self-motivated, well experienced in test management, team management, client interaction in the global delivery model in the Agile - scrum framework. Extensive work experience in managing major software projects and coordinate all software development activities with project stakeholders.Career Profile:Clients worked with: Proven experience at client sites such as New York State (NYS) Department of Health, Blue Cross Blue Shield of Kansas City (BKC); Cigna, Philadelphia, PA; Bank of America, Pennington, NJ; United Health Group (UHG), Horsham, PA; PHH Corporation, Mount Laurel, NJSoftware Testing Experience: More than 18 years of extensive Quality Assurance experience with extensive work in manual testing, web services testing, database testing, data warehouse testing, ETL testing, infrastructure testing, mainframe applications testing, security testing, Cloud services testing of AWS and Databricks, End to End Integration testing, and User Acceptance Testing. Experience in providing testing solutions for complex enterprise-software applications.oQuality Engineering/ Assurance: Possess strong experience in ensuring all quality standards, methods, capacity to develop benchmarks of quality standards directed towards improving performance of departments. Contain extensive experience in conducting System testing, End to End Integration testing, Infrastructure testing in Cloud environment, Mobile device testing of web apps, Backend testing, APIs Microservices testing, Security testing, Context Driven, Risk Based testing, End to End Integration testing, Business Acceptance testing while following Test Case designing techniques. Offer expertise in designing and developing Test Plans, Test Strategies and Test Scripts based on user needs specifications.oETL and Database Testing: Created complex SQL queries to validate ETL Mappings, counts of records in Source and Target tables, Validated the data using the Informatica PowerCenter, validated the migrations, conversions and ETL validations. Strong in SQL, PLSQL, good experience in verifying Data Integrity, and Data ValidationoMobile Device Testing: Performed Web App testing using emulators such as BrowserStack, TestComplete.oMicro Services Testing: Good experience in WebServices, Rest API testing using SOAPUI and Postman.Test Management: Proven experience in Sprint planning, test estimations, test strategies, test plans, test approaches, test readiness and closure documents with Testing Signoff. Good experience in building high-performance testing teams in Global Delivery Models and leading multiple enterprise scale projects, supporting testing organizations with planning, coordination with cross functional teams and in compliance with Service Level Agreement (SLA).Process and Methodology: Proven expertise in Safe Agile, SCRUM Methodologies, enterprise test management, test governance, proven experience on Iterative incremental & Waterfall Model. Experience in conducting daily scrum meetings.Companies and Clients worked:Cloud and Things/NTT DATA; December 2023 presentoNew York State Department of Health Division of Operations and Systems (NYSDOH DOS) December 2023 - presentTCS America Inc, USA; May 2019 July 2023oBlue Cross Blue Shield of Kansas City November 2022 to July 2023oCigna Healthcare; Remote April 2020 to October 2022oBank of America, Pennington, NJ May 2019 to March 2020United Health Group Inc, March 2007 April 2019oUnited Health Group - Full time employmentHoward Systems Inc; October 2006 to March 2007oUnited Health Group RTH periodTEK Systems January 2006 to October 2006oPHH Mortgage ServicesCertifications:SQL Certified SQL DeveloperEducation:Master of Science, Rutgers University, New Brunswick, NJ, June 2006Master of Business Administration, IGNOU, New Delhi, India, June 2003Areas of Knowledge & Expertise:Agile Tools JIRA, Rally, Azure Dev Ops (ADO)Domain Expertise Banking, Healthcare, Insurance, Medicare and Medicaid, Home Loans and Mortgages, Home equitiesOperating Systems Windows, Mainframes, Unix, LinuxProgramming Languages SQL, C, C++, JavaDatabases Oracle, MS-SQL Server, MS-AccessWebServices SOAP UI, PostmanWeb Tools HTML, XMLETL Tools Informatica Power CenterCloud Technologies AWS, DatabricksReporting Tools Crystal, Business Objects, Tableau, Cognos, Power BIOffice Tools MS Word, Excel, PowerPoint, Access, Outlook and VISIOOther Tools /Technologies XML Spy, TOAD for Oracle, SqlSever management Studio, AQT (Advanced Query Tool), Infomaker, Putty, Jenkins, Mainframes testingTest Management Jira, Zephyr, HP ALM / Quality Center, Test Director, ADOProfessional Experience:Client: New York State Department of Health Division of Operations and Systems(NYS DOH DOS) Nov 2023 Apr 2024Domain: Healthcare Government InsuranceEmployer: Cloud and Things, NTT DATARole: User Acceptance Test ManagerNew York State Department of Health, Division of Operations and Systems has initiated non-MAGI Medicaid transformation for the Medicaid complex population with proven and advanced methodologies.Roles & Responsibilities:Responsible for overall UAT testing after QA team signs off quality assurance testing of MECM Project.Work closely and act as a liaison with project internal and external stakeholders. Enhance communication in order to conduct all testing and evaluation of project initiatives.Develop effective and positive working relationships with both internal and external contacts.Plan and lead all UAT testing, including organizing, coordinating, and monitoring testing efforts.Estimate team size, provide justification for each resource, and establish team for UAT testing.Responsible for UAT test strategy and UAT test plan.Provide direction and guidance to the team to understand requirements, follow the testing processes, create defects in Jira.Responsible for making sure all requirements are effectively tested by UAT team. Create Requirements Traceability Matrix (RTM)Ensure that software testing is conducted on time and as planned, promptly notifying management of bottlenecks, issues, and risks.Analyze discrepancies in service or performance and provide recommendations for product or service updates.Monitor defects, create defect reports, and collaborate with vendors and the state to resolve defects/bugs.Work with UAT Team, QA team, and Development teams on Defect tracking and managementTools: Azure Dev Ops, Jira, JAMA, Toad, Word, ExcelProject Methodology: Hybrid methodologyClient: Blue Cross Blue Shield of Kansas City Nov 2022 - July 2023Domain: Healthcare Commercial and Government InsuranceEmployer: TCS IncRole: QA, UAT and Data Analytics Lead Engineer (Database, ETL, and Data warehouse)Blue Cross Blue Shield of Kansas City (BKC) is a major health insurance company serving major part of Kansas and North-Western Missouri population. Facets is a comprehensive Insurance application developed and being supported by Cognizant Inc (CTS Inc) to Cigna client to support Member enrollment, Plan data, Claim data for all healthcare plansRoles & Responsibilities:Was responsible for all QA and UAT work efforts that both the onshore and offshore teams are assigned to work on the particular project the team is working time to time.Worked to resolve all issues Environmental, data, development, resources etc that interrupted the team to progress in the project workResponsible for Estimates, work allocation, tracking work progress of teamWas responsible to provide status to senior management at any point of timeAttended requirement/user story reviews in Scrum calls, analyzed requirements and design reviews conducted by Product Owners, System Analysts and Development teams. Provided feedback regarding incomplete or unclear requirements.Discussed the technical issues and testing defects in the daily stand-up meetings of Agile teams.Attended lockdown estimation meetings, worked with QA management and actively involved in QA Resource Planning. Created work breakdown structure (WBS) for assigning work to team and monitored allocation status on an ongoing basis.Extensively involved in testing data in data warehouse for integrity, accuracy, reliability, and consistency for ETL loads.Was Responsible to create and execute functional test scenarios for System testing on Portal, Database, ETL validations to verify the conversions. Extensively did ETL testing using Informatica PowerCenter with DVO to verify the various objects due to the migration from the legacy systems to new servers. Also verified calculations, data mappings, columns conversions, validity of the claim data etc.Verified loading of .csv files with huge data from source system to the target system.Extensively performed data ware house testing using Power BI and Query Surge toolsWell versed with CMS mandates for Member enrollment, billing, fulfillment transactions and TRR reportsExperienced in Facets and EAM applications. Used Edifecs to verify the file transport between the applications.Worked extensively on EDI files with 837,835, 834, 270/271, 276/277 transactionsWell versed in EMR/HER data compliance rules and HIPAA compliance rules and regulationsPresented the product demos to the leadership, Sales and customers teamsCreated, reviewed and uploaded Test plan documents, Test Scripts, Test Summary ReportsProvided regular feedback on QA policies, procedures, and escalated quality concerns to management, team members and automation team in Facets Application perspective functionality.Analyzed Production defects (if any) and provided Root Cause Analysis (RCA) to the senior management and Release post-mortem meetings.Environment: Facets, EAM, EDI files, MS SQL Server, Oracle, VDI, EAM (Edifecs Application Manager), MS SQL Server, Oracle, AWS RDSTools used: Azure Dev Ops (ADO), SQL Developer, Power BI Reports, Informatica Power Center, Azure Dev Ops (ADO), AWS RDS, AWS Lambda, AWS S3Project Methodology: AgileClient: Cigna Inc, Philadelphia, PA April 2020 - October 2022Domain: Healthcare Commercial and Government InsuranceEmployer: TCS IncRole: Sr. QA Lead (Database, ETL, and Data warehouse)Cigna, a Health Insurance Company that strives to improve the health by providing affordable health insurance US nationwide. The Software application that Cigna uses is Facets, thats developed and maintained by Cognizant Inc (CTS Inc) team. Cigna uses this application to load the member data, provider data, plan data, process claims and maintain claim data etc. Cigna has been using Facets for years and during the course of my work over there, Government projects were developed for Medicare and Medicaid using population.Commercial systems:On the commercial front, Cigna has Facets application that can enroll or load from upstream applications Member and Provider data in order to process claims.Government System:With the success of commercial systems, CIGNA implemented a similar approach of Member and Provider data by enrollment within Facets and load from upstream applications, Process Claims for Medicare and Medicaid members that get subsidies from Government. It was a very big initiative and I was responsible for the complete testing assignment of this project.Roles & Responsibilities:As a TCS Lead working onsite, was responsible for every work offshore does. And, was responsible to complete work that offshore was not able to complete during their work hours. Worked collaboratively with Developers and Testers offshore and Business, Project Managers, Scrum Masters onshoreExtensively working with loading providers by running Batch jobs (for commercial systems) by Web Services (for Government Project), have been validating and reporting issues and getting them resolvedDiscuss the issues in the Development/QA checkpoint meetings that Project managers hostWorked to resolve any issue Environmental, data, development, resources etc that interrupts the team to progress in the project workHandled multiple projects parallelly.Worked with product owners, business users to understand the requirements and converted them into detailed features for a legacy application. Periodically re-prioritized the Product Backlog before every sprint based on customer feedback, market changes and business priority as communicated by the Product OwnerResponsible for the design and requirements reviews to prepare high level test scenarios. Ensured that test scenarios and test cases are reviewed with business and project teams to determine the test coverage using traceability matrix.Performed ETL testing using Informatica PowerCenter with DVO to verify the various objects due to the migration of Claims data from legacy systems to new servers. Also verified numerous calculations, data mappings, columns conversions, validity of the claims, member and provider data etcCreated complex SQL queries which helped to verify the automated transformations of ETLWorked extensively on Facets, EAM, EDI files including 837,835, 834, 270/271, 276/277 transactionsResponsible for Defects management through HP ALM, Quality CenterI was the key point of contact from TCoE and worked in collaboration with other stake holdersCreated test strategies, test plans, test approaches, test readiness documents, test estimations, test closure documents and many other required documents during sprint executionResponsible for test delivery of several applications in terms of functionality testing, automation, mobile testing, database testing etc., in an onshore-offshore model of executionEnvironment: Facets, EAM (Edifecs Application Manager), EDI, JAVA/J2EE, MS SQL Server, Oracle, AWS RDSTools used: Azure Dev Ops (ADO), Oracle PL/SQL Developer, Informatica Power Center, AWS RDS, Power BI, and Tableau Reports as Data Visualization toolsProject Methodology: AgileClient: Bank of America, Pennington, NJ May 2019 Jan 2020Domain: Banking Wealth ManagementEmployer: TCS IncRole: Test Lead (ETL, Webservices)Data Analytics & Insights Technology (DAIT) - Global Wealth Management Client and Account Data (GWM C&AD) is a wealth management system where GWM partnered with Business Product and Channel providers to transform GWM into a client-centric, process and service model with the ultimate goal of enhancing client experience and enabling GWM to be an essential partner with its clients. This has been implemented through a strong program of governance, compliance, integration, development and measurement around Client and Account Data (C&AD) on a Customer/Client Core Data Platform (CCDP) by the DAIT Team.Roles & Responsibilities:Handled multiple projects in parallel in a multi-vendor environment by following Agile and Waterfall modelsResponsible to create and execute functional test scenarios for System testing on portal. Database, ETL validations to verify the conversions. Also handled Disaster recovery testing effort.Extensively involved in the User Story grooming process to write good user stories and align them to each sprint in Agile projects.Conducted Strategy Documents and Test Plan reviews with PM/ SA/ Dev/ QA/ EQA/ UAT/ Business and Cross App teams.Provided guidance to Offshore QA team members to assist them in planning scenarios as per the User Story requirements to create and ensure proper details are present in Test Cases.Created and executed test cases for the user stories assigned to the sprint and projects in Waterfall.Performed Peer review of Scenario Grids in order to ensure Valid Test Cases were created as per requirements. Setup and Facilitate Test Case Walk-thru review and Act as the communication liaison for PM/SA/DEV/UAT and QA team members for various projectsEnsured the removal of all technical bottlenecks during executionExtensively involved in testing a Mainframe based application called KD in several projects.Performed Web Services testing and Validated XML request/response data using Grand Central Test Automation tool (GCA tool) which is an internal tool based on SOAP UI. Created a reusable SoapUI test suite in the GCA tool and also worked closely with Offshore QA team to move the test cases from GCA tool to Parasoft SOAGood experience in creating and verifying YAML filesPerformed Health Checks of Daily Deployment to cover several internal applications of DAIT such as OAO, EAO, KD, Web services etc. Created and monitored defects if any of these applications fail in the Health Check after that days deployment and followed up with concerned applications developersReviewed the status of projects on a regular basis with Offshore QA team, and guided them in project testing, and Provided overall QA status to Project Managers, Scrum masters, QA Managers and Release Managers.Provided feedback to Offshore team members on the development of existing Regression suite.Environment: Mainframe, ODM, MuleSoft, WebServicesTools used: DataX (an internal tool similar to SQL Navigator to build and run SQLs), HP ALM, Rally, Jira, SoapUI, Parasoft SOAProject Methodology: Waterfall, Hybrid, and Agile.Client: UnitedHealth Group, Horsham, PA Oct 2006 April 2019Domain: Healthcare Government (Medicare and Medicaid InsuranceEmployer: Howard Systems Oct 2006 - Mar 2007 (Right to Hire contractUnited Health Group Apr 2007 Apr 2019Role: IT Quality Consultant Several roles in the course of time as Test Analyst, Test Lead, ETL Test lead, Data Analyst, System Analyst and IT Quality Assurance LeadUnited Health Group is one of the leading providers of health insurance in North America. GPS is member administration system that manages enrollment, eligibility, billing and fulfillment for Medicare and Medicaid members covered under Part-C for hospital & doctor visits and Part-D for Prescription drugs. GPS is tier 1 enterprise strategic application with multiple integration points build on JAVA/J2EE and Spring framework with Oracle as back-end. Worked in various roles in GPS application starting as a QA Analyst, progressed as QA lead, Software Developer for BI reporting, System Analyst.Below mentioned are some of the major functionalities and projects that I worked on and coordinated successfully in GPS QA as IT Quality Consultant.Projects: PDP and MAPD Enrollments, Billing Redesign, Fulfillment-Opt In to Paperless, Annual Vendor Testing, Oxford and Pacificare Data Migrations, GPS Web Service Standardization, Medicare Advantage Part C EOB, Billing Letter Enhancements, Medicaid Medicare Enrollment Automation. VRP Vendor Analysis and various other initiatives.Roles & Responsibilities:Attended requirement/user story reviews in Scrum calls, analyzed requirements and design reviews conducted by Product Owners, System Analysts and Development teams. Provided feedback regarding the clarity of requirements.Involved in lockdown estimations, worked with QA management, and actively involved in QA Resource Planning. Created work breakdown structure (WBS) for assigning work to team and monitored allocation status for each project development and execution.Planned for the required Infrastructure and Testing Processes for the project execution.Created Comprehensive Test Strategy, Test Plan and Sprint planning document with work estimates.Extensively involved in the User Story grooming process to write detailed user stories and understand the acceptance criteria and finally aligned them to each sprint.Conducted Test Plan and Test Case reviews with PM/SA/Dev/QA/EQA/UAT/Business and Cross App teams.Involved in proper resource alignment for a project or a test data request.Provided guidance to Offshore QA team members to assist them in planning scenarios as per the User Story requirements to create Requirement Traceability Matrix and Scenario Grid and to ensure proper details in Test Cases.Performed Peer review of Scenario Grids and Requirement Traceability Matrix in order to ensure valid Test Cases were created as per requirements. Setup and Facilitate Test Case Walk-thru review and Act as the communication liaison for PM/SA/DEV/UAT and QA team members for various projectsCreated and Executed test cases for the user stories assigned to the sprint.Monitored Quality Center/HP ALM for projects - both test cases and defects. Validated the defects raised by UAT and QA teams and assigned it to right people for triage. Make sure these defects are addressed by the assigned resource and see them through the resolution.Performed Mobile Web apps testing on IOS and Android devices using BrowserStack, and TestComplete as emulators for myuhc.com and Walgreens-ODIN projects.Coordinate the processing of test data requests (TDRs) of ALM that are created by cross applications that are upstream or downstream to GPS.Coordinated with all appropriate teams and oversee all testing activities related to the project are appropriately planned and executed for System testing, Integration Testing and End-to-End testing with cross applications such as Portals, Cosmos, PBMs such as RxSolutions, Walgreens etc..Validated Defects raised by QA and UAT Teams and make sure these defects are addressed by the assigned resource and see them through to resolutionEnsured the removal of all technical bottlenecks during executionPerformed Web Services testing and Validated XML request/response data using SOAP UI. Web services SME and point of contact for all queries. Created a reusable SoapUI test suite of multi XMLs and also worked closely with Offshore QA team to come up with test suite in Test RunnerPerformed ETL testing for numerous Data migrations to verify the counts of records loaded in the database.Worked extensively on database testing, data migration testing and Validated ETL mappings and tested the data in data warehouse.Executed the automated jobs to verify the truncate the target tables, migration of the data to the target tables and validating the data as per ETL rulesTested hundreds of Crystal, Tableau, and Actuate reports for data and counts accuracy.Scheduled and conducted QA/UAT Daily Defect review meetings to go over the status of Testing Effort for every release.Reviewed status of project on regular basis to update senior management.Provided guidance to Offshore Automation to identify and bridge gaps in the Regression suite for GPS functionality - enrollment, eligibility, and billing for various projects as and when required.Created, reviewed and uploaded Test plan document, Test Script, Test Summary Reports on the project ADR SharePoint. Coordinated with QA management and Release management for Approvals within deadlines.Provided regular feedback on QA policies, procedures, and escalated quality concerns to management, team members and automation team for GPS functionality.Worked closely with Onshore/Offshore QA teams to complete several projects and delivered them on time and, on budget.Actively participated in Root Cause Analysis and Release post-mortem meetings.Lead the effort on test automation framework enhancements, test scripts functionality coverage, ensured the quality of the test scripts, developing automated test scripts along with offshore team.Environment: UNIX, LINUX, JAVA/J2EE, SQL, PL/SQL, Oracle 11i/12i, MS AccessTools used: SQL Navigator, PL/SQL Developer, Oracle SQL Developer, Putty, UNIX, WS_FTP, Subversion, Jira, Autosys, TWS, Actuate, Crystal Reports, Business Intelligence Business Objects, Tableau, HP ALM,, Rally, TeamTrack, TestCompleteProject Methodology: Waterfall, Hybrid, and Agile.Client: PHH Corporation, Mount Laurel, NJ Jan 2006 Oct 2006Domain: Mortgage and Home Equities loansEmployer: Howard Systems IncRole: Sr. SQA AnalystPHH Mortgage is the industry's leading provider of private label mortgage services and the top originator of mortgage loans by phone. PHH Mortgage provides full-service capabilities for originating, processing, closing and servicing loans. More than 100 different mortgage products, twenty-minute single session home loan approvals on the Internet or by phone and has one of the industrys strongest rate protection programs. PHH Mortgage uses the CA$H (Cendant Achieving Servicing Heights) application to process and close all Nets-first and second lien loans. This system supports diverse client needs in terms of products, pricing, processing and documentation, catering to the unique PHH Mortgage need of supporting private labeling initiatives. All loans originated by the Organization (thru PHHORCE, CA$H, and Web sites) are interfaced to CA$H where they can be processed and closedRoles & Responsibilities:Involved in the Manual and automated testing of different applications such as Phhorce, Cash, Galaxy used for Origination, processing, and closing of different types of loans like Purchase, Refinance, Heloc, Piggyback, Landscape etc using WR and QTPExtensively involved in the manual and automated testing of Web applications - B2C (Business to customer), B2B (Business to Business) and other web applications like www.mortgageloanstatus.com (MLS.com testing), www.mortgagequestions.com (MQ.com testing)Worked as an only member of a Web based project DMS migration; to ensure that the Web applications - B2C, B2B, MLS.com, and MQ.com sites using DMS authentication are working as expected, and the data is integrated when the server was changed from Unix to Linux.Analyzed software requirement specifications (SRS) to understand the business requirements and involved in developing the Master Test PlanPrepared detailed Test Plan and test cases for Functional, Integration, Security, GUI and also prepared the procedures to test for manual and automated testingWrote Test Scripts and executed Test Cases for a web application called FSMS ClosingInvolved in testing of an Intranet application called IDESK which is used within PHH Mortgage Services to manage loan-processing system.Used Test Director/ALM for defect reporting and tracking.Wrote test cases derived from business functional and marketing requirements.Performed Smoke, Functional, Data Integrity, and Regression Testing.Performed Regression testing, Compatibility testing on different Web applicationsPerformed Database Integrity testing using Info Maker to ensure the data has been populated as intended and, all database events occurred properly.Performed Backend testing by writing SQL statements using Info Maker to ensure that the correct data was retrieved.Worked closely with Developers, Business Analysts, and User RepresentativesActively participated in the periodic review and status meeting to discuss the issues raised during testing.Environment: UNIX, LINUX, JAVA/J2EE, Oracle 11i, MS AccessTools used: Info Maker, SQL Navigator, Oracle SQL Developer, Putty, WS_FTP, ALM,Project Methodology: Waterfall |
