SUMMARY:

• Over 8 years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms.
• Expertise in Automated Software Quality Testing & Manual Testing of Web based and Client - Server applications and in Data Warehouse applications testing using Informatica Power Center and Data stage on multiple platforms.
• Expertise in Extraction, Transformation and Loading (ETL) processes using Informatica Power Center (Source Analyzer, Warehouse and Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager, Workflow Monitor, Informatica Power Analyzer, Power Exchange, Informatica Power Connect, Informatica Power Plug, Informatica Designer, Workflow Manager, Work flow Monitor, ETL, ODS, OLAP, OLTP, Mapplet, Transformations.
• Possess excellent skills in Automation Testing using HP / Mercury´s Quick Test Pro (QTP), Quality Center.
• Experienced in creating the SSIS packages, DTS packages
• Well versed with various types Software Development methodologies- Waterfall, Agile, RUP, Iterative and Extreme Programming.
• Worked with SOAPUI for testing Web Services
• Experienced in configuration management using Visual Studio Team System (VSTS), Team Foundation Server (TFS), VSS and Subversion
• Executed the Batch job in Autosys and validated the data.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Experience with Agile/ Scrum Methodology.
• Good Knowledge on Business intelligence, OLAP, Dimensional modeling, Star and Snowflake schema, extraction, transformation and loading (ETL) process
• Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
• Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
• Experience in data retrieval methods using Universes, Personal Data files, Stored Procedures, and free hand SQL. Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Proficient in SQL, PERL, Shell Scripting and PL/SQL coding and experience in Performance Tuning of SQL and Stored Procedures.
• Experience in testing Business Report developed in Cognos
• 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.

TECHNICAL SKILLS:

Data Warehousing: Informatica 9.0 8.6.1/8.1/7.1/, Data Stage 8.x

Reporting Tools: Business Objects 6.5/XIR3, Cognos 8.0 Suite, Crystal Reports, SSAS, SSRS, MicroStrategy 8.x

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

Testing Tools: Win Runner, Load Runner, Test Director, HP Quality Center, Rational Tools

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

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, .NET, Java, J2EE, XML, XSD, XSLT

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

MPP: Databases Netezza NPS 8050

PROFESSIONAL EXPERIENCE:

Confidential, Monroe, LA

Sr. ETL QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 10
• Tested ETL jobs as per business rules using ETL design document
• Involved in Test plan, Test case preparation and assigning defects through TFS(Team Foundation Server
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Expert in writing Complex SQL/PLSQL Scripts in querying Teradata and Oracle.
• Defined data requirements and elements used in XML transactions.
• Worked with business team to test the reports developed in Cognos
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Developed UAT test cases for business users and worked closely with them to execute UAT test cases.
• Experience is creating test cases to validate functionality and performing UAT testing
• Tested Dimensional tables SCD Type 1, Type 2 and Fact Tables in Star Schema
• Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
• Good experience in web related technologies including HTML, XML, SOAP, JavaScript, ASP, VB, VB.NET,ASP.NET
• Did testing of SOA end to end, Service by service and Interface by Interface
• Extensively used Informatica Power Center for Extraction, Transformation and Loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Extensively used Teradata load utilities Fast load, Multiload and FastExport to extract, transform and load the Teradata data warehouse
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Autosys.
• Worked in an agile technology with Scrum.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Queried Teradata Database and validated the data using SQL Assistant.
• Involved in automation of test cases using QTP and Did functional testing using QTP
• Effectively distributed responsibilities, arranged meetings and communicated with team members in all phases of the project.
• Scheduled the jobs using Auto sys and automated the jobs to be run at specific time and automated the reports.
• Writing UNIX scripts to perform certain tasks and assisting developers with problems and SQL optimization.
• Configured Quick Test Pro with Quality Centre and Maintained the project information in Quality Centre.
• 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.
• Did work with SOA testing involving SOAP, XML, and REST. Analyzed Mapping and System Bottlenecks to improve the performance of various ETL Jobs.
• Built database based on technical requirements. Managed and extracted Metadata associated with ETL processes.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio.

Environment: Informatica 8.6.1, MS SQL Server 2008, TFS,VSTS, Oracle 11g / 10g, SQL, PL/SQL, IBM DB2 8.0, AGILE/scrum, Teradata V2R6, Teradata SQL Assistant, SOAP, SOAPUI, Web Services, Cognos 8.0 Series, HP QTP 9, HP Quality Center 10,Toad,Autosys, SSIS, Unix Shell Scripting, Windows

Confidential, Baton Rouge, LA

Sr. ETL QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0.
• Experienced in configuration management using Visual Studio Team System (VSTS), Team Foundation Server (TFS), VSS and Subversion.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata.
• Designed the Load Runner scenarios with various user-mix incrementing in constant ratios, till the peak load is achieved.
• Compared the data sets resulted from the databases Oracle and SQL Server using the tool, Toad for Data Analysts.
• Worked with SOAPUI for testing Web Services
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing
• Extensively used AUTOSYS to schedule the jobs and run the scheduled jobs at specific time.
• Developed TSL (Test Script Language) for automated Testing using Win Runner. Worked with business team to test the reports developed in Cognos.
• Understanding Source Systems used by State Farm Insurance to populate Data Mart.
• Working on defining mapping requirements sources systems used by State Farm Insurance to populate data mart.
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica
• Tested SOA security with limited access to communicate between the services
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports.
• 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 validation, constraints, source to target row counts.
• Used data conversion to protect the data and prevent data loss.
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs
• Experienced in working with DB2, Terada.
• As Data warehouse ETL Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica.
• Written Test Cases for Data warehouse ETL to compare Source and Target database systems
• Extensively used Data warehouse ETL Informatica Debugger to validate maps and to gain trouble-shooting information about date and error conditions.
• Tested several Data warehouse ETL Informatica Mappings to validate the business conditions.
• Involved in the error checking and testing of the Data warehouse ETL procedures and programs Informatica session log.
• Used Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Strong in writing SQL queries and makes table queries to profile and analyze the data in MS Access.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Monitored the Informatica workflows using Power Center monitor. Checked session logs in case of aborted/failed sessions
• Performed Web Services testing and Validated XML request/response data using SOAPUI.
• Perform Functional, Data Validation, Integration, regression and User Acceptance testing.
• Used TOAD, DB Artisan tools to connect to Oracle Database to validate data that was populated by ETL applications
• Worked with business team to test the reports developed in Cognos.
• Involved in testing Unix Korn Shell wrappers to run various ETL Scripts to load the data into Target Database (Oracle).
• Created test cases and executed test scripts using Quality Center.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables

Environment: Informatica 8.1, Informix, DB2, Java, TFS,VSTS, Cognos 7 Series, SQL, PL/SQL,SQL Server 2000/2005, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), SOAP, SOAPUI, Web Services AutoSys, Teradata SQL Assistant 7.0, SSIS,XML, XSLT, XML Spy 2008, UNIX, Shell Scripting, HP QTP v5.5/6.5, HP Quality Center 9.2

Confidential, Baton Rouge, LA

QA Tester

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Wrote complex SQL queries for querying data against different data bases for data verification process.
• Designed the data flow diagrams using MS VISIO.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• 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
• As Data warehouse ETL Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica.
• Experience with Auto sys job scheduler including jil scripting, virtual machines and custom calendars.
• Helped the Testing team by writing SQL statements to validate the reports
• Used multiple data providers, Master/Detail, cross tab, Charts.
• Created several Ad-hoc reports in Business Objects XI R2 to validate the data.
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro.
• Worked with SSIS system variable, passing variables between packages.
• Created cascading prompts at the universe level. These cascading prompts were used within full client and thin client reports to narrow down the selection parameters.
• Tested different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional.
• Written Test Plans and Test Cases on HP Quality Center Tool.
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
• Responsible for different Data mapping activities from Source systems to Teradata
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Designed and supported SQL 2000 Reporting services, Integration services and Analysis services.
• Creating test cases for ETL mappings and design documents for production support.
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Scheduling and automating jobs to be run in a batch process.
• Effectively communicate testing activities and findings in oral and written formats.
• Reported bugs and tracked defects using Test Director 6.5
• Extensively used Informatica power center for Extraction, Transformation and Loading process (ETL).
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.

Environment: UNIX Shell Scripting, Informatica Power Center 7.1 (Power Center Designer, workflow manager, workflow monitor), Business Objects XIR2, AutoSys, SSIS, Mercury Test Director 6.5, QTP 7.2, SQL *Loader, Oracle8i, SQL Server 2000, TOAD 7, Teradata V2R

Confidential, Metairie, LA

QA Tester

Responsibilities:

• Wrote SQL Statements to extract Data from Tables and to verify the output Data of the reports
• Performed back-end testing on the Oracle database by writing SQL queries.
• Collected, analyzed and reported testing metrics, executed SQL queries
• Built and maintained effective QA test lab environments
• 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
• Developed SQL queries in Toad and DB Artisan to achieve the data transformations
• Participated in various meetings and discussed Enhancement Request issues
• Conducted Regression testing after the bugs have been fixed by the development team
• Generated reports from Test Director.
• Responsible for source control, versioning, and configuration management of test scripts, test results, defects
• Developed Test Strategy, Test plan, Test cases, and Test scripts
• Created test plan and executed test cases using Rational Test Manger
• Conducted Functionality, Security, and End to End testing
• Reported bugs using Test Director and generated the defect reports for review
• Defect reporting and tracking was also done using Test Director.
• Maintained the test traceability matrix
• Performed Regression Testing on weekly builds.
• Monitored the workflow transformations in Informatica work flow monitor

Environment: Windows 2000 Server, SQL Server, Oracle 9i, Documentum 5i, Rational Test Manager, Rational Requisite Pro, Informatica 7.1, Cognos 7.3 Series, Test Director, Toad, Java, J2EE, JSP