SUMMARY

• 8 years of experience in Software Testing focusing on Quality Assurance and Quality control projects of client/server, Data warehouse, Mainframe, Web based using manual and automated testing procedures for Banking,Securities,Telecommunication,Retail and IT sectors.
• Experience in system analysis & design, coding, documentation, implementation and testing (BLACK BOX as well as WHITE BOX)
• Extensive experience performing Data warehouse testing with ETL and Reporting tools like Informatica and Cognos.
• Extensive experience using Informatica Power Center, Data mart, OLAP and OLTP tools.
• Proficient with RDBMS and Data Warehousing concepts and methodologies with about 8 years of experience using Oracle, DB2, Teradata, MS SQL Server.
• Experience with various tools and technologies as SQL, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000 on Windows and various flavors of UNIX platforms.
• Good knowledge of Cognos 8.4 (Event Studio, Query Studio, Metric Studio, Analysis Studio, Report Studio).
• Good understanding in OLTP/OLAP System Study, Analysis and E - R modeling, developing Database Schemas like StarSchema and SnowflakeSchema used in relational, dimensional and multidimensional modeling.
• Experience working on programming languages SQL, PL/SQL,Unix Shell scripts & Perl scripts
• Experienced Automated Tools QTP 9.2, Load Runner Winrunner6.x&7.x, Mercury Quality Center (Test Director (6.x&7.x&8.0), Rational Clear Quest and Clear Case.
• Extensive knowledge with Hyperion SQR production Reporting.
• Experience in testing mainframe applications which are developed using COBOL II, DB2, IMS and CICS. Worked on Both Online and Batch systems.

TECHNICAL SUMMARY

Databases: Teradata V2R5/V2R4/V2R3, Oracle 10g/9i/8i/8.0/7.0, DB2 8.0/7.0, MS SQL Server 2000/7.0, MS Access 97/2000

Operating System: HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Win 3.x/95/98, Win NT 4.0, SCO Unix, Windows 2000

Testing Tools: Quick Test Pro 8.0/9.1/9.2, Win Runner 6.0/6.5/7.01/7.5, Test Director 8.0 and Load Runner 8.0, Quality Center9.2, Rational Robot 2001, Rational SQA Suite, PVCS Tracker, Rational Clear Case, Clear Quest. Test Manager, SQA Robot

Programming Language: C, C++, Java, J2EE, HTML/ DHTML, XML, Java Script, ASP, SQL,.net,TSL for Win Runner, VB script for QTP, Shell script, Perl script, Mainframe, Cobol

Dimensional Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

IDE: Toad (Tool for Oracle),Toad for DB2,SQL Developer, SQL Navigator, Query Analyzer

Data Warehousing: Informatica Power Center 8.1.1/8.0/7.1.5/1.2/6.2/5.1.2/1.5/1.7 (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor, Worklets), Informatica Powermart 5.1.1/5.0/4.7.2, Informatica PowerAnalyzer, ETL, Data mart, OLAP, OLTP, SQL*Plus, SQL*Loader,SSIS

OLAP Tools: Cognos 8 Series, Cognos ReportNet 1.1 MR1/MR2/MR3 (Cognos Configuration, Framework manager, Query Studio, Report Studio), Business Objects 5i, Web intelligence, Power Play, Transformer & Impromptu, IWR, Upfront, Cognos 7.0.

PROFESSIONAL EXPERIENCE

Confidential, Newyork

Test Lead

Responsibilities:

• Working as Onsite coordinator, leading a team in offshore.
• Conducted meetings with offshore team for daily status of team members.
• Conducted defect review meetings during test execution cycle which involves Business Analysts and Developers.
• Prepared high level Test scenarios and Test cases based on BRD, HLD and LLd.
• Performed integration Testing, System testing and Regression Testing.
• Setup Test environment and Test data.
• Monitor and validate the loaded data to the database after all the daily, monthly and other scheduled ETL jobs are executed.
• Run Autosys scheduled jobs and Informatica workflows in UNIX.
• Debugging Pl Sql code to understand data flow during source to warehouse.
• Tested Stored Procedures, Cursors and Functions in Pl Sql
• Debugging Informatica mappings /Transformations/Sessions/Workflows.
• Consolidated required test data from all the feeds
• Extensive use of SQL to verify the data integrity and calculated fields.
• Perform testing to ensure Account renumbering and Account prefix logic implemented successful in Phase 1.
• Tested Stored Procedures, Cursors and Functions in Pl Sql
• Tested STR and CSARGM data marts and Transloin Fact table in CSAR Reporting, which is mapped to Client, Repcode, People, Security and Trade dimensions.
• Tested renumbered AP accounts in MTO browser, to ensure those should not break existing logic for Revenues on reports.
• Perform Data Integration, Data comparison and Data Validation for Back End Testing by using SQL Queries (TOAD).
• Ensured SCD2 type in warehouse.
• Done research on validating the quality of Data Extracts from the source system before loading it to the warehouse.
• Involved in the validation of data at various levels (source, Staging, Warehouse)
• Validated fact and dimension mappings and Tested scheduling and purging process
• Performed functional testing for MTO browser which generates reports from CSAR Reporting warehouse
• Tested Cognos reports.
• Worked on issues with migration from development to testing and worked in agile environment.
• Worked with Quality Center as defect tracking tool.

Environment: Informatica Power Center8.1,Loadrunner,QTP, Oracle 10g,Sql Server2005,Netezza,Cognos.Actuate,Compass,Autosys Windows 2000, UNIX (ksh), Quality Center, Cognos 8.4 (Framework Manager, Report Studio, Query Studio), ASP.NET,java Script, HTML, IIS, Xml

Confidential, Herndon, Virginia

Sr ETL QA

Responsibilities:

• Prepared Test Plan, Estimation and Overall project tracking for every release.
• Involved in Gathering requirements from Business and Preparation of Test Scenarios and Test Cases.
• Performed Functional Testing, Smoke Testing, Integration Testing, System testing, User acceptance testing and Regression Testing.
• Setup Test environment and Test data.
• Involved Execution of Test Cases and reporting Defect and tracking them to Closure.
• Preparing and analyzing Weekly and Monthly status reports.
• Developed test cases for ETL coding and mapping standards based on design spec document
• Tested warehouse metadata, naming standards and warehouse standards for future application development.
• Perform Data Integration, Data comparison and Data Validation for Back End Testing by using SQL Queries (TOAD).
• Involved in testing Transformation Techniques and Debugging the Workflows / Sessions / Mappings during the failures.
• Involved in testing Mapping Sources and Targets, performed data validation while dealing with missing data and reconciling during extracts and loads.
• Ensured SCD2 type in warehouse.
• Performed data quality gaps and diddata cleansing.
• Tested Mappings using different transformations.
• Done research on validating the quality of Data Extracts from the source system before loading it to the warehouse.
• Involved in the validation of data at various levels (source, Staging, Warehouse)
• Validated fact and dimension mappings and Tested scheduling and purging process
• Tested different reports like List Reports, Cross tab Reports, Chart Reports, and Drill-Through Reports
• Tested regulatory reports like HIPAA, ITIL V3, PCI Compliance reports.
• Tested complex reports multiple prompts, multiple query references, master-detail relationships and drill-through within the reports to meet the business needs
• Validated data displayed on reports with warehouse data and BCAN application data.
• Validated graphs on summary and trend reports and tested each report in different formats like PDF, excel, CSV and xml.
• Involved in system testing the reports and moving them to UAT and product documentation for clients
• Worked on issues with migration from development to testing and worked in agile environment.

Environment: Informatica Power Center 8.1, Oracle 10g, Windows 2000, UNIX, Quality Center, Cognos 8.4 (Framework Manager, Report Studio, Query Studio), Teradata V2R6, ASP.NET,SharePoint,java Script, HTML, IIS, Xml

Confidential, Richmond, Virginia

Sr ETL QA

Responsibilities:

• Create, Implement and Execute Test Plan, Test Cases, Test Scripts, Test Scenarios, Test Data based on the on the Technical Design Document and Requirements Specification Document.
• Experience in translating business requirement to functional requirements and prepared use cases. Involved in defining business context, stakeholders needs, requirement management, vision and scope of the system and feasibility analysis.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.
• Involve in setting up Test Environment, Test Data Source, Test Cycle, Release Cycle, for functional, Integration, System, UAT and Regression testing of the application.
• Report defect issues into the bug reporting/tracking systems and followed up with the development team until resolved the status of the defect accordingly using Quality Center.
• Perform Data Integration, Data comparison and Data Validation for Back End Testing by using SQL Queries (TOAD, SQL Developer).Extensive use of SQL to verify the data integrity and calculated fields.
• Involved in testing Data Marts and Mapping Sources and Targets, performed data validation while dealing with missing data and reconciling during extracts and loads.
• Done research on validating the quality of Data Extracts from the source system before loading it to the database
• Involved in the validation of data at various levels (source, Staging, Warehouse)
• Developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Wrote complex Teradata SQL Queries to comply with the conditions specified in extracting data from the TD Warehouse.
• Interacted with Business users and developers collected business information and their requirements to test reports.
• Tested list reports, cross-tab reports, dashboard reports, Master-Detail reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.
• Tested complex reports (multiple queries joined together to create one output, tabular SQL with custom joins) using Report Studio.
• Tested Dash Board Reports and Drill down / Drill Up reports
• Tested Filters, Prompts, Calculations both at package level and report level.
• Developed reports using Ad-hoc reporting.
• Develop automation scripts that took over manual test cases for regression testing, User Interface testing, Integration testing by using QTP.
• Identified scenarios for automation testing and Created and maintained automated tests using QTP by coding in VB Script.
• Developed User Defined Functions to support the automated scripts using QTP.
• Used data driven testing and database accessing techniques to support the scripts.
• Performed Regression testing using QTP and manipulated necessary recovery manager steps

Environment: Informatica Powercenter 8.1( Designer, Workflow Manager, Workflow Monitor), Teradata V2R5, Oracle 9i/8i,TOAD 7.5, DB2 7.0, Putty Client, Visio 2003, XML, Windows 2000, Cognos 8 BI, Cognos ReportNet1.1, Cognos Connection, Frame Work Manager, Cognos Impromptu 7.1, Power play Transformer 7.1, Access Manager

Confidential, Austin, Texas

Sr Quality Analyst

Responsibilities:

• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the Oracle database in UNIX environment
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Data validation and Data integrity testing done by executing SQL, PL/SQL statements.
• Analyzed business requirements, system requirements, data mapping requirement specification
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Experience in testing POS systems.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Tested whether the reports developed in Business are as per company standards.
• Used Clear quest to track and report system defects
• Worked on increasing the performance of the exiting complex reports.
• Tested various types of reports like List Reports, Crosstab reports and Master Detail Reports using Cognos 8.2 and also tested some complex reports from 1.1Mr2 to Cognos 8.1.
• Developed stored procedures, views, Packages in SQL server 2000 & Oracle 9i databases to test the performance of SQL in complex Cognos 8 Report Studio reports.
• Troubleshooted errors/issues with Production reports.
• Assisted Query Studio users with questions regarding data in the database, joins/relationships and Query Studio report design.
• Involved in the System testing the reports and involved in UAT with business users.

Environment: Cognos ReportNet1.1 MR3(Framework Manager, Query Studio, Report Studio)Power Play Enterprise Server 7.3,Transformer 7.3, Oracle 9i,Migration Utilities(Impcat2xml, Migratetoc8, Deploytoc8).

Confidential, Iowa

Sr Quality Analyst

Responsibilities:

• Logging, Tracking defects, and Version Control using Test Director.
• Creating Business Test Plan using Requirements.
• Conducted Regression testing for subsequent versions of the same application
• Performed various phases of testing to ensure an acceptable level of performance of the prudential product, phases included unit, regression, smoke, integration, system and acceptance testing.
• Involved in the preparation of test plan specifying an overview of testing approach, testing strategy, roles, and responsibilities and testing scope.
• Developed test scripts for data-driven tests using win runner.
• Performing queries on the database using ‘SQL’ to check successful Transaction and to create particular test cases.
• Used Load Runner to measure the time it took for the server to respond to a request without going across the network.
• Tested Cognos Reports.
• Writing new shell scripts and modifying existing shell scripts.
• Automating the shell scripts using Autosys Job Scheduler.
• UNIX shell scripting to run the Informatica workflows and store header and footer information in flat files. Writing UNIX functions to run different steps of jobs to load and validate data.
• Writing wrapper script in UNIX shell to run the whole process, rename/moving flat files for archiving and emailing the flat files to clients.
• Testing on Development Server and move the code to testing server on AS400.
• Responsible for updating Issue logs everyday with the expected Results.
• Using Compslot Libraries f or testing and send the grids for Daily Assembly Run to get policy Numbers for AS400.
• Responsible doing Post Evaluation testing two weeks after Project Live date and Verify open IDCMs opened on Production on AS400.
• Involved in Testing COBOL Projects on MVS Mainframe Environment

Environment: PACS, UNIX, C#, ASP.net QTP, Quality Center, SDH, SS7, Windows XP, Xml, Oracle, Toad, Windows Server 2003,Perl,VOIP, VS COBOL II, CICS, VSAM, TSO/ISPF, EXPEDITOR, JCL, Change Man, CA7, File Aid, Mainframes, Windows 2000, Erwin 3.5.2, PL/SQL, DB2, Windows NT 4.0), Cognos (Transformer, Power Play, Impromptu, IWR),