Quality Assurance Business Intelligence

SUNITHA MAOURAM

Phone: 812-***-****

E-mail: **************@*****.***

SUMMARY

~13 Years of Software Quality Assurance / Testing experience in Data Warehouse, ETL processes, Data Marts, Web, and Client-Server Systems, API and Applications for Banking, Financial, Transportation, and Retail Domains.

Expertise in both software developments (SDLC), Agile and testing (STLC) life cycle processes.

Highly practiced in creating test plans, test strategy, test cases and developing test scripts using test automation tools in various software applications.

Expert in all aspects and various phases of the SDLC (Water Fall and Agile methodologies).

Thorough knowledge in scripting languages like VB Script, Java Script, .NET technologies.

Expertise in tracking the Defects using the defect tracking tool and reported the bugs in the ALM & Clear Quest and Octane.

Analyze bugs, troubleshooting with software development and other teams to fix errors.

Proactively assist in troubleshooting to identify and resolve issues early.

Experienced in ETL, Database and Business Intelligence (BI) testing.

Hands on expertise in Data ware housing concepts and tools. Tested the ETL processes where in the organizations may use Ab Initio, Informatica, Microsoft, SAS tools.

Has thorough knowledge on Extraction, Transformation and Loading (ETL) process, Data Warehouse, Business Intelligence, Reports, Dashboards, Dimensional modeling, Star and Snowflake schema, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.

Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end, Performed end-to-end testing.

Expertise in writing SQL/PLSQL and SQL complex Queries for data validation.

Developed and Executed Automation testing solutions using HP-UFT/QTP, Selenium, TOSCA automation through a successful POC.

Expertise in Windows & UNIX/LINUX OS Platforms as well as Mainframes.

Possess excellent analytical, verbal, written and interpersonal skills.

Strong attention to detail, producing detailed, accurate and reliable documentation.

Strong understanding of cloud computing concepts and cloud based technologies.

Experience in working Onsite/Offshore models.

EDUCATION

Bachelors of Technology in Computer Science, J.N.T University, India

CERTIFICATION

Microsoft Certified: AZURE (AZ-900) Fundamentals

TECHNICAL SKILLS

Testing Tools : Micro focus UFT, Selenium, TOSCA(POC)

Bug Tracking Tools : HP Quality Center/ALM, IBM-Clear Quest, Jira, Octane.

Relational Database : Oracle, SQL Server, Teradata,

Reporting /ETL Tools : SSRS, Informatica

Browsers : Internet Explorer (IE), Chrome, Fire Fox, Safari, Microsoft

Scripting Languages : VB Script, Java Script,Python, Shell Scripts

Programming Languages : C, C++, Java, .NET

Operating System : MS-Windows and UNIX/Linux

CI/CD tools : GitHub, uDeploy, Jenkins

API Testing : SOAPUI,REST

Others : Visual Studio, Eclipse

PROJECTS PROFILE

#1 Wells Fargo, Charlotte, NC Dec’17 – Mar’25

Projects: Enterprise Reference Data Project, EPIC and ElW

Position: Senior Software Engineer/Senior Systems QA Analyst

Responsibilities:

Involved in Sprint Planning, Agile/scrum stand up meetings, backlog meetings and analyzed acceptance criteria, story description, load rules and mapping of a story.

Involved in writing test cases and upload it to Quality Center and later used Octane tool instead of ALM.

Solid understanding of source to target data mapping.

Involved in smoke testing, integration testing, UAT and regression testing of IDQ and MDM tools.

Wrote complex SQL queries using joins, sub queries and correlated sub queries between source and target.

Involved in end to end ETL testing on Data warehouses to validate data extraction, transformation and loading processes.

Performed Unit, System, Regression and Integration and Regression and Data Validation testing in SIT, UAT, PROD and BCP environments.

Involved in writing and executing automated test scripts in UFT tool for EPIC project.

Developed Java based automation scripts using Selenium to validate data for EIW project.

Conducted a POC on TOSCA to evaluate its feasibility for automating regression Test cases.

Involved in executing test cases against mapping in Teradata (ETL process) and Oracle SQL Developer (IDQ process) tools.

Involved in running Abnitio and Informatica Jobs through Autosys.

Have the knowledge to IDQ tools and CI/CD deployment tools like GitHub, Jenkin and uDeploy, IDQ Admin.

Good working experience in API testing using SOAP web services and XML for the NRT validations.

Used UNIX commands for the file processing and troubleshooting deployment issues.

Involved in creating CR in Service Now for UAT and Prod deployments.

Logged defects in Quality Center/ALM and Octane and participated in entire Defect Life Cycle.

Involved in Onsite offshore co-ordination.

Tools & Environment: JIRA,HP Unified Functional Tester (UFT) 14.0, Selenium, Java, Octane, HP- ALM, IDQ, Ab Initio, Oracle, Unix, Shell scripting, Teradata SQL Assistant, Teradata Studio, Autosys.

#2 Wells Fargo, Charlotte, NC Sep’15 – Mar’17

Project: Contact Center / Call Center, Money Transfer System (MTS)

Position: Systems QA Analyst

Responsibilities:

Understanding the Functional Specification and Business Requirement documents.

Involved in writing Ambiguity review, Test plan and Traceability Matrix documents.

Responsible for writing Test Cases in QC/ALM using Master Design Document.

Involved in Smoke, System and Regression testing.

Involved in executing the test cases in QC/ALM and analyzing the results.

Detected Defects, Communicated to the developers using Bug Reporting Tool and Tracking the Defects using QC/ALM.

Mapping all the Requirements to specific Test set and Test cases in Quality Center and Involved in designing and maintaining Requirements Traceability Matrix.

Used Splunk to monitor application logs and identify root causes for test failures.

Involved in FSD, BRD internal review and QA hand over meetings.

Lead different QA people in onsite and offshore for every release.

Involved in verifying the middleware logs in WinSCP /SLOG.jar files.

Involved in conditioning the data in Hogan mainframe.

Tools & Environment: HP-Quality Center/ALM, Java, UNIX/Linux, XML, HTML, MS-Office, SWIFT, Splunk

#3 Rail Inc., Cary, NC Aug’14 – Jan’15

Project: MRR (Mechanical Resource Repository)

Position: QA Engineer

Responsibilities:

Analyzed project requirements and convert them into test requirements.

Involved in converting user stories into Test Scenarios and Test Cases.

Involved in creating automation test scripts using Hybrid Framework using UFT.

Used Teradata SQL Assistant for different queries for retrieving the data from Oracle and Teradata data bases.

Used SOAP UI and MQ for verifying server logs.

Involved in logging the defects using Rally software.

Involved in attending Agile Scrum meetings for planning stories, status updates, retrospective, backlog, demos etc.

Involved in writing and executing SQL queries in Teradata SQL Assistant.

Developed parameter driven ETL processes to map source systems to target data warehouse with SAS complete source system profiling.

Created custom Splunk queries to validate backend processing and ensure data consistency.

Written Complex SQL queries to validate the data conditions for ETL testing.

Involved in QA meetings to provide testing updates.

Involved in Manual and automation regression test case executions

Tools & Environment: Windows XP/7, HP-UFT, Rally, ALM/QC, VB Script, SAS, Teradata, Tera data SQL Assistant, SOAP UI, MQ.

#4 Capital One, Richmond, VA July’13 – July’14

Project: Capital One Mobile App & EOS

Position: Mobile/Web QA Analyst

Responsibilities:

Analyzed project requirements and convert them into test requirements.

Created Test Plan, Test Strategy and Test Case Index and convert them into test cases.

Extensively used HP Quality Center for all the testing activities; primarily used Requirements, Test plan, Test lab, and Defects, Dashboard tabs.

Involved in Mobile Testing of Capital One Mobile Application and Mobile Online website.

Developed automation test scripts with HP-UFT automation scripts using Keyword driven framework.

Created Images in Perfecto Mobile tool and execute the scripts from Quality Center/ALM.

Involved in writing and executing test cases for iOS and Android Devices.

Involved in writing EOS functions and test cases using VB Scripting.

Involved in writing SQL queries to test the data at backend.

Used SOAP UI tool to validate the XML SOAP Requests for the API testing.

Involved in logging defects in ALM/QC and participated in various phases of Defect Life cycle.

Involved in attending Agile Scrum/Sprint meetings for maintaining team standards, tools and best practices.

Documented all phases of QA processes.

Tools & Environment: Windows XP/7, Mac, HP-UFT, Perfecto Mobile, QC/ALM, VB Script, SOAP UI, Selenium, MS-Office, iOS, Android, Android Studio iPad etc.

#5 Lowe’s Companies Inc., Mooresville, NC Jan’12 – Jun’13

Project: Genesis (POS)

Position: QA Analyst

Responsibilities:

Responsible for the successful completion of Test design for the assigned category, including test condition grouping and test case creation.

Involved in Design and development of QA test plans based on high-level and detailed designs

Analyze, Design and Develop/Enhance Enterprise Test Automation Framework.

Developed automated regression test suite for Lowe’s Store POS System (Genesis).

Development the automation scripts by using Terminal Emulator Add-in of QTP.

Create, debug and run the test scripts/procedures in QTP.

Validated the DB2 and Teradata Database tables/columns/rows as part of Backend testing.

Preparation of quality documents like Test Plan, Test Execution Plan and Test Execution Summary Reports.

Execution of the automation scripts on different releases.

Logged defects in Quality Center/ALM and Participated in Defect Triage Meetings.

Closely worked with QC Admin during the ALM QC Migration (from 10 to 11) and made sure all the Genesis Project artifacts are retained after the Migration.

Lead the offshore automation team and involved in taking status from them.

Tools & Environment: QTP 11, QC/ALM 10/11, C, UNIX, SQL, .NET, DB2, UDB, Teradata, Mainframe, Hummingbird Exceed and Attachmate XTRA.

#6 Wells Fargo, Charlotte, NC Nov’10 - Dec’11

Project: Contact Center / Call Center

Position: Systems QA Analyst

Responsibilities:

Understanding the Business Requirement Specification.

Developed Keyword Driven Automation Framework using descriptive programming in QTP.

Developed automation scripts using QTP and integrated the script with Master Script.

Ensure that all the Test Scripts are written and updated in Quality Center.

Writing Test scripts and functions wherever necessary for various units of the business modules.

Developed shared object repositories in QTP and stored in Quality Center.

Involved in Functional Testing with Valid/Invalid inputs under different scenarios.

Involved in Regression Testing using QTP.

Involved in converting Win Runner Scripts to QTP Scripts.

Involved in developing Test cases, Test Execution and Reporting Defects.

Preparation of weekly and monthly status reports.

Involved in project meetings and interacted to other team members in order to resolve the problems.

Tools & Environment: HP-QTP 9.5, HP-Quality Center 10.0, Win Runner 9.2, .NET, UNIX/Linux, XML, HTML, DHTML, Shell Script.

Contact this candidate