Customer Technologies Projects
Bristol Myers Squibb
Chester
November 2001 - December 2010
Highslide JS
The Chester Business Park is not far from the centre of Chester
Bristol-Myers Squibb Business Services Limited
Lakewood
Heronsway
Chester Business Park
Wrexham Road
Chester
CH4 9QW
Tel: +44 1244 586100
Fax: +44 1244 586107
Web : http://www.bms.com

Bristol-Myers Squibb is a global BioPharma company firmly focused on its Mission to discover, develop and deliver innovative medicines that help patients prevail over serious diseases.

Around the world, our medicines help millions of people in their fight against cancer, cardiovascular disease, diabetes, hepatitis B, HIV/AIDS, rheumatoid arthritis and psychiatric disorders.

At Bristol-Myers Squibb, our BioPharma strategy uniquely combines the reach and resources of a major pharma company with the entrepreneurial spirit and agility of a successful biotech company. With this strategy, we focus on our customers’ needs, giving maximum priority to accelerating pipeline development, delivering sales growth and continuing to manage costs.

The strategy is working. For the past three years, our total return for shareholders, including dividends, has been among the best in the industry. We outperformed most mega pharma companies, diversified companies and pure biotech companies. Reflecting our long-standing commitment to deliver shareholder value, our company has paid dividends to stockholders for more than 300 consecutive quarters.

In addition, we have delivered nine new products to patients in the past seven years. And there are more medicines on the way. We anticipate up to six additional regulatory approvals or submissions through 2012.

Our R&D organization is considered among the most productive in the industry. And the String of Pearls strategy of innovative alliances, partnerships and acquisitions further enhances our internal capabilities. Our full array of 10 pearls encompasses many of our key disease areas, including cancer, cardiovascular disease, immunology, neuroscience and virology.

Pursuing our Mission also means we are working to provide patient access to health care. We are striving to that goal through public/private partnerships like SECURE THE FUTURE, our groundbreaking $150 million program to help confront HIV/AIDS in Africa. In addition, through our patient assistance programs, in 2009 we provided medicines worth more than $290 million at estimated wholesale list price to qualifying patients in the U.S.

Innovation is critical for successfully executing our BioPharma strategy. That innovation is enhanced by a diverse workforce and an inclusive culture. Bristol-Myers Squibb has been recognized year after year as one of the best companies for female executives and working mothers. We’ve also been recognized by the Human Rights Campaign Foundation’s Corporate Equality Index for achieving a perfect score for the past four consecutive years.

My Role :
  • Requirement Analysis
  • Design and Specification
  • Development of robust rich-client and Web applications worldwide.
  • Development team leader.
  • Data transition and data cleaning from legacy systems.
  • Writing of UAT test plans.
  • Training of off-shore software support personnel
  • Documentation of applications and internal procedures
  • Application Support.
All versions of Access from 97 to 2010
Custom Office Ribbon User Interfaces were built. Projects included managing the transition of applications to new versions of MS Office.
Visual Studio was used in ribbon development
Access Package Solution was used to build complete runtime applications deployed by Windows Installer.
Microsoft Graph was used to build graphical reports.
Total Access Analyser, from FMS Inc, was used to analyse and manage existing appications, and perform the final check on applications for distribution.
There was significant interaction between the Access applications and Excel. Spreadsheets were built and manipulated by the applications.
Multiple Oracle 8i, 9i and 10g databases were used for Microsoft Access and Web applications. Dynamic connections were made by DSN-less connections and the Oracle OCI interface was manipulated directly using ADO. Significant interfacing was made to SAP data.
Multiple Microsoft SQL Server 2000, 2005 and 2008 databases were used as a backend to Microsoft Access and Web applications.
XML was output by some of the applications.
Citrix platforms were used for Users around the world for performance and data security purposes, allowing the applications to run in both 2-tier and 3-tier environments. Projects included the transition and deployment to Citrix platforms.
PDF files were part of the output of automatic document generation of the applications.
Dreamweaver and Visual Studio were used to write web applications and develop MS Office ribbons.
Projects included managing the transition of applications to new versions of Windows
Highslide JS
When a User selects a report criteria controls appear on the panel on the right
Highslide JS
A large application like this needs many different reports to satisfy Users
Account Reconciliation Tool
Highslide JS
This is the video splash screen that greets up to 1,500 Users around the world. The data is tested to support 46 languages including difficult languages such as Japanese, Greek, Russian and Klingon (Yes we did test it as it is a recognised language in Unicode)
This is a world-wide 1500-user project, to reconcile the accounts of about 400 companies, using three different MS Access applications. It supports a hierarchy of User permissions to allow the Reconciliation, Approval, Review and Sign-Off of Accounting data. It utilises MS Access front-ends to Oracle 9i and 10g backends. The applications are very complex (>65k lines of VBA) and require sophisticated design to provide the required performance. Client-Server technology is used throughout. Thin-Client operation is supported. Later enhancements included leading a team of developers to implement my designs. Data interfaces included Sharepoint, XML & Excel and the Office Ribbon is customized for the application.
Exception Vendor
This is an ASP web application, used throughout Europe, interfacing to both Oracle and SQL Server, with an Access administration front-end. It started as an Oracle 8i application, progressing to Microsoft SQL Server 2005, then to Microsoft SQL Server 2008.
Salary Merit
This is a complex secure world-wide Access Data Project with MS SQL Server backends to allow managers around the world to perform multi-level appraisal/approval of personnel. Although used mainly in the UK, it was also used in China, Europe and the USA
FleetLog
This multi-user application managed about £6million expenditure in leased cars. It uses MS Access front-ends and back-ends. The project requires significant amounts of data analysis and cleaning, interfacing with data from MS SQL server and Excel.
JoblineUK
Highslide JS
Jobline was a very complex web application that automatically managed the BMS Job Application process
This large complex Europe-wide application managed the posting of internal job vacancies on the company intranet, allowing applicants to submit their CV’s and for managers to post vacancy and location documents. The application was written in ASP, at code level, with an Oracle backend. I was responsible for training two internal technical staff on advanced techniques. I wrote Javascript libraries for use by other development personnel. I later lead the migration to MS SQL Server 2008.
TraVAS
Transport Vendor Analysis System. Used throughout France to analyse hundreds of complex vendor Excel spreadsheets and decide top three vendors in each region for any combination of distance and load.