Analyst

CARLA NEGRAO

415-***-**** / ac3yzm@r.postjobfree.com

EDUCATION

• Beginning Programming: Python, Stanford University, San Francisco, CA. 2017

• Professional Program in Data Analysis, Berkeley University, San Francisco, CA. BI with SQL / Introduction to Databases / Data Modeling and Database Design 2017

• MBA in Strategic Management of Information Technology, FGV, Sao Paulo, Brazil.

(According to the report published by QS Global 200 Business Schools in 2014, FGV is the only Brazilian school in the ranking of the World’s Best MBA schools.) 2016

• Analyzing and Visualizing Data with Power BI – Microsoft/EDX 2016

• Specialization in Project Management, FIAP, Sao Paulo, Brazil. 2009

• MBA in Business Management and Technology, IPT/USP, Sao Paulo, Brazil.

(University of Sao Paulo is considered the Best Brazilian University) 2005

• Bachelor Degree in Business Administration, FIEO University, Sao Paulo, Brazil. 2004 EXPERIENCE

Business intelligence Specialist, Alelo, Sao Paulo, Brazil. 2012-2016 Results Oriented

• I changed the way the BI development and production teams communicated, bringing more information, transparency and collectivity spirit to both teams, influencing the BI area culture to create guidelines facilitating production support, offering inputs to maintain service quality.

• Led the first BI project in the new environment, following new development standards, including the usage of Informatica Power Center tool. During this challenging project, my team encountered many unpredictable situations, but it was possible to find the best solution to deliver the project with success.

• Led the BI pilot project executed in a specific region of Sao Paulo, to understand the consumption pattern in the region's restaurants, stimulated by SMS promotion to the users. In a sample of 200K registered users and 400 restaurants, the results were 6% increase in consumption in partner restaurants, 21% increase in the average ticket for Alelo.

• Built the commercial planning area’s Dashboard, containing expected and accomplished revenue, so that the area could daily control and adjust plans to achieve their goals.

Problem Solving and Analytical skills

• Standardized the BI user access defining the request process according to the company standards and norms.

• Translated business needs into technical solutions, ie. created functional and technical specifications of the company's financial control project, containing large groups of information: profile, order, electronic invoice, billing and fees, validating 6MM records/day.

• Built Data Model using star and/or snowflake schema.

• Developed and delivered BI solutions creating attributes, metrics, filters, consolidation, mobile dashboards, MicroStrategy distribution services, user security administration and access, data discovery, reports, dashboards and ad-hoc.

• Design and maintained ETL process with 5MM daily processed records, 982 DW tables, 305 DM tables. The DW had 3.5 TB of information registered, 330 Stored procedures and 70 ODI process, data load of 8MM users, 490K commercial stores and 100K customers.

• Followed and executed project deployments (Development, Staging Area, Production).

• Maintained existing projects: 18 MicroStrategy projects, average of 2500 report extractions per month. One of the projects I developed had about 5 million active users. Managed and developed several projects simultaneously. Business Intelligence Manager, Bradesco Foundation, Sao Paulo, Brazil. 1999-2012 Leadership/Teamwork

• Created the BI area in the company, managing a team of 5 people.

• Responsible for selecting and allocating BI consulting companies to attend requests from departments and 40 schools.

• Planned budget for the BI area, which represented 10% of the IT department staff and created and evaluated BI KPIs. Problem Solving and Analytical skills

• Maintained existing projects: 81 active MicroStrategy users, 15 Dashboards, 16 totems, 80 auditing reports and 600 common reports, DW 44GB and metadata 3.5GB, more than 3.45MM students inserted on the database.

• Followed and executed project deployments (Development, Staging Area, Production). Results Oriented

• Planned, managed, developed and delivered BI projects. As an example, one of the projects achieved 97.6% cost reduction, 93% time reduction and 75% less human resources to produce reports to the strategic planning area. VOLUNTEER ACTIVITIES

• Student Ambassador – San Mateo Adult School 2017

• Volunteer Intake Processing Center and Biomedical Services: Blood Drive – American Red Cross 2017

• Microsoft: renovate school, Brentwood Acadamy in Palo Alto 2017

• Food delivery to the homeless through Glide Memorial Church in San Francisco 2016

• Food delivery to homeless in Brazil 2014

• Social Marathon fundraiser (social environmental 6 months project) 2008 LANGUAGES

• Portuguese: Native Speaker • English: Fluent

GENERAL SKILLS

MS Project, Visio, Bizagi, Erwin, Basics R, MicroStrategy, Power BI, Tableau, SQL Server, Oracle DB, SQL Server Integration Services

(SSIS), Power Center, ODI, Putty, Shell Script, Office, BPM projects, PMI Methodology, Client/server Application, Centura, Python, Agile/SCRUM, Relational and Dimensional Model, OLTP, OLAP. ITIL e COBIT certified. Speaker at the fifth edition of the MicroStrategy Business Intelligence Symposium Brazil - "The implementation of the strategy through control panels" - Aug / 2010.

Contact this candidate