MOHIT AGARWAL

QA LEAD/TECHNICAL ANALYST

Phone: 403-***-**** Email: adc40n@r.postjobfree.com

ISTQB certified Oracle certified Database SQL expert

Bachelor’s in Engineering – Computer Science

QUALITY ASSURANCE

Experienced Technical IT Systems and Lead QA consultant with 9+ years of experience in Telecom, Airline, Data Warehousing.

Rich exposure to different phases of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) including Agile Scrum and Waterfall methodologies.

Insightful experiences in end to end delivery from feature development, testing, project delivery in production and post-production support.

Working experience on Agile and SCRUM methodology by careful analysis of requirement specifications.

Strong skills in implementing Quality Assurance Standards, and Testing Methodologies for Large Enterprise GUI, and WEB applications using Use Case Documents, Functional Specifications and Business Requirements.

Responsible for creating daily & weekly QA dashboards, lead daily triages and scrum meets regarding Project Execution.

Organized and facilitated project planning, daily stand-up meetings, Stakeholder Demo’s, used different delivery techniques like Scrum, Kanban frameworks for efficient flow of processes.

Provided all support to the team using a Servant Leadership style whenever possible and led by example.

Hands-on mobile testing on both native and mobile site apps by performing Integration, functional, cross platform, installation, cross browser, content, navigation, and security testing.

Work experience in developing Linux scripts, SOAP UI (Web-Services) automation, JIRA for test management.

Proficient in validating financial reports, month end journals, account receivable payments on multiple billing systems (Netcracker RBM, Oracle BRM)

Hands -On work experience in Callidus Cloud cloud-based application.

RELEASE MANAGEMENT /DEFECT MANAGEMENT

Define release cycle plan & deployment schedules with stakeholders to provide minimal disruptions to ongoing operations and optimize releases.

Deal with release package acceptance and provide final system build sign off to be deployed on Test environments.

GITHub – Bit-Bucket for Server side and SourceTree repositories to store test automation artifacts and source code management

Perform defect triage for QA environments to ensure validity of defects before they reach the test teams.

Monitor the defect lifecycle on JIRA to ensure defects are in the correct status ultimately leading to resolution or closure.

Hands-on experience with developing strategies for risk management to plan, eliminate or reduce risk to an acceptable level.

KEY STRENGTHS

Ability to build strong relationships with development and testing teams of diverse culture.

Excellent communication, organizational skills and critical thinking that helps in increasing testing process efficiency.

Positioned uniquely as lead that acts as a bridge to see bigger picture between the development, QA and Technical teams to identify bottlenecks and gaps in overall solution.

TECHNICAL SKILLS

●Windows, Unix

●SQL, HTML, XML, SOAP, Raw Data vault

●Oracle, SQL Server

●iOS, Android

●JIRA, Azure dev-ops, Bitbucket, Mingle

●Team city, SVN, MS SharePoint, SOAP UI, Oracle BRM, Netcracker RBM, Putty, Wherescape

●Legacy Migration, Upgrade, Web Applications, Mobile applications, Green field Implementation, OSS/BSS

EXPERIENCE

DLJV – DATA EXCHANGE APRIL 2019 – PRESENT

WESTJET, AB QA LEAD/TEST COORDINATOR, MINDTREE TECHNOLOGY

As partners, Delta and WestJet airlines are expected to exchange revenue and metrics data involving trans-border routing through daily file exchange process for revenue settlement purpose. Data team will land the daily and 5-year historical data from multiple source systems in data warehouse, transform into meaningful business information and send over the revenue accounting and revenue management data to Delta.

In charge in chief to set up QA team and test processes for Datawarehouse vertical at WestJet.

Started on Datawarehouse team as a sole Test Coordinator and now Leading a team of 12 team members across multiple projects.

Played a key role in setting up QA processes like, Requirement traceability matrix (RTM), Test Plan, Test Results summary, Story/scenarios review, sign off documents.

Created and deployed the QA framework to provide 100% test coverage for the Load data from old Datawarehouse (Oracle) and flat file sources into the single SnowFlake DB via Wherescape.

Coordinated with business and leads to gather ETL mapping for conversion strategies, conversion routines, business requirements, Data Model, Use Cases with vendors like Hyperion, Accelya, Delta

Worked on creating multiple Test plans across multiple stages and master test plan encompassing end to end test.

Conducted Integration test to validate the data in various stages of data movement from source files to Staging to Data Warehouse tables as per business rules.

Hands-on writing complex SQL queries using minus, joins, sub queries, union to validate the revenue data between through multiple stages in Datawarehouse.

Performed PL/SQL code walkthrough with dev team as part of white box and structural testing.

Managed all test efforts (test cases, defect management, and reporting) between Jira and AZURE dev-ops.

Managed and coordinated day to day testing efforts with onsite & offshore resources and provided status reports to the Project/QA Management teams and key stakeholders.

Worked on setting up Test framework to test Cloud environment infrastructure and CI/CD using Azure Scrum.

Worked in Agile environment consisting of iterative development model, Sprint planning, Backlog Grooming planning and Retrospective meetings.

Worked closely with business and tech leads to enhance control framework in cloud for file exchanges.

PAY FOR PERFORMANCE JANUARY 2018 – MARCH 2019

SHAW COMMUNICATIONS, AB QA/LEAD TECHNICAL ANALYST, NETCRACKER TECHNOLOGY

Service Excellence 2.0 program is made up of inter-dependent projects: Pay for Performance (Callidus-Cloud), Next Generation Dashboard and Case Management. The Goal is to create a new model that will pay agents based on their performance, align payouts to business strategies and adopt technology which supports the calculation and payout of new model commission. The goal was to calculate Shaw’s investment in market v/s revenue generated v/s payments based on commissions to agents/technicians.

●Brought in project for rescue mode to assess the state of testing and bring in testing efficiencies and identify testing gaps.

●Involved from project re-definition phase to devise overall Test strategy and work closely with BA in defining project requirements.

●Lead a team of 15 members & responsible for all facets of test execution including test resource allocation, daily targets and reporting.

●Built testing dashboard for macroscopic look at quality by examining the trends in metrics across functional modules for project to reflect overall system quality v/s timelines provided.

●Lead and manage cross functional defect review calls with project, technical team and vendors to triage issues and set priorities based on risk and urgency.

●Prepare Test strategy, Test Plan, test case preparation and group the test cases identified for logical flow in integrated testing environment.

●Work closely with project owner in backlog management and continuous delivery of features.

●Validated the Billing, commissions, revenue results on Monthly, Quarterly Revenue reports generated.

●Assisted BAs in synchronizing the Process Maps on Visio, writing the Mingle stories and updated BRD based on stake-holder requirements.

●Responsible for ETL/BI testing (Informatica) to make sure all workflows are aligned in accordance with the EDW snapshot and data transformation is precise.

●Lead the testing team in troubleshooting all their defects from Shaw’s end making sure the SQL queries pulling the data in the required template from EDW and Golden Gate.

●During Test execution, identified and resolved 150+ defects and 19 gaps in System Integration test phase.

BSS RELEASE IMPLEMENTATION SEPTEMBER 2015 – DECEMBER 2017

SHAW COMMUNICATIONS, AB RELEASE TECHNICAL ANALYST, NETCRACKER TECHNOLOGY

Shaw-BSS as an organization is moving towards standard release process and would require to automate the daily build process and code promotion from low level development environments up to production, define checkpoints in build process (soft code freeze, hard code freeze), integrate builds from multiple vendors (Order entry, provisioning, Billing) and in house development. At the same time, provide automated test framework to certify the build and publish status for consumption by required parties.

●Assist the release manager to plan & maintain the release lifecycle for all core services (major/minor/hot fix release) and ensure domain builds are in alignment across key partners.

●Created relevant release documentation to ensure Prod Operations team have an appropriate handover with Release candidate, build artifact, release notes, MOP details.

●Performed automated sanity testing using selected critical end to end test cases to verify the stability of the build provided by the developers for testing.

●Audit system build contents and perform integrated checks before and after the implementation of release build changes and identify the variances.

●Produce end 2 end test results from Order try till billing, Customer invoice & defect performance reports to be sent to key stakeholders and management and ensure proper coordination between development and QA team.

●Provide technical, application guidance and support throughout the release process, including known errors and workarounds involved in individual system builds.

●Train other colleagues on the release lifecycle, policy and process.

●Suggest & Implement innovative ideas/ suggestions/ recommendations in release/environment/delivery management.

SERVICE AGREEMENT, COLLECTIONS, SHAW DIRECT, COMMISSIONS FEBRUARY 2015 – AUGUST 2017

SHAW COMMUNICATIONS, AB QA LEAD, NETCRACKER TECHNOLOGY

As part of Shaw’s monthly release, multiple features and projects were released. Shaw Direct was the new phase of existing Shaw.ca service, offered by Shaw. Shaw Direct digital services new enhancements included single sign-in, upgrading legacy application, Oracle ERP implementation Next Gen Video and Wind Mobile Integration. In Collections, Shaw implemented the dollar amounts for pending payments and setting up reminders for payment collection. Service agreement was a new feature to lure customers with additional discounts if the sign up is agreed for 2 years.

●Analyzed user functional requirements and detail design documents for Direct digital services new enhancements include single sign-in, upgrading legacy application and Wind Mobile Integration.

●Provide Effort Estimate and prepare Coverage, Traceability Matrix for testing projects.

●Participated in Stories writing, estimation, scoping of work.

●Responsible for the Test execution for the multiple feature project on the Shaw account (Service Agreement, Commissions, Collections, Shaw Direct) to validate business processes such as login authentication, authorization and licensing, search, rentals, subscriptions, order management, check contents of a user’s personal media vault collection.

●Lead a team of 12 members for Test plan creation, Integration Test planning, execution and test support.

●Lead UAT testing, Created Go-Live Support and Deployment plan, and was a part of Go/No-Go decision-making team.

●Responsible for ETL/BI testing (Informatica) to make sure all Business mappings are correct and data transformations are accurate.

●Managed defect creation, validation, and release. Interacted with teams on triage, prioritization, and root cause of how to prevent recurrence.

●Created plan to reuse data set up for scenarios involving collections, payments, reversals, adjustments followed by reconciliation due to multiple actions on financial reports.

●Worked on Test coverage to include scenarios against multiple devices such as Desktop, Mobile and Tablets in the new services.

●Facilitating the SIT/UAT Testing activities with offshore team.

SLOVAK TELECOM BILLING UPGRADE DECEMBER 2014 – JANUARY 2015

SLOVAL TELECOM, SK QA CORDINATOR, NETCRACKER TECHNOLOGY

●Facilitating the Accenture team (Client representative) in providing details for RBM (revenue Billing management) core functionalities.

●Affirm only under contract details are passed on to Accenture team for executing the tests from RBM side.

●Fielding all queries and concerns regarding the RBM core upgrade issues being the single POC for NC at client location.

●Hands -on experience in executing Billing, post billing and invoice generation jobs and processes to generate customer bills.

●Coordinating with client as well as Accenture test team and NC support team to minimize the gaps over issues / defects.

●Issue triaging for quicker turn around for fixes from NC support team.

●Analyze the parallel run defects and assign it to proper team based on the root cause analysis, if needed.

●Assisted the offshore team by reviewing the test deliverables and optimizing the test case/scenarios for upgrade test.

ANDORRA TELECOM BILLING TRANSFORMATION AUGUST 2013 – NOVEMBER 2014

ANDORRA TELECOM, AD QA CORDINATOR, NETCRACKER TECHNOLOGY

●Involved in test planning for migration from legacy to upgraded system.

●Gather in-depth understanding of existing functionality through PL/SQL & Shell scripting code walkthroughs.

●Worked extensively on Oracle backend database using SQL to validate data Mapping and Data Integrity issues.

●Design end-end test cases for the SIT test phase which includes upgraded system as well as change related to custom, core, migration, upgrade and integration.

●Created end-end automated Sanity test suite using UNIX shell scripting.

●Facilitating the business users during UAT in results verification for IVT and parallel run.

●Assisted the offshore team by reviewing the test deliverables and optimizing the test case/scenarios for upgrade test.

AT&T WHOLESALE BILLING APRIL 2011 – JULY 2013

AT&T, US QA ANALYST, NETCRACKER TECHNOLOGY

AT&T upgraded and migrated the legacy Mainframe billing system to latest netcracker RBM version with new features and technology to scale up the wholesale billing for all its child service providers within US.

●Being the Feature Lead provide test estimation and strategy for the assigned features.

●Responsible for planning, designing and execution of test scenarios and test cases for the assigned features.

●Created mapping documents that provides insight about the existing legacy system and the new system providing the end –end connectivity.

●Designed the production test schedule for each Bill cycle that mimics day –to – day operations in live system.

●Responsible for Parallel Run Execution in PRODUCTION Environment and raised 400 + valid defects in and around the system.

●Along with testing the solution, also offered the initial triage/investigation into issues/defects found during testing.

●Analyze issues raised in production, provide quick workaround to ensure system is running smoothly.

●Automated the end-end ATWS solution Regression suite (shell scripting).

LEAP CRICKET RATING & BILLING IMPLEMENTATION JULY 2010 – MARCH 2011

CRICKET COMMUNICATIONS, US QA ANALYST, NETCRACKER TECHNOLOGY

●Develop test scenarios for SIT, CR phase and Regression cycles.

●Execute test cases for business areas like Usage guiding, rating, billing; bill formatting, Discounts and Activation.

●Interacting with SAs, BAs and developers for design issue conflicts and change requests against the current system behavior.

●Testing the production issues in isolated environment before deploying the fixes in production environment.

●Analyze the UAT defect prone areas and plan for regression tests to ensure the solution is stable in each build release to client environment.

●Facilitating the UAT client testers in preparing/identifying the test data upfront for the designed UAT tests for each release.

●Helping the business users in UAT to understand the design and flow of the system.

EDUCATION

JULY 2006- JUNE 2010

BACHELOR OF TECHNOLOGY (COMPUTER SCIENCE), Gautam Budh Technical University, India

Contact this candidate