Home

Madhukar Kalakuntla - Sr quality analyst

madhukar.kalakuntla@gmail.com

Location: Remote, Remote, USA

Relocation: NO

Visa: Green Card

MADHUKAR KALAKUNTLA Email:madhukar.kalakuntla@gmail.com Cell: 610- 533-1275 SUMMARY 17+ years of experience in the Software Industry having held positions that involve Design, Implementation, Development, Production Support, and Testing (SDLC) Experience in IT / Software Industry as a Quality Assurance Analyst with emphasis on HIPAA EDI Transactions, Manual, Functional, Automation and Backend testing using Mercury/HP Quality Center/Application Life Cycle Management (ALM), JIRA, QTP, Selenium and Open-Source tools Expertise in Test lead activities include Test planning, Estimation, Scheduling, Resource allocation, Client coordination onsite and Offshore coordination Experience in Medicare and Medicaid applications and knowledgeable in HIPAA (Health Insurance Portability and Accountability Act) Experienced in Software Development Life Cycle including Requirements Analysis, Systems Design, Development, Resource Scheduling, Project Tracking, Engineering Acceptance testing, Deployment and User Training s Sound knowledge of standard business Methodologies, SDLC, Agile/Scrum, RUP and Waterfall. Expert in Test Cases, Test Scenarios, Documentation and Defect life cycle management in a DevOps environment Extensive experience in testing the applications developed in C, C++, .Net, C#, ASP.Net, JAVA, PHP, and J2EE Performed extensive Backend Testing of data validation of applications using SQL queries. Executed SQL statements to check if the data integrity has been maintained. Responsible for creating the test scripts for IBM iSeries/AS400 RPG legacy application. Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing. Wrote detailed Test cases for the SOAP interface using XML. Tracked and reported bugs using Mercury Quality Center and Jira. Wrote complex SQL queries to perform the backend testing of the Oracle database using PL/SQL developer and UNIX shell commands Strong Analytical skills, excellent communication and interpersonal skills, team player and self-Starter Experience of PRPC (Pega Rules Process Commander) as design Testing, and PRPC workflow experience. TMF Responsible for the testing of all new workflow configurations in Pega and the entry of process results into the internal testing application. EDUCATION Masters in E-Commerce and Computer Applications from Stratford University, Virginia. TECHNICAL SKILLS: Programming Languages: Java, ASP, C#, VB.NET, SQL, PL/SQL, T-SQL, UNIX/Linux, VB Scripting, JavaScript. Testing Tools: ALMQC, QC, IBM, IBM Rational Manager Test Director, JIRA, Load Runner, QTP, Selenium, SOAP UI, Version Control: MS Team Foundation Server (TFS), VSS, CVS, PVCS, Clear Case Other Tools: SQL*PLUS, SQL Navigator, TOAD, Notepad++, EDI Notepad, Eclipse, WINSCP Operating Systems Windows Family, UNIX Databases: Oracle 10g, MySQL, MS SQL, MS-Access, DB2. PROFESSIONAL EXPERIENCE Publix Super Markets, Lakeland, FL Sep2023 to Till Date Role: Sr. SQA Analyst Project description: Publix Instacart Omnichannel Integration project was designed to create a unified customer experience across all digital and physical shopping touchpoints. The objective was to seamlessly integrate Instacart online ordering systems with Publix storefronts for online Ordering /delivery and Pickup. Roles and Responsibilities: Creating Test Scripts based on the Business Requirements Specification documents in HP Quality Center. Collaborated with business analysts and developers to understand omnichannel workflows including delivery, curbside pickup, and in-store promotions Created and executed test scenarios and test cases based on business requirements for Project with core Backend validations worked and tested to upload all table data to Azure Data Lakes form of CSV files. Tested Shared Access Signature (SAS) token authentication using the Azure vault to access azure resources. Worked extensively on Azure Synapse Database Extensively worked with Azure Blob Storage, Table Storage and Azure SQL Database. Involved in testing queues for sending and receiving messages to and from external systems using Azure Queue and WebSphere MQ. worked on testing windows service for constantly listening to Azure Queue and processing messages. Worked using SQL server to test Store procedure, Views and indexes. Focused on API testing using Postman, validating response payloads in JSON Validated backend updates reflected correctly in frontend by cross-checking API responses with database. Logged and tracked defects in HPQC, DB errors, timeout errors and service failures worked on Validation AZURE function token refresh with OAUTH 2.0 for 24-hour auto refresh worked on UAC migration from CA7 platforms Validate all the OMNI jobs end to end (daily and Nightly jobs) Documented All test cases and validation scenarios in HPALM, ensuring traceability to business requirements Executing Test Cases in Quality Center and logging defects. Prepare documentations like Testing Progress, Test coverage and providing status to various stake holders. Environment: Azure Data Bricks, Micro Focus ALM, MS SharePoint, PL/SQL Developer, SQL Server Management Studio20, Postman. Federal Employee Program - OC Jun2022 to Aug2023 Role: Sr.QA Analyst Project description: FEPOC is a subsidiary of CareFirst Blue Cross Blue Shield and supports the world s largest privately underwritten health insurance contract. FEPOC has a contract with BCBSA and maintains/updates the FEP Enrollment system and Claims System. FEPOC transmits and receives Claims from Plans, and provides Software, Documents, and training to Plans. Roles and Responsibilities: Involved in testing 837 Project in distributed Technology Applications Web, dB2, Mainframes, ITX and UNIX. Create and track testing Tasks, Risks, Issues, Quality Metrics and Status Reports. Worked on Processing Batch, Bulk & Realtime claim Processing for 837IPD. Analyze and identify the existing and new changes implemented as part of Product Upgrade. Expertise in the FEP Medicare and Medicaid Claims Processing Rules Assisted Agile Scrum Master and implemented Kanban Board based on the nature of deliverables. Analyze and provide the inputs for Production Issues for Plan testing support. Actively participate in Change Controls decisions, estimations, and coordinate with team for testing. Worked and Processed Price claims (LPP Claims) for both inbound and outbound Validations. Validate the outbound FCR files and different data elements positions based on the FCR mapping spec. Involved in sprint planning and Provided LOEs for testing activities. Involved in all the test activities Planning, Grooming, Retro, Stories, Defects and Allocation. Assisted Plan enquires EDI X12 Queries and analyzed EDI files and Provided Results. Engaged and coordinated with IT Application teams and BA teams. Reported test status at Sprint level. Created test scenarios, test cases and executed test cases. Participated in daily scrum meetings, refinement meetings, retro meetings, and sizing sessions of the user stories as part of the Agile process. Actively participated in the defect triage meetings and prioritized the defects. Worked with the Operations Support team whenever any production issues are reported. Worked on FEP Direct Validations for all the claims submitted and Resolved the Edits. Environment: Rocket Shuttle, Mainframes, .Net, IBM B2B ITX, Java, Selenium, Eclipse, JIRA, SQL, FileZilla, MS SharePoint. Publix Super Markets, Lakeland, FL Oct2020 to May2022 Role: Sr. SQA Analyst Project description: ICCRM - Generating the marketing data from Instacart CRM application to retrieve the Instacart Customer List who opted-in for E-mail communications on Instacart platform. Each Instacart customer will be mapped against the ECMS profile based on the Email address to determine if the customer is already a PAH (Publix Account Holder). If the customer is Non-PAH, a Non-Account ECMS profile is created. And the generated data will then be uploaded to SFMC (Sales Force Marketing Cloud) Data Extensions for marketing. Roles and Responsibilities: Creating Test Scripts based on the Business Requirements Specification documents in HP Quality Center. Interact with various Business Analysts and Developers to design better test plan and strategies based on the requirements of the business. Executing Test Cases in Quality Center and logging defects. Prepare documentations like Testing Progress, Test coverage and providing status to various stake holders. Helping the Business team in carrying out the User Acceptance Testing. Worked on testing Azure Databricks note to validate different data files connecting to data lake Created the test Notebooks for Azure data bricks to create the views to different datafiles to validate and compare the data. Worked on the Azure Data Lake Gen1 migration to Gen2 migration to validate the files are created as expected in Storage containers. Validated the Blob Storage account data after the aggregation process in combination of data from different data frames Executed SQL statements to validate the data in Azure workspace Worked on Aggregating the on prem and data lake data for the end point validation. Tested SFMC Journey Builder for weekly campaigns for business team. Environment: Azure Data Bricks, Salesforce marketing cloud, MS SharePoint, MTM, HP AGM, PL/SQL Developer, SQL Server 2015 Management Studio. Verizon Telecom Services, Tampa, FL Sep2019 to Sep2020 Role: Sr.QA Analyst / Test lead &Test Coordinator Project description: MTAS UI is the user interface for the Mobile Telephone Activation System that provisions subscriber services onto the Verizon Wireless network. The MTAS UI is used by tier 2 technical support, network personnel and other support groups for troubleshooting service issues. The system enables synchronization with VZW billing systems, verification of subscriber details, access to provisioning transaction history and various other network self-serve functions. Roles and Responsibilities: I have experience in telecom domain which involves understanding the different technologies like 3G, 4G, 5G. Involved in Production Support for the provision transaction in real time and load balance the transaction based on high queue count and transaction flow. Monitored and submitted the hourly health check of the applications and trouble shouted if any issues and involved the Crises teams. Worked as Onsite and Off shores test coordinator and assigning work and daily coordination and defeat calls with team for all Enterprises releases (ER, MR & Ref Data Changes) Participate in daily scrum meetings following agile methodology and provide day-to-day burn down hours of QA and tasks progress for the different sprints utilizing Jira tool Managed Q-Test for test management and Defect tracking, executing test scripts and running in test lab. Validate backend scripts and sql tables and see all the Activation, Device Changes, MDN change, and other transactions processed as expected with all feature Provisioned. Validate the transaction with feature code queue to the correct Network element in Unix instances. Developed business documentation for the Network elements with New Feature for downstream applications (Billing teams) Worked closely with external and network teams for Product outage resolutions. Involved in sprint planning for all the major enterprise releases Involved in Automation testing of different network elements that different scenario for testing and creating environments for execution using selenium. Worked on web services testing using both Postman and soap UI, all external services are tested as part of regression for calls MTAS applications. Environment: G-suite, Eclipse, Selenium, SQL server, Linux/Unix, Soap, Postman, Q Test, Jira BCBS of Florida (Florida Blue), Jacksonville, FL May2019 to Sep2019 Role: Sr.QA Analyst / Mobile Application test Project description: MLP (MY Life Plan) & Native Mobile Application, work on implementation of new payment Platform for both Florida blue Mobile Apps. And also implemented the major functionality of Member Portal in mobile App. Roles and Responsibilities: Performed compatibility testing with various mobile handsets to ensure that functionality working as expected. Involved in writing Requirement Tractability Matrix (RTM) detailed Test Plan and Test scenarios. Working closely with project manager and Project team to learn about the project functionalities and provided testing timelines. Logged defects encountered in the application through Rally during test cycles and conducted fix verification. Tested the application under different networks and Internet speeds including on 3G, 4G/LTE and Wi-Fi. Involved in testing application on different mobile Platform such as iOS and Android devices. Involved in all stages of testing process Development of Test procedures and Test cases based upon requirements for regression test. Experienced in PEGA CRM 7.2.2 and 8.4.1. Excellent understanding of different types of PEGA Rules and Data transforms which includes, Correspondence rules Hands on experience in debugging/logging application using PEGA Clipboard, Tracer tool and PAL Attended Demos and met with Client for User Acceptance and providing QA Signoff on the testing. Tested Web app, Native app using See Test for automated the mobile testing and run the scripts for multiple devices, and also perform manual testing according to the requirements. Testing of member payments utilizing self-service portals Web Application which uses Restful Web services, SOAP UI, XML, DOM and JSON Participating in daily and weekly meetings and leveraging ALM and RALLY tools to maintain the dashboards and provide real-time metrics to the management Environment: Application Life Cycle Management (ALM)/Quality Center, Rally, JIRA, Selenium, DB2, Oracle, DevOps, HTML, SQL Navigator, EDI Notepad, SOAP UI Publix Super Markets, Lakeland, FL Nov2017 to May2019 Role: Sr. SQA Analyst Project description: Electronic Item Form - Item Form Approvals and the maintenance of item data has become highly fragmented across many systems in Publix. Setting up a new item at Publix can require the use of more than 10 different systems by multiple business areas to set up hundreds of pieces of data and parameters. In order for the downstream systems to work, it is important that the data be accurate, complete and synchronized. The Item Form Project provides key solutions across different areas by developing a new systems. Roles and Responsibilities: Perform business requirements analysis, design documents for completeness and testability Develop system integration test plans, test scenarios, test cases, test data and test scripts. Perform and coordinate system verification and validation test activities using HP ALM/ Quality Center/ MTM Microsoft Test Manager End to end testing with multiple systems integrated applications in retail management. And analyzing system requirements and developing test plans, test scripts for functional, integration and system testing. Conduct test team meetings to ensure business and IT testing expectations are met, and test deliverables are traceable to business requirements Partner with QA support teams, Business Areas, and IT to ensure testing goals, objectives, and expectations are effectively met across organizations Support the effort of creation of Master Test Plan, Detailed Test Plan, Test Cases and other testing deliverables in accordance with SDLC guidelines via manual and automated toolsets Perform extensive Backend Testing of data validation of applications using SQL queries. Executed SQL statements to check if the data integrity has been maintained. Work closely with the QA Organization in leading the development of Regression and Functional Test Cases to meet release and project deliverables Collaborate with software/systems personnel in application testing, such as unit, system, regression, load and acceptance testing methods Contribute to the establishment and adherence to quality assurance guidelines and standards as defined by the project and/or organization requesting testing services Prepare and Analyze test results to aid in problem solving and facilitate decision-making Environment: MS SharePoint, MTM, HP AGM, PL/SQL Developer, SQL Server 2015 Management Studio, Teradata WellCare Health Plans Inc, Tampa, FL Jan 2017 Nov 2017 Role: Business Technical Analyst Project description: WellCare Health Plans, Inc. provides managed care services exclusively for government-sponsored health care programs, focusing on Medicaid and Medicare. EWF (Encounter Workflow) project is implementation of Pega out of the box automated workflow to optimize the encounters resolution window for state rejection and internal withheld claims by WellCare. Develop reports to measure the productivity and performance of the workflow through Pega dashboards and other metrics. Roles and Responsibilities: Verify and validate that all fields in Pega are populated in front end and backend as per the requirement based on the Encounter Process. Participated in test planning, writing test cases/scripts with in PEGA DCO. Tested reports Pega out of the box functionality OOTB Involved in debugging application using Pega Tracer tool, performance testing using PAL tool Participated in test planning, writing test cases/scripts within PEGA PRPC and correcting the according Involved in writing and Executing SQL statements to test the Integrity between applications and database. Defects were tracked, reviewed, analyzed and compared using Quality Center. Analyzed EDI translation errors that failed in the inbound and re-processed the EDI's without losing the information. Created and maintained templates such as: Quality Strategy, Test Plans, Requirements, Traceability Matrix, Test Scripts, Test Calendars, Testing Issues, Project Sign-off and Test Reports Perform both front end and back-end testing Actively involved in developing test cases and coordinating functional and user acceptance testing. Involved in updating the QA process metrics every week which would track the project documents, and which will be used for generating the metrics for the project. Environment: MS SharePoint, HP ALM, HP AGM, PEGA, PL/SQL Developer, SQL Server 2014 Management Studio Health Plan Services (HPS), Tampa, FL. March 2014 to Jan 2017 Role: Sr.QA Analyst/EDI Analyst Project description: Health Plan Services (HPS) is the nation s largest independent provider of sales, Health insurance benefits administration. FFM\SBM Exchange: HPS currently offers both ON and OFF exchange enrollment and billing solutions to Major Carriers in health care industry for both FFM and SBM based exchanges for 2014, 2015, 2016 and 2017 open enrollments. Roles and Responsibilities: Writing Test plan, Test Strategy and Test Lead Activities. Reviewed case documents, Detailed Design Documents to complete test cases and test case coverage. Testing EDI transaction (EDI834 and EDI820) for different carriers. Worked on testing EDI 820 APTC and CSR payment file received from CMS and successfully tested both system and performance of all FFM carriers Involved in all the phases of SDLC Requirements/System Testing/Regression/Integration and UAT. Conducting review meeting with the team/BA/PM. Sizing the effort. Distributing the work. Writing DB2 queries to validate test data stored properly in the right tables and columns. Participated in daily scrum meetings as the agile methodology is followed and provided day to day burn down hours of QA and tasks progress for the different sprints Experience in generating status reports and defect report and conduct calls and co-ordination with the teams Experienced in System/Regression/Integration/UAT/Automation testing. Worked on implementation refund process form internal SLP portals. Experienced in creating/preparing End to End Dependency Plan and executing the end-to-end testing. Conducted and coordinated UAT with Focus business user and client UAT users and to get approval on timely manner Environment: Application Life Cycle Management (ALM)/Quality Center, IBM RQM, IBM Rational Manager, Rally, JIRA, Selenium, Load Runner, DB2, Oracle, DevOps, HTML, TOAD, VB Script, XML, CSS, Agile, WINSCP, Mainframe, Java, MS Office, SQL Navigator, EDI Notepad, SOAP UI Publix Super Markets, Lakeland, FL May 2012 to March2014 Role: Sr. QA Analyst Project description: McKesson a pharmacy-based application used in retail facilities for Processing Patient Rx(Prescription) in store and from different Interfaces, projects involve in customizing the Enterprise Rx (McKesson product) for Publix. Worked extensively in testing and maintenance of Third party (Rx Claims), Central Fill, Supply chain and workflow streams with Enterprise Rx application. Roles and Responsibilities: Involved in the proposal stage for understanding the requirements Reviewed business requirements for assigned testing projects and made recommendations for changes. Developed test cases and test scripts from business requirements and documented in Quality Center in accordance with QA standards and processes Created test data and set up test environment, wrote test cases, executed them and tracked Defects in Quality Center. Interacted with RBU Team and further modified the application based on the user requirements, recommendations Scheduled and facilitated test results reviews with RBU, BA s, and obtain business sign-off Performed Production validation where applicable post-deployment Provided status updates to QA Supervisor and attended Monthly Test case review Meetings Designed and developed Test plan, Test strategies, and Test Cases using Quality Center Constantly involved in review meetings and made sure testing is done based on the QA master plan and deadlines are met Took an active part in the Progress Meetings with the team on daily defects status by manipulating bug reports in Quality Center Worked close with the developers for unit testing the application Smoke tested the new builds for QA acceptance Used Quality Center for managing test execution and defect tracking of all issues Environment: SOAP, HTTP, SQL Server 2000, Quality Center, UNIX, SQL, Java, MS Office WellCare Health Plans Inc, Tampa, FL May 2010 May 2012 Role: Sr. QA Analyst Project description: GA HP Conversion: This project handles the changes required to move all data transfers from ACS processing environment to the new HPES environment. Worked on 834 inbound files, Monthly Claims Extracts, COB files, 837 Outbound files and Validation of the Outbound 837 files (SNIP Level) Validation through XEngine. Roles and Responsibilities: Prepared High Level End to End Use Cases and Individual Use Cases for each 5010 transactions. Involved in creating Test Cases for HIPAA 5010 standards. Prepared High Level Test Strategies for the 5010Compliance. Involved in the process of mapping, data migration, and training. Involved in writing and Executing SQL statements to test the Integrity between applications and database. Created migration scripts, performed data migration from old database, files into new system Defects were tracked, reviewed, analyzed and compared using Quality Center. Analyzed EDI translation errors that failed in the inbound and re-processed the EDI's without losing the information. Created and maintained templates such as: Quality Strategy, Test Plans, Requirements, Traceability Matrix, Test Scripts, Test Calendars, Testing Issues, Project Sign-off and Test Reports Reviewed EDI 837 claims and flagged HIPPA non-compliant claims received from the Payer side Perform both front end and back-end testing. Actively involved in developing test cases and coordinating functional and user acceptance testing. Experienced in using BizTalk and XEngine to validate the X12 files. Environment: MS SharePoint, BizTalk, XEngine6.5, SOAP UI, EDIFECS Transaction Manager, C#.Net, MS Office, Oracle 11i, SQL Server 2005, Quality Center10.0 and QTP. Serveen Software Systems, Hyderabad, India. Aug 2005 to July 2007 Role: QA Analyst Project description: Worked as a QA Engineer ITR-DRDO performance and regression testing team. The Testing team is responsible for doing manual testing and automation testing for different projects. Roles and Responsibilities: Involved and designed and executed Test plan and strategy, performed requirements verification, test plan walkthroughs, test case walkthroughs, test case creation, regression testing, functional testing integration testing, and defect creation. Analyzed the Functional Design documentation, User Requirements and Technical Requirements. Test Planning and bug tracking was done using Quality Center Analyzed end user performance results and determined which steps need performance optimization, required installation of diagnostics and working with Performance team. Work closely with the QA manager to plan, schedule, and execute the QA strategy. Created Test Cases for the Functional, Integration, End-to-End, Load, and Performance testing of the application ensuring that it meets all required specifications. Executing, Maintaining Test Scripts and Updating as and when the business rules change. Execution of Manual Test scripts and use Quality Center as repository for requirement analysis, design test cases and track and log the defects. Coordinated the testing, provided status to manager and business clients and trained new team members. Environment: Quality Center, QTP, Test Director, WinRunner, Windows, HTML, XML, J2EE, Apache, Oracle, SQL Server, SQL, PL/SQL Keywords: cprogramm cplusplus csharp quality analyst business analyst user interface message queue business intelligence database information technology hewlett packard fiveg fourg microsoft mississippi procedural language Colorado Florida Georgia Wisconsin