OBJECTIVE

• To associate with an organization where technical and functional skills are being used contributing directly, in meeting company goals and becoming an integral part of corporate strategy, financial plans and collaborations.

SUMMARY

• 5+ years of experience in planning, developing, & maintaining Hyperion application and other financial software products
• Experienced in narrowing down technical needs based on requirements
• Excellent understanding of Oracle Hyperion Enterprise Performance Management Architect (EPMA) and related tools
• Excellent understanding of the development and communication of the plan/budgets and forecasts for multiple divisions/companies including operational analysis and executive reviews for Actuals and Business Plan
• Clear understanding of the creation of financial reports including monitoring of reported results vs projections and variation analysis
• Created dashboards pivots, charts, reports using Hyperion Planning dashboards/ Hyperion Financial Reporting Studio
• Quick learner with proven track record of learning and delivering best solutions without hand - holding or supervision
• Excellent presentation, written and oral communication skills
• Functional expert to gather and refine business, functional, and data requirements
• Rewarded as Confidential BEST PERFORMER 2014
• Advanced proficiency in MS Excel (pivot tables, vlookups, etc.)
• Excellent development and team leading qualities

TECHNICAL SKILLS

EPM Suite: Enterprise Planning and Budgeting Cloud Service (EPBCS), Planning and Budgeting Cloud Service (PBCS), Hyperion Planning different modules like Workforce, CAPEX, PSB etc, Hyperion Calculation Manager, Hyperion Financial Management (HFM), Hyperion Essbase, Hyperion Shared Services (HSS), Calculation Scripts, EPM Automate, Multidimensional Expressions (MDX’s) scripts, Hyperion Smart View, Excel Add-in, Hyperion Planning Admin Extension

Reporting Tools: Hyperion Financial Reporting, OBIEE, Web Analysis

ETL Tool: Financial Data Management, Financial Data Quality Management Enterprise Edition (FDMEE)

ELT Tool: Oracle Data Integrator (ODI)

Application Software: MS Office (MS Word, MS PowerPoint, MS Excel)

Accounting Software: Tally ERP 9.0

PROFESSIONAL EXPERIENCE

Hyperion Analyst

Confidential

Responsibilities:

• Assist in the design and development of Project Forecast and Revised Budget processes for the business,
• Expertly managing development and testing of business rules and calculation scripts on the cloud Hyperion Planning & Essbase application as per the requirement of users,
• Was responsible for building financial reports for management using Hyperion Financial Reporting 11.1.4 and Smart view,
• Created budget book report by using Financial Reporting Studio and Web analysis,
• Enhanced and developed budgeting, reporting templates and ad-hoc reporting using the smart view for office,
• Involved in the Optimization of Business Rules and calculation scripts,
• Involved in the analyses of raw financial data as well as compilation/consolidation of reports, graphs and presentations,
• Providing consultation/support to the client on various financial statement matters and performance related issues if necessary,
• Was involved in maintaining and administering security permissions for users and groups,
• Created documentation of all the technical and functional issues which would be helpful to users for future reference,
• Scheduled training sessions with user(s) on implemented processes and/or systems.

PBCS Lead/Hyperion Analyst

Confidential

Responsibilities:

• Involved in gathering requirements from financial and business users for developing a project plan,
• Designed the whole process flow for planning and budgeting for the client,
• Created the planning application in PBCS and built the standard dimensions Period, Year, Scenario, Version, Entity, Account (manually/ automated ) with attributes as per the requirement,
• Developed metadata load files for additional dimensions as per PBCS standard format to load metadata using excel vlookups & concatenate functions,
• Developed web based budget and forecast data entry form with in PBCS,
• Created the application in EPBCS with the initialization of different modules like Financial Planning, Workforce, CAPEX etc. for one of the client requirement,
• Migrated on-premise Hyperion Planning to Hyperion Planning and Budgeting Cloud Service (PBCS) 11.1.2.4 version,
• Created data Smart Push and attached them to EPBCS input forms to move data when users save input data,
• Utilized EPM Automate for daily aggregation and backup jobs on PBCS,
• Preparation of revenue & expense budgets and forecasts, financial reporting (monthly /quarterly /annually) and analysis, operational and management reporting,
• Retrieval/submission of data & metadata to the PBCS application using either EPM automate utility or Hyperion Planning Admin Extension taking PBCS as the source connection,
• Integrated the historical data from ERP to PBCS & loaded the budget data using FDMEE/ smart view/ web forms,
• Developed business rules for flipping sign for the Balance Sheet accounts as the data has been imported from the transactional system,
• Created the security roles for managing planning unit hierarchy (PUH),
• Created security groups and roles to enable the provisioning of users in PBCS using Hyperion Shared Services (HSS),
• Involved in the drill through functionality using data sources as PBCS application to Oracle General Ledger using FDMEE,
• Managed Hyperion Financial Quality Data Management (FDMEE) System involving all source and target mappings, mapping validation & mapping of any validation errors, review and analyze process monitor & audit reports and exporting data to ensure that all legal entities have properly loaded data
• Ensured proper documentation of the environment and operational processes,
• Delivered high quality & scalable solution to sales team as per industry requirements.

Techno-Functional Consultant

Confidential, Houston, TX

Responsibilities:

• Upgraded client’s current Hyperion version 11.1.2.1 to higher version 11.1.2.3,
• Root cause analysis and solution of the issues in current production environment,
• Gathered requirements from clients and assignment of the plan of action to colleagues,
• Involved in the bottom - up planning and budgeting cube creation as per the client requirement,
• Involved in the creation of the consolidation cube for unified reporting and integration information system,
• Worked on the restructuring of the metadata for the shared hierarchies using Smart View,
• Data loading to both the planning and reporting cube using Smart view taking Planning as the source connection,
• Worked on both the Block Storage Option Database (BSO) and Aggregate Storage Option Database (ASO) in Hyperion Essbase,
• Creation of data forms, task lists, user variables, substitution variables and smart lists,
• Scripting of calculation scripts like data export script, data copy script, allocations script, etc.,
• Scripting of business rules,
• Worked on ELT (Extract, Load and Transform) tool for actuals and historical data load into reporting cube (ASO) for,
• Worked on ETL (Extract, Transform and Load) tool for actuals data load into planning(BSO) cube,
• Built financial reports using FR and OBIEE tools with added customizations using my own functional skills,
• Interacting with our product support team to troubleshoot client problems and resolve client questions,
• Reviewing client product features requests with product management and development,
• Delivered high quality & scalable solution to client for his financial consolidated planning, budget, forecasting,
• Travelled to the US for providing support during different phase of projects.

Essbase Developer

Confidential, Houston, TX

Responsibilities:

• Conversion of BSO cube to ASO cube,
• Writing member formulas in MDX for ASO cube,
• Writing report scripts for data export of ASO cube,
• Understanding client’s requirements for developing new scripts and proposed solution related to technical and performance aspects,
• Documenting issues and solutions,
• Retrieving and submitting data using Smart view taking Essbase as the source connection,
• Building ad-hoc analysis reports using Smart View ad-hoc grids.

Essbase Developer

Confidential

Responsibilities:

• Integration of Essbase Studio with Essbase,
• Worked on production issues involving root cause analysis and providing solutions for them,
• Documenting issues and solutions.

Assistant Finance Manager

Confidential

Responsibilities:

• Preparation of consolidated financial statements,
• Managed billing related issues, researched and resolved audit issues,
• Drafting reports to company management identifying weaknesses in the company’s systems and controls and making recommendations for their improvement,
• Analysis and commentary on variances (Actual V’s Budget),
• Audited turnover, budgets, and forecasts reports.

Senior Auditor

Confidential

Responsibilities:

• Lead teams in the execution of audit & assurance assignments of reputed organizations to ensure the fair presentation of financial statements,
• The main aim is to identify the weaknesses and frauds committed and recommend improving the process to the outcome the identified shortcomings,
• Conducted Audits of various pharmaceuticals, retails, manufacturing concerns.