My name is Mauricio and welcome to my Github Page. The purpose of this space is to introduce myself and highlight current/past projects.
Work History...
Currently working with...
- 🖥️ 📅 🗄️ MS SQL for database management: sales, customer transactions, location data and market segmentation
- 📈 📍 👨👩👧👦 Power BI for data visualization: sales, customer transactions, and location data
- 🐼 🌟 🔍 Python and libraries for data cleaning and manipulation
- 🗺️ 🎯 🏘️ Leaflet, ArcMap Pro, Google Earth, and Kepler for mapping
- 🌐 🌎 🧿 ESRI ArcMap Pro for Geospatial Analysis and Data Science: Data Engineering, Visualization, Prediction, Object Detection, Pattern Detection over Space and Time, and Site Suitability
Currently working on...
- How-to-guides for Python libraries: Pandas, GeoPandas, PySpark, and ArcPy
- How-to-guides for ETL and data engineering tasks: Data wrangling, data cleaning, batching, and related data prep
- Continued Learning and Certification: MS Data Analyst, IIBA Data Analyst, IIBA BI Analyst, ESRI Academy, LinkedIn Learning, Alteryx and other online-resources
- Collecting and revisting past projects using updated data and software tools
- Winnie's Hotel and Theo's Restaurant
Interesting...
- FRED: https://fred.stlouisfed.org/
- ALPHA VANTAGE: https://www.alphavantage.co/
- Ventusky: https://www.ventusky.com/?p=40.6;-85.2;4&l=rain-3h
- Flight Tracking: https://www.flightaware.com/live/
- 30 Day Map Challenge: https://30daymapchallenge.com/
- geojson.io: https://geojson.io/#map=2/0/20
- mapsharper: https://mapshaper.org/
- Urban Institute: https://upward-mobility.urban.org/
- Geocoder: https://geocoder.ca/
- Nominatim: https://nominatim.org/release-docs/develop/
- AI: https://pair.withgoogle.com/explorables/
- Overture Maps: https://overturemaps.org/
- Leaflet: https://leafletjs.com/
- Folium: https://python-visualization.github.io/folium/latest/
- Mock up: https://www.mokkup.ai/
- https://openrouteservice.org/
::location:: |
::latitude,longitude:: |
||
::what3words:: |
::timezone:: |
||
::bike_lanes:: |
::interests:: |
||
::to_poi:: |
::es_poi:: |
||
::linkedin:: |
::email:: |
||
::library:: |
::github:: |
Solution-driven analytical professional with experience managing socioeconomic, geospatial, and transactional databases for software companies in the Marketing, Advertising, Law Enforcement, and Retail industries. Pursuing an opportunity to use skills in database management, data operations, data analysis and business analysis.
-
Data and tech enthusiast in the areas of database management, data analysis, geospatial technologies, business intelligence and business systems
-
Developed ETL pipelines streamlining data operations using database management, BI and visualization tools
-
Related experience: Data warehousing, data lakes, data governance, stakeholder support, pre-sales support, sales enablement, product management, client advocacy, client services, community forums
Kalibrate Technology and eSite Analytics Data Engineer 2022 - 2023
Responsibilities:
- Requirements gathering
- Data migration into SaaS BI platforms
- Process documentation
Tools used include: Alteryx | MS SQL | Power BI | Excel | Trailblazer | Kalibrate Location Intelligence | Inkscape | JIRA | Confluence
Website: Kalibrate
Take a look at some examples...
Williams Engineering and Flow Consulting Business Intelligence Analyst Reporting Specialist 2021 - 2022
Responsibilities:
- Client support
Tools used include: MS Power Apps | Power BI |
Uncharted Software and GeoTime Technical Support Specialist 2019 - 2021
Responsibilities:
- Requirements gathering
- Data migration into SaaS cell phone forensics mapping and analytics platform
- Software pre-sales demo.
- License fulfillment
- Technical support and installation support
- Training and monthly demo.
- Client activity support and tracking
- SaaS and desktop UAT and bug reporting
Tools used include: Excel | GeoTime | TellFinder | ArcMap | Freshdesk | Salesforce | WordPress | JIRA | Camtasia
Website: GeoTime
Environics Analytics Technical Fulfillment and Client Services Manager 2012 - 2019
Responsibilities:
- Data production
- Data products cleaning and standardization
- ETL processing for data lakes and client distribution
- Product management support
- Pre-release and release product documentation
- Product bundling
- SaaS platform UAT testing and bug reporting
- Client services
- Zendesk implementation with macros and triggers
- Client support through phone, email and ticketing systems
- Data walkthroughs
- SaaS platform training
- Customer and trade area segmentation analysis
- Geodemographics and location analysis training
- IT
- SFTP management and user accessibility
- Process documentation for data governance
- Fulfillment
- SaaS platform license distribution
- Data product distribution
- Sales Enablement
- Account managment and business rules
- SaaS licences and data product analytics
- Client Advocacy
- Requirements gathering
- Pre-sales demos., SaaS platform demos., and data support
- Customer segmentation and market insights
Tools used include: Alteryx | Excel | ENVISION5 | Zendesk | MS Dynamics | Globalscape |
Website: Environics Analytics
NetGain Partners Research Associate, Data Mining and GIS 2011 - 2012
Responsibilities:
- Survey design and administration
- Data analysis
- Report writing
Tools used include: MS Project | Excel | SurveyMonkey | ArcMap
Bell Canada Inc. Geospatial Analyst 2011 - 2011
Resonsibilities:
- Location analysis for retail and competitors
- Market research
- Spatial Data Science: The New Frontier in Analytics - ESRI, Fall 2024
- Data Analyst - International Institute of Business Analysis (IIBA), Fall 2024
- Business Intelligence Specialist - International Institute of Business Analysis (IIBA), Fall 2024
| Level Up: Advanced SQL | Database Foundations: Database Management and Administration |
| ETL In Python and SQL | Tableau 2024.1: Essential Training |
| Intermediate SQL: Data Reporting and Analysis | Power BI Essential Training |
| Microsoft SQL Server Essential Training 2022/2019 | Data Literacy: Exploring and Describing Data |
| Relational Databases Essential Training | Marketing Analytics Setting and Measuring KPIs |
Data Engineer
- ETL pipelines from a variety of sources in to SaaS BI platform
- Database management for sales, transactions and customer records
- Tools used include: Alteryx, SQL, Power BI, TrailBlazer, and Kalibrate Location Intelligence
Database Diagram for Winnie's Hotel and Theo's Resto
Winnie's Hotel and Theo's Resto Locations with 3 KM Buffer in ArcGIS Pro
Winnie's Hotel and Theo's Resto Locations - Power BI Dashboard
Reporting Analyst
- Created workflow to present Power BI reports
- Implemented process to capture change requests inpacts on resources and project deliverables
- Tools Used Include: MS Power Apps, Form, Excel, Power BI
Technical Support
- Software technical support and product advocate
- Pre-sales product demos., software training, product webinars, product fulfillment, community forums and sales enablement
- Tools used include: MS Office, Freshdesk, Zendesk, MS Dynamics and Salesforce
Product Licensing, Fulfillment and Support
- Batch Scripting for Data Warehousing
- Creating file managment process to create data management system
- CMD line Batch Scripting using XCOPY, MD, MOVE, DEL, REN, TREE and others to manage files and directories across business systems.
- CMD line used to call on WINZIP, zip and rename files for distribution
Product Mangement
- Data production and product bundling for distribtion
- Data QA
- SaaS End-User feature and workflow testing
Client Services
- Client advocacy
- CRM reporting
- Zendesk, Freshdesk and JIRA
Elections Ontario - 2022 General Elections
- Polling stations
- Voter response rates
Elections Ontario - 2022 General Election ArcMap Pro
Toronto Environmental Alliance - PM2.5 in the City of Toronto
- Harmful toxins reported to City of Toronto
City of Toronto Arts Incubator Program
- Industry research and focus groups
- Report writing
Artscape
- Industry research and survey distribution
- Data analysis
- Report writing
Centennial College Field Feasibility Study
- Business plan for building multipurpose sports field
- Market research
Business Plan Outline
Business Plan Schedule
Deforestation in Rodonia, Brazil
- Remote sensing and image analysis for pattern detection
- Change over time analysis
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
Source logos: https://simpleicons.org/