We provide IT Staff Augmentation Services!

Sr Data And Quality Assurance Analyst Resume

Atlanta, GA

SUMMARY:

  • Over all 13 years of total IT experience and very good knowledge QA of Software Applications and Testing. Extensive experience in testing of data warehouse / data marts for business applications with Financial, Insurance, Pharmaceuticals, Manufacturing.
  • Extensive 8 years of QA experience in Data Warehouse experience in building and managing various data warehouse / data marts using Informatica products such as Informatica Power Center/Power Mart, Power Connect, Power Analyzer and Power Exchange Tools.
  • Experience working in using Databases like Oracle, SQL Server, Teradata, MS Access and DB2. Expertise in Database Programming (Stored Procedures, Triggers, Packages, PL/SQL) using Oracle.
  • Expert in testing Mainframes environment using TSO, ISPF, JCL, COBOL II, VSAM and Copy Books.
  • Experience in Pharmaceutical, Financial, Banking, Brokerage, and Securities industries.
  • Extensive testing ETL experience using Informatica 8.1/7.1/6.2/5.1 (Power Center / Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
  • Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica.
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
  • Extensive experience in Business Intelligence reporting tools using Cognos Series, Power Play, Transformer, Impromptu Web Reports (IWR).
  • Extensive experience in Web Services testing using SOAP UI tool.
  • Extensive experience in various data files Flat files, Txt files, XML, Delimiter and Mainframes files.
  • Extensively used SQL, PLSQL to create complex queries, SQL Override, Stored Procedures, and Triggers.
  • Experienced in Data Modeling, Erwin, Star/Snow Flake Schema Designs, Logical Data Modeling, Normalization, Physical Design, Data Analysis, Data Modeling, Reports and Report Design.
  • Expertise in writing UNIX Shell Scripts and writing complex SQL queries
  • Excellent Analytical and Logical Programming skills with a good understanding at the Conceptual Level and possess excellent Presentation, Interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.

TECHNICAL SKILLS:

OS: Sun Solaris 2.7/2.6, HP-UX, IBM AIX 4.3/4.2, MS DOS 6.22, Win NT/2000/98/95.

ETL Tools: Informatica Power Center 8.1/7.1/6.x, Power Connect, Power Analyzer, and Power Exchange tools, Datastage 7.5x, SSIS, Ab Initio (GDE 1.15, Co>Op 2.15)

BI Tools: Cognos Impromptu 8.0, Cognos Reportnet 1.1, Business Objects, and Siebel Analytics

Languages: SQL, PL/SQL, VB, C, C++, JCL, COBOL, Shell Scripting, PERL

Databases: Oracle 10g/9i/8i, MS Access, SQL Server, Teradata, DB2, Sybase

Other Tools: Erwin 4.5/4.0/3.5.5/3.5.2

Testing Tools: Win Runner 8.2, Rational Clear Quest, Rational Functional Tester, Load Runner 7.8, QTP 8.2, Quality Center, and Test Director

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr Data and Quality Assurance Analyst

Responsibilities:

  • Review requirements and design documentation to ensure traceability and testability, review deliverables for adequacy and completeness prior to systems implementation into production
  • As a member of the Scrum team participated in daily standup meetings, project status meetings, grooming sessions, backlog meeting, Sprint planning meeting as well as retrospective meetings and iteration reviews.
  • Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL mapping document.
  • Reviewed and translated the system requirements into system test elements like modular test scenarios, scripts and test cases for the Selling system components using Quality Center
  • Involved in developing detailed Test strategy, Test plan, Test cases and Test procedures using Quality Center for Functional and Regression Testing
  • Validating the data files from source to make sure correct data has been captured to be loaded to target tables
  • Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
  • 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.
  • As an analyst involved in gathering System and Business requirements, studying and coordinated with the Development and Business teams to prepare Test Plans.
  • Analyzed the Business requirements, Functional requirements and Design Specifications, Detail Design Specifications and Technical Specifications in order to write the Test Plans and Tests cases in Quality Center.
  • Involved in developing detailed test plan, and responsible for writing test cases and test scripts using Quality Center for System Integration, User Acceptance, Functional and Regression Testing and various other testing.
  • Involved in Database testing by writing & executing SQL & PLSQL queries by using PL/SQL Developer to validate the data that is being populated in an appropriate tables & manually comparing the results with front-end values.
  • Developed and involved in Manual Testing Test scripts based on Use cases.
  • Conducted the Functional, System, White Box, Regression, User Acceptance and Performance testing of the application.

Environment: Informatica, Oracle 11g, PL/SQL, UNIX Shell Scripting, Quality Center 10.

Confidential, Atlanta, GA

Data and Quality Assurance Analyst

Responsibilities:

  • Involved in writing the test cases and Test plans based on Informatica Mappings Transformation Matrix or (Traceability Matrix) for supporting Black box and White Box testing.
  • As a member of the Scrum team participated in daily standup meetings, project status meetings, grooming sessions, backlog meeting, Sprint planning meeting as well as retrospective meetings and iteration reviews.
  • Prepared documentation for all the testing methodologies used to validate the Data Warehouse.
  • Developed test conditions and test scenarios according to Business Requirements in Quality Center.
  • Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse.
  • As an analyst involved in gathering System and Business requirements, studying and coordinated with the Development and Business teams to prepare Test Plans.
  • Analyzed the Business requirements, Functional requirements and Design Specifications, Detail Design Specifications and Technical Specifications in order to write the Test Plans and Tests cases in Quality Center.
  • Involved in developing detailed test plan, and responsible for writing test cases and test scripts using Quality Center for System Integration, User Acceptance, Functional and Regression Testing and various other testing.
  • Worked with data validation, data cleansing, constraints, record counts, and source to target, row counts, random sampling and error processing.
  • Conducted the Functional, System, White Box, Regression, User Acceptance and Performance testing of the application.
  • Responsible for defect tracking, defect reporting and defect reproducing.
  • Documented defects accurately and with sufficient information to enable developers to analyze and reproduce the defect using defect reporting tool.
  • Good experience working on the Agile environment and PMO standards
  • Managed the testing process, bug reporting, analyze the test results, track the progress of system testing, and provide daily status to Test Manager in everyday Stand-up meetings.
  • Tested Web Services, XML, WSDL using SOAPUI tool. Modified end points when we worked on different servers and different versions of Web Services.
  • Tested Web Services, providing required input data to request XML and validated response XML
  • Validated Web Services request and response xml using SOAPUI tool.
  • Extensively performed database testing with SQL Queries.
  • Involved in Database testing by writing & executing SQL & PLSQL queries by using PL/SQL Developer to validate the data that is being populated in an appropriate tables & manually comparing the results with front-end values.
  • Developed and involved in Manual Testing Test scripts based on Use cases developed.
  • Conducted the Functional, System, White Box, Regression, User Acceptance and Performance testing of the application.

Environment: Informatica, Micro Strategy, Netezza, Oracle 11g, XML, XML Spy, PL/SQL, UNIX Shell Scripting, Quality Center 10, VersionOne, Web Services.

Confidential, Charlotte, NC

Sr ETL Tester

Responsibilities:

  • Experience with high volume datasets from various sources like SAS, MS-SQL Server 2008, Teradata, Mainframes (EBCDIC), Text Files, and Netezza Relational Tables and xml targets.
  • Tested and validated XML Data verification, XML Elements Verification, DTD Validations, XML Schema validation(XSD Files)
  • Validated and good knowledge on Claims, Providers, Members, enrollments, policy member demographic, disease management data.
  • Tested Web Services, XML, WSDL using SOAPUI tool. Modified end points when we worked on different servers and different versions of Web Services.
  • Tested Web Services, providing required input data to request XML and validated response XML
  • Validated Web Services request and response xml using SOAPUI tool.
  • Performed database testing with SQL Queries.
  • Involved in various phases of SLTC like White box Testing, Functional Testing, Integration Testing, Performance Testing, Regression Testing, Smoke Testing and UAT Testing.
  • Prepared documentation for all the testing methodologies used to validate the Data Warehouse.
  • Test execution in accordance with test strategy and test schedule, review; issue identification and data mining exercises in accordance with project plan timelines.
  • Tested several ab initio graphs for inbound and outbound files from various external vendors.
  • Experience running the ab initio psets from command prompt using air command.
  • Experience running the ETL jobs from Control M scheduler.
  • Responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
  • Used various SQL queries to validate the test case results for back-end test cases.
  • Worked on the UNIX for the running the Ab Initio graph in the HP UX environment.
  • Tested Web Sphere MQ Messages passed through web services to load into EDW tables in the Integration testing.
  • Tested several extracts from Legacy System (Mainframes) to Teradata.
  • Compared Data between Mainframes DB2 to Teradata data.
  • Tested several reports in Micro Strategy 9.2.
  • Tested metrics and dashboard in Micro Strategy 9.2.
  • Providing testing inputs to the Project team (Project manager, Planner and the Development lead) during the Planning sessions to finalize the Work Breakdown structure (WBS).

Environment: Abnitio2.15,Mainframes,JCL,COBOL,CICS,VSAM, Hyperion, Micro Strategy 9.2, Netezza, Oracle 11g, MS-SQL Server 2008, XML, PL/SQL UNIX Shell Scripting, Putty, Control M, Share Point, Business Objects & Quality Center 10.

Confidential, Durham, NC

Sr ETL Tester

Responsibilities:

  • Review requirements and design documentation to ensure traceability and testability, review deliverables for adequacy and completeness prior to systems implementation into production
  • As a member of the Scrum team participated in daily standup meetings, project status meetings, grooming sessions, backlog meeting, Sprint planning meeting as well as retrospective meetings and iteration reviews.
  • Preparing detailed Test plan, Test scripts and test cases by understanding the business logic and user requirements. Expertise with Functional testing, System testing, Integration testing and Smoke testing.
  • Tested several ab initio graphs for inbound and outbound files from various external vendors.
  • Tested Web Services, XML, WSDL using SOAPUI tool. Modified end points when we worked on different servers and different versions of Web Services.
  • Tested Web Services, providing required input data to request XML and validated response XML
  • Validated Web Services request and response xml using SOAPUI tool.
  • Experience running the ETL-Ab initio psets from command prompt using air command in UNIX box.
  • Experience running the ETL jobs from Control M scheduler.
  • Responsible for defect tracking, defect reporting and defect reproducing.
  • Loaded several extracts from Mainframes (DB2) to Teradata.
  • Developed complex SQL queries in Teradata during End-to-End testing stage.
  • Good testing experience on various flat files, source conditioning files.
  • Good experience on validating the slowly changing dimension tables (Type 1,Type 2 & Type 3)
  • Tested and validated, data cleansing, XML Data verification, XML Elements Verification, DTD Validations, XML Schema validation (XSD Files).
  • Used various SQL queries to validate the test case results for back-end test cases.
  • Tested the BTEQ scripts which insert the data into the target tables. Tested various reports in the Business Objects.
  • Well exposed to Software Development Life Cycle and Test methodologies.
  • Tested the data and data integrity among various sources and targets.
  • Tested various MQ messages passed through web services.
  • Involved in testing to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test cases.
  • Created the test data & Coordinating with Developers/Leads in resolving bugs.
  • Worked with data validation, data cleansing, constraints, record counts, and source to target, row counts, random sampling and error processing.
  • Responsible for validating the transferred data in MS-SQL Server 2008, Procedures and functions etc.
  • Worked on the UNIX for the running the Ab Initio graph in the HP UX environment.
  • Worked on migration project for the Business Objects to Micro Strategy
  • Validated several reports and compared reports against Business Objects to Micro Strategy
  • Validated and tested several dashboards in the Micro Strategy.

Environment: Abnitio2.15,Microstrategy 9.2,Business objects XI, Mainframes COBOL,JCL,CICS, VSAM, Teradata V13, MS-SQL Server 2008, XML, PL/SQL UNIX Shell Scripting, Control M, Share Point, Business Objects, OBIEE, Putty & Quality Center 9.2.

Confidential, St Louis

Sr ETL Tester

Responsibilities:

  • Writing the test cases and Test plans based on Informatica Mappings Transformation Matrix or (Traceability Matrix) for supporting Black box and White Box testing.
  • Prepared documentation for all the testing methodologies used to validate the Data Warehouse.
  • Developed test conditions and test scenarios according to Business Requirements in Quality Center.
  • Developed detailed test plan, and responsible for writing test cases and test scripts using Quality Center for System Integration, User Acceptance, Functional and Regression Testing and various other testing.
  • Experience in testing many multi-layer data warehouse on Unix, Windows and Teradata systems
  • Involved in writing JCL and Procedures to execute programs and create generation’s files.
  • Tested Web Services, XML, WSDL using SOAPUI tool. Modified end points when we worked on different servers and different versions of Web Services.
  • Tested Web Services, providing required input data to request XML and validated response XML
  • Validated Web Services request and response xml using SOAPUI tool.
  • Validate Web services built in SOA Architecture using SOAP UI and HP Service Test tool
  • Performed Integration testing with the Web Service and overall System testing.
  • Created the Test data using Altova XML Spy in XML format and made the required modifications that helped extensive Backend Testing.
  • Generate Web Service test cases in Soap UI Pro 8
  • Excellent experience in testing the various reports generated in with Hyperion.
  • Tested various reporting like year to date, month to date, quarterly, half yearly reports in Hyperion
  • Tested various dashboards and answers in Hyperion.
  • Tested various ETL transformed from Mainframes System to EDW.
  • Tested user privilege, data access level testing in Hyperion
  • Integration of mainframe and Unix environments in Data warehousing
  • Conducted the Functional, System, White Box, Regression, User Acceptance and Performance testing of the application.
  • As an analyst involved in gathering System and Business requirements, studying and coordinated with the Development and Business teams to prepare Test Plans.
  • Analyzed the Business requirements, Functional requirements and Design Specifications, Detail Design Specifications and Technical Specifications in order to write the Test Plans and Tests cases in Quality Center.
  • Extracted data from flat files and RDBMS tables and upload into targets Oracle tables. Used Informatica as the ETL tool to extract the data from sources and loading it into targets.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
  • Managed the testing process, bug reporting, analyze the test results, track the progress of system testing, and provide daily status to Test Manager.
  • Good experience working on the Agile environment and PMO standards
  • Executed and written UNIX shell scripts to check whether data import/export done correctly or not.
  • Written several complex SQL queries for validating/verifying various business rules.
  • Involved in Database testing by writing & executing SQL & PLSQL queries by using TOAD to validate the data that is being populated in an appropriate tables & manually comparing the results with front-end values.
  • Worked with business team to test the reports developed in OLAP. Tested whether the reports developed in OLAP are as per company standards.
  • Participated in weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application

Environment: Informatica Power Center 8.6, Talend Kettle, Hyperion 8, Oracle 10g, SQL, PL/SQL, SQL Server 2000/2005, Unix Shell Scripting, JCL, TSO, Micro focus COBOL, TOAD 9.2,Ma inframe, HP Quality Center 10, SSRS.

Confidential

Sr. QA/ ETL/ Analyst/ Designer

Responsibilities:

  • Gained Knowledge and tested various applications like Claims, Financials, Reinsurance Claims, Actorials, and Underwriting.
  • Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse.
  • Well exposed to SDLC (Software Development Life Cycle) and Test methodologies.
  • Configured the QA Environment for Manual Testing as well as Automation through Autosys.
  • Designed and created the Microsoft Visio diagram which represents the workflow and execution process of all the process in the reinsurance world.
  • Worked with Legacy Mainframe environment and tested the COBOL Files and Record Formats using Copy Books.
  • Experience in testing many multi-layer data warehouse on Unix, Windows and Teradata systems
  • Involved in writing JCL and Procedures to execute programs and create generations files
  • Integration of mainframe and Unix environments in Data warehousing
  • As a Test Lead involved in gathering System and Business requirements, studying and coordinated with the Development and Business teams to prepare Test Plans and Execution Plans.
  • Involved in Database testing by writing & executing SQL & PLSQL queries using TOAD to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.
  • Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
  • Involved in writing the test cases and Test plans based on Informatica mappings and Data Analyst mappings, BA Visio diagrams.
  • Used Rational Functional Tester for Web Interface and Data Driven.
  • Tested the Direct Sales Fact, Prescription Sales Fact, Sales level Market Level Fact etc
  • Tested and Worked with OBIEE Pre-built dashboards like Backlog, Customer Report, Sales cycle and Customer dashboards
  • Created Test Cases for Siebel Analytics/OBIEE Admin Functionalities and iBots.
  • Validation of Data Loaded by ETL Process.
  • Tested the Configured OBIEE iBots to deliver analytics content based on schedule to obtain daily reports and sent notification Alerts.
  • Tested and worked on OBIEE Publisher, Webcat Manager, OBI Presentation services (Answers and Dashboards) to create reports and dashboards.
  • Resolved data quality issues for multiple feeds coming from Mainframe Flat Files
  • Involved in testing to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test cases. Involved in various testing phases like Functional Testing, Unit Testing, System Testing, Integration Testing, Data Validation Testing Positive and Negative Testing, White Box Testing, Black Box Testing, Smoke Testing, User Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing.
  • Extensively worked on handling the application response for Positive and Negative sets of data using data driven testing. Also manually tested the application for each system build, for both negative and positive testing.
  • Tested complex objects to the universe to enhance the report functionality.
  • Tested ad hoc and canned reports for Business objects.
  • Coordinate Test Data Preparation with business users covering all necessary features for securities.
  • Test execution in accordance with test strategy and test schedule, review; issue identification and data mining exercises in accordance with project plan timelines.
  • 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.
  • Generated tractability Matrices to ensure that all the requirements are covered by the test cases.
  • Extensively used Informatica Debugger for testing the mapping logic during Unit Testing. Performed unit testing, integrated testing and validated results with Business Analyst and/or customer.
  • Involved in FTP process to transfer the files from one server to other.
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
  • Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
  • Utilized Test Director/Quality Center for Tracking and Reporting Defects, which are assigned to developers. Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
  • Providing testing inputs to the Project team (Project manager, Planner and the Development lead) during the Planning sessions to finalize the Work Breakdown structure (WBS).
  • Participated in Daily and weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application.

Environment: Informatica Power Center 7.x and 8.1/8.6,OBIEE Sales 10.1.3, Business Objects XIR2/6.5.1, SQL, PL/SQL, SQL Server 2000/2005, Unix Shell Scripting, JCL, TSO, Micro focus COBOL, TOAD 9.2,Teradata, Oracle 8i, 9.2 and 10G, Mainframe, HP Quality Center, Autosys, MQ Series, Microsoft Visio, Web Focus reports

Confidential, Houston, TX

Sr. QA/ ETL Tester/ Designer

Responsibilities:

  • Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
  • Involved in writing the Test Plans based on Business Requirement and Functional Requirement documents.
  • Involved in implementation of the Test plans, Test cases and Test Scripts.
  • Created Test sets in Test Lab to move all the test cases from Test plan to execute the test cases.
  • Tested the data and data integrity among various sources and targets.
  • Developed and involved in both Manual Testing and Automation Test Scripts based on Use cases developed.
  • Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
  • Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test cases.
  • Created reports using Business Objects functionalities like Slice & Dice, Drill Mode, @Functions, Cross Tab, Master/Detail and Formulas etc
  • Reviewed Informatica mappings and test cases before delivering to Client.
  • Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
  • Trained and coordinated with the offshore team members in understanding the requirements and test cases for UAT.
  • Worked with Rational Functional Tester for both manual and automation for setting up verification points and regular expression.
  • The reports that were created in Business Objects were testing by running the SQL statements
  • Involved in ETL Mapping Design and Performance tuning to Load mapping process.
  • Experienced in writing complex SQL queries for extracting data from multiple tables.
  • Reviewed the test cases written based on the Change Request document.
  • Testing has been done based on Change Requests and Defect Requests.
  • Involved in preparation of System Test Results after Test case execution.
  • Experienced in writing UNIX script.
  • Effectively coordinated with the development team.
  • Created critical scenarios for each change request and defect request.
  • Worked on HP Quality Center and updated defects status with appropriate information. Test cases and Test plans are managed and controlled using HP Test Director. And also used HP Test Director to manage and track defects.
  • Designs, test scripts, for data driven test for Web- based pricing and underwriting system
  • Involved in deployment of programs using web logic server
  • Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing.
  • Used various SQL queries to validate the test case results for back-end test cases.
  • Well exposed to Software Development Life Cycle and Test methodologies.
  • Hands on experience with working on Autosys jobs and MQ’s. MQ’s are used for intermediate storage where the messages are stored for temporary purpose.
  • Hands on experience working with SQL Server DTS Packages.

Environment: Informatica Power Center 8.1, Rational Functional Tester, Business Objects XIR2/6.5.1, SQL, PL/SQL, SQL Server 2000/2005,Teradata,Unix Shell Scripting, XML, XML Spy 2008, XSLT, TOAD 9.2,Oracle 9.2, HP Quality Center, Rational Suite, DB Artisan 8.5.2, Autosys, MQ’s

Confidential, Warren, NJ

Data/ SQL Tester

Responsibilities:

  • Gathered user requirements from each Business Units for test.
  • Interacted with the Business users to identify the process metrics and various keys dimensions and measures.
  • Designed and developed Test Plans and Test Cases and executed them.
  • Involved in implementation of the Test plans, Test cases and Test scripts.
  • Involved in the error checking and testing of the ETL programs using Informatica session log and workflow logs.
  • Used Teradata SQL Assistant extensively to work with Teradata Database.
  • Involved in ETL Mapping Design and Performance tuning to Load mapping process.
  • Organized sessions in a batch to run the sessions in a batch in sequential order or start them concurrently by the server.
  • Mainframe testing skills including modifying the JCL
  • Designed process performance loading strategies. And also wrote the optimizing techniques to improve the process loading time within the streamline using Server Manager to load the data into the Target Database.
  • Involved in writing Test cases and Test plans which are managed and controlled using HP Test Director. Also used HP Test Director to manage and track defects.
  • Documented defects accurately and with sufficient information to enable developers to analyze and reproduce the defect using Test Director’s defect reporting tool.
  • Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing and Performance Testing.
  • Used various SQL queries to validate the test case results for back-end test cases.
  • Well exposed to Software Development Life Cycle and Test methodologies.
  • Created and published Impromptu/Report Net reports.
  • Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
  • Used Query Studio to test ad hoc reports.
  • Involved in Unit Testing of all reports and packages.
  • Involved in testing the Cognos reports by writing complex SQL queries.
  • Developed complex queries using different data providers in the same report.

Environment: Informatica Power Center 8, SQL Server, SQL, PL/SQL, Erwin 4.0, UNIX Shell Scripting, XML,JCL,TSO, TOAD, HP Quality Center, Teradata, Report Net, Mainframe, Framework Manager, Cognos 8 B Report Studio, Cognos 8 BI Query Studio, Report Net 1.1

Confidential, MA

Data Tester/ ETL/ SQL

Responsibilities:

  • Used Informatica Power Center for Extraction, Loading and Transformation (ETL) of data into the Data Warehouse.
  • Involved in developing the Test Cases, Test Plans and Test Scripts using the Business Requirement
  • Developed Shell Scripts to perform pre-session and post-session operations.
  • Involved in writing the Test Cases, Test Plans and Test Scripts using the Business Requirement
  • Involved in Manual Testing of the Application.
  • Involved in Positive and Negative Testing.
  • Created the test data & Coordinating with Developers/Leads in resolving bugs.
  • Completely involved in developing Test Plans and developed Test Cases/Test Strategy with input from the assigned Business Analysts
  • Extensively involved in the Performance testing of the programs, ETL Procedures and Processes
  • Coordinated with QA Testing Team to test various test scenarios involving Test Plans, Test Cases and Test Scripts.
  • Used various SQL queries to validate the test case results for back-end test cases.
  • Extensively used Mercury Quality Center (Test Director) and created Test Cases in the Test Plan according to the specifications.

Environment: Informatica Power Center 7.1, Oracle, MS Excel, Flat Files, SQL, PLSQL, SQL Server, Erwin 4.0, Unix Shell Scripting

Confidential, DE

Data Tester

Responsibilities:

  • Gathering of user requirements and source system analysis and establishing mappings between sources to target attributes.
  • Involved in writing the Test Plans based on Business Requirement and Functional Requirement documents.
  • Involved in writing the Test Cases and Test Plans based on Informatica mappings Data Analyst mappings and BA Visio diagrams.
  • Worked with business, technical, QA for data reconciliation needs for multiple source systems including Mainframe Flat Files, XML, DAT, CSV, Excel Sheets and RDBMS data.
  • Attending Daily Status meetings to report the Status of QA team to Managers.
  • Used Informatica Power Center for Extraction, Loading and Transformation (ETL) of data into the Data Warehouse.
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
  • Developed Shell Scripts to perform pre-session and post-session operations.
  • Involved in Positive and Negative Testing.
  • Extensively involved in the Performance testing of the programs, ETL Procedures and Processes
  • Coordinated with QA Testing Team to test various test scenarios involving Test Plans, Test Cases and Test Scripts.
  • Used various SQL queries to validate the test case results for back-end test cases.
  • Documented defects accurately and with sufficient information to enable developers to analyze and reproduce the defect.

Environment: Informatica Power Center 6.x, Oracle 9i, SQL, PL/SQL, Mainframe, Erwin 4.0, UNIX Shell Scripting

Confidential, Tennessee

Data Tester

Responsibilities:

  • Experience in designing and developing Test Plans and Test Cases based on the Business Requirements Document, and Functional Requirements Document for new and existing products.
  • Created and tested Database connections to Informatica Repository and configured the components.
  • Extracted data from various sources and to targets like Flat files, Oracle, XML and DB2 VSAM Files
  • Extensively performed database testing with SQL Queries.
  • Worked with Legacy Mainframe environment and tested the COBOL Files and Record Formats using Copy Books.
  • Used extensive SQL query. Evaluated actual data load results. Involved with high volume testing.
  • Created the test data & Coordinating with Developers/Leads in resolving bugs.
  • Developed Shell Scripts to perform pre-session and post-session operations.
  • Wrote the SQL queries in TOAD to check the data in different stages.
  • Extensively written, created and completed regression test cases.

Environment: Informatica Power Center 7.1, Oracle 9i, SQL, Mainframe, PL/SQL, Erwin 4.0, UNIX Shell Scripting, Toad

Confidential, Philadelphia, PA

Data Tester

Responsibilities:

  • Executed test cases for complex Mappings that involved expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.
  • Major involvement in tuning the mappings, to perform maximum efficiency and performance complete knowledge of session properties in server manager.
  • Involved in the error checking and testing of the ETL procedures and programs Informatics session logs and workflow log.
  • UNIX scripts were written at various situations like job scheduling etc. Wrote different stored procedures to check Pre-Load and Post-Load session Jobs.
  • Coordinated with QA Testing Team to test various test scenarios involving Test Plans, Test Cases, and Test Scripts.
  • Extremely involved in using Test Director for identifying the bugs with the help of SQL queries. Reported Defects and prioritized outstanding defects using Test Director/Quality Center.

Environment: Informatica Power Center 6.2/5.1, UDB DB2, Windows NT, Sybase, Sybase Central 3.2.0, Mainframe, Sybase SQL Advantage 11.5.1, Business Objects 6.x, Shell Scripting, Sun Solaris 5.8, Test Director 8.x, Win Runner 7.6

Hire Now