Anderson Pereira

BI Analyst SulAmerica Seguros SA Built Oracle Hyperion Essbase database, performed data loading of financial data and utilized calculation scripts to properly update information.

•Developed and Maintained BSO Cubes.

•Created rules files for dynamic outline build.

•Worked on Oracle database to Map databases and constructed Data Mart.

•Modified and maintained Oracle Hyperion Essbase applications and databases to incorporate new business requirements.

•Developed and employed calculation scripts.

•Utilized Excel Spreadsheet Add-in reporting tools to help meet the reporting needs of business and management.

•Performed the analysis necessary to design and architect solutions that meet identified client requirements.

•Worked closely with client management and users to define requirements and project scope.

•Managed the use of time and other resources to complete projects.

•Modified and maintained Oracle Application Express APEX.

•Develop and maintain automation of data flowing into and out of Microsoft Power BI.

BI Analyst Capgemini SA Project TV Globo, Brazilian Television company.

• Provide end user support to assist with application training and reporting training.
• Develop and maintain Smartview Reports
• Create and maintain technical documentation for core system processes, break fix manuals and maintenance playbooks
• Validate Hyperion systems after patches are installed and after environment refreshes are performed

Project OI, Telecommunication company.

• Provide end user support to assist with application training and reporting training.
• Writing Essbase Calculation Scripts, Hyperion Planning Business Rules using Calc Manager.
• Develop and maintain Smartview Reports.
• Create and maintain Hyperion Planning forms and Tasklists.
• Use Hyperion Shared Services to maintain Planning and Essbase security.

BI Analyst AdQuam Consulting Project Espírito Santo travel, touring company.

•Develop Hyperion Planning application dimensions and hierarchies.

•Develop, maintain, and troubleshoot data load rules, calc scripts, business rules, WebForms, and reports.

•Develop and maintain automation of data flowing into and out of Hyperion Planning.

•Perform upgrades, proactive tuning, optimization, and monitoring of Hyperion environments.

•Work with infrastructure team in identifying and resolving environment (database, OS, network, security, etc.) issues.

•Effectively communicate progress and issues with management and team.

Project Salvador Caetano, company car market.

•Involved in implementation, migration and validation for Oracle Hyperion System 11, Oracle Database 11 g and Oracle Data Integrator.

•Worked closely with IT and finance teams to resolve issues, upgrade, develop, test, and implement financial systems.

•Interaction with finance and accounting customers who possessed various levels of business knowledge.

Computer Technology UniverCidade

Hyperion Essbase Dimensi Consultoria