SUMMARY:

• As a Sr. QA ETL with over 7+ years of IT experience in the Analysis, design, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server Applications.
• SQAwithmanualandautomatedtesting tools infinancial, Investment banking, Retail Industry, health insurance, pharmaceutical and Supply Chain Management (DM and DP).
• Wrote extensive SQL and PL/SQL scripts to test the ETL flow, Data Reconciliation, Initialization, and Change Data Capture, Delta Processing, Incremental process.
• Have the ability to evaluate an ETL/BI specification, verify it with Systems experts and data architects, and assess if it complete and fully understand EDW and ETL Architecture.
• Experience in Business Intelligence in generating various reports using Cognos and Business Objects
• Strong knowledge in Data warehouse Testing using AbInitio
• Strong knowledge of test methodologies: Object Oriented test methodology, Service Oriented Architecture, Top to bottom and Bottom to top test methodology, QA Validations & QA Compliances to ensure the Quality Assurance Control.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects.
• Worked under testing methodologies likeAgile - SCRUMandWaterfall Model.
• Experience inSDLCand Agile methodologies such as SCRUM
• Sound Business knowledge in Retail, Banking and Insurance domains.
• Experience in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite consultants.
• Industrial experience includes Healthcare (HIPAA and EDI), EHR clinical Systems
• Proven Leadership experience with strong Analytical, Presentation and Communication skills
• Expert in writing PERL & UNIX Shell scripting for various needs including text processing, data archiving, data parsing and database connectivity.
• Experience in using Automation Tools: Quick Test Professional, Win Runner and Quality Center in Client/Server.
• ICD 9-ICD 10 Conversion knowledge -Worked in the analysis of the ICD 9 - 10 codes
• Strong Testing Experience in HIPAA X-12 EDI (Insurance/Health Series (INS) such as 270/271, 274, 276/277, 278, 820, 834, 835, 837, and Version 5010 of this transactions.
• Strong knowledge of current industry standards, such as HIPAA, CAQH, 21 CFR part 11, 21 CFR part 820, cGMP, CAPA.
• Worked on Waterfall, RUP and Agile methodologies.
• Experience in UNIX shell scripting and configuring cron-jobs for ETL Loads
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
• Experience in User Acceptance Testing, Performance Testing, GUI Testing, System & Functional Testing, Integration Testing, Regression Testing, Data Driven & Keyword driven Testing
• Experience in IBM Rational Suite for maintaining test requirements, test flows using Requisite Pro, automate tests using Rational Robot and Rational Functional Tester, Rational Manager, Defect tracking using Rational Clear Quest, version control using Rational Clear Case.
• Efficiently performed Defect Tracking using various tools like Quality Center, Test Director, Rational Clear Quest, Remedy Tool, PVCS Tracker, and Bugzilla.
• Proficient in writing SQL queries to perform data driven tests and involved in front-end and back-end testing. Strong knowledge of RDBMS concepts. Developed SQL queries in Oracle databases to conduct DB testing. Having good knowledge on Oracle Data Integrator.
• Worked on Data files & label parameter of data file, strong in writing UNIX Korn shell scripting.

TECHNICAL SKILLS:

ETL: Informatica 6.1, 7.1, 8.1, 8.6.1, (Power Center/ Power Mart (Designer, Workflow Manager, Workflow Monitor and Server Manager), AbInitio 1.13,1.14,1.15.6.

Reporting Tools: SAS, Cognos8.0, Business Objects 6.0, MS Access Reports, Pivot Tables

Databases: Oracle 10g/9i/8i/8.0/, SQL Server 2000/2005, PL/SQL, DB2, Teradata V2R6, SQL Assitatnt 6.0, MS Access 7.0/97/2000, MS Excel 2007

Database Modeling: Star Schema, Snowflake schema, Fact and Dimensions Tables, Physical and Logical Data Modeling, Dimensional Data Modeling, Erwin 4.5/4.0/3.5/3.0 Programming Unix Shell Scripting, C, SQL, PL/SQL, HTML, XML

Database Tools: SQL *Loader, SQL*Plus, TOAD, SQL Assistant 6.0

Testing Tools: HP Quality Center 9.2, Test Director, QTP 8.0

Environment: Windows NT/95/98/2000/XP, UNIX, MS DOS, RED HAT LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

Sr QA Tester

Responsibilities:

• As a Tester, was involved in weekly status, following up the development as well as the business /Testing teams, re-scoping project planning
• Managed multiple projects for EDWH Group for all testing activities related to both ETL and BI
• Supervising the QA team in accomplishing their tasks as per the deadlines.
• Conducted Weekly Onsite-Offshore Status Meetings.
• Design and execute the test cases on the application as per company standards
• Preventing occurrences of multiple runs by flagging processed dates
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags.
• Involved in automation of test cases using QTP.
• Did functional testing using QTP
• Responsible for working with the team to review and modify process flows to increase productivity
• And effectively utilize FACETS features not provided by the legacy systems
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations and Ensured that the mappings are correct
• Conducted data validation testing and extracted certain column of data from a number to files using PERL.
• Troubleshoot any problems found withinFACETSand when testing the SQL data database whilevalidating against the business rules.
• Responsible for working with the team to review and modify process flows to increase productivity and effectively utilize FACETS features not provided by the legacy systems
• Functioned as Project Lead to implement an effective and efficient test regression test bed. Test Automation using QTP
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Configured Quick Test Professional with Quality center.
• Worked with Quality center to document test results and validate test scripts.
• Written UNIX Shell scripts for cleanup, error logging, text parsing, job scheduling and job sequencing.
• Perform Backend database testing to validate the data using complex SQL queries, PL/SQL, Oracle and AbInitio.
• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Debugging the SQL-Statements and stored procedures
• Developed regression test scripts for the application
• Involved in metrics gathering, analysis and reporting to concerned team
• Tested the Oracle PL/SQL testing programs
• Conducted review sessions on test case and regression test scripts in quality center
• Developed Test Plan in IEEE format and implemented
• Use AbInitio graphs to test positive & negative scenarios based on the test cases
• Involved in testing procedures, functions, packages and triggers as a part of backend testing using Toad.
• Identified and recommended training required to the testing effort
• Conducted Training & Knowledge Transfer Sessions on new applications to QA Analysts

Environment: Informatica 6.1, 7.1, 8.1, 8.6.1 (Power Center/ Power Mart, Teradata V2R6, SQL Assistant 6.0, FACETS (4.41), AbInitio GDE1.14, BI, Windows XP, HP Quality Center 9.2, Oracle 10G, SQL Server 2005/2008, SQL, PL/SQL,, IBM Rational Tools, PERL, Shell Scripting, TOAD, UNIX, VB Script, VSAM Files, COBOL II, JCL, File-Aid

Confidential, Philadelphia, PA

Sr ETL QA Tester

Responsibilities:

• Analyzed the Functional requirements using Scenarios & DDD(Detailed Design Document)
• Ran SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, Nulls/Defaults/Trim spaces rules as per the design specifications.
• Implemented Iterative and IncrementalAgile - ScrumMethodology for rapidly changing or highly emergent requirements and following parallel development and testing.
• Worked as a lead to resolve issues during critical phase of projects and guide junior testers and even played the role of a mentor whenever required.
• Used UNIX to verify the session log files for error and warning details.
• Performed Analysis of ICD 9 Procedure and Diagnosis Codes in accordance with ICD 10 CM and ICD 10 PCS Conversion Compliances
• Executed the Test Scripts in TOAD and documented the results in RTM.
• Worked with leadership team to analyze current SDLC process and recommended process improvements.
• Validation of various transactions and documents base on EDI files 837 I, 837 P, 835,834,820/270,271 and 278.
• Tested several complex reports generated by Micro Strategy including Dashboards, Summary Reports, Master Detailed,Drill down.
• Involved in the claims adjudication process of Facets
• Worked on facets an extension mapping attributes.
• Worked in keyword view as well as expert view of Quick Test Pro.
• Configured Quick Test Pro with Quality Centre and Maintained the project information in Quality Centre.
• Submitted Status and Test Evaluation Reports to Test Lead on daily basis and Constantly updated test deliverables.
• Taken a lead in involving End-to-End testing.
• Performed SOA / Web Service testing using soapUI.
• Involved in processing claims in FACETS and validating the full cycle process to make sure the checks are generated and 835’s are generated.
• Gap Analysis between the HIPAA Transactions (837P and 837I) and Facets system
• Involved in the configuration of Facets system for the HIPAA changes
• Involved in the reporting analysis and configuration in Facets System
• Compared query result sets from different database systems using UNIX diff command.
• Verified correctness of data after the transformation rules were applied on source data.
• Coordinated execution of User Acceptance Testing, regression and integration testing with multiple departments.
• Interacted with the Tester while transporting the requirements to Mercury Quality Center.
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Wrote complex SQL s to validate target data based on the business requirements.
• Used PL/SQL programs for performance testing.
• Developed complex queries by joining different Dimensional tables to Fact tables and retrieved the data From EDM and validated the data against EDW.
• Implemented data verification procedures for ETL processes in load testing.
• Used SQL and PL/SQL scripts to perform backend database testing.
• Involved in coordinating the White box and Black box testing for the data warehouse by checking ETL procedures/mappings
• Generated the detailed reports of the Bugs, go no go reports and comparison charts.
• Involved in Manual and Automated testing using QTP and Quality Center.
• Defects tracking, review, analyze and compare results using Quality Center.
• Participating in the MR/CR review meetings to resolve the issues.
• Defined the Scope for System and Integration Testing.
• Worked extensively with Database Procedures, Functions, Cursors and Joins to validate data.
• Wrote & executed Test Cases for each functionality based on interfaces that interacting with workflow application
• Preparation of various test documents for ETL process in Quality Center.
• Involved in Test Scheduling and milestones with the dependencies
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Informatica 6.1, 7.1, 8.1, 8.6.1 (Power Center/ Power Mart) Business Objects XIR2/6.5.1, MicroStrategy, FACETS (4.41), Windows XP, SQL, PL/SQL, PERL, Shell Scripting, QTP 9.2, SQL Server 2005, Quality Center 9.0, Load Runner7.0, Oracle 10g, Java, Unix AIX 5.2,VB Script, XML, XSLT, XSD, XML Spy 2008

Confidential, Wilmington, DE

ETL/BI Tester

Responsibilities:

• Analyzing new Business requirements for each & every release and worked with analysts and business team for any gaps found during the test analysis
• Tested the data coming through various lines of business of Confidential Bank such as Capital Funding, Venture Capital, Trust Accounting System, Bank Owned Life Insurance etc
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Used Agile testing methodology for achieving deadlines in UAT testing.
• Incremental development/testing of Enterprise Data Warehouse.
• Used Quality Center for bug reporting.
• Day-to-day Cognos administration activities like monitoring Scheduled jobs like Cube refresh, Impromptu scheduled reports, Backup and recovery maintenance
• Utlized Cognos 7.3 Series for building the Reports.
• Worked as a consultant in delivering quality data centric solutions for various business domains.
• Build a customer data centric data warehouse to analyze transactions across finance, marketing, risk collections and consumer relations for the credit card division. Clean customer data warehouse successfuly implemented on Oracle target, the data warehouse is growing in its analytical richness.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Tracked and reported the bugs with Quality center.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Experience in ETL Data Warehousing, database testing using DataStage for Workflow process.
• Write SQL queries to validate that actual test results match with expected results
• Check the naming standards, data integrity and referential integrity.
• Used QTP for Checkpoints, Regular Expression and Accessed Data Tables for multiple applications.
• Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
• Responsible for monitoring data for porting to current versions.
• Checked the reports for any naming inconsistencies and to improve user readability.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology ie backward navigation from target to source.
• Used Clear Quest for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs.
• Supporting presales activity for Data centric warehouse testing projects.
• Preparing Defect Reports and Test Summary Report documents.
• Checking the status of ETL jobs in UNIX.
• Interacted with Business Analyst, Database Administrators, development team and End Users.
• Preparing Test plan, Test scenarios and writing & execution of Test cases
• Identified Test Conditions in according to the BRD’s and Change Requests
• Written and Executed the UNIX test cases on EDI format and verify Translation response
• Performed Reliability testing for testing the UNIX servers
• Responsible for execution of Batch jobs and population test data for other teams
• Executed Complex SQL queries within UNIX shell scripts in the UNIX environment.
• Responsible for FTP jobs to transfer data between UNIX test servers.
• Responsible for Production Monitoring during peak hours
• Regression Testing for Each and Every Release Using Win Runner
• Used Test Director & Rational DDTS as Test Management tool.
• Responsible for doing System Testing, Functional Testing, Integration Testing, Load Testing and Smoke Testing.
• Extensively worked on Backend using SQL Queries to validate the data in the database.
• Testing the XML’s for the all the validations like request and response.
• Used Rational Clear Case for version controlling

Environment: Informatica 6.1, 7.1, PERL, Cognos 7.3 Series, MicroStrategy Unix Shell Scripting, SAS 9.1,SAS/SQL, PL/SQL, XML, XSLT, XSD, Teradata V2R5, IBM DB2, Flat Files, VSAM, COBOL II, MVS, JCL, Copy Books, Rational Clear Quest, Clear Case, Autosys

Confidential

QA Tester

Responsibilities:

• Worked extensively with Database Procedures, Functions, Cursors and Joins to validate data.
• Wrote & executed Test Cases for each functionality based on interfaces that interacting with workflow application
• Developed ETL Test Plan and Test Strategies for the entire Line of businesses.
• Extensively used SQL queries for Database testing and Validation.
• Involved in extensive backend testing.
• Tested PL/SQL statements to verify the output and compared against ETL Output.
• Designed and developed Test Plans and Test Cases and executed them.
• Developed Test Cases for testing the mapping designs before going to the production phase.
• Written several UNIX Shell Scripts for cleanup, logging, file manipulation and transferring the files.
• Involved in creating Test Matrix for various work streams for traceability purposes.
• Involved in writing Test cases for all the links and various data files based on ETL Mapping document.
• Performed Functional and Regression tests of enhancements using Mercury and Rational Tools.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Moving Data into Target using Sessions and Batches
• Designer for mappings and coding it using reusable mapplets using from various sources involving flat files and DB2 tables.
• Scheduling the session’s tasks comprising of different mappings in order to load data into DB2 database Tables.
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Tested slides for data flow and process flows using PowerPoint and Microsoft Visio
• Tested and maintained the universe and reports
• Used all Teradata utilities including Fast Load, Multi Load, Fast Export, SQL Assistant, BTEQ & TPUMP
• Using Import Wizard deploying the reports from Dev system to QA box.
• Used Sets, Metrics, Productive Analysis and Enterprise Performance Management (Scorecard and Dashboard).
• Involved in Regression and Automated testing of the application using Mercury QTP
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.
• Major involvement in tuning the mappings, to perform maximum efficiency and performance complete knowledge of session properties in server manager.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.

Environment: Informatica Power Center 6.1/6.2, Informatica Power Connect, MicroStrategy MS Visio 2002, Oracle 8i/9i, MS SQL Server7/2000, IBM DB2/400, IBM AS/400, Teradata V2R5, MS Excel 97, Flat files, PL/SQL, SQL, Toad 7.0, Windows 2000, MQ Series, Transact-SQL, SQL*Loader, Mercury Quality center8.0,Mercury QTP, Windows 2000, HP-UX 11.x Unix (ksh) Shell and Cognos (Impromptu, Power Play) 7.1