SUMMARY

• Having 9+ years of Information Technology experience with 5+ years of experience in ETL/ Cognos/Data Warehouse Testing and 4 years in Cognos report development
• Experience in software QA Testing and Data Warehouse using ETL tools Informatica, SSIS, Teradata, Datastage, SAP BODS and Reporting tools Cognos, SSRS, OBIEE and Business Objects.
• Extensive Experience in Quality Center which includes Uploading Requirement, Preparation of Test cases and uploading, Execution of Test Cases, Logging & tracking Defects, Preparation of Metrics and Preparing Status reports for test design Phase and Execution Phase.
• Good experience in environment of Oracle, SQL Server, Cognos reports, Report studio, Query studio, Analysis studio, Framework manager.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target Data Warehouse.
• Strong experience in cubes, extracts and Data Warehouse tables testing.
• Sound knowledge and experience in Data Warehousing and Business Intelligence Testing using different tools like SQL, SSIS, SSRS, DataStage, Informatica, Cognos etc.
• Expertise in writing and executing test cases based on given software requirement specification and developed detailed Test Plan.
• Performed Functional testing, Integration testing, System testing, Regression testing, and Smoke Testing.
• Experience in Problem solving and Bug reports using Defect Tracking Tool Mercury Quality Center.
• Highly motivated, organized, able to work independently and able to switch between projects quickly.

TECHNICAL SKILLS

Testing: Manual Testing, DWH - Testing, Report testing and Front-end Testing

Manual Testing: Functional Testing, System Testing, Regression testing, UAT

Development: Cognos reporting, Report studio, Query studio, Analysis studio, Framework manager

Defect Tracking Tool: Clear quest, Quality Centre, Rational Team Concert, JIRA

Data Warehousing: SQL Server, Teradata, SSIS, Cognos, Informatica Power Center

Operating Systems: Windows NT, 9x, 2000, XP, 2003 Server

PROFESSIONAL EXPERIENCE

Confidential

Senior Tester

Responsibilities:

• Responsible for testing and reviewing of ETL mapping, Cognos reports and transformation specifications based on the business requirements from various teams and the business teams.
• Responsible for requirement gathering, analysis and estimation for the testing the ETL mappings and cognos reports
• Responsible for all the project deliverables and artifacts to all the stakeholders
• Responsible for the multiple project management and task management
• Tested the performance bottle necks at sources, targets, mappings and employed required measures.
• Tested a number of complex ETL mappings, and reusable transformations for daily data loads.
• Tested a number of complex cognos report functionalities, logical transformations and expected output
• Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages for business rules.
• Tested Triggers which were enforcing Integrity constraints, stored procedures for complex business logic complementing the Informatica sessions.
• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
• Formulate methods to perform Positive and Negative testing against requirements.
• Used Agile testing methodology for achieving deadlines in UAT.
• Creating test cases for ETL mappings, cognos report validations and design documents for production support
• Setting up, monitoring and using Job Control System in Development/QA/Prod
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
• Validated data in between source and target after running Mappings by the Informatica developer team.
• Developed SQL queries to check the database and checking the data integrity in accordance with business standards of the company.
• Used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
• Table-to-Table data comparison between Oracle DB tables and Source tables and files.
• Extraction of test data from tables and loading of data into SQL tables.
• Validated the data in Source and Target using SQL queries in the transactional system.
• Logging defects in Quality centre, clear quest and Rational Team concert
• Created Test script preparations and test executions in Rational Quality Manager
• Created project status reports for all the stakeholders based on the metrics
• Conducted and actively participated in reviews, walkthroughs of test cases.
• Coordinated with different users in UAT process.
• Coordinating between Onshore and Offshore team to meet the deliverables

Confidential

Developer

Responsibilities:

• Responsible for requirement gathering from the business teams
• Responsible for impact analysis with the new requirement against the current system
• Responsible for project estimations based on the report complexity
• Responsible for project timeline planning and deliverables
• CreatedList Reports,Grouped Reports,Cross tab Reports,Chart Reports, Drill-DownandDrill-Through Reports.
• CreatedComplex reports in report studio including Drill Down reportsfromFrame work model
• Created framework manager model to publish package for the cognos projects
• Created dashboards to represent one single place to access multiple reports which would help the users for their analyze the audit status
• Manually modified the SQL in report studio to tune and to write the complicated reports
• Usedunion and Joinobjects in Report Studio
• Experience indeveloping Framework Manager Modelsand analyzed those models in analysis studio.
• Analyzing existingtransactional database schemasand designingstar schema modelsto support the users reporting needs and requirements
• Used some advanced features likeConditional FormattinginReport Studioin generating multipage Reports.
• Performing unit test cases before implementing to staging environment
• Worked on bug fixes raised and production issues
• Worked on adhoc requirements to create any new functionality for the ongoing project
• Worked on enhancements for the existing reports
• Assisted stakeholders during the User Acceptance testing
• Managing business meetings, status reporting, product’s adhoc requirements, etc.,

Confidential

Developer

Responsibilities:

• Responsible for requirement gathering from the business teams
• Responsible for impact analysis with the new requirement against the current system
• CreatedList Reports,Grouped Reports,Cross tab Reports,Chart Reports, Drill-DownandDrill-Through Reports.
• CreatedComplex reports in report studio including Drill Down reportsfromFrame work model
• Created framework manager model to publish package for the cognos projects
• Manually modified the SQL in report studio to tune and to write the complicated reports
• Analyzing existingtransactional database schemasand designingstar schema modelsto support the users reporting needs and requirements
• Performing unit test cases before implementing to staging environment
• Worked on bug fixes raised and production issues
• Managed adhoc requirements to create any new functionality for the ongoing project
• Worked on enhancements for the existing reports
• Assisted stakeholders during the User Acceptance testing
• Managing business meetings, status reporting, product’s adhoc requirements, etc.,

Confidential

Developer

Responsibilities:

• Documenting user requirements and system specifications from the business teams
• Responsible for preparing design documents and walkthrough with the business teams
• CreatedList Reports,Grouped Reports,Cross tab Reports,Chart Reports, Drill-DownandDrill-Through Reports.
• Created framework manager model to publish package for the cognos projects
• Manually modified the SQL in report studio to tune reports
• Designingstar schema modelsto support the users reporting requirements
• Performing unit test cases before implementing to staging environment
• Worked on bug fixes raised and production issues
• Worked on enhancements for the existing reports
• Assisted stakeholders during the User Acceptance testing

Confidential

Tester, Support and Maintenance

Responsibilities:

• Documenting user requirements and system specifications from the business teams prior to project deployments
• Responsible for preparing testing cases and scenarios to walkthrough with the business teams
• Involved in preparation of test cases.
• Involved in Functionality Testing and Regression Testing.
• Migrating packages and reports through Cognos upfront.
• Validating framework manager model and checking for the performance issue.
• Validating and migrating models, cubes, mappings, workflows and scripts
• Monitoring the job chains running in the server
• Handling the issues of the job chain failures
• Maintaining the code versions
• Effective Coordination between Development teams to make sure the changes doesn’t impact one other deployments
• Scheduling the deployment timelines