SUMMARY

• Around 6+ years of IT experience in the testing and implementation of Business Intelligence solutions using Data Warehouse.
• Providing estimates for the projects, creating Test strategy and Test plan.
• Providing exact progress and intimating risk and issues at right time to leadership for risk mitigation.
• Coordinating with various teams to achieve the common goal of ‘project release’ on ‘time and quality’.
• Experience in testing Business Intelligence reports generated by various BI Tools like MicroStrategy, Qlikview, Congo’s SSRS, and OBIEE.
• Good understanding in the concepts of Data modeling, slowly changing dimensions, Star schema & snow flake schema and Business process testing, Data analysis and experience in testing the reports.
• Publishing daily, weekly and monthly status report to the business team.
• Responsible for End to End testing of applications.
• Good understanding of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), Bug Life Cycle and its different phases.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide- ETL Solution using ETL tools like Informatica Talend and DataStage
• Ability to communicate effectively with IT teams as well as Business Teams
• Resolves technical issues related to testing with Project and Development teams.
• Solid Back End Testing experience by writing and executing SQL and PL/SQL Queries.
• Extensive experience with Reporting Tools like Cognos, MicroStrategy, SSRS, Tableau
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Experience of using ETL tools like Informatica power center / Ab Initio / Microsoft SSRS and Reporting tools like IBM Cognos
• Expert in writing SQL queries and Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing in a corporate-wide-ETL solution using ETL tools like Informatica.
• Expertise in Testing complex Business rules by creating mapping and various transformations
• Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Extensive experience in writing SQL to validate the database systems and for backend database testing.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Excellent communication, analytical and interpersonal skills.

TECHNICAL SKILLS

• OPERATING SYSTEMS: Windows XP,NT/95/2000, OS/2, Sun Solaris 2.6/2.7,Linux 6.X/7.X/8.X
• LANGUAGES KNOWN: C, PL/SQL, SQL*Plus
• RDBMS: Oracle, Teradata V2R6, MS SQL Server, MS Access, SQL Server 11.x/12.0
• REPORTING TOOLS: Crystal Reports, MicroStrategy, OBIEE, Tableau, Cognos
• SCRIPTING LANGUAGES: VB Script, XSLT
• DATABASES: DB2, Oracle, Teradata V2R6, Sybase, SQL Server, Netezza
• TECHNOLOGY: Agile, Functional Testing, Team Foundation Server
• DATAMODELLING TOOLS: Erwin 3.5.1/4.x, Designer 2000
• DATAWAREHOUSING: Informatica Power Center / Powermart, Data Stage, ETL, Talend

PROFESSIONAL EXPERIENCE

Confidential, WEST CHESTER, PA

Sr.ETL/QA Tester

Responsibilities:

• Working as ETL Test lead responsible for the requirements / ETL Analysis, ETL Testing.
• Used Informatica Power Center Workflow Manager to run the workflows.
• Extensively executed SQL queries to view successful transactions of data
• Analyzed SQL stored procedures to build the test scripts
• Tested the Outbound feeds generated by running Talend Jobs and validated the data in the feed file with the input data created in front end and querying the data in the Oracle 10g DB using SQL
• Involved in testing MicroStrategy reports including conditional formatting testing and threshold testing.
• Worked with iterative development environment using Agile Methodology
• Wrote SQL queries to validate source data versus data in the data warehouse
• Tested data migration to ensure that integrity of data was not compromised.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Responsible for different Data mapping activities from Source systems to Teradata
• Developed Test Plan, Test cases & Test Scenarios for new features in HP ALM.

Environment: ALM/HP Quality Center, Informatica Power Center, Oracle, SQL, Teradata, MicroStrategy, Soap UI, Agile, XML, XSD, Flat Files, Excel, Ms. PowerPoint, UNIX

Confidential, King of Prussia, PA

Sr.ETL/BI/SQL/Data Warehouse Tester

Responsibilities:

• Written Test Plan, Test Strategy, Test Summary Reports, Governance report, Test Script, Test Cases, Reported bugs and tracked defects using Jira.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Analyzed business requirements, data mapping specifications and developed Test Plans, Test Cases, Expected Results and Prioritized tests for the applications for various modules using Jira.
• Tested Complex ETL SSIS and SSRS Packages, Sessions based on business user requirements and business rules to load data from different source
• Tested the reports using SSRS reports.
• Expert in writing Complex SQL/PLSQL Scripts in querying SQL Server, Teradata and Oracle.
• Written several complex SQL queries for validating SSRS Reports.
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Involved in validating SSIS and SSRS packages according to functional requirements.
• Written Test Cases for ETL to compare Source and Target database systems.
• Tested the SSRS report functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Ad hoc, Dashboards etc.
• Using JIRA (workflow manager) for recording Test cases, Test Executions, Bugs
• Perform end-to-end UAT testing before handling it off to the user group.
• Involved in reviewing Test cases, Functional Requirements.
• Creating Test strategy for the project.
• Tested and validated the SSRS Report Net reports by running similar SQL queries against the source system(s)
• Generating analysis graphs so as to verify the status of the project as well as the execution count of resources.
• Involved in functional testing and Regression Testing
• Tested SSIS packages for transferring data from corporate and other non SQL server databases to populate various tables
• Creating, Deploying and managing Reports through SQL Server Reporting Services (SSRS) and generating pie charts.
• Maintaining Traceability matrix of the project.
• Interaction with Business/System Analyst team members to understand the project scope and requirements.

Environment: MS Access, SSIS, SSRS, SQL, XML/VSAM/Flat Files, SOAP UI, UNIX, Teradata, Microsoft Visual Studio, Jira, Oracle, XML, XML, XSLT

Confidential, Alpharetta, GA

Sr. Data Warehouse Tester

Responsibilities:

• Written Test Plan, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using Quality Center
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Collected requirements and tested several business reports.
• Written SQL complex queries to verify data is flowing from source to target and from the target reports have been generated using MicroStrategy.
• Worked as a consultant in delivering quality data centric solutions Experienced in writing Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
• Tested several dashboards and deployed them across the organization to monitor the performance.
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Tested both conditional formatting and threshold level testing for several reports developed in MicroStrategy.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted

Environment: Informatica , XML, XSLT, MicroStrategy, ALM/HP Quality Center, SQL, Teradata, Teradata SQL Assistant, UNIX, Oracle, MS Access, XML/VSAM/Flat Files