PROFESSIONAL SUMMARY:

• 12+ years of professional experience in providing IT solutions at client location from different domains Banking & Finance, Insurance, Life Sciences, Health care as a Data warehousing tester.
• Expertise with the Informatica, Cognos 8 BI tools, BO, Java, SSRS, and SSIS as a Test Analyst.
• Successfully completed s in ISTQB, Data Warehousing, Cognos reporting, TM1, Cubes and Teradata.
• Have good exposure in test cases preparation and reviews, test plan preparation, test data preparation, Test Summary Preparation, Test Dashboard Preparation, Test Estimations, creating defect report, database queries and usage of Quality Center.
• Creating Test Strategies for Complex projects.
• Expert in SQL, PL/SQL and Stored procedures. Extensive experience in using UNIX commands.
• Worked on Test Automation framework using Cucumber tool.
• Experienced in working closely with the clients and business users to understand the system in depth and providing appropriate solutions.
• Excellent interpersonal skills and capable of working as a member of an Agile team, complementing the skills and work of team members.
• Excellent Team Player with good communication & leadership skills, ability to learn fast and take up responsibility & be proactive in any assignments given.
• Worked in different regions Globally - USA, UAE & INDIA. Well conversant with all the phases of a Software Development Life Cycle (SDLC).

SKILLS PROFILE:

Primary Skills: Informatica, Oracle ODI, Cognos 8 BI tools, TM1, CUBES, Oracle Discoverer reporting, BO, Lumira, SAP Information Steward tool and SSRS.

Databases: Oracle 10g/9i,SQL Server, Hive database and Teradata

Languages: SQL & PL/SQL, Java

Operating Systems: Windows, Unix

Version Control Software: C20, Clear case, SVN Tortoise, Mantis, IBM Clear quest, JIRA, TFS, HP ALM

Other Tools: Ingenium, Informatica DVO, Perfaware & Platinum tool, Cucumber and Selenium, SNL online portal, VISIO,DB SOLO, KIBANA, APP DYNAMICS, GO CD,MAVEN, JENKINS GIT HUB, CLOUD FOUNDRY, Web services testing like REST API TESTING, SOAP TESTING, MONGO DB, HIVE DATABASE, IMPALA DATABASE, CONTROL-M, RUNDECK

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, Delaware

Senior Quality Assurance Engineer /Test Engineer

Tools: Used: HIVE database, Impala, Oracle, Mongo db. using command prompt, Mongo Compass, Control-M, Run deck, HP ALM, RALLY, Micro strategy Reports (MSTR), SAS, CUCUMBER TOOL

Responsibilities:

• Working as a part of Confidential Information and Integration Services (BII) Team responsible for validating the Business Intelligence Reports and Data Warehousing components in Agile Methodology.
• Review the scope of project defined in the sprint planning meetings in RALLY tool.
• Prepare the test strategies and test Scenarios according to the sprint planned. Involve with Business analyst/ Product Owners to understand the scope of project and define the tasks for Stories assigned in RALLY.
• Prepare the analysis document on the requirements stories and share the outcome with the team and Business team which would help them to take decision on design and coding standards.
• Understanding the existing SAS reports and discuss on known issues in existing system or any enhancements for the existing reports with the business and this helps to come up with test coverage and scenarios for the new MSTR reports
• Updated the requirements against the test cases for generating the traceability matric which is used for Quality Governance team in HPALM tool.
• Ensure that the changes are incorporated to the code/reports as per the story acceptance criteria and demonstrate the test result to the team, post that the story is been accepted by the PO.
• Test the Control - M jobs that are used to load the data in the data warehouse in Oracle database from the difference data sources including the Mongo DB’s, Consumer risk review, Know your customers (KYC) data and risk engines. Validation of populated data to ensure that this is as per the requirement /Transformation logics provided by Business team. Post validations of data, the Control-M jobs needs to be migrated to PROD using change management process. All the change management, approval of change and governance documentation needs to be done by me.
• Validate the data from the each data source into data mart and data is sqoop into Hive data base from data mart using the run deck jobs. Upon this the MSTR reports are generated. Parallel the data is also ingested into the IMPALA for the different subject areas and consuming application so that reports can be generated on this database as well.
• Compare the existing report generated by SAS programming with that of the newly built MSTR report for data and key fields to ensure that there is no change in data as the underlying data is same for both the reports.
• Automating of the repeated test cases which are used for the data validations by using cucumber framework.
• Recommendations to the team on the outcome of analysis and testing to ensure that there is no leakage of defects.
• Participate in Defect triage meeting with Business Analyst /Development Team /Scrum Masters on root cause of the defect and mitigation plan for future.
• Hold discussions with the team about the QA process and making decisions on the priorities set for the work in Rally, based on the business feedback.
• Maintain steady coordination between Business and team so as to ensure that team works collectively towards our sprint goal i.e., Business needs

Confidential

Senior Quality Assurance Engineer/ Test Engineer

Tools: Used: HIVE database, Impala, Oracle, Mongo db. using command prompt, Control-M, HP ALM, RALLY, Run deck, Micro strategy Reports (MSTR)

Responsibilities:

• Review the scope of project defined in the sprint planning meetings in RALLY tool.
• Prepare the test strategies and test Scenarios according to the sprint planned by using HPALM. Involve with Business analyst/ Product Owners to understand the scope of project and define the tasks for Stories assigned in RALLY.
• Prepare the analysis document on the spike stories and share the outcome with the team and Data engineering which would help them to take decision on design and code.
• Write up the test cases and scenarios for each story assigned in Rally with the Projects story number folder format in HPALM
• Updated the requirements against the test cases for generating the traceability matric which is used for Quality Governance team
• Ensure that the changes are incorporated to the code/reports as per the story acceptance criteria and demonstrate the test result to the team, post that the story is been accepted by the PO.
• Test the Control - M jobs and move the code to Prod using the change management request by following the QA process and documentation.
• Recommendations to the team on the outcome of analysis.
• Participate in Defect triage meeting with Business Analyst /Development Team /Scrum Masters on root cause of the defect and mitigation plan for future.
• Hold discussions with the team about the QA process and making decisions on the priorities set for the work in Rally, based on the business feedback.
• Maintain steady coordination between Business and team so as to ensure that team works collectively towards our sprint goal i.e., Business needs

Confidential

Senior Quality Assurance Engineer/ Test Engineer

Tools: Used: HIVE database, Impala, Oracle, Mongo db. using command prompt, Control-M, HP ALM, RALLY, CRUCIBLE

Responsibilities:

• Review the scope of project defined in the sprint planning meetings in RALLY tool.
• Prepare the test strategies and test Scenarios according to the sprint planned by using HPALM. Involve with Business analyst/ Product Owners to understand the scope of project and define the tasks for Stories assigned in RALLY.
• Prepare the analysis document on the spike stories and share the outcome with the team and Data engineering which would help them to take decision on design and code.
• Write up the test cases and scenarios for each story assigned in Rally with the Projects story number folder format in HPALM
• Updated the requirements against the test cases for generating the traceability matric which is used for Quality Governance team
• Ensure that the changes are made to the code as per the story acceptance criteria and demonstrate the test result to the team, post that the story is been accepted by the PO.
• Recommendations to the team on the outcome of analysis.
• Post the changes moved to QA, dev team shares the Crucible links to be approved by Quality assurance team after testing the story. Once this links are reviewed and approved, the code is all good to move to Production using change management and CAB meeting.
• Participate in Defect triage meeting with Business Analyst /Development Team /Scrum Masters on root cause of the defect and mitigation plan for future.
• Hold discussions with the team about the QA process and making decisions on the priorities set for the work in Rally, based on the business feedback.
• Maintain steady coordination between Business and team so as to ensure that team works collectively towards our sprint goal i.e., Business needs

Confidential, Newark, DE/ Mt Laurel, NJ

Senior Quality Assurance Engineer

Tools: Used: SAP Data services ETL tool to load data from ORACLE database into SQL SERVER Database, Oracle Database, SQL SERVER Database, Oracle Data Integrator (ODI), JIRA, Microsoft office tools, VISIO tool.

Responsibilities:

• Review the scope of project defined in the sprint planning meetings in JIRA tool.
• Prepare the test strategies and test plan according to the sprint planned by using Microsoft tools like POWER POINT PRESENTATION (PPT) & EXCEL. Involve with Business analyst/ Product Owners to understand the scope of project and define the tasks for Stories assigned in JIRA.
• Placing the QA process in the Project by coming up with the Test Strategy document which is created by using the MICROSOFT POWERPOINT PRESENATION (PPT) which will be used as the document for the Project is uploaded and saved in the Confluence of JIRA
• Prepare the Analysis document on the issues seen in ORACLE DATABASE and SQLSERVER DATABASE for decision making by doing the analysis on the current data and share the outcome in Microsoft office tool like Word and excel to Business in order to take decisions on available data and enhancement stories for future backlog sprints in JIRA.
• Analyze and create the use cases, user stories, use case diagrams, and Activity diagrams/Flow charts using the UML tool like VISIO and JIRA tool.
• Come up with the Tech memos by using the MICROSFOT WORD tool, to make the decision easy for the Business on current system problems and gap analysis.
• Analyze the existing data for any known issues in SQL server and Oracle Databases, come up with the scenarios and test coverage details by using tools called MICROSOFT WORD and EXCEL and conducted the Three Amigos meeting (Business/ Development/Testing team) using Microsoft outlook to verify with the team and make team aware and come to an agreement.
• Prepare Test plan, User Acceptance Scenarios, Test case document, Test execution planner for each testing story assigned for that sprint in JIRA by using tools like Microsoft excels, POWER POINT PRESENTATION (PPT) and word.
• Analyze the risk due to defects and prioritize them for fix and conduct meeting with team to make aware for future defect prevention.
• Ensure all the team members follow the QA process developed by Microsoft office tool called POWER POINT PRESENATIAONS (PPT) and uploaded and saved in Confluence of JIRA and be vigilant.
• Prepare the Bug summary report and Bug Closure report on the bug/Issues so far reported by using the Microsoft tool called Excel and Word as part of testing and handle UAT testing phases and handle defect triage calls.
• Analyze the exception handling which was created by ETL tools (SAP Data services and Oracle ODI tool) and manufacture the data to satisfy the test condition in Oracle and SQL server database and validate them.
• Participate in Defect triage meeting with Business Analyst /Development Team /Scrum Masters on root cause of the defect and mitigation plan for future.
• Prepare the Test Execution Summary report by using tool POWER POINT PRESENATIAON (PPT) AND WORD with the Business/Team.
• Demonstrate the test evidence document which is created by using the tool called MICROSOFT EXCEL and WORD to the Business Team along with the Bug details and bug Re-test details, on a regular basis.
• Ensure that the data is thoroughly tested and transformed in the SQL SERVER DATABASE from ORACLE DATA BASE by using SAP ETL tool Data services tool and Oracle ODI for the committed stories and get the positive feedback from Business Team.
• Hold discussions with the team about the QA process and making decisions on the priorities set for the work in JIRA, based on the business feedback.
• Maintain steady coordination between Business and team so as to ensure that team works collectively towards our sprint goal i.e., Business needs

Confidential

Senior Quality Assurance Engineer

Tools: Used: Oracle ODI, JIRA, ORACLE SQL DEVELOPER, Microsoft office tools, SAP Information Steward Tool, Business Object (BO) tool

Responsibilities:

• Responsibility to review the scope of project defined in the sprint planning meetings.
• Responsible for execution of the project. Prepare the test strategies and test plan according to the sprint planned. Involve with Business analyst/ Product Owners to understand the scope of project and define the tasks for stories assigned.
• Responsible for placing the QA process in the Project by coming up with the Test Strategy document as below
• Prepare the Analysis document on the issues seen for decision making by doing the analysis on the current data and share the outcome to Business in order to take decisions on available data and enhancement stories for future backlog sprints.
• Preparation on Test plan, User Acceptance Scenarios, Test case document, Test execution planner for each testing story assigned for that sprint.
• Run the jobs that were created in the Oracle ODI for loading the data into Oracle database and validate the data.
• Preparation on Bug summary report on the bug/Issues so far reported /retested /closed in Jira, as part of testing
• Responsible for Defect triage meeting them with Business Analyst /Development Team /Scrum Masters on root cause of the defect and mitigation plan for future.
• Data service tool called SAP Information steward was used to automate the data validations and quality checks on each objects that’s was created and loaded to ensure that the data is of good quality.
• Reports developed by the Business objects tool were run and tested for the data to ensure if the calculations and aggregations are coming as expected per Business rules.
• Preparation of Test Execution Summary report with the Business/Team and responsible to get the story reviewed and mark the story ‘Done/ completed’ by Product Owner.

Confidential

Senior Quality Assurance Engineer

Tools: Used: Hadoop, HIVE database, SAP data services, Lumira reporting tool, ALTISCALE PORTAL, ORACLE SQL DEVELOPER, Microsoft office tools, JIRA, Market Intelligent Portal website, KIBANA, APP DYNAMICS, GO CD, MAVEN,JENKINS, GIT HUB, CLOUD FOUNDRY

Responsibilities:

• Review the scope of project defined in the sprint planning meetings in Jira.
• Preparing the test strategies and test plan according to the sprint planned. Involve with Business analyst/ Product Owners to understand the scope of project and define the tasks for stories assigned.
• Responsible for placing the QA process in the Project by coming up with the Test Strategy document as below.
• Responsible for the Three Amigos meeting with business/Development/Testing team to go through the known issues and the scenarios covered as part of test coverage.
• Analyze the online data by access the SNL ONLINE PORTAL and the reserve ratios so as to ensure that the data injected in Hive data lake in Hadoop using SAP data services tool and by creating the Hadoop work bench by using altiscale portal to access data lake, is same as that of Online feeds and share the outcome with the Business.
• Preparation on Test plan, User Acceptance Scenarios, Test case document for each testing story assigned for that sprint.
• Preparation on Bug summary report on the bug/Issues so far reported /retested /closed in Jira, as part of testing
• Data service tool called SAP Information steward was used to automate the data validations and quality checks on each objects that’s was created and loaded to ensure that the data is of good quality.
• Reports developed by the SAP Lumira tool were run and tested for the data to ensure if the calculations and aggregations are coming as expected per Business rules and validate the graphs and pie charts data and its corresponding numbers.
• Responsible for Defect triage meeting them with Business Analyst /Development Team /Scrum Masters on root cause of the defect and mitigation plan for future.
• Check-in and check - out for the code for testing purpose in GITHUB using JENKINS tool and GO CD tool to run the builds for testing purpose.
• Monitory the performance of the services that are pushed on the Cloud from On-Premises by CLOUD FOUNDRY Tool.
• Check the health of the services that are recently moved to CLOUD using APPDYNMAICS and forecast the Errors and promptly raise the Incidents to the Support team
• Demo the Test Execution details with the Business/Team every 2 weeks so as to ensure that we achieved the sprint goal and get constant feedback from Business. Post this responsible to get this story reviewed and mark the story ‘Done/ completed’ by Product Owner.

Confidential, New Castle, DE

Technical Test Lead

Responsibilities:

• Responsible for execution of the project. Prepare the test strategies and test plan according to the release planned. Involve in FRD preparation with Compliance team.
• Responsibility to review the scope defined for the release in Kick off meeting.
• Prepare the Tech Memo for decision making by doing the analysis on the current data and share the outcome to Business in order to take decisions on available data.
• Responsible for Estimation and planning for the defined release (Quarterly or application release).
• Involved in Test data conditioning scenarios for the given release and Coordinate with GCT (Global Consumer team/Source team) Team.
• Preparation of daily execution planners.
• Preparing the data analysis after each load (Lock filed analysis, Day 0/Day 1 Load analysis etc.) and present it to stakeholders.
• Facilitating the DIT release note meetings to SIT and SIT release note/handover to UAT.
• Preparation on Dashboard for the cycles involved in given release which includes the File calendar dates, Test cases planned, Test data condition request planned and Project plan dates.
• Responsible for Daily handshake meeting with Compliance team for daily SIT Execution statistics.
• Responsible for facilitating the Daily check point meeting with the stakeholders (source, Compliance, Consumer technology)
• Facilitate defect triage meeting with Source /Application team/ Technology team/ Compliance team
• Publish the Daily status metrics to the stakeholders.
• Coordinate with the Test Data management team and Database team and raise necessary Incidents /service now request to ensure the DB and environment is up and running before Environment is handed over to Testing team.
• Facilitate the Agenda calls with testing team for daily activities and resource planning.
• Coordinating with Technology team to conduct Defect closure meetings and root cause analysis.
• Coordinate with UAT team for the requirements and ensure that scenarios are covered in SIT.

Confidential, Franklin WI

Sr. Test Lead/ETL/BI

Responsibilities:

• Responsible for gathering detailed requirements by interviewing or facilitating meetings with subject matter experts (SME) across business functions and analyzing the business requirements effectively.
• This involves estimation of requirements, obtain clarifications on requirements gap and defect management. Participation in client meetings for test environment set up, feasibility analysis and scope identification.
• Prepare the Tech Memo for decision making by doing the analysis on the current data.
• Analyzes business requirements to understand the business needs and to determine how Consolidate Client Data Warehouse applications can best functionally fulfill with business needs/ Consumer Applications.
• Involved in the test data preparation, data extraction, and data validation process.
• To come up with the Functional and Design Document for given Consumer application by combining the CC Knowledge on how it’s built and the Business requirements.
• Analyzing on the existing system and coming up with future design in 3D diagram/Visio for sharing those details to Dev team.
• Designs the test strategy and plan in accordance with requirements specifications and comes with test plan.
• Perform integration testing of enhancements and share the logs and results with NM clients and get the signoff for the test artifacts.
• Responsible for coordinating with the offshore testing team activities and also act as a key liaison between the client and offshore testing team.
• Preparing traceability matrix.
• Perform code migration from Integration to Production and coordinate with NM team if required.
• Responsible for identifying defects during acceptance testing, managing them in Application Life Cycle Management and ensure retest/closure of the defects on fix.
• Perform final run in production environment and also perform post production validation and share the results.

Confidential, Eagan, MN

Sr. Test Lead

Responsibilities:

• Responsible for gathering detailed requirements by interviewing or facilitating meetings with subject matter experts (SME) across business functions and analyzing the business requirements effectively.
• Identify and implement new data quality rules and Perform daily, weekly and monthly s process.
• Analyzes business requirements to understand the business needs and to determine how existing Integrated Data Warehouse (IDW) can be migrated to new data base called Highmark.
• This involves estimation of requirements, obtain clarifications on requirements gap and defect management. Participation in client meetings for test environment set up, feasibility analysis and scope identification.
• Involved in the test data preparation, data extraction, and data validation process.
• Responsible for creating the test cases and test scripts in “Clear Case” tool get approval from stakeholders.
• Designs the test strategy and plan in accordance with requirements specifications and comes with test plan.
• Perform integration testing of enhancements and share the logs and results with Blue Cross asset owners for review and sign off.
• Responsible for coordinating with the offshore testing team activities and also act as a key liaison between the client and offshore testing team.
• Perform data profiling using tools like Atacama and create the test data for the testing as per requirement.
• Preparing traceability matrix.
• Perform code migration from Integration to Production and prepare scheduling plan and coordinate with Blue Cross Scheduling team, if required.
• Responsible for identifying defects during acceptance testing, managing them in Application Life Cycle Management and ensure retest/closure of the defects on fix.
• Provide warranty support and production hand over of Quality Assurance (Level 0 ) to EDIM data support team.
• Perform final run in production environment and also perform post production validation and share the results.

Confidential

Test Lead

Responsibilities:

• Provided L0, L1 and L2 estimates for various new projects.
• Participated in Review Team Meetings to analyze scope & feasibility of the testing for current system and Involved in requirement analysis
• Analyzed the Functional requirements using Detailed Design Document.
• Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications and Developing Testing Strategies, Test Plans, Test Cases, Requirement Mappings
• Defined entry and exit criteria for different phases of validation and prepared test data for interpreting positive and negative results.
• Lead a team of 10 members and was responsible for project initiation, delegation of tasks to peer team members, review of test cases and test results, presentation of test cases and test results to onsite and client team, defect management and tracking in QC and create/review of project repository.

Confidential

Test Lead

Responsibilities:

• Interacted with Business Analyst to understand the business requirements. Involved in Client meetings for the estimation and Design for each releases.
• Analyzed project requirements, In Initial stage of the project Interacted with the Onsite Team and gathered the requirements.
• Analyze requirement, track requirement change and Forecast / Estimate project future requirements
• Involved in test dashboard Preparation and the Testing estimates at the initial stage of the project.
• Preparation of complex test scenarios and test cases for data loads between various systems.
• Supported in test plan (UAT) creation to the client and involved in the test case reviews & walkthroughs to the client.
• Involved in the Test Data preparation and also the test evaluation and summary preparation.
• Used Clear Case for tracking the test execution, defects, creating data warehouse test plan and handling test activities.
• Attending status call to discuss about outstanding defects and issues.
• Interacting with business analysts and users during user acceptance testing and ensuring that all business scenarios and requirements have been tested and qualified.

Confidential

Onsite Test Lead

Responsibilities:

• Knowledge Acquisition and successfully handover from Competitors.
• Test Requirement Study and Preparation of Test Estimates.
• Preparation of Test Strategy, test cases for ETL, Report Testing and Test Data Creation for Scenarios.
• Defect Management.
• Execution of Test cases in RQM.
• Preparation of Traceability Matrix (Mapping Test Requirement into Relevant Test cases in QC).
• Prepare test results documentation. Execute the test cases analyze the test results and report the issues tracking the defects to closure in Mercury Quality Center.
• Review the task completed by other Team members.
• Daily Task Progress mail to Client Manager.
• Defect Tracking/Retesting/Closing in Quality Center.
• Extensively involved in Test Strategy, Test Plan preparation, RTM, Test Design reviews, Test Execution plan, Defects Calls (Scrum meetings), Handling issues related to project, Metrics preparation, Dashboard and various reports preparation.
• Have experience in estimating projects for DWBI testing based on the Business logics.
• Communicate activities/progress to clients, project managers, business development and business analysts.
• Extensive Experience in Test Director which includes Uploading Requirement, Preparation of Test cases, Execution of Test Cases, Logging Defects in QC, Preparation of Metrics and Preparing Status reports for test design Phase and Execution Phase.
• Excellent communication skills and inter-personal skills worked successfully on multiple projects in Agile and Iterative.