marcelo bianchi super logo.png

Consulting Services 

contatoprofissional.jpg

PROFESSIONAL EXPERIENCIES

Scriptoria Communcations               (INTERNATIONAL EXPERIENCE)

Data Scientist / Data Engineer

London - England - UK

06/2018 - 05/2020


I have been working in London United Kingdom at Scriptoria Communications since June of 2018 until nowadays like a Data Scientist working with Machine Learning (Regression, Classification, Clustering) using Machine Learning algorithms and Deep Learning. I have created classification systems for some Agricultural Datasets (Plants Diseases) for the Africa Projects.

Technologies for Data Science Projects:
Regression, Classification and Clustering Systems.
- Machine Learning Models (Python Libraries: Numpy/ Pandas/ Sci-kit Learn)
- Deep Learning Models (Python Librarires: TensorFlow/ PyTorch/ Keras)

Another part of my work is related with Business Intelligence Projects, dealing with the entire process (Analysis, Modeling, Development (including ETL), Tests and Deployment. In some projects is necessary to use NoSQL DB then I used ElasticSearch.

Technologies for Big Data Projects:
- ElasticSearch Stack (LogStash,ElasticSearch, Kibana)

Technologies for Analytics Projects:
- ETL Tool: SSIS (SSIS Integration Services) / SSAS (Cubes)
- Databases: SQL Server / SQL Azure
- BI Data Visualization Tool: Power BI
- Cloud Computing: Windows Azure
- Project Management: MS Project / Kanban
- Methodologies: Scrum / Waterfall

__________________________________________________________________________________________________________________________________________________

Sysprice Consultoria e Sistemas

Data Scientist / Data Engineer

Sao Paulo - SP - Brazil

12/2016 - 01/2018

 

Customer: McDonalds Brazil

 

I´ve worked like Data Scientist on the YKP Company for the customer Arcos Dourados (Mcdonalds) in São Paulo Brazil.

My work was related with Data Science (Regression, Classification, Clustering) using Machine Learning algorithms and Deep Learning. I created predictions system for the use of the Stock of Products in the Stores.

 

Technologies for Data Science Projects:
Regression, Classification and Clustering systems.
-    Machine Learning Models (Python Libraries:  Numpy/ Pandas/ Sci-kit Learn)
-    Deep Learning Models (Python Librarires: TensorFlow/ PyTorch/ Keras) 

 

Another part of my work was related with Business Intelligence Projects, dealing with the entire process (Analysis, Modeling, Development (including ETL), Tests and Deployment. 

 

Business Intelligence Projects:  
      - ETL Tool: Pentaho Data Integrator
      - Databases: SQL Server / Oracle / PostGree SQL
      - BI Data Visualization Tool: MicroStrategy
      - Project Management: MS Project / Kanban
      - Methodologies: Scrum / Waterfall

__________________________________________________________________________________________________________________________________________________

CET Labs

Data Scientist  / Data Engineer

Sao Paulo - SP - Brazil

12/2015 - 11/2016

 

Creation of the Product: CET Analytics BI

 

I´ve worked like a Data Scientist for CET Labs Company in São Paulo Brazil and my work was related with Data Science (Regression, Classification, Clustering) using Machine Learning algorithms and Deep Learning. I have created clustering system to classify the customers of a ERP database, according with the Spending in the Store.

 

Technologies for the Data Science Projects: 
Regression, Classification and Clustering Systems. 
- Machine Learning Models (Python Libraries: Numpy/ Pandas/ Sci-kit Learn)
- Deep Learning Models (Python Librarires: TensorFlow/ PyTorch/ Keras)

 

About the Business Intelligence Projects, I developed a product that was a BI Solution based in Cloud Computing. I actuated with BI Architecture of the Product using Microsoft Cloud Computing Azure to host the solution and provide security. For the development process I´ve worked using MicroStrategy OLAP tool, specifically to build the cubes and Dashboard and and the name of the product is CET BI Analytics.

 

I´ve used MicroStrategy Technology embedded in a web site in PHP using the Web Server Apache Tomcat and the communication between the client and the Cloud BI Solution was through a VPN. The Data Modeling Tool that I´ve used was TOAD Modeler and the Architectural Diagrams were made using MicroSoft Visio, specifically for the UML modeling I used Argo UML tool.

 

Technologies for the Business Intelligence Projects:
- ETL Tool: Pentaho Data Integrator
- Databases: SQL Server / Oracle / PostGree SQL
- BI Data Visualization Tool: MicroStrategy
- Project Management: MS Project / Kanban
- Methodologies: Scrum / Waterfall

__________________________________________________________________________________________________________________________________________________

TQI Consultoria

Data Engineer

Sao Paulo - SP - Brazil

12/2014 - 11/2015

 

Customers: NEXTEL TELECOMMUNICATIONS 

 

Business Intelligence: 

I ´ve worked in São Paulo Brazil, started my activities since November of 2014 until November of 2015 for the customer Nextel Telecomunications. I´ve worked like Sr Data Engineer using Multidimensional Modelling, creating new data marts from different sources of data and for the ETL Process (Extranction , Transformation and Load) was used Microsoft Integration Services. For the OLAP process was used Oracle and to build the reports was used the Microstrategy. I ´ve worked also with project management (updating the timetable of the project, analyzing the risks, status report).The Databases and tools that I used on the ETL Process were:  SQL Server 2010 (SSIS), Oracle 10 G, TeraData 13.  

 

Big Data: 

- Hadoop 

- HBase

__________________________________________________________________________________________________________________________________________________

Microsoft Brazil

Sr. Software / Dev Support Cloud Computing Engineer (Azure Cloud Computing)

Sao Paulo - SP - Brazil

06/2011 - 11/2014

 

Product: Microsoft AZURE/ SQL AZURE (Cloud Computing Development and Hosting)

 

Activities Descriptions:
I´ve worked at São Paulo Brazil, I´ve started like a Developer Support Engineer on SQL Server Database Technologies including SSIS, SSRS and SSAS. After some time I´ve moved to the SQL Azure Database Technology. I´ve used troubleshooting techniques to solve customer´s issues at the level of the development solutions regarding the VM IaaS and VM PaaS using the SQL Azure Databases on the clusters of the Microsoft Azure Data Centers around the world. I´ve worked with support cases for North American, Europeans and Brazilians customers.

__________________________________________________________________________________________________________________________________________________

IBM Brazil

Sr. Software / Dev Support Data Base Engineer (Cluster IBM DB2)

Sao Paulo - SP - Brazil

06/2009 - 06/2011

 

Product: IBM ISAS BI APPLIANCE (Business Intelligence Appliance)

 

Activities Descriptions:
I´ve worked at São Paulo Brazil, my position was Software Engineer / Data Base Engineer. My position was related to prepare the machines of the cluster for the BI appliance called ISAS and was necessary to create some configurations to IBM DB2 that will allow to be prepared to work automatically to the software of the cluster running on the AIX Operational System or Linux Suze OS.  Another responsibility that I had was to developing Batch scripts using Pearl running over the AIX on the IBM Workstations and Linux Blade Servers, the software was monitoring the Storage System and the usage of the disks of the appliance. It was necessary to check the Network Fiber Channel Communication between the nodes of the machines and I was performed like a support developer engineer level 3 engaged to help the support engineer on the support cases on customer´s critical performance issue using IBM DB2 data base. I used Cognos to make some analyze the monitoring data that we´ve collected during the performance problems.

__________________________________________________________________________________________________________________________________________________

SysVision International Brazil

Sr. BI Engineer / Team Leader

Sao Paulo - SP - Brazil

08/2008 - 07/2009

 

Customer: ITAÚ BANK

 

Activities Description:
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.

__________________________________________________________________________________________________________________________________________________

Close Up International Brazil

Sr. BI Engineer / Team Leader

Sao Paulo - SP - Brazil

08/2007 - 08/2008

 

Customer: ELI LILLY BRAZIL LABORATORY

 

Activities Description:
I´ve worked in São Paulo Brazil like a Data Engineer and my work was related to build requirement´s document of the project making a design of the multi-dimensional models, programing SQL language to ETL (Extraction, Transformation and Load) using Integration Services on MS SQL Server 2005 Database and I did make some scripts to load data on the Oracle Database. I´ve worked with administration and development of Dashboards and Reports using MicroStrategy. The Databases that it was used on the project were SQL Server 2005 and Oracle 9i and for the data modeling ERWIN, to administration of the project was used MS Project Software to update the timetable. 

__________________________________________________________________________________________________________________________________________________

7 COMM

Sr. BI Engineer / Team Leader

Sao Paulo - SP - Brazil

08/2006 - 08/2007

 

Customer: ASTRAZENICA BRAZIL LABORATORY

 

I´ve worked at São Paulo Brazil like a Data Engineer and Project Coordinator for the Business Intelligence Area. My work was related to the build the requirement´s document, create the   multidimensional models, programming in SQL Language using ETL (Extraction, Transformation and Load) process, MetaData creation and report development using  MicroStrategy. The database that I used was MS SQL SERVER and Oracle. For the cube module, I´ve programmed a DataMart using C# (ASP .NET) technology with components to generate graphics and tables to the Internet Pages (Dundas). The cubes were created using the Analysis Services and was used the Integration Services to extract data. For the dashboards and reports I used the Reporting Services. For the system´s modeling, I´ve used ER Studio. For the project coordination,  I´ve used the software MS Project.

__________________________________________________________________________________________________________________________________________________

W IT Solutions

Sr. Web Site Engineer /  Project Coordinator  

Sao Paulo - SP - Brazil

03/2006 - 08/2006

 

Customer: NOVARTIS BRAZIL LABORATORY

 

Activities Description:
I ´ve worked at São Paulo Brazil, on the period of March of 2006 until August of 2006, I actuated like system analyst for web sites, create the requisite´s document for the development team Web .NET, development web site´s in the Microsoft .NET technology using Visual Basic .NET (ASP.NET), doing 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 Tech Lead 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.

__________________________________________________________________________________________________________________________________________________

RioSoft

Sr. Web Sites Engineer /  Project Coordinator 

Sao Jose do Rio Preto - SP - Brazil

02/2005 - 02/2006

 

Customer: ABIMAQ - ASSOCIAÇÃO BRASILEIRA DA INDUSTRIA DE MÁQUINAS

 

Activities Description:
I´ve worked in São Paulo Brazil, in the period of February of 2005 until February of 2006 like System Analyst 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 and Oracle 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 the timetables I used the software MS Project. I developed using the C# ASP .NET on the IDE Visual Studio 2003. 

__________________________________________________________________________________________________________________________________________________

NEC UNORP 

System Analyst / Web Sites Programmer

Sao Jose do Rio Preto - SP - Brazil

08/2004 - 01/2005

 

Customer: UNORP University.

 

Activities Description:
I´ve worked at São José do Rio Preto SP Brazil on  NEC (Nucleo de Estudos de Computacao) UNORP. My work was related the with the build of the requirement´s document, creation of database models and design of the 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. 

__________________________________________________________________________________________________________________________________________________

BRQ Informatica

System Analyst / Web Sites Programmer

Sao Jose do Rio Preto - SP - Brazil

07/2001 - 07/2004

 

Customer: GRUPO VERDI - RODOBENS

 

Activities Description:
I´ve  worked at São José do Rio Preto / SP Brazil, in the period of July of 2001 until July of 2004 through BRQ Informática. The customer that I´ve worked was a company called  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 report susing database SQL Server and Oracle.

__________________________________________________________________________________________________________________________________________________

SDG Projetos de Engenharia Civil

Support Analyst

Sao Jose do Rio Preto - SP - Brazil

01/2001 - 06/2001

 

Customer: GRUPO VERDI - RODOBENS

 

Customer: ICEC ENGENHARIA

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

__________________________________________________________________________________________________________________________________________________

Virtual Flash Informatica

System Analyst / Web Sites Programmer and Owner

Sao Jose do Rio Preto - SP - Brazil

01/2000 - 12/2000

 

Customer: GRUPO VERDI - RODOBENS

 

Activities Description:
I´ve worked at São José do Rio Preto / SP, Brazil,  in the period of January of 2000 until December of 2000 through Virtual Flash Informática, that this company was my own. My Job was to sale computers, maintain and do the installation and configuration of network. Another task I had was make a web site in ASP technology with database Access. 

__________________________________________________________________________________________________________________________________________________

Proansi informatica

System Analyst / Client Server Programmer

Sao Jose do Rio Preto - SP - Brazil

01/1999 - 06/1999

 

Customert: INDUSTRIAS VILA RICA

 

Activities Description: 
I´ve worked at São José do Rio Preto / SP, Brazil,  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.

__________________________________________________________________________________________________________________________________________________

INSS (instituto Nacional de Seguridade Social)

Trainee of Information Technology

Sao Jose do Rio Preto - SP - Brazil

01/1994 - 06/1994

 

Activities Description: 
I´ve worked at São José do Rio Preto / SP, Brazil,  in period of January of 1994 until June of 1994. My job was a trainee of computer area of INSS – Instituto Nacional de Seguridade Social. My work was operations of benefits systems and maintenance of computers.

__________________________________________________________________________________________________________________________________________________