PROFESSIONAL SUMMARY:

• Over 7 years of IT experience, in Manual and Automated testing on web applications, Data warehouse testing, Client - Server, Database migration and Database testing.
• Strong understanding in Analysis, design, development, testing and implementation of business intelligence solution using Database Warehouse/Data Mart, ETL, BI, Client/Server applications.
• Proficient in Data Oracle, MS SQL Server, DB2
• Skilled in troubleshooting UNIX scripts
• Experience in testing Business Intelligence reports generated by various BI Tools like Micro Strategy Series and Business Objects.
• Extensively Queried the SSAS cubes by MDX scripts in the SSAS Environment to validate the cubes
• Excellent problem-solving skills with a strong technical background and affable interpersonal skills
• Experienced in automating and integration of Informatica jobs through Autosys (scheduling tool)
• Performed various testing like Unit Testing, Integration-System Testing, Regression Testing, and User Acceptance Testing to ensure that the code was ideal. Other activities included archiving the test logs and publishing the User Acceptance test logs to the respective stake holders.
• Experience with integration testing of the applications using various sources like flat files, Sybase and oracle, Teradata databases.
• Experienced in production support activities
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
• Involved in gathering and analyzing the user requirements in coordination with Business Analysts.
• Identified the Facts, Dimensions, and the grain of Dimensional mode and referential joins.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality.
• Involved in extensive data validation using SQL queries and back-end testing
• Worked with XML transactions for multiple feeds.
• Performed quality assurance reviews on all System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Experienced in Metadata and Star/Snowflake Integrated schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.

TECHNICAL SKILLS:

Data Warehousing ETL: Informatica Power Center 9.x/8.x, DataStage 8xMicro Strategy: Data Modeling Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams

Databases: Oracle, MySQL 5.4, MYSQL, OLTP

Programming: SQL Plus, SQL Developer, PL/SQL, SQL*Loader, Unix, Shell Scripting, MS SQL

Tools: Oracle Plus, Oracle Developer, My SQL, Siebel

Environment: UNIX (IBM AIX, Sun Solaris), Windows XP/Vista, Linux(RHEL) Testing Tools

HP Quality Center 10.x, Selenium, Test Director. HP-ALM

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

DWH QA SQL Tester

• Validating the messages flow in IBM MQ service bus from EDM to ESB
• Validating the EDM and ESB integrations flow, work with downstream application to name few SAP, Food Star, etc. provide the required input to them.
• Validating developed software solutions using technologies such as SAP, Retalix, Informatica-MDM, BPM and JAVA Enterprise Service Bus service
• Gather Test requirements from SME’s and BA’s and draw out a plan for releases of the requirements and enhancements for the application requested by the users and planning work for subsequent releases.
• Creating a detailed Test Strategy and Test plan for the project, Design Test Scenarios for the requirements. Review the Test scenarios with the SME’s and business users.
• Validating the databases designed in Microsoft SQL server and ORACLE by utilizing SQL Server Management Studio and Informatica Power Center.f
• Tested data quality for MDM, customer data integration and Match-Merge process
• Performing User Acceptance Testing (UAT) from test case design to execution and defect tracking, reviewing, analyzing, and closing.
• Experience installing and configuring IBM Info Sphere Change Data Capture, IBM WebSphere MQ for data replication subscriptions.
• Strong understanding on Hadoop and various components such as HDFS, Map Reduce, HBase, Hive, Pig, Flume, Swoop
• Worked on Integration of Big data and cloud platforms Using Talend.
• Involved in understanding Logical and Physical Data model using Erwin Tool
• Setup HP ALM for the project with Users, access rights, folders structures, workflows and reports.
• Analyze the changes to requirements throughout the project.
• Tested the data acquisition, data transformation and data cleansing approach for the MDM implementation.
• Worked on Hadoop Schema design, involved in file uploads from UNIX/LINUX file system to Hadoop Distribute File System Environment.
• Develop the requirement traceability matrix to map the requirements to test cases, Defining test methodology to carry out the development schedule.
• Allocate the Test scenarios & scripts to Test Analysts for Test design and Test execution. Review and finalize the test cases and Test scripts that are designed.
• Performed Installation, Implementation and Support using IBM Info sphere Data Mirror/Change Data Capture and Change Data Delivery.
• Experience in managing and reviewing Hadoop log files.
• Work with team to ensure test environments are setup and test data are available for test execution
• Allocate the Test cases for Execution. Monitor and track the progress of Test execution and the various cycles involved.
• Test newly developed features to ensure proper functioning prior to release to QA for multiple MDM processes
• Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts
• Chair the Defect Triage meeting with the various stakeholders and resolving defect clarifications raised.
• Interacting with onsite and offshore team in resolving their problems.
• Regular interaction with the offshore team manager/leader and Quality Assurance using the proprietary tools.
• Preparing and sending out the weekly status report to the client.

Environment: Solution Manager, SAP (FI/CO, SD, MM, WM), Retalix Product suite, SAP - TAO, HP

ALM, HP Unified Functional Tester, HP - PC, Selenium scripting, Rational Functional Tester and Rational Performance Tester, Informatica Power Center, MSSQL, Oracle, IBM Info sphere, MQ/IIB

Confidential, San Francisco, CA

ETL Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in ALM
• Involved in creating Test Strategy, Test plan and created test scenario, Test cases and assigning defects
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, and User Acceptance Testing (UAT) and Data validation testing.
• Formulate methods to perform Positive and Negative testing against requirements.
• Developed UAT test cases for business users and worked closely with them to execute UAT test cases
• Involved in automation of test cases using QTP and Did functional and regression testing using QTP
• Performed Web Services testing and Validated XML request/response data using SOAPUI.
• Tested jobs as per business rules using design document and STM Document
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Reviewed normalized/Denormalization schemas for effective and optimum performance tuning queries and data validations in OLTP and OLAP environments.
• Writing SQL for data integration, data validation for verifying the SSIS Packages and business Rules.
• Tested Dimensional tables SCD Type 1, Type 2 and Fact Tables in Star Schema.
• Involved in extensive Data validation using SQL queries and back - end testing.
• Validated cube and query data from the reporting system back to the source system.
• Extensively used Informatica Power Center for Extraction, Transformation and Loading process.
• Tested of SOA end-to-end, Service-by-service and Interface-by-Interface (SOAP, REST)
• Worked with business team to test the reports developed in Cognos
• Involved in ETL Mapping Design and Performance tuning to Load mapping process
• Involved in backend testing for the front end of the application using SQL Queries in Oracle, MS SQL Server database.
• Queried Oracle and Teradata Databases using SQL and validated the data using SQL Assistant.
• Writing SQL queries within UNIX shell scripts in the UNIX environment to perform certain tasks and assisting developers with problems and SQL optimization.
• Built database based on technical requirements. Managed and extracted Metadata associated with ETL processes.
• Responsible for testing packages using SSIS to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Tested analytical reports using Analysis Studio.
• Trained and coordinated with the offshore team members in understanding the requirements and test cases for UAT.

Environment: AGILE/scrum, ALM, HP QTP, SQL, Informatica 8.6.1, MS SQL Server 2008, Oracle 11g / 10g, SQL, IBM DB2 8.0, Oracle, Teradata V2R6, Teradata SQL Assistant, SOAP, REST, SOAPUI, Web Services, XML, Cognos 8.0 Series, SSIS, Unix Shell Scripting,

Confidential, Baltimore, MD

DWH Tester

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Designed the data flow diagrams using MS VISIO.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro.
• Worked with SSIS system variable, passing variables between packages.
• Created cascading prompts at the universe level. These cascading prompts were used within full client and thin client reports to narrow down the selection parameters.
• Tested different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional.
• Written Test Plans and Test Cases on Quality Center
• Defects identified in testing environment where communicated to the developers using defect tracking tool Quality Center
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Designed and supported SQL Reporting services, Integration services and Analysis services.
• Creating test cases for ETL mappings and design documents for production support.
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Scheduling and automating jobs to be run in a batch process.
• Effectively communicate testing activities and findings in oral and written formats.
• Reported bugs and tracked defects using Quality Center
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.

Environment: ETL, Quality Center, UNIX Shell Scripting, Informatica Power, Cognos, Oracle, SQL Server, Teradata

Confidential

QA ETL Tester

Responsibilities:

• Built the Forms for application using various form modules and windows.
• Participated in gathering Business Requirements and designed the project according to the Business requirement specifications.
• Conducted Bug Review meetings for update on defects from development team and retesting of bug fix. Worked with developers to fix faults found in the structure and functionality of the application.
• Prepared daily/weekly bug status reports highlighting bug fix metrics and tracked the progress of test cycles in Quality Center
• Conducted Training & Knowledge Transfer Sessions on new applications to QA Analysts
• Designed the screens and layout using Visual Basic.
• Used SQL*Plus for updating the database and for data retrieval.
• Design and develop a custom database (Tables, Views, Functions, Procedures, Packages)
• Run batch jobs for loading database tables from flat files using SQL*Loader
• Developed UNIX Shell scripts to automate repetitive database processes
• Work with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Used Clear Quest for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs.

Environment: Oracle, SQL*Plus, SQL, Rational Clear Quest, Clear Case, SQL Server, PL/SQL, Windows 95, XML, XSLT