SUMMARY

• Outcome - oriented GIS professional with combined 10+ years’ achievement in progressively responsible Enterprise Data Management leadership roles and a demonstrated track record of success translating business requirements into technical solutions, extracting data from various business systems to build high-level analytical solutions, data visualization tools, and delivering enterprise GIS projects in complex environments.
• In-depth expertise in variety of platforms/tools - databases, JavaScript, and R/Python.
• Skilled at creating and managing spatial data in SDE, architecture/models, data warehouses and GIS applications to improve overall reporting capabilities and enhance management’s toolkit. Self-motivated, PMI Agile Certified Practitioner who brings business perspectives to technology projects - adept at identifying critical alignments between technology and business which translate into bottom-line growths.

AREAS OF EXPERTISE:

• ArcGIS (10+) Full Stack - Lean/PMBOK® Agile Practice - Strategic Planning - Mentor & Training
• .NET 4+ - JavaScript - Python - Data Analytics/Visualization - Metrics & Reporting

PROFESSIONAL EXPERIENCE

Confidential

Lead Tableau developer

Responsibilities:

• Manage workbooks/dashboards deployment, perform the optimization, data extract refreshing, data backup, row-level security access setup on Tableau online sever, using various TABADMIN/TABCMD.
• Perform quick data analysis using Tableau Prep to build workbook mockups and prototype dashboard based on variety of raw data from difference sources.
• Develop SSIS packages to clean and build data source; develop and maintain Tableau data sources at the backend through complex queries, stored procedures/programs.
• Develop various predictive analytical tools/methods in Python/R, scripts integrated with Tableau dashboards to enhance data analysis capabilities and help planning course of actions.
• Build and deliver a variety of prototype dashboards using new features, e.g. Tableau Extensions, External Service connections.

Confidential

Lead Data automation & visualization sme

Responsibilities:

• Employed dashboard best design practices to develop a suite of unique visual appealing visualization tools to meet various high level and operating management needs, with easy to use interactive features.
• Developed SSIS packages and Python scripts to automate mundane data (ETL) process - multiple sources e.g. csv/excel files, and SAP HANNA; developed and maintained Maintenance Tableau data sources at the backend in stored procedures/programs.
• Participated Dow Chemicals’ digital transformation, evaluated current IT infrastructure, software platform and developed/incorporated GIS initiative as part of larger goals/strategy on overall data governance, related to spatial data assets in GIS space.
• Developed various predictive analytical tools/methods in Python/R, scripts integrated with Tableau dashboards to enhance data analysis capabilities and help planning course of actions.
• Built and delivered a variety of prototype dashboards easy to customize using Tableau/Power BI on Engineering projects through collaborate efforts with other teams in identifying and finalizing business requirements utilizing PMBOK®/Agile methods.
• Shared technical expertise in scripting/developing, trained/coached team members in speeding up deliveries of working solutions (Tableau) with continuous improvement.

Confidential

Tableau Developer/consultant

Responsibilities:

• Developed high-level storyboards/dashboards. Customized applications using JavaScript API, compatible with mobile devices and different browsers, with enhanced visualization, easy-to-use query functionalities to present various KPIs, using new features, e.g. LOD techniques and table calcs.
• Identified stakeholders, overall objectives to establish the data governance framework focused on BI data warehouse management support and implemented a set of procedures to ensure data availability, integrity and security in support of overall asset reporting goals using Tableau reporting toolkit.
• Created, set up and optimize Tableau extracts from different business systems, scheduling/back up, performance tuning at various levels.
• Designed, developed spatial data from various data sources, combining Oracle data with complex Pipeline data structures on 3k+ tables, and developed data marts/data warehouses as part of the enterprise data governance initiatives for Midstream and Intrastate pipeline BI reporting. Built GIS Web Services, metadata source through custom query, data blending and other techniques and publish to the GIS and non-GIS servers.

Confidential

Business Intelligence consultant

Responsibilities:

• Designed/developed various Dashboards and visuals through customized scripts, calculated/grouped fields/sets and filters (using built-in scripting tools/functions) to accommodate specific reporting needs and published as services for other applications; built GIS(WMS) services integration with Tableau visuals to geo-locate critical business data.
• Built Oracle data marts/data warehouses (PL/SQL) along with ETL processes (data mining) to expedite data migration and transformation for various reporting requirements with Tableau Desktop.
• Installed, configured and optimized Tableau enterprise server/desktop - set up infrastructure resources to improve the overall management goal of COH Street and Drainage asset management in Cityworks; use Tabadmin/Tabcmd for server performance tuning, set up user access privileges, data backups/extract scheduling, patching installations and etc.

Confidential

GIS Supervisor

Responsibilities:

• Identified client departmental data needs/requirements and accountabilities to set up strategic partnership in alignment with the city-wide Enterprise GIS data governance to support Enterprise GIS system; introduced Agile/Lean Data Governance practice.
• Led a team of three technical staffs on variety of GIS and non-GIS data migration/development across multiple departments for COH enterprise GIS system initiative; authored project plans, built data marts, data warehouse and implemented ETL process for multiple data transforming/migrations across departments.
• Built State of Texas Sales Tax tracking application that recovered otherwise missing tax collection revenues by 40%; additionally, built unique project management tools (.NET) to track department IT project status, and several JavaScript/HTML 5 GIS Web applications - Fire emergency response, Fire Hydrants tracking and etc.
• Deployed and configured SSRS, built SSIS packages for asset data reporting.