Anil Yekula 201-***-**** adhihp@r.postjobfree.com

Career Summary

EPM Professional with 16 years of total IT experience in design, development, implementation and support of EPBCS\PBCS, FCCS, ARCS, EDMCS, HFM, Anaplan, FDMEE, Hyperion Essbase, Hyperion Planning, Hyperion FDQM, Hyperion DRM, Oracle General Ledger and Business Intelligence in large global organizations (including Investment Banking & Financial services companies). Detailed knowledge and experience on full application development life cycle. Ability to effectively plan and adapt to rapid requirement changes and deadlines.

Professional Summary

Planned and conceived computer systems using information engineering, data modeling and structured analysis.

EPM Professional with experience into EPM space (Solution design & development, Application maintenance & Support of PBCS\EPBCS, FCCS, Anaplan, HFM, FDMEE, Essbase and Planning)

Experience in end to end implementation of Oracle-Hyperion EPM Suite.

Experience in transforming the business needs to technical solutions.

Proactively communicate and collaborate with stakeholders, developers, QA, and other team members

to analyze information and functional requirements.

Oversaw installation of software programs and hardware systems to meet Client requirements.

Investigated and addressed system issues to enhance usability and improve functionality.

Developed flowcharts and diagrams to describe and lay out logical operational steps.

Involved in all aspects of Software Development Life Cycle, Production Support, Troubleshooting, Software Testing, Requirement Analysis, Design Documents, Client Support, Test plan preparations, Unit/System testing, Change Requests, Impact Analysis, System Integration & Testing and documentation.

Proven expertise in Techno-Functional activities with rich experience in all phases of the SDLC including requirement gathering, system analysis & design, development, and implementation of client/server applications.

Involved in Designing and building the metadata based on the existing hierarchies and chart of Accounts.

Involved in Application support like metadata changes, Reports changes, data reconciliations, rules changes etc.

Strong in Business Model development with Dimensions, Hierarchies and Mappings.

Exposure in Oracle SQL\PL SQL.

Skills

Skill

Utilities

Application

EPBCS\PBCS, Hyperion Financial Management, FDMEE, Anaplan, FCCS, ARCS, EDMCS, Hyperion Essbase, Hyperion Planning, Hyperion DRM, Hyperion FDQM, Hyperion Shared services, Hyperion EPM application, Hyperion Essbase and Oracle GL.

Hyperion Reporting Tools

Hyperion Financial Reporting Studio & Hyperion Smart view

Oracle E-Biz

Oracle Financials 11 version and R12

Operative Systems

Windows XP, Windows Server 03 and Windows Vista/7

Professional Experience

Organization

designation

period

Cognizant Technology Solutions

Hyperion & Anaplan Data Architect

May 2015 - Present

Accenture Services LLC

Hyperion Systems Analyst (TL)

Sep 2010 – May 2015

S & P Capital IQ

BI Analyst

Apr 2004 – Aug 2010

Educational Background:

MBA from Andhra University in 2003, Vishakhapatnam.

B. Com from Nagarjuna University in 2000, Guntur.

Certifications:

HFM Certified Consultant

Anaplan Intermediate Model Builder

Anaplan Certified Model Builder

Project Experience

Company : Cognizant Technology Solutions

Client : Healthcare Client

Designation : EPMA Solution Architect

Duration : May 2019 – Present

Environment : EPMA

Project Description:

It is a medical products distribution company focused on delivering clinical medical device solutions, where we must implement and support the reporting applications like EPBCS\PBCS, FCCS, HFM, FDMEE, Essbase, IBM CCC and HFR.

Roles & Responsibilities: -

Architected the EPBCS application and worked closely with all business units.

Understanding the Business requirements from Stakeholder and Client partners and prepared functional & technical specifications.

Prepared design documents. Setup the Metadata/outline hierarchies.

Involved in End to End Design, Development, Testing, UAT phases of EPM suites of products.

Automated jobs using EPM Automate and Batch scripting.

Worked on Flat file integration with Data Management.

Integrated from on-premise EBS to PBCS via EPM Integration Agent.

Conversion of Cal Script to Business rules.

Security configuration in PBCS.

Enable Smart Push to push the data from BSO cubes to ASO(Reporting) Cube.

Migrate HFR reports to Web Reporting Studio

Application backups and metadata updates

Understands and complies with system change control procedures & software validation

Organized system infrastructure documentation and operating procedures, strengthening controls, and enhancing overall performance.

Administer HFM Application Change Management by properly documenting Metadata and HFM Business Rules changes for SOX reporting

Coordinating requests for HFM security class access and creation/management of existing security classes and groups

Review and approve user access requests for HFM

Quarterly SOX security review and insider’s blackout list

Periodic review of system functionality setup and interface testing

Review and validation of financial data submission packages during month end close and resolving any data/system issues with the international accounting teams

Perform copy application and disaster recovery validations

Company : Cognizant Technology Solutions

Client : Healthcare Client

Designation : EPMA Solution Architect

Duration : May 2018 – May 2019

Environment : EPMA

Project Description:

It is a medical devices company focused on delivering clinical medical device solutions, where we have to support the reporting applications like OACS, EPBCS\PBCS, HFM, FDM applications, Essbase, IBM CCC and HFR.

Roles & Responsibilities: -

As a Project lead, responsible for support client's Financial applications on HFM, EPBCS\PBCS and OACS, for their Financial Reporting systems of records.

Responsible for requirement gathering/design document and development of new integration based on the business requirements

Responsible to liaise multiple departments for interface consolidations, process improvements new interface solutioning

Responsible for end to end testing of enhancement/beak fix in existing interfaces

Defining the ETA and timelines and approval of new development and communicate to business

Responsible for attending client meetings for Design, Build and testing review phases

Responsible to provide support on all incidents/tickets created by business or user within SLA time

Providing support in all Financial Integrations which include Hyperion and Anaplan applications

Responsible of incidents analysis and propose solution on issues

Works with business on Month-end closure and co-ordinate the upstream and downstream ERP teams.

Company : Cognizant Technology Solutions

Client : Healthcare

Designation : Hyperion & Anaplan Architect

Duration : May 2015 – May 2018

Environment : EPMA

Project Description:

It is new company which is established by spin off of Resources & Consumer Goods company, where we have to support the reporting applications like Hyperion Financial Management, EPBCS, FDM applications, Essbase, IBM CCC and HFR.

Roles & Responsibilities: -

As a Project lead, responsible for support client's Financial applications on Oracle Hyperion and Anaplan Platform for their Financial Reporting systems of records

Defined business goals to determine systems requirements.

Evaluated and adopted new technologies to address changing industry needs.

Organized system infrastructure documentation and operating procedures, strengthening controls and enhancing overall performance.

Resolved or escalated problem tickets to resolve user issues.

Defining the ETA and timelines and approval of new development and communicate to business

Gathered requirements and performed gap analysis through design workshops with users.

Responsible for attending client meetings for Design, Build and testing review phases

Responsible to provide support on all incidents/tickets created by business or user within SLA time

Providing support in all Financial Integrations which include Hyperion and Anaplan applications

Responsible of incidents analysis and propose solution on issues

Works with business on Month-end closure and co-ordinate the upstream and downstream ERP teams.

Company : Accenture Services LLC

Client : Insurance

Designation : Hyperion Systems Analyst

Duration : Jan 2013 – May 2015

Environment : EPMA & E-Biz

Project Description:

Client is currently engaged in an implementation and support of Oracle technologies to create an integrated environment that provides both ERP and EPM capabilities. Oracle EPM System Workspace, Fusion Edition version 11.1.2.2 (HFM) is being implemented as a centralized, web-based budgeting and forecasting solution to replace the current process in some countries. Apart from this, there are multiple rollouts involved in this project for different locations.

Roles & Responsibilities: -

Supporting Data Governance project by creating hierarchies which is requested by Business.

Creation of automators to upload nodes to DRM.

Creation of versions and updating the hierarches of versions twice a month.

Involved in Development of New versions and Designing Metadata and loading metadata into HFM.

Creation of new nodes in HFM as per the requirement given by business.

Resolving the Tickets for users and help the business to run the daily, monthly, quarter and year end activities.

Handled the Team of 4 and the SPOC for the entire Hyperion Team.

Working on Oracle GL and created legal entities and balancing segments to support business.

Company : Accenture Services LLC

Client : Resources (Mines and Minerals)

Designation : Hyperion Systems Analyst

Duration : Jan 2012 – Dec 2012

Environment : HFM & Hyperion Enterprise

Project Description:

This is a one of the world’s biggest copper and gold mining company, they are using HFM and Hyperion Enterprise. This project involved HFM rollout for some locations and Enterprise support.

Roles & Responsibilities: -

Gathering business requirements.

Preparing the system requirement documents.

Given KT and trained the team members in HFM.

Provided the required KT to the Client.

Involved in procuring the requirements that are needed to get the Hyperion Development Instance.

Involved in Development of New Application and Designing Metadata.

Extracting and Loading Application, data and Run Consolidation.

Adding and Deleting Entities & accounts and as the client requirement.

Running Test Cases and as Test Case documentation.

Locking and Unlocking of periods.

HFM Application backup whenever before the data loads and application maintenance.

Company : Accenture Services LLC

Client : Manufacturing company

Designation : SSE

Duration : Jun 2012 – Jun 2012

Environment : FDQM

Project Description:

This is a global leader in complete lifecycle power solutions for the marine and energy markets. This project involved FDQM RFP/POC.

Roles & Responsibilities: -

Successfully completed the Proof of Concept (POC) for Hyperion-FDQM to Wartsila.

Attained knowledge in successfully installing and configuration of FDQM and uploading data from different sources to FDQM.

As per the client specification worked on importing data from RDBMS to FDQM and again exporting the same to RDBMS without any bugs and difficulties.

Company : Accenture Services LLC

Client : Oracle SME - Oracle EBS

Designation : SSE

Duration : Sep 2011 – Dec 2011

Environment : HFM

Project Description:

Oracle SME- EBS is internal initiative; it functions for building up the assets for internal trainings, preparing the Estimation for new projects and some more assets building activities.

Roles & Responsibilities: -

As a part of Oracle SME-EBS Capability we are involved in various activities like Presales, Hyperion Product trainings, setting up complete Environment for all the Hyperion products, Presentations on various products.

We are coming up with the Environmental set up for Complete Hyperion product suite latest version 11.1.2. We have installed and configured all the products successfully on the server and working on the access to the end users and demo applications for the trainings.

Created Trainings deck for the Hyperion products like HFM and DRM. This will be used for class room trainings.

Attended Hyperion DRM 11.1.2, Hyperion Planning Administration 11.1.2, Hyperion Financial Close Management Administration 11.1.2, Hyperion Disclosure Management Administration 11.1.2, Oracle

Company : Accenture Services LLC

Client : AAES - Oracle

Designation : SSE

Duration : Jun 2011 – Sep 2011

Environment : HFM & Oracle EBS

Project Description:

AAES - Oracle is internal initiative, in this we harvest the documents from our existing projects and keep in a repository, which help and reduce the effort of building the new documents for new projects and in which we worked on integrating the Oracle EBS with HFM.

Roles & Responsibilities: -

Involved in procuring the technical requirements that are needed to get the Hyperion Instance.

Drafted the Hierarchy for Hyperion as a tool under AAES process hierarchy.

Interacted with Hyperion SME's to get the hierarchy finalized.

Interacted with ARTL team to build the interface between ARTL and AAES.

Reviewed the technical artifacts from ARTL and submitted the consolidated list of artifacts available from ARTL to AAES for leveraging the same.

Prepared documentation like Activity docs & TR437 related to P2P pertaining to Oracle applications apart from Hyperion documentation.

Got training on AAES Methodology. Well verse with the process flows under AAES.

Company : Accenture Services LLC

Client : Steel producer

Designation : SSE

Duration : Sep 2010 – May 2011

Environment : HFM

Project Description:

This is an integrated steel producer with major production operations in the United States, Canada and Central Europe. It engaged in an implementation of Oracle technologies to create an integrated environment that provides both ERP and EPM capabilities.

Roles & Responsibilities: -

Gathering business requirements

Handled the entire HFM activities end –to –end in the project implementation.

Preparing the system requirements document

Creation and Building of the application in HFM.

Worked with the task flows and application settings of the HFM application.

Creation and maintenance of data forms and data grids in HFM

Worked on Web based applications to perform financial consolidations and analysis

Customization of all dimensions by using Manage Metadata Module as per requirement

Defining users and groups for the applications and assigning the access rights and securities

Designing new Data Entry Forms by using Web Application and creating Grids As per the requirement.

Involved in Loading and extraction of securities, Metadata and data

Creation of grids and consolidate the grids to refresh the values upon loading

Involved in Creating templates for Recurring Journals and generating and approving recurring journals

Regularly update metadata with new Accounts, Entities and Custom Dimensions

Extracted and loaded the metadata when ever metadata changes occur

HFM Application backup whenever before the data loads and application maintenance

Company/Client : Capital IQ

Designation : BI Analyst

Duration : Jan 2009 – Aug 2010

Environment : HFM & Others

Project Description:

Capital IQ is the powerful new combination of offerings including Global Credit Portal and Market Scope Advisor, enterprise solutions, which involves end user support for entering the client data and testing environments.

Roles & Responsibilities: -

Cross trained into HFM technology and worked as end user of HFM.

Tested the installation of HFM application according to test scripts given.

Testing the data forms and data grids working according to scripts given.

Testing the new features of the product as regards to installation configuration and functional aspects of the product.

Testing all new added features for web form.

Company/Client : Capital IQ

Designation : BI Analyst

Duration : Nov 2006 – Dec 2009

Project Description:

Capital IQ is the powerful new combination of offerings including Global Credit Portal and Market Scope Advisor, enterprise solutions such as S&P Securities Evaluations and Compustat, research offerings including Leveraged Commentary & Data, Global Markets Intelligence, and company and fund research.

Roles & Responsibilities: -

Analyzing the financial statements of International Listed Companies and US. Calculating Insiders Shareholdings, Substantial Shareholdings, and Public float of the US and International Listed Companies.

Ensure and finalize the Quality of the entire data by running QC checks.

Co-ordinate and Co-operate with the other team members for day to day delivery of data.

Develop new logics for Qualitative and Quantitative output.

Revising the comments and requirements sent by the customer.

Attending Data Issue’s posted by Clients

Company/Client : Capital IQ

Designation : BI Analyst

Duration : Apr 2004 – Oct 2006

Project Description:

Capital IQ is the powerful new combination of offerings including Global Credit Portal and Market Scope Advisor, enterprise solutions such as S&P Securities Evaluations and Compustat, research offerings including Leveraged Commentary & Data, Global Markets Intelligence, and company and fund research.

Roles & Responsibilities: -

Calculating the Compensation and Other Emoluments of the Directors and Executive Officers of the Companies.

Calculating Options granted to the Directors and Other Executive Officers of the Companies.

Analysis of people’s data of Companies that are listed in SEC.

Data Analysis from different filings that are filed in different exchanges.

Contact this candidate