Sign in

Test Cases Project Manager

Cleveland, Ohio, United States
May 19, 2017

Contact this candidate

Jayalakshmi Jiddu


Professional Summary:

Good experience in the field of Information technology with emphasis on Software Quality Assurance and Development.

Comprehensive knowledge of SDLC, Agile, QA Methodologies and Defect Management Lifecycle.

Performed ETL (Informatica, Data Stage) testing on DWH and Data Migration projects.

Extensive testing ETL experience using Informatica 8.6/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor), and Data stage.

Have worked with SQL queries, Oracle, RDBMS Concepts and UNIX.

Experienced in manual testing with the focus on Functional Testing on Client-server Web- based applications, GUI Automation testing, Regression Testing, Back End testing, Database testing, System Testing, UAT testing Stress Testing and Unit Testing.

Involved in Business Intelligence (BI) data/reports validation on Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence) and Cognos.

Involved in XML data verification and validations.

Designed and done peer review of manual test cases, executed test cases and worked closely with Development to validate fixes for coding issues.

Experience in web application testing and identifying defects in software and quickly isolate the root cause of the defects at the component level.

Expertise in developing Software Test Plans, Test Case Design, Test Scripts based on User Requirements Specification (URS) and System Requirements documents.

Creative thinker that specializes in automation and computerization, replacing the amount of time consumed by repetitive work.

Leverages analytical skills and keen attention to detail to develop and deliver top-quality comprehensive business requirements and functional specifications.

Installs, maintains and writes training manuals for Software application packages.

Ability in collaboration, communication, conflict resolution, creativity, critical thinking.

Leads teams to drive process development and process improvement.

Technical Skills:

Mercury Interactive

Quality Center10.0/9.2, Test Director 9.0/8.0., QTP, JIRA, Excel

ETL Tools

Informatica 9/8.6/8.1/7.1/6.1, Data Stage.

Programming/Scripting Languages

SQL, PL/SQL, HTML, XML, Java/J2EE web applications

Operating Systems

Windows XP/NT/2000, UNIX, LINUX


Oracle 10g/9i/8i, MS SQL Server 2008, MS Access, TOAD tool

Reporting Tools

Business Objects6.5, Cognos7.0

Data Analyst / Cultural Secretary Jan 2016 – Dec 2016

NEOTA (North East Ohio Telugu Association)

Cleveland, Ohio


Collect, evaluate and analyze all registration data to successfully log and track information and managed the inquires.

Through historical data analysis. identified potential sponsors, events, venues, caterers, footfalls etc.

Used advanced Microsoft Excel to generate spreadsheets, and other excel functions.

Analyze data, develop and generate reports/ visualization.

Conduct outreach to the prospect community as needed via email, or phone to explain necessary information for sponsoring the event.

Designing and creating the flyers for the events and getting approvals from trustees for promoting the flyers.

Respond to telephone inquiries promptly, professionally, and efficiently to provide first call information regarding the event.

Played a key role in conducting and organizing cultural activities and events.

Worked with President to arrange sponsors for the event and promoting the events.

Managed registrations of activities and explained the guidelines to participate. Also, took full responsibility of stage decoration and audio arrangements.

Successfully did anchoring and conducted the cultural programs and concluded the schedule on time.

Worked with trustees to felicitate the Guest and handover the prizes to winners.

Played a key role in giving feedback and suggestions in various community meetings.

Actively involved in charity services like Sandwich Seva and helped in cooking Lunch for Grand Lunch event.

Provided assistance as needed to team members or other support.

ETL/Data Warehouse Analyst Feb 2013 – Mar 2014

Viacom, New York, NY



Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.

Checked the naming standards, data integrity and referential integrity.

Responsible for monitoring data for porting to current versions.

Checked the reports for any naming inconsistencies and to improve user readability.

Compared the actual result with expected results. Validated the data by reverse engineering methodology, backward navigation from target to source.

Used Quality Center for defect tracking, test cases, test plan, updating the bug status and discussed with developers to resolve the bugs.

Validating the reporting objects in the reporter against the design specification document.

Validating the load process of ETL to make sure the target tables are populated according to the data mapping provided that satisfies the transformation rules.

Assisted in creating test data and test cases and execute function system tests as needed.

Performed Black Box Testing, Regression and end-to-end testing.

Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.

Initiated the bi-weekly QA-Stat-Meet to discuss the intricacies involved in the application(s) being tested.

Assisted the Business in the User Acceptance Test (UAT) testing.

Attended weekly status meetings showing progress and future testing efforts to the project manager.

Environment: Data stage 7.5, Mercury Test Director 6.5, XML, Cognos 7.0, Oracle8i, SQL Server 2000, Windows 2008.

ETL Test Engineer Jan 2013 – Feb 2012

Home Depot, Atlanta, GA

Customer Information Warehouse


Created test requirements hierarchy to represent the features and functionality that needs to be tested in the application.

Created manual test cases and performed Manual Testing of the application which involves accounting of various customer accounts using numerous test scripts.

Wrote SQL queries to test the application for data integrity and verified the contents of the data table.

Preparation of technical specifications and Source to Target mappings.

Inserted rendezvous points to generate peak load on the server to ensure that the transactions are performed accurately under the scenario.

Modified and tracked defects using Test Director.

Defects were tracked, reviewed, analyzed and compared using Test Manager.

Assisted the Business in the User Acceptance Test (UAT) testing.

Attended weekly status meetings showing progress and future testing efforts to the project manager.

Environment: Windows 2003, ASP, HTML, SQL, PL/SQL, Oracle 8i, MS SQL Server 2000, Test Cases, Test Scripts, Test Plan and Test Director.

Master’s in Business Administration in Information Technology, Nagpur University, India.

Bachelor of Engineering in Computer Science, Rajiv Gandhi University, India.

Personal Skills

• Leadership qualities with an ability to work with different people

• Positive approach and keeps learning from my mistakes

• Possess excellent presentation and good communication skills

• Ability to work in various environments.

Contact this candidate