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.

SKILLS

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.

Confidential (Apr 2011 – Oct 2012)
Little Rock, 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, Richardson, 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.

Confidential, Richardson, TX (Feb 2008 – Feb 2010)
Sr.QA Analyst

Project:Uverse

Responsibilities:

• Analyzed functional requirements and documented the user specifications and business rules.
• Involved in mapping testcases with RTM (Requirement traceability Matrix) and impact matrix.
• Involved in functional and Regression testing of Frontend and middleware viz; API and XML interfaces.
• Involved in functional, technical, impact matrix walkthrough and daily defect & Weekly status calls.
• ETL Regression testing done using old and new test dataset to ensure proper functioning.
• Testing the various SSIS controls like Data conversion control,Condition split, Derived column for the transformation rules given in source to mapping document.
• Testing SSRS reports with source and legacy report as benchmark.
• Performed the Back-End integration testing to ensure data consistency on front-end by writing and executing SQL queries on the Oracle database using toad.
• 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.
• Experienced in manual testing with the focus on Functional Testing, Regression Testing, Smoke Testing, Load Testing and System Testing.
• Validate the Billing history for Change of Bill Cycle BANs to check for Errors once the Invoicing was done and Send the BANs for IR Processing and Invoicing.
• Pulling and analyzing UNIX logs for the defects from various gateways and servers.
• Run billing batch job using UNIX scripts.
• Worked as UAT Defect manager, managing defects for User Acceptance Team, designed prototypes for UAT testers, organizing meetings, resolving defects and retesting fixes, deliverables.
• Deployed and customized collaborative and publishing site collections, sites, web parts, document libraries, lists, and views.
• Actively involved in creation and execution of QA and testing processes such as test planning, test case writing, test case execution, Defect documentation and issues investigation.
• Organizing meetings with Team lead, Developers, and QA team members for Defect tracking, resolving to meet the deadline.
• Working with automation team to design workflows in QTP for regression testing.
• Escalating & Filing Defects, tracking the defects using HP Quality center.
• Designed various scenarios based on the different business rules of Uverse combined billing. e.g: Wireline and wireless.
• Experience in working on AMDOCS CIM billing module, Telegence CSM Module.
• Conducting planning meetings with onshore and offshore AMDOCS team for various issues and solutions.

Environment: Oracle 10g, SQL server 2005, Asp.Net,VB.net Java, Selenium,XML,LoadRunner, IBM Rational ClearQuest, HP Quality Center 10.0, QTP 9.2, SOA,MS Sharepoint, Change Request Tool, TOAD, VI editor, Putty, Telegence, CARE, XMLSpy.

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.