Mark Dawson Email & Phone Number

Denver, Co, Us

New Taipei City, Taiwan, Tw

Global leader of YAGEO Group Business Intelligence and data management team. Provide global vision and oversite on YAGEO Group data architecture, data management, and data analytics platforms. Lead multi-national business intelligence team located in both Asia and the Americas, providing critical data insights for C-suite executives, product business group leadership, as well as finance, planning, and manufacturing.

New Taipei City, Taiwan, Tw

Global leader of YAGEO group business intelligence and data management initiatives. Provide thought leadership, strategic vision, and technical direction for YAGEO group data strategy, data governance, and data quality efforts. Manage international distributed business intelligence team providing strategic reports, data assets, and insights to our business stakeholders.

Fort Lauderdale, Florida, Us

Fort Lauderdale, Florida, Us

New York, Ny, Us

Designed, developed, and optimized IBM DataStage ETL load routines of Brokerage and Mutual Funds daily, weekly, and monthly batch jobs. Optimization of enterprise production load schedule to insure compliance with company service level agreement (SLA).• Reverse engineered legacy Java-based Brokerage and Mutual Funds load algorithms for conversion to more efficient, scalable, and enterprise compliant Datastage ETL jobs as part of Brokerage and Mutual Funds Maintenance project. • Developed critical data mapping document for successful source to target data element mapping• Developed multiple IBM DataStage ETL load routines using sequences, transformer stages, joiner stages, merge stages, sequential file stages, and ODBC stages, as well as other to replicate legacy algorithm. • Created or modified SQL Server 2005 and SQL Server 2008 tables, views, and T-SQL stored procedures for integration of database objects with IBM DataStage ETL load routines.• Created multiple LINUX scripts for transfer of data files both internal and external as required using MQFTE transfer protocol.• Performed extensive regression testing of existing SQL Server 2005 T-SQL stored procedures, views, user-defined functions, and triggers migrated to SQL Server 2008 platform as required for compliance to corporate high availability.• Developed complex Autosys production load schedules with predecessor, successor, and time dependencies to insure compliance with SLA for internal and external customers.

New York, Ny, Us

Designed, developed, and optimized IBM DataStage ETL load routines of Brokerage and Mutual Funds daily, weekly, and monthly batch jobs. Optimization of enterprise production load schedule to insure compliance with company service level agreement (SLA).• Reverse engineered legacy Java-based Brokerage and Mutual Funds load algorithms for conversion to more efficient, scalable, and enterprise compliant Datastage ETL jobs as part of Brokerage and Mutual Funds Maintenance project. • Developed critical data mapping document for successful source to target data element mapping• Developed multiple IBM DataStage ETL load routines using sequences, transformer stages, joiner stages, merge stages, sequential file stages, and ODBC stages, as well as other to replicate legacy algorithm. • Created or modified SQL Server 2005 and SQL Server 2008 tables, views, and T-SQL stored procedures for integration of database objects with IBM DataStage ETL load routines.• Created multiple LINUX scripts for transfer of data files both internal and external as required using MQFTE transfer protocol.• Performed extensive regression testing of existing SQL Server 2005 T-SQL stored procedures, views, user-defined functions, and triggers migrated to SQL Server 2008 platform as required for compliance to corporate high availability.• Developed complex Autosys production load schedules with predecessor, successor, and time dependencies to insure compliance with SLA for internal and external customers.

San Francisco, California, Us

Supported enterprise-wide customer relationship management tool (CRMTools) on issues pertaining to back-end Oracle 11g load process. Implemented new functionality via PL/SQL procedures, UNIX shell scripts, materialized views, and other database objects. Developed web-based interactive Tableau 6.0 dashboards and workbooks against CRMTools subject area, as part of reporting proof of concept.•Developed/modified multiple PL/SQL load procedures for data migration from legacy RMTools application to new CRMTools data tables•Created multiple materialized views for sourcing data from distributed databases for use by CRMTools load process•Designed, tested, and implemented SQLLDR scripts for loading of critical data from source data files into staging tables•Produced multiple UNIX shell scripts for automation of load process by Autosys production scheduler•Developed several interactive web-based Tableau 6.0 workbooks and dashboards for proof of concept against CRMTools subject area•Developed browser-based analytics on customer call rates by revenue by blending disparate data sources into an interactive and visually eye catching dashboard•Implemented Tableau cutting edge functionality, such as guided analytics, quick filters, action filters, parameter fields, calculated fields, sets, groups, Top N analysis, and scheduled data extract as part of proof of concept•Interfaced with Tableau sales and support team for Tableau 6.0 migration issues and defect identification and resolution•Implemented best practice version control methodology, and designed and documented all aspects of project lifecycles

Greenville, South Carolina, Sc, Us

Functioned as Project Manager to successfully lead Power School Bridge Implementation project as part of Power School student information system conversion. Minimized impact and outage of critical district wide applications through timely completion of project prior to “sun setting” of legacy SASI student information system. Designed and developed Power School Oracle 10g to SQL Server 2008 ETL process. •Performed gap analysis of district wide applications to identify magnitude of impact to mission critical district functionality due to South Carolina Department of Education mandated conversion to Pearson Power School student information system•Communicated scope of conversion impact to GCSD Information Technology management and successfully developed Power School Bridge conversion project to mitigate outage and impact to students, parents, faculty, and staff•Successfully delivered project within timeline and budget to meet deliverable of Master Pearson SASI to Pearson Power School conversion project•Resolved day-to-day project issues with emphasis on SDLC methodology•Implemented project control measures for limiting change of scope as well as tracking of application defects and issues•Collaborated with SQL Server DBA for design of ETL process using SSIS for loading of critical student information data into target tables•Developed multiple SSIS integration packages to extract data from Power School Oracle 10g database into SQL Server tables•Configured connection strings and linked servers to connect with Oracle database•Utilized control flow element Execute SQL task to extract data via user stored T-SQL procedures for loading into target table•Resolved data type incompatibility issues due to disparate database platforms of Oracle 10g source to SQL Server 2008 target•Developed multiple SQL Server T-SQL stored procedures for loading data from Oracle 10g source to SQL Server 2008 target tables

Rosemont, Il, Us

•Designed back-end ETL load process, partition strategy, and indexing requirement as well as table design and space utilization of Sales KPI process for deployment to Hyperion cube load •Successfully functioned as team lead of Sales KPI (Key Performance Indicator) project to manage contractors and junior developers to meet technical and business requirements within scope of project time and budgetary constraints•Designed, developed, and successfully initiated augmentation of existing Sales subject area with supplemental sales loading process for use in Contract Pricing Audit tool to audit contract compliance for national account customers•Routinely handled on-call support for 6 data warehouse applications with over 20,000 + corporate user-base across multiple time zones on several Oracle platforms•Initiated new member orientation and mentoring/shadowing program to improve employee retention and technical assimilation•Designed, tested, and implemented advanced Perl extraction process to access HP Neoview 2.4.1 database for loading into Oracle 11g database•Utilized advance Oracle features such as external tables and transportable tablespace for optimal data migration of divisional datamart for Discover user-base•Routinely perform extensive and complex SQL query tuning of Oracle SQL statements, PL/SQL packages and procedures, which involves but not limited to explain plan generation using SQL*PLUS, SQL Tuner, autotrace and TKPROF to identify application programs that are CPU, I/O intensive and resolve them•Resolved multiple datastage performance issues and release errors for enhancement, optimization, and improvement of mission critical Enterprise Data warehouse•Implemented best practice version control methodology, and designed and documented all aspects of project lifecycles