Analista Programador at Siemens
Brazil
- Current
-
- Analista Programador VBA - Excel Macro and Access - Office Specialist at Siemens
- System Analyst at A&A - In Any Place
- Past
-
- Management Information System - MS Access & MS Excel (VBA) at Promon
- System Analyst - ONCO BR - BPA Financial Reports at Novartis Biociências S/A
- Analista Administrativo de Vendas Senior at Fosfertil SA
- Education
-
- Centro Universitário Newton Paiva
- Centro Universitário Lusíada - UNILUS
- Connections
-
119
connections
- Industry
- Computer Software
- Websites
André Luiz Bernardes’s Summary
Responsible for the design, development, and maintenance of business programs.
Provide technical solutions to simple business problems while working
Analyzes and evaluates existing or proposed systems, and devises computer programs, systems and related procedures to process data.
Reporting to the Technical Support Group Leader, is responsible for providing technical and analytical support in the design, development, maintenance, and reporting of database and software applications ranging from medium to high complexity.
Key Skills/Competencies:
• Investigates and analyzes verbal or written requests for computer software. Confers with others and performs research to collect the information necessary to complete the specifications. Determines the specific changes or new systems or routines which need to be developed.
• Writes technical documentation for routines and small systems that facilitates their maintenance and effective use.
• 1-2 years experience writing reports using SQL and/or Crystal Reports.
• 8 years experience writing programs using MS Access, Visual Basic and VBA.
• Demonstrated proficiency in reading and interpreting logical and physical data models and being able to formulate appropriate data relationships.
• Demonstrated proficiency with Microsoft applications, specifically Access, Excel, Word and PowerPoint.
• Demonstrated ability to organize, prioritize, coordinate, and manage simultaneous projects/tasks to ensure deadlines are achieved.
• Demonstrated ability to quickly learn new technology and data concepts.
• Highly developed analytical and problem solving skills, with a strong focus on detail.
• Actively involved in the implementation of a software system or process into the production environment
Particularly interested in client/server and relational database design using Oracle, Sybase, and MS-SQL Server. Apply MS Office suite.
André Luiz Bernardes’s Specialties:
Financial exec with broad experience in all aspects of accounting, auditing and financial management.
Application Developer, Database Administrator, and Project Manager in a wide variety of business applications.
Always interested in migration projects, as well as close interaction with the DB manufacturers.
VBA, MS ACCESS, MS EXCEL, BI
SAP R/3, BW, SD
PEOPLESOFT, BAAN.
André Luiz Bernardes’s Experience
-
Analista Programador VBA - Excel Macro and Access - Office Specialist
Siemens
(Public Company; si; Industrial Automation industry)
March 2009 — Present (5 months)
GSS - Mobility Services is part of Global Shared Services since October 2006.
PML - Procurement, Mobility and Logistics. Área de Compras - Informações consolidadas em KPIs
Criação de Dashboards e Scorecards.
Interface desenvolvida com o MS Excel.
Dados conectados através de aplicação MS Access que consolida todos os dados (planilhas eletrônicas, arquivos texto, conexões DAO, cubos OLAP, etc). Aplica filtro a essas consolidações disponibilizando informações para diversas interfaces, entre elas:
Powerpoint - Apresentações eletrônicas conectadas às bases.
Dashboard - Interfaces atualizadas através de Pivot Tables.
See more details in http://al-bernardes.sites.uol.com.br/ -
System Analyst
A&A - In Any Place
(Privately Held; 1-10 employees; Computer Software industry)
April 2005 — Present (4 years 4 months)
* Develope brand strategy and statistics systems.
* Strategic Consulting, including business plan & sales strategy
development.
* Advising new businesses on formation of corporations and business
structures, drafting privacy policies and structuring commercial
transactions.
* Generated new development deals for a real estate development
company that focuses on multi-family residential projects, including
real-estate market analysis.
* Comprehensive database management and migration from SQL to
Oracle.
* Comprehensive database management and migration from SQL to
MS Access, MS Excel.
* Assembly and develope M.I.S. (Manager Information System) with
any Database (Oracle, My SQL, SQL Server, Firebird, Sybase, etc. ..) -
Management Information System - MS Access & MS Excel (VBA)
Promon
(Privately Held; Construction industry)
June 2008 — February 2009 (9 months)
Designs, programs, tests, implements, documents and maintains computing applications.
Gathers and evaluates End User requirements.
Writes and compiles code, and constructs database objects based on documented design, and analyzes information to determine:
- Architecture Specifications.
- Parameters for Software Compatibility.
- Application Security needs.
- Other Application Architecture requirements.
- Modifies and/or upgrades applications to maintain
software functionality.
- Identifies and resolves Programming and/or Application
Architecture problems.
- Reviews system performance, and identifies and
recommends improvements.
Developing code routines using Microsoft Access and Visual Basic for Applications to push/pull data from Microsoft Excel spreadsheets for data processing. -
System Analyst - ONCO BR - BPA Financial Reports
Novartis Biociências S/A
(Pharmaceuticals industry)
January 2007 — May 2008 (1 year 5 months)
Assistente do BPA (Business Planning Analyst) na área financeira de oncologia.
§ Separable performance management system. Developing, delivering planning, reporting, scorecarding, dashboards,
analysis and financial consolidation.
§ Replace rigid, annual budgeting with continuous planning—daily, weekly, or monthly.
§ Gain greater flexibility—Create your own business rules and structures, Reporting and analysis. Transforms heterogeneous
BI data sources into a business view Multidimensional slicing-and-dicing, drill-down. -
Analista Administrativo de Vendas Senior
Fosfertil SA
(Privately Held; 1001-5000 employees; Chemicals industry)
January 1999 — April 2004 (5 years 4 months)
Listas de Preço:
Criação, Cadastramento no SAP R/3, divulgação para clientes no mercado interno e externo.
Contratos:
Nacionais e Internacionais,
Manutenção da vigência, Taxas aplicadas, Renovação, etc.
Gestão dos dados mestres
Criação e implementação de BI em MS Access
Gestão dos preços, descontos e respectivas análises
por Clientes no SAP R/3.
Levantamento e análise do Marketingshare
Módulos de SD, MM e CO.
Interação e definições de KPIs para o BW.
André Luiz Bernardes’s Education
-
Centro Universitário Newton Paiva
Curso Superior em , Tecnologia em Gestão da Tecnologia da Informação , 2008 — 2010 (expected)
O Curso Superior de Tecnologia em Gestão da Tecnologia da Informação objetiva trabalhar de forma sistêmica as duas filosofias envolvidas: GESTÃO DE NEGÓCIOS E TECNOLOGIA DA INFORMAÇÃO, com o propósito de atender a uma demanda mercadológica latente de profissionais especializados em gestão de negócios com ênfase em tecnologia da informação aliando assim a teoria à prática e despertando o espírito de empreendedorismo aliado às práticas tecnológicas de gestão. Busca-se preparar o aluno para as pressões competitivas.
Atualmente o que vemos no mercado de trabalho são profissionais extremamente capacitados para desempenhar funções administrativas sem no entanto terem conhecimentos e habilidades em ferramentas de tecnologias da informação que possa vir a facilitar suas operações, ou em outro extremo, profissionais capacitados tecnicamente a lidarem com tecnologias mas sem conhecimento em gestão de negócios.- Activities and Societies:
- O Centro Universitário Newton Paiva está credenciado para o oferecimento de cursos por meio do parecer CES/CNE nº 341/04 e Portaria n.º 1.064, de 25 de maio de 2006.
-
Centro Universitário Lusíada - UNILUS
Tecnólogo , Informática , 1998 — 2002
A grade curricular compreende abranger as competências pessoais, de informática e gerais. As disciplinas básicas foram: Comunicação, Ética e Responsabilidade Social, Linguagem e Técnicas de Programação, Sistemas de Computação, Análise de Sistemas, Estrutura de Banco de Dados, Rede de Computadores, Tele-Processamento, Ambiente WEB, Programação Avançada, Informática Avançada, Auditoria e Qualidade, Projeto de Sistemas, Matemática e Inglês.
- Activities and Societies:
- Este curso já está na sua 20ª turma e é considerado o mais antigo de Santos, entre os cursos tecnológicos. Reconhecido pelo parecer CFE 444/91.
