Don George

Experience

• 

  Cognizant

  Dec 2017 - Aug 2021

  Programmer Analyst

  • Developed ETL routines for Extraction, Transformation and Loading data into target Databases.• Performed data analysis and normalization to resolve requirement conflicts and gaps between various data stores and business entities.• Worked extensively in Oracle warehouse builder to create, analyse and maintain mappings to enhance data flow from source systems to Data marts.• Worked with engineers from disparate source systems for data acquisition, transformation and data quality.• Documented and developed ETL routines related to Fact Tables, Dimension Tables, star/snow flake schema models, slowly changing dimensions, foreign key concepts & referential integrity.• Defined business rules and transformations for data coming from source systems into data warehouse to match business application of data.• Frequent interactions with stakeholders discussing user stories and enhancements.• Designed and developed production level data loads into data warehouse that are optimized for fast performance and minimal maintenance.• Designed dimensional data models that work well with other components of BI stack, like database and reporting tools.• Implementing fixes and design data audits to capture issues in future.• Implemented indexing and partitioning strategies that maximize query performance based on how users access data.• Interaction with system architects, designers, and developers to ensure thorough understanding of functions, technical, and performance requirements.• Review/analyse test case results to ensure functionality meets documented specifications.• Assisted in execution/analysis of integration, user acceptance, and performance testing.• Trained employees on coding standards, increasing coding efficiencies.• Met and exceeded quality targets by constantly verifying developed code for accuracy, efficiency and robustness. Show less

• 

  Wavenet

  Aug 2023 - Dec 2023

  Service Assurance Advisor

  • Monitored the performance of Wavenet's telecommunications services, ensuring optimal quality and reliability.• Resolved service issues by identifying root causes and coordinating with cross-functional teams for t timely resolution.• Provided exceptional customer support, addressing client concerns and keeping them informed throughout the incident resolution process.• Maintained accurate records of service incidents, resolutions, and relevant data to facilitate trend analysis and process improvement.• Actively participated in process improvement initiatives to enhance service delivery efficiency and minimize disruptions.• Collaborated closely with network operations, technical support, and engineering teams to streamline service operations.• Ensured strict adherence to company policies, procedures, and industry standards to uphold service quality and compliance.• Prepared and delivered regular reports on service performance and incident management to management and stakeholders.• Demonstrated effective communication skills, conveying technical information clearly and concisely to non-technical stakeholders and customers. Show less

• 

  Cambridgeshire County Council

  Dec 2023 - now

  Technical Analyst

  •Facilitated the reporting for archived data from retired applications whose data is required for statutory purposes.•Provisioning and supporting large complex datasets to allow users to analyze data across multiple systems for data mining purposes.• Implemented data flows to connect operational systems, data for analytics and business intelligence systems.•Designed ETL(Extract, Transform, Load) scripts and code to ensure the ETL process performs optimally.• Built accessible data for analysis. • Developed, coded, and tested new reports and modifications to existing reports, adhering to established standards and utilizing tools such as Crystal Reports, SQL Server Reporting Services (SSRS), Business Objects, and Power BI. Ensured alignment with business specifications to meet application/report requirements effectively.• Developed, coded, and tested new reports and modifications to existing reports, adhering to established standards and utilizing tools such as Crystal Reports, SQL Server Reporting Services (SSRS), Business Objects, and Power BI. Ensured alignment with business specifications to meet application/report requirements effectively.• Supported reporting applications in compliance with service level agreements, maintaining updated support documentation and adhering to change management procedures.• Collaborated with users, colleagues, IT, and third-party vendors to address support issues, raising and escalating support calls as needed to achieve satisfactory resolution within defined timelines.• Provided technical advice and consultancy to users and colleagues on reporting and data-related matters to enhance understanding and utilization of reporting tools and data resources.•Contributed to the reporting aspects of application support, ensuring effective alignment of reporting functionalities with overall application objectives. Show less