CAREER OBJECTIVE:

Looking for a suitable BI Manager/lead role to utilize my skills based on my experience on the technologies (OBIEE, Hyperion, BI APPS, Informatica) on Unix/Windows Platforms across the ERP source systems (Oracle EBS R12 Financials, SAP, PeopleSoft HR, Salesforce CRM and Workday) and contribute towards the development of the organization.

PROFESSIONAL SUMMARY:

• Experience of 8+ years in OLAP design, analysis, architecture, development, implementation, reporting, administration, and migration of various applications in client/server environment using Hyperion Essbase, Hyperion Planning, Hyperion Workspace, OBIEE 10g/11g, Informatica Power Center 9.x, SAP Data Services, OBIA/BIAPPS 7.9.6.4 HR/Financial Analytics, Cognos, Hyperion Reports, Essbase Spread Sheet Add - in/Smart-view, Oracle Database 11g on Unix and Windows environments.
• Proven experience in implementing complete software life cycle involving various phases of design, development and implementation of Data Warehouses & Data marts with OLAP and OLTP Tools on Oracle/SQL Server/Sybase using both SQL and TSQL.
• Capable of supporting multiple technologies/applications and projects which includes several BI applications across the source systems EBS Finance, Salesforce CRM, Workday and PeopleSoft HR.
• Expertise in administrative tasks of Essbase managing applications and databases, Essbase architecture, data and dimension loading, Calc Scripts, MaxL, Report Scripting and Performance tuning.
• Experience in working with Aggregate Storage Outline (ASO) and Block Storage Outline (BSO).
• Experience in Hyperion System 11 and 9.3.0 modules (Hyperion System 9+Analytic Services, Hyperion System 9 planning, Interactive Reporting, Financial Reporting, Production Reporting and Dashboards).
• Expertise in Installations, configurations and Implementations associated with Hyperion and OBIEE/OBIA Product suite on Linux Platforms including the Weblogic Server/JDK configurations.
• Responsible for the configuration of OBIA Financial analytics (GL, AP, AR & Profitability) and the delivery of Out-of-the-Box reports (OOTB)
• Experience in OBIEE Administration and Presentation Services including RPD, Webcat, Analytics, Interactive Dashboards, Delivers/IBOTS, Cache Management, Scheduler Configuration, BI Publisher.
• Experience in developing Cubes, Calculation Scripts, in Essbase and Business rules in Planning.
• Experience in leading teams consisting of both employees and vendor resources in multiple locations and time zones.
• Proven track record of successful implementation of all project lifecycle stages from implementation and enhancements.

PROFESSIONAL EXPERIENCE:

OBIEE/Hyperion Lead

Confidential, Marlborough, MA

Responsibilities:

• Leading small to mid-size projects and individually completing complex work requests with user satisfaction under minimal guidance.
• Lead an OBIEE, Hyperion and EBS team (offshore/onsite model) ensuring design, development and testing work is completed to standard and on time.
• Responsible for Developing, Enhancing, Optimizing, Migrating Hyperion ASO application associated with 5 BSO application into 11.1.2.4 from 11.1.1.2.
• Successfully installed Hyperion EPM 11.1.2.4 on Linux environment and configured with Oracle Application Server (Web Logic server)
• Responsible for migrating the Finance reports from Cognos to OBIEE Environment.
• Worked closely with Accounting Team, Finance Team and P&L Team in gathering Hyperion Planning, budgeting and Reporting requirements, created Functional and Technical Documents for Planning and Reporting requirements.
• Worked on procedures related to Planning, Allocations with finance and business users to understand requirements and translated them into Essbase tasks and vice versa for other Essbase users
• Involved in design and development of ASO and BSO cubes to support Planning, Forecasting and Reporting.
• Developed various reports for reconcillation of the data between hyperion and workday.
• Migrated Cubes, rules, calculation scripts, reports and other artifacts from Dev to testing and production environment’s and Performed Migration validations.
• Perform the Unit Testing of Dashboards and Reports in OBIEE 11g.
• Performed the Installations, configurations and administration of OBIEE 11.1.1.7.1.
• Coordinate with the Business Head in the decisions involving the purchase of new IT Technologies, Softwares & Evaluation of Vendor Services.
• Upgraded the OBIEE weblogic server from 10.3.5 to 10.3.6 including the JDK components.
• Worked on the Organisation Logo changes on the OBIEE Login and Home page.
• Worked on OBIEE 11g RPD regarding the Customizations and Enhancements as per the Client requirement as part of the Organization recent acquisitions and inclusion of new pharma products for customers.
• Development and maintenance of OBIEE HR dashboards weekly, monthly, quarterly, annual reports, Headcount, Hires, Terminations, Offcycles, Merits, Global Compensation & Turnover reports to outline and analyze some of the following: workforce trends, quarterly dashboards, monthly reporting with detailed analyses, risk/cost assessment for wages and Rollover.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Worked on performance tuning to increase the performance ofHyperionproduct (heap size tuning, OS tuning etc) and Essbase Optimization techniques.
• Involved in the Disaster Recovery Activities (DR) for Hyperion and OBIEE applications including the Backup Strategies.

Environment: OBIEE 11.1.7.1, BI Publisher, Hyperion EPM Suite 11.1.2.4, Hyperion Essbase, Hyperion Planning, Hyperion Workspace, Informatica 9.x, EBS R12 Finance, Cognos, Salesforce CRM, Workday, RedHat Linux (RHEL), Cisco Tidal Scheduler, Windows and VMware.

OBIEE/Hyperion Senior Consultant

Confidential, Hoboken, NJ

Responsibilities:

• Lead for the Tracks OBIEE, Hyperion and Informatica, Co-ordinated with both Onsite and Offshore teams.
• Performed Daily and Monthly system maintenance by loading actuals for period close and ran the period close calculation scripts.
• Migrated Cubes, rules, calculation scripts, reports and other artifacts from Dev to testing and production environment’s and Performed Migration validations.
• Worked on top of service requests with Oracle and resolved all open issues with the help of Oracle support.
• Maintenance and Optimization Of all the application and backend day to day jobs on ASO and BSO applications with latest Optimizing Implementation of ASO parallel Buffer data loading trimming down huge ASO loads from 4 hours to 40 minutes.
• Gathered Business requirements, interacted with the business users, defined subject areas for analytical data requirements.
• Responsible for the Installation of OBIA/Oracle BI APPS 7.9.6.4, OBIEE 11.1.1.7, Informatica Power Center 9x & DAC 11g.
• Worked on Physical, BMM and Presentation layer of the Oracle Business Intelligence Admin tool to create the physical and business model diagram and the logical hierarchies.
• Created workflows for full load and incremental loads to be used by DAC.
• Responsible for the configuration of OBIA Financial analytics (GL, AP, AR & Profitability) and the delivery of Out-of-the-Box reports (OOTB).
• Created the Installations & Configuration guides for the implementation of OBIA 7.9.6.4 Financial analytics.
• Worked on the Data Validations & Unit Testing of Dashboards in OBIA Peoplesoft HR Analytics.
• Created the custom financial reports (FSG Template) using OBIEE answers per the business requirement
• Performance tuning of Dashboards/reports and made recommendations for changes to database by implementing the materialized views, partitions.
• Analyze the HR processes in the organization and makes recommendations for improvements via the use of reports and notifications.
• Validate the ad-hoc reports data with the source PeopleSoft system before releasing to stakeholders.
• Design of OBIEE Reports & Dashboards on Core HRMS processes (Employee/Workforce details, Hires/Headcount/ Terminations, compensation/Diversity/benefit, Turnover reports & VIP dashboards)
• Created the Test strategy for the data validations of the Out-of-the-box HR reports against the PeopleSoft HRMS System.
• Responsible for the development of Custom reports & Dashboards for Financial & Peoplesoft HR Analytics.
• Developed best practices & standards for RPD, Dashboards & report Analysis

Environment: OBIEE 11g, OBIA/Oracle BI Apps HR & Financial Analytics 7.9.6.4, Hyperion System 11.1.2.4/11.1.1.4 : Hyperion Planning, Essbase Administration Services, Calc Manager, Financial Reporting Studio, Interactive reporting tool, Oracle PeopleSoft Enterprise HRMS 9.0, Cognos, Informatica,EBS Finance, DAC, Linux, Oracle DB 11g.

OBIEE/Hyperion Sr.Developer

Confidential, Kansas City, Missouri

Responsibilities:

• Involved in requirement gathering from business user and finalize of the User requirement specifications.
• Worked on Multiple modules like Service Request reports, Contact Centre reports, Sales Pipeline reports, Sales and Coaching Reports.
• Customized Financial Reports for Investment Banking.
• Created mock up reports and dashboards for review by the business users.
• Created design, development, and testing documentation.
• Design and Building the Data model for OBIEE reports.
• Developed BIP Reports in OBIEE 11g.
• Involved in Design of Essbase applications and databases (BSO) - Portfolio, Forecast and planning cubes to capture the financial and quantity data for Value Planning to enhance reporting.
• Created Functional design documents and Technical design documents and reviewed it with the users and the team.
• Created transparent partition for the ASO cubes as target for BSO source cubes to enhance reporting.
• Responsible for maintenance of more than 10 Cubes (BSO) including daily, monthly and Quarterly Loads.
• Worked extensively on metadata and data loads, business rules, load rules, performance tuning, Batch Scripting, UDA’s.
• Created detailed documentation for everyday easy to use maintenance guide for DBAs and financial controllers and report design documents.

Environment: OBIEE 11g, Oracle BI Publisher, Hyperion Essbase 11.1.1.4, Hyperion Workspace system 11, Essbase Shared Services 11, Hyperion Planning 11.1.1.4, Hyperion Interactive Reports, ODI 11g, SAP Data Services, SQL Server, TSQL, Excel Add-In, Essbase Utilities, Windows 2003/2008, LINUX.

OBIEE/Hyperion Developer

Confidential, Kansas City, Missouri

Responsibilities:

• Involved in requirement gathering for OBIEE Reports.
• Involved in Development of Repository (Physical, BMM and Presentation Layers).
• Involved in Developing the reports and Dashboards as per the client requirement.
• Taken the entire ownership of developing the repository, reports and dashboards.
• Created Materialized views on the Transactional database for Transactional Reporting.
• Performed Unit Testing of OBIEE reports.
• Developed best practices, development & deployment standards for successful implementation of OBIEE solution.
• Worked on Funding stability issues, enhanced existing calc scripts and resolved the stability issue.
• Modified existing data load rules files and added new members as per new data feeds from source database.
• Reviewed existing documents and rewrote measures flow mapping, documented all the details.
• Worked with a team in implementing Hyperion Planning to build the Planning and Budget application from the scratch as per business functional requirement and created data forms.
• Improved performance by optimizing Planning, Essbase system by changing the dimension order and working on configuration file including cache settings.
• Worked on Hyperion Shared Services and created user directories, users, groups, projects and application.

Environment: OBIEE 10g, Hyperion 11.1.1.3, 9.3.3 - Hyperion Planning, Shared Service, Workspace Essbase, Hyperion Interactive Reporting Studio, ODI 11g, MS Excel 2003/2007, Windows XP, SAP Data Services, SQL Server, TSQL, Microsoft Access, LINUX..

Graduate Engineer Trainee

Confidential

Responsibilities:

• Successfully finished and joined BI team as developer.
• Primarily responsible for Siebel and Hyperion Reports, developments and maintenance.
• Designed and developed Essbase cubes, created rules files, and performed data loads.
• Provided detailed documentation to new team members for Essbase updates and progress of cube.
• Presented detailed analytical reports to higher administrative personnel to assist plan annual budget forecasting.
• Worked as a team member in Hyperion Essbase and Hyperion Planning to help in implementing various business strategies.

Environment: Hyperion, Siebel7, Siebel Analytics 7.8.2, Oracle 10g, SQL, Windows, MS Office.