Clifford Thompson Email & Phone Number

Seattle, Washington, United States

Renton, Washington, United States

• Designed and developed a backend database to support supply chain logistics to improve scalability and eventual move to a data warehouse. After stabilizing the supply chain logistics solution, worked with product.
• Developed Python based ETL tool to streamline SSIS packages into a table-driven solution pulling from Teradata, Oracle, Excel, FTP, and SQL Server.
• Designed ETL framework for backend solution and leveraged SSIS packages to integration of data between platforms.
• Designed and developed back-end database to support front end software solution with future support for data warehousing and reporting.

Bellevue, WA

• Led multiple agile teams on migrating on-premise data marts into Azure and the development of a Azure Data Warehouse. Later assisted leadership in transiting the product teams into using Safe Agile framework and.
• Oversaw migration of on-premise SQL Server and Teradata data marts into Azure using ADF and data bricks.
• Designed and developed Azure Data Warehouse solution for new lines of business and led two product teams of 15 members.
• Assisted leadership with organizational transition to using Safe Agile framework and led as an agile coach four product teams as Scrum Master
• As member of architecture committee, organized training, provided architectural support, and governance for product teams.

Bellevue, WA

• Developed and designed several data marts supporting finance and marketing covering multiple lines of business to be used for executive dashboard. Eventually lead the team as lead developer and then eventually as the.
• Developed SSAS Tabular Cube and Azure SQL Server data mart to support business critical metrics supporting nearly 600 user and quarterly game plan for executive leadership. Coordinated with outside vendor to integrate.
• Solution owner and lead developer of multiple SSAS multi-dimensional cubes and SQL
• Server/Teradata data marts supporting reporting and analytics for finance and consumer metrics over multiple product lines.
• Managed SSIS ETL pipelines from Teradata, SQL Server, Oracle, and Sales Force to support Marketing and Enablement organization.

Seattle, Washington, United States

• Assisted Marketing leadership and Product Owners on identifying Business to Business customers and assisted on segmenting the business as well as the creation of the international calling product.
• Performed data analysis and support ultimately resulted in creation of T Mobile for Business and International UnCarrier initiatives.
• Assisted Product Managers in finding business opportunities and understanding customer behavior which ultimately resulted in new customer products.
• Laid foundation for data marts that supported analytics for the newly created product lines.Worked with vendors to obtain market intelligence such as Dun and Bradstreet and KPMG Link analytics.

Seattle, WA

• Prioritize projects from various business groups and identify which candidate projects would fit within the program mandate to receive budget.
• Coordinate with the Project Manager, Release Management, and Engineering to ensure that projects are implemented as required.
• Manage project budget and oversee vendor relationships to utilize the expertise of the partners and ensure that the individual projects are within budget
• Communicate with Senior Management the program delivery status and obtain additional funding (approximately. 4.5 million annually).

• Highmark Automation Testing, Highmark, San Antonio, TXAssisted Highmark Insurance in the automation testing of their claims processing system upgrade from their legacy system to the latest version of Oscar. This is.
• Lead the development of use cases, user acceptance testing (UAT), and systems integration testing (SIT) scripts using the Functional Specification Document as reference
• Identified opportunities to automate portions of the test plan in an effort to improve test coverage and reduce project cost
• Coordinated with the Development Team to ensure that bugs are resolved and that the solution meets the business requirements
• Coordinated with the Development Team and Project Manager to ensure version control and that the test environment reflects the development environment.

• Data Asset Management System Upgrade, Technical Solution Manager –Microsoft, Redmond, WAManaged the data cleanup, migration, and upgrade efforts of the current digital asset management system (ADAM) to the latest.
• Gathered Business requirements using global steering committee of approximately 50 members
• Development of the BRD for business approval from senior directors, directors, and managers from each business unit of Retail Marketing and presented the BRD to the Project Manager and Development Team
• Coordinated with the Development Team the implementation of the data migration plan and identified critical metadata fields necessary for the ADAM configuration tool
• Managed software vendor and sub contractor relationships to utilize the expertise of the partners and ensure that the project is within budget
• Coordinated with the Test Lead in developing the SIT and conducted UAT to ensure that the solution meets business requirements

• Asset Lifecycle Management, Technical Project Manager – T Mobile, Bellevue, WAWorked with the client in the development of business intelligence tools to monitor the outcome of the fixed financial asset reconciliation.
• Supervised other Business Analyst in defining critical integration points between CATS, SAP, and SAMS for the fixed asset reconciliation process
• Established managerial dashboards and reporting tools for critical metrics to provide senior management visibility to the reconciliation process
• Developed project plan for re-aligning outstanding items identified in the managerial dashboards and communicated with multiple heads within asset accounting
• Managed the development of the SQL Server solution in assisting the business analyst in the reconciliation process
• Developed the SIT and UAT plan and supervised other Business Analyst in implementing the plan

• Asset Lifecycle Management, Technical Data Analyst – US Cellular, Chicago, ILLead the client in creating a fixed asset reconciliation process by implementing a SAP load sub process for the market analyst. This sub.
• Defined metadata fields critical to the integration between CATS and SAP and developed a load process using SSIS and coordinated with the client in the development of custom SAP programs.
• Developed custom reports using SSRS to assist the Market Analyst in realigning fixed financial assets to their fair market value
• Coordinated with the client to establish a SIT and SOX compliance test plan and lead business analyst in executing the test plan
• SAP load process became the standard for other accounts in the Telecommunications industry for re-aligning fixed assets

• Center For Public Health Informatics, Computing Assistant, Seattle, WAAssisted both the computing manager and development team in project planning and custom development of health informatics research software.
• Development of a network security plan to bring department to HIPPA standards
• Testing, debugging, and development of web based applications for communicating and gathering health information from health practitioners
• Development of a SQL Server solution for use in data analytics and reporting.

• Central Distribution, Program Assistant, Seattle, WAActed as a liaison between nursing and central distribution to improve patient care, satisfaction, and cost savings.
• Designed a business plan to improve the operations of my department to improve cost savings, patient care, and satisfaction
• Presented and trained management, existing and new employees for responsibilities included in the business plan
• Senior management presented business plan to a national nursing conference as a new operational standard for central distribution in the medical industry

Master Of Tecnology, Business Administration

Business Administration, Accounting And Information Systems

Activities and Societies: Beta Alpha Psi, Golden Key

Associate Of Business, Business And Computer Science

Activities and Societies: Presidents List

Education record