PROFESSIONAL SUMMARY

• 11+ years of experience in Banking & Pharmaceutical domain ( 8 years in Hyperion Suite of applications)
• Possess expert knowledge in Hyperion Financial Management Design & Development
• Hands - on experience in Data Relationship Management (DRM) & FDMEE mapping
• Rich experience in financial accounting process (GL, Reconciliation, Analysis of Financial Statement)
• Working experience & knowledge in US GAAP & IFRS standards
• Hand-on experience in developing HFM Rules, Member list creation, metadata creation in DRM 11.1.2.3
• Expert knowledge in Web Analysis dashboard, Hyperion Financial Reports & SmartView Development
• Prince2 Practitioner with 3 years of strong Project Management experience
• Pursuing CPA from New York State Board of Public Accountancy
• Strong function knowledge on the financial close & consolidating reporting/ process
• Well versed with Group & site level planning (ROP & AOP) cycle, budgeting & forecasting activities.
• Green Belt certified and four Yellow Belt project done in the process with a fair knowledge in SIX SIGMA lean
• Expert knowledge in MS-Excel, MS-Access, VBA Macro & working knowledge in SQL

TECHNICAL SKILLS

• Degree and Date
• Institute
• Result
• Major Subject
• CPA
• NYSBP, New York
• Pursuing
• AUD, BEC, FAR, REG
• M.Com. 2005
• Berhampur University, Odisha
• First Division
• Accountancy, Financial Reporting, Statistics

PROFESSIONAL EXPERIENCE

Confidential, Boston

Lead Hyperion Consultant

Responsibilities:

• Created all mapping to from GL to Hyperion system
• Created the new GRCA structure for the Order 2 Cash system
• Revised the new schedules Revenue, Cost, Asset, Liabilities to be created for Order 2 Cash system
• Custom dimension were changed to provide more analysis & granular level of data
• Hybrid hierarchy was created basis fully used, partially used & not used base accounts
• Differences have been captured in a control hierarchy
• Automation rule developed to replace manual journal entries
• Rules developed for creating more validation for data integration check
• Created more global variables, array and lists to avoid generation of them during Sub routine
• Relevant entities & hierarchies changes
• Removed all NIP accounts & unused customs
• All Metadata labels were created in uppercase

Confidential

Reporting team

Tool used: HFM 11.1.2.3, DRM, HFR Studio 11.1.2.3, Smart View, FDMEE 11.1.2.3Team Size: Fifteen, worked as Lead HFM Analyst

Responsibilities:

• Involved in the end to end implementation of the project.
• Involved in the preparation of BRD, FRD, SRS documentation.
• One Primary GRCA Chart of Accounts were setup for both IFRS & Global Business
• To implement IFRS9 requirement 8 custom dimensions were set up
• Rules development for Data Copy, Validation, Journal automation & ICP elimination
• Involved in the development of more than 500 complex Reports & Webform
• Prepared the metadata for creating the application.
• Involved in the creation of Test scenario, Test Cases, Test Script & Traceability matrix
• Created the HBEU Validation tool which regulates more than 5000 validation accounts
• Partially involved in the rule & member list creation.
• Providing training session & Go Live support to the users.

Confidential

HFM Analyst

Responsibilities:

• Involved in the end to end implementation of the project.
• Involved in the preparation of BRD, FRD, and SRS documentation.
• Created the new hierarchy structure in DRM
• Involved in the development of more than 500 complex Reports & Webform
• Prepared the metadata for creating the application.
• Involved in the creation of Test scenario, Test Cases, Test Script & Traceability matrix
• Created the HBEU Validation tool which regulates more than 5000 validation accounts
• Partially involved in the rule & member list creation.
• Providing training session & Go Live support to the users.

Confidential

Hyperion Developer

Responsibilities:

• Involved in the end to end implementation of the project.
• Created the structure using DRM using automator and blender functionality
• Involved in the requirement gathering process.
• Setting up the Cash-flow statement, established the ICP elimination set up.
• Partially involved in the HFM rules creation.
• Fixing the defects rose during the UAT & Go Live support.

Confidential

Hyperion Developer

Responsibilities:

• Involved in Rolling Operating Plan (ROP) & Annual Operating Plan (AOP) of Group MI & Planning team.
• Possess strong knowledge in Group & site level planning activity.
• Created the structure in Oracle DRM
• Work closely with business stakeholders to understand business requirements.
• Developed various templates linked to Hyperion Planning for data input, adjustment & data reconciliation.
• Developed various Hyperion Planning reports & dashboards for the users & higher management.
• Queries Management (data reconciliation between HFM to Hyperion Planning, admin help to site users to populate data, data transfer from staging cube to reporting cube).
• Process Management (opening & closing of periods & entities for reporting, loading exchange rate etc)

Confidential

BI Developer

Responsibilities:

• Involved in the end to end implementation of the project.
• Designed & developed 200 complex reports in HFR studio to replace the existing drillers.
• Created a VBA macro to split excels exported report in to multiple sheets.
• Fixing the defects rose during the UAT & Go Live support.
• Testing all new features/functionalities created during the course of development.
• Creating Test scenario, Test Cases, Test Script & Traceability matrix
• Developed more than 300 data forms in the new application.
• Created more than 600 complex multi grid HFM reports.
• Fixing the defect in the UAT phase using HP Quality Centre, training & Go Live support to the users.

Confidential

Business Analyst

Responsibilities:

• Involved in the preparation of BRD, FRD documentation.
• Creating specification files (SPEC) and taking sign-offs from Business Owner.
• Involved in the design on creation of 125 of High Level of Dashboards created.
• Involved in the brainstorming session of designing the dashboards.
• Leading weekly call with stakeholders from different region and sites
• Training & Go Live support to the users.

Confidential

Hyperion Support Lead

Responsibilities:

• Liaising with Working Group & other regional team to analyze the impact of proposed Change Request(CR)
• Creating & modifying new business units/entities & hierarchies.
• Modifying & creating HFM rules as per the business requirement & setting up security for them.
• Developing complex reports in HFR Studio, maintaining 1000+ reports for the Global users of HSBC.
• Creating new & modifying existing member list to write rule efficiently & to meet business requirement.
• Deploying the changes in to Hyperion Planning application.
• Queries Management (data reconciliation, dispensations, data and task audits, phased submissions).
• Loading Metadata, Security file, Member list, Rule file in the system.
• Liaising with Oracle for any performance/functionality issue.

Analysis

Confidential

Responsibilities:

• Successfully migrated General Ledger CR&A process for HEBU region from GHQ London.
• Involved in the GL migration from existing Mainframe system to FTP (People-Soft GL)
• Monitoring various control account on a daily & monthly basis.
• Closing of Financials monthly & quarterly basis
• Passing CPA(Close Period Adjustment) entries, doing Monthly certification, ageing analysis, raising exception
• Review of overnight batch, feed issues that led to error/suspense items between GL to other sub systems.
• Doing the critical Treasury Funding Activity on a daily basis.
• Doing the critical Intercompany reconciliation activity.
• Created Group level adjustment entity for different currency which was highly appreciated.
• GBM Driller Project automation led to 1 FTE (Full Time Employee) Saving (Green Belt Project)
• Automation done on COGNOS Report. Benefit: Saving of 250 Hrs & 25000 sheets of printed papers p.a.
• Q4 2011 won prestigious 100 clubs Member for contribution in QTA, HTA, CCS, BPR reports.
• Reduction of Query Handling Time by 50% in HFM Helpdesk largely appreciated by the Management.

Confidential

Accounts Officer

Roles & Responsibilities:

• Recording Journal entries and preparing Ledger accounts for various parties
• Day to day preparation of cash flow and Bank reconciliation statements.
• Responsible for the finalization of Accounts, i.e. preparing P & L Account and Balance Sheet