Praveena Karanam

• Associate with partners and users to articulate business needs to inform appropriate reporting strategies. • Write intricate SQL stored procedures by extracting data from disparate sources to create reporting tables. • Perform analysis using EMR, payer claims and eligibility data, communicate the actionable information to senior leadership, thus facilitating their decision making. • Develop user-friendly dashboards using Tableau and Power BI to help the management better visualize and comprehend the trends in data. • Designed an Executive summary dashboard that enables the users to understand the dollars lost and gained by Providence Health in various categories for different performance years. • Instituted a dashboard for the use of regional executives to compare the actual PMPM (per member per month) costs to the PMPM target for a fiscal year across regions, thereby determining the gain/loss statistics. • Experience working with the Bundled Payments (Episode Payments) model data.

• Researched online and visited nail salons to understand the current business model, process, products, topology and the extent of use of technology in the nail salon industry • Analyzed every aspect of nail salon industry and created a technology solution that would help in innovating the business process • Designed an Entity Relationship diagram to integrate all elements of a nail salon on to a single platform which facilitates Customer and Employee Management, Retail and E-Commerce, Inventory Management, Budget Planning, Traffic Prediction and Efficient marketing strategies

• Worked primarily on Health Care Analytics projects to help a leading US National Health Payer transition from Volume to Value base care by performing SDLC activities • Performed requirement analysis, test strategy creation, test planning, test execution and stakeholder management • Devised a test strategy, created in detail test cases based on test scenarios and mapped the test cases to the business requirements • Ran and monitored Informatica workflows to load data into extracts • Wrote complex SQL queries in Teradata to perform Unit Testing, System Integration and Regression Testing • Extensively used different defect tracking tools like Rational Clear Quest, Rational Team Concert and Jira to log defects and delivered defect free code to higher environments like UAT and Production • Validated and delivered multiple modules and change requests on time with 100% readiness and accuracy • Used ETL tools to test the code that optimized the run time and improved the performance by 20-30% • Coordinated with the onsite team for multiple tasks and gave client presentations demonstrating the test strategy and test cases • Extended my support to the team on many occasions and handled critical stakeholders with perseverance, on a tough assignment • Provided training to the new joiners in the team and guided them through the work • Planned Agile project implementations through scrum meetings, sprints and retrospectives • Generated and maintained daily and weekly executive reports for clients and internal management