Back to the listing
John Russell C.

Consultant

615 dollar
Freelancer
6 years
Bristol, UNITED KINGDOM
DAX Microsoft Excel Microsoft SQL Server Power BI SSIS SSRS T-SQL

My experience

More

Agylia Group LtdMay 2019 - June 2019

Upgrading and refreshing the learning material for the online edX Power BI course title ``Analyzing and Visualizing Data with Power BI''. New features are frequently being released for Power BI, so this bit of work involved the upgrading of video transcripts and learning exercises for the edX Power BI course. It covered a wide spectrum of Power BI topics mainly categorised into Power BI Desktop Data Transformations, Power BI Data Modelling, DAX, Power BI Desktop Visualisation, Power BI Service, Data Connectivity, Developer API; Mobile APP.
More

Enterprise DNAJanuary 2019 - May 2019

In Jan 2019 I enrolled on the Enterprise DNA Membership giving me unlimited access to its Power BI courses & resources. Since then I have been building and reverse engineering Power BI Dashboards and writing DAX formulas for Advanced Business Analytical Scenarios. Some examples of topics covered include advanced data transformation & modelling; advanced analytics in Power BI; solving business scenarios with Power BI; segmentation and grouping; time intelligence; financial reporting templates; cohort analysis; budgeting & forecasting, what-if scenario analysis; advanced DAX formula combinations. Along the way I've also been preparing a Dashboard Toolkit which incorporates things such as best practices, models, DAX patterns and template Dashboard solutions.
More

Consolidata LtdSeptember 2018 - November 2018

Overview the Month End Financial Reporting project and define the big picture BI architecture. Reviewing BEAM specifications and building Stage and Data Warehouse schema. Building SSIS packages for the loading of Oracle finance data into the SQL Server DW, and for the initial Staging of data. SSIS packages designed with `best practices' providing templates for going forward. Defining & building SSAS cubes (Tabular Model) and writing
DAX formulas if needed. Deploying the cubes to the SQL Server Analysis
Services in preparation for Power BI connection. Pulling the cubes into Power
BI Desktop and building Dashboard reports. Saving the Power BI reports as a temporary (.pbit) files, and then publishing them to the Power BI Report
Server. Recommending best practices in terms of architectures, models, templates and approaches. Using Visual Studio/TFS as the IDE and for SSIS/
SSAS source code management. Attending regular team meetings.
More

Toyota Motor EuropeFebruary 2018 - March 2018

Analysing and investigating into a required Power BI Dashboard solution for Toyota used to report on ServiceNow KPI/Metrics in `near' real time. Reviewing and refining exisiting KPI/Metric specifications, and analysing and modeling business data. Prototyping data models and visualisations in the Power BI
Desktop tool. Recommending best practices with Power BI architecture in terms of performance, robustness and scalability. Working with IT members to resolve an error with the Enterprise Data Gateway, and investigating into the limitations of Direct Query connetion mode in Power BI when using the Query Editor. Other duties included publishing reports to the Power BI Service, setting-up data gateways and refresh schedules, collaborating with team members. Keeping the SharePoint project folder up-to-date with relevant documentation.
More

HftSeptember 2017 - January 2018

This project involved the building and modelling of a MI Dashboard solution in SQL Server BI technology (SSMS, SSRS, SSIS, T-SQL), with the initial design spec being proposed by HFT. It was about defining and building a MI Dashboard architecture that meets the immediate reporting needs of the business (Payroll, Finance, Budget, HR), and which provides a `template'
solution for additional report development i.e. the agile build & slot-in of reports. Involving most aspects of Dashboard development including data story telling, ETL, datasets, parameters/stored procedures, charts, tablix, calculated expressions, drill-down, drill-through, JavaScript, navigation, regional and divisional levels of abstraction. Also the coding of Procedures, Functions and Views in T-SQL in order to shape and prepare data for Dashboard visualisations. Working closely with the IT project manager, and key business users in order to gather, define and clarify business reporting requirements.
More

Data IntegrationNovember 2016 - June 2017

Assigned to four different projects with duties involving the modelling. designing and building of SQL Server KPI data marts, ETL SSIS packages, SSRS reports and the coding of T-SQL procedures & functions. Using Visual
Studio and TFS for the Integrated Development Environment. Attending regular meetings and leasing with team members and business users in BI requirements analysis.
More

Shaw-TrustJune 2016 - November 2016

Shaw-Trust is a national charity formed in 1982 providing employment opportunities, skills development training and health and well-being services. I was employed to provide BI analysis, design and development services to these clients

MPS SES BI

Modeling, designing and building the MPS SES BI solution for the Shaw-Trust SES Program. Following the Agile BI Development methodology and working on all parts of the BI Function including data staging, data mart, ETL SSIS, predefined SSRS, and self-service Power BI. Liaising with management in reporting requirements analysis and attending regular transformation meetings. Reviewing the BI Strategy of the company and advising on possible BI architectures, tools and best practices which meet the initiatives of the business. Road mapping the stages and tasks of the BI project and allocating work to another BI Developer team member.

Technical snapshot: 

Zachman, SharePoint, Agile DW, Jira, Kimball, SQL Server, SSIS, SSRS, Power BI, T-SQL, Excel, PowerPivot, PivotTable, Procedures, Functions, Views

More

Wessex WaterJune 2016 - November 2016

BI Developer / Data Integration Wessex Water is the regional water and sewage treatment business serving an area of the South West of England and supplies 1.3 million people with around 285 million litres of water a day. I was employed to provide analysis, design and development services to these clients.

MI Reporting, WAMR78, CX Measures & Metrics, Water 2 Business Assigned to four different projects with duties involving the modelling. designing and building of SQL Server KPI data marts, ETL SSIS packages, SSRS reports and the coding of T-SQL procedures & functions. Using Visual Studio and TFS for the Integrated Development Environment. Attending regular meetings and leasing with team members and business users in BI requirements analysis

Technical snapshot:

Zachman, SharePoint, Agile, Trello, Kimball, Visual Studio (with TFS), SQL Server, SSIS, SSRS, T-SQL, Excel, Procedures, Functions, Views

More

KCOM Group PLCApril 2016 - May 2016

Investigating the workflow, systems and data usage of various KCOM business processes in order to locate the MI data needed for KPI reporting. Frequently engaging with internal stakeholders during the investigation, and analysing source databases to identify table fields in focus for DW design. Building the staging and reporting schema for the CSO North DW, and using T-SQL
and SSIS to maintain and expand it with data. Modelling and building Excel
PowerPivot reports for users to include pivot tables, pivot charts, and SQL data refresh scripts to run off the DW. Hosting the Excel reports on SharePoint with descriptions and data refresh timings.
More

hoppaSeptember 2015 - December 2015

Overhaul developing Hoppa's old TGRS reporting system into the Microsoft
Power BI Cloud. Liaising with key users to analyse, elicit and document reporting requirements. Performing data mappings in preparation for DW and ETL design. Designing dimensional models (Star Schema) for the Azure
DW, and assisting in the development and automation of the ETL data refresh involving SSIS/T-SQL and Excel PowerQuery datasets. Using the Power BI Desktop tool (and Power BI Cloud) to model, design and build reports and dashboards consisting of data models (datasets), calculated columns, visualisations, charts and maps. Establishing best approaches and architectures for the BI Function, at the same time as identifying limitations with Power BI technology. Overseeing general BI project management, and having regular meetings with Senior Management on project progress.
More

WiproDecember 2014 - May 2015

Using UML standards and notation to reverse engineer the existing PPS
Metals system used by Outokumpu in Steel production and planning.
Outokumpu applications map onto ISA-95 Level 2, Level 3, and Level 4 systems. These applications interface with each other and are built from various technologies including Oracle, Java, SQL Server. Modelling the business Workflow architecture and associated application Use Case functionality. Analysing applications, database schema and tracking PL/
SQL source code. Identifying application pain points and recommending systematic improvements. Attending meetings with subject matter expects and participating in knowledge transfer sessions online.
More

Volt Europe LtdSeptember 2014 - November 2014

MI reporting requirements analysis followed with proposing various architectures for the Volt MI Reporting System as required to support business initiatives. Re-modelling old Excel worksheet data into PivotTable models and defining data transformation requirements. Using Excel to build PivotTable reports with multiple groupings, calculated items, calculated fields, filters, slicing, and custom subtotals. Automating PivotTable functionality with VBA triggers and procedures.
More

EDF EnergyFebruary 2014 - August 2014

Support investigation into key problem areas within B2B and work with key business experts to deliver valuable analysis and reporting. Develop and automate new reporting tools as required to support B2B initiatives and projects. Trouble-shooting issues with reporting tools and supporting reporting solutions used by the business. Specifications implemented in Access and Excel involving the building of tables, queries, reports, forms and VBA procedures. Access and Excel integration with connections to various databases such as SQL Server, Oracle and data warehouses.

Alarqaa Training & Development
More

Alzarqaa Training & Development, Riyadh, KSASeptember 2012 - November 2013

Alzarqaa Training and Development is a training institute in Riyadh that specialises in providing courses in IT, Business and English subject areas. I was employed to provide EFL instruction and IS related services to these clients. 

Achievements:

•    Modelling business data architecture

•    Recommending improvements to business systems & applications.

•    Planning, teaching and assessing CELTA & IELTS English lessons

Technical snapshot: 

Zachman, Visio, Access, Excel, e-Learning, Interactive WB, Classware, Flow!Works


More

Frankfurt Am Main AreaSeptember 2011 - February 2012

European Central Bank
Data Modeller, MI Developer
Frankfurt Am Main Area,
Modelling, designing and building the Package Deployment reporting database used in the Ms Office 2010 Upgrade Project to monitor and administer the deployment of Office 2010 applications and to generate MI reports on project progress. Using the Visio tool in data usage analysis, workflow modelling and database design. Building and automating the Package DB Reporting Tool in Access and VBA. Upgrade fixes made to old VBA to ensure Excel and Access applications integrate and function successfully in the new Microsoft Office
2010 suite,
More

European Space AgencyFebruary 2011 - August 2011

Maintaining the existing CoCKPIT Reporting Tool built in Ms Access and used by management to generate MI reports on systems configuration, incidents and change requests. Using the Assyst tool in incident management and Visio in systems problem solving. VBA modifications made to the ETL data refresh, executed nightly against an Oracle database in order to extract data, transform it, and then load it into the Access CoCKPIT Reporting Tool. Building new reports and forms as specified by user change requests. Specifications implemented in Access involving the building of tables, queries, reports, forms and VBA procedures. VBA modifications also made to existing Excel reports.
More

LTGD, London, UKAugust 2008 - September 2009

The London Thames Gateway Development institute for Sustainability (the Institute) is an independent, private sector led charity created to significantly advance the UK’s ability to deliver solutions for a sustainable future. I was employed to provide analysis, design and development services to these clients.

IfS Program Management System

Modelling, designing and building the IfS Database System for the IfS Program Management System used to administer and monitor close-to-market collaborative research and demonstration projects. Using the Visio tool in requirements analysis, data usage analysis, and database design. Specifications implemented in Access involving the building of tables, queries, reports, forms and VBA procedures. 

Achievements:

•    Modelling the data architecture of the IfS Project Management System.

•    Developing an Access ‘IfS Database System’ for MI reporting.

Technical snapshot:

Zachman, Visio, EER, Access, Excel, Forms, Reports, SQL, VBA, Triggers, Functions, Procedures

More

SimplySeptember 2008 - July 2009

A financial recruitment specialist for Media and Marketing services. I was employed to provide analysis, design and development services to these clients.

Recruitment Database System

Modelling, designing and building this required Recruitment Database System, used to administer the placement of finance staff to Media and Marketing clients, and to calculate their associated salaries, fees, discounts, % vat, etc. Using the Visio tool in requirements analysis, data usage analysis, workflow and database design. Specifications implemented in Access involving the building of tables, queries, reports, forms and VBA procedures. 

Achievements:

•    Modelling the data architecture of the business

•    Designing a database with extended ER schema (EER)

•    Building an Access Recruitment Database System 

My stack

Frameworks

Oracle Forms

Analysis methods and tools

Requirements Analysis

Other

MI Developer, the Assyst, EFL Instructor, MI Reporting Developer, Reporting Developer, Data Modeller, Senior BI Developer, Developer API, Power BI Dashboard Developer, Power BI Developer, Zachman Framework, general BI project management, valuable analysis, DW design, Agile BI Development, SSIS/ SSAS source code management, Scenario Analysis, Practical Skills, Oracle Manufacturing, Power BI Consultant, Mobile Applications, Data Warehousing, Data Architecture, CRUD, Microsoft Visio, SQL Server Analysis Services, Microsoft Team Foundation Server, Microsoft Transact-SQL, Bachelors Degree, Visual Basic for Applications, cohort analysis, Data Mapping, Microsoft Office, Oracle Designer 2000, Oracle Workflow, Microsoft Access, Microsoft Visual Studio, Knowledge Transfer, industry~it, Masters Degree, English, Analyst, UML/OMT, BI DEVELOPER, DNA Membership, Masters Degree > Master of Science > Master of Science Management, CELTA, Data Modelling, Masters Degree > Master of Science > Master of Science Strategic Information Systems, Analyst modelling, Pivot Tables, LinkedIn, Bachelors Degree > Bachelor of Science > Bachelor of Science Business, O Levels/Grades, Dashboard development, Oracle Report, Systems Development, IELTS, Systems Analyst, Incident Management, Microsoft PowerPivot, DBMS

Computer Tools

Microsoft Excel

Technologies

Oracle Financials

Languages

JavaScript, Oracle PL/SQL, Java, T-SQL, SQL

Application servers

Microsoft SharePoint

Business Intelligence

SQL Server Reporting Services, ETL, Power BI, SSIS, DAX, SSRS, SQL Server Integration Services

Others

SDLC, Analytics, Database Design, Troubleshooting, Problem Solving

Databases

Microsoft SQL Server, Oracle

My education and trainings

Master of Science, Strategic Information Systems, Management - Griffith University2003 - 2004

O Levels/Grades, English, Maths, Science, Geography, Accountancy - Sandringham High School1981 - 1986