Rodrigo Simões de Mendonça

Brazilian. ** years old. Married.

Abagiba St., 582 – Sao Paulo/SP - Brazil

+55-11-982**-****(Mobile)

adkqft@r.postjobfree.com

Objective

Finance. Planning Analytics TM1 Consultant.

Summary

Project Lead Consultant focused on designing and developing customized financial solutions working on projects with IBM Planning Analytics.

Graduated in Information Systems and Post-Graduated in Accounting, Controllership and Finance, certified by IBM as a PA developer, database administrator and analyst. Around 15 years of IT and Finance experience, since 2013, focused on developing and modeling customized solution of Financial projections, Demand Planning (Sell In/SellOut) and / or Strategic Planning (Budget, Forecast, G&A, CAPEX, Cash Flow, Profitability), Business Intelligence and Performance Management projects in Retail, Sugar and Ethanol, Call Center, Cellulose, Industry and Banking areas, working on projects with IBM Planning Analytics and TM1 software.

Strong knowledge in:

- Create and deploy complex TM1 models with advanced rules, feeders, Turbo Integrator.

- Create Applications and Databases.

- Create TM1 Perspectives/PAX active form spreadsheets for reports, inputs and cockpit load files.

- Specialist in create reports in PAW – Planning Analytics Workspace

- Create and implement TM1 security.

- Modeling Data with IBM Planning Analytics.

- Optimize and tune models. Good experience on workflow design.

- Significant experience as DBA Oracle/SQL building queries for data analysis.

- Give technical trainings and workshops on solutions and tools developed. Professional Experience

• CTI Global Consultants (Apr./2013 – present)

Lead Consultant – IBM Planning Analytics

CTI Global Consultants is a highly specialized boutique company, IBM Platinum Business Partner, focused on financial performance management and IT.

- Delivery of financial and business solutions that address CFO's problems in information and FPM, using IT and business and financial knowledge.

- Project management such as scheduling, follow ups, project activities, team members and their roles

- Experience with Agile/Scrum methodology

- Development of customized complex models using IBM Planning Analytics: o Financial and technical modeling of FP&A solutions, conducting interviews with key users o Strong knowledge of Planning Analytics Modeler tools, such as cubes and dimensions, complex rules, feeders, Turbo Integrator processes, etc. o Strong knowledge of Planning Analytics User and Administrator tools o Reports and dashboards creation using TM1 Perspectives, TM1 Web, PAX and Planning Analytics Workspace

o Conducting workshops on developed solutions for clients o Development and conducting training programs for new employees Implemented models: Budget and Forecast models, Revenue, Costs and Inventories, OPEX, CAPEX, Payroll, Financing, Logistics, etc. integrated with Income Statement, Cash Flow, Balance Sheet on the following clients:

Major Projects:

Coca-Cola – Industry; Cosan/Raízen (Shell) - Sugar and Ethanol; Tereos - Sugar and Ethanol; Fibria – Cellulose; GPA - Grupo Pão de Açucar – Retail; Centauro – Retail; Atento - Call Center; Contax - Call Center; Omni - Air Taxi; ExxonMobil - Oil; Santander Bank; Hypera - Pharma.

• Unisys Brazil (Aug./2009 – Nov./2012)

DBA/System Analyst

Worked with the responsibility of monitoring and managing projects in 24x7 environments for Government Bank and Department of Labor. Installation, creating, configuring, administering Oracle 10g databases, users, roles, tablespaces, datafiles, support the development and production, planning and execution of strategies for backup and recovery, documentation for growth, performance and tuning plan. Environments for tape backup management tools through Symantec Backup Exec / NetBackup and HP Data Protector. Implementation and monitoring processes audited by ISO 27000, 20000, and 9000 of the ITIL best practice standards.

• CLONE – IT Accessories (Nov./2005 – Feb./2009)

IT Technician

Performed the activities for approval of product, quality testing, preparation of technical reports, internal technical support, installation and maintenance of software and hardware product development, packaging, manuals and assistance in the implementation of ERP.

• IAP – Advanced Plastic Institute (Jul./2005 – Nov./2005) Web Designer

Developing the company's website, organization's mailing, drafting emails dissemination, development of direct mail, developing technical handouts, issuing invoices.

• INSS – Instituto Nacional do Seguro Social (Jan./2004 – Jul./2005) Intern

Played in assisting the general logistics of the Company, Help Desk, document filing, customer service and suppliers, receiving courier, mail, central reprographics, couriers and shipping activities.

Education bac kgro und

• Post-Graduation, Accounting, Controllership and Finance. At FIPECAFI-USP – São Paulo University (2016 - 2017);

• University, System Analysis, IT.

At USCS – São Caetano University (2007 - 2010);

• College, IT Technician.

At Brasília College (2004 - 2005).

Skills & Expertise

- IBM Planning Analytics Modeler.

- TM1 PAX/Perspectives active form reports.

- Planning Analytics Workspace advanced reports, dashboards and Financial Workflow.

- ETL Construction with Turbo Integrator, SQL Server Integration services and Infosphere DataStage.

- Knowledge and work experience in Oracle Databases and SQL Server, built Queries for data analysis and Dimensional Data Modeling.

- DBA Oracle/SQL knowledge (Create databases / Backups / Create Tables, indexes and constraints).

- Project Management and Planning.

- Self-taught knowledge and work experience in Hardware. Languages

English (Fluent).

Spanish (Basic).

Portuguese (Native Language).

Certifications a nd Cou rses

- IBM Planning Analytics Modeler, Administrator and Analyst 2021.

- English course - Yagizi Internexus (School of English), studied for 5 years.

- Accounting for non- accountant – FIPECAFI.

- OCP Oracle Database Certified Professional 11 G: Oracle Database 11g, Introduction to SQL, Administration Workshop I and Administration Workshop.

- MCTS SQL Server 2008 R2 - KA Solution: Implementation & Maintenance, MCTS Microsoft SQL Server 2008, Database Development.

- VMWare vSphere: Administration and Operation – Unisys Brazil.

- NetBackup 7: Administration and Implementation – Symantec Brazil.

- Backup Exec 2010: Administration and Implementation – Symantec Brazil,

- HP DataProtector 6: Administration and Implementation – Eduksempre.

- VMWare vSphere Administration and Operation.

- IBM Power Systems and IBM i SO – IBM.

Contact this candidate