SUMMARY:

• Over 6 years of consistent experience as Quality System Analyst.
• Majorly involved in testing mobile application and validating different platforms to ensure stable functionality.
• Experienced using handheld devices as well as emulator to validate mobile functionality.
• Strong experience in Front - end Web Testing for Telecom, Insurance, E-Commerce, Inventory, and check-out/registers.
• Excellent experience in creating tables, views from Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Expert in developing all types of SQL objects like stored procedures, triggers, user defined functions, views, tables, Index etc.
• Expert in utilizing Join, Merge, Union, Union All, Except, Pivot, Un-Pivot, Temp Table, Table Variable, CTEs, and Cursor in SQL queries.
• Expert in utilizing various types of table Constraints to enforce the data integrity and utilizing various types of Indexes for better query performance.
• Perform Front End testing including but not limited to GUI testing and Functional testing for Registration Ware House Management and order management module.
• Extensively worked with Return Transactions, Invalid Card/Pin, Discount Sale Returns, No Receipts and Usability Checks.
• Experienced performing web services testing of the application using SOAP UI.
• Tracked bugs and created reports using test management/defect tracking tools like Test Director, Quality Center and documented Test Documents Using MS Office Tools - Word, Excel, Power Point.
• Experience with SQL to perform backend testing.
• Expert in designing complex reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models SQL Server Reporting Services (SSRS) based on client requirement.
• Excellent experienced in data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Bulk Insert and Bulk Copy Program utility.
• Highly experienced in creating, configuring and scheduling the Dynamic SSIS packages using containers and variables.
• Experienced in creating many complex SSIS packages with transformations like Aggregate, Lookup, Data conversion, Merge Join using SQL Server Integration Services (SSIS).
• Experienced in designing high level ETL architecture for overall data transfer from the OLTP-Online Transaction Processing to OLAP with the help of SSIS.
• Experience working in Agile as well as Waterfall Software Development Life Cycle (SDLC) methodologies.
• Write and document Business Plan, Requirements Document, Functional Specification Document, and Test Case.
• Define Test Cases, analyze bugs, interact with team members in fixing errors, and User Acceptance Testing (UAT).

TECHNICAL SKILLS

QA Software: HP Quality Center ALM,TFS, Jira,

Business Modeling Tools: Rational Rose, MS Visio

Requirement Management Tools: Rational Requisite Pro

Defect Tracking Tools: HP QC ALM, Jira, TFS

Operating Systems: Windows NT/XP/2000, UNIX, AS400

Databases: SQL Server, MS Access, MS-SQL Server 2012/2008R2/2008/2005, MS SQL Server Integration Services (SSIS)

Languages: SQL, HTML

EXPERIENCE:

Confidential

Ashburn, VA

Quality Analyst

Role & Responsibilities:

• Analyzed System specification documents, Business requirement document and created Test Plan, Test Scenario, Test Cases and Test Procedures for manual testing.
• Performed static testing on the mobile application.
• Performed Smoke and Sanity Testing.
• Followed the Agile methodology for the entire ISDLC.
• Determined test requirements and developed test scripts for positive and negative test scenarios. 
• High Level Test Plans were written by incorporating User Profiles, Configurations, Environments, Risks, Test Scenarios, Schedules and Analysis and Presentation of Results.
• Created test cases for the UAT session and executed the test cases.
• Worked with the product team for UAT sign off.
• Coordinated with various teams for different testing activities on a project. Prepared daily and weekly reports for the project progress.
• Utilized Agile version one for maintaining user stories.
• Used HP ALM to create and maintain Test Requirements and defect tracking, also verified resolution of software and specification defects.
• Following all documented requirements and procedures designed Test Plan, Test Approaches, Test Matrixes, Test Cases and Test Validations documents to validate test result at each of validation points.
• Performed functionality testing, System Integration Testing and Regression testing on various mobile devices like Ipad 4.0/5.0, Blackberry Torch, I phone.
• Used VSO for Video Converter.
• Performed web services testing using Test Harness and soap UI.
• Involved in weekly team meetings.
• Used Defect Management grid of Quality Center in logging and analyzing issues

Environment: JIRA, SQL, Web services, IOS/Android, Agile, VSO, Version one, ADB tool, XML, Android, IOS, Charles Proxy, Firefox, IE, Chrome

Confidential

Madison, WI

Quality Analyst

Responsibilities:

• Gathered business requirements through interviews and JAD sessions and performed an inventory analysis followed by a first level functional decomposition of all existing legacy systems.
• Involved in Data analysis and Data Profiling to analyze Data quality and plan approaches for Data cleansing and transformations.
• Developed Technical Design specifications and Source to Target Mapping (STTM) specifications for each legacy system interface with Enterprise system.
• Designed and developed physical and logical Data Models using Erwin and developed SQL Server Database objects including Tables, Views and Indexes.
• Designed, developed and deployed complex SSIS packages to cleanse and transform data and load from legacy systems into the Enterprise system SQL Server database.
• Used advance features of T-SQL to design and tune T-SQL to interface with the databases and other applications in the most efficient manner.
• Developed complex Stored Procedures and Functions and incorporated them in reporting to enable report generation on the fly.
• Implemented Version Control with TFS.
• Designed and implemented Job scheduling, setting up alerts, User logins and access rights based on user roles, permissions and security requirements.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Tested to optimize the procedures and triggers to be used in production.

Environment: Microsoft DTS, MS SQL Server 2008, T-SQL, ER-Win v4.0, MS Visual Studio .NET, MS .NET Framework, J2EE technology, Windows 2000 Advanced Server, UNIX / Oracle Platform, MS Visio, MS SQL Server 2000/7.0, Microsoft Visual Basic 6, MS Access, MS-Reporting Services, Crystal Reports.

Confidential

Northbrook, IL

Quality Analyst

Responsibilities:

• Responsible for defining the scope and business rules of the project, gathering business requirements, and document them textually or using models.
• Interacted with cross functional teams to facilitate gathering of business requirements.
• Created system models and software design processes and software intensive systems using Unified Modeling Language.
• Involved in creating test documents with the Test Coordinators.
• Written test cases encompassing different test scenarios to provide full test coverage.
• Provided backup for other test analysts in the team to co-author and review their documents.
• Maintained open and clear communication with the business team on change requests timelines.
• Test POS application to ensure the staff members can easily checkout the customers.
• Reported defects using Quality Center Verified fixes and closed bugs during regression testing.
• Performed manual testing executing all the test cases in Quality Center before switching to automation testing.
• Recorded the Defects in Quality Center with priorities and co-ordinate with Development team for fixing.

Environment: Firefox, IE, Chrome, SQL, Web Logic, Windows XP/2000/NT/98, HTML

Confidential

Charlottesville, VA

Quality Assurance Analyst

Responsibilities

• Involved in working on several different applications within the same project.
• Created LOE/Test Plans/ Test Approach documents in Microsoft Excel for project.
• Involved in FRD review and Test plan review meetings with the team.
• Created test cases based on the FRD document using HP QC ALM.
• Executed test cases in QC and reported defects.
• Report defects using Team Foundation Server TFS.
• Followed up with developers for defect resolution.
• Performed the Back-End integration testing to ensure data consistency on front-end by writing and executing SQL queries on the Oracle database.
• Used SQL server 2010 to access the database for Back-end Testing.
• Performed Regression Testing and User Acceptance Testing (UAT) with the business.
• Maintained the Requirements Tractability Matrix (RTM).
• Verified student records and tuition refunds in On base records system.
• Performed testing of application across multiple platforms like android, IOS.
• Involved in UAT testing with the Business analyst.
• Assisted with UAT test plan creation.
• Tested application in different devices like Samsung galaxy phone, Samsung galaxy tab, IPhone and IPad.
• Verified student tuitions and refunds are being updated using Great Plains.

Environment: Microsoft Excel, SQL Server 2010, on base, Team Foundation server TFS, HP QC ALM, Citrix, Devices (IPhone, IPad, Samsung galaxy phone/tab)