SUMMARY

• 7+ years of experience in Quality Assurance testing in the domains of Finance and Mortgage.
• Extensive experience in Software Quality AssuranceTesting of ETL Informatica, Web Services, Data Driven Applications, Data Warehousing
• Extensive knowledge in data modeling and good understanding with logical and physical relation between fact and dimension tables.
• Strong Experience in testing Business Intelligence reports and ETL loads
• Extensive experience working in star and snowflake schema models with and type I, II, III Slowly changing dimensions.
• Experience in different Databases like Oracle and Teradata. Solid experience in back - end testing using SQL queries
• Written numerous complex SQL queries to carry out the testing strategies like checking for data completeness, quality, and integrity.
• Involved in all phases of SDLC such as Waterfall, Agile with timely Delivery against aggressive deadlines.
• Tested PLSQL procedures to validate the data against the requirements.
• Extensive experience working and testing in different ETL technologies like Informatica, Datastage.
• Verified and validated numerous transformations as per the requirements to go ahead with the testing phase
• Strong knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)
• Working with various testing tools like HP ALM for requirements tracking, defect tracking, results and status reporting.
• Written and validated a number of Test Plans, Test cases, RTM’s and Test Scripts.
• Extensively involved in Creating Status reports and closely worked with Project Manager
• Performed RCA for a lot of defects and was part of defect review calls with development and Business Analyst teams.
• Experience in working with offshore and on-site teams
• Excellent written and presentations skills with excellent communication.

TECHNICAL SKILLS

Testing Tools: Quality Center 10.0/9.0, JIRA, QuickTest Pro 9.5/9.2/8.0, Zephyr, QC, HP-ALM 11

Operating Systems: Windows 7/XP/NT, UNIX, AS-400, IBM Mainframe

Databases: Oracle 11g/10g/9i, DB2 9.7, MS SQL Server 2005, Progress DB 4GL, Teradata

Database Tools: Teradata SQL Assistant 14.0, TOAD 10.6, SQL Developer, SQL Server Management Studio

Web Development: HTML, XML, VBScript, Java Script

MS Suite: MS Office 2007, MS Visio, MS Project

Reporting Tools: OBIEE, EssBase Cubes, OFSAA, Business Objects

ETL Tools: Informatica 8.x, DataStage 7.5/8.1

B2B Tools: Sterling Integrator, JDA

Middleware: Sonic Messenger

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr.ETL Tester/BI Tester

Responsibilities:

• Performed end to end testing of migration to new Wholesale Profitability platform
• Validated the Profitability data and dimensional hierarchy data coming from different System of Records (Source systems) into landing,staging areas and Results area.
• Performed ETL validations for dimensional hierarchy tables for slowly changing Dimension Type 1 and Type 2.
• Validated the data movement between Sources through Staging, Staging through Dimensional and Fact tables for incremental loads and full loads using Data lineage documents and FSDs
• Written complex SQL queries using joins and sub queries and different functions to carry out ETL validations for count checks, duplicate records, transformation logic for new Wholesale Profitability platform built on Oracle Financials and Analytical Services (OFSAA), Informatica, EssBase and OBIEE
• Validated OBIEE Dashboards for different dimensional hierarchies like Organization hierarchies, Product hierarchies, Customer hierarchies and for different time periods
• Validated Wholesale Profitability OBIEE Summary and Detailed Reports by passing different prompt values against the database, using SQL queries.
• Good experience in validating OBIEE Report layout against mock ups provided by Business Users.
• Validated the materialized views created for downstream application purposes
• Ensured data integrity and verified all data modifications and calculations
• Identified Test Scenarios and written Test Cases for ETL to compare Source and Target database systems.
• Prepared Test Data for different scenarios to perform ETL and Report validations for different metrics
• Used HP ALM to manage all Testing activities like Test Case Design, Execution and Defect Tracking.
• Analyzed Business Requirements for different Releases and written numerous Test Cases to carry out Smoke Testing, Regression Testing and System Integration Testing
• Actively involved in the Daily Defect Status calls and Daily Status meetings that are ongoing between BA,QA and Dev teams
• Co-ordinating with offshore teams for timely delivery of Testing deliverables.

Environment: ETL Informatica, Oracle 11g, Oracle Financials (OFSAA), HP-ALM, OBIEE, ESSBASE Cubes,TOAD Data Analyst, Teradata 14.0, Autosys

Confidential, King of Prussia, PA

Backend QA Tester

Responsibilities:

• Extensive experience testing Sterling Order Management System and Sterling integrator, JDA, drop-ship, warehouse systems and EBay market places.
• Created Test Cases based on the Business requirements and using source to target mapping defined for each requirement
• Involved in extensive DATA validation using SQL queries and End to End testing of ETL process.
• Written complex SQL queries using Functions and Joins to compare data movement between different systems.
• Validated inbound and outbound feeds for different partners and tested incremental loads.
• Developed separate test cases for ETL Informatica process for verifying Inbound feeds from various source systems for checking data completeness, quality and transformation logic.
• Verified data loads between external files to Data Staging tables, Data staging tables to Dimension tables, fact tables.
• Extensively involved in smoke testing, user acceptance testing, functional testing, integration testing, database testing and regression testing
• Developed a wide-range of SQL queries to assure data validation and avoid duplication in tables of the target database.
• Extensively used SQL queries/Unix commands for data verification and backend testing.
• Documented and published test results, troubleshooting and escalate issues and prepared QA manifest
• Involved in the error checking and testing of the ETL procedures and programs in the Informatica session log.
• Performed data analysis and data profiling using SQL on various sources systems.
• Executed UNIX shell scripts for data reconciliation, cleanup needs and job scheduling.
• Validated XML messages and worked with Sonic messaging manager and sterling integrator
• Used Zephyr for test case creation and execution and JIRA for defect management process.
• Worked with offshore - on-site teams
• Supported UAT testing for store launches
• Worked with business users and developers directly

Environment: DataStage, Oracle 11g, QTP, Sonic Message Manager, Sterling Order Management Systems, AS 400, UNIX, JIRA, Zephyr, FileZilla.

Confidential, Jersey City, NJ

ETL/QA Tester

Responsibilities:

• Involved in E2E testing of application from Confidential Originations through loan closure and servicing and data warehouse.
• Involved in testing of web based front end Confidential application systems and Mainframe based Loan processing systems
• Involved in extensive DATA validation using SQL queries aginst DB2 Database and back-end testing
• Involved in testing of various interfaces involving DB2 and Oracle databases, XMLs, Data Files
• Validation of data integrity, data quality across multiple related systems and their processes
• Validated straight pass through fields, derived fields and enumerated fields across all interfaces
• Prepared test data for various input scenarios, by querying production data bases.
• Reviewed, analyzed Requirements and data mapping documents for developing test cases
• Worked with mocking the production data to test the dry runs in QA and UAT sessions
• Participated in all meetings with project team members on Overview and Architecture
• Created test plans and written test cases for end to end testing and back wash testing.
• Written several complex SQL queries for validating different interfaces and source to target data bases using data mapping documents.
• Extensively used Quality center to document and track defects
• Participated in defect review calls periodically.

Environment: Oracle 10g/11g, Data Stage 8, SQL Server 2008, SQL Developer, progress DB 4GL, IBM Mainframes, Squirrel, FileZilla, UNIX, XML, Windows XP, Quality Center 10.0, Notepad ++, Ultra Edit

Confidential, RI

ETL/QA SQL Tester

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
• Involved in extensive DATA validation using SQL queries and back-end testing
• Developed and Performed execution of Test Scripts manually to verify the expected results
• Conducted Black Box - Functional, Regression and Data Driven and Integration Testing (positive and negative scenarios).
• Defects tracking, review, analyze and compare results using Quality Center.
• Identifying field and data defects with required information in ETL process in various mappings and one to one mapping.
• Conducted test case review and revision of surrogate key generation in Informatica to uniquely identify master data elements for newly inserted data.
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Used Quality Center to log defects and monitored the defects for successful resolution.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Queried databases using SQL queries in TOAD to validate the data loaded into target tables.
• Tested different summary reports, ad-hoc reports and on demand reports using business objects info view.
• Extensively tested several BO reports for data quality, fonts, headers and cosmetic errors.
• Tested the list, cross tab, repeater and Drill-through reports in different formats like PDF, XML, and HTML.

Environment: Windows XP, Informatica 8.1, QTP 9.2, Teradata, SQL Server 2005, Quality Center 9.0, Oracle 10g, Java, Unix AIX 5.2,VB Script, Business Objects