SUMMARY:

• 8+ years of overall IT exposure in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Proven skills in all phases within the software development lifecycle and very strong in the implementation and maintenance of Quality Engineering Processes.
• Expert in understanding of DW/BI concepts
• Expert in ETL & Reports validation, SQL
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica & Data stage
• Extensively written Test Strategy, Test plans, Test cases and followed STLC extensively for DWH testing practices.
• Strong in both Manual & Automation Testing.
• Used various Automation & performance tools like QTP & Load Runner
• Experience in Business Intelligence in generating various reports using Micro Strategy, Cognos, Business Objects and OBIEE
• Proficient in using Informatica workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Power Exchange, Power Mart, Power Analyzer, Power Connect.
• Experience in bug reporting and bug tracking using management tools such as Quality Center and communicated recorded problems to the responsible QA or development personnel.
• Experienced in using testing tools like Test Director, HP Quality Center, ALM to write and maintain Test scripts
• Strong analytical and trouble-shooting skills to perform root cause analysis.
• Performed Release Acceptance Test (RAT)
• Mentored junior QA tester
• Experience working in short release cycle.
• Experience in Oracle BI Apps that include OBIEE, ETL Tools and DAC in Banking, Financial, Pharmaceutical, Insurance and Sales & Marketing domains.
• Strong Skills in using Functional Integration, System, Regression, End to End, Ad Hoc and UAT Testing.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame
• Experience in Testing BI applications using OBIEE
• Develop and implement efficient and effective test plans including detailed test cases based on project artifacts, such as business requirements, functional specifications, source to target mappings, analytic specifications and technical specifications for Data Warehousing environments.
• Analyze/profile data to meet project needs, create test beds and seed test data using Structure Query Language (SQL), or by other means based on environment, to ensure complete coverage of business requirements, functional and technical specifications are met.
• Review Test Estimates and Test Design and Test coverage
• Manage Testing within approved budget and schedule
• Testing Status Monitoring & Metrics Reporting
• Perform risk analysis and manage mitigation
• Perform issue management and escalation, when necessary
• Tested several UNIX Shell Scripts and PERL scripts for connecting to database and for file manipulation of data.
• Worked on Control-M tool for Scheduling & Monitoring jobs
• Strong SQL query Analyzer skills using an enterprise wide RDBMS (Oracle, Teradata, MS SQL Server & MS Access) and familiar with concepts of SQL queries ranging from DML, DDL and TCL
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Proficient experience in different Databases like Oracle, SQL Server 2008, DB2 and Teradata
• Team Player with excellent communication, analytical, verbal, writing and interpersonal skills.

TECHNICAL SKILLS:

Data Warehousing/ ETL Tools: Informatica Power Center 7.x/8.x/9.x, Data Stage, Ab Initio, Repository & Data mart

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams

BI Tools: Business Objects XIR3/XIR2/6.x, Cognos, Micro Strategy, OBIEE

Databases: Oracle 11g/10g/9i/8.0, MYSQL, SQL Server 2008, DB2, Teradata v2r6

Scripting Language: Shell Scripting, Shell, C Shell, Bourne Shell, Bash

Other Tools: SQL*Plus, Dream weaver

Operating system: UNIX (Sun Solaris 8.0), Windows XP/Vista

Automation Tools: QTP 9.5, UFT, Load Runner 9.10, Postman

Testing Tools: HP Quality Center 10, ALM 11, Test Director, JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Oklahoma City, OK

Sr. ETL/ Cognos Tester

Responsibilities:•

• Reviewed and understood user stories/ functional Requirements and various business requirements documents.
• Designed and executed Test plans and Test cases according to product backlog and user stories
• Identified and organized the overall plan for test data, strategy and the Scope of testing within the context of each Sprint.
• Performed Sprint level testing, Functional Testing, Systems Integration Testing, UAT, and Regression Testing.
• Participated in daily Scrum Meetings, Sprint Planning Sessions, Sprint Review and Sprint Retrospective Sessions.
• Involved in preparing burned down chart for measuring the progress of the project with stakeholders.
• Demonstrated to client/product owner in sprint review sessions that all requirements are met as per sprint backlog
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Created detailed periodic Status Reports for senior management to keep them on the progress of implementation.
• Attended periodic meetings, teleconferences and led discussions on problem resolution.
• Extensively used MS Excel and MS Access to validate data between source and target.
• Validated Transactional data on a weekly basis.
• Extracted and validated flat files using UNIX environment.
• Attended daily Stand up, Scrum and Defect Review meetings.
• Worked with several cross-functional teams with in enterprise landscape in identifying the requirements, understanding the data flow within each system, and executing end-to-end test scenarios.
• Interacted with developers, Business & Management Teams and End Users
• Prepared and provided status summary reports on system status, system changes, problems and potential impacts.
• Tested various major functionalities like Policy Submissions, Changes, Cancels, Reinstate, Rewrites and Renewals.
• Performed Policy and Billing Center Integration Testing on various Billing Instructions.
• Worked with developers by updating the defects and resolving them and tracking the status.
• Defects found during testing were logged in HP ALM (Quality Center 11).
• Queried database using SQL queries to ensure data integrity and to validate the inserted and updated data
• Tested business integration between internal and external systems.
• Reviewed Product backlog and updated task status in JIRA.
• Used Selenium for regression testing for functional areas of the application.
• Discussed with the team in identifying regression areas that can be automated
• Involved in creating the frame work for automation testing
• Executed test scripts in Selenium for regression testing to ensure the quality of the system
• Maintained RTM to check if all the requirements are implemented and Tested according to entry/exit criteria
• Created detailed periodic Status Reports for senior management to keep them on the progress of implementation

Environment:: Informatica 9.5.1, Cognos Reports 8i (Cognos Configuration, Framework Manager, Cognos connection, Query studio, Report studio), ALM/HP Quality Center 11, SQL, Oracle 11g, SQL Server 2008.

Confidential, TX

Sr. ETL/ Cognos Tester

Responsibilities:

• Gathered business requirements and designed Database Dictionary.
• Extensively worked on Report studio to build different kinds of reports like Grouped list reports, crosstab, chart, Drill through reports, burst reports, Dash boards with multiple tables.
• Worked on Query studio for adhoc reporting.
• Involved in testing the report against the database.
• Set up the Security at the package level, query subject level and the query item level. Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Created the list, cross tab, repeater and Drill-through reports and created the reports in different formats like PDF, XML, and HTML.
• Performed manual testing executing all the test cases in ALM before switching to automation testing.
• Involved in extensive backend testing.
• Created public folders, private folders, personalized pages and custom views on the Cognos connection portal.
• Distributed the reports to the users via Cognos Connection.
• Ad-hoc reports and templates were created using Query Studio.
• Page explorer, query explorer and variable explorer were used to manage the content of the reports
• Performed various calculations on the Report Studio Reports.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Worked on Informatica workflow monitor to create and execute workflows
• Filtered the reports based on various conditions and prompts to meet the user requirement.
• Used various types of prompts like text box, select & search, value & date prompts.
• Created cascading prompts in some of the reports to meet the functional requirement.
• Created reports of multiple report pages and prompt pages.
• Written several shell scripts using UNIX Korn shell for file transfers and clean up process
• Wrote unit test (SQL queries) queries and unit tested the reports using SQL Navigator to check the validity of the data.
• Reported defects using HP ALM Verified fixes and closed bugs during regression testing.
• Used SQL for Querying the DB2 database in UNIX environment
• Prepared manual test scripts covering different scenarios and documented in Mercury Quality center
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Extensively used SQL queries for Database testing and Validation
• Involved in all business meetings for understanding all the business logic.
• Tested the entire data reconciliation process for multiple source and target systems.
• Used HP ALM to Report, track and, monitor defects.
• Written SQL scripts to test the mappings and extensively used Cognos for report generation
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
• Involved in testing Cognos Reports and closely worked with operations, and Release teams to resolve the production issues.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Prepared extensive set of validation test cases to verify the data.

Environment: Teradata SQL Assistant 13.10, Oracle, HP ALM, JIRA, Informatica, MS Access, Excel, Unix, Putty, Control - M, Cognos, Pipe delimited Files

Confidential, Chicago, IL

Sr. ETL Tester

Responsibilities:

• Responsible for creating Test Strategy, Test Plans, Test Cases and other test documents based on business requirement.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica flow.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Reviewed the existing reports in MicroStrategy and analyzed the freeform SQL to understand the reporting requirement
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema.
• Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Assist QA Team with defining and implementing a defect resolution process including defect priority, severity, next steps, and assigned owner
• Automated & executed test cases using UFT
• Proficient in Functional Testing tool UFT and the various frameworks in UFT.
• Change Data Capture can do using the Power Exchange.
• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager and Informatica Power Exchange.
• Performed Functional Integration, System, Regression, End to End, Ad Hoc and UAT Testing.
• Validated various dashboards.
• Gathered and Analyzed Functional and Performance requirements.
• Extensively used SQL queries for data validation and back end testing.
• Tested UNIX shell scripts created for data migration.
• Tested customized and OBIEE reports with Metrics and Filters for Business analysis using Desktop intelligence with features of Drilling options drill up, drill down and drill anywhere
• Involved in extensive data validation using SQL queries and back-end testing
• Used HP ALM for test scripts creation, execution, test coverage and defect tracking
• Worked with integration services for transferring and reviewing data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Setup the Performance test environment with the support of technical team
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Performed tests to check whether there is any loss of data during data loads
• Worked on JIRA and ALM to log defects and track resolution till the closing of defect after retesting.
• Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Developed test reports and participated in testing prioritization and archived test results and user signoff.
• Written complex SQL queries to validate the data against the target based on ETL mapping specifications.
• Worked on Agile Methodology projects.

Environment: Teradata, Informatica 9.5.1, UFT 12, HP ALM 11.52, Informatica Power Exchange (8.6/8.5), Postman API, Microsoft Visual Studio Ultimate 2012, Putty, UNIX, Core FTP Lite, Filezilla, Microstrategy, OBIEE, Oracle, Excel & MS Access

Confidential, Cherry Hill, NJ

ETL Tester

Responsibilities:

• Extensively written several Test Scripts to compare source and target database.
• Analyzed the requirements and wrote simple to complex queries to test the requirements.
• Performed Dry Run on the test scripts before System Integration Testing.
• Involved in verification, validation, functional, GUI, system integration, sanity, and regression testing
• Validated data from source to stage and stage to target database.
• Tested several UNIX Shell Scripts and PERL scripts for connecting to database and for file manipulation of data.
• Worked on Informatica workflow monitor to create and execute workflows
• Used Informatica Power Exchange for loading/retrieving data from mainframe systems.
• Performed record count from source to target database
• Created and implemented Micro Strategy reports by creating projects, schema objects and public objects, Attributes, hierarchies, metrics, filters, and templates.
• Extensively worked with flat files and Excel sheet data sources. Wrote scripts to convert Excel to flat files.
• In the process of data migration, migrated data from an Oracle data source to Teradata.
• Prepared test/Seed data for various positive and negative testing scenarios.
• Tested Micro Strategy reports and written test cases using HP Quality Center.
• Experienced in writing UNIX shell scripts for testing the counts and for processing the test data feeds and folder contents.
• Followed Defect management life cycle and raised the defects based on priority and severity level on TFS.
• Automated & executed test cases using UFT
• Tracked the bad records present in the table.
• Tested all the reports by running queries against the warehouse-using TOAD. Also compared those queries with the Micro Strategy SQL engine generated queries.
• Validated the data present from flat files to database
• Wrote complex SQL queries using Teradata SQL assistant and toad for various testing purpose
• Developed test/QA environment using Informatica.
• Created mappings and executed workflows using Informatica power center
• Tested the layout of the table from the database to the data model.

Environment: Teradata SQL assistant 13.0, Micro Strategy, Toad for Oracle10g, Informatica Power Center 8.6.1, MS Excel, Erwin Data Modeler, SQL loader, Quality Center, TFS, Cobol Files, UNIX, UFT 11.5,

Confidential, Foster City, CA

ETL Quality Analyst

Responsibilities:

• Worked closely with Business Analysts and Developers to gather Application Requirements and Business Processes in order to formulate the test plan.
• Developed and maintained innovative, repeatable QA test plans based on functional requirements, use cases, user interface designs, system design documents and domain knowledge.
• Created high level strategy documentation and detailed test documents.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Test planning, documentation, coordination and execution and work with other QA engineers to coordinate testing.
• Extensively used Load Runner to validate the performance testing.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Experienced in writing complex SQL queries.
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation
• Determined the level of testing required validating new or revised system capabilities.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Developed Test Plans and developed Test Cases/Test Strategy with input from assigned business analysts and data architect.
• Reported accurate testing status and created test summary reports.
• Continuously improved test models, test data, and test processes based on lessons learned.
• Tested Business Objects reports and Web Intelligence reports.
• Managed user accounts and security using Business Objects Supervisor
• Coordinated component and system testing with the appropriate technical groups and Release Management and documented test procedures and findings.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used TOAD, SQL developer software for querying the Oracle databases.
• Used Teradata SQL Assistant 12.0 for accessing Teradata database on DEV, QA and Production areas.
• Created test mappings and MLOAD scripts for testing purposes.
• Used Maestro scheduler for composing and executing jobs to simulate the production environment in QA.

Environment: ETL (Informatica 8.5.1, Power Center), Business Objects XIR2, UNIX, Mercury Quality Center 8.2 (Test Director), Maestro Conman Scheduler, Oracle 10g, TOAD, Teradata SQL Assistant, Load Runner 9.10

Confidential

DWH Tester

Responsibilities:

• Involved in business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Developed test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on the ETL Mapping document.
• Extensively used SQL programming in backend and front-end functions, procedures, and packages to implement business rules and security.
• Gained solid testing experience in working with SQL stored procedures, triggers, and views and worked with performance tuning of complex SQL queries.
• Wrote Test Plans and Test Cases on Mercury’s Test Director Tool and also automated test cases using Quick Test Pro
• Defects identified in the testing environment were communicated to developers using the defect tracking tool, Mercury Test Director.
• Monitored production runs and resolved both technical and financial accounting problems. Implemented software upgrades. Coordinated hardware and software upgrades.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Used Quick Test Pro generated various scripts for performing functional testing
• Extensively used Cognos for testing various reports.
• Effectively communicated testing activities and findings in oral and written formats.
• Reported bugs and tracked defects using Test Director 6.5.
• Extensively used Ab Initio for extraction, transformation and loading process.
• Worked with the ETL group for understanding Ab Initio graphs for dimensions and facts.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process; automated the process of loading & pulling the data.

Environment: Ab Initio, Cognos 7.0, Oracle 9i, SQL Server 2000, Erwin 3.5, Test Director 6.5, Windows 2000, TOAD 7, Unix, QTP 9.5