EPM Hyperion Admin / BI Analyst & Developer

SUMMARY: Highly experienced Hyperion EPM Admin and Reporting Analyst with over 13+ years of expertise in designing, developing and maintaining complex financial reporting solutions. Proven ability to analyze complex data sets and deliver actionable insights through effective data visualization. Work closely with CEO, CFO and VP of finance on a daily basis supporting strategic planning, financial analysis and critical decision making . Skilled in Hyperion EPM, Business Intelligence tools (Business Objects, Cognos, Tableau, PowerBI), financial data analysis and modeling, report development and optimization, with a strong focus on optimizing performance and enhancing user experience. Adept at data analytics, regulatory reporting and providing strategic recommendations to enhance business operations .

PROFESSIONAL SKILLS

Financials Data Analysis

Data Visualization

Data Management

Reporting and Documenting

Forecasting & Budgeting

Presentation Skills

PROGRAMMING SKILLS & TOOLS

Reporting Tools: SAP BO, Tableau, PowerBI,COGNOS 8/10 Suite ( Report Studio, Analysis Studio, COGNOS Connection, Query Studio),SSRS

Databases: Snowflake, SAP HANA, Progress, Databricks, DB2, Microsoft SQL Server

Data Modeling: IDT(Information Design Tool), Framework manager

Forecasting/Budgeting Tools: Oracle EPM Cloud (Planning, EPBCS, FCCS) EDMCS, Narrative Reporting, On-Prem Hyperion Planning, Essbase,HFM, Financial Reporting Studio .

ERP Systems : SAP, Rental results

Scheduling tools: InfoBurst

Programming Languages : SQL, SAS, Python, R, Powershell, Bash, KornShell

Version Control : Bitbucket, Azure Repos

Regulatory Compliance Checkpoints : Data Privacy, Sox Compliance, ITGC Alignment, Year End & Quarterly Reviews

Documentation & Enablement Tools: Visio, SharePoint, Confluence, Jira

Process Automation: EPM Automate, Groovy scripting, Unix shell scripting

Change Management: SharePoint, PowerPoint, Confluence, Azure DevOps, ServiceNow

PROFESSIONAL CERTIFICATION

IBM Certified Designer—Cognos 10 BI Reports

PROFESSIONAL EXPERIENCE

Hyperion Administrator/BI Developer WillScot MobileMini, Phoenix, Arizona, U.S Mar 2022 - Current

BI Developer

Creating and Maintaining dashboards for Finance teams on Tableau .

Providing reporting support using both SAP BO, PowerBI and Tableau reporting tools to Finance teams as needed.

Heavily involved in testing and validation of data between systems (Webi, Tableau and EPM)

Hyperion Administrator

Directly supporting the CEO, CFO & VP of Finance by delivering executive level reporting, ad-hoc analysis and strategic insights to aid in daily operations and high level decision making .

Involved in day-to-day maintenance and production application support activities.

Responsible for Month end roll forwarding process and preparing the upcoming forecast cycle.

Maintaining Entity/Account/Product hierarchies in EDM. Support various forecasting and budgeting needs as requested.

Maintaining security and providing user access as needed to data forms and dimensions.

Lead monthly workforce data integration from Successfactors & Databricks into EPM. Ensuing timely, accurate data loads used in headcount forecasting, SG&A planning, budgeting processes across departments.

Collaborate closely with HR and FP&A teams to manage and validate employee data for forecasting models, including salary, bonuses, FTE and organizational hierarchy changes .

Data loads for month that involve rates, FX updates, capex loads, operational data loads, loads from sap for net income and trail balance.

Updating Calc scripts and derived accounts as needed.

Developed and maintained EPM Automate scripts to automate daily backup, metadata loads, and data integration tasks across multiple Planning applications.

Created and debugged Groovy scripts to dynamically validate data inputs and drive complex business rule logic, improving calculation performance and reducing processing time.

Automated LCM export/import routines using batch scripts integrated with EPM Automate for regular patching and migrations.

Streamlined month-end close workflows by implementing automated data loads from external sources (via Data Management and EPM Automate).

Extracting plan data and loading it to SAP .

Training new users on how to setup smartview connections and user preferences .

Proving support to the EPM users as needed on the various requirements, questions on data flow, calculations as needed.

Continuous support to Finance/Accounting teams for month end/quarter end and year end as needed.

Heavily involved in budgeting and planning process and making updates as needed by teams.

Creating various reports, form, slides, dashboards in EPM systems for Finance teams .

Business Intelligence Developer/Hyperion Admin Mobile Mini/WillScot, Phoenix, Arizona, U.S Oct 2019 - Feb 2022

Business Intelligence Developer

Played a big role during the merger between Mobile Mini Inc and Willscot .

Merger involved data clean up and heavy data validations, system alignment, reporting support between 2 companies.

Providing month end support to various department during this transition.

Creating universes to accommodate the new enhancements to the systems.

Interacting with the other company to understand their processes and requirements.

Creating consolidated reports that meet requirements of both the companies.

Supporting Year End, Quarter end and SOX controlled reporting needs for the finance/accounting teams.

Worked closely with Finance/Accounting, AR and AP teams during this transition

Hyperion Admin

Month end roll forwarding, forecast cycle preparation.

Month end workforce uploads, actual data loads and part of heavy data validation and tie outs.

Maintaining security and providing user access as needed.

Continued support to Finance/Accounting teams for month end.

Provided continued support to Hyperion users as needed .

Actively involved in merger related discussions for the migrating to EPM cloud.

Business Intelligence Developer/Hyperion Admin Mobile Mini Inc, Phoenix, Arizona, U.S Mar 2018 - Sep 2019

Business Intelligence Developer

Upgrading to SAP HANA environment. Responsible for migration of reports and Universes to SAP HANA.

Created the new Universes as well as customizing the old Universes (using aliases, contexts, aggregate awareness, aggregate navigation and hierarchies) as per the requirements.

Creating New Webi reports (used alters, merge dimension, filters, prompts, user response, multiple data providers) as per the request.

Highly Involved in dashboard creation and maintenance including updating existing dashboards as per user needs, which involved updating the underlying Webi Reports and Queries and displaying the updated data in dashboard.

Creating Unit test cases and conducting unit testing of individual reports.

Participated in reviews of the reports and Universes and creating the review logs and review checklists.

Hyperion Admin

Attended a 3 day boot camp and started training as a backup Admin for Hyperion Essbase & HFM systems..

Maintaining security and providing user access as needed.

Validating month end data tie-outs within the systems.

Generating Month end reports for finance and accounting teams.

Smartview installation and training to users as needed.

Business Intelligence Developer Mobile Mini Inc, Phoenix, Arizona, U.S Jan 2016 - Mar 2018

Transitioning to SAP environments. Recreated the existing reports from Cognos / Excel format to Webi.

Interfaced with different departments to gather requirements and delivered complete analytics report. Made recommendations for new metrics, techniques to improve content quality.

Customizing the Universes as per the requirements.

Creating Unit test cases and conducting testing of individual reports.

Interacting with customers to fix the issues found in UAT.

Managing the reporting needs via SAP BO which involved updating, analyzing and reporting changes on daily/weekly/monthly basis .

Cognos BI Developer Mobile Mini Inc, Phoenix, Arizona, U.S Jan 2015 - Dec 2016

Managed the Reporting via Cognos 8/10, which involved updating, analyzing and reporting changes in turnover on daily/weekly/monthly basis .

Proficiency with Cognos 10 BI product suite (Report Studio, Analysis Studio, Query Studio, Framework Manager)

Create custom Cognos reports and modify existing queries and reports to enhance productivity or supply data to various departments.

Played a major role in migrating to SAP environment from Rental Results.

Performed gap analysis and analyzed business requirements to provide data seamlessly to the business users during this SAP migration.

Implemented enterprise analytics for new products by participating in design sessions and analyzed data requirements for data warehousing.

Worked in a globally diverse team environment and interacted with all levels of management.

BI Developer HSBC Global Technologies, Hyderabad, India Jun 2010 - Mar 2013

Worked on various COGNOS Tools – COGNOS 8 Suite including Report Studio, Query Studio, and COGNOS Connection.

Involved in developing SQL Scripts to validate the Reports data and Unit Testing.

Understanding the user requirements.

Developed different types of reports on Report studio and Query studio.

Worked on the creation of Materialized query tables.

Worked on loading data into Base and MQT tables.

Developed the sql queries for data validation.

Involved in unit testing of the reports.

Worked in cross-functional teams and maintained cooperative relationship with teams in UK by working on multiple tasks simultaneously

Involved in preparing the technical documentation.

Worked on Unix Scripts to load data and to generate reports

EDUCATION

Degree and Date

Institute

Percentage Master of Technology, Software Engineering, Dec 2010

JNTU, Hyderabad, India

85.5

Bachelor of Technology, Computer Science & Engineering, May 2010

JNTU, Hyderabad, India

80.8

12th Grade Score, Mar 2006

Board of Intermediate, Hyderabad

87.5

10th Grade Score, Mar 2004

Board of Secondary Education, Hyderabad

84.5

Contact this candidate