Hyperion Developer

LIKITHA BADDAM

Dallas, TX LinkedIn Portfolio +1-940-***-**** ***************@*****.***

PROFILE SUMMARY

● 5+ years of hands-on experience in designing, developing, and maintaining Oracle Hyperion solutions, including HFM, Hyperion Planning, and Essbase.

● Proficient in combining finance and technology to deliver impactful consulting and development services.

● Strong experience in Hyperion Essbase 11.1.2.X/11.1.1.X, Hyperion Planning 11.1.2.X /11.1.1.X, Hyperion Financial Management, Hyperion Web Analysis (Web Analyzer), Financial Data management enterprise edition 11.1.2.X.

● Performed End to End DRM implementation (An upgrade from 11.1.1 to 11.1.2 version).

● Proficient in managing master metadata, maintaining hierarchies and version control process.

● Expertise in financial consolidation, planning processes, data integration, and system performance tuning.

● Strong proficiency in Hyperion scripting languages (MaxL, MDX, Business Rules) and data integration tools (FDMEE).

● Strong experience in Essbase Cube analysis, design and development, database administration and performed Upgrades, Maintenance, Database backups, Performance tuning, optimization of BSO/ASO Cubes, Dense/Sparse settings, partitioning etc.

● Expert in financial analysis, managing multidimensional data cubes, forecasting and budgeting, performing detailed data slicing and dicing, identifying root causes and building Forms & Dashboards.

● Experience in troubleshooting and creating financial reports in Hyperion Financial Reports.

● Experience in working through all phases of Software Development Life Cycle (SDLC) including the design, development, implementation, and maintenance of financial applications.

● Well versed in software documentation, preparing manuals for team members and end-users, report writing etc.

● Expert in handling P1, P2 ServiceNow tickets (incidents and change managements), providing resolutions without breach of time.

● Excellent problem-solving skills with the ability to communicate effectively with both technical and non-technical stakeholders.

WORK EXPERIENCE

Cognizant Technology Solutions (Full-time) Nov 2019 – Dec 2022 Voya Finances – EPBCS Engineer

● Oracle EPBCS administrator, working with FP&A users for daily maintenance and support.

● Administered Oracle EPBCS and EDMCS, managing metadata and maintaining hierarchies across applications.

● Developed and maintained data forms, dashboards, business rules, and managed system performance, backups, upgrades, and audits.

● Integrated EDMCS with Planning, HFM, and Essbase to ensure metadata consistency and optimize financial processes.

● Created financial reports in Hyperion Financial Reporting (HFR) and handled consolidations for budget and forecasting processes.

● Provided technical support and resolved issues using SmartView (Essbase Excel Add-In) for FP&A users.

● Ensured timely resolution of incidents and change requests using ServiceNow. Agilent Technologies – DRM Developer

● Performed an End-to-End implementation of DRM

● Handled hierarchy structures for dimensions as per the requirement analysis by clients.

● Created Validations and Exports to push hierarchies to the downstream applications.

● Integrated DRM with Planning and HFM to streamline metadata and enhance consistency across the platforms.

● Facilitated DRM and ASO integration with ERP and external sources ensuring data across the systems remains accurate.

● Created and tested Versions according to the monthly activities and scenarios

● Created application specific Exports, Imports and Books.

● Involved in derived property value derivations using Java script and formulas.

● Performed unit testing of each created DRM components.

● Metadata validation between DRM and Hyperion applications (Planning, Reporting, HFM) and Essbase.

● Migrated required artifacts from one environment to another using Migration Utility.

● Weekly maintenance of all instances and synchronization.

● Provided access to the team, business users and IT teams following security terms.

● Documented the process, test reports and user manuals for the end users.

● Participated in month end activities and batch integrations after the live. Estee Lauder – EPM Engineer

● Worked on both EPM and DRM, providing business the required services.

● Handled daily activities such as data loads, data issues, and ticketing.

● Automated data loads and data backup of EPM from Unix and windows increase by 12% efficiency.

● Managed HFM consolidations and financial closures.

● Administrated to the business users under Planning and Essbase servers.

● Handled and performed ad-hoc analysis, input the data and drill down to the level 0 members.

● Overseen the project scope, KPIs, SLA, release schedules ensure timely and quality outcomes.

● Managed 20% of data changes and version controls ensuring data assets are up to date and reflect business conditions.

● Implemented and overseen systems for tracking change requests and documented all the changes to audit compliance and effectiveness.

● Collaborated with IT teams, Business leads and Analysts to understand and support their requirements by engaging strategic planning sessions to drive business values. Amba Systems Inc Nov 2017 – Apr 2019

Data Analyst – Intern

● Explored and analyzed a large amount of data related to healthcare security using Power BI.

● Built automated queries to analyze the data using SQL required for the user.

● Created dashboards and reports for ease access to the users, reducing 10% of the effort to analyze numbers.

● Worked with various visualization types, charts, plots, and maps

● Hands-on with data blending, Pivoting, joins, calculations, and expressions.

● Presented insights and findings providing forecast trends requested by the business.

● Improved data engine performance by 8% optimizing data extract, source filters and aggregation methods.

● Documented the automated methods and techniques for the trainees. PROJECTS

Financial Risk Management System using AI Feb 2024 – Mar 2024 Developed a predictive risk management system using Python and machine learning algorithms (Logistic Regression, Random Forest) for a hypothetical global logistics firm using the "Global Logistics Financial Data" dataset from Kaggle. Enterprise Data Warehouse for Olympic Game Management Mar 2020 – Apr 2020 This is a software system designed to store and manage historical data related to activities in five key departments of the Olympic Games: Player, Country, Game, Schedule, and Medal Ranking. This data warehouse facilitates efficient reporting and supports the sustainability of the event by integrating diverse resources. Utilizing Informatica PowerCenter for the ETL process, the project aims to systematically capture and fulfill functional requirements, ensuring comprehensive data extraction, transformation, and loading into the target data warehouse. SKILLS

Programming Languages: Python, SQL, PL/SQL, MDX,

Front-end Technologies: HTML5, CSS3

Databases: MySQL, Oracle SQL, PostgreSQL, Microsoft SQL server Business Data Management: DRM, EPM, Essbase, EDMCS, FDMEE, ARCS BI (Business Intelligence) Tools: Planning, Reporting, EPBCS/PBCS, HFM, HFR, ODI, Tableau, Power BI, IBM Cognos, MicroStrategy Reporting tool, Informatica Power Centre Service Tools: SNOW (Service Now), Smart View, Microsoft Excel, JIRA EDUCATION

University of North Texas Jan 2023 – May 2024

Master’s in Computer Engineering

CGPA: 3.8 / 4.0

Contact this candidate