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, allowing for fast migration, smoother transitions and improved efficiency.• 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.• ChatGPT Custom Portal Development: Implemented a custom ChatGPT portal using SharePoint documentation and added a backend database to keep history for future analysis, enhancing user interaction and access to information.

▪ 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• Maintaining backups using automated and manual snapshots using Lambda and Python + mysqldump• Building robust Power BI reports and dashboards to provide insights into business• Developing and managed Lambda python scripts to dynamically generating Rich Excel reports with Charts.• R & D and evaluate new tools and technologies to support growing business needs• R & D Assist in designing and implementing the next generation data platform

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 systems Tools using C Sharp Language with third party APIs - Implemented and maintained data integration with MySQL, Microsoft SQL Server and cubes. - Managed data migration project from several types of data sources and legacy systems to MSSQL server. - Created Web Portal for career services replacing legacy systems using ColdFusion language- Managed backup and restore process for several terabytes of MSSQL databases and Cube data.- Installed and maintained MSSQL versions 2008, 2008R2 and 2012.- Managed 10+ SQL servers including production, QA, development and test servers.

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 time of applications. - Created MSSQL database backup and restore process utilizing different solutions and vendors.- Developed and implemented Data warehouse for Business Intelligence reporting using Microsoft products.- Performed Database Disaster recover setup solutions for Oracle using DBVisit- Created MySQL replication using Master Slave Replication- Setup MSSQL mirroring and AlwaysOn Availability Groups.- Developed MSSQL Reports, SSIS package, C# Tools, ETL Process and SharePoint BI reports with MDX query - Managed Linux/Unix and developed bash scripts for backups and monitoring systems. - Developed Web Portal utilizing Oracle Application Express.- Developed Database Monitoring systems and Database Tools using C Sharp Language- Implemented and Maintained SharePoint Server 3.0/2007/2010/2013 with data replication - Performed Installation, configuration, and maintained VMware ESX virtualization infrastructure.

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 Unix bash Scripts.- Implemented Oracle database replication using Oracle “stand by” for standard version and Oracle Data guard or Oracle Streams for Enterprise Version.- Implemented Solaris Unix SHELL Scripts and OEM Scripts to monitor Oracle environments which created Real-Time reports based on Oracle Portal.

- 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 security implementation on web servers and applications serves following NSA security guides

- 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