SUMMARY:

• 9.4 years of total work experience with 7+ years of exper ience in Business Intelligence and Hyperion Technologies
• Expert in Financial Data Quality Management (FD QM) and Hyperion Financial Management (HFM)
• Proactive professional with demonstrated capability to acquire and apply knowledge proficiently and achieve the desired results within shrinking deadlines
• Experience in working through all phases of Application Development Life Cycle, comprising the design, development, implementation, and support/enhancement
• Capable of suggesting appropriate technology based solution for enhancement of efficiency and achieving the business excellence
• Lead a team of 10 and capable of performing all team management activities
• Substantial experience in HFM Application creation / maintenance, Metadata creation / maintenance, Implementation of Intercompany Transactions and Data form / grids creation etc
• Expert in implementing Oracle ARCS (Account Reconciliation Close Service) starting from designing the formats, creating profiles,reconciliation rules, workflow and system settings in Compliance module.
• Expert in implementing Oracle ARCS (Account Reconciliation Close Service) starting from creating calendars, Data Sources, Reconciliation types, Transaction Matching types and setting up Matching process in Matching module.
• Implemented projects with Oracle FCCS (Financial Cloud and Consolidation Service) and de veloped artifacts starting from Metadata creation/updates, setting up Ownership module, catering to Intercompany eliminations in FCCS, designing web forms and data grids, creating validation accounts, Data locking
• Have given demos to the client on the cloud products FCCS and ARCS
• Created direct integration to ERP GL from FCCS/ARCS and pulled data from ERP GL to FCCS/ARCS using Data Management
• Expert in Oracle Data Management and EPM Automate
• Good experience working EPMA applications along with classic Hyperion applications.
• Worked in EPMA 11.1.2.4 version mainly in HFM and FDMEE along with older versions of EPMA and Classic versions
• Knowledge in migration, reconciliation, development of Hyperion Financial Applications, Hyperion Financial Data Quality Management Applications
• Experience in migration, upgrade and configuration of Hyperion Financial Management
• Good at writing FDM scripts using VB
• Good at developing HFM Business rules
• Certified Hyperion Financial Management 11 Implementation Specialist
• Oracle Certified Associate

SYSTEM EXPERIENCE:

• Oracle Hyperion Financial Management(HFM) - Expert
• Financial Data Quality Management (FDQM) - Expert
• Oracle Financial Reporting - Expert
• Oracle Account Reconciliation Cloud Service (ARCS) - Expert
• Oralce Financial Consolidation and Cloud Service - Project Experience
• Data Management - Expert
• VB Scripting - Project experience
• Unix, Windows 95, 98, 2000, XP,VISTA, Windows 7, Windows 8, Windows 10,
• Oracle Database - Project experience
• PL/SQL - Project experience
• Informatica -Project experience
• Sybase -Project experience
• Microsoft Office 2007 -Expert

PROFESSIONAL EXPERIENCE:

Confidential

FCCS Offshore Lead

Responsibilities:

• Convert functional requirements into technical objects
• Provide suggestions on the FCCS design aspects to Onshore team
• Design FCCS system based on the client requir ements
• Analyze user stories and discuss with business to close the gaps
• Implemented Ownership management module to cater to proportional consolidation requirement
• Currently leading a team of 5

Technical Environment: : - FCCS, Data Management, ERP GL

Confidential

FCCS Technical Expert

Responsibilities:

• Created custom validation rules using member formulae in FCCS
• Deployed FCCS Balance out of the box rule in FCCS and created validation sheets based on this rule
• Explored and implemented data locking process in FCCS
• Provide suggestions on the FCCS design aspects
• Design FCCS system based on the client requirements
• Analyze user stories and discuss with business to close the gaps

Technical Environment: : - FCCS, Data Management, ERP GL

Confidential

ARCS Lead

Responsibilities:

• 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 reports
• Designed security set up as per the requirements
• Created artifacts in both compliance and matching modules per business needs
• Travelled to client location and provided User KT to Business Users
• Migrated Data Management from One environment to another

Technical Environment: : - ARCS, FCCS, Data Management

Confidential

ARCS Offshore Lead

Responsibilities:

• Understanding the requirements from Onsite and converting them to technical build objects
• Designed ARCS design and developed artifacts as per requirements
• Created test data for reconciliations
• Built integration layer to load data to ARCS from FCCS balances
• Worked in security and process management
• Worked on developing FCCS components
• Worked on maintaining metadata in FCCS

Technical Environment: : - ARCS, FCCS, Data Management

Confidential

ARCS offshore Lead and FCCS Developer

Responsibilities:

• Understanding the requirements from Onsite and converting them to technical build objects
• Designed ARCS design and developed artifacts as per requirements
• Created test data for reconciliations
• Built integration layer to load data to ARCS from FCCS balances
• Worked in security and process management
• Worked on developing FCCS components
• Worked on maintaining metadata in FCCS

Technical Environment: : - ARCS, FCCS, Data Management

Confidential

HFM/FDM Consultant

Responsibilities:

• Understanding the requirements from Onsite and converting them to technical build objects
• Developed of FDM maps for 100s of locations
• Managed USI-Hyderabad team and also provided guidance to the team members in Mumbai location
• Developed HFM objects like data grids, data forms and journals
• Worked in security and process management
• Provided user support post go-live
• Developed HFR reports
• Prepared documentation for HFM, FDM and Unit test cases
• Developed FDM scripts

Technical Environment: : - HFM 11.1.2.3, FDM Classic, HFR

Confidential

HFM/FDM Consultant

Responsibilities:

• Got requirements knowledge from onsite/client team and played vital role to explain the same to the team members
• Involved in the development phase of the project particularly in writing rules and testing the rules with respect to HFM
• Developed scripts (Custom Scripts) in FDM and involved in the development of maps
• Performed reconciliation activities and made sure that all the accounts are mapped accurately (close to 15000 reports). As this client has global presence, validation of money movement for each division is a must
• Performed migration activities in HFM as well as in FDM
• Performed unit, system and integration testing between HFM and FDM

Technical Environment: EPMA 11.1.2.2, Classic HFM, FDM

Confidential

Functional Tester

Responsibilities:

• Analyze the functional and technical requirements and create design documents including test plan, test scenario document and test cases.
• Prepare test data according to the requirement using facets front end tool.
• Test execution to cover all the scenarios and test cases and also capture the test metrics.
• Documentation of the test results and client deliverables and also if any knowledgeable documents for the growth of the team.
• Involved in preparing the release notes and go live documents

Technical Environment: : Facets tool, Sybase, Clear Quest, RTM

Confidential

Business Technology Analyst

Responsibilities:

• Developed and testing some of the modules in the project
• Involved in the bug fixing of the defects raised by the testing team in Informatica
• Gained Informatica skills
• Improved database and ETL testing skills
• Played the role of the testing expert in the team to mark whether the defects existing are valid or invalid
• Helped the team to get accustomed with the HP Quality center and maintained smooth flow in the defect testing phase
• Involved in preparing the release notes and go live documents

Technical Environment: Informatica 8.6.2,Oracle 10g, TOAD, QC 9.2

Confidential

Business Technology Analyst

Responsibilities:

• The primary objective of the project Church Unit Confidential System is to replace the current systems (LURBS, CFAR, MLS, and REFIS). This has four major modules like Donations, Disbursements, Reconciliations and Bank Management.
• Donations describe the process of receipting contributions & revenue from donors or customers by various channels.
• Disbursements are the process of disbursing money for various Church activities (E.g. Fast Offerings) by various channels & by using different instruments.
• Reconciliations is the process and activities covering reconciliations of donations receipted, disbursements made etc. as a result of all financial transactions.
• Bank Management involves the activities of estimating cash balances, moving cash between accounts & managing other related activities, such as account setup and data transfers
• Understanding, analyzing and identify gaps in the Functional Specification documents
• Understanding the technical design documents
• Have very good understanding and Knowledge in QC (Quality Control) tool and its components like Test Plan, Test Lab, Requirements and Defects
• Creation of Test cases
• Execution of test cases manually
• Execution of test cases using oracle database and scripts
• Worked actively with database(SQL) and backend modules other than online application
• Took complete ownership of two modules(which involves Backend, Reports and Online sections) which are considered as most complex modules in my project and held responsible from the phase of functional specifications analysis to defect raising phase
• Through testing of Backend modules I became expert in SQL and gained knowledge in Data Base scripting as well.
• Had project knowledge on SAOP UI tool, Job scheduler tool called ‘TIDAL’.
• Had project experience to perform Testing through BODI tool
• Had an experience to work with FileZilla for processing files
• Familiar with UNIX commands and UNIX server
• Actively involved in knowledge sharing on the modules to the team members
• Received applause award for my contribution in the project.

Technical Environment: Oracle 10g, TOAD, QC 9.2, BODI

Confidential

Integration Developer

Responsibilities:

• Developed, tested and documented the building of an interface.
• Developed an Interface starting from analysis of the business requirements, design, coding and testing
• Developed unit test cases and successfully completed testing of the interface.
• Analyzed and understood the technical documents of Business Process Transformations and gave a presentation to the offshore team on the same

Technical Environment: TIBCO, TOAD, Oracle 10g