Aparna Devarakonda

Project: CA OTC, MI2 -: .Net, Java, SQL Server, PostgresSQL

• Established QA department from ground up: began as sole manual tester, implemented Automation and grew team overtime
• Introduced Automated Testing frameworks and CI/CD test integration
• Recommend new tools, techniques and methodologies needed to enhance productivity and quality
• Create, and implement organization goals for the QA team
• Implemented formal QA process in Agile Scrum Methodology
• Collaborate with product teams to strategize and align long term solutions for test automation including roadmap, tools, framework & approach
• 
  
• Understand planning and building of automated tests scenarios
• Successfully implemented Test Rail for documenting and executing test cases
• Automated Smoke Test Suite through Selenium Automation Framework

Project: Residuals 2 -.NET, Java, PostgreSQL

• Manage team of 5 QA members including resourcing and budgeting
• Responsible for overall Test coordination with Onshore and Offshore teams
• Review test plans, test cases, test scripts, test results, conduct test plan walkthrough and test schedule
• Responsible for sending Weekly Test Status/Metrics to the management and Project Teams
• Participate in DSU, update status and demo Test Results with product teams

Project: ALS, MSP, ETL –iShare, IRDX, Reps and Warrants – CLAIMS, PSG
Environment: Mainframes, ASP.Net, ORACLE, iSeries, CITRIX, DataStage, SQL Server 2008, Java Script and Windows – XP, iSeries

• Implemented formal QA processes in line with Bank Policies and standards for ALS
• Train the new resources on QA process and Audit requirements to meet the Bank Standards
• Responsible for sending the status reports to the management including project Status, Achievements, Roadblocks and Challenges
• Deliver 100% of all projects on time and on budget with 0 production defects
• Escalate the issues/defects to management and send the Project Status report on daily basis
• Responsible for Data Conversion Test Plan, Test Scripts, Validations including identifying Automation Test Scripts
• Coordinate with offshore and onshore teams
• Identifying Test Data and write complex SQL queries for validation
• Review test plans, test cases, test scripts, test results, conduct test plan walkthrough and test schedule
• Run test cases and submit defect reports in ALM
• Verify fixes and run regression tests.

Project: Reverse Mortgage Application Rev Star: C#, SQL Server 2005, Db2, Crystal Reports, Java Script and Windows

• Create Functional Specification from given Business Requirements
• Write test plans, test cases, test scripts, conduct test plan review and test schedule
• Run test cases and submit defect reports
• Verify fixes and run regression tests
• Extensively used MS Excel during testing phase
• Optimized QTP scripts for Regression testing of application with various data sources and data types
• Mapped custom objects to standard objects where necessary, and inserted GUI, Bitmap and Text checkpoints where needed, to compare current behavior of application being tested to its behavior in earlier version using Quick Test Pro (QTP)
• Parameterize fixed values in checkpoint statements, created data tables for parameters and write functions for parameters to read new data from table upon each iteration – Performed Data-driven testing
• Using VB scripting to develop QTP scripts
• Using HP Quality Center to create, maintain and close defects
• Performing Functional, GUI, Regression, System Integration, User Acceptance, Configuration and content testing