Vijay Veluri is the Director of IT at Imagine Communications in Frisco, Texas.
Monarch allows Vijay to quickly create custom reports for the business analysts in his organization.
Vijay is now demonstrating Monarch’s ability to wrangle data from disparate sources to other departments at Imagine Communications, including Order Operations and Supply Chain.
My name VJ Valorie. I’m the Director of IT with Imagine Communications corporation based in Frisco, Texas. Imagine is a leader in the broadcasting segment. IPTV is catching up, so we provide solutions, both hardware and software solutions in that sphere. There are a lot of tools available but the quickest way to get on board and something to present to the users, I think the Monarch is the tool to kind of meet the perfect requirements for the users. Because they look at different reports and they say, “I want these fields, I want these fields, I want these fields from these reports,” and Monarch is perfect because it helps to trap the required elements from each of these report and give to the users. And best part is it takes shorter window to just deliver the report to the users. The tool itself has lots of flexibility. There are regular expressions. There are little advanced feature about it helps you to filter through a large chunk of data and just do a filtration in a quick fraction of a second for you. So, it’s all about how well you are conversed with the tools, and if you leverage these advanced functions your ETL, the data massaging is very quicker than what you think. And also you can’t go wrong with these regular expressions. That’s one thing that I would encourage lot user coming in to just focus on these regular expressions than the simple user-built functions. Think about your invoice numbers, or transaction numbers, or … There are a lot of special characters. I mean, data is structured or unstructured and they come with wide variety of problems. You want to trim off certain things, some trim off some extra spaces, and regular expressions are the way to go. I mean, they just churn through large chunks of data, even like gigabytes of data, and just get you the right data in the right format for you, and quicker. I think that’s the very advantage of that. So, it’s nine dodects but today I went through the 14 version so I think there’s lot of enormous capabilities out there, so our next plan is to just upgrade, and also look forward to the road map and … That means to, a simple transform to visualize. I think it’s a great tool by itself. So, this is something, you know, in quick, short time you can load the data from various systems, structured and unstructured data as I said and then get to the reports that users want in a short want in a short window of time, so it’s a great tool. So, I think to get them the data that they want in the fashion they want, I think that’s the challenge that helps me solve for that. We started like mid of last year and so far the experience is great, and we want to extend that to not just the finance community now, we can do way beyond that. So, now we’re trying to do some demos for other users like in the order operations, supply chain, to make sure … “Hey, this is great opportunity for you. You want something to look at …” One other thing that I learned today is the web scrape. That means looking at the website, there are a lot of screens that some of the ERP systems have so you can scrape the data from there and then show it to them. And that’s easier way for them to export and then drill something. Especially during the month-end times they want to collect all data, and this is way quicker than any other tools out there in the market to my knowledge here.