Professional Profile
Ms. Vennam has 8 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 - Fiveyearsof expertise in creating complex reports in Cognos Report Studio, (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 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

Work Status

• GreenCard holder

• Automotive
• Banking/Financial
• Government
• Retail
• Health Care

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

Cognos Reports developer - General Motors Corporation / Onstar - Created multiple reports to cater various business requirements and distributed Catalog to users for Ad-Hoc reporting and analysis for Vehcomm, ACRM (Advisor Customer Relationship Marketing) and IPT (Internet Protocol Telephony applications.
Cognos Reports developer - Daimler Chrysler Corp - Extensively used report studio for creating multiple reports based on business requirements, sales requirements for Dealer Connect and Techportal applications.
Cognos Reports developer - MBNA America - Created complex reports in crunch time to meet the deadline and handled service requests for modification or changes in the existing reports for MBNA and Wachovia web sites.
Cognos Reports developer - Boston Scientific - Developed multi page reports with prompt pages and conditional variables according to the end user requirements. Created list, cross tab and chart reports to cater various business requirements for health care delivery application.

• Quality Assurance Analyst - State of Michigan - Executed all phases of end-to-end testing including user acceptance, functionality, regression, GUI, negative, system, integration and unit testing for SDS application.

Chronology of Experience

Industry: Confidential, Duration: 1 Year, 6 Months
Position: Cognos Reports developer
Environment: MSWindows 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 Onstar Vehcomm applications.
• Created list, cross tab and chart reports to cater various business requirements for 3.0 advisor application.
• 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 for Call Center4 Makati, Philippines.
• Created nested Cross tab reports for Advisor Customer Relationship Marketing application.
• Created adhoc reports using Query Studio for ACRM.
• Involved in unit testing to finalize the report accuracy.

Industry: Confidential, Duration: 1 Year
Position: Cognos Reports developer
Environment: Java, DB2, Rumba, Oracle 10G, OS/390, Solaris, AIX
Tools: Cognos 8.2, Report Studio, Analysis Studio, Query Studio, Framework Manager, PowerPlay7.4, Java, Impromptu. Cognos Transformer 7.3, Cognos Power Play 7.3, SQL Server 2000, PVCS, Windows NT/2000.

• Managed with off-shore teams(TCS) on developing packages which connect to different data sources, establishing relationships in the model, and published packages for reporting purposes for B2C applications hosted by the corporation.
• 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 for Dealer Connect and Techportal applications.
• Developed standard reports, charts, drill -through reports, master detail reports using Report Studiofor Chrysler financial services.
• Created complex reports that involve query prompts, layout calculations, conditions, and filters.
• Deployed the reports from development to testing and then to prod through deployment tool.
• Scheduled and distributed reports through schedule management in CognosConnection Portal.
• Extensively used Quest's Toad for database analysis.

Industry: Confidential, Duration: 1 Year
Position: Cognos Developer
Environment: MSWindows XP, SQL Server 2005, Visual Basic.Net, Visual source Safe 8.0, Visual Studio 2005
Tools: Cognos 8BI, (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, PVCS ,Windows NT/2000.

• Communicated with Business Analysts to resolve design action items.
• Created complex reports in crunch time to meet the deadline. Reports included complex calculations using various functions, parameters, filters, prompts, conditions and multiple HTML formatting for financing Credit Application flow in order management, including NetAccess (for affinity groups) and third party finance (CheckFree) for the product purchase.
• Handled service requests for modification or changes in existing Report studio reports for MBNA, Wachovia and IBS web sites.
• Fine-tuned the queries for performance purpose and enhanced the performance of the reports to support Amex Credit Card processing system at MBNA.
• Involved in unit testing and functional testing to finalize the report accuracy.

Industry: Confidential, Duration: 1Year 6 Months
Position: Cognos Reports developer
Environment: MSWindows XP, Oracle 10g, SQL Server 2005, Unix/AIX
Tools: Cognos Report Net 1.1, Report Studio, Query Studio, Framework Manager, Cognos Connection, PowerPlay7.4, Java, Cognos Impromptu 7.0, Cognos Transformer 7.3

• BI solution for Order management module was aimed at empowering OM Users with business critical information, with an ability to slice and dice data according to their unique needs.
• Analyzed user/business requirements to design and created new reports using report studio.
• Developed standard reports, charts, drill-through reports, master detail reports and bursting reports using Report Studio for Order management application.
• 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.
• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas.

Confidential, November 2000 to September 2004

Industry: Confidential, Duration: 2 Year
Position: Quality Assurance Analyst
Environment: TSO/ISPF, HostExplorer9.0 (Hummingbird), Java, OS/390, MS Office, UNIX
Tools: TestDirector, Bug Tracker 2.9

• Executed multiple SIT test cases and documented test results to support the State of Michigan using Student Data System application.
• Executed all phases of end-to-end testing including user acceptance, functional, regression, GUI, negative, system, integration and unit testing for SDS application using rigorous testing methodologies.
• 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.
• Executed user acceptance test scripts, validated test results and loaded test scenarios into TestDirector.

Industry: Confidential, 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 for Edscha.
• 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.