SUMMARY

• 7+ years of extensive experience in Quality Assurance testing of data warehousing and Business Intelligence processes, Web Based and Client/Server applications.
• Hands on experience on ETL tools in ETL process development, testing and in maintaining ETL codes.
• Expertise in Business Requirement gathering through JAD sessions, interviews, workshops and walkthroughs, and main concentration in Business Process Flow and Business modeling tools as a Business analyst.
• Excellent knowledge of HIPAA standards, EDI (Electronic data interchange), transaction syntax like ANSI X12, Implementation and Knowledge of HIPAA code sets, ICD - 9, ICD-10 coding and HL7.
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
• Well versed with various types Software Development methodologies- Water fall, Agile, RUP, Iterative and extreme Programming.
• Experience in Software QA and Testing Methodologies, verification and validations in all phases of the SDLC.
• Expert in review and analyze requirements, use cases, technical specifications and database designs.
• Expert in Develop Test Plans, Test Designs, Specifications, Test Cases and Scenarios.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Experienced in documenting defects, generate defect and test progress graphs with overall test summary.
• Knowledge of and ability to apply a wide range of software test engineering concepts: testing principles (Testing Methodology) and concepts, building a test environment, tracking defects n Quality Center.
• Strong technical Knowledge of UNIX Utilities, shell Script to automate process.
• Ability to manage multiple project in testing by managing team, automate process and delivered all task.
• Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
• Extensively involved in SIT and UAT by supporting Testing and implement QA Process.
• Extensively Used Quality Center, PVCS Tracker, Rational Clear Quest for Test Case and defect tracking management.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Expert in working with various cross geo teams across the world with various time zones.
• Excellent interpersonal and communication skills with good learning curve in short span of time.
• Ability to work in a Team or individually and very flexible to work in complex environment with tight schedules.

TECHNICAL SKILLS

Operating Systems: Windows XP/ 2000 Professional /98/NT, Unix, MVS

Languages: PL/SQL, Shell Scripting, PERL, Java, SQL

Database: ORACLE, SQL Server, Teradata, Sybase, DB2 and MS Access, OLTP, OLAP

Application Servers: WebLogic5.1/4.5, Web Sphere

Testing Tools: PVCS, Rational Clear Quest, Test Director, Quality Center

Test Automation: Quick Test Professional, Load Runner

ETL Tools: Informatica, Data Stage, SSIS, Ab Initio

BI Tools: Cognos Series 8.0, Crystal Reports

Hardware: IBM ES/9000 and IBM compatible PC's

PROFESSIONAL EXPERIENCE

Sr. ETL-Ab Initio QA SQL Tester

Confidential, Charlotte, NC

Responsibilities:

• Reviewed and analyzed Business Requirements and clarified with Business Analyst.
• Written several UNIX scripts for invoking data reconciliation.
• Reviewed High Level and Low level Design docs and clarified design solutions with Developers.
• Testing of complicated graphs with various Ab Initio components such as Join, Rollup, Filter by Expression, Round Robin, Merge, Dedup sorted, Scan and Validate Business requirements.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing.
• Worked with business team to test the reports developed in Cognos.
• Tested a number of complex ETL Ab Initio graphs, for initial and daily data loads.
• Extensively executed SQL queries in order to view successful transactions of data.
• TOAD is used to perform manual test in regular basis.
• Worked on EDI (Electronic data interchange) transactions: 270, 271, 834, 820, 835, and 837 to identify key data set elements for designated record set.
• Written several complex SQL queries for validating Cognos Reports.
• Involved in FACETS Implementation, involved end to end testing of FACETS Billing, Enrollment Claim Processing and Subscriber/Member module.
• Involved in processing claims in FACETS and validating the full cycle process to make sure the checks are generated and 835's are generated.
• Tested Ab initio graphs for various ETL functions and transformations.
• UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Wrote SQL queries to validate source data versus data in the data warehouse.
• Identified duplicate records in target tables.
• Tested the claims processing with EDI transactions (270, 271, 835, 837) in HIPPA and HL7 Environment.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Expert in writing Complex SQL/PLSQL Scripts in querying SQL Server, Teradata and Oracle.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Tested a number of complex ETL Ab Initio graphs, for initial and daily data loads.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Involved in all walk throws for test designs, data designs and code reviews.
• Developed Test Plan, Test cases & Test Scenarios for new features.
• Extensively used Teradata load utilities Fast load, Multiload and Fast Export to extract, transform and load the Teradata data warehouse.
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports.
• Updated existing Regression Test cases for impacted features due to new features.
• Tested the Application in UNIX Environment and collecting the Test data from the Business Team.
• Identified the Test Environment for Database Testing.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Queried Teradata Database and validated the data using SQL Assistant.
• Used T-SQL for Querying the SQL Server database for data validation.
• Writing the test scripts for manual testing.
• Preparation of various test documents for ETL process in Quality Center.
• Understand the database development for this project.
• Reviewing the database Test cases and performs the Database Testing when writing the SQL queries.
• Executed the Stored procedure when passing the valid/Invalid Parameters.
• Involved in Data migration and Data distribution testing.
• Tested the Dashboard reports using Cognos Report Studio and Metric Studio.
• Execute the database Test cases according to release.
• Tested the Universe s Structure to ensure that tables are properly uploaded, tested the aggregate Universe to ensure the query is pulling correct level of Aggregation.

Environment: Ab Initio (GDE 1.14.38 & GDE 1.16.1), Cognos, HIPAA, FACETS, ALM/HP Quality Center 11, Teradata 13.0, PVCS, SQL, PL/SQL, Oracle 11i, TOAD, XML, XSD, PERL 5.12.1, XML Spy 2008, Flat Files, Excel, Ms PowerPoint, Autosys, UNIX, IBM AIX 6.1.

ETL /DWBI Tester- Cognos /QA

Confidential, Chicago, IL

Responsibilities:

• Interacting with Business Analysts and Development teams to understand the business requirements and giving the estimates from testing prospectus.
• Test plan preparation, preparing daily status reports and defect reports.
• Involved in prioritizing the requirements according to business needs and putting all the requirements in QC.
• Prepared Test Cases based on business requirements and business rules for HIPPA EDI Transaction 834, .
• Extensively used Ab Initio GDE for mocking data using continuous flow graphs.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Used Tivoli to schedule and run Ab Initio Jobs and Unix to monitor ETL execution and logs.
• Worked with business team to test the reports developed in Cognos.
• Experiences working in ANSI x12 837-835 EDI Transaction.
• Involved in writing and executing the test cases and involved in Defect reporting and verification.
• Involved in identifying the cause of Defect and reporting the same to developers.
• Validating the data between Oracle Tables and SQL Server Tables by using SQL Statements.
• Testing the data present in fact tables and dimensions tables.
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Involved in Data Validation, Data Conversion and Data Reconciliation Testing.
• Involved in HUT (Hard unit testing), SIT (System Integration Testing) and WIL (Week in Live Testing) Testing.
• Testing of Ab Initio graphs and Autosys scripts for job scheduling, executing the test cases, raising the bugs in QC and closing them for all the modules
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Wrote PL/SQL /Complex SQL queries for system testing.
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Tested data warehouse ETL process using SSIS (Integration Service).
• Extensively executed SQL queries in order to view successful transactions of data and for validating data.
• Observed the Extract, Transform, Load process with Ab Initio and tested the data load process using the Ab Initio ETL tool.
• Extensively used Informatica tool to extract, transform and load the data from Oracle to DB2.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Responsible for reporting and escalating data issues arising from project or daily support.
• Involved in Defect prevention, productivity improvement and knowledge management activities

Environment: Ab initio 2.14 GDE, Cognos, HIPAA, EDI, HP ALM/ Quality Center 9.0, Teradata V2R6, Oracle 10g, SQL, PL/SQL, SQL Server 2008/2005, SQL Navigator 5.0, DB2 8.x, IBM AIX 5.5, MVS, ISPF, VSAM Files, Flat Files, XML Files, Shell Scripting, PERL, XML, XSD, TOAD, WinSQL

ETL/BI Tester/QA

Confidential, Tampa, FL

Responsibilities:

• Interacting with Business Analysts and Development teams to understand the business requirements and giving the estimates from testing prospective.
• Excellent knowledge on Agile Methodology.
• Worked with business team to test the reports developed in Cognos.
• Test plan preparation, preparing daily status reports and defect reports.
• Involved in prioritizing the requirements according to business needs and putting all the requirements in QC.
• Verifying all the information from HIPAA to FACETS.
• Extensively used Ab Initio for extraction, transformation and loading process.
• Observed the Extract, Transform, Load process with Ab Initio and tested the data load process using the Ab Initio ETL tool.
• Standardized QA processes for FACETS implementation and testing.
• Validated the ETL Scripts in the Target Database (Oracle) for creating the cube before migrating it to SQL Server.
• Involved in developing test cases to test Teradata scripts (Bteq, multiload, fastload).Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD. Extensively written Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.

QA Analyst

Confidential

Responsibilities:

• Reviewed Client Requirements, Use Cases, and High Level and Low level Design documents for the changes in each release.
• Reviewed Mock Ups, Technical specifications, and Data design documents for data changes.
• Developed Test Plans, and Test cases based on requirements, and technical and design specifications
• Wrote and ran UNIX Scripts for batch jobs.
• Ran UNIX shell scripts to count the records for EDW source to staging tables.
• Ran SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.
• Developed Test data requirements and data dependencies, and conditions for all test cases.
• Performed Functional, Integration, and Regression testing
• Testing ETL sessions and PL/SQL scripts for multiple feeds and multiple LOBS'.
• Identified Test scenarios for Automation for critical functionality.
• Developed Automation test scripts, and run the scripts as part of regression testing.
• Quality Center used for Test Cases development and test execution status tracking.
• Testing the data present in fact tables and dimensions tables.
• Performed Data Validation, Data Conversion and Data Reconciliation Testing.
• Performed HUT (Hard unit testing), SIT (System Integration Testing) and WIL (Week in Live Testing) Testing.
• Defects found tracked and managed in Quality Center and disposition in defect scrub meetings.
• Represented in Project and Defects scrub meetings, and provide status on assigned tasks.
• Testing status reported to QA Manager and project manager.
• Involved in production data validations for each change in all releases

Environment: Quality Center, UNIX SQL Navigator, Oracle Web Cache server, Oracle Application Server, Oracle 10g, SQL, PL/SQL, Oracle Reports Generator, PL/SQL, XML, Teradata V2R5, Quality Center, Windows XP