Indu Kesarwani
Total Experience: 7 Years
adclf1@r.postjobfree.com
Functional Testing
SFDC, MS CRM, Service Cloud,EIW
AGILE (CSM Certified )
Business System Analyst (Test Lead)
SUMMARY
Hands on Exp on Business Analyst of project, FRD, BRD creation, UML Creation Configuration on SFDC Domain
Hands on Exp on JIRA, QTP, ALM, Test Management, Visual Studio
Proficient in Test Automation using UFT (Formerly QTP) and Selenium IDE Strong experience with test case creation
Strong experience in functional testing, Regression testing, UAT, Stress testing, Smoke testing Strong experience in status report generation from ALM
Experienced in Scoping Phase, Gap Analysis, Testing, and Implementation Phase.
In Depth knowledge on all the Test Planning process and Document creation including RTM, Test Scenario, Test Closure
Strong Requirements gathering experience using JAD Sessions & Conducting User Interviews, and preparing functional documents like Use Cases, Software Requirements Specifications (SRS).
Expert in generating and analyzing custom reports and dashboard for management and various business unit personnel to provide detail information on key performance indicators.
Developed process enhancements through automations including Workflow, Approval Processes, and Escalation Rules.
Experience in Salesforce Testing and Administration spanning all facets of package software and SaaS application implementation.
In-depth Knowledge of test object model, functional and regression test
In-depth knowledge of developing and executing standard test plans and procedures
Test automation with Quick Test Professional & Selenium TestNG Framework – creation of framework and test scripts.
TECHNICAL SKILLS
Testing Tools: QTP 7.x, 8.x; Quality Center 8.x, 9.x.11X(ALM); MS TFS; JIRA
Framework Experience: TEST NG, Junit Framework for selenium; Cucumber Selenium
Test Scripting: VB Script, Java Script
Languages: SQL, Java, HTML, JavaScript, VB Script, Unix Shell script
Functional Tools: Manhattan PKMS, Salesforce CRM, Sterling OMS
Certifications
HP QTP Certified Professional
CSM Certified Scrum Master (2019) HP QTP (2019)
PROFESSIONAL EXPERIENCE
Year: June 2019 -december2019
Company : GigatechConsultancy Inc
Senior ETL Tester
EDW
EDW(Enterprise data warehousing) and ESP(Enterprise staging platform) teams maintains the TIAA-CREF enterprise level data which will be from different application sources. The raw data from source gets loaded into Enterprise staging platform which is envisioned as a central staging platform for enterprise usage to house all system of records data from different line of business and then business logic is applied and then loaded to Enterprise data warehouse where the huge data resides and also provide the extracts and business reports as per different requirements for downstream application.
Roles and Responsibilities:
Analyzed the business process workflows and mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
Developed high level ETL test matrix based on business requirements, ETL functional and ETL technical specifications, and development standards for assigned projects/applications
Created test cases based on test matrix including test data preparation for Data Completeness, Data Transformation, Data Quality, Performance and scalability
Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
Created SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations
Performed data quality analysis using SQL and executed ETL Test Cases / ETL Test Scenarios
Executed ETL Test Cases to verify reliability, accuracy and Compatibility of application
Extensive SQL querying on Staging, Data warehouse and Data Marts and ensured Error logs and audit tables are generated and populated properly
Performed UAT and Regression Testing, Tracked and reported the issues to project team and management during test cycles also Involved in trouble shooting of long running sessions and fixing bugs
Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams also Tested various Reusable and complex ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
Solid testing experience in working with SQL, triggers, views and worked on performance tuning of complex SQL queries
Conduct defect triage meetings to make sure all issues are detected early. Provide proper test closure at the end of the system test phase and document the same in the test phase summary document.
Attended Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Stand-ups, Sprint Check-In, Sprint Review & Retrospective.
Year: 2016-2019(April)
Completed training on Cucumber Framework Development Completed training on Selenium IDE/WebDriver io
Currently Learning Rest Assured Api Test Framework for WebServices/Rest API Testing Completed Training on certified scrum master
Organization: CA India Pvt Ltd
Project: BIG DATA (EIW TO TERADATA INTEGRATION) Lead Role: BSA/Test Lead Feb 2015 – April 2015
Duration: 2 months
As a part of this project we are moving informatica data from SQL database and migrating it to Teradata.
Involved in BSA activities and Testing.
Worked on Agile and Scrum Methodology for implementation.
In charge of conducting the UAT with the Business users, and gathering feedback and providing the same to the Development team.
Reviewing the test cases provided by the QA team, and providing feedback.
Project: Service Cloud (Salesforce Lead) Role: Scrum Master/Test Lead March 2014 – Jan 2015
Duration: 10 months
Preparation of Master Test Strategy and Show and Tell Documentation for every Completed Iteration. Preparation of Test Plans and Test Scripts from Design Specifications.
Involvement in Test Execution, Results Analyzing and Defect Reporting. Involved in Automation Infrastructure Development using Selenium.
Execution of Selenium Test cases and Reporting defects.
Conducting Data driven testing, cross browser testing and parallel test execution. Analyze testing requirements and attend meetings to freeze requirements.
Attending daily catch up calls with all the stake holders to publish the latest status on daily monitoring Defects/Jira tickets tracking and closure
Following & inculcating best practices in & among team to ensure the deliverables reach with utmost quality. Tested requirements in LIVE environment and done end to end functional review as well as testing.
Conducted several shows and tell sessions to the customer on developed requirements.
Working closely with the program manager and configuration teams to ensure the availability of test environments.
Scrum Master Role:
As performing scrum master role was involved with following:
Acted as Scrum Master for Product teams with a focus on guiding the teams towards improving the way they work.
Assisted team to remove impediments by having an understanding the control and release processes
Assisted with prioritization and resolution of software defects
Built relationship with Product owner and other stake holders to facilitate team's interaction with them Coached Product Owners in creation and maintenance of Product Backlog
Coached team members on Agile principles and providing general guidance on the methodology Continuously learned Agile/Scrum techniques and shared findings with the team
Facilitated sprint planning, retrospective and sprint demos
Helped team to solve problems rather than provide solutions
Organized and facilitated project planning, daily stand-up meetings, reviews, retrospectives, sprint, release planning, demos, and other Scrum-related meetings
Provided all support to the team using a servant leadership style whenever possible, and led by example Took responsibility of delivery and management of the tasks
Worked with the Scrum Team and the Product Owner to negotiate the minimum viable product for delivery
Project: SharePoint 2012 (Lead Role): BSA/Test Lead Nov 2013 to Feb 2014
Duration: 4 months
As a part of this project we have migrated from SP 2007 to SP 2010.
As a BSA/Test Lead for the Salesforce & web-marketing projects in the Global Information Services team.
Led the team in several projects in the cloud domain including the major Nimsoft and Service cloud release for the Organization.
Worked in the capacity of a BSA for the web marketing projects and performed use-case writing along with User/business testing of the web pages.
Involved in Test consulting and process documentation for the projects in various phases of the software test Life-cycle.
Involved in Automation Environment setup using Eclipse, Java, Selenium WebDriver jars and TestNG.
Project: Nimsoft (Lead Role): Scrum master /Test Lead May 2013 to Oct 2013
Duration: 6 months
Understand and convert User Stories and system requirements into positive and negative test cases. Preparing RTM to ensure all the requirements are covered.
Responsible for designing Test plan and Test cases and review peer test cases.
Running the jobs daily, troubleshooting the jobs with issues and ensuring they were completed successfully. Creating and validating the Test data.
Ensuring Test environment is ready.
Participate in walk through of Unit Testing results. Performing the sanity test to verify the builds.
Scrum Master Role:
As performing scrum master role was involved with following:
Acted as Scrum Master for Product teams with a focus on guiding the teams towards improving the way they work.
Assisted team to remove impediments by having an understanding the control and release processes Assisted with prioritization and resolution of software defects
Built relationship with Product owner and other stake holders to facilitate team's interaction with them Coached Product Owners in creation and maintenance of Product Backlog
Coached team members on Agile principles and providing general guidance on the methodology Continuously learned Agile/Scrum techniques and shared findings with the team
Facilitated sprint planning, retrospective and sprint demos
Helped team to solve problems rather than provide solutions
Organized and facilitated project planning, daily stand-up meetings, reviews, retrospectives, sprint, release planning, demos, and other Scrum-related meetings
Provided all support to the team using a servant leadership style whenever possible, and led by example Took responsibility of delivery and management of the tasks
Worked with the Scrum Team and the Product Owner to negotiate the minimum viable product for delivery
Project: PRM (Lead Role): Scrum Master/Test Lead Jan 2013 to May 2013
Duration: 5 months
This is a partner portal management system in SFDC.
Involved in the test automation efforts for the legacy QA applications and worked on QTP automation.
Involved in ALM knowledge sharing across the business unit and troubleshooting for critical ALM issues.
Coordinating the team of consultants for the Service Cloud/ Nimsoft project which involved liaising with the Business teams & the consultants
FRD creation with Business and getting involved for design of Use cases Creation of Users, App and database in SFDC.
Developed a web-to-lead functionality to site which directs leads to Salesforce CRM.
Scrum Master Role:
As performing scrum master role was involved with following:
Acted as Scrum Master for Product teams with a focus on guiding the teams towards improving the way they work.
Assisted team to remove impediments by having an understanding the control and release processes Assisted with prioritization and resolution of software defects
Built relationship with Product owner and other stake holders to facilitate team's interaction with them Coached Product Owners in creation and maintenance of Product Backlog
Coached team members on Agile principles and providing general guidance on the methodology Continuously learned Agile/Scrum techniques and shared findings with the team
Facilitated sprint planning, retrospective and sprint demos
Helped team to solve problems rather than provide solutions
Organized and facilitated project planning, daily stand-up meetings, reviews, retrospectives, sprint, release planning, demos, and other Scrum-related meetings
Provided all support to the team using a servant leadership style whenever possible, and led by example Took responsibility of delivery and management of the tasks
Worked with the Scrum Team and the Product Owner to negotiate the minimum viable product for delivery
Organization: Accenture India
Project: Microsoft (Avanade) (Senior QA Analyst) Feb 2012 -Dec 2012
Duration: 11 Months
Test Case Development by analyzing the Requirement documents. Test Planning & Execution by forecasting release cycles.
Estimations for Manual Testing and Weekly Status Reporting. Test Cases creation and maintenance using TFS.
Lead the Defect Triage calls.
Involved in Regression testing, Full System Testing, Exploratory Testing, Bug logging in Microsoft Tool and Retesting and vast interaction with client regarding BRD walkthrough and Status Updates as working at client location.
Active participation in the sprint planning.
Gained Extensive knowledge in MS-CRM CCA (Customer Care Accelerator Product) and MS-CRM.
Project: Microsoft- Client Location (QA Analyst): Oct 2011 to Feb 2012
Duration: 6 months
Integrated with development team and discussed the technical problems, reported bugs and supported the team.
Involved in changing the test cases for regression testing according to the new functionality of the application and executing them.
Participating in daily conference meetings to track the progress of testing effort with
end user clients
Involved in the implementation and customer support of the product.
Project: UPS (QA Analyst): June 2009 to Oct 2011
Duration: 3 years
Analyzed Business Requirement documents (BRD), Software Requirement specification (SRS) and
developed Test Plan.
Involved in setting up the Test Environment and Test Data.
Involved in Offshore and Onsite coordination with Development team and testing teams.
Developed and executed test cases manually and compared the actual with expected results.
Developed automation scripts using QTP 10
Performed Black box Testing, Ad-hoc Testing, Regression Testing, and Functionality Testing and Backend Testing.
Logged and tracked defects using Test Director Defect’s module.
Employment Details
Organization
Designation
Duration
CA Technologies, Hyderabad, India
Business System Analyst
Dec 2012 to April 2015
Accenture, Hyderabad, India
Software Engineer
June 2009 to Dec 2012
EDUCATION
B-Tech (Electrical Engineering) from Greater Noida, Greater Noida U.P. institute of technology in the year 2008 with 73%
Class XII (I.S.C.) from Christ Church College, Lucknow, U.P. in 2003 with 66.6%. Class X (I.C.S.E.) from Christ Church College, Lucknow, U.P. in 2003 with 76.6%