Integrating CRM systems through .NET development for multiple international clientsDiagnose and resolve performance issuesMaximise optimisation of SQL queries, tables and stored proceduresAutomate and apply ETL of incoming and outgoing data through SSIS or pure SQLBuild and design solutions for operational data used for data warehousing and real-time performanceDevelop reports for Database maintenance, performance as well as reports required for clients internally or externally using SSRS or custom built via .NETEnsuring data integrity, compliance and securityExplore new technologies and frameworks for future integration and automation

• Writing complex SQL functions, procedures and queries to extract, transform and load data• Generating dynamic multi-level reports in SSRS to track performance• Creating automated packages in SSIS using complex variables to improve efficiency of repeated tasks• Using GIT to track and make changes• Communicating with the clients and understanding their requirements• Troubleshooting server and database issues to ensure maximum productivity for agents

• Writing Teradata/Oracle/Access SQL to generate reports to provide insight and analysis for finance and marketing decisions.• Designing Microstrategy web-based dashboards for greater interactivity.• Building strategic solutions for long term reporting. • Adherence to strict SLAs. • Problem solving to ensure data integrity.• Developing and automating reports using VBA and OCDB connections.• Creation of production schedules.

• Developed, created and produced an all-in-one software solution for Outbound Calling using VBA. Using Access as the backend for data storage, capturing customer information from different systems. The front-end for agents providing interaction with Softphone to make calls, visualising commission status to drive performance, google maps integration with distance from broadband exchange and potential download speeds. The system was also used in the Glasgow Call Centre to monitor and help inbound Telesales performanceCreate multi-level Telesales reporting including commission.Create HTML5 reports for greater interactivity and deeper analysis