Information Technology Software Development

Aparna Bommineni

EXPERIENCE SUMMARY:

Over * years of Professional experience in Information Technology with extensive experience in performing manual, Data warehouse and automated testing of client- server and web applications for major companies worldwide.

Experienced in Design, Development and System Testing & Implementing product with zero defects.

Experience in working in white box, black box and gray box testing.

Excellent team player to work in conjunction with team of testers, developers and BA members in testing complex scenarios and projects and in the maintenance of Quality Standards in Projects.

Expertise in analyzing Business Specifications and develop Test Plans, Test Cases and Test Scripts and execute them.

Extensive experience in Unit, Functional, Integration, Regression, User Acceptance, System Testing.

Experience in writing Test Cases for ETL to compare Source and Target database systems.

Proficient in Manual, Database Testing and exposure to Automation Testing with ability to manage, record and play functions based on the automation needs.

Experienced in different phases of Software development Life cycle including Strategic Systems Planning Designing, Programming, Testing, Documentation, and Presentation to clients and preparing customer specifications as part of software technical requirements and Customer support

Good expertise in the review and documentation of system test plans, creating and executing test scripts, test cases and data sets on the basis of product release features requirements and technical documents

Experience in using Automation testing Tools Quick Test Professional (QTP), and Microsoft Visual Studio and TFS.

Ability to interact with developers and product analysts regarding Testing Status and Defect & Change Tracking using JIRA.

Extensive experience in bug tracking tools like JIRA and Quality Center.

Excellent logical and analytical abilities for understanding and developing system workflows, computing and verifying Software Metrics and well suited for communicating with both technical and non-technical professionals

Expert in Manual Testing and Automated Testing applications developed on windows Environment.

Good knowledge of identifying various test scenarios. Holds strong ability to handle multiple tasks and prioritize it.

Experienced in working with software development team in resolving defects, presenting the defect status reports, resolving requirement.

Execution of Manual Test Scripts and responsible to track and log the defects using Quality Center.

Strong analytical, communication & documentation skills.

Exceptional ability to quickly master new concepts, very co-operative team player, fluent communicational skills, and interpersonal skills, innovative and self-motivated.

TECHNICAL SKILLS:

Operating Systems : Windows 7, 98, 2000, XP, VISTA, UNIX

Testing Tools : Application Lifecycle Management, Quick Test Professional 10.0, Quality Center, JIRA, Confluence, TestRail

Databases : MS-SQL Server, Teradata, oracel

ETL Tools : Cognos 10, Informatica 9.1, SSIS

Languages : C, SQL, PL/SQL, SAS, XML, VB, Mainframes

Applications : Web Based, Client/Server

Miscellaneous : MS Outlook, MS-Office Suite and Visio.

Methodologies : Waterfall, Software Development Life Cycle (SDLC), Agile

Defect Tracking Tools : Bugzilla, Test Director, Quality Center

EDUCATION:

Bachelors of Engineering, Osmania University, India.

PROFESSIONAL EXPERIENCE:

Client: American Campus Communities Aug’17 – Present

Full Time Employment

Role: Senior Quality Assurance Engineer (ETL)

American Campus Communities is the nation's largest developer, owner and manager of high-quality student housing communities. Housing more than 128,000 students on more than 90 university campuses across the nation, ACC is dedicated to consistently providing every resident with an environment conducive to healthy living, personal growth, academic achievement, and professional success.

As a Quality Assurance Engineer, I am responsible to validate the data across multiple systems like Microsoft SQL server database, SSRS reports, Tableau dashboards, Cognos and Sales Force UI and Reports.

Responsibilities:

Responsible for Validating custom and complex SSRS reports.

Validation of ETL procedures and logics to ensure they abide to the complex business logics.

Working with development teams on architectural and business reviews to come up with a solution to represent data to high level management using Cognos and Tableau Dashboards.

Helped in validation and migration of the entire corporate UI from a home grown LAMS solution to a sales Force UI.

Migrated and validated all the SSRS reports to Sales force reports.

Managed all defects thru JIRA.

Performed all Build deployments and was single point contact for approving all QA.

Writing Regression Queries in SQL for simplifying the Validation flows and automating the data validation.

Very active proponent of daily stand-up meetings, reviews, retrospectives, sprint and release planning, demos, and other Scrum-related meetings, as well as ensuring to practice the core Agile principles of collaboration, prioritization, team accountability.

Collaborate and help develop improved processes, requirements and data solutions with both business owners, stakeholders and other development teams.

Working interactively with the ultimate end-users of the data to determine the problems they want to solve and jointly develop solutions that will integrate into the overall corporate model.

Client: CaptureRx, San Antonio, TX Nov’16 – June’17

Vendor: KForce

Role: Software Quality Assurance (SQA) Engineer

Founded in 2000, San Antonio-based CaptureRx is a leading 340B solution provider, which manages inventory and financial flow for 340B prescriptions filled at contract pharmacies and perform the eligibility checks required to comply with 340B program requirements. Using a process that’s seamless to the covered entity, pharmacy and patient, our Cumulus platform has processed more than 183 million patient encounters and more than 647 million switch claims. Currently, CaptureRx solutions serve more than 500 hospitals and health centers in 45 states via a robust pharmacy network and a preferred 340B partnership allowing access to any Rite Aid pharmacy.

Responsibilities:

Using Test Rail to create test plans and Test runs (integration, functional, security, performance and regression)

Consulted for an Electronic Data Interchange (EDI) upgrade to a medical data system

Talking to Business Analysts to understand the requirements and coming up with the test strategies

Writing Store Procedures in Microsoft SQL server management studio for simplifying the flows.

Executed complex back end logic test cases, setup test data and wrote SQL queries

Scheduling daily SSIS jobs and making sure they run and the daily data is captured in appropriate tables

Created Test Cases and scenarios for Unit, Regression, Integration as well as Back –end and System testing.

User Interface Testing the front end interface that is accessible by Pharmacy users.

Bug Tracking and reporting in JIRA

Documenting the best known methods in Confluence.

Interacted with developers, users and management to speed up the defect resolution.

Validate and test the following reports that are sent to Third Party Administrators (TPA/PBM): Replenishments, Invoices, Reversals, Remediation.

Understand the concepts for Claims (B1), Claim reversals(B2), Claim Approvals, Rejections and to populate a new table for Pending balance for each specific accounts.

Environment: Microsoft SQL Server, JIRA, Confluence, Test Rail, SSIS, UNIX, Microsoft Office Suite 2010, Windows 7, MS Outlook.

Client: UNITED HEALTH GROUP, Eden Prairie, MN Jun’14 – Sep’16

Role: ETL QA Analyst

United Health Care is the leading single largest health care provider in the US. STARS Management program is aimed at improving Medicare Star Ratings. Medicare Star Ratings is a government pay –for-performance program for Medicare Advantage and Part D prescription drug plans. The centers for Medicare & Medicaid Services ( CMS ) uses Star Ratings as an indicator of how well we serve Medicare beneficiaries, especially by improving health outcomes and closing gaps in care. Higher Star Ratings provide greater reimbursement from CMS, which allows United Health Care to offer innovative solutions and better benefits for consumers who purchase Medicare health and prescription drug plans.

Responsibilities:

Setup Testing Suite for the project.

Create and maintain folder structure in ALM ( Application Lifecycle Management ).

Participated in talent acquisition and resource management on the QA team

Created Test Plan and Test Strategy documents for the project.

Written Test Cases for ETL to compare Source and Target database systems.

Responsible for training the project team and Users on required tools.

Worked with the Subject Matter Experts to understand and analyze impacts of various data acquisitions.

Responsible for reviewing Use cases with the Business Analysts and align the test scenarios accordingly.

Reviewed Test Cases prepared by other QA team members.

Created the reporting module in ALM to reflect test progress, defect tracking etc.

Created test scripts for database and report testing.

Validated the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.

Performed cubes validation for reporting based on the technical specifications document.

Reviewed test scripts ( SQL ) and assisted the team on test script tuning.

Co-ordinated testing activities between onsite and offshore teams for handshakes on a day to day basis.

Conducted Defect Triage calls to review and track down defects for each release.

Responsible for leading efforts on UAT and to coordinate between the Users and the Design / Development teams on issues during UAT.

Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.

Responsible for creating and maintaining QA documents on SharePoint for the project.

Facilitate QA meetings with the business and source owners to mitigate risks and resolve issues.

Organize daily triage calls with the testing team and the development teams to facilitate progress review, defect discussion and issue resolutions.

Facilitated UAT readiness meetings and Production readiness meeting to mitigate issues and outline defect deferral process to facilitate progress.

Environment: Informatica 9.1, SSIS, Teradata TD 12, SQL Server 2008, Cognos 10, Flat Files, Teradata SQL Assistant, TOAD, SQL, PL/SQL, HP Application Lifecycle Management ( ALM 11 ), QTP, UNIX, Microsoft Office Suite 2010, Windows 7, MS Outlook.

Contact this candidate