Resume

Sign in

Data Sales

Location:
Cupertino, CA
Posted:
October 04, 2018

Contact this candidate

Resume:

Sireesha

408-***-****(Home)

408-***-****(Cell)

ac6995@r.postjobfree.com

Professional Summary:

Over 10 years of IT experience in online analytical applications (OLAP), ETL, Business Analysis, Requirements, Development, Testing and Database Administration of Data Warehousing and Client/Server projects using industry accepted methodologies and procedures.

Strong experience as Essbase Cube Analysis & Design, Essbase database administration and performed up gradations, Maintenance, database backups, Performance tuning, Optimization, Dense/Sparse settings, partitioning, etc.

Hands on experience with Hyperion EPM, Hyperion Essbase, Hyperion Planning, HFM, Hyperion Reports and Hyperion Analyzer financial tools.

Strong experience supporting and maintenance of the Hyperion Financial platform (Planning, Essbase, PBCS, HFM, FDM, FDMEE, BI+ Environments and other related products).

Developed overall Architecture, Star Schema, Data Model, and Hands on design and development of Extract Transform & Load (ETL) and OLAP Reports.

Hands-on expertise creating reports using Essbase Excel Add-In, Brio Intelligence, and smart view.

Strong experience in all phases of testing including defining user acceptance criteria, developing plans/scripts, documenting expected results, execution of scripts, validating actual results.

Posse’s excellent project management skills in managing, developing and implementing the project.

Experienced in knowledge transfer, preparing the required documentation, training the clients.

Posse’s excellent analytical, logical, communication skills, familiar with the SDLC methodology of system development.

Education

Bachelor of technology

Current Immigration Status

US Citizen

Technical Skills

OLAP : Hyperion EPM 11.1.2.x, PBCS, EPBCS, Hyperion System 9, Brio Intelligence, Hyperion Planning 4.x, Hyperion Essbase 6.5.x / 7.x / 9.x, Hyperion Analyzer6.5/7.x, Hyperion Reports6.5/7.x, Essbase Excel Add-In, VBA

Languages : Java, C++, C, VB and PL/SQL.

App Server / Web Server : Bea Web Logic, Apache web server, Microsoft IIS4.0

Operating Systems : Windows NT 4.0, Aix, Solaris.

Databases : Oracle 8.0, 9i, Oracle Financials 11i, Microsoft SQL Server.

Markup Languages : HTML 4.0, DHTML, XML, and XSL

Shell Languages : Korn shell, Bash shell

Project Profile

Wells Fargo, San Francisco CA Nov’17 – Till Date

Sr. Hyperion Developer/Administrator/Business Analyst

Responsibilities:

Responsible for delivering management reporting solutions using Hyperion EPM tools to finance teams.

Created new RRP and RRC Essbase applications from existing application depending on the request from the business users.

Created and modified the SQL queries for loading data into Essbase Applications.

Created new load rules and modified the existing load rules for the new and existing applications.

Created calculation scripts and maintaining the existing calculation scripts depending upon the new business requirements from finance users.

Responsible for the Maintenance of Current Position, Market Value, Adjustments and Legal Entity Essbase cubes.

Responsible for scheduling and maintenance of Data load processes on different applications using the Cognos Command Centre and BPA .

Created new security filters for the users and updated the existing filters based on the user requirements.

Involved in documenting the processes and maintaining the existing applications enhancements and creating new reports.

Provided user support to the finance team on different analytical related questions, data validations and Meta data analysis between different systems.

Environment: Oracle Hyperion EPM 11.1.2.4.x, Oracle Hyperion Financial Reports 11.1.2.x, Cognos Coomand Center 10.2.1, Oracle Hyperion Essbase 11.1.2.4.x, Smart view, BP Server 10, ODI, FDM/FDMEE, Oracle 11i, Toad, and Windows NT 4.0

Independent Contractor, Cupertino CA Apr’13 – Jul’17

Hyperion Developer/Administrator/Business Analyst

Responsibilities:

Responsible for providing Administration/Production Support/Development and helping global business users in using oracle epm (Planning, Essbase, PBCS, HFM, FDM, FDMEE, BI+ Environments and other related products) efficiently.

Provided support for Actual Month End, Forecast/Planning close cycles and other processes related to these activities.

Provided primary user support on analytical related questions, data Validations and Meta data analysis between different systems.

Developed Esbase BSO/ASO Revenue for Financial Plan and Qtrly Commit and Weekly PL Planning applications.

Developed the Calculation scripts, Business rules, MAXL scripts, MDX Scripts, Load Rules and Batch scripts to perform Annual Planning, Quarterly commit and Monthly forecasting.

Developed on demand and ad-hoc reports for clients using Hyperion Smartview, Hyperion Financial Reports and Web Analysis products.

Worked with technical team in explaining issues that requires code changes, identifying bugs and testing for code promotions and perform unit testing.

Perform data/metadata reconciliation between source systems and Hyperion and between Hyperion databases.

Documented the usage of different alternate dimensions from users by Essbase Surveys to provide more cleaner and efficient applications and financial systems operation procedures.

Responsible for training and educating business users in effectively using the Hyperion client tools (Hyperion Financial reports, Smart view and Essbase Excel Add-in).

Responsible to make sure Hyperion systems follow SOX controls, IT change management processes and data governance processes.

Responsible to partner and collaborate with other IT apps team, database administrators and business users to provide business solutions.

Responsible for day to day maintenance, production support, ongoing improvements to finance-related processes to ensure accuracy and integrity of planning, forecasting and financial reporting data.

Environment: Oracle Hyperion EPM 11.1.2.x, Oracle Hyperion Financial Reports 11.1.2.x, Oracle Hyperion Web Analysis 11.1.1.2.x, Oracle Hyperion Essbase 11.1.2.x, HFM, Smart view, ODI, FDM/FDMEE, Oracle 11i, Toad, and Windows NT 4.0

Google Inc., Mountain View CA Nov’12 – Mar’13

Hyperion Developer/Administrator/Business Analyst

Responsibilities:

Responsible for providing production support in maintaining various applications/databases ProdpnL, Planning/Employee and Current Employee for business.

Provided support for Actual Month End, Forecast/Planning close cycles and other processes related to these activities.

Provided primary user support on analytical related questions, data Validations and Meta data analysis between different systems (Planning, HFM, Essbase and Oracle).

Worked with technical team in explaining issues that requires code changes, identifying bugs and testing for code promotions and perform unit testing.

Perform data/metadata reconciliation between source systems and Hyperion and between Hyperion databases.

Documented the usage of different alternate dimensions from users by Essbase Surveys to provide more cleaner and efficient applications and financial systems operation procedures.

Environment: Oracle Hyperion EPM 11.1.1.3.x, HFM 11.1.1.3.x, Oracle Hyperion Financial Reports 11.1.1.3.x, Oracle Hyperion Web Analysis 11.1.1.3.x, Oracle Hyperion Essbase 11.1.1.3.x, Oracle Hyperion EPMA 11.1.1.3.x, Excel Add-In, Smart view, Oracle 11i, Toad, and Windows NT 4.0

Coherent Inc., Santa Clara CA Apr’12 – Oct’12

Hyperion Developer/Administrator/Business Analyst

Responsibilities:

Responsible for application administration, customer support, troubleshooting, and enhancements of the Hyperion Planning environment.

Providing production support and prioritizing and developing solutions for day-to-day system issues raised by business users for Hyperion planning application related issues across the globe.

Responsible for data integrity in all Essbase cubes, via data checking and data validation before, during, and after month-ends, forecasts, and annual budget.

Setting up and closing forecast and budgeting processes both in Planning and Essbase.

Updated the dimensions with new members, maintained the Essbase outlines using EPMA and reconciled the data between Essbase cubes and HFM application

Created users and maintained security via Shared Services and Hyperion Planning.

Developed and maintained calculation scripts, and business rules as per the business processes changes.

Created and maintained planning web forms.

Created new reports in Financial Reporting, smart view and using Essbase Excel Add-in.

Worked with business and IT teams to create and improve processes and methodologies.

Assisted with ad-hoc user requests necessary to support business needs.

Designed and developed Variance Analysis Reports, Headcount reports, Expense reports, CapEx Reports, etc. using Hyperion Financial Reports.

Designed and developed reconciliation reports to compare the data between Hyperion Essbase/Planning data source and OBIEE by using the conditional formatting.

Designed and developed detailed Headcount reports and Expense reports using the Hyperion Planning as the data source in order to provide complete details input by the analysts as supporting details, etc.

Designed and developed the integrated Variance Analysis workbooks for Forecast review against Actuals using Smart view and Essbase Excel Add-in.

Responsible for training and educating business users in effectively using the Hyperion client tools (Hyperion Financial reports, Smart view and Essbase Excel Add-in).

Environment: Oracle Hyperion EPM 11.1.1.3.x, HFM 11.1.1.3.x, Oracle Hyperion Financial Reports 11.1.1.3.x, Oracle Hyperion Web Analysis 11.1.1.3.x, Oracle Hyperion Essbase 11.1.1.3.x, Oracle Hyperion EPMA 11.1.1.3.x, ODI, FDM, Excel Add-In, Smart view, Oracle 11i, Toad, and Windows NT 4.0

Logitech Inc., Fremont CA Apr'07 – Apr’10

Hyperion Developer/Administrator/Business Analyst

Responsibilities:

Involved in implementation of P&L Planning & Reporting solution to streamline and automate the P&L reporting process for the Finance, Accounting and Sales groups for annual planning, monthly and quarterly forecasting.

Designed and developed web enabled forms to enable users to submit data for annual planning, monthly P&L Forecasting.

Designed and developed P&L by Customer, P&L by Product, OPEX Reports, Revenue reports, CapEx Reports, etc. in Hyperion financial Reports (Hyperion Reports).

Designed and maintained the BBB (Billings, Bookings and Backlogs) essbase application for daily sales, backlogs, standard margins, comparison to historical data.

Developed the load rules to automate the daily data loads of daily bookings, billings and backlogs data loading from Data warehouse, text files and SQL Server.

Developed daily flash report for Billings (Net Sales), Bookings and Backlogs details in Hyperion web analysis (i.e. Hyperion Analyzer).

Developed calculation scripts to calculate financial metrics, to allocate the costs and revenues and to aggregate the essbase databases.

Worked on the HFM operations which include Loading Units data to HFM, Extracting Actuals from HFM and loading to Essbase and Loading Ops data to HFM

Created Ad-hoc validation reports for validation of the Hyperion with data from HFM, Warehouse and SQL Server using Smart view.

Supported business users for Installation of Essbase Excel Add-in and Smart view software and trouble shooting and resolving technical issues and maintenance of users and security.

Administration Essbase applications by adding and updating master data changes and performed data validation and validation of key executive reports which are generated on a daily, weekly and quarterly basis.

Developed system documentation, user documentation and administration documentation for essbase and planning applications.

Co-ordinated and provided training to the offshore team by transitioning the month end, Quarter end and year end processes.

Developed the Maxl scripts and Esscmd scripts to automate the daily data loads and maintenance of essbase databases.

Attended OBIEE 10g Training.

Environment: Oracle Hyperion EPM 11.1.1.x, Hyperion System 9, HFM 11.1.1..x, Hyperion Reports 9.x, Hyperion Analyzer 9.x, Essbase, HAL, Excel Add-In, Oracle11i, Toad, and Windows NT 4.0

JDS Uniphase Corporation, Milpitas CA Jan'05 – Mar’07

Essbase Developer/Analyst/Support

Responsibilities:

Performed the full life cycle of design, development, implementation, and ongoing maintenance and support of Essbase applications in the Pre System 9 Environment and Hyperion System 9 BI+ Environment.

Developed essbase applications including Calculation Scripts (write/maintain/enhance), Load Rules, Report Scripts, Application Manager, Database Tuning and optimization, Dense/Sparse Outline Configuration, Esscmd and MaxL scripting, Batch Scripting, Automation, Backup/Recovery, Security Filters, importing data from RDBMS systems, etc.

Maintained Essbase Outlines by adding new COA, new departments, new product lines, etc on time using dimension build rules to make the most current data available for business users for the analysis in the Essbase databases.

Designed and developed Variance Analysis Reports, Function P&L Reports, Quarterly statements of operations, Headcount reports, Capital expense reports, Balance Sheet Reports, Cash Flow Reports, etc. using Hyperion Financial Reports.

Reconciled and Troubleshoot data reporting issues by analyzing and validating the data against different source systems.

Developed and automated dimension building, data loading and application backup scripts using dimension build rules, data load rules and MAXL scripts.

Maintained users using shared services and administer and setup security procedures for financial reporting system, in compliance with company guidelines and Sarbanes-Oxley.

Developed Financial and Management reports using Hyperion Analyzer, Essbase Excel Add-in, and Hyperion Reports.

Supported business users and resolved issues in a timely manner during budgeting, forecasting, and management reporting.

Developed dash board reports using Brio Intelligence.

Designed, Developed and Tested HAL Integration Projects in VBIS (Vignette Business Integration Studio 6.1) using Hyperion Planning Adapter, Essbase Adapter, Flat File Adapter etc. using HAL3.0.

Performed the performance tuning and optimization by using the Dense/Sparse settings and partitioning and developed the required alternate rollups for reports.

Developed SQL to extract data from data warehouse tables using toad and created the data load rules to load data into Essbase cubes.

Created detailed test plans, test cases as well as providing assistance to Business Owners for user acceptance testing (UAT).

Developed the documentation required to transfer knowledge for the users and for the administration and support.

Environment: Hyperion Essbase6.5.4&7.x, Hyperion System 9, Brio Intelligence, Hyperion Reports 7.x, Hyperion Analyzer 6.5&7.x, Essbase Excel Add-In, VBA, Oracle11i, Toad, Solaris 8.0 and Windows NT 4.0

Sony Electronics, San Diego CA Apr'04 – Dec’04

Essbase Developer/Analyst/Support

Responsibilities:

Involved in Designing, developing, and supporting Essbase Applications for P/L Analysis, GL Reporting, Expense Analysis, Cost Analysis and Marginal Profits Analysis for TVA and EMCSA Departments at Sony Electronics Systems.

Developed Calculation Scripts for Calculating the Marginal Profits for different SML, STE, PTG and VPA plants.

Updated the Existing Essbase Applications by adding extra dimensions needed for the analysis of expenses from different departments.

Developed Calculation Scripts for Calculating the Expenses, Expense Allocations for different SML, STE, PTG and VPA plants.

Developed Expense Reporting System and Modified procedures followed by the users to calculate the expenses of different departments (by cost centers) and created detailed report using the Visual Basic for Applications (VBA).

Developed the Esscmd scripts for loading the General Ledger, Cost and Export Sales data in to the VPA (Visual Products of America) and RWC (Royalties Warranties and Cost) applications.

Defined and developed the strategies for Testing and Production Support. Involved in providing 24/7 production support.

Developed and modified the EMCSA and VPA Essbase Esscmd and Maxl Scripts due to the migration of Oracle from 10.7 to 11.0.3.

Worked with Oracle 10.7 and Oracle 11.0.3 applications for extracting the cost, sales and GL data for The VPA and EMCSA departments.

Designed and Developed different Excel Templates for generating the dynamic expense reports using Essbase Excel VBA Macros.

Designed the Functional and Technical documentation by analyzing the business requirements and the procedure needed for calculating the Marginal Profit.

Developed shell scripts to run the batch jobs for executing the ESSCMD scripts and Calculation Scripts.

Environment: Hyperion Essbase6.5.4, Hyperion Reports 2.6, Hyperion Analyzer 6.5, Essbase Excel Add-In, VBA, MS SQL Server, IIS4.0, Oracle11i, Solaris 8.0 and Windows NT 4.0

Conoco, TX May ‘03 – Dec’03

Essbase Analyst / Administrator

Responsibilities:

Involved in defining requirements, functional specification, design documents, test strategy and implementation specification.

Involved in identification of potential tasks, review of application design and underlying data model.

Analyzed and designed the Essbase bases as required, for changing business and organizational requirements.

Developed methodologies and procedures for other required technical updates and validations as are necessary to ensure integrity of the structures and data contained within the systems.

Developed the Calculation Scripts to calculate the Sales Performance Analysis figures and Operational Costs.

Created the essbase partitions between the CRD and URD databases to provide upstream consolidation and reporting of Multiple, periodic variance analyses provided by the worldwide BU’s, Annual Budgets and Forecasts.

Developed the Calculation Scripts to calculate the Financial Planning Data and Period-To-Date Values.

Created databases, outlines, applications and generated calc scripts necessary and report scripts for better decision support.

Provided technical administration and support assuring databases stay in sync with the Corporate CRD system and with each other and maintaining security groups for approved accesses.

Created Database outlines and developed Essbase Load Rules and optimized the outlines arranging the Dimensions.

Developed the ESSCMD scripts to take backup of the database and to recover from the failure.

Scheduled the meetings for issues resolution, prioritizing the issues and fixing the issues.

Scheduled and conducted meetings with the business clients to review and collect the feedback and revisions.

Created easy-to-share customized views that represent sales performance, financial and operational reports using the Hyperion Analyzer.

Developed SQL Statements and PL/SQL procedures to extract the data from Oracle database to load into Essbase Cubes.

Created performance analysis charts and graphical presentation reports using the pre-built customer intelligence reports with Analyzer Form Design Tools.

Integrated data from multidimensional Essbase cubes and oracle database to create reports from financial and non-financial information.

Developed the reports by providing the user-friendly features such as drill down in to data and viewing data from different perspectives.

Environment: Hyperion Essbase 6.x, Hyperion Analyzer6.2, Microsoft IIS4.0, MS Excel, VBA, Oracle 8.0, DB2, SQL server 7.0, Informatica PowerMart4.x, Windows NT 4.0, and Solaris 8.0



Contact this candidate