Tejaswi Kavuru

Client : Blue Cross Blue Shield of Michigan

• Working on large volume data spanning across 8+ Blue cross clients
• Responsible for the development and delivery of multiple concurrent projects/programs that encompass business process design and improvement
• Streamlined data analysis by implementing efficient BI solutions and tools.
• Supporting various initiatives in requirements definition, documentation of current and future state business capabilities, process development, process flows, training, and internal/external communications
• Recognized for brainstorming, leading and developing Risk360, a BI Dashboard developed for all Healthcare Plans which will display all member information like demographic, provider data, CPT, ICD and HCC-gap metrics
• Providing advanced analytical support for Risk Adjustment programs in following areas: Provider Engagement Coordination (PEC), In-home Assessments (IHA), Risk Adjustment Data Validation (RADV) audit, RAPS/EDPS submission, HEIDS audit, external reporting
• Assisting strategy team with claims data, provider data and member data
• Assisting Azure cloud data lake implementation with system testing and helping to figure the data discrepancies
• Developed and automated various RAPS/EDPS supplemental submission file process, Encounter Reconciliation process and CCL (Chart Chase List) preparation in optimit and ciox format
• Developing various reports, dashboards, scorecards, analytic solutions in Power BI
• Playing lead role in the research, analysis, identification, and evaluation of data from assigned problems to evaluate existing and potential trends and issues
• Initiating and leading problem-solving efforts working closely with internal and external stakeholders
• Creating KPI metrics per business needs which helped strategy team to take key crucial decisions
• Conducted training sessions for internal and external stake holders to help them understand the developed dashboards
• Converted SAS programs for recurring reports and analysis to SQL
• Assisting and mentoring other Data Analysts in the team.
• Evaluated new technologies and tools for potential application within the company''s analytics framework, ensuring continued innovation in the field of data analysis.
• Improved data quality by implementing stringent validation processes and enhanced data cleansing techniques.

• Designed analytics and assisting business owners of Commercial Lines insurance including Property, Auto, Umbrella, General Liability, Farm, Inland Marine, Cyber, Workers Compensation and Crime in driving consistent and measurable key results
• Partnered with teams across the organization (product development, marketing, etc) to understand their analytics needs and produce dashboards and analytics solutions that allow them to execute more effectively
• Analysis and reporting on agency and member data in retaining members and expanding the network
• Developed strategies in data extraction from variety of third-party sources to enhance member benefits and member retention
• Developed monthly reports to showcase the member trends across LOB and the profitability across them.
• Developed monthly reports to showcase the member trends across LOB and the profitability across them.
• Developed monthly reports based on ISO submission.
• Lead development effort in forecasting models, and report generation
• Played crucial role in migration of Mainframe to Duck Creek conversion project to derive strategies for state rollouts
• Conducted QA reviews to ensure consistency and integrity of dashboards that are being developed by the team
• Assisted business with the development of compliance-related reports and ISO reporting
• Worked with business on development of strategies using the Quote data for new member enrollments
• Produced adhoc dashboards/reports based on business requirements
• Supported data needs for internal and external customers
• Managed timely delivery of the reports.

Client: USAA

• Designed billing payment pattern reports utilizing Power BI
• Identified unique trends on delinquency and recommended solutions to retain the members
• Delivered comprehensive reports to business which helped them in taking decisions regarding state rollouts planned with migration of MSB to core logic conversion project.
• Designed, developed and managed performance metrics, reports, analysis, dashboards; drove key business decisions to managers
• Assisted business users with analysis by researching and providing monthly, quarterly and ad-hoc
• Prepared procedure documentation for operational support and consistency within the reporting team

Client : Blue Cross Blue Shield of Minnesota

• Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
• Assisted in the migration of legacy systems to modern platforms, ensuring seamless integration with existing workflows.
• Developed custom reports for business stakeholders, providing valuable insights into key performance metrics.
• Supported various ad hoc requests from end-users by delivering accurate datasets as per their requirements.
• Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
• Reduced processing time for ETL tasks through the implementation of parallel execution strategies.
• Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
• Collaborated with cross-functional teams for seamless integration of data sources into the company''s data ecosystem.
• Conducted extensive troubleshooting to identify root causes of issues and implement effective resolutions in a timely manner.

Client : Blue Cross Blue Shield of Minnesota

• Worked as cobol developer in various portfolios like Star Finance(claims) and New Membership and Billing
• Assisted in the Design for the Claims Migration Project to NASCO for Customer Service Application
• Worked in Requirement gathering, Analysis, Design, Coding, Unit Testing, System testing and Implementation of various enhancements using COBOL, JCL, VSAM, IMS DB/DC, DB2, CICS,TELON etc
• Performed lead analyst role to complete technical systems design for new and enhanced systems.
• Assisted the business in answering the technical questions and completing various service requests or Change Requests for them.
• Collaborated with cross-functional teams to design, develop, and implement new applications using COBOL.
• Assisted in the successful migration of critical business processes from legacy systems to modernized platforms, utilizing extensive COBOL knowledge.
• Lead team, assigning them work, reviewing the code and Unit Test results