TrackWise Accomplishments:
- Separated TrackWise instance with over 1,628,000 records and 21,000 login accounts into two instances
- Developed process to extract all file attachments from the TrackWise database
- Developed accurate and efficient process to create database views exposing all record data in an easy-to-read format for downstream reporting systems
- Used database queries to extract all record data from TrackWise database
- Created database queries that extract all configuration information which was used for analysis and technical documents
- Assisted in FDA and EMA audits by creating database queries that identified all records requested that met a specific criteria. TrackWise application would not identify requested records
- Identified pattern then worked with Sparta to identify cause and solution after a new Virtual Group Category included over 8,000 users causing performance issues
- Technical lead for 9 TrackWise developers
- Developed a Visual Basic program that automatically moved file attachments due to a system bug. This was created and implemented in less than 24 hours
- Automated process which executed 43 TrackWise data integrity queries saving 20+ hours/week
Additional Accomplishments:
- Created process that reformats security data from the Veeva Vault configuration report into an easy to read and use format
- Agile scrum master while supervising a team of 10 people and balancing roll of technical lead for TrackWise and Veeva Vault systems
- Created plan and schedule for multiple groups retiring a legacy system while implementing a new cloud based system
- Reduced data warehouse’s daily load time by over 65% from 8 hours to less than 3 hours
- Learning Management System technical team lead that implemented an interface to a Document Management System to 42 sites
- Managed development team that implemented Veeva Vault for six audit groups
- Wrote Oracle database queries, modified UNIX shells, JCL jobs and COBOL programs for a data warehouse
- Technical lead for a PowerBuilder application with an Oracle database which made $1,000,000 credit card payments each week
- Enhanced Travel & Expense application saving more than $250,000/year
Positions Held:
- TrackWise Technical Lead and Team Lead – 9 years
- TrackWise Technical Lead – 10 years
- TrackWise Technical Team Member – 1 year
- Veeva Vault Technical Lead and Team Lead – 2 years
- Data Warehouse Technical Lead – 5 years
- Data Warehouse Technical Team Member – 2 years
- Technical Lead for Travel & Expense Application – 6 years
- Technical Lead for Program using Access Database – 2 years
- Learning Management System Technical Lead – 1 year