We provide IT Staff Augmentation Services!

Sap Hana View Data Quality Analyst Resume

4.00/5 (Submit Your Rating)

FL

SUMMARY:

  • Overall 7 years of experience in Analyzing Data, Testing and Documentation, Data Loading and Writing SQL queries to validate the custom developed software application on which 2+ years of experience in testing and data validation on the functional area of SAP MM Module and SAP SD Module. Worked with SAP implementation team to verify the data in ECC 6.0 for the SAP MM Module including Material Master, Vendor Master, PO and Goods receipt data.
  • Downloading data from the SAP MM table and compare the data against the data provided in the excel to record and track the defects as recommended by the SAP implementation team.
  • Tested country specific scenarios including sales document types, contract, delivery, shipping, pricing procedures, conditions, taxes, output determination and invoice layout.
  • Familiar in SAP Organization structure, Transaction Code and Master data configuration.
  • Complete understanding of SAP MM and SAP SD(OTC) process flow.
  • Analyzed and tested different Sales document types such as Sales Order, Shipping, Billing and Special Sales document types such as Credit Process and Debit Process, and Return Order.
  • Worked collaboratively with QA, development and business groups to complete comprehensive testing on 2 major new releases.
  • Used HP ALM to create requirements and identified business process, sub process, requirements and variations.
  • Defined test cycles in ALM based on project test plan to track the progress of testing in SIT and UAT cycles.
  • Good Knowledge in SAP HANA Attribute views, Analytical views and Calculation views.
  • Used advanced Microsoft Excel to create pivot tables,charts, used VLOOKUP, and other Excel functions.
  • Domain Knowledge in Pharmaceuticals and Health Care. Involved in Phase I, Phase II, Phase III of clinical trials and working knowledge.
  • Performed Data management like merging, concatenating, interleaving of SAS datasets using MERGE and SET statements in DATA step and PROC SQL.
  • Knowledge in using Tableau Desktop.
  • Knowledge in creating action fi

TECHNICAL SKILLS:

BI Tools: SAP HANA studio,Tableau Desktop

ERP: SAP ECC 6.0

Databases: SAP HANA 1.0, MS Access and SQL, Oracle 11g,SQLSERVER 2000

Quality Tools: HP ALM 11.0

SAS Tools: SAS/BASE, SAS/SQL, SAS/ACCESS, SAS/MACRO, SAS ODS, SAS/GRAPH

Microsoft tools: Microsoft Office (MSWord, MS Excel, Powerpoint)

Operating System: Windows 98/ 2000, Windows XP

PROFESSIONAL EXPERIENCE:

Confidential, FL

SAP HANA View Data Quality Analyst

Responsibilities:

  • Verified CO - PA based HANA view to compare the actual vs plan data at the high level such as Market and line of business against table.
  • Validated SD Billing data on the HANA Calculation View at semantic node against the ECC SD module to make sure that aggregation and selections are done as per the business requirement.
  • Executed test run for the purchase order and Goods movement using the Function modules BAPI PO DETAIL1 to get details of the delivered quantity of each item in purchase order and BAPI GOODSMVT CREATE for post good movement to get list of all orders at customer level.
  • Data verification on the attribute views for simple join conditions, Infocube based calculation view for the currency conversion, Calculation views for complex logic on Union operations for the invoice data.
  • Involved in BW HANA Implementation with performance testing, load testing and UAT.
  • Used HP ALM to create test cases to compare the HANA view data against ECC Data.

Confidential, MN

SAP QA Tester

  • Executed and validated Purchase Orders, Good receipt, Invoice verification and custom reports.
  • Validated SAP BW Bex reports against the SAP MM tables and views.
  • Tested and validated data migration with extracting, cleansing and mapping of Vendor and Material master.
  • Execute Pre-system, Unit, Integration test cases and Log any defects in Quality Center and report the same to QA lead.
  • Validation of data quality to ensure correctness and usage in the system. Major checks were for master data of Vendor (Address attribute of postal code, city, state) and other attributes other Master Data Entities, and Reference or Check Table information.

Confidential, NJ

SAS/SQL Analyst

Responsibilities:

  • Reviewed protocol, CRF and SAP for creating Metadata sheet and creating SDTM data set.
  • Created metadata sheet from the CRF.
  • Mapping the SDTM domain from the metadata Excel sheet.
  • Worked with various Medicare claims files like Inpatient, Outpatient, Prescription drug, Physician for CMS (Centers for Medicare and Medicaid Services) which were 5% random samples drawn without replacement.
  • Created Analysis data set, Tables Listings using Base/SAS, SAS/STAT, SAS Macro, SAS/SQL and SAS/Report.
  • Produced reports using Proc Means, Proc Freq, Proc SQL and proc reports.
  • Used ODS to produce reports in HTML and PDF and RTF.

Confidential

SAP BW Report QA Analyst

  • Generated Custom BEX reports with variants from the standard menu to test different scenarios with different type of selections on variables and restricted key figures.
  • Test Cases were prepared for data validation. Query Specifications design and record the defects in the spreadsheet.
  • Query Development for sales performance based on the origin country product code.
  • Tested the SD Order extractor which is enhanced using customer exit code to get the item level data.

Confidential

SQL Data Reporting Analyst

Responsibilities:

  • Created view and SQL queries to test the day to day business transactions Create daily reports in designed Excel spreadsheets with pivot table. front end screens.
  • Used advanced Excel functions to generate spreadsheets and pivot tables.
  • Extracted, compiled and tracked data, and analyzed data to generate reports.
  • Extracted data from Oracle created datasets and analyzed it for baseline characteristics.
  • Develop and modify SQL queries to extract and create views and report from Client system.
  • Wrote stored procedures, reports, and data input interfaces using SQL.
  • Queried the databases, wrote test validation scripts and performed the System testing.
  • Gathered Data collection from Data Warehouse development (ETL) team with source to target data mapping.

Confidential

SQL Developer

Responsibilities:

  • Designed the Data Access layer and components.
  • Created XML, ASP.Net Pages for Title Management Module.
  • Worked on SQL Queries, Stored Procedures, DTS in SQL Server 2000
  • Collected data from SQL and loaded in to Excel to output for the Web Reporting.
  • Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.
  • Used ADO.NET Command Objects, Connection Objects, Data Reader, Data Table objects and Dataset objects for various database communications.
  • Extracted data from Oracle created datasets and analyzed it for baseline characteristics.
  • Develop and modify SQL queries to extract and create views and report from Client system.
  • Wrote stored procedures, reports, and data input interfaces using SQL.
  • Queried the databases, wrote test validation scripts and performed the System testing.
  • Gathered Data collection from Data Warehouse development (ETL) team with source to target data mapping.

Confidential

Software Testing Reporter

Responsibilities:

  • Extensively Created GUI User Controls using server controls of ASP.Net like Data grids, Repeaters, Textbox, Button, Dropdown List etc.
  • Used Java Script for the Client-Side Validations.
  • Worked on SQL Queries, Stored Procedures in SQL Server 2000.
  • Used CSS for applying different style attributes to HTML elements.

We'd love your feedback!