PROFESSIONAL SUMMARY:

• Experienced Quality Assurance Engineer with expertise in both Business Intelligence and ETL applications
• Highly skilled in developing Test Plans, Test scripts, Test Matrix and Executing Test Cases
• Hands on experience in writing test scripts, preparing test data, testing Informatica Mappings and creating SQL scripts using stored procedures, functions, Unix.
• Tested the customized Reports as per the business Requirements using Micro strategy.
• Executed and validated the data on weekly and monthly reports in Micro strategy before UAT.
• Involved in Testing Micro strategy prompt, Filter, Template, Consolidation, and Custom Group.
• Expertise in testing of the reports using Data Mart Reports, Aggregate Tables and Intelligent Cubes.
• Recently assigned as MSTR Developer and developing documents/dashboard using the tool based on business requirements.
• Part of MSTR production support team as well.
• Experience in creating ETL test scenarios and test cases and deployment plan by using ETL mappings
• Solid Back End Testing experience by writing SQL queries and executing shell scripts
• Experience in Data Analysis, Data Validation, Data Verification, Data Cleansing, Data Completeness and identifying data mismatch.
• Expert in writing SQL queries and has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Knowledge of UNIX shell scripting and scheduling and execution jobs through Control M
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica
• Excellent analytical, problem solving, and communication skills, with ability to interact with individuals at all levels.
• Experience in executing the test cases and reporting bugs using test management tools like HP ALM JIRA, Rally.
• Responsible for mentoring resources technically and training other QA Team Members.
• Experience with QA Methodology to ensure the Quality Assurance Control.
• Good in analyzing risk and issues and able to communicate to Management for determining mitigation plan in timely manner

SKILL:

Data Warehousing: Informatica 9/8.5/ 8.1/7.1/6.2/5.1 (Power Center/ Power Mart)

Reporting Tools: Business Objects 6.5/XIR2, OBIEE 10g\11g, MicroStrategy 8.x/ 9.x

Data Modeling: StarSchema Modeling, Snowflake Schema Modeling, FACT and dimension tables, Pivot Tables

Testing Tools: Test Director 7.5, HP ALM 11/Quality Center, JIRA, Cucumber

RDBMS: Oracle 11/10g/9i/8i/7.x, MS SQL Server 2012/2010/2005/2008 R2, UDB DB2, Sybase, Teradata 13/12/V2R6, MS Access 2008,Data Stage

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, java, Hadoop

Web Technologies: JavaScript, HTML 4.0, and DHTML, .NET, Java, J2EE, XML

Environment: UNIX, HP-Unix, IBM AIX 4.2/4.3, Hyperion, Win 3.x/95/98/XP/Win 7, NT 4.0, Sun-Ultra, Red Hat Linux

EMPLOYMENT HISTORY:

Confidential, Barclaycard

QA Test Engineer

Responsibilities:

• Working on Agile SDLC environment and involved in multiple projects related with different Barclays partners and Vendors.
• Extensively worked with Data Extraction, Transformation and Loading process.
• Created ETL test data based on the requirement to cover all the scenarios.
• Used HPALM/Rally for writing test plans test cases and defect tracking as well.
• Utilized SQL scripts to validate data movement from source to target as part of ETL process.
• Written extensive PERL and UNIX Shell scripting for data parsing and text parsing needs including archiving the old data, running backend jobs & setting up of job dependencies.
• Performed extensive Data Validation, Data Verification against Data Warehouse. Key goals for quality data involved data correctness, data transformation validation, Integration testing, data completeness, regression testing
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• Responsible for ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica, Shell Scripting & PERL
• Created spreadsheet of scenarios of input data and expected results for better data quality.
• Strong ability in developing SQL queries to validate data correctness, data profiling, duplicate checks, data quality validation, etc.
• Good knowledge on creating/testing reports, filters, slicers using the BI tool like MSTR.
• Actively worked on cosmetics checks and data validation of numerous partners/vendors related reports using tools like Micro strategy and Hyperion.
• Contributing in lab day for various brainstorming sessions to generate new ideas within a group setting.
• Participating in grooming session to identify the complexity of user stories, also involved in Sprint planning, daily scrum standup, and retrospective meeting for betterment of process.
• Used Control-M to run jobs, check the job schedule, validate cyclic or non-cyclic jobs, validate job execution in success or failure status, etc.
• Validated number of incoming and outgoing feeds from different partners and vendors using UNIX commands and WinSCP.
• Utilizing technologies such as TSYS, Control-M, Toad, and Data Stage to replicate the production scenarios and validate the business logic as per the requirement.
• Recently started working on Automation Script in Cucumber.
• Hands on Experience on Integration testing data pipelines and system in Kafka. Validating/Comparing the structure and data sent in messages from Producer and to Consumer in various topics.
• Executing/ writing Automation script for Functional Testing scenarios as well as for End to End Test.
• Data comparison between the source (oracle) to target (ingest layer in Hadoop) using the automated script.
• Converting the payload structure in json to table format and comparing messages sent to target topics.

Confidential, Utah

Sr ETL/QA Engineer/Scrum Master

Responsibilities:

• Reported directly to the Director of Technology and Channel Managers on project metrics, status, schedules and risk assessments
• Manage technical projects for software development and infrastructure improvements that encompass software and system upgrades.
• Coordinate between various department dependencies and escalation of issues to keep project schedules on track, utilizing JIRA for online issue tracking
• Worked aggressively and closely with the team in order to meet QA timeline and signed off QA reports.
• Involved in QA activities beginning of every release and have created Test Strategy, Test Plan document according to the requirements and user story.
• Created test conditions (test cases) for every release for SIT.
• Good experience working on an agile project.
• Used Rally for Test Management and Defect Management.
• Used HPALM to execute the Test Condition for SIT.
• Supported business for UAT.
• Worked actively in ETL process and writing complex SQL queries for querying data against different databases (SQL Server and Netezza) for data verification process.
• Written SQL queries to validate the data from Source to Target database.
• Tested Customized Auto Styles to allow reports in Microstrategy Web.
• Debugged the reports along with the help Microstrategy Knowledge Base to troubleshoot some Report / data related issues.
• Developed Reports in MicroStartegy for business using Dashboard, Documents.
• Used MicroStartegy Developer tool to create Reports using prompts, filters, metrics, attributes.
• Worked on automating most of the Manual testing scenarios using QTP and VBScripts.
• Wrote VB script to convert the .xml file to .csv file for file validation purpose
• Generated the automation framework design using Microsoft Visio.
• Involved in writing automation script to validate the data from pre stage to different staging layer and to the fact table.
• Used the UFT (Unified functional tool) for automation using the VB script as a scripting language.
• Actively involved in Business meeting and Team meeting to understand the requirement properly.
• Worked actively in data profiling, data scrubbing and data cleansing for the ETL process.
• Performed end to end data validation in the Historical Migration process from SQL Server to Netezza.
• Performed end to end data validation in incremental data load in Netezza and making sure the data is flowing from Retention to Fact as per the lookup condition.
• Used Informatica (Informatica Designer, Manager, and workflow) as ETL tool to check if the data is loading correctly and also to debug the data using the debugger tool in Informatica.
• Worked on SFT application for pulling and pushing the files to different UI application.
• Good Knowledge on creating Test Data in each release for validating the ETL process.
• Worked on a project where the ODS (Operation Data Store) system is migrated from UNIX/PERL/SYNSCORTS script to load the data to tables to Informatica workflows.
• Validated the Control M jobs if they are being triggered as per the setup or not.
• Also involved in Support Team mainly on MSTR support activities.
• Helping Business to get access to MSTR tool, assigning roles as Reporter, Analyst, professional, Developer, Looking into server level issues as in environment down or caches problem.

Confidential, Oak Brook, IL

Sr ETL/ QA Analyst (QA Lead)

Responsibilities:

• Co-ordinated with development team and closely worked with offshore QA team in order to meet timeline for QA environment latest build & signed off QA Reports.
• Performed testing activities related to ecommerce based application.
• Used JIRA tool for logging the defects and assigning it to the respective developers.
• Validated the latest build, proxy and version for the RBI web application.
• Validated Response and Result code for different platform automation using the assertion configuration file.
• Extensively worked in cross browser testing for multiple devices and web.
• Used Fiddler and developer tool for validation the commands, results and response code, methods, status, url, etc
• Performed different kind of testing such as Ad Hoc Test, Full Regression Test, Smoke Test, and Functional Testing, Integration testing, Performance testing.
• Used Quality Center for management, presentation and tracking the defects/ bugs.
• Used QC to upload the manual test result of intermediate/full regression, smoke testing.
• Attended the defect triage meeting every two weeks to prioritize defects.
• Practiced Agile Methodology for project development and QA
• Work closely with developers to isolate and reproduce Defects, validation of fixed code & deploying in respective environment.
• 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 databases for data verification process.
• Scheduling the UNIX script from the CRONTAB
• Unit tested the mappings using SQL scripts.
• Tested mappings to load data into Type II slowly changing dimension tables.
• Suggested to create Oracle Indexes on some of the source tables
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.

Environment: Informatica Power Center (Power Center Designer, workflow manager, workflow monitor),, HP ALM, SQL *Loader, Oracle 11g, Windows 2000, TOAD 7, Microstrategy, Selenium, SOAP UI,Silverlight

Confidential, Washington, Columbia

QA/ DW Test Analyst

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in HP Quality Center
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Tested Customized Auto Styles to allow reports in OBIEE.
• Debugged the reports along with the help OBIEE Knowledge Base to troubleshoot some Report / data related issues.
• Performed cross browser testing of OBIEE reports in I.E 9.
• Tested the customized Reports as per the business Requirements using OBIEE.
• Developed Data flow Analysis and Modeling for Healthcare applications and categorized the applications according to HIPAA 4010, ICD 9.0 and Institutional Guidelines
• Highly Experienced in HIPAA (Health Insurance Portability and Accountability Act), Health Care industry providing Business Process Assessment, Requirements Gathering, Gap Analysis, Implementation and Testing
• Analyzed ICD9 to ICD10 Mapping for content standardization.
• Followed HIPAA Standards ( ) EDI and Compliance issues, Medicare (Part A and Medicare Part B), Medicaid and ICD 9.
• Performed comparative analysis and gap analysis to identify variation in the process as per HIPAA X12 4010 and 5010 guidelines to in corporate updates as per 5010 guidelines
• Experienced Data Quality Testing Data Analysis, Data Validation, Data Verification, Data Cleansing, Data Completeness and identifying data mismatch.
• Executed several PL/SQL procedures.
• Tested several BI Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s, Grouped List, Cascade and Web Reports.
• Tested and validated the BO reports by running similar SQL queries against the source system(s).
• Tested several Informatica Mappings to validate the business conditions.
• Testing the source and target databases for conformance to specifications
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center 10
• Designed and prepared scripts to monitor uptime/downtime of different system components
• Written Test Cases for ETL to compare Source and Target database systems.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations
• Interacting with senior peers and subject matter experts to learn more about the data

Environment: Informatica 8.6.1, OBIEE, WinSQL, HP Quality Center 11, Teradata 13.0, Teradata SQL Assistant 12.0, TOAD, Oracle 11g, PL/SQL, IBM DB2. EDI Notepad