Post Job Free

Resume

Sign in

Manager, Test Data Management, QA management, SQL, Soap UI, Telecom

Location:
Atlanta, GA
Posted:
November 11, 2016

Contact this candidate

Resume:

As a Test Data Manager, Test Delivery lead, Automation Engineer and QA Test engineer, I have experience in all phases of software Lifecycle, right from architecture design phase to requirement gathering, developing Test Cases, Test Plan, Manual testing, Automation testing in Client/Server, Windows, UNIX/Linux and Web based applications. Good experience in Finance and Telecom Billing sectors with strong Business and Functional knowledge.

Excellent understanding of Software Development Life Cycle (SDLC), STLC and importance of QA in Development/ Enhancement and Maintenance of software applications.

Experience in implementing testing process & quality standards.

Expertise in Manual and Automated Testing in different testing methodologies like Agile and Waterfall. Good skills in data analysis and problem solving test strategies.

Good experience in leading onsite and offshore team in Agile and waterfall methodology.

Experience in working with Business and different implementing partners at client to manage the test data and held responsible to load the data in to environments coordinating with different applications and technologies involved.

Follow the scrums using project management tool like Jira.

Experience in working with Quality Center ALM as bug tracking tool.

Developed & Implemented effective Test Plan and Test cases based on the user stories (Functional requirements) related to SOA architecture and Web Services.

Proficient with automation testing using Quick Test Professional and developing function libraries in VB script for QTP.

Managed testing of applications and web products that are developed on .Net and Java.

Used SoapUI to test web services and to run the automated scripts to create customer data.

Experience in analyzing business specification documents, developing test plans, defining test cases, developing and automating test scripts.

Good experience in QTP – VB Script programming standards, developed reusable functional libraries which are used in different scripts. Good experience in handling custom objects, exception handling/Recovery Scenarios in QTP and also familiar with String functions, Date functions, Math functions and other related QTP functions.

Supported DevOps teams and Performance teams and partially responsible for load testing using load runner.

Tracked, reported and updated the team using Team Foundation Server (TFS)

Experience using different Frameworks like Hybrid, Keyword and Data Driven frame works in QTP, and extensively worked on Scripting using Shared Object repository and Descriptive Programming.

Extensively worked on Backend testing using SQL.

Worked with Jira as a product management tool.

Maintained the Environments like DIT, SIT, UAT, QAT, Pre-Prod and Prod along with DevOps teams

Assisted in Creating Jenkins Workflows for pre deployment process (DB execution, Environment configuration changes etc.) on both QA and preproduction Environments

Hands on experience on Jerkins and Selenium web driver.

Hands-on experience in Black Box Testing, White box testing, Unit Testing, User acceptance testing (UAT), Functional, Integration, GUI, System, Usability, Regression, Performance, Security, Stress Testing and blackout testing.

Hands on experience on Billing tools like OMS Application Console, API Tester, AS400 and Centivia.

Participated in requirement review meetings, analyzing requirements, developing test plan and test cases, Requirement Traceability Matrix, Defect management, Reporting and tracking.

Proficiency in Structured Query Language (SQL), Joins, stored procedures.

Excellent Analytical and problem solving skills, Interpersonal and communication skills. Result oriented, committed and hard working with a quest to learn new technologies and undertake challenging tasks.

Highly motivated, self-starter able to work independently and collaboratively within a diverse technical team.

TECHNICAL SKILLS

Operating Systems

Windows XP, UNIX

Testing Tools

Jira, TFS, Quick Test Professional ( QTP ), HP Quality Center ALM, Jenkins, Soap UI, Post man Collection, Load Runner, Selenium,

Languages

C, C++, Java, Visual Basic (VB), .Net, VB Script, SQL, HTML, XML, Java Script, JSP, VB Script, Visual source safe

Databases & other tools

Oracle 9, 10, 11, MS SQL Server, MS Access, SQL Developer, Toad, Microsoft Office Suite, AS400, Centivia, API Tester,OMS application Console.

App/Web Servers /

HTML, XML,

Education:

Master’s Degree from Southeast Missouri state university.

Postgraduate Degree in Management and Entrepreneurship (MBA) from IMI.

PROFESSIONAL EXPERIENCE

T-Mobile, Dunwoody GA (2014 Till Date)

Test Data Manager

T-Mobile is one of the nation’s largest Telecom Company which provides prepaid and contract voice and data mobile services. The projects that I worked on testing at T-Mobile are Uprising and Rebellion which are known as a unified system interface of all types of service modules like Order management, billing and provisioning in a single interface when accessed through multiple channels. As a Test Data Manager I am responsible to setup the environments with relevant test data by leading the team and deliver the best Test planning & execution.

Responsibilities:

Responsible for overall project test data planning and execution

Developed detailed test data management strategy.

Responsible for track of test data load in DIT, QAT environments.

Reviewing Business, Functional requirement documents and User Stories of Rebellion and Uprising projects of T-Mobile USA, Inc.

Lead team onshore and offshore to ensure different kinds of data is tracked and acquired before the sprint plan

Studied high level architecture and involved in strategic planning meetings.

Follow the scrums using project management tool like Jira

Involve in installation, configuration of QA Testing environment.

Worked with Business Analyst, Technical Architects, SA’s to identify the functional scenarios to anticipate relevant data.

Involve in developing Data Management Scope and coordinated with sprint plan and deployments

Involve in integrating the databases with client databases from different implementing partners

Worked with tools like centivia, IMEI generator, OMS console and IBM Config to manage data

Involve in Web Services validation and XML validations.

Assisted in performance testing by providing data to test using load runner.

Tracked data request and bridged the gaps of development, implementing partners, vendors, architects and testers to ensure the smooth go of the project.

Responsible to run automation scripts using selenium to create data through Rebellion UI.

Participated in Integration of Automation scripts (Selenium WebDriver API) on Continuous Integration tools Jenkins for nightly batch run of the Script.

Worked with Ericsson and Amdocs billing modules.

Maintained the Environments like DIT, SIT, UAT, QAT, FCT, MIT, Pre-Prod and Prod along with DevOps teams.

Assisted in Creating Jenkins Workflows for pre deployment process (DB execution, Environment configuration changes etc.) on both QA and preproduction Environments

Validated SAMSON and Ericsson Databases

Worked closely with third party vendors -payment and non-payment vendors like j-payment, VESTA Q pay and TCAT to integrate the data in to target environments.

Validation of Data in CSR application with Database.

Involve in attending daily SCRUM meetings to provide the status of QA testing activities.

ENVIRONMENT: Jira, Jenkins, Test Flight, HP QC/QTP, Load Runner, Clear Quest, Cucumber, HTML, XML, Oracle, Windows 7 Professional, SQL, UNIX, JAVAEE, JQuery, Java Script, VB Script, VB.Net, PHP, PERL, MySQL, Microsoft office, Android, iOS.

T-Mobile, Dunwoody GA (2013 to 2014)

Senior Quality Test Delivery Lead/ Test Data Lead.

T-Mobile is one of the nation’s largest Telecom Company which provides prepaid and contract voice and data mobile services. As a Test Delivery Lead I am responsible to deliver the quality of web interface by leading the team and deliver the best Test planning & execution.

Responsibilities:

Participated in developing test strategies, procedures and performed Risk Analysis.

Developed detailed test plans/matrices that satisfy all required project test conditions.

Detected Defects, communicated to the developers and Tracking the Defects using Test Manager.

Reviewing Business, Functional requirement documents and User Stories of Rebellion and Uprising projects of T-Mobile USA, Inc.

Involve in installation, configuration of QA Testing environment.

Responsible to run automation scripts using selenium to create data through Rebellion UI.

Working with Business Analyst, Technical Architects to identify the functional scenarios for testing.

Involve in developing test plan, test cases, and Scope.

Run Bill cycles using Unix commands to age customers.

Add usage to the customers by running web services.

Involve in developing SQL queries to validate data in database.

Involve in loading data in QA testing environment.

Involve in Web Services validation and XML validations.

Validation of Data in CSR application with Database.

Involve in login to UNIX / Linux to validate log files.

Involve in attending daily SCRUM meetings to provide the status of QA testing activities.

ENVIRONMENT: HP-UNIX, Windows, AS 400, IE 8.0, WebLogic

TitleMax, Alpharetta GA (2012 to 2013)

Automation Engineer

TitleMax is one of the nation’s largest and most reputable title lending companies. The application that I worked on testing is QFund a premier short term financial lending solution. As an automation tester I worked on automating the data entry, account and loan creations etc. and also developed the scripts to validate the Front and back end for the Regression suite.

Responsibilities:

Participated in developing test strategies, procedures and performed Risk Analysis.

Developed detailed test plans/matrices that satisfy all required project test conditions.

Detected Defects, communicated to the developers and Tracking the Defects using Test Manager.

Developed test scripts for Data driven testing using parameterization in QTP by using Excel sheet for test data and Database Queries based on the functionality.

Extensively worked in VB scripting

Developed reusable scripts which can be used in different scripts.

Developed reusable SQL library files and called them from different scripts by passing the variables

Extensively worked in developing SQL queries using join statements and performed calculations to get different financial calculations

Developed & Implemented effective Test Plan and Test cases based on the user stories (Functional requirements) related to SOA architecture and Web Services.

Developed Driver scripts by calling different scripts and passing the parameter values

Validated the financial calculations and logics in the front end according to the website functionality

Worked closely with the migration, development, DW reporting teams to better understand

Validated and updated the scripts with the CRs in different versions of the Qfund releases

Developed and maintained strong knowledge of business/products, systems, and quality assurance procedures and methodologies.

Tested Web Services and XML using SoapUI

Extensively worked on Backend testing using SQL.

Monitoring the Scripts, functions and SQL, Object repositories versions in Visual Studio.

Executed the efficient testing of new or enhanced systems to validate processing in accordance with approved business specifications and test plans.

Actively involved in functional, unit and integration testing in Waterfall methodology. Worked on QTP hybrid framework (Data Driven), identifying the functional areas and created different functions to make the scripts reusable in Quick Test Professional (QTP).

Performed extensive Black-box testing. Designed Stored Procedures to extract and manipulate data from the back end database using SQL Queries.

Performed extensive End-To-End testing and UAT of the process by working in coordination with the TMAX Customers.

Environment: Microsoft Test Manager, QTP 11.0, SoapUI, Windows XP 32 Bit Version, Java, SQL, Oracle 11g, MS Office 2007

Frontier Communications, Rochester, New York (2011 to 2012)

Sr.QA Test Analyst

CRM 9.2 Sterling Ordering Module, Small Business (Commercial), Single Line Customer for Non-Complex products, APIs, Q4 Promotions, Existing Promotions and Rewards, Billing Information, Monthly Bill, Commercial Contract Terms on Bill, Perorations and Vertex. Regression – Residential CRM7.2 and Performance testing of Commercial.

Responsibilities:

Setting the Environment and sanity check before starting the Testing of Product

Worked on AS400 to verify the Directories.

Worked on Databases using TOAD to validate databases

Worked on API and ESB to validate the correct flow of information

Tested products like Access lines, Bundles, IPTV etc.

Worked on Sales force based CRM.

Assigned Test defects to the developer and followed up to resolve the issue.

Conducted smoke tests periodically to ensure all CD and CC order types are getting executed.

Reviewing the Project Requirements and Preparing Test Plan and estimating the testing effort

Extensively worked on Sterling 9.1 – CRM, DPI, API, Billing and FBF.

Looking entire E2E SIT testing for new functionality implementing Commercial business in CRM.

Creating and executing regressive UNIX Scripts for alerts for making sure env is up and running.

Worked in Production like Environment with Huge Volume with Various Interfaces involved.

Coordinated with development, Infra and ADBA teams on an issue to get it resolved and if required to get it fixed thru Defects.

Participated in Daily Defect's Status Meetings along with UAT team and Development team, working closely on High priority and Severity defects.

Reported directly to managers and directors working in the war room with providing status on all issues and progress of Execution.

Responsible for overall testing of software products with Quality with the least number of defects to be in production.

Manage daily status mail and calls to provide updates for issues within the Team.

Coordinated with offshore team for daily tasks and path forwards, for the progress and issue tracking of execution.

Test Execution is a combination of glass box and black-box approaches due to the Timelines

Languages: C, C++, Java, AS 400, DPI, Power Builder, XML, Quality Center

ENVIRONMENT: HP-UNIX, Windows, AS 400, IE 8.0, WebLogic

ICICI Securities Ltd, Hyderabad, India (2007 –2010)

Wealth Manager & QA Tester

ICICI Bank provides a diversified line of financial services, including business and personal banking, wealth management, estate planning and investments through its affiliated companies. The project involved testing the online Banking and Client Management applications that provide client account information. The modules under test were Order Management and Transaction Management.

Responsibilities:

Reviewed test cases for requirements coverage, ambiguity, and completeness.

Performed manual testing on different modules of the application.

Worked with DBA and developers to resolve the performance bottlenecks.

Performed Functional, Integration, System and Security Testing.

Performed web specific testing like Link checking, Browser page testing, Application Testing and Security Testing.

Documenting the Test results using Quality Center

Query databases to retrieve data through Joins and Select statements

Attended meetings with Developers, Team Leads to create a friendly manner and helped them to solve the errors.

Extensively used FTP tools for copying files across different UNIX servers, from Windows to UNIX and vice versa.

Interacted with the Testing and Development team to resolve and follow up on development issues.

Reported results and updates to the QA Lead.

ENVIRONMENT: Quality Center, Java, JSP, Servlets, Windows 2000/NT, SQL-Server, Web Logic, HP-UX, Oracle, Solaris.



Contact this candidate