Oracle EPM
Sunil Tewari
Senior Consultant
New Delhi
Summary
ARCS Implementation Consultant with over 10 years of experience while working across various EPM technologies. I have a great expertise in Oracle Hyperion EPM suite, ERP, data integration, data quality, proof of
concepts, Pre-sales, requirement analysis, technical and functional documentation and presentation.
Overview
11
11
years of professional experience
8
8
years of post-secondary education
4
4
Certifications
2
2
Languages
Work History
Senior ARCS Consultant
Fusion Practices
New Delhi
09.2022 - 03.2023
- Designing and implementing Balance attestation solution for customer in ARCS.
- Capture account balances, reconciliation information and to generate required schedules
- Workflow associated with review and approval of reconciliations
- Track reconciliation status
- Design knocking off rules at transactional level data between GL Journal lines and subsystem details
- Provide supporting details to complete the reconciliation in Reconciliation Compliance
- Understanding the requirements from Onsite and converting them to technical build objects
- Designed ARCS design and developed artifacts which includes setting up profiles, frequencies,
- Formats, periods and configuration settings as per requirements
- Created reconciliations set up and performed reconciliation activities
- Built integration layer by creating direct integration with ERP GL to load data to ARCS balances
- Developed custom reports as per client need
- Generated reconciliation compliance and Transaction matching reports
- Created artifacts in both compliance and matching modules per business needs
- Created required integrations in Data Management for loading data Reconciliation and
- Transaction matching data
- Automate the integration using EPM Automate and batch scripting
- Technical Environment and Tools: - Oracle Cloud EPM, ARCS, BI Publisher, Windows, UNIX., Analyze user stories and discuss with business to close the gap
- Convert functional requirements into technical objects
- Creating Match types for different transaction matching between source system and sub-system
- Created different types of attributes for required data sources
- Configuring Transaction Matching while creating and managing Rules for various data sources
- Designed ARCS design and developed artifacts which includes setting up profiles, frequencies,
- Formats, periods and configuration settings as per requirements
- Created reconciliations set up and performed reconciliation activities
- Provided integration solutions between POS, Bank statements, GL and ARCS
- Developed custom reports as per client need
- Generated reconciliation compliance and Transaction matching reports
- Technical Environment and Tools: - Oracle Cloud EPM, ARCS, BI Publisher, EPM Automate,
- Windows, UNIX
- Client
- Managed time efficiently in order to complete all tasks within deadlines.
- Gained extensive knowledge in ARCS implementation in financial domain
- Assisted with day-to-day operations, working efficiently and productively with all team members.
- Used critical thinking to break down problems, evaluate solutions and make decisions.
Principal Consultant
Oracle
Noida
10.2019 - 08.2022
- Lead various teams in implementing ARCS solutions for more than 3 customers.
- Demonstrated leadership skills in managing projects from concept to completion.
- Converted functional requirements into technical builds.
- Preparing Functional Specifications Document, and walking through the same with relevant stakeholders for sign-off.
- Configuring and implementing ARCS application to meet the account reconciliation requirements
- Developing metadata and Data integration for loading account profiles into ARCS.
- Creating custom reconciliation reports, if necessary, based on business requirements.
- Assisting in the preparation of system documentation (Design document, Test Cases, etc) and training material.
Senior Consultant
Bristlecone India Pvt Ltd
Noida
06.2012 - 10.2019
- Assisted in the development of business project plans and implementation plans to support
major deliverables. - Responsible for executing data loads to and from Hyperion modules, implementing
financial controls, and reconciling data between sources and targets. - Provided ad-hoc query and reporting support utilizing Hyperion reporting tools
(Financial Reports/Web Analysis/Essbase Scripts/Smart View) - Designed FDM data loading process, including: Import, Export, Validate and Check.
- Creating new import format, location and period mapping in FDMEE and Data
management on Cloud. - Designed ODI ETL Project right from gathering requirement and preparing functional documents
to implementing the end solution. - Built transformation logic, configured servers and established connections to various sources and targets.
- ETL development, testing and implementation on Client/Server, Business Intelligence,
data warehousing and data Integration applications - Lead a team in implementing integration solutions in Development, Test and Production environments.
- Clear understanding of business procedures and ability to work as an individual and as a part
of a team.
Education
EPGDIB -
Indian Institute of Foreign Trade
New Delhi 08.2015 - 03.2017
B.Tech - IT
Graphic Era Institute
Dehradun 08.2007 - 05.2011
HSC(XII) -
BSSV
Nainital 06.2004 - 06.2006
SSC -
Sri DD Chhimwal Memorial Public School
Nainital 03.2003 - 04.2004
Skills
Oracle Account Reconciliation Cloud Service (ARCS)
Financial Data Management Enterprise Edition
Oracle Financial Reporting
Oracle Data Integrator
Smart View
SQL
Data Integrations
Accomplishments
- ARCS and Oracle EPM expert
- IP creation for innovative solutions implemented across projects.
- Continuous Delivery management for Oracle EPM products
- Integration lead implementing various EPM integration solutions
- Rewarded and recognized by customer for various project accomplishments
Certification
Oracle Account Reconciliation 2020 Certified Implementation Specialist
Software
Data Integrations, FDMEE/DM, Oracle Data Integrator
Oracle ,SQL
BI, Data Analytics
MS Office, Smart View
Timeline
Senior ARCS Consultant
Fusion Practices
09.2022 - 03.2023
Principal Consultant
Oracle
10.2019 - 08.2022
EPGDIB -
Indian Institute of Foreign Trade
08.2015 - 03.2017
Senior Consultant
Bristlecone India Pvt Ltd
06.2012 - 10.2019
B.Tech - IT
Graphic Era Institute
08.2007 - 05.2011
HSC(XII) -
BSSV
06.2004 - 06.2006
SSC -
Sri DD Chhimwal Memorial Public School
03.2003 - 04.2004