Experience

Aspen Insurance Group

• United States
• Insurance
• 1 - 100 Employee

• SQL/SSRS Developer

  • Feb 2017 - Present



Collinson

• United Kingdom
• Consumer Services
• 700 & Above Employee

• SQL Developer

  • Jan 2016 - Feb 2017



RBC BlueBay Asset Management

• United Kingdom
• Financial Services
• 300 - 400 Employee

• SQL Developer

  • Aug 2014 - Jan 2016

  I worked on projects to: • support the EMIR & Regulatory Reporting teams • support BAU teams / desktop support • migrate legacy reports and developments to new platform • migrate SSRS reporting suite from SSRS 2005 to 2008 • Develop new transactional, valuation, holding, Fixed Income, Cash Analysis, Cash Problems, Cash ladder, FX and Risk reports. This involved ownership and resolution of issues which the users have logged. I am responsible for the analysis, development UAT testing and change control of these issues and developments into production environment. Show less



Ninety One

• United Kingdom
• Financial Services
• 700 & Above Employee

• SQL Developer

  • Aug 2013 - Aug 2014

  Contract role to support the business teams in South Africa & the UK. This involved ownership and resolution of issues which the users logged. I did the analysis, development UAT testing and change control of these issues into production environment. These developments related to transactional, valuation and holding reports and extracts. I was also responsible for migration of existing SQL stored procedures and SSRS reports to the new “Global” environment. Skill set: SQL 2008 R2, Visual Studio, SSRS, T-SQL, Stored procedures, Excel Show less



SAV Credit

• SQL Developer (SQL2008 R2 / SSIS / SSRS)

  • May 2013 - Aug 2013



Lloyds Banking Group

• London, United Kingdom, Brighton

• SSIS developer

  • Jun 2012 - May 2013

  I worked in a team of contractors on a 9 month contract at Lloyds bank in Brighton. I was responsible for the analysis, design and development of a "file manager" utility using MS SSIS to poll folder locations and to move these files into a landing area for processing. I remediated existing outbound feeds from MS DTS into MS SSIS in a newly developed framework to automate the staging, cleansing and loading of these files. Skill set: SQL 2005 / 8, SSIS, T-SQL, Stored procedures Show less



Gallagher

• United States
• Insurance
• 700 & Above Employee

• SSIS / SSRS Consultant

  • Jul 2009 - Jun 2012

  Analysis and development of complex MS Visual Studio DTS and SSIS package to automate ETL of data from 3rd party insurance systems into SQL2005/8 database. Design & development of scheduled packages to run overnight and produce daily SSRS MI for underwriters and business teams. The SSIS packages provide output feeds into other internal systems in the company, creates complex pivot spreadsheets (vba) and Cognos reporting. Analysis , design and development of large SSRS MI reporting suite producing regulatory carrier reports and MI in various output formats (pdf, xls, csv, MS word) Data migration of data from large MS SQL / MS Access / MS XLS databases from recent acquisitions into AJG Cognos & SQLdatabases. I am familiar with triangle reporting, pivot tables, claims and underwriting processes. Show less



Oxygen Insurance

• Lead SQL Server SSRS SSIS SSAS MI Developer

  • Nov 2008 - Jul 2009

  Analysis, Migration and development of reporting suite for a large insurance company using Sql 2005 reporting services. The report data was interfaced with a bespoke finance / insurance application. Data is downloaded from (Pivot Point) large cubes. I developed and support aSSIS packages to transform the data into SQL tables and views suitable for the report suite. The report suite provides output to other application in the company and also creates complex Excel spreadsheets. I am familiar with triangle reports, pivot tables, claims and underwriting processes with exposure to supporting and developing Cognos reports. I developed shared schedules to automatically run and deliver the reports to the business users. Show less



Euphony Benelux

• Belgium
• Telecommunications
• 100 - 200 Employee

• IT Consultant

  • Mar 2006 - Oct 2008

  Analysis, Support and development of various reporting applications for this telecoms provider to provide MI statistics for the finance department. This telecoms supplier markets landline, mobile, gas and electricity to UK and European markets. These reporting applications have been developed using SQL, excel, access and FoxPro with SQL server databases. SSRS & Crystal reports (Business Objects) were used for reporting I was responsible for data migration and cleansing from the various systems. My role was to develop a combination of ad-hoc and standard reports using rapid development tools to help the business in their decision making Show less



Mitsu

• IT Consultant

  • Sep 2005 - Mar 2006

  Analysis, support and develop various MIS reporting applications for Shipping Company, Lloyds syndicates (Jardine, Jubilee). These applications have been developed using access / FoxPro GUI on SQL server database. All versions of excel, FoxPro with SQL server databases. Sql Reporting (SSRS) & Crystal reports used for reporting functionality Analysis, support and develop various MIS reporting applications for Shipping Company, Lloyds syndicates (Jardine, Jubilee). These applications have been developed using access / FoxPro GUI on SQL server database. All versions of excel, FoxPro with SQL server databases. Sql Reporting (SSRS) & Crystal reports used for reporting functionality



Abbey

• Banking
• 300 - 400 Employee

• IT Consultant

  • Nov 2004 - Aug 2005

  Business analysis, support and developed a complex Pensions applications. Pension Simplification and reporting project,(crystal reports) for Santander takeover of Abbey. Rates review project to bring application in line with current legislation. Maintained, supported and developed VB / Access application which produced annual report review packs to be sent directly to Abbey customers. Liaised with Abbey board, IFA’s, senior pension managers and compliance department to update various business critical applications in line with new legislation. Very high profile applications in the bank with most senior management exposure. Show less



Sovereign Credit Management

• IT Consultant

  • Aug 2004 - Nov 2004

  Reverse analysis of Credit Management reporting application to produce detailed technical specification. (stored procedures, cursor adaptor, classes). The large database was SQL server. Reverse analysis of Credit Management reporting application to produce detailed technical specification. (stored procedures, cursor adaptor, classes). The large database was SQL server.



Call Centre Technology

• IT Consultant

  • Sep 2003 - Aug 2004

  Development of a statistical analyzer to produce management reports. The Telephone Management System processes call center data to create statistical and MIS reports. TMS creates export files in various formats for import into other systems (internal and external). My role was to assess the existing system, specify user requirements, do the analysis, develop, test and document the new system using Visual Foxpro ver 8.0. Interfacing with large SQL backend databases. The application produces reports using Crystal Reports, maintains contact information and calculates invoices. Show less



Horner Brothers Printers

• Foxpro Developer / Analyst

  • Jun 2002 - Aug 2003

  Support and development of a legacy Fox DOS application. Rewrite new functionality in VFP ver 7/8. My role was to assess the existing system, gather user requirements, team lead the analysis, development , and testing of the new functionality. Interfacing with an SQL backend database. The application produced reports, maintained invoice information. The application processed debt analysis and claims processes for the accounts department. The new development was linked to Opera (Pegasys) for production of bespoke management report and statistics Automated posting of invoices into BACS and FTP to and from remote user sites. Clean client databases for import into our systems and create output files in specified formats. I used crystal reports to produce statistical and MI reports. Show less



IMS Health

• United States
• Hospitals and Health Care
• 700 & Above Employee

• IT Consultant

  • Jun 2001 - May 2002

  Full analysis and Development of a Panel Management system that manipulated data relating to hospitals and doctors with a view to creating marketing, statistical analysis and MIS reports. My role was to assess the existing system, specify user requirements, do the analysis, develop, test and document the new system using Visual Foxpro ver 6.0. Interfacing with an SQL backend database. The application produces reports, maintains contact information and calculates payments to be made to panel members. The system also tracks data and issues into a "booking in" system. I have worked in a team environment and alone reporting to both senior management (director level) and users to develop this application. The application interfaces with Crystal reports for all reporting functionality. I was responsible for training the users and creating test plans – full life cycle project. I converted and imported data from old system using Access and Excel. Show less



Software House

• Foxpro Developer / Analyst

  • May 2000 - May 2001

  Rewrite an existing system developed using Clipper (DOS) in Visual Foxpro 6. Develop, test and document the new system. The application has been developed with attention to windows "feel". This application called TRACS is a TIME Recording and Charging System. The application produces "MIS reports" for a billing system that is used by many local government offices. I have developed this multi user application from scratch. Rewrite an existing system developed using Clipper (DOS) in Visual Foxpro 6. Develop, test and document the new system. The application has been developed with attention to windows "feel". This application called TRACS is a TIME Recording and Charging System. The application produces "MIS reports" for a billing system that is used by many local government offices. I have developed this multi user application from scratch.



Bupa

• United Kingdom
• Hospitals and Health Care
• 700 & Above Employee

• IT Consultant

  • Jan 2000 - Apr 2000

  I worked at BUPA on a billing system for their Homecare division. This 3-month project was to rewrite an existing system in Visual Foxpro 6. The application was an account billing system. I developed, tested and documented the management reports and invoices modules. Clean existing databases and import them into new system. I worked at BUPA on a billing system for their Homecare division. This 3-month project was to rewrite an existing system in Visual Foxpro 6. The application was an account billing system. I developed, tested and documented the management reports and invoices modules. Clean existing databases and import them into new system.



J.P. Morgan

• United States
• Financial Services
• 700 & Above Employee

• Foxpro Developer / Analyst

  • Jun 1997 - Dec 1999

  I worked on various trade management systems for this American merchant bank. I have been involved in design, analysis, documentation and development of these systems. Most of the applications have been in a trade support environment for both Foreign exchange and SWAP dealing systems. I was initially taken on to develop an application called TMS which is a trade management system which feed real-time trades into the banks accounting systems. This system was implemented in December 1998. I was then moved onto a team that supported an application called UPMS, which is a Unified Position Management System. This system managed both FX and FI. As the FX business grew the FX and FI business was split. I was given the responsibility of project managing the system, which serviced the FX side of the business. I joined a project called PRADO. This project was based in NewYork for the European offices. The PRADO application was originally written in Fox for the Apple Mac. We converted this to Foxpro 2.6 for windows and then migrated the application into Visual Foxpro. This conversion project lasted about 3 months and was then handed over to a support team. This application was called STIRT and was a hybrid of the UPMS system. STIRT managed the short-term interest rate trades. I was responsible for the conversion of STIRT when the EURO was introduced in January 1999. This system was based in London and served Tokyo, Singapore and Sydney. I supported all overnight batch runs in these foreign locations. I was responsible for the Y2K conversion of this system. I supported a deal entry system for the Front office. This system was called EIRST and was based in Paris. I joined the team to bring the support function to London. The EIRST application is written in Win Fox 2.6, Unix, Sybase, SQL server, Access, Java, Perl, HTML and Stored procedures. Applications: TMS (Dos Fox 2.5/2.6) UPMS (Dos Fox 2.5/2.6) PRADO (Mac Fox, Win Fox, Visual Fox Show less



Citi

• United States
• Financial Services
• 700 & Above Employee

• Foxpro Developer / Analyst

  • Jan 1996 - May 1997

  Support various financial systems for Portfolio officers, M.I.S. reporting on funds/assets under management. I developed a bespoke SWIFT messaging system for electronic trade settlements. These system are written in Foxpro for Dos and Foxpro 2.6 for Windows. I have also just completed a Financial Markets course at the Institute of Directors. Applications: GLIMPSE, GEO, CEASAR, EROS Glimpse (Management Information System: Dos Fox 2.5/6) GEO (Geographic Exposure System: Dos Fox 2.5/6) CEASAR (internal Citibank system: Dos Fox 2.5/6) EROS (Electronic Routing of Swift Messages: Win Fox 2.6) Show less



Tarmac

• Foxpro Developer / Analyst

  • Jun 1995 - Dec 1995

  The original PIMS system I developed for Mandeco was taken over by TBV. I was involved in the support and training of a large userbase in the UK. I analyzed, designed and developed a Polling system to allow the use of PIMS across a WAN. PIMS interfaced with a document imaging package called Watermark and was written in Foxpro 2.6 for windows. I wrote user manuals, trained and supported 60 users on PIMS. The original PIMS system I developed for Mandeco was taken over by TBV. I was involved in the support and training of a large userbase in the UK. I analyzed, designed and developed a Polling system to allow the use of PIMS across a WAN. PIMS interfaced with a document imaging package called Watermark and was written in Foxpro 2.6 for windows. I wrote user manuals, trained and supported 60 users on PIMS.



American Express

• United States
• Financial Services
• 700 & Above Employee

• Consultant Developer / Analyst

  • Aug 1991 - Jun 1995

  I worked in a team of up to eight people to develop a system to manage the salesforce time. SESAME scheduled diary appointments, maintained a large prospect database, produced management reports and had its own bespoke work processor. The system was installed across Europe and I was involved in the installation of SESAME in Rome, Frankfurt and London to a userbase of 250 salepeople. SESAME interfaced with mainframe links and ran on notebook PC’s. The notebooks automatically dialed into a central Admin. site for nightly downloads. I was involved in training , translation into foreign languages and support. This was a high profile development over four years. Applications: SESAME Prospect Output System Show less



Royal Voluntary Service

• United Kingdom
• Civic and Social Organizations
• 400 - 500 Employee

• Foxpro Developer / Analyst

  • Jul 1991 - Aug 1991

  Analysis, design and development of Helpers Database User Training. Applications: Helpers Database Analysis, design and development of Helpers Database User Training. Applications: Helpers Database



Macmillan

• United States
• Book and Periodical Publishing
• 700 & Above Employee

• Foxpro Developer / Analyst

  • Jan 1991 - Jun 1991

  Nursing Times undertook a project to train enrolled nurses to the level of State Registered Nurses in an open learning environment. I designed a program to track the progress of nurses through the two year course. All mailing, accounting and management statistics were produced by the system. Applications: Nursing Times Nursing Times undertook a project to train enrolled nurses to the level of State Registered Nurses in an open learning environment. I designed a program to track the progress of nurses through the two year course. All mailing, accounting and management statistics were produced by the system. Applications: Nursing Times



Mandeco

• Foxpro Developer / Analyst

  • Apr 1990 - Dec 1990

  Mandeco was a project management company specializing in the construction industry. Analysis, design and development of an information system to assist contractors in arbitration disputes. The system was written in dBase IV and reporting was managed by R&R report writer. PIMS (project management information system) was designed to interface with image processing software. Installed and supported 20 user Novell network Applications: PIMS Mandeco was a project management company specializing in the construction industry. Analysis, design and development of an information system to assist contractors in arbitration disputes. The system was written in dBase IV and reporting was managed by R&R report writer. PIMS (project management information system) was designed to interface with image processing software. Installed and supported 20 user Novell network Applications: PIMS



Remote Work #LI-REMOTE

• 1 - 100 Employee

• IT Consultant

  • Aug 1989 - Mar 1990

  Analysis, design and development of Client Tracking System Analysis, design and development of Funds Under Management System. Applications: Client Tracking System Funds Under Management Analysis, design and development of Client Tracking System Analysis, design and development of Funds Under Management System. Applications: Client Tracking System Funds Under Management