Masahiro Hiramatsu - Data Engineer, Freelance (Self employed)

Feedback from Masahiro’s ex-colleagues

Let me see

Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app

Work Background

Carrefour Varejo - BrasilEngenheiro de dados - operação, suporte projetos big data

Nov. 2020São Paulo, São Paulo, Brasil• Support and maintenance of Bigdata operations in a GCP cloud environmentmonitoring and supporting data ingestion pipelines; implementing monitors/ downtimes in Datadog • Troubleshooting in daily issues in data ingestion pipelines across GCP services - BigQuery, BigTable, Composer Airflow DAGs, PubSub, Dataflow jobs, Datafusion & Dataproc jobs, Cloud Run/Function; data movements across Cloud Storage (Shell scripting); enrichment of team’s troubleshoot Knowledge Base. • Conduct assessment of requirements prior to deploys in prod (change analysis, tech doc, sched and assignment • Provide swift response to Jira tickets, addressing incidents and service requests related to data ingestion. • Create and update documentation for data ingestion pipelines and support procedures.

Keyrussystem analyst - big data infrastructure

Jul. 2017 - Nov. 2020Brasil• Sodexo (Client, 2019 - 2020): Monitored data ingestion and cluster health (Cloudera 5.10), automated reports, performed housekeeping tasks. • Carrefour (Client, 2017, 2019 Oct-Nov): Installed Hortonworks cluster remotely, participated in cloud migration project, tested, and reviewed scripts. • Ambev (Client, 2018-2019): Assisted in HDInsight environment handover, supported Hadoop clusters, led process migrations.

ConsultantIT Consultant / Salesforce Administrator

Feb. 2017 - May. 2017Sao Paulo, BrazilConsulting services in IT services/projects - infraestructure, DB/BI development & lifecycle, system integration/intefaces, IT governance support (ITIL, project management) - implementations of enhancement and new business rules in Salesforce.com Sales Cloud for Construction business (HTB by K2 Partnering, 2017, March-April): configurations of objects and layouts, customization through APEX programming for specific needs.

FreelancerIT consultant

Dec. 2014 - Jan. 2017São Paulo e Região, BrasilIT consultancy - in MS SQL Server (infrastructure, configuration, T-SQL scripting/teaching), small local network config.

RocheIT Specialist | BI Analyst SAP BW/BO

Mar. 2012 - Oct. 2014Brazilsupport services - daily operations, incident reported by users in SAP BW, HP Service Manager, enhancements in SAP BO/Web-I reports/dashboards, data integration (MS Sharepoint, codepage conversion and upload from Windows to filesystem HP UX through sFTP for dataload in SAP BW cubes ). Training on SAP BI Web-I resources and features issued in Buenos Aires, Argentina, to LatAm key users. Review of training content "SAP R/3 end user incident support process" and conversion into elearning TT Knowledge Force platform for 1st level service desk team across region - content translation and voicing in Spanish, English and Portuguese.

RocheSupport Analyst, IT Serv Mgmt, Solution lifecycle, Operations

Aug. 2008 - Mar. 2012São Paulo and Region, BrasilJob description: - design solution infrastructure blueprint with vendor/provider - carry out planning, scheduling, team formation, activity assignment, coordinate execution for local/regional/global projects - single point of contact for platforms and further application under Commercial Operation support umbrella - respond for their SLA, service quality. - carry out change processes and incident support according to ITIL processes in place - local contact to external service providers for Commercial Operation platform - for new service contracting, amendments, renewal, ending. - planejamento e negociação de migração com donos de aplicações e plataformas a serem ou já obsoletas/fora de suporte. - hands-on support activities as Siebel Admin role, also DBA SQL Server, Windows System Admin to tackle deployment of components set to deploy new Siebel services and support their operations. - networking with local/regional/global peers and colleagues to tackle support, projects and further assignments. - provide support in ITIL processes to peers and contractors. - support for EDI solutions - IBM Sterling (regional), Tivit (domestic)

RocheSupport Analyst/Siebel Admin/DBA SQL Server/Windows Sys Admin

Aug. 2005 - Aug. 2008Sao Paulo, Brazil- invited to join Application support analyst team (hand over done to new comers). Job responsabilities: - support for Siebel ePharma 7.5 components and assignments as Siebel Admin : incident support, process documentation, Incident/Change management, massive database extractions per country (1500 reps total in Latam) - conduction of stress test with Mercury Loadrunner to document baseline for performance of current Siebel installations: setup of agents across countries with Siebel users, scenario scripting and execution, documentation of results. - housekeeping: took part in implementing automation of Siebel ZeroDowntime SRF swap and component monitoring through scripting with DOS and GAwk.

RocheAnalista de Suporte - Windows Intel

Aug. 2001 - Sep. 2005Sao Paulo, BrazilAs support analyst: - implementing layers segregating DEV, QA and production, for web apps in Intranet, Extranet and Internet: installing Windows Intel servers, enabling IIS component, priv/pub keys in some of web sites (Thawte certifier), collocation of web and database server in datacenter managed by external provider); enforce change management of web apps released in production. - influence on developers (internal and external consultants) to adhere and support change management process. - back to role of DBA SQL Server: migration of bare metal servers, Windows version upgrades, reception of external hardware support specialists for maintenances and incidents, participation in storage SCSI recovery (had 2 spare disks, both failed, delta of the day had been lost), FS migration from SCSI storage to EMC. - took part in some regional projects : Datacenter consolidation to Sao Paulo: app knowledge and doc transfer, inventory and relocation to Sao Paulo ); Upgrading Exchange Servers in Chile, implementing SMS Servers in LatAm for cascading antivirus signatures to internal servers across region. - took part on initiative to launch ITIL processes across LatAm region as Configuration Item Champion, coordinated inventory and checking of configuration items, known services, registry of relations among CIs in HP Service Desk. - install of HP Intel servers and Windows Server (standalone, cluster) for installation of platforms , e.g. Siebel ePharma, MS SQL Servers, MS Sharepoint. - qualification of every installation (installation tests according to defined standard processes); after results approved, set to be in backup routine, its registries in CMDB were activated, documentation kept by server name. - joint periodic review of processes in changes and incidents (HP Service Desk)

RocheAnalista de Informação

Jun. 2000 - Aug. 2001São Paulo e Região, BrasilHired to clear backlog of managerial reports and data extraction requests. learning of how to integrate MS Office and SQL Server, to enhance quality of reports. clean up of multiple (with typo) registries of addresses - learning of activities and time estimation to achieve goal - selection of temporary analysts, to train and lead them through cleaning process. Goal achieved in 2.5 month (estimated in 3.5), registry recovery rate achieved was 93% (200K cleaned addresses). Creation of control by postal code (CEP) to organize division of work. As their leader i could exercise my role as server leader, anticipating needs and obstables ahead and helping analysts providing instructions, making bets to motivate the team ('I will step samba if you achieve results before day X'; and I had to do it ;) ).

Atica Shopping / FNACAnalista de Sistemas / DBA SQL Server

Jul. 1996 - Mar. 2000São Paulo e Região, BrasilHired to make happen integration among distinct systems - bookstore managing system (Wordstock, QNX), brazilian ERP (Microsiga, nowadays Totvs). Later on, one more to be integrated: Point of Sale Itautec ACT. I had to interact with specialist from provider of each system (mostly with ERP consultant, which I learned a lot with) to be able to design and implement needed interfaces among these systems and also modelling and programming in T-SQL the calculation of daily balance for goods, per branch (store, warehouse). I had to understand and learn how business runs and which were the critical data. I implemented idea of my boss - balance calculation by aggregating rows representing an operation. Due to disk I/O involved, duration of routine were lengthy (4 to 6 hours, sometimes 8 to 9h). Researching ways to speed up the process, I came across with some literature about Pivoting and Folding, to make calculations in columns and in memory ). it was a satisfaction to reach result lowering duration to 20 to 30 minutes. I learned the role of DBA in this job - database modeling, and related subjects (e.g. networking in TCP/IP with Windows NT, NTFS security), server backups . I took requests of managerial reports and data extractions from management - product, finance/fiscal. When time permitted, I used to research ways to improve/innovate current processes setting and executing proofs of concept - e.g.: data replication between servers, OLAP databases and reports.