Uma Kandarpa Email and Phone Number

• Prepared various reports such as MIS, Daily Operations, quality, resource allocation, resource tracking, test planning, test execution, test performance, status reports for weekly, fortnightly and monthly reports using Pivot Tables and Charts, Sort, Filter, Subtotal, Conditional Formatting, Consolidations, Advance Functions like V-lookup, Lookup, Index-Match, Countifs, Sumifs, etc. to understand and analyse the why, fallout, area of improvement, clear the bottlenecks such as to improve the quality, achieve the targets etc. • Used VBA Macros for Summary Report Preparation. This Macro was picking the data from various sheets, databases and aggregating to main sheet in Excel. • Performed Data Manipulation tasks on Tables such as Subscriber Details, Rate Plan, Price Plan, GB Allocation, Discount Table, Customer Call center, CDR, Mediation, Billing in SQL Server Database using SQL statements such as SELECT statement, joins to fetch subscribers, prices, plan information etc, tested the logics, workflow in the backend and inserted their information in the database. Proficient in writing SQL SELECT, INSERT, UPDATE, DELETE, Functions, Joins, Sub-queries, Derived Tables etc. Used SQL to test various discounts in billing, to implement price plan change and its impact on various tables.• Interacted with all stakeholders, acted as scrum master for Integration testing & Development / PMs.• Involved in requirements and design phase by reviewing requirements, design, use case documents.• Created Test Strategy, Master Test Plans. Manage System Integration Test (SIT) planning, execution, defect, risks in Dynamic CRM and issues tracking across teams. • Provided Testing progress, defects tracking reports to project stakeholders.• Reviews of Master Test Plan, Interface Planning and Testing, Test scenarios, Test summary Reports.• Maintained audit artifacts to support Quality processes.

• Prepared various reports such as MIS, Daily Operations, quality, resource allocation, test planning, test execution, test performance, defect tracker, status reports for weekly, fortnightly and monthly reports using Pivot Tables and Charts, Sort, Filter, Subtotal, Conditional Formatting, Consolidations, Advance Functions like V-lookup, Lookup, Index-Match, Countifs, Sumifs, etc. to understand and analyse the why, fallout, area of improvement, clear the bottlenecks such as to identify product defects, improve the quality, achieve the targets etc. • Performed Data Manipulation tasks on Tables such as Subscriber, Pre-paid bundling, Messaging, Discount, Promotions of Databases using SQL statements such as SELECT statement, joins to fetch customer, price, plan information etc, tested the logics, workflow in the backend and inserted their information in the database. Proficient in writing SQL SELECT, INSERT, UPDATE, DELETE, Functions, Joins, Sub-queries, Derived Tables etc. • Acted as SPOC between development team, test team and cross functional team.• Was a part of Reverse Engineering Team for Prepaid Top-up system.• Involved in Framework development using C to find out Prepaid Fraud.• Devised plan for Defect Management Process along with Risk and Issue Management.• Arranged necessary trainings and workshops to make sure team has required skills.

• Prepared various reports such as MIS, Message Gateway, CDR Analysis for weekly, fortnightly and monthly reports using Pivot Tables and Charts, Sort, Filter, Subtotal, Conditional Formatting, Consolidations, Advance Functions like V-lookup, Lookup, Index-Match, Countifs, Sumifs, etc. to find TPS for Particular short code, omitting duplicates etc. • Performed Data Manipulation tasks on Tables. Used SQL statements such as SELECT statement joins, derived tables to fetch and analyze subscriber base. Performed bulk uploads of Rate Plans using PL/SQL, importing and exporting data from production environment for data analysis. Proficient in writing SQL SELECT, INSERT, UPDATE, DELETE, Functions, Joins, Sub-queries, Derived Tables etc. • Understanding the business requirements and preparing HLD/LLD.• Developed Subscriber Edge Service Management (SESM) for VAS services management.• Development and implementation of new java API which interact with internal or external software component and to carry out other user management task.• Planning and building, new features in SMS/MMS & Email platforms internally and through vendors.