Pushpalatha Thammisetti

Project Description:

Enhance Cost of Care Platform with AI Predictive and proactive insights, deeper anomaly/outlier detections, and conversational self-service analytics with Gen AI capabilities.Enrich Enterprise Data Foundation with digitization of internal and external unstructured policies/contracts/manuals, improved claim-auth match and new data integrations.The platform enables broader/deeper insights and automated identification of CoC opportunities/ recommendations for users to take quick informed decisions and drive timely interventions/actions to reduce cost of care.

Roles and Responsibilities:

• Designed and implemented a POC utilizing Document AI in Snowflake to assess feasibility for policy document analysis and JSON conversion.
• Transitioned from Document AI to an internal AI tool due to technical limitations, ensuring continued automation and efficiency.
• Conducted in-depth analysis of PDF-based policy documents to extract key insights and generate JSON data.
• Led efforts to convert unstructured JSON data into structured formats, optimizing usability for downstream processes.
• Understanding the business requirements based on the Story description, Mapping documents and BRD documents.
• Attending daily scrum meeting with the Scrum master, Product owner, Architects and Business analyst teams to understand the requirement.
• Involved in Peer review for developed code within the team member to make sure that each requirement captured correctly.
• Create and trigger the Step functions to automatically trigger the Glue jobs which holds the Snowsql code.
• Version the code and push it to centralized code repository which is in bit bucket using git.

Project Description :

ElevanceHealth (formerly known as Anthem, Inc.) is a prominent health insurance company in the United States. The company provides a wide range of healthcare services, including health insurance, Medicaid, Medicare, and other health-related programs.Elevance Health is known for its strong presence in the healthcare and insurance industry, serving millions of members across various segments of the population. Cost of Care (COC) is a platform where every dollar spent on a subscriber or a member by elevance health can be tracked using dashboards.

Roles and Responsibilities:

• Understanding the business requirements based on the Story description, Mapping documents and design documents.
• Attending daily scrum meeting with the Scrum master, Product owner, Architects and Business analyst teams to understand the requirement.
• Done the impact assessment in terms of schedule changes, dependency impact.
• Tune the queries in such a way that the code meets the performance standards of the snowflake.
• Involved in Peer review within for developed code within the team member to make sure that each and every requirement captured correctly.
• Create and trigger the Step functions to automatically trigger the Glue jobs which holds the Snowsql code.
• Version the code and push it to centralized code repository which is in bit bucket using git.

Project Description:

ElevanceHealth (formerly known as Anthem, Inc.) is a prominent health insurance company in the United States. The company provides a wide range of healthcare services, including health insurance, Medicaid, Medicare, and other health-related programs.Elevance Health is known for its strong presence in the healthcare and insurance industry, serving millions of members across various segments of the population. Cost of Care (COC) is a platform where every dollar spent on a subscriber or a member by elevance health can be tracked using dashboards.

Roles and Responsibilities:

• Understanding the business requirements based on the Story description, Mapping documents and design documents.
• Involved in migrating the existing BTEQ scripts to SNOW SQL’s and also worked on the enhancements.
• Attending daily scrum meeting with the Scrum master, Product owner, Architects and Business analyst teams to understand the requirement.
• Tune the queries in such a way that the code meets the performance standards of the snowflake.
• Involved in a peer review for developed code within the team member to make sure that each and every requirement captured correctly.
• Create and trigger the Step functions to automatically trigger the Glue jobs which holds the Snowsql code.
• Version the code and push it to centralized code repository which is in bit bucket using git.

Project Description:

ElevanceHealth (formerly known as Anthem, Inc.) is a prominent health insurance company in the United States. The company provides a wide range of healthcare services, including health insurance, Medicaid, Medicare, and other health-related programs.Elevance Health is known for its strong presence in the healthcare and insurance industry, serving millions of members across various segments of the population. Cost of Care (COC) is a platform where every dollar spent on a subscriber or a member by elevance health can be tracked using dashboards.

Roles and Responsibilities:

• Understanding the business requirements based on the Story description, Mapping documents and design documents.
• Attending daily scrum meeting with the Scrum master, Product owner, Architects and Business analyst teams to understand the requirement.
• Worked on the impact assessment in terms of schedule changes, dependency impacts.
• Extensively Developed the BTEQ scripts, Mappings based on the mapping documents.
• Involved in a peer review for developed code within the team member to make sure that each and every requirement captured correctly.
• Worked on the Unit testing and also involved in the migration of code using bit bucket.

Project Description:

ElevanceHealth (formerly known as Anthem, Inc.) is a prominent health insurance company in the United States. The company provides a wide range of healthcare services, including health insurance, Medicaid, Medicare, and other health-related programs.Enterprise Data Mart is an analytic application supporting Enterprise Data Solutions Client reporting. Edward is the data warehouse which is source to EDM and the business users will generate the reports like AURA,CII on top of the EDM data. Future versions will also support Financial, and Clinical reporting. The EDM is a shared business intelligence service that provisions Edward data and other source data via a dimensional model. Data marts are provisioned from EDM for analytic reporting.

Roles and Responsibilities:

• Understanding the business requirements based on the DIM portal and Mapping documents.
• Participated in requirements meetings which will be given by Analytical resource team for understanding the business requirements.
• Work closely with BA’s/product owners in all phases of the software development cycle.
• Develop Test strategy, test plan/design, execute test cases for the DIMS.
• Extensively Developed the SQL queries, Mappings based on the mapping documents.
• Involved in approach document walkthrough calls with business people to get the signoff for the Approach document.
• Good experience in preparing the documentation like DB objects workbook, UNIX and Informatica objects migration documents (ICRF) forms.

Project Description:

ElevanceHealth (formerly known as Anthem, Inc.) is a prominent health insurance company in the United States. The company provides a wide range of healthcare services, including health insurance, Medicaid, Medicare, and other health-related programs.Enterprise Data Warehouse and Research Depot (Edward) is the enterprise-wide data warehouse that stores data from all regions and states across the corporation.Data feeds directly from Operational source systems. It loads data from different subject areas like Capitation, Chart of Accounts, Claims, Health Record, Health Risk Assessment, Medical Management, Membership, Provider, and Revenue, Lab, pharmacy, ETG, DRG which in turn will have many Source Systems like Claims has Facets, Aces, Star, NASCO, WGS, CS90 etc.

Roles and Responsibilities:

• Understanding the business requirements based on the DIM portal and Mapping documents.
• Participated in requirements meetings which will be given by Analytical resource team for understanding the business requirements.
• Work closely with BA’s/product owners in all phases of the software development cycle.
• Develop Test strategy, test plan/design, execute test cases for the DIMS.
• Extensively Developed the SQL queries,Mappings based on the mapping documents.
• Involved in approach document walkthrough calls with business people to get the signoff for the Approach document.
• Involved in Unit testing and Handover the SIT data to testing team.
• Involved in Production activities.
• Extensively worked on BTEQ,Teradata SQL Assistant.
• Finding the issues and reporting to the developers to fix the issues and followed the defect management cycle.
• Worked on Project management tool JIRA and also followed the Defect life cycle.
• Executed the regression test cases using DVO and iCEDQ tools.
• Involved in daily agile standups, retrospective meetings.
• Worked in an agile team, responsible for timely releases of the potential product at every sprint.