TIRUMALA KANNAN

Email: adgr4i@r.postjobfree.com

Ph: 703-***-****

https://www.linkedin.com/in/tirumala-kannan/

EXPERIENCE SUMMARY

US Citizen with secret clearance, ISTQB certified, Quality Assurance Lead with 16yrs of diversified testing experience in ETL, OBIEE in Client/Server, Web Applications using Manual & Backend and automation Testing technologies. Result oriented Business Intelligence Professional with a focus in Stakeholder/Client. Strong knowledge of all phases of Software Development Life Cycle (SDLC) and Bug Life Cycle (BLC). Excellent analytical, problem-solving, decision making, interpersonal, presentation skills and communication capabilities, managing customer/stakeholder expectations. Strong experience in converting Business requirements into Test cases & executing the same. Formulating Test Plans, test scripts based on the Use cases, User Requirement Document and System requirement documents for the Functional, Unit testing, GUI, Front end, Back end, ETL Testing. Extensive experience in identifying potential problems, evaluating and testing them against business requirements. Conducted Review meetings with IT Managers, Project Managers and testers about the project plans, project specification. Excellent track record of successful completion of multiple projects under tight deadlines. Self-motivated, quick learner with excellent communication and interpersonal skills. Very effective as an individual and as a team player, ability to perform multiple roles as Team Lead, Resource Management as well as Service delivery. Capable of bringing overwhelming enthusiasm and awareness to projects, while applying professional judgment, keeping teams focused and delivering success in rapidly evolving and dynamic environments. KEY SKILLS

• Designed and developed

Software testing Methodologies

and strategies

• Created test plan, test script, test

scenarios and test cases

• Business Requirement analysis

• ETL Testing

• E2E Testing

• Unit Testing

• Integration Testing

• UAT Testing

• Risk Assessment and Root

Cause Analysis

• Project Management

• Documentation Writing

• Requirements Management

• Customer engagement

• Customer engagement

• Data Analysis

TECHNOLOGIES AND TOOLS

• Linux, Windows

• Oracle, SQL Server, Netezza,

Mongo DB

• AbInitio, Informatica

• Python 3.5+

• Java

• XML

• SQL Developer

• TOAD

• Aginity Work Bench

• ODI

• UI Path (RPA Tool)

• BI Publisher, BI Analytics,

BI Answers

• Qlickview

• Beyond Compare

• JERA, DOORS

• Confluence, Testlink, Share Point

• Gitlab

• XML Spy

• ER Studio

• HP/ALM QualityCenter

• QTP, Win Runner

• Test Director

CERTIFICATIONS & TRAININGS

ISTQB Certification

Completed training in SQL, UNIX, 508 Testing

ETL tools (Informatica, Ab Initio and ODI)

OBIEE Tools (BI Publisher, BI Dashboard and BI Answers) Qlickview Training

UI Path (RPA -Automation Tool)

EDUCATION

Master’s in science Pondicherry University, India

Master’s in philosophy Pondicherry University, India Bachelor’s in education

Client: Security Exchange Commission May 2019 - Current Employer: Inode ink corporation

QA /QC Lead

The mission of the SEC is to protect investors; maintain fair, orderly, and efficient markets; and facilitate capital formation. The SEC strives to promote a market environment that is worthy of the public's trust. Inode supports SEC DERA since October 2016 with big data development solutions. Together with QRADS teammates Green Zone Solutions and Booz Allen Hamilton, Inode looks forward to continuing to evolve and enhance the SEC’s ability to provide data services to enable quick turnaround of high-quality data sets for analytical purposes across the Commission. Responsibilities:

Lead software quality assurance by guiding team through the creation of Test Plan, Test Scenarios, Test cases and Testing Summary documents with all possible Use Case to cover all testable function for Positive

& Negative Testing

Analyzing source data from various environment using complex SQL queries and advanced analytical functions.

Working closely with the PM, Developers and Business Analyst to gather and review Business requirements

Participating in weekly project the meetings, team meetings, Code/design review, Defect review and retrospective meetings

Designed RTM to track all requirements are covered, tested and to maintain the test cases status

Tracked and reviewed the requirements in Jira to make sure the functionality of the application is covered

Opened defect tickets in Jira with defect found while testing

Deployed DDLs in multiple databases and created home directory/folders and configuration files by checking out the code from Gitlab

Executed Python scripts in Linux server for the ETL Transfer of data (Ingestion, data pull and rollback) from source to Target tables

Performing Unit testing and E2E Functional testing of the of the projects using Oracle and Netezza databases

Created corn jobs to run the etl scripts on daily, weekly, monthly and quarterly basis

Uploading testing documents to Gitlab after completion of E2E and UAT testing

Working on highly complex projects in many different and varied technical areas and business segments Client: Defense Security Corporation Agency January 2018 - May 2019 Security Cooperation Enterprise Solution (SCES)

Employer: Inode ink corporation

QA Lead / Sr Business Analyst

The SCES mission is to improve the speed and agility of Foreign Military Sales (FMS) case execution processes, improve accessibility and transparency of information for United States Government (USG) and FMS Customers. FMS case execution solution includes Prospect-to- Order (P2R), Order-to-Cash (O2C), Procure-to-Pay (P2P), and Budget-to-Report

(B2R) and custom BI application based on AbInitio, QlikView, SSRS and Oracle WebCenter. Inode provides IT Services to SCES mission to improve the speed and agility of FMS case execution processes, improve accessibility and transparency of information for United States Government (USG) and FMS Customers. In the target state, the SCES program capabilities will enable the retirement of the legacy mainframe case execution systems. Responsibilities:

Facilitated daily scrum and sprint ceremonies, managed burndown metrics, tracked/removed impediments and assisted the Product Owner in grooming the product backlog.

Worked closely with the PMO, SME and project management team to gather and review requirements.

Documented existing software requirements through reverse engineering in a functional/technical requirements document

Created process flows and conceptual diagrams in MS Visio during and as follow up to JAD sessions

Analyzing data from various source environment using complex SQL queries and advanced analytical functions.

Participated in weekly project meetings, team meetings, Code and design review meetings and Defect review meetings

Designed and developed Test Plan/Test Cases using Testing methodology with all possible Use Case to cover all testable function for Positive & Negative Testing

Tracked and reviewed the requirements in Jira to make sure the functionality of the application is covered and opened defect tickets with bugs found while testing the application

Responsible for SCIP Operational check in all environments using reporting toll Qlikview

Used ETL Tool Ab Initio for data transfer from ERP to DMRS databases

Worked with Automation team for automation of SCIP Operational check and Windows fire wall patch validations using UI Path (RPA Tool)

Created and maintained run books and project documentation in SharePoint and in confluence Client: USCIS August 2016 – January 2018

Employer: Sevatec, Fairfax, VA

QA Lead

Sevatec provides IT services to support design, configuration, development, and maintenance of a centralized enterprise data warehouse and standard reporting interfaces through eCISCOR, SMART, and SAS implementations; i.e., DW/BI solution. These services support USCIS’s objective to implement a centralized data warehouse for its large volume of data. The goal is to create an authoritative “one source of truth” that will facilitate reporting on USCIS core business operations as well as agency administrative functions. Responsibilities:

Conduct daily stand ups and provide status updates to leadership.

Assigning JIRA stories to QA team members, reviewing test case creation and test case results.

Experience in designing test strategies, Test plans and test scenarios

Experience working on various Agile development methodologies and focused on using QA and development metrics to drive decision-making

Using Informatica for data transfer from database to data warehouse

Creating mock of data to check the data flow between source and target tables and modified/updated data for –ve testing

Using BI tools for creating Dashboards and reports and comparing the reports against data from databases

Actively participated in Business, system and functional specification discussions

Involving in Project Planning, grooming, development, Coordination and implementing various projects

Adhere and conform to Enterprise Level Systems Implementation Framework, Agile Methodologies, Scrum and Iterative QA Processes

Employer: K12, Herndon, VA July 2010 – August 2016 Senior SQA Engineer/ Lead

Responsibilities:

Working as Business Intelligence team lead for OBIEE projects. Working extensively on all the BI related applications like BI Publisher, BI Interactive Dashboard, BI Analytics, BI Answers, BI Subject areas and BI Admin tools.

Using ETL tools like Oracle Data Integrator (ODI) and Informatica for data transfer from database to data warehouse

Actively participated in Business, system and functional specification discussions

Involving in Project Planning, development, Coordination and implementing various projects

Conducting daily meetings with offshore team to discuss about the projects and for assigning daily jobs and checking their progress every day to validate performance

Creating SQL queries for stored procedures and packages and executing then in database and dataware house

Scheduled scheduler jobs in database on daily and weekly basis based on the requirement and executed the schedulers manually to spot check the executions

Working on different Unix servers to execute the scripts, executing cron jobs manually and automatically

GUI testing on different K12 applications

Working with tools like Testlink, Jira for creating deployment tickets

Excellent team player with logical reasoning ability, coordination and interpersonal skills

Hands-on experience as a team leader with strong focus on documentation, communication and constant improvements.

Proficient in ETL techniques, sound knowledge of Dimensional Schema models like Star Schema

Skilled in UNIX and Shell Scripting operating systems and DBMS and RDBMS concepts for large Oracle databases.

Involved in decision making with management for final applications release Employer: Lockheed Martin Management Systems, Fairfax. VA June 2009 – May 2010 Senior Software Engineer

Responsibilities:

Analyzed the business rules from scratch to understand the business logic

Conducted Use case walkthroughs with the supervisors, testers and test managers

Closely worked with the business users to understand the business logic

Validation and verification of Tax forms

Extensively used SQL, PL SQL, stored procedures to validate the test data

Performed Load, Stress, Performance, functional and regression testing on multiple environments for web based, backend and serve application

Excellent team player with logical reasoning ability, coordination and interpersonal skills

Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts, Test Scenarios and Test Summary Reports for both Manual and Automated Testing. Employer: Sprint, Herndon, VA Sep 2006 – May 2009

QA Tester/Lead Tester

NRM project implements Netcracker, a Commercial off the Shelf, i.e. COTS, software application that supports Network Resource Management for Sprint to manage the IP network and VOIP Orders. It replaced the functions previously performed via the SIMS2 application

Responsibilities:

Participated in peer reviews of BRs, SRs, FRs and actively involved in design and analysis meetings

Conducted weekly and daily status calls among the team and with ITPM and system Integrators to discuss about the project being tested. Create UAT documentation and conduct presentations for the end users

Created Bays, Sites, Routers, Cards and Ports, Different kinds of circuits, Tunnels, Customer accounts, Partner clouds necessary for all the projects

Created IP Pools, IP V4 and IPV6 IP addresses. Worked on IP/TCP protocols

Worked on different networks like Sprintlink, GMPLS and PIP

Provisioned different VOIP orders like SPA Ethernet orders, ATM and SL ATM orders on different networks

Constantly follow up with resolving workgroups and get updated status on Bugs/issues being worked on. Ensure that the workgroups are aware of and working on all the tickets being assigned to them.

Opened tickets in Change synergy against Net Cracker for the bugs found while testing. Resolving and closing the tickets after the bug fix.

Being test lead created LOEs, Test Plans, uploaded test cases to the Quality Center, conducted weekly and daily status calls among the team and with ITPM and system Integrators to discuss about the project being tested

Worked after hours to meet the deadline for NRM and 24/7 on support for user groups

Very Strong in Oracle skills that include build/maintain tables and indexes build/maintain PL/SQL scripts, Stored Procedures and Functions

Involved in Database testing by writing & executing SQL queries by using SQL & TOAD to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.

Setting unix cron jobs for data loads.

Client: Nextel June2006 – Sep 2006

Employer: SLAD Infotech, Inc., Herndon, VA

QA Tester

Sprint projects are all TELECOM based projects. Overall, all the projects contain different applications in different environments. Each application contained the following process as Define, Discover, Design, Develop and Deploy Responsibilities:

Analyzed the business rules from scratch to understand the business logic.

Conducted Use case walkthroughs with the supervisors, testers and test managers.

Closely worked with the business users to understand the business logic.

Worked closely with all developers to become expert in all modules of NRM application.

Extensively used Toad and SQL Plus to validate data. Used SQL queries extensively to check data integrity, field size validation.

Client: Maximum Quest Group), Falls Church VA Aug 2004 - May 2006 Employer: SLAD Infotech, Inc., Herndon, VA

QA Tester

Rent Estimate (RE) is a Public Buildings Service (PBS) Enterprise Application that uses source information from back- office systems and applications such as the System for Tracking and Administering Real-property (STAR), Appraisal Data System (ADS), and Galaxy to estimate rent charged for the upcoming budget year. These estimates are used by customers of the General Services Administration (GSA) and by GSA in the budget formulation process. Responsibilities:

Documented Detailed Test Cases that described the steps needed and the expected results.

Provided critical information needed for estimating time and resources required for testing and supporting various releases.

Responsible for generating the daily reports with detailed information.

Used SQL, PL/SQL and TOAD extensively to validate the data in Oracle database.

Contact this candidate