Manager Project

ANAND MAMILLA

Phone: 402-***-**** Email: *******.*******@*****.***

SUMMARY OF QUALIFICATIONS

7+ years of professional experience in Business Analysis and Software Quality Assurance.

Involved in different stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

Worked as Scrum Master and helped in managing multiple Project Teams and successfully delivered User stories on Sprint basis and delivered Products on time to Clients.

Experienced in JIRA, Sprint Planning, Daily Stand-up, Release planning, Demos, Retrospectives and other Scrum-related meetings.

Experience in Business requirements gathering, preparing documentation, developing test plan, defining business priorities and analyzing risks.

Skilled in Agile, Waterfall, SDLC, Scrum ceremonies, User stories, JAD sessions, BRD, Functional, Content Specifications, Test scenarios, Regression Testing, Functional Testing, UAT and maintaining Requirement Traceability Matrices.

Proficient in Test Planning, Requirements Management and Defect Tracking and Reporting.

Managed multiple Project testing and successfully delivered User stories on Sprint basis and delivered Products on time to Clients.

Strong business understanding of Pharmacy, Healthcare, Insurance and Automotive domains.

Experience in testing Data Warehouse ETL tools like Informatica.

Experience in data/database testing using Oracle, SQL Server and Toad.

Strong knowledge on Automation tools like QTP, QC, Rational Functional Tester.

Experience in testing 508 Compliance using tools like NVDA and JAWS.

Strong knowledge in reporting tools like Business objects (Crystal Reports/Xcelsius).

Experience in Backend Testing using SQL and UNIX.

Experience in testing Oracle, XML, Java, VB and Web based applications.

Hands on experience in IBM –Mainframe Application and Windows environment.

Experienced in working with Business Analysts, Development groups in analyzing business specifications and in working with other testers to resolve technical and end-user issues.

Self-starter and ability to adapt and learn new things quickly.

Excellent understanding of documentation in testing environment.

Capable of working independently and/or as a part of the team with excellent inter-personal and communication skills in client interface and user training.

TECHNICAL SKILLS

Testing/Management Tools: JIRA, Perfecto, Rational Functional Tester, Quality center, QTP

Languages: PL/SQL, SQL, VB Script

Databases: Oracle, TOAD, SQL Server, DB2

Bug Tracking Tools: IBM Rational Clear Quest, HP Service Manager

GUI Tools: Visual Basic 5.0/6.0, SoapUI, WinSCP

Reporting Tools: Business objects (Crystal Reports/Xcelsius)

Data Warehouse: Informatica Power Center 8.6.1

Screen readers: NVDA, JAWS

PROFESSIONAL EXPERIENCE

IHS Markit, Southfield, Mi Aug 2018 –Till date

Sr. Technical BA/Test Lead

Project: Recall Rewrite

Responsibilities:

Collaborated with the product owner to analyze and understand Business requirements

Gathered User, Functional and Non-Functional requirements and translated the requirements into User Stories for Scrum process using JIRA.

Generated Business Requirement documents (BRD), Functional Specification design documents (FSD) and Functional Requirement Documents (FRD)

Led Scrum meetings with development team to review Functional specification and design the system

Developed Process Flow Diagram/Activity Diagrams, Test Cases, Use Cases and performed Functionality testing and Regression testing

Worked on creating business process flow and data flow diagrams using Visio

Creating Epics, Releases and story cards in JIRA based on the requirements

Creating Technical tasks to Development team and making sure the tasks are completed on sprint basis.

Assisted the Product owner in documenting the UAT scenarios.

Lead offshore testing team to perform system functional testing.

Performed test and pre-prod deployments with new code and database changes.

Setup data for different OEMs and test scenarios.

Collaborated with the testing team in understanding user stories.

Participate in Requirement & Design document review session; evaluate requirements & design docs from a quality test automation standpoint.

Involved in planning meeting to discuss the effort estimations and discuss to have clear understanding of the user stories.

Analyzed, documented issues and performed root cause analysis and worked with the Development team to resolve the outstanding issues.

Performed extensive data analysis using SQL Developer and worked with Data factory and Data Source team in resolving data issue between new and old systems.

Review Test scenarios and Test plans meeting with QA Team.

Performed Unit Testing and System Integration Testing with QA Team.

Documented lessons learned during the sprints in Retrospective meetings and found solutions.

Participating the daily stand-up meetings and Defect triage meetings

Participate Work Group Activities.

Take the lead in identifying and resolving Issues.

Provide Daily and weekly status report to leadership.

Environment: Unix, Windows, SQL Developer, SQL, PL/SQL, Oracle, XML, Java, HTML, JIRA, Visio, Putty, JDK, FileZilla, Jenkins, SharePoint, MS Office

DaVita, El Segundo, CA March 2018 –Aug 2018

Sr. Technical BA/Scrum Master/UAT Coordinator

Project: National MRA/RAF

Responsibilities:

Involved in discussion with the Business team to understand the business requirements and converting them to Business Requirements documents and Technical Design documents.

Gathering requirements, preparing documentation, defining business priorities, analyzing risks and managed the Agile/Scrum process.

Involved in planning meeting to discuss the effort estimations and discuss to have clear understanding of the user stories.

Created and managed product and sprint backlogs via planning, grooming, feature prioritization and story acceptance; created and managed technical user stories in JIRA.

Managed changes to base-lined requirements via application of change control process and tools.

Developed Process Flow Diagram/Activity Diagrams, Test Cases, Use Cases and performed Functionality testing and Regression testing.

Led Scrum meetings with development and testing team to review technical specification and design the ETL process.

Worked on creating business process flow diagrams, data flow diagrams using Visio.

Created mockups to illustrate and verify the business process and requirement with business stakeholders.

Develop and maintain dashboards, requirements gathering and documentation of processes.

Enhanced the over-all architecture for the project with ETL framework contribution.

Designed High level document (HLD) for ETL mappings/session/workflows.

Assisted ETL developers in development of Mapping, Mapplets, Sessions, tasks and Workflows.

Extensively used SQL queries for data analysis, validation and backend testing.

Validating the data files from source to make sure correct data has been captured to be loaded to target tables.

Written complex SQL queries, stored procedures to compare Source and Target database systems.

Creating UAT scenarios and developing test scripts to run SQL queries against Oracle database as source, MS SQL server 2010 as target database.

Support for QA & UAT testing.

Used ALM 11.00 to track the test cases, testing status and defects and update the project status.

Experience working as an Onsite UAT coordinator with offshore Business and Testing teams.

Environment: Oracle, SQL Server 2010, Informatica Power Center, Toad, JIRA, Confluence, SQL, PL/SQL, HP ALM/QC, IBM Clear Quest, Source Tree, Bit Bucket, WINSCP, SOAP UI, Visio, MS Office

Blue Cross Blue Shield of Michigan, Detroit MI Jan 2017 –Feb 2018

Scrum Master/BA/Test Lead

Project: Member Portal Inflight Projects- Desktop & Mobile app

Responsibilities:

Working with the Product owners and prioritizing the user stories for the sprints in a release.

Facilitate Grooming, Story Card sizing and Review sessions with Business and Technical Team and work closely with team members to accommodate updates and improvements.

Coordinating with the Product owner, Business Analyst to have better understanding of the user stories and documenting the UAT scenarios.

Address any issues with Story cards, Design, Content and any clarifications/gaps from the technical team addressed and make it available before sprint start date.

Identifying the Scope of Testing for a Release by coordinating with the relevant stakeholders and delegation of work to team members.

Preparing test data for SIT, QA, UAT, Consistency, E2E, Performance and security testing.

Involved in planning meeting to discuss the effort estimations.

Participating the daily stand-up meetings and Defect triage meetings.

Working with cross-functional teams for End-to-End testing.

Coordinating with the delivery team and discussing the testing progress and roadblocks on a daily basis.

Represented test team during demo and retrospective meetings.

Participate in Requirement & Design document review session; evaluate requirements & design docs from a quality test automation standpoint.

Assist the testers with Test scenarios, Regression, Functional and User Acceptance testing, Data preparation, and Sprint demo to Business for acceptance.

Assist automation tester to create scripts and run automation testing for monthly prod releases.

Manage projects independently and as a part of the team with internal and external stakeholders.

Documented lessons learned during the sprints in Retrospective meetings and found solutions.

Performed functional, Regression testing, UAT testing on both Desktop Responsive web and Mobile Application on IOS and Android devices, and using perfecto.

Performed and assisted in 508 Compliance testing using tools like NVDA and JAWS.

Conducting Risk Analysis and doing Mitigation plan to handle the risk.

Training new resources with QA and business processes and assist them with technical issues.

Testing web services using SOAPUI tool.

Environment: JIRA, SQL, PL/SQL, Oracle, Toad, XML, Java, HTML, Mainframe, JIRA, Perfecto, IBM RFT, IBM Clear Quest, HP Service Manager, WINSCP, SOAP UI, DB2, NASCO Systems, MS Office

Blue Cross Blue Shield of Michigan, Detroit MI Oct 2016 –Dec 2016

Test Lead/SME

Project: New Member Portal Testing

New Member Portal: The main purpose of member portal is to provide transparency, clear and simple customer experience. New Member Portal – is a new site which combines 3 different portals (BCBSM, BCN and IKA) which Allow members to view their coverage, claims information and Explanation of Benefits, Benefits, Copay information for different plans under single login which will give transparency to member and allow them to take health assessments, which will reduce premiums.

Health Care Benefits Online: The main purpose of Group Portal is to provide transparency to the Group representatives and have better customer experience. HCBO allow Group representatives to perform Member maintenance. HCBO is used to add/update all groups in Michigan with BCBSM coverage.

Responsibilities:

Defined and participated in the Test strategies and associated test scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality.

Lead and conduct walk through meetings to review Test Strategy, Estimations with stake holders.

Analyze business and system requirements, manage development of specifications to create and execute detailed test plans, writing test cases, reviewing the stories for each requirement, and collecting the data for each story from database.

Review test cases/scripts with QA manager and project team to make sure all the scenarios are covered (positive and negative).

Assessed testing environments and worked with project manager and developers to outline test systems and data needed.

Work closely with other members of the Development Team and Business to review the designs of the system, implement test plans, and test the quality of software products and effectively managed Off-Shore team.

Responsible to help team on creating test cases to make sure the data originating from source is making into target properly in the right format.

Coordinating Functional testing, Integration testing, UAT and Regression testing.

Assisted UAT walk-through, with all stakeholders for the final sign off before Go-Live.

Strong knowledge on Member Cost Share, claims, and enrollment/eligibility.

Worked in Member Online portal includes member's Eligibility, Coverage, Claims, EEOB, Wellness and Benefit documents.

Executed test cases and for manual testing. Defects are raised in the JIRA and Rational Clear Quest for logging, tracking and reporting bugs in the application.

Identified various scenarios for functional and integration testing.

Involved in Backend Database testing in oracle using SQL.

Solid Back End Testing experience by writing and executing SQL Queries.

Validated the SOAP output backend results by writing SQL queries and executing them in TOAD.

Working with Web Services using SOAPUI, rest and XML, return output in the form of a valid JSON.

Strong understanding of the Agile Software Development Life Cycle Methodologies

Responsible for resource planning, assigning tasks, monitoring and coordinating with team to discuss on the status for current and future tasks.

Assigning of task to team members based on the test plan.

Conducting daily call with team members to check the status of each assigned task daily.

Ensure each team member is optimally occupied with work.

Conducting daily defect triage calls with stake holders to discuss on issues and dependencies.

Act as a single point of contact between development and testers for iterations, testing and deployment activities.

Preparation of daily and weekly status reports and circulating end of the day to all the project participants.

Communicating with Tech Leads, BA's and project manager regularly and ensuring project deliverables are on track.

Environment: Unix, Windows, JIRA, SQL, PL/SQL, Oracle, Toad, XML, Java, HTML, Mainframe, JIRA, IBM Clear Quest, HP Service Manager, RFT, WINSCP, SOAP UI, DB2, NASCO Systems, MS Office

Blue Cross Blue Shield of Michigan, Detroit MI Jan 2015 –Oct 2016

Sr. Business System Analyst/SME

Project: Digital Experience Base Production Support

Responsibilities:

Work closely with Customer (Marketing & Help Desk) to understand the requirements of user.

Gathered High Level Requirements and documented them in PDM (Project Data Manager – Mainframe) and conducted business walkthrough of the requirements.

Work closely with Business to create/finalize new requirements.

Conducted HLR walkthrough with technical to explain the requirements.

Working in as Production support team to review logs and determine the root cause of issue.

Conduct Super Triage meeting – to go through high Severity issues and their resolution.

Creating JIRA stories based on Business requirements, and providing demo to Business and Dev team.

Ran SAML Request/Response using Mid-Tier application to determine root cause of service issues.

Tested all CSR (Change Service Request) in the migration of Group Portal.

IT Owner/ Administrator of HCBO (Michigan) portal– which is used to allow Group Representatives to view their employee’s Benefit information for all NASCO groups.

Providing HCBO access to HR Reps to update the members information in their group

Triage the HCBO Portal issues, and create tickets to NASCO.

Performing monthly Interact tool/HCBO production regression and validating all the issues/CSRs in Model office

Triaging and Resolving HCBO/Interact Customer inquiries.

Worked with IMS and provided support to IMS Provider Search tool for BCBSM.

Performing IMS Provider Search tool UAT and Production health checks.

Load New Groups and updating existing groups in HCBO Model office, Production.

Loading yearly Benefits to Member Benefit Application for all NASCO groups in Michigan

Analyzed Software and Business Requirements documents to get a better understanding of the system from both technical and business perspectives.

Prepared and executed test plan, test scripts and test case documents for UAT, based on functional and technical specifications

Performing automation using RFT, manual regression testing and providing approvals for monthly QA and Production deployments.

Providing Test data for SIT, QA and UAT testing, as per the requirements.

Responsible for creating Test scenarios and developed Test Matrix for various scenarios.

Validated different feeds in the mainframe application and verified the actual results in the database.

Performed Negative, Positive, Regression, Functional and UAT testing.

Used Clear Quest, Service Manager and JIRA for maintaining and reporting the defects

Worked closely with App Development team and prioritized bugs according to severity level described.

Identify the gaps in the business requirements and get Business team alignment.

Perform daily/monthly Production validation and publishing dashboard to Project Director and Leadership.

Daily/Weekly meeting with the management team and share the Status Report on the daily/weekly basis.

Interact with clients for Quality Assurance discussions and responsible for the QA deliverables.

Environment: Mainframe, JIRA, IBM Clear Quest, HP Service Manager, RFT, WINSCP, SOAP UI, DB2, Oracle, Toad, XML, Java, NASCO Systems, Adobe CQ (Content Management), Microsoft Office

Blue Cross Blue Shield of Michigan, Detroit MI June 2013 –Dec 2014

Sr. QA Analyst

Project: Health Care Reforms & Federally Facilitated Marketplace

Health Care Reforms (IBU Project): Health Care Reforms is a web based Application that requires significant changes to IBU business processes. A consumer, after reviewing and evaluating the various plan options is prepared to make their purchasing decision. The consumer enters our website to apply. As the consumer completes the application, key real-time field level data input edits are performed and the user is prompted by the system for correction. Once the application is complete and all consumer responses meet the required data validation and logical edits, the consumer can submit their application for processing. The system will review the application and if the application meets all criteria it is accepted and pushed through the automated enrollment process.

Federally Facilitated Marketplace (FFM): In the direct enrollment process model, the consumer will be redirected to the (FFM) Federally Facilitated Marketplace website to complete their eligibility application. Upon receiving an eligibility determination, the consumer would be transferred back to the partner website to continue plan shopping and selection for individuals eligible for a QHP, with or without financial assistance.

Responsibilities:

Involving in preparing the project test plan for every release

Defining the testing scope for the Direct Enrolment release

Planning, Managing & Executing the testing effort

Conducting the daily touch point meetings with stakeholders to discuss the status of the project

Task allocation validating the results, review of deliverables, status tracking, UAT co-ordination

Preparation, Review, Execution of Test cases, report defects and conduct Defect Triage calls

Responsible for delivering Detailed Test Plan, Test Strategy and Estimates

Understanding & Involving in requirements gathering, change in requirements

Conducting the knowledge sharing sessions to team

Develop, Review the test scenarios and test cases for all the business requirements

Ensure complete coverage for functional and non-functional requirements

Managing Clear Quest for all test management activities and Uploading all reviewed test cases & defects management

Consolidating the daily status reports, review and circulating to client managers

Prepare the test metrics dashboard at the end of a phase or at the completion of every release

Review various reports prepared by Test engineers & Provide directions to the team member

Ensure the timely delivery of various testing milestones for the projects involved

Ensure every team member have sufficient work in the project

Environment: Java, IBM Rational Clear Quest, QTP, Oracle, Access Database, NASCO Systems, Mainframes, VB scripting, EDI ANSI X12 834 xml Files, Windows 2007, Microsoft Excel, Visio, IBM Clear Quest, HP Service Manager

Blue Cross Blue Shield of Michigan, Detroit MI Sep 2012-May 2013

ETL Test Specialist

Project: Information Management Data Validation

Responsibilities:

Preparing Test Strategy, Test Plans, Test Scripts and Test cases for SIT, UAT, Performance and Regression testing.

Analyzing and approving the Unit Test Results.

Performed Integration, System, ETL, Performance and Regression Testing.

Involved in analyzing System specifications, design, development and execution of test plans and test Cases.

Involved in preparing the Test case planning matrix and Defect report

Involved with the UAT testing team.

Worked with Pharmacy claims, Medical claims, Data feeds, Membership.

Written modification requests for the defects in the application.

Validating the source to target mapping and executing the jobs in Tivoli.

Coordinated and worked closely with legal, clients, third-party vendors, architects, DBA’s, operations and business units to build and deploy.

Executed Informatica sessions using Informatica

Performed ETL backend testing to validate the data.

Validating the Data in source and target by using SQL queries.

Used Rational Clear Quest to track and report system defects fixes.

Investigated software bugs and interfaced with developers to resolve technical issues

Involved in preparing Test Metrics, developing Traceability Matrix, update weekly status to the Project manager.

Environment: Informatica Power Center 8.6.1, SQL Server 2008, IBM Rational Clear Quest, Oracle 10g, TOAD, Tivoli, MS Access, Windows XP, Windows 7

Blue Cross Blue Shield of Michigan, Detroit MI May 2011-Aug 2012

ETL Test Specialist

Project: ICD-10 Remediation & Logic Changes

Responsibilities:

Gathering requirements, preparing documentation, defining business priorities and analyzing risks.

Consult with business staff to develop understanding of the varied and complex business needs supported by the system.

Experience in Data Analysis, Data Validation, Data Verification and identifying data mismatch.

Extensively executed Extraction Transformation and loading using SQL Queries on tables to test the hard-coded ICD-9 logic to ICD-10 logic and verified the logic changes.

Involved in Testing ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and stage tables to target tables.

Interacted with end users to obtain specific system requirements and for User Acceptance Tests (UAT).

Participated in weekly status meetings to discuss the status of the project, review meetings to discuss the bottlenecks and its resolutions.

Managed test cases development and execution.

Developed and Tested DTS Packages and Stored Procedures as part of the ETL process, automate the process of loading, pulling the data.

Extensively executed DTS Packages to test ICD-10 field expansion and logic changes.

Tested the ETL process for both before data validation and after data validation process.

Involved in Testing for multiple interface points of Customer Health Accounts.

Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables.

Written Test Plans, Test Scripts, Test cases and Test Execution using Quality Center.

Performed database testing by writing SQL queries.

Identifying duplicate records in the staging area before data gets processed.

Executed tests in appropriate test regions in support of unit, integration, functional, and regression testing

Defects identified in testing environment where communicated to the developers using defect tracking tool.

Documented and reported the bugs through Quality Center.

Worked with Data warehouse developers who extensively used SQL Server and Informatica, ETL tool to move data from source to target database.

Environment: SQL Server 2000/2008, Informatica Power Center 8.6.1, IBM Mainframes, IBM Rational Clear Quest, DB2, Oracle 10g, TOAD, MS Access, MS Visual Basic 6.5, Windows XP, Windows 7.

EDUCATION

Master of Science in Electrical Engineering from Western Michigan University (2011)

Bachelor of Technology in Electronics and Communications from Jawaharlal Nehru Technological University (2008)

Contact this candidate