Technical Specialist-Enterprise Apps

Area(s) of responsibility

• Strong technical skills on Oracle EPM Cloud components (ASO, BSO, Calculation Scripts, Business Rules, Load Rules, MaxL and MDX).  
• Understanding of accounting, Long-Range Planning & Forecasting, Short Range Planning & Forecasting, Weekly Pacing, planning, and budgeting concepts.  
• Experience in creating Web forms, Financial Reports, Member formulas, Data Maps, Dashboards and complex Business Rules.  
• Knowledge and experience configuring dimensions with optimal dimension design.  
• Experience in building dimensionality and understanding dependencies and interrelationships between various dimensions including smartlist in EPM Cloud. 
• Expertise in developing custom integrations using Webforms, EPM Data Integrations & Groovy Business Rules.  
• Create and maintain application documentation, both functional specifications, technical design & Admin SOP Guides. 

• Hands on experience with Data Extraction, Transformation and Data Loading in Data Warehouse environment.
• Review FSD/business requirement documents and consult on project scope and timelines

Size, estimate and groom stories for development and deployment per agile methodology.

• Develop ETL jobs for automation, monitoring and responsible for job performance optimization with the use of ETL development tools or custom developed procedures.
• Implementing design decisions using design patterns and plans in Abinitio and creating Unix wrapper scripts to handle complex transformation logic.
• Experience working in an agile project development lifecycle
• Well Acquainted with Oracle SQL/PLSQL, Strong proficiency in Shell scripting
• Experience in production support and handling Incidents and providing RCA.
• Grooming junior resources in team on the technology and support.