Mauro M. Email & Phone Number

La Mirada, California, US

• Microsoft Synapse & Microsoft Fabric: Proficient in leveraging Microsoft's premier analytics services to streamline and enhance big data processing workflows.
• MSSQL to PySpark Framework: Created an innovative MSSQL2PySpark Migration framework using Large Language Models (LLM), Python, PySpark, Langchain, Ollama/Azure OpenAI to translate MS SQL queries into PySpark SQL.
• SSIS to PySpark Migration: Successfully migrated SSIS packages to PySpark, dramatically reducing query run times from over 10 minutes to a mere 25 seconds, thereby boosting performance and productivity.
• PySpark Pipeline Optimization: Dedicated to continuous improvement of PySpark pipelines, enhancing their reliability and performance through meticulous tuning and optimization.
• PySpark & ETL: Skilled in developing robust ETL pipelines using PySpark, ensuring seamless data integration and transformation using Azure Data Lake Storage Gen2 and OneLake to meet business needs.
• AI-Driven Development: Leveraging AI and LLM to minimize coding effort, I develop solutions that are not only efficient but also cutting-edge, keeping pace with the latest advancements in technology.

• Cloud Solutions: Design and implement scalable and reliable cloud solution environment technology.
• AWS Cognito: Implement AWS Cognito for main authentication.
• AWS EC2: Configure and manage Amazon EC2 instances.
• AWS Aurora MySQL: Implement and optimize Aurora MySQL.
• Docker: Containerize applications using Docker for efficient deployment and scalability.
• Jenkins: Utilize Jenkins for continuous integration and continuous delivery (CI/CD) pipelines.

San Francisco, California, US

• Terraform: Design, develop, and maintain infrastructure as code using Terraform, and deploy and manage AWS Aurora database instances, clusters, and related services using both Terraform and Terraform Cloud.
• Debezium: Configure and manage Debezium for real-time data integration and replication between databases.
• DataDog: Implement DataDog monitoring tools to monitor system performance, logs, and metrics for proactive issue resolution.
• GitHub: Manage and administer GitHub repositories, branches, and permissions for seamless collaboration.
• Jenkins: Configure and maintain Terraform infrastructure pipelines automation to ensure efficient deployment.
• AWS DMS: Utilize AWS Data Migration Service to migrate data with minimal downtime and ensure data integrity.

Los Angeles, CA, US

• Architecting, building and maintaining database hosted in AWS using MySQL Aurora
• Managing Aurora DB Cluster replication with cross region replication
• Developing, designing and implementing queries, stored procedures, triggers and indexes using best practices
• Designing scalable data model based on limited requirements
• Optimizing database performance and ensure data integrity
• Analyzing access and security with Cloudwatch

Burbank, CA, US

- Supporting MSSQL 2008/2012/2014/2016 including log shipping and Always On - Implemented/Managing Cloud solutions AWS (RDS Aurora/Cloudtrail/Cloudwatch/RedShift) and Azure SQL- Developed integration process and ETL using bash scripts- Created database migration process for MSSQL, MySQL, MongoDB databases to AWS Aurora MySQL.- Managing code deployment

- Performed MSSQL 2014 installation and configuration- configured MSSQL always on Availability and backup process - Developed integration process and ETL using SSIS packages- Created database migration process from MySQL 5.0.2 to MSSQL 2014.- Managed team of DBAs and developers with migration process and documentation

- Researching and Development of IoT/M2M Technologies- C++ application for embedded systems MPU/MCU- Analytical applications for embedded databases- Embedded IoT Hardware with custom sensors- Debian Linux customization for embedded systems- Ultra low power Bluetooth Nordic Semiconductor application development

- Designed and Managed Data Mart and Data Warehouse, BI and Data Mining with SQL and Sharepoint 2013- Developed MSSQL SSRS Reports, SSIS Packages, SSAS, and ETL Process using several third party data source.- Created Business Intelligent portal with Sharepoint 2013.- Implemented system integration with third party companies.- Developed Database integration.

New York, NY, US

- Research of new technologies and techniques for Disaster Recover, data replication, IT security and work on tuning to optimize operation and performance of the overall system for Chelsea Technologies clients. - Managed MSSQL database including mirroring, always on Availability and clustering.- Developed MSSQL mirror auto failover process to mitigate down.

Austin, Texas, US

- Implemented and managed Oracle Database, Oracle ERP, Oracle Portal and Oracle Interconnect for fortune 500 companies such as Alcan, Alcoa and Usiminas.- Performed Installation, configuration, management, maintenance, migration, patching, and cloning of Oracle E-Business Suite (ERP) 10.x, 11.x and 11i. - Created Oracle Backup/Recovery process with OEM and.

- Managed Solaris and Linux with DNS servers, web servers, and application servers.- Performed installation, configuration, and maintenance of Oracle 8 on UNIX and Windows servers.- Implemented application systems following Full Life Cycle Project- Performed implementation of applications servers: ColdFusion, JRun, Spectra and Web Logic. - Implemented.

- Implemented Oracle 8.0.at Windows NT 4 and Linux.- Managed NT, Lantastic, Novell and Red Hat Linux servers and network for small business.- Manage Unix SCO and dummy serial terminals and configured Cyclades 8y/8ye multi-serial card

Microsoft Machine Learning Openhack

Artificial Intelligence

Aws Solutions Architect

Master Of Information Systems Management, Data Administration & Business Intelligence

Industrial Design Engineering

Bachelor'S Degree - Technical Management With Oracle Specialization, Business Managment And Oracle Systems

The Microsoft Bi 2010 Boot Camp - 40 Hours Of Complete Microsoft Bi 2010 Stack Training

C# 2010 Boot Camp Training - 40 Hours Of Complete C# 2010 Programing

Associate In Business Administration, Managment

Oracle 10G - 12 Hours Of Training With Oracle 10G

Oracle 9I Rac - 18 Hours Of Complete Rac Training

C++ Boot Camp - 60 Hours Of Complete C++ Coding

Weblogic Administration 6.1, Weblogic Web Application

Asis – Advanced School Of Internet Security - 6 Months Of Intensive Security Systems Training

Fast Track To Coldfusion - Web Development

Unix Solaris 8 Boot Camp Training - 160 Hours Of Complete Solaris Unix Training

Introduction Of Oracle 7 And Software Developing With Procedural Options

Oracle 8 Boot Camp Training - 365 Hours Of Complete Oracle Training

Windows Nt 4

Novell Certified Novell Engineer (Cne) - Advanced