SUMMARY:

• 10+ years of experience as Quality Assurance Analyst, with expertise in testing Healthcare, Pharmaceutical and Insurance software applications.
• More than 6 years of experience in Data warehouse ETL and BI Testing.
• 2 years of experience in Project management activities and leading QA offshore team. Involved in project level RCA, Estimates and project plan.
• Worked with major clients Confidential in Health care, Confidential in Pharmaceuticals and Insurance domains.
• Well acquainted with Software Development Life Cycle, Testing Life Cycle, Concepts and methodologies.
• Have strong experience with different types of Black box testing techniques like System Testing, Integration Testing (integrating new systems with existing systems/applications using ETL - source to target validation testing), Regression Testing, Functional testing, UI Testing, Ad-hoc Testing, Smoke Testing, Implementation testing, User Acceptance testing and, Data warehouse/ETL Testing.
• Extensive experience working with Global delivery team for effective project management and onsite-offshore co-ordination.
• 7+ Years of Experience in Agile- Scrum, Waterfall and Iterative Development Methodologies.
• Experience in leading cross functional team of 10+ with varied skill, Planning, Tasking, Scheduling, Monitoring, Assessing, Evaluating, Motivating and Mentoring & Training.
• Excellent analytical, organizational, interpersonal skills, Identification and negotiation for Business and Technology requirements.
• Conducted extensive review and analysis of existing QA and Development Practices and worked on continuous improvement to yield effective solutions.
• Experience in facilitating the Test status call with various Testing groups, Defect Management and participating in Defect Triage Meetings.
• Experience in defining and collecting metrics for analysis and reporting to measure quality assurance effectiveness.
• Active participant in the continual improvement of the organization.
• Adapt readily to ever changing technologies and possesses demonstrated supervisory, customer relations and training / support ability.
• Hands on writing and executing the complex SQL queries.
• Excellent Technical, Training, Planning, Communication, Presentation and Interpersonal skills.
• Expertise in preparation of Test Summary Report, Defect Trend Analysis, Test Case Development plan and Testing Dash Board on daily basis.
• Defining and managing project scope, schedule, risk, budget and Managing project teams in the development of business cases, requirements gathering, business and technical documentation, testing and deployment planning, risk mitigation strategies and project status reporting
• Well-developed interpersonal and communication skills, having dealt with diverse professionals, clients & team members at global locations and Vibrant team player with belief in taking positive approach towards issue resolution.
• Experience with ETL automation tools and performed proof of concept with ICEDQ.
• Extensive experience in data analysis and product owner demos.
• Performed Automation feasibility study for ETL Testing project and tool selection.
• TMMI Professional certified by TMMI org.

TECHNICAL SKILLS:

Functional Areas: ETL Testing, Analysis (Business Process Improvement), Leadership/Management ( Problem-Solving, Strategic Planning)

Methodologies: Agile-Scrum, waterfall, prototyping, iterative and incremental development, spiral development

Application Development Tools: Teradata, Abinitio, Informatica,Microstrategy, Qlikview, SQL Server, ICEDQ, Business Objects

Databases / DB Tools: Teradata, Oracle, SQL Server, Toad, DB Visualizer

Desktop Tools: MS Office, Adobe Acrobat, MS Project, Adobe Acrobat

Methodologies / Techniques: Agile Scrum, Business Process Modeling, Database Design, Online Analytical Processing (OLAP)Project Control and Reporting, RDBMS, System Development Life Cycle Methodology

Network Software / Communications: TCP/IP

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

Programming Languages: C, C++, SQL /PLSQL and Shell scripting

Testing Tools: ALM, QC, Knowledge of QTP, Mind map, Toad

Utilities / Command Languages: FTP, Footprints ticketing system, OTRS Ticketing System

Other: RTC-Rational Team Concert, CONTROL M, SharePoint, Facets

PROFESSIONAL EXPERIENCE:

Confidential

QA Lead

Responsibilities:

• Participating in Sprint planning sessions, backlog grooming sessions and retrospectives.
• Participate in business meetings and identify the scope of the project.
• Involved in data analysis, identifying source column mapping and identified the gaps in existing functional specifications.
• Reviewed the mapping documents and specifications with data integration analysts.
• Prepared the Adapter guides with source and target mappings and specification documents.
• Worked closely with data modeling team in impact analysis for the changes, object properties, addition of new fields, & renaming the fields.
• Identify the stories and calculate the story points for each sprint. Estimated the testing effort for required changes and enhancements.
• Efficiently allocating the work and monitoring the deliverables of team members on daily basis.
• Setting up the QA environment and Test data preparation.
• Prepared SQL scripts to validate data loaded in target system.
• Run Control M jobs and load data in XML, MQ and Abinitio Queue, Validate the data loaded in XML.
• Involved in checking out code to QA Environment and running control m jobs.
• Participate in demo for test cases and test results.
• Set up environment for UAT and coordinate UAT runs.
• Attend daily standup calls to track work status and identify the issues while executing the project.
• Execute all test cases, SQL scripts and capture test results in HPALM and Teradata.
• Identify the regression test scripts and run them after new changes are promoted.
• Perform root cause analysis for the defects identified in UAT phase.
• Created Test Approach documentation and Requirement Traceability Matrix to ensure coverage of test requirements and comprehensive regression testing.
• Participate in product owner demos.

Environment: Teradata Administrator, Teradata SQL Assistant, Unix, Facets, PMHS, Control M, HP ALM, Rational Team Concert, DB Visualizer, Winscp, XML, XSD.

Confidential

QA Lead

Responsibilities:

• Involved in creating mapping documents for small group and individual members data enrolled through Facets system.
• Participating in Sprint planning sessions, backlog grooming sessions and retrospectives.
• Participate in business meetings and identify the scope of the project.
• Involved in data analysis, identifying source column mapping and identified the gaps in existing functional specifications.
• Reviewed the mapping documents and specifications with data integration analysts.
• Prepared the Adapter guides with source and target mappings and specification documents.
• Worked closely with data modeling team in impact analysis for the changes, object properties, addition of new fields, & renaming the fields.
• Identify the stories and calculate the story points for each sprint. Estimated the testing effort for required changes and enhancements.
• Efficiently allocating the work and monitoring the deliverables of team members on daily basis.
• Setting up the QA environment and Test data preparation.
• Prepared SQL scripts to validate data loaded in target system.
• Run Control M jobs and load data in XML, MQ and Abinitio Queue, Validate the data loaded in XML.
• Involved in checking out code to QA Environment and running control m jobs.
• Participate in demo for test cases and test results.
• Attend daily standup calls to track work status and identify the issues while executing the project.
• Execute all test cases, SQL scripts and capture test results in HPALM and Teradata.
• Identify the regression test scripts and run them after new changes are promoted.
• Perform root cause analysis for the defects identified in QA & UAT phase.
• Created Test Approach documentation and Requirement Traceability Matrix to ensure coverage of test requirements and comprehensive regression testing.
• Participate in product owner demos.

Environment: Teradata Administrator, Teradata SQL Assistant, Unix, Facets, PMHS, Control M, HP ALM, Rational Team Concert, DB Visualizer, Winscp, XML, XSD.

Confidential

QA Lead

Responsibilities:

• Extensive onsite interaction to understand requirements and formulating solutions.
• Analyzed the requirements of the project and prepared clarification log.
• Estimated work hours for the stories of each sprint.
• Promoted code to QA environment and checked out using code promotion tool.
• Designed and executed reusable backend SQL scripts to validate complete set of data loaded in target system.
• Validated data loaded in extracts files with the set of UNIX commands.
• Participated in daily scrum meetings to report daily progress of activities
• Setting up the QA environment and Test data preparation.
• Prepared SQL scripts to validate data loaded in target system.
• Maintained the Quality Standards set by the Project and Prepared Understanding documents.
• Prepared User acceptance test scripts and performed preliminary checks on data loaded in UAT environment.
• Participated in Test cases, test scripts and test results demo to users and project leads at the end of every sprint.
• Actively participated in Sprint retrospectives and suggested the improvements
• Collected sprint level metrics, completed sprint burndown charts.

Environment: Teradata Administrator, Teradata SQL Assistant, Unix, Facets, PMHS, Control M, HP ALM, Rational Team Concert, DB Visualizer

Confidential

QA Lead

Responsibilities:

• Extensive interaction with business users to identify the requirements and prepared understanding documents.
• Understand business logic of Fact and semantic layer tables by analyzing the data in source or dimension tables.
• Prepared understanding documents and conducted knowledge transitions to offshore team.
• Efficiently allocating work and monitoring work performed by offshore team.
• Identified test scenarios for all the fact tables.
• Designed and executed reusable backend SQL scripts to validate the data loaded in target tables.
• Developed test scenarios and test cases using modular approach.
• Validated Microstrategy and Qlikview reports.
• Used HP Quality Center as test management tool and Teradata SQL Assistant for and executing SQL queries.
• Used QDC tool for all the change requests tracking.
• Prepared test strategy, Project plan and test summary reports.
• Prepared status reports on weekly basis.
• Executed SQL queries in batch mode and reporting defects.

Environment: Teradata Administrator, Teradata SQL Assistant, Toad, HP Quality Center, SharePoint

Confidential

QA Lead

Responsibilities:

• Attended the knowledge transfer sessions at client place.
• Attended the follow up sessions with SME’s to understand the warehouse technology of different streams.
• Understood different modules like sales, market, product and territories.
• Involved in the migration of existing applications to enterprise data warehouse.
• Prepared the estimates for the test case design effort for pre production and ongoing support.
• Submitted the estimates for test case design, test execution to management of GSK.

Environment: Teradata Administrator, Teradata SQL Assistant, Toad, HP Quality Center, SharePoint

Confidential

Team Lead

Responsibilities:

• Analysis of the specifications provided by the clients.
• Knowledge acquisition, designing test scenarios and test cases in quality center.
• Responsibilities include extensive onsite interaction to understand requirements, formulate the solutions to the requirements by designing test scenarios, test cases and complete project execution.
• Prepared Project plan with high level estimates, test scenarios and test schedules.
• Prepared Test Strategy and Test Summary report for every release.
• Involved in system testing and functional testing.
• Executed manual test cases and identified the deviations from business requirements.
• Executed test cases in Quality Center and reported defects.
• Prepared status report on weekly basis.

Environment: Windows NT/XP, ASP.Net, Test Director 8.0, Mercury Quality Center 9.0

Confidential

Team Member

Responsibilities:

• Analysis of the specifications provided by the clients.
• Knowledge acquisition, designing test scenarios and test cases in quality center.
• Responsibilities include extensive onsite interaction to understand requirements, formulate the solutions to the requirements by designing test scenarios, test cases and complete project execution.
• Prepared Test Strategy and Test Summary report for every release.
• Involved in system testing and functional testing.
• Executed manual test cases and identified the deviations from business requirements.
• Executed test cases in Quality Center and reported defects.
• Prepared status report on weekly basis.
• Involved in test data preparation for Mainframe systems.

Environment: IBM Mainframes Applications, TIBCO, EAI Middleware, Epiphany CRM, DB2, Oracle 9i, Test Director.