EXPERIENCE SUMMARY:

• Talented and accomplished IT professional having 7 years of experience installing, configuring, upgrading, patching, analyzing, developing, implementing, tuning and supporting the Oracle Confidential Suite of tools, including Confidential Essbase, Confidential Financial Reporting, Confidential Web Analysis, Confidential Planning.
• Experienced in installing, configuring, upgrading and patching of Confidential EPM products including: Confidential Foundation, EPMA, CALC Manager, Planning, Essbase, Profitability, ODI, Financial Reporting, Web Analysis, Oracle HTTP server and WebLogic in distributed environment. Authored comprehensive documentation for all installation and configuration steps.
• Experienced in development and implementation of Confidential Planning/Essbase systems. Expertise in complete development, final testing and implementation.
• Proficient in Confidential System 9/11.x BI+, Confidential Essbase 9.x /11.x, Confidential Planning 9.x/11.x, Confidential Reports, ESSCMD, MAXL, Essbase Excel Add - In and Smartview.
• Expertise in Calc Scripting, and dimension build, Data Load Rules, Tuning and Optimization.
• Expertise in writing custom Essbase calculation scripts, automated the Confidential using MAXL and Batch Scripts.
• Expertise in creation and maintenance of Confidential planning applications, business rules, web forms, task lists, security groups and users etc.
• Expertise in loading metadata and data using EPMA, ODI.
• Extensive Knowledge of LCM
• Worked exclusively on Confidential Shared Services and Created numerous users, groups and provided them different privileges.
• Expertise with all ODI tools - Topology, Security Manager, Designer, Operator
• Demonstrated ability to work in a fast-paced, team environment

TECHNICAL SKILLS

OLAP: Confidential Essbase & Planning(Classic & EPMA) 11.1.2/11.1/9.3, ESSCMD, MAXL

Reporting Tools: Confidential Financial Reports, Smart View, Confidential spreadsheet Add In, Web Analysis

Database: Oracle 11g, 10g, 9i, 8.x & 8.1.5, 8.1.6, 8.1.7, SQL Server 2000/2005/2008/2012, MS Access 2003

Operating System: Microsoft Windows 2000/2003/2008/2012, AIX,Linux

ETL: Oracle Data Integrator 11.1.1,10.1.3.6

PROFESSIONAL EXPERIENCE

Confidential, Germantown,MD

Sr. Oracle, Consultant

Key Responsibilities:

• Extensively used calculation commands and functions to improve the performance of applications. Developed Calc Scripts/Business Rules for complex calculations and optimized them.
• Migrating the Artifacts from one Environment to the other using LCM.
• Responsible for Migrations.
• Maintenance of User Security and troubleshooting user access issues as they arise.
• Worked with Confidential Support on a number of issue resolutions.
• Developed Customized Reports.
• On time completion of all assigned tasks and meeting the business expectations and timelines

Environment: Confidential Essbase 11.1.2.4, Confidential Planning 11.1.2.4, Confidential Shared Services 11.1.2.4, Confidential SmartView, Confidential Financial Reporting Studio, Windows Server 2008 R2.

Confidential, Minneapolis,MN

Sr. Oracle, Consultant Lead

Responsibilities:

• Installed EPM 11.1.2.3 on RHEL 5.6.
• Analyzed Issues in WebLogic Admin Console 10.3.6 and applied needed Patch Sets
• Applied the latest Confidential Products related patches
• Worked closely with Confidential Support Development team in fixing the Issues.
• Responsible for Migrations..
• Keeping all the environments in sync.
• Supporting the End users on Client install issues. Tracking the issues with Incident management tickets.
• Maintenance of user security and troubleshooting user access issues as they arise.
• Setting up security in planning and assigning access to Forms, Rules and Reports.
• Backup and Recovery of Confidential applications.
• Defined and documented the steps to migrate applications in the Confidential Planning,Essbase between PROD,DR,QA and Dev environments.
• Worked with Confidential Support on a number of issue resolutions.
• Experience with Change/Incident/Problem Management
• Training end users

Environment: Confidential Essbase 11.1.2.3, Confidential Planning 11.1.2.3, Confidential Shared Services 11.1.2.3, Excel Addin, Confidential SmartView, Confidential Financial Reporting Studio, Confidential EPMA 11.1.2.3, RHEL 5.6.

Confidential, Nashville,TN

Sr. Oracle, Consultant Lead

Responsibilities:

• Performed metadata building using outline load utility for different dimensions.
• Created various rule files for loading Data into Planning cubes
• Developed Dynamic Web forms and composite web forms for various applications with POVs, menus, run time prompts, Smart Lists, Validation rules and Pages.
• Performed Essbase Calc script tuning and debugging as well as enhancements
• Optimization of BSO cubes: Custom setting type of compression, data cache, index cache, and allocation of dense/spare configuration relating to hourglass model to have optimum database block size
• Created various business rules according to the requirements.
• Automated and backup all the LCM artifacts on a daily basis and also documented various steps of how to restore the application when the cube is corrupted.
• Worked extensively on Confidential shared Services and Created numerous users, groups and provided them different privileges.
• Developed and monitored MaxL Scripts and Rules files to dynamically upload dimensions and data from legacy system to Confidential .
• Created ODI design documents from the existing SSIS packages. Used these design documents in development of ODI interfaces/packages.
• Resolved tickets which are coming from various business users through ticketing system.
• Subject matter expert for all queries related to Confidential products.
• Provided external support for all Confidential issues on as need basis.
• Mentoring and guiding business users on all Confidential products.

Environment: Confidential Essbase 11.1.2.2, Confidential Planning 11.1.2.2, ODI 11.1.1, SSIS, Confidential Shared Services 11.1.2.2, Excel Addin, Confidential SmartView, Confidential Financial Reporting Studio, Confidential EPMA 11.1.2.2, Windows server 2008 R2.

Confidential, St. Louis, MO

Sr. Oracle, Consultant

Responsibilities:

• Setup the ODI connection with Flat Files, Oracle and Confidential Planning.
• Setup the Topology including physical architecture, logical architecture and context.
• Created new Models for the Source - Flat Files, Staging Area - Oracle and Target - Confidential Planning.
• Created Data Stores for Flat Files and reverse engineered for the data sources and targets.
• Developed interfaces to load the metadata from flat files, to Confidential Planning.
• Did SQL and PL/SQL programming for ODI and oracle.
• Worked extensively with ODI navigators: Designer, operator, topology. Developed TDD for the ODI Project
• Currently redesigning Confidential planning application in order to work more efficiently.
• Worked on the performance tuning (Cube Optimization) of the Application for the fast data loads, better calculation times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings, Outline formulas and Calc scripts.
• Optimized Nightly package by bringing it down from running around 12 hours to 1.5 hours.
• Optimized Essbase application to balance the calculations and retrieval performance needs.
• Documented various Essbase tuning methods and recommendations.
• Build ODI package in order to extract data out from Oracle to load into AHY Essbase cube.
• Build calc scripts in order to extract data out from Essbase and load into Oracle using ODI and based upon user selected POV.

Environment: Confidential Essbase 11.1.2.1, Confidential Planning 11.1.2.1, ODI 10.1.3.6.0, Confidential Shared Services 11.1.2.1, Excel Addin, Confidential SmartView, Confidential Financial Reporting Studio, Confidential WebAnalysis, Confidential EPMA 11.1.2.1, Windows server 2008, LINUX.

Confidential, St. Louis, MO

Sr. Oracle, ODI Consultant

Responsibilities:

• This project was a full life cycle, global implementation of Confidential Planning, including EPMA, Calculation manager and ODI for 200+ users.
• Confidential Planning Consultant responsible for development of Planning applications for P&L, Variance Analysis using Oracle Enterprise Performance Management System 11.1.2.2 .
• Developed calculations for variance analysis, including price\volume\cost mix, spend and FX impact.
• Developed SG&A allocations across all cost centers.
• Developed and automated data integration for loading metadata and data for various Planning cubes.
• Created weekly, nightly process to back up all the Confidential systems both metadata and data using LCM and Essbase maxl scripts.
• Automated monitoring to detect Confidential Web application crashes and other failures, enabling the team to immediately respond to such issues using Weblogic WLST scripts.
• Subject matter expert for all queries related to Confidential products.
• Provided external support for all Confidential issues on as need basis.
• Mentoring and guiding business users on all Confidential products.
• Helping business users on the team less familiar with Confidential System 11 to come up to speed to Oracle EPM 11.1.2 system.
• Identify project risks, issues and avenues of mitigation on Confidential Planning & Essbase.

Environment: Confidential Essbase 11.1.2.2, Confidential Planning 11.1.2.2, ODI, Confidential Shared Services 11.1.2.2, Excel Addin, Confidential SmartView, Confidential Financial Reporting Studio, Confidential WebAnalysis, Confidential EPMA 11.1.2.2, Windows server 2008.

Confidential, Dallas, TX

Sr. Oracle, /ODI Consultant

Responsibilities:

• Created all MS SQL Server database required for Production, Stage and Development Confidential installations
• Installed, configured and patched Confidential Prod/Stage/Development Environments: Foundation Services, EPMA, Calc Manager, Essbase Server, EAS, APS, Essbase Studio, Planning, and Financial Reporting.
• Configured Shared Services security integration with Microsoft Active Directory
• Created custom start/stop scripts for Confidential Windows services
• Migrated Essbase business rules and substitution variables, converting them to Calculation Manager objects
• Migrated Confidential EPMA, Planning, Essbase, Financial Reports.
• Produced documentation of all steps involved in infrastructure work.

Environment: Confidential Essbase 11.1.2.2, Confidential Planning 11.1.2.2, Confidential Shared Services 11.1.2.2, MS SQL SERVER 2008,Windows server 2008, Confidential Financial Reports Studio, Smartview, Excel Addin.

Confidential, Dallas,TX

Responsibilities:

• Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Set up the Topology including physical architecture, logical architecture and context.
• Created new models for the data sources - flat files, Oracle.
• Did reverse engineering for the data sources and targets.
• Worked extensively with ODI Designer, operator and metadata Navigator.
• Developed interfaces to load the metadata from flat files, Oracle to Confidential Planning.
• Developed complex interfaces, procedures, packages in order to extract data out of IBR Essbase cube to 33 APEX cubes.
• Developed and optimized ODI packages in order to extract data out of IBR Confidential to file systems based upon user selected Year, Scenario,Version. This process has been optimized to complete the process in ~6 hours compared to 27 hours current process.
• Did SQL and PL/SQL programming for ODI and oracle.
• Created ODI packages, scenarios using interfaces, variables, procedure.
• Used ODI commands like ODIFile Move, odiFileAppend, odiFilecopy,odisqlunload etc.
• Optimized the knowledge modules to improve the functionality of the process.
• Performed unit and integration testing. Created various test scenarios to test the application.
• Delivered the assignments before the tight deadlines.

Environment: Confidential Essbase 11.1.2.2, Confidential Planning 11.1.2.2, ODI 11.1.1.7, Oracle 11g, Windows server 2008

Confidential, Seattle, WA

Responsibilities:

• Confidential SmartView retrieval performance has been improved from 10 mins to about 5 seconds
• Provided technical documentation Planning Applications build using ODI 11.1.1.3.0 to classic planning.
• Provided training and workshops for the Users for the new features in SmartView and Webanalysis 11.1.2.1
• Applied patches for Oracle EPM 11.1.2 Shared Services, Planning.
• Created weekly, nightly process to backup all the Confidential systems. Both metadata+data using LCM and Essbase MAXL scripts
• Worked closely with Oracle Product Assurance and Oracle Developers to resolve bugs as they arose
• Worked to build and implement a process to automate nightly processes relating to Essbase Data loads
• Optimized Planning applications: Submitting and Retrieving data using either Webforms or Smartview has been gradually reduced from more than 4 minutes to 10 seconds
• Build complex CALC scripts, Business Rules according to business requirement

Environment: Confidential Essbase 11.1.2.1, Confidential Planning 11.1.2.1, ODI, Confidential Shared Services 11.1.2.1, Excel Confidential Add-In, Smartview.

Confidential, Los Angels, CA

Responsibilities:

• Participated in requirement analysis phase and gathered reports in several format, analyzed the reports to design a Confidential .
• Developed P&L and Workforce classic Planning applications.
• Automated the process of XREF which extracted the data from Workforce cube to P&L cube.
• Developed customized web forms for all cube along with the business rules.
• Developed Calc scripts and Business Rules for Workforce application including merit and benefits etc.

Environment: Confidential Essbase 11.1.2.1, Confidential Planning 11.1.2.1, Confidential Shared Services 11.1.2.1, Excel Add-In, SQL Server 2005, Windows server 2005, Confidential Financial Reports 11.1.2.1.

Confidential, Los Angeles, CA

Responsibilities:

• Participated in requirement analysis phase and gathered reports in several format, analyzed the reports to design a Confidential .
• Developed Income Statement Confidential .
• Developed Calc scripts for Income Statement.
• Developed customized web forms for Income statement with the business rules.
• Developed task lists, smart lists and menus. Developed complex Financial Reports.

Environment: Confidential Essbase 11.1.1.3, Confidential Planning 11.1.1.3, Confidential Shared Services 11.1.1.3, Excel Add-In, SQL Server 2005, Windows server 2003, Confidential Financial Reports 11.1.1.3.

Confidential

Responsibilities:

• Involved in development for forecasting and budgeting application.
• Optimized outline, data load rules and calculation scripts, Manipulated data columns to suite dimension builds, tested data load rules, f ixed errors from the error log files, resolved issues of data retrieve from excel.
• Developed complex Financial Reports

Environment: Confidential Essbase 9.3.1, Confidential Financial Reports 9.3.1, Smartview, Excel Add-in, Windows server 2003, SQL Server 2005.