Rajeev Sumandev Nautiyal

RBC have web-based report application which facilities upload of impaired assets information by the various Finance platforms and provides enterprise-wide loans reporting

• Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity.
• Performed duties in accordance with applicable standards, policies and regulatory guidelines to promote safe working environment.
• Used critical thinking to break down problems, evaluate solutions and make decisions.
• Offered friendly and efficient service to customers, handled challenging situations with ease.
• Identified issues, analyzed information and provided solutions to problems.
• Resolved problems, improved operations and provided exceptional service.
• Exceeded goals through effective task prioritization and great work ethic.
• Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork.
• Used coordination and planning skills to achieve results according to schedule.
• As part of ETL Testing - Hadoop (Big data testing)- Trigger jobs from universal controller, Extract the data from upstream application through spark Scala scripts stored in edge node, Transform data to application as per business logic defined in transformation queries and load data in Hive tables.
• As part of SQL (Scooping data) testing - ensure the data loaded in hive through ETL tool is scooped as part of jobs and validate data set in tables by writing complex SQL query for data validation
• As part of Business Intelligence Reporting (Tableau Reports) testing- ensure the data loaded in SQL is displayed in correctly manner for the parameters defined in the tableau server through Tableau report (web application). The scope of testing is to compare Hive data set, SQL data set & Tableau report data are in sync.
• As part of web application (API testing)- ensure that web application tabs like roles assignment, uploading template formats, triggering few sets of jobs from UI and check the integration between UI and universal controller is in sync.
• Automation Testing - Created scripts in Python language for the Big data testing for hive and SQL layer of testing.
• Created SIFT framework for UI related component as part of automation scripts for Python
• Create regression test suite as part of automation testing in Python and ensure the suite is run every release

The focus of the project was on the new products testing in insurance mainframe application, Illustration system and insurance calculations meets as per the business requirement

• Developed test scripts utilizing comprehensive business requirements, functional documentation and processes.
• Performed root cause analysis through retrospective session and track the action item through confluence.
• Provided analytical, planning and coordination support on projects as assigned, reviewing, interpreting, analyzing and illustrating data to stimulate and support enlightened decision making.
• Developed monthly, end-of-quarter and other statistical reports for leadership team and quality improvement programs.
• Participated in weekly meetings with various teams at enterprise level for data set requirement for testing.
• Provided regular updates to team leadership on quality metrics by communicating consistency problems or production deficiencies.
• The project includes 3 layers of testing for BFSI – ETL Layers wherein the data from the online application would be picked and transformed in staging area, after processing the data set it move to next layer of application CC built in Java. The integration of ETL Layers and CC -Java happens through by calling API points. The tool used to transform the business logic informatica.
• Help UAT team with the data set-up, infrastructure readiness and quick walk through of the user stories to be covered as part of the release. Accountable for creating UAT closure document and acquire sign-off from all business teams
• Perform Regression testing whenever new code gets merged with different project as part of the release
• Perform Manual testing for the mainframe applications (Ingenium, AS400) and UI applications (Work Management, CMS, Advisor Support, Alias etc)
• Performed Proof of Concept (PoC) in JIRA and provided the demo about the insight usage of JIRA in BMO insurance as part of scope of improvement in the project.
• An initiative to establish Enterprise Test Management solution catering to all SDLC methodologies at BMO.
• The Project scope was to perform end to end Proof of Concept for the Core Test Management Capability of Zephyr, JIRA Standardization, Core Capabilities of Zephyr to handle tool integration with DevOps In-Built tool, CI/CD and Automation tool, Dashboard & Reporting through SPOTFIRE, Migration and Roll out of the projects in HP ALM to Zephyr.
• Closely work with the Vendor – SmartBear and DevOps for the blockers and issues in the project
• Perform End to End testing of Zephyr Enterprise Tool and capture the advantage and disadvantage of features

The project focus was to standardize the templates in JIRA for various issue types. Based on the standardization, KPI metrics are generated for overall End to End SDLC in the JIRA dashboard

• Coordinating with End users and Stakeholders to streamline the process and projects in the HP ALM, JIRA and PVCS by creating a Master Template based on Client Defect Management Process Approach for Waterfall and Agile.
• Preparation of document – SOP, Weekly Status Report, Monthly Status Report, User Guide for end users, Integration of TFS tool and JIRA tool with HP ALM through Connect2Group plug-in and HP ALM Synchronizer utility, excel Plug-in usage in HP ALM, Root Cause Analysis for the issues faced in the tools, charts, schedules, and dashboards.
• Customize and configure Users Groups, Project Entities, Project Workflows, Field Configuration, Screens, and issue types in JIRA tool as per project and business requirement. Managing user's groups & permission and ensure NDA process is adhered in all tools managed as Tools Administrator. Configuration of dashboards in JIRA and HP ALM tool to generate KPI Metrics at project level.

Delivery Excellence Group is a TCS Internal Team assures all his clients an experience of certainty through agility, rigor, and continuous improvement. Ensuring that delivery team follows the review process efficiently and effectively for the deliverables to the client and record the same in Integrated Project Management System (IPMS)-

• Review the health of the project through Project management review meeting, Audit and Monthly meetings with Project Leaders
• Successfully completed CMMI Assessment and Triple ISO audit at TCS level for few of the projects
• Good knowledge in TCS process and tools like iQMS, IPMS, Audit, PMR, TQAS, iEST, DP corner etc
• Preparation of reports in excel and PPT for upcoming issues in PMR, Audit, RAG status of the project every month, UMP Metrics, CSS dashboard at project level, alert report, weekly report share at higher level
• Successfully completed Structured Problem Solving (SPS) and yellow belt certification
• Conduct training session on the release of the iQMS to the project team
• Implementation of Defect Prevention Causal Analysis Model in the projects to help the project team to avoid the defects proactively Ensure that all the project activities are captured, tracked and monitor in Integrated Project
• Management System (IPMS) which includes Estimates, Schedule, Efforts, IQA Review , EQA Review, Final Inspection, Project Metrics, Generation of Statistical Process Control (SPC), XMC Chart, Control Chart, Customer Satisfaction Survey (CSS), Customer Appreciation Tracker, Risk Management, Issue Management, Service Management , Concession and Work ahead

SAP is a German based European Multinational software corporation that makes enterprise software to manage business operations and customer relation.

• Feeding New organization and Contact person in Customer database i.e (Customer Relationship Management) either manually or through UPM Tool
• Weekly call with FO and highlight issues, challenges and risks involved in testing service request
• Assess client feedback on regular basis with offshore Delivery Partners and come up with scope for improvements
• Responsible in preparing different types of reports like Daily Status report and Monthly status report
• Perform Black Box testing on SAP tools – Customer Relationship Management (CRM), Unified Project Management (UPM), ABAP and Segment builder in ICT environment
• Creation of Leads, Opportunities, AO, and AE in CRM based on the inputs from FO in ICP environment
• Extraction of reports region wise for CRM using Segment Builder and ZBPR tool
• Identifying Test scenarios, Preparation of Test cases, Review of Test cases and Execution of Test cases
• An efficient team player with good analytical, problem solving and communication skills
• Played a key role in developing, training, and mentoring the associates to increase their Testing Knowledge. Involved very closely in Requirement Analysis and design to have a complete understanding of requirements at overall project level

Main objective of this project was to set up data in Phoenix Life Insurance Application through NBC tool and ensure that all relevant information of insurance is up to date as per data received from client Creation and Update New Life Insurance Policy in mainframe application as per Standard

• Operating Procedure (SOP) Quality checks for set up done by team in application of New Life Insurance Policy and provides timely feedback to team on daily basis for any deviation from SOP Co-ordinate with various stakeholders like Client, Third Party Vendor, and internal stakeholders for smooth run of operations Preparation of reports like Project Status, Individual productivity, and Four-eye quality report to ensure daily target is met
• Conduct training session for new joiners in team and mentor them in live production environment of NBC