Data Processing Analyst

• Jan 2018 - Present

Software Engineer

• Jun 2008 - Present

• Gathered requirements from client teams for data, mapping and dashboards • Migrated data from Salesforce and legacy systems to the CRM system Mobile Intelligence • Mapped territories across Europe for various clients • Matched data across different systems (for example, legacy to Mobile Intelligence) • Shared data with clients to bespoke requested formats • Built ad-hoc queries, often to tight deadlines • Built and maintained custom-built sales performance monitoring dashboards, in a CRM pharmaceutical environment using the TIBCO Spotfire data analytics software and complex SQL. • Maintained Europe-wide database of 11,000,000+ medical professionals and integrated 3rd party feed into this database. • Loaded data pertaining to calls, targets and other aspects into the medical professional database using bespoke tools • Created ‘views’ of the data in the medical professionals database to assist myself and the rest of the team in running queries Show less

Senior Development Engineer

• 2000 - 2007

Working on client site at Eli Lilly - responsibilities: (1) Producing reports for the sales force on both regular/ad-hoc bases, using PL/SQL to interrogate a database and Excel to format the report (2) Developing and maintaining PL/SQL procedures for incorporating weekly data feed into host database of 700,000+ medical professionals, including data cleansing (3) Incorporting sales activity of partners in joint promotions (4) Migrating data to Siebel system (5) Mentoring more junior team members, and reviewing and 'red-penning' code written by other developers (including the team leader) Show less

Senior Development Engineer

• 2000 - 2007

• Enabled client management team to plan ongoing activity by producing weekly COMPASS reports for a sales force of 400+. Reports were on time and accurate. • Tailored reports for ad hoc requests, based on minimal requirements from the business. • Maintained database of 700,000+ medical professionals and integrated 3rd party feed into this database. • Improved new report generation process, reducing timelines by 70%. • Provided competitor analysis for client. • Migrated data to Siebel systems, focussing on data mapping, data cleansing and development. Show less

Developer

• Jan 2000 - May 2000

Used Oracle PL/SQL to develop and maintain Corporate Actions sub-module for Synopsys' trade settlement system RIMS Used Oracle PL/SQL to develop and maintain Corporate Actions sub-module for Synopsys' trade settlement system RIMS

Database Developer

• Nov 1999 - Jan 2000

Engaged to develop ACCESS database for Children & Families Division to facilitate placement of children for fostering and adoption Engaged to develop ACCESS database for Children & Families Division to facilitate placement of children for fostering and adoption

Developer

• Jan 1999 - Oct 1999

Developed and maintained PL/SQL procedures to interrogate a database of financial transactions and therby calcuate interest and produce statements using Oracle Reports Developed and maintained PL/SQL procedures to interrogate a database of financial transactions and therby calcuate interest and produce statements using Oracle Reports

Developer

• Sep 1995 - Jan 1999

Server Development and Maintenance Engineer, NT Database Administrator, Release and Build Engineer, Member of Product Technical Support Team Key achievements  Developed and maintained Korn Shell and SQL scripts which install the product schema into a user account or upgraded previous versions of product schemas.  Set up and administered Oracle databases on NT boxes for use by product smoke tests.  Defined and developed product patch facility for both UNIX and NT, allowing users to install bug fixes quickly without complete re-installation.  Created build automation scripts as part of duties of build and release engineer. The build scripts automated the process of fetching a source file set for a given release. Transferring this to each of the build platforms (Solaris, AIX, HP, Sequent, DG), creating the build, and then transferring the product file to the administration box. Show less