SUMMARY:

• Having 12 years of professional IT experience as Sr. QA data Analyst in the field of Testing.
• Experience with domains - Telecom, Retail(Supply chain), Investment banking, Medicaid
• Extensive experience in Functional, Web, Integration, Regression, User Acceptance testing.
• Good Experience in Informatica ETL testing and Database testing.
• Experience in RDBMS such as Oracle and Teradata
• Leading as Onshore And offshore test team.
• Good knowledge in analyzing and understanding the exact issue and updating the related logs and screenshots to the issues.
• Good experience performing daily defect triage and reviewing defects with multiple development team and managing the defect thru its life cycle
• On time Communicates QA risks, milestones, and status to the Project Manager and Project management.
• Have In-depth knowledge and experience on Data warehousing ETL (Extraction, Transformation, and Loading)
• Well acquainted with understanding the user requirements, preparing technical and functional specification document.
• Extensively involved in unit testing, system testing and preparing test plans.
• Strong problem solving, analytical skills and ability to learn and adapt to new technologies.
• Discussed requirements with Business team in Scrum calls and helped able to resolve any queries/issues for Scrum team.
• Having experience customer expectation in Creation of Test strategy and Test plan
• Developed automation framework for continuous integration using Selenium
• Having experience Test scenario identification and Test case creation
• Coordinating with offshore team and ensure the deliverables are reviewed and met as per customer expectations
• Validating for in REST, SOAP, XML protocol for security testing
• Strong experience in End-to-End process of Telecom billing and Order Management System.
• Strong in Software Development Life Cycle, Agile and Test Methodology
• Experience in Defect Reduction and Testing Cycle Time minimization process.
• Experience in Preparing test plan independently and Contribute in developing a Test Approach & Strategy.
• Having experience in test metrics and sharing the same.
• Review and verify functional and system requirements and ensure project deliverables adhere to QA criteria and comply with the requirements prior to deployment
• Interaction skills with clients and customers
• Managing the Test Data Management (TDM) and sharing the test data for different testing’s.
• Having good Team leading skills
• Involved in Manual and Automated Testing of applications on Windows Environment.
• Extensive experience in writing test scripts in Black Box Testing Excellent problem solving skills with a strong technical background and good interpersonal skills.
• Developed and maintained test automation scripts.

TECHNICAL SKILLS:

Operating Systems: Windows7/2k/XP/NT, UNIX

Languages: JAVA, SQL, XML, VB.NET, ASP.NET

RDBMS: SQL Server, Oracle 10g, Toad, Teradata

Testing Tool: QTP 11, Win Runner, Selenium, load runner

Test Management Tools: Quality Center 11

Scripting Languages: VB Script, Java Script and HTML

Reporting Tools: Informatica, SAP BI/BW, Tableau

Web services Testing Tools: iTKO-Lisa, Flex monkey

PROFESSIONAL EXPERIENCE:

Confidential

Sr. QA data Analyst

Responsibilities:

• Provisioning the orders in the Provisioning system and checking the same in the OMS to make sure the orders are active.
• Verifying the provisioning logs and reviewing the orders in the provisioning systems.
• Managing the Test Data Management (TDM) and sharing the test data for different testing’s.
• Creating the Test data for functional, Integration and UAT testing.
• Running the Billing, verifying the invoices, and doing the post billing activities.
• Assigning the daily task to the team members.
• Reporting the weekly status to the onsite and offshore
• Preparing the Master Test Plan
• Validating for in REST, SOAP, XML protocol for security testing
• Providing the Estimates and participation in confirming the scope for each release.
• Daily Status call with offshore Lead and Preparing Status Report.
• Coordinating with Offshore for Issues and concern
• Coordinating and running the daily conference call.
• Preparing the month review deck and sharing with onsite and offshore.
• Reporting Daily status to the concern leads& Mangers on daily basis
• Involved in Planning and Analysis phases of the current and next release.
• Leading as onshore test team lead.
• Developed and maintained test automation scripts using Selenium
• Developed automation framework for continuous integration using Selenium.
• Reviewed software and Business requirement documents of current and next release.
• Involved in daily status report and status calls with client team.
• Tracked the bugs using defect-tracking tool and Reporting Defect and Verifying.
• Writing SQL queries for back end verification and validation
• Worked with informatica ETL tool to load data from different sources to target.
• Interacted with developers and QA Manager to identify and resolve technical issues
• Involved in Functional, Regression, Security and Database testing
• Using TFS done Web Services for cross machine communication
• Developed and maintained Linux Platform and shell scripts

Confidential

Sr. QA data Analyst

Responsibilities:

• Provisioning the orders in the Provisioning system and checking the same in the OMS to make sure the orders are active.
• Verifying the provisioning logs and reviewing the orders in the provisioning systems.
• Creating the Test data for functional, Integration and UAT testing.
• Running the Billing, verifying the invoices, and doing the post billing activities.
• Assigning the daily task to the team members.
• Reporting the weekly status to the onsite and offshore
• Preparing the Master Test Plan
• Having experience with Hadoop big data tools like Hive for ETL.
• Providing the Estimates and participation in confirming the scope for each release.
• Daily Status call with offshore Lead and Preparing Status Report.
• Coordinating with Offshore for Issues and concern
• Coordinating and running the daily conference call.
• Preparing the month review deck and sharing with onsite and offshore.
• Reporting Daily status to the concern leads& Mangers on daily basis
• Involved in Planning and Analysis phases of the current and next release.
• Reviewed software and Business requirement documents of current and next release.
• Involved in daily status report and status calls with client team.
• Writing SQL queries for back end verification and validation
• Leading as onshore test team lead.
• Validating for in REST, SOAP, XML service s for security testing
• Worked with informatica ETL tool to load data from different sources to target.
• Interacted with developers and QA Manager to identify and resolve technical issues
• Involved in Functional, Regression, Security and Database testing
• Developed and maintained test automation scripts using Selenium
• Developed automation framework for continuous integration using Selenium.

Confidential

Sr. QA data Analyst

Responsibilities:

• Developed, monitored and did coordinate project activities, such as scheduling, tracking, and reporting.
• Discussed requirements with Business team in Scrum calls and helped able to resolve any queries/issues for Scrum team.
• Having experience customer expectation in Creation of Test strategy and plan
• Having experience Test scenario identification and Test case creation
• Coordinating with offshore team and ensure the deliverables are reviewed and met as per customer expectations
• Worked as Test team lead and onshore coordinator
• Reviewing the Business scenarios, Test Cases for all Change Requests (CR's).
• Leading the product test team for execute all CR test scripts in Assembly test and Product test Environment.
• Involved in release related meeting with onshore and offshore.
• Assigning the work to the team to Execute the Business Scenarios and Coordinate with other teams to make sure the execution is smoothly going
• Validating for in REST, SOAP, XML service s for security testing.
• Developed and maintained test automation scripts using Selenium
• Developed automation framework for continuous integration using Selenium.
• Reporting Daily status to the concern leads& Mangers on daily basis
• Has extensive experience in resource allocation, scheduling project tasks and risk analysis activities.
• Leading the Offshore team.

Confidential

Sr. QA data Analyst

Responsibilities:

• Involved in Planning and Analysis phases of the current and next releases.
• Understand business needs and implement the same into a functional database design.
• Technical validation to ensure that the objects are running correctly by executing the workflows.
• Responsible for the Dimensional Data Modeling and populating the business rules into the Repository for Meta Data management.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Data Quality Analysis to determine cleansing requirements.
• Re-migration of objects from old Dev Version to new Dev Version
• Documentation of issues and fixes applied
• Validation of objects post migration to ensure that they are in a valid state for execution.
• Create Entity Relationship (ER) Diagrams to the proposed database
• Execution and recording of test plans specific to the application provided the test plans are supplied by the application team worked as a ETL Module lead and Senior Developer cum tester
• Identify columns for Primary Keys in all the tables at the design time and create them.
• Create functions to provide custom functionality as per the requirements.