PROFESSIONAL SUMMARY:

• Over 7+ years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Worked with IT Operations to ensure test environment readiness.
• 5+ years of experience in Data Warehouse applications testing using Informatica, SSIS, Shell Scripting, PL/SQL, Data Stage and Ab Initio on multiple platforms.
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Well versed in GUI application testing, Database testing and Front-end testing.
• Experience in Financial, Banking, Brokerage, and Securities industries
• 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.
• Experience in testing and writing SQL and PL/SQL statements.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects
• Experience in testing the Universe (business view of the database), and updating the existing Universes, developing canned/ad-hoc reports, scheduling the processes using Broadcast Agent and administering the BO activities.
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Well versed in analyzing the XML Files.
• Ability to interact with developers and product analysts regarding testing status and to maintain detailed QA documentation.
• Extensive background in QA methodologies.
• Strong Problem Analysis & Resolution skills and ability to work in Multi Platform Environments like Windows and UNIX.
• Experience in Installation and Implementing Mercury Interactive Test suite.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling
• Experience in testing XML files and validating the data loaded to staging tables.
• Good experience in Cognos & Business Objects Reports testing
• Experience in Performance Tuning of SQL and Stored Procedures.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Expert knowledge in UNIX shell scripting (Korn shell/Bourne shell)
• Excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

Data Warehousing: Ab Initio CO>Op 2.15, GDE 1.15, Informatica 8.6/8.1/7.1/6.1, SSIS, Data Stage 8.x

Reporting Tools Business Objects: 6.5, XIR3, Cognos 8 Suite

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Testing Tools: Win Runner, Load Runner, Test Director, Mercury Quality Center, Rational Clear Quest

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server 2008, UDB DB2 9.x, Sybase 12.5, Teradata V2R6, MS Access 7.0

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, Java, J2ee

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Novell NetWare, Win 3.x/95/98, NT 4.0, Sun-Ultra, Sun-Spark, Sun Classic, and SCO

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, Delaware

Data Warehouse Tester

Roles & Responsibilities:

• Used Quality Center to create manual and automated tests, build test cases, Test cycles, run tests, report and track defects.
• Generated reports and graphs to review the progress of test planning, tests run and defects tracked.
• Used Quality center to manage the requirements, test cases and also log defects and generate defect reports and graphs.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Developed Test Plan and Test Strategy for multiple data feed applications.
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and Tested the testing programs
• High Level Test Plans were written by incorporating User Profiles, Configurations, Environments, Risks, Test Scenarios, Schedules and Analysis and Presentation of Results
• Involved in developing test cases to test Teradata scripts (Bteq, multiload, fastload).
• As part of Data warehousing QA responsibilities, we have done with data verification and data validation of services providing by the Clear Vision system for business decision and reporting.
• Create and Monitor workflows using workflow designer and workflow monitor.
• Written several complex SQL queries for data validation and data verification.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Defined the Scope for System Integration Testing and was responsible to understand and train others on the enhancements or new features developed.
• Tune and test the mappings to perform better using different logics to provide maximum efficiency.
• Written Test Cases for ETL to compare Source and Target database systems, Source to Target column level mapping, check Referential integrity etc and created the scripts accordingly.
• Created BTEQ Scripts to automate the test cases and extensively written test scripts for back-end validations.
• Identifying duplicate records in the staging area before data gets processed and ensured that the mappings are correct and conducted data validation.
• Testing the source and target databases for conformance to specifications
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
• Testing of Business Objects and Reports which Includes, Database Connectivity, Tested objects in the Universe to ensure the correct mapping of the objects, Tested the Universe s Structure to ensure that tables are properly uploaded., Tested the aggregate Universe to ensure the query is pulling correct level of Aggregation
• Conducted review sessions on test case and regression test scripts in quality center.
• Reviewing the project and coordinating with onsite Clients, onsite Project Leads and local reporting managers.
• Involved in validating both functional and automated business processes using HP Quality center.
• Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly
• Identify & record defects with required information for issue to be reproduced by development team.
• Flexible to work late hours to coordinate with offshore team.

Environment: Oracle 10g, SQL, PL/SQL, Informatica 8.6.1/8.1, EME, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Teradata SQL Assistant, UNIX, TOAD, Business Objects XIR3 (Web Intelligence, Desktop Intelligence, Info View), XML, XSD, XML Spy 2008, Quality Center 10.0, Windows XP.

Data Warehousing Tester

Roles & Responsibilities:

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.2
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Expert in writing Complex SQL/PLSQL Scripts in querying Teradata and Oracle.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Defined data requirements and elements used in XML transactions.
• Tested the database schema with help of data architects using ERWIN.
• Involved in the testing of Data Mart using Power Center.
• Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Extensively used Teradata load utilities Fast load, Multiload and FastExport to extract, transform and load the Teradata data warehouse
• Responsible for different Data mapping activities from Source systems to Teradata
• Queried Teradata Database and validated the data using Sql Assistant.
• Effectively distributed responsibilities, arranged meetings and communicated with team members in all phases of the project.
• Used import and export facilities of the application to download/upload XMLs of failed test cases so as to re-verify.
• Scheduled the jobs using Auto sys and automated the jobs to be ran at specific time and automated the reports.
• Writing UNIX scripts to perform certain tasks and assisting developers with problems and SQL optimization
• Converted SQL queries results into PERL variable and parsed the same for multiple reasons.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system
• Performed Functional, Regression, Data Integrity, System, Compatibility.
• Tested different detail, summary reports and on demand reports.
• Implemented Database Checkpoints for Back-end Testing
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Processed a query to update a field in an Oracle database, to ensure that debt payments are allocated.
• Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
• Worked in multiple source data extraction and data transition from existing production system to test environment.
• Developed automation test scripts by using data driven, parameterization and regular expression in QTP.
• Involved in testing the UI applications
• Used Query Studio to develop ad hoc reports and tested reports using variety of parameters.
• Did Unit testing for all reports and packages.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Tested complex objects to the universe to enhance the report functionality.
• Tested ad hoc and canned reports for Business objects.
• Tested Business Objects reports and Web Intelligence reports
• Responsible for testing Business Reports developed by Business Objects XIR2
• Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects.
• Responsible for migrating the code changes from development environment to SIT, UAT and Production environments.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio.

Environment: Informatica Power Center 7.2, PowerConnect, Flat files, Perl, Erwin 4.0, DTS, MS SQL Server 2005, Oracle 9i, SQL, PL/SQL, IBM DB2 8.0, Teradata V2R6, Teradata SQL Assistant, Business Objects XIR2, COBOL, QTP 9.0, HP Quality Center 9.2, Auto sys, UTL FILE, TSO, ISPF, OS/z, JCL, Mainframes, Toad, Unix Shell Scripting, Windows XP/2000.

Informatica/SQL Tester

Roles & Responsibilities:

• Involved in creating source target mappings based on the Technical Design requirements.
• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• 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.
• Tested design strategy of the Extract, Transform and Load for various ODW tables.
• Tested mappings with the Design Documents and also performed testing for various sample data.
• Tested various mappings transformations like Filter, Joiner, Sequence Generator and Aggregator and perform query overrides in Lookup transformation as and when required to improve the performance of the mappings.
• Co-ordinate with team members for effective management for all project requirements and responsible for deliverables and receivables during all project phases.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Effectively communicate testing activities and findings in oral and written formats.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Used different sources for Input.
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
• Created different user defined functions for applying appropriate business rules
• Written test cases and completed unit test documentation.
• Used Unix environment variables in various .ksh files which comprises of specified locations to build Ab Initio Graphs
• Involved in pager rotation program to support 24 x 7 production support.

Environment: Informatica 6.1, MVS, UNIX (K-Shell Script), Oracle 10G, SQL Server 2005, DB2, Windows 2000 Pro, XML, XSLT, XSD, Rapid SQL, PL/SQL, TOAD, Dat Files, XML Files, Autosys

DWH/Backend Tester

Roles & Responsibilities:

• Participated in business requirement walk through, design walk through and analyzed Business requirements.
• Involved in developing detailed test plan, test cases and test scripts using Test Director 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.
• Created Test plan, Test Design, Test scripts and responsible for implementation of Test cases as Manual test scripts.
• 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)
• Written several complex SQL queries for validating Cognos Reports.
• Tested several stored procedures.
• Written customized SQL queries for business needs.
• Did automation using PERL and UNIX Shell scripting.
• Reviewed system use cases and functional specs with business and System Analysts.
• 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
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server based data warehouse.
• Involved in testing the UI applications
• Involved in Security testing for different LDAP roles.
• Worked with business team to test the reports developed in Cognos
• Tested whether the reports developed in Cognos are as per company standards.
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.

Environment: Informix, DB2, Java, Cognos, SQL, Teradata V2R4 (MLOAD, FLOAD, FAST EXPORT, BTEQ), XML, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, Ultra editor, Oracle 8i/9i, DB2, SQL Server 2000, Mainframe, SunOS 5.8, DTS, ERWIN, Windows XP