SUMMARY:

• Over 8 years of increasing QA responsibility in Banking, Non banking Financial Solution & Retail domains.
• Experience in Defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC).
• Experience using query tools for Oracle, Teradata, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Worked on managing large and complex data sets; extract, clean and format data for Data Analysis using MS Excel, MS SQL, etc.
• Excellent Leader experienced in building and managing on - site and offshore teams.
• Experienced in end-to-end management of QA tasks in different SDLC (Agile, Iterative, and Waterfall) and concurrent enterprise level system development.
• Capable in developing test strategy based on customer requirements, project constraints and risk analysis and delivering high quality products.
• Extensively Verified ETL methodology for supporting data extraction, transformations and load processing in a corporate-wide-ETL Solution using Informatica, SSIS and Data Stage.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Expertise in Defect Tracking, Defect management and Bug Reporting Tools like Mercury’s Quality Center (Test Director), Project Track, Rational Clear Quest and version control tools like Rational Clear Case. Participated in and Bug Reporting using Test Director for business software and Web applications.
• Strong with Mercury Test Director & Quality Center for Planning, Maintaining, Executing Test Cases, Defect Management, Bug Tracking and QTP 9.2 for regression Testing.
• Experience in testing Business Intelligence reports generated by various BI Tools like Business Objects.
• Experienced in ETL Testing, BI Testing, and Data Quality Issues & Data Reconciliation process.
• Extensively worked on MS Access, MS Excel, Power Design, MS Visio, MS PowerPoint, MS Project, and SQL.
• Strong communication and inter-personal skills.
• Self-motivated and ability to master new technologies.

TECHNICAL SKILLS:

Data Base Systems : Oracle, DB2, SQL Server, TOAD , MSSQLServer2000, Teradata RDBMS

Software Testing : Quality Center, Test Director, Team Foundation Server 2008, 2010 Test Edition, QTP,Team City, Rally & Merant PVCS, TFS

Automation Tools : QuickTestPro 6.5/8.2/9.0/9.2/10.0 , WinRunner6.0/7.6, LoadRunner 9.0/8.1/8.0, Test Complete

System Design : Microsoft Office, Visio, System Analysis and Design

Warehouse Tools: Teradata, Informatica PowerCenter 7.1, Data Stage, Changeman, FileAid

Methodologies : Waterfall, Agile/Scrum

Confidential

Mobile Test Lead/ Sr.QA Engineer

Responsibilities:

• Review functional or business requirement documents and use cases. Translation of requirements into test plan and test cases.
• Acquire from or do knowledge transfer with Developers, Business Analysts, SME and Architect who are expert in the relevant functional domain.
• Coordinate with other team members like Business Analysts, Developers, and Business people Advice or provide feedback on test activities and deliverables, conforming to appropriate quality requirements.
• Regularly assess testing progress and prepare test status report for management. Communicate with QA manager about testing progress, needs and any organizational/quality/technical risk/issue that might have an impact on the ability of the testing team to perform testing activities.
• Validate solution, whether it is fits the purpose and supports the complete end-to-end client business process.
• Perform comprehensive analysis of any error using the logs and json. Defect tracking and documentation was done using Clear Quest and MS Office. And review of defects with business users as well as technical team.
• Learn new technologies as needed and mentor or guide members of the project team, provide examples, and assist them in project deliverables. Can work with minimum supervision.
• System level tasks like,
• Uploading applications to handsets using Mac mini- configuration utility for  Native. App can be accessed on Mobile, Mobile browser and web browser.

Test Lead/ Sr.QA Engineer

• Led a QA team of 5+ persons, including mentoring, managing workload priorities and promoting professional development
• Developed and implemented Test Plans adjusting test strategy to the requirements of the particular product release. Maintained Traceability matrix and manual tests in QC.
• Used the Defects module of QC to track, fetch, edit, retest and close the defects status and follow up with developer on the defect until problem is resolved.
• Prepared and ran Functional and regression scripts.
• Used PL/SQL for Querying the Oracle database for data validation and data conditioning.
• Successfully completed knowledge transfer for ultimate consumption by offshore development personnel in India.
• Written specified SQL scripts to test the areas defined in each requirement.
• Coordinated execution of functional, integration, system, upgrade, end-to-end and regression tests.
• Backend testing for Test data Integrity, Data validation, testing store procedures and SSIS packages.
• Conducted daily meetings with QA team to track QA task progress, mitigated risks, took corrective actions, resolved issues with parties involved and escalated as needed. Provided the project status report to management on regular basis.
• Developed, collected and analyzed quality metrics about products and projects. Ensured that teams followed processes through SDLC and provided reports to managers. Provided input for the process improvements.
• Analyzed system impact during design reviews with development and business analysts.
• Managed onsite and offshore QA teams.

Confidential

Lead QA Analyst & Developer

Responsibilities:

• Performed Manual and Automation testing on customer service Online support application which is utilized by Express call center personnel.
• Extensively tested all the web services (Custom and Standard API) through API Runner.
• Extensively used SQL queries using Joins to retrieve Test data from Data Ware House.
• Worked closely with Business Analyst, Development team involved in resolving defects found during testing.
• Tested the Online reports via COGNOS of key loyalty performance metrics and exception/loss prevention statistics including but not limited to point accrual, liability forecasts and reward earning forecasts.
• Used Oracle 11 to retrieve and edit data from Express Data Ware House database where all the transactions were housed.
• Used Project Insight to store all Requirements, test cases, testing results, metrics, defect tracking and reporting.
• Performed data validation testing writing SQL queries.
• Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
• Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region. And did the querying on the same data.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Used QTP to automate the regression test scripts.

Confidential

Senior QA Analyst

Responsibilities:

• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designed reports in Access, Excel using advanced functions not limited to vlookup, pivot tables, formulas.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Created SQL server Analysis Projects using MS SQL Server 2000.
• Migrated objects from SQL Server 2000 to SQL Server 2005.
• Tested different reports including detail, summary reports and on demand reports developed by SSRS Report Studio.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping and Mapplet Designer and Transformation.
• Written Test Cases for ETL to compare Source and Target database systems. 
• Testing of records with logical delete using flags 
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.
• Tested ad hoc and canned reports for Business Objects.
• Tested Business Objects reports and Web Intelligence reports.
• Managed user accounts and security using Business Objects Supervisor.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Tested the universes and reports in Business Objects 6.0.
• Implemented Database Checkpoints for Back-end Testing.
• Used SQL for Querying the Oracle database for data validation and data conditioning.
• Produced variance reports, Excel graphs, charts, and presentations in PowerPoint.
• Identified, tracked and resolved performance problems. Made recommendations on potential functional and technical improvements to plan or existing system components and applications.
• Designed, implemented and maintained code needed for data extraction, transformation and loading.
• Customized complex reports in Excel using intricate formulas.
• Made recommendations on potential functional and technical improvements to plan or existing system components and applications.
• Added new features for compliance with and maintenance of quality standards.
• Implemented SDLC, QA methodologies and concepts in the Project.
• Involved in testing of Universes from different data sources like Oracle/SQL Server.
• Successfully completed knowledge transfer for ultimate consumption by offshore development personnel in India.
• Worked on profiling the data for understanding the data and mapping document.
• Reported bugs and tracked defects using Quality Center 8.0.
• Developed Access databases and associated graphical user interfaces.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Written several UNIX scripts for invoking data reconciliation.
• Used SQL for Querying the DB2 database in UNIX environment.
• Tested the Oracle Applications and Portals like Executive Dashboard, CIE Portal built on Oracle. Used TOAD Software for Querying ORACLE.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.

Confidential

System Analyst /Tester

Responsibilities:

• Participating in project discussions to gather the requirements and to monitor status / progress of the project.
• Through analysis of requirements to identify ambiguity, incompleteness or incorrectness.
• Checking whether the design is correct by logically analyzing the model and predicting its execution.
• Understanding the actual business that has created a need for the project. This helps in better design of the system.
• Preparation of a design / model for the system to be enhanced / developed, following standard models & artifacts.
• Preparing unit test plan and test scripts which could be used along with sample test data for validation.
• Following proper naming conventions and version control in the documents / datasets / components that are used in the project.
• Coding the system by following effective coding practices to meet the requirements
• Conducting Quality reviews of design documents, code, test plan and test scripts regularly to ensure defect free delivery.
• Gathering the data from the source (SOR).
• Aggregating the data as per requirement and loading the transformed data into ‘The W’.
• Third party tools like CA7, FILA and Change man are used for scheduling and for performing file level operations.
• CA7 - This automatically controls, schedules and initiates work.
• FILA - This tool is used for creating, copying, sorting and deleting datasets in mainframes.
• Change man - This is used to implement / install a new component in production.
• Testing and validating the code by executing test scripts to ensure that all the client requirements are satisfied and monitoring the performance of the system by collecting and analyzing the metrics.
• Conducting UAT (User Acceptance Testing) in case if it is required.
• Migrating the data
• Moving the data across databases whenever needed by using network data movement.
• Identify, assess, control and plan contingency measures.
• TCS tool - IPMS is used to collect various product and process metrics about the project.
• Arranging for Quality audits to ensure high quality standards in the component being developed.
• Arranging for a Final inspection of the developed and tested component to make sure that the component adheres to the quality standards.
• Implementation and post implementation support. Turnover to production support team.

Confidential

Senior Quality Assurance Analyst

Responsibilities:

• Managed multiple OLAP and ETL projects for various testing needs.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Performed extensive Data Validation, Data Verification against Data Warehouse.
• As an ETL Tester responsible for the business requirements, ETL Analysis, MVS, ETL test and design of the flow and the logic for the Data warehouse project using Informatica, Shell Scripting & PERL.
• Used Mercury Quality Center tool to store and maintain the Test cases.
• Tested several Cognos Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s and Web Reports.
• Tested and validated the Report Net reports by running similar SQL queries against the source system(s).
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Packages.
• Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
• Tested several Informatica Mappings to validate the business conditions.
• Testing the source and target databases for conformance to specifications.
• Conditional testing of constraints based on the business rules.
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center.
• Used Quality Center for writing and executing Test Scripts.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing