Rishitha Vancha Email & Phone Number

Houston, Texas, United States

• Processing data from tools such as Snowflake and writing complex queries in SQL or SAS using complex joins, sub-queries, Table creation, Aggregation, and using concepts of DLL, DQL and DML.• Developed Complex Mappings for creating match-merge reports for ACO Provider.• Tuned performance of Outbound ETL. Performed CDC based on MDM last update date, which is indexed and maintained by MDM. Used the parameterization template mapping/session for each base object and had that as first task in the Workflow.• Predictive analytics, healthcare fraud detection and prevention methods, using R/SAS Enterprise miner/machine learning. Worked as production support team to resolve production issues caused by data, UI code and backend code.• Tuned performance of Informatica session to optimize the EMPI data load to landing process. Created Pre-Landing tables in Oracle and bulk loaded them. Used SQL Transformation in Informatica Designer to populate the data from Pre-Landing tables to actual Landing tables.• Created mappings for loading data files received from different Sources like ECHO, HMS, and CLARITY, worked with different kinds of input files like CSV, XML, Tab delimited files.• Created Views which were used by Micro-Strategy team to display Provider data in the portal.• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.• Used PL SQL stored procedures as part of mappings to improve performance.• Configured match rule set property by enabling search by rules in MDM according to Business Rules.

Houston, Texas, United States

• As a Data Analyst, generated Data Models using Erwin and deployed them to the Enterprise Data Warehouse.• Gathered system specification requirements via JRD sessions with business users and SMEs. • Participated in data warehouse business analysis, from conceptual to physical design of data marts. • Created multiple graphs for business analysis and reporting. Collaborated with domain experts to analyse risk and maintain large datasets as a BI Analyst. • Developed data warehouses from operational source systems for data analysis. • Elicited requirements through interviews, document analysis, surveys, and workflow analysis. • Created detailed data mapping documents to define ETL transformation logic, source-to-target data flow, and business rules. • Worked with business analysts and data engineers to translate business requirements into technical specifications for accurate data integration. • Utilized data integration tools (Azure Data Factory, Informatica) to automate data ingestion from multiple sources into centralized repositories. • Developed advanced dashboards visualizing key metrics (CAC, LTV) for actionable insights. • Performed logical and physical data modelling based on business rules and data sources. • Conducted gap and impact analysis to assess system deficiencies and define new requirements. • Administered and optimized ETL processes in ODI, ensuring timely data loading into OAS for analytics. Customized GA4 configurations for enhanced data capture and reporting for e-commerce activities. • Optimized SQL queries, utilized T-SQL stored procedures, and developed complex SSRS reports for business analysis.

• Worked Visualized KPI metrics like resource utilization, net profit margin, gross profit margin and burn rate using Tableau.• on time series analysis using Pandas to identify patterns on how asset variable changes which in turn helped project completion by 70%.• Recommended solutions to increase revenue reduce expense, maximize operational efficiency, quality, compliance, etc.• Identified business requirements and analytical needs from potential data sources.• Performed SQL validation to verify the data extracts integrity and record counts in the database tables• Worked with ETL developers for testing, mapping data and aware of data models to translate and migrate data.• Created Requirements Traceability Matrix (RTMs) using Rational Requisite Pro to ensure complete requirements coverage with reference to low level design document and test cases.• Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs. Also, assisted on project expectations and in evaluating the impact of changes on the project plans accordingly and conducted project related presentations and in performing Risk Assessment, Management and Mitigation.• Collaborated with different teams to analyze, investigate and diagnose root cause of problems and publish Root Cause Analysis Report (RCA).• Achieved in using advanced SQL queries and analytic functions for date calculations, cumulative distribution and NTILE calculations.• Used advanced Excel formulas and functions like Pivot Tables, Lookup, If with and/index, match for data cleaning.• Extract data from various data sources and prepare interactive dash boards utilizing various kinds of charts, graphs and filtering data using logical filters and publishing them.• Involved in Exploring, Designing, Building, and Deployment of the high-level dashboards for Board of Directors, Decision makers for critical metrics using Tableau.