VIJAYA KUMAR KOPPERLA
HYDERABAD
Summary
Have open minded, goal focused Software professional offering around 16 years of Experience in IT Industry. I am motivated an enthusiastic by new challenges and tasks and take excellent approach to achieve success in projects. I like to work in Complex projects, which have scope learning and challenge. I have experienced in Working with different operating systems and platforms namely Oracle Hyperion ESSBASE, Oracle Hyperion Financial Management, Oracle Hyperion Planning, Oracle Hyperion Financial Data Quality Management, Oracle Enterprise Planning and Budgetting and Cloud Service (EPBCS), Oracle Financial Consolidation & Cloud Service (FCCS), Oracle Tax Reporting Cloud Service (TRCS) and Java.
Overview
16
16
years of professional experience
Work History
Technical Project Manager
Qentelli Solutions
01.2024 - 05.2025
- Requirements gathering from Customer for Oracle FCCS
- Close Manager POC for Oracle FCCS
- Daily Actuals loading through Data Exchange
- Intelligent Performance Management (IPM) – to Automate data analysis
- Scenario Modelling & What-if Analysis
- Connected Planning – Bridges gaps between departments by Integrating Financials, Workforce.
- Predictive Planning – Automated forecasts by analyzing historical data to predict future performance
- Daily Balance application Development
- Monthly Cost allocation (Budget) loads through Data Management and Data Exchange
- Daily Balance, Loans and Deposits reports development
- Reports migration from FR reports to reports
- Monthly Account changes and Cost Center Changes
- Business rules conversion to Groovy in both EPBCS and FCCS
- Integration from Coupa to EPBCS and EPBCS to FCCS
- Ticket resolving through User Stories, Sprint wise
- Client: Texas Capital Bank (USA)
Oracle EPM Senior Consultant
Avalon Software Services
01.2022 - 09.2023
- Participation in requirements definition workshops
- Assisting with developing design documentation
- Knowledge of application of better practices within performance reporting and planning process areas
- Developing Hyperion Essbase and/or Hyperion Planning environments, including outlines, load rules, calculation scripts, partitions, web forms and security, systems testing, and training of end user and Client support team
- Intelligent Performance Management (IPM) – to Automate data analysis
- Scenario Modelling & What-if Analysis
- Connected Planning – Bridges gaps between departments by Integrating Financials, Workforce.
- Predictive Planning – Automated forecasts by analyzing historical data to predict future performance
- EBPCS Activities: EPBCS Application creation, Configuration of Finance, Capital and Projects Modules, Dimension Building, Actuals and Budget data loading, Created Reports like Income statement, Balance Sheet, Comprehensive Income Statement, Financial Summary, Monthly Financial Statement, Statement of Capital Works, Created Dashboards like Balance Sheet, Expense, Income Statement, Revenue, Act vs Bud Current Month, Act vs Bud current month with Cost center, Act vs Bud Y-T-D and Act vs Budget
- ICS Activities: Grant Access and Manage Security, Move Design-Time Metadata between Environments, Scale an Oracle Integration Instance, SSL Certificates upload, Troubleshoot Oracle Integration Classic
- Client: AAXA Software Services (Australia)
Senior EPM Consultant
ImplifyInc
06.2021 - 12.2021
- Hierarchy Updates: New Member creation for Accounts/Departments/Clients/Locations Movement of members across the Hierarchy Updating of member properties
- ODI Activities: Execution of ODI Jobs during hierarchy updates
- Actual Activities: close actuals solve for a particular period, Start Actuals solve for a new period and Perform allocations execution (Run ODI allocations and Push JE entries to Oracle System)
- Budget and CE Activities: monthly roll over activities across different versions, Quarterly Roll over activities across different Scenarios, CE allocations data load and data copy from Actuals into CE
- ACT + CE and CC: Data copy into ACT + CE and Perform Constant Currency Calculation
- Capacity Forecast: Fortnight roll over process across different versions, Monthly roll over process across different scenarios, Yearly roll over process
- Ad Hoc Requests: Fill Missing COA members info in ODI tables, ASKNOW tickets, users Hyperion and SmartView related issues, Loading Bookings and Productions workstations data for actuals into Essbase reporting application
- Users Hyperion Access Request: Processed users Hyperion Access Request
- Monitoring Scheduled Jobs: Actuals solve process, CE Solve process, Loading FX Rates into actuals, Essbase cube compact process, Daily backup process
- Maintenance Activities: Weekly defragmentation process for Planning application, weekly service restart process in prod DB Server, weekly server reboot process in Hyperion Prod Web and Plan Servers
- EPBCS Activities: New Member creation for Account/Departments/Clients/Locations directly in Prod environment, Actuals Solves and CE solves through EPM Automate
- TRCS Activities: Application creation and maintenance, Metadata loading, Data loading, Custom Navigation Flows design, Infolets design, Dashboard, Forms design, Tax rates setup and Tasks
- Client: Incyte Inc
Senior Hyperion Consultant
TTEC Digital Analytics India
01.2020 - 05.2021
- Hierarchy Updates: New Member creation for Accounts/Departments/Clients/Locations Movement of members across the Hierarchy Updating of member properties
- ODI Activities: Execution of ODI Jobs during hierarchy updates
- Actual Activities: close actuals solve for a particular period, Start Actuals solve for a new period and Perform allocations execution (Run ODI allocations and Push JE entries to Oracle System)
- Budget and CE Activities: monthly roll over activities across different versions, Quarterly Roll over activities across different Scenarios, CE allocations data load and data copy from Actuals into CE
- ACT + CE and CC: Data copy into ACT + CE and Perform Constant Currency Calculation
- Capacity Forecast: Fortnight roll over process across different versions, Monthly roll over process across different scenarios, Yearly roll over process
- Ad Hoc Requests: Fill Missing COA members info in ODI tables, ASKNOW tickets, users Hyperion and SmartView related issues, Loading Bookings and Productions workstations data for actuals into Essbase reporting application
- Users Hyperion Access Request: Processed users Hyperion Access Request
- Monitoring Scheduled Jobs: Actuals solve process, CE Solve process, Loading FX Rates into actuals, Essbase cube compact process, Daily backup process
- Maintenance Activities: Weekly defragmentation process for Planning application, weekly service restart process in prod DB Server, weekly server reboot process in Hyperion Prod Web and Plan Servers
- EPBCS Activities: New Member creation for Account/Departments/Clients/Locations directly in Prod environment, Actuals Solves and CE solves through EPM Automate
- TRCS Activities: Application creation and maintenance, Metadata loading, Data loading, Custom Navigation Flows design, Infolets design, Dashboard, Forms design, Tax rates setup and Tasks
- Client: Teletech US
Senior Hyperion Consultant
Access Automation India Pvt Ltd
02.2019 - 09.2019
- FCCS Application Creation, Provisioning Security, Loading Metadata, Loading Data
- Intercompany Transactions, Journal Posting, Data Forms
- HFM Application creation, providing security, Metadata Loading, Data Loading
- Intercompany transaction loading and elimination
- Written Business Rules
- Designed Dashboards and Infolets
- Designed Reports through Financial Reporting Studio
- Client: Seagate HDD India
Senior Hyperion Consultant
Capgemini Consulting
08.2016 - 10.2017
- File loading from FDMEE (4 fish process) to HFM
- Consolidate all, Consolidate all with data, Calculation, translation
- Copy Application
- Incident, change request
- Lock/unlock period
- Restart Hyperion services
- Manage journals
- Process control steps
- Data form and Data grid
- Batch jobs/scripts
- Ad hoc request for adding user through shared services
- Metadata loading
- Security group/roles
- Rules creation in HFM
- Jobs, batches, report validation, matching, data, logs, patches
- Client: HSBC
Senior Consultant
Capgemini Consulting
04.2015 - 07.2016
- Support for Oracle EPM applications like GAUDI (HFM application), Amber (Planning application), CIO (HPCM Application)
- Resolving the issues facing by the end user with ticketing system
- Client: NN Group, Netherlands
Senior Consultant
Bristlecone
01.2014 - 01.2015
- Managing Applications, Security, Metadata, business rules, IC transactions
- Hyperion Essbase and Planning Application Creation
- Modified existing outlines for addition, deletion and movement of members both through manually and used dimension build methods
- Member formulas and Calculation Scripts
- Calculation Scripts
- MaxL Scripting
- Data Forms and Grids
- Client: Internal Project
Senior Consultant
NDS Infotech
02.2013 - 12.2013
- BSO to ASO conversion
- Modified existing outlines for addition, deletion and movement of members both through manually and used dimension build methods
- Member formulas and Calculation Scripts
- Calculation Scripts
- MaxL Scripting
- Extended analytics (HFM) Managing Intercompany Transactions in Hyperion Financial Management
- Client: Sealy INC US
Hyperion Consultant
Mahindra Satyam
05.2011 - 08.2012
- Modified existing outlines for addition, deletion and movement of members both through manually and used dimension build methods
- Developed ASO and BSO
- Developed calculations in Essbase (Member Formulas, Calculation Scripts)
- Managing applications, Managing Application Security
- Managing metadata, creating a grid, Managing Data Forms
- Managing Rules
- Managing Intercompany Transactions in Hyperion Financial Management
- Created alternate Hierarchies
- Client: Fair Child, Southport land, USA
Hyperion Consultant
Mahindra Satyam
11.2010 - 04.2011
- Modified existing outlines for addition, deletion and movement of members both through manually and used dimension build methods
- Developed ASO and BSO
- Developed calculations in Essbase (Member Formulas, Calculation Scripts)
- Managing applications, Managing Application Security
- Managing metadata, creating a grid, Managing Data Forms
- Managing Rules
- Managing Intercompany Transactions in Hyperion Financial Management
- Created alternate Hierarchies
- Optimized data loads
- Client: Cashman Equipments CA
Hyperion Consultant
Mahindra Satyam
09.2010 - 11.2010
- Modified existing outlines for addition, deletion and movement of members both through manually and used dimension build methods
- Developed ASO and BSO
- Developed calculations in Essbase (Member Formulas, Calculation Scripts)
- Managing applications, Managing Application Security
- Managing metadata, creating a grid, Managing Data Forms
- Managing Rules
- Managing Intercompany Transactions in Hyperion Financial Management
- Created alternate Hierarchies
- Optimized data loads
- Client: Restoration Hardware, CA
Hyperion Consultant
Mahindra Satyam
06.2010 - 08.2010
- Coordinating with Client and Business Analyst to understand and develop an Optimized Cube
- Developed Calculation scripts
- Optimized Essbase cubes and calc scripts
- Developed Maxl Scripts and responsible for scheduling the batch jobs
- Managing applications, Managing Application Security, managing metadata, creating a grid, Managing Data Forms, Managing Rules, Managing Intercompany Transactions in Hyperion Financial Management
- Client: LINAX Inc, New York
Hyperion Consultant
Mahindra Satyam
09.2009 - 05.2010
- Coordinating with Client and Business Analyst to understand and develop an Optimized Cube
- Developed Calculation scripts
- Optimized Essbase cubes and calc scripts
- Developed Maxl Scripts and responsible for scheduling the batch jobs
- Managing applications, Managing Application Security, managing metadata, creating a grid, Managing Data Forms, Managing Rules, Managing Intercompany Transactions in Hyperion Financial Management
- Client: NDC HEALTH, US
Education
Master of Computer Applications -
Sri Venkateswara University
Tirupati, India01-2005
Bachelor of Computer Applications -
Sri Venkateswara University
Tirupati, India01-2002
Skills
- Oracle Hyperion Essbase and Planning
- Hyperion Financial Management
- Financial data quality management
- Smart View
- Financial consolidation and close cloud service
- Enterprise planning and budgeting cloud service
- Groovy rules for Oracle EPM Cloud
- Oracle analytics cloud service
- OAC analysis with machine learning
- Narrative reporting
Custom Section
Windows 2003 Server, Windows 2008 Server, Windows 7, Windows 8, Linux, Client/Server, DB2, Oracle, SQL server, HTML, Java Beans, Servlets, Jsp, Struts, java, Oracle Hyperion Essbase, Planning, Financial Management, Financial Data Quality Management, Smart View (Techno Functional), Financial Close Cloud Service (FCCS), Enterprise Planning and Budgeting Cloud Service (EPBCS), Oracle Tax Reporting Cloud Service (TRCS), Groovy Rules for Oracle EPM Cloud, Oracle Analytics Cloud Service (OAC), Adaptive Planning (Intelligent Performance Management, What-if, Predictive Planning and OAC Analysis with Machine Learning)
Languages
Telugu
Advanced
C1
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Technical Project Manager
Qentelli Solutions
01.2024 - 05.2025
Oracle EPM Senior Consultant
Avalon Software Services
01.2022 - 09.2023
Senior EPM Consultant
ImplifyInc
06.2021 - 12.2021
Senior Hyperion Consultant
TTEC Digital Analytics India
01.2020 - 05.2021
Senior Hyperion Consultant
Access Automation India Pvt Ltd
02.2019 - 09.2019
Senior Hyperion Consultant
Capgemini Consulting
08.2016 - 10.2017
Senior Consultant
Capgemini Consulting
04.2015 - 07.2016
Senior Consultant
Bristlecone
01.2014 - 01.2015
Senior Consultant
NDS Infotech
02.2013 - 12.2013
Hyperion Consultant
Mahindra Satyam
05.2011 - 08.2012
Hyperion Consultant
Mahindra Satyam
11.2010 - 04.2011
Hyperion Consultant
Mahindra Satyam
09.2010 - 11.2010
Hyperion Consultant
Mahindra Satyam
06.2010 - 08.2010
Hyperion Consultant
Mahindra Satyam
09.2009 - 05.2010
Master of Computer Applications -
Sri Venkateswara University
Bachelor of Computer Applications -
Sri Venkateswara University