Bryan R. Email & Phone Number

Charlotte, North Carolina, United States

• Managed compliance of multiple web applications with domestic and international data privacy regulations.• Gathered and converted business requirements into practical code updates while navigating complex intertwined initiatives.• Proactively identified potential future data privacy compliance risk within managed code procedures and escalated.• Investigated and fixed broken automated processes.• Performed User Acceptance Testing (UAT) of updates, evaluating application code.• Reported on regulation compliance status by dates, location and application, using Excel pivot tables and charts.• Maintained developer guide for updating application controls and notifications.

Charlotte, North Carolina, United States

• Monitored a Production DQ Dashboard that covered 19 tech domains with 6 uniquely calculated metrics each, writing, testing, implementing and documenting SQL changes and corrections.• Worked with teams in Business Intelligence (BI), Data Warehouse, Extract Transform Load (ETL), and Architecture, keeping Data Governance management informed of big picture results and setbacks.• Translated initiatives into pseudo code and then constructed complex SQL queries for metric calculations.• Worked with Data Warehouse team to resolve back-end calculation problems.• Consulted with Microstrategy BI development team on front-end/display issues and provided visual mock-ups of desired dashboard layouts and default configurations.• Performed SQL User Acceptance Testing (UAT) and change validation in Toad Data Point for all Data Warehouse involved modifications, approving or denying migration to production based on comparison between the System of Record (SOR) origination query and "fact table" counts.• Aided Data Governance in performance analytics and risk analyses.• Communicated technical updates, setbacks and successes to department leaders.• Cut a quarter of redundant change operations by consolidating similar data procedures across domains and processing in parallel.• Maintained data quality metrics profile, data dictionaries for local team use, and Sharepoint documentation.• Created environment process flow chart diagrams in Visio for quick reference guides.

Matthews, North Carolina Area

• Analyzed imagery warehouse datasets & object data collections for prospective business site suitability.• Provided 3D residential lot profiling (topographical features, tree canopy cover percentage, setbacks, building footprint, etc.).• Connected information systems to aerial photography datasets stored in AWS S3 buckets.• Processed/cleaned tabular data via Python pandas, NumPy and SQLite embedded databases.• Utilized PySpark clusters and dataframes for processing (cleaning/aggregating) multiple "xyz" csv files in Python.• Processed/cleaned/transformed raw LiDAR point cloud datasets into bare earth data for raster DTM conversion.• Imported data into spatial databases, and warehouses, performed ad-hoc analysis for clients, identifying/filtering parcels which met multiple criteria, producing custom maps, plots, and charts of results.• Loaded results to GIS Cloud, enabling private web map and dashboard access to clients, plus secure downloads.

Charlotte, North Carolina Area

• Provided valuable insights to vendor contract management team clients via BI dashboard visualizations of Key Performance Indicator metrics (KPIs).• Performed data mapping between disparate databases and data aggregation in Tableau.• Pulled data from data warehouse OLAP cube connections via Multidimensional Expressions (MDX).• Utilized Excel formulas, Macros and VBA, Python pandas, for cleaning/processing, and Tableau, Excel pivot tables, and Python matplotlib for plots/charts, BI dashboards and reports.• Increased efficiency and lowered impact of enterprise’s entire building portfolio via analyzing property utilization data and identifying employee workspace usage patterns to inform decisions.• Highlighted changes in office utilization via ad-hoc queries and reporting.• Migrated manual charting/reporting systems from Access and Excel to Tableau, eliminating 3 days per iteration.• Envisioned using metadata to identify overlapping BI workflows, to reduce process redundancies and consolidate similar actions, performing exploratory research on creative solutions devised.• Attributed processes for technical and non-technical users.• Produced engaging visualizations with Python for slideshow presentations showcasing team BI pipeline progress.

Charlotte, Nc 28227

• Performed spatial and quantitative analysis on all types of datasets for various clients, oversaw production of GIS data, imagery and visualizations, static and dynamic/interactive maps.• Imported data into spatial databases, performed ad-hoc analysis for senior management customers, identifying/filtering parcels which met multiple criteria, producing custom maps, plots, and charts of results.• Formatted/translated 3D and tabular data between different structure types according to client requirements.• Cleaned and processed raw LiDAR point cloud datasets into bare earth data for raster DTM conversion.• Corrected and georeferenced aerial photography, draping over terrain models, enabling reliable measurements.• Mapped between client, public source and in-house databases/systems.• Published results to Cloud Software as a Service (SaaS) providers, enabling private client web map interaction and dashboard access, plus secure downloads.• Wrote and maintained process guide documents and software installation history lists.

B.A. Geography, Earth Systems Science, Geographic Information Systems

Activities and Societies: Geography Undergrad ClubCoursework: Physical Geography, Statistics, GIS, Data Collection and Manipulation, Best.

Data Analytics Bootcamp

Covered: - virtual programming environments - libraries in Python for data parsing, analytics, visualizations, machine learning, and web.

Professional And Personal Development Course With Team Building

Individual Leadership Development course was an empowering experience that helped me better recognize professional and personal.

A.S. Liberal Arts, Mechanical Engineering Related Technologies/Technicians

Software Skills Acquired: AutoCAD, SolidWorks 3D design and Microsoft Word