Home

Sai Kumar - Oracle EPM Consultant

[email protected]

Location: Irving, Texas, USA

Relocation:

Visa: Green Card

GAJJALA SIDDI SAIKUMAR REDDY Mobile: 254-273-4015 Email: [email protected] PROFESSIONAL SUMMARY Oracle EPM and Essbase Developer with 8+ years of experience in delivering enterprise-level financial planning and reporting solutions. Proficient in Oracle Planning, EPBCS, ASO/BSO cube development, Calc scripting, and advanced features like Webforms, Business Rules, and SmartLists. Skilled in data automation, metadata management, and performance tuning to drive operational efficiencies across industries. Adept at translating complex business requirements into robust technical solutions. TECHNICAL SKILLS EPM Tools: Oracle Planning, EPBCS, Essbase (ASO, BSO Cubes) Advanced Features: Webforms, Business Rules, Runtime Prompts, SmartLists Database Management: SQL Server, Oracle Database Schema Programming: Python, MaxL, MDX, Calc Scripting Visualization Tools: Power BI, Tableau Specialties: Data Load Automation, Performance Tuning, Metadata Management, Dashboard Development CORE COMPETENCIES Oracle EPM Suite (Planning, EPBCS, Essbase ASO/BSO) Webforms, Business Rules, Runtime Prompts, SmartLists SQL Server, Oracle Database Schema MaxL, MDX, Calc Scripting, Data Load Automation Python, Power BI, Tableau Performance Tuning, Metadata Management, Dashboard Development PROFESSIONAL EXPERIENCE Capital One Bank (Jan 2023 Present) Role: Senior Oracle EPM Developer Enhanced Planning and EPBCS applications by designing Webforms with runtime prompts and SmartLists, enabling dynamic and user-friendly data input for budgeting processes. Automated metadata and data loads using MaxL and Python, streamlining nightly refresh processes for planning and reporting systems. Optimized ASO cube performance by implementing cache tuning techniques, reducing retrieval and calculation times by 40%. Designed Business Rules to handle complex allocations, driver-based planning, and consolidations across financial processes. Developed real-time dashboards in Power BI and Tableau for executive reporting, integrating data from EPM systems and SQL Server. Environment: Oracle Planning, EPBCS, Essbase, SQL Server, Python, Tableau CVS Health (Jan 2021 Dec 2022) Role: Oracle EPM Consultant Led the design and development of Planning and EPBCS applications, including detailed Webforms, runtime prompts, and SmartLists for enhanced user interaction. Built Calc scripts and Business Rules to manage driver-based forecasting, resource allocation, and consolidations. Automated cube refresh processes using MaxL scripting, improving the timeliness and accuracy of data. Collaborated with teams to integrate SQL Server and Oracle databases with EPM systems, ensuring a unified data platform. Conducted performance tuning for ASO and BSO cubes, increasing data retrieval efficiency by 30%. Environment: Oracle Planning, EPBCS, Essbase, SQL Server, Oracle Database, Python Change Healthcare (Jan 2019 Dec 2020) Role: Oracle EPM Developer Developed ASO and BSO cubes to support financial and operational reporting, incorporating runtime prompts and SmartLists for flexible data entry. Designed and optimized Webforms for budgeting and forecasting, ensuring seamless user interaction and real-time validations. Automated data and hierarchy updates using MaxL scripts, significantly reducing manual efforts. Created dynamic dashboards in Tableau and Power BI, providing actionable insights into business trends. Conducted regular database and metadata management, ensuring consistency across Planning and Essbase applications. Environment: Oracle Planning, Essbase, SQL Server, Power BI, Tableau DTCC (Depository Trust & Clearing Corporation) (Jan 2015 Jan 2018) Role: Oracle EPM Analyst Designed and developed Planning applications and BSO cubes to support financial consolidation processes. Authored Calc scripts and Business Rules for allocations, intercompany eliminations, and consolidations. Built Webforms and runtime prompts to facilitate detailed input for budgeting and forecasting activities. Implemented SmartLists to enhance data validation and user experience in Planning applications. Provided ongoing maintenance and performance optimization for Planning and Essbase solutions, ensuring reliability and efficiency. Environment: Oracle Planning, Essbase, Oracle EPM Suite EDUCATION Bachelor of Technology, Electrical and Electronics Engineering BIHER Bharath University, Chennai, India | 2022 | 85% High School (10+2), Mathematics, Physics, Chemistry Sri Chaitanya Junior College, Tirupati, India | 2018 | 96.2% Keywords: business intelligence