James Kimber Email & Phone Number

Cullompton, England, United Kingdom

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.

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

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

● 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

● 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

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

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

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.

Exeter, United Kingdom