SUMMARY:

• Around 8+ years of IT experience in Validating Data Warehouses, Business Intelligence reports, ETL applications in the Banking, Health care, Energy, Financial, Retail industries.
• Strong knowledge on HIPAA standards, ICD9/ICD10, EDI transactions & 4010/5010 versions, Medicare and Medicaid Services.
• Excellent ETL/BI testing experience with extensive backend testing and good understanding of Data Warehousing concepts & Architecture, Database concepts and Data Analysis skills.
• Expertise in Functional Testing, System Testing, Regression Testing, Backend Testing, ETL / Report Testing, UI Testing, ATDD and TDD.
• Experience in working on legacy policy Conversion process, which involves comparing the data, validations, rating, status between legacy and Guidewire PC.
• Expertise in end to end testing, involved in preparing test plans, test cases, test scripts, execution of test cases, regression scripts.
• Very good knowledge in validating the data warehouses built on Oracle, SQL Server, Teradata, DB2 and HADOOP.
• Experience in Front - end GUI testing of web based applications and client/server applications.
• Very good working knowledge of water fall and Agile Software Development Life Cycles.
• Involved in UAT and Post production support activities.
• Expertise in testing ETL applications built in Informatica, Ab Initio, DataStage, and SSIS.
• Very good knowledge on complete test cycle and defect life cycle.
• Validated reports developed in SSRS, Cognos, SAP Business objects, Micro Strategy, FALCON and IMPALA.
• Experienced in writing and executing SQL queries to verifying Source-to-Target Mapping.
• Used HP Quality Center for test management and defect management.
• Worked on validating reconcile and delta loads of ETL applications.
• Experience in validating functionality of the application on different browsers and operating systems.
• Experience in usage of defect tracking tools Quality Center, Clear Quest, Rally, JIRA, TFS for logging the defects, generation of reports, creating user stories and analyzes the reports.
• Involved in testing the claims conversion from Mainframe to Facets. Also involved in testing the EDI transactions 834, 837, 835. 270/271 & 276/277 conversion to Facets.
• Good knowledge and working experience in using UNIX commands and VI Editor.
• Experience in working as onsite offshore coordinator.
• Experience working on various source systems such as RDBMS, Flat Files, XML Files, Legacy Systems.
• Working experience in all phases of software/Test development life cycle that including requirement Analysis, application/test design, test execution, UAT, post production support.
• Experience in validating ETL, PL/SQL, UNIX batch jobs scheduled using Autosys, Cron tab.
• Expertise in working with Informatica power center, power exchange, IDQ.
• Very good experience in working fast paced agile environments.
• Excellent communication, technical skills and very good team player.

TECHNICAL SKILLS:

ETL Tools: Informatica (4 years), Data Stage (1 year), Ab Initio (1 year), SSIS (1 year)

Test Management Tools: HP Quality Center 11/10.0/12 (5 years), Rally (2 years), TFS (2 years)JIRA (2 years)

Databases: SQL Server 2008/2005, Oracle 11g, DB2, Teradata, HADOOP (Over all 8 years experience writing Sql script)

BI Reporting Tools: Cognos 10/8, MicroStrategy, Business Objects XI, SSRS, FALCON (6 month), IMPALA (6 month)

Software QA & Testing: SDLC, STLC, Test Plan Development, Development and

Execution of Test Cases: (Over all 6+ years of experience for end to end testing)

Defect Management Tools: ClearQuest (1 year), Quality Center (5 years)

DB Query Tools: Toad, Rapid SQL, Teradata SQL Assistant (Over all 8 years experience writing Sql script)

Version Control Tools: Rational Clear Case (1 year), VSS, Win CVS

Operating System: Windows 7/XP, UNIX (2 year), LINUX

Languages: SQL, PL/SQL, XML, HTML, C, Java, .NET, Visual Basic

Browsers: IE, Firefox, Chrome and Safari

Other Tools: Putty, WinSCP, Fiddler

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

Sr. ETL / DWH / BI Tester / Data Analyst III

Responsibilities:

• Involved in BIDM QA Projects with IHC (Intermediate holding company), LOB (Line of Business) for Risk of Commercial Loan for the Source system like All financial state, Bloomberg, LG, Wall Street etc. both in STG, ODS and EDW and as well as involved in project planning and implementation . Also involved in data health checks for CCAR (Comprehensive Capital Analysis and Review) which is one of the known project every bank needs to go through in USA as federal law. Leading the BAU (Business as Usual) items for LOB (Line of Business) projects with Prod Ops.
• Involved in creating the test plan and test cases based on Functional requirements, Business requirements, Mapping specifications, Entity relationship documents.
• Involved in executing test cases and also responsible for creating and maintaining the test results.
• Used Informatica workflow manager to execute the workflows and Informatica workflow monitor to monitor the status of the workflows.
• Validated the initial and incremental loads of EDW for CCAR and IHC Projects for CIB and IRS.
• Performed Backend testing, ETL testing, Reports testing, Black Box Testing based on the functional requirements.
• Worked closely with Guidewire Claim center team to provide policies required for claims testing.
• Created and maintained automated smoke test scripts for Guidewire Policy Center
• Worked with Business Analysts and Functional experts for analyzing and prioritizing test cases for Guidewire User stories cards.
• Participated in EDI X12 transactions including 834, 820 and 999s. Triage calls with vendors for the EDI X12 834 and 820 reconciliation and 999s issues.
• Performed User Acceptance Testing, Post production support.
• Written several complex SQL queries for ETL and Report testing.
• Reported defects on ClearQuest and followed till they are closed.
• Involved in validating various ETL, PL/SQL, Report batch jobs scheduled using autosys.
• Involved in validating SSIS and SSRS packages according to business requirement documents.
• Involved in validating SSAS cubes according to functional specifications.
• Tested the Front-end functionality for the entire application, navigational testing, and tested broken links.
• Involved in validating cross browser testing.
• Worked on Risk Reporting for Commercial and Consumer loans.
• Tested the XML files and checked whether data is parsed and loaded to staging tables
• Involved in testing reports and closely worked with Release team, technical operations team to complete the SIT phase.
• Designed test data using excel and GS data generator to test the application with positive and negative inputs.
• Validated Informatica workflows that are using transformations such as aggregators, filters, expressions, joiners, routers, sorters, look up.
• Used Toad to run SQL queries to check data is populating as expected from tables.
• Performed in data validation, data profiling, data scrubbing, and data frequency analysis.
• Validated Cubes, Adhoc Reports and Standard Reports built from Cognos.
• Uploaded test cases into Quality Center and executed them in test lab.

Environment: Oracle 11g, SQL, PL/SQL, EDIX12N 5010, EDIX12N 4010.Informatica 9.1 (Power Center, Power Exchange, IDQ), Quality Center 11, GUI, Cognos 10, SQL Server 2008, SSIS, SSRS, SSAS, Java, XML, Autosys, Rational Clear Case, Rational Clear Quest, TFS, UNIX, Putty, TOAD, IMPALA

Confidential, Charlotte, NC

Sr. Data Migration tester / ETL / Reports QA II

Responsibilities:

• Involved with FCT (Financial Crime Technology) team for projects like terrorist funds tracking, Suspicious accounts tracking and monitoring, accounts involving with unnecessary transactions between different banks.
• Prepared Test Plan and the Test Strategy based on business requirements and Functional Specs.
• Developed Test Cases for Operational Data Store, Enterprise Data ware house, Standard Reports, Adhoc Reports, OLAP, CUBES and UI Testing.
• Involved in reviewing Test plans, Test cases and Test scripts according to requirement specifications.
• Created traceability matrix to map Test cases against Requirements using Quality Center.
• Validated the slowly Changing Dimension type 1 and 2 based on the requirement.
• Validated ETL DW load statistics and Data mart Loads on an Ongoing Basis.
• Validated whether Source to Target ETL mappings are according to transformation rules and Business Rules.
• Validated Data Stage jobs by running them in data stage director.
• Validated Data Stage ETL jobs for the data quality and record count.
• Validated Adhoc Reports, Standard Reports for Data quality.
• Prepared complex SQL scripts for functional and data validation of ETL applications.
• Validated the record count between source and target for passive and active ETL transformations.
• Created test sets based on scenarios to validate EDW.
• Collected and distributed Test and Defect metrics based on priority.
• Quality Center is used for Test management.
• Validated Cubes, Adhoc Reports and Standard Reports built using Cognos.
• Involved in all phases of Agile Development Methodology.
• Participated in reviewing the project as a Lead and coordinating with onsite Clients, onsite Project Manager and local reporting managers.
• Involved in onshore offshore co-ordination of project as a Lead.
• Involved in reviewing and modifying test cases & scripts after initial iterations of testing phases to account for changes in project scope.

Environment: HADOOP v1.2s, Oracle 10g, DB2, SQL Server, SQL, PL/SQL, T-SQL, Data Stage 8, Quality Center 10, Remedy, Rapid SQL, Toad, UNIX, Putty, Teradata, Flat Files, .Net, C#, Rational Clear Case, Rational Clear Quest, XML, XML Spy, Business objects XI, JIRA, FALCON

Confidential, Denver, CO

Data Analyst II / ETL Tester

Responsibilities:

• Involved with validating data for the Pharmacy and Lab report for the Core and Non-Core members of the different entities at enterprise level for reporting purposes.
• Created Test Scenarios and test plans to Validate Data from source.
• Developed Test cases and Test scripts and Traceability matrix from Functional Requirements and Use cases.
• Involved in validating data moving from multiple source systems to ODS and EDW.
• Performed functional, integration, regression, UAT and end to end testing for the project.
• Validated the Fact and Dimension tables in Star Schema
• Extensively used Oracle/Teradata to write SQL Queries to validate the initial and incremental loads.
• Prepare and maintained test cases with changes in application interface and navigation flow.
• Validated SSIS packages for record count and the data moving from source to target.
• Performed batch testing of ETL jobs schedules in Autosys.
• BizTalk was used to develop the new interfaces to support EDI transactions in the New Data Format, projects which were involved in 837/ 835 transactions.
• Validated various Complex ETL graphs based on data mapping specifications to load data from desperate source flat files and RDBMS tables to target tables.
• Collected QA documents like test metrics, reports, and schedules.
• Involved in validating various business objects reports for layout and data presented.
• Validated several SSRS reports according to functional specifications.
• Reported and prioritized defects using Quality Center and presented reports in weekly team meetings.
• Involved in testing the Ab Initio ETL graphs based on data mapping requirements and Entity relationship diagrams.
• Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets.
• Experience testing Transaction processing system for End Users during UAT and ensuring that payments made and received were calculated based on all the Business rules.
• Validated various options like pushbutton, textboxes, radio and check boxes on the web pages are working fine.
• Validated Adhoc Reports, Standard Reports, drill up, drill down, dashboards and charts.
• Closely worked with Technical operations and Release management teams to resolve the production issues.
• Validated various database objects including stored procedures, functions, packages, triggers using data driven approach.

Environment: Ab Initio 2.13, Teradata V2R5, EDI, Quality Center, SQL, PL/SQL, TOAD, UAT, Autosys, UNIX, Business Objects, Oracle 9.0, Rally, SQL Server, SSIS, SSRS, C#, .net, Java, Clear Case

Confidential, Chicago, IL

Reports Tester/ ETL Tester

Responsibilities:

• Conducted JAD sessions with the Business to understand/ analyze/ document business needs.
• Ensured that requirements were of the highest quality which delivered the business value
• Analyzing the Business requirements and prepared the test plans and cases.
• Created Requirements Traceability Matrix (RTM) to track requirements during the QA Testing Phase using Quality Center.
• Testing experience in multiple cross platform environments and performed cross browser testing.
• Involved in validating Informatica workflows for different parameters.
• Validated various Informatica workflows according to business requirement documents.
• Performed regression testing for Change requests and production fixes.
• Performed different types of testing including data driven approaches to ensure that application is error free.
• Worked as a liaison between test team and the development team for defect fixes.
• Tested the reports build using micro strategy for data quality and lay out.
• Supported User Acceptance Testing by providing necessary information about the product when needed.
• Validated both the databases and the front end applications.
• Checked the data flow through the front end to backend, by using SQL queries to extract the data from the database.
• Performed database backend testing by field level validation in SQL.
• Completed the assigned tasks on time to meet the project deadlines.

Environment: Informatica, C#, PERL, UNIX, Putty, SQL, Micro Strategy, Microsoft Access, Excel, SQL Server, HTML, Oracle 8i, TOAD, SQL, Windows

Confidential, Seattle, WA

Software Tester

Responsibilities:

• Prepared and executed test cases based on the requirements and also responsible for creating and updating user-defined functions to meet business requirements.
• Used Test Director to report defects and followed defect life cycle.
• Involved in performing Black Box Testing based on the functional requirements and product specifications of the application including smoke, regression and functional testing using Test Director.
• Involved in creating analysis documents based on technical and setup documents send for review to BA and Team Lead.
• Validated the broken links and dashboards on the web pages.
• Prepared test data using MS Excel sheet to test the application with positive and negative inputs.
• Validated whether the data from front end applications is reaching the databases properly.
• Created of various test documents for testing process in Test Director.
• Collected, and maintained test evidence and test results.

Environment: Test Director, Java, TOAD, XML, Oracle 8i, SQL, Apache, Web Testing, MS Office, Windows, UNIX, Bugzilla, Win CVS