Nithya Vijayan

There are multiple projects related to reporting at Providence Health Plan. One of them is a Weekly Funding Report that uses multiple data sources like Salesforce and Facets. Another major system replacement was Accounting of Disclosure (AOD), where the system was upgraded with newer reporting systems. The software development methodology used is Kanban and Agile Scrum.

• Developed training materials, SOPs and work instructions to supplement new team member onboarding.
• Write SQL queries to pull data from Enterprise Data Warehouse (EDW) and the backend tables to identify, analyze, and interpret trends or patterns to design better systems using Microsoft Visual Studio.
• Create and manage business requirements and backlogs in Azure DevOps.
• Worked on different data architecture layers such as ETL integrations, data processing, Mapping, Data Visualization, Data Modelling, and REST API’s.
• Discuss the issues faced by the operations team and perform root cause analysis including researching issues with applications, systems and processes and overseeing the resolution.
• Create test cases to complete the system tests and run the test cases in the web applications in AWS environment, thereby uploading the test cases once they pass in Azure DevOps.
• Actively involved in conducting reviews, walkthroughs and facilitating in requirement definition workshops (JAD) to get consensus on business requirements for the project.
• Analyzed and assessed client requests to create professional, presentation quality deliverables in the form of dashboards & reports to provide additional insight to any critical indicators.
• Developed UML Models using MS Visio.
• Presented the business process workflows to business stakeholders.
• Tasked with coordinating, tracking and updating project issues, risks and change controls that impacted the business unit.
• Run Ad-hoc reports for management, as well writing SQL queries on MS SQL Server 2008 R2 and upload reports on SharePoint site.
• Documented API, XML and BATCH file transfer process requirements to maintain information.
• Assisted QC team to ensure requirements are translated into executable Test Plans and strategies.

The project was based on creating an effective new system for the State of California Air Resource Board (CARB) called Integrated Multi-Pollutant Emissions System (IMPEI) which is user-friendly and able to access the system in different environments. This system also generates multiple reports for the ARB users, in case of any analysis. The software development methodology used was Agile Scrum.

• Collaborates with vendors and business teams to identify and develop key performance indicators (KPI's) that assisted in creating KPI's with realistic targets that can easily be quantified and measured.
• Write SQL queries to pull data from Enterprise Data Warehouse (EDW) and the backend tables to identify, analyze, and interpret trends or patterns to design better systems using PgAdmin.
• Create Data Mapping documents to direct the development team to the backend tables, from where they can fetch the data.
• Create and manage business requirements and documentation.
• Discuss the issues faced by the operations team and perform root cause analysis including researching issues with applications, systems and processes and overseeing the resolution.
• Perform Manual Quality Analysis once the modules are deployed in the testing and the production environment.
• Create test cases to complete the system tests and run the test cases in the web applications in AWS environment, thereby uploading the test cases once they pass in Azure DevOps.
• Monitors alignment to KPI's and escalates required corrective actions.
• Used data processing for ongoing activities and assist with resolution of participant issues including the timely and complete close out of participant cases.
• Verified the inspection data for possible data quality issues.
• Collaborated with operation manager to align reporting objective & analytic reports requirements.
• Ran performance tuning and optimization of large databases for fast accessing of data and reports.

CWOW (Center Without Walls) is one of the major ongoing projects to build reports and dashboards for DaVita clinics. The other major project is MedSleuth Breeze, an organization bought by DaVita LLC. This project is based on integrating the MedSleuth system with DaVita’s Single-Sign on (SSO). Also, Clinical Conductor was another project that I worked on, alongside MedSleuth and CWOW, which is based on connecting the Clinical Research team to the Accounts Payable team to make sure the research participants are paid on time. Alongside, worked on other small production support, Data Integration and Data analysis projects which involved connecting with the business and architecture teams. The software development methodology used was Agile Scrum, SAFe Agile and Waterfall for each project.

• High visibility as liaison between the business line, users, and the development teams throughout the project cycle.
• Create and manage business requirements and documentation.
• Performed Quality Assurance testing and created test cases, strategies and test plans before and during the UAT hand-off, making sure of the quality standard and metrics are measured and maintained.
• Create Data Mapping documents to direct the development team to the backend tables, from where they can fetch the data.
• Worked intimately with business domain to gain full knowledge of the flow of business.
• Scheduled JAD sessions with impacted team members.
• Held interviews and brainstorming sessions for requirement analysis, and to define business and function/technical specifications
• Conducted Gap Analysis by identifying the strategic objectives.
• Analyzed the AS-IS system for wire transfers users deficiencies to correctly identify a cost effective and efficient future state.
• Participated in UAT and developed test cases for unit testing based on functional specifications.
• Collected data for internal users to track interaction between user and system.

SCAN Health Plan was replacing the existing Clinical Systems and some of the Customer Relationship Management systems with two efficient systems named Agent Cubed and MedHok respectively, to perform the Clinical and CRM related activities. This project utilized a hybrid approach of both Waterfall and Agile. Some of the dashboards were developed by the in-house Tableau Development Team and others by the SSRS developers. The software development methodology used was Agile Scrum.

• Acted as a liaison between regional executives, direct users, client managers and software development team to gather requirements.
• Gathered user requirements for mapping data flow process analysis.
• Created mapping document in iteration for performing outlier analysis and provided developers knowledge on the business requirements and use cases.
• Made Use Cased diagrams for process documentations to assist stakeholders.
• Used MS Visio for data modeling.
• Tested SQL queries for maximum efficiencies.
• Produced weekly status reports for business teams to understand updated reporting system
• Created Data Dictionary document and wireframes for Tableau dashboards to show trends over time.
• Performed Quality Assurance testing, created test plans, came up with different test strategies before and during the UAT hand-off.
  

This project was to provide enterprise data warehouse reporting for some of the Southern California Hospitals contracted with Alta Hospital Systems, a sister company of Prospect Medical Holdings.

• Initially engaged as a Senior Business Analyst, then promoted into a Project Manager role because the client wanted a hybrid resource who could perform both PM and BA activities.
• As the point of contact and bridge between Clinical Analysts, users, and the Developer, understood the requirements from the non-technical users and assisted the Developer in converting them into meaningful reports.
• Created BRD, cut-over plans, and test cases and was responsible for automated and manual creation and submission of clinical reports, both ad-hoc and scheduled.
• Guided SSRS developers on new reports in queue to be automated on a daily, weekly, and monthly basis and used IBM Cognos to create some of the data warehousing reports for the clients.
• Worked with AEM guides and DITA XML for Component Content Management System (CCMS) to improve the overall user (patient and provider) experience with consistent data collection, data-driven decision making and simple administrative tasks for the users to complete.
• Prepared requirements documentation, process flow documentation, and test documentation.
• Assisted the developers in prioritizing the different types of reports in their queue.
• Conducted test sessions for the requestors on how to use the reports and the dashboards.
• Prepared documentation on the usage and workflows of the reports.
• Prepared technical documentation for the IT team on the Allscripts workflow.

This project involved the EDI teams of Cigna to make decisions on the fields and segments used, number of claims and transactions for HIPAA compliant 834, 270/ 271 and 837 professional and dental EDI messages. With the acquisition of Great West Insurance, this project also involved a migration process including configurations, claims auto adjudication scope and definitions, financial transactions ID cards, Membership, Enrollment, EDI 835, 837I, 837P, 276/277, 278 and proprietary conversions utilizing the right extensions and development of new scripts in order to meet proprietary origination formats and reformat them into HIPAA standardized formats.

• Implemented best-practice methodologies that improved overall project delivery timelines while maintaining quality standards.
• Supported software development projects by defining clear requirements and effectively communicating them to technical teams.
• Interacted with internal customers to understand business needs and translate into requirements and project scope.
• Optimized workflow processes to enhance overall productivity and achieve operational excellence.
• Conducted GAP analysis and prepared methodology documents for implementing 834 & 837 transactions after multiple meetings with the clients and knowing their business requirements.
• Led detailed business discussions with payers and providers based on CMS guidelines for mapping HIPAA transactions including 835, 276/277, 278, 270,834, and 837 (Institutional, Professional & Dental)
• Designed a detailed plan for identifying the key deliverables and deadlines.
• Developed use cases, test scenarios, and test cases for testing the functional and non-functional elements
• Facilitated JAD and JRP sessions with Management, Development team, users, and other stakeholders to refine functional requirements.