Bryan Pina
Email: *********@********.***
Address: **** ***** ***
City: San Antonio
State: TX
Zip: 78255
Country: USA
Phone: 617-***-****
Skill Level: Experienced
Salary Range: $110,000
Willing to Relocate
Primary Skills/Experience:
See Resume
Educational Background:
See Resume
Job History / Details:
Bryan Pina
8927 Rocky Ridge
San Antonio, TX 78255
Phone: 617-***-****
E-mail: *********@********.***
EXPERIENCE
IT Technologist, Consultant - Database (SME/Senior Application Administrator/Software Support), Genzyme Corporation - A Sanofi Company, San Antonio, Texas, Dec 2004-Present
Manage, develop and train the offsite application teams based in Cambridge, MA and India that support the IT applications.
Manage the Global Service Desk/Helpdesk support team for the IT department to include facilitating requests in Clarify, updating the Global Service Desk with the department`s procedures and applications for requests, authoring and maintaining the application request forms and the application website menus for the Global Service Desk.
Manage the global on-call response teams for the IT applications for all high priority (P1) cases to include 24/7 application, database, and system coverage.
Manage, coordinate and develop the validation documentation, work instructions (WIs), statement of procedures (SOPs), industry standard process and procedure improvements and guidelines, and change request documentation for business/IT process improvement.
Configuration/change manager, technical lead and program lead for software and database management, implementation, testing, training, and upgrades while working with multiple departments and corporate partners globally.
Lead the Incident Management, Problem Management, Change Management and Access Management team`s initiatives within the framework of ITIL for business/IT process improvement.
Manage the Access Management, Change Management and Incident Management modules within the ITIL framework to include gathering metrics, streamlining procedures, coordinating/SME for the bi-weekly Change Management meetings, and actively communicating with senior management on the overall scope of the ITIL initiatives.
Coordinate with the technical and business teams in all software application and database vendor management, oversight, and business solutions;
Responsible for the administration, configuration, maintenance, and enhancement of the software and database systems to include development of SQL scripts, troubleshooting potential database inefficiencies, importing/exporting data, and granting/maintaining user access accounts and privileges.
Facilitate the receipt, logging, entry, querying, coding, and tracking of SAE (Serious Adverse Event) patient data; conduct the electronic production of the relevant FDA regulatory reports; design, code, validate and implement workflow modifications.
Develop and facilitate global internal/external user and administrator training and documentation on departmental and cross-functional business processes and software systems.
Developed and maintained the internal/external weekly, monthly, and annual distribution of clinical trials and post marketing user and audit reports and metrics to support Senior Management, and the Pharmcovigilance and Quality Assurance; work with internal/external customers to define user data listing requirements and software functionality.
Clinical Safety Database Administrator, ILEX Oncology, San Antonio, Texas, June 2002-Dec 2004
Technical lead and coordinator on the ILEX Clintrace 2.8.3 to Clintrace 2.8.5b software upgrade and database migration, the ILEX software and database migration from Clintrace 2.8.5b to the Argus application, and the implementation of the Waban software system to include validation testing and documentation.
Responsible for the administration, maintenance, and enhancement of the Clinical Safety database system while maintaining the overall integrity of secure clinical patient data that includes development of SQL scripts, troubleshooting potential database inefficiencies, importing/exporting data, and granting/maintaining user access rights.
Facilitate the receipt, logging, entry, querying, coding, and tracking of SAE (Serious Adverse Event) patient data; conduct the electronic production of the relevant FDA regulatory reports; design, code, validate and implement the workflow modifications for the Clinical Safety software Clintrace and Clintrial.
Develop and manage the Clinical Safety departments SAE Reporting system for weekly, monthly, and annual distribution of data listing and auditing reports to support ILEX Oncology`s clinical site and patient data while utilizing MS Access and Oracle 8.0; work with internal/external customers to define user data listing requirements and software functionality.
Worked closely with the ILEX Oncology Information Technology and Data Management departments to ensure efficient system and process flow; develop and maintain tools and interface solutions to integrate new and existing systems.
System/Database/Web Administrator, Camber Corporation, San Antonio, Texas, May 2000-June 2002
Develop and support the database and websites supporting the IFT (Introductory to Flight Training) and Graduate Evaluation pilot training programs for the United States Air Force.
Responsible for the accurate coding, testing, implementing and maintaining of requested system and database enhancements and modifications in order to provide the most efficient and effective system for the IFT and Graduate Evaluation programs utilizing Visual Basic, Java, SQL, Oracle, HTML and other office software.
Perform enhancements to applications with end users; create preliminary and detailed design specifications; provide technical knowledge for end users; design and create testing procedures; execute final testing of system; develop implementation procedures to insure smooth installation; provide documentation and instruction on the requested systems; and provide- on-call- support for system problems.
Monitor and maintain the IFT and Graduate Evaluation databases and system server connectivity to 194 Air Force bases worldwide which includes daily backups of tables, files, and data; periodical system performance checks, analyze and resolve potential difficulties and challenges regarding the supporting databases and server, and perform daily and weekly database and web server backup.
Graphic Support Engineer, Camber Corporation, San Antonio, Texas, Sept 1999-May 2000
Provided support and insight of complex graphic software programs for the recreation of the T-37 flight training program at Randolph Air Force Base while utilizing Adobe Photoshop 5.5, Illustrator 8.0, 3-D Studio Max, and Multimedia Authorware Attain 5.0.
Assisted the AETC Training Support Squadron`s Training Technologies Branch to convert existing MicroTICCIT T-37 Computer Aided Instruction graphics and images to the Joint Primary Aircraft Training System Ground-Bases Training System format to be delivered to Flight Safety.
Responsible for the maintenance of the Image Database, Graphics Quality Control Process, and the Courseware Development Lifecycle to insure overall organization, support, and compliance of the requirements of the project.
Client Applications Development Programmer, West Teleservices, San Antonio, Texas, Jan 1999-Sept 1999
Responsible for the accurate coding, testing, implementing and maintaining of requested system enhancements and modifications in order to provide the most efficient and effective system for the organization utilizing COBOL, SQL, UNIX, and other office software.
Perform enhancements to applications with end users and/or systems analysts; create preliminary and detailed design specifications; provide technical knowledge for programming staff; design and create testing procedures; execute final testing of system; develop implementation procedure to insure smooth installation; provide documentation and instruction on the requested systems; and provide- on-call- support for system problems.
EDUCATION
Cameron University, Lawton, Oklahoma
Baccalaureate Degree: Art, December 1995
Baccalaureate Degree: Computer Information Systems, December 1998
COMPUTER KNOWLEDGE
Languages:
Query, SQL, HTML, Visual Basic, Java, COBOL I, COBOL II, C++
Software:
Oracle 7.3 - 8.0, Oracle 8i-11i, Argus, Cognos, Insight, E2B/Cyclone Gateway, Clintrace, Clintrial, Microsoft IIS, Toad, CDC, CTAT, Prisma, IRiS, eCTD Manager, MDR
TRAINING and AWARDS
ITIL Foundation training - 2010
Cognos Powerplay, Report Building, and OLAP Modeling training - 2007
Cognos Report Authoring and Metadata training - 2006
Argus Configuration Management and Administrator training - 2006
Clintrace and Clintrial Configuration Management and Administrator training - 2002
Oracle Administrator training - 2000
Genzyme Vice-President`s Award - 2012
First recipient of the Genzyme ITIL Award - 2010
Genzyme Vice-President`s Award - 2008
Genzyme Storm Trooper Award - 2007