I'm a Senior Business Systems Analyst for a pharmaceutical company in central NY. I've only been here for a few weeks so I'm still figuring things out. I have a Masters degree in IT along with several certifications in Data Analysis and Visualization. My background has mainly involved working with enterprise-level financial software, writing reports, finding process efficiencies and automation, and data mining, manipulation, and presentation.
1. The biggest challenge I'm currently facing is automating and visualizing (dashboarding) as much of our reporting as possible. Working with the data isn't the challenge - it's extracting the data in the first place that poses the biggest hurdle because we're using JD Edwards and we don't have views or a reporting tool so we must write our own SQL queries. If you've ever attempted to directly query an Oracle database then you know how convoluted that can be!
2. Probably I'd want to master JD Edwards so that I better understand the data flows and how all the pieces of information are stored and related to one another.
3. I am curious to learn about scheduling SQL reports to run automatically, which I've been told QuickBase is capable of but I have not yet seen this functionality myself.
------------------------------
Paul
------------------------------
