This is the second of two posts on “Off the Grid” Days.
The first post showcased the event and the first annual Paul Vienneau Award winning Invention.
Bet those boys from Belfast are happy they missed Winter Storm Nemo…and Frank probably is, too, cause pub crawls on snow days can get expensive. And for those of you who are worried, Pirate Horse is still vacationing on his prize money in Vietnam, so he’s fine (see end of post for details).
First Place: NaviCon: On-the-Fly, Real-Time Product Configuration—Kevin Waite, Adeel Sheikh, Prasad Manam, and Surinder Dhall
LM: Hi, Kevin. Congratulations to you and the team. What did you all set out to accomplish with NaviCon?
KW: This application encourages both NaviNet and Health Plan Project Team members to become NaviNet end users by providing a means to make on-the-fly configuration changes to the product (i.e., Eligibility and Benefits, Claim Status Inquiry, Plan Central, Logos, etc.).
LM: This solution increases efficiency, right?
KW: Yes. The application is super easy to use, and configuration changes no longer require intervention from developers. This feature empowers health plans to make real-time design decisions based on their business needs.
LM: What do you envision as a future capability?
KW: In the future, configuration options would be based on the user’s role.
Second Place Tie: Flipping the Provider Model on its Head—Evgueni Souvorov
LM: Hi, Evgueni. Great news on winning! Why do you want to flip the provider model on its head?
ES: The project goal is to provide an alternative solution to the data-loading process, data management, and reporting. The current data-loading process is complicated, cumbersome, manually intensive, and inaccurate. Reporting is based on several databases and, thus, lacks a single point of true and self-service reporting capability. As well, I want to demonstrate capabilities of the new features of MS SQL Server 2012 and create Master Data Management Hub using Master Data Services (MDS). The solution includes the elimination of redundant features as Oracle CRM and BizTalk and replacing them with SSIS packages for data loading and MDS for data management.
LM: How did you achieve that?
ES: I created a data model for MDS and populated it with sample data. I also created a data warehouse model and SSIS packages to populate the data warehouse with the data from the NaviNet Core database and transactions. To make reporting easy, I created a cube for canned reports and PowerPivot reports to demonstrate the self-service capability.
LM: What was your surprise learning?
ES: Surprisingly, the current system may be replaced with the simpler and easier controllable system in a relatively short period of time.
Third Place. Create a Plan Central Upload Administration Transaction for Health Plans to Manage Their Own “Plan Central” Content—Peter Nikolov, Neha Goel, and Nadia Edoh
LM: Hi, Nadia. Great work! Would you tell me a bit about your team’s project?
NE: The goal of the project was to come up with a process to streamline the Plan Central Update process, empower the plan, and alleviate NaviNet Customer Support. When staff changes, plans run into all kinds of problems: For example, users aren’t too familiar with where and when to upload files, and files are uploaded in an incorrect format. Plans don’t have the ability to verify their work and how things will appear in NaviNet, so they often load the files and then realize that things don’t look as they were expecting.
Today, NaviNet Production Support is involved in current Plan Central Update process. They have to log onto a production server, run jobs, and refresh cache manually. The new Upload Plan Central Files transaction has the following benefits: There is no NaviNet involvement, which saves a lot of Production Support time and effort. It eliminates the need for dropping files to FTP folders. Content is secure: User privileges are assigned, so only authorized people can access content. In addition, files for more than one office classification can be submitted and previewed at the same time. Finally, it’s easy to revert back to a default Plan Central.
LM: Those sound like significant enhancements. How did you do it?
NE: This was Peter Nikolav’s idea. He had shared the idea with Neha and me. Our team got together to discuss the idea in more depth and exchange ideas on how best to design it. We divided up the work, regrouped, and then focused on the improvements that surfaced during the day.
LM: Were there any surprise learnings?
NE: We were not expecting to modify our solution as described initially; however, once we started working on the demo and talking through things as a team, we came up with new functionality within the transaction to improve the workflow and user experience. We worked very well as a team.
And where has our loyal Pirate Horse been, you wonder? According to Tony Leopold, Senior Software Engineer, Belfast, who, with team members Karsten Nielsen, Mark Patience, Gareth Armour, and Rodrigo Blanco, is the inventor of Ye Olde OrgEntities Buccaneer: Or How I Learned to Stop Worrying (About SQL)...and proud custodian of said noble nag:
What do you think about Off the Grid Days? Any of our prize-winning projects? Are you an inventive genius, too? Want to help Pirate Horse spend his treasure? Continue the discussion by commenting on our blog, and connecting with us on Twitter, Facebook, and LinkedIn.