WAKE FIT Personal training

Samuel's own fitness business. His mission statement is to concentrate on his passion: coaching clients and helping them achieve their fitness goals. Samuel practices what he preaches and applies his knowledge by competing in 'physique competitions' and other fitness challenges. He is still involved with elite level sport and performs the role of Strength and Conditioning coach for the GB Luge team. This multi faceted approach ensures he has all the tools at his disposal to work towards the clients ultimate fitness aim, whatever that may be.

Samuel currently conducts his personal training from a state-of-the-art fitness facility in central London as well as outdoor/home visits. Samuel has a diverse portfolio of clients from celebrities, actors and West-end performers to 'office based' professionals. He is also a regular writer and advisor for Men’s Fitness magazine.

Founder & Head coach

Robert Walters

Robert Walters IT Contract Division recruits Technology contractors for Financial Services and Commerce and Industry clients. We align our consultants in a vertical matrix to prioritise candidate skillsets and sector knowledge.

Robert Walters plc is one of the world's leading specialist professional recruitment consultancies with 51 offices spanning 23 countries. 

The vast majority of our competitors operate on an individual commission basis however success through team performance and a non-commision based renumeration model are fundamental values at Robert Walters, when speaking to clients and candidates or interviewing people to join my team I can honestly say that this strategy serves long term relationships.

Because every recruitment challenge is characterised by differing circumstances our candidate sourcing campaigns and solutions are designed specifically for each client.

Recruitment Consultant

Royal Air Force

Co-ordinating and scheduling chartered privately owned aircraft as part of a NATO contract to assist the military heavy lift capability.

Operations Officer (manager)

Officer

RAF- Defence Supply Chain Organisation and Management

Responsibility as part of a team to co-ordinate and plan all RAF heavy lift air movements world wide.  This involved solving complex logistics and mathmatical problems within such issues as crew duty planning, slot prioritisation and fleet management.

Airlift Task Planning

I help busy professional male leaders achieve their body/fitness goals through time efficient online coaching around their lifestyle. Fully personalised high end service achieving a guaranteed lean, fit & healthy body.

After completing my degree in Sports Science I went on to serve 10 years as an RAF Officer initially as a pilot and later as an Operations Officer. During my military career I was fortunate to work in a variety of countries in many dynamic and fast moving positions.  As a team leader I have been responsible for the welfare, training and development of subordinates as well as bearing overall responsibility for mission success. 

I left the RAF in Dec 2012 and took a role in recruitment. During this time I made the decision to follow my passion for exercise and take my fitness work fulltime. I left Robert Walters after an enjoyable year to establish my own business.

Sam Wake

AK DATA INTELLIGENCE, ANALYTICS & SOFTWARE SOLUTIONS LIMITED

QlikView, Qlik Sense Enterprise, Qlik Sense SaaS, Power BI, Kibana, Elastic Stack, Azure Data Factory

Migration of Qlik applications to Power BI.

SQL Server, Data Warehousing, Business Intelligence, ETL, Data Architecture.

Senior Consultant

HSBC

QlikView, QlikSense, NPrinting, Geo-Analytics, Power BI, Tableau, Python, R, Google Cloud Platform

Lead MI Developer (Compliance IT)

QlikView, QlikSense, NPrinting, Geo-Analytics.

Lead Qlik Developer, Financial Crime and Compliance Investigations IT

Design, development and implementation of QlikView (including NPrinting and QlikSense) technology to provide governance and MI dashboards using data from the following Global areas - 

Fraud Risk
Sanctions
Anti Money Laundering
Anti Bribery and Compliance

MI and Technology Consultant (QlikView), Financial Crime and Compliance Investigations

•	QlikView architecture, design, development and support to create KPI and Metrics dashboards. Data sources – SQL Server, DB2, Teradata, DB2, Hadoop/HIVE & Excel.
•	Development of various QlikView applications and dashboards for senior management.
•	Refresh and distribution of QlikView applications using QlikView Publisher, Management Console and AccessPoint.
•	Documenting existing legacy systems and recommending QlikView as the reporting or visualisation tool of choice.
•	Optimising the internal QlikView data model (via the table viewer) to conform to the Logical and Physical data models.
•	Integrating QlikView to Hadoop and HIVE using the Hortonworks ODBC Driver.
•	Distribute QlikView PDF reports via email and the NPrinting application
•	BCBS 239 regulatory requirements – providing data lineage and data quality capabilities using IBM Infosphere Information Server Governance Centre, IBM Infosphere Information Analyser, Global IDs, Ab Initio Metadata Hub, SAS DI Studio/Data Flux, Actian, HP Vertica and Pivotal Hawq.
•	Creation of Logical Data Architecture diagrams in order to design the ETL and data flow for SQL Server, Data Stage and Java data warehouse systems.
•	Creation and ownership of the Conceptual, Logical and Physical data models (ER and Star Schema), and DDL generation using ERWin and IBM Infosphere Data Architect (IDA) which conform to the industry standard reference models such as IBM Banking Data Warehouse (BDW) and IBM Information Framework (IFW).

Global Risk Data Integration Architect

Barclays

•	I was the  QlikView and SQL Server BI/MI Lead Developer for global Market, Credit and Contingent Risk
•	QlikView architecture, design, development and support to create various Risk KPI and Metrics dashboards.
•	ETL design and development using SQL Server 2008r2, MS BI Stack SSIS and T-SQL
•	C# design and development. For example, console application to remotely execute QV tasks using EDX methods and classes.
•	Development of ASPX C# web pages for reference data maintenance.
•	Design and development of multiple AutoSys schedules
•	User support during UAT and general out of office UAT and Production support.
•	Agile software development using Scrum.

QlikView Developer - Market, Credit Risk and Contingent Risk BI

Unipart Technology Logistics

Working on the Mobile BI team specifically on the Vodafone Account.
Establishing QlikView templates and best practices.
Design and development of QlikView dashboards, scorecards, KPI and other reports using all the charts and
GUI features available in QlikView.
Extraction of data from SQL Server 2008r2 databases using SSIS and T-SQL. Extracted data stored in QVDs.
Deployment and administration of production QlikView reports and environment using QlikView
Management Console and QlikView AccessPoint.
Develpoment using Set Analysis, QlikView functions and QlikView scripting.
Connecting to OBDC and OLEDB data sources.
Analyse business needs for Dashboards and other QlikView solutions.
End-to-end design and implementation of QlikView solutions.

QlikView Designer Developer - Logistics and Mobile Telecommunications BI (Vodafone Account)

Next Group PLC

•	Developed and maintained 50+ SQL Server 2008/2008r2 SSIS ETL Packages.
•	Developed and maintained 50+ SQL Server 2008/2008r2 SSRS Reports. Data extraction using T-SQL, stored procedures and MDX. KPI analysis using Dashboards.
•	Developed 100s of T-SQL stored procedures, functions, views, DML scripts and data migration scripts.
•	Prototyping reports in Qlikview Personal Edition v11. KPI analysis using Dashboards.
•	10% of time working closely with Business Users and other stakeholders.
•	Developed Dynamic SQL to execute via stored procedures and executed open query MDX via stored procedures using linked servers.
•	Assisted in the design of the data warehouse.
•	Developed an overnight backfill data update process using SSIS and stored procedures to update a 1.2 billion row Fact table.
•	Assisted in the development and maintenance of SSAS OLAP Cubes. Maintenance, deployment, reprocessing and synchronising Production and DR cubes.
•	Production of test plans & systems documentation to Company & Project standards.
•	Development phases using Agile and Test Driven Development techniques.
•	ETL from Oracle/Informix legacy systems to SQL Server.
•	Migration of Oracle/Informix DB, Tables, SPs etc to SQL Server.
•	Migration of BOXI reports to SSRS.
•	Creation of SQL Agent jobs for batch processing / production job scheduling.
•	SQL Profiler for Query Optimisation.
•	Visual Studio 2008/2010 C# development 
o	Create APSX web pages to interrogate and manipulate database tables.
o	Create interfaces to IBM MQ data to retrieve messages from queues.
o	Create Windows Services
•	Support of Live Production systems during office hours.
•	Some Managed Data Services, PowerPivot and Report Builder 3.0 experience
•	Some SQL Server 2012 experience.
•	Source control - Visual Source Safe and Team Foundation Server.
•	Business areas – Business Intelligence, Retail, Sales, Manpower.

Business Intelligence Data Warehouse Developer (Retail BI)

Credit Suisse

•	I was the Equities, Securities Lending, Business Intelligence SQL Server BI/MI Lead Developer for EMEA, Prime Services
•	Developed and maintained 100s of SQL Server 2005/2008/ SSIS ETL Packages.
•	Developed and maintained 50+ SQL Server 2005/2008 SSRS Reports. Data extraction using T-SQL, stored procedures and MDX. KPI analysis using Dashboards.
•	Developed 100s of T-SQL stored procedures, functions, views, DML scripts and data migration scripts.
•	Assisted in the development and maintenance of SSAS OLAP Cubes. Maintenance, deployment, reprocessing and synchronising Production and DR cubes.
•	Assisted in the Analysis, Design & Implementation of Kimball compliant Data Warehouse
•	Prototyping reports in Qlikview Personal Edition v10. KPI analysis using Dashboards.
•	25% of time working closely with Business Users and other stakeholders.
•	Coordination of offshore development and testing teams in India and America.
•	Control-M job design, development, testing and support. Developed and maintained 2 Control-M schedules which consisted of 250+ jobs with cross server in and out conditions.
•	24 hour fix on fail live service 3rd line production support.
•	Migration of Microsoft Access system to SQL server.
•	Production of test plans and other systems documentation to Company and Project standards.
•	Development phases using Agile and Test Driven Development techniques.
•	Visual Studio 2005/2008 C# development 
o	Create APSX web pages to interrogate and manipulate database tables.
o	Create a build process which produces on DB script based on a build manifest.
•	Responsible for the team version control using Rational ClearCase and Subversion SVN (Tortoise). Creation of branches, labels, tags and config specs.
•	Business areas – Business Intelligence, Prime Services, Securities Lending, Rehypo, Counterparty Risk, Transfer Pricing, Product Control.

Business Intelligence Data Warehouse Developer - Prime Services / Front Office Secuties Lending BI

•	Conversion of SQL Server 2000 DTS to SQL Server 2005 SSIS
•	Analysis, Design & Implementation of Kimball compliant Data Warehouse
•	Developed & maintained 100s of SQL Server 2005/2008/ SSIS ETL Packages
•	Developed & maintained 50+ SQL Server 2005/2008 SSRS Reports. Data extraction using T-SQL, stored procedures & MDX. KPI analysis using Dashboards
•	Developed 100s of T-SQL stored procedures, functions, views, DML scripts & data migration scripts
•	Development & maintenance of SSAS OLAP Cubes. Maintenance, deployment, reprocessing & synchronising Production & DR cubes
•	Creation & maintenance of 100s of business user reports using QlikView Professional & Enterprise
•	Installation of QlikView Publisher on VM & App servers
•	Creation & maintenance of batch job schedules using QlikView Publisher
•	Supported the Architects in the design of the BI solution so that it conforms to standard Data Warehousing principles i.e. Kimball Methodology 
•	Coordination of offshore development & testing teams in India & America
•	30% of time working closely with Business Users & Senior Management on a daily basis to gather requirements & to produce prototype reports. Worked with Business Users to convert their SQL into Adhoc reports
•	Developed migration scripts & DTS/SSIS packages from Oracle & Sybase to SQL Server
•	Visual Studio 2005 C# development of APSX web pages to interrogate & manipulate database tables
•	Create a build process, which produces on DB script based on a build manifest
•	Production of test plans & other systems documentation to Company & Project standards
•	Assisted & lead System Testing, User Acceptance Testing (UAT) & Operational Acceptance Testing (OAT) support across continents & time zones
•	24-hour fix on fail live service 3rd line production support
•	Responsible for the team version control using Rational ClearCase. Creation of branches, labels & config specs
•	Business areas – Trade & Product Control, Exposure & P&L Reporting, Counterparty Risk

Business Intelligence Data Warehouse Developer - Middle Office Commodities Trading BI

Prudential Assurance (Formerly Egg Bank)

•	Developed PL/SQL / SQL Objects & Scripts: SQL*LOADER, External Table, Meta Data, Packages, Procedures, Cursors, Autonomous Transactions, Functions, Sequences, Triggers, Database Links, Views, Materialized Views & Logs, DB Links, DBMS Jobs & scheduling, Data Correction SQL scripts, DDL & Tablespace creation scripts.
•	Used Oracle 9i, PL/SQL, SQL, SQL*PLUS, , SQL*LOADER, TOAD 7.5.2.0, PVCS, Oracle Enterprise Manager, Tera Term & FTP 
•	Used messaging technology & packages for Oracle Advanced Queues & XML.
•	Provided technical skills in order to prove the Egg business departments with a consolidated view of all its customer data in a single repository.
•	Have gained financial sector business knowledge. This includes life insurances (PPI e.g. Accident, Sickness & Life), general personal insurances (motor, home, travel), pensions (AXA life), mortgages (Prudential), credit cards (Boots, MasterCard), personal loans, savings, investments & the BASEL II implementation.
•	Coding, Unit / System testing & delivery of the following functionality - Egg Money Manager (EMM), Trigger & Spend data marts, OMIGA data feed, UKI Motor Web & Phone Quotes Backfill, MasterCard CMF, MasterCard SQL*LOADER control files, CIC SQL*LOADER control files, BACS, DCM, AXA Home / Travel / Motor Quotations & Policies, Contact Address data cleansing & formatting.
•	Basic Unix shell scripting – calling SQL*LOADER another Oracle scripts.
•	Data Migration from legacy systems to new Management Information system using PL/SQL & SQL*LOADER.
•	Have used BusinessObjects 5i & 5.1 to produce client specified universes & reports. Technical scope as per BP (see above).
•	I have also produced supplementary Analysis documentation which has been incorporated into the master specification by the team’s Business Analysts e.g. BACS & Trigger Mart
•	Produced the PL/SQL coding standards & other project related quality & process documentation
•	Coached & mentored new members of staff

Business Intelligence Data Warehouse Developer - Retail Banking BI

Capgemini (Formerly EDS)

•	Designed, developed, tested & delivered Cool:Gen & Advantage:Gen (V5 to V6.5) GUI & Batch functionality.
•	Built PL/SQL (using TOAD) & Unix batch functions using Oracle parallel processing and Unix Shell scripting.
o	Writing code with effective and appropriate SQL hints
o	Writing code using both the rule-based and cost-based optimizer
o	Writing code using the many built-in functions
•	Performed the role of Project DBA (using TOAD and DBA Studio) for 2 years on a NT and UNIX platform.
o	Maintaining the Oracle Database on a Unix Server Environment including File and Disk Management
o	Performing Backup and Recovery tasks
o	Installing Oracle on Unix and Windows NT
o	Creating a Parallel Oracle Database
o	Configuring Net8 Clients
•	Used SQL*LOADER extensively to load data from flat files.
•	Built, tested & delivered Oracle Based batch functions in an NT and Unix Tuxedo environment using the Maestro scheduling tool.
•	Mentored and coached Graduates and other permanent members of Staff.
•	Performed the role of Technical lead, which has included the use of ‘best practices’.
•	Led teams of up to 12 people to deliver business critical Oracle based software.
•	Produced analysis and design documentation for development teams.
•	Been involved the Oracle 9i validation project
•	Been on 24 hour fix on fail call for all the functions produced by the project
•	Integrated calls from Advantage:Gen code to Oracle based PL/SQL and C code.
•	PL/SQL / SQL Objects developed: SQL*LOADER scripts, External Table scripts, Packages, Procedures, Functions, Sequences, Triggers, Database Links, Views, Data Correction SQL scripts, DDL scripts and Tablespace creation scripts
•	Unix Scripting objects developed: File handling, text manipulation, job scheduling, SQL*LOADER Unix scripts, oracle script management (passing parameters to oracle scripts).

Business Intelligence Data Warehouse Developer - Taxation BI / DBA

Intec Systems

•	Developed and maintained many GUI Client Server and Batch applications which have utilized many new features of Cool:Gen and used third party software such as Sheridan’s calendar and tab OCX controls.
•	Ported the Cool:Gen code to various UNIX environments such as HP, Compaq, Sun and Sequent.
•	Installed Composer and Cool:Gen software on Windows NT, HP UNIX, Sun, Sequent and Compaq environments.
•	Built many PL/SQL and Unix batch functions using Oracle parallel processing and Unix Shell scripting.
•	Lead a team of six to develop, install and support the production version of InterconnecT – this has involved a great deal of technical coaching and mentoring especially with the Graduate Trainees. 
•	Been responsible for the data model management for various releases of the InterconnecT product. 
•	Involved in the writing of GUI, Quality Assurance and Installation standards for Interconnect product.
•	Been involved in the worldwide systems installation, support and maintenance division.
•	Development of GUI client server applications using Java 2 with Swing, JDBC, RMI and CORBA.
•	Performed the role of Oracle 8i DBA for 9 months. This has involved 
o	performing daily start up and shutdown tasks
o	creating instances, databases and users
o	monitoring data file sizes and efficiency
o	managing users and there resources
o	performing exports, imports and backups
•	PL/SQL / SQL Objects developed: SQL*LOADER scripts, External Table scripts, Packages, Procedures, Functions, Sequences, Triggers, Database Links, Views, Data Correction SQL scripts, DDL scripts and Tablespace creation scripts

Analyst / Developer - Telecommunications BI / DBA

Email: amit_p_kakkad@yahoo.co.uk

Passionate about Data!

Skills 
   - Power BI (Desktop, PBI Service, Apps, Reports, Dashboards)
   - QlikView, QlikSense, NPrinting, Geo-Analytics
   - Qlik Certified Business Analyst & System Administrator
   - Qlik qualified Data Architect
   - Eslatic Certified Data Analyst
   - Eslatic (accreditations in Observability, Security, Enterprise Search)
   - Google Cloud Business Professional Accreditation
   - SQL Server, Oracle, HIVE
   - Data Architecture & Data Modelling

taplio

The Battle

Sam Wake

Amit K.

Followers

Posts

Engagements

Likes

Ready to grow your LinkedIn presence?