Stefano Moro
Senior Data Warehouse Architect @Kubota Tractor Corporation
Signup · Get unlimited contacts
WORK HISTORY
Senior Data Warehouse Architect @Kubota Tractor Corporation
Grapevine, TX, US
Working with Kubota Credit Corporation (KCC) – the financial arm of Kubota Tractor Corporation – designed and deployed from the group up a departmental data warehouse with the goals of o Consolidating data from multiple upstream operational systems / vendors.o Allowing legacy reports to be migrated from Excel/Oracle BI Publisher to Microsoft Power BI.o Deploying new reports, new dashboards, and a self-service data analytics layer.• The tech stack used Azure SQL as the target system. ELT flows were orchestrated via an Azure VM server and implemented using Windows Shell scripts and Transact-SQL stored procedures. Interfacing with upstream sources was achieved invoking sqlcmd (SQL Server), SQL*Plus (Oracle), db2sql (DB2) and mongoexport (MongoDB) sessions from the spooling/loading batches, along with embedding VBS scripts and GNU Sed commands for advanced preprocessing of incoming Excel, JSON, and CSV (pipe-delimited) files. A migration to Azure Data Factory for part of the ETL pipelines is currently under evaluation.• Core responsibilities included logical and physical data modeling, scripts and store procedures development, query optimization and database tuning, SQL conversion (e.g. Oracle/DB2 to Azure SQL and vice versa), data and business analysis, mentoring client’s analysts/developers, support and troubleshooting of daily/monthly production pipelines, maintaining code and database documentation.• The project was managed via Agile sprint sessions and JIRA + ServiceNow tickets; architectural/modeling deliverables included schema-level Data Flow Diagrams and Data Models, Data Architecture Diagrams, Data Refresh Schedule Diagrams, Security Framework Diagram, and other subject-area-specific material. The project documentation was maintained in Confluence.• Onboarded data flows: Oracle Financial Services Loans & Leases (OFSLL), Automated Credit Decisioning (ACD), Kubota Tractor Acceptance Corporation (KTAC), Genesys Call Center, and others.
EDUCATION
CQF Institute
Certificate In Quantitative Finance (CQF), Quantitative Finance
MIT Sloan School of Management
Certificate (MIT Executive Education), MIT Sloan Blockchain Technologies: Business Innovation and Application
CUOA Business School
Postgraduate Certificate, Systems Analysis For Business Information Management
Università degli Studi di Padova
Laurea in Ingegneria Informatica (Master of Science in Computer Science), Computer Science Engineering - Robotics and Automated Systems
Naveen Jindal School of Management, UT Dallas
Master, Business Administration
MIT Sloan School of Management
Certificate (MIT Executive Education), MIT Artificial Intelligence: Implications for Business Strategy.
ABOUT STEFANO MORO
Stefano Moro is the founder and owner of Effective Data Designs, LLC – a Dallas-based consultancy specialized in Data Warehouse Architecture, Data Engineering, Cloud-based Database Solutions, Data Migrations, and Data Flow Optimization; he has 20+ years of IT experience, mostly accrued in the areas of data warehousing, data modeling, data governance, ETL, business intelligence, data visualization, and data-centric software development.Stefano holds a Master of Science Degree in Computer Science (MSCS), a Master of Business Administration (MBA), a Postgraduate Certificate in Systems Analysis for Business Information Management, and a highly sought-after Certificate in Quantitative Finance (CQF); he is an AWS Certified Solutions Architect - Associate, an Oracle DBA Certified Professional (OCP) on Oracle 9i and 10g, a Microsoft Certified Professional (MCP) on SQL Server 7 Data Warehouses, a Microsoft Certified Database Administrator (MCDBA) on SQL Server an IBM Certified Database Administrator (DB2DBA) on DB2 UDB V8.1 on Linux, UNIX and Windows, and a Sybase ASE 12.5 Certified SQL Developer. He has also completed in-depth training courses on big data solutions (HP Vertica, Redshift), time-series databases (kdb+/q), Dimensional Modeling, Blockchain, and Artificial Intelligence (AI).Stefano\'s work experience and academic curriculum make him the ideal candidate for a role that requires strong analytical skills, mathematical acumen, and a deep understanding of both Database and Cloud Architecture. In fact, besides having a solid education in both Computer Science and Business Administration, he is arguably one of very few professionals certified by all of the four major database vendors (IBM, Oracle, Microsoft, and Sybase) and by the lead Cloud provider (Amazon Web Services). Such a unique background, along with outstanding analytical and project management skills, would make Stefano particularly effective in a consulting role as a Data Warehouse Architect or Data Engineer, or as a hands-on Data/Cloud Migration Lead supporting an organization facing complex data-related problems arising in cross-functional projects (data warehouse design & deployment, performance tuning, data pipelines/ETL design, historical data migrations, design and development of cloud-based or hybrid database systems). An exceptional problem-solver, a dedicated professional with a passion for business, databases, and mathematics, Stefano can always be reached at S••••••••@EffectiveDataDesigns.com
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.