Ashwani Yerram

ASHWANI YERRAM MAYTAS HILL COUNTY Bachupally, Hyderabad-:-PROFESSIONAL SUMMARY: Vast Software Quality Assurance experience in Application Software Testing (Manual and Automated) in Database, Web Technologies, Client/Server Architecture and Data Warehouse. Seasoned Software QA Lead / Manager and development experience with emphasis in testing design, architecture and Professional with in depth understanding of all phases of SDLC, focusing on translating business requirements into viable technical solutions. Analysis and implementation of test efforts for large-scale development projects in various environments. Solid personal and organizational skills, ability to handle multiple parallel tasks. History of building QA teams from the ground up, with proven ability to manage through periods of both intense growth and downsizing. QA, release management and operations support Excellent technical writing skills with hands on experience creating Business Requirements, Functional Specifications, Mapping Documents, E-R Diagrams, Test Plans, Test Scripts and Status Reports Experience leading medium sized Teams spread across multiple time zones and countries Expertise in Process Management using Quality Center, Clear Quest and PVCS to document Test Cases and conduct triage meetings to resolve issues Experience working with huge volumes of data, analyzing record sets for Data Quality, Data Validation and Metrics using SQL and / or PL/SQL Proficiency in customization & implementation of ETL processes and Web applications Proven ability to coordinate medium sized project from initial conceptualization through implementation Experience working with various software development methodologies including Agile, Iterative and Waterfall Excellent knowledge in Sybase, DB2 and Oracle Database Systems and Unix Platform Expertise in performing different types of testing like System, Integration, White Box, Black Box, UAT, Regression, Performance testing and Mobile Testing. Experience in testing web applications which are developed using .Net, JAVA ASP, XML, HTML, VB Scripts and Java Scripts. Strong communication and interpersonal skills to maintain effective work relationships with all levels of personnel. Clear understanding of business rules and ability to work individually and as a part of team. Proven communication, presentation skills and Leadership Qualities PROFESSIONAL CAPABILITIES: Testing Tools: Win Runner, Quick TestPro Bug Tracking Systems: Quality Center, Test Director, Clear Quest, and PVCS RDBMS: Oracle 9i/8.0/7.x, MS-SQL Server 2005/2000 7.0/6.5/, Rapid SQL, Sybase ETL: Informatica (Power Mart 7.1/6.1/5.1/4.7, Power Center8.6) Languages: .NET (VB.NET, ASP.NET) VB, ASP, JAVA, SQL, PLSQL, MySQL, PHP, C, HTML, XHTML, DHTML and XML Scripting Languages: UNIX Shell Script, VB Script, JavaScript Mainframe Tools: Rumba, RWOE, FDOT DB Client Tools: TOAD, Query Analyzer. SQLYog, SSMS, SSIS, SSRS Operating Systems: Windows 2000, NT/98/95, UNIX, and MS DOS 6.22 Specialties: QA testing (mobile devices, mobile applications, mobile network servers, regression, Agile), test plan creation, IT troubleshooting. Mobile platforms: Android, iOS, Windows Mobile, IPAD PROFESSIONAL POSITIONS: 03/2015 - Present: Associate Test Lead, Prolifics (McKesson Client), Hyderabad Responsible for training / managing a team, planning activities, creating documents (Test Strategy / Test Plan / Test Model / Risk Assessment / QA Certification) per the Client Business Process, Traceability Matrix and Standard Template (Daily status, defect status, defect process etc.,) Coordinating with Onsite Delivery Manager in reviewing the day to day activities. Environment: SharePoint, SQL server, SSRS, SSIS, HPALM, BA360 tool. 08/2013 - 11/2014 Lead / Manager – QA Engineer, Cartera Commerce, Lexington, MA, USA Responsible for managing offshore team (EPAM QA), creating of project plan, defining QA tasks to be done and estimating times for those tasks. Deployed build into QA environment using Tortoise SVN for subversion and checkout Test scripts. All the Bugs that came up during testing process were reported through JIRA bug reporting tool. Participated and managed the reviews and defect report meetings. Analyze and identify the root cause of bugs by reviewing log files, Database tables etc., closely interacted with Business teams and Developers to understand business requirements and bug fixes. Worked with SAOP UI to test some of the WSDLS and web services. Validating API using JUnit, JMeter and TestNGgraphics software. Special emphasis was placed on Adobe graphics programming. Environment: Php, Java, MySQL, UNIX/Linux, Test rail, Jira, Svn (subversion), Env Configurator, Jira, Zephyr 07/2011 - 07/2013 Sr. QA Engineer / Lead, Fidelity Investments (FAX), Boston, MA, USA Successfully managed multiple projects simultaneously from planning to release in various phases of SDLC using waterfall and SCRUM methodologies and delivered products on schedule without compromising the quality. Lead offshore QA team (Bangalore). Hired onshore and offshore members and mentored, and led highly functioning and productive team. Involved in end to end testing of 34 Corporate Action Election-able event types functionality, Notification & Response module functionality which is a portion of the corporate action full event management lifecycle by creating Notifications for eligible Corporate Actions using pre-defined templates. Validation of Responses sending to Custodians via different communication methods; SWIFT messages MT 564 / 565 / 567 / 568 / FAX/ Email. Created SQL queries and UNIX Shell Scripts to verify complex business rules and ensure that all business requirements are met. Environment: Java, C++, Quality Center (10.0), UNIX, Oracle, TOAD (10) Mobile platforms: Android, iOS, Windows Mobile, IPAD 12/2007 - 06/2011 Sr.QA Engineer, Fidelity Investments (CWE / PWI GRP) Marlborough, USA Verify the implemented ETL code against the corresponding mapping document. Confirm the data loads from source files into the target tables. Work with business partners, analysts, developers and project managers to develop test plans, produce test scenarios and repeatable test cases/scripts through all parts of the development lifecycle, execute and sign-off for a high volume of data and regular release schedule for successful project delivery. Validated DataMart’s and Data Applications. Analyzed the data mapping and developed scenarios to verify the data migration from different data sources. Analyzed raw data to ensure the data will meet the business need. Worked with the business owner to identify key data elements that will be monitored on an on-going basis to ensure a high level of data quality within the Warehouse. Analyze data using SQL/ TSQL, Excel, Unix and data testing tools. Execute workflows / scripts on Informatica Server & UNIX box. Attended SDS and TSD review meetings and provided input to the project team. Provide technical guidance to UAT. Coordinating between multiple teams for End to End and integration testing. Lead offshore QA team Environment: Quality Center (9.0/10.0), Clear Quest, UNIX, Oracle, AQT (Advanced Query Tool), Informatica Power Centre (8.6), TOAD (8.5) 11/2005 - 11/2007 QA Engineer, Fidelity Investments (FFOS) Boston, USA Mock trading using RWOE (Retail Web Order Entry) Validated and Verified 43 kinds of reports for Family Office Service viz., Fixed Income Detail Report, Corporate Actions Report, Dividend & Interest, Transaction History. Developed SQL Queries using Rapid SQL to validate business rules & requirements. Involved in database comparisons between Oracle and Sybase using Advance Query Tool (AQT). Set up accounts for QA using Mosiki Account Data Gathering Tool. Involved in validating various financial calculation in reports. Involved in testing all functions in Entitlements Administration Tool. Validated trading details using Mosiki Query Tool and DSTi. Coordinating between multiple teams for E2E and integration testing. Generated reports and metrics to provide project status. Environment: Quality Center (9.0), Clear Quest, QTP (9.0), UNIX, Oracle, Sybase, Rumba, FDOT, RWOE, Actionsxchange, FFOS Workstation, DSTi, Entitlements Administration Tool, Mosiki Query Tool, Mosiki Account Data Gathering Tool, AQT (Advanced Query Tool), AISA tool (Alternative Investment Self Administration Tool) EDUCATIONAL BACKGROUND Masters of Business Administration from India.