Rogerio Andrade Email and Phone Number
SQL Server DBA, BI Consultant and MCSA Power BI, passionate about data analysis with 17 years in IT field.I have always studied concepts before applying the business to the tools, this gives me the flexibility to work with different types of databases and dataviz.My work preference is with SQL Server Database and Power BI. I have good experience with these tools and even when I didn't work directly, I always used them as an example.I have experience with ETL and Integration using Integration Services (SSIS)Creation and Use of OLAP with exploration of cubes generated by Analysis Services (SSAS)As a SQL Server DBA, I developed a lot of my studies on databases and their needs, always thinking about performance and the best possible use according to business rules.Friendly conduct, good communication, teamwork, transparency, resilience, proactivity and optimism are my trademarks.Project would I like to be part of :)Projects with space for improvement and innovation, where the application of my skills can make a difference in the company, increasing profits, achieving results and changing the lives of the people involved directly and indirectly for the better.How Business IntelligenceWork on projects that think about organization, market research, planning, execution and evaluation using data and indicators as a basis.How Database AdministratorProjects where my main job as DBA will be to ensure quality, performance and if there are risks, that these can be planned and minimized.
Stefanini Brasil
View- Website:
- stefanini.com
- Employees:
- 24504
-
Senior Business Intelligence AnalystStefanini BrasilFederal District, Brazil -
Senior Business Intelligence AnalystStefanini Brasil Oct 2022 - PresentBrasília, Distrito Federal, BrasilAnálise e desenvolvimento de Relatórios em PowerBI Report Service:• Criação de cargas para bases SQL Server• Criação de rotinas Integration Services (SSIS)• Criação de cubos e camada Semântica no Analysis Services (SSAS)• Definição de Indicadores• Criação de relatórios e dashboards -
Consultor Em Gestão Da Informação E BiAutônomo Jul 2019 - Oct 2022BrasilAnalista de dados e BI, atualmente trabalho criando projetos e modelos de gestão do conhecimento.O que é Gestão do conhecimento?Trata-se de algo mais que BI (Business Intelligence), a Gestão do conhecimento confere a organização, descentralização e compartilhamento conforme nível de acesso de todos os objetos importantes para o bom funcionamento dos processos da empresa.Como isso é realizado?• Fazendo o diagnóstico Situacional;• Estudo do negócio, processos, missão, visão e valores determinados pela empresa;• Análise SWOT do modelo atual;• Conhecimento de Equipe e análise de resultados de Recursos Humanos;• Análise de Centro de Custos, Contratos, Insumos estratégicos e despesas • Estudo de mercado etc.Com base nessas informações é criado o modelo que pode ser direcionado aos objetivos da organização ou mesmo seguir um modelo generalizado onde todos tenham visão do todo.Aplicabilidade do projeto de Gestão da Informação:• Maior eficiência no acesso de informação• Gestão • Transparência• Foco na informação• Repositórios de informações compartilhadas• Consolidação da memória institucional• Informação Simplificada, atualizada, móvel e automática• Auditoria e melhoria dos processos atuais• Ganho de tempo • Economia de recursos e redução de custos• Análise facilitadas de orçamento• Profissionalização de equipe• MeritocraciaPara isso tenho experiencia aplicada desde 2006 nas seguintes áreas:• Desenvolvimento de Software• Análise de sistemas• Análise de Negócio• Processos e Micros Serviços (Microservices)• Business Intelligence, SQL Server, Certificação em Power BI, Modelos de dados Multidimensionais entre outras ferramentas e atividades nos últimos anos.• Conhecimento em gestão de conflitos, relacionamentos, liderança, PNL e atualmente estou estudando psicologia cognitiva e marketing para aplicar em tomadas de decisão mais assertivas.Habilidades• Trabalho em grupo• Transparência• Resiliência• Proatividade• Otimismo
-
Dba, Business Intelligence ConsultantVeriz Tecnologia Oct 2019 - Sep 2022Brasília, Distrito Federal, BrasilData infrastructure support:• Installation and configuration of environments and databases (AWS RDS and AWS EC2)• Ensuring good practices• Planning and execution of maintenance• Performance maximization• Integration between databases• Automation and Job creation• Disaster Recovery and Failover Documentation• Configuration and maintenance of LogShipping and AlwaysOn• Experience with horizontal and vertical scalability definition• Development support• Monitoring and decision makingPower BI environment support:• Office 365 configuration• Access, maintenance, permission to workspaces• Configuration for On Premises gateway, and Azure AD for Analysis Services (SSAS)• Creation of Integration Services (SSIS) routines• Definition of Indicators• Creation of reports and dashboards
-
Business Intelligence CoordinatorGeap Autogestão Em Saúde Oct 2018 - Apr 2019Brasília E Região, BrasilManagement Situation Room (SSG) Project, GEAP Knowledge ManagementProject needs:• Greater efficiency in accessing information;• Management;• Transparency;• Resource savings;• Shared information repositories;• Simplified, updated, mobile and automatic information;• Audit and improvement of current processes;• Time gain;Project Definition and Phases• Phase I – Diagnosis;• Phase II – Planning;• Phase III – Execution;• Within the execution, there is an evaluation of the results for each released feature;Diagnosis of obstacles for SSGDiagnosis and plan “knowledge of the GEAP business”Knowledge action planDocumentation of the execution of the action planDefinition of the team involved in SSG GEAP projectsStudy• Concept and History;• Mission vision values;• Statute;• Organization Chart;• Business;• Organization model;• Representatives and regulators;• System (SISGEAP);Definition of Project Indicators• ROI (Return on Investment) based on the diagnosis;• Internal (axes);• External;• Strategic;• Tactics;• Operational (Meeting goals);• Based on SISGEAP; -
Information Management CoordinatorEicon - Controles Inteligentes De Negócios Ltda. Mar 2015 - Sep 2018São Paulo E Região, BrasilCoordinator of the Information Management department, former Administration of Database and Business Intelligence (AD & BI)My story at EiconHired as Full BI Programmer Analyst (Jun/2011)My Director and mentor took over the department in the same year I was hired, since then he has prepared me to be his successor.I was promoted to senior, and in 2015 I had the opportunity to coordinate the DGI for the second time.Mission:Management, Planning and maintenance of the organizational and productive climate, promote training and internal evolution, disseminate knowledge, ensure productivity growth, audit processes using best practices.With the knowledge acquired and the determination of limits on the fronts of action, I can manage conflicts, minimize pressure points and increase productivity.As? Knowing the terrain, determining strategies and anticipating future problems.Department of Information Management (DGI)Responsible for the laboratory of part of the organizational model of the Strategic Services Department (DES).Always working with the directors of services and technology in the delivery of processes and systems adhering to the customer and the Eicon sales model, basically what the president dreams of to create the largest public management project in the country that will benefit everyone.DGI - Fronts of actionDevelopment - New productsMaintenance - Products in production environmentCommercial - Concepts, demonstrations, direct sales ProjectManagement situation room and municipal situation roomCodename: Project Matrix HTML5 - SPA, responsive frameworkProjects started with the concept of BI, but it is not a BI itself.The sale of BI is ruled out by Eicon for its handling complexity and for our market niche, our idea is to create an information management project that takes the user to what he would like to see in different types of views with maximum mobility . -
Analista Programador BiEicon - Controles Inteligentes De Negócios Ltda. Jun 2011 - Mar 2015Missão:Desenvolver ferramentas que utilizam conceito de BI na Web em HTML5 ou Silverlight, utilizando inteligencia de busca dos dados em webservices e bancos de dados com modelo multidimensional.Programador C#, VB.NET, Entity Framework, Oracle e SQL ServerAplicação de arquitetura em WCF, Rest, Soap e integração de sistemas.Aplicação de estrutura de sistemas com Webservice e RPCsDesenvolvimento com JavaScript, HTML, Jquery, Kendo, Angular.Desenvolvimento de aplicações com Liguagem estruturada e Orientação a Objeto.Estudo de ferramentas como Analysis service e power center.Desenvolvimento com Linq e Dynamic linq na utilização multi database.Desenvolvimento com aplicações Web com arquitetura em MVVM.Desenvolvimento com orientação a Serviço (SOA).Desenvolvimento na utilização do RadControls (ASP.NET), Telerik (Silverlight), Kendo e Angular js (Html).Criação de estrutura de aplicações em camadasCriação de estrutura de base de dados (Relacional, e Multidimensional utilizando Star Schema). -
Programmer AnalystOrgm It Solutions Jun 2006 - Apr 2011Veleiros, Sp - São Paulo BrasilDevelopment of new features on company ERP, Management and Support of clients, personalization of ERP for the clientsProgrammer VB, VBA, VB.NET, Asp.NET and SQL Server.Development, customization of ERP system.Operating system control.
Rogerio Andrade Skills
Rogerio Andrade Education Details
-
Information Technology
Frequently Asked Questions about Rogerio Andrade
What company does Rogerio Andrade work for?
Rogerio Andrade works for Stefanini Brasil
What is Rogerio Andrade's role at the current company?
Rogerio Andrade's current role is Senior Business Intelligence Analyst.
What schools did Rogerio Andrade attend?
Rogerio Andrade attended Universidade Anhembi Morumbi.
What are some of Rogerio Andrade's interests?
Rogerio Andrade has interest in Social Services, Civil Rights And Social Action, Consultoria Em Bi, Education, Analista Desenvolvedor, Science And Technology, Human Rights, Analista Desenvolvedor Bi, Arts And Culture, Analista Em Integração De Soluções.
What skills is Rogerio Andrade known for?
Rogerio Andrade has skills like Microsoft Sql Server, C#, Microsoft .net, Asp.net, Oracle, Sql, Vb.net, Scrum, Silverlight, Xml, Vba, Entity Framework.
Who are Rogerio Andrade's colleagues?
Rogerio Andrade's colleagues are Lian Dias, Isabela Cristina, Aline Molina Sguerri, Silvana Gomes De Lima, Hossein Monfared, Maria Luíza Amorim Rohde, Jenifer Elizier.
Not the Rogerio Andrade you were looking for?
-
-
Rogério Andrade
São Paulo, Sp -
Rogerio Andrade
São Paulo, Sp2hotmail.com, avantto.com.br -
2hotmail.com, brf-global.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial