SUMMARY

• Over 7+ years of Software Quality Assurance (QA) experience testing Data Warehouse, Database (ETL & BI), Web, and Client - Server Systems and Applications for Banking, Insurance, Financial, Healthcare, and Retail Industries.
• Experience in Defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC).
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, UNIX, SQL, PL/SQL, OLAP, XML, SQL Server, Oracle, and ETL.
• Experienced in defining Testing methodologies, Designing Test Plans and Test Cases, Verifying and Validating Data for several ETL and BI applications and documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle.
• Proficient experience with SQL Server and MSBI tools like SSIS, SSAS, and SSRS.
• Adept at using both manual and automated testing tools to troubleshoot systems, integration, user acceptance, positive and negative, functionality, object, and regression
• Experienced in testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, and generated reports.
• Well versed with Manual and Automated Testing methodologies and principles.
• Expert in managing/leading ETL and Business Intelligence Testing.
• Configured test environment and create strategy for product development and certification. Assure test data, schedule automated/manual tests. Approve results documentation and tracking systems updates.
• Experienced and updated Test plans, Test Matrixes, Test Scenarios, and Test Cases for all company products
• Adept at using both manual and automated testing tools to troubleshoot systems, integration, user acceptance, positive and negative, functionality, object, and regression
• Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end, Performed end-to-end testing.
• Extensively used ETL methodology for 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.
• Designed data models using Erwin.
• 5+ years with SQL/PLSQL and expertise in writing SQL complex Queries for data testing.
• Work extensively with slowly changing Dimensions.
• Experienced SQL Data Analyst / Data Reporting Analyst with strong background in design, development, and support of online databases and information products as well as data analysis / reporting / processing.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading
• Proficient in Oracle 10g/9i/8i/7.3, PL/SQL Development Toad, PL/SQL Developer, SQL Navigator, Perl, UNIX, Korn Shell Scripting.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Automated and scheduled the Ab Initio & Informatica jobs using UNIX Shell Scripting.
• Application Data warehousing experience in Financial, Banking, Healthcare and Insurance.

TECHNICAL SKILLS

Operating Systems: Windows 2000/NT/XP/Vista, UNIX (Linux, Sun Solaris, IBM AIX)

Modeling Tools: ERWIN and POWER DESIGNER.ER STUDIO

Databases: Oracle 8.1/9i/10g,PL/SQL,SQL Server 2000/2005, Siebel, Sybase

ETL Tools: Informatica 8.6 (Power Center/ Power Mart (Designer, Workflow Manager, Workflow Monitor and Server Manager).and Ab Initio (GDE 1.15, Co>Op 2.15)

Reporting Tools: Cognos, Business Objects 5.0/6.5/XI R3/R2/R1

Query Tools: PL/SQL, Toad 7.4/8.3.6, SQL Query Analyzer, SQL Plus

Scripting Languages: XML, HTML, XHTML, Shell Scripting

Languages: C/C++, SQL, PL/SQL

Application Development: Visual Basic 6.0, Oracle9i/10g

Packages: MS-Office, Visual Studio. 2005

Modeling Tools: Star-Schema & Snowflake-FACT and Dimension Tables, Erwin 4.0, ER studio

Scheduler Tools: Autosys, Appworx, Tidal

Others: Visual Source Safe, File Zilla, MKS Tool kit, XML Spy 2008 (UNIX scripts)

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr.Data Warehouse Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Defined data requirements and elements used in XML transactions.
• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Optimized QTP scripts for Regression testing of the application with various data sources and data types.
• Tested different reports including detail, summary reports and on demand reports developed by SSRS Report Studio.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Tested reports using SSRS functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• Extensively used T-SQL to verify and validate the data loaded to the MS SQL Server 2008.
• Executed regression tests at each new build in QTP.
• Managed multiple projects from different Line of Businesses.
• Reviewed and approved database modifications .
• Used Quality Center in routing defects, defect resolution and assigning business cases to business users.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Coded UNIX awk and sed shell scripts for data migration for the Department of Credit Risk Warehouse and Capital Funding (CAPFUN) Database.
• Used Clear Quest to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Validating the Archive process to purge the data that meet the defined business rules.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Validated the ETL Scripts in the Target Database (Oracle) for creating the cube before migrating it to SQL Server.
• Worked with all Teradata load utilities
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Generated test scenarios, test cases and test data. Executed tests, created problem reports
• Conducted various management activities by analyzing and verifying test results, providing status reports
• Worked with business analysts, developers, and content department to resolve issues.
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.

Environment: Informatica 8.6 (Power Center/ Power Mart (Designer, Workflow Manager, Workflow Monitor and Server Manager). SQL, PL/SQL, SQL Server 2008,SSIS,SSRS,SSAS, HP Quick Test Pro, HP QC 9.0,Business Objects XIR2, UNIX, Shell Scripts, HP Quality Center, Teradata V2R6, SQL Assitant 6.0, MLOAD, FLOAD, TPUMP, Rational Robot, Oracle, SQL Plus, Access, SOAP, XML, XML Spy, SQL, TSO/ISPF

Confidential, Bridgewater, New Jersey

SQL Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system.
• Tested the created SSIS packages to transfer data from various sources like Oracle, Excel,
• Worked with SSIS system variable, passing variables between packages.
• Used T-SQL for Querying the SQL Server2000 database for data validation and data conditioning.
• Tested stored procedures & views in MS SQL Server 2000/2005
• Tested data warehouse ETL process using SSIS (Integration Service)
• Interacted with the Tester while transporting the requirements to Quality Center.
• Managed multiple projects and schedule the timelines for testing process for entire data warehousing projects.
• Responsible for identifying and defining the Key Performance Indicators in SSAS 2005.
• Used Erwin to reverse engineer the existing database design in SQL Server 2000
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
• Performed Data Driven Testing using QTP for testing the application for multiple data
• Worked with QTP for Regression Testing
• Executed the Test cases for Crystal Reports and Cognos.
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Oversaw the historical loads in UAT and PROD environments.
• Also worked on Integration of all the processes in UAT/PROD.
• 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.
• Generated test data (on UNIX box using Perl scripts) to support development.
• Experience in Data Inspection/analysis of tables as well as outbound files (data files in EBCIDIC & ASCII format).
• Verified layout of data files and control file entries as per business requirement.
• Based on the generated test data wrote test cases to demonstrate testing approach with detailed explanation of the cases for SORs.(System Of record)
• Did Unit Testing for all reports and packages.
• Tested the entire data reconciliation process for multiple source and target systems.
• Day-to-day Cognos administration activities like monitoring Scheduled jobs like Cube refresh, Impromptu scheduled reports, Backup and recovery maintenance.
• Involved in creating the test data for generating sample test reports before releasing to production.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Provided input into project plans for database projects providing timelines and resources required.
• Maintained the data integrity and security using integrity constraints and Data base triggers.
• Involved in the application tuning of database by identifying the suitable Indexes.
• Worked on UNIX Shell wrapper scripts
• Worked on Autosys which involved in creation of Autosys jobs, execution.
• Worked on issues with migration from development to testing.
• 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.
• Tested analytical reports using Analysis Studio

Environment: Informatica 8.1 (Power Center/ Power Mart (Designer, Workflow Manager, Workflow Monitor and Server Manager). MS SQL Server 2000/2005, SSIS, SSRS,SSAS, SQL, PL/SQL, TOAD 7.0, HP Quick Test Pro, HP QC 9.0,Test Cases, Test Scripts, Test Plan, Traceability Matrix, Test Director, IBM DB2, COBOL, Flat Files, Copy Books, MVS, TSO, JCL, IMS DB/DC, ISPF, SQL *Loader, Cognos 7.0 Series, Oracle8i, SQL Server 2000/2005, Erwin 3.5/4.0

Confidential, Atlanta, GA

Data Warehouse Tester

Responsibilities:

• Participated and Performed System Integration testing by developing Sub graphs and Integrated with Extraction and Load Graphs.
• Used TestDirector to Report bugs and Data Quality Issues on each check sum and field validation Tests completed.
• Communicated and Discussed with Developers about the status of each Data Quality Issues
• Ran SQL Statements manually to execute Record Counts on Each Table Loaded into System and Compared with Source Table.
• Used Quality Center for bug reporting.
• Tracked and reported the bugs with Quality center.
• Used Quick Test Pro to write the automated test scripts by using various actions and reusable actions
• Developed and involved in both Manual Testing and Automation Test scripts based on Use cases
• Prepared the Customer Templates to Upload the Data to the Application.
• Assist with the user testing of systems (User Acceptance testing) developing and maintaining quality procedures, and ensuring the appropriate document is in place.
• Developed SQL procedures to ensure compliance with standards and lack of redundancy, business rules and functionality requirement into ETL procedures.
• Designed and executed Functionality and User Acceptance test cases.
• Written various Autosys JIL Scripts to activate the UNIX scripts in production i.e. Jil scripts for the Box and Commands.
• Written UNIX AWK Scripts to manipulate test data and input files.
• Participated in bug triage meetings with developers to validate the severity of the bug and responsible for tracking of the bug life cycle using TestDirector.
• Designed test data using MS Excel sheet, created data driven test for testing the application with positive and negative inputs.
• Perform data driven testing and validated the test results.
• Created various User Defined Functions for script enhancements and to verify the business logic.
• Written Complicated SQL queries in DB2 for Update Dimension Tables, Export Data from Target tables etc.
• Written various UNIX Shell Scripts for Scheduling the job in production like check file script, load script, complete script, and DQ script.
• Wrote complex SQL scripts in DB2 for testing data quality and validation.
• Execute the Unix Shell Scripts to Know the Backend Batch Jobs Status

Environment: Ab Initio (Co>Op 2.13, GDE 1.13), Data Profiler, Oracle 9i, Autosys, IBM DB2, Syncsort, Erwin 4.0, Business Objects 5.x, IBM AIX-UNIX 5.0, Windows NT, Shell Scripting, SQL, PL/SQL, Test Plan, Test Cases, Test Scripts, COBOL, VSAM Files, TSO, MVS, ISPF, JCL, XML, XSLT, XSD, XML Spy

Confidential, Chicago, IL

Sr. Backend/ETL Tester

Responsibilities:

• Designed and created various Test Plans, Test Cases based on the Business requirements.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Involve with Design and Development team to implement the requirements.
• Performed execution of test cases manually to verify the expected results.
• Used TOAD Software for Querying Database.
• Designed and supported SQL 2000 Reporting services, Integration services and Analysis services
• Responsible for identifying and defining the Key Performance Indicators in SSAS 2005.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
• Tested mappings with the Design Documents and also performed testing for various sample data.
• Tested 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.
• Defect Reporting & Defect Tracking using Quality Center.
• Automated detailed test cases by using Quick Test Pro.
• Co-ordinate with team members for effective management for all project requirements and responsible for deliverables and receivables during all project phases.
• Participated in walkthrough and defect report meetings periodically.
• Involved in Unit, Functional, Regression and System testing.
• Worked on profiling the data for understanding the data and ETL mapping document.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Used SQL for Querying the DB2 database in UNIX environment
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• 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.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Documented and reported various bugs during Manual Testing.
• Retesting the resolved defects/issues after the developers fix the defects
• Performed Installation testing and Performance testing manually.

Environment: Informatica 7.1 (Power Center/ Power Mart (Designer, Workflow Manager, Workflow Monitor and Server Manager).Oracle 9i, Autosys, IBM DB2, Syncsort, Erwin 4.0, Business Objects 5.x, IBM AIX-UNIX 5.0, Windows NT, Shell Scripting, SQL, PL/SQL, Test Plan, Test Cases, Test Scripts, COBOL, VSAM Files, TSO, MVS, ISPF, JCL, XML, XSLT, XSD, XML Spy

Confidential

Software Engineer

Responsibilities:

• Verified layout of data files and control file entries as per business requirement.
• Validated the base table (Star schemas- Fact and Dimension) by writing complicated SQL statements and reports.
• Developed backend programming in Oracle using PL/SQL and SQL.
• Performed Requirements Verification Testing, Unit Testing, Functional Testing, Security Testing, Regression Testing, Positive, Negative testing, Post Production testing and End to end Testing of ETL code and reports.
• Tested daily, monthly and quarterly loads end to end.
• Experience in writing complicated SQL statements.
• Wrote extensive SQL and PL/SQL Scripts for creating stored procedures in Oracle.
• Created new Oracle Stored Procedures and modified the existing ones. Designed, Developed and tested PL/SQL Programs to prepare and clean Data for data migration and also to retrieve data from the database to compare against the input sets
• Did functional testing using Quick Test Pro.
• Designed forms and reports using Developer 2000 according to the client requirements. Triggers, procedures and functions are developed in this reports using PL/SQL.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Prepared Mapping documents and design documents for data conversion.
• Developed validation procedures and error reporting on the data in the intermediate tables.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Used various checkpoints in the Informatica designer to check the data being transformed.
• Wrote and ran UNIX Scripts for batch jobs.
• Involved in validating the ETL mappings from various systems(CRM,OLTP) to transaction history/reporting database
• Interacted with Solutions analysts, system staff, ETL developers and the data load staff.

Environment: Informatica 6.2/5.1, Toad, SQL, Test Director, Shell Scripting, QTP, Sun Solaris 5.8, PL/SQL, Windows NT 4.0, Erwin, Test Cases, Test Plan, Test Scripts