ETL Tester / Data Warehouse Tester

Nitu Jaiswal

Phone: +1-415-***-**** email: ***********@*****.***

SOFTWARE QA/Manual Tester, Quality Analyst, Data warehouse,

ETL & BI Tester

Expert in Manual, ETL & BI Testing 5+ Years Record of Proven Results Consulting Experience with Wisetek Providers, Inc [2016-present], Harman International (formerly Aditi Technologies) [2011-2015], ASTRUM [2010-2011]

Clients like Ladbrokes (U.K client), NECC (U.S client), The Co-operative FOOD Supplier Portal (U.K client), Motricity (U.S Client)

•Software QA Tester with full SDLC and STLC experience, including designing, developing and implementing test plans, test cases and test processes under Scrum.

•Qualifications include Five plus years of QA software testing experience which includes Smoke Testing, Sanity Testing, Functional testing, System testing, Regression testing, Black Box testing, UAT, Adhoc Testing, Database testing, Manual testing, Migration testing, ETL and BI report testing, Game Testing in iOS and Android devices.

•Backed by strong credentials including a bachelor degree in Electronics & communication, SDLC, Experience in Agile and V-shaped testing methodologies, Strong knowledge of Transact-SQL, Pl/SQL languages and Date warehouse architecture. ETL tools Informatica Power center and Oracle SQL developer, BI tool OBIEE and cross-platform skills in Windows and UNIX.

•Extensively worked on Data Warehouse Full Life Cycle Projects for Retail, Sales, Gaming, Mobile Content Network industries and Healthcare.

SKILLS SUMMARY

SQA Testing & Methodologies

Test Plans, Test Cases & Test Processes, Functional Requirements,

Scripting & Documentation

Regression & Negative Testing

UI & Compatibility Testing

Data Interface & Migration Testing, Incremental testing,

Transact-SQL and Pl/SQL language, Black box Testing

Defect/Bug Tracking

Test Strategies & Coverages

QA & QC Standards

Quality Center, JIRA, Visual Studio

TECHNICAL SKILLS

ETL Tools

INFORMATICA Power Center 95.1, Oracle SQL Developer.

Testing Tools

HP Quality Center 10, JIRA, Visual Studio 2010, Google doc, Open bet delivery tool.

Database

Oracle 10g/11g, SQL Developer, SQL Server 2008, MS Access.

Reporting Tools

OBIEE.

Operating Systems

Windows 98, Windows XP, UNIX

Languages

C++, SQL, Pl/SQL,

Scripting Tool

Ruby Scripting.

Automation tool

Calabash (Mobile Automation).

Methodology

Agile

Others

User experience, User Research.

EDUCATION & CREDENTIALS

Bachelor of Technology in Electronics & Communication [2006-2010]

PROFESSIONAL EXPERIENCE

Wisetek Providers, Inc.

Duration: January 2016 – Present

Location: Fairfax, VA

Industry: Healthcare

Role: Quality Analyst/ETL Tester

Environment: Oracle 10g, 11g, Informatica 9.6, Transact-SQL, HP Quality Center 10.0

Project Description:

Upgraded an Electronic Medical Record (EMR) application, creating a BI dashboard for doctors and nurses, and upgrade the database from Oracle 10g to 11g, inbuilt Data warehouse module for analysis and research on Billing/Payment for the Dashboard.

Responsibilities:

Created quality assurance (QA) plan and test case documents, created traceability from requirements to test cases and their respective defects logged during the testing cycle.

Conducted user acceptance testing (UAT) and obtained signoffs from the stakeholders.

Developed Oracle SQL Queries simple and complex for analysis and creating testing scripts.

Analyzed the data extracts from Legacy Systems. Interacted with the Technical Analyst to determine the element source, format and its integrity within the system.

Interacted extensively with data modeler and ETL developers for creating the Data Functional Design documents.

Worked throughout the quality assurance life cycle including requirements specifications, creating a test plan, creating test cases, executing test cases, reporting defects, generating reports and managing regression testing

Established traceability from Business requirements to Functional requirements to user requirements

Conducted formal and informal product design reviews throughout the software development lifecycle to provide input on functional requirements, product designs, schedules and potential issues. Leveraged developer background to communicate effectively with software design team, quickly gaining their respect and becoming a valued, “go-to” team member on challenging test cases

Defect Management using HP Quality Center.

Delivered QA testing reports that determined product quality and release notes.

Documented and reported various bugs during the Testing process.

Ladbrokes ADW PHASE 2

Client: Ladbrokes (U.K client)

Duration: July 2013 – May 2015

Industry: Gaming

Role: Data warehouse/ETL/BI Tester

Environment: Oracle 11g, SQL Server, ETL tool ODI and reporting tool OBIEE, JIRA

Project Description:

ADW is a newly developed central warehouse for Ladbrokes wherein both Live and Historical data resides which are pulled from different data source systems and the available data helps Ladbrokes to generate either transactional level or aggregated summary level reports/dashboard on top of it to allows Ladbrokes a clear view of their liabilities, risk, and exposure. The Active Data warehouse will replace the existing reporting system with a single warehouse. This would enable management to access extensive/consolidated Analytical reports on a single platform.

Responsibilities:

Attended walkthrough meetings with the Business Analysts and Dev team to get a clear understanding of the business and the applications.

Responsibilities include writing advanced queries for data validation during ETL processes and on Business Dashboard Reports.

Developed and Designed Test Cases based on the Business Rules and Mapping Documents.

Database/Backend verification - executing basic and complex queries using Transact-SQL.

Testing of ETL processes, Source Data Files, SRC to Target, Dashboard Reports.

Tested Incremental load.

Aggregated the data at source and compared with the Target to validate Transformations.

Prepared Requirement Traceability Matrices to track the requirements with the test cases and make sure none of them have been missed.

Defect Management using JIRA and Visual Studio 2010.

Tested the reports drill down, drill up and Pivot reports generated from TFS.

Worked with other members of the QA and Development teams and managed efforts with the team in improving the processes, methods, effectiveness, and efficiency.

Worked on End to End BI Testing activities.

Performed BI Report Testing using OBIEE, by writing SQL queries to validate the data on the report and compare with the DWH data, DataMart.

Done the subject area testing and RPD testing in OBIEE reporting.

IPLay

Client: Ladbrokes (U.K client) Duration: OCT 2012 - July 2013

Industry: Gaming

Role: Data warehouse/ETL/BI Tester

Environment: Oracle 11g, SQL Server, ETL tool ODI and reporting tool OBIEE, JIRA

Project Description:

The project deals with Ladbrokes which is Gambling Company based in London, Overall the largest betting company in the UK and largest retail bookmaker in the world.

Responsibilities:

Involved in Metadata testing, Data completeness testing, Data Incremental testing.

Performed extensive Data Validation, Data Verification against Data Warehouse.

Validated all the ETL mappings developed to fetch data from Source system to the data warehouse.

Conducted Data quality, ETL Regression, ETL Integration and System Testing.

Verified stability of the build by doing Sanity/Smoke testing.

Validated all the session logs.

Created a Performance Report for the end to end testing in comparison with the baseline and final values.

AZURE

Client: NECC (U.S client)

Duration: May 2012 - OCT 2012

Industry: Education

Role: QA Analyst/DW/Reports Tester

Environment: Oracle 9i/1og, SQL, Flat File, Informatica Power center, UNIX, TFS

Project Description:

The project deals with NECC (New England Center for Children) schools which are a Non-Profit organization taking care of autistic children. The project included creating a .Net Application for maintaining ACE (Autism Curriculum Encyclopedia) and generates reports based on curriculum and student’s performance. Autism Curriculum Encyclopedia (ACE) is a web-based application used extensively at NECC which equips teachers and instructive staff to manage students, impart education curriculum, monitor and track their progress.

Responsibilities:

Created test scenarios, test cases, executed test cases and maintained defects in internal bug tracking systems in TFS.

Developed and executed various testing scenarios for Data Transformation Testing, Data quality testing.

Debugging the SQL-Statements and stored procedures for various business scenarios.

Performed extensive Data Validation, Data Verification against Data Warehouse.

Tested several Business Objects Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated and Web Reports.

Tested several Informatica Mappings to validate the business conditions.

Testing the source and target databases for conformance to specifications.

Done the Performance Testing Using Https Watch Basic tool.

NEW SUPPLIER

Client: THE CO- OPERATIVE FOOD SUPPLIER PORTAL (U.K client) Duration: FEB 2012 - MAY 2012

Industry: Retail/Sales

Role: QA Analyst/Report Tester

Environment: Database Oracle 9i/10g, SQL Developer, Transact-SQL, Visual studio 2010

Project Description:

This project is developed for The Co-operative Group. The Co-operative has over 3,000 food stores and supermarkets around the UK. The Co-operative had recognized the need to provide Suppliers and buyers with a common platform to help bring the business together and better enable information exchange. Our SharePoint Web Application gives them the opportunity to achieve this dream by bridging the gap between them.

Responsibilities:

Validated all the ETL mappings developed to fetch data from Heterogeneous source to the data warehouse/data mart.

Logged defects and worked with developers and system analysts to resolve defects using Defect Management Tools such as Visual studio 2010.

Performed regression testing, end to end testing, defect fixes retesting and reported bugs after executing the test cases

Performed extensive Data Validation, Data Verification against Data Warehouse

Database/Backend verification - executing basic and complex queries using Transact-SQL.

Testing of ETL processes, Source Data Files, SRC to Target, Dashboard Reports.

AXIATA 3 (Dialog, Hello and Robi), Celcom

Client: Motricity (U.S client)

Duration: March 2011 - FEB 2012

Industry: Mobile content Network industries

Role: Device Tech (Mobile Testing)/Report Testing.

Environment: Web services, Management console tool, TFS, Report, Ruby Script, and SQL Server.

Project Description:

Axiata 3, Celcom are the major mobile carriers of Asia Pacific. The objective of the Axiata 3, Celcom project is to create a compelling mobile web user experience establishing Axiata 3, Celcom as a brand that brings high-value mobile content to its users starting with the initial page view, and including an escorted off-portal browsing experience, provide popular content available in a portal experience to drive usage and adoption.

Responsibilities:

Performed Integration, functional, Regression testing.

Automation testing using Calabash tool.

Involved in Test Script Generation, Script Maintenance, Script Batch execution

Worked on content publication tool and Create Text, Assert, Promotion, publication, Banner, According to CSS style guide.

Validated all the reports by firing SQL query in the database.

Performed types of Testing Positive, Negative, Regression, Integration, System, User-acceptance, Black Box.

ASTRUM: Image Processing on Matlab tool

Client: DRDO

Duration: August 2010 - FEB 2011

Industry: Research Organization

Environment: FPGA, Matlab

Responsibilities:

Image processing using Matlab in which Various parameters associated with an image were altered for ex. Size/Coding.

Contact this candidate