SUMMARY:

• 15+ years of experience in software industry with 9 + years in ETL testing using informatica
• 4+ years of experience as SDET role in Confidential
• Created test plans, test scenarios, test cases and traceability metrics
• Led a QA team of 5 members for 5 years to perform ETL testing, System Integration, and Regression testing.
• Worked closely with the Business teams to support User Acceptance Testing (UAT)
• 4 years of experience testing Customer Information System (CIS) and Master Data Management (MDM) applications and dashboard reporting
• Good experience in python, MDM,Reltio MDM API and webservices testing.
• 9 + yrs exp in Oracle
• Good experience in Automation testing using Script wizard, VSTS, UFT, selenium and KAF automation tool.
• Familiar with Test Plan and Test Metrics Document
• 8+ years of experience with agile methodology and JIRA for issue tracking.
• Excellent exposure to Onsite/Offshore model and experience in working with offshore team members and stakeholders.

WORK EXPERIENCE:

ETL Test Lead

Confidential

Responsibilities:

• Migrate InfoLease on Linux 7.x to MS Windows Server 2016
• Custom Programs that Add/Update Info Lease data
• Custom Reports
• Web Portal applications
• Streams and Queues
• Data transfer from Source to target by using Informatica tool
• Data validate from Source to data Mart

ETL Test Lead

Confidential

Responsibilities:

• Successfully launched 5 applications by leading a team of 5 members over 7 years
• Tested all 5 applications using ETL process.
• Launched all the applications in a phased approach (Data Migration, Data Marts, P1: 8 eco systems deployed, P2: 32 eco - systems deployed, Dashboard Development, ETL testing)
• Developed cloud based single point access system (OM, OCE and RELTIO MDM) to monitor national and international sales data.
• Significant cost savings to the company by moving from territory hierarchy to eco system hierarchy followed by moving the eco system to cloud (Salesforce).
• Developed sales publication process using AWS S3 cloud infrastructure.
• Developed gsonar platform using Big data(Hadoop)
• Rewired the existing model of data transmission and submission to 25+ external vendors sales based on therapeutic, field and sub field force level.
• Improved efficiency of the whole organization by developing dashboard which provided easy access to Confidential t statistics, sales data, and hospitals information providing access based on employee grade.
• Migrated sensitive and critical data such as cases, Medical History, accounts, shipment and Prescriptions information from source to targets (cloud).
• Developed data marts from multiple commercial data sources tailored to the business needs which included trials and projects’ scheduling, clinical operations, and financial data.
• Streamlined and improved a 15-year established alignment system (data handling is critical) by efficiently aligning data for all Commercial Sales Field Forces and Payer Team and for Non-Sales Field Forces.

Software Development Engineer

Confidential

Responsibilities:

• Tested core banking system that handled inbound and outbound payments in hours rather than days.

Sr.Test engineer

Confidential

Responsibilities:

• Performed main frame testing of a banking system and responsible for migration of Customer Relationship Facility (CRF) to Customer Information System (CIS).

Software Development Engineer

Confidential

Responsibilities:

• Tested CRM and MSN search applications

Associate consultant

Confidential

Responsibilities:

• Confidential Direct is corporate internet banking. It provides financial services to GCB. To create a .net based "thin" client for Confidential Direct - a Java based "thick" client application for Confidential Corporate Banking.

QA Lead

Confidential

Responsibilities:

• Analysis of the system requirementsUnderstand the system requirements
• Create Test Plan
• Interacts with Business users
• Identified the High-level Scenario Delta Scenarios
• Create Delta scenarios and test data
• Prepared test cases based on the STM documents.
• Prepared test scripts based on the user stories and STM documents.
• Review of test cases
• Execution of test cases
• Validate data from source to target
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping
• Mapplet Designer and Transformation.
• Reviewed Informatica mappings and test cases before delivering to Client
• Experienced in writing complexSQLqueries for extracting data from multiple tables.
• Compare the data between Source and Target database
• Written the queries using SQL developer
• Validate data from MDM to Reltio MDM
• Validate data in dashboard against Datamart
• Identify the defects and log the defects in HPALM/JIRA
• Creation of daily status reports
• Involved in daily scrum status and Defect triage meeting calls

QA Lead

Confidential

Responsibilities:

• Analysis of the Legacy CDM system and SFA system requirementsUnderstand the new system requirements
• Identified the High level Scenario Delta Scenarios
• Create Delta scenarios and test data
• Prepared test cases based on the STM documents.
• Prepared test scripts based on the user stories and STM documents.
• Review of test cases
• Execution of test cases
• Validate data from source to target
• Compare the data between Source and Target database
• Written the queries using Toad
• Identify the defects and log the defects in HPALM
• Creation of daily status reports
• Involved in daily status calls
• Involved in Defect triage meeting calls

QA Lead

Confidential

Responsibilities:

• Understand the new system requirementsIdentified the High level Scenario Delta Scenarios
• Create Delta scenarios and test data
• Prepared test cases based on the STM documents.
• Prepared test scripts based on the user stories and STM documents.
• Review of test cases
• Execution of test cases
• Validate data from source (CM) to target (PACT)
• Compare the data between Source and Target database
• Written the queries using Toad
• Identify the defects and log the defects in HPALM
• Creation of daily status reports
• Involved in daily status calls
• Involved in Defect triage meeting calls

QA Lead

Confidential

Responsibilities:

• Analysis of the requirements
• Involved in JAD sessions.
• Preparing Test plan, Traceability matrix and Test Metrics
• Identified the High level Scenario
• Prepared test cases based on the Functional Spec and STM documents.
• Review of test cases
• Upload the Test Cases into ALM
• Execution of test cases
• Involved in mocking up the data in source for some of the test scenarios
• Compare the data between Source and Target database
• Verify the data in Reports
• Written the queries using Toad
• Identify the bugs and upload to ALM
• Creation of daily status reports
• Involved in Defect status management calls
• Involved in Consumer application calls
• Analysis the test results.
• Regression Testing
• Preparation of Bug report metrics.
• Allocation of work to the team members

Sr Test Engineer

Confidential

Responsibilities:

• Analysis of the requirements,
• Involved in Defect status management calls
• Involved in Status report calls,
• Identified the High level Scenario
• Creation of test cases
• Review of test cases
• Execution of test cases using Automation Frame work
• Identify the bugs and upload to TFS,
• Creation of daily status reports
• Analysis the test results.
• Functional Testing, Regression Testing
• Preparation of Bug report metrics.

Sr Test Engineer

Confidential

Responsibilities:

• Analysis of the requirements
• Involved in JAD sessions.
• Identified the High level Scenario
• Prepared test cases based on the Functional Spec and STM documents.
• Review of test cases
• Upload the Test Cases into QC
• Execution of test cases
• Prepare test data using Xml
• Insert the data into source system using Fitness tool
• Involved in mocking up the data in source for some of the test scenarios
• Compare the data between Source and Target database
• Verify the data in Reports
• Written the queries using SQL
• Identify the bugs and upload to QC
• Creation of daily status reports
• Involved in Defect status management calls
• Involved in Consumer application calls
• Analysis the test results.
• Regression Testing
• Preparation of Bug report metrics.

Sr.Test Engineer

Confidential

Environment: (with skill versions) Languages: ASP.NET,C#.Net Database: SQL Server 2005

Responsibilities:

• Analysis of the requirements
• Identified the High level Scenario
• Creation of test cases
• Review of test cases
• Upload the Test scenarios and Test Cases into Product Studio
• Execution of test cases
• Identify the bugs and upload to Product Studio.
• Worked on BVT, System and Regression testing

Sr.Test Engineer

Confidential

Responsibilities:

• Analysis of the requirements
• Interaction with client
• Identified the High level Scenario
• Creation of test cases
• Review of test cases
• Upload the Test scenarios and Test Cases into Product Studio
• Execution of test cases
• Automated the test cases using VSTS and Script wizard tool
• Identify the bugs and upload to Product Studio with screenshots
• Creation of daily status reports
• Creation of test summary report
• Analysis the test results.
• Regression Testing
• Preparation of Bug report metrics

Software Engineer

Confidential

Environment: (with skill versions) Languages: ASP.NET,C#.Net and JAVA Database: SQL Server 2000

Responsibilities:

• Analysis of the requirements
• Reengineering for the Infra Module.
• Developed Web Forms for the Infra Module using .Net
• Prepared UTC, PS for the Module
• Unit testing for the Module
• Interacts with Business team