Project Management
Resume:
Ali Kashif Ansari
***, ********* ******, **** ***** Plaza,
Palam Vihar, Gurgaon, Haryana, India, 122017
Mobile: +91-999**-*****, Email: **********@*****.***
Summary
. I have 6.5 years of experience in Enterprise Performance Management (EPM)
consulting, specifically in HFM application design /development, FDM
integration, ERP integrator, Essbase Cube designing, and BI Suites.
. I am currently working with Ernst & Young as a Senior Consultant focusing
on Enterprise Performance Management and IT consulting from Jan 2011 to
till date.
. Previously I worked for 3i infotech Ltd as a consultant in IT consulting
and implementation for different kind of domain like Banking, Finance
/Portfolio Management and Manufacturing, working on Hyperion technologies
for 4 years.
. I have good understanding of Hyperion Financial Management: Working on
Data Model and designing, developing application, writing rules,
Consolidation performance optimization, creating webforms.
. Designing integration interface using FDM - Financial Data Management.
Creating location, mapping, creating import formats, writing batch and
event scripts.
. Hyperion Essbase: Has performed various roles like Designing and building
Essbase Cube, Writing Calculation / Report Script in Essbase.
. Good exposure of ERP Integrator - integrating Oracle EBS source system
and loading data using FDM in to Hyperion Financial Management (HFM).
. Hyperion Certified Developer
. Hyperion Reporting: Good knowledge of different reporting tools in
Hyperion suites - Financial Reporting, Interactive Reporting and Smart
view.
. Working knowledge of Hyperion Planning
. Basic understanding of Hyperion Performance Scorecard.
. Good understanding of Oracle Hyperion System 9 and EPM 11 Architecture.
. Oracle's OBIEE: I have worked on Oracle's BI (OBIEE) and has performed
role like creating RPD file, integrating MSAD Security and working on
Answers and Dashboards. User provisioning/access based on user role.
. Has been part different project implementation globally and have worked
in Australia and Business Trips - United States of America.
. Understanding of ETL tool, Oracle Warehouse Builder (OWB) and
Informatica.
. I have been involved in presales activities like working on EOI/RFI/RFP
and POC. Drafting proposals, effort estimation and drafting project plan
and implementation approach.
Technologies
EPM Tools : Oracle EPM 11.x, Hyperion Essbase 9.x,11.x, Hyperion Planning
11.x, Hyperion Financial Management, FDM, ERPI,
Hyperion System9 Administration, Interactive
Reporting, Hyperion Financial Reports, Hyperion Web
Analysis, Hyperion Production Reporting, Hyperion
Performance Scorecard, Oracle OBIEE 10.1.3.2, Oracle
EPM 11.
ETL Tools : Basics of Oracle Warehouse Builder,
Informatica
RDBMS : Oracle 10g, DB 2, Microsoft SQL Server
Operating System : Windows 98/2000/ XP, UNIX.
Capabilities:
. Designing and building Hyperion Financial Management application,
managing metadata, writing rules and creating web forms, MS Excel based
spreadsheet packs.
. Designing and developing Financial Data Management application, creating
location, import formats and batch scripts, conditional mapping,
customized script for logs and validation.
. Working with Hyperion ERP integrator
. Implementation, handling and designing of applications using Hyperion
Essbase.
. Designing Essbase Cube, creating outlines, data loading through rule
files.
. Writing calculation scripts.
. Optimization of outline, database, calculation script, data loading etc.
. Working with MaxL/ESSCMD
. Writing report script etc.
. Creating Hyperion Planning Application
. Generating reports using Interactive Reporting, Financial Reporting and
Production Reporting.
. Working with Oracle's BI (OBIEEE)
. A brief knowledge Hyperion Performance Scorecard
. Good SQL, PL/SQL, Oracle skills.
Training Attended:
Hyperion HFM, FDM, Hyperion Planning, Hyperion Essbase and Oracle's OBIEE
10.x
Work Experience
Current Assignment:
Client: Royal Bank of Scotland - UK
Tools Used: Oracle EPM 11.1.2.1, HFM, ODI, HFR and Smart View
Role: - Design and build data model for COREP requirements from EBA, build
changes in HFM application and define extraction process using ODI. Led the
build and different cycles.
Location: Gurgaon, India
Project Summary: RBS wants to update the existing data model of HFM in
order to comply with guidelines for COREP from EBA (European Banking
Authority). It has been identified that existing HFM application need to be
modified and updated which will allow the system to capture/calculate feeds
for COREP requirements and that will be extracted later using ODI and then
will be loaded into an Essbase application from where all required returns
can be produced.
Client: Royal Bank of Scotland - UK
Tools Used: Oracle EPM 11.1.2.1, HFM, FDM, EAL, ODI, HFR and Smart View
Relational Database: Oracle 11g R2, Oracle EBS 12
Role: - Responsible for building and maintaining HFM and FDM changes
Location: Gurgaon, India
Project Summary: Hyperion Financial Management is being used by RBS Group
to meet all the Statutory and Regulatory Reporting requirement. It has been
designed in such a way that it will produce financials statement required
by RBS. Hyperion Financial Report and Smartview are being used to meet
reporting requirements. Flat files from GL sources are being produced and
Financial Data Quality Management is used to load GL numbers into HFM.
My role:
. Identifying and resolve HFM issues and defect raise during UAT
. Building CR's pertaining to Hyperion Financial Management
. Working on HFM rule file and optimizing consolidation performance
. Identifying and resolve FDM issues and defect raise during UAT
. Building CR's pertaining to Financial Data Management
. Identifying and resolve HFR issues and defect raise during UAT
Client: Religare - India
Tools Used: Oracle EPM 11.1.2.1, HFM, FDM, and ERPI
Relational Database: Oracle 11g R2, Oracle EBS 12
Role: - HFM design and Development
Location: New Delhi, India
Project Summary: Organization has decided to go for automated consolidation
system and HFM has been identified as the tool for the consolidation.
Hyperion Financial Management has been designed in such a way that it will
produce all the financials required by Religare. Statutory and MIS reports
will be generated using Hyperion Financial Report and Smartview. The
current process of the consolidation is very manual and Microsoft Excel
based. While has being used as consolidation too Oracle Hyperion Enterprise
Management Architect is being used for metadata management. Financial Data
Quality Management is being used to provide feed from Oracle GL system.
My role includes:
. Interviewing Consolidation team and analyzing requirements
. Documenting all requirements in the User Requirement Specification
. Designing Data Model with the help of core accounting team
. Writing relevant section of design document
. Designing and building HFM and EPMA application.
. Setting up Development and Production boxes which include installation
of all required Oracle EPM components.
Client: Hudson Advisors - USA
Tools Used: Oracle OBIEE 10.1.3., Oracle Hyperion System 9.3, Oracle
Hyperion Essbase, OWB 10g
Multi-dimensional Database: Hyperion System 9 Essbase Analytic
Relational Database: Oracle 10g R2
Role: - Onsite coordinator and Developer
Location: Dallas, USA
Project Summary: This Project pertained to the financial domain and it
involved automation of financial reports that were being generated by
different investments of Hudson Americas. Microsoft PowerPoint was the
existing reporting system and Microsoft Excel was being used as the data
feed for these reports. To automate current reporting solution, Oracle's
OBIEE is being used as a reporting solution. Oracle 11g and Oracle Oracle's
Essbase 11.1.1.3 is being used to build data marts and OLAP cube.
In this project the financial data was provided by all different
investments of Hudson America's in Microsoft Excel format, the data is then
cleansed/transformed using an ETL tool of Oracle, called Oracle Warehouse
Builder and then it was stored in a staging area for building data mart in
oracle or OLAP cube in Hyperion Essbase. Once the data is populated in data
mart or Essbase cube, it was acting as a data source for OBIEE dashboards
and reports.
My role includes:
. Interviewing Business Users and Associates and analyzing the client
requirements
. Documenting all requirements in the Business Requirement Document for
all different investments of Hudson
. Designing and creating data input templates for all investments in the
organization
. Developing design document
. Designing and building Hyperion Essbase Cube
. Developing OBIEE reports
. Reconciliation of data
. Publishing reports and provisioning, user's access.
Client: Commonwealth Bank of Australia (Consolidation) - Australia
Tools Used: Hyperion System 9 Financial Management, Hyperion System 9.3.1
Essbase Analytics, Hyperion Interactive Reporting and Smart view Provider
Multi-dimensional Database: Hyperion System 9 Essbase Analytic
Relational Database: IBM DB2 8.2
Role: - Team Member
Location: Sydney, Australia
Project Summary: The project objective was to automate the bank's
consolidation process and it involved a large scale implementation and up-
gradation to HFM 9.3.1 Server from HFM 4.0. Through this project a new
financial setup was established making major changes in the previous
accounting methods used at the client.
The project was divided into two phases. In the first phase, the project
Implementation was done for only one of the subsidiaries of the client.
Subsequently, in the second phase, the complete group of the client was
included in the Project scope.
In this project the transactional data was downloaded from the People Soft
System. Then through Macros, transaction level data was aggregated and
cleaned and loaded into the Relational database. The output flat files so
generated from the database, was then used to build the HFM Application
and load the business data into the Hyperion Financial Management
application on a monthly basis. This data in the application was used to
generate the desired reports as and when required by the end users. More
than 100 Financial Reports and Web Input forms were developed. These
reports were published on the Hyperion server.
My role included:
. Analyzing the client requirements
. Designing and creating generic template for capturing reporting
requirements and Web-Input forms requirements
. Developing Financial Reports
. Developing Reports using Smart View
. Developing Web-Input forms in HFM
. Reconciliation of data
. Publishing reports and provisioning, users access
Client: Commonwealth Bank of Australia (Unified Reporting) - Australia
Tools Used: Hyperion System 9.3.1 Essbase Analytics, Hyperion Interactive
Reporting and Smart view Provider
Multi-dimensional Database: Hyperion System 9 Essbase Analytic
Relational Database: IBM DB2 8.2
Role: - Team Member
Location: Sydney, Australia
Project Summary: The client was a leading financial institution in its
country. The project involved migration of existing Risk Management
reports built on Business Objects platform to Hyperion platform. The client
was maintaining operational data on IBM DB2 Relational Data Source. As part
of transformation into Hyperion, the project involved build OLAP cubes on
Essbase.
Further, in the project, there were two types of reporting requirements,
Standard reports and Adhoc reports. Standard reports were being generated
based on the predefined business requirements. Ad-hoc reports were
developed through Interactive Reports in which user was provided complete
control over the Data Model. This project also involved solving the
performance issues which were present in the earlier reporting system.
My role included:
. Analyzing the client requirements
. Interacting with business users for input
. Understanding existing reporting solution and Business Object
environment
. Developing reports in Hyperion Interactive Reporting
. Optimizations of reports
. Providing ad hoc reporting template in Interactive Reporting
. Reconciliation of Data and Unit Testing of reports
. Providing User Training
Client: Avago Manufacturing Pvt. Ltd. - USA
Tools Used: Hyperion System 9 Essbase Analytics, Hyperion System 9
Interactive Reporting and Hyperion System 9 Web Analysis, Smart view
Provider
Multi-dimensional Database: Hyperion System 9 Essbase Analytic
Relational Database: Oracle 10g
Role: - Team Member
Location: Bangalore, India
Project Summary: This Product an out of box business solution which
provides executives, business users, and analysts with an intuitive user
directed query and analysis tool, accessed through an easy-to-use dashboard
interface. Data was flowing from Oracle 10g to the Essbase using an ETL
tool. The Oracle Warehouse Builder ODS database was the source for loading
data and building dimensions in Hyperion Essbase. Data loading and
dimension building tasks were automated and scheduled through Maxl and Korn
shell scripts for different cubes. After aggregation had completed, the
users could extract the cube data using Essbase Excel Add-Inns. Moreover,
the users were analyzing their data from Essbase as well from Oracle,
reports provided by Hyperion System 9 Interactive Reporting and Hyperion
System 9 Web Analysis.
My role included:
. Analyzing the client requirements
. Designing and creating the cube
. Loading of data and writing calculation script
. Reconciliation of data
. Optimization of the cube, calculation script, restructures time
. Working with DBA to optimize existing reports in Interactive Reporting
. Development of Reports, Unit Testing
. Scheduling Reports
Educational Qualifications
. Masters in Computer Application in 2006 from IEC College of
Engineering and Tech, Greater Noida, U.P Tech University
. B.Sc. (Math) from Magadh University, Bodh Gaya
. Higher Secondary (10+2) from Bihar Intermediate Education Council
. High School (10th) from Bihar Secondary School Examination
Ali Kashif Ansari
Contact this candidate