Accomplished professional with extensive experience in managerial and leadership roles, experienced in data strategies and strategic alignment. Demonstrates proficiency in project management, business analysis, utilising tools such as JIRA boards for project and sprint planning. Adept at utilising tools such as Tableau, SpotFire, Power BI, SQL, Hadoop, Teradata, PL/SQL, Microsoft Office tools and ETL processes including Talend. Skilled in data science techniques and the use of statistical packages for predictive and descriptive analytics using SAP Predictive analysis, R, Python (including NLTK and Matplotlib) and Azure ML studio. Strong analytical skills complemented by experience in performance reporting and stakeholder management. Career goal includes leveraging extensive technical expertise to drive business intelligence initiatives within an agile framework.
Overview
8
8
years of professional experience
4
4
years of post-secondary education
Work History
Business intelligence manager
Student Loans Company (SLC)
Glasgow
09.2023 - Current
Streamlined data management procedures to improve efficiency, and was influential in implementation of Collibra in SLC.
Identified departures from agreed-upon procedures and standards and helped close gaps. Created confluence pages that is now used to monitor and update standards and procedures.
Used BI solutions like Tableau and Power BI to provide a unified view of enterprise data. Created enterprise wide branding for all dashboard we build.
Led development of over 30 dashboards, 20 ETL jobs and 20 predictive models.
Worked closely with ELT to establish KPIs and objectives, ensuring alignment with overall business goals, KPIs were featured on business balanced scorecard created and it's used to drive enterprise wide decisions.
Constructed predictive and statistical models to help guide future planning.
Highlighted undetected organisational needs and created insights to improve business performance.
Evaluated existing BI systems for areas of improvement or upgrade, upgraded both our BI tool Power BI and Tableau.
Drove change management initiatives related to business intelligence projects.
Coordinated, implemented and oversaw plans for testing new software releases and performing required updates.
Interviewed staff to obtain personal observations and insights into existing technical and non-technical strengths and weaknesses. Implemented training programmes for staff to improve technical skills set based on weakness.
Demonstrated strong leadership whilst managing diverse team of analysts, monitored and kept them informed on performance through weekly catch up and monthly personal development plan.
Fostered better team collaboration through clear communication and guidance.
Created safe working environment where team members felt valued, heard and appreciated.
Enforced strict compliance with data privacy regulations to safeguard company's reputation.
Senior business intelligence developer
Janssen
Edinburgh, Edinburgh
10.2021 - 09.2023
Provided technical input at daily sprint such as project definition workshops and business analysis workshops, implementing and monitoring standards and procedures for all projects and activities within span of control.
Gathered business requirement and translated them into projects and drove functional alignment to maximise insights of operational data.
Engaged with subject matter experts within the organization to understand data quality and lineage.
Routinely undertook data-quality checks to achieve high-level of data accuracy.
Analysed data with statistical techniques, applying appropriate caveats and contextualizing presentation of analysis to provide clear message(s).
Developed over 15 dashboards, 5 predictive models and maintained 40 dashboards and model combined.
Created dashboards with KPI tracking for better performance monitoring using Tableau and SpotFire.
Created various time series forecasting techniques to predict samples needed from subjects, increasing efficiency of sample management.
Built subject attrition random forecast that improved yearly retention of our subjects for various trials.
Ensured systems code and documentation are inspection ready.
Conducted training sessions on use of Tableau and understanding of how to structure data.
Supported interns through their career development by guiding them through relevant internal courses.
Ensured junior developers continued to be compliance with information governance framework and statute.
Delegated project tasks to team members based on their level of expertise.
Quickly learned and applied new skills to daily tasks, improving efficiency and productivity.
Senior consultant - Business intelligence
Morgan Stanley
Glasgow, Glasgow City
10.2019 - 10.2021
Acquired data from primary and secondary data sources using SQL developer.
Instrumental in gathering all cyber security market standard data and helped set up test and deployment documentation.
Developed over 10 dashboards and 5 predictive models. Maintained over 20 dashboards and models combined.
Supported vice president with development and implementation of strategies for operations and further development of data warehouse.
Developed dashboards to drive insights using using Tableau, Power BI and QlikView for visualization.
Created NLP model that searches keyword in MS controls and map them to market standards to understand how many market controls Morgan Stanley has in place.
Cleared ad hoc queries from various stakeholders while also managing their expectations.
Led and managed developers from outsourcing companies for various project such as risk management dashboard, data quality dashboard etc.
Prioritized different project with overall team based on stakeholders' expectations and managed projects on jira. Led sprint call with developers.
Performance-tuned and troubleshooted reporting and BI tools, systems and software.
Identified areas of improvement in current dashboard and suggested dashboards to be decommissioned.
Facilitated team training on BI tools for improved performance and understanding.
Mentored interns and assisted them with their upskilling, supported them through their career development by guiding them through relevant internal courses.
Understood of cyber strategy, market standard and cyber metrics.
Reporting analyst
Business Stream
Edinburgh
06.2018 - 10.2019
Acquired data from primary and secondary data sources using SQL.
Interpreted data, analysed results and used Tableau for visualization.
Built dashboard that allowed company to recover £5.3 million of water cost based on assignment of incorrect tariffs.
Streamlined data processing with automation techniques, built dashboard that automatically provide accurate tariff to right customer based on company size.
Conducted detailed competitor analysis, provided actionable insights to stakeholders. Built competitive market dashboard that shows water supply market share across UK.
Presented analytic findings in a clear manner during team meetings, fostered informed decision making.
Maintained knowledge of industry trends, innovations and best practices to offer up-to-date business insight.
Cleared ad hoc queries from various stakeholders while also managing their expectations.
Data analyst
AEGON
Edinburgh
11.2017 - 02.2018
Investigated user requirements, using results to design functional specifications.
Structured development projects by creating flows, processes and data structures.
Translated complex findings into understandable insights, increased company-wide understanding of critical metrics.
Built 1 dashboard and 1 ETL job for data that feeds dashboard
Created schedule adherence dashboard for operation team, this led to decrease in average handling time and call handling speed.
Ensured accuracy of all metrics through rigorous testing procedures.
Defined and maintained data-definitions, metrics and KPIs.
Technical support team leader
Sony PlayStation
Edinburgh
02.2017 - 11.2017
Managed team of technical specialist, made sure agreed SLA are met, provided support for their career development, met with key stakeholders within business to discuss how systems and processes can be improved.
Led weekly tech talks, encouraging sharing of best practices amongst team.
Managed and maintained user accounts, permissions and security settings in Active Directory.
Used broad range of questioning skills to understand and resolve customers' needs and expectations.
Prioritised help desk requests based on severity, maintaining customer satisfaction levels.
Education
MSc - Business Information Technology
Edinburgh Napier University
Edinburgh
01.2016 - 07.2017
BSc (Hons) - Information Technology
Edinburgh Napier University
Edinburgh
09.2012 - 06.2015
Skills
Managerial
Managerial and technical leadership skills
Data strategies and strategic alignment
Performance reporting (Corporate and People)
Negotiation proficiency
Project management
Business analysis
Agile methodology
Stakeholder management
Scrum and use of JIRA boards for sprint planning
Database
Oracle database development
PL/SQL and SQL
Hadoop
Teradata
ETL
Talend
Business intelligence
Strong analytical skills
Report writing
Tableau, Power BI, SpotFire and QlikView
Data science
Use of statistical packages for predictive and descriptive analytics
SAP Predictive analysis
R and Python
Azure ML studio
Others
Microsoft Office tools
Accomplishments
Implementing a KPI dashboard for internal stakeholders
Receiving an excellence award for BSc (Hons) dissertation
Mentored 2 interns at Morgan Stanley with both receiving a graduate role
Interests
Socializing with friends and family
Meeting new people and experiencing different cultures
Keeping fit by taking part in competitive sports
Timeline
Business intelligence manager
Student Loans Company (SLC)
09.2023 - Current
Senior business intelligence developer
Janssen
10.2021 - 09.2023
Senior consultant - Business intelligence
Morgan Stanley
10.2019 - 10.2021
Reporting analyst
Business Stream
06.2018 - 10.2019
Data analyst
AEGON
11.2017 - 02.2018
Technical support team leader
Sony PlayStation
02.2017 - 11.2017
MSc - Business Information Technology
Edinburgh Napier University
01.2016 - 07.2017
BSc (Hons) - Information Technology
Edinburgh Napier University
09.2012 - 06.2015
Similar Profiles
Daniel BrownDaniel Brown
Business Analyst at Student Loans CompanyBusiness Analyst at Student Loans Company