Senior Business Systems Analyst /Senior QA Lead

Swapna Reddyshetty : ******.***********@*****.***

Senior Business Systems Analyst : 425-***-****

SUMMARY

I am a Senior Software Business Systems Analyst specializing in delivering SQL Database, Business Intelligence Data warehousing, ETL, SharePoint Online, Web applications, and Reporting applications.

I have 10+ years of extensive experience in software application Analysis, Design, Development, Test, Business interaction, Offshore-onshore coordination, and Team Management and Planning.

EDUCATIONAL QUALIFICATION

•Master of Science in Managing Information Technology, Sullivan University, Kentucky, USA

•Bachelor of Engineering in Computer Science, University of Madras

EXPERIENCE OVERVIEW

•Currently working as Consultant for T-Mobile Inc. at Bellevue, WA since April 2020 to till date in the role Senior Business Systems Analyst. Primary responsibility for this role is to manage business and technical requirements, CR's, configure, implement, and test strategies in the credit decision engine.

Date: April 2020 to Till Date

•I have worked as Consultant for PACCAR Inc. at Renton, WA since Feb 2019 to April 2020 in the role Senior Quality Analyst. I am working on analyzing, designing, test planning, configuring test environment, test scripts preparation, and testing database, BI data warehousing, ETL, and reporting, web applications along with RBAC/ABAC, Azure Portal, and SharePoint Online applications.

Date: Feb 2019 to April 2020

•I have worked as Consultant for T-Mobile Inc. at Bellevue, WA since April 2017 to Feb 2019 in the role of Senior Back Office UAT Test Lead. I have on analyzing, test planning, and configuring test environment for the testing database, BI data warehousing, and reporting applications. I worked with business and stakeholders to validate the Use cases, BRQ’s, and CR’s. I worked on UAT test cases and test scripts, business scenarios validations end to end and BVT validations.

Date: April 2017 to Feb 2019

•I have worked as Consultant for T-Mobile Inc. at Bothell, WA around 5 years in the role of Senior Business Intelligence SDET. I have worked on analyzing, designing, and developing databases, dashboards along test planning, configuring test environment, test scripts preparation, and testing database, BI data warehousing, ETL, and reporting applications.

Dates: 2016, 2015, 2014, 2013, 2012

•I have worked for Nuance Communications Inc. at Seattle, WA around 8 months in the role of Senior Software Test Engineer. I have worked on test planning, configuring test environment, test scripts preparation, test data preparation, code deployment, testing, and defect triaging for data base, reporting, and web based applications

Dates: 2011, 2012

•I have worked for Aztec Soft, Bangalore, India for 2 years in the role of Software Test Engineer. I have worked on test planning, test case preparation, and testing of data base and web based applications.

Dates: 2007, 2008

TECHNICAL SKILLS

Testing: Functional Testing, Black box Testing, White box testing, Integration Testing, Smoke Testing, ETL and Data Warehouse Testing, UI Testing, Unit Testing, System Testing, and Web applications Testing, Front end Report Testing, Mobile Testing

Test Automation Framework/Tools: Windows Test Technologies (WTT), Selenium, and Query Surge.

Databases: MS SQL Server 2005/2008/2012/2014, Toad for Oracle 11.5, Teradata SQL Assistant, SAS Enterprise Guide

ETL Tools: Informatica, Hadoop, PIG script, Sqoop, HIVE, HDFS, HBASE, SSIS

BI Tools/ Reporting Applications: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Report Info, Business Objects, OLAP, BO Universes, My Insight, Tableau

Scheduling Tools: TIDAL, Control -M

Engineering Tools: VSTS 2008/2010, Product Studio, Source Depot, Clear Quest, HP Quality Center (ALM), Test Director, Bugzilla, Jira, Rally, Azure DevOps

Operating Systems: Windows 7/Vista/XP/NT/Server 2003/Server 2008, UNIX.

OTHER SKILLS

•Requirements gathering, Analysis, and Development

•Agile Delivery and Water fall SDLC model

•Business interaction skills

•Test planning, test environment setup, test case preparation, test data generation

•Build/code deployment and configuring test environment

•Requirement mapping and test scripts preparation

•Use case validations

•Test plan, test exit report, and bug report preparation

•Bug Triaging

•Onsite-Offshore coordination and delivery

•Interaction with project management, Analysts, and Architects for requirement gathering

•Root cause analysis

•White box and Black box testing along with UI, Functional, Regression, Integration, Data Driven, User Acceptance (UAT), BVT, Smoke testing, and Use Case testing.

•BVT verification

•Identify and solve weaknesses in and out of the organization.

•Explore new ways of opportunities to increase client/customer satisfaction.

•Develop solutions for complex business problems inside the organization.

WORK EXPERIENCE:

#1. T-Mobile Inc., Bellevue, WA, USA (April 2020 – Till Date)

Senior Business System Analyst/ Senior Quality Analyst (Dual role)

Project:

Credit Risk Management

Credit Risk Management project is for business integration of Sprint and T-Mobile consumers. This project consists of TFB (T-Mobile for Business) and Consumers new BAN (Billing Account Number) origination for NTM (New T-Mobile) products, MaP strategies, AAL (Add a line), upgrades, device financing, lease, and loan based on the integration strategies.

Roles and Responsibilities:

Review and analyze business requirements and CR (Change Requests) documents for Consumer and TfB Originations, MaP, and Fraud Strategies.

Develop and update test plan documentation and test cases to match the business requirements and CR's.

Working on client integration GO-Live support, post Day1 tracking and defect test resolution.

Defining and mapping the test cases to requirements to ensure that all the requirements are tested thoroughly and meet the expected test results.

Working on the end-to-end business process and being liaison between the Business, Vendor and Client business team.

Translating the customer requirements into specific test plans and tasks using knowledge of the industry and delivery methodology.

Test Data setup and make sure to have access to the required systems for testing.

Configure, implement, test, and monitor the new and existing Consumer and TfB originations, MaP, and Fraud strategies and CR's.

Performing Strategy teams validation which is C part of A=B=C testing to make sure that there are no discrepancies and actual output CC match to the expected output CC for the given Consumer/TfB Originations or MaP strategies

End to end validations done for TfB Sprint BAN’s from TEA which are eligible for sprint migration (MaP) by submitting the credit requests through Salesforce (SFDC) and validating in TOGA UI and Samson tables.

Submitting the SOAP UI requests for Consumer and TfB, making sure that CRID application is created in TOGA UI

Verifying the application history in TOGA UI for the required CRID applications to make sure that AppType, CC, Store ID, Legacy Store Indicator, Dealer Code, Strategy Name, Number of lines requested, and Neg file details are correctly populated in the appropriate credit module request/response XML files.

Verify that all the CRID’s generated in TOGA UI are stored in appropriate tables in IAM DB which is system of record for TOGA.

Troubleshoot the issues and get them resolved by working closely with the appropriate project teams and resources until the issues are resolved. Work in war rooms until the issues are resolved.

Performing cross validations testing between Yellow Stack and Magenta Stack to make sure that both are aligned and final CC output matches.

Monitor closely to make sure the system and product is defect free.

Working with project teams and communicating about the status and issues effectively so that issues are addressed and resolved at the earliest.

Developing, updating, and maintaining the test cases in Q-Test

Creating and tracking the defects in Jira to until the issues are fixed, resolved, retested, reviewed with business and closed.

Environment: Oracle SQL Server, SAS Enterprise Guide 7.1, JIRA, Q-Test, TOGA, SOAP, Python, MySQL, Salesforce (SFDC), TEA, Splunk.

#2. PACCAR Inc, Renton, WA, USA (Feb 2019 – April 2020)

Senior Quality Assurance Analyst

Project:

Global Portal Project (GPP)

Global portal replaces existing two portals of North America and Europe which are over 10 years old and do not provide centralized access to information for external users, such as dealers, fleets and suppliers. The PACCAR Global Portal will serve as the logical, single point of entry for all trusted business partners in PACCAR’s value chain. Global Portal will provide the means by which dealers, fleets, customers, ISP’s and suppliers make nearly every electronic connection with PACCAR. Global portal will be hosted on Microsoft’s Azure Platform. Users will experience improved access and single sign on to the applications they use.

Roles and Responsibilities:

•Working in Agile test model.

•Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.

•Experience using query tools for Teradata and MS SQL Server to validate reports and troubleshoot data quality issues.

•Worked on Data Extraction, Transformation, and Loading with RDBMS and Flat files

•Experience in testing and writing SQL statements.

•Worked on managing large and complex data sets, extracts, clean and format data for Data Analysis using MS Excel, MS SQL etc.

•Extensive Working experience in applying Relational Database Management (RDMS) concepts.

•Experience in testing Business Intelligence reports generated by various BI Tools like Report Info, Business Objects, OLAP,

•Experienced in ETL Testing, BI Testing, and Data Quality Issues & Data Reconciliation process.

•Design test plans, scenarios, scripts, or procedures

•Develop or specify standards, methods, or procedures to determine product quality or release readiness

•Document software defects, using bug tracking systems such as HP ALM, Azure DevOps and report defects to software developers

•Develop testing programs that address areas such as database impacts, software scenarios, regression testing, negative testing, error or bug retests, or usability in Azure DevOps

•Document test procedures to ensure replicability and compliance with standards.

•Web application and mobile application testing for EID PASS (Empower ID PACCAR Authentication Software System) and IAM (Identity Access Management) applications

•Cross browser testing and GUI testing of EID PASS and IAM applications in all major supported browsers and operating systems.

Environment: Microsoft SQL Server, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), BI, ETL, Data warehousing, Jira, HP Quality center (ALM), Git, Azure DevOps, Sharepoint Online 2007/2010, Jira, TFS, CI/CD, .NET, Python RBAC/ABAC, Identity access management (IAM)

#3. T-Mobile Inc., Bellevue, WA, USA (April 2017 – Feb 2019)

UAT Lead/Business Analyst

Project:

Revenue Sub Ledger (BO UAT RSL)

I have worked on the Business scenarios and Use case validation, UAT test planning, UAT test case design, and test execution, BVT verification. Working with Business on daily basis to communicate the test status, issues, and road blocks and resolve them on timely manner.

Roles and Responsibilities:

•Involved in user acceptance testing to ensure that developed systems satisfy the needs of business clients as specified in the functional requirements and business requirements.

•Working in Agile and Waterfall SDLC methodologies

•As a UAT Test lead, involve in interactions with business users to analyze the BI reporting needs and requirements to design and develop valuable BI solutions

•Involved in design, development and implementation user acceptance testing protocols in the final phase of applications development.

•Capturing and testing all modifications to proposed functional requirements.

•Making sure that all project timelines and deadlines are met.

•Assisting clients and teams in producing high quality applications.

•Actively participating in project meetings and discussions.

•Analyzing the Sprint requirements from the user stories and acceptance criteria, creating test cases, executing the test cases, engage in the defect resolution process, and look for automation integration if required.

•Setup QA environment including builds and installation of required software applications

•Designing and implementing the robust, scalable, and high quality test automation suites, to improve quality and productivity of functional and regression tests.

•Documenting the test strategies and procedures for quality assurance and testing to maintain high data integrity

•Using Rally as test management tool for creation of test cases, execution results, and for the defect triage in Agile delivery model.

•Leading the Release Readiness and Demos

•As a test lead adding value to the business by delivering the quality products on time

•Performing the KPI validations as per the business requirements

•Onsite – Offshore co-ordination to perform day to day activities.

•Working closely with business and stakeholders to verify the business requirements are met

•Defects identification and bug triaging

•Extensive Working experience in applying Relational Database Management (RDMS) concepts.

•Experience in testing Business Intelligence reports generated by various BI Tools like Report Info, Business Objects, OLAP,

•Experienced in ETL Testing, BI Testing, and Data Quality Issues & Data Reconciliation process.

•Design test plans, scenarios, scripts, or procedures

•BVT validations

•Working with developers, functional analysts, architects, and upstream systems for bug triaging and in case of any issues identified and incase of any clarifications needed.

•Explore new ways to increase client/customer satisfaction

•Develop, document and maintain complex business models and should interact with all departments and should participate on business meetings of the organization.

Environment: MS SQL Server2012/ 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio.NET# 2008Mi, Microsoft Excel, Tableau, TSQL, ETL, Data warehousing, Rally, HP Quality center, Informatica, Teradata, Oracle, Business Objects, Universe, Report Info.

#4. T-Mobile Inc., Bothell, WA, USA (2012 - 2016)

SQL\ETL\BI SDET

Projects:

T-Mobile Tuesdays

Digital Analytics and Reporting

Integrated Data warehouse

Wal-Mart Family Mobile

Serialization Replacement

Bridge to Value

Enhanced Bridge to Value

ACC Reporting – Go Smart and Bright Sport

Prepaid Campaign Management

Enterprise Product Catalog

I have built and tested data base, ETL, data warehousing, and BI reporting applications.

Roles and Responsibilities:

•Working in Agile and Waterfall SDLC methodologies

•As a Test lead I have interactions with business users to analyze the BI reporting needs and requirements to design and develop valuable BI solutions

•Involved in Sprint Planning, Daily Stand-up, Sprint Review, and the Sprint Retrospective meetings

•Design and development of SQL objects such as tables, views, stored procedures, indexes etc.

•Development and quick delivery of reports for adhoc requests from business.

•Experience in development of reports and Dashboards using tools SSRS and Tableau.

•Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

•Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.

•Analyzing the Sprint requirements from the user stories and acceptance criteria, creating test cases, executing the test cases, engage in the defect resolution process, and look for automation integration if required.

•Setup QA environment including builds and installation of required software applications

•Designing and implementing the robust, scalable, and high quality test automation suites, to improve quality and productivity of functional and regression tests.

•Documenting the test strategies and procedures for quality assurance and testing to maintain high data integrity

•Using Rally as test management tool for creation of test cases, execution results, and for the defect triage in Agile delivery model.

•Leading the Release Readiness and Demos

•As a test lead adding value to the business by delivering the quality products on time

•Performing the KPI validations as per the business requirements

•Working on Tableau reports, dashboards, and score cards for the data visualization and data analytics which helps business users to take decisions.

•Very good experience in understanding the processes and technical skills, including an understanding of manual and automated test execution and performance related tools.

•Onsite – Offshore co-ordination to perform day to day activities.

Leading offshore team of size of 5

•As a test lead conducted Test plan and exit report reviews

•Leading the Bug Triaging (using Rally, HP Quality center, Bug zilla, Jira)

•Extensive experience in Dashboard and ETL tools (SSRS, SSIS, and Tableau, Informatica)

•Experience in Reporting applications (Business Objects, OLAP cubes, Report Info)

Environment: MS SQL Server2012/ 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio.NET# 2008Mi, Microsoft Excel, Tableau, TSQL, ETL, Data warehousing, Rally, HP Quality center, Informatica, Teradata, Oracle, Business Objects, Universe, Report Info.

#5. Nuance Communications, Seattle, WA, USA (2011 - 2012)

Senior Software Test Engineer

Projects:

Mobile Devices Certification for

•T-Mobile G2 & ZTE Roamer Z990 (Android 2.2)

•Samsung Galaxy Ace, HTC EVO 3D & HTC Bliss S510b (Android 2.3)

•LG Encore & LG Spice (L4 /WISE)

•Samsung Galaxy and Samsung Smiley2 (SHP)

•BlackBerry (RIM)

•Nokia N8, Cider, E73, E66 (Symbian)

I have worked on Device certification on mobile devices to verify NMC client functionality.

Roles and Responsibilities:

•Analyzing the requirements of Mobile Device Systems

•Designing Test Cases

•Setting up the test environment and deployment of Application packages which involves Installation of drivers, Java JDK packages, Operating system.

•Testing Desktop Applications, various Mobile Devices with various Mobile platforms, Emulators and Simulators.

•Testing the functionality of the NMC application using Manual and Automation testing.

•Executing the Test cases of both Manual and Automation using the TVA test harness on the device.

•Using ADB shell commands to pull the Test results from the device

•Using TVA reader tool to interpret the Test results

•Analyze the Test results and log the bugs in Bug tracking tool.

•Bug Triaging

•Root cause analysis.

•Sanity Testing, Functional Testing, Regression testing and UI testing.

•Preparing the Documentation with the behavior both in terms of Audio and functionality of each device.

•Training the new resources on device certification process.

•Participating in business, technical, and team meetings.

Environment: Android SDK, Java JDK 6.0, ADB shell commands (Android Debug Bridge),

JIRA (Web based Bug Tracking Tool), Test link 1.9, Perforce P4, Python.

#6. AZTEC Software and Technology Services Limited, Bangalore, India (2007 – 2008)

Software Test Engineer

Projects:

Member Connect Reporting System

INFORMA Forecasting Application

Mobile Commerce Service Applications

Optimum Suite Applicant Tracking

I have worked on testing the data base, web based, and reporting applications.

Roles and Responsibilities:

•Analyzing the Reporting application requirements and designing the Test Scenarios.

•Testing the Excel based Member Connect Reporting Applications

•Testing the Reporting application functionality

•Database Testing using TSQL

•Verifying the Report data by checking against Back end data

•Verifying each of Report fields drop down list values with Back end data

•Report Security Testing

•Checking the Data restrictions

•Verifying the User security access

•Setting up the reporting environment

•Deploying the build on test environments

•Writing C# programs to automate report executions

•Writing Batch files to automate the tasks of Build deployments

•Test case design, Execution, Bug Triage, Root cause analysis, Requirements analysis

•Regression Testing.

Environment:

TSQL, C#, Microsoft .NET Framework, Visual Studio Team Foundation

OS Batch, VSTS 2008/2010, SQL Server 2005/2008, SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, METAL (ETL Tool), OLAP CUBE, Java5, J2EE 1.4, JBoss

Contact this candidate