Amit K.

Associate Consultant

United Kingdom27 yrs 4 mos experience
Highly Stable

Key Highlights

  • Expert in Data Migration and Business Intelligence solutions.
  • Proven track record in QlikView and Power BI implementations.
  • Strong background in Data Warehousing and ETL processes.
Stackforce AI infers this person is a Business Intelligence expert with extensive experience in Data Warehousing and ETL processes.

Contact

Skills

Core Skills

Data WarehousingBusiness IntelligenceData VisualizationData ArchitectureData MigrationDatabase Administration

Other Skills

Microsoft Power BIExtract, Transform, Load (ETL)Agile MethodologiesQlik SenseQlikViewElastic Stack (ELK)Data Warehouse ArchitectureAzure Data FactoryNPrintingGeo-AnalyticsPower BITableauPythonRGoogle Cloud Platform

About

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

Experience

27 yrs 4 mos
Total Experience
2 yrs 10 mos
Average Tenure
--
Current Experience

Hsbc

4 roles

Lead MI Developer (Compliance IT)

Dec 2019Dec 2022 · 3 yrs

  • QlikView, QlikSense, NPrinting, Geo-Analytics, Power BI, Tableau, Python, R, Google Cloud Platform
QlikViewQlikSenseNPrintingGeo-AnalyticsPower BITableau+5

Lead Qlik Developer, Financial Crime and Compliance Investigations IT

Oct 2017Dec 2019 · 2 yrs 2 mos

  • QlikView, QlikSense, NPrinting, Geo-Analytics.
QlikViewQlikSenseNPrintingGeo-AnalyticsBusiness Intelligence

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

Nov 2015Oct 2017 · 1 yr 11 mos

  • 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
QlikViewNPrintingQlikSenseBusiness Intelligence

Global Risk Data Integration Architect

Jan 2014Nov 2015 · 1 yr 10 mos

  • 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).
QlikViewSQL ServerDB2TeradataHadoop/HIVEExcel+2

Barclays

QlikView Developer - Market, Credit Risk and Contingent Risk BI

Jan 2013Jan 2014 · 1 yr · London, United Kingdom

  • 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.
QlikViewSQL ServerMS BI StackSSIST-SQLC#+1

Unipart technology logistics

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

Oct 2012Dec 2012 · 2 mos · Nuneaton

  • 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.
QlikViewSQL ServerSSIST-SQLBusiness Intelligence

Next group plc

Business Intelligence Data Warehouse Developer (Retail BI)

Feb 2012Oct 2012 · 8 mos · Leicester, United Kingdom

  • 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.
QlikViewSQL ServerSSIST-SQLBusiness Intelligence

Credit suisse

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

Apr 2010Feb 2012 · 1 yr 10 mos · London, United Kingdom

  • 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.
SQL ServerSSISSSRST-SQLMDXData Warehousing

Bp

Business Intelligence Data Warehouse Developer - Middle Office Commodities Trading BI

Mar 2005Mar 2010 · 5 yrs · London, United Kingdom

  • 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
SQL ServerSSISSSRST-SQLMDXData Warehousing

Prudential assurance (formerly egg bank)

Business Intelligence Data Warehouse Developer - Retail Banking BI

Jan 2004Jan 2005 · 1 yr · Derby, United Kingdom

  • 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
SQL ServerSSISSSRST-SQLMDXData Warehousing

Capgemini (formerly eds)

Business Intelligence Data Warehouse Developer - Taxation BI / DBA

Sep 2001Jun 2004 · 2 yrs 9 mos · Telford, United Kingdom

  • 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).
PL/SQLSQLSQL*LOADERData Migration

Intec systems

Analyst / Developer - Telecommunications BI / DBA

Jan 1997Jan 2001 · 4 yrs · Woking, Surrey

  • 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
PL/SQLUnix Shell ScriptingDatabase Administration

Ak data intelligence, analytics & software solutions limited

Senior Consultant

Apr 1996Present · 30 yrs 1 mo · United Kingdom

  • 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.
Microsoft Power BIExtract, Transform, Load (ETL)Data WarehousingData MigrationAgile MethodologiesQlik Sense+5

E.on (formerly midlands electricity board)

Contract Developer - Energy Trading BI

Apr 1996Sep 1997 · 1 yr 5 mos · Dudley, United Kingdom

  • Been responsible for the design, construction, delivery and maintenance of three major design areas - Work Instructions, Work Instructions Printing (On-line & Batch) and Usage Enquiry. This has involved supervising a team of up to three IEF / COMPOSER developers.
  • Developed numerous (35) IEF C3 GUI Client / IEF CICS Server and (3) Batch procedures (including check pointing / restart processing / streaming) using IEF V5.2 and Composer 3 including development of several IEF interfaces to existing systems. Also used CICS printing products such as Advanced Function Printing and Prevail.
  • Given technical assistance and advice to members of the project.
  • Performed QA Reviews on several GUI and Batch procedures developed by other Contractors on the project.
  • Been involved in the migration of code from PC to IBM mainframe environment using ENDEVOR and the IBM IEF Implementation Toolkit and performed system testing using database tools such as QMF, RELATIONAL TOOLS & SPUFI and client/server tools such as the IEF Client Manager.
  • Created an integrated PC and mainframe database, which was utilized by the other members of the project.
PL/SQLUnix Shell ScriptingDatabase Administration

British gas plc

Oracle Analyst Developer - Energy Trading BI

Jun 1991Apr 1996 · 4 yrs 10 mos · Solihull

  • Developed numerous GUI Client Server procedures, several batch procedures, common action blocks to read & create serial files, & specified C external action blocks.
  • Been involved in the development of Invoicing & Accounting systems using IEF V5.2. PC construction & unit testing on OS/2 DB2/2 environment - target environment was UNIX Oracle for Server applications & Windows for the GUI Client executables.
  • System tested on-line & batch procedures on UNIX using SQL*PLUS to create & manipulate test data & to verify test results.
  • Been heavily involved in the cross generation of on-line & batch procedures from the OS/2 DB2/2 OSPM environment to the UNIX Oracle Windows client server environment. This has involved the use of the Windows Software Development Kit (SDK), the IEF Implementation Toolkit, TI utilities such as AEF & IEFC1, general utilities such as the File Transfer Protocol (FTP) & an understanding of UNIX principles such as daemons, sockets & funnels.
  • Performed several model management tasks such as change control, version management, impact analysis, migrations & adoptions. I have also assisted the writing of the Model Check In / Check Out procedures for both seamless transfer & manual file transfer of the IEF.TRAN files. I have also frequently used the IEF query facility Central Encyclopaedia (CE) Access.
  • Programming on ICL George 3 / 2900 / 3900 using VME COBOL - Batch & TP.
  • Systems Analysis of Gas Billing system using SSADM V4 techniques. Programming on ICL 3900 using VME COBOL - Batch & TP. Systems Test Preparation using Maestro Development Workbench. System Test scripting. Systems Test Execution. Systems Delivery, Implementation & Support. Project & Team planning using PMW & ARTEMIS. Team Leading - up to 6 people (which have included permanent members of staff, Contractors & temporary contract staff) on several projects which have lasted from 3 to 9 months in duration.

Education

De Montfort University

Bachelor of Arts (B.A.) — Business Studies

Jan 1987Jan 1991

Stackforce found 100+ more professionals with Data Warehousing & Business Intelligence

Explore similar profiles based on matching skills and experience