PROFESSIONAL SUMMARY:

• I am an Oracle Certified BI/EPM Consultant having 8 Years of experience in Hyperion, BI and ODI implementation, upgrade and support projects
• My technology forte includes Oracle data Integrator (ODI), Hyperion Essbase, Hyperion Planning, Oracle Business intelligence Applications (OBIA), OBIEE and SQL database
• Proficient with Business intelligence techniques, data Warehouse modelling and its applications
• Expertise in various reporting tools like Smart View, Hyperion FR studio, BI Analysis and dashboards, Oracle Discoverer, OSA, OFA and Oracle FSG’s
• Manage BI team, worked closely with customer and delivered multiple BI projects successfully along with implementation of various process improvements during support activities
• Strong experience with SQL, SQL query tuning and database concepts including basic DBA activities

TECHNICAL SKILLS:

Operating System: Upto Windows server, Unix, Linux

Technologies: Oracle SQL, PLSQL, Core Java, HTML, MAXL

Database: Hyperion Essbase 11.1.2.4, Oracle 11i and 12c DB, Oracle Express

Development Tools: Hyperion EAS, ODI, EPMA, Essbase Studio, Hyperion FR studio (FRS), Web Analysis, Hyperion Planning, Smart View, OBIEE, Oracle Sales Analyzer, SQL Developer and Oracle Discoverer.

Ticketing Tool: BMC Remedy 7.1(AMP), Service now

PROFESSIONAL EXPERIENCE:

Hyperion team lead

Confidential, Alpharetta, GA

Responsibilities:

• Hyperion technical lead
• Perform Hyperion infrastructure/application upgrade from 11.1.2.2 to 11.1.2.4.
• Infrastructure planning for Hyperion upgrade and Oracle database setup to support Hyperion planning and other Hyperion components.
• Implementation of SSL (TLS1.4) to mitigate security vulnerabilities on various layers of Hyperion infrastructure.
• Distributed installation for various Hyperion products like Hyperion Planning, Essbase, Hyperion provider services, shared services, Financial reporting etc and configuration of all components.
• Migration of Hyperion Planning and Essbase applications to upgraded environment along with entire ODI and JAVA integration layer.
• ODI installation, repository configurations, setting up java and standalone agent for load automation.
• Implementation of partitioning for Hyperion planning applications to integrate for reporting.
• Writing MAXL and Calculation scripts for daily load and data extract automation.
• End to End Hyperion application and ODI support.
• Perform Hyperion planning month end and year end roll forward activities.
• Designed Hyperion data, security and artifacts backup automation.
• Regular implementation of Hyperion application and security patches to keep system upto date.
• Working with Business Analysts to implement new Essbase reporting applications.
• Merging planning applications as per business unit realignments and ERP changes.

Solution Environment:

OS : Windows XP, Unix, Linux

Database : Oracle 11g, Oracle Essbase.

Application Server: Windows 2008 server.

Tools: Essbase Administrative service, Hyperion financial reporting studio, Hyperion Planning, ODI, Smart View, Oracle SQL Developer

BI Technical Lead

Confidential, Houston, Texas

Responsibilities:

• Technical lead for Business Analytics Team
• Design and Development of of Hyperion Essbase applications (Both ASO and BSO) for client reporting
• ODI ETL modeling, interface development and managing BI loads.
• ODI ETL tuning and SQL query tuning to reduce daily BI load timings.
• OBIA DW maintenance (partitioning tables, managing indexes etc) .
• Drafting technical and functional design documents for Hyperion, ODI and Oracle BI apps as per client requirements
• Extensively worked on Hyperion Essbase (11.1.2.3) ASO/BSO implementations, ODI, SQL procedures, SQL db management, Data warehousing and OBIA/OBIEE.
• Development of calculation scripts and MAXL scripts for automation as per business and support requirements.
• Oracle BI Application (OBIA) support, maintenance and enhancements.
• Creation of standard Hyperion FR studio and OBIA/OBIEE reports for end users.
• Designed Security for Hyperion and BI apps.
• Working with Confidential (Oracle managed cloud services) on all infrastructure issues.

Solution Environment:

OS : Windows XP, Unix, Linux

Database : Oracle 11g, Oracle Essbase.

Application Server: Windows 2008 server.

Tools: Essbase Administrative service, Essbase Studio, Hyperion financial reporting studio, EPMA, ODI, Smart View, Oracle SQL Developer, OSA

Confidential

Business Intelligence Developer

Responsibilities:

• Part of knowledge transition team to take trasition for BI application from previous IT support vendor.
• 24x7 support and enhancement of BI Applications like BI Data Warehouse, Oracle Discoverer 10g, ODI, Oracle Financial Analyzer Oracle Essbase applications and BI Portals.
• Implementation of Hyperion Essbase applicatons
• Supporting entire Hyperion infrastructure/applications (SmartView, FR studio, EPMA, Oracle DBs, EAS and ODI)
• Development of ODI interfaces for Hyperion metadata and data load.
• Supporting month end and year end activities related to Hyperion and BI applications
• Hyperion FR studio report development for business users.
• Capturing functional/technical details of Reporting applications, Data Warehouse and documenting the same.
• Capturing details on various operational processes like incident management process, change management process etc and documenting the same
• Preparing Migration Cut over Plans, Integration Test plan/test cases for BI applications.

Solution Environment:

OS: Windows XP, Unix, Linux.

Database : Oracle 9i, Oracle Express, Oracle Essbase.

Application Server: Oracle9i Application Server, Windows 2008.

Tools: Oracle Administrative service, Hyperion financial reporting studio, EPMA, ODI, Oracle SQL Developer, Oracle Discoverer, Oracle Sales analyzer, PVCS.