SUMMARY:

• I am working as Oracle EPM, Hyperion, PBCS, OAC and Business Intelligence area with, with overall more than 10 years of IT experience. I have been in diverse roles such as Oracle Business Intelligence (OBIEE) developer, Hyperion Developer and OBIEE Chief Architect. I have been responsible for OBIEE administration, architecture consultancy, POC’s, technical proposals, presentations, product implementation, project management and providing technical support. I also have played an active part in Enterprise Architecture (EA).
• I was also involved for considerable amount of time in Pre - sales activities where I got the exposure in IT pre-sales communications. In order to better serve my end clients and to come up with holistic solutions, I decided to pursue my Master’s in Business Administration in 2014.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta

Hyperion Analyst

Responsibilities:

• Working on identifying outlines for new applications
• Identify and create mappigs from source to Tableau reports
• Design reports and analysis from updated cubes
• Edit business rules based on new mappings.
• Working with business to gather requirements and to assure fool proof delivery.
• Working closely with technical team and provide guidance with architecture and with technical solution.

Confidential, LV

OBIEE Developer

Responsibilities:

• Working on OBIEE 12 g data visualizer
• Working on Oracle Analytics Cloud to integrate Oracle DV
• Working on financial planning PBCS forms and reports
• Primary point of contact business requirement, technical design and development.
• Create documentation and lead regular sessions to end users
• Work on JSON files to render maps with Oracle as base maps
• Worked on BICC and OBIEE integration
• Developed custom PL/SQL procedures to automate data load in DW
• Created DBMS scheduler jobs to scheduler regular loads

Confidential, Chicago

Responsibilities:

• Working on Hyperion PBCS
• Design and develop new forms as per the business requirements.
• Primary point of contact for ticket and issue, data governance escalates and collaborate with IT on issues that require IT intervention.
• Working on testing for the new forms and prepare test cases for business users
• Providing s for business users.
• Create Qlikview reports and dashboards for BU specific reports
• Create and design PBCS forms and reports
• Create smart lists and utilize them in PBCS forms.
• Working closely with business users to gather requirements and provide them technical design

Confidential, IL

Responsibilities:

• Working on OBIEE 12 g and on Tableau Server
• Design and develop new data model for Spend Summary reports and dashboards
• Primary point of contact for ticket and issue, data governance escalate and collaborate with IT on issues that require IT intervention.
• Create documentation and lead regular sessions to end users
• Work on Supply chain visibility for Pizza Hut, Taco Bell, KFC and A &W
• Establish distributer and suppliers cross mappings.

Confidential, IL

Responsibilities:

• Working on OBIEE 11g 11.1.1.7
• Working closely with business users to gather requirements, perform user testing, business analysis in OBIEE.
• Primary point of contact for ticket and issue, data governance escalate and collaborate with IT on issues that require IT intervention.
• Create documentation and lead regular sessions to end users on how to utilize OBIEE
• Working in OTBI for PoC for internal project
• Work on Sales dashboards for sales and marketing people.
• Worked on BI Publisher, for automated report bursting features.
• Working on custom reports designed from multiple data sources.

Confidential, IL

Responsibilities:

• Working on Oracle Hyperion and Financial Management, Hyperion Planning
• Working closely with business users to gather requirements, perform user testing, business analysis in Oracle Hyperion Planning.
• Creating and maintaining Hyperion Financial Planning Reports using Financial Reporting Studio.
• Working in Hyperion FDM, FDQM
• Evaluating OTBI, OBIEE cloud for reporting off HCM system.
• Designing and developing financial reports for the newly defined requirements.
• Working in Calculation Manager to modify MDX query to bring correct data.
• Administering Planning application, using shared services console, and to manage security and LCM application migration

Confidential

Responsibilities:

• Work on Oracle R12 Oracle HRMS to maintain and manage UL employees records
• Working on OBIEE 11g upgrade from 11.1.1.7 to 11.1.1.9
• Working closely with business users to gather requirements, perform user testing, business analysis in OBIEE and in Fusion OTBI reporting
• Assist with change management of Oracle Apps, Fusion and conduct, testing, and ongoing support for the developed solution.
• Provide guidance in Hyperion Essbase planning application for setting up Plans
• Primary point of contact for ticket and issue, data governance escalate and collaborate with IT on issues that require IT intervention.
• Working in Oracle Transactional BI (OTBI)
• Working in Hyperion FDM module to consolidate dimensions.
• Working on the Oracle Fusion performance management suite and deal with functions and understand how those functions interact with the Oracle HRIS system in all facets.
• Create documentation and lead regular sessions to end users on how to utilize Oracle HRIS system.
• Interfacing Oracle HCM with OTBI system
• Serve as the technical point of contact for data integrity and analyzing data trends.

Confidential

Responsibilities:

• Detailed analysis of the current Oracle EPM environments
• Review and prepare for hardware installation for Test and Production
• Installation on the existing hardware
• Develop high level plan with timelines and resources to execute reporting activities
• Identify resources to complete tasks within plan
• Confidential would upgrade Hyperion 11.1.2.1 to 11.1.2.3 on 2 existing Windows server environments for the following products:
• Hyperion Shared Services
• Hyperion Workspace
• Hyperion Essbase
• OBIEE Dashboards and reports
• OBIEE prompts and filters
• Hyperion SmartView (or Excel Add-In)- Consolidation and Balance Sheet reporting, P&L, ad-hoc reporting.
• Hyperion Financial Reporting

Confidential

Responsibilities:

• Working as a functional and technical team lead for Oracle EPM.
• Working with business to come up with required strategy for making the IT lean and agile.
• Working on Hyperion Essbase Planning and OBIEE Administrator
• Responsible for creating and maintaining Hyperion plan types
• Working in Hyperion FDM module.
• Responsible for migrating Hyperion migration using LCM utility and using manual process
• Working on Amazon Cloud EC2 for Hyperion Planning, and Hyperion Essbase setup and configuration providing estimations, project plans and guidelines and working closely with project mentors
• Working to deliver Consolidation and Balance Sheet reporting, Profit and Loss reporting, Financial Close Management Process and ad-hoc reporting.
• Generating the efficiencies during the project execution and implementation.
• Working on planning and preparations for upgrade to OBIEE 11g and OBIEE 10g
• Working on user adoption strategies for increased BI and Analytics usage

Confidential

Responsibilities:

• Working on Conversion and report migrations for OBIEE 11g
• Working on point upgrades of RPD upgrade using utility and webcat upgrade
• Interact with business users for requirement gathering
• Working on Hyperion Essbase migrations and upgrades
• Working as OBIEE Administrator and OBIEE developer
• Working as Oracle EPM/FDM team lead, for offshore team
• Working on Hyperion migration, application setup, plan application administration
• Working on Essbase Calc Scripts and load rules
• Providing estimations, project plans and guidelines and working closely with project owners
• Generating the efficiencies during the project execution and implementation.
• Working on OBIEE 11g and OBIEE 10 g

Confidential

Responsibilities:

• Working on Oracle EPM support.
• Hyperion EPM point upgrade from 11.2.0.1
• Working closely with business users to gather requirements, perform user testing, business analysis
• Supporting business users on Hyperion Essbase and OBIEE reports
• Working on OBIEE Admin tool to design data model
• Working as a Oracle EPM team lead, for offshore team
• Providing estimations, project plans and guidelines and working closely with project owners

Confidential

Responsibilities:

• Working on Request for Proposals (RFP)
• Providing benchmarking standards for OBIEE performance on various metrics, providing estimations, project plans and guidelines and working closely with project mentors
• Generating the efficiencies during the project execution and implementation.

Confidential

Responsibilities:

• Worked extensively on OBIEE Answers to create the reports as per the business requirements.
• Worked on Hyperion Essbase Planning application for financial reporting
• Worked on rule files, calc scripts custom MDX scripts and Hyperion migration
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Configured intelligent dashboards by including embedded content such as links/images & HTML objects.
• Working as a coordinator for offshore team and for Business and mapping the functional requirements with technical feasibility.
• Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards & answers.
• Created iBots and Delivers to send alert messages to subscribed users.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.

Confidential

Responsibilities:

• Translated business requirement into reporting matrix in Siebel Analytics.
• Built the Physical layer/Business Model and Mapping Layer/Presentation Layer of a Repository by using Star Schemas.
• Customized Mappings and used Aliases in Physical Layer.
• Participated in Adding Calculations to a Fact Table for various reporting requirements.
• Created Dimension Hierarchies and Level-Based Measures for Business requirements.
• Used Aggregate Tables and specified Aggregate Levels for each source.
• Mapped Dashboard field requirements to Siebel OLTP/OLAP Physical/Business Model.
• Designed and customized Siebel Answers Views and Charts, Create and save filters, Create Charts and Tables in Siebel Answers.
• Developed general ledger and payable analytics reports in Financial Analytics.
• Involved in Performance Tuning of reports, created bitmap Indexes, Materialized Views and Table Partitions.
• Used Metadata Design Principles to Design Repository based on business requirements and followed best practices.
• Set up Analytics Server Security to control access given to business users.
• Created and granted privileges for the users using Analytics Catalog Manager
• Used DAC for scheduling and running the ETL jobs, for this OBIEE Sales Analytics Application

Confidential

Responsibilities:

• Worked closely with Business Analyst in understanding the Analytics requirements and generated reports as per the user requirements.
• Converted the Functional Specs to technical design and designed the overall rpd metadata development methodology.
• Involved in RPD Modeling which includes building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business Model and Mapping layer. Established the logical joins/keys required to support drill-down aggregation.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the OBIEE Repository.
• Implemented security by creating roles & web groups, checks with LDAP Authentication.
• Developed Dimensions and Time Series objects in the Business Model and Mapping Layer with Security settings in Analytics Admin Tool to setup groups, access privileges and query privileges.
• Developed reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly sales for each region & send alerts to upper management.
• Configured metadata objects (Subject Area, Table and Column) and Web Catalog Objects (Dashboard, Pages, Folders and Reports).
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.