Data Analyst Sr – ERP/EPM

Summary:

Oracle ERP/EPM Cloud “Data Analyst Sr” is an individual with supply chain, analytics and business process knowledge with critical thinking to provide solutions for complex business reporting needs. Conversant with multiple reporting tools use and excellent SQL skills. Willingness to learn new tools like FAW or FDI using subject areas and start building reports to support business functions. The knowledge in the end to end supply chain business processes and relevant Oracle modules as well as subject areas will be handy to design reporting solutions. Will be instrumental in requirement gathering, analysis, solution design, estimation, development and deployment of analytics and reporting solutions in line with organization change control board policies. The role also involves, maintenance, troubleshooting, resolution of errors for existing system functionalities and reports, and support new roll outs. Bring new technical ideas and innovative use of functionalities and technology to provide business solutions.

Essential Duties and Responsibilities:

• Perform requirement gathering, process Mapping, Analysis, and solutions design
• Create documentation, perform fit/gap analysis and recommend solutions
• Work with BIP, FR, Narrative and OTBI reports
• Work on SQL, XML, XSLT, VBCS, App Composer and OIC interfaces
• Work with ADFDI, FBDI & excel loads into Oracle
• Perform reports development in RDBMS, Essbase & Other sources
• Work with various data mining / archival tools, perform extracts and modify ETLs
• Good understanding on various APIs and troubleshooting
• Use business process flows, modules, system tables knowledge in day to day deliverables
• Manage supplier master & Item master creation and data conversion
• Configure BUs, Expense templates and card transactions mapping & loading
• Perform security analysis, create/modify roles and manage data access
• Troubleshoot and resolve technical and functional issues with the stringent timelines to support month close, and build/modify new workflow using BPM
• Conduct user trainings and maintain consistent documents
• Support business on month close and year close activities
• Work on a highly critical assignments with challenging timelines
• Provide support to other Oracle cloud ERP modules
• Regular learning with the latest Oracle SCM updates and conduct internal sessions
• Historical Data Conversion and Mapping
• Troubleshoot and resolve technical and functional issues within timelines

Minimum Qualifications:

Required Education: Bachelor’s in Computer Science, Finance, Accounting or other related field
Preferred Education: Master’s Degree in Computer Science, Finance, Accounting

Required Experience:

• 7-10 Years of any ERP experience like Oracle EBS, Fusion or Premier or Lawson etc.,
• 2-5 experience in “Requisition, Purchasing, Contracts, Receiving, Inventory & Cost Management

Preferred Experience: 2-5 Years of experience in Oracle Fusion SCM

Preferred License/Registration/Certification: Oracle Cloud ERP Certifications preferred

Computer Skills Required: Strong SQL, BI and XML working knowledge is required

Physical Demands:

In order to successfully perform this job, with or without a reasonable accommodation, the following are outlined below:

• The Employee is required to read, review, prepare and analyze written da ta and figures, using a PC or similar, and should possess visual acuity.
• The Employee may be required to occasionally climb, push, stand, walk, reach, grasp, kneel, stoop, and/or perform repetitive motions.
• The Employee is not substantially exposed to adverse environmental conditions and; therefore, job functions are typically performed under conditions such as those found within general office or administrative work.