Phillip Belone, MISM

Experience

• 

  Knowledge Computing Corporation

  Jun 2006 - Aug 2009

  Project Lead /ETL Specialist

  Developed and deployed technology for the COPLINK® program. Designed, analyzed, tested, deployed and administered regional information sharing systems for over 26 national law enforcement agencies.Planned and implemented best industry practices to ensure projects successfully progressed through all phases of the System Development Life Cycle.Installed, configured, and managed SQL 2000,2005,2008 R2, AS/400, and Oracle 8i-11g databases.Analyzed Oracle, AS400, and SQL RDMSs to construct ETL virtual maps to effectively and efficiently migrate information to a SQL 2000,2005,2008 R2 or Oracle database.Analyzed various RDBMS via data mining to construct XML maps to facilitate in the migration of data from an Oracle/AS/400/MS Access/SQL Server Database to a SQL 2000,2005, 2008 R2 data base.Configured, tested, and established network connectivity between multiple and diverse relational database management systems for the migration of source data to a SQL 2000,2005, 2008 R2 database. Show less

• 

  Canyon Ranch

  Jan 2010 - Jul 2010

  Support Analyst (Contract Consultant)

  Provided quality and professional IT Customer Support to ensure users maintain optimal productivity.Provided technical support and service for Sage Accountant Solutions and proprietary software.Monitored and efficiently resolved help desk tickets generated from phone, email, web, and voice mail from 5 national properties.

• 

  The University of Arizona

  Jul 2010 - Jan 2011

  Systems Analyst (Contract Consultant)

  Deployed Microsoft Business Productivity Online Standard Suite for University of Arizona Medical Center faculty and Staff.Documented technical requirements and utilized Microsoft Project to assist in deploying systems that met user requirements on schedule.

• 

  M3 Engineering & Technology Corp.

  Jan 2011 - Jul 2014

  Software Systems & ETL Developer

  Managed, Developed and Deployed Microsoft Dynamics SL modules to increase office efficiency and improve data standardization and reporting capabilities for various international projects.Managed, Developed and Deployed and maintain multiple international ETL projects.Analyzed and documented end-user requirements, and developed story boards, to develope deploy new software technologies, update existing Enterprise software and/or evaluate and recommend business processes.Developed Crystal and SSRS reports. Created Ad-Hoc Crystal, Excel (Power Pivot, Power Query), and SSRS Reports.Managed the development of technical end-user training documentation and supplemental training videos. Trained, provided technical support, and worked with Engineering, Procurement, and Construction Management (EPCM) departments to audit, secure, validate, and manage M3 data. Show less

• 

  Raytheon Missile Systems

  Jul 2014 - Feb 2015

  Enterprise Program Business Intelligence Managment Analyst & ETL Specialist

  Responsible for the development and implementation of enterprise data warehouse (EDW) with emphasis on data warehousing, OLAP, star schemas or reporting cubes for SSRS reporting and data analysisApplied experience in data analysis and mining, operational and analytical reporting, data transformation and cleansing, data warehouse and data mart design, definition and administration of user access and security via Corporate authentication standardsAnalyzes, develops specifications, and execute data mapping and transformation processes and requirements within and between applicationsLeads requirements gathering, conceptualizing solutions, and developing a framework for implementation of a data warehouse, data mart, and or data web solutionPerforms data-related research and root cause analysis activities, provide correction specifications, and escalate issues as appropriate Manages procedures of data warehousing including data extraction, manipulation, and cleansing toolsManages the implementation of table partitioning, working with SQL Server Integration ServicesFacilitates system data maintenance and SQL database table changes associated with software applicationsEngages in control activities to ensure data quality and adherence to enterprise data policy Ensures data integrity by executing necessary processes and controls around the flow of data Verifies accuracy of table changes and data transformation processes, and tests changes via QA/QC processes prior to deploymentUtilizes Microsoft technology to analyze data and/or metrics from applicable systems to review data processes, identifies issues, and determines actions to resolve or escalate problems that require data, system or process improvements Defines, publishes, and/or enforces changes to corporate codes Provide input to data architecture discussions and decisions on request Show less

• 

  Hexagon Safety & Infrastructure

  Jan 2015 - Jan 2018

  Systems Consultant

  Systems Consultant focused on the Intergraph Public Safety Dispatch, Law Enforcement and Fire Department Mobile Public Safety software solutionsDevelop and troubleshoot GUI applications customization using T-SQL, XML, XSL, HTML, ASP.NET, JavaScript, and VBScript Responsible for the administration, development, and maintenance of Intergraph Public Safety softwareResponsible for requirements gathering with diverse user groups and stakeholdersProvides technical support, installation, maintenance, and configuration of Intergraph Public Safety softwareManages on-going system development, administration and maintenance servicesTechnical liaison between the City of Tucson IT, Tucson Police and Fire Departments to Intergraph Communications Center staff and Intergraph technical personnelComplies with Tucson City IT standards and procedures for deployment testingMentors and trains less experienced team membersManage relationships with IT Application Development and Public Safety teams as it relates to testing, Root Cause Analysis, and development Show less

• 

  City of Tucson

  Jan 2018 - Feb 2019

  Public Safety Systems Analyst

  • Public Safety Systems Analyst focused on Public Safety and Law Enforcement Records Management Systems and Public Safety Dispatch Systems• Performs data analysis of various data sources and processes to ensure data integrity, completeness and accuracy for reporting• Applies knowledge of T-SQL to write and modify complex T-SQL scripts• Analyzes, evaluates, modifies, configures, tests, and assists in development of critical public safety systems• Identifies and evaluates data and reporting areas of concern• Assists in managing on-going reporting and systems development, administration and maintenance services• Manages and develops GUI customization work via JavaScript, HTML,XML creation/modification of various i/Dispatch and Mobile Public Safety application dialogs Show less

• 

  Roche

  Feb 2019 - now

  • Applies 19+ years of experience designing, developing, testing and implementing secure, scalable and high-performance BI and analytic solutions for Roche • Assists in the design and development of systems to consolidate and analyze unstructured, diverse “big data” sources to generate actionable insights and solutions for client services and product enhancement• Interacts with product and service teams to identify questions and issues for data analysis and experiments• Identifies meaningful insights from large data and metadata sources; interprets and communicates insights and findings from analysis and experiments to product, service, and business managers• Develops and deploys Snowflake data warehouses• Develop mathematical or statistical theory methods to collect, organize, interpret, and summarize numerical data to provide usable information• Develops ETL data pipelines with Snowflake and Microsoft SQL Server Integration Services packages• Develops Tableau Dashboards from disparate data sources including JSON, Excel, Google Analytics, Oracle, MySQL, Microsoft SQL, SAP HANA, Google Sheets, and SharePoint Lists• Designs, develops and maintains on-premises and cloud-based data structures such as data marts, Data Warehouses, data lakes, and data pipelines Show less • Applied 15+ years of experience designing, developing, testing and implementing secure, scalable and high-performance BI and analytic solutions for Roche • Develops and deploys data warehouses with Microsoft SQL Server• Utilizes Python with Pandas and Matplotlib to perform preliminary Data Analysis • Develops ETL processes with Microsoft SQL Server Integration Services packages• Develops Tableau Dashboards from disparate data sources including JSON, Excel, Google Analytics, Oracle, MySQL, Microsoft SQL, SAP HANA, Google Sheets, and SharePoint Lists• Applies experience with data visualization development with SSRS and Tableau• Designs, develops and maintains on-premises and cloud-based data structures such as data marts, Data Warehouse warehouses, data lakes, and data pipelines• Develops and maintains data pipelines to acquire, profile, cleanse, consolidate, integrate, and persist structured, semi-structured, and unstructured data• Develops, manages, and troubleshoots enterprise ETL processes• Recommends ways to improve data reliability, efficiency and quality• Optimizes and tunes queries for performance• Develops DFD and ERD models and documents complex report systems• Collaborates with International team members on project goals• Monitors data warehouse performance and recommend any necessary infrastructure changes• Remains current on data architecture, analytics, and data science developments• Ensures systems meet industry best practices and business, security, privacy, and retention Show less

  • Data & Analytics Specialist

    Oct 2022 - now

  • Senior Enterprise Programer Analyst

    Feb 2019 - Oct 2022