Manual Testing, SQL, DB2

Role: Senior Test Analyst (Aug 2011 – Present)

Company: Infosys Technologies Limited  (Chandigarh)

Location: Onsite, Swindon – United Kingdom

Client: Nationwide Building Society, UK

Project Type: System Testing

Technologies: SQL Server 2008, Data warehouse testing, Business Objects

Responsibilities

• Test planning and analysis.
• Testing of Historical Data Store, Marts on Corporate Analytical Warehouse.
• Reconciling Business Object Reports to data present in SQL database.
• Working with client's Business SME's to support UAT
• Working with a client test managers under stern timelines giving excellent result and getting high recommendation from the test manager and business SME's.

• Test planning and analysis.
• Testing of Historical Data Store, Marts on Corporate Analytical Warehouse.
• Interactions with Business SME's
• Co-ordination with the Deloitte's US and UK teams to perform an end to end testing of ABS Suite.
• Working with a client test managers under stern timelines giving excellent result and getting high recommendation from the test manager and business SME's.

• Understanding the Nationwide Building Society system and architecture.
• Analysis of the detailed design to make technical specifications for individual components.
• Coding and testing various complex modules.
• Work package testing of the entire application.
• System Testing and User Acceptance Testing Support.
• Preparing defect tracking reports and conduct a defect prevention meeting after each phase of the project life cycle.

• Acquiring required domain and technical skills.
• Analysis of the business requirements and the functional specifications to make the Application design and Component designs.
• Analysis of existing architecture by in depth study and making changes wherever required.
• Coding using Endevor and Self Testing the online modules using Expeditor and Test Harness
• Independent Unit Testing using Expeditor and Test Harness.
• End to End link testing of the application, error analysis and resolution wherever required.
• System Test and User Acceptance Testing Support.
• Client interactions during various tracker and design calls.
• Preparing defect tracking reports and conduct a defect prevention meeting after each phase of the project life cycle.

• Scheduling and maintenance of CICS clusters (CICS on Demand Scheduling) to provide development, test regions to support various online (user interface) projects.
• Handling testing environment related issues.
• Handling Bind issues.
  

• Operating Systems: MVS-OS, Z-OS, OS-2200, Disk Operating System, Microsoft Windows
• Technologies: IBM Mainframes, Unisys Mainframes, C/C++.
• Programming Languages: COBOL, CICS, JCL, SQL, and ECL.
• Database: DB2
• Software Tools: HP Quality Centre, Endevor, Expeditor, File Aid, Dump, VSS/PVCS.

• RDBMS, MVS, JCL, COBOL, CICS and DB2 from Infosys Technologies Limited.
• C Language training from C-DAC.
• C++ Language training in Senior Secondary School and Infosys Technologies