James Kimber

James Kimber Email and Phone Number

Relational Database and big data schema Architect. @ Gregory Group
north tawton, devon, united kingdom
James Kimber's Location
Greater Exeter Area, United Kingdom
James Kimber's Contact Details

James Kimber personal email

n/a
About James Kimber

Experienced relational database database and big data schema architect.ETL developer, report writer and systems integrator for over 20 years in eComm compliance.I specialize in designing scalable relational and big data schemas for enterprise scale deployments (1B+ rows) on oracle, sql-server and apache Hive.I have a tenacious customer and business focus with high attention to detail, and will constantly strive to achieve 100% customer satisfaction.Implement unit and regression testing in all environments, SIT, UAT and ProdI understand business, and have the technical ability to implement a solution.I have mentored many colleges, teaching them technologies and good working practiceI work in a VERY collaborative way. ALL my work is saved to shared spaces - bitbucket / confluence / teams, and I encourage others to do the same.Specialties ● Design enterprise sized (1B+ rows) Star / Snowflake schemas supporting Tableau, Cognos and other report generators ● Oracle and SQL-Server tuning and optimization on partitioned Enterprise scale deployments ● Turn around specialist on failing deployments ● Ability to understand the business requirements and configure a product to meet those needs ● SQL, PL/SQL ● T-SQL ● Apache Hive / HQL / Starburst ● Spark (pyspark) ● Bash scripting ● Data warehousing ● Star Schema ● ETL / Data Migration / Integration ● Unit Testing, Regression Testing ● Installation, support and maintenance roles ● Documentation and Wiki creationOther skills include ● Cognos ● VB ● JavaScript ● XML / XSL ● Active Directory ● Windows ● Linux ● Powershell ● Virtualization ● Professional Services ● Agile Methods - JIRA ● Confluence, JIVE ● Bitbucket

James Kimber's Current Company Details
Gregory Group

Gregory Group

View
Relational Database and big data schema Architect.
north tawton, devon, united kingdom
Website:
gdl.uk.com
Employees:
118
James Kimber Work Experience Details
  • Gregory Group
    Senior Data Engineer
    Gregory Group Jun 2024 - Present
    Cullompton, England, United Kingdom
    View
  • Citi
    Apps Development Tech Lead Analyst, Vp
    Citi Jan 2018 - Apr 2024
    Belfast, Northern Ireland, United Kingdom
    ● Architected and built Oracle Snowflake schema for eComm compliance for day to day reporting using Cognos. ETL incrementally refreshes data every 15mins, to achieve near real time reports.● Built an EAP pyspark / oracle / cognos (BI reporting tool) pipeline monitoring solution used by devops and the auditors. Pulling metrics from multiple stages in the eComm pipeline to validate data integrity at every stage.● Productionization a business critical effectiveness report that was previously developed by the data science team. Using pyspark, Hive and Starburst. We built a highly efficient Hive parquet table, reducing the highly manual process from 2 days to an "On Demand" report that ran in 30 seconds.● Built a culture of sharing knowledge by building "How to.." Wiki's, checking in POC/investigation code, and encouraged other to do the same.● Mentored and trained and encourage many junior colleges● Pioneered JIRA advanced Roadmaps, resulting in significantly improving plans visibility and reduction in overruns● Currently working on a 7B+ row schema with tableau dashboard that returns data < 3 secs.
    View
  • Citi
    Business Analyst (Contractor)
    Citi Dec 2014 - Jan 2018
    London, United Kingdom
    ● Played a primary roll building the Business Intelligence team setting development standards, process and documentation standards now used within the team● Carried a technical feasibility study and assisted in the Upgrade the CA-Data Minder character set to AL32UTF8● Designed and implemented an optimized entitled data layer within the CA Data Minder database to simplify the creating of reports within Cognos and at the same optimizing DB performance● Worked with the Cognos team to migrate from Business Objects to Cognos● Architected a Star Schema solution to aggregate message counts at multiple levels in the CA Data Minder hierarchy broken down by channel and message direction. Over 20k discrete "counts" being calculated every day.● Designed and implemented a new CA-Data Minder purge solution that allowed Citi to move from daily yo weekly purging saving 2 hrs down time every day for APAC countries● CA Data Protection 15.2 upgrade● Implemented Source control (SVN), JIRA (planning) and Confluence (Documentation) within the team and trained others to do the same● Numerous data integration projects supplying entitled data to other groups within Citi
    View
  • Kustom Solution
    Director And Solutions Architect
    Kustom Solution Apr 2013 - Jul 2018
    Exeter, United Kingdom
    ● Recruited a team of engineers to created the CA-Data Protection partitioning solution for SQL-Server for Barclays● Report writing services for Standard and Pores● Onsite CA Data Minder consultant at Fidelity (FIL). Upgraded Data minder from 14.0 -> 14.5 in 10 days● Architected and coded a custom package for HSBC to identify and exclude duplicate emails from their DataMinder review queue
    View
  • Ca Technologies
    Ca Dataminder Specialist (Contractor)
    Ca Technologies Jun 2013 - Nov 2014
    ● Supported the handover or CA DataMinder from the UK team to the CA team in Hyderabad● Assisted with the CA Data Protection 14.6 and 14.5 SP 1 release. Added additional search functionality● Architected Partial Review feature in for CA Data Protection 15.0● Architected ETL process to aggregate messages at multiple levels in the CA Data Minder hierarchy for Barclays● Created ETL process and Business Object report for Bank of New York Mellon● Provided SQL advice for other team members writing reports for McGraw Hill● CA Data Minder 14.5 upgrade at Citi
    View
  • Technically Creative Inc
    Consultant
    Technically Creative Inc Apr 2013 - Mar 2014
    ● Performance tuned LPL Dataminder custom review queue● Created review queue customization for historic data for LPL● SQL performance tuned multiple reports/queries for LPL.● Implemented Data Minder User/Group fix to remove surplus user/group moves from the database for LPL● Dataminder reports for RBS● Created purge script to specified requirements for RBS
  • Ca Technologies
    Senior Software Engineer
    Ca Technologies Apr 2009 - Mar 2013
    Taunton, United Kingdom
    ● Provided second line customer support for the CA Technologies Data Minder product.● Worked closely with clients gathering remote performance diagnostics and query plans. These were then used to resolve the issues with Hot Fixes..● Resolving database customer partitioning and purging problems.● Optimized the Data Minder data warehouse ELT load process for Oracle.● Standardized and documented oracle configuration across clients to eliminate performance issues. This included manual setting of statistics to correct cardinality estimates.● Typically customer databases grow at 20 million rows per day.● Clients: Goldman Sachs, HSBC, Citi Bank, Fidelity, Raymond James, Bank of New York Mellon, Bloomberg, Jefferies, Hartford, Stifel
    View
  • Orchestria
    Senior Services Consultant
    Orchestria Jan 2008 - Mar 2009
    Taunton, United Kingdom
    ● Services consultant supporting product implementations, integrations and upgrades at customer sites.● Produced custom reports for Lehman Brothers, UBS and assisted with implementation.● Completed several successful complex migrations from earlier 3.x release
    View
  • Orchestria
    Senior Software Engineer
    Orchestria Aug 2001 - Jan 2008
    Taunton
    ● Optimized Orchestria (DLP) search performance on partitioned Oracle 10g database for UBS and Citibank● Optimized Orchestria (DLP) search performance on SQL-Server 2000 for Goldman Sachs● Developed standard reports using stored procedures / Crystal reports for Orchestria versions 1-3 and stored procedures / XML based reports for Orchestria versions 4-6.
    View
  • Torex Retail
    Senior Software Engineer
    Torex Retail Dec 2000 - Jul 2001
  • Amey
    Applications Manager
    Amey 1994 - 2000
    View
  • British Rail
    Technical Officer
    British Rail 1989 - 1994
    Exeter, United Kingdom

James Kimber Skills

Linux Cloud Computing Security Identity Management Dlp Pre Sales Saas Enterprise Software Virtualization Sql Tuning Oracle Oracle Pl/sql Development Sql Oracle Sql Developer Microsoft Sql Server Vmware Architecture Oracle Applications Active Directory Professional Services Solution Architecture Agile Methodologies Enterprise Architecture Unix Servers Information Security Sql Performance Tuning T Sql Crystal Reports Visual Basic Javascript Xml Business Objects Big Data Amazon Ec2 Amazon Web Services Data Warehousing Software Development Databases Requirements Analysis Performance Tuning Pl/sql Software Design Web Services Data Integration Integration Architectures Scrum Soa Software Engineering

James Kimber Education Details

  • Queen Elizabeth School Crediton
    Queen Elizabeth School Crediton

Frequently Asked Questions about James Kimber

What company does James Kimber work for?

James Kimber works for Gregory Group

What is James Kimber's role at the current company?

James Kimber's current role is Relational Database and big data schema Architect..

What is James Kimber's email address?

James Kimber's email address is ja****@****oup.com

What schools did James Kimber attend?

James Kimber attended Queen Elizabeth School Crediton.

What skills is James Kimber known for?

James Kimber has skills like Linux, Cloud Computing, Security, Identity Management, Dlp, Pre Sales, Saas, Enterprise Software, Virtualization, Sql Tuning, Oracle, Oracle Pl/sql Development.

Who are James Kimber's colleagues?

James Kimber's colleagues are Brian Thornton, Cameron Williams, Cathy Austin, Clive Glenn, Paul Glasspool, Emily Everington, Mark Spittle.

Not the James Kimber you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.