Carlos Marzinotto

The BARE Analytical Project at Bradesco Seguros, developed by Wipro, aimed to create a robust data pipeline using Databricks and Azure Data Factory, structured into three layers (Bronze, Silver, and Gold) to optimize the ingestion, transformation, and delivery of fact and dimension tables for analytical purposes CONDOMINIO, EQUIPAMENTOS anda EMPRESARIAL facts view. Key Respibilities: Ingestion Layer Extracted raw data from multiple sources, including relational databasesL, APIs, and flat files.Stored raw data in Delta Lake to ensure reliability and scalability. Transformation Layer (Silver): Developed ETL/ELT processes in Databricks to clean, normalize, and enrich data.Created intermediate models to prepare data for advanced analytics.SQL and Python Delivery Layer (Gold): Structured data into fact and dimension tables, optimizing it for analytical consumption. Integrated with BI tools and reporting systems to enable strategic data insights. Databricks: Managed distributed processing, data transformation, and modeling. Delta Lake: Implemented for versioned, ACID-compliant storage. Key Achievements: Improved data analysis efficiency for Bradesco Seguros .Standardized data governance and pipeline management. Reduced operational costs while enhancing report performance. Used Power BI. Tools: Arure Databricks and Snowflake Azure Data Factory: Orchestrated data ingestion and transformation pipelines.ETL / ELT Datamodeling Dataarchitect, Datawarehouse, SQL, DB2. Scrum meeting, Jira,

Magna Sistemas (Acquired by AlmavivA) Agricultural Defense Project – GCP Dataproc, Dataflow, Looker and Data Architecture and modeling Agricultural Economics Institute Project - GCP Dataproc, Dataflow, LookerML and Data Architecture Remedio em Casa Project – Postgre – GCP Looker and Data Architecture and modeling Porto São Sebastiao Customs Project – Architecture and Data Modeling integrated with Power BI Agricultural Projects: Definition of AS-IS and TO-BE, in the Agricultural Secretariat of SP Government establish the premises for IT, as well as conducting meetings with Government agronomists for detailed survey of the requirements of the Animal Health and Plant Health fronts, ensuring alignment with government guidelines. Reduction of millions of dollars with optimization of IT processes. Tools: Projects on GCP Google Cloud Platform (GCP) and practice in migrating local ETLs to using native cloud tools BIG query, Cloud Data Proc, DataFlow, Google Cloud Storage, Composer, Airflow Bucket or Datalake storage, directing from legacy Bases to ETL1 or dimensional and relational ELT, for consumption in DataViz Developing data marts and storage projects using multi-base distribution SQL, Hive SQL, Python (Numpy and Pyspark to handle increasing data volume and pipelines Practice in scripting and building data pipelines on Unix/Linux systems. Developing SSIS and DataStage packages to extract, transform and load data (ETL) into data warehouses/data marts from heterogeneous sources. Use Python to import and export data from RDBMS. Manager teams with agile tools.

Data Analyst Consultant, manager and developer CUBES Financial for the Alcohol Usines, environment SAP HANA integration Amazon Web Services - datamarts architecture AWS (EC2, S3, Airflow, QuickSigth OLAP, Github CI) Definition of the architecture of Data Mart projects for control and maintenance of plants, financial, development of SSAS DM Tabular Cubes, Dashboards in Power BI, SSAS, SSRS, and Azure Synapse Analytics, Pipeline, using Databricks, Spark , Pyspark and Python. Cloud, ETL SSIS. Identified markets for future product development and methods to improve existing product sales by analyzing BAU technology trends to support actionable recommendations to stakeholders.

Activities: Performance on BI projects and architecture fronts in the various business drivers of BNB. Project management and development Credit Portfolio, Corporate University, Agribusiness Indicators, migration of Cognos 10 platform to Analytics 11, development of Cubes and Dashboards, with effective implementation. Defined the premises, architecture as well as the rules for handling information in IBM Cognos and ETL Datamanager environments with users and managers. Used business strategic tools, and identify deliveries in current operational terms.

Developer Cognos Suite 10 and TM1

Manager and consultant strategic projects in the Cognos and TM1 environment. Defining and redefining all policies, rules and premises of pricing negotiations, taxes, discounts and formation of final prices for 'SELL OUT' on the Cognos 10.x and TM1 platform, Activities: - ROITEC Project, Specific project to calculate all investments in innovations for each layer of finished products of Boticário, developed by R & D (Research and Development) in order to measure the financial return in the last 3 years. Countless meetings from concepts to integration flow as well as the definition of IBM Cognos TM1 analysis and the provision of financial metrics for BSC. Project developed corporately with the participation of all the manufacturing and financial areas to define a BBP, which I accomplished. Activities: Surveys, Meetings, validation of rules as well as architecture, carried out proofs of concept, integration with teams multi technical, HANA BW, developed case-of-use, Developed BBP (Business Blue Print) material for alignment and approval. Programming and development in Architect and Turbo Integrator with procedural programming. Articulated follow-up with multi-technical teams, managers and directors.

Manager and consultant BusIness Intelligence - Cooperation BI for UNESCO (Brazil area) Development BI systems in Brazil government (certificated) Areas : SME - Secretaria Municipal de Educação de São Jose dos Campos - Project IDEB Brasil, used IBM Cognos and MS Power BI.

Consultant and Developer in tactical and strategic areas Trade (Import and Export) Risk Management IFRS Treasury Civil Claim Leader team and management for business and development models based on requirements generated Cognos Reports and Transformer Cubes 8.x and TM1 for tactical and strategic areas, analysis for management and executive dashboards Cognos ReportStudio, Framework and SAS

Consultant / Developer and Business Analyst role, modeler, perform models and cubes with MS-AS, road-map and formulate KPI, Data Mart Logistics, developer rule to Integration Services (DTS) and Front-End (MS-AS) Areas : Supply chain DM

Business Intelligent (BI) Manager and Consultant, Architect for an On-line Retail Company. The role of BI Architect was a mix of Business Analyst and Data Modeler, and OLAP queries e ETL developer. The Business Analyst role required gathering of business functions through interviews with key personnel. These functions were then captured in the Functional Requirements Document. As the Data Modeler, the interview information was used to create several subject areas for the sales reporting data warehouse in ERwin. Datastage Developed specifications to aply to dimensional DW for several areas Performed and managed OLAP queries and Maps of ETL Tools Used – IBM-Datastage IBM-ESB OLAP-Cognos e Hyperion Erwin Modeling Bases DB2,Teradata e Oracle