Summary
Overview
Work History
Education
Skills
Technicalsummary
Projects
Timeline
Generic

Sanjana Madari

Des Moines,IA

Summary

Goal-driven Facets Project Associate with a comprehensive background in healthcare management system upgrades. Proficient in current industry standards such as Medicaid, Medicare, FACETS, HIPAA, and other supporting applications for insurance providers and service providers. Proficient in navigating the intricacies of the Facets platform, with a deep understanding of healthcare industry standards and compliance requirements. Skilled in orchestrating end-to-end project lifecycles, from requirements gathering and analysis to implementation and post-deployment support. Experienced working in Facets online modules such as Billing, Provider, Claims, and Membership modules, with a strong understanding of the FACETS Data Model. Eager to contribute my expertise in healthcare technology and analysis to advance the mission of your company in delivering exceptional solutions and driving organizational success.

Overview

6
6
years of professional experience

Work History

Project Associate

Wellmark Blue Cross and Blue Shield
11.2022 - Current

• Perform in-depth analysis of upgrade defects and features, encompassing custom code,core impacts, and database implications.

• Orchestrated cross-functional approvals from diverse business modules including Billing,Claims, Membership, Network Economics, and Provider, ensuring project alignment with technical requirements.

• Engineered efficient SQL-based solutions, augmenting the robustness of the Facets system.

• Delivered comprehensive technical assistance to Quality Assurance teams during testing phases, expediting issue identification and resolution.

• Coordinate smooth deployment of upgrades into production environments, ensuring adherence to technical specifications and minimizing downtime.

• Conduct rigorous validation of core system components post-upgrade, encompassing verification of all Facets front-end screens, runbooks, templates, SQL compatibility, database cardinality, and seamless deployment of custom code modifications.

• Offer post-deployment technical support to resolve production issues promptly and maintain operational integrity.

Project Associate

Wellmark Blue Cross and Blue Shield
11.2020 - 11.2022

• Collaborate with business stakeholders in requirement-gathering processes and effectively communicate project needs to offshore teams for streamlined execution.

• Reviewing the quality of code for the mission-critical internal web application ensuring compliance with the company coding standards

• Involved in the configuration of the FACETS Subscriber/Member application and worked on FACETS Data. Have good knowledge of FACETS business rules.

• Worked with a cross-functional and diverse team of business users and developers to enable accurate communication of requirements and ensure consensus for BRD and FRD

and business docs.

• Compile SQL Queries to validate the data integration between the various Database tables. Also involved with Planning, designing, and implementing application database code objects, such as stored procedures and views.

• Worked closely with the business team, development team, and the Quality Assurance team to ensure that desired functionalities have been achieved by the application.

• Assisted the project with Change requests and held responsible for weekly changes to the applications. Maintained and recorded the ticket numbers for request changes on CR manager tool.

• Worked with Facets TriZetto Batch Scheduling and monitored daily for updates in various domains of the Facets.

• Worked in the healthcare sector managing different healthcare claims for various providers and updating the database for various changes for the same.

Computing and Teaching Assistant

Fairleigh Dickinson University
09.2018 - 05.2020

• Maintained databases for student records. Performed update and delete operations.

• Responsible for contacting faculty teaching undergraduate statistics and methods to

request access as Graduate Assistants to their D2L pages.

• Co-written papers by the professor and conducted and performed experiments for the

professor.

• Helped students with various errors in technologies like Linux, AWS, Java and Python.

• Provide telephonic support for a variety of technical problems like computer software

installations, updates hardware support and user access issues.

• Scheduling meetings and appointments and being a point of contact for a range of staff

and external students.

• Conducted independent research under the supervision of a faculty member and

provided support to a faculty member's research program.

• Writing and issuing emails to teams and departments on behalf of teams or senior staff.

Education

Master of Science in Computer Science -

Fairleigh Dickinson University

Bachelor's in Information Technology -

Gokaraju Rangaraju Institute of Engg & Technology, India

Skills

  • HTML
  • SQL/MYSQL
  • PL/SQL
  • XML
  • NET
  • Quality reporting
  • Presentation skills
  • Linux
  • Putty
  • GitHub
  • Agile
  • Waterfall

Technicalsummary

HTML, SQL, PL/SQL, XML, .NET, TOMCAT, HTML5, CSS, Linux, JavaScript, Oracle, Shell Scripting, Textpad, Putty, UNIX, MS Access, MY SQL, GitHub, Agile, Waterfall, Amazon Web Services, Technical design document (TDD), Functional design document (FDD), Document Analysis

Projects

Implemented and designed Inventory Management system Designed a maven project using ansible playbooks and deployed through Jenkins. Developed a Library Management SQL project Used AWS services for various EC2 configurations and running putty systems for implanting Linux projects. Utilizes AWS services like IAM, S3, EC2, VPC and CloudWatch.

Timeline

Project Associate

Wellmark Blue Cross and Blue Shield
11.2022 - Current

Project Associate

Wellmark Blue Cross and Blue Shield
11.2020 - 11.2022

Computing and Teaching Assistant

Fairleigh Dickinson University
09.2018 - 05.2020

Master of Science in Computer Science -

Fairleigh Dickinson University

Bachelor's in Information Technology -

Gokaraju Rangaraju Institute of Engg & Technology, India
Sanjana Madari