Delwyn
Calcraft-Jones

IT, BI Systems Engineer, Analyst, Support, Resourceful Problem Solver

Find Out More

BI System Development

Creating & maintaining automated reporting systems from multiple sources eg API's, CRM, SQLServer etc.

Examples

IT Reporting

Creating Reports with Power BI, Business Objects, Dynamic Excel Dashboards with SQL DAX & M Query

Examples

Process Automation

Using Powershell, MS Power Automate & VBA to free Human Resources & Add Real Value.

Examples

UAT Testing & Dev

Leading Projects to Test & Develop New Systems

Examples

MS Visio – MS SharePoint

Process Mapping, Process Improvements, SharePoint Resource & Workflow

Examples

Communicator

Solid Communicator, technical & business knowledge

Examples

About Me

Resourceful
Problem Solver

With a professional & methodical approach I thrive in a pressured environment. An experienced Data Analyst, IT Support, Application testing and delivery of training, I bring an ease of communication between groups bridging those of differing technical and business knowledge.

I am a creative problem solver at heart and always open to new ideas or new perspectives when things get difficult. I relish challenges, have an endless desire to learn and master new skills and enjoy taking ownership of problems through to resolution.

BI Systems Developer

Automated reporting systems
Design, develop Á maintain.

Reporting Analyst

Power BI (DAX M-Query), Bisuness Objects (SQL),
Advanced MS Excel (VBA). Resourceful Problem Solver.

MS Visio & PowerPoint

Process Mapping with MS Visio.
Business Presentations.

Excellent Communicator

Bridging Technical Understanding with Business
Accumen with a focus on the Customer.

1st & 2nd Line Support

System & Process Training delivery
Excellent communicator.

Process Automation

Use of Powershell, PowerAutomation (MS Flow)
& VBA to utomate repetative process.

Examples of Work

Reporting

Power BI

Use of Power BI to find simple and effective ways to visually represent reports. Sometimes an trusty traditional table is usefeul but often there are more astute ways to give the bigger picture.

Power BI - M-Query

Power BI is a powerful Data Analytics & Visual tool with many out-of-the-box solutions to connect to various data sources. Knolwedge & Experience of using M-Query allows smooth massaging & data manipulation to ensure the data does what it is supposed to do.

Excel Dashboards

New Modern Dashboards provide vital monitoring for perfomance ini all areas. Live data connections used in Excel can produce fantastic resutls.

Excel - Advanced

With use of Power Pivot and advanced VBA Excel is a vital tool with an almost unlimited potential. Although more powerful software exists for specific tasks, having the understanding of what Excel can be made to do means that the main limitation is your imagination.

DAX

When using PowerPivot features of Excel or use of Power BI, being able to make advanced use of DAX language is vital for stable & reliable reports. DAX is a hugely powerful tool in the operation of these programs & getting it right not only allows for more solutions but faster and more accurate ones too.

SQL

Regardless of which data analytics software is being used, SQL is a vital tool in connecting to the relevant data source. Experience using and creating reports and sata connections with SQL is a valuable resource.

MS Power Automate

Sometimes the data you need cannot be collected by existing or traditional means, this is where Power Automate (Previously known as MS Flow) comes in. The ability to connect & monitor any Windows Network/Microsoft Function and build data banks from this maens there's a whole level of internal performance that you can keep ontop of.

VBA

Advanced use of Visual Basic allows a truley customisable use of Microsoft Applications. Manual Preparation of reports in the way 'the client prefers' is not required when automation of the finer-visual points is used.
Process Mapping

MS Visio

Microsoft Visio is a very poweful tool for building a truley intelegent map of any business process. Whether a traditional process flow diagram or swim-lane mapping proceses through various interaction points.

Time

Duration is everything. Freeing Employees from repetative manual tasks to add value to your company is the ultimate goal. Understanding what is draining the time out of your workplace is a valuable in moving forward.

Customer Journey

In any business identifying the path of least resistance to allow customer driven process to run smoothly is key. Identifying where this journey detours for often internal processes limitations is the first step to improving the customer experience.

Excel

Collaborative features of Excel allow this tool to add real value in logging and recording actual work activity. Knowing what tasks occupy your workforce is vital to understanding how the business is actually functioning.

Power Automate

A very useful tool in tracking events, Power Automate (previously MS Flow) can quietly track activity volume and detail. Whether triggered to monitor mailbox activity, Active Directory logs or many other connections, turning anacdotal conversations in to actionable data adds real value to understanding a problem.

Creative Thinking

There's always an exception to the rule. This is where adding someone with critical creative thought can offer a new perspective.

Customer Perspective

Some internal processes involve unavoidable merry-go-rounds for legal or regulatory purposes. Making sure the customer's persperctive is vital to keeping the back office is focused on the right things.

Identifying Waste

Waste can come in many forms; duplication of effort, over-compartmentalisation & paper trails, just to name a few. Is this needed? How can it be reduced? How can it be improved?.
Communicator

Training Delivery

Ensuring Training is delivered in engaging and meaningful way is important for the integrety of any given process. Often it is thought of as a basic requirement but done well, can offer insights into the understanding of working practices generally.

Supportive Environment

Communcating a change in someone's work practice is often seen & felt by the individual as a personal criticism. Keeping this in mind will be far more effective for everyone involved as the change is much easier with everyone pulling in the same direction.

Planning & Review

Planning is obviously important when delivering any meaningful training but too often overlooked is reviewing training sessions honestly. As an experienced educator I have seen first hand the various different ways that individuals engage with learning in different ways. Reviewing & Revising planning methods is vital to ensuring no one is left behind.

Creative Thinking

There's always an exception to the rule. This is where adding someone with critical creative thought can offer a new perspective.