SUMMARY

Extensive IT experience in Software Quality Assurance (SQA) and Testing of Client/Server, GUI and Web-based applications with expertise in Manual and Automation Testing, System Testing including Integration and Regression Testing in Government, Telecom and Financial industries business applications on Windows/Unix based Platforms.

• Excellent knowledge and implementing skills in complete Software Development Life Cycle (SDLC) using Agile methodology.
• Experienced in manual testing with the focus on Functional Testing, Regression Testing, Smoke Testing, Load Testing and System Testing.
• Experience in working with analysts, developers, and testers for complex projects during the full Software Development Life Cycle (SDLC).
• Expertise in creating Test Plans and executing Test Cases/Test Scripts.
• Testing Client/Server and Web-based applications and performing Manual Testing.
• Proficient in working on Windows and knowledge of UNIX environments.
• Prepared and documented Test Cases and Test Scenarios for both Manual and Automated testing.
• Experience in conducting Black box, White Box, Integration, System, Functional, Regression, GUI Testing and UAT and Database Testing.
• Extensive use of defect tracking tools HP Quality Center, ClearQuest.
• Experience in performing back-end testing using T-SQL, PL/SQL and SQL Queries.
• Extensive experience with testing Multi-Tier application architecture.
• Expertise in Functional, Integration , end-to-end and UAT testing.

Operating Systems : Windows, UNIX
Languages : Java, C++, C, PL /SQL, VB.net, C#, VB Script, javascript,
Unix Shell scripting
Database : Oracle 10g, SQL server 2005/2008 R2.
Internet Tools : HTML, XML.
Automated Test Tools : Quick Test Pro 9.2
Test management Tool : Test Director, IBM Rational ClearQuest,
HP-ALM, ClearQuest, MS Sharepoint.
BI Tools : SSIS 2010, SSRS, Informatica 8.6.1
ERP : SAP

PROFESSIONAL EXPERIENCE

Confidential, (OCT 2012 Current)
Fort Lauderdale, FL
Sr.Backend QA Analyst

Project : Freedom of Information(Migration)

Responsibilities:

• Reviewing and analyzing business requirements and functional documentations for test scenario development.
• Designing the test plan and scenarios and test cases that to be exported into HP-ALM.
• Analysis of heterogeneous data from various systems like SAP, Siebel, Salesforce.com and validating it in ODS(operational Data store).
• Analyze data by using T-SQL’s, using pivot and adhoc functional tests in SAP Sales Ordering system and reporting to compare the data in EDW.
• Loading the data by executing SSIS package and Sql Server Mgt. Studio.
• Perform adhoc analysis of compliance related data.
• Aggregating, Trending and creating graph of Backlog Order information in Excel.
• Develop statistical random samples for Backlog Order data for various status like overall rejected, delivered, not invoiced and completed.
• Performing data validationusing PL/SQL andT-SQL queries.
• Daily scrum meeting with team and developers.
• Weekly meeting with Business,Stakeholders and Analyst.
• Preparation of artifacts/deliverables for business and stakeholders.
• Load testing using IBM Rational performance tester.
• Running Smoke, functional, integration, end to end testing and regression scenarios during various phases of projectin an agile environment.
• Logging defects in HP-ALM, Follow up, involving resources on Bridge meeting to resolve critical issues.
• Writing SQL based on Source to Target mapping document.
• Data validation and verification will be carried out in Backend using Toad and SQL server management studio.

Environment:SQL server 2008 R2, SSIS, SSRS, Oracle 10g, SAP, VB.Net, Odata Explorer, TOAD, Excel, Agile Methodology, HP-ALM 11.0, MSSharepoint, XML, Rational performance Tester.

Department of Finance and administration (Apr 2011 Oct 2012)
Confidential, State of Arkansas
Sr. QA / Data Analyst

Project : Finance application, Licensing and Motor vehicle

Responsibilities:

• Reviewing and analyzing business requirements and functional documentations for test scenario development.
• Designed functional test cases and test steps and record the output.
• Responsible for reviewingthe designanddeployment ofany deliverables from development/staging to production environments.
• Working with Conversion team of data from State legacy system(getting datafeeds from mainframe) so as to carry out testing in more efficient way.
• Worked on Data warehouse with high volumes of data and extensive testing and guiding team members.
• Extensive SOAPUI, XML, and REST based messaging against a service endpoint in order to assess the robustness, reliability, and resilience of the service.
• Testing and validating XML, XSD, XPath Syntax, Web Services, MQ, Topics, REST, HTTP, SOAP Messaging.
• Extensive Functional and Regression testing of frontend and middleware via SOAP, WSDL and Businesss process management through Java Messaging Services inside the web service client.
• Worked closely with developments team for STM(Source to Target mapping) document Modifications and raise a Change request(CR) incase required.
• Mapping testcases with RTM (Requirement traceability Matrix) and impact matrix.
• Designing of Extensive Test Plan, Scenarios and managing walkthrough and daily defect & Weekly status calls.
• Experience in ETL deliverables, sourcing from multiple source systems.
• Testing of Data quality tickets. History and incremental fixes.
• Worked on implementation and post implementation support.
• Act as the technical contact for any query/database performance issues, work with developers and business users in query requestsand enhancements.
• Working with developers to fix/tweak the .net code using the Visual Studio debugger.
• Live Meetings with SME’s (Subject matter experts) for writing scenarios for testing thevarious State Tax vix IT, Sales Tax, Lottery and other financial application.
• Validating the data using T-SQL on very large databases (VLDB).
• Worked as UAT Defect manager, managing defects for User Acceptance Team, designed prototypes for UAT testers, organizing meetings, resolving defects and retesting fixes, deliverables.
• Written cross joins SQL Queries for verification and validation.
• Running SQL server Trace to find long running queries using DMV’s(Dynamic Managed views) and to take appropriate action.
• Diagnose and troubleshoot performance issues using SQL Trace(Profiler) to fix the root cause.
• Verification and Testing reports on reporting server(Copy of Staging data) with the reports from legacy system.
• Fair understanding of DB mirroring concept.
• Proactively monitor the database systems to ensure secure services with minimum downtime.
• Worked on implementation and post implementation support.
• Mentoring a group of 5-7 resources.
• Tested application servers using performance monitor and resource monitor(Cache hit ratio, Disk I/O pegging etc).
• Testing application for disaster recovery (DR) goes as per schedule.
• Providing 24x7 support of the SQL environment, including on call support on rotating basis.

Environment:SQL server 2005/2008 R2, SSIS, SSRS, Oracle 10g, VB.Net, VS 2008, TOAD,Agile Methodology, Mainframe,ClearQuest, MS Sharepoint, Tivoli Storage Manager, SAN,XML, SOAPUI, XmlSpy, LiteSpeed 6.5 ,Spotlight, VMWare.

Confidential, TX (Mar 2011 Apr 2011)
Sr.QA Analyst

Project: Long Term Evolution(LTE)

Responsibilities:

• Analyzed the Business Requirements Document and System Specifications and identified the test requirements.
• Writing andexecuting test cases based on FSD (Functional Specification Document).
• Testing specific session based data usage for prepaid accounts.
• Evaluating speed test, volume test by burning the data from specific network towers and geographical locations.
• Responsible for per-production device testing (Smartphone, Data only device and Netbooks).
• Validating billing information from telegence in Oracle DB using Pl/SQL and queries.
• Managing and Coordinating test in MSG (Mobile Shared Data), EIT (Enterprise Integration Testing) and in QP (Quite Production).
• Testing of SIM card on Various brands Smartphones, Tablets etc. for speed and usage analysis.
• User interface testing on various smartphones and tablets.
• Actively participating in live-meeting for resolving issues with developers.
• Organizing and meeting with different teams to gather test data.
• Participating in weekly meeting to track the progress of testing effort.
• Analyzed the Business requirements and flow of the business processes.
• Actively involved in identifying the testscenarios, test case writing as per the specifications and functional documentation.
• Involved in writing the test cases for regression testing according to the new functionality of the application and executing them.
• Tested integration system using post XML for various front-ends such as OPUS, PDC, System X, My Att, and Premier.
• Escalating& Filing Defects, tracking the defects using HP Quality center.
• Involved in Integrated Systems Testing team for testing of various applications like Phoenix, POS, and OPUS for the external clients like RadioShack, Wal-Mart, Best buy etc.
• Actively involved in creation and execution of QA and testing processes such as test planning, test case writing, test case execution, bug documentation and issues investigation.
• Designed various scenarios based on the different business rules for testing the usage and billing.

Environment: Oracle 10g , Java, selenium,SOAP, XML,SQL, UNIX, HP Quality Center 10.0, Agile Environment,
ClearQuest, MS Sharepoint, Agile Methodology,Telegence

Confidential, MI (Apr 2010 March 2011)
BI Sr. QA Analyst

Project : Multiple Projects

Responsibilities:

• Analyzed functional requirements and SRS documented the user specifications and business rules.
• Mapping testcases with RTM (Requirement traceability Matrix) and impact matrix.
• Designing of Extensive Test Plan, Scenarios and managing walkthrough and daily defect & Weekly status calls.
• Working on multiple projects like Large group renewal and small group renewal system and Blue Direct Reporting (BDR).
• System Integration testing, End to End Testing, Regression of various projects.
• Worked on Data quality tickets for incremental and historical data fixes.
• Testing data from mainframe input file, Staging and EDW.
• Data aggregation matching against staging table and ODS(Operational Data store).
• Ensured ETL Regression testing and integration testing to ensure proper functioning.
• Worked closely with developments team for STM(Source to Target mapping) document Modifications and raise a Change request(CR) incase required.
• Worked on Dental, Vision, claims processing and protected healthcare information(PHI).
• Validating on data using SQL queries in TOAD based on conditions and filters specified in source to target mapping document(STM).
• Checked compatibility for upstream and downstream flows.
• Tested for Errors logs and audit tables are generated and properly populated.
• Tested scripts for notifications to business are generated as per format.
• Testing of Data quality tickets, History and incremental fixes.
• Using Informatica workflow monitor for job execution and for raising defects based on severity.
• Scheduling and monitoring the Tivoli job scheduler for sequence of jobs execution with dependencies and scheduling, Holding and re-startability of a job in case of failure.
• Extensively tested each table based on STM(Source to mapping) using SQL’s, rules and filters.
• Extensive testing of reports in COGNOS.
• Active member in designing test strategy and test plan.
• Extensive SOAP, XML, and REST based messaging against a service endpoint in order to assess the robustness, reliability, and resilience of the service.
• Extensive interoperabilitytesting by measuring both the design characteristics of a service as well as the runtime adherence to standards and best-practices.
• Carried out Securitytesting to assess the risk posture and robustness of a service with regard to vulnerability, data-leakage, data privacy, and data integrity.
• Ensure error log generation, cleanup scripts for environment including database.
• Leading to scheduling meetings with Development team and various cross testing team.
• Ensuring the compliancy of the system with business requirements.
• Involved as managing defects for User Acceptance Team, Designed prototypes for UAT testers, organizing meetings, resolving defects and retesting fixes.
• For ETL issues conducted LiveMeeting with experts from all related applications to interpret the result correctly.
• Mentoring a small team of 5 QA resources.
• Managing issues with on-shore and off-shore development team.

Environment: Mainframe 3270, UNIX, Informatica 8.6.1, SQL Server 2005, Oracle 10g, OWB, COGNOS, TOAD 10.5 , Tivoli Job Scheduler,MS Project, Visio, SOAP, PVCS, XML, IBM suite, IBM ClearQuest.

EDUCATION

• Bachelors in Accounting.
• Diploma in Computer applications.

TRAINING

• Microsoft certified professional(MCP)
• Professional Training in Oracle 8.0.
• Professional Training in Windows NT 4.0 Administration.
• Professional training in SQL Server Integration Services and SSRS.