James McConnell
Database Administrator at Moneyfacts Group plc- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Moneyfacts Group plc
-
United Kingdom
-
Financial Services
-
1 - 100 Employee
-
Database Administrator
-
2019年3月 - – 現在
-
-
-
ESE Direct Ltd
-
United Kingdom
-
Wholesale
-
1 - 100 Employee
-
Web/IT Manager
-
2007年4月 - 2019年3月
Developing e-commerce websites for a small business using MS SQL Server, .NET C# MVC, ASP/VB, HTML/CSS/XML/XSLT and AJAX. Designing SQL interfaces between websites, Sage 200 Accounting and Sage CRM MME via XML and JSON.Mentoring junior developers to learn systems.Data extraction from accounting and CRM systems to create email marketing campaigns and to load into a brand new printed catalogue.Developed some internal systems using Adobe Flex/Flash Builder.ETL data between various versions of MS SQL Server. Using SSIS to fuzzy match customer data & SSRS to create a suite of reports using MS BIDS.Developing a mobile app for Android/iOS/Blackberry smartphone & tablet devices which is a portal into the admin side of the e-commerce site. Shows orders, baskets, product detail, customers and revenue graphs.Perform SQL-Server DBA tasks, such as backups, maintenance plans, SQL profiling and query optimisations.
-
-
-
Royal Bank of Scotland
-
Banking
-
1 - 100 Employee
-
Consultant Oracle Developer
-
2004年5月 - 2006年12月
Part of the web-development team developing sites for The One account, First Active, Direct Line and NatWest. Developed the First Active and Tesco Personal Finance on-line mortgage and KFI application forms using Oracle PL/SQL HTML Server Pages and CSS to DDA standards. Also, developed PL/SQL packages for the client management system whichhandles both mortgage and current accounts, interfacing with CICs transactions to RBS mainframes. Prepared PERL scripts for handling mail forwarding from website forms, web URL re-direction and data loads into Oracle. 90% time dedicated to PL/SQL package development, ERD modelling, writing component design specifications, and unit test plans.Imported Excel spreadsheet data to Oracle using SQL Loader.
-
-
-
-
Consultant
-
2002年9月 - 2004年5月
Developing e-commerce websites for small businesses. Prepared several Actinic and osCommerce PHP websites. Domain name maintenance for clients.Developer within a small software consultancy specialising in speech recognition products. Developing Java and VB applications to interface to a speech recognition engine for capturing customer orders, providing documentation in UML format. Developing e-commerce websites for small businesses. Prepared several Actinic and osCommerce PHP websites. Domain name maintenance for clients.Developer within a small software consultancy specialising in speech recognition products. Developing Java and VB applications to interface to a speech recognition engine for capturing customer orders, providing documentation in UML format.
-
-
-
EDF Trading
-
United Kingdom
-
Oil and Gas
-
700 & Above Employee
-
Project Manager/Consultant Oracle Developer
-
2001年9月 - 2002年9月
Leading a team of developers.EdF Energy Merchants is the energy trading subsidiary of France’s major energy supplier. “Global Energy” is a Powerbuilder/Oracle client/server bespoke developed energy trading system that allows direct trade input, as well as trade upload from exchanges. As a PM/Lead Developer I was responsible for the delivery of several aspects of the commodities tradingand profit and loss modules. 50% project management; 50% PL/SQL package development, documenting and testing.
-
-
-
JPMorgan Chase
-
United States
-
Investment Management
-
Technical Lead - Global Trust Services
-
1996年1月 - 2001年9月
Global Trust Services (formerly Institutional Trust Group) provides Bond/MTN/CD/CP issuing services to the investor and borrower market acting as Issuing and Paying Agent, and the Common Depositary (for Euroclear and Cedel).The Issuing & Paying Agency (IPA) system(Powerbuilder/Sybase), handles both bookkeeping for tranches in mainly programme-based debt and the recording of physical paper in the vault and market place. This, still active, application handles $600 billion of commercial debt.Auto-Trader is an XML web-based b2b (Powerbuilder/Sybase) application for auto-loading of deals into IPA which come directly through the CapitalNet gateway.Managerial responsibilities included performing semi-annual and annual appraisals, interviewing and hiring contract and permanent staff, task assignment and review and ensuring that company development life-cycle standards were followed.Architect for replication server system utilizing warm standby concept between Sybase database in the UK and Oracle database in the States.
-
-
Systems Manager - Portfolio Strategies Group
-
1994年2月 - 1996年1月
Principal SQL database designer of a Client/Server portfolio and Futures and Options and Forex trading system utilising Sybase back end database and Powerbuilder front end. Working in the Portfolio Strategies Group, reporting to the London Site Manager to develop a system which complemented the needs of the traders and the back office staff. Thesystem is a management information tool which tracks hypothetical bond and financial market index futures and forex trades hedged against a cash swap based on mathematical models and reports mark-to-market information. 80% Transact SQL development; 20% management.
-
-
-
Daiwa Securities SMBC Co. Ltd.
-
Investment Banking
-
1 - 100 Employee
-
IT Specialist
-
1987年2月 - 1994年2月
Over seven years of various PC related roles including network design, application support, computer purchasing, user training, and systems implementation.Programming of Syndication Database System, in Pascal, to manage Daiwa’s participation level in New Issues. This recorded Daiwa’s role within the launch of a syndicated issue and the profit (or loss) gained from the fees charged. It was an important system to the Syndicate department as it could show past relationships with other investors and issuers.Development of a database of debt sales information including yield calculators and general book-keeping services. The system took a daily down-load from the mainframe of Daiwa’s closing prices in all the Bonds it had positions in, recorded them for historic graphing of both the prices and the yields, and an overall “Daiwa Index of Bonds”.Development of a system to support equity traders trading through SEAQ. This, also, recorded the traders deals and calculated profit and loss. It was shown to be very accurate and reduced the margins of error produced by the dealers in their old manual record keeping methods.
-
-
-
Eikon Systems
-
Software Development
-
Consultant Partner
-
1986年5月 - 1987年2月
Partner of a small consultancy developing bespoke systems using Pascal for various clients in the cloth making, travel and manufacturing industries. Partner of a small consultancy developing bespoke systems using Pascal for various clients in the cloth making, travel and manufacturing industries.
-
-