Oracle Demantra Technical Specialist

Company Description  For more than 70 years, The Nature's Bounty Co. has enriched the lives of consumers around the world and stood as the leader in health and wellness by introducing innovative products and solutions to the marketplace. Putting science and the highest quality standards at the heart of our business, the brands of The Nature's Bounty Co. are some of the most trusted in the world. Always motivated by nature's bountiful effects on people's health, our vision for health and wellness has inspired leading brands such as Nature's Bounty , Sundown Naturals , Solgar , Osteo Bi-Flex , Ester-C , MET-Rx , Pure Protein , Balance , Body Fortress , Puritan's Pride and Organic Dr. , among others. As a leading global manufacturer, marketer, distributor and retailer of vitamins, nutritional supplements, sports & active nutrition and ethical beauty products, The Nature's Bounty Co. is committed to supporting wellness in all its forms. Job Description  This position is within the IT organization reporting directly to the Business Relationship Manager for a particular area/function of the business. The role will assist key leaders with determining opportunities for automation of processes and functions to achieve the strategic business objectives.  Qualifications  o       Bachelor's degree in computer science or relevant field          o      Under direct supervision, manages vendor relationships. Ensures vendor SOW deliverables are met while tracking project budgets, timelines and resources. o       Must understand project plans. Participates in project management status meetings as well as provides the corresponding updates.  o       Supports minor enhancements i.e. report changes, data extracts, etc. o       Works with users to trouble shoot and resolve issues, answers business questions, provides data analysis and works with Platform Management team to build future enhancements.  o       Responsible for task management and tracks action items to completion. o       Participates in SIT (System Integration Testing) and coordinates and engages in UAT (User Acceptance Testing). o       Documents business and minor system requirements, organizes requirements into standard document templates and participates in requirement gathering meetings. o       Profiling of data to assess data quality, works with business to improve data quality, and presents results and makes preliminary recommendations to management. o       Assists with meeting facilitation, communicates between IT, the business and our vendors to provide status updates with respect to SOW alignment and requirement fulfillment. o       Assists with end-user documentation and training. o       Must have good understanding of the following Oracle Demantra capabilities: Understanding of the demand management principles. Navigation and personalization of the collaborator workbench and worksheets creation and deletion. Understand series and time dimension as well as create/modify worksheet filters. Understand hierarchy levels and add/remove worksheet series. Filter and customize worksheets to different hierarchy viewing levels. Understand forecast accuracy and exceptions at various levels of aggregation. Troubleshoot Demantra issues including user access, java related and aggregation level related. o   Understand user groups in relationship to worksheet series access. o   Statistical Engine Tuning understanding and how it relates to forecast accuracy. o   PSQL programs and Packages o       Must be able to understand PSQL scripts and collaborate with support partners in the development of new functionalities. o       Must be able to perform analysis and comparisons of large data sets in Microsoft Excel o       Must be able to create/execute SQL scripts in an Oracle platform. o       Must be able to create Tableau reports. o       Mast be able to create medium complexity Excel spreadsheets which include the following: o   Pivot Tables o   Graphs and Charts o   If & VLOOKUP functions o   Import csv, txt, & data files into Excel o       Must be able to collect business requirements and draft business requirements documentation in MS Word. o       Must be able to create Power Point Presentations which may include the following o   Charts o   Visio Diagrams o   Spreadsheets o   Captured screen prints o       Must be able to navigate in SharePoint and Post/Retrieve document. o       Must be able to manage multiple tasks concurrently and prioritize accordingly. o       Must be able maintain the open task tracker and facilitate status meetings with Business and Support partners. o       Must be able to understand a medium complexity project plan and create a basic project plan using MS Project which may include the following: o   Define tasks and tasks dependencies o   Add resources Define time lines Experience: o       Typically has up to 3 years of related experience. o       Proficient with Excel, PowerPoint, Word, Tableau & SharePoint  o       Knowledge of MS Project, MS Access, SQL o       Solid time management and organization skills. o       Excellent communication skills both in written and verbal. o       General project management skills (knowledge of project life cycle preferred). o       Critical thinking with good analytical skills..
Salary Range: NA
Minimum Qualification
Less than 5 years

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Senior Compliance Technical Specialist
Brookhaven, NY Amneal Pharmaceuticals, Inc.
Operations Technical Specialist
New York City, NY XO Group
Manager, Oracle Cloud Technical Lead
New York City, NY KPMG
Compliance Technical Specialist
Ballston Lake, NY Global Foundries