TECHNICAL SUMMARY

Sukhminder is a SQL Developer with more than 18 years of experience in IT and currently specializing in Systems Development, Data Analysis and Presentation using the Microsoft Stack. He started working with SQL in 1999, when he joined Bank of Scotland as a graduate intake. He has been working with Microsoft SQL Server since 2002. He has worked predominantly within the Finance and Insurance sector over his career span. Most recently he has worked as a BI Consultant in the RAC Groups Corporate Partner and Insurance Team, specializing in SQL Server and using 3NF, Boyce-Codd Normal Form and Ralph Kimball’s data modelling frameworks. In addition, he is highly competent and has a good artistic temperament when using Reporting/Data Visualization software including Reporting Service, Power BI, Tableau etc. SUKHMINDER SINGH

KEY SOFT SKILLS

Time served with Microsoft’s BI stack for ETL, Analysis and Reporting, namely using Integration Services (SSIS), Management Studio

(SSMS), SQL Server Analysis Services (SSAS), Reporting Services (SSRS) and Power BI (Data Extraction, Modelling, Visualisation).

Database specialism is in MS SQL Server (Transact SQL), whilst also competent across other platforms, including Oracle, Teradata, Sybase, and Microsoft Access.

For agile application development, competent in using MS Access, InfoPath, Master Data Services and SharePoint in Integrated Mode.

In addition to his experience with SSRS and Power BI for Data Visualistion, competent with Crystal Reports for Traditional/Linear Reporting and Spotfire for Dashboard Reporting. Some knowledge of Tableau, QlikView, Cognos and always keen to learn new tools.

For data Extract, Transform, and Load (ETL) purposes, competent in the use of SSIS (DTS) and Linked Servers. Time served with High Volume Data Loads, Transformation and Reconciliations. Familiar also with several best practice SSIS design patterns for BI.

For scheduling of the ETL process, competent using main stream tools such as SQL Server Agent, Task Scheduler, and AutoSys.

Experienced using Team Foundation Server (TFS) for Database, SSIS and SSRS Projects as well as SharePoint for collaboration, integration, and use with the Microsoft BI Stack. Open to other source code management tools i.e. GitHub, SourceForge, Kiln etc.

Having studied and practiced PRINCE2, understands the importance of project prioritisation, lifecycle planning, and documentation.

An effective communicator, confident in conversation, and articulate with the written word.

Proven team player with a leadership bias towards coaching, keen to take on new challenges, very much hands-on, yet able to ensure effective delegation.

Experienced and confident in undertaking workflow/process reviews, documentation, making recommendations and following through to completion.

Experienced working on both strategic and time-critical tactical projects. CURRENT EMPLOYMENT HISTORY

Position Term

Employer / Company

Availability / Notice

Reason for Leaving

Nationality

Education

Contract

Data Management and Assurance (DM&A), RAC Group, Bradley Stoke, Bristol Immediate

Completion of Project.

British (United Kingdom)

2:1 BA Honours Degree in Economics & Business Studies PREVIOUS EMPLOYMENT HISTORY

RAC Group (Insurance)

Royal Bank of Scotland (Finance)

Lloyds Banking Group (Finance)

Mueller Group (FMCG & Logistics)

Access Accounting Group (Finance)

CAT Solutions Ltd (Telecoms)

HBOS Banking Group (Finance)

Jun ‘14 – Sep ‘16

Oct ‘11 – Mar ‘14

Sep ‘10 – Sep ‘11

Dec ‘08 – Sep ‘09

Nov ‘07 – Oct ‘08

Jun ‘06 – Sep ‘07

Sep ‘99 – May ‘06

Contract

Contract

Contract

Contract

Permanent

Permanent

Permanent

EXECUTIVE SUMMARY

3 Wergs Drive, West Midlands WV6 8TZ ● 24 Summersby Road, London N6 5UH (079-***-***** acxk1u@r.postjobfree.com

3 Wergs Drive, Wolverhampton, West Midlands (079-***-***** acxk1u@r.postjobfree.com SUKHMINDER SINGH

SUMMARY EXPERIENCE & ACHIEVEMENTS

A highly competent Data Warehouse and SQL Developer, specialising in the Microsoft BI Stack. Tenured in respect to the design, development, and deployment of cost effective, well written, and robust solutions across different organisational models. Well-versed in prioritising and delivering to business needs, working against tight deadlines, and frequently exceeding expectations whilst under pressure. In terms of BI deliverables to the end customer, competent with an array of technologies, including Reporting Services, Power BI, Spotfire, Tableau and Crystal Reports as well as self-serve deployments, such as OLAP cubes and localised Data Marts. Finally, whilst strong technically, a real people person at heart, with good team ethics and the ability make significant and positive contributions from day one. MICROSOFT SQL DEVELOPER AND BI SPECIALIST

PROFESSIONAL QUALIFICATIONS

Economics & Business Studies 2:1 SEP 1997 - JUL 1999 BA with Honours

University of Wolverhampton – Telford, Shropshire

HND in Business Studies SEP 1995 - JUL 1997

University of Wolverhampton – Telford, Shropshire

A Level Economics & Business Studies SEP 1992 - JUL 1994 South Birmingham College – Birmingham

GCSE Studies including Maths & English SEP 1998 - JUL 1992 Manor High School – Birmingham

PROFESSIONAL SKILLS

Ms SQL Server

Ms Reporting Services

Ms Integration Services

Ms Analysis Services (OLAP/MDX/DAX)

Ms Power BI (via Desktop or MS Excel)

Ms Team Foundation Server

Ms Share Point

Ms Access

Ms Excel

Enterprise Data Store Dev (3NF/Codd)

Dimensional Data Store Dev (Kimball)

Programming (VB/C#/Powershell)

Oracle / Terdata / Sybase

Tableu

QlikView, Spotfire, Crystal Reports

BI Developer JUN 2014 - SEP 2016

Data Management & Assurance, RAC Group (Bristol)

Worked on the Design, Development and Maintenance of an Enterprise Wide Data Warehouse using 3NF and Boyce-Codd, maintaining both Sales and Service Delivery Operational Stores.

Developed several Data Marts from the Operational Stores using the Kimball Framework and for the purpose of Reporting and Self-Service via the deployment of OLAP cubes.

Liaised with Business Representatives, Data Consumers, Business Analysts, Developers, and Architects to ensure all requirements were within scope of the Data Warehouse Project and the wider RAC Information Management Strategy.

Key applications used daily include Microsoft Management Studio, Integration Services for ETL/ Workflow Management, Reporting Services (SSRS) and Power BI for Data Visualisation, Analysis Services (SSAS) and Team Foundation Server (TFS).

Other recent activities included the shredding of XML and XSD Validation, the use of SQL CDC the deployment of Reporting Services and Performance Point Dashboards via SharePoint, the use of InfoPath and Master Data Services and MS Access as a GUI for Reference Data Enrichment by End Users. BI and RAD Developer OCT 2011 – MAR 2014

Middle Office Risk Team, RBS Group Plc (London City)

Agile Reporting, Data Analysis, and Application Development within a Middle Office Risk & Control Team. Responsible for the provision of BI and application Development across global desk analysts and for management, as well as for external Regulatory and Benchmark submissions to ISDA, FED, the FCA, and Market Watch.

Developed an in-house FIX Message DataMart, translating FIX Messages in near real-time, which allowed downstream analysis and reporting. The DataMart was developed and used across Europe, Asian, and North America Middle Office Team and integrated with a Risk Scoring Platform for use by Front Office Analysts.

Managed a program of work to the reverse engineering of several high risk and business critical VBA centric solutions, written in MS Excel and MS Access, in addition to harmonising several desperate SQL platforms onto the Microsoft Stack.

The ETL and Workflow Management aspect of this role was performed, using SSIS, and involved dealing with data from multiple platforms, including Microsoft SQL Server, Oracle, Sybase, Web Services, and multiple flat files formats. The scheduling of tasks was done using SQL Server Agent and a similar tool, called AutoSys.

Data delivery included the deployment of traditional reporting in Reporting Service (SSRS), OLAP Cubes for Self-Service, Dashboards using Tibco Spotfire and files to FTP/SharePoint Locations in Excel, Flat File, and XML format.

Finally, MS Access and InfoPath, coupled with SharePoint and SQL Server backend, were utilized for the agile development and deployment of several solutions for data entry into a transactional (normalised) database.

PROFESSIONAL EXPERIENCE & ACHIEVEMENTS (CONTINUED) RAD and MI Developer, Finance SEP 2010 – SEP 2011

Lloyds Banking Group Plc (London City)

Agile System Development and Report Writing for one of the UK’s largest Branch Integration Programmes of Work. Working alongside certified accountants, the position involved being the lead developer, responsible for creating a platform to allow reconciliation of large volume P&L Balances post system’s migration. Resolution of any differences required working with an off-shore team, based in India.

The systems development work primarily involved using MS SQL Server 2008 and Integration Services (SSIS). Source data was being analysed from multiple systems, including TeraData, MS SQL, Oracle, and flat file extracts from AutoRec.

Presentation of data was performed using MS Excel and SSRS, with stakeholders accessing reports online and via scheduled emai ls.

The role also required some database administration (DBA) responsibilities, including setup/management of Scheduling Backups, Indexing, Updating Statistics, User Permission, and so forth within the MS 2008 environment. BI Developer, Culina Logistics DEC 2008 – SEP 2009 Muller Group Plc (Staffordshire)

Responsible for the deployment of Crystal Reports Enterprise Server and Reporting within the 24hr logistics operation at Mueller Group.

Tasked with training staff to use a new reporting environment and move from using manual extracts run against an Oracle Database.

Responsible for automating the process of data extraction and load (ETL) from Oracle, SQL, and other flat file formats using SSIS.

Responsible for developing, correcting, and migrating to SQL Server 2005 several business critical MS Access and Oracle databases. IT Consultant NOV 2007 – OCT 2008

Access Accounting Group Plc (Harpenden)

Field consultant role involved the deployment of an Accounting and Finance System at client sites, requiring travel across the UK

Project management and systems development, using SQL Management Studio 2005, DTS, Crystal Reports, and Microsoft Project 2003.

Work on-site typically involved dealing with the organisation’s Head of Finance, setting pre-migration and post-migration milestones.

Data cleansing and migration onto SQL undertaken using Data Transformation Services (DTS), SQL Management Studio, and MS Access.

SAP Business Objects Crystal Reports used for all Statutory, Management Accounting, and general Management Information Reporting.

Finally, as part of the consultancy’s service offering, when required, was responsible for providing Access and Crystal training onsite. IT Analyst/Consultant JUN 2006 – SEP 2007

CAT Solutions Limited (Chester)

Small business venture geared to provide Data Analysis and Consultancy Services to Sales Executives within large Telco Companies.

The service offering was to take receipt of Telecom’s Data from a Corporate Prospect, to analyse this, and to provide ‘Benchmark’ reports.

Development was done using DTS, SQL 2000/05 as the underlying database, and SAP Crystal Reports to produce the large majority of MI.

The service offering involved attending client meetings to present findings and assisting Sales Executives to secure new business.

Commercially running the business involved negotiations with telecom’s companies over rates, commission, and delivery timescales etc. Project Manager JUN 2005 – MAY 2006

HBOS Group Plc – Chester (Chester)

Responsible for Project Management, Business Analysis, and Systems Development during MG Rover’s period of insolvency. At the time, this was a very commercially sensitive project that required working closely with the auditors PWC and staff at the Long Bridge MG Plant.

Project managed numerous data and system related issues, following a Windows Operating System migration programme, involving circa 300 personnel located across 3 regional sites – Edinburgh, Chester, and London. IT Operations Manager OCT 2001 – MAY 2005

HBOS Group Plc – Corporate Finance Division (Chester)

Operational IT Management Role with line management responsibilities of five permanent staff members with varying skill sets.

IT estate included MS Access, SQL Server, Lotus Notes and a Data Warehouse deployed Business Objects and SAP Crystal Reports.

Governed business and process analysis, documentation, testing, end-user training, deployment, handover and post project reviews.

Other key responsibilities in this role included managing the department’s intranet, introduction of a Project Management framework

(PRINCE2); Departmental Contact for group-wide IT Projects and Programmes; Supplier management and hardware procurement Management Trainee SEP 1999 – SEP 2001

HBOS Group Plc

Completion of a two-year programme, involving four placements, regular coaching, and off-site training. Placements were undertaken in IT Strategy & Planning, IT Assurance, Internal Audit, and Marketing.

Contact this candidate