SUMMARY:

• Overall 8+ Years of Experience in Data quality analyst, Data Profiling and Reports validation and development of reports using Tableau, Jasper, Oracle SQL, PL/SQL, Informatica and SAP BODS data sources.
• Strong experience in Requirement Analysis, Test Plans, Test Strategy, Estimations, Traceability Matrix, Risk Analysis for different domains like Finance, Insurance,Health and Retail.
• Strong experience in performing Testing and hands on complex SQL queries as per the Business requirements in Hive, to validating the data loaded by Hadoop Sqoop, ETL tools such as Informatica, SAP BODS and Talend.
• Exper tise in processing Semi - structured data such as (XML,JSON,RC and CSV) in Hive/Impala as part of Data Validation.
• Experience on CA Grid Test Data Management Tool, which is used to generate the Masking, Synthetic type test data as per the business requirements for validating the new ETL code.
• Hands on Informatica Power Center such as Designer to verify the mappings, Workflow Manager to validate the Job Flow and Workflow Monitor to verify the job run at the time of testing.
• Responsible for End to End testing involving various Sources Databases until Target Databases.
• Working knowledge and practice working in Agile development environment.
• Proficiency on Financial Services Data Mart known as FSDM , and Data Lake designs.
• Extensive knowledge in Dimensional data modeling, Star Schema, Snow-Flake Schema, Normalization, Physical and Logical Data modeling .
• Experienced in writing Test cases and complex SQL queries as per the Business requirements , validating the data loaded by ETL tools like SAP BODS , Informatica, Data Stage, Hadoop Hive etc.
• Proficiency in MS Office suite with an emphasis on Excel to perform data analytics, pivot tables, lookups and external data source connections
• Expertise in validating dashboards, reports, reporting and analytic applications and tools to drive Organisational sales and revenue growth
• Experience Interacting with power user community to understand the Business requirements and converting into Test plan, scenarios and get it reviewed by the business for further proceedings.
• Proficiency in SQL, Transact SQL, SAS, writing stored procedures, functions and statements for data transformation and manipulation
• Developed ETL Testing regression bed by analyzing the ALM (Quality Center) for all the projects, and selected the qualified test cases and with the help of parameterized concept in QC, built a set of regression test cases with self-explanation.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Reports, and Weekly Status Reports.
• Created numerous ad-hoc analysis, dashboards, reports, graphs, and charts to the management to take quick decisions.
• Tested reports developed by Business Objects Universes for both Ad hoc & Canned Reporting users of Business Objects.
• Hands on SAP BODS such as Designer to verify the mappings, Management console to validate the Job Flow and 3rd party Scheduler to verify the job run status and dependencies at the time of testing.
• Experience with Hyperion analysis, reports validation with Pivot tables and databases .
• Experience in validating the source flat files which loaded into Hadoop HDFS environment and validated the reports which is pulled from the HDFS.
• Extensively worked on Application Life Cycle Management (HP ALM 12) to track the execution, defects and pulled the traceability Matrix.
• Excellent communicat ion - ability to tell a story through data.

TECHNICAL SKILLS:

Reporting Tools: Tableau Suite of Tools 9.2, 9.0, 8.2, 8.1, 8.0, 7, 6, 5.1 Hyperion, Business Objects, SSRS.

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, FSDM, Data Lake.

Databases: Oracle, MS SQL Server-2005, 2008, Teradata, DB2

ETL Tools: SAP BODS, Informatica, Talend, Data Stage.

Tools: Toad, SQL assistant, SQL Navigator, SQL Developer, MS - Visio, HP Quality Centre ALM 12, Bug Tracker, Team Track 6.2, Ca Grid Test Data Management Tool

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Big Data and Data Quality Analyst Lead

Responsibilities:

• Analyzed the requirements from business requirement & functional use case diagrams, and other project related documents to design and develop effective Test cases.
• Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts. Tested functionality across applications and workflows.
• Comparing the results of traditional system to Hadoop environment to identify any differences and fix them by finding the route cause.
• Validate daily and weekly Sqoop jobs to dump data from existing Oracle database into HDFS for processing and exporting data to RDMS.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Hadoop Bigdata.Validated the Map reduce, Pig, Hive Scripts by pulling the data from the Hadoop and validating it with the data in the files and reports.
• Writing the Test plan by analyzing the technical design document and get it signed off from the Business.
• Strong Knowledge on SQL Query writing skills in Oracle 10g, SQL Server 2008 and Teradata.
• Validate the data, which is loaded from multiple sources such as Flat files, Excel and Hadoop HDFS environment.
• Involved in preparation of test data to cover the end-end scenarios as per the business requirements.
• Prepared complex queries and running SQL queries to verify tables at source, stage & target Database.
• Reusable Test case prepared for End to End, i.e. starting from Source DB to Target Reporting.
• Developed Regression test bed by analyzing previous test runs which helps the business to save a huge effort.
• Prepared defect analysis documents and Share the knowledge with the team.
• Involved in Execution of test cases and capture the success and failure analysis through ALM for tracking purpose.
• Validated Source flat files which is generated in UNIX box against with Database.
• Extensively worked on External tables, Big Data HIVE to validate the data in HDFS file system.
• Success fully delivered multiple projects in tight schedules with 0 Defects in UAT.

Environment: Tableau 9.2, Hyperion, Hadoop HDFS File system, SQL Server 2008, SSIS, SSRS, Toad for Data Analytics

Confidential

Data Quality Analyst/ ETL Tester

Responsibilities:

• Understanding the Business requirements and map these to the Solution design.
• Providing estimations and handling the project discussions with LOB partners
• Responsible for data quality certification to ensure the data is transformed correctly and ready for building insights through analytics and reporting
• Design complex SQL Queries in Oracle/ SQL Server to verify the data load(ETL) into Enterprise Data Ware House
• Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica, SAP BODS
• Developed test scripts based upon business requirements and processes, in line with defined workflows and use cases. Processed transactions from system entry to exit Tested functionality across applications and workflows
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center/ALM Built a library of test cases for regression testing and automated them using QTP.
• Working closely with business analyst and technical teams to ensure BI/Reporting requirements are designed accurately per the LOB request.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Involved in extensive DATA validation on data marts by using SQL queries.
• Developed test reports and participated in testing prioritization and archived test results and user signoff
• Validated Business Objects reports by running the SQL queries based on the business rules.
• Validated BO Reports, Dash boards and Universes like Fields present in the report are as agreed in the specifications, Drill down features, Column headings for business sense and familiarity, Display of units along the column headers, Presence of graphs, Report Descriptions, special features like alerts, filters, extraction criteria.
• Created reports and graphs for Analysis and Tracking for Test processes with Quality Center/ALM.
• Experience in testing Business Report developed in Business Objects XIR2
• Responsible for End to End testing involving various Sources Databases until Target Databases.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Involved in Schedule jobs Testing.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Build scripts through automation Tool (Toad Data Point) which is used to validate the data on large scale.
• Ensure the Reporting SQL Queries built solves the identified business problem.
• Ensured that all documents and products were in compliance with quality standards.
• Prepare Defect Analysis Documents and Share the knowledge within the team.

Environment: informatica 8.x, SAP BODS 4.x, Hyperion, SQL Server 2008, SSIS, SSRS, Toad for Data Analytics

Confidential

Data Quality Analyst/ ETL Tester

Responsibilities:

• Analyzing Finacle Business requirements and producing relevant artifacts like Business Cases, Functional specifications and Solution overview documents.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance.
• Performed L3 level support for the existing Data runs in Production, and routed the tickets to the right Stack holder.
• Played a single point of contact to Develop and validated the SAP BO reports ad hock.
• Validated the Financial system data mart against with the source systems, and the current data model.
• Involved in preparation of test data to cover the end-end scenarios as per the business requirements.
• Prepared complex queries and running SQL queries to verify tables at source, stage & target Database.
• Test case prepared for End to End, i.e. starting from Source DB to Target Reporting.

Environment: SAP BODS, SAP BO Reports, Oracle 11, SQL, SQL*Plus, Windows 2003/ XP

Confidential

Data Quality Analyst/ ETL Tester

Responsibilities:

• Analyzed the requirements from business requirement & functional use case diagrams, and other project related documents to design and develop effective Test cases.
• Mortgage industry professional with loan-processing experience and a comprehensive knowledge of conventional and government loan programs.
• Review of test scenarios, test cases and Data Warehouse Test Results.
• Good skills in interacting with Clients, Business Analysts, UAT Users and Developers.
• Developed test scripts using SQL queries to validate data.
• Prepared Regression Test Plans, Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use
• Hands on experience in Automation testing using QTP.
• Generated reports using SOAPUI.
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and S Report.
• Manually tested the applications and handled Test Cases through Test Management Tool Quality Center/ALM.
• Involved in data governance, defined data mapping from source to target
• Reviewing the test activities through daily Agile Software development stand-up meetings.
• Defect tracking and Status reporting using Quality Center (QC) ALM defect tracking tool.
• Developed SQL queries to check the database automatically and checking the data integrity in ETL Flow of data from source to stage and target Database.
• Design, develop and execute regression, usability, stress, database verification, ad-hoc and other types of testing activities.
• Worked closely with business users and the project team to analyze business requirements in order to create project test scenarios.

Environment: Informatica Power Point, Oracle 10g, SQL Server 2012, Quality Center 11 &ALM, Agile, XML, QTP, 9, SharePoint, UNIX, Documentation Tools: MS Office - MS Word, Excel, PowerPoint, MS Project

Confidential

Data Quality Analyst/ ETL Tester

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Understanding the Business requirements and map these to the Solution design.
• Strong SQL Query writing skills in Oracle 10.
• Analyzed and used various data sources - Oracle, Excel, and Web Services.
• Involved in preparation of test data to cover the end-end scenarios as per the business requirements.
• Involved in preparing functional Documents on the current process.
• Prepared complex queries and running SQL queries to verify tables at source, stage & target Database.
• Test case prepared for End to End, i.e. starting from Source DB to Target Reporting.
• Prepare defect analysis documents and Share the knowledge with the team.
• Involved in Execution of test cases and capture the success and failure analysis for tracking purpose.
• Validated the Insurance claims data using SQL queries in Backend Testing
• Knowledge on UNIX commands & Shell scripting.
• Involved in Regression testing for the existing functionality.
• Involved in Equivalence, Reconciliation Testing by using Informatica tool
• Work with UNIX commands & Shell scripting to access logs and debugging.

Environment: Oracle 11i, Informatica 8.x, SQL, MS SQL, Windows 2003/ XP, UNIX.

Confidential

Data Quality Analyst

Responsibilities:

• Interacted and worked with ETL team for improving performance on data from multiple data sources
• Understanding the Business requirements and map these to the Solution design.
• Validated the data based on Basel Norms in Oracle 10.
• Analyzed and used various data sources - Oracle, Excel, and Web Services.
• Involved in preparation of test data to cover the end-end scenarios as per the business requirements.
• Involved in preparing functional Documents on the current process.
• Prepared complex queries and running SQL queries to verify tables at source, stage & target Database.
• Test case prepared for End to End, i.e. starting from Source DB to Target Reporting.
• Prepare defect analysis documents and Share the knowledge with the team.
• Involved in Execution of test cases and capture the success and failure analysis for tracking purpose.
• Involved in Regression testing for the existing functionality.

Environment: Data Stage,SQL, Oracle 10g, Jasper Reports.

Confidential

Pl/SQL Developer

Responsibilities:

• Requirement was studied and involved in writing the Oracle code for SECURITISATION Module.
• Construction of stored Procedures which used to extract data from tables and generate flat files.
• Worked with tables, index, views, synonyms, and sequence, Constraints.
• Hands on UNIX shell scripts to validate the flat files, and automated ftp process to down the stream.
• Used Oracle utilities like SQL loader, data pump to load the data from flat files to respective tables.
• Prepared Unit Test Plan, and execution documents for end to end process.

Environment: Oracle Pl/SQL, SQL, Oracle 10g, UNIX Shell Scripting, Windows

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Involved in Design & Development, coding and various PLSQL validations.
• Development of Re-usable objects like General Procedures, Functions, Triggers & Packages.
• Create the objects like tables, synonyms, sequences and views.
• Technical & Project reviews with client, coding, testing and Implementation.
• Prepared Unit Test Plan.

Environment: Window NT, Oracle 10g, PL/SQL, SQL, Informatica 8.5, Web focus 7.6.4