SUMMARY:

• 11+ Years of proven record in ETL, Manual, Database and Automated Software Testing
• Senior software QA Lead/Tester with full system development lifecycle experience, including designing, developing and implementing test plans, test cases and test processes fueling swift corrective actions, significant cost savings and fault - free audits.
• Coordinating QA Testers, designing new tests, preventing market entry delays, collaborating with other departments, and making sure software development projects are completed in time.
• Backed by strong credentials including Information Technology Master's degree, advanced command of various testing suites, ETL, agile methodologies, database and various domain s and monitoring tools.
• Received Arbie from project manager for ECS project while working with RBC
• HMRC project team has been ed with the 'PROJECT OF THE QUARTER’ within account.
• Active participation and prizes in various competitions of CTS like Greeting card competition, Best out of Waste Contest - Earth Day, Xmas Stall Comp, Independence Day-Pune.
• Member of Fun committee in Cognizant Technology Solutions.
• Certified with Elementary and Intermediate in drawing & painting
• Conducted and participated in many domain and testing related sessions on project level.

TECHNICAL SKILLS:

SKILLS & TOOLS: Agile Model ETL Testing Waterfall Model Test Strategies & Coverage Test Plans, Cases & Processes Functional Requirements Scripting & Documentation Defect/Bug Tracking Service Oriented Architecture (SOA) E2E QA & QC StandardsManual Testing Integration Testing Regression Testing Functional / Non - Functional Testing Sanity Testing Automation Testing Database Testing Data Interface & Migration Testing Web Services Testing UNIX Basics Citrix PlatformHP QC / ALM (Quality Centre) SQL Server SOAP UI QTP TestComplete SCCM 2007 Perforce Enterprise Architecture Win SCP JIRA

PROFESSIONAL EXPERIENCE:

Middleware DB/ Lead Quality Analyst Testing

Confidential

Responsibilities:

• Lead Quality analyst for Client Reporting team. Responsible for comparing PDF flies generated as part of client statements/Reports on Monthly/semiannually or yearly basis. Make sure that all statement balances for entire account activities are populated correctly.
• Tools & Methods:
• Confluence, JIRA, XML, Excel, Delimited files, DB visualizer

ETL Quality Assurance Lead Testing

Confidential

Responsibilities:

• A QA Lead of ETL Quality Assurance team handling offshore team of 3 people. Responsible for ETL Testing of 4 applications and managing work deliverables of offshore team.
• Tools & Methods:
• TeraData SQL, HP QC, HP ALM, XML, Excel, Delimited files

ETL Quality Assurance Testing

Confidential

Responsibilities:

• With Teradata SQL Verify that the:
• Data received in delimited files is as per the requirements.
• Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL minus queries which includes Virtual Tables (VT’s), physical Tables, joins (inner/outer) verify that the data quality is as per standards.
• Tested the ETL mappings from Source to Target.
• Written test cases for checking the populated data correctly into fact and dimension tables.
• Responsible for different Data mapping activities from Source systems to Teradata
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status.
• Make sure that all the fields affected due to one transaction are correctly saved in respective table.
• Created automation test cases to achieve 100% regression - By addressing areas where regression is possible I made all regression testing 100% by automation. Resulting saving all manual efforts for regression testing.
• Addressed issues in traditional ways of Confidential scripting, while gathering knowledge with BSA and asking valid questions I could find the discrepancies in historical VT’s.
• Identified the root cause, I have always taken efforts to find the root cause of the defects. Resulting saving time and hence money spent in future.

Senior Software Quality Assurance Lead Testing

Confidential

Responsibilities:

• Created and executed manual and automated software test plans, cases and scripts to uncover, identify and document software problems and their causes.
• With SQL Verify that the:
• Correct data (before/after calculation) is saved in the respective table at the backend.
• Amount displayed on reports at front end is the same that is saved in the backend database.
• All the fields affected due to one transaction are correctly saved in respective table.
• Designed and implemented automated testing tools and programs addressing areas including database impacts, software scenarios, regression testing, negative testing, error/bug retests and usability. Enhancement and Execution of Automation Scripts using QTP, Helping other team members
• Started project with two people with basic testing which later turn to be 9 people team. Also with various testing techniques.
• Pinpointed previously undiscovered flaw in Confidential application, resulting in formal division of project into two modules.
• Identified the root cause of intermittent interoperability glitch in Confidential, leading to a no-fault audit finding.
• Transitioned software development efforts to a test-driven development (TDD) process, which brought QA testing in on the front-end of the development cycle for gains in code quality, software functionality and programmer productivity.
• Conducted formal and informal design reviews throughout the software development lifecycle to provide input on functional requirements, schedules and potential issues. Leveraged developer background to communicate effectively with software design team, quickly gaining their respect and becoming a valued, “go-to” team member on challenging test cases.

Senior Software Quality Assurance Tester and Lead

Confidential

Responsibilities:

• Delivered thorough QA testing reports that determined product quality and release readiness.
• Performed System Testing, System Integration Testing (SIT), GUI Testing, Regression Testing, End-To-End (E2E) Testing, Functional Testing, Non-Functional Testing, Sanity Testing and Smoke Testing; Provided client developer teams with detailed reports on quality metrics, identified bugs/flaws and recommended fixes.
• Designed and implemented root cause analysis template addressing areas require more attention which causes major defects.
• Designed Estimates, Metrics and reports (EOTR and Status Report) and sharing the same with Clients and management.
• Design test plans and test cases/scenarios, test execution, defect logging and analysis with root cause analysis. Compose the Regression Test Packages.
• By SQL queries verify the details on frontend are same that are saved in backend database. Also verify the report displays the same data that is saved at backend database.

Confidential

Software Quality Assurance Tester

Responsibilities:

• Design test plans and test cases/scenarios, test execution, defect logging and analysis with root cause analysis. Compose the Regression Test Packages.
• Delivered thorough QA testing reports that determined product quality and release readiness.
• By SQL queries verify the details on frontend are same that are saved in backend database. Also verify the report displays the same data that is saved at backend database.
• Designed Estimates, Metrics and reports (EOTR and Status Report) and sharing the same with Clients and management.
• 7.HMRC (Her Majesty s Revenues and Customs), LBG (Lloyds Banking Group)
• Role: Software Quality Assurance Tester
• Working as a single resource in this project had given great exposure to learn details on software testing life cycle. Build up confidence dealing with business directly on very early stage of the experience.
• HMRC is based around the transfer of data between Lloyds TSB and HM Revenues and Customs (HMRC). The key business objective of this project is to replace all removable media data feeds between LTSB and HMRC with encrypted electronic feeds. This project has four important nodes as Datastage, MEFG (Multi - enterprise functional gateway), GGW (Government gateway) and HMRC. This is an automated process needs to run daily once.
• Web Services are the foundations of modern Service Oriented Architecture (SOA). This includes message exchange between a consumer and a producer using SOAP request and responses over the ubiquitous HTTP protocol.
• A Web service producer advertises its services to potential consumers through Web Services Description Language (WSDL) an XML file that contains details of available operations, execution endpoints and expected SOAP request-response structures.
• Worked without any from previous cycles. Original creation of all test phases including Planning, Design, Execution, defect logging/analysis and Reporting.
• I was rewarded for Excellent Client Feedback which was published in Cognizant s 'BIG SMILE OF THE WEEK' weekly mailer.