Rao Raza

· Worked as Lead Business Data Analyst in data tracing team to gather, document and analyze tracing information for over 1k+ data labels across various frontend & backend systems.

· Compared and grouped tracing components across screens and identified process gaps, process enhancements and system enhancements opportunities.

· Identified discrepancies, gaps and inconsistencies across various client and agent systems including Web, Atlas, IVR & EICE

· Used MS Excel for data analysis including formatting, trend identification, complex formula creation and automation of key data.

· Leveraged SQL and Python to analyze API responses, endpoints and scripts/queries enabling the identification and resolution of potential API data issues impacting customers.

· Managed and updated Excel worksheets in a SharePoint environment, facilitating collaboration and multitasking within the team.

· Working with Web/BI developers and DBAs to identify the correct parameters for API endpoints, variables and SQL queries.

· Analyzed and validated business logics and client-side logics to determine what and how data should display. Identify instances where similar labels display different information

· Testing systems on historical EPROBs remediation as well as identify new EPROBs

· Identified and documented frontend system screens for Web, Atlas, EICE and IVR.

· Coordinated with developers and analysts to gather and standardize data lineage mapping for the captured (in scope) labels.

· Performed data validations across systems and in Oracle using SQL queries.

Analyzed, cleansed, and standardized various business logics and transformations to check inconsistencies, errors and fallacies.

Environment: Oracle SQL Developer, Snowflake, JIRA, SharePoint, MS Excel, ATLAS, Teams, Power BI, Beyond Compare

Worked in Enterprise Data Management team in process of maintaining optimal data flow to cater to the requirements of business and external vendors

· Worked with business, developers and business analysts to understand, document, and refine business requirements and data availability scenarios

· Prepared and maintained data mappings, requirement traceability matrix, test planning documentation, test scenarios and test cases to ensure business acceptance criteria is met and it covers all integration points and business requirements.

· Define data needs, scope and impact in partnership with technical teams.

· Executed test cases covering all scenarios and document test results with defects in JIRA

· Coordinated with Business Intelligence and reporting team in understanding and refining business and functional requirements

· Extracted, analyzed and validated huge flat files using unix scripts, UltraEdit, Python and R.

· Part of the team to generate the monthly and yearly flat file extracts to be submitted to DHCS and other agencies.

· Involved in team’s meetings to ensure continuous improvement in data extraction, transformation and loading architecture and processes.

· Planned and performed data analysis and data quality analysis between various sources against data lakes.

Analyzed and validated extracts in flat files generated periodically or ad-hoc for the external vendors including Optum, Syntranet etc.

· Analyzed and validated various PL/SQL packages in Oracle for functionality and business logic.

· Ingested flat files and validated for business requirements and data validation from file-to-table or file-to-file using Python, Excel and SQL developer.

· Prepared and updated testing artifacts including test plans, test strategies, test cases and RTM

· Analyzed and validated data transformations and business logic by creating scenarios and preparing data.

· Used Unix shell scripts and WinSCP to access and update the parameter files for various projects.

· Used JIRA to track tasks and defects repository up-to date. Scheduled and participated in SIT and UAT test defects meeting to discuss which resource opened and logged the defect and determined the state of the bug is, whether Active, proposed, or closed.

· Coordinated and communicated with UAT testers and business users regarding their expectations, test approach, data availability and test results

· Used Excel's vlookup and pivot functions to analyze member and provider data and created pivots to easily access and validate data for ad-hoc analysis.

· Provided valuable inputs in development of interactive dashboards and visualizations of financial and healthcare data using OBIEE and Tableau.

· Identified PII for healthcare data across tables in data warehouse and used Delphix engine to execute and validate data masking.

· Investigated data sources, data mining, data profiling for BI projects

Environment: Oracle SQL Developer, SQL Server, Informatica, JIRA, Informatica, Tableau, OBIEE, UltraEdit, Python

Worked as Data Quality Analyst in SAP BPC and SAP BW environment. The scope of project covered end-to-end transfer pricing activities within Microsoft group. As a Data Quality Analyst, I was responsible preparing and executing test plan, test scenarios and data validation in SAP BW & BPC reporting environment.

· Tested newly developed Data sources, Business Objects, DSOs and cubes and mapped them with the source.

· Prepared reporting documents including Business Requirement Documents, Technical Specification document, Functional Specification document, End-to-End mapping and Process Flow documents.

· Test data loads from the source cube against BPC cube.

· Tested the data mapping, transformation, and conversion of the reports data and executed the monthly excel reports into SAP BPC Workbooks and Dashboards

· Created Test scenarios and Test Cases for BW data warehouse tables and BPC reporting

· Provided expertise in the planning, construction, and execution of test scripts.

· Tested input files and flat file extracts for data validation and compared them with the BPC reports

· Led and managed offshore meetings, assigned them daily tasks and reviewed their work.

· Applied business and functional knowledge including testing standards, guidelines, and testing methodology to meet the team's overall test objectives.

· Uploaded the Test Scripts and Test Scenarios using Test Case Migrator tool.

Created the test plan and Test case document and updated the Master Test Plan based on the requirements and meetings with the developers and business users

· Provided detailed testing summary status to Test lead and provided the status of number of Active, closed, and blocked tests.

· Track defects to closure and keep defect repository up-to date. Scheduled and participated in SIT and UAT test defects meeting to discuss which resource opened and logged the defect and determined the state of the bug is, whether Active, proposed, or closed.

· Performed BW data validation structural and functional testing.

· Validated and Performed the Performance Testing for BPC - Data Load, Volume Testing, Testing for BADI, BW Volume Testing

Environment: SAP BW, SAP BPC, SQL Server, SSRS, Excel-EPM, JIRA