Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Software
Timeline
Generic
Sunil Tewari

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)

undefined

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

Oracle EPM

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

Similar Profiles

CREATE PROFILE
Sunil TewariSenior Consultant