Marcelo Franceschi de Bianchi

Outras informações:
I am working at São Paulo / SP, from January of 2016 until nowdays, actuating like Professor of Computer Science Area to the University Universidade Ibirapuera. I teach in the evening period for the Computer Science Course the following subjects: Graduation Course: ? Programming Language (C/C++) ? Object Oriented Programming (Java JSE)

Outras informações:
I currently work in São Paulo / SP, started my activities since May of 2015 until nowdays in TQI Consultoria. I am business intelligence engineer or Data Engineer for TQI Consultoria at São Paulo Brazil since may of 2015 until today working for the customer: Telefonica / Vivo. I work with Multidimensional modelling, creating new data marts from different sources and for the ETL (Extranction , Transformation and Load) operations using Integration Services and SAS software. For the OLAP process I am using the meta data mapping and the reports I am using Microstrategy. I ´ve been working with project management (updating the timetable of the project, analyzing the risks, status report).The Databases and tools that I am using on the ETL Process are: SQL Server 2010 (SSIS), Oracle 10 G, TeraData 13, Visual Studio - C Sharp, SAS Guide 5.5.

Outras informações:
I´ve been working at São Paulo / SP from February of 2009 until june of 2015. My job is Professor of Science Computer Area at UNINOVE University. I work during the evenings teaching for the Information Systems and Computer Science bachelor courses in the following subjects: Graduation Courses: - Software Engineering (UML), - Management and SQL Language for Databases (SQL Server and Oracle), - Programming for Databases (PL/SQL), - Data Structures (C/C++), - Object Oriented Programming (Java JSE) Post-Graduation Courses: - Information Security (Penetration Tests using BackTracking on Linux VM) - Java JEE (JDBC, JSP, Servlet, Beans, Sessions) Professor Tutor on the Science Initiation Project: - Project: Information Security using Penetration Tests (Linux BackTracking)

Outras informações:
I´ve worked at São Paulo / SP, started at June of 2011 and finished at September of 2014. I started like a Developer Support on the IIS / ASP.net Technologies and after that I moved to the Azure technology. I started on the Azure CIE Team (Cloud Integration Team) I was working like Developer Support Engineer with Cloud Computing Technology. Passed more one year I moved to the WATS Team, (Azure Infrastructure Team) and I worked during more one year using troubleshooting techniques to solve issues at the level of the platform infrastructure Issues regarding the the VM IaaS and VM PaaS on the clusters of the Microsoft Azure Data Centers around the world. I was working with cases in the majority was North American and Europeans customers and rarely I worked with the Brazilian customers.

Outras informações:
I´ve worked at São Paulo / SP, started at August of 2009 and finished at June of 2011, my position was Software Engineer / Developer Support Engineer. I´ve worked preparing the machines of a new appliance configuring the IBM DB2 database, the AIX Operational System and Linux Suze OS. On the development part I worked with the product called ISAS BI System Appliance, developing process using C language and Pearl Script to integrate the software that was part of the software stack of the appliance to be running on the IBM AIX Workstations and Linux Blade Servers. I worked with the Storage System, monitoring the usage of the disks on the appliance. Checking the Network Fiber Channel Communication between the nodes of the machines. Another activity that I performed was support developer engineering level 3 engaged by the level 2 support, because was necessary to work on the cases there were some communication issues between the software stack of the BI Appliance. I worked on the development of the cubes and reports using the BI Tool called Cognos.

Outras informações:
I ´ve worked starting at August of 2008 until July of 2009 like System Analyst and Project Coordinator in Business Intelligence Projects, working for the company Sysvision International Brazil, with partnership of MicroStrategy Brazil. My job was make interviews with customers to build the requirements document, multi dimension modeling, SQL Programming of the ETL process (extraction, transformation and Load) with the software Integration Services of Database MS SQL Server 2005 and make scripts to the Oracle Database. For reports, I used MicroStrategy Plataform version 8.1.1 for administration and development Reports, Report Services: Dashboards, Dynamic Dashboards, MicroStrategy Office e NarrowCast. I used to build the modeling the software ERWIN 4.0. For the technical coordination of the project I used MS Project software.

Outras informações:
In this company my work has built of requirement´s document of the project with users, I´ve designed multi-dimensional models, programing SQL language to ETL (Extraction, Transformation and Load) using the software Integration Services to MS SQL Server 2005 Database and I did make some scripts to Oracle Database. I´ve worked with administration and development of Reports with Report Services: Dashboards, Dynamic Dashboards, MicroStrategy Office e NarrowCast in MicroStrategy Plataform version 8.1.1. The Databases used for the projects were MS SQL Server 2005 and Oracle 9i. I used to implement the modeling the ERWIN Software and to coordinate the activities I used the MS Project software.

Outras informações:
I´ve worked at São Paulo / SP, from February of 2008 until July of 2008, actuating like Professor of Science Computer Area on University FIAP. I did teach in the evening period for the Computer Science and Information System Course in the following subjects: Graduation Course: ? Database SQL (Oracle)

Outras informações:
I´ve worked at São Paulo / SP, from July of 2007 until January of 2008, actuating like Professor of Science Computer Area to private University Sumaré. I did teach in the evening period for the Computer Science and Information System Course in the following subjects: Graduation Course: ? Software Engineering (UML) ? Programming Laboratory VI (Java J2SE) ? Automata Languages and Compilers

Outras informações:
I´ve worked at São Paulo / SP like a System Analyst and Project Coordinator for the Business Intelligence Area. My work was make the requirements document with the users and build of the multidimensional models, programming in SQL Language of the ETL (Extraction, Transformation and Load) process, MetaData creation and report development with MicroStrategy version 8.0.2. The database that I used was MS SQL SERVER 2000 and Oracle 9i. I designed and programming one DataMart with C# (ASP .NET) technology using components to generate graphics and tables to the Internet Pages (Dundas).I used to make cubes, the Analysis Services of Database MS SQL Server 2005 and Integration Services to extract data. For the reports I used the Reporting Service. For the system´s modeling, I´ve used ER Studio. For the project coordination I used the software MS Project.

Outras informações:
I ´ve worked at São Paulo / SP, in the period of March of 2006 until August of 2006, my job was system analyst and project coordinator, make the requisites document for the development team Web .NET, development web site´s in the Microsoft .NET technology using Visual Basic .NET (ASP.NET) make the integration between the ERP with the software SFA (Sales Force Automation) (CRM) and B.I (Business Intelligence). My work was the creation of the requirements document, analysis, multi-dimensional modeling using the software Erwin for the SQL Server 2000 and Oracle 9i Databases. I executed some screen validations, navigation diagram. I´ve worked like Project Coordinator using PMI Methodology to control and uses schedules using the MS Project Software. I executed the programming of some parts of the software using the Visual Basic .NET (ASP NET) on the I.D.E. MS Visual Studio 2003.

Outras informações:
I´ve worked in São José do Rio Preto / SP and São Paulo / SP, in the period of February of 2005 until February of 2006 like Business Analyst / System and Project Coordinator for the RIOSOFT Company. I developed web site´s using the MicroSoft .NET technology using C# ASP .NET language to integrate the ERP Apolo with the web platform. I worked in another part of this Project, the build of the DataMart to generate reports. I created the DataMart Project with the goal to generate DataMart for the ERP. My job was to make the requisites document using UML analysis on the Borland Together Software, Data Modeling multi-dimensional models using Erwin software and SQL Server 2000 and Oracle 8i for the Databases. I executed some validations with customers, navigation diagram, measurement time and costs using the technique called Use Case Point. My work was do the coordination of the team using PMI Methodology and to make schedules I used the software MS Project. I developed using the C# ASP .NET on the IDE Visual Studio 2003.

Outras informações:
I´ve worked at São José do Rio Preto on NEC (Núcleo de Estudos de Computação) of UNORP. My work was make the requirement document , creation of models, and construction UML Diagrams, besides coordinator of development team . The products that was developed with team was divided into two modules, one operations and another module was Business Intelligence, to use university. The team was formed by 5 developers, because they needed stage to graduate in your courses. To extract data the DTS software of SQL Server 2000 The objective was a make decision reports. The language used to transational module was DELPHI and the DataBase was SQL Server 2000 and Oracle 8i.To models was used ERWIN software and UML visions was used Visio Software. To control projects, was used MS Project software.

Outras informações:
I´ve worked at São José do Rio Preto / SP, in the period of February of 2003 until February of 2006. My job was professor of science computer department. In the evening period, teaching classes to Information Systems and Science Computer courses on the following subjects:. - Graduation: . DataBases (SQL Server) . Software Engeering (UML) . Data Structure (C) . Concurrent Programming (C++) . Object Oriented Programming (Kylix, Java)

Outras informações:
I´ve worked at São José do Rio Preto / SP, in the period of July of 2001 until July of 2004 through BRQ Informática. My allocation was in company VERDADOS ? GRUPO VERDI (RODOBENS), in one team of 5 persons to work with Modelling and Analysis to Internet System using Structured Analysis and Object Oriented Programming with UML. Another software I worked was System Architect and programming language Java J2EE, JSP, JDBC, XML, Java Script, HTML e SQL of database IBM DB2 to develop new web sites and maintain others. Another task was create Data Marts to make decision reports. with database SQL Server and Oracle.

Outras informações:
I´ve worked at São José do Rio Preto / SP, in the period of January of 2001 until June of 2001. My job was network administration to Windows 2000 Server, installation, configuration of softwares and maintain the hardware.

Outras informações:
I´ve worked at São José do Rio Preto / SP, in the period of january of 2000 until december of 2000 through Virtual Flash Informática, that this company was mine., My Job was to sale equipments, maintain and instalation and configuration of networks . Another taks I had was make a web site in ASP technology with database Access.

Outras informações:
I´ve worked at São José do Rio Preto / SP, in period of July of 1999 until December of 1999 through to Instituto de Hematologia. My job was analysis, modeling and programming of systems using Delphi language with Data Base SQL Server 97.

Outras informações:
I´ve worked at São José do Rio Preto / SP, trough company Proansi informática in period January of 1999 until July of 1999. My job was analysis, modeling and programming systems using Delphi language and data base SQL Server 97.

Outras informações:
I´ve worked at São José do Rio Preto / SP, in period of july of 1994 until july of 2001. My job was computer instructor by Microcamp International, teaches some languages of programming and MicroSoft Office package.

Outras informações:
I´ve worked at São José do Rio Preto / SP, in period of January of 1994 until june of 1994. My job was trainee of computer area of INSS ? Instituto Nacional de Seguridade Social. My work was operations of benefits systems and maintenance of equipments.