Over 9 years experience in IT industry as BI Test lead, Pre-Sales Architect, Big data Quality Analyst, Functional Quality Analyst and leading Testing Solutions.
Experienced with big data testing, BI-DW testing, Database testing, ETL, Migration, Automation and Manual testing.
Experienced in US healthcare on Facets Membership , Plan/Product and Claim life cycle
Worked on cutting edge technologies and diversified frameworks and various domains like Core Banking, Telecom, Supply chain management, Insurance and Aerospace.
Good experience in defining test strategy, test plan, estimations and metrics, Testing Methodologies, and Defect Management process.
Architect by writing proposals and solutions for BIDW, Database, Migration Testing RFP's
SPOC for ETL Testing Solutions for the Regions N. America ,Middle East ,UK / Ireland ,Australia , Asia Pac and successful in achieving the new bids from major clients.
Building and management of complete Presales process RFPs/RFIs , test assets and artifacts in Transition Management activities for Direct Sales
Expertise in Functional test Automation tools RFT, QTP, WR and BI tools Datastage, SSIS, Cognos and BO and Test Management tools QC/ALM, Test Director and databases SQL, Oracle
Experienced in Staffing calls, war room sessions, project allocations to the team members, mentoring, training and guiding the team
Decision making in expanding the team size and conducting interview rounds at 2nd and 3rd stages for the open positions
Technical Skills
Primary Skills
Functional Manual testing, BI/DW Testing, DB Testing, ETL, Bigdata and data migration
Secondary Skills
Automation testing, Presales Architect, Project Management and onsite/offshore coordination
Domain skills
Travel and Logistic, Auto Insurance, Core Banking, Aerospace, supply chain management and Healthcare
Tools Utilities
BO, Datastage, SSIS, Cognos , ALM
Databases
Oracle, SQL-Server, Access
Achievements
Client recognized as PROGRAM LEAD OF THE QUARTER for the part of managing ocean shipment program across the regions.
Received BEST PERFORMER AWARD for Successful co-ordination as team lead in managing the team stayed across geographical locations DAO US, APJ-Penang, Ireland-EMEA
Received Client appreciation award- STAR AWARD for single handedly delivered the Data migration project from offshore.
PROJECT DETAILS:
Confidential
Role : QA Lead
Leading the entire Test release and Test access issues for Business, Dev, and Test for Offshore
Define and managed the test strategy for both functional testing events
Preparation of Test plan and defect management process and tracking using Quality Centre
Responsible for work assignment to resources and managing their performance appraisals
Test data preparation for Test execution.
Maintaining Traceability Matrix and Test Coverage Matrix.
Responsible for producing Daily Status updates, Weekly Executive Report and Monthly Dashboards
Actively involved in reviewing Test artefacts
Test case execution, analyzed results and defect reporting through QC.
Confidential
Role : ETL Solution Spoc
Pre-Sales management expertise in providing testing solutions to the embedded RFP's development with testing and Independent testing RFP's in the form of providing solutions and writing proposals
Creation of testing solution architecture , solution design , Effort estimations , resource loading with suggesting right automation tools within client budget
Developing Quality Process for the organization and working in Center For Excellence for QA and testing process improvements at organizational level
Deciding the test coverage for ETL , Database, BIDW and big data testing with good knowledge on test automation frame work using BI Tools, Reporting and automation tools.
Responsibilities:
Understand client requirements and propose engagement models and solutions Participate in customers visits to conduct requirement workshops and due diligence
Understanding and analyzing the product requirements and develop the test strategy , test plans and estimated for the testing projects
Interact with the sales and delivery unit heads and ensure expectations are met with respect to proposal quality and related presentations
Creation of solution architecture, solution design, estimation and proposal response generation
Proposing the Testing Methodologies for the client and play a key role in changing the test strategies during implementation by creating client-centric proposal responses aligned to the win themes and value proposition developed for the opportunity
Define and design frameworks, test approaches for system testing, functional testing, regression testing, security testing and UAT as appropriate at each stage of development.
Manage proposal documents and providing recommendations in improving proposal processes, databases, archives, templates, etc.
Drive adoption of reusable assets and technology best practices to foster delivery excellence
Confidential
Role : QA-Lead
Responsibilities:
Handling the testing assignment as one point contact from offshore
Participate in design walkthroughs, review meetings
Preparation of test plan, involved in the estimations get reviewed by client
Design the test cases and reviewed by business and team to signoff
Seeding data into CIW as per the test case mapped to requirements
Validate Test Environment
Responsible for testing data transfer from CIW warehouse to MDW
Extract the data into flat file and run the extract using SSIS with help of developers
Verify the extract contains the data as per the requirement
Run the JCL to move the data into M20
Verify the data in both warehouses with running the job for matching logic
Perform integration, system testing
Conduct defect triage meeting involving dev lead , test lead and PM
Participate in defect triage calls.
Identify risks/concerns related to the project and share with Project Management.
Follow quality assurance norms and guidelines
Onsite Offshore co-ordination by attending daily stand-ups
Provide status updates on execution, defect tracking, overall testing progress
Involve in domain and functionality trainings where and when required from onsite team
Confidential
Role : QA - Lead
Responsibilities:
Participate in requirements gathering and analysis
Handling Block Set of states level planning, execution from stage gate reviews
Conduct internal requirement review meeting with team and address the queries.
Prepare test plan, estimates, Prepare / Update System / Integration, Test Plan
Validate Test Data for System / Integration, Testing and Engage in peer reviews during testing
Review Test Scenarios prepared by team and get it signoff by onsite/Client
Review sign off System / Integration Test cases in coordination with onsite Business dev team
Validate Test Environment, Ensure testing readiness or QC readiness of QA for each release.
Set up and maintain the project in QC, Follow quality assurance norms and guidelines
Perform test execution, log defects and track them to closure.
Participate in defect triage calls, resolve technical and functional queries/issues that team members may have
Participate and contribute to status reporting for the customer weekly and onsite meetings
Report QA status accurately and in a timely manner to Quality Managers periodically daily / weekly
Identify Raise issues/concerns, share with Project Management and escalate to the QA Manager on time
Report time and effort spent accurately, Provide all type of metrics in each level of testing phase and share to client and onsite
Work with multiple stakeholders in different geographies to resolve issues
Support preparation of User Acceptance testing for Handover to Production
Contribute towards updating knowledge assets and continuous assessment process improvement of testing quality practice
Review the release notes and ensure that resolutions to the defect fixes are provided.
Responsible for identifying gaps in resource skills and taking suitable mitigation actions
Confidential
Role : QA - Lead
Responsibilities:
Understanding the existing/current system architecture, database tables
Review BRD, SRS and TDS with Onsite BA, Manager and team
Hosting Functional specification review meetings with the Manager and onsite BA on task allocation
prepare Test Plan and Test strategy based on the SDD System Design Document
Preparing Test Scenarios and test cases
Perform Sanity test ensure the overall health of the application.
Perform System Testing Dev Env, System Integration Testing in Pre Prod Env
Environment setup
Run the test cases as described in the Test Cases, and ensure that these tests prove that the system changes give desirable results
Review and make sure traceability matrix, SIT entry and exist criteria followed for the project Manual Test case execution and Bug reporting
Defects and other issues are communicated to the development team
A summary report will be prepared, which will include a checklist for defects and the Test Cases
Participated in Scrum meeting and give updates to scrum master. Internally conduct daily stand up meeting with testing team and get the updates.
Confidential
Role : Module Lead
Responsibilities:
Review BRD, SRS and TDS with internal team and project stakeholder Designing the Test plan
Review and prepare estimation for the project SIT cycle and communicated the same to PM defining testing scenario and convert those scenarios into Test conditions
Review and make sure traceability matrix, SIT entry and exit criteria followed for the project Manual Test case execution and Bug reporting
Hosting Functional specification review meetings with the stakeholder Resource management and task allocation
Hosting the Test plan /Test cases/QA related review meetings with the stakeholder.
Prepared various metrics like Test execution status , Defect trend , major milestone and blocking issue during project execution phase to all stakeholder
Prepared and identified regression suite for every release of the project