Resume
The following is a brief outline of what I have doing. For CV downloads, please check bottom of the page.
An MSc Business Information Systems graduate, with a BI dissertation, marketing qualification, Tableau, SQL, SSIS, SSRS, Excel experiences, seeks a position where he can utilize his critical, analytic skills, problem solving, data cleaning /preparation and extensive Data visualisation experience. Committed to partner with customers to increase customer value proposition by matching their needs with company’s objectives.
An adaptable, enthusiastic and self-motivated who takes pride in his work. Communicates well at all levels and is able to form working relationship quickly with a wide range of people. Possess excellent technical, administrative skills, able to organise people and systems effectively in order to achieve objectives. Used to working extra unsocial hours and under pressure to meet strict deadlines.
Customer Service
I have dealt with a broad range of customers’ needs and requirements. Believes in building customer relationships by connecting, informing, engaging and maybe even energizing them in the process. Subscribes to the following notion, what is good for the customer is good for the company, and what is good for the company is good for me.
Self-Development
- Using AI to take Data analysis to the next level.
- Keeping up to date with current trends, AI, T-SQL, Tableau,Tableau Prep, Power BI, Power Query, SPSS, SSIS and SSRS
- Learning to analyse tabular data using the BI Sematic Model (BISM) in SQL Server 2012 Analysis Services. Learning Data Analysis expressions (DAX) language to create calculated columns, measures, and queries.
- Building a personal website from scratch. For the website, I am learning HTML, CSS, Dreamweaver and Photoshop. The idea of a website was to show some of my work and blog about Data analysis.
NHS East of England Venn Group (Fixed Term Contract) Jul 2023 – Oct 2023
Business Analyst
- Designed Tableau Dashboards to illustrate Turnover rates, Leaver rates, Sickness rates as well as various metrics and statistics relating to Integrated Care Systems and individuals.
- Created custom SQL queries from different NHS National Data Warehouse databases to facilitate efficient Tableau connections.
Nissan (Expleo Fixed Term Contract) Oct 2021 – Mar 2023
Tableau Data Analyst
- Lead in cost reporting using Tableau and other strategic vehicle business tools
- Supported delivery of cost reduction objectives
- Provided expert support to engineers regarding sources of data, systems and processes.
- Supported other areas of the department as and when required
- Maintained of existing reports to meet evolving business requirements using Tableau.
- Managed and control cost reports using Tableau desktop/server
- Developed high quality visualisations consistent with corporate objectives
- Developed and maintained best practices in the use of Tableau
- Maintained subscriptions, data source extracts (data joins, data filters, prioritisation & refresh schedules)
- Developed customer and business requirements to create new reports, delivering simple summaries from complex source data
- Developed training material and deliver training on the use of the reporting tools
- Analysed data output to identify trends, opportunities, risks, anomalies and areas requiring action.
- Cost Data Warehouse administrator
John Henry Group (Fixed Term Contract) May 2021 – Aug 2021
Data Analyst
- Analysed, Developed and Tested Front-End and Back-End of the Costing and Bidding Control Price Model using Excel, Power Query and Visual Basic.
TLX Electrical Oct 2020 – Feb 2021
Data Analyst
- Created, Documented and maintained the automated data processes
- Produced and Tracked Key Performance indicators
- Prepared reports for Tesco mobile and John Lewis
- Created Tableau Reports and Dashboards
Deltic Group Sep 2015 – Oct 2020
Marketing Data Analyst/ Business Systems Administrator
- Created Dashboards for the different domains: goods, services, events, experiences, persons, places, properties, organizations, information, and ideas.
- Identified prospects by generating sales leads. analysing feedback responses from links to home pages, business reply cards, emails, phone calls and customer database.
- Improved customer loyalty/ reactivated customer purchases by analysing customer interests, preferences,Birthdays, anniversaries and customer metrics pathway etc.
- Supported data decision making, measured business performance, uncovered some inefficiencies in processes /people and identified problems proactively.
- Used data to uncover hidden trends, patterns, anomalies, correlations and presented the new-found information and insights in an informative way to the business stakeholders, sometimes along with recommendations.
- Analysed customer data to find opportunities for cross-selling, upselling, improving efficiency, closing revenue leakages, decreasing customer churn, targeted marketing, etc.
- Ensured that all stakeholders involved in the business got consistent information, and reliable data for processing before use.
- Reduced costs /expenditure while increasing revenues by identifying, preventing and stopping of revenue leakages.
- Tracked key metrics related to regulatory and compliance mandates that de-risked the business.
- Increased transparency that resulted in reduction of fraudulent activities by employees, customers, suppliers.
- Reduced data hoarding and reduced delays in accessing data.
- Replaced static reports with interactive dashboards and used data visualization to highlight data quality issues.
- Compiled management reports on a regular and ad hoc basis to enable Data-Driven Decision Making (DDDM)
- Supported the Business to achieve its objectives through data investigation and correlation to business activities
- Performed Data integration, analysis and interrogation using T-SQL, Tableau, Tableau Prep, Regex and Excel
- Developed and maintained operational Tableau reporting for the company’s 60 Venues
- Defined and utilised visualisation tools that can be used by non-technical users up to the executive level
- Continually improved ongoing reporting and analysis processes, automating or simplifying self-service support for 60 venues.
- Published reports and Dashboards, incorporated with Tableau Server user/ security Filters
- Ensured that the Departments maintained proper Data documentation to provide an audit trail
- Scheduled and Automated Reports that are distributed via email using Tableau tabcmd, PowerShell and Windows Task Scheduler.
- Proactively (and reactively where needed!) monitored and troubleshot datasets, dashboards and reports.
- Expert on reporting tools such as Tableau, SQL and Excel. Acted as a “go-to” person with in depth knowledge of Tableau and data visualisation practices, offering assistance and advice to stakeholders across the business
- Performed impact analysis and planned change management for Tableau related upgrades
- Tableau community involvement
SMC July 2013 – Sept 2013
Reporting & Analytics Analyst
Develop, Test and Execute Reports upon requests from Customers and Management
Gather, structure, analyse and transform data from MOVEX AS400 into requested formats.
Develop and distribute reports with SQL Server 2008 Reporting services
Develop and distribute reports with MS Access and MS Excel
Teach other workers how to use Excel including V_LOOKUP & H_LOOKUPs.
PRGX October 2012 – June 2013
Data Analyst
- Develop, test, execute and validate ETL, SSIS processes for Commercial Audit line of business
- Deploy, Backup, Achieve and test ASP. Net websites & Microsoft SSRS Reports
- Creation of transformation packages and scripts to perform effective data-transformation
- Validation of transformed data and load data to client application websites
- Identification of new tools and techniques to improve the data analysis process
- Gaining overall knowledge of client systems and work with clients to resolve data issues
- Provide advice and support to other Analysts
- Assisting the Technical Operations Manager in maintaining and improving standards of quality and timeliness in data processing
- Ensuring adherence to processes and documentation
- Ensuring that work plans are created & maintained (project management)
Other Jobs
- I have also worked in other non-data related jobs in various industries like Telecoms, Medical, Retail.
University of Bedfordshire Jan 2011 – June 2012
MSc Business Information Systems
(Dissertation) Business Intelligence for New Restaurants’ Decision Makers
- Delivering Restaurants’ Business Intelligence with Microsoft SQL Server 2008 by covering the entire BI lifecycle. Managing, analysing, and distributing enterprise data by building robust data integration (SSIS), reporting (SSRS), and analysis solutions (SSAS). Used Real-restaurant examples to illustrate all of the powerful BI capabilities of SQL Server 2008, and transforming disparate data into actionable insight for users throughout the restaurant.
- Designed and created relational data marts and OLAP cubes
- Managed Analysis Services databases using BI Development Studio
- Cleansed data (ETL) and populated data marts with SQL Server Integration Services (SSIS)
- Took advantage of the flexibility of the (UDM) Unified Dimensional Model
- Manipulated and analysed data using T-SQL, MDX scripts and queries.
- Used data mining to identify data patterns, correlations, and clustering
- Developed and distributed interactive reports with SQL Server 2008 Reporting Services (SSRS)
- Integrated business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control
Data Analysis using SPSS, R and Advanced Excel
Project Management using PMBOK and PRINCE2
MSc in Business Information Systems with the University of Bedfordshire (Commendation)
Graduate Diploma in Marketing Management (IMM)
Studied BSc Electrical Engineering (Automation) University of Maribor - Slovenia
PKMS, Oracle 10g, T-SQL, SQL Server 2008 R2 / 2012, Java,PRINCE2, PMBOK,SPSS, Advanced MS Excel 2013 including V_LOOKUPs / Pivot Tables, Power Pivot, Windows, Computer Repairs & Maintenance, MS Office 2013.
Cryptography, Computer Security, Consumer Buyer & Behaviour, First AID, Power BI, Tableau Desktop
LEISURE INTERESTS
- I have installed Developer version of SQL Server 2022, SPSS27, Python, R and upgraded RAM to 16GB on the home computer.
- Learning how to build websites and manipulate images using Photoshop.
- Computer repairs and Installations
- Watching football, Technical Reading, Chess
- My most enjoyable pastime is spending time with family and friends.
Download my CV here