Paul Clark Email and Phone Number

Analyzed existing and legacy system platforms coupled with information collected from technical and business teams to formulate and design an At Scale Analytics Platform (ASAP) in Azure. Work extensively with business and technical teams, as well as the Enterprise Architecture team, to solidify the architecture. Break down the overall platform design to project level incremental deployments assuring all projects align with the target architecture. Worked closely with engineering and program management teams to bring any needed clarity of the architecture at macro and micro levels. Created extensive collateral to support the transfer of information to many levels within the organization from Executive to Engineering resources.

Working with leadership, engineering and operations teams providing architectural and strategic direction for the organization's data management infrastructure, platforms, and business units. This role is a core contributor and leader across the entire business, interfacing with clients, executives, engineers, cloud operations and product teams. Responsibilities include design and architecture, creation and maintenance of reference architecture collateral, roadmaps, rollout plans, current, and future state diagrams, data standards, and guidelines, security models, data models, platform microservice integration and resource management.• Collaboratively designed and articulated overall platform architecture.• Created Data Management Standards and Guidelines collateral.• Designed more than 15 data models for the various microservices.• Constructed a migration plan for re-platforming efforts.• Worked with leadership to roadmap current and future product plans.• Managed engineering and operations teams in VPs absence.• Consulted on design and engineering efforts.• Solidified MVP for a rollout of legacy system efforts.• Designed and implemented a data management platform.• Consulted on major technology direction and services.• Aided the Product Team in their design of the new UI.• Stepped in wherever I could to make it happen.

Working with the global team, authoring Global Data Management standards, guidelines and best practice considerations. Staying current with technology trends and being an authoritative source for our delivery teams. Providing research and concept development while supporting organizations locally. Provide training guidance, and oversight as well as producing and maintaining GDM framework. Manage vendor service agreements and provide timely, accurate and relevant information globally. Lead for the Following Data Management Functions:• Security• Integration• Quality• Integrity• Storage• Analytics• Architecture• Modeling and Design• Interoperability

Providing architectural and strategic oversight for the organization's data management infrastructure, platforms, and BI stack. This role is a core contributor to the technical data strategy and information roadmaps for the organization, which include optimizing and enhancing our capabilities to integrate and maintain data for all corporate infrastructure. Proactively own the data architecture, lead technical projects and manage resources to support the overall needs of the organization.• Architected and developed their first BI Infrastructure and Data Warehouse.• Introduced, defined and chaired the Data Architecture Board.• Defined and published coding standards and data guidelines.• Served as the technical advisor to the Engineering teams.• Designed the end to end data architecture for the backend infrastructure.• Worked with executive sponsors for technology choices.• Architecture Review Board member.• Lead technical projects throughout the company.• Co-lead partnership efforts for system reconstruction project.• Designed a new MDM called Delegated Master Data Management. (Whitepaper)• Designed and disseminated a complete end-to-end process and data architecture. • Established data governance platform and roadmap for future governance needs.• Created and maintained a full set of detailed data architecture and business process diagrams.

• Architected and developed BI platforms for various companies in the San Francisco bay area.• Manage BI teams contracted throughout the bay area.• Design and implement standard practice processes for fulfilling contracts.• Developed and implemented a template BI architecture design and process.• Streamlined the complete development cycle of the BI platform.• Interfaced with clients and maintained healthy relationships.• Gained and persisted partnerships with clients and companies.• Mentored and matured BI consultants.• Designed and oversaw mapping and interface development.• Articulated the end-to-end data architecture in a set of detailed diagrams.Technologies Used• SQL Server 2012, 2014 with MDS and DQS• SSIS, SSRS, SSAS• PowerQuery, PowerPivot, PowerView, PowerBI and SharePoint• MS Office (Excel, Word, Power Point, Project, Visio)• C#, Batch Scripting• Tableau• ER Studio, Red Gate, Task Factory

• Designed, developed and deployed end-to-end BI architecture for online mobile applications.• Co-Designed an extensible and scalable mobile marketing platform.• Designed and developed database architecture for configuration data, central to the platform design. The architecture was fully dynamic preventing the need for further schema changes.• Provided consultation on many company projects and operational tasks.• Managed the development, build and deployment processes for all data related items.• Quickly ramped up and became versed in MongoDB and NoSQL technologies.• Stepped into various other positions when needed such as; Reporting operations, Operations management, Engineering VP• Gathered business requirements and use cases for project planning and design.• Designed a data warehouse proof of concept.• Production support and debugging issues throughout the platform architecture.• Trained and assisted the FunMobility staff for all data related software.• Designed an ETL platform to replace existing methodologies for data transfer.Technologies Used• MS SQL Server 2005, 2008 and 2012 / SSAS / SSRS / SSIS• Visual C# (Visual Studio 2008/2010/2013)• Java, Java Script• Visual Studio Design Tools for DB Schema Design• HTML5, XAML, XML and JSON• MS Office (Excel, Word, Power Point, Project, Visio, Access)• Mongo DB, MySQL, MongoVue, ActiveMQ, Tomcat• SVN (Subversion), HipChat, JIRA, Confluence• NetBeans, Eclipse

• Provided architectural insight, design and solutions in response to business necessities either communicated or discovered.• A development resource, in the execution of approved projects, requests and one-off requirements.• Avail my experience, history of software design, knowledge of business intelligence systems and other project work to provide Dodge and Cox a complete and verbose pool of information to make the best business decisions. • Supplement the IT support structure to provide better service to Dodge and Cox.• Provided research information for the edification of staff and management.• Designed and implemented the following systems within the first year. - Tracking system: to track transactional information for ETL pipelines. - Data Mapping Architecture: designed to replace hard-coded and manual ETL mappings. - Source Control Migration: designed new TFS source control structure and migrated source code. - ETL Framework: helped enhance their existing ETL framework.Technologies Used• MS SQL Server 2005, 2008 and 2012 / SSAS / SSRS / SSIS• Visual C# (Visual Studio 2008/2010), Perl, Java Script• Lightswitch• Visual Studio Design Tools for DB Schema Design• SharePoint• HTML, XAML, XML and Visual Basic• MS Office and many more tools and software• Oracle 10 and 11

• Quickly ramped up to maintain all existing BI pipelines and databases.• Designed end-to-end architecture for processing all current data feeds.• Worked with business analysts to design reporting architecture.• Worked with IT and DBAs for the purchase and integration of a new server.• Designed future BI architecture using raw-log data sources.• Provided educational support to BI team on programming and SQL technologies.• Developed a variety of tools; from fuzzy-match string comparison tools to high-speed parsers.• Re-wrote SQL code to increase performance for current processes.Technologies Used• MS SQL Server 2005 and 2008 / SSAS / SSRS / SSIS• Visual C# (Visual Studio 2008/2010)• Visual Studio Design Tools for DB Schema Design• SharePoint• HTML and Visual Basic

• Developed extract, transform and load pipelines for analysis.• Ad-hoc reports development for publishing analytics.• Tools development for optimized data extraction and data cleaning.• Database and Data Warehouse design and development.• Responsible for the reporting framework in the Offline Experimentation Platform for Ad Center.• Reporting DLL interface and Services development.• Developed JSON reader tools.• Data mining tools development and data mining for research and development teams.Technologies Used• MS SQL Server 2005 and 2008 / SSAS / SSRS / SSIS, Erwin Modeling• Visual C# (Visual Studio 2008/2010), F#• Cosmos (A proprietary big data analytics platform)• Scope scripting (A proprietary query language for Cosmos) • MS Office (Excel, Word, Power Point, Project, Visio, Access)• MS Office Interop C#• BVT and Integrated test project development• JSON formats, XML• HTML, ASP, VB Script

• Developed extract, transform and load pipelines for 8 TB+, per-day throughput.• Database and Data Warehouse design and development.• Developed custom report generation tools.• Developed MS Visio add-in used as a user interface for ETL pipeline development. (US Patent)• Designed a user-training course for the Visio ETL UI.• Collaborated with the MS SQL Server development team to design SQL Server’s first SSIS tools.• Assisted in presentation and documentation creation for executive review and funding.• Co-Designed partitioned server configurations and SQL Server distributed processing solutions for scalable and extensible data warehousing. (US Patent)• Co-Designed unique user tracking and reporting platform. (US Patent)Technologies Used• MS SQL Server 2000 and 2005 / SSAS / SSRS / SSIS, Erwin Modeling• VB, VB Script, Perl• XSLT schematics, XML, HTML, ASP• MS Office (Excel, Word, Power Point, Project, Visio, Access)• MS Office Interop VBA• C++

• Developed diagnostic and monitoring tools to support the MS License EDI pipeline. • Designed/Developed Microsoft License E2E reporting system.• Managed the project planning for customer specified reporting requirements. • Managed international relations between US Microsoft and Ireland MS offices.Technologies Used• VB, VB Script, Perl• Batch scripts in basic and VAX• SQL Server 4.1 – 6• Visual C++

• Developed a technician scheduling system between Vanstar inventory and order systems and Microsoft hardware order tracking. • Developed an inventory decision support, reporting system for Vanstar executive staff.• Developed a sales reporting system on inventory capacity and projections.Technologies Used• VBA• Access• VAX• SQL Server• Visual Basic• Batch script in basic

Throughout my time in college, I studied computer configurations. I built, troubleshot and configured computers for my classmates and teachers. At one point, the school hired me to reconfigure one of the labs.