We provide IT Staff Augmentation Services!

Test Engineer Resume

San Diego, CA

SUMMARY

  • 5 Years of extensive experience in SQL, PL/SQL development and testing of Data warehousing tools.
  • Good Knowledge of Java Technologies. Hands-on experience with JSF, Spring and Hibernate.
  • Worked with development and Testing of ETL mappings with Informatica,Talend and Cognos reports.
  • Good understanding of Business requirements and interpretation of business and IT terminology.
  • Experience in writing PL/SQL procedures, packages and query tuning for better performance and automation script development for Testing.
  • Quick learner and a proactive individual with excellent communication and strong analytical skills.
  • Oracle Certified Associate (OCA).
  • Basic level of Cognos Reporting tool certified.

TECHNICAL SKILLS

  • Programming Languages : SQL,PL/SQL and JAVA.
  • J2EE Technologies : JSF, Servlets.
  • RDBMS : Mysql, Oracle 10g.
  • Web Servers : Tomcat 5.5,Apache web Server 2.x
  • Tools : Informatica Power center 8.5, Cognos 8, Talend.
  • Testing Tools : HP Quality center 9.0, 9.2 and Remedy.

EDUCATION

  • Master of Computer Applications

PROFESSIONAL EXPERIENCE

Confidential,San Diego, CA Feb 2012 to Sep 2012
Project: QES- NGB
Role: Senior Test Engineer

Confidential,is the name of the billing implementation project. This system would have a bill run cycle that will once in a month. This basically computes all the charges based on the messages sent, characters sent, size of the message sent discounts, taxes, base charges, off peak hours and peak hours etc and comes up with one invoice per customer for each customer every month. This data is used to generate reports for each product.

Contribution:

  • Validation or Testing of billing report generated in Cognos by writing the suitable queries and running over the database.
  • Developed SQL scripts for automating the validation testing process.
  • Identifying, analyzing, and documenting defects, questionable functions, errors, and inconsistencies in application functions, outputs, and content.
  • Flexible report generation UI and its functionality testing in all possible scenarios by developing the queries and PL/SQL procedures as required.
  • Defects reporting and managing using HP Quality Center.
  • Mentoring juniors to bring them up to the speed.
  • Resting the Cognos reports after migration from Cognos 8 to Cognos 10.

Environment: Windows XP, HP Quality Center 9.2, Cognos 8.3 Report Studio, Informatica Power Center 7.x/8.5, SQL Developer, Oracle 10g

Confidential,San Diego, CA Sep 2009 to Jun 2011
Project: QES- P & L Financial Hierarchy
Role: Senior Test Engineer

Confidential,Data Warehouse project will consolidate, into one central database, information of Actual and Budget concerning QWBS’ financial performance. In order to provide the best possible performance and allow for system growth, this central database will be designed and developed using the standard QWBS data warehouse model. This model will allow for the retrieval and consolidation of large volumes of data from multiple source systems while providing a wide range of end-user reporting and analysis capabilities.

The end users for the P&L Project will consist of virtually the entire QWBS Finance community, including executive level managers as well as those managing and executing the day-to-day financial reporting and analysis activities. Additional users/ beneficiaries of this project may also include anyone who is responsible for managing and tracking the various revenue and cost centers of QWBS.

Contribution:

  • Review the Business Requirements document with the business and development team to understand the architecture and functionality of the application.
  • Developed test scripts for all instances of the database for Manual database testing
  • Developed and written a suite of Test Scripts that included Acceptance, Functional and Regression test cases using HP Quality Center 9.2.
  • Execute the test scripts on different releases and validated the actual results against the expected results.
  • Identifying, analyzing, and documenting defects, questionable functions, errors, and inconsistencies in application functions, outputs, and content.
  • Tracking test results for management, categorizing issues and creating/distributing defect reports and managing defect database using HP Quality Center 9.2.
  • Validation of data in the data warehouse & data marts.
  • Retest the defects, which are fixed.
  • Sending Daily status to clients as a part of Agile Methodology.
  • Identifying the key areas/opportunities for the business growth.
  • Organizing/Conducting program level trainings and knowledge sharing sessions.
  • Ensure TCS Quality processes are followed in all the projects.

Environment: Windows XP, HP Quality Center 9.2, Cognos 8.3 Report Studio, Informatica Power Center 7.x/8.5, SQL Developer, Oracle 10g

Confidential,San Diego, CA Feb 2009 to Sep 2009
Project : VOE (MySourceJ)
Role : Test Engineer

Confidential, is a module of MySourceJ, which is a Qualcomm internal portal system for all HR activities. VOE (Verification of Employment) contains Standard Letter and Residential Proof Letter for the Qualcomm Indian Employees. This completely automates the residential proof letter handling for various roles and locale people.

Contribution:

  • JSF user interface screens development for various employee verification forms
  • Spring, Hibernate DAO layer for persisting and retrieval of data
  • Role and employee locale based system behavior design and use case implementation.
  • JUnit test case development for various use case.

Environment: Java, JSF, Spring, Hibernate, Oracle 10g, Tomcat, PL/SQL Developer, Perforce.

Confidential,San Diego, CA June 2007 - Jan 2009
Project : SQR Conversion and EEO Reports
Role : Test engineer

The Project aims at converting 100+ Batch processes that are coded in PeopleSoft SQRs into PL/SQL Blocks with major performance improvement and schedule them as needed. Report generation (like Termination report, promotions report) and archiving of reports was main functionality in EEO project. Development of user friendly UI using JSF, for complete offline scheduling and triggering of PL/SQL procedures using Flux with full length job monitoring capability.

Contribution:

  • Migration of PeopleSoft SQRs into Oracle PL/SQL Blocks.
  • Design and maintain Database scripts for backed tables
  • Existing EEO reports Enhancements
    • Design change in the table structures
    • Change in the functionality by writing PL/SQL blocks
    • Reports testing and Data validation
  • Use Flux as the Scheduler
  • Configuration Management using perforce
  • Performance improvement of the converted system.

Environment: Oracle 10g, Java, JSF, Spring, Hibernate, PL/SQL Developer, Eclipse, Tomcat.

Hire Now