Summary

• Over 7 years of strong IT experience in Testing of various Datawarehousebuilt using Oracle, SQL Server, Teradata, Shell Scripting, Unix and Informatica.
• Proven track in interacting with Dev team and data analysts and testing team members to coordinate job tasks. Expert in ETL, Data Warehousing, front-end and BI testing.
• Experienced in validating the extracted, analyzed data and reports that present data in graphical format for BI.Proficient in Oracle 11
• Teradata, SQL Server, scripting on UNIX and Windows platforms.
• Well capable in preparing Financial Reports, On-Demand Reports using Oracle SQL, and Teradata.
• Developed Reports using the Teradata / oracle using analytical techniques like Rank, Row number and lead lag functions.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Ab Initio and Informatica PowerCenter
• Expertise in Data validation andfront end testing.
• Clear understanding of snowflake and star schema and datawarehousing concepts.
• Experience in testing various types SCDs.
• Worked with Quality Assurance team to evaluate test results for fulfillment of all data requirements.
• Extensively used HP QC to upload test cases, to prepare the RTM and to log defects.
• Took part in defect summary and status calls.
• Proficient in preparing status reports and summary using word, Microsoft Excel and PowerPoint
• Performed source data analysis and profiling to identify the source systems for the EDW and performed distribution analysis for the data on various systems to perform route cause analysis during bug reporting.
• Proactive team player with capability of handling responsibilities independently as well as in a team environment and displayed strong analytical, problem-solving skills and document function/process flows.

Technical Skills

Confidential

Sr.QA Analyst

Responsibilities:

• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs.
• Tested Post session emails to provide information about the mappings used sessions and batches completion statuses.
• Software Testing including regression, System and System Integration Testing, Test case/data preparation, execution and verification of the test results using Mercury tool.
• Confidence testing the application in QA / production by performing smoke and sanity tests.
• Validating the data using the master testing strategy to build the test data.
• Understand existing business processes and data model.
• Analyzing the application system and their source databases
• Tested the ETL Informatica mappings and other ETL Processes Data Warehouse Testing .
• Creating the test plan and test case as per the SSD/Business cases.
• Interaction with business / data analyst to understand the mapping document and requirement specification
• Analysis of Business requirements Design Specification Document to determine the functionality of the ETL Processes.
• Prepared Test Cases for the mappings developed through the ETL Informatica tool and executed those Test Cases.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Extensively tested several Cognos reports for data quality, fonts, headers cosmetic
• Written several complex SQL queries for validating Cognos Reports.
• Participated in weekly meetings and discussed modification request with team.
• Performing GAP and Impact Analysis for in-house changes and fixed the test cases and plan.
• Executed regression test suites in QA region using UFT.

Environment: Informatica PowerCenter 9.x, UFT, Salesforce.com, SQL Server 2008 R2, UNIX Shell Scripts, Control-M, Cognos 8.0 Series,SQL,PL/SQL,Sybase, HP Quality Center, SQL Server 2005/2000,

Confidential

QA Analyst

Responsibilities:

• Written test cases for both positive and negative scenarios for incremental and historical loads of the load process.
• Written unix scripts to validate the incoming flat file feeds to ensure the data correctness of the feeds.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Created test plan and test data based on the strategy for end-to-end project requirement for both positive and negative scenarios.
• 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.
• Performed numerous data pulling requests using SQL for analysis.
• Tested the data and layout of reports as per BRD.
• 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.
• Used Joins like Inner Join, Outer join while creating tables from multiple tables.
• Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.
• Tested reports developed by Business Objects Universes for both Adhoc Canned Reporting users of Business Objects XI R3
• Responsible for testing Business Reports developed by Business Objects XIR2
• Experienced in using OLAP functions like sum, count, lead, lag, etc.
• Proficient in working on Set, Multi-set, Derived, Volatile Temporary tables.
• Proficient working in loading data into staging tables via views.
• Utilized ODBC for connectivity to Teradata MS Excel for testing the automated reports and graphical representation of data to the Business and Operational Analysts.
• Expertise in generating graphs using MS Excel Pivot tables.

Environment: UNIX scripting, Oracle SQL Developer, Teradata 13, Windows XP, SAS data sets, HP ALM, SQL, PL/SQL, Shell Scripting ,Oracle 10g, XML Files, Business Objects XIR3,IBM, DB2. Cognos 8.0 Series

Confidential

QA Tester

Responsibilities:

• Written the test cases based on the changes to the mapping document / service request.
• Validate the migrated data from different sources text based files, Excel spread sheets, and Access to SQL Server databases using SQL Server Integration Services SSIS .
• Involved with ETL test data creation for all the ETL mapping rules.
• Validated data from Flat and migrated into SQL Server 2008r2 using SSIS .
• Tested the EDI environment, including file system, file definitions, alert and error notifications
• Tested complex Stored Procedures, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Performed ETL testing based on ETL mapping document for data movement from source to target.
• Tested the migration using Bulk Insert and dynamically created queries.
• Tested complex business requirement in backend using efficient stored procedures and flexible functions, and using various scenario based test data front end.
• Written several complex SQL queries to validate the Data Transformation Rules for ETL testing.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Apply coding and analytical skills in all phases of the system life cycle
• Tested old SSIS package to support ICD10 and ICD9 healthcare version.

Environment:Microsoft SQL Server 2008/2008 R2, SSIS, Microsoft Visual studio 2008 and 2010,Team foundation server-2008, VBA, SQL, PL/SQL, Informatica PowerCenter 8.6.1, Oracle 10g/9i, Cognos, UNIX AIX , Linux,.

Confidential

QA Tester

Responsibilities:

• Created UNIX shell scripts for Informatica ETL tool to automate sessions.
• Did extensive work with ETL testing including Data Completeness, Data Transformation Data Quality for various data feeds coming from source.
• Developed the ETL process to automate the testing process and also to load the test data into the testing tables.
• Testing the ETL data movement from Oracle Data mart to Teradata on an Incremental and full load basis.
• Design and development of ETL processes using Data Stage ETL tool for dimension and fact file creation.
• Verified GWM Channel Hub profile Client Channel Segment Code and re-calculated Master Profile Client Channel Segment Rollup Code
• Verified EPI Alignment code reference table, Client Channel Segment Code reference table and Client Channel Segment Rollup Code reference table
• Verified Client Segment Roll UP Codes for Combine.
• Created various business scenarios for functional and UAT testing.
• Created test data based on the test cases and executed the test cases.
• Executed the SQL queries to validate the database
• Worked with Business team to discuss on the existing Business process.
• Interacted with developers to resolve the bugs.
• Logged the defects in Quality Center.

Environment: Oracle 10g, Mainframes, .Net, C , ASP.Net, VB.Net, XML, JavaScript, Clear Quest, Windows XP, SQL, PL/SQL, SQL, UNIX, Informatica 6.1, Microsoft office 97, Windows 2000, Cognos 10.2 Series