JAMES HODGE
Penticton,Canada
Summary
An enthusiastic data analyst, with an extensive range of technical and analytical skills. Proactively works to produce solutions to complex problems by using creativity, collaberation, and initiative.
Overview
30
30
years of professional experience
1
1
Certification
Work History
Systems Analyst
Summerland Credit Union
08.2021 - Current
- Performed gap analysis between existing systems or processes and desired state, identifying areas for improvement or enhancement.
- Provided ongoing support for users experiencing issues or requiring assistance with application functionality.
- Collaborated with cross-functional teams to ensure seamless integration of new features into existing applications.
- Identified opportunities for process improvement within the development team, implementing changes that led to increased efficiency and collaboration among members.
Owner
JCME Properties
11.2017 - 08.2021
- Developed and maintained strong relationships with clients, resulting in repeat business and referrals.
- Maintained positive landlord-tenant relationships, ensuring clear communication and prompt resolution of any disputes.
Data Engineer
Bel Air Consulting Limited
07.2012 - 06.2019
- By wrangling different data feeds in SAS/SQL I was able to undertake exploratory data analysis and create models in Python to produce regulatory liquidity reports
- Developed a data feed for QRM software using Teradata SQL and Python for Barclays Bank.
- Improved decision-making processes with accurate data analysis and visualization techniques.
Balance Sheet Management Analyst/Programmer
Barclays Bank PLC - Corporate Banking
08.2010 - 06.2012
- Lead a team of 5 in the production of ad-hoc and strategic reporting of the Corporate balance sheet
- Designed, developed and implemented treasury liquidity reports using SQL, OLAP and UNIX
- Used Data wrangling in SQL and SAS models to analyze behavioral life of balances
- Mentored junior coaches in best practices for leadership development, fostering a culture of continuous learning within the organization.
Database Administrator and Bookkeeper
Bel Air Cedar Resort, Canada
01.2004 - 01.2010
- Boosted brand awareness and generated leads while managing internal and external marketing campaigns and programs.
- Managed accounts payable and receivable activities, maintaining vendor relationships and positive cash flow.
- Handled payroll processing for employees, ensuring timely payment and adherence to tax regulations.
Analyst/Programmer
Barclays Bank PLC
01.1994 - 01.2004
- Used Data wrangling different data sources in Teradata SQL to create a baseline for finance and risk models
- Modeled small business data to generate marketing leads using SAS
- Used SAS and SQL to analyze corporate data to produce profitability profiles and customer insight papers
- Extracted and analyzed mortgage book data using SAS and Quadtone to understand credit default
- Produced a pricing tool for Large Business Lending in VBA.
Education
Bachelor of Science - Computer Science
Reading University
Reading, England06.1994
Skills
- DNA
- Lodestar Data Warehouse
- Oracle/Teradata/SQLserver SQL
- Python
- SAS
- Unix
- Microsoft Office/VBA
- Problem Solving
- Leadership
- Creativity
Linkedin Profile
https://www.linkedin.com/in/jameshodge2512
Citizenship
- British Citizen
- Canadian Citizen
Hobbies and Interests
- Personal fitness
- Learning computer languages
- Geocaching
- Travel
- Entertaining
- D.I.Y.
Languages
English
Native or Bilingual
Certification
· SAS Certified specialist - Base Programming
· Applied Machine Learning – Emeritus/Columbia University
· 2 Credits Open University - in Statistics
· Associate Chartered Institute of Bankers– whitehead/Lombard association prize finance international Trade
Timeline
Systems Analyst
Summerland Credit Union
08.2021 - Current
Owner
JCME Properties
11.2017 - 08.2021
Data Engineer
Bel Air Consulting Limited
07.2012 - 06.2019
Balance Sheet Management Analyst/Programmer
Barclays Bank PLC - Corporate Banking
08.2010 - 06.2012
Database Administrator and Bookkeeper
Bel Air Cedar Resort, Canada
01.2004 - 01.2010
Analyst/Programmer
Barclays Bank PLC
01.1994 - 01.2004
Bachelor of Science - Computer Science
Reading University
Similar Profiles
Amber HuzarAmber Huzar
Financial Services Representative at Summerland Credit UnionFinancial Services Representative at Summerland Credit Union
Angela OlsenAngela Olsen
Teller, Operations Department at Beehive Credit Union (now Security Services Credit Union)Teller, Operations Department at Beehive Credit Union (now Security Services Credit Union)
Briana DameBriana Dame
Customer Service Representative II at Coastal1 Credit Union FKA Pawtucket Credit UnionCustomer Service Representative II at Coastal1 Credit Union FKA Pawtucket Credit Union
Christine SpiresChristine Spires
Accounts Receivable Clerk at Okanagan Laminators IncAccounts Receivable Clerk at Okanagan Laminators Inc
TONY DHALIWALTONY DHALIWAL
General Farm Worker at D'Angelo Vineyards - BCGeneral Farm Worker at D'Angelo Vineyards - BC