Quality Assurance Manager
Resume:
Professional Profile
Ms. Vennam has * years of experience in the IT Industry. She has worked as
a Cognos developer, Quality Assurance Analyst and Programmer Analyst, with
emphasis in application development, modeling, deployment, testing and
maintenance.
. Cognos developer - Expertise in creating complex reports in Cognos Report
Studio, Impromptu Administrator (List reports, Cross-tab reports, Drill
through reports) and also improved several reports performance when they
run against production system.
. Quality Assurance Practices - Prepared test plans, test scripts and test
cases for manual and automated testing. Modified test procedures per
requirements. Executed Unit, Integration, Functional, User Acceptance,
Regression, Performance / Load and Stress Testing. Executed manual and
automated software QA testing in Web and Client/Server Applications using
build process tools/methodologies. Maintained test cases and test scripts
to incorporate defect fixes and new enhancements in each release.
. Business Analysis - Reviewed business and user requirements, system
specifications and used guidelines per IEEE Std. 1058 and IEEE Std. 730.
Education and Certifications
. Master of Science - Information Systems
Lawrence Technological University, Southfield, MI
. Microsoft Certified Professional in Visual Basic 5.0
Industries
. Automotive
. Banking
. Distribution
. Government
. Retail
Areas of Expertise
. Data Analysis & Reporting
. Data modeling with BI tools
. Application Development
. Application Support
. Coding / Debugging
. Design Specifications
. Quality Assurance Practices
. Test Case Design & Execution
Experience and Skills
. Cognos
. Java
. LoadRunner
. MS Visual Basic
. Oracle Developer/2000
. PL/SQL
. PVCS Tracker
. Quality Center
. TestDirector
. TOAD
Experience Highlights
. Cognos Reports developer - General Motors Corporation / Onstar -Created
List, Sub and Cross-Tab reports using Impromptu and distributed Catalog
to users for Ad-Hoc reporting and analysis. Created standard filters,
calculation prompts, and conditions.
. Cognos Reports developer - Daimler Chrysler Corp -Created reports using
Cognos and automated scripts to validate the integrity of the data based
on end user needs. Migrated different databases (Oracle and MS Access) to
MS SQL Server database using Data Transformation Service tool (DTS).
. Quality Assurance Analyst -State of Michigan - Developed test cases,
identified and reported bugs using Bug Tracker for SDS application.
. Quality Assurance Analyst - MBNA America - Executed all phases of end-to-
end testing including user acceptance, functionality, regression, GUI,
negative, system, integration and unit testing for MBNA, Wachovia web
sites.
. Programmer / Analyst - Edscha Inc - Executed test cases and test scripts
for both inbound and outbound transactions. Executed all phases of end-to-
end testing including user acceptance, functional, regression, GUI,
boundary, system and unit testing of the application.
Chronology of Experience
Compuware Corporation September 2004 to April 2009
Industry: Automotive - GM/ OnStar Duration: 1 Year, 6 Months
Position: Cognos Reports developer
Environment: MS Windows XP, Oracle 10G/Developer 2000, Linux, UNIX,
Avaya, Genesys, VoIP, Wireless Telephony, Switches, Routers
Tools: Cognos 8.3, Cognos 8.2, Report Studio, Analysis Studio, Query
Studio, Framework Manager, PowerPlay7.4,Java, Impromptu,
Oracle 10g, Unix/AIX, Toad, Windows XP
. Developed multi page reports with prompt pages and
conditional variables according to the end user requirements
(for PVCS project and Onstar China (SIT) projects)
. Daily team meetings to discuss and review the tasks.
. Developed and Published Packages in Framework Manager
. Created list, cross tab and chart reports to cater various
business requirements
. Created List Reports by applying Cascading prompts and Filters to
restrict the data fetch.
. Developed Master-Detail reports and Drill-Through reports to provide
summary-detail information.
. Created nested Cross tab reports and Repeaters in Report Studio.
. Created adhoc reports using Query Studio.
. Assisted Quality Assurance Team in documenting and analyzing
their current process and then make recommendations for
improvements in their functional areas.
Industry: Automotive - Daimler Chrysler Corp. Duration: 2Years
Position: Cognos Reports developer
Environment: Java, DB2, Rumba, OS/390, Solaris, AIX
Tools: Cognos 8BI, Cognos Report Net 1.1(Framework Manager,
Report Studio, Query Studio, and Cognos configuration),
Cognos Impromptu 7.0, Impromptu Web Reports, Cognos
Transformer 7.3, Cognos Power Play 7.3, SQL Server 2000,
Windows NT/2000.
. Worked on creating the model and publishing the package on
Cognos Connection for reporting purposes.
. Dimensionally modeled the existing Relational Metadata in
Framework Manager 8.3 with multiple hierarchies in the
regular dimensions.
. Applied security on data level and in the package level in a
manner that only the relevant users were able to see those
packages and reports created.
. Created dashboard reports using Cognos 8 report studio.
. Developed standard reports, charts, drill -through reports,
master detail reports and bursting reports using Report
Studio
. Created complex reports that involve query prompts, layout
calculations, conditions, and filters
. Developed multi page reports with prompt pages and
conditional variables according to the end user requirements.
. Deployed the reports from development to testing and then to
prod through deployment tool.
. Used SDK Java to extract the output of a report and saved it
to the local file system.
. Scheduled and distributed reports through schedule management
in Cognos Connection Portal.
. Extensively used Quest's Toad for database analysis.
. Involved in unit testing and functional testing to finalize
the report accuracy.
Industry: Government - State of Michigan Duration: 1Year 6 Months
Position: Quality Assurance Analyst
Environment: MS Windows XP, SQL Server 2005, Visual Baisc.Net, Visual
source Safe 8.0, Visual Studio 2005
Tools: LoadRunner, TestDirector, PVCS.
. Executed multiple SIT test cases and documented test results to support
the State of Michigan using Student Data System application.
. Developed test cases and scenarios for testing the front end SDS
application.
. Used Bug Tracker for defect management.
. Contributed in defect review meetings and managed SDS defect logs, TEPRs.
Howard Systems International November 1999 to September 2004
Industry: Banking - MBNA America Duration: 2 Year
Position: Quality Assurance Analyst
Environment: TSO/ISPF, HostExplorer9.0 (Hummingbird), Java, OS/390, MS
Office, UNIX
Tools: TestDirector
. Executed all phases of end-to-end testing including user acceptance,
functional, regression, GUI, negative, system, integration and unit
testing for MBNA, Wachovia and IBS web sites.
. Tested the Financing Credit Application flow in order management,
including NetAccess (for affinity groups) and third party finance
(CheckFree) for the product purchase.
. Executed user acceptance testing to support Amex Credit Card processing
system at MBNA using rigorous testing methodology and testing tools.
. Executed user acceptance test scripts, validated test results and loaded
test scenarios into TestDirector.
Industry: IT Services - Edscha Inc Duration: 1Year
Position: Programmer /Quality Assurance Analyst
Environment: Java, Oracle, SQL, PL/SQL, MS Visual Basic, HTML, MS
Office, UNIX
Tools: Oracle Forms, Test Director
. Developed test scripts using Test Director for Regression and system
testing.
. Executed SQL statements and extracted data from tables.
. Validated output data of the reports on the browser page.
. Created data driven tests for testing the scenario with multiple set of
test data.
. Executed back-end testing using SQL queries to make sure that data
entered was uploaded correctly into the Oracle database.
. Tracked and reported application defects using TestDirector.
. Validated changes and closed bugs during regression testing.
Contact this candidate