Data Management Cloud Services

Baby Lakshmi Sindhu Yanala

Ph: 803-***-**** Email: ***********@*****.***

Summary:

• Over 4 years of experience in gathering business requirements, conducting analysis, and designing, developing, testing, implementing, and documenting Oracle EPM solutions, including Enterprise Planning and Budgeting Cloud Services (EPBCS), Planning and Budgeting Cloud Services (PBCS), On-Premises Hyperion Planning, and Financial Data Management Enterprise Edition (FDMEE).

• Implemented and supported Oracle Enterprise Performance Management System 11 on Windows environments, ensuring reliable system performance and user accessibility.

• Administered and optimized Essbase applications by managing databases, fine-tuning Essbase architecture, loading data and dimensions, writing Calc Scripts and Business Rules, creating and executing MAXL scripts, configuring user security, and enhancing overall performance.

• Proficient in a wide range of Oracle EPM tools, including PBCS, EPBCS, FCCS (Financial Consolidation and Close Cloud Service), ARCS (Account Reconciliation Cloud Service), Essbase, Hyperion Planning, FDMEE, Hyperion Financial Reporting, Smart View, and Data Management, leveraging these tools to deliver tailored solutions.

• In-depth knowledge of financial processes, such as budgeting, forecasting, financial statement preparation, and planning cycles, enabling efficient alignment of technical solutions with business needs.

• Designed and implemented complex business rules and reusable transformations in Informatica, creating efficient mappings/mapplets to streamline data integration workflows.

• Facilitated seamless migration of applications and components across Test, UAT, and Production environments, ensuring minimal disruptions during transitions.

• Provided end-to-end development, production support, and administration for Oracle EPM solutions, ensuring high system reliability and user satisfaction.

• Expert in application migration using Lifecycle Management (LCM) utilities, effectively transferring data, metadata, and system components across environments.

• Automated recurring tasks and manual processes using EPM Automate, significantly improving operational efficiency and data accuracy.

EDUCATION:

SOUTHEAST MISSOURI STATE UNIVERSITY Jan’20 – Dec’21 M.S in Applied Computer Sciences

MIC College of Engineering Jul’14 – May’18

Bachelors in Electronics and Communication engineering Professional Skills:

EPM Tools: PBCS, FCCS, ARCS, EPBCS, On Premise Hyperion Planning 11.2.10, PCMCS. Data Tools: FDMEE, Data Management.

Reporting Tools: Reporting Web Studio (PBCS/EPBCS), Smart View. Languages: Groovy, Batch Scripting, SQL.

Cloud Services: Amazon Web Services (AWS)

MS Office Tools: MS Word, PowerPoint, Excel.

Business Requirements Gathering, Design Documents, FP&A, Process Flow & Data Flow Diagrams. PROFESSIONAL EXPERIENCE:

Oracle Hyperion Financial Analyst Apr' 22 - Till Date Client: Galderma

• Analyzed business processes and gathered user requirements to design and implement effective planning, budgeting, and reporting solutions, aligning with organizational goals and improving decision-making processes.

• Developed ASO and BSO applications, databases, and forms within Oracle Planning & Budgeting Cloud Services (PBCS), customizing solutions to meet unique client requirements and ensuring seamless integration with existing systems.

• Designed solutions for non-currency and multi-currency applications, ensuring accurate financial reporting and analysis across global operations.

• Configured data management workflows to load and transform actual and budget data efficiently, enhancing data accuracy and accessibility for end-users.

• Automated repetitive processes using EPM Automate, reducing manual efforts, improving efficiency, and ensuring consistent execution of critical tasks such as data loads and backups.

• Designed and implemented complex business rules, web forms, dimensions, menus, and member functions to support dynamic financial modeling and reporting.

• Coordinated testing and deployment of system changes, serving as the primary interface between business users and the development team, ensuring seamless implementations and minimal disruptions to business operations.

• Created advanced web forms with validation rules and ad hoc grids, enabling users to perform detailed financial analyses while maintaining data integrity.

• Loaded and transformed data and metadata from FDMEE, leveraging advanced techniques such as stripping mapping and member ignorance mapping to maintain consistency and accuracy in financial data.

• Prepared comprehensive knowledge transfer documents to support smooth handovers and ensure that teams had the necessary tools and information for ongoing system maintenance.

• Configured reconciliation profiles, rules, and workflows in ARCS, automating the reconciliation of actual data for healthcare operations, which improved transparency, reduced errors, and accelerated financial close cycles.

• Streamlined reconciliation processes in ARCS by integrating real-time data files, aligning financial data between budgeting and reconciliation systems to ensure accuracy and facilitate faster financial reporting for healthcare operations.

Environment: EPBCS, ARCS, Smart View, Data Management, EPM Automate, Reporting Web Studio.

Financial Analyst Jan’ 19 – Nov’19

NCR Corporation

• Developed an end-to-end Hyperion Planning application for the Business Data Processing (BDP) area, ensuring a robust and scalable solution tailored to meet organizational planning and budgeting needs.

• Enabled seamless data entry workflows by implementing both bottom-up and top-down data entry capabilities, improving the efficiency and flexibility of financial planning processes.

• Collaborated with stakeholders to gather user requirements from existing Excel-based reports, translating them into comprehensive, automated reports using Financial Reporting Studio (FR Studio) to enhance reporting accuracy and reduce manual efforts.

• Authored multiple MDX member formulas for ASO cubes to enable dynamic calculations and streamline data analysis, improving the performance and usability of reporting applications.

• Utilized Oracle Data Management tools to design and configure mappings, locations, import formats, and import scripts, enabling efficient monthly data loads into planning applications.

• Created and executed MAXL scripts to automate the transfer of data from BSO to ASO cubes, ensuring consistent and accurate data synchronization across applications.

• Developed complex business rules for transferring data between applications, automating repetitive tasks, and ensuring seamless integration within the planning ecosystem.

• Conducted comprehensive user training sessions to enhance adoption and understanding of the application, covering topics such as application usage, data loading processes through Data Management, and generating financial reports.

• Performed regular application backups using Lifecycle Management (LCM) and MAXL scripts, ensuring data integrity and system recoverability while minimizing potential downtime.

• Designed and modified reports using FR Studio, delivering dynamic and visually appealing financial reports that aligned with business requirements and improved decision-making. Environment: Designed and modified Essbase database outlines for better performance and for dynamic calculations.

PBCS Consultant Jun’ 18 – Dec’ 18

PAJ

• Managed monthly backups and year-end activities for planning and budgeting applications, ensuring data integrity and seamless continuity of operations during critical financial cycles.

• Provisioned and configured user access by creating new accounts and assigning appropriate roles and permissions for PBCS applications, catering to both user-level and power-user-level requirements, thereby ensuring secure and efficient system usage.

• Executed data management loads for FCCS and PBCS applications, streamlining data integration processes and enhancing the accuracy of financial consolidations and planning operations.

• Enhanced existing business rules to accommodate organizational changes such as newly added departments, stores, and brands, ensuring that the planning and budgeting system remained aligned with evolving business needs.

• Developed and implemented new business logic based on user requirements, providing customized solutions that improved the accuracy and functionality of planning applications.

• Automated data export processes by creating batch scripts to extract data from PBCS applications into files, facilitating downstream reporting and analysis.

• Maintained and updated data load mappings to adapt to changing data structures and requirements, ensuring efficient and error-free data transfers.

• Refined EPM Automate scripts by updating existing automation workflows to meet dynamic business needs, improving process efficiency and reducing manual interventions. Environment: PBCS, Data Management, EPM Automate, Smart View, Reporting Studio.

Contact this candidate